Baselight
Sign In

Foreign And Commonwealth Office (FCO) Consular Management Information Data

Foreign and Commonwealth Office

@ukgov.foreign_office_consular_data

Loading...
Loading...

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
  • 69.57 kB
  • 309 rows
  • 82 columns
Loading... 
CREATE TABLE foreign_and_commonwealth_office_fco_consular_managemen_52f0c1d9 (
  "apr_17" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_missing" BIGINT  -- Arrest/Detention > Missing,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_none" BIGINT  -- Arrest/Detention > None,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_missing" BIGINT  -- Child Welfare > Missing,
  "child_welfare_none" BIGINT  -- Child Welfare > None,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_missing" BIGINT  -- Death > Missing,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_none" BIGINT  -- Death > None,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_missing" BIGINT  -- Death In Custody > Missing,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "diplomatic_claim" BIGINT,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT  -- Forced Marriage - Reluctant Sponsor,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" BIGINT  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_missing" BIGINT  -- Hospitalisation > Missing,
  "hospitalisation_none" BIGINT  -- Hospitalisation > None,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "property_fraud" VARCHAR  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_missing" BIGINT  -- Property > Missing,
  "property_none" BIGINT  -- Property > None,
  "property_other" VARCHAR  -- Property > Other,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_missing" BIGINT  -- Victim Of Crime > Missing,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_none" BIGINT  -- Victim Of Crime > None,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "welfare" VARCHAR,
  "whereabouts" VARCHAR,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_missing" BIGINT  -- Accident/Emergency > Missing,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_none" BIGINT  -- Accident/Emergency > None,
  "accident_emergency_not_set" BIGINT  -- Accident/Emergency > Not Set,
  "accident_emergency_road_traffic_accident" BIGINT  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "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
  • 62.14 kB
  • 309 rows
  • 72 columns
Loading... 
CREATE TABLE october_2020_consular_management_information (
  "oct_18" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" BIGINT  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" BIGINT,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "diplomatic_claim" VARCHAR,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT  -- Forced Marriage - Reluctant Sponsor,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "property_fraud" VARCHAR  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" BIGINT  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT,
  "welfare" VARCHAR,
  "whereabouts" BIGINT,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" VARCHAR  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" BIGINT  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency - Unknown,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);

Share link

Anyone who has the link will be able to view this.