Cabinet Office Senior Officials' Meetings

CREATE TABLE cabinet_office_senior_officials_meetings_april_to_june_2016 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_april_to_june_2017 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_april_to_june_2018 (
  "jeremy_heywood_2018_04_27_core_cities_uk_ceo_s_group_d_ee370f25" VARCHAR,
  "n__martin_rees_ceo_bristol_city_council" VARCHAR,
  "n__suzanne_wylie_ceo_belfast_city_council" VARCHAR,
  "n__paul_orders_ceo_cardiff_city_council" VARCHAR,
  "n__anne_marie_o_donnell_ceo_glasgow_city_council" VARCHAR,
  "n__ged_fitzgerald_ceo_liverpool_city_council" VARCHAR,
  "n__tom_riordan_ceo_leeds_city_council" VARCHAR,
  "n__joanne_roney_ceo_manchester_city_council" VARCHAR,
  "n__ian_curryer_ceo_nottingham_city_council" VARCHAR,
  "n__pat_ritchie_ceo_newcastle_city_council" VARCHAR,
  "n__john_mothersole_ceo_sheffield_city_council" VARCHAR,
  "n__meeting_of_the_core_cities_ceo_s_to_establish_areas_9f3f79d8" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_april_to_june_2019 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" 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_meetings_april_to_june_2020 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_april_to_june_2021 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_april_to_june_2022 (
  "name_permanent_secretary_only" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_april_to_sept_83fe8357 (
  "n__may_sunday_times_marie_woolf_assistant_editor_whitehall" VARCHAR,
  "n__sunday_telegraph_tim_ross_political_correspondent" VARCHAR,
  "n__observer_toby_helm_political_editor" VARCHAR,
  "n__the_independent_on_sunday_jane_merrick_political_editor" VARCHAR,
  "n__sunday_mirror_vincent_moss_political_editor" VARCHAR,
  "n__the_sun_on_sunday_dave_wooding_political_editor_dis_723cac59" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_january_to_march_2016 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_january_to_march_2017 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_january_to_march_2018 (
  "permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" 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
);

CREATE TABLE cabinet_office_senior_officials_meetings_january_to_march_2019 (
  "permanent_secretary" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" 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_meetings_january_to_march_2020 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_january_to_march_2021 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_january_to_march_2022 (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_january_to_march_2023 (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_john_manzoni__18a2258e (
  "john_manzoni_s_external_meetings_january_2015" VARCHAR,
  "john_manzoni_s_external_meetings_february_2015" VARCHAR,
  "john_manzoni_s_external_meetings_march_2015" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_john_manzoni__e9408cfc (
  "john_manzoni_s_external_meetings_october_2014" VARCHAR,
  "john_manzoni_s_external_meetings_november_2014" VARCHAR,
  "john_manzoni_s_external_meetings_december_2014" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_jon_day_july__2970bf2f (
  "jon_day_s_external_meetings_august_2014" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_jon_day_octob_98ee0b56 (
  "jon_day_s_external_meetings_november_2014" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_july_to_september_2017 (
  "permanent_secretary_only" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_july_to_september_2018 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" 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
);

CREATE TABLE cabinet_office_senior_officials_meetings_july_to_september_2019 (
  "permanent_secretary" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_july_to_september_2020 (
  "permanent_secretary" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_senior_officials_meetings_july_to_september_2021 (
  "permanent_secretary" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);