Leeds City Council International Travel
Leeds City Council
@ukgov.leeds_city_council_international_travel
Leeds City Council
@ukgov.leeds_city_council_international_travel
CREATE TABLE april_2017_march_2018 (
"foreign_travel_for_leeds_city_council_april_17_to_march_18" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"n" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"unnamed_56" VARCHAR,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" VARCHAR,
"unnamed_60" VARCHAR,
"unnamed_61" VARCHAR,
"unnamed_62" VARCHAR,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"unnamed_65" VARCHAR,
"unnamed_66" VARCHAR,
"unnamed_67" VARCHAR,
"unnamed_68" VARCHAR,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR,
"unnamed_71" VARCHAR
);
CREATE TABLE january_2016_june_2017 (
"name_of_person_travelling" VARCHAR,
"job_title" VARCHAR,
"city" VARCHAR,
"country" VARCHAR,
"departure_date" VARCHAR,
"return_date" VARCHAR,
"total_number_of_days_and_nights" VARCHAR,
"reason_for_visit" VARCHAR,
"lcc_paid_for_travel" VARCHAR,
"external_paid_for_travel" VARCHAR,
"lcc_paid_for_accomodation" VARCHAR,
"external_paid_for_accomodation" VARCHAR,
"lcc_paid_for_local_transport_expenses" VARCHAR,
"external_paid_for_local_transport_expenses" VARCHAR,
"lcc_paid_for_food_and_drink" VARCHAR,
"external_paid_for_food_and_drink" VARCHAR,
"total_cost_of_visit" VARCHAR,
"total_costs_to_lcc" VARCHAR,
"total_costs_to_other_external" VARCHAR
);
CREATE TABLE n_2018_2019_international_travel_expenses (
"foreign_travel_for_leeds_city_council_april_18_to_marc_eb713c70" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"unnamed_56" VARCHAR,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" VARCHAR,
"unnamed_60" VARCHAR,
"unnamed_61" VARCHAR,
"unnamed_62" VARCHAR,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"unnamed_65" VARCHAR,
"unnamed_66" VARCHAR,
"unnamed_67" VARCHAR,
"unnamed_68" VARCHAR,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR
);
CREATE TABLE n_2019_2020_international_travel_expenses (
"foreign_travel_for_leeds_city_council_april_19_to_march_20" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"n" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"unnamed_56" VARCHAR,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" VARCHAR,
"unnamed_60" VARCHAR,
"unnamed_61" VARCHAR,
"unnamed_62" VARCHAR,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"unnamed_65" VARCHAR,
"unnamed_66" VARCHAR,
"unnamed_67" VARCHAR,
"unnamed_68" VARCHAR,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR,
"unnamed_71" VARCHAR
);
Anyone who has the link will be able to view this.