This is an automated email from the ASF dual-hosted git repository.
sadpandajoe pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/master by this push:
new 70346a51b69 perf(examples): dedupe dataset imports, right-size
chunksize, add timing to load_examples (#43907)
70346a51b69 is described below
commit 70346a51b6999a6624406a1c801f0fc197947505
Author: Joe Li <[email protected]>
AuthorDate: Wed Sep 9 10:16:01 2026 -0700
perf(examples): dedupe dataset imports, right-size chunksize, add timing to
load_examples (#43907)
Co-authored-by: Claude Fable 5.1 <[email protected]>
---
superset/cli/examples.py | 19 +-
superset/commands/importers/v1/examples.py | 8 +
.../data/cleaned_sales_data.parquet | Bin 91814 -> 0 bytes
.../datasets/cleaned_sales_data.yaml | 348 --
superset/examples/generic_loader.py | 13 +-
.../misc_charts/data/wb_health_population.parquet | Bin 15010872 -> 0 bytes
.../misc_charts/datasets/wb_health_population.yaml | 4319 --------------------
.../commands/importers/v1/examples_test.py | 65 +
8 files changed, 102 insertions(+), 4670 deletions(-)
diff --git a/superset/cli/examples.py b/superset/cli/examples.py
index d8a7ac8ec7a..42e29fdbefd 100755
--- a/superset/cli/examples.py
+++ b/superset/cli/examples.py
@@ -15,6 +15,7 @@
# specific language governing permissions and limitations
# under the License.
import logging
+import time
from typing import Any, Callable
import click
@@ -58,10 +59,18 @@ def _load_dataset(
if "force" in sig.parameters:
params["force"] = force
+ start = time.perf_counter()
try:
loader(**params)
except Exception as e:
- logger.warning("Failed to load %s: %s", dataset_name, e)
+ logger.warning(
+ "Failed to load %s after %.2fs: %s",
+ dataset_name,
+ time.perf_counter() - start,
+ e,
+ )
+ else:
+ logger.info("Finished [%s] in %.2fs", dataset_name,
time.perf_counter() - start)
def load_examples_run(
@@ -70,6 +79,7 @@ def load_examples_run(
only_metadata: bool = False,
force: bool = False,
) -> None:
+ run_start = time.perf_counter()
if only_metadata:
logger.info("Loading examples metadata")
else:
@@ -94,7 +104,14 @@ def load_examples_run(
_load_dataset(loader, loader_name, only_metadata, force)
# Load examples that are stored as YAML config files
+ configs_start = time.perf_counter()
examples.load_examples_from_configs(force, load_test_data)
+ logger.info(
+ "Finished [Examples From Configs] in %.2fs",
+ time.perf_counter() - configs_start,
+ )
+
+ logger.info("load_examples finished in %.2fs", time.perf_counter() -
run_start)
@click.command()
diff --git a/superset/commands/importers/v1/examples.py
b/superset/commands/importers/v1/examples.py
index 9cc929f6f14..71f851ca2bf 100644
--- a/superset/commands/importers/v1/examples.py
+++ b/superset/commands/importers/v1/examples.py
@@ -163,6 +163,14 @@ class ImportExamplesCommand(ImportModelsCommand):
dataset_info: dict[str, dict[str, Any]] = {}
for file_name, config in configs.items():
if file_name.startswith("datasets/"):
+ # Some examples ship a dataset config for a table that another
+ # example already defines (same uuid, re-exported under a
+ # different folder). Import each uuid once per run --
+ # reimporting it just repeats the same column/metric sync
+ # against an identical config.
+ if config["uuid"] in dataset_info:
+ continue
+
# find the ID of the corresponding database
if config["database_uuid"] not in database_ids:
raise Exception( # pylint: disable=broad-exception-raised
diff --git a/superset/examples/featured_charts/data/cleaned_sales_data.parquet
b/superset/examples/featured_charts/data/cleaned_sales_data.parquet
deleted file mode 100644
index 1b50e80b669..00000000000
Binary files
a/superset/examples/featured_charts/data/cleaned_sales_data.parquet and
/dev/null differ
diff --git a/superset/examples/featured_charts/datasets/cleaned_sales_data.yaml
b/superset/examples/featured_charts/datasets/cleaned_sales_data.yaml
deleted file mode 100644
index fe0f4063f51..00000000000
--- a/superset/examples/featured_charts/datasets/cleaned_sales_data.yaml
+++ /dev/null
@@ -1,348 +0,0 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-always_filter_main_dttm: false
-cache_timeout: null
-catalog: null
-columns:
-- advanced_data_type: null
- column_name: order_date
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: true
- python_date_format: null
- type: TIMESTAMP WITHOUT TIME ZONE
- verbose_name: null
-- advanced_data_type: null
- column_name: price_each
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: DOUBLE PRECISION
- verbose_name: null
-- advanced_data_type: null
- column_name: sales
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: DOUBLE PRECISION
- verbose_name: null
-- advanced_data_type: null
- column_name: address_line1
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: address_line2
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: order_line_number
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: BIGINT
- verbose_name: null
-- advanced_data_type: null
- column_name: quantity_ordered
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: BIGINT
- verbose_name: null
-- advanced_data_type: null
- column_name: order_number
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: BIGINT
- verbose_name: null
-- advanced_data_type: null
- column_name: quarter
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: BIGINT
- verbose_name: null
-- advanced_data_type: null
- column_name: year
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: BIGINT
- verbose_name: null
-- advanced_data_type: null
- column_name: month
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: BIGINT
- verbose_name: null
-- advanced_data_type: null
- column_name: msrp
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: BIGINT
- verbose_name: null
-- advanced_data_type: null
- column_name: contact_last_name
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: contact_first_name
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: postal_code
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: customer_name
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: deal_size
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: product_code
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: product_line
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: state
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: status
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: city
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: country
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: phone
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-- advanced_data_type: null
- column_name: territory
- description: null
- expression: null
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: TEXT
- verbose_name: null
-data_file: cleaned_sales_data.parquet
-database_uuid: a2dc77af-e654-49bb-b321-40f6b559a1ee
-default_endpoint: null
-description: null
-extra: null
-fetch_values_predicate: null
-filter_select_enabled: true
-folders: null
-main_dttm_col: order_date
-metrics:
-- currency: null
- d3format: null
- description: null
- expression: COUNT(*)
- extra: null
- metric_name: count
- metric_type: count
- verbose_name: COUNT(*)
- warning_text: null
-normalize_columns: false
-offset: 0
-params: null
-schema: null
-sql: null
-table_name: cleaned_sales_data
-template_params: null
-uuid: e8623bb9-5e00-f531-506a-19607f5f8005
-version: 1.0.0
diff --git a/superset/examples/generic_loader.py
b/superset/examples/generic_loader.py
index 9d516e2d06b..59bdb6bfa18 100644
--- a/superset/examples/generic_loader.py
+++ b/superset/examples/generic_loader.py
@@ -150,14 +150,23 @@ def load_parquet_table( # noqa: C901
except Exception as e:
logger.warning("Could not process column %s: %s", col, e)
- # Write to target database
+ # Write to target database. Scale the row chunksize down for wide
+ # tables so a single batch's bound-parameter count (rows * columns)
+ # stays under stock SQLite's default SQLITE_MAX_VARIABLE_NUMBER of
+ # 32766 -- a flat chunksize=500 on a 328-column table generates
+ # ~164k params per batch, which only some builds raise the limit
+ # for (e.g. Debian's SQLite package). A right-sized batch also
+ # plans faster than an oversized one.
+ num_cols = max(len(pdf.columns), 1)
+ chunksize = max(50, min(500, 30_000 // num_cols))
+
with database.get_sqla_engine() as engine:
pdf.to_sql(
table_name,
engine,
schema=schema,
if_exists="replace",
- chunksize=500,
+ chunksize=chunksize,
method="multi",
index=False,
)
diff --git a/superset/examples/misc_charts/data/wb_health_population.parquet
b/superset/examples/misc_charts/data/wb_health_population.parquet
deleted file mode 100644
index 3b49720bac0..00000000000
Binary files a/superset/examples/misc_charts/data/wb_health_population.parquet
and /dev/null differ
diff --git a/superset/examples/misc_charts/datasets/wb_health_population.yaml
b/superset/examples/misc_charts/datasets/wb_health_population.yaml
deleted file mode 100644
index e01a8732e9f..00000000000
--- a/superset/examples/misc_charts/datasets/wb_health_population.yaml
+++ /dev/null
@@ -1,4319 +0,0 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-always_filter_main_dttm: false
-cache_timeout: null
-catalog: null
-columns:
-- advanced_data_type: null
- column_name: country_name
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: VARCHAR
- verbose_name: null
-- advanced_data_type: null
- column_name: country_code
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: VARCHAR
- verbose_name: null
-- advanced_data_type: null
- column_name: region
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: VARCHAR
- verbose_name: null
-- advanced_data_type: null
- column_name: year
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: true
- python_date_format: null
- type: TIMESTAMP WITHOUT TIME ZONE
- verbose_name: null
-- advanced_data_type: null
- column_name: NY_GNP_PCAP_CD
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_ADT_1524_LT_FM_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_ADT_1524_LT_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_ADT_1524_LT_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_ADT_LITR_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_ADT_LITR_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_ADT_LITR_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_ENR_ORPH
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_PRM_CMPT_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_PRM_CMPT_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_PRM_CMPT_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_PRM_ENRR
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_PRM_ENRR_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_PRM_ENRR_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_PRM_NENR
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_PRM_NENR_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_PRM_NENR_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_SEC_ENRR
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_SEC_ENRR_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_SEC_ENRR_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_SEC_NENR
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_SEC_NENR_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_SEC_NENR_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_TER_ENRR
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_TER_ENRR_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SE_XPD_TOTL_GD_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_ANM_CHLD_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_ANM_NPRG_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_CON_1524_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_CON_1524_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_CON_AIDS_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_CON_AIDS_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DTH_COMM_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DTH_IMRT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DTH_INJR_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DTH_MORT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DTH_NCOM_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DTH_NMRT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DYN_AIDS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DYN_AIDS_DH
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DYN_AIDS_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DYN_AIDS_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DYN_MORT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DYN_MORT_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DYN_MORT_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_DYN_NMRT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_FPL_SATI_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_H2O_SAFE_RU_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_H2O_SAFE_UR_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_H2O_SAFE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_0014
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_1524_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_1524_KW_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_1524_KW_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_1524_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_ARTC_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_KNOW_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_KNOW_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_ORPH
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_HIV_TOTL
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_IMM_HEPB
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_IMM_HIB3
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_IMM_IBCG
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_IMM_IDPT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_IMM_MEAS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_IMM_POL3
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MED_BEDS_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MED_CMHW_P3
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MED_NUMW_P3
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MED_PHYS_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MLR_NETS_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MLR_PREG_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MLR_SPF2_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MLR_TRET_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MMR_DTHS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MMR_LEVE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MMR_RISK
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MMR_RISK_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_MMR_WAGE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_PRG_ANEM
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_PRG_ARTC_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_PRG_SYPH_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_PRV_SMOK_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_PRV_SMOK_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_ACSN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_ACSN_RU
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_ACSN_UR
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_ANV4_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_ANVC_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_ARIC_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_BFED_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_BRTC_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_BRTW_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_DIAB_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_IYCF_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_MALN_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_MALN_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_MALN_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_MALR
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_MMRT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_MMRT_NE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_ORCF_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_ORTH
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_OW15_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_OW15_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_OW15_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_OWGH_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_OWGH_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_OWGH_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_PNVC_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_STNT_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_STNT_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_STNT_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_WAST_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_WAST_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_STA_WAST_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_SVR_WAST_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_SVR_WAST_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_SVR_WAST_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_TBS_CURE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_TBS_DTEC_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_TBS_INCD
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_TBS_MORT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_TBS_PREV
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_VAC_TTNS_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_EXTR_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_OOPC_TO_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_OOPC_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_PCAP
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_PCAP_PP_KD
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_PRIV
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_PRIV_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_PUBL
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_PUBL_GX_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_PUBL_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_TOTL_CD
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SH_XPD_TOTL_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SI_POV_NAHC
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SI_POV_RUHC
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SI_POV_URHC
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SL_EMP_INSV_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SL_TLF_TOTL_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SL_TLF_TOTL_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SL_UEM_TOTL_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SL_UEM_TOTL_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SL_UEM_TOTL_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SM_POP_NETM
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SN_ITK_DEFC
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SN_ITK_DEFC_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SN_ITK_SALT_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SN_ITK_VITA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_ADO_TFRT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_AMRT_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_AMRT_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_CBRT_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_CDRT_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_CONU_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_IMRT_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_IMRT_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_IMRT_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_LE00_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_LE00_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_LE00_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_SMAM_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_SMAM_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_TFRT_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_TO65_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_TO65_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_DYN_WFRT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_HOU_FEMA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_MTR_1519_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0004_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0004_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0004_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0004_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0014_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0014_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0014_TO
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0014_TO_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0509_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0509_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0509_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_0509_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1014_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1014_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1014_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1014_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1519_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1519_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1519_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1519_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1564_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1564_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1564_TO
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_1564_TO_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_2024_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_2024_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_2024_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_2024_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_2529_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_2529_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_2529_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_2529_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_3034_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_3034_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_3034_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_3034_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_3539_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_3539_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_3539_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_3539_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_4044_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_4044_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_4044_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_4044_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_4549_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_4549_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_4549_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_4549_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_5054_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_5054_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_5054_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_5054_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_5559_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_5559_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_5559_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_5559_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_6064_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_6064_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_6064_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_6064_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_6569_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_6569_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_6569_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_6569_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_65UP_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_65UP_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_65UP_TO
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_65UP_TO_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_7074_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_7074_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_7074_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_7074_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_7579_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_7579_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_7579_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_7579_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_80UP_FE
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_80UP_FE_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_80UP_MA
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_80UP_MA_5Y
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG00_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG00_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG01_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG01_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG02_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG02_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG03_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG03_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG04_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG04_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG05_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG05_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG06_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG06_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG07_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG07_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG08_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG08_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG09_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG09_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG10_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG10_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG11_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG11_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG12_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG12_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG13_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG13_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG14_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG14_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG15_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG15_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG16_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG16_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG17_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG17_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG18_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG18_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG19_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG19_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG20_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG20_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG21_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG21_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG22_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG22_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG23_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG23_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG24_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG24_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG25_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_AG25_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_BRTH_MF
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_DPND
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_DPND_OL
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_DPND_YG
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_GROW
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_TOTL
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_TOTL_FE_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_TOTL_FE_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_TOTL_MA_IN
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_POP_TOTL_MA_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_REG_BRTH_RU_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_REG_BRTH_UR_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_REG_BRTH_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_REG_DTHS_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_RUR_TOTL
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_RUR_TOTL_ZG
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_RUR_TOTL_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_URB_GROW
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_URB_TOTL
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_URB_TOTL_IN_ZS
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-- advanced_data_type: null
- column_name: SP_UWT_TFRT
- description: null
- expression: ''
- extra: null
- filterable: true
- groupby: true
- is_active: true
- is_dttm: false
- python_date_format: null
- type: FLOAT
- verbose_name: null
-data_file: wb_health_population.parquet
-database_uuid: a2dc77af-e654-49bb-b321-40f6b559a1ee
-default_endpoint: null
-description: "<!--\nLicensed to the Apache Software Foundation (ASF) under
one\nor\
- \ more contributor license agreements. See the NOTICE file\ndistributed
with this\
- \ work for additional information\nregarding copyright ownership. The ASF
licenses\
- \ this file\nto you under the Apache License, Version 2.0
(the\n\"License\"); you\
- \ may not use this file except in compliance\nwith the License. You may
obtain\
- \ a copy of the License at\n\n
http://www.apache.org/licenses/LICENSE-2.0\n\nUnless\
- \ required by applicable law or agreed to in writing,\nsoftware distributed
under\
- \ the License is distributed on an\n\"AS IS\" BASIS, WITHOUT WARRANTIES OR
CONDITIONS\
- \ OF ANY\nKIND, either express or implied. See the License for
the\nspecific language\
- \ governing permissions and limitations\nunder the License.\n-->\nThis data
was\
- \ downloaded from the\n[World's Health Organization's
website](https://datacatalog.worldbank.org/dataset/health-nutrition-and-population-statistics)\n\
- \nHere's the script that was used to massage the data:\n\n DIR = \"\"\n
df_country\
- \ = pd.read_csv(DIR + '/HNP_Country.csv')\n df_country.columns =
['country_code']\
- \ + list(df_country.columns[1:])\n df_country =
df_country[['country_code', 'Region']]\n\
- \ df_country.columns = ['country_code', 'region']\n\n df =
pd.read_csv(DIR\
- \ + '/HNP_Data.csv')\n del df['Unnamed: 60']\n df.columns =
['country_name',\
- \ 'country_code'] + list(df.columns[2:])\n ndf = df.merge(df_country,
how='inner')\n\
- \n dims = ('country_name', 'country_code', 'region')\n vv = [str(i)
for i\
- \ in range(1960, 2015)]\n mdf = pd.melt(ndf, id_vars=dims + ('Indicator
Code',),\
- \ value_vars=vv)\n mdf['year'] = mdf.variable + '-01-01'\n dims = dims
+ ('year',)\n\
- \n pdf = mdf.pivot_table(values='value', columns='Indicator Code',
index=dims)\n\
- \ pdf = pdf.reset_index()\n pdf.to_csv(DIR + '/countries.csv')\n
pdf.to_json(DIR\
- \ + '/countries.json', orient='records')\n\nHere's the description of the
metrics\
- \ available:\n\nSeries | Code Indicator Name\n--- | ---\nNY.GNP.PCAP.CD |
GNI per\
- \ capita, Atlas method (current US$)\nSE.ADT.1524.LT.FM.ZS | Literacy rate,
youth\
- \ (ages 15-24), gender parity index (GPI)\nSE.ADT.1524.LT.MA.ZS | Literacy
rate,\
- \ youth male (% of males ages 15-24)\nSE.ADT.1524.LT.ZS | Literacy rate,
youth total\
- \ (% of people ages 15-24)\nSE.ADT.LITR.FE.ZS | Literacy rate, adult female
(% of\
- \ females ages 15 and above)\nSE.ADT.LITR.MA.ZS | Literacy rate, adult male
(% of\
- \ males ages 15 and above)\nSE.ADT.LITR.ZS | Literacy rate, adult total (%
of people\
- \ ages 15 and above)\nSE.ENR.ORPH | Ratio of school attendance of orphans to
school\
- \ attendance of non-orphans ages 10-14\nSE.PRM.CMPT.FE.ZS | Primary
completion rate,\
- \ female (% of relevant age group)\nSE.PRM.CMPT.MA.ZS | Primary completion
rate,\
- \ male (% of relevant age group)\nSE.PRM.CMPT.ZS | Primary completion rate,
total\
- \ (% of relevant age group)\nSE.PRM.ENRR | School enrollment, primary (%
gross)\n\
- SE.PRM.ENRR.FE | School enrollment, primary, female (%
gross)\nSE.PRM.ENRR.MA |\
- \ School enrollment, primary, male (% gross)\nSE.PRM.NENR | School
enrollment, primary\
- \ (% net)\nSE.PRM.NENR.FE | School enrollment, primary, female (%
net)\nSE.PRM.NENR.MA\
- \ | School enrollment, primary, male (% net)\nSE.SEC.ENRR | School
enrollment, secondary\
- \ (% gross)\nSE.SEC.ENRR.FE | School enrollment, secondary, female (%
gross)\nSE.SEC.ENRR.MA\
- \ | School enrollment, secondary, male (% gross)\nSE.SEC.NENR | School
enrollment,\
- \ secondary (% net)\nSE.SEC.NENR.FE | School enrollment, secondary, female
(% net)\n\
- SE.SEC.NENR.MA | School enrollment, secondary, male (% net)\nSE.TER.ENRR |
School\
- \ enrollment, tertiary (% gross)\nSE.TER.ENRR.FE | School enrollment,
tertiary,\
- \ female (% gross)\nSE.XPD.TOTL.GD.ZS | Government expenditure on education,
total\
- \ (% of GDP)\nSH.ANM.CHLD.ZS | Prevalence of anemia among children (% of
children\
- \ under 5)\nSH.ANM.NPRG.ZS | Prevalence of anemia among non-pregnant women
(% of\
- \ women ages 15-49)\nSH.CON.1524.FE.ZS | Condom use, population ages 15-24,
female\
- \ (% of females ages 15-24)\nSH.CON.1524.MA.ZS | Condom use, population ages
15-24,\
- \ male (% of males ages 15-24)\nSH.CON.AIDS.FE.ZS | Condom use at last
high-risk\
- \ sex, adult female (% ages 15-49)\nSH.CON.AIDS.MA.ZS | Condom use at last
high-risk\
- \ sex, adult male (% ages 15-49)\nSH.DTH.COMM.ZS | Cause of death, by
communicable\
- \ diseases and maternal, prenatal and nutrition conditions (% of
total)\nSH.DTH.IMRT\
- \ | Number of infant deaths\nSH.DTH.INJR.ZS | Cause of death, by injury (%
of total)\n\
- SH.DTH.MORT | Number of under-five deaths\nSH.DTH.NCOM.ZS | Cause of death,
by non-communicable\
- \ diseases (% of total)\nSH.DTH.NMRT | Number of neonatal
deaths\nSH.DYN.AIDS |\
- \ Adults (ages 15+) living with HIV\nSH.DYN.AIDS.DH | AIDS estimated deaths
(UNAIDS\
- \ estimates)\nSH.DYN.AIDS.FE.ZS | Women's share of population ages 15+
living with\
- \ HIV (%)\nSH.DYN.AIDS.ZS | Prevalence of HIV, total (% of population ages
15-49)\n\
- SH.DYN.MORT | Mortality rate, under-5 (per 1,000 live
births)\nSH.DYN.MORT.FE |\
- \ Mortality rate, under-5, female (per 1,000 live births)\nSH.DYN.MORT.MA |
Mortality\
- \ rate, under-5, male (per 1,000 live births)\nSH.DYN.NMRT | Mortality rate,
neonatal\
- \ (per 1,000 live births)\nSH.FPL.SATI.ZS | Met need for contraception (% of
married\
- \ women ages 15-49)\nSH.H2O.SAFE.RU.ZS | Improved water source, rural (% of
rural\
- \ population with access)\nSH.H2O.SAFE.UR.ZS | Improved water source, urban
(% of\
- \ urban population with access)\nSH.H2O.SAFE.ZS | Improved water source (%
of population\
- \ with access)\nSH.HIV.0014 | Children (0-14) living with
HIV\nSH.HIV.1524.FE.ZS\
- \ | Prevalence of HIV, female (% ages 15-24)\nSH.HIV.1524.KW.FE.ZS |
Comprehensive\
- \ correct knowledge of HIV/AIDS, ages 15-24, female (2 prevent ways and
reject 3\
- \ misconceptions)\nSH.HIV.1524.KW.MA.ZS | Comprehensive correct knowledge of
HIV/AIDS,\
- \ ages 15-24, male (2 prevent ways and reject 3
misconceptions)\nSH.HIV.1524.MA.ZS\
- \ | Prevalence of HIV, male (% ages 15-24)\nSH.HIV.ARTC.ZS | Antiretroviral
therapy\
- \ coverage (% of people living with HIV)\nSH.HIV.KNOW.FE.ZS | % of females
ages\
- \ 15-49 having comprehensive correct knowledge about HIV (2 prevent ways and
reject\
- \ 3 misconceptions)\nSH.HIV.KNOW.MA.ZS | % of males ages 15-49 having
comprehensive\
- \ correct knowledge about HIV (2 prevent ways and reject 3
misconceptions)\nSH.HIV.ORPH\
- \ | Children orphaned by HIV/AIDS\nSH.HIV.TOTL | Adults (ages 15+) and
children\
- \ (0-14 years) living with HIV\nSH.IMM.HEPB | Immunization, HepB3 (% of
one-year-old\
- \ children)\nSH.IMM.HIB3 | Immunization, Hib3 (% of children ages 12-23
months)\n\
- SH.IMM.IBCG | Immunization, BCG (% of one-year-old children)\nSH.IMM.IDPT |
Immunization,\
- \ DPT (% of children ages 12-23 months)\nSH.IMM.MEAS | Immunization, measles
(%\
- \ of children ages 12-23 months)\nSH.IMM.POL3 | Immunization, Pol3 (% of
one-year-old\
- \ children)\nSH.MED.BEDS.ZS | Hospital beds (per 1,000
people)\nSH.MED.CMHW.P3 |\
- \ Community health workers (per 1,000 people)\nSH.MED.NUMW.P3 | Nurses and
midwives\
- \ (per 1,000 people)\nSH.MED.PHYS.ZS | Physicians (per 1,000
people)\nSH.MLR.NETS.ZS\
- \ | Use of insecticide-treated bed nets (% of under-5
population)\nSH.MLR.PREG.ZS\
- \ | Use of any antimalarial drug (% of pregnant women)\nSH.MLR.SPF2.ZS | Use
of\
- \ Intermittent Preventive Treatment of malaria, 2+ doses of SP/Fansidar (%
of pregnant\
- \ women)\nSH.MLR.TRET.ZS | Children with fever receiving antimalarial drugs
(% of\
- \ children under age 5 with fever)\nSH.MMR.DTHS | Number of maternal
deaths\nSH.MMR.LEVE\
- \ | Number of weeks of maternity leave\nSH.MMR.RISK | Lifetime risk of
maternal\
- \ death (1 in: rate varies by country)\nSH.MMR.RISK.ZS | Lifetime risk of
maternal\
- \ death (%)\nSH.MMR.WAGE.ZS | Maternal leave benefits (% of wages paid in
covered\
- \ period)\nSH.PRG.ANEM | Prevalence of anemia among pregnant women
(%)\nSH.PRG.ARTC.ZS\
- \ | Antiretroviral therapy coverage (% of pregnant women living with
HIV)\nSH.PRG.SYPH.ZS\
- \ | Prevalence of syphilis (% of women attending antenatal
care)\nSH.PRV.SMOK.FE\
- \ | Smoking prevalence, females (% of adults)\nSH.PRV.SMOK.MA | Smoking
prevalence,\
- \ males (% of adults)\nSH.STA.ACSN | Improved sanitation facilities (% of
population\
- \ with access)\nSH.STA.ACSN.RU | Improved sanitation facilities, rural (% of
rural\
- \ population with access)\nSH.STA.ACSN.UR | Improved sanitation facilities,
urban\
- \ (% of urban population with access)\nSH.STA.ANV4.ZS | Pregnant women
receiving\
- \ prenatal care of at least four visits (% of pregnant
women)\nSH.STA.ANVC.ZS |\
- \ Pregnant women receiving prenatal care (%)\nSH.STA.ARIC.ZS | ARI treatment
(%\
- \ of children under 5 taken to a health provider)\nSH.STA.BFED.ZS |
Exclusive breastfeeding\
- \ (% of children under 6 months)\nSH.STA.BRTC.ZS | Births attended by
skilled health\
- \ staff (% of total)\nSH.STA.BRTW.ZS | Low-birthweight babies (% of
births)\nSH.STA.DIAB.ZS\
- \ | Diabetes prevalence (% of population ages 20 to 79)\nSH.STA.IYCF.ZS |
Infant\
- \ and young child feeding practices, all 3 IYCF (% children ages 6-23
months)\n\
- SH.STA.MALN.FE.ZS | Prevalence of underweight, weight for age, female (% of
children\
- \ under 5)\nSH.STA.MALN.MA.ZS | Prevalence of underweight, weight for age,
male\
- \ (% of children under 5)\nSH.STA.MALN.ZS | Prevalence of underweight,
weight for\
- \ age (% of children under 5)\nSH.STA.MALR | Malaria cases
reported\nSH.STA.MMRT\
- \ | Maternal mortality ratio (modeled estimate, per 100,000 live
births)\nSH.STA.MMRT.NE\
- \ | Maternal mortality ratio (national estimate, per 100,000 live
births)\nSH.STA.ORCF.ZS\
- \ | Diarrhea treatment (% of children under 5 receiving oral rehydration and
continued\
- \ feeding)\nSH.STA.ORTH | Diarrhea treatment (% of children under 5 who
received\
- \ ORS packet)\nSH.STA.OW15.FE.ZS | Prevalence of overweight, female (% of
female\
- \ adults)\nSH.STA.OW15.MA.ZS | Prevalence of overweight, male (% of male
adults)\n\
- SH.STA.OW15.ZS | Prevalence of overweight (% of adults)\nSH.STA.OWGH.FE.ZS |
Prevalence\
- \ of overweight, weight for height, female (% of children under
5)\nSH.STA.OWGH.MA.ZS\
- \ | Prevalence of overweight, weight for height, male (% of children under
5)\n\
- SH.STA.OWGH.ZS | Prevalence of overweight, weight for height (% of children
under\
- \ 5)\nSH.STA.PNVC.ZS | Postnatal care coverage (%
mothers)\nSH.STA.STNT.FE.ZS |\
- \ Prevalence of stunting, height for age, female (% of children under
5)\nSH.STA.STNT.MA.ZS\
- \ | Prevalence of stunting, height for age, male (% of children under
5)\nSH.STA.STNT.ZS\
- \ | Prevalence of stunting, height for age (% of children under
5)\nSH.STA.WAST.FE.ZS\
- \ | Prevalence of wasting, weight for height, female (% of children under
5)\nSH.STA.WAST.MA.ZS\
- \ | Prevalence of wasting, weight for height, male (% of children under
5)\nSH.STA.WAST.ZS\
- \ | Prevalence of wasting, weight for height (% of children under
5)\nSH.SVR.WAST.FE.ZS\
- \ | Prevalence of severe wasting, weight for height, female (% of children
under\
- \ 5)\nSH.SVR.WAST.MA.ZS | Prevalence of severe wasting, weight for height,
male\
- \ (% of children under 5)\nSH.SVR.WAST.ZS | Prevalence of severe wasting,
weight\
- \ for height (% of children under 5)\nSH.TBS.CURE.ZS | Tuberculosis
treatment success\
- \ rate (% of new cases)\nSH.TBS.DTEC.ZS | Tuberculosis case detection rate
(%, all\
- \ forms)\nSH.TBS.INCD | Incidence of tuberculosis (per 100,000
people)\nSH.TBS.MORT\
- \ | Tuberculosis death rate (per 100,000 people)\nSH.TBS.PREV | Prevalence
of tuberculosis\
- \ (per 100,000 population)\nSH.VAC.TTNS.ZS | Newborns protected against
tetanus\
- \ (%)\nSH.XPD.EXTR.ZS | External resources for health (% of total
expenditure on\
- \ health)\nSH.XPD.OOPC.TO.ZS | Out-of-pocket health expenditure (% of total
expenditure\
- \ on health)\nSH.XPD.OOPC.ZS | Out-of-pocket health expenditure (% of
private expenditure\
- \ on health)\nSH.XPD.PCAP | Health expenditure per capita (current
US$)\nSH.XPD.PCAP.PP.KD\
- \ | Health expenditure per capita, PPP (constant 2011 international
$)\nSH.XPD.PRIV\
- \ | Health expenditure, private (% of total health
expenditure)\nSH.XPD.PRIV.ZS\
- \ | Health expenditure, private (% of GDP)\nSH.XPD.PUBL | Health
expenditure, public\
- \ (% of total health expenditure)\nSH.XPD.PUBL.GX.ZS | Health expenditure,
public\
- \ (% of government expenditure)\nSH.XPD.PUBL.ZS | Health expenditure, public
(%\
- \ of GDP)\nSH.XPD.TOTL.CD | Health expenditure, total (current
US$)\nSH.XPD.TOTL.ZS\
- \ | Health expenditure, total (% of GDP)\nSI.POV.NAHC | Poverty headcount
ratio\
- \ at national poverty lines (% of population)\nSI.POV.RUHC | Rural poverty
headcount\
- \ ratio at national poverty lines (% of rural population)\nSI.POV.URHC |
Urban poverty\
- \ headcount ratio at national poverty lines (% of urban
population)\nSL.EMP.INSV.FE.ZS\
- \ | Share of women in wage employment in the nonagricultural sector (% of
total\
- \ nonagricultural employment)\nSL.TLF.TOTL.FE.ZS | Labor force, female (% of
total\
- \ labor force)\nSL.TLF.TOTL.IN | Labor force, total\nSL.UEM.TOTL.FE.ZS |
Unemployment,\
- \ female (% of female labor force) (modeled ILO estimate)\nSL.UEM.TOTL.MA.ZS
| Unemployment,\
- \ male (% of male labor force) (modeled ILO estimate)\nSL.UEM.TOTL.ZS |
Unemployment,\
- \ total (% of total labor force) (modeled ILO estimate)\nSM.POP.NETM | Net
migration\n\
- SN.ITK.DEFC | Number of people who are undernourished\nSN.ITK.DEFC.ZS |
Prevalence\
- \ of undernourishment (% of population)\nSN.ITK.SALT.ZS | Consumption of
iodized\
- \ salt (% of households)\nSN.ITK.VITA.ZS | Vitamin A supplementation
coverage rate\
- \ (% of children ages 6-59 months)\nSP.ADO.TFRT | Adolescent fertility rate
(births\
- \ per 1,000 women ages 15-19)\nSP.DYN.AMRT.FE | Mortality rate, adult,
female (per\
- \ 1,000 female adults)\nSP.DYN.AMRT.MA | Mortality rate, adult, male (per
1,000\
- \ male adults)\nSP.DYN.CBRT.IN | Birth rate, crude (per 1,000
people)\nSP.DYN.CDRT.IN\
- \ | Death rate, crude (per 1,000 people)\nSP.DYN.CONU.ZS | Contraceptive
prevalence\
- \ (% of women ages 15-49)\nSP.DYN.IMRT.FE.IN | Mortality rate, infant,
female (per\
- \ 1,000 live births)\nSP.DYN.IMRT.IN | Mortality rate, infant (per 1,000
live births)\n\
- SP.DYN.IMRT.MA.IN | Mortality rate, infant, male (per 1,000 live
births)\nSP.DYN.LE00.FE.IN\
- \ | Life expectancy at birth, female (years)\nSP.DYN.LE00.IN | Life
expectancy at\
- \ birth, total (years)\nSP.DYN.LE00.MA.IN | Life expectancy at birth, male
(years)\n\
- SP.DYN.SMAM.FE | Mean age at first marriage, female\nSP.DYN.SMAM.MA | Mean
age at\
- \ first marriage, male\nSP.DYN.TFRT.IN | Fertility rate, total (births per
woman)\n\
- SP.DYN.TO65.FE.ZS | Survival to age 65, female (% of
cohort)\nSP.DYN.TO65.MA.ZS\
- \ | Survival to age 65, male (% of cohort)\nSP.DYN.WFRT | Wanted fertility
rate\
- \ (births per woman)\nSP.HOU.FEMA.ZS | Female headed households (% of
households\
- \ with a female head)\nSP.MTR.1519.ZS | Teenage mothers (% of women ages
15-19 who\
- \ have had children or are currently pregnant)\nSP.POP.0004.FE | Population
ages\
- \ 0-4, female\nSP.POP.0004.FE.5Y | Population ages 0-4, female (% of female
population)\n\
- SP.POP.0004.MA | Population ages 0-4, male\nSP.POP.0004.MA.5Y | Population
ages\
- \ 0-4, male (% of male population)\nSP.POP.0014.FE.ZS | Population ages
0-14, female\
- \ (% of total)\nSP.POP.0014.MA.ZS | Population ages 0-14, male (% of
total)\nSP.POP.0014.TO\
- \ | Population ages 0-14, total\nSP.POP.0014.TO.ZS | Population ages 0-14 (%
of\
- \ total)\nSP.POP.0509.FE | Population ages 5-9, female\nSP.POP.0509.FE.5Y |
Population\
- \ ages 5-9, female (% of female population)\nSP.POP.0509.MA | Population
ages 5-9,\
- \ male\nSP.POP.0509.MA.5Y | Population ages 5-9, male (% of male
population)\nSP.POP.1014.FE\
- \ | Population ages 10-14, female\nSP.POP.1014.FE.5Y | Population ages
10-14, female\
- \ (% of female population)\nSP.POP.1014.MA | Population ages 10-14,
male\nSP.POP.1014.MA.5Y\
- \ | Population ages 10-14, male (% of male population)\nSP.POP.1519.FE |
Population\
- \ ages 15-19, female\nSP.POP.1519.FE.5Y | Population ages 15-19, female (%
of female\
- \ population)\nSP.POP.1519.MA | Population ages 15-19,
male\nSP.POP.1519.MA.5Y |\
- \ Population ages 15-19, male (% of male population)\nSP.POP.1564.FE.ZS |
Population\
- \ ages 15-64, female (% of total)\nSP.POP.1564.MA.ZS | Population ages
15-64, male\
- \ (% of total)\nSP.POP.1564.TO | Population ages 15-64,
total\nSP.POP.1564.TO.ZS\
- \ | Population ages 15-64 (% of total)\nSP.POP.2024.FE | Population ages
20-24,\
- \ female\nSP.POP.2024.FE.5Y | Population ages 20-24, female (% of female
population)\n\
- SP.POP.2024.MA | Population ages 20-24, male\nSP.POP.2024.MA.5Y | Population
ages\
- \ 20-24, male (% of male population)\nSP.POP.2529.FE | Population ages
25-29, female\n\
- SP.POP.2529.FE.5Y | Population ages 25-29, female (% of female
population)\nSP.POP.2529.MA\
- \ | Population ages 25-29, male\nSP.POP.2529.MA.5Y | Population ages 25-29,
male\
- \ (% of male population)\nSP.POP.3034.FE | Population ages 30-34,
female\nSP.POP.3034.FE.5Y\
- \ | Population ages 30-34, female (% of female population)\nSP.POP.3034.MA |
Population\
- \ ages 30-34, male\nSP.POP.3034.MA.5Y | Population ages 30-34, male (% of
male population)\n\
- SP.POP.3539.FE | Population ages 35-39, female\nSP.POP.3539.FE.5Y |
Population ages\
- \ 35-39, female (% of female population)\nSP.POP.3539.MA | Population ages
35-39,\
- \ male\nSP.POP.3539.MA.5Y | Population ages 35-39, male (% of male
population)\n\
- SP.POP.4044.FE | Population ages 40-44, female\nSP.POP.4044.FE.5Y |
Population ages\
- \ 40-44, female (% of female population)\nSP.POP.4044.MA | Population ages
40-44,\
- \ male\nSP.POP.4044.MA.5Y | Population ages 40-44, male (% of male
population)\n\
- SP.POP.4549.FE | Population ages 45-49, female\nSP.POP.4549.FE.5Y |
Population ages\
- \ 45-49, female (% of female population)\nSP.POP.4549.MA | Population ages
45-49,\
- \ male\nSP.POP.4549.MA.5Y | Population ages 45-49, male (% of male
population)\n\
- SP.POP.5054.FE | Population ages 50-54, female\nSP.POP.5054.FE.5Y |
Population ages\
- \ 50-54, female (% of female population)\nSP.POP.5054.MA | Population ages
50-54,\
- \ male\nSP.POP.5054.MA.5Y | Population ages 50-54, male (% of male
population)\n\
- SP.POP.5559.FE | Population ages 55-59, female\nSP.POP.5559.FE.5Y |
Population ages\
- \ 55-59, female (% of female population)\nSP.POP.5559.MA | Population ages
55-59,\
- \ male\nSP.POP.5559.MA.5Y | Population ages 55-59, male (% of male
population)\n\
- SP.POP.6064.FE | Population ages 60-64, female\nSP.POP.6064.FE.5Y |
Population ages\
- \ 60-64, female (% of female population)\nSP.POP.6064.MA | Population ages
60-64,\
- \ male\nSP.POP.6064.MA.5Y | Population ages 60-64, male (% of male
population)\n\
- SP.POP.6569.FE | Population ages 65-69, female\nSP.POP.6569.FE.5Y |
Population ages\
- \ 65-69, female (% of female population)\nSP.POP.6569.MA | Population ages
65-69,\
- \ male\nSP.POP.6569.MA.5Y | Population ages 65-69, male (% of male
population)\n\
- SP.POP.65UP.FE.ZS | Population ages 65 and above, female (% of
total)\nSP.POP.65UP.MA.ZS\
- \ | Population ages 65 and above, male (% of total)\nSP.POP.65UP.TO |
Population\
- \ ages 65 and above, total\nSP.POP.65UP.TO.ZS | Population ages 65 and above
(%\
- \ of total)\nSP.POP.7074.FE | Population ages 70-74,
female\nSP.POP.7074.FE.5Y |\
- \ Population ages 70-74, female (% of female population)\nSP.POP.7074.MA |
Population\
- \ ages 70-74, male\nSP.POP.7074.MA.5Y | Population ages 70-74, male (% of
male population)\n\
- SP.POP.7579.FE | Population ages 75-79, female\nSP.POP.7579.FE.5Y |
Population ages\
- \ 75-79, female (% of female population)\nSP.POP.7579.MA | Population ages
75-79,\
- \ male\nSP.POP.7579.MA.5Y | Population ages 75-79, male (% of male
population)\n\
- SP.POP.80UP.FE | Population ages 80 and above, female\nSP.POP.80UP.FE.5Y |
Population\
- \ ages 80 and above, female (% of female population)\nSP.POP.80UP.MA |
Population\
- \ ages 80 and above, male\nSP.POP.80UP.MA.5Y | Population ages 80 and above,
male\
- \ (% of male population)\nSP.POP.AG00.FE.IN | Age population, age 0, female,
interpolated\n\
- SP.POP.AG00.MA.IN | Age population, age 0, male,
interpolated\nSP.POP.AG01.FE.IN\
- \ | Age population, age 01, female, interpolated\nSP.POP.AG01.MA.IN | Age
population,\
- \ age 01, male, interpolated\nSP.POP.AG02.FE.IN | Age population, age 02,
female,\
- \ interpolated\nSP.POP.AG02.MA.IN | Age population, age 02, male,
interpolated\n\
- SP.POP.AG03.FE.IN | Age population, age 03, female,
interpolated\nSP.POP.AG03.MA.IN\
- \ | Age population, age 03, male, interpolated\nSP.POP.AG04.FE.IN | Age
population,\
- \ age 04, female, interpolated\nSP.POP.AG04.MA.IN | Age population, age 04,
male,\
- \ interpolated\nSP.POP.AG05.FE.IN | Age population, age 05, female,
interpolated\n\
- SP.POP.AG05.MA.IN | Age population, age 05, male,
interpolated\nSP.POP.AG06.FE.IN\
- \ | Age population, age 06, female, interpolated\nSP.POP.AG06.MA.IN | Age
population,\
- \ age 06, male, interpolated\nSP.POP.AG07.FE.IN | Age population, age 07,
female,\
- \ interpolated\nSP.POP.AG07.MA.IN | Age population, age 07, male,
interpolated\n\
- SP.POP.AG08.FE.IN | Age population, age 08, female,
interpolated\nSP.POP.AG08.MA.IN\
- \ | Age population, age 08, male, interpolated\nSP.POP.AG09.FE.IN | Age
population,\
- \ age 09, female, interpolated\nSP.POP.AG09.MA.IN | Age population, age 09,
male,\
- \ interpolated\nSP.POP.AG10.FE.IN | Age population, age 10, female,
interpolated\n\
- SP.POP.AG10.MA.IN | Age population, age 10, male\nSP.POP.AG11.FE.IN | Age
population,\
- \ age 11, female, interpolated\nSP.POP.AG11.MA.IN | Age population, age 11,
male\n\
- SP.POP.AG12.FE.IN | Age population, age 12, female,
interpolated\nSP.POP.AG12.MA.IN\
- \ | Age population, age 12, male\nSP.POP.AG13.FE.IN | Age population, age
13, female,\
- \ interpolated\nSP.POP.AG13.MA.IN | Age population, age 13,
male\nSP.POP.AG14.FE.IN\
- \ | Age population, age 14, female, interpolated\nSP.POP.AG14.MA.IN | Age
population,\
- \ age 14, male\nSP.POP.AG15.FE.IN | Age population, age 15, female,
interpolated\n\
- SP.POP.AG15.MA.IN | Age population, age 15, male,
interpolated\nSP.POP.AG16.FE.IN\
- \ | Age population, age 16, female, interpolated\nSP.POP.AG16.MA.IN | Age
population,\
- \ age 16, male, interpolated\nSP.POP.AG17.FE.IN | Age population, age 17,
female,\
- \ interpolated\nSP.POP.AG17.MA.IN | Age population, age 17, male,
interpolated\n\
- SP.POP.AG18.FE.IN | Age population, age 18, female,
interpolated\nSP.POP.AG18.MA.IN\
- \ | Age population, age 18, male, interpolated\nSP.POP.AG19.FE.IN | Age
population,\
- \ age 19, female, interpolated\nSP.POP.AG19.MA.IN | Age population, age 19,
male,\
- \ interpolated\nSP.POP.AG20.FE.IN | Age population, age 20, female,
interpolated\n\
- SP.POP.AG20.MA.IN | Age population, age 20, male,
interpolated\nSP.POP.AG21.FE.IN\
- \ | Age population, age 21, female, interpolated\nSP.POP.AG21.MA.IN | Age
population,\
- \ age 21, male, interpolated\nSP.POP.AG22.FE.IN | Age population, age 22,
female,\
- \ interpolated\nSP.POP.AG22.MA.IN | Age population, age 22, male,
interpolated\n\
- SP.POP.AG23.FE.IN | Age population, age 23, female,
interpolated\nSP.POP.AG23.MA.IN\
- \ | Age population, age 23, male, interpolated\nSP.POP.AG24.FE.IN | Age
population,\
- \ age 24, female, interpolated\nSP.POP.AG24.MA.IN | Age population, age 24,
male,\
- \ interpolated\nSP.POP.AG25.FE.IN | Age population, age 25, female,
interpolated\n\
- SP.POP.AG25.MA.IN | Age population, age 25, male,
interpolated\nSP.POP.BRTH.MF |\
- \ Sex ratio at birth (male births per female births)\nSP.POP.DPND | Age
dependency\
- \ ratio (% of working-age population)\nSP.POP.DPND.OL | Age dependency
ratio, old\
- \ (% of working-age population)\nSP.POP.DPND.YG | Age dependency ratio,
young (%\
- \ of working-age population)\nSP.POP.GROW | Population growth (annual
%)\nSP.POP.TOTL\
- \ | Population, total\nSP.POP.TOTL.FE.IN | Population,
female\nSP.POP.TOTL.FE.ZS\
- \ | Population, female (% of total)\nSP.POP.TOTL.MA.IN | Population,
male\nSP.POP.TOTL.MA.ZS\
- \ | Population, male (% of total)\nSP.REG.BRTH.RU.ZS | Completeness of birth
registration,\
- \ rural (%)\nSP.REG.BRTH.UR.ZS | Completeness of birth registration, urban
(%)\n\
- SP.REG.BRTH.ZS | Completeness of birth registration (%)\nSP.REG.DTHS.ZS |
Completeness\
- \ of death registration with cause-of-death information (%)\nSP.RUR.TOTL |
Rural\
- \ population\nSP.RUR.TOTL.ZG | Rural population growth (annual
%)\nSP.RUR.TOTL.ZS\
- \ | Rural population (% of total population)\nSP.URB.GROW | Urban population
growth\
- \ (annual %)\nSP.URB.TOTL | Urban population\nSP.URB.TOTL.IN.ZS | Urban
population\
- \ (% of total)\nSP.UWT.TFRT | Unmet need for contraception (% of married
women ages\
- \ 15-49)\n"
-extra: null
-fetch_values_predicate: null
-filter_select_enabled: true
-folders: null
-main_dttm_col: year
-metrics:
-- currency: null
- d3format: null
- description: null
- expression: sum("SP_POP_TOTL")
- extra: null
- metric_name: sum__SP_POP_TOTL
- metric_type: null
- verbose_name: null
- warning_text: null
-- currency: null
- d3format: null
- description: null
- expression: sum("SH_DYN_AIDS")
- extra: null
- metric_name: sum__SH_DYN_AIDS
- metric_type: null
- verbose_name: null
- warning_text: null
-- currency: null
- d3format: null
- description: null
- expression: sum("SP_RUR_TOTL_ZS")
- extra: null
- metric_name: sum__SP_RUR_TOTL_ZS
- metric_type: null
- verbose_name: null
- warning_text: null
-- currency: null
- d3format: null
- description: null
- expression: sum("SP_DYN_LE00_IN")
- extra: null
- metric_name: sum__SP_DYN_LE00_IN
- metric_type: null
- verbose_name: null
- warning_text: null
-- currency: null
- d3format: null
- description: null
- expression: sum("SP_RUR_TOTL")
- extra: null
- metric_name: sum__SP_RUR_TOTL
- metric_type: null
- verbose_name: null
- warning_text: null
-- currency: null
- d3format: null
- description: null
- expression: COUNT(*)
- extra: null
- metric_name: count
- metric_type: count
- verbose_name: COUNT(*)
- warning_text: null
-normalize_columns: false
-offset: 0
-params: null
-schema: null
-sql: null
-table_name: wb_health_population
-template_params: null
-uuid: 69e9de42-fe7f-4948-946a-f7913227aee8
-version: 1.0.0
diff --git a/tests/unit_tests/commands/importers/v1/examples_test.py
b/tests/unit_tests/commands/importers/v1/examples_test.py
index 71bd1dcac1c..29d9e24a29f 100644
--- a/tests/unit_tests/commands/importers/v1/examples_test.py
+++ b/tests/unit_tests/commands/importers/v1/examples_test.py
@@ -348,6 +348,71 @@ def test_import_passes_ignore_permissions_to_all_importers(
assert mock_import_dashboard.call_args[1].get("ignore_permissions") is True
+@patch(
+
"superset.commands.importers.v1.examples.safe_insert_dashboard_chart_relationships"
+)
+@patch("superset.commands.importers.v1.examples.import_dataset")
+@patch("superset.commands.importers.v1.examples.import_database")
+def test_import_dedupes_datasets_with_same_uuid(
+ mock_import_db,
+ mock_import_dataset,
+ mock_safe_insert,
+):
+ """_import() must import a given dataset uuid at most once per run.
+
+ Two example folders can ship a dataset config for the same
+ underlying table with an identical uuid (e.g. "world_health" and
+ "misc_charts" both shipping a config for "wb_health_population").
+ Importing it twice repeats the same column/metric sync for no
+ benefit.
+ """
+ from superset.commands.importers.v1.examples import ImportExamplesCommand
+
+ db_uuid = "a2dc77af-e654-49bb-b321-40f6b559a1ee"
+ dataset_uuid = "69e9de42-fe7f-4948-946a-f7913227aee8"
+
+ mock_db_obj = MagicMock()
+ mock_db_obj.uuid = db_uuid
+ mock_db_obj.id = 1
+ mock_import_db.return_value = mock_db_obj
+
+ mock_dataset_obj = MagicMock()
+ mock_dataset_obj.uuid = dataset_uuid
+ mock_dataset_obj.id = 10
+ mock_dataset_obj.table_name = "wb_health_population"
+ mock_import_dataset.return_value = mock_dataset_obj
+
+ configs = {
+ "databases/examples.yaml": {
+ "uuid": db_uuid,
+ "database_name": "examples",
+ "sqlalchemy_uri": "sqlite:///test.db",
+ },
+ "datasets/examples/world_health.yaml": {
+ "uuid": dataset_uuid,
+ "table_name": "wb_health_population",
+ "database_uuid": db_uuid,
+ "schema": None,
+ "sql": None,
+ },
+ "datasets/examples/wb_health_population.yaml": {
+ "uuid": dataset_uuid,
+ "table_name": "wb_health_population",
+ "database_uuid": db_uuid,
+ "schema": None,
+ "sql": None,
+ },
+ }
+
+ with patch(
+ "superset.commands.importers.v1.examples.get_example_default_schema",
+ return_value=None,
+ ):
+ ImportExamplesCommand._import(configs)
+
+ mock_import_dataset.assert_called_once()
+
+
def test_normalize_dataset_schema_converts_main_to_null():
"""SQLite 'main' schema must be normalized to null in YAML content.
