About this Dataset

Foreign And Commonwealth Office (FCO) Consular Management Information Data

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

Tables

FCO Consular Management Information April 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_april_2019

73.01 kB
173 rows
88 columns

CREATE TABLE fco_consular_management_information_april_2019 (
  "apr_19" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" BIGINT  -- 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" BIGINT  -- 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" VARCHAR  -- 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_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_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" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" VARCHAR  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" BIGINT  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information April 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_april_2020

68.79 kB
250 rows
83 columns

CREATE TABLE fco_consular_management_information_april_2020 (
  "apr_20" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" DOUBLE  -- 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" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" DOUBLE  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_other" VARCHAR  -- Arrest/Detention > Other,
  "arrest_detention_sex_not_child" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" DOUBLE  -- Child Welfare > Unknown,
  "commercial_dispute_none" DOUBLE  -- Commercial Dispute > None,
  "commercial_dispute_missing" DOUBLE  -- Commercial Dispute > Missing,
  "coroner_request_none" DOUBLE  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" DOUBLE  -- 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" DOUBLE  -- 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" VARCHAR  -- 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" DOUBLE  -- 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
);

FCO Consular Management Information August 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_august_2019

72.43 kB
173 rows
87 columns

CREATE TABLE fco_consular_management_information_august_2019 (
  "aug_19" 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_sex_not_child" BIGINT  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" BIGINT  -- 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_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" BIGINT  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" VARCHAR  -- Child Welfare > Unknown,
  "commercial_dispute_none" BIGINT  -- Commercial Dispute > None,
  "commercial_dispute_missing" VARCHAR  -- Commercial Dispute > Missing,
  "coroner_request_none" VARCHAR  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" BIGINT  -- Death > Drowning,
  "death_execution" VARCHAR  -- 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" VARCHAR  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "diplomatic_claim_none" BIGINT  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" VARCHAR  -- Female Genital Mutilation > None,
  "forced_marriage_none" BIGINT  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" VARCHAR  -- Forced Marriage - Reluctant Sponsor > None,
  "hospitalisation_dementia" BIGINT  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" BIGINT  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" VARCHAR  -- Hospitalisation > Unknown,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "mistreatment_torture_none" BIGINT  -- Mistreatment & Torture > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" VARCHAR  -- Property > Government,
  "property_other" BIGINT  -- Property > Other,
  "property_unknown" VARCHAR  -- Property > Unknown,
  "travel_ban_none" BIGINT  -- Travel Ban > None,
  "travel_documents_cancel_passport" VARCHAR  -- Travel Documents > Cancel Passport,
  "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_unknown" VARCHAR  -- 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" 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" BIGINT  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" VARCHAR  -- Victim Of Crime > Unknown,
  "welfare_health" VARCHAR  -- Welfare > Health,
  "welfare_financial_issues" BIGINT  -- Welfare > Financial Issues,
  "welfare_immigration" VARCHAR  -- Welfare > Immigration,
  "welfare_unknown" BIGINT  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" VARCHAR  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" VARCHAR  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" BIGINT  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" VARCHAR  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" BIGINT  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" VARCHAR  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" VARCHAR  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" BIGINT  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information August 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_august_2020

68.92 kB
250 rows
83 columns

CREATE TABLE fco_consular_management_information_august_2020 (
  "aug_20" 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" 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" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" DOUBLE  -- Death In Custody > Natural Death,
  "diplomatic_claim_none" DOUBLE  -- Diplomatic Claim > None,
  "female_genital_mutilation_none" DOUBLE  -- Female Genital Mutilation > None,
  "forced_marriage_none" DOUBLE  -- Forced Marriage > None,
  "forced_marriage_reluctant_sponsor_none" DOUBLE  -- 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" 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" DOUBLE  -- 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
);

FCO Consular Management Information By Country January - December 2018

@ukgov.foreign_office_consular_data.fco_consular_management_information_by_country_january_6f41f4c8

78.24 kB
173 rows
88 columns

CREATE TABLE fco_consular_management_information_by_country_january_6f41f4c8 (
  "n_2018" VARCHAR  -- 2018,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" BIGINT  -- 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_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "death_in_custody_sudden_death" VARCHAR  -- 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" VARCHAR  -- 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" VARCHAR  -- 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_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_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" VARCHAR  -- Whereabouts > None,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" VARCHAR  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" VARCHAR  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" VARCHAR  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" BIGINT  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information December 2018

@ukgov.foreign_office_consular_data.fco_consular_management_information_december_2018

61.99 kB
309 rows
72 columns

CREATE TABLE fco_consular_management_information_december_2018 (
  "dec_18" 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_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" BIGINT  -- Arrest/Detention > Murder / Manslaughter,
  "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,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" BIGINT,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "death_in_custody_suicide" BIGINT  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "diplomatic_claim" BIGINT,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT  -- Forced Marriage - Reluctant Sponsor,
  "hospitalisation_dementia" BIGINT  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "property_fraud" VARCHAR  -- Property > Fraud,
  "property_government" BIGINT  -- Property > Government,
  "property_other" BIGINT  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT,
  "welfare" VARCHAR,
  "whereabouts" BIGINT,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency - Unknown,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);

FCO Consular Management Information December 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_december_2019

71.26 kB
173 rows
86 columns

CREATE TABLE fco_consular_management_information_december_2019 (
  "dec_19" 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_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_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "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_natural_death" BIGINT  -- 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" 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" 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_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_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,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" BIGINT  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" VARCHAR  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information February 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_february_2019

73.03 kB
173 rows
88 columns

CREATE TABLE fco_consular_management_information_february_2019 (
  "feb_19" 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_general" VARCHAR  -- Arrest/Detention > General,
  "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_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_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" VARCHAR  -- 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_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" VARCHAR  -- Death In Custody > Unknown,
  "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_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "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_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" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" VARCHAR  -- Whereabouts > None,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" BIGINT  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" VARCHAR  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" BIGINT  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" BIGINT  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information February 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_february_2020

61.6 kB
174 rows
86 columns

CREATE TABLE fco_consular_management_information_february_2020 (
  "feb_20" VARCHAR,
  "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_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_78" VARCHAR  -- 78,
  "n_79" VARCHAR  -- 79,
  "n_80" VARCHAR  -- 80,
  "n_81" VARCHAR  -- 81,
  "n_82" VARCHAR  -- 82,
  "n_83" VARCHAR  -- 83,
  "n_84" VARCHAR  -- 84,
  "n_85" VARCHAR  -- 85,
  "n_86" VARCHAR  -- 86,
  "n_87" VARCHAR  -- 87,
  "n_88" VARCHAR  -- 88,
  "n_89" VARCHAR  -- 89,
  "n_90" VARCHAR  -- 90,
  "n_91" VARCHAR  -- 91,
  "n_92" VARCHAR  -- 92,
  "n_93" VARCHAR  -- 93,
  "n_94" VARCHAR  -- 94,
  "n_95" VARCHAR  -- 95,
  "n_96" VARCHAR  -- 96,
  "n_97" VARCHAR  -- 97,
  "n_98" VARCHAR  -- 98,
  "n_99" VARCHAR  -- 99,
  "n_100" VARCHAR  -- 100,
  "n_101" VARCHAR  -- 101,
  "n_102" VARCHAR  -- 102,
  "n_103" VARCHAR  -- 103,
  "n_104" VARCHAR  -- 104,
  "n_105" VARCHAR  -- 105,
  "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
);

FCO Consular Management Information January 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_january_2019

73.41 kB
173 rows
88 columns

CREATE TABLE fco_consular_management_information_january_2019 (
  "jan_19" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "coroner_request_none" VARCHAR  -- 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" 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_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "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_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" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" VARCHAR  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" BIGINT  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" BIGINT  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information January 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_january_2020

72.26 kB
173 rows
86 columns

CREATE TABLE fco_consular_management_information_january_2020 (
  "https_www_gov_uk_government_publications_open_strategy_refresh" VARCHAR  -- Https://www.gov.uk/government/publications/open-data-strategy-refresh,
  "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_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_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "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" BIGINT  -- 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" VARCHAR  -- 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" 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" 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_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_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" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" BIGINT  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" BIGINT  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" BIGINT  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information January-December 2018

@ukgov.foreign_office_consular_data.fco_consular_management_information_january_december_2018

68.39 kB
309 rows
72 columns

CREATE TABLE fco_consular_management_information_january_december_2018 (
  "n_2018" VARCHAR  -- 2018,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_unknown" BIGINT,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" BIGINT,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "death_in_custody_suicide" VARCHAR  -- Death In Custody > Suicide,
  "death_in_custody_unknown" VARCHAR  -- Death In Custody > Unknown,
  "diplomatic_claim" VARCHAR,
  "female_genital_mutilation" VARCHAR,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT  -- Forced Marriage - Reluctant Sponsor,
  "hospitalisation_dementia" VARCHAR  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_unknown" VARCHAR,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "property_fraud" VARCHAR  -- Property > Fraud,
  "property_government" VARCHAR  -- Property > Government,
  "property_unknown" BIGINT  -- Property > Unknown,
  "property_other" VARCHAR  -- Property > Other,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_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_unknown" BIGINT,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "welfare" VARCHAR,
  "whereabouts" VARCHAR,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" VARCHAR  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" VARCHAR  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency - Unknown,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" BIGINT,
  "fee_bearing_services" VARCHAR
);

FCO Consular Management Information January - December 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_january_december_2019

69.98 kB
174 rows
80 columns

CREATE TABLE fco_consular_management_information_january_december_2019 (
  "n_2019" VARCHAR  -- 2019,
  "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" BIGINT  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" VARCHAR  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" VARCHAR  -- Commercial Dispute > Missing,
  "coroner_request_none" VARCHAR  -- 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" 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" 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" VARCHAR  -- Whereabouts > None,
  "crisis_none" BIGINT  -- Crisis > None,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information July 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_july_2019

91.94 kB
173 rows
112 columns

CREATE TABLE fco_consular_management_information_july_2019 (
  "jul_19" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" 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_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "compass_advice_and_self_help" BIGINT  -- COMPASS > Advice And Self Help,
  "compass_asylum" BIGINT  -- COMPASS > Asylum,
  "compass_citizenship_application" BIGINT  -- COMPASS > Citizenship Application,
  "compass_deportation" BIGINT  -- COMPASS > Deportation,
  "compass_dispute" BIGINT  -- COMPASS > Dispute,
  "compass_evacuation" BIGINT  -- COMPASS > Evacuation,
  "compass_extradition" BIGINT  -- COMPASS > Extradition,
  "compass_financial_transaction" BIGINT  -- COMPASS > Financial Transaction,
  "compass_fraud" BIGINT  -- COMPASS > Fraud,
  "compass_immigration_service" BIGINT  -- COMPASS > Immigration Service,
  "compass_information_local" BIGINT  -- COMPASS > Information (Local),
  "compass_information_uk" BIGINT  -- COMPASS > Information (UK),
  "compass_injury" BIGINT  -- COMPASS > Injury,
  "compass_legal_service" BIGINT  -- COMPASS > Legal Service,
  "compass_loss" BIGINT  -- COMPASS > Loss,
  "compass_medical" BIGINT  -- COMPASS > Medical,
  "compass_miscellaneous" BIGINT  -- COMPASS > Miscellaneous,
  "compass_nationality" BIGINT  -- COMPASS > Nationality,
  "compass_repatriation" BIGINT  -- COMPASS > Repatriation,
  "compass_shipping" BIGINT  -- COMPASS > Shipping,
  "compass_surrogacy" BIGINT  -- COMPASS > Surrogacy,
  "compass_theft" BIGINT  -- COMPASS > Theft,
  "compass_welfare_whereabouts" BIGINT  -- COMPASS > Welfare/Whereabouts,
  "compass_unknown" BIGINT  -- COMPASS > Unknown,
  "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" VARCHAR  -- 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" 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_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "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_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" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "accident_emergency_air_incident" VARCHAR  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident
);

FCO Consular Management Information July 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_july_2020

68.86 kB
250 rows
83 columns

CREATE TABLE fco_consular_management_information_july_2020 (
  "jul_20" 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" 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" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- 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
);

FCO Consular Management Information June 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_june_2019

91.7 kB
173 rows
112 columns

CREATE TABLE fco_consular_management_information_june_2019 (
  "jun_19" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" BIGINT  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" BIGINT  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" BIGINT  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "compass_advice_and_self_help" BIGINT  -- COMPASS > Advice And Self Help,
  "compass_asylum" BIGINT  -- COMPASS > Asylum,
  "compass_citizenship_application" BIGINT  -- COMPASS > Citizenship Application,
  "compass_deportation" BIGINT  -- COMPASS > Deportation,
  "compass_dispute" BIGINT  -- COMPASS > Dispute,
  "compass_evacuation" BIGINT  -- COMPASS > Evacuation,
  "compass_extradition" BIGINT  -- COMPASS > Extradition,
  "compass_financial_transaction" BIGINT  -- COMPASS > Financial Transaction,
  "compass_fraud" BIGINT  -- COMPASS > Fraud,
  "compass_immigration_service" BIGINT  -- COMPASS > Immigration Service,
  "compass_information_local" BIGINT  -- COMPASS > Information (Local),
  "compass_information_uk" BIGINT  -- COMPASS > Information (UK),
  "compass_injury" BIGINT  -- COMPASS > Injury,
  "compass_legal_service" BIGINT  -- COMPASS > Legal Service,
  "compass_loss" BIGINT  -- COMPASS > Loss,
  "compass_medical" BIGINT  -- COMPASS > Medical,
  "compass_miscellaneous" BIGINT  -- COMPASS > Miscellaneous,
  "compass_nationality" BIGINT  -- COMPASS > Nationality,
  "compass_repatriation" BIGINT  -- COMPASS > Repatriation,
  "compass_shipping" BIGINT  -- COMPASS > Shipping,
  "compass_surrogacy" BIGINT  -- COMPASS > Surrogacy,
  "compass_theft" BIGINT  -- COMPASS > Theft,
  "compass_welfare_whereabouts" BIGINT  -- COMPASS > Welfare/Whereabouts,
  "compass_unknown" BIGINT  -- COMPASS > Unknown,
  "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_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_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,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident
);

FCO Consular Management Information June 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_june_2020

68.82 kB
250 rows
83 columns

CREATE TABLE fco_consular_management_information_june_2020 (
  "jun_20" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" DOUBLE  -- 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" 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" DOUBLE  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" DOUBLE  -- Child Welfare > Unknown,
  "commercial_dispute_none" DOUBLE  -- 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" DOUBLE  -- Death In Custody > Hospital Death,
  "death_in_custody_sudden_death" DOUBLE  -- Death In Custody > Sudden Death,
  "death_in_custody_suicide" VARCHAR  -- Death In Custody > Suicide,
  "death_in_custody_unknown" DOUBLE  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" DOUBLE  -- 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" DOUBLE  -- 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
);

FCO Consular Management Information March 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_march_2019

73.25 kB
173 rows
88 columns

CREATE TABLE fco_consular_management_information_march_2019 (
  "mar_19" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" 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_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "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" BIGINT  -- 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_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_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" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" VARCHAR  -- Whereabouts > None,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" VARCHAR  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" BIGINT  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" BIGINT  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information March 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_march_2020

71.97 kB
173 rows
86 columns

CREATE TABLE fco_consular_management_information_march_2020 (
  "mar_20" 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_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_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "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" VARCHAR  -- 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" 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_documents_cancel_passport" BIGINT  -- Travel Documents > Cancel Passport,
  "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_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,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" BIGINT  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" BIGINT  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" BIGINT  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information May 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_may_2019

72.16 kB
173 rows
88 columns

CREATE TABLE fco_consular_management_information_may_2019 (
  "may_19" VARCHAR,
  "arrest_detention_assault" VARCHAR  -- Arrest/Detention > Assault,
  "arrest_detention_assault_with_weapon" VARCHAR  -- Arrest/Detention > Assault With Weapon,
  "arrest_detention_child_pornography" VARCHAR  -- Arrest/Detention > Child Pornography,
  "arrest_detention_child_sex" VARCHAR  -- Arrest/Detention > Child Sex,
  "arrest_detention_drugs" VARCHAR  -- Arrest/Detention > Drugs,
  "arrest_detention_fraud" VARCHAR  -- Arrest/Detention > Fraud,
  "arrest_detention_general" VARCHAR  -- Arrest/Detention > General,
  "arrest_detention_immigration" VARCHAR  -- Arrest/Detention > Immigration,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR  -- Arrest/Detention > Modern Slavery / Human Trafficking,
  "arrest_detention_murder_manslaughter" VARCHAR  -- Arrest/Detention > Murder / Manslaughter,
  "arrest_detention_sex_not_child" VARCHAR  -- Arrest/Detention > Sex (not Child),
  "arrest_detention_terrorism" VARCHAR  -- Arrest/Detention > Terrorism,
  "arrest_detention_theft" VARCHAR  -- Arrest/Detention > Theft,
  "arrest_detention_unknown" VARCHAR  -- Arrest/Detention > Unknown,
  "child_welfare_child_abandonment" VARCHAR  -- Child Welfare > Child Abandonment,
  "child_welfare_child_custody" VARCHAR  -- Child Welfare > Child Custody,
  "child_welfare_child_safeguarding" VARCHAR  -- Child Welfare > Child Safeguarding,
  "child_welfare_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" VARCHAR  -- Child Welfare > Unknown,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" VARCHAR  -- Commercial Dispute > Missing,
  "coroner_request_none" VARCHAR  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" VARCHAR  -- 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" VARCHAR  -- 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" VARCHAR  -- 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" VARCHAR  -- 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" VARCHAR  -- Property > Unknown,
  "travel_ban_none" VARCHAR  -- Travel Ban > None,
  "travel_documents_cancel_passport" VARCHAR  -- Travel Documents > Cancel Passport,
  "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_unknown" VARCHAR  -- 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" VARCHAR  -- 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" VARCHAR  -- Whereabouts > None,
  "accident_emergency_air_incident" VARCHAR  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" VARCHAR  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" VARCHAR  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" VARCHAR  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" VARCHAR  -- Accident/Emergency > Unknown,
  "crisis_none" VARCHAR  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" VARCHAR  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" VARCHAR  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information May 2020

@ukgov.foreign_office_consular_data.fco_consular_management_information_may_2020

68.39 kB
250 rows
83 columns

CREATE TABLE fco_consular_management_information_may_2020 (
  "may_20" 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" 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" DOUBLE  -- Child Welfare > Surrogacy,
  "child_welfare_unknown" DOUBLE  -- Child Welfare > Unknown,
  "commercial_dispute_none" DOUBLE  -- Commercial Dispute > None,
  "commercial_dispute_missing" DOUBLE  -- Commercial Dispute > Missing,
  "coroner_request_none" DOUBLE  -- Coroner Request > None,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" DOUBLE  -- 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" DOUBLE  -- Death In Custody > Unknown,
  "death_in_custody_natural_death" DOUBLE  -- 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" VARCHAR  -- Property > Government,
  "property_other" DOUBLE  -- 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
);

FCO Consular Management Information November 2018

@ukgov.foreign_office_consular_data.fco_consular_management_information_november_2018

62.04 kB
309 rows
72 columns

CREATE TABLE fco_consular_management_information_november_2018 (
  "nov_18" 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_general" VARCHAR  -- Arrest/Detention > General,
  "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_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,
  "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_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "child_welfare_unknown" BIGINT,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR  -- Death > Accidental,
  "death_drowning" VARCHAR  -- Death > Drowning,
  "death_execution" BIGINT  -- Death > Execution,
  "death_hospital_death" VARCHAR  -- Death > Hospital Death,
  "death_murder_or_manslaughter" VARCHAR  -- Death > Murder Or Manslaughter,
  "death_natural_death" VARCHAR  -- Death > Natural Death,
  "death_rta" VARCHAR  -- Death > RTA,
  "death_suicide" VARCHAR  -- Death > Suicide,
  "death_unknown" VARCHAR  -- Death > Unknown,
  "death_in_custody_natural_death" BIGINT  -- Death In Custody > Natural Death,
  "death_in_custody_suicide" VARCHAR  -- Death In Custody > Suicide,
  "death_in_custody_unknown" BIGINT  -- Death In Custody > Unknown,
  "diplomatic_claim" BIGINT,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT  -- Forced Marriage - Reluctant Sponsor,
  "hospitalisation_dementia" BIGINT  -- Hospitalisation > Dementia,
  "hospitalisation_disability" VARCHAR  -- Hospitalisation > Disability,
  "hospitalisation_mental_health" VARCHAR  -- Hospitalisation > Mental Health,
  "hospitalisation_physical_health" VARCHAR  -- Hospitalisation > Physical Health,
  "hospitalisation_unknown" BIGINT,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR  -- Missing Persons > None,
  "property_fraud" BIGINT  -- Property > Fraud,
  "property_government" VARCHAR  -- Property > Government,
  "property_other" VARCHAR  -- Property > Other,
  "property_unknown" BIGINT  -- Property > Unknown,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR  -- Travel Documents > Lost/Stolen Passport,
  "travel_documents_recovered_passport" VARCHAR  -- Travel Documents > Recovered Passport,
  "victim_of_crime_assault" VARCHAR  -- Victim Of Crime > Assault,
  "victim_of_crime_domestic_abuse" VARCHAR  -- Victim Of Crime > Domestic Abuse,
  "victim_of_crime_held_against_will" VARCHAR  -- Victim Of Crime > Held Against Will,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT  -- Victim Of Crime > Modern Slavery/Human Trafficking,
  "victim_of_crime_rape_sexual_assault" VARCHAR  -- Victim Of Crime > Rape & Sexual Assault,
  "victim_of_crime_theft" VARCHAR  -- Victim Of Crime > Theft,
  "victim_of_crime_unknown" BIGINT,
  "welfare" VARCHAR,
  "whereabouts" BIGINT,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency - Unknown,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);

FCO Consular Management Information November 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_november_2019

71.76 kB
173 rows
86 columns

CREATE TABLE fco_consular_management_information_november_2019 (
  "nov_19" 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_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_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "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_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" 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" 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_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_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" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" BIGINT  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" BIGINT  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" BIGINT  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information October 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_october_2019

71.88 kB
173 rows
86 columns

CREATE TABLE fco_consular_management_information_october_2019 (
  "oct_19" 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_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_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "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" 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" 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" 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_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_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" VARCHAR  -- Welfare > Unknown,
  "whereabouts_none" BIGINT  -- Whereabouts > None,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" VARCHAR  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" BIGINT  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown,
  "crisis_none" BIGINT  -- Crisis > None,
  "financial_transactions_undertaking_to_repay" VARCHAR  -- Financial Transactions > Undertaking To Repay,
  "financial_transactions_payment" BIGINT  -- Financial Transactions > Payment,
  "financial_transactions_request_for_financial_assistance" VARCHAR  -- Financial Transactions > Request For Financial Assistance,
  "financial_transactions_request_for_a_vulnerable_person_0a12649f" VARCHAR  -- Financial Transactions > Request For A Vulnerable Persons Fund (VPF) Grant,
  "consular_enquiries" VARCHAR,
  "fees" VARCHAR,
  "emergency_travel_documents" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR
);

FCO Consular Management Information September 2019

@ukgov.foreign_office_consular_data.fco_consular_management_information_september_2019

90.14 kB
173 rows
110 columns

CREATE TABLE fco_consular_management_information_september_2019 (
  "sep_19" 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_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_parental_child_abduction" VARCHAR  -- Child Welfare > Parental Child Abduction,
  "commercial_dispute_none" VARCHAR  -- Commercial Dispute > None,
  "commercial_dispute_missing" BIGINT  -- Commercial Dispute > Missing,
  "compass_advice_and_self_help" BIGINT  -- COMPASS > Advice And Self Help,
  "compass_asylum" BIGINT  -- COMPASS > Asylum,
  "compass_citizenship_application" BIGINT  -- COMPASS > Citizenship Application,
  "compass_deportation" BIGINT  -- COMPASS > Deportation,
  "compass_dispute" BIGINT  -- COMPASS > Dispute,
  "compass_evacuation" BIGINT  -- COMPASS > Evacuation,
  "compass_extradition" BIGINT  -- COMPASS > Extradition,
  "compass_financial_transaction" BIGINT  -- COMPASS > Financial Transaction,
  "compass_fraud" BIGINT  -- COMPASS > Fraud,
  "compass_immigration_service" BIGINT  -- COMPASS > Immigration Service,
  "compass_information_local" BIGINT  -- COMPASS > Information (Local),
  "compass_information_uk" BIGINT  -- COMPASS > Information (UK),
  "compass_injury" BIGINT  -- COMPASS > Injury,
  "compass_legal_service" BIGINT  -- COMPASS > Legal Service,
  "compass_loss" BIGINT  -- COMPASS > Loss,
  "compass_medical" BIGINT  -- COMPASS > Medical,
  "compass_miscellaneous" BIGINT  -- COMPASS > Miscellaneous,
  "compass_nationality" BIGINT  -- COMPASS > Nationality,
  "compass_repatriation" BIGINT  -- COMPASS > Repatriation,
  "compass_shipping" BIGINT  -- COMPASS > Shipping,
  "compass_surrogacy" BIGINT  -- COMPASS > Surrogacy,
  "compass_theft" BIGINT  -- COMPASS > Theft,
  "compass_welfare_whereabouts" BIGINT  -- COMPASS > Welfare/Whereabouts,
  "compass_unknown" BIGINT  -- COMPASS > Unknown,
  "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" BIGINT  -- 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" VARCHAR  -- 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_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_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,
  "accident_emergency_air_incident" BIGINT  -- Accident/Emergency > Air Incident,
  "accident_emergency_coach_crash" BIGINT  -- Accident/Emergency > Coach Crash,
  "accident_emergency_natural_disaster" BIGINT  -- Accident/Emergency > Natural Disaster,
  "accident_emergency_road_traffic_accident" VARCHAR  -- Accident/Emergency > Road Traffic Accident,
  "accident_emergency_terrorist_incident" BIGINT  -- Accident/Emergency > Terrorist Incident,
  "accident_emergency_unknown" BIGINT  -- Accident/Emergency > Unknown
);