Foreign & Commonwealth Office List Of Posts Overseas
Foreign and Commonwealth Office
@ukgov.uk_foreign_post_locations
Foreign and Commonwealth Office
@ukgov.uk_foreign_post_locations
CREATE TABLE fco_list_of_overseas_posts (
"region" VARCHAR,
"country_territory" VARCHAR,
"location_city" VARCHAR,
"type_of_post" VARCHAR,
"y" DOUBLE,
"x" DOUBLE,
"unnamed_6" VARCHAR
);
CREATE TABLE fco_list_of_overseas_posts_may_2019 (
"region" VARCHAR,
"country_territory" VARCHAR,
"location_city" VARCHAR,
"type_of_post" VARCHAR,
"y" DOUBLE,
"x" DOUBLE,
"unnamed_6" VARCHAR
);
CREATE TABLE fco_list_of_overseas_posts_august_2019 (
"region" VARCHAR,
"country_territory" VARCHAR,
"location_city" VARCHAR,
"type_of_post" VARCHAR,
"y" DOUBLE,
"x" DOUBLE,
"unnamed_6" VARCHAR
);
CREATE TABLE foreign_commonwealth_office_list_of_posts_overseas (
"region" VARCHAR,
"country_territory" VARCHAR,
"location_city" VARCHAR,
"type_of_post" VARCHAR,
"y" DOUBLE,
"x" DOUBLE
);
CREATE TABLE fco_list_of_overseas_posts_october_2019 (
"region" VARCHAR,
"country_territory" VARCHAR,
"location_city" VARCHAR,
"type_of_post" VARCHAR,
"y" DOUBLE,
"x" DOUBLE,
"unnamed_6" VARCHAR
);
CREATE TABLE fco_list_of_overseas_posts_march_2019 (
"region" VARCHAR,
"country_territory" VARCHAR,
"location_city" VARCHAR,
"type_of_post" VARCHAR,
"y" DOUBLE,
"x" DOUBLE,
"unnamed_6" VARCHAR
);
Anyone who has the link will be able to view this.