Name: Foreign, Commonwealth And Development Office Geographical Names Index
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Foreign, Commonwealth And Development Office Geographical Names Index

These are the British English-language names and descriptive terms for sovereign countries, UK Crown Dependencies and UK Overseas Territories, as well as their citizens. ‘Sovereign’ means that they are independent states, recognised under international law. The Foreign, Commonwealth & Development Office (FCDO) approved these names. The FCDO leads on geographical names for the UK government, working closely with the Permanent Committee on Geographical Names. All UK government departments and other public bodies must use the approved country and territory names in these datasets. Using these names ensures consistency and clarity across public and internal communications, guidance and services. You can also view the Welsh language version of the geographical names index on GOV.WALES: international place-names.
Publisher name: Foreign, Commonwealth and Development Office (FCDO)
Last updated: 2024-09-14T06:47:11Z

Tables

FCDO Country Names

@ukgov.foreign_commonwealth_and_development_office_geographic_a3d378b7.fcdo_country_names

11.66 kB
195 rows
4 columns

CREATE TABLE fcdo_country_names (
  "country_code" VARCHAR,
  "name" VARCHAR,
  "official_name" VARCHAR,
  "citizen_names" VARCHAR
);

UK Crown Dependencies

@ukgov.foreign_commonwealth_and_development_office_geographic_a3d378b7.uk_crown_dependencies

4.06 kB
3 rows
4 columns

CREATE TABLE uk_crown_dependencies (
  "country_territory" VARCHAR,
  "name" VARCHAR,
  "official_name" VARCHAR,
  "citizen_names" VARCHAR
);

UK Overseas Territory Names

@ukgov.foreign_commonwealth_and_development_office_geographic_a3d378b7.uk_overseas_territory_names

4.67 kB
15 rows
4 columns

CREATE TABLE uk_overseas_territory_names (
  "country_territory" VARCHAR,
  "name" VARCHAR,
  "official_name" VARCHAR,
  "citizen_names" VARCHAR
);