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

67.47 kB
174 rows
83 columns

CREATE TABLE april_2021_fcdo_consular_mi (
  "apr_21" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" BIGINT  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_family_abandonment" VARCHAR  -- Child Welfare > Family Abandonment,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" VARCHAR  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" BIGINT  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" BIGINT  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" VARCHAR  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" BIGINT  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" BIGINT  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_advice_unknown" BIGINT  -- Travel Advice > Unknown,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

58.79 kB
175 rows
83 columns

CREATE TABLE april_2022_fcdo_consular_mi (
  "apr_22" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "n_13" VARCHAR  -- 13,
  "n_14" VARCHAR  -- 14,
  "n_15" VARCHAR  -- 15,
  "n_16" VARCHAR  -- 16,
  "n_17" VARCHAR  -- 17,
  "n_18" VARCHAR  -- 18,
  "n_19" VARCHAR  -- 19,
  "n_20" VARCHAR  -- 20,
  "n_21" VARCHAR  -- 21,
  "n_22" VARCHAR  -- 22,
  "n_23" VARCHAR  -- 23,
  "n_24" VARCHAR  -- 24,
  "n_25" VARCHAR  -- 25,
  "n_26" VARCHAR  -- 26,
  "n_27" VARCHAR  -- 27,
  "n_28" VARCHAR  -- 28,
  "n_29" VARCHAR  -- 29,
  "n_30" VARCHAR  -- 30,
  "n_31" VARCHAR  -- 31,
  "n_32" VARCHAR  -- 32,
  "n_33" VARCHAR  -- 33,
  "n_34" VARCHAR  -- 34,
  "n_35" VARCHAR  -- 35,
  "n_36" VARCHAR  -- 36,
  "n_37" VARCHAR  -- 37,
  "n_38" VARCHAR  -- 38,
  "n_39" VARCHAR  -- 39,
  "n_40" VARCHAR  -- 40,
  "n_41" VARCHAR  -- 41,
  "n_42" VARCHAR  -- 42,
  "n_43" VARCHAR  -- 43,
  "n_44" VARCHAR  -- 44,
  "n_45" VARCHAR  -- 45,
  "n_46" VARCHAR  -- 46,
  "n_47" VARCHAR  -- 47,
  "n_48" VARCHAR  -- 48,
  "n_49" VARCHAR  -- 49,
  "n_50" VARCHAR  -- 50,
  "n_51" VARCHAR  -- 51,
  "n_52" VARCHAR  -- 52,
  "n_53" VARCHAR  -- 53,
  "n_54" VARCHAR  -- 54,
  "n_55" VARCHAR  -- 55,
  "n_56" VARCHAR  -- 56,
  "n_57" VARCHAR  -- 57,
  "n_58" VARCHAR  -- 58,
  "n_59" VARCHAR  -- 59,
  "n_60" VARCHAR  -- 60,
  "n_61" VARCHAR  -- 61,
  "n_62" VARCHAR  -- 62,
  "n_63" VARCHAR  -- 63,
  "n_64" VARCHAR  -- 64,
  "n_65" VARCHAR  -- 65,
  "n_66" VARCHAR  -- 66,
  "n_67" VARCHAR  -- 67,
  "n_68" VARCHAR  -- 68,
  "n_69" VARCHAR  -- 69,
  "n_70" VARCHAR  -- 70,
  "n_71" VARCHAR  -- 71,
  "n_72" VARCHAR  -- 72,
  "n_73" VARCHAR  -- 73,
  "n_74" VARCHAR  -- 74,
  "n_75" VARCHAR  -- 75,
  "n_76" VARCHAR  -- 76,
  "n_77" VARCHAR  -- 77,
  "n_2_1" VARCHAR  -- 2.1,
  "n_2_2" VARCHAR  -- 2.2,
  "n_2_3" VARCHAR  -- 2.3,
  "n_2_4" VARCHAR  -- 2.4,
  "n_3_1" VARCHAR  -- 3.1
);

April 2023 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.april_2023_fcdo_consular_mi

62.93 kB
173 rows
83 columns

CREATE TABLE april_2023_fcdo_consular_mi (
  "apr_23" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82
);

August 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.august_2021_fcdo_consular_mi

67.81 kB
174 rows
83 columns

CREATE TABLE august_2021_fcdo_consular_mi (
  "aug_21" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" BIGINT  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_family_abandonment" VARCHAR  -- Child Welfare > Family Abandonment,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" BIGINT  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" BIGINT  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" BIGINT  -- Female Genital Mutilation > None,
  "forced_marriage_none" BIGINT  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_advice_unknown" BIGINT  -- Travel Advice > Unknown,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" VARCHAR  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

59.11 kB
175 rows
83 columns

CREATE TABLE august_2022_fcdo_consular_mi (
  "aug_22" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "n_13" VARCHAR  -- 13,
  "n_14" VARCHAR  -- 14,
  "n_15" VARCHAR  -- 15,
  "n_16" VARCHAR  -- 16,
  "n_17" VARCHAR  -- 17,
  "n_18" VARCHAR  -- 18,
  "n_19" VARCHAR  -- 19,
  "n_20" VARCHAR  -- 20,
  "n_21" VARCHAR  -- 21,
  "n_22" VARCHAR  -- 22,
  "n_23" VARCHAR  -- 23,
  "n_24" VARCHAR  -- 24,
  "n_25" VARCHAR  -- 25,
  "n_26" VARCHAR  -- 26,
  "n_27" VARCHAR  -- 27,
  "n_28" VARCHAR  -- 28,
  "n_29" VARCHAR  -- 29,
  "n_30" VARCHAR  -- 30,
  "n_31" VARCHAR  -- 31,
  "n_32" VARCHAR  -- 32,
  "n_33" VARCHAR  -- 33,
  "n_34" VARCHAR  -- 34,
  "n_35" VARCHAR  -- 35,
  "n_36" VARCHAR  -- 36,
  "n_37" VARCHAR  -- 37,
  "n_38" VARCHAR  -- 38,
  "n_39" VARCHAR  -- 39,
  "n_40" VARCHAR  -- 40,
  "n_41" VARCHAR  -- 41,
  "n_42" VARCHAR  -- 42,
  "n_43" VARCHAR  -- 43,
  "n_44" VARCHAR  -- 44,
  "n_45" VARCHAR  -- 45,
  "n_46" VARCHAR  -- 46,
  "n_47" VARCHAR  -- 47,
  "n_48" VARCHAR  -- 48,
  "n_49" VARCHAR  -- 49,
  "n_50" VARCHAR  -- 50,
  "n_51" VARCHAR  -- 51,
  "n_52" VARCHAR  -- 52,
  "n_53" VARCHAR  -- 53,
  "n_54" VARCHAR  -- 54,
  "n_55" VARCHAR  -- 55,
  "n_56" VARCHAR  -- 56,
  "n_57" VARCHAR  -- 57,
  "n_58" VARCHAR  -- 58,
  "n_59" VARCHAR  -- 59,
  "n_60" VARCHAR  -- 60,
  "n_61" VARCHAR  -- 61,
  "n_62" VARCHAR  -- 62,
  "n_63" VARCHAR  -- 63,
  "n_64" VARCHAR  -- 64,
  "n_65" VARCHAR  -- 65,
  "n_66" VARCHAR  -- 66,
  "n_67" VARCHAR  -- 67,
  "n_68" VARCHAR  -- 68,
  "n_69" VARCHAR  -- 69,
  "n_70" VARCHAR  -- 70,
  "n_71" VARCHAR  -- 71,
  "n_72" VARCHAR  -- 72,
  "n_73" VARCHAR  -- 73,
  "n_74" VARCHAR  -- 74,
  "n_75" VARCHAR  -- 75,
  "n_76" VARCHAR  -- 76,
  "n_77" VARCHAR  -- 77,
  "n_2_1" VARCHAR  -- 2.1,
  "n_2_2" VARCHAR  -- 2.2,
  "n_2_3" VARCHAR  -- 2.3,
  "n_2_4" VARCHAR  -- 2.4,
  "n_3_1" VARCHAR  -- 3.1
);

Consular Data: Annual Consolidated Management Information Data 2021

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.consular_annual_consolidated_management_information_2021

71.53 kB
174 rows
83 columns

CREATE TABLE consular_annual_consolidated_management_information_2021 (
  "n_2021" VARCHAR  -- 2021,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_family_abandonment" VARCHAR  -- Child Welfare > Family Abandonment,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" VARCHAR  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" VARCHAR  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" VARCHAR  -- Death In Custody > Suicide,
  "death_in_custody_unknown" VARCHAR  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" VARCHAR  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" VARCHAR  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" VARCHAR  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_advice_unknown" BIGINT  -- Travel Advice > Unknown,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" VARCHAR  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

64.15 kB
176 rows
83 columns

CREATE TABLE consular_data_annual_consolidated_management_information_2022 (
  "n_2022" VARCHAR  -- 2022,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "n_13" VARCHAR  -- 13,
  "n_14" VARCHAR  -- 14,
  "n_15" VARCHAR  -- 15,
  "n_16" VARCHAR  -- 16,
  "n_17" VARCHAR  -- 17,
  "n_18" VARCHAR  -- 18,
  "n_19" VARCHAR  -- 19,
  "n_20" VARCHAR  -- 20,
  "n_21" VARCHAR  -- 21,
  "n_22" VARCHAR  -- 22,
  "n_23" VARCHAR  -- 23,
  "n_24" VARCHAR  -- 24,
  "n_25" VARCHAR  -- 25,
  "n_26" VARCHAR  -- 26,
  "n_27" VARCHAR  -- 27,
  "n_28" VARCHAR  -- 28,
  "n_29" VARCHAR  -- 29,
  "n_30" VARCHAR  -- 30,
  "n_31" VARCHAR  -- 31,
  "n_32" VARCHAR  -- 32,
  "n_33" VARCHAR  -- 33,
  "n_34" VARCHAR  -- 34,
  "n_35" VARCHAR  -- 35,
  "n_36" VARCHAR  -- 36,
  "n_37" VARCHAR  -- 37,
  "n_38" VARCHAR  -- 38,
  "n_39" VARCHAR  -- 39,
  "n_40" VARCHAR  -- 40,
  "n_41" VARCHAR  -- 41,
  "n_42" VARCHAR  -- 42,
  "n_43" VARCHAR  -- 43,
  "n_44" VARCHAR  -- 44,
  "n_45" VARCHAR  -- 45,
  "n_46" VARCHAR  -- 46,
  "n_47" VARCHAR  -- 47,
  "n_48" VARCHAR  -- 48,
  "n_49" VARCHAR  -- 49,
  "n_50" VARCHAR  -- 50,
  "n_51" VARCHAR  -- 51,
  "n_52" VARCHAR  -- 52,
  "n_53" VARCHAR  -- 53,
  "n_54" VARCHAR  -- 54,
  "n_55" VARCHAR  -- 55,
  "n_56" VARCHAR  -- 56,
  "n_57" VARCHAR  -- 57,
  "n_58" VARCHAR  -- 58,
  "n_59" VARCHAR  -- 59,
  "n_60" VARCHAR  -- 60,
  "n_61" VARCHAR  -- 61,
  "n_62" VARCHAR  -- 62,
  "n_63" VARCHAR  -- 63,
  "n_64" VARCHAR  -- 64,
  "n_65" VARCHAR  -- 65,
  "n_66" VARCHAR  -- 66,
  "n_67" VARCHAR  -- 67,
  "n_68" VARCHAR  -- 68,
  "n_69" VARCHAR  -- 69,
  "n_70" VARCHAR  -- 70,
  "n_71" VARCHAR  -- 71,
  "n_72" VARCHAR  -- 72,
  "n_73" VARCHAR  -- 73,
  "n_74" VARCHAR  -- 74,
  "n_75" VARCHAR  -- 75,
  "n_76" VARCHAR  -- 76,
  "n_77" VARCHAR  -- 77,
  "n_2_1" VARCHAR  -- 2.1,
  "n_2_2" VARCHAR  -- 2.2,
  "n_2_3" VARCHAR  -- 2.3,
  "n_2_4" VARCHAR  -- 2.4,
  "n_3_1" VARCHAR  -- 3.1
);

Consular Data: Annual Consolidated MI Data 2020

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.consular_data_annual_consolidated_mi_data_2020

69.21 kB
173 rows
80 columns

CREATE TABLE consular_data_annual_consolidated_mi_data_2020 (
  "n_2020" VARCHAR  -- 2020,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" VARCHAR  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" VARCHAR  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" VARCHAR  -- Death In Custody > Hospital Death,
  "death_in_custody_natural_death" VARCHAR  -- Death In Custody > Natural Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" VARCHAR  -- Death In Custody > Suicide,
  "death_in_custody_unknown" VARCHAR  -- Death In Custody > Unknown,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" VARCHAR  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" VARCHAR  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" VARCHAR  -- Property > Fraud,
  "property_government" VARCHAR  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" VARCHAR  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

65.16 kB
173 rows
80 columns

CREATE TABLE december_2020_fcdo_consular_mi (
  "dec_20" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" BIGINT  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" BIGINT  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" VARCHAR  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" BIGINT  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" VARCHAR  -- Death In Custody > Hospital Death,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" BIGINT  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" BIGINT  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

67.68 kB
174 rows
83 columns

CREATE TABLE december_2021_fcdo_consular_mi (
  "dec_21" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" BIGINT  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" BIGINT  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_family_abandonment" VARCHAR  -- Child Welfare > Family Abandonment,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" BIGINT  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" BIGINT  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" VARCHAR  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" VARCHAR  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" BIGINT  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" BIGINT  -- Hospitalisation > Dementia,
  "hospitalisation_disability" BIGINT  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_advice_unknown" BIGINT  -- Travel Advice > Unknown,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

58.77 kB
176 rows
83 columns

CREATE TABLE december_2022_fcdo_consular_mi (
  "dec_22" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "n_13" VARCHAR  -- 13,
  "n_14" VARCHAR  -- 14,
  "n_15" VARCHAR  -- 15,
  "n_16" VARCHAR  -- 16,
  "n_17" VARCHAR  -- 17,
  "n_18" VARCHAR  -- 18,
  "n_19" VARCHAR  -- 19,
  "n_20" VARCHAR  -- 20,
  "n_21" VARCHAR  -- 21,
  "n_22" VARCHAR  -- 22,
  "n_23" VARCHAR  -- 23,
  "n_24" VARCHAR  -- 24,
  "n_25" VARCHAR  -- 25,
  "n_26" VARCHAR  -- 26,
  "n_27" VARCHAR  -- 27,
  "n_28" VARCHAR  -- 28,
  "n_29" VARCHAR  -- 29,
  "n_30" VARCHAR  -- 30,
  "n_31" VARCHAR  -- 31,
  "n_32" VARCHAR  -- 32,
  "n_33" VARCHAR  -- 33,
  "n_34" VARCHAR  -- 34,
  "n_35" VARCHAR  -- 35,
  "n_36" VARCHAR  -- 36,
  "n_37" VARCHAR  -- 37,
  "n_38" VARCHAR  -- 38,
  "n_39" VARCHAR  -- 39,
  "n_40" VARCHAR  -- 40,
  "n_41" VARCHAR  -- 41,
  "n_42" VARCHAR  -- 42,
  "n_43" VARCHAR  -- 43,
  "n_44" VARCHAR  -- 44,
  "n_45" VARCHAR  -- 45,
  "n_46" VARCHAR  -- 46,
  "n_47" VARCHAR  -- 47,
  "n_48" VARCHAR  -- 48,
  "n_49" VARCHAR  -- 49,
  "n_50" VARCHAR  -- 50,
  "n_51" VARCHAR  -- 51,
  "n_52" VARCHAR  -- 52,
  "n_53" VARCHAR  -- 53,
  "n_54" VARCHAR  -- 54,
  "n_55" VARCHAR  -- 55,
  "n_56" VARCHAR  -- 56,
  "n_57" VARCHAR  -- 57,
  "n_58" VARCHAR  -- 58,
  "n_59" VARCHAR  -- 59,
  "n_60" VARCHAR  -- 60,
  "n_61" VARCHAR  -- 61,
  "n_62" VARCHAR  -- 62,
  "n_63" VARCHAR  -- 63,
  "n_64" VARCHAR  -- 64,
  "n_65" VARCHAR  -- 65,
  "n_66" VARCHAR  -- 66,
  "n_67" VARCHAR  -- 67,
  "n_68" VARCHAR  -- 68,
  "n_69" VARCHAR  -- 69,
  "n_70" VARCHAR  -- 70,
  "n_71" VARCHAR  -- 71,
  "n_72" VARCHAR  -- 72,
  "n_73" VARCHAR  -- 73,
  "n_74" VARCHAR  -- 74,
  "n_75" VARCHAR  -- 75,
  "n_76" VARCHAR  -- 76,
  "n_77" VARCHAR  -- 77,
  "n_2_1" VARCHAR  -- 2.1,
  "n_2_2" VARCHAR  -- 2.2,
  "n_2_3" VARCHAR  -- 2.3,
  "n_2_4" VARCHAR  -- 2.4,
  "n_3_1" VARCHAR  -- 3.1
);

February 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.february_2021_fcdo_consular_mi

64.89 kB
174 rows
80 columns

CREATE TABLE february_2021_fcdo_consular_mi (
  "feb_21" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" BIGINT  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" VARCHAR  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" BIGINT  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" BIGINT  -- Death In Custody > Hospital Death,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" BIGINT  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

58.46 kB
175 rows
83 columns

CREATE TABLE february_2022_fcdo_consular_mi (
  "feb_22" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "n_13" VARCHAR  -- 13,
  "n_14" VARCHAR  -- 14,
  "n_15" VARCHAR  -- 15,
  "n_16" VARCHAR  -- 16,
  "n_17" VARCHAR  -- 17,
  "n_18" VARCHAR  -- 18,
  "n_19" VARCHAR  -- 19,
  "n_20" VARCHAR  -- 20,
  "n_21" VARCHAR  -- 21,
  "n_22" VARCHAR  -- 22,
  "n_23" VARCHAR  -- 23,
  "n_24" VARCHAR  -- 24,
  "n_25" VARCHAR  -- 25,
  "n_26" VARCHAR  -- 26,
  "n_27" VARCHAR  -- 27,
  "n_28" VARCHAR  -- 28,
  "n_29" VARCHAR  -- 29,
  "n_30" VARCHAR  -- 30,
  "n_31" VARCHAR  -- 31,
  "n_32" VARCHAR  -- 32,
  "n_33" VARCHAR  -- 33,
  "n_34" VARCHAR  -- 34,
  "n_35" VARCHAR  -- 35,
  "n_36" VARCHAR  -- 36,
  "n_37" VARCHAR  -- 37,
  "n_38" VARCHAR  -- 38,
  "n_39" VARCHAR  -- 39,
  "n_40" VARCHAR  -- 40,
  "n_41" VARCHAR  -- 41,
  "n_42" VARCHAR  -- 42,
  "n_43" VARCHAR  -- 43,
  "n_44" VARCHAR  -- 44,
  "n_45" VARCHAR  -- 45,
  "n_46" VARCHAR  -- 46,
  "n_47" VARCHAR  -- 47,
  "n_48" VARCHAR  -- 48,
  "n_49" VARCHAR  -- 49,
  "n_50" VARCHAR  -- 50,
  "n_51" VARCHAR  -- 51,
  "n_52" VARCHAR  -- 52,
  "n_53" VARCHAR  -- 53,
  "n_54" VARCHAR  -- 54,
  "n_55" VARCHAR  -- 55,
  "n_56" VARCHAR  -- 56,
  "n_57" VARCHAR  -- 57,
  "n_58" VARCHAR  -- 58,
  "n_59" VARCHAR  -- 59,
  "n_60" VARCHAR  -- 60,
  "n_61" VARCHAR  -- 61,
  "n_62" VARCHAR  -- 62,
  "n_63" VARCHAR  -- 63,
  "n_64" VARCHAR  -- 64,
  "n_65" VARCHAR  -- 65,
  "n_66" VARCHAR  -- 66,
  "n_67" VARCHAR  -- 67,
  "n_68" VARCHAR  -- 68,
  "n_69" VARCHAR  -- 69,
  "n_70" VARCHAR  -- 70,
  "n_71" VARCHAR  -- 71,
  "n_72" VARCHAR  -- 72,
  "n_73" VARCHAR  -- 73,
  "n_74" VARCHAR  -- 74,
  "n_75" VARCHAR  -- 75,
  "n_76" VARCHAR  -- 76,
  "n_77" VARCHAR  -- 77,
  "n_2_1" VARCHAR  -- 2.1,
  "n_2_2" VARCHAR  -- 2.2,
  "n_2_3" VARCHAR  -- 2.3,
  "n_2_4" VARCHAR  -- 2.4,
  "n_3_1" VARCHAR  -- 3.1
);

February 2023 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.february_2023_fcdo_consular_mi

62.89 kB
173 rows
83 columns

CREATE TABLE february_2023_fcdo_consular_mi (
  "feb_23" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82
);

January 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.january_2021_fcdo_consular_mi

64.99 kB
173 rows
80 columns

CREATE TABLE january_2021_fcdo_consular_mi (
  "jan_21" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" BIGINT  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" BIGINT  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" BIGINT  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" BIGINT  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" VARCHAR  -- Death In Custody > Hospital Death,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" BIGINT  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" BIGINT  -- Hospitalisation > Dementia,
  "hospitalisation_disability" BIGINT  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" VARCHAR  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" VARCHAR  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

67.53 kB
174 rows
83 columns

CREATE TABLE january_2022_fcdo_consular_mi (
  "jan_22" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" BIGINT  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_family_abandonment" VARCHAR  -- Child Welfare > Family Abandonment,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" BIGINT  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" BIGINT  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" BIGINT  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_advice_unknown" BIGINT  -- Travel Advice > Unknown,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

58.89 kB
176 rows
83 columns

CREATE TABLE january_2023_fcdo_consular_mi (
  "jan_23" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "n_13" VARCHAR  -- 13,
  "n_14" VARCHAR  -- 14,
  "n_15" VARCHAR  -- 15,
  "n_16" VARCHAR  -- 16,
  "n_17" VARCHAR  -- 17,
  "n_18" VARCHAR  -- 18,
  "n_19" VARCHAR  -- 19,
  "n_20" VARCHAR  -- 20,
  "n_21" VARCHAR  -- 21,
  "n_22" VARCHAR  -- 22,
  "n_23" VARCHAR  -- 23,
  "n_24" VARCHAR  -- 24,
  "n_25" VARCHAR  -- 25,
  "n_26" VARCHAR  -- 26,
  "n_27" VARCHAR  -- 27,
  "n_28" VARCHAR  -- 28,
  "n_29" VARCHAR  -- 29,
  "n_30" VARCHAR  -- 30,
  "n_31" VARCHAR  -- 31,
  "n_32" VARCHAR  -- 32,
  "n_33" VARCHAR  -- 33,
  "n_34" VARCHAR  -- 34,
  "n_35" VARCHAR  -- 35,
  "n_36" VARCHAR  -- 36,
  "n_37" VARCHAR  -- 37,
  "n_38" VARCHAR  -- 38,
  "n_39" VARCHAR  -- 39,
  "n_40" VARCHAR  -- 40,
  "n_41" VARCHAR  -- 41,
  "n_42" VARCHAR  -- 42,
  "n_43" VARCHAR  -- 43,
  "n_44" VARCHAR  -- 44,
  "n_45" VARCHAR  -- 45,
  "n_46" VARCHAR  -- 46,
  "n_47" VARCHAR  -- 47,
  "n_48" VARCHAR  -- 48,
  "n_49" VARCHAR  -- 49,
  "n_50" VARCHAR  -- 50,
  "n_51" VARCHAR  -- 51,
  "n_52" VARCHAR  -- 52,
  "n_53" VARCHAR  -- 53,
  "n_54" VARCHAR  -- 54,
  "n_55" VARCHAR  -- 55,
  "n_56" VARCHAR  -- 56,
  "n_57" VARCHAR  -- 57,
  "n_58" VARCHAR  -- 58,
  "n_59" VARCHAR  -- 59,
  "n_60" VARCHAR  -- 60,
  "n_61" VARCHAR  -- 61,
  "n_62" VARCHAR  -- 62,
  "n_63" VARCHAR  -- 63,
  "n_64" VARCHAR  -- 64,
  "n_65" VARCHAR  -- 65,
  "n_66" VARCHAR  -- 66,
  "n_67" VARCHAR  -- 67,
  "n_68" VARCHAR  -- 68,
  "n_69" VARCHAR  -- 69,
  "n_70" VARCHAR  -- 70,
  "n_71" VARCHAR  -- 71,
  "n_72" VARCHAR  -- 72,
  "n_73" VARCHAR  -- 73,
  "n_74" VARCHAR  -- 74,
  "n_75" VARCHAR  -- 75,
  "n_76" VARCHAR  -- 76,
  "n_77" VARCHAR  -- 77,
  "n_2_1" VARCHAR  -- 2.1,
  "n_2_2" VARCHAR  -- 2.2,
  "n_2_3" VARCHAR  -- 2.3,
  "n_2_4" VARCHAR  -- 2.4,
  "n_3_1" VARCHAR  -- 3.1
);

July 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.july_2021_fcdo_consular_mi

68.17 kB
174 rows
83 columns

CREATE TABLE july_2021_fcdo_consular_mi (
  "jul_21" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" BIGINT  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_family_abandonment" BIGINT  -- Child Welfare > Family Abandonment,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" BIGINT  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" BIGINT  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" BIGINT  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" BIGINT  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" BIGINT  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_advice_unknown" BIGINT  -- Travel Advice > Unknown,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" BIGINT  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" BIGINT  -- Travel Documents > Emergency Passport,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

59.21 kB
175 rows
83 columns

CREATE TABLE july_2022_fcdo_consular_mi (
  "jul_22" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "n_13" VARCHAR  -- 13,
  "n_14" VARCHAR  -- 14,
  "n_15" VARCHAR  -- 15,
  "n_16" VARCHAR  -- 16,
  "n_17" VARCHAR  -- 17,
  "n_18" VARCHAR  -- 18,
  "n_19" VARCHAR  -- 19,
  "n_20" VARCHAR  -- 20,
  "n_21" VARCHAR  -- 21,
  "n_22" VARCHAR  -- 22,
  "n_23" VARCHAR  -- 23,
  "n_24" VARCHAR  -- 24,
  "n_25" VARCHAR  -- 25,
  "n_26" VARCHAR  -- 26,
  "n_27" VARCHAR  -- 27,
  "n_28" VARCHAR  -- 28,
  "n_29" VARCHAR  -- 29,
  "n_30" VARCHAR  -- 30,
  "n_31" VARCHAR  -- 31,
  "n_32" VARCHAR  -- 32,
  "n_33" VARCHAR  -- 33,
  "n_34" VARCHAR  -- 34,
  "n_35" VARCHAR  -- 35,
  "n_36" VARCHAR  -- 36,
  "n_37" VARCHAR  -- 37,
  "n_38" VARCHAR  -- 38,
  "n_39" VARCHAR  -- 39,
  "n_40" VARCHAR  -- 40,
  "n_41" VARCHAR  -- 41,
  "n_42" VARCHAR  -- 42,
  "n_43" VARCHAR  -- 43,
  "n_44" VARCHAR  -- 44,
  "n_45" VARCHAR  -- 45,
  "n_46" VARCHAR  -- 46,
  "n_47" VARCHAR  -- 47,
  "n_48" VARCHAR  -- 48,
  "n_49" VARCHAR  -- 49,
  "n_50" VARCHAR  -- 50,
  "n_51" VARCHAR  -- 51,
  "n_52" VARCHAR  -- 52,
  "n_53" VARCHAR  -- 53,
  "n_54" VARCHAR  -- 54,
  "n_55" VARCHAR  -- 55,
  "n_56" VARCHAR  -- 56,
  "n_57" VARCHAR  -- 57,
  "n_58" VARCHAR  -- 58,
  "n_59" VARCHAR  -- 59,
  "n_60" VARCHAR  -- 60,
  "n_61" VARCHAR  -- 61,
  "n_62" VARCHAR  -- 62,
  "n_63" VARCHAR  -- 63,
  "n_64" VARCHAR  -- 64,
  "n_65" VARCHAR  -- 65,
  "n_66" VARCHAR  -- 66,
  "n_67" VARCHAR  -- 67,
  "n_68" VARCHAR  -- 68,
  "n_69" VARCHAR  -- 69,
  "n_70" VARCHAR  -- 70,
  "n_71" VARCHAR  -- 71,
  "n_72" VARCHAR  -- 72,
  "n_73" VARCHAR  -- 73,
  "n_74" VARCHAR  -- 74,
  "n_75" VARCHAR  -- 75,
  "n_76" VARCHAR  -- 76,
  "n_77" VARCHAR  -- 77,
  "n_2_1" VARCHAR  -- 2.1,
  "n_2_2" VARCHAR  -- 2.2,
  "n_2_3" VARCHAR  -- 2.3,
  "n_2_4" VARCHAR  -- 2.4,
  "n_3_1" VARCHAR  -- 3.1
);

July 2023 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.july_2023_fcdo_consular_mi

63.34 kB
175 rows
83 columns

CREATE TABLE july_2023_fcdo_consular_mi (
  "jul_23" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82
);

June 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.june_2021_fcdo_consular_mi

68.27 kB
250 rows
83 columns

CREATE TABLE june_2021_fcdo_consular_mi (
  "june_21" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" DOUBLE  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" DOUBLE  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" DOUBLE  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" DOUBLE  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" DOUBLE  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_family_abandonment" DOUBLE  -- Child Welfare > Family Abandonment,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" VARCHAR  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" DOUBLE  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" DOUBLE  -- Commercial Dispute > Missing,
  "coroner_request_none" DOUBLE  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" DOUBLE  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" VARCHAR  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" DOUBLE  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" DOUBLE  -- Death In Custody > Suicide,
  "death_in_custody_unknown" VARCHAR  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" VARCHAR  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" DOUBLE  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" DOUBLE  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" DOUBLE  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" DOUBLE  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" DOUBLE  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" DOUBLE  -- Property > Fraud,
  "property_government" DOUBLE  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" DOUBLE  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_advice_unknown" DOUBLE  -- Travel Advice > Unknown,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_cancel_passport" DOUBLE  -- Travel Documents > Cancel Passport,
  "travel_documents_unknown" DOUBLE  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" DOUBLE  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" DOUBLE  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" DOUBLE  -- Welfare > Unknown,
  "whereabouts_none" DOUBLE  -- Whereabouts > None,
  "crisis_none" DOUBLE  -- Crisis > None,
  "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

59.04 kB
175 rows
83 columns

CREATE TABLE june_2022_fcdo_consular_mi (
  "jun_22" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "n_2" VARCHAR  -- 2,
  "n_3" VARCHAR  -- 3,
  "n_4" VARCHAR  -- 4,
  "n_5" VARCHAR  -- 5,
  "n_6" VARCHAR  -- 6,
  "n_7" VARCHAR  -- 7,
  "n_8" VARCHAR  -- 8,
  "n_9" VARCHAR  -- 9,
  "n_10" VARCHAR  -- 10,
  "n_11" VARCHAR  -- 11,
  "n_12" VARCHAR  -- 12,
  "n_13" VARCHAR  -- 13,
  "n_14" VARCHAR  -- 14,
  "n_15" VARCHAR  -- 15,
  "n_16" VARCHAR  -- 16,
  "n_17" VARCHAR  -- 17,
  "n_18" VARCHAR  -- 18,
  "n_19" VARCHAR  -- 19,
  "n_20" VARCHAR  -- 20,
  "n_21" VARCHAR  -- 21,
  "n_22" VARCHAR  -- 22,
  "n_23" VARCHAR  -- 23,
  "n_24" VARCHAR  -- 24,
  "n_25" VARCHAR  -- 25,
  "n_26" VARCHAR  -- 26,
  "n_27" VARCHAR  -- 27,
  "n_28" VARCHAR  -- 28,
  "n_29" VARCHAR  -- 29,
  "n_30" VARCHAR  -- 30,
  "n_31" VARCHAR  -- 31,
  "n_32" VARCHAR  -- 32,
  "n_33" VARCHAR  -- 33,
  "n_34" VARCHAR  -- 34,
  "n_35" VARCHAR  -- 35,
  "n_36" VARCHAR  -- 36,
  "n_37" VARCHAR  -- 37,
  "n_38" VARCHAR  -- 38,
  "n_39" VARCHAR  -- 39,
  "n_40" VARCHAR  -- 40,
  "n_41" VARCHAR  -- 41,
  "n_42" VARCHAR  -- 42,
  "n_43" VARCHAR  -- 43,
  "n_44" VARCHAR  -- 44,
  "n_45" VARCHAR  -- 45,
  "n_46" VARCHAR  -- 46,
  "n_47" VARCHAR  -- 47,
  "n_48" VARCHAR  -- 48,
  "n_49" VARCHAR  -- 49,
  "n_50" VARCHAR  -- 50,
  "n_51" VARCHAR  -- 51,
  "n_52" VARCHAR  -- 52,
  "n_53" VARCHAR  -- 53,
  "n_54" VARCHAR  -- 54,
  "n_55" VARCHAR  -- 55,
  "n_56" VARCHAR  -- 56,
  "n_57" VARCHAR  -- 57,
  "n_58" VARCHAR  -- 58,
  "n_59" VARCHAR  -- 59,
  "n_60" VARCHAR  -- 60,
  "n_61" VARCHAR  -- 61,
  "n_62" VARCHAR  -- 62,
  "n_63" VARCHAR  -- 63,
  "n_64" VARCHAR  -- 64,
  "n_65" VARCHAR  -- 65,
  "n_66" VARCHAR  -- 66,
  "n_67" VARCHAR  -- 67,
  "n_68" VARCHAR  -- 68,
  "n_69" VARCHAR  -- 69,
  "n_70" VARCHAR  -- 70,
  "n_71" VARCHAR  -- 71,
  "n_72" VARCHAR  -- 72,
  "n_73" VARCHAR  -- 73,
  "n_74" VARCHAR  -- 74,
  "n_75" VARCHAR  -- 75,
  "n_76" VARCHAR  -- 76,
  "n_77" VARCHAR  -- 77,
  "n_2_1" VARCHAR  -- 2.1,
  "n_2_2" VARCHAR  -- 2.2,
  "n_2_3" VARCHAR  -- 2.3,
  "n_2_4" VARCHAR  -- 2.4,
  "n_3_1" VARCHAR  -- 3.1
);

June 2023 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.june_2023_fcdo_consular_mi

63.35 kB
175 rows
83 columns

CREATE TABLE june_2023_fcdo_consular_mi (
  "jun_23" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82
);

March 2021 FCDO Consular MI

@ukgov.https_www_gov_uk_government_publications_foreign_commo_9196cafe.march_2021_fcdo_consular_mi

67.79 kB
174 rows
83 columns

CREATE TABLE march_2021_fcdo_consular_mi (
  "mar_21" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" BIGINT  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_family_abandonment" VARCHAR  -- Child Welfare > Family Abandonment,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" BIGINT  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" BIGINT  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" BIGINT  -- Female Genital Mutilation > None,
  "forced_marriage_none" VARCHAR  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" BIGINT  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" BIGINT  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_advice_unknown" BIGINT  -- Travel Advice > Unknown,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" VARCHAR  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" BIGINT  -- Travel Documents > Emergency Passport,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "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

68.07 kB
174 rows
83 columns

CREATE TABLE march_2022_fcdo_consular_mi (
  "mar_22" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" BIGINT  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_child_in_care" VARCHAR  -- Child Welfare > Child In Care,
  "child_welfare_child_working_licence" VARCHAR  -- Child Welfare > Child Working Licence,
  "child_welfare_family_abandonment" VARCHAR  -- Child Welfare > Family Abandonment,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_surrogacy" BIGINT  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" BIGINT  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_infectious_disease" VARCHAR  -- Death > Infectious Disease,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_hospital_death" BIGINT  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" BIGINT  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" BIGINT  -- Female Genital Mutilation > None,
  "forced_marriage_none" BIGINT  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" BIGINT  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" BIGINT  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" VARCHAR  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_advice_unknown" BIGINT  -- Travel Advice > Unknown,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "travel_documents_emergency_travel_document" BIGINT  -- Travel Documents > Emergency Travel Document,
  "travel_documents_emergency_passport" VARCHAR  -- Travel Documents > Emergency Passport,
  "travel_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "travel_documents_unknown" BIGINT  -- Travel Documents > Unknown,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" BIGINT  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" VARCHAR  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);