TCA

Datasets (1)

SEL — DGIWG Spatial Entity Listing standard SEL+ — Platform extension (not in DGIWG core spec) CCL — DGIWG Cross-Cultural Language standard Extension — Preserved in extension tables (not in core SEL/CCL schema) Pending — Awaiting mapping

TCA OpenFactBook TCA-OPENFACTBOOK Country Profile

14 rows · 14 table(s) OpenFactBook 0 1 2 3 86 SEL 6 CCL 366 ext ▶

Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 14 table(s)

TCA openfactbook - communications — 1 rows, 18 columns

Standards-Aligned Fields (7)

Field Name	Label	Type	Schema	Nulls	Unique
`telephones_fixed_lines_subscriptions_per_100_inhabitants_numeric`	telephones_fixed_lines_subscriptions_per_100_inhabitants_numeric	float	SEL	0%	1
`telephones_mobile_cellular_subscriptions_per_100_inhabitants_numeric`	telephones_mobile_cellular_subscriptions_per_100_inhabitants_numeric	float	SEL	0%	1
`internet_country_code_text`	internet_country_code_text	string	SEL+	0%	1
`internet_users_percent_of_population_numeric`	internet_users_percent_of_population_numeric	float	SEL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (11) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`telephones_fixed_lines_total_subscriptions_text`	telephones_fixed_lines_total_subscriptions_text	string	0%	1
`telephones_fixed_lines_total_subscriptions_numeric`	telephones_fixed_lines_total_subscriptions_numeric	float	0%	1
`telephones_fixed_lines_subscriptions_per_100_inhabitants_text`	telephones_fixed_lines_subscriptions_per_100_inhabitants_text	string	0%	1
`telephones_mobile_cellular_total_subscriptions_text`	telephones_mobile_cellular_total_subscriptions_text	string	0%	1
`telephones_mobile_cellular_total_subscriptions_numeric`	telephones_mobile_cellular_total_subscriptions_numeric	float	0%	1
`telephones_mobile_cellular_subscriptions_per_100_inhabitants_text`	telephones_mobile_cellular_subscriptions_per_100_inhabitants_text	string	0%	1
`broadcast_media_text`	broadcast_media_text	string	0%	1
`broadcast_media_numeric`	broadcast_media_numeric	float	0%	1
`internet_users_percent_of_population_text`	internet_users_percent_of_population_text	string	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

TCA openfactbook - economy — 1 rows, 89 columns

Standards-Aligned Fields (5)

Field Name	Label	Type	Schema	Nulls	Unique
`real_gdp_per_capita_real_gdp_per_capita_2024_numeric`	real_gdp_per_capita_real_gdp_per_capita_2024_numeric	float	SEL	0%	1
`gdp_official_exchange_rate_numeric`	gdp_official_exchange_rate_numeric	float	SEL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (84) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`economic_overview_text`	economic_overview_text	string	0%	1
`economic_overview_numeric`	economic_overview_numeric	float	0%	1
`real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2024_text`	real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2024_text	string	0%	1
`real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2024_numeric`	real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2024_numeric	float	0%	1
`real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2023_text`	real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2023_text	string	0%	1
`real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2023_numeric`	real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2023_numeric	float	0%	1
`real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2022_text`	real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2022_text	string	0%	1
`real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2022_numeric`	real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2022_numeric	float	0%	1
`real_gdp_purchasing_power_parity_note`	real_gdp_purchasing_power_parity_note	string	0%	1
`real_gdp_growth_rate_real_gdp_growth_rate_2024_text`	real_gdp_growth_rate_real_gdp_growth_rate_2024_text	string	0%	1
`real_gdp_growth_rate_real_gdp_growth_rate_2024_numeric`	real_gdp_growth_rate_real_gdp_growth_rate_2024_numeric	float	0%	1
`real_gdp_growth_rate_real_gdp_growth_rate_2023_text`	real_gdp_growth_rate_real_gdp_growth_rate_2023_text	string	0%	1
`real_gdp_growth_rate_real_gdp_growth_rate_2023_numeric`	real_gdp_growth_rate_real_gdp_growth_rate_2023_numeric	float	0%	1
`real_gdp_growth_rate_real_gdp_growth_rate_2022_text`	real_gdp_growth_rate_real_gdp_growth_rate_2022_text	string	0%	1
`real_gdp_growth_rate_real_gdp_growth_rate_2022_numeric`	real_gdp_growth_rate_real_gdp_growth_rate_2022_numeric	float	0%	1
`real_gdp_growth_rate_note`	real_gdp_growth_rate_note	string	0%	1
`real_gdp_per_capita_real_gdp_per_capita_2024_text`	real_gdp_per_capita_real_gdp_per_capita_2024_text	string	0%	1
`real_gdp_per_capita_real_gdp_per_capita_2023_text`	real_gdp_per_capita_real_gdp_per_capita_2023_text	string	0%	1
`real_gdp_per_capita_real_gdp_per_capita_2023_numeric`	real_gdp_per_capita_real_gdp_per_capita_2023_numeric	float	0%	1
`real_gdp_per_capita_real_gdp_per_capita_2022_text`	real_gdp_per_capita_real_gdp_per_capita_2022_text	string	0%	1
`real_gdp_per_capita_real_gdp_per_capita_2022_numeric`	real_gdp_per_capita_real_gdp_per_capita_2022_numeric	float	0%	1
`real_gdp_per_capita_note`	real_gdp_per_capita_note	string	0%	1
`gdp_official_exchange_rate_text`	gdp_official_exchange_rate_text	string	0%	1
`inflation_rate_consumer_prices_inflation_rate_consumer_prices_2022_text`	inflation_rate_consumer_prices_inflation_rate_consumer_prices_2022_text	string	0%	1
`inflation_rate_consumer_prices_inflation_rate_consumer_prices_2022_numeric`	inflation_rate_consumer_prices_inflation_rate_consumer_prices_2022_numeric	float	0%	1
`inflation_rate_consumer_prices_inflation_rate_consumer_prices_2021_text`	inflation_rate_consumer_prices_inflation_rate_consumer_prices_2021_text	string	0%	1
`inflation_rate_consumer_prices_inflation_rate_consumer_prices_2021_numeric`	inflation_rate_consumer_prices_inflation_rate_consumer_prices_2021_numeric	float	0%	1
`inflation_rate_consumer_prices_inflation_rate_consumer_prices_2020_text`	inflation_rate_consumer_prices_inflation_rate_consumer_prices_2020_text	string	0%	1
`inflation_rate_consumer_prices_inflation_rate_consumer_prices_2020_numeric`	inflation_rate_consumer_prices_inflation_rate_consumer_prices_2020_numeric	float	0%	1
`inflation_rate_consumer_prices_note`	inflation_rate_consumer_prices_note	string	0%	1
`gdp_composition_by_sector_of_origin_agriculture_text`	gdp_composition_by_sector_of_origin_agriculture_text	string	0%	1
`gdp_composition_by_sector_of_origin_agriculture_numeric`	gdp_composition_by_sector_of_origin_agriculture_numeric	float	0%	1
`gdp_composition_by_sector_of_origin_industry_text`	gdp_composition_by_sector_of_origin_industry_text	string	0%	1
`gdp_composition_by_sector_of_origin_industry_numeric`	gdp_composition_by_sector_of_origin_industry_numeric	float	0%	1
`gdp_composition_by_sector_of_origin_services_text`	gdp_composition_by_sector_of_origin_services_text	string	0%	1
`gdp_composition_by_sector_of_origin_services_numeric`	gdp_composition_by_sector_of_origin_services_numeric	float	0%	1
`gdp_composition_by_sector_of_origin_note`	gdp_composition_by_sector_of_origin_note	string	0%	1
`agricultural_products_text`	agricultural_products_text	string	0%	1
`industries_text`	industries_text	string	0%	1
`industrial_production_growth_rate_text`	industrial_production_growth_rate_text	string	0%	1
`industrial_production_growth_rate_numeric`	industrial_production_growth_rate_numeric	float	0%	1
`remittances_remittances_2023_text`	remittances_remittances_2023_text	string	0%	1
`remittances_remittances_2023_numeric`	remittances_remittances_2023_numeric	float	0%	1
`remittances_remittances_2022_text`	remittances_remittances_2022_text	string	0%	1
`remittances_remittances_2022_numeric`	remittances_remittances_2022_numeric	float	0%	1
`remittances_remittances_2021_text`	remittances_remittances_2021_text	string	0%	1
`remittances_remittances_2021_numeric`	remittances_remittances_2021_numeric	float	0%	1
`remittances_note`	remittances_note	string	0%	1
`budget_revenues_text`	budget_revenues_text	string	0%	1
`budget_revenues_numeric`	budget_revenues_numeric	float	0%	1
`budget_expenditures_text`	budget_expenditures_text	string	0%	1
`budget_expenditures_numeric`	budget_expenditures_numeric	float	0%	1
`current_account_balance_current_account_balance_2018_text`	current_account_balance_current_account_balance_2018_text	string	0%	1
`current_account_balance_current_account_balance_2018_numeric`	current_account_balance_current_account_balance_2018_numeric	float	0%	1
`current_account_balance_current_account_balance_2017_text`	current_account_balance_current_account_balance_2017_text	string	0%	1
`current_account_balance_current_account_balance_2017_numeric`	current_account_balance_current_account_balance_2017_numeric	float	0%	1
`current_account_balance_current_account_balance_2016_text`	current_account_balance_current_account_balance_2016_text	string	0%	1
`current_account_balance_current_account_balance_2016_numeric`	current_account_balance_current_account_balance_2016_numeric	float	0%	1
`current_account_balance_note`	current_account_balance_note	string	0%	1
`exports_exports_2018_text`	exports_exports_2018_text	string	0%	1
`exports_exports_2018_numeric`	exports_exports_2018_numeric	float	0%	1
`exports_exports_2017_text`	exports_exports_2017_text	string	0%	1
`exports_exports_2017_numeric`	exports_exports_2017_numeric	float	0%	1
`exports_exports_2016_text`	exports_exports_2016_text	string	0%	1
`exports_exports_2016_numeric`	exports_exports_2016_numeric	float	0%	1
`exports_note`	exports_note	string	0%	1
`exports_partners_text`	exports_partners_text	string	0%	1
`exports_partners_numeric`	exports_partners_numeric	float	0%	1
`exports_commodities_text`	exports_commodities_text	string	0%	1
`exports_commodities_numeric`	exports_commodities_numeric	float	0%	1
`imports_imports_2018_text`	imports_imports_2018_text	string	0%	1
`imports_imports_2018_numeric`	imports_imports_2018_numeric	float	0%	1
`imports_imports_2017_text`	imports_imports_2017_text	string	0%	1
`imports_imports_2017_numeric`	imports_imports_2017_numeric	float	0%	1
`imports_imports_2016_text`	imports_imports_2016_text	string	0%	1
`imports_imports_2016_numeric`	imports_imports_2016_numeric	float	0%	1
`imports_note`	imports_note	string	0%	1
`imports_partners_text`	imports_partners_text	string	0%	1
`imports_partners_numeric`	imports_partners_numeric	float	0%	1
`imports_commodities_text`	imports_commodities_text	string	0%	1
`imports_commodities_numeric`	imports_commodities_numeric	float	0%	1
`exchange_rates_text`	exchange_rates_text	string	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

TCA openfactbook - energy — 1 rows, 23 columns

Standards-Aligned Fields (4)

Field Name	Label	Type	Schema	Nulls	Unique
`electricity_access_electrification_total_population_numeric`	electricity_access_electrification_total_population_numeric	float	SEL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (19) — supplemental data preserved outside core SEL/CCL schema

TCA openfactbook - environment — 1 rows, 27 columns

Standards-Aligned Fields (7)

Field Name	Label	Type	Schema	Nulls	Unique
`land_use_agricultural_land_numeric`	land_use_agricultural_land_numeric	float	SEL	0%	1
`land_use_forest_numeric`	land_use_forest_numeric	float	SEL	0%	1
`urbanization_urban_population_numeric`	urbanization_urban_population_numeric	float	SEL	0%	1
`urbanization_rate_of_urbanization_numeric`	urbanization_rate_of_urbanization_numeric	float	SEL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (20) — supplemental data preserved outside core SEL/CCL schema

TCA openfactbook - ethnic_groups — 1 rows, 9 columns

Standards-Aligned Fields (4)

Field Name	Label	Type	Schema	Nulls	Unique
`ethnic_groups_text`	ethnic_groups_text	string	CCL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (5) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`nationality_noun_text`	nationality_noun_text	string	0%	1
`nationality_adjective_text`	nationality_adjective_text	string	0%	1
`ethnic_groups_numeric`	ethnic_groups_numeric	float	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

TCA openfactbook - geography — 1 rows, 49 columns

Standards-Aligned Fields (13)

Field Name	Label	Type	Schema	Nulls	Unique
`area_total_numeric`	area_total_numeric	float	SEL	0%	1
`area_land_numeric`	area_land_numeric	float	SEL	0%	1
`area_water_numeric`	area_water_numeric	float	SEL	0%	1
`land_boundaries_total_numeric`	land_boundaries_total_numeric	float	SEL	0%	1
`coastline_numeric`	coastline_numeric	float	SEL	0%	1
`elevation_highest_point_numeric`	elevation_highest_point_numeric	float	SEL	0%	1
`elevation_lowest_point_numeric`	elevation_lowest_point_numeric	float	SEL	0%	1
`land_use_agricultural_land_numeric`	land_use_agricultural_land_numeric	float	SEL	0%	1
`land_use_forest_numeric`	land_use_forest_numeric	float	SEL	0%	1
`irrigated_land_numeric`	irrigated_land_numeric	float	SEL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (36) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`location_text`	location_text	string	0%	1
`geographic_coordinates_text`	geographic_coordinates_text	string	0%	1
`geographic_coordinates_numeric`	geographic_coordinates_numeric	float	0%	1
`map_references_text`	map_references_text	string	0%	1
`area_total_text`	area_total_text	string	0%	1
`area_land_text`	area_land_text	string	0%	1
`area_water_text`	area_water_text	string	0%	1
`area_comparative_text`	area_comparative_text	string	0%	1
`area_comparative_numeric`	area_comparative_numeric	float	0%	1
`land_boundaries_total_text`	land_boundaries_total_text	string	0%	1
`coastline_text`	coastline_text	string	0%	1
`maritime_claims_territorial_sea_text`	maritime_claims_territorial_sea_text	string	0%	1
`maritime_claims_territorial_sea_numeric`	maritime_claims_territorial_sea_numeric	float	0%	1
`maritime_claims_exclusive_fishing_zone_text`	maritime_claims_exclusive_fishing_zone_text	string	0%	1
`maritime_claims_exclusive_fishing_zone_numeric`	maritime_claims_exclusive_fishing_zone_numeric	float	0%	1
`climate_text`	climate_text	string	0%	1
`terrain_text`	terrain_text	string	0%	1
`elevation_highest_point_text`	elevation_highest_point_text	string	0%	1
`elevation_lowest_point_text`	elevation_lowest_point_text	string	0%	1
`natural_resources_text`	natural_resources_text	string	0%	1
`land_use_agricultural_land_text`	land_use_agricultural_land_text	string	0%	1
`land_use_agricultural_land_arable_land_text`	land_use_agricultural_land_arable_land_text	string	0%	1
`land_use_agricultural_land_arable_land_numeric`	land_use_agricultural_land_arable_land_numeric	float	0%	1
`land_use_agricultural_land_permanent_crops_text`	land_use_agricultural_land_permanent_crops_text	string	0%	1
`land_use_agricultural_land_permanent_crops_numeric`	land_use_agricultural_land_permanent_crops_numeric	float	0%	1
`land_use_agricultural_land_permanent_pasture_text`	land_use_agricultural_land_permanent_pasture_text	string	0%	1
`land_use_agricultural_land_permanent_pasture_numeric`	land_use_agricultural_land_permanent_pasture_numeric	float	0%	1
`land_use_forest_text`	land_use_forest_text	string	0%	1
`land_use_other_text`	land_use_other_text	string	0%	1
`land_use_other_numeric`	land_use_other_numeric	float	0%	1
`irrigated_land_text`	irrigated_land_text	string	0%	1
`population_distribution_text`	population_distribution_text	string	0%	1
`natural_hazards_text`	natural_hazards_text	string	0%	1
`geography_note_text`	geography_note_text	string	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

TCA openfactbook - government — 1 rows, 64 columns

Standards-Aligned Fields (2)

Field Name	Label	Type	Schema	Nulls	Unique
`country_code`	country_code	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (62) — supplemental data preserved outside core SEL/CCL schema

TCA openfactbook - introduction — 1 rows, 7 columns

Standards-Aligned Fields (3)

Field Name	Label	Type	Schema	Nulls	Unique
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (4) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`background_text`	background_text	string	0%	1
`background_numeric`	background_numeric	float	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

TCA openfactbook - languages — 1 rows, 6 columns

Standards-Aligned Fields (3)

Field Name	Label	Type	Schema	Nulls	Unique
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (3) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`languages_text`	languages_text	string	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

TCA openfactbook - migration — 1 rows, 7 columns

Standards-Aligned Fields (5)

Field Name	Label	Type	Schema	Nulls	Unique
`refugees_and_internally_displaced_persons_refugees_text`	refugees_and_internally_displaced_persons_refugees_text	string	CCL	0%	1
`refugees_and_internally_displaced_persons_refugees_numeric`	refugees_and_internally_displaced_persons_refugees_numeric	float	CCL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (2) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

TCA openfactbook - military_and_security — 1 rows, 6 columns

Standards-Aligned Fields (3)

Field Name	Label	Type	Schema	Nulls	Unique
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (3) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`military_note_text`	military_note_text	string	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

TCA openfactbook - people_and_society — 1 rows, 117 columns

Standards-Aligned Fields (25)

Field Name	Label	Type	Schema	Nulls	Unique
`population_total_numeric`	population_total_numeric	float	SEL	0%	1
`population_male_numeric`	population_male_numeric	float	SEL	0%	1
`population_female_numeric`	population_female_numeric	float	SEL	0%	1
`age_structure_0_14_years_numeric`	age_structure_0_14_years_numeric	float	SEL	0%	1
`age_structure_15_64_years_numeric`	age_structure_15_64_years_numeric	float	SEL	0%	1
`age_structure_65_years_and_over_numeric`	age_structure_65_years_and_over_numeric	float	SEL	0%	1
`dependency_ratios_total_dependency_ratio_numeric`	dependency_ratios_total_dependency_ratio_numeric	float	SEL	0%	1
`dependency_ratios_youth_dependency_ratio_numeric`	dependency_ratios_youth_dependency_ratio_numeric	float	SEL	0%	1
`dependency_ratios_elderly_dependency_ratio_numeric`	dependency_ratios_elderly_dependency_ratio_numeric	float	SEL	0%	1
`median_age_total_numeric`	median_age_total_numeric	float	SEL	0%	1
`population_growth_rate_numeric`	population_growth_rate_numeric	float	SEL	0%	1
`birth_rate_numeric`	birth_rate_numeric	float	SEL	0%	1
`death_rate_numeric`	death_rate_numeric	float	SEL	0%	1
`net_migration_rate_numeric`	net_migration_rate_numeric	float	SEL	0%	1
`urbanization_urban_population_numeric`	urbanization_urban_population_numeric	float	SEL	0%	1
`urbanization_rate_of_urbanization_numeric`	urbanization_rate_of_urbanization_numeric	float	SEL	0%	1
`sex_ratio_at_birth_numeric`	sex_ratio_at_birth_numeric	float	SEL	0%	1
`sex_ratio_total_population_numeric`	sex_ratio_total_population_numeric	float	SEL	0%	1
`infant_mortality_rate_total_numeric`	infant_mortality_rate_total_numeric	float	SEL	0%	1
`life_expectancy_at_birth_total_population_numeric`	life_expectancy_at_birth_total_population_numeric	float	SEL	0%	1
`total_fertility_rate_numeric`	total_fertility_rate_numeric	float	SEL	0%	1
`gross_reproduction_rate_numeric`	gross_reproduction_rate_numeric	float	SEL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (92) — supplemental data preserved outside core SEL/CCL schema

TCA openfactbook - religions — 1 rows, 7 columns

Standards-Aligned Fields (6)

Field Name	Label	Type	Schema	Nulls	Unique
`religions_text`	religions_text	string	CCL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1
`composition_religion_other_pct_synth`	other	numeric	CCL	0%	-
`composition_ethnicity_primary_label_synth`	Black	string	CCL	0%	-

Extension Fields (3) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`religions_numeric`	religions_numeric	float	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

Pending (14) — awaiting mapping

Field Name	Label	Type	Nulls	Unique
`composition_religion_protestant_pct_synth`	Protestant	numeric	0%	-
`composition_religion_protestant__baptist_pct_synth`	Baptist	numeric	0%	-
`composition_religion_protestant__church_of_god_pct_synth`	Church of God	numeric	0%	-
`composition_religion_protestant__anglican_pct_synth`	Anglican	numeric	0%	-
`composition_religion_protestant__methodist_pct_synth`	Methodist	numeric	0%	-
`composition_religion_protestant__seventh_day_adventist_pct_synth`	Seventh Day Adventist	numeric	0%	-
`composition_religion_roman_catholic_pct_synth`	Roman Catholic	numeric	0%	-
`composition_religion_jehovah_s_witness_pct_synth`	Jehovah's Witness	numeric	0%	-
`composition_ethnicity_black_pct_synth`	Black	numeric	0%	-
`composition_ethnicity_white_pct_synth`	White	numeric	0%	-
`composition_ethnicity_mixed_pct_synth`	mixed	numeric	0%	-
`composition_ethnicity_east_indian_pct_synth`	East Indian	numeric	0%	-
`composition_ethnicity_other_pct_synth`	other	numeric	0%	-
`composition_ethnicity_primary_share_pct_synth`	Black	numeric	0%	-

TCA openfactbook - transportation — 1 rows, 27 columns

Standards-Aligned Fields (5)

Field Name	Label	Type	Schema	Nulls	Unique
`civil_aircraft_registration_country_code_prefix_text`	civil_aircraft_registration_country_code_prefix_text	string	SEL+	0%	1
`airports_numeric`	airports_numeric	float	SEL	0%	1
`country_code`	country_code	string	SEL	0%	1
`country_name`	country_name	string	SEL	0%	1
`admin_level`	admin_level	string	SEL	0%	1

Extension Fields (22) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`airports_text`	airports_text	string	0%	1
`merchant_marine_total_text`	merchant_marine_total_text	string	0%	1
`merchant_marine_total_numeric`	merchant_marine_total_numeric	float	0%	1
`merchant_marine_by_type_text`	merchant_marine_by_type_text	string	0%	1
`merchant_marine_by_type_numeric`	merchant_marine_by_type_numeric	float	0%	1
`ports_total_ports_text`	ports_total_ports_text	string	0%	1
`ports_total_ports_numeric`	ports_total_ports_numeric	float	0%	1
`ports_large_text`	ports_large_text	float	0%	1
`ports_large_numeric`	ports_large_numeric	float	0%	1
`ports_medium_text`	ports_medium_text	float	0%	1
`ports_medium_numeric`	ports_medium_numeric	float	0%	1
`ports_small_text`	ports_small_text	float	0%	1
`ports_small_numeric`	ports_small_numeric	float	0%	1
`ports_very_small_text`	ports_very_small_text	float	0%	1
`ports_very_small_numeric`	ports_very_small_numeric	float	0%	1
`ports_size_unknown_text`	ports_size_unknown_text	float	0%	1
`ports_size_unknown_numeric`	ports_size_unknown_numeric	float	0%	1
`ports_ports_with_oil_terminals_text`	ports_ports_with_oil_terminals_text	float	0%	1
`ports_ports_with_oil_terminals_numeric`	ports_ports_with_oil_terminals_numeric	float	0%	1
`ports_key_ports_text`	ports_key_ports_text	string	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

HERA · Human Entity Reference Atlas by Masego Inc

SEL (68 mappings)

CCL (2 mappings)

Preview

Download Options

Field Name	Label	Type	Nulls	Unique
`environmental_issues_text`	environmental_issues_text	string	0%	1
`climate_text`	climate_text	string	0%	1
`land_use_agricultural_land_text`	land_use_agricultural_land_text	string	0%	1
`land_use_agricultural_land_arable_land_text`	land_use_agricultural_land_arable_land_text	string	0%	1
`land_use_agricultural_land_arable_land_numeric`	land_use_agricultural_land_arable_land_numeric	float	0%	1
`land_use_agricultural_land_permanent_crops_text`	land_use_agricultural_land_permanent_crops_text	string	0%	1
`land_use_agricultural_land_permanent_crops_numeric`	land_use_agricultural_land_permanent_crops_numeric	float	0%	1
`land_use_agricultural_land_permanent_pasture_text`	land_use_agricultural_land_permanent_pasture_text	string	0%	1
`land_use_agricultural_land_permanent_pasture_numeric`	land_use_agricultural_land_permanent_pasture_numeric	float	0%	1
`land_use_forest_text`	land_use_forest_text	string	0%	1
`land_use_other_text`	land_use_other_text	string	0%	1
`land_use_other_numeric`	land_use_other_numeric	float	0%	1
`urbanization_urban_population_text`	urbanization_urban_population_text	string	0%	1
`urbanization_rate_of_urbanization_text`	urbanization_rate_of_urbanization_text	string	0%	1
`carbon_dioxide_emissions_total_emissions_text`	carbon_dioxide_emissions_total_emissions_text	string	0%	1
`carbon_dioxide_emissions_total_emissions_numeric`	carbon_dioxide_emissions_total_emissions_numeric	float	0%	1
`carbon_dioxide_emissions_from_petroleum_and_other_liquids_text`	carbon_dioxide_emissions_from_petroleum_and_other_liquids_text	string	0%	1
`carbon_dioxide_emissions_from_petroleum_and_other_liquids_numeric`	carbon_dioxide_emissions_from_petroleum_and_other_liquids_numeric	float	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

Field Name	Label	Type	Nulls	Unique
`country_name_conventional_long_form_text`	country_name_conventional_long_form_text	string	0%	1
`country_name_conventional_short_form_text`	country_name_conventional_short_form_text	string	0%	1
`country_name_abbreviation_text`	country_name_abbreviation_text	string	0%	1
`country_name_etymology_text`	country_name_etymology_text	string	0%	1
`government_type_text`	government_type_text	string	0%	1
`dependency_status_text`	dependency_status_text	string	0%	1
`capital_name_text`	capital_name_text	string	0%	1
`capital_geographic_coordinates_text`	capital_geographic_coordinates_text	string	0%	1
`capital_geographic_coordinates_numeric`	capital_geographic_coordinates_numeric	float	0%	1
`capital_time_difference_text`	capital_time_difference_text	string	0%	1
`capital_time_difference_numeric`	capital_time_difference_numeric	float	0%	1
`capital_daylight_saving_time_text`	capital_daylight_saving_time_text	string	0%	1
`capital_daylight_saving_time_numeric`	capital_daylight_saving_time_numeric	float	0%	1
`capital_etymology_text`	capital_etymology_text	string	0%	1
`capital_etymology_numeric`	capital_etymology_numeric	float	0%	1
`legal_system_text`	legal_system_text	string	0%	1
`constitution_history_text`	constitution_history_text	string	0%	1
`constitution_history_numeric`	constitution_history_numeric	float	0%	1
`citizenship_text`	citizenship_text	string	0%	1
`suffrage_text`	suffrage_text	string	0%	1
`suffrage_numeric`	suffrage_numeric	float	0%	1
`executive_branch_chief_of_state_text`	executive_branch_chief_of_state_text	string	0%	1
`executive_branch_chief_of_state_numeric`	executive_branch_chief_of_state_numeric	float	0%	1
`executive_branch_head_of_government_text`	executive_branch_head_of_government_text	string	0%	1
`executive_branch_head_of_government_numeric`	executive_branch_head_of_government_numeric	float	0%	1
`executive_branch_cabinet_text`	executive_branch_cabinet_text	string	0%	1
`executive_branch_election_appointment_process_text`	executive_branch_election_appointment_process_text	string	0%	1
`legislative_branch_legislature_name_text`	legislative_branch_legislature_name_text	string	0%	1
`legislative_branch_legislative_structure_text`	legislative_branch_legislative_structure_text	string	0%	1
`legislative_branch_number_of_seats_text`	legislative_branch_number_of_seats_text	string	0%	1
`legislative_branch_number_of_seats_numeric`	legislative_branch_number_of_seats_numeric	float	0%	1
`legislative_branch_electoral_system_text`	legislative_branch_electoral_system_text	string	0%	1
`legislative_branch_scope_of_elections_text`	legislative_branch_scope_of_elections_text	string	0%	1
`legislative_branch_term_in_office_text`	legislative_branch_term_in_office_text	string	0%	1
`legislative_branch_term_in_office_numeric`	legislative_branch_term_in_office_numeric	float	0%	1
`legislative_branch_most_recent_election_date_text`	legislative_branch_most_recent_election_date_text	string	0%	1
`legislative_branch_most_recent_election_date_numeric`	legislative_branch_most_recent_election_date_numeric	float	0%	1
`legislative_branch_parties_elected_and_seats_per_party_text`	legislative_branch_parties_elected_and_seats_per_party_text	string	0%	1
`legislative_branch_parties_elected_and_seats_per_party_numeric`	legislative_branch_parties_elected_and_seats_per_party_numeric	float	0%	1
`legislative_branch_percentage_of_women_in_chamber_text`	legislative_branch_percentage_of_women_in_chamber_text	string	0%	1
`legislative_branch_percentage_of_women_in_chamber_numeric`	legislative_branch_percentage_of_women_in_chamber_numeric	float	0%	1
`legislative_branch_expected_date_of_next_election_text`	legislative_branch_expected_date_of_next_election_text	float	0%	1
`legislative_branch_expected_date_of_next_election_numeric`	legislative_branch_expected_date_of_next_election_numeric	float	0%	1
`judicial_branch_highest_court_s_text`	judicial_branch_highest_court_s_text	string	0%	1
`judicial_branch_highest_court_s_numeric`	judicial_branch_highest_court_s_numeric	float	0%	1
`judicial_branch_judge_selection_and_term_of_office_text`	judicial_branch_judge_selection_and_term_of_office_text	string	0%	1
`judicial_branch_judge_selection_and_term_of_office_numeric`	judicial_branch_judge_selection_and_term_of_office_numeric	float	0%	1
`judicial_branch_subordinate_courts_text`	judicial_branch_subordinate_courts_text	string	0%	1
`judicial_branch_note`	judicial_branch_note	string	0%	1
`political_parties_text`	political_parties_text	string	0%	1
`diplomatic_representation_in_the_us_text`	diplomatic_representation_in_the_us_text	string	0%	1
`diplomatic_representation_from_the_us_embassy_text`	diplomatic_representation_from_the_us_embassy_text	string	0%	1
`international_organization_participation_text`	international_organization_participation_text	string	0%	1
`independence_text`	independence_text	string	0%	1
`flag_text`	flag_text	string	0%	1
`national_symbol_s_text`	national_symbol_s_text	string	0%	1
`national_anthem_s_title_text`	national_anthem_s_title_text	string	0%	1
`national_anthem_s_lyrics_music_text`	national_anthem_s_lyrics_music_text	string	0%	1
`national_anthem_s_history_text`	national_anthem_s_history_text	string	0%	1
`country_name`	country_name	string	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

Field Name	Label	Type	Nulls	Unique
`population_total_text`	population_total_text	string	0%	1
`population_male_text`	population_male_text	string	0%	1
`population_female_text`	population_female_text	string	0%	1
`age_structure_0_14_years_text`	age_structure_0_14_years_text	string	0%	1
`age_structure_15_64_years_text`	age_structure_15_64_years_text	string	0%	1
`age_structure_65_years_and_over_text`	age_structure_65_years_and_over_text	string	0%	1
`dependency_ratios_total_dependency_ratio_text`	dependency_ratios_total_dependency_ratio_text	string	0%	1
`dependency_ratios_youth_dependency_ratio_text`	dependency_ratios_youth_dependency_ratio_text	string	0%	1
`dependency_ratios_elderly_dependency_ratio_text`	dependency_ratios_elderly_dependency_ratio_text	string	0%	1
`dependency_ratios_potential_support_ratio_text`	dependency_ratios_potential_support_ratio_text	string	0%	1
`dependency_ratios_potential_support_ratio_numeric`	dependency_ratios_potential_support_ratio_numeric	float	0%	1
`median_age_total_text`	median_age_total_text	string	0%	1
`median_age_male_text`	median_age_male_text	string	0%	1
`median_age_male_numeric`	median_age_male_numeric	float	0%	1
`median_age_female_text`	median_age_female_text	string	0%	1
`median_age_female_numeric`	median_age_female_numeric	float	0%	1
`population_growth_rate_text`	population_growth_rate_text	string	0%	1
`birth_rate_text`	birth_rate_text	string	0%	1
`death_rate_text`	death_rate_text	string	0%	1
`net_migration_rate_text`	net_migration_rate_text	string	0%	1
`population_distribution_text`	population_distribution_text	string	0%	1
`urbanization_urban_population_text`	urbanization_urban_population_text	string	0%	1
`urbanization_rate_of_urbanization_text`	urbanization_rate_of_urbanization_text	string	0%	1
`major_urban_areas_population_text`	major_urban_areas_population_text	string	0%	1
`major_urban_areas_population_numeric`	major_urban_areas_population_numeric	float	0%	1
`sex_ratio_at_birth_text`	sex_ratio_at_birth_text	string	0%	1
`sex_ratio_0_14_years_text`	sex_ratio_0_14_years_text	string	0%	1
`sex_ratio_0_14_years_numeric`	sex_ratio_0_14_years_numeric	float	0%	1
`sex_ratio_15_64_years_text`	sex_ratio_15_64_years_text	string	0%	1
`sex_ratio_15_64_years_numeric`	sex_ratio_15_64_years_numeric	float	0%	1
`sex_ratio_65_years_and_over_text`	sex_ratio_65_years_and_over_text	string	0%	1
`sex_ratio_65_years_and_over_numeric`	sex_ratio_65_years_and_over_numeric	float	0%	1
`sex_ratio_total_population_text`	sex_ratio_total_population_text	string	0%	1
`infant_mortality_rate_total_text`	infant_mortality_rate_total_text	string	0%	1
`infant_mortality_rate_male_text`	infant_mortality_rate_male_text	string	0%	1
`infant_mortality_rate_male_numeric`	infant_mortality_rate_male_numeric	float	0%	1
`infant_mortality_rate_female_text`	infant_mortality_rate_female_text	string	0%	1
`infant_mortality_rate_female_numeric`	infant_mortality_rate_female_numeric	float	0%	1
`life_expectancy_at_birth_total_population_text`	life_expectancy_at_birth_total_population_text	string	0%	1
`life_expectancy_at_birth_male_text`	life_expectancy_at_birth_male_text	string	0%	1
`life_expectancy_at_birth_male_numeric`	life_expectancy_at_birth_male_numeric	float	0%	1
`life_expectancy_at_birth_female_text`	life_expectancy_at_birth_female_text	string	0%	1
`life_expectancy_at_birth_female_numeric`	life_expectancy_at_birth_female_numeric	float	0%	1
`total_fertility_rate_text`	total_fertility_rate_text	string	0%	1
`gross_reproduction_rate_text`	gross_reproduction_rate_text	string	0%	1
`drinking_water_source_improved_urban_text`	drinking_water_source_improved_urban_text	string	0%	1
`drinking_water_source_improved_urban_numeric`	drinking_water_source_improved_urban_numeric	float	0%	1
`drinking_water_source_improved_rural_text`	drinking_water_source_improved_rural_text	string	0%	1
`drinking_water_source_improved_rural_numeric`	drinking_water_source_improved_rural_numeric	float	0%	1
`drinking_water_source_improved_total_text`	drinking_water_source_improved_total_text	string	0%	1
`drinking_water_source_improved_total_numeric`	drinking_water_source_improved_total_numeric	float	0%	1
`drinking_water_source_unimproved_urban_text`	drinking_water_source_unimproved_urban_text	string	0%	1
`drinking_water_source_unimproved_urban_numeric`	drinking_water_source_unimproved_urban_numeric	float	0%	1
`drinking_water_source_unimproved_rural_text`	drinking_water_source_unimproved_rural_text	string	0%	1
`drinking_water_source_unimproved_rural_numeric`	drinking_water_source_unimproved_rural_numeric	float	0%	1
`drinking_water_source_unimproved_total_text`	drinking_water_source_unimproved_total_text	string	0%	1
`drinking_water_source_unimproved_total_numeric`	drinking_water_source_unimproved_total_numeric	float	0%	1
`sanitation_facility_access_improved_urban_text`	sanitation_facility_access_improved_urban_text	string	0%	1
`sanitation_facility_access_improved_urban_numeric`	sanitation_facility_access_improved_urban_numeric	float	0%	1
`sanitation_facility_access_improved_rural_text`	sanitation_facility_access_improved_rural_text	string	0%	1
`sanitation_facility_access_improved_rural_numeric`	sanitation_facility_access_improved_rural_numeric	float	0%	1
`sanitation_facility_access_improved_total_text`	sanitation_facility_access_improved_total_text	string	0%	1
`sanitation_facility_access_improved_total_numeric`	sanitation_facility_access_improved_total_numeric	float	0%	1
`sanitation_facility_access_unimproved_urban_text`	sanitation_facility_access_unimproved_urban_text	string	0%	1
`sanitation_facility_access_unimproved_urban_numeric`	sanitation_facility_access_unimproved_urban_numeric	float	0%	1
`sanitation_facility_access_unimproved_rural_text`	sanitation_facility_access_unimproved_rural_text	string	0%	1
`sanitation_facility_access_unimproved_rural_numeric`	sanitation_facility_access_unimproved_rural_numeric	float	0%	1
`sanitation_facility_access_unimproved_total_text`	sanitation_facility_access_unimproved_total_text	string	0%	1
`sanitation_facility_access_unimproved_total_numeric`	sanitation_facility_access_unimproved_total_numeric	float	0%	1
`children_under_the_age_of_5_years_underweight_text`	children_under_the_age_of_5_years_underweight_text	string	0%	1
`children_under_the_age_of_5_years_underweight_numeric`	children_under_the_age_of_5_years_underweight_numeric	float	0%	1
`currently_married_women_ages_15_49_text`	currently_married_women_ages_15_49_text	string	0%	1
`currently_married_women_ages_15_49_numeric`	currently_married_women_ages_15_49_numeric	float	0%	1
`child_marriage_women_married_by_age_15_text`	child_marriage_women_married_by_age_15_text	string	0%	1
`child_marriage_women_married_by_age_15_numeric`	child_marriage_women_married_by_age_15_numeric	float	0%	1
`child_marriage_women_married_by_age_18_text`	child_marriage_women_married_by_age_18_text	string	0%	1
`child_marriage_women_married_by_age_18_numeric`	child_marriage_women_married_by_age_18_numeric	float	0%	1
`child_marriage_men_married_by_age_18_text`	child_marriage_men_married_by_age_18_text	string	0%	1
`child_marriage_men_married_by_age_18_numeric`	child_marriage_men_married_by_age_18_numeric	float	0%	1
`education_expenditure_education_expenditure_gdp_text`	education_expenditure_education_expenditure_gdp_text	string	0%	1
`education_expenditure_education_expenditure_gdp_numeric`	education_expenditure_education_expenditure_gdp_numeric	float	0%	1
`education_expenditure_education_expenditure_national_budget_text`	education_expenditure_education_expenditure_national_budget_text	string	0%	1
`education_expenditure_education_expenditure_national_budget_numeric`	education_expenditure_education_expenditure_national_budget_numeric	float	0%	1
`school_life_expectancy_primary_to_tertiary_education_total_text`	school_life_expectancy_primary_to_tertiary_education_total_text	string	0%	1
`school_life_expectancy_primary_to_tertiary_education_total_numeric`	school_life_expectancy_primary_to_tertiary_education_total_numeric	float	0%	1
`school_life_expectancy_primary_to_tertiary_education_male_text`	school_life_expectancy_primary_to_tertiary_education_male_text	string	0%	1
`school_life_expectancy_primary_to_tertiary_education_male_numeric`	school_life_expectancy_primary_to_tertiary_education_male_numeric	float	0%	1
`school_life_expectancy_primary_to_tertiary_education_female_text`	school_life_expectancy_primary_to_tertiary_education_female_text	string	0%	1
`school_life_expectancy_primary_to_tertiary_education_female_numeric`	school_life_expectancy_primary_to_tertiary_education_female_numeric	float	0%	1
`people_note_text`	people_note_text	string	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

Field Name	Label	Type	Nulls	Unique
`electricity_access_electrification_total_population_text`	electricity_access_electrification_total_population_text	string	0%	1
`electricity_access_electrification_urban_areas_text`	electricity_access_electrification_urban_areas_text	string	0%	1
`electricity_access_electrification_urban_areas_numeric`	electricity_access_electrification_urban_areas_numeric	float	0%	1
`electricity_access_electrification_rural_areas_text`	electricity_access_electrification_rural_areas_text	string	0%	1
`electricity_access_electrification_rural_areas_numeric`	electricity_access_electrification_rural_areas_numeric	float	0%	1
`electricity_installed_generating_capacity_text`	electricity_installed_generating_capacity_text	string	0%	1
`electricity_installed_generating_capacity_numeric`	electricity_installed_generating_capacity_numeric	float	0%	1
`electricity_consumption_text`	electricity_consumption_text	string	0%	1
`electricity_consumption_numeric`	electricity_consumption_numeric	float	0%	1
`electricity_transmission_distribution_losses_text`	electricity_transmission_distribution_losses_text	string	0%	1
`electricity_transmission_distribution_losses_numeric`	electricity_transmission_distribution_losses_numeric	float	0%	1
`electricity_generation_sources_fossil_fuels_text`	electricity_generation_sources_fossil_fuels_text	string	0%	1
`electricity_generation_sources_fossil_fuels_numeric`	electricity_generation_sources_fossil_fuels_numeric	float	0%	1
`electricity_generation_sources_solar_text`	electricity_generation_sources_solar_text	string	0%	1
`electricity_generation_sources_solar_numeric`	electricity_generation_sources_solar_numeric	float	0%	1
`petroleum_refined_petroleum_consumption_text`	petroleum_refined_petroleum_consumption_text	string	0%	1
`petroleum_refined_petroleum_consumption_numeric`	petroleum_refined_petroleum_consumption_numeric	float	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1