About this Dataset

Consular Management Information

FCO Consular Management Information (MI) Data from various sources (including Compass, BRIDGE, and the Online Monthly Collection Sheet (OMCS) returns). It is used to allow Consular to retrieve statistics on case numbers, types etc, and provides the data for the British Behaviour Abroad Report. It is held on the Jedox database.
Publisher name: Foreign and Commonwealth Office
Last updated: 2022-07-01T04:04:17Z

Tables

Consular MI December 2018

@ukgov.consular_management_information_1.consular_mi_december_2018

61.99 kB
309 rows
72 columns

CREATE TABLE consular_mi_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
);

Consular MI October 2018

@ukgov.consular_management_information_1.consular_mi_october_2018

62.14 kB
309 rows
72 columns

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

FCO Consular Management Information February 2019

@ukgov.consular_management_information_1.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 January 2019

@ukgov.consular_management_information_1.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 March 2019

@ukgov.consular_management_information_1.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 May 2019

@ukgov.consular_management_information_1.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 MI November 2018

@ukgov.consular_management_information_1.fco_consular_mi_november_2018

62.04 kB
309 rows
72 columns

CREATE TABLE fco_consular_mi_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
);