Cabinet Office Senior Officials' Business Expenses
Cabinet Office
@ukgov.cabinet_office_senior_officials_expenses
Cabinet Office
@ukgov.cabinet_office_senior_officials_expenses
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2016 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2022 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2010 (
"alex_allan_chairman_joint_intelligence_committee" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_d121b3b2 (
"alex_allan_chairman_joint_intelligence_committee" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2014 (
"lord_browne" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2018 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" DOUBLE,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2021 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2012 (
"patricia_aldred_cabinet_office" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_a9e2e867 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" VARCHAR,
"unnamed_75" VARCHAR,
"unnamed_76" VARCHAR,
"unnamed_77" VARCHAR,
"unnamed_78" VARCHAR,
"unnamed_79" VARCHAR,
"unnamed_80" VARCHAR,
"unnamed_81" VARCHAR,
"unnamed_82" VARCHAR,
"unnamed_83" VARCHAR,
"unnamed_84" VARCHAR,
"unnamed_85" VARCHAR,
"unnamed_86" VARCHAR,
"unnamed_87" VARCHAR,
"unnamed_88" VARCHAR,
"unnamed_89" VARCHAR,
"unnamed_90" VARCHAR,
"unnamed_91" VARCHAR,
"unnamed_92" VARCHAR,
"unnamed_93" VARCHAR,
"unnamed_94" VARCHAR,
"unnamed_95" VARCHAR,
"unnamed_96" VARCHAR,
"unnamed_97" VARCHAR,
"unnamed_98" VARCHAR,
"unnamed_99" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2012 (
"patricia_aldred" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2017 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" DOUBLE,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_a31529ce (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" BIGINT,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2022 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2013 (
"patricia_aldred_cabinet_office" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_6a88f180 (
"patricia_aldred" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2018 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" DOUBLE,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" VARCHAR,
"unnamed_75" VARCHAR,
"unnamed_76" VARCHAR,
"unnamed_77" VARCHAR,
"unnamed_78" VARCHAR,
"unnamed_79" VARCHAR,
"unnamed_80" VARCHAR,
"unnamed_81" VARCHAR,
"unnamed_82" VARCHAR,
"unnamed_83" VARCHAR,
"unnamed_84" VARCHAR,
"unnamed_85" VARCHAR,
"unnamed_86" VARCHAR,
"unnamed_87" VARCHAR,
"unnamed_88" VARCHAR,
"unnamed_89" VARCHAR,
"unnamed_90" VARCHAR,
"unnamed_91" VARCHAR,
"unnamed_92" VARCHAR,
"unnamed_93" VARCHAR,
"unnamed_94" VARCHAR,
"unnamed_95" VARCHAR,
"unnamed_96" VARCHAR,
"unnamed_97" VARCHAR,
"unnamed_98" VARCHAR,
"unnamed_99" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2014 (
"lord_browne" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2022 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2020 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" BIGINT,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2014 (
"lord_browne" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2019 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" BIGINT,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2019 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" BIGINT,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_ab9c6e0f (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_63f0697f (
"patricia_aldred_cabinet_office" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2023 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2015 (
"senior_official" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2016 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR,
"unnamed_11" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2011 (
"patricia_aldred" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2017 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2021 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2016 (
"permanent_secretary" VARCHAR,
"date" TIMESTAMP,
"person_or_organisation_that_meeting_was_with" VARCHAR,
"purpose_of_meeting" VARCHAR,
"unnamed_4" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_c18dbcf8 (
"name" VARCHAR,
"start_date_of_trip" TIMESTAMP,
"duration_of_visit_days" BIGINT,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2019 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" DOUBLE,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2021 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2012 (
"patricia_aldred_cabinet_office" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_27340352 (
"patricia_aldred_cabinet_office" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2015 (
"lord_browne" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2023 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2020 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_2307b38b (
"lord_browne" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2013 (
"patricia_aldred_cabinet_office" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2011 (
"patricia_aldred" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2017 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" DOUBLE,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2020 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_2973ccd4 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" DOUBLE,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" 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,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" VARCHAR,
"unnamed_75" VARCHAR,
"unnamed_76" VARCHAR,
"unnamed_77" VARCHAR,
"unnamed_78" VARCHAR,
"unnamed_79" VARCHAR,
"unnamed_80" VARCHAR,
"unnamed_81" VARCHAR,
"unnamed_82" VARCHAR,
"unnamed_83" VARCHAR,
"unnamed_84" VARCHAR,
"unnamed_85" VARCHAR,
"unnamed_86" VARCHAR,
"unnamed_87" VARCHAR,
"unnamed_88" VARCHAR,
"unnamed_89" VARCHAR,
"unnamed_90" VARCHAR,
"unnamed_91" VARCHAR,
"unnamed_92" VARCHAR,
"unnamed_93" VARCHAR,
"unnamed_94" VARCHAR,
"unnamed_95" VARCHAR,
"unnamed_96" VARCHAR,
"unnamed_97" VARCHAR,
"unnamed_98" VARCHAR,
"unnamed_99" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_january_to_march_2013 (
"patricia_aldred_cabinet_office" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_july_to_september_2018 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip_specific" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_april_to_june_2011 (
"patricia_aldred" 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
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_6180f814 (
"senior_official_scs2_and_above" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_2a13065a (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
CREATE TABLE cabinet_office_senior_officials_expenses_october_to_de_e1aef8ad (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_days" VARCHAR,
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accommodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR,
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR,
"total_cost_of_use_of_official_secure_car" VARCHAR
);
Anyone who has the link will be able to view this.