Consular Management Information

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
);