Leeds City Council International Travel
Leeds City Council
@ukgov.leeds_city_council_international_travel
Leeds City Council
@ukgov.leeds_city_council_international_travel
Dataset showing all instances of overseas travel by Leeds City Council officers and councillors. The dataset shows places visited and the associated travel costs. On some occasions these costs were met by other organisations or bodies. Please note ----------- * Lower ranking council officers have had their names redacted * Instances of repatriation are listed, though details of city/town are redacted to protect the identity of those affected
Publisher name: Leeds City Council
Last updated: 2024-09-14T09:48:08Z
CREATE TABLE april_2017_march_2018 (
"foreign_travel_for_leeds_city_council_april_17_to_march_18" VARCHAR -- FOREIGN TRAVEL FOR LEEDS CITY COUNCIL (April 17 To March 18),
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"n" VARCHAR,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" VARCHAR -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" VARCHAR -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" VARCHAR -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" VARCHAR -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" VARCHAR -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" VARCHAR -- Unnamed: 71
);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 -- FOREIGN TRAVEL FOR LEEDS CITY COUNCIL (April 18 To March 19) ALL COSTS IN GBP,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" VARCHAR -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" VARCHAR -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" VARCHAR -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" VARCHAR -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" VARCHAR -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70
);CREATE TABLE n_2019_2020_international_travel_expenses (
"foreign_travel_for_leeds_city_council_april_19_to_march_20" VARCHAR -- FOREIGN TRAVEL FOR LEEDS CITY COUNCIL (April 19 To March 20),
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"n" VARCHAR,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" VARCHAR -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" VARCHAR -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" VARCHAR -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" VARCHAR -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" VARCHAR -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" VARCHAR -- Unnamed: 71
);Anyone who has the link will be able to view this.