Cabinet Office Ministerial Meetings Data

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2011 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2012 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2013 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2014 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2016 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" 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_ministerial_meetings_april_to_june_2017 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" 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_ministerial_meetings_april_to_june_2018 (
  "minister" VARCHAR,
  "date" TIMESTAMP,
  "name_of_organisation_or_individual" 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
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2019 (
  "oliver_dowden" VARCHAR,
  "n_24_04_2019" VARCHAR  -- 24/04/2019,
  "lexington_communications_cisco_bai_communications_fuji_c6e7508c" VARCHAR  -- Lexington Communications; Cisco; BAI Communications; Fujitsu; Atomic Weapons Establishment; Johnson & Johnson; Balfour Beatty; Amazon Web Services; Gemserv; Serco; Post Office; Canon; Amey; Engie; VINCI Facilities; Wates Group,
  "roundtable_dinner_to_discuss_social_value_in_procurement" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2020 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2021 (
  "alok_sharma_2021_04_26_faith_leaders_bishop_of_salisbu_a665ff07" VARCHAR  -- Alok Sharma,2021-04-26,"Faith Leaders: Bishop Of Salisbury And Lead Bishop For The Environment,
  "n__bishops_conference_of_scotland" VARCHAR  -- Bishops’ Conference Of Scotland,
  "n__faith_for_the_climate" VARCHAR  -- Faith For The Climate,
  "n__christian_aid" VARCHAR  -- Christian Aid,
  "n__quakers_in_britain" VARCHAR  -- Quakers In Britain,
  "n__scottish_catholic_international_aid_fund" VARCHAR  -- Scottish Catholic International Aid Fund,
  "n__diocese_of_armagh" VARCHAR  -- Diocese Of Armagh,
  "n__bishop_of_dudley" VARCHAR  -- Bishop Of Dudley,
  "n__chief_rabbi" VARCHAR  -- Chief Rabbi,
  "n__uk_buddhist_society" VARCHAR  -- UK Buddhist Society,
  "n__zoroastrian_trust_funds_of_europe" VARCHAR  -- Zoroastrian Trust Funds Of Europe,
  "n__diocese_of_norwich" VARCHAR  -- Diocese Of Norwich,
  "n__finchley_reform_synagogue" VARCHAR  -- Finchley Reform Synagogue,
  "n__roman_catholic_diocese_of_salford" VARCHAR  -- Roman Catholic Diocese Of Salford,
  "n__the_united_reformed_church" VARCHAR  -- The United Reformed Church,
  "n__masorti" VARCHAR  -- Masorti,
  "n__methodist_church_in_great_britain" VARCHAR  -- Methodist Church In Great Britain,
  "n__lambeth_palace" VARCHAR  -- Lambeth Palace,
  "n__church_of_scotland" VARCHAR  -- Church Of Scotland,
  "n__catholic_bishops_conference_of_england_and_wales" VARCHAR  -- Catholic Bishops’ Conference Of England And Wales,
  "n__moray_ross_caithness_diocese" VARCHAR  -- Moray, Ross & Caithness Diocese,
  "n__inter_faith_network_for_the_united_kingdom" VARCHAR  -- Inter Faith Network For The United Kingdom,
  "n__bishop_of_reading_currently_sit_on_environment_working_group" VARCHAR  -- Bishop Of Reading, Currently Sit On Environment Working Group,
  "n__general_assembly_of_the_united_reformed_church" VARCHAR  -- General Assembly Of The United Reformed Church,
  "n__swansea_brecon_diocese" VARCHAR  -- Swansea & Brecon Diocese,
  "n__global_one" VARCHAR  -- Global One,
  "n__international_society_for_krishna_consciousness" VARCHAR  -- International Society For Krishna Consciousness,
  "n__churches_together_in_england" VARCHAR  -- Churches Together In England,
  "n__three_generate_tv" VARCHAR  -- Three Generate TV,
  "n__lutheran_church_in_great_britain" VARCHAR  -- Lutheran Church In Great Britain,
  "n__al_khoei_institute_to_discuss_the_uk_presidency_s_c_0c322114" VARCHAR  -- Al-Khoei Institute ",To Discuss The UK Presidency's COP26 Priorities With Signatories Of The Lambeth Declaration On Climate Change.
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2022 (
  "andrew_griffith_2022_06_20_british_gas" VARCHAR,
  "n__e_on" VARCHAR  -- E.ON,
  "n__edf" VARCHAR  -- EDF,
  "n__scottish_power" VARCHAR  -- Scottish Power,
  "n__sse" VARCHAR  -- SSE,
  "n__ovo" VARCHAR  -- Ovo,
  "n__octopus" VARCHAR  -- Octopus,
  "n__energy_uk_energy_roundtable_to_discuss_energy_efficicency" VARCHAR  -- Energy UK,Energy Roundtable To Discuss Energy Efficicency
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_june_2023 (
  "oliver_dowden_2023_06_12_lseg" VARCHAR,
  "n__coadec" VARCHAR  -- Coadec,
  "n__index_ventures" VARCHAR  -- Index Ventures,
  "n__datagusto" VARCHAR  -- Datagusto,
  "n__aleees" VARCHAR  -- Aleees,
  "n__phantom_fx" VARCHAR  -- Phantom FX,
  "n__gcash" VARCHAR  -- GCash,
  "n__starling_bank" VARCHAR  -- Starling Bank,
  "n__casualens" VARCHAR  -- CasuaLens,
  "n__beam" VARCHAR  -- Beam,
  "n__benevolent_ai" VARCHAR  -- Benevolent AI,
  "n__zoopla" VARCHAR  -- Zoopla,
  "n__brent_hoberman" VARCHAR  -- Brent Hoberman,
  "n__eden_global_partners" VARCHAR  -- Eden Global Partners,
  "n__matillion" VARCHAR  -- Matillion,
  "n__quantexa" VARCHAR  -- Quantexa,
  "n__marshmallow" VARCHAR  -- Marshmallow,
  "n__silver_lake" VARCHAR  -- Silver Lake,
  "n__darktrace" VARCHAR  -- Darktrace,
  "n__verse_dailyhunt" VARCHAR  -- VerSe/DailyHunt,
  "n__oxford_nanopore" VARCHAR  -- Oxford Nanopore,
  "n__builder_ai" VARCHAR  -- Builder.ai,
  "n__lendable" VARCHAR  -- Lendable,
  "n__simon_sinek" VARCHAR  -- Simon Sinek,
  "n__iconiq" VARCHAR  -- ICONIQ,
  "n__braze" VARCHAR  -- Braze,
  "n__motorway" VARCHAR  -- Motorway,
  "n__wolt" VARCHAR  -- Wolt,
  "n__miro" VARCHAR  -- Miro,
  "n__causaly" VARCHAR  -- Causaly,
  "n__monzo_part_of_dpm_s_regular_schedule_of_business_en_4be42ff9" VARCHAR  -- Monzo,Part Of DPM's Regular Schedule Of Business Engagement At London Tech Week. To Build And Strength Relationships With Key Stakeholders.
);

CREATE TABLE cabinet_office_ministerial_meetings_april_to_september_2015 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_august_to_september_2010 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_external_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2011 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2012 (
  "minister_of_state_minister_for_government_policy_the_r_29a27d09" VARCHAR  -- Minister Of State (Minister For Government Policy), The Rt Hon Oliver Letwin MP,Mar-12,Hayer,
  "n__wincanton" VARCHAR  -- Wincanton,
  "n__norbert_dressangle" VARCHAR  -- Norbert Dressangle,
  "n__dhl" VARCHAR  -- DHL,
  "n__bp" VARCHAR  -- BP,
  "n__suckling" VARCHAR  -- Suckling,
  "n__turners" VARCHAR  -- Turners,
  "n__suttons_potential_industrial_action" VARCHAR  -- Suttons,Potential Industrial Action,
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2013 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2014 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR  -- Purpose Of Meeting˛
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2016 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2017 (
  "n__24_jan_elevations_network" VARCHAR  -- ,24-Jan,Elevations Network,
  "n__nottingham_council" VARCHAR  -- Nottingham Council,
  "n__amosshe" VARCHAR  -- AMOSSHE,
  "n__cambridge_council" VARCHAR  -- Cambridge Council,
  "n__sixth_form_college_association" VARCHAR  -- Sixth Form College Association,
  "n__scottish_assessors_association" VARCHAR  -- Scottish Assessors Association,
  "n__national_association_of_managers_of_student_services" VARCHAR  -- National Association Of Managers Of Student Services,
  "n__birmingham_council" VARCHAR  -- Birmingham Council,
  "n__electoral_commission" VARCHAR  -- Electoral Commission,
  "n__association_of_electoral_administrators" VARCHAR  -- Association Of Electoral Administrators,
  "n__national_union_of_students" VARCHAR  -- National Union Of Students,
  "n__oxford_council" VARCHAR  -- Oxford Council,
  "n__canterbury_council" VARCHAR  -- Canterbury Council,
  "n__universities_uk" VARCHAR  -- Universities UK,
  "n__sheffield_hallam_university" VARCHAR  -- Sheffield Hallam University,
  "n__coventry_council" VARCHAR  -- Coventry Council,
  "n__leeds_council" VARCHAR  -- Leeds Council,
  "n__manchester_council_student_roundtable_to_discuss_vo_22229f91" VARCHAR  -- Manchester Council,Student Roundtable To Discuss Voter Registration And Under-registered Groups
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2018 (
  "chloe_smith_2018_03_05_scottish_assessors_association" VARCHAR,
  "n__shout_out_uk" VARCHAR  -- Shout Out UK,
  "n__the_company_of_community_organisers" VARCHAR  -- The Company Of Community Organisers,
  "n__my_life_my_say" VARCHAR  -- My Life My Say,
  "n__uk_youth" VARCHAR  -- UK Youth,
  "n__uprising" VARCHAR  -- UpRising,
  "n__rnib_royal_national_institute_of_blind_people" VARCHAR  -- RNIB (Royal National Institute Of Blind People),
  "n__the_electoral_commission" VARCHAR  -- The Electoral Commission,
  "n__ncs_trust" VARCHAR  -- NCS Trust,
  "n__association_of_colleges" VARCHAR  -- Association Of Colleges,
  "n__bite_the_ballot" VARCHAR  -- Bite The Ballot,
  "n__step_up_to_serve" VARCHAR  -- Step Up To Serve,
  "n__democracy_club" VARCHAR  -- Democracy Club,
  "n__city_sikh_network" VARCHAR  -- City Sikh Network,
  "n__mencap" VARCHAR  -- Mencap,
  "n__elevation_networks" VARCHAR  -- Elevation Networks,
  "n__voice_4_change_england" VARCHAR  -- Voice 4 Change England,
  "n__association_of_electoral_administrators" VARCHAR  -- Association Of Electoral Administrators,
  "n__patchwork_foundation" VARCHAR  -- Patchwork Foundation,
  "n__three_faiths_forum" VARCHAR  -- Three Faiths Forum,
  "n__ymca_england_wales" VARCHAR  -- YMCA England & Wales,
  "n__prince_s_trust" VARCHAR  -- Prince's Trust,
  "n__british_youth_council" VARCHAR  -- British Youth Council,
  "n__uk_parliament_outreach_engagement_team" VARCHAR  -- UK Parliament Outreach & Engagement Team,
  "n__scope_national_democracy_week_council_meeting" VARCHAR  -- Scope,National Democracy Week Council Meeting,
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2019 (
  "david_lidington_31_01_2019_atkins" VARCHAR,
  "n__atos" VARCHAR  -- ATOS,
  "n__accenture" VARCHAR  -- Accenture,
  "n__amey" VARCHAR  -- Amey,
  "n__arqiva" VARCHAR  -- Arqiva,
  "n__babcock" VARCHAR  -- Babcock,
  "n__bt" VARCHAR  -- BT,
  "n__ciso_of_capgemini" VARCHAR  -- CISO Of Capgemini,
  "n__capita" VARCHAR  -- Capita,
  "n__cgi_uk" VARCHAR  -- CGI UK,
  "n__engie_uk" VARCHAR  -- ENGIE UK,
  "n__fujitsu" VARCHAR  -- Fujitsu,
  "n__g4s" VARCHAR  -- G4S,
  "n__interserve" VARCHAR  -- Interserve,
  "n__ibm" VARCHAR  -- IBM,
  "n__kbr" VARCHAR  -- KBR,
  "n__kpmg" VARCHAR  -- KPMG,
  "n__iss" VARCHAR  -- ISS,
  "n__mitie" VARCHAR  -- Mitie,
  "n__microsoft" VARCHAR  -- Microsoft,
  "n__pwc_uk" VARCHAR  -- PWC UK,
  "n__sopra_steria" VARCHAR  -- Sopra Steria,
  "n__sodexo" VARCHAR  -- Sodexo,
  "n__vodafone_meeting_to_discuss_cyber_security" VARCHAR  -- Vodafone,Meeting To Discuss Cyber Security
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2020 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR  -- Value (£),
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2021 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE cabinet_office_ministerial_meetings_january_to_march_2022 (
  "alok_sharma_2022_02_07_meeting_with_business_leaders_l_73839e64" VARCHAR  -- Alok Sharma,2022-02-07,"Meeting With Business Leaders: Legal & General Investment Management,
  "salesforce" VARCHAR,
  "scottish_power" VARCHAR,
  "dalmia_cement" VARCHAR,
  "hindustan_zinc" VARCHAR,
  "dalmia_cement_1" VARCHAR,
  "scottish_and_southern_energy" VARCHAR,
  "n__legal_general_investment_management" VARCHAR  -- Legal & General Investment Management,
  "n__united_nations_high_level_champions_team" VARCHAR  -- United Nations High Level Champions Team,
  "national_grid" VARCHAR,
  "hitachi" VARCHAR,
  "klabin" VARCHAR,
  "diageo" VARCHAR,
  "hitachi_1" VARCHAR,
  "n__cgi_group" VARCHAR  -- CGI Group,
  "hitachi_2" VARCHAR,
  "n__royal_dsm" VARCHAR  -- Royal DSM,
  "unilever" VARCHAR,
  "salesforce_1" VARCHAR,
  "dsm" VARCHAR,
  "unilever_1" VARCHAR,
  "ikea" VARCHAR,
  "global_adaptation_center_united_nations_climate_leader_306cb70a" VARCHAR  -- Global Adaptation Center, United Nations Climate Leaders,",Discuss COP26 Ccommitments And The Delivery Of COP26 Outcomes Through Private Sector Action.
);