About this Dataset

Foreign, Commonwealth And Development Office: Posts Abroad

List of Foreign, Commonwealth & Development Office (FCDO) embassies, high commissions, delegations, missions and consulates by country.
Publisher name: Foreign, Commonwealth and Development Office (FCDO)
Last updated: 2025-05-02T04:00:06Z

Tables

Commonwealth And Development Office Posts Overseas: March 2021

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.commonwealth_and_development_office_posts_overseas_march_2021

15.27 kB
283 rows
7 columns

CREATE TABLE commonwealth_and_development_office_posts_overseas_march_2021 (
  "region" VARCHAR,
  "country_territory" VARCHAR,
  "location_city" VARCHAR  -- Location (City),
  "type_of_post" VARCHAR,
  "y" DOUBLE,
  "x" DOUBLE,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

Foreign, Commonwealth And Development Office Posts Overseas: September 2021

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.foreign_commonwealth_and_development_office_posts_over_804f950c

15.35 kB
283 rows
7 columns

CREATE TABLE foreign_commonwealth_and_development_office_posts_over_804f950c (
  "region" VARCHAR,
  "country_territory" VARCHAR,
  "post_location_name" VARCHAR  -- Post Location (name),
  "type_of_post" VARCHAR,
  "y" DOUBLE,
  "x" DOUBLE,
  "status" VARCHAR
);

Foreign, Commonwealth & Development Office Posts Overseas: June 2022

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.foreign_commonwealth_development_office_posts_overseas_2459ab8a

15.36 kB
283 rows
7 columns

CREATE TABLE foreign_commonwealth_development_office_posts_overseas_2459ab8a (
  "region" VARCHAR,
  "country_territory" VARCHAR,
  "post_location_name" VARCHAR  -- Post Location (name),
  "type_of_post" VARCHAR,
  "y" DOUBLE,
  "x" DOUBLE,
  "status" VARCHAR
);

Foreign, Commonwealth & Development Office Posts Overseas: April 2024

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.foreign_commonwealth_development_office_posts_overseas_4b05506a

15.81 kB
283 rows
7 columns

CREATE TABLE foreign_commonwealth_development_office_posts_overseas_4b05506a (
  "general_geographic_grouping" VARCHAR,
  "country_territory" VARCHAR,
  "post_location_name" VARCHAR  -- Post Location (name),
  "type_of_post" VARCHAR,
  "y_lat_co_ords" DOUBLE  -- Y (lat) Co-ords,
  "x_long_co_ords" DOUBLE  -- X (long) Co-ords,
  "status" VARCHAR
);

Foreign, Commonwealth & Development Office Posts Overseas: July 2021

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.foreign_commonwealth_development_office_posts_overseas_5c8565cb

15.31 kB
283 rows
7 columns

CREATE TABLE foreign_commonwealth_development_office_posts_overseas_5c8565cb (
  "region" VARCHAR,
  "country_territory" VARCHAR,
  "post_location_name" VARCHAR  -- Post Location (name),
  "type_of_post" VARCHAR,
  "y" DOUBLE,
  "x" DOUBLE,
  "status" VARCHAR
);

Foreign, Commonwealth & Development Office Posts Overseas: April 2023

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.foreign_commonwealth_development_office_posts_overseas_788ce86b

15.39 kB
282 rows
7 columns

CREATE TABLE foreign_commonwealth_development_office_posts_overseas_788ce86b (
  "region" VARCHAR,
  "country_territory" VARCHAR,
  "post_location_name" VARCHAR  -- Post Location (name),
  "type_of_post" VARCHAR,
  "y" DOUBLE,
  "x" DOUBLE,
  "status" VARCHAR
);

Foreign, Commonwealth & Development Office Posts Overseas: February 2023

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.foreign_commonwealth_development_office_posts_overseas_92b7c380

15.33 kB
281 rows
7 columns

CREATE TABLE foreign_commonwealth_development_office_posts_overseas_92b7c380 (
  "region" VARCHAR,
  "country_territory" VARCHAR,
  "post_location_name" VARCHAR  -- Post Location (name),
  "type_of_post" VARCHAR,
  "y" DOUBLE,
  "x" DOUBLE,
  "status" VARCHAR
);

Foreign, Commonwealth & Development Office Posts Overseas: September 2022

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.foreign_commonwealth_development_office_posts_overseas_936ea182

15.36 kB
283 rows
7 columns

CREATE TABLE foreign_commonwealth_development_office_posts_overseas_936ea182 (
  "region" VARCHAR,
  "country_territory" VARCHAR,
  "post_location_name" VARCHAR  -- Post Location (name),
  "type_of_post" VARCHAR,
  "y" DOUBLE,
  "x" DOUBLE,
  "status" VARCHAR
);

Foreign, Commonwealth & Development Office Posts Overseas: April 2025

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.foreign_commonwealth_development_office_posts_overseas_de6e70b2

15.75 kB
282 rows
7 columns

CREATE TABLE foreign_commonwealth_development_office_posts_overseas_de6e70b2 (
  "general_geographic_grouping" VARCHAR,
  "country_territory" VARCHAR,
  "post_location_name" VARCHAR  -- Post Location (name),
  "type_of_post" VARCHAR,
  "y_lat_co_ords" DOUBLE  -- Y (lat) Co-ords,
  "x_long_co_ords" DOUBLE  -- X (long) Co-ords,
  "status" VARCHAR
);

Foreign, Commonwealth & Development Office Posts Overseas: May 2021

@ukgov.foreign_commonwealth_and_development_office_posts_overseas.foreign_commonwealth_development_office_posts_overseas_may_2021

15.57 kB
284 rows
7 columns

CREATE TABLE foreign_commonwealth_development_office_posts_overseas_may_2021 (
  "region" VARCHAR,
  "country_territory_hosting_uk_representation" VARCHAR  -- Country/Territory (hosting UK Representation),
  "post_location_name" VARCHAR  -- Post Location (name),
  "type_of_post" VARCHAR,
  "y" DOUBLE,
  "x" DOUBLE,
  "status" VARCHAR
);