PCN

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

PCN OpenFactBook PCN-OPENFACTBOOK Country Profile

12 rows · 12 table(s) OpenFactBook 0 1 2 3 51 SEL 2 CCL 159 ext ▶

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

0 Admin 0 — 12 table(s)

PCN openfactbook - communications — 1 rows, 10 columns

Standards-Aligned Fields (5)

Field Name	Label	Type	Schema	Nulls	Unique
`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 (5) — supplemental data preserved outside core SEL/CCL schema

Field Name	Label	Type	Nulls	Unique
`telephones_mobile_cellular_text`	telephones_mobile_cellular_text	string	0%	1
`broadcast_media_text`	broadcast_media_text	string	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

PCN openfactbook - economy — 1 rows, 28 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 (25) — 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
`agricultural_products_text`	agricultural_products_text	string	0%	1
`industries_text`	industries_text	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_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_currency_text`	exchange_rates_currency_text	string	0%	1
`exchange_rates_exchange_rates_2024_text`	exchange_rates_exchange_rates_2024_text	string	0%	1
`exchange_rates_exchange_rates_2024_numeric`	exchange_rates_exchange_rates_2024_numeric	float	0%	1
`exchange_rates_exchange_rates_2023_text`	exchange_rates_exchange_rates_2023_text	string	0%	1
`exchange_rates_exchange_rates_2023_numeric`	exchange_rates_exchange_rates_2023_numeric	float	0%	1
`exchange_rates_exchange_rates_2022_text`	exchange_rates_exchange_rates_2022_text	string	0%	1
`exchange_rates_exchange_rates_2022_numeric`	exchange_rates_exchange_rates_2022_numeric	float	0%	1
`exchange_rates_exchange_rates_2021_text`	exchange_rates_exchange_rates_2021_text	string	0%	1
`exchange_rates_exchange_rates_2021_numeric`	exchange_rates_exchange_rates_2021_numeric	float	0%	1
`exchange_rates_exchange_rates_2020_text`	exchange_rates_exchange_rates_2020_text	string	0%	1
`exchange_rates_exchange_rates_2020_numeric`	exchange_rates_exchange_rates_2020_numeric	float	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

PCN openfactbook - environment — 1 rows, 13 columns

Standards-Aligned Fields (5)

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
`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 (8) — supplemental data preserved outside core SEL/CCL schema

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_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
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

PCN openfactbook - ethnic_groups — 1 rows, 8 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 (4) — 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
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

PCN openfactbook - geography — 1 rows, 42 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 (29) — 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
`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_economic_zone_text`	maritime_claims_exclusive_economic_zone_text	string	0%	1
`maritime_claims_exclusive_economic_zone_numeric`	maritime_claims_exclusive_economic_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_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

PCN openfactbook - government — 1 rows, 69 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 (67) — supplemental data preserved outside core SEL/CCL schema

PCN 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

PCN openfactbook - languages — 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
`languages_text`	languages_text	string	0%	1
`languages_numeric`	languages_numeric	float	0%	1
`source_section`	source_section	string	0%	1
`source_profile_path`	source_profile_path	string	0%	1

PCN 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

PCN openfactbook - people_and_society — 1 rows, 10 columns

Standards-Aligned Fields (5)

Field Name	Label	Type	Schema	Nulls	Unique
`population_total_numeric`	population_total_numeric	float	SEL	0%	1
`population_growth_rate_numeric`	population_growth_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 (5) — supplemental data preserved outside core SEL/CCL schema

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

PCN openfactbook - religions — 1 rows, 7 columns

Standards-Aligned Fields (4)

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

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 (2) — awaiting mapping

Field Name	Label	Type	Nulls	Unique
`composition_religion_seventh_day_adventist_pct_synth`	Seventh Day Adventist	numeric	0%	-
`composition_ethnicity_descendants_of_the_bounty_mutineers_and_their_tahitian_wives_pct_synth`	descendants of the Bounty mutineers and their Tahitian wives	numeric	0%	-

PCN openfactbook - transportation — 1 rows, 5 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 (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

HERA · Human Entity Reference Atlas by Masego Inc

SEL (24 mappings)

CCL (0 mappings)

Preview

Download Options

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_etymology_text`	country_name_etymology_text	string	0%	1
`country_name_etymology_numeric`	country_name_etymology_numeric	float	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_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
`executive_branch_election_appointment_process_numeric`	executive_branch_election_appointment_process_numeric	float	0%	1
`executive_branch_most_recent_election_date_text`	executive_branch_most_recent_election_date_text	string	0%	1
`executive_branch_most_recent_election_date_numeric`	executive_branch_most_recent_election_date_numeric	float	0%	1
`executive_branch_election_results_text`	executive_branch_election_results_text	string	0%	1
`executive_branch_expected_date_of_next_election_text`	executive_branch_expected_date_of_next_election_text	string	0%	1
`executive_branch_expected_date_of_next_election_numeric`	executive_branch_expected_date_of_next_election_numeric	float	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	string	0%	1
`legislative_branch_note`	legislative_branch_note	string	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
`national_holiday_text`	national_holiday_text	string	0%	1
`national_holiday_numeric`	national_holiday_numeric	float	0%	1
`flag_text`	flag_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