Baselight
Sign In

Foreign, Commonwealth And Development Office: Consular Management Information

Foreign, Commonwealth and Development Office (FCDO)

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe

Loading...
Loading...

About this Dataset

Foreign, Commonwealth And Development Office: Consular Management Information

These data gives information about the Foreign, Commonwealth and Development Office (FCDO) 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.
Publisher name: Foreign, Commonwealth and Development Office (FCDO)
Last updated: 2024-07-26T19:31:48Z

Tables

April 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.april_2021_fcdo_consular_mi
  • 65.89 KB
  • 174 rows
  • 83 columns
Loading... 

CREATE TABLE april_2021_fcdo_consular_mi (
  "apr_21" 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" 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_child_in_care" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_family_abandonment" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" VARCHAR,
  "child_welfare_unknown" BIGINT,
  "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" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "death_in_custody_natural_death" 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" BIGINT,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_advice_unknown" 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_cancel_passport" BIGINT,
  "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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

April 2022 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.april_2022_fcdo_consular_mi
  • 57.42 KB
  • 175 rows
  • 83 columns
Loading... 

CREATE TABLE april_2022_fcdo_consular_mi (
  "apr_22" VARCHAR,
  "n_1" 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_21" VARCHAR,
  "n_22" VARCHAR,
  "n_23" VARCHAR,
  "n_24" VARCHAR,
  "n_25" VARCHAR,
  "n_26" VARCHAR,
  "n_27" VARCHAR,
  "n_28" VARCHAR,
  "n_29" VARCHAR,
  "n_30" VARCHAR,
  "n_31" VARCHAR,
  "n_32" VARCHAR,
  "n_33" VARCHAR,
  "n_34" VARCHAR,
  "n_35" VARCHAR,
  "n_36" VARCHAR,
  "n_37" VARCHAR,
  "n_38" VARCHAR,
  "n_39" VARCHAR,
  "n_40" VARCHAR,
  "n_41" VARCHAR,
  "n_42" VARCHAR,
  "n_43" VARCHAR,
  "n_44" 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_2_1" VARCHAR,
  "n_2_2" VARCHAR,
  "n_2_3" VARCHAR,
  "n_2_4" VARCHAR,
  "n_3_1" VARCHAR
);

April 2023 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.april_2023_fcdo_consular_mi
  • 61.46 KB
  • 173 rows
  • 83 columns
Loading... 

CREATE TABLE april_2023_fcdo_consular_mi (
  "apr_23" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR
);

August 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.august_2021_fcdo_consular_mi
  • 66.22 KB
  • 174 rows
  • 83 columns
Loading... 

CREATE TABLE august_2021_fcdo_consular_mi (
  "aug_21" 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" 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_child_in_care" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_family_abandonment" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" BIGINT,
  "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" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "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_advice_unknown" 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_cancel_passport" BIGINT,
  "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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

August 2022 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.august_2022_fcdo_consular_mi
  • 57.73 KB
  • 175 rows
  • 83 columns
Loading... 

CREATE TABLE august_2022_fcdo_consular_mi (
  "aug_22" VARCHAR,
  "n_1" 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_21" VARCHAR,
  "n_22" VARCHAR,
  "n_23" VARCHAR,
  "n_24" VARCHAR,
  "n_25" VARCHAR,
  "n_26" VARCHAR,
  "n_27" VARCHAR,
  "n_28" VARCHAR,
  "n_29" VARCHAR,
  "n_30" VARCHAR,
  "n_31" VARCHAR,
  "n_32" VARCHAR,
  "n_33" VARCHAR,
  "n_34" VARCHAR,
  "n_35" VARCHAR,
  "n_36" VARCHAR,
  "n_37" VARCHAR,
  "n_38" VARCHAR,
  "n_39" VARCHAR,
  "n_40" VARCHAR,
  "n_41" VARCHAR,
  "n_42" VARCHAR,
  "n_43" VARCHAR,
  "n_44" 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_2_1" VARCHAR,
  "n_2_2" VARCHAR,
  "n_2_3" VARCHAR,
  "n_2_4" VARCHAR,
  "n_3_1" VARCHAR
);

Consular Data: Annual Consolidated Management Information Data 2021

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.consular_annual_consolidated_management_information_2021
  • 69.86 KB
  • 174 rows
  • 83 columns
Loading... 

CREATE TABLE consular_annual_consolidated_management_information_2021 (
  "n_2021" 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" BIGINT,
  "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" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" 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_sudden_death" BIGINT,
  "death_in_custody_suicide" VARCHAR,
  "death_in_custody_unknown" VARCHAR,
  "death_in_custody_natural_death" 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" BIGINT,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_advice_unknown" 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_cancel_passport" BIGINT,
  "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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

Consular Data: Annual Consolidated Management Information 2022

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.consular_data_annual_consolidated_management_information_2022
  • 62.65 KB
  • 176 rows
  • 83 columns
Loading... 

CREATE TABLE consular_data_annual_consolidated_management_information_2022 (
  "n_2022" VARCHAR,
  "n_1" 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_21" VARCHAR,
  "n_22" VARCHAR,
  "n_23" VARCHAR,
  "n_24" VARCHAR,
  "n_25" VARCHAR,
  "n_26" VARCHAR,
  "n_27" VARCHAR,
  "n_28" VARCHAR,
  "n_29" VARCHAR,
  "n_30" VARCHAR,
  "n_31" VARCHAR,
  "n_32" VARCHAR,
  "n_33" VARCHAR,
  "n_34" VARCHAR,
  "n_35" VARCHAR,
  "n_36" VARCHAR,
  "n_37" VARCHAR,
  "n_38" VARCHAR,
  "n_39" VARCHAR,
  "n_40" VARCHAR,
  "n_41" VARCHAR,
  "n_42" VARCHAR,
  "n_43" VARCHAR,
  "n_44" 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_2_1" VARCHAR,
  "n_2_2" VARCHAR,
  "n_2_3" VARCHAR,
  "n_2_4" VARCHAR,
  "n_3_1" VARCHAR
);

Consular Data: Annual Consolidated MI Data 2020

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.consular_data_annual_consolidated_mi_data_2020
  • 67.59 KB
  • 173 rows
  • 80 columns
Loading... 

CREATE TABLE consular_data_annual_consolidated_mi_data_2020 (
  "n_2020" 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" 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" 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" VARCHAR,
  "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" BIGINT,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

December 2020 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.december_2020_fcdo_consular_mi
  • 63.63 KB
  • 173 rows
  • 80 columns
Loading... 

CREATE TABLE december_2020_fcdo_consular_mi (
  "dec_20" 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_other" 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_in_care" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" VARCHAR,
  "child_welfare_unknown" BIGINT,
  "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" 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" BIGINT,
  "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" 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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

December 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.december_2021_fcdo_consular_mi
  • 66.09 KB
  • 174 rows
  • 83 columns
Loading... 

CREATE TABLE december_2021_fcdo_consular_mi (
  "dec_21" 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_other" 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_child_in_care" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_family_abandonment" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" BIGINT,
  "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" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" VARCHAR,
  "death_in_custody_natural_death" VARCHAR,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" BIGINT,
  "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_advice_unknown" 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_cancel_passport" BIGINT,
  "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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

December 2022 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.december_2022_fcdo_consular_mi
  • 57.39 KB
  • 176 rows
  • 83 columns
Loading... 

CREATE TABLE december_2022_fcdo_consular_mi (
  "dec_22" VARCHAR,
  "n_1" 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_21" VARCHAR,
  "n_22" VARCHAR,
  "n_23" VARCHAR,
  "n_24" VARCHAR,
  "n_25" VARCHAR,
  "n_26" VARCHAR,
  "n_27" VARCHAR,
  "n_28" VARCHAR,
  "n_29" VARCHAR,
  "n_30" VARCHAR,
  "n_31" VARCHAR,
  "n_32" VARCHAR,
  "n_33" VARCHAR,
  "n_34" VARCHAR,
  "n_35" VARCHAR,
  "n_36" VARCHAR,
  "n_37" VARCHAR,
  "n_38" VARCHAR,
  "n_39" VARCHAR,
  "n_40" VARCHAR,
  "n_41" VARCHAR,
  "n_42" VARCHAR,
  "n_43" VARCHAR,
  "n_44" 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_2_1" VARCHAR,
  "n_2_2" VARCHAR,
  "n_2_3" VARCHAR,
  "n_2_4" VARCHAR,
  "n_3_1" VARCHAR
);

February 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.february_2021_fcdo_consular_mi
  • 63.37 KB
  • 174 rows
  • 80 columns
Loading... 

CREATE TABLE february_2021_fcdo_consular_mi (
  "feb_21" 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" BIGINT,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" BIGINT,
  "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" VARCHAR,
  "child_welfare_unknown" BIGINT,
  "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" 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_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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

February 2022 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.february_2022_fcdo_consular_mi
  • 57.09 KB
  • 175 rows
  • 83 columns
Loading... 

CREATE TABLE february_2022_fcdo_consular_mi (
  "feb_22" VARCHAR,
  "n_1" 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_21" VARCHAR,
  "n_22" VARCHAR,
  "n_23" VARCHAR,
  "n_24" VARCHAR,
  "n_25" VARCHAR,
  "n_26" VARCHAR,
  "n_27" VARCHAR,
  "n_28" VARCHAR,
  "n_29" VARCHAR,
  "n_30" VARCHAR,
  "n_31" VARCHAR,
  "n_32" VARCHAR,
  "n_33" VARCHAR,
  "n_34" VARCHAR,
  "n_35" VARCHAR,
  "n_36" VARCHAR,
  "n_37" VARCHAR,
  "n_38" VARCHAR,
  "n_39" VARCHAR,
  "n_40" VARCHAR,
  "n_41" VARCHAR,
  "n_42" VARCHAR,
  "n_43" VARCHAR,
  "n_44" 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_2_1" VARCHAR,
  "n_2_2" VARCHAR,
  "n_2_3" VARCHAR,
  "n_2_4" VARCHAR,
  "n_3_1" VARCHAR
);

February 2023 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.february_2023_fcdo_consular_mi
  • 61.41 KB
  • 173 rows
  • 83 columns
Loading... 

CREATE TABLE february_2023_fcdo_consular_mi (
  "feb_23" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR
);

January 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.january_2021_fcdo_consular_mi
  • 63.46 KB
  • 173 rows
  • 80 columns
Loading... 

CREATE TABLE january_2021_fcdo_consular_mi (
  "jan_21" 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" BIGINT,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_other" 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_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" BIGINT,
  "commercial_dispute_none" VARCHAR,
  "commercial_dispute_missing" BIGINT,
  "coroner_request_none" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" BIGINT,
  "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" BIGINT,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" VARCHAR,
  "forced_marriage_reluctant_sponsor_none" BIGINT,
  "hospitalisation_dementia" BIGINT,
  "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" BIGINT,
  "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" BIGINT,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

January 2022 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.january_2022_fcdo_consular_mi
  • 65.95 KB
  • 174 rows
  • 83 columns
Loading... 

CREATE TABLE january_2022_fcdo_consular_mi (
  "jan_22" 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_other" 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_child_in_care" VARCHAR,
  "child_welfare_child_working_licence" VARCHAR,
  "child_welfare_family_abandonment" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" BIGINT,
  "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" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "death_in_custody_natural_death" 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_advice_unknown" 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_cancel_passport" BIGINT,
  "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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

January 2023 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.january_2023_fcdo_consular_mi
  • 57.51 KB
  • 176 rows
  • 83 columns
Loading... 

CREATE TABLE january_2023_fcdo_consular_mi (
  "jan_23" VARCHAR,
  "n_1" 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_21" VARCHAR,
  "n_22" VARCHAR,
  "n_23" VARCHAR,
  "n_24" VARCHAR,
  "n_25" VARCHAR,
  "n_26" VARCHAR,
  "n_27" VARCHAR,
  "n_28" VARCHAR,
  "n_29" VARCHAR,
  "n_30" VARCHAR,
  "n_31" VARCHAR,
  "n_32" VARCHAR,
  "n_33" VARCHAR,
  "n_34" VARCHAR,
  "n_35" VARCHAR,
  "n_36" VARCHAR,
  "n_37" VARCHAR,
  "n_38" VARCHAR,
  "n_39" VARCHAR,
  "n_40" VARCHAR,
  "n_41" VARCHAR,
  "n_42" VARCHAR,
  "n_43" VARCHAR,
  "n_44" 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_2_1" VARCHAR,
  "n_2_2" VARCHAR,
  "n_2_3" VARCHAR,
  "n_2_4" VARCHAR,
  "n_3_1" VARCHAR
);

July 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.july_2021_fcdo_consular_mi
  • 66.57 KB
  • 174 rows
  • 83 columns
Loading... 

CREATE TABLE july_2021_fcdo_consular_mi (
  "jul_21" 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_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" BIGINT,
  "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" BIGINT,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" BIGINT,
  "child_welfare_unknown" BIGINT,
  "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" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "death_in_custody_natural_death" 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_advice_unknown" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" BIGINT,
  "travel_documents_emergency_passport" BIGINT,
  "travel_documents_cancel_passport" BIGINT,
  "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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

July 2022 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.july_2022_fcdo_consular_mi
  • 57.82 KB
  • 175 rows
  • 83 columns
Loading... 

CREATE TABLE july_2022_fcdo_consular_mi (
  "jul_22" VARCHAR,
  "n_1" 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_21" VARCHAR,
  "n_22" VARCHAR,
  "n_23" VARCHAR,
  "n_24" VARCHAR,
  "n_25" VARCHAR,
  "n_26" VARCHAR,
  "n_27" VARCHAR,
  "n_28" VARCHAR,
  "n_29" VARCHAR,
  "n_30" VARCHAR,
  "n_31" VARCHAR,
  "n_32" VARCHAR,
  "n_33" VARCHAR,
  "n_34" VARCHAR,
  "n_35" VARCHAR,
  "n_36" VARCHAR,
  "n_37" VARCHAR,
  "n_38" VARCHAR,
  "n_39" VARCHAR,
  "n_40" VARCHAR,
  "n_41" VARCHAR,
  "n_42" VARCHAR,
  "n_43" VARCHAR,
  "n_44" 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_2_1" VARCHAR,
  "n_2_2" VARCHAR,
  "n_2_3" VARCHAR,
  "n_2_4" VARCHAR,
  "n_3_1" VARCHAR
);

July 2023 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.july_2023_fcdo_consular_mi
  • 61.86 KB
  • 175 rows
  • 83 columns
Loading... 

CREATE TABLE july_2023_fcdo_consular_mi (
  "jul_23" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR
);

June 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.june_2021_fcdo_consular_mi
  • 66.67 KB
  • 250 rows
  • 83 columns
Loading... 

CREATE TABLE june_2021_fcdo_consular_mi (
  "june_21" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" VARCHAR,
  "arrest_detention_child_sex" DOUBLE,
  "arrest_detention_drugs" VARCHAR,
  "arrest_detention_fraud" VARCHAR,
  "arrest_detention_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" DOUBLE,
  "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" VARCHAR,
  "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" VARCHAR,
  "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" 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" VARCHAR,
  "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
);

June 2022 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.june_2022_fcdo_consular_mi
  • 57.66 KB
  • 175 rows
  • 83 columns
Loading... 

CREATE TABLE june_2022_fcdo_consular_mi (
  "jun_22" VARCHAR,
  "n_1" 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_21" VARCHAR,
  "n_22" VARCHAR,
  "n_23" VARCHAR,
  "n_24" VARCHAR,
  "n_25" VARCHAR,
  "n_26" VARCHAR,
  "n_27" VARCHAR,
  "n_28" VARCHAR,
  "n_29" VARCHAR,
  "n_30" VARCHAR,
  "n_31" VARCHAR,
  "n_32" VARCHAR,
  "n_33" VARCHAR,
  "n_34" VARCHAR,
  "n_35" VARCHAR,
  "n_36" VARCHAR,
  "n_37" VARCHAR,
  "n_38" VARCHAR,
  "n_39" VARCHAR,
  "n_40" VARCHAR,
  "n_41" VARCHAR,
  "n_42" VARCHAR,
  "n_43" VARCHAR,
  "n_44" 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_2_1" VARCHAR,
  "n_2_2" VARCHAR,
  "n_2_3" VARCHAR,
  "n_2_4" VARCHAR,
  "n_3_1" VARCHAR
);

June 2023 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.june_2023_fcdo_consular_mi
  • 61.87 KB
  • 175 rows
  • 83 columns
Loading... 

CREATE TABLE june_2023_fcdo_consular_mi (
  "jun_23" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR
);

March 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.march_2021_fcdo_consular_mi
  • 66.2 KB
  • 174 rows
  • 83 columns
Loading... 

CREATE TABLE march_2021_fcdo_consular_mi (
  "mar_21" 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" BIGINT,
  "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" BIGINT,
  "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" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" BIGINT,
  "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" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "death_in_custody_natural_death" 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" BIGINT,
  "property_unknown" BIGINT,
  "travel_ban_none" VARCHAR,
  "travel_advice_unknown" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" VARCHAR,
  "travel_documents_emergency_passport" BIGINT,
  "travel_documents_cancel_passport" BIGINT,
  "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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

March 2022 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.march_2022_fcdo_consular_mi
  • 66.47 KB
  • 174 rows
  • 83 columns
Loading... 

CREATE TABLE march_2022_fcdo_consular_mi (
  "mar_22" 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" BIGINT,
  "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" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_surrogacy" BIGINT,
  "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" BIGINT,
  "death_in_custody_sudden_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "death_in_custody_natural_death" BIGINT,
  "diplomatic_claim_none" BIGINT,
  "female_genital_mutilation_none" BIGINT,
  "forced_marriage_none" BIGINT,
  "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_advice_unknown" BIGINT,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "travel_documents_emergency_travel_document" BIGINT,
  "travel_documents_emergency_passport" VARCHAR,
  "travel_documents_cancel_passport" BIGINT,
  "travel_documents_unknown" BIGINT,
  "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" 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,
  "crisis_none" BIGINT,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

Share link

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