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: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

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  -- Jeremy Heywood,2018-04-27,"Core Cities UK CEO's Group: Dawn Baxendale (CEO, Birmingham City Council),
  "n__martin_rees_ceo_bristol_city_council" VARCHAR  -- Martin Rees (CEO, Bristol City Council),
  "n__suzanne_wylie_ceo_belfast_city_council" VARCHAR  -- Suzanne Wylie (CEO, Belfast City Council),
  "n__paul_orders_ceo_cardiff_city_council" VARCHAR  -- Paul Orders (CEO, Cardiff City Council),
  "n__anne_marie_o_donnell_ceo_glasgow_city_council" VARCHAR  -- Anne Marie O'Donnell (CEO, Glasgow City Council),
  "n__ged_fitzgerald_ceo_liverpool_city_council" VARCHAR  -- Ged Fitzgerald (CEO, Liverpool City Council),
  "n__tom_riordan_ceo_leeds_city_council" VARCHAR  -- Tom Riordan (CEO, Leeds City Council),
  "n__joanne_roney_ceo_manchester_city_council" VARCHAR  -- Joanne Roney (CEO, Manchester City Council),
  "n__ian_curryer_ceo_nottingham_city_council" VARCHAR  -- Ian Curryer (CEO, Nottingham City Council),
  "n__pat_ritchie_ceo_newcastle_city_council" VARCHAR  -- Pat Ritchie (CEO, Newcastle City Council),
  "n__john_mothersole_ceo_sheffield_city_council" VARCHAR  -- John Mothersole (CEO, Sheffield City Council),
  "n__meeting_of_the_core_cities_ceo_s_to_establish_areas_9f3f79d8" VARCHAR  -- ,Meeting Of The Core Cities CEO's To Establish Areas Of Mutual Concern And Potential Joint Work Jeremy Heywood,2018-04-27,McKinsey And Company,Meeting To Discuss NHS Improvement Jeremy Heywood,2018-04-30,Greensill Capital,Meeting To Discuss Pharmacy Earlier Payments Scheme Jeremy Heywood,2018-05-03,Santander UK,Discussion On Financial Services Issues And Brexit Jeremy Heywood,2018-05-03,Bechtel,Meeting To Discuss Nuclear Power In The UK And Infrastructure Development Jeremy Heywood,2018-05-14,Horizon Nuclear Power,Meeting On The Horizon New Nuclear Project Jeremy Heywood,2018-05-16,Laura Kuenssberg BBC,General Discussion On Topical Issues Jeremy Heywood,2018-05-18,Tesco,Meeting To Discuss Export Strategy, Inward Investment And Apprenticeship Levy"
);

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

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  -- Name (Permanent Secretary Only),
  "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  -- ,May,"Sunday Times (Marie Woolf, Assistant Editor, Whitehall),
  "n__sunday_telegraph_tim_ross_political_correspondent" VARCHAR  -- Sunday Telegraph (Tim Ross, Political Correspondent),
  "n__observer_toby_helm_political_editor" VARCHAR  -- Observer (Toby Helm, Political Editor),
  "n__the_independent_on_sunday_jane_merrick_political_editor" VARCHAR  -- The Independent On Sunday (Jane Merrick, Political Editor),
  "n__sunday_mirror_vincent_moss_political_editor" VARCHAR  -- Sunday Mirror (Vincent Moss, Political Editor),
  "n__the_sun_on_sunday_dave_wooding_political_editor_dis_723cac59" VARCHAR  -- The Sun On Sunday (Dave Wooding, Political Editor)",Discussion On Constitutional Issues
);

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

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

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  -- Name (Permanent Secretary Only),
  "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 October 2014,
  "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: 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
);

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

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