About this Dataset

Foreign And Commonwealth Office (FCO) Consular Management Information Data

This data is now published by The Foreign, Commonwealth and Development Office. These data gives information about the Foreign Office Consular data on Consular services provided to British nationals worldwide this includes numbers of incidents handled by UK consulates overseas, including hospitalisations, deaths, detentions, with geographical location. FCO merged with the Department for International Development on 1 September 2020. This data continues to be published on the Foreign, Commonwealth and Development Offices publication page.
Publisher name: Foreign and Commonwealth Office
Last updated: 2024-09-14T11:58:19Z

Tables

Foreign And Commonwealth Office (FCO) Consular Management Information Data

@ukgov.foreign_office_consular_data.foreign_and_commonwealth_office_fco_consular_managemen_52f0c1d9

67.94 KB
309 rows
82 columns


CREATE TABLE foreign_and_commonwealth_office_fco_consular_managemen_52f0c1d9 (
  "apr_17" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" VARCHAR,
  "arrest_detention_child_sex" VARCHAR,
  "arrest_detention_drugs" VARCHAR,
  "arrest_detention_fraud" VARCHAR,
  "arrest_detention_general" VARCHAR,
  "arrest_detention_immigration" VARCHAR,
  "arrest_detention_missing" BIGINT,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_none" BIGINT,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" VARCHAR,
  "arrest_detention_theft" VARCHAR,
  "child_welfare_child_abandonment" VARCHAR,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_missing" BIGINT,
  "child_welfare_none" BIGINT,
  "child_welfare_parental_child_abduction" VARCHAR,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_missing" BIGINT,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_none" BIGINT,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_missing" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim" BIGINT,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" BIGINT,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_missing" BIGINT,
  "hospitalisation_none" BIGINT,
  "hospitalisation_physical_health" VARCHAR,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" BIGINT,
  "property_missing" BIGINT,
  "property_none" BIGINT,
  "property_other" VARCHAR,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "victim_of_crime_assault" VARCHAR,
  "victim_of_crime_domestic_abuse" VARCHAR,
  "victim_of_crime_held_against_will" VARCHAR,
  "victim_of_crime_missing" BIGINT,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT,
  "victim_of_crime_none" BIGINT,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "welfare" VARCHAR,
  "whereabouts" VARCHAR,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_missing" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_none" BIGINT,
  "accident_emergency_not_set" BIGINT,
  "accident_emergency_road_traffic_accident" BIGINT,
  "accident_emergency_terrorist_incident" BIGINT,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);

October 2020 Consular Management Information

@ukgov.foreign_office_consular_data.october_2020_consular_management_information

60.69 KB
309 rows
72 columns


CREATE TABLE october_2020_consular_management_information (
  "oct_18" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" VARCHAR,
  "arrest_detention_child_sex" VARCHAR,
  "arrest_detention_drugs" VARCHAR,
  "arrest_detention_fraud" VARCHAR,
  "arrest_detention_general" VARCHAR,
  "arrest_detention_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" BIGINT,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" VARCHAR,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" VARCHAR,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_unknown" BIGINT,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim" VARCHAR,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" BIGINT,
  "property_other" BIGINT,
  "property_unknown" BIGINT,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "victim_of_crime_assault" VARCHAR,
  "victim_of_crime_domestic_abuse" VARCHAR,
  "victim_of_crime_held_against_will" VARCHAR,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "welfare" VARCHAR,
  "whereabouts" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" VARCHAR,
  "accident_emergency_road_traffic_accident" BIGINT,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);