Baselight
Sign In

Consular Management Information

Foreign and Commonwealth Office

@ukgov.consular_management_information_1

Loading...
Loading...

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
  • 60.53 KB
  • 309 rows
  • 72 columns
Loading... 

CREATE TABLE consular_mi_december_2018 (
  "dec_18" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" BIGINT,
  "arrest_detention_child_sex" VARCHAR,
  "arrest_detention_drugs" VARCHAR,
  "arrest_detention_fraud" VARCHAR,
  "arrest_detention_general" VARCHAR,
  "arrest_detention_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" BIGINT,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" VARCHAR,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_unknown" BIGINT,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim" BIGINT,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT,
  "hospitalisation_dementia" BIGINT,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" BIGINT,
  "property_other" BIGINT,
  "property_unknown" BIGINT,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "victim_of_crime_assault" VARCHAR,
  "victim_of_crime_domestic_abuse" VARCHAR,
  "victim_of_crime_held_against_will" VARCHAR,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "welfare" VARCHAR,
  "whereabouts" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);

Consular MI October 2018

@ukgov.consular_management_information_1.consular_mi_october_2018
  • 60.69 KB
  • 309 rows
  • 72 columns
Loading... 

CREATE TABLE consular_mi_october_2018 (
  "oct_18" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" VARCHAR,
  "arrest_detention_child_sex" VARCHAR,
  "arrest_detention_drugs" VARCHAR,
  "arrest_detention_fraud" VARCHAR,
  "arrest_detention_general" VARCHAR,
  "arrest_detention_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" BIGINT,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" VARCHAR,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" VARCHAR,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_unknown" BIGINT,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_suicide" BIGINT,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim" VARCHAR,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT,
  "hospitalisation_dementia" VARCHAR,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR,
  "property_fraud" VARCHAR,
  "property_government" BIGINT,
  "property_other" BIGINT,
  "property_unknown" BIGINT,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "victim_of_crime_assault" VARCHAR,
  "victim_of_crime_domestic_abuse" VARCHAR,
  "victim_of_crime_held_against_will" VARCHAR,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "welfare" VARCHAR,
  "whereabouts" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" VARCHAR,
  "accident_emergency_road_traffic_accident" BIGINT,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);

FCO Consular Management Information February 2019

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

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

FCO Consular Management Information January 2019

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

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

FCO Consular Management Information March 2019

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

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

FCO Consular Management Information May 2019

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

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

FCO Consular MI November 2018

@ukgov.consular_management_information_1.fco_consular_mi_november_2018
  • 60.58 KB
  • 309 rows
  • 72 columns
Loading... 

CREATE TABLE fco_consular_mi_november_2018 (
  "nov_18" VARCHAR,
  "arrest_detention_assault" VARCHAR,
  "arrest_detention_assault_with_weapon" VARCHAR,
  "arrest_detention_child_pornography" BIGINT,
  "arrest_detention_child_sex" VARCHAR,
  "arrest_detention_drugs" VARCHAR,
  "arrest_detention_fraud" VARCHAR,
  "arrest_detention_general" VARCHAR,
  "arrest_detention_immigration" VARCHAR,
  "arrest_detention_modern_slavery_human_trafficking" VARCHAR,
  "arrest_detention_murder_manslaughter" VARCHAR,
  "arrest_detention_sex_not_child" VARCHAR,
  "arrest_detention_terrorism" BIGINT,
  "arrest_detention_theft" VARCHAR,
  "arrest_detention_unknown" BIGINT,
  "child_welfare_child_abandonment" BIGINT,
  "child_welfare_child_custody" VARCHAR,
  "child_welfare_child_safeguarding" VARCHAR,
  "child_welfare_parental_child_abduction" VARCHAR,
  "child_welfare_unknown" BIGINT,
  "commercial_dispute" VARCHAR,
  "coroner_request" BIGINT,
  "death_accidental" VARCHAR,
  "death_drowning" VARCHAR,
  "death_execution" BIGINT,
  "death_hospital_death" VARCHAR,
  "death_murder_or_manslaughter" VARCHAR,
  "death_natural_death" VARCHAR,
  "death_rta" VARCHAR,
  "death_suicide" VARCHAR,
  "death_unknown" VARCHAR,
  "death_in_custody_natural_death" BIGINT,
  "death_in_custody_suicide" VARCHAR,
  "death_in_custody_unknown" BIGINT,
  "diplomatic_claim" BIGINT,
  "female_genital_mutilation" BIGINT,
  "forced_marriage" VARCHAR,
  "forced_marriage_reluctant_sponsor" BIGINT,
  "hospitalisation_dementia" BIGINT,
  "hospitalisation_disability" VARCHAR,
  "hospitalisation_mental_health" VARCHAR,
  "hospitalisation_physical_health" VARCHAR,
  "hospitalisation_unknown" BIGINT,
  "missing_persons" VARCHAR,
  "missing_persons_none" VARCHAR,
  "property_fraud" BIGINT,
  "property_government" VARCHAR,
  "property_other" VARCHAR,
  "property_unknown" BIGINT,
  "travel_ban" VARCHAR,
  "travel_documents_lost_stolen_passport" VARCHAR,
  "travel_documents_recovered_passport" VARCHAR,
  "victim_of_crime_assault" VARCHAR,
  "victim_of_crime_domestic_abuse" VARCHAR,
  "victim_of_crime_held_against_will" VARCHAR,
  "victim_of_crime_modern_slavery_human_trafficking" BIGINT,
  "victim_of_crime_rape_sexual_assault" VARCHAR,
  "victim_of_crime_theft" VARCHAR,
  "victim_of_crime_unknown" BIGINT,
  "welfare" VARCHAR,
  "whereabouts" BIGINT,
  "accident_emergency_air_incident" BIGINT,
  "accident_emergency_coach_crash" BIGINT,
  "accident_emergency_natural_disaster" BIGINT,
  "accident_emergency_road_traffic_accident" VARCHAR,
  "accident_emergency_terrorist_incident" BIGINT,
  "accident_emergency_unknown" BIGINT,
  "etds" VARCHAR,
  "complaints" VARCHAR,
  "compliments" VARCHAR,
  "consular_enquiries" VARCHAR,
  "fee_bearing_services" VARCHAR
);

Share link

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