Saint Pierre and Miquelon

Datasets (3)

SEL — DGIWG Statistical Extent Location SEL+ — Platform extension (not in DGIWG core spec) CCL — DGIWG Cultural Context Location Extension — Preserved in extension tables (not in core SEL/CCL schema) Pending — Awaiting mapping

SPM OpenFactBook SPM-OPENFACTBOOK Country Profile

13 rows · 13 table(s) OpenFactBook 0 1 2 3 79 SEL 1 CCL 266 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 13 table(s)

SPM OpenFactBook - Communications — 1 rows, 14 columns

Loading data…

Field details — 14 fields (type, nulls, unique, samples)

Standards-Aligned Fields (6)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`telephones_fixed_lines_subscriptions_per_100_inhabitants_numeric`	Fixed line subscriptions per 100	float	SEL	0%	1	76.0
`internet_country_code_text`	Internet country code text	string	SEL+	0%	1	.pm
`internet_users_percent_of_population_numeric`	Internet penetration percent	float	SEL	0%	1	88.7
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`telephones_fixed_lines_total_subscriptions_text`	telephones_fixed_lines_total_subscriptions_text	string	0%	1	4,800 (2015 est.)
`telephones_fixed_lines_total_subscriptions_numeric`	telephones_fixed_lines_total_subscriptions_numeric	float	0%	1	4800.0
`telephones_fixed_lines_subscriptions_per_100_inhabitants_text`	telephones_fixed_lines_subscriptions_per_100_inhabitants_text	string	0%	1	76 (2015 est.)
`broadcast_media_text`	broadcast_media_text	string	0%	1	8 TV stations, all part of the French Overseas Network,...
`broadcast_media_numeric`	broadcast_media_numeric	float	0%	1	8.0
`internet_users_percent_of_population_text`	internet_users_percent_of_population_text	string	0%	1	88.7% (2022 est.)
`source_section`	source_section	string	0%	1	Communications
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

SPM OpenFactBook - Economy — 1 rows, 32 columns

Loading data…

Field details — 32 fields (type, nulls, unique, samples)

Standards-Aligned Fields (4)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`gdp_official_exchange_rate_numeric`	Gdp total usd	float	SEL	0%	1	261.3
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`economic_overview_text`	economic_overview_text	string	0%	1	high-income, French North American territorial economy;...
`real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2015_text`	Real gdp purchasing power parity 2015 (text)	string	0%	1	$261.3 million (2015 est.)
`real_gdp_purchasing_power_parity_real_gdp_purchasing_power_parity_2015_numeric`	Real gdp purchasing power parity 2015 (numeric)	float	0%	1	261.3
`real_gdp_purchasing_power_parity_note`	real_gdp_purchasing_power_parity_note	string	0%	1	note: supplemented by annual payments from France of...
`gdp_official_exchange_rate_text`	gdp_official_exchange_rate_text	string	0%	1	$261.3 million (2015 est.)
`agricultural_products_text`	agricultural_products_text	string	0%	1	vegetables; poultry, cattle, sheep, pigs; fish
`industries_text`	industries_text	string	0%	1	fish processing and supply base for fishing fleets; tourism
`exports_partners_text`	exports_partners_text	string	0%	1	Canada 78%, Ireland 5%, France 5%, Djibouti 4%, UK 2% (2023)
`exports_partners_numeric`	exports_partners_numeric	float	0%	1	78.0
`exports_commodities_text`	exports_commodities_text	string	0%	1	processed crustaceans, shellfish (2023)
`exports_commodities_numeric`	exports_commodities_numeric	float	0%	1	2023.0
`imports_partners_text`	imports_partners_text	string	0%	1	France 57%, Canada 37%, Netherlands 3%, Belgium 2%,...
`imports_partners_numeric`	imports_partners_numeric	float	0%	1	57.0
`imports_commodities_text`	imports_commodities_text	string	0%	1	refined petroleum, packaged medicine, cars, plastic...
`imports_commodities_numeric`	imports_commodities_numeric	float	0%	1	2023.0
`exchange_rates_currency_text`	exchange_rates_currency_text	string	0%	1	euros (EUR) per US dollar -
`exchange_rates_exchange_rates_2024_text`	Exchange rates 2024 (text)	string	0%	1	0.924 (2024 est.)
`exchange_rates_exchange_rates_2024_numeric`	Exchange rates 2024 (numeric)	float	0%	1	0.924
`exchange_rates_exchange_rates_2023_text`	Exchange rates 2023 (text)	string	0%	1	0.925 (2023 est.)
`exchange_rates_exchange_rates_2023_numeric`	Exchange rates 2023 (numeric)	float	0%	1	0.925
`exchange_rates_exchange_rates_2022_text`	Exchange rates 2022 (text)	string	0%	1	0.95 (2022 est.)
`exchange_rates_exchange_rates_2022_numeric`	Exchange rates 2022 (numeric)	float	0%	1	0.95
`exchange_rates_exchange_rates_2021_text`	Exchange rates 2021 (text)	string	0%	1	0.845 (2021 est.)
`exchange_rates_exchange_rates_2021_numeric`	Exchange rates 2021 (numeric)	float	0%	1	0.845
`exchange_rates_exchange_rates_2020_text`	Exchange rates 2020 (text)	string	0%	1	0.876 (2020 est.)
`exchange_rates_exchange_rates_2020_numeric`	Exchange rates 2020 (numeric)	float	0%	1	0.876
`source_section`	source_section	string	0%	1	Economy
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

SPM OpenFactBook - Energy — 1 rows, 15 columns

Loading data…

Field details — 15 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`electricity_installed_generating_capacity_text`	electricity_installed_generating_capacity_text	string	0%	1	26,000 kW (2023 est.)
`electricity_installed_generating_capacity_numeric`	electricity_installed_generating_capacity_numeric	float	0%	1	26000.0
`electricity_consumption_text`	electricity_consumption_text	string	0%	1	48.714 million kWh (2023 est.)
`electricity_consumption_numeric`	electricity_consumption_numeric	float	0%	1	48.714
`electricity_transmission_distribution_losses_text`	electricity_transmission_distribution_losses_text	string	0%	1	2 million kWh (2023 est.)
`electricity_transmission_distribution_losses_numeric`	electricity_transmission_distribution_losses_numeric	float	0%	1	2.0
`electricity_generation_sources_fossil_fuels_text`	electricity_generation_sources_fossil_fuels_text	string	0%	1	100% of total installed capacity (2023 est.)
`electricity_generation_sources_fossil_fuels_numeric`	electricity_generation_sources_fossil_fuels_numeric	float	0%	1	100.0
`petroleum_refined_petroleum_consumption_text`	petroleum_refined_petroleum_consumption_text	string	0%	1	400 bbl/day (2023 est.)
`petroleum_refined_petroleum_consumption_numeric`	petroleum_refined_petroleum_consumption_numeric	float	0%	1	400.0
`source_section`	source_section	string	0%	1	Energy
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

SPM OpenFactBook - Environment — 1 rows, 27 columns

Loading data…

Field details — 27 fields (type, nulls, unique, samples)

Standards-Aligned Fields (7)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`land_use_agricultural_land_numeric`	Agricultural land percent	float	SEL	0%	1	8.7
`land_use_forest_numeric`	Forest area percent	float	SEL	0%	1	5.0
`urbanization_urban_population_numeric`	Urban population percent	float	SEL	0%	1	90.1
`urbanization_rate_of_urbanization_numeric`	Urban growth rate percent	float	SEL	0%	1	0.75
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`environmental_issues_text`	environmental_issues_text	string	0%	1	overfishing
`climate_text`	climate_text	string	0%	1	cold and wet, with considerable mist and fog; spring and...
`land_use_agricultural_land_text`	land_use_agricultural_land_text	string	0%	1	8.7% (2023 est.)
`land_use_agricultural_land_arable_land_text`	land_use_agricultural_land_arable_land_text	string	0%	1	arable land: 8.7% (2023 est.)
`land_use_agricultural_land_arable_land_numeric`	land_use_agricultural_land_arable_land_numeric	float	0%	1	8.7
`land_use_agricultural_land_permanent_crops_text`	land_use_agricultural_land_permanent_crops_text	string	0%	1	permanent crops: 0% (2022 est.)
`land_use_agricultural_land_permanent_crops_numeric`	land_use_agricultural_land_permanent_crops_numeric	float	0%	1	0.0
`land_use_agricultural_land_permanent_pasture_text`	land_use_agricultural_land_permanent_pasture_text	string	0%	1	permanent pasture: 0% (2022 est.)
`land_use_agricultural_land_permanent_pasture_numeric`	land_use_agricultural_land_permanent_pasture_numeric	float	0%	1	0.0
`land_use_forest_text`	land_use_forest_text	string	0%	1	5% (2023 est.)
`land_use_other_text`	land_use_other_text	string	0%	1	86.3% (2023 est.)
`land_use_other_numeric`	land_use_other_numeric	float	0%	1	86.3
`urbanization_urban_population_text`	urbanization_urban_population_text	string	0%	1	90.1% of total population (2023)
`urbanization_rate_of_urbanization_text`	urbanization_rate_of_urbanization_text	string	0%	1	0.75% annual rate of change (2020-25 est.)
`carbon_dioxide_emissions_total_emissions_text`	carbon_dioxide_emissions_total_emissions_text	string	0%	1	57,000 metric tonnes of CO2 (2023 est.)
`carbon_dioxide_emissions_total_emissions_numeric`	carbon_dioxide_emissions_total_emissions_numeric	float	0%	1	57000.0
`carbon_dioxide_emissions_from_petroleum_and_other_liquids_text`	carbon_dioxide_emissions_from_petroleum_and_other_liquids_text	string	0%	1	57,000 metric tonnes of CO2 (2023 est.)
`carbon_dioxide_emissions_from_petroleum_and_other_liquids_numeric`	carbon_dioxide_emissions_from_petroleum_and_other_liquids_numeric	float	0%	1	57000.0
`source_section`	source_section	string	0%	1	Environment
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

SPM OpenFactBook - Ethnic Groups — 1 rows, 8 columns

Loading data…

Field details — 8 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`nationality_noun_text`	nationality_noun_text	string	0%	1	Frenchman(men), Frenchwoman(women)
`nationality_adjective_text`	nationality_adjective_text	string	0%	1	French
`ethnic_groups_text`	ethnic_groups_text	string	0%	1	Basques and Bretons (French fishermen)
`source_section`	source_section	string	0%	1	People and Society:ethnic_groups
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

SPM OpenFactBook - Geography — 1 rows, 50 columns

Loading data…

Field details — 50 fields (type, nulls, unique, samples)

Standards-Aligned Fields (13)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`area_total_numeric`	Area sqkm	float	SEL	0%	1	242.0
`area_land_numeric`	Area land sqkm	float	SEL	0%	1	242.0
`area_water_numeric`	Area water sqkm	float	SEL	0%	1	0.0
`land_boundaries_total_numeric`	Land boundary km	float	SEL	0%	1	0.0
`coastline_numeric`	Coastline km	float	SEL	0%	1	120.0
`elevation_highest_point_numeric`	Elevation max m	float	SEL	0%	1	240.0
`elevation_lowest_point_numeric`	Elevation min m	float	SEL	0%	1	0.0
`land_use_agricultural_land_numeric`	Agricultural land percent	float	SEL	0%	1	8.7
`land_use_forest_numeric`	Forest area percent	float	SEL	0%	1	5.0
`irrigated_land_numeric`	Irrigated land sqkm	float	SEL	0%	1	0.0
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`location_text`	location_text	string	0%	1	Northern North America, islands in the North Atlantic...
`geographic_coordinates_text`	geographic_coordinates_text	string	0%	1	46 50 N, 56 20 W
`geographic_coordinates_numeric`	geographic_coordinates_numeric	float	0%	1	46.0
`map_references_text`	map_references_text	string	0%	1	North America
`area_total_text`	area_total_text	string	0%	1	242 sq km
`area_land_text`	area_land_text	string	0%	1	242 sq km
`area_water_text`	area_water_text	string	0%	1	0 sq km
`area_note`	area_note	string	0%	1	note: includes eight small islands in the Saint Pierre...
`area_comparative_text`	area_comparative_text	string	0%	1	1.5 times the size of Washington, D.C.
`area_comparative_numeric`	area_comparative_numeric	float	0%	1	1.5
`land_boundaries_total_text`	land_boundaries_total_text	string	0%	1	0 km
`coastline_text`	coastline_text	string	0%	1	120 km
`maritime_claims_territorial_sea_text`	maritime_claims_territorial_sea_text	string	0%	1	12 nm
`maritime_claims_territorial_sea_numeric`	maritime_claims_territorial_sea_numeric	float	0%	1	12.0
`maritime_claims_exclusive_economic_zone_text`	maritime_claims_exclusive_economic_zone_text	string	0%	1	200 nm
`maritime_claims_exclusive_economic_zone_numeric`	maritime_claims_exclusive_economic_zone_numeric	float	0%	1	200.0
`climate_text`	climate_text	string	0%	1	cold and wet, with considerable mist and fog; spring and...
`terrain_text`	terrain_text	string	0%	1	mostly barren rock
`elevation_highest_point_text`	elevation_highest_point_text	string	0%	1	Morne de la Grande Montagne 240 m
`elevation_lowest_point_text`	elevation_lowest_point_text	string	0%	1	Atlantic Ocean 0 m
`natural_resources_text`	natural_resources_text	string	0%	1	fish, deepwater ports
`land_use_agricultural_land_text`	land_use_agricultural_land_text	string	0%	1	8.7% (2023 est.)
`land_use_agricultural_land_arable_land_text`	land_use_agricultural_land_arable_land_text	string	0%	1	arable land: 8.7% (2023 est.)
`land_use_agricultural_land_arable_land_numeric`	land_use_agricultural_land_arable_land_numeric	float	0%	1	8.7
`land_use_agricultural_land_permanent_crops_text`	land_use_agricultural_land_permanent_crops_text	string	0%	1	permanent crops: 0% (2022 est.)
`land_use_agricultural_land_permanent_crops_numeric`	land_use_agricultural_land_permanent_crops_numeric	float	0%	1	0.0
`land_use_agricultural_land_permanent_pasture_text`	land_use_agricultural_land_permanent_pasture_text	string	0%	1	permanent pasture: 0% (2022 est.)
`land_use_agricultural_land_permanent_pasture_numeric`	land_use_agricultural_land_permanent_pasture_numeric	float	0%	1	0.0
`land_use_forest_text`	land_use_forest_text	string	0%	1	5% (2023 est.)
`land_use_other_text`	land_use_other_text	string	0%	1	86.3% (2023 est.)
+7 more extension fields — download the CSV/Parquet to see them all.

SPM OpenFactBook - Government — 1 rows, 72 columns

Loading data…

Field details — 72 fields (type, nulls, unique, samples)

Standards-Aligned Fields (2)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`country_code`	Country code	string	SEL	0%	1	SPM
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`country_name_conventional_long_form_text`	country_name_conventional_long_form_text	string	0%	1	Territorial Collectivity of Saint Pierre and Miquelon
`country_name_conventional_short_form_text`	country_name_conventional_short_form_text	string	0%	1	Saint Pierre and Miquelon
`country_name_local_long_form_text`	country_name_local_long_form_text	string	0%	1	Département de Saint-Pierre et Miquelon
`country_name_local_short_form_text`	country_name_local_short_form_text	string	0%	1	Saint-Pierre et Miquelon
`country_name_etymology_text`	country_name_etymology_text	string	0%	1	Saint-Pierre and Miquelon is reputed to be named after...
`government_type_text`	government_type_text	string	0%	1	parliamentary democracy (Territorial Council); overseas...
`dependency_status_text`	dependency_status_text	string	0%	1	overseas collectivity of France
`capital_name_text`	capital_name_text	string	0%	1	Saint-Pierre
`capital_geographic_coordinates_text`	capital_geographic_coordinates_text	string	0%	1	46 46 N, 56 11 W
`capital_geographic_coordinates_numeric`	capital_geographic_coordinates_numeric	float	0%	1	46.0
`capital_time_difference_text`	capital_time_difference_text	string	0%	1	UTC-3 (2 hours ahead of Washington, DC, during Standard Time)
`capital_time_difference_numeric`	capital_time_difference_numeric	float	0%	1	-3.0
`capital_daylight_saving_time_text`	capital_daylight_saving_time_text	string	0%	1	+1hr, begins second Sunday in March; ends first Sunday...
`capital_daylight_saving_time_numeric`	capital_daylight_saving_time_numeric	float	0%	1	1.0
`capital_etymology_text`	capital_etymology_text	string	0%	1	may be named after Saint Peter, the patron saint of...
`administrative_divisions_text`	administrative_divisions_text	string	0%	1	no first-order administrative divisions as defined by...
`administrative_divisions_numeric`	administrative_divisions_numeric	float	0%	1	2.0
`legal_system_text`	legal_system_text	string	0%	1	French civil law
`constitution_history_text`	constitution_history_text	string	0%	1	4 October 1958 (French Constitution)
`constitution_history_numeric`	constitution_history_numeric	float	0%	1	4.0
`constitution_amendment_process_text`	constitution_amendment_process_text	string	0%	1	amendment procedures of France's constitution apply
`citizenship_text`	citizenship_text	string	0%	1	see France
`suffrage_text`	suffrage_text	string	0%	1	18 years of age; universal
`suffrage_numeric`	suffrage_numeric	float	0%	1	18.0
`executive_branch_chief_of_state_text`	executive_branch_chief_of_state_text	string	0%	1	President Emmanuel MACRON (since 14 May 2017);...
`executive_branch_chief_of_state_numeric`	executive_branch_chief_of_state_numeric	float	0%	1	14.0
`executive_branch_head_of_government_text`	executive_branch_head_of_government_text	string	0%	1	President of Territorial Council Marc DIDIO (since 12...
`executive_branch_head_of_government_numeric`	executive_branch_head_of_government_numeric	float	0%	1	12.0
`executive_branch_cabinet_text`	executive_branch_cabinet_text	string	0%	1	Le Cabinet du Préfet
`executive_branch_election_appointment_process_text`	executive_branch_election_appointment_process_text	string	0%	1	French president directly elected by absolute-majority...
+40 more extension fields — download the CSV/Parquet to see them all.

SPM OpenFactBook - Introduction — 1 rows, 7 columns

Loading data…

Field details — 7 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`background_text`	background_text	string	0%	1	First settled by the French in the early 17th century,...
`background_numeric`	background_numeric	float	0%	1	17.0
`source_section`	source_section	string	0%	1	Introduction
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

SPM OpenFactBook - Languages — 1 rows, 7 columns

Loading data…

Field details — 7 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`languages_languages_text`	Languages (text)	string	0%	1	French (official)
`languages_major_language_sample_s_text`	languages_major_language_sample_s_text	string	0%	1	The World Factbook, une source indispensable...
`source_section`	source_section	string	0%	1	People and Society:languages
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

SPM OpenFactBook - Military And Security — 1 rows, 6 columns

Loading data…

Field details — 6 fields (type, nulls, unique, samples)

Standards-Aligned Fields (3)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`military_note_text`	military_note_text	string	0%	1	defense is the responsibility of France
`source_section`	source_section	string	0%	1	Military and Security
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

SPM OpenFactBook - People And Society — 1 rows, 78 columns

Loading data…

Field details — 78 fields (type, nulls, unique, samples)

Standards-Aligned Fields (25)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`population_total_numeric`	Population count	float	SEL	0%	1	5070.0
`population_male_numeric`	Population male	float	SEL	0%	1	2442.0
`population_female_numeric`	Population female	float	SEL	0%	1	2628.0
`age_structure_0_14_years_numeric`	Population 0 14 percent	float	SEL	0%	1	13.1
`age_structure_15_64_years_numeric`	Population 15 64 percent	float	SEL	0%	1	61.6
`age_structure_65_years_and_over_numeric`	Population 65 plus percent	float	SEL	0%	1	25.3
`dependency_ratios_total_dependency_ratio_numeric`	Total dependency ratio	float	SEL	0%	1	63.3
`dependency_ratios_youth_dependency_ratio_numeric`	Youth dependency ratio	float	SEL	0%	1	21.0
`dependency_ratios_elderly_dependency_ratio_numeric`	Elderly dependency ratio	float	SEL	0%	1	42.3
`median_age_total_numeric`	Median age	float	SEL	0%	1	51.8
`population_growth_rate_numeric`	Population growth rate percent	float	SEL	0%	1	-1.24
`birth_rate_numeric`	Birth rate per 1000	float	SEL	0%	1	6.31
`death_rate_numeric`	Death rate per 1000	float	SEL	0%	1	11.83
`net_migration_rate_numeric`	Net migration per 1000	float	SEL	0%	1	-6.9
`urbanization_urban_population_numeric`	Urban population percent	float	SEL	0%	1	90.1
`urbanization_rate_of_urbanization_numeric`	Urban growth rate percent	float	SEL	0%	1	0.75
`sex_ratio_at_birth_numeric`	Sex ratio at birth	float	SEL	0%	1	1.06
`sex_ratio_total_population_numeric`	Sex ratio overall	float	SEL	0%	1	0.93
`infant_mortality_rate_total_numeric`	Infant mortality per 1000	float	SEL	0%	1	7.6
`life_expectancy_at_birth_total_population_numeric`	Life expectancy	float	SEL	0%	1	81.8
`total_fertility_rate_numeric`	Fertility rate	float	SEL	0%	1	1.6
`gross_reproduction_rate_numeric`	Gross reproduction rate	float	SEL	0%	1	0.79
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`population_total_text`	population_total_text	string	0%	1	5,070 (2025 est.)
`population_male_text`	population_male_text	string	0%	1	2,442
`population_female_text`	population_female_text	string	0%	1	2,628
`age_structure_0_14_years_text`	age_structure_0_14_years_text	string	0%	1	13.1% (male 346/female 328)
`age_structure_15_64_years_text`	age_structure_15_64_years_text	string	0%	1	61.6% (male 1,559/female 1,600)
`age_structure_65_years_and_over_text`	age_structure_65_years_and_over_text	string	0%	1	25.3% (2024 est.) (male 571/female 728)
`dependency_ratios_total_dependency_ratio_text`	dependency_ratios_total_dependency_ratio_text	string	0%	1	63.3 (2025 est.)
`dependency_ratios_youth_dependency_ratio_text`	dependency_ratios_youth_dependency_ratio_text	string	0%	1	21 (2025 est.)
`dependency_ratios_elderly_dependency_ratio_text`	dependency_ratios_elderly_dependency_ratio_text	string	0%	1	42.3 (2025 est.)
`dependency_ratios_potential_support_ratio_text`	dependency_ratios_potential_support_ratio_text	string	0%	1	2.4 (2025 est.)
`dependency_ratios_potential_support_ratio_numeric`	dependency_ratios_potential_support_ratio_numeric	float	0%	1	2.4
`median_age_total_text`	median_age_total_text	string	0%	1	51.8 years (2025 est.)
`median_age_male_text`	median_age_male_text	string	0%	1	50.5 years
`median_age_male_numeric`	median_age_male_numeric	float	0%	1	50.5
`median_age_female_text`	median_age_female_text	string	0%	1	51.9 years
`median_age_female_numeric`	median_age_female_numeric	float	0%	1	51.9
`population_growth_rate_text`	population_growth_rate_text	string	0%	1	-1.24% (2025 est.)
`birth_rate_text`	birth_rate_text	string	0%	1	6.31 births/1,000 population (2025 est.)
`death_rate_text`	death_rate_text	string	0%	1	11.83 deaths/1,000 population (2025 est.)
`net_migration_rate_text`	net_migration_rate_text	string	0%	1	-6.9 migrant(s)/1,000 population (2025 est.)
`population_distribution_text`	population_distribution_text	string	0%	1	most of the population is found on Saint Pierre Island;...
`urbanization_urban_population_text`	urbanization_urban_population_text	string	0%	1	90.1% of total population (2023)
`urbanization_rate_of_urbanization_text`	urbanization_rate_of_urbanization_text	string	0%	1	0.75% annual rate of change (2020-25 est.)
`major_urban_areas_population_text`	major_urban_areas_population_text	string	0%	1	6,000 SAINT-PIERRE (capital) (2018)
`major_urban_areas_population_numeric`	major_urban_areas_population_numeric	float	0%	1	6000.0
`sex_ratio_at_birth_text`	sex_ratio_at_birth_text	string	0%	1	1.06 male(s)/female
`sex_ratio_0_14_years_text`	sex_ratio_0_14_years_text	string	0%	1	1.05 male(s)/female
`sex_ratio_0_14_years_numeric`	sex_ratio_0_14_years_numeric	float	0%	1	1.05
`sex_ratio_15_64_years_text`	sex_ratio_15_64_years_text	string	0%	1	0.97 male(s)/female
`sex_ratio_15_64_years_numeric`	sex_ratio_15_64_years_numeric	float	0%	1	0.97
+23 more extension fields — download the CSV/Parquet to see them all.

SPM OpenFactBook - Religions — 1 rows, 10 columns

Loading data…

Field details — 10 fields (type, nulls, unique, samples)

Standards-Aligned Fields (4)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national
`composition_religion_other_pct_synth`	other	numeric	CCL	0%	-	1.0

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

Field Name	Label	Type	Nulls	Unique	Samples
`religions_text`	religions_text	string	0%	1	Roman Catholic 99%, other 1%
`religions_numeric`	religions_numeric	float	0%	1	99.0
`source_section`	source_section	string	0%	1	People and Society:religions
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

Pending (2) — awaiting mapping

Field Name	Label	Type	Nulls	Unique	Samples
`composition_religion_roman_catholic_pct_synth`	Roman Catholic	numeric	0%	-	99.0
`composition_ethnicity_basques_and_bretons_pct_synth`	Basques and Bretons	numeric	0%	-	-

SPM OpenFactBook - Transportation — 1 rows, 22 columns

Loading data…

Field details — 22 fields (type, nulls, unique, samples)

Standards-Aligned Fields (4)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`airports_numeric`	Airports count	float	SEL	0%	1	2.0
`country_code`	Country code	string	SEL	0%	1	SPM
`country_name`	Country name	string	SEL	0%	1	Saint Pierre and Miquelon
`admin_level`	Admin level	string	SEL	0%	1	national

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

Field Name	Label	Type	Nulls	Unique	Samples
`airports_text`	airports_text	string	0%	1	2 (2025)
`ports_total_ports_text`	ports_total_ports_text	string	0%	1	2 (2024)
`ports_total_ports_numeric`	ports_total_ports_numeric	float	0%	1	2.0
`ports_large_text`	ports_large_text	float	0%	1	0
`ports_large_numeric`	ports_large_numeric	float	0%	1	0.0
`ports_medium_text`	ports_medium_text	float	0%	1	0
`ports_medium_numeric`	ports_medium_numeric	float	0%	1	0.0
`ports_small_text`	ports_small_text	float	0%	1	1
`ports_small_numeric`	ports_small_numeric	float	0%	1	1.0
`ports_very_small_text`	ports_very_small_text	float	0%	1	0
`ports_very_small_numeric`	ports_very_small_numeric	float	0%	1	0.0
`ports_size_unknown_text`	ports_size_unknown_text	float	0%	1	1
`ports_size_unknown_numeric`	ports_size_unknown_numeric	float	0%	1	1.0
`ports_ports_with_oil_terminals_text`	Ports with oil terminals (text)	float	0%	1	1
`ports_ports_with_oil_terminals_numeric`	Ports with oil terminals (numeric)	float	0%	1	1.0
`ports_key_ports_text`	ports_key_ports_text	string	0%	1	Miquelon, St. Pierre
`source_section`	source_section	string	0%	1	Transportation
`source_profile_path`	source_profile_path	string	0%	1	north-america/sb.json

SPM NGA GEOnet Names Server (GNS) SPM-NGA_GNS Language

3 rows · 2 table(s) NGA GEOnet Names Server (GNS) 0 1 2 3 4 SEL 12 CCL 20 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 2 table(s)

SPM Nga Gns - Language — 2 rows, 9 columns

Loading data…

Field details — 9 fields (type, nulls, unique, samples)

Standards-Aligned Fields (9)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`country_code`	country_code	string	SEL	0%	1	SPM, SPM
`gns_language_code`	gns_language_code	string	CCL	0%	2	fra, eng
`gns_language_name`	gns_language_name	string	CCL	0%	2	French, English
`gns_toponym_count`	gns_toponym_count	integer	CCL	0%	2	18, 2
`gns_toponym_share_pct`	gns_toponym_share_pct	float	CCL	0%	2	90.0, 10.0
`gns_non_roman_toponym_count`	gns_non_roman_toponym_count	integer	CCL	0%	1	0, 0
`gns_dominant_script_code`	gns_dominant_script_code	string	CCL	0%	1	,
`gns_dominant_script_name`	gns_dominant_script_name	string	CCL	0%	1	,
`gns_script_count`	gns_script_count	integer	CCL	0%	1	0, 0

SPM Nga Gns - Summary — 1 rows, 27 columns

Loading data…

Field details — 27 fields (type, nulls, unique, samples)

Standards-Aligned Fields (7)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`country_code`	country_code	string	SEL	0%	1	SPM
`admin_level`	admin_level	integer	SEL	0%	1	0
`gns_country_name`	gns_country_name	string	SEL	0%	1	Saint Pierre and Miquelon
`gns_language_count`	gns_language_count	integer	CCL	0%	1	2
`gns_script_count`	gns_script_count	integer	CCL	0%	1	0
`gns_endonym_share_pct`	gns_endonym_share_pct	float	CCL	0%	1	99.6479
`gns_non_roman_name_count`	gns_non_roman_name_count	integer	CCL	0%	1	0

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

Field Name	Label	Type	Nulls	Unique	Samples
`gns_name_count`	gns_name_count	integer	0%	1	568
`gns_feature_count`	gns_feature_count	integer	0%	1	517
`gns_endonym_count`	gns_endonym_count	integer	0%	1	566
`gns_exonym_count`	gns_exonym_count	integer	0%	1	2
`gns_source_build_date`	gns_source_build_date	string	0%	1	Wed, 05 Aug 2026
`gns_source_change_date`	gns_source_change_date	string	0%	1	2026-08-05
`gns_name_count_hypsographic`	gns_name_count_hypsographic	integer	0%	1	220
`gns_feature_count_hypsographic`	gns_feature_count_hypsographic	integer	0%	1	199
`gns_name_count_administrative_regions`	gns_name_count_administrative_regions	integer	0%	1	13
`gns_feature_count_administrative_regions`	gns_feature_count_administrative_regions	integer	0%	1	3
`gns_name_count_populated_places`	gns_name_count_populated_places	integer	0%	1	5
`gns_feature_count_populated_places`	gns_feature_count_populated_places	integer	0%	1	5
`gns_name_count_hydrographic`	gns_name_count_hydrographic	integer	0%	1	280
`gns_feature_count_hydrographic`	gns_feature_count_hydrographic	integer	0%	1	263
`gns_name_count_vegetation`	gns_name_count_vegetation	integer	0%	1	13
`gns_feature_count_vegetation`	gns_feature_count_vegetation	integer	0%	1	13
`gns_name_count_spot_features`	gns_name_count_spot_features	integer	0%	1	28
`gns_feature_count_spot_features`	gns_feature_count_spot_features	integer	0%	1	25
`gns_name_count_areas_localities`	gns_name_count_areas_localities	integer	0%	1	9
`gns_feature_count_areas_localities`	gns_feature_count_areas_localities	integer	0%	1	9

SPM Glottolog Language Catalog SPM-GLOTTOLOG Language

1 rows · 1 table(s) Glottolog Language Catalog 0 1 2 3 12 CCL 4 ext ▶

or use the per-admin-level buttons below. Free downloads return a 10-row sample. Contact us for the full pack.

0 Admin 0 — 1 table(s)

SPM Glottolog - Languages — 1 rows, 16 columns

Loading data…

Field details — 16 fields (type, nulls, unique, samples)

Standards-Aligned Fields (12)

Field Name	Label	Type	Schema	Nulls	Unique	Samples
`glottocode`	Glottocode	string	CCL	0%	1	stan1290
`name`	Name	string	CCL	0%	1	French
`iso639_3`	Iso639 3	string	CCL	0%	1	fra
`level`	Level	string	CCL	0%	1	language
`family_name`	Family name	string	CCL	100%	-	-
`family_glottocode`	Family glottocode	string	CCL	0%	1	indo1319
`parent_name`	Parent name	string	CCL	100%	-	-
`parent_glottocode`	Parent glottocode	string	CCL	0%	1	glob1239
`endangerment_status`	Endangerment status	string	CCL	100%	-	-
`child_family_count`	Child family count	integer	CCL	0%	1	0
`child_language_count`	Child language count	integer	CCL	0%	1	0
`child_dialect_count`	Child dialect count	integer	CCL	0%	1	23

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

Field Name	Label	Type	Nulls	Unique	Samples
`latitude`	latitude	float	0%	1	48.0
`longitude`	longitude	float	0%	1	2.0
`country_codes`	country_codes	string	0%	1	['AD', 'BE', 'CA', 'CH', 'FR', 'GF', 'IT', 'LU', 'MC',...
`classification`	classification	string	0%	1	[]

Language	Place names	Share	Script
French (fra)	18	90.0%	—
English (eng)	2	10.0%	—

Source	Type	Access
Glottolog Language Catalog	academic	bulk_download
NGA GEOnet Names Server (GNS)	official_government	bulk_download
OpenFactBook	community_compilation	bulk_download

HERA · Human Entity Reference Atlas by Masego Inc

Saint Pierre and Miquelon

Build a download