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

FCO Consular Management Information April 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_april_2019
  • 71.3 KB
  • 173 rows
  • 88 columns
Loading... 

CREATE TABLE fco_consular_management_information_april_2019 (
  "apr_19" 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" VARCHAR,
  "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_none" VARCHAR,
  "commercial_dispute_missing" VARCHAR,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" BIGINT,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" VARCHAR,
  "financial_transactions_request_for_financial_assistance" BIGINT,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information April 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_april_2020
  • 67.18 KB
  • 250 rows
  • 83 columns
Loading... 

CREATE TABLE fco_consular_management_information_april_2020 (
  "apr_20" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" DOUBLE,
  "arrest_detention_child_sex" DOUBLE,
  "arrest_detention_drugs" VARCHAR,
  "arrest_detention_fraud" VARCHAR,
  "arrest_detention_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" DOUBLE,
  "arrest_detention_other" VARCHAR,
  "arrest_detention_sex_not_child" DOUBLE,
  "arrest_detention_terrorism" DOUBLE,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" DOUBLE,
  "child_welfare_child_abandonment" DOUBLE,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_child_in_care" VARCHAR,
  "child_welfare_child_working_licence" DOUBLE,
  "child_welfare_family_abandonment" DOUBLE,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" DOUBLE,
  "child_welfare_unknown" DOUBLE,
  "commercial_dispute_none" DOUBLE,
  "commercial_dispute_missing" DOUBLE,
  "coroner_request_none" DOUBLE,
  "death_accidental" VARCHAR,
  "death_drowning" DOUBLE,
  "death_execution" DOUBLE,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" DOUBLE,
  "death_in_custody_sudden_death" DOUBLE,
  "death_in_custody_suicide" DOUBLE,
  "death_in_custody_unknown" VARCHAR,
  "death_in_custody_natural_death" VARCHAR,
  "diplomatic_claim_none" DOUBLE,
  "female_genital_mutilation_none" DOUBLE,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" VARCHAR,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" DOUBLE,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" DOUBLE,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" DOUBLE,
  "property_government" DOUBLE,
  "property_other" DOUBLE,
  "property_unknown" DOUBLE,
  "travel_ban_none" VARCHAR,
  "travel_advice_unknown" DOUBLE,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_cancel_passport" DOUBLE,
  "travel_documents_unknown" DOUBLE,
  "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" DOUBLE,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" DOUBLE,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" DOUBLE,
  "whereabouts_none" DOUBLE,
  "crisis_none" DOUBLE,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information August 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_august_2019
  • 70.73 KB
  • 173 rows
  • 87 columns
Loading... 

CREATE TABLE fco_consular_management_information_august_2019 (
  "aug_19" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" BIGINT,
  "arrest_detention_terrorism" VARCHAR,
  "arrest_detention_theft" BIGINT,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" VARCHAR,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" BIGINT,
  "child_welfare_unknown" VARCHAR,
  "commercial_dispute_none" BIGINT,
  "commercial_dispute_missing" VARCHAR,
  "coroner_request_none" VARCHAR,
  "death_accidental" VARCHAR,
  "death_drowning" BIGINT,
  "death_execution" VARCHAR,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" VARCHAR,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" VARCHAR,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" VARCHAR,
  "forced_marriage_none" BIGINT,
  "forced_marriage_reluctant_sponsor_none" VARCHAR,
  "hospitalisation_dementia" BIGINT,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" BIGINT,
  "hospitalisation_unknown" VARCHAR,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" BIGINT,
  "property_fraud" BIGINT,
  "property_government" VARCHAR,
  "property_other" BIGINT,
  "property_unknown" VARCHAR,
  "travel_ban_none" BIGINT,
  "travel_documents_cancel_passport" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" BIGINT,
  "travel_documents_unknown" VARCHAR,
  "victim_of_crime_assault" VARCHAR,
  "victim_of_crime_domestic_abuse" VARCHAR,
  "victim_of_crime_held_against_will" BIGINT,
  "victim_of_crime_modern_slavery_human_trafficking" VARCHAR,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" BIGINT,
  "victim_of_crime_unknown" VARCHAR,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" BIGINT,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" BIGINT,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" VARCHAR,
  "accident_emergency_natural_disaster" VARCHAR,
  "accident_emergency_road_traffic_accident" BIGINT,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" VARCHAR,
  "financial_transactions_undertaking_to_repay" BIGINT,
  "financial_transactions_payment" VARCHAR,
  "financial_transactions_request_for_financial_assistance" VARCHAR,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information August 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_august_2020
  • 67.3 KB
  • 250 rows
  • 83 columns
Loading... 

CREATE TABLE fco_consular_management_information_august_2020 (
  "aug_20" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_other" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" DOUBLE,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" DOUBLE,
  "child_welfare_child_abandonment" DOUBLE,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_child_in_care" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_family_abandonment" DOUBLE,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" DOUBLE,
  "child_welfare_unknown" DOUBLE,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" DOUBLE,
  "coroner_request_none" DOUBLE,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" DOUBLE,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" DOUBLE,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" VARCHAR,
  "death_in_custody_sudden_death" DOUBLE,
  "death_in_custody_suicide" DOUBLE,
  "death_in_custody_unknown" DOUBLE,
  "death_in_custody_natural_death" DOUBLE,
  "diplomatic_claim_none" DOUBLE,
  "female_genital_mutilation_none" DOUBLE,
  "forced_marriage_none" DOUBLE,
  "forced_marriage_reluctant_sponsor_none" DOUBLE,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" DOUBLE,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" DOUBLE,
  "property_government" DOUBLE,
  "property_other" DOUBLE,
  "property_unknown" DOUBLE,
  "travel_ban_none" VARCHAR,
  "travel_advice_unknown" DOUBLE,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_cancel_passport" DOUBLE,
  "travel_documents_unknown" DOUBLE,
  "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" DOUBLE,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" DOUBLE,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" DOUBLE,
  "whereabouts_none" DOUBLE,
  "crisis_none" DOUBLE,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information By Country January - December 2018

@ukgov.foreign_office_consular_data.fco_consular_management_information_by_country_january_6f41f4c8
  • 76.41 KB
  • 173 rows
  • 88 columns
Loading... 

CREATE TABLE fco_consular_management_information_by_country_january_6f41f4c8 (
  "n_2018" 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" VARCHAR,
  "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_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" VARCHAR,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" VARCHAR,
  "death_in_custody_suicide" VARCHAR,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim_none" VARCHAR,
  "female_genital_mutilation_none" VARCHAR,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" VARCHAR,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" VARCHAR,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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" VARCHAR,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" VARCHAR,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" VARCHAR,
  "accident_emergency_natural_disaster" VARCHAR,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" VARCHAR,
  "financial_transactions_request_for_financial_assistance" BIGINT,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information December 2018

@ukgov.foreign_office_consular_data.fco_consular_management_information_december_2018
  • 60.53 KB
  • 309 rows
  • 72 columns
Loading... 

CREATE TABLE fco_consular_management_information_december_2018 (
  "dec_18" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" BIGINT,
  "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" VARCHAR,
  "arrest_detention_murder_manslaughter" BIGINT,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "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" BIGINT,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT,
  "hospitalisation_dementia" BIGINT,
  "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" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);

FCO Consular Management Information December 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_december_2019
  • 69.59 KB
  • 173 rows
  • 86 columns
Loading... 

CREATE TABLE fco_consular_management_information_december_2019 (
  "dec_19" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "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" BIGINT,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" VARCHAR,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" BIGINT,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" BIGINT,
  "financial_transactions_request_for_financial_assistance" VARCHAR,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information February 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_february_2019
  • 71.32 KB
  • 173 rows
  • 88 columns
Loading... 

CREATE TABLE fco_consular_management_information_february_2019 (
  "feb_19" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" BIGINT,
  "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" VARCHAR,
  "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" VARCHAR,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" VARCHAR,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" BIGINT,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" VARCHAR,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" BIGINT,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" VARCHAR,
  "financial_transactions_request_for_financial_assistance" BIGINT,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information February 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_february_2020
  • 60.15 KB
  • 174 rows
  • 86 columns
Loading... 

CREATE TABLE fco_consular_management_information_february_2020 (
  "feb_20" VARCHAR,
  "n_2" VARCHAR,
  "n_3" VARCHAR,
  "n_4" VARCHAR,
  "n_5" VARCHAR,
  "n_6" VARCHAR,
  "n_7" VARCHAR,
  "n_8" VARCHAR,
  "n_9" VARCHAR,
  "n_10" VARCHAR,
  "n_11" VARCHAR,
  "n_12" VARCHAR,
  "n_13" VARCHAR,
  "n_14" VARCHAR,
  "n_15" VARCHAR,
  "n_16" VARCHAR,
  "n_17" VARCHAR,
  "n_18" VARCHAR,
  "n_19" VARCHAR,
  "n_20" VARCHAR,
  "n_45" VARCHAR,
  "n_46" VARCHAR,
  "n_47" VARCHAR,
  "n_48" VARCHAR,
  "n_49" VARCHAR,
  "n_50" VARCHAR,
  "n_51" VARCHAR,
  "n_52" VARCHAR,
  "n_53" VARCHAR,
  "n_54" VARCHAR,
  "n_55" VARCHAR,
  "n_56" VARCHAR,
  "n_57" VARCHAR,
  "n_58" VARCHAR,
  "n_59" VARCHAR,
  "n_60" VARCHAR,
  "n_61" VARCHAR,
  "n_62" VARCHAR,
  "n_63" VARCHAR,
  "n_64" VARCHAR,
  "n_65" VARCHAR,
  "n_66" VARCHAR,
  "n_67" VARCHAR,
  "n_68" VARCHAR,
  "n_69" VARCHAR,
  "n_70" VARCHAR,
  "n_71" VARCHAR,
  "n_72" VARCHAR,
  "n_73" VARCHAR,
  "n_74" VARCHAR,
  "n_75" VARCHAR,
  "n_76" VARCHAR,
  "n_77" VARCHAR,
  "n_78" VARCHAR,
  "n_79" VARCHAR,
  "n_80" VARCHAR,
  "n_81" VARCHAR,
  "n_82" VARCHAR,
  "n_83" VARCHAR,
  "n_84" VARCHAR,
  "n_85" VARCHAR,
  "n_86" VARCHAR,
  "n_87" VARCHAR,
  "n_88" VARCHAR,
  "n_89" VARCHAR,
  "n_90" VARCHAR,
  "n_91" VARCHAR,
  "n_92" VARCHAR,
  "n_93" VARCHAR,
  "n_94" VARCHAR,
  "n_95" VARCHAR,
  "n_96" VARCHAR,
  "n_97" VARCHAR,
  "n_98" VARCHAR,
  "n_99" VARCHAR,
  "n_100" VARCHAR,
  "n_101" VARCHAR,
  "n_102" VARCHAR,
  "n_103" VARCHAR,
  "n_104" VARCHAR,
  "n_105" VARCHAR,
  "n_2_1" VARCHAR,
  "n_2_2" VARCHAR,
  "n_2_3" VARCHAR,
  "n_2_4" VARCHAR,
  "n_3_1" VARCHAR
);

FCO Consular Management Information January 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_january_2019
  • 71.68 KB
  • 173 rows
  • 88 columns
Loading... 

CREATE TABLE fco_consular_management_information_january_2019 (
  "jan_19" 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" VARCHAR,
  "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_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "coroner_request_none" VARCHAR,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" BIGINT,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" VARCHAR,
  "financial_transactions_request_for_financial_assistance" BIGINT,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information January 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_january_2020
  • 70.56 KB
  • 173 rows
  • 86 columns
Loading... 

CREATE TABLE fco_consular_management_information_january_2020 (
  "https_www_gov_uk_government_publications_open_strategy_refresh" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" BIGINT,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" BIGINT,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" BIGINT,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" VARCHAR,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" BIGINT,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" BIGINT,
  "financial_transactions_request_for_financial_assistance" BIGINT,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information January-December 2018

@ukgov.foreign_office_consular_data.fco_consular_management_information_january_december_2018
  • 66.78 KB
  • 309 rows
  • 72 columns
Loading... 

CREATE TABLE fco_consular_management_information_january_december_2018 (
  "n_2018" 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" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "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_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" VARCHAR,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim" VARCHAR,
  "female_genital_mutilation" VARCHAR,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_unknown" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" VARCHAR,
  "property_unknown" 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_modern_slavery_human_trafficking" VARCHAR,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "victim_of_crime_theft" VARCHAR,
  "welfare" VARCHAR,
  "whereabouts" VARCHAR,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" VARCHAR,
  "accident_emergency_natural_disaster" VARCHAR,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" BIGINT,
  "fee_bearing_services" VARCHAR
);

FCO Consular Management Information January - December 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_january_december_2019
  • 68.34 KB
  • 174 rows
  • 80 columns
Loading... 

CREATE TABLE fco_consular_management_information_january_december_2019 (
  "n_2019" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_other" 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_in_care" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" BIGINT,
  "child_welfare_unknown" VARCHAR,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" VARCHAR,
  "coroner_request_none" VARCHAR,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" VARCHAR,
  "death_in_custody_natural_death" VARCHAR,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" VARCHAR,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" VARCHAR,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" VARCHAR,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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" VARCHAR,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" VARCHAR,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information July 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_july_2019
  • 89.78 KB
  • 173 rows
  • 112 columns
Loading... 

CREATE TABLE fco_consular_management_information_july_2019 (
  "jul_19" 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" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" BIGINT,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_unknown" BIGINT,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "compass_advice_and_self_help" BIGINT,
  "compass_asylum" BIGINT,
  "compass_citizenship_application" BIGINT,
  "compass_deportation" BIGINT,
  "compass_dispute" BIGINT,
  "compass_evacuation" BIGINT,
  "compass_extradition" BIGINT,
  "compass_financial_transaction" BIGINT,
  "compass_fraud" BIGINT,
  "compass_immigration_service" BIGINT,
  "compass_information_local" BIGINT,
  "compass_information_uk" BIGINT,
  "compass_injury" BIGINT,
  "compass_legal_service" BIGINT,
  "compass_loss" BIGINT,
  "compass_medical" BIGINT,
  "compass_miscellaneous" BIGINT,
  "compass_nationality" BIGINT,
  "compass_repatriation" BIGINT,
  "compass_shipping" BIGINT,
  "compass_surrogacy" BIGINT,
  "compass_theft" BIGINT,
  "compass_welfare_whereabouts" BIGINT,
  "compass_unknown" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" VARCHAR,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" BIGINT,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" VARCHAR,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR
);

FCO Consular Management Information July 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_july_2020
  • 67.25 KB
  • 250 rows
  • 83 columns
Loading... 

CREATE TABLE fco_consular_management_information_july_2020 (
  "jul_20" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_other" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" DOUBLE,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" DOUBLE,
  "child_welfare_child_abandonment" DOUBLE,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_child_in_care" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_family_abandonment" DOUBLE,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" DOUBLE,
  "child_welfare_unknown" DOUBLE,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" DOUBLE,
  "coroner_request_none" DOUBLE,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" DOUBLE,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" DOUBLE,
  "death_in_custody_sudden_death" DOUBLE,
  "death_in_custody_suicide" DOUBLE,
  "death_in_custody_unknown" DOUBLE,
  "death_in_custody_natural_death" DOUBLE,
  "diplomatic_claim_none" DOUBLE,
  "female_genital_mutilation_none" DOUBLE,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" DOUBLE,
  "hospitalisation_dementia" DOUBLE,
  "hospitalisation_disability" DOUBLE,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" DOUBLE,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" DOUBLE,
  "property_government" DOUBLE,
  "property_other" DOUBLE,
  "property_unknown" DOUBLE,
  "travel_ban_none" VARCHAR,
  "travel_advice_unknown" DOUBLE,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_cancel_passport" DOUBLE,
  "travel_documents_unknown" DOUBLE,
  "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" DOUBLE,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" DOUBLE,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" DOUBLE,
  "whereabouts_none" DOUBLE,
  "crisis_none" DOUBLE,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information June 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_june_2019
  • 89.55 KB
  • 173 rows
  • 112 columns
Loading... 

CREATE TABLE fco_consular_management_information_june_2019 (
  "jun_19" 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_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "compass_advice_and_self_help" BIGINT,
  "compass_asylum" BIGINT,
  "compass_citizenship_application" BIGINT,
  "compass_deportation" BIGINT,
  "compass_dispute" BIGINT,
  "compass_evacuation" BIGINT,
  "compass_extradition" BIGINT,
  "compass_financial_transaction" BIGINT,
  "compass_fraud" BIGINT,
  "compass_immigration_service" BIGINT,
  "compass_information_local" BIGINT,
  "compass_information_uk" BIGINT,
  "compass_injury" BIGINT,
  "compass_legal_service" BIGINT,
  "compass_loss" BIGINT,
  "compass_medical" BIGINT,
  "compass_miscellaneous" BIGINT,
  "compass_nationality" BIGINT,
  "compass_repatriation" BIGINT,
  "compass_shipping" BIGINT,
  "compass_surrogacy" BIGINT,
  "compass_theft" BIGINT,
  "compass_welfare_whereabouts" BIGINT,
  "compass_unknown" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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" VARCHAR,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR
);

FCO Consular Management Information June 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_june_2020
  • 67.21 KB
  • 250 rows
  • 83 columns
Loading... 

CREATE TABLE fco_consular_management_information_june_2020 (
  "jun_20" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" DOUBLE,
  "arrest_detention_child_pornography" VARCHAR,
  "arrest_detention_child_sex" VARCHAR,
  "arrest_detention_drugs" VARCHAR,
  "arrest_detention_fraud" VARCHAR,
  "arrest_detention_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_other" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" DOUBLE,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" DOUBLE,
  "child_welfare_child_abandonment" DOUBLE,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_child_in_care" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_family_abandonment" DOUBLE,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" DOUBLE,
  "child_welfare_unknown" DOUBLE,
  "commercial_dispute_none" DOUBLE,
  "commercial_dispute_missing" DOUBLE,
  "coroner_request_none" DOUBLE,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" DOUBLE,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" DOUBLE,
  "death_in_custody_sudden_death" DOUBLE,
  "death_in_custody_suicide" VARCHAR,
  "death_in_custody_unknown" DOUBLE,
  "death_in_custody_natural_death" DOUBLE,
  "diplomatic_claim_none" DOUBLE,
  "female_genital_mutilation_none" DOUBLE,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" DOUBLE,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" DOUBLE,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" DOUBLE,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" DOUBLE,
  "property_government" DOUBLE,
  "property_other" DOUBLE,
  "property_unknown" DOUBLE,
  "travel_ban_none" VARCHAR,
  "travel_advice_unknown" DOUBLE,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_cancel_passport" DOUBLE,
  "travel_documents_unknown" DOUBLE,
  "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" DOUBLE,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" DOUBLE,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" DOUBLE,
  "whereabouts_none" DOUBLE,
  "crisis_none" DOUBLE,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information March 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_march_2019
  • 71.54 KB
  • 173 rows
  • 88 columns
Loading... 

CREATE TABLE fco_consular_management_information_march_2019 (
  "mar_19" 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" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "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_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" BIGINT,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" VARCHAR,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" VARCHAR,
  "financial_transactions_request_for_financial_assistance" BIGINT,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information March 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_march_2020
  • 70.28 KB
  • 173 rows
  • 86 columns
Loading... 

CREATE TABLE fco_consular_management_information_march_2020 (
  "mar_20" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" BIGINT,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "commercial_dispute_none" BIGINT,
  "commercial_dispute_missing" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" VARCHAR,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" BIGINT,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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" VARCHAR,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" BIGINT,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" BIGINT,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" BIGINT,
  "financial_transactions_request_for_financial_assistance" BIGINT,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information May 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_may_2019
  • 70.47 KB
  • 173 rows
  • 88 columns
Loading... 

CREATE TABLE fco_consular_management_information_may_2019 (
  "may_19" 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" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" VARCHAR,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" VARCHAR,
  "child_welfare_child_abandonment" VARCHAR,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_unknown" VARCHAR,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" VARCHAR,
  "coroner_request_none" VARCHAR,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" VARCHAR,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" VARCHAR,
  "death_in_custody_natural_death" VARCHAR,
  "death_in_custody_sudden_death" VARCHAR,
  "death_in_custody_suicide" VARCHAR,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim_none" VARCHAR,
  "female_genital_mutilation_none" VARCHAR,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" VARCHAR,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" VARCHAR,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" VARCHAR,
  "property_other" VARCHAR,
  "property_unknown" VARCHAR,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" 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" VARCHAR,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" VARCHAR,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" VARCHAR,
  "accident_emergency_air_incident" VARCHAR,
  "accident_emergency_coach_crash" VARCHAR,
  "accident_emergency_natural_disaster" VARCHAR,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" VARCHAR,
  "accident_emergency_unknown" VARCHAR,
  "crisis_none" VARCHAR,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" VARCHAR,
  "financial_transactions_request_for_financial_assistance" VARCHAR,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information May 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_may_2020
  • 66.79 KB
  • 250 rows
  • 83 columns
Loading... 

CREATE TABLE fco_consular_management_information_may_2020 (
  "may_20" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_other" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" DOUBLE,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" DOUBLE,
  "child_welfare_child_abandonment" DOUBLE,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_child_in_care" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_family_abandonment" DOUBLE,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" DOUBLE,
  "child_welfare_unknown" DOUBLE,
  "commercial_dispute_none" DOUBLE,
  "commercial_dispute_missing" DOUBLE,
  "coroner_request_none" DOUBLE,
  "death_accidental" VARCHAR,
  "death_drowning" DOUBLE,
  "death_execution" DOUBLE,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" VARCHAR,
  "death_in_custody_sudden_death" DOUBLE,
  "death_in_custody_suicide" DOUBLE,
  "death_in_custody_unknown" DOUBLE,
  "death_in_custody_natural_death" DOUBLE,
  "diplomatic_claim_none" DOUBLE,
  "female_genital_mutilation_none" DOUBLE,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" DOUBLE,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" DOUBLE,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" DOUBLE,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" DOUBLE,
  "property_government" VARCHAR,
  "property_other" DOUBLE,
  "property_unknown" DOUBLE,
  "travel_ban_none" VARCHAR,
  "travel_advice_unknown" DOUBLE,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_cancel_passport" DOUBLE,
  "travel_documents_unknown" DOUBLE,
  "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" DOUBLE,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" DOUBLE,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" DOUBLE,
  "whereabouts_none" DOUBLE,
  "crisis_none" DOUBLE,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information November 2018

@ukgov.foreign_office_consular_data.fco_consular_management_information_november_2018
  • 60.58 KB
  • 309 rows
  • 72 columns
Loading... 

CREATE TABLE fco_consular_management_information_november_2018 (
  "nov_18" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" BIGINT,
  "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" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" BIGINT,
  "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" VARCHAR,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim" BIGINT,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT,
  "hospitalisation_dementia" BIGINT,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" VARCHAR,
  "property_other" VARCHAR,
  "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" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);

FCO Consular Management Information November 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_november_2019
  • 70.08 KB
  • 173 rows
  • 86 columns
Loading... 

CREATE TABLE fco_consular_management_information_november_2019 (
  "nov_19" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" BIGINT,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" VARCHAR,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" BIGINT,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" VARCHAR,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" BIGINT,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" BIGINT,
  "financial_transactions_request_for_financial_assistance" BIGINT,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information October 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_october_2019
  • 70.2 KB
  • 173 rows
  • 86 columns
Loading... 

CREATE TABLE fco_consular_management_information_october_2019 (
  "oct_19" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" BIGINT,
  "arrest_detention_child_pornography" VARCHAR,
  "arrest_detention_child_sex" VARCHAR,
  "arrest_detention_drugs" VARCHAR,
  "arrest_detention_fraud" VARCHAR,
  "arrest_detention_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" BIGINT,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" VARCHAR,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" VARCHAR,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" BIGINT,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" 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,
  "crisis_none" BIGINT,
  "financial_transactions_undertaking_to_repay" VARCHAR,
  "financial_transactions_payment" BIGINT,
  "financial_transactions_request_for_financial_assistance" VARCHAR,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information September 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_september_2019
  • 88.02 KB
  • 173 rows
  • 110 columns
Loading... 

CREATE TABLE fco_consular_management_information_september_2019 (
  "sep_19" 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_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "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" BIGINT,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "compass_advice_and_self_help" BIGINT,
  "compass_asylum" BIGINT,
  "compass_citizenship_application" BIGINT,
  "compass_deportation" BIGINT,
  "compass_dispute" BIGINT,
  "compass_evacuation" BIGINT,
  "compass_extradition" BIGINT,
  "compass_financial_transaction" BIGINT,
  "compass_fraud" BIGINT,
  "compass_immigration_service" BIGINT,
  "compass_information_local" BIGINT,
  "compass_information_uk" BIGINT,
  "compass_injury" BIGINT,
  "compass_legal_service" BIGINT,
  "compass_loss" BIGINT,
  "compass_medical" BIGINT,
  "compass_miscellaneous" BIGINT,
  "compass_nationality" BIGINT,
  "compass_repatriation" BIGINT,
  "compass_shipping" BIGINT,
  "compass_surrogacy" BIGINT,
  "compass_theft" BIGINT,
  "compass_welfare_whereabouts" BIGINT,
  "compass_unknown" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_infectious_disease" BIGINT,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_hospital_death" VARCHAR,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" VARCHAR,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons_none" VARCHAR,
  "mistreatment_torture_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_unknown" BIGINT,
  "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" VARCHAR,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "welfare_health" VARCHAR,
  "welfare_financial_issues" VARCHAR,
  "welfare_immigration" VARCHAR,
  "welfare_unknown" VARCHAR,
  "whereabouts_none" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT
);

Share link

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