Foreign, Commonwealth And Development Office: Ministers Gifts, Hospitality, Travel And Meetings

CREATE TABLE fcdo_ministerial_gifts_october_to_december_2022 (
  "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 fcdo_ministerial_hospitality_october_to_december_2022 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend
);

CREATE TABLE fcdo_ministerial_meetings_october_to_december_2022 (
  "anne_marie_trevelyan_23_11_2022_nicola_simmonds_nz_hc__fc4cb05d" VARCHAR  -- Anne-Marie Trevelyan,23/11/2022,"Nicola Simmonds, NZ HC For Vanuatu,
  "n__aupito_william_sio_new_zealand_minister_of_pacific__4427e3a7" VARCHAR  -- Aupito William Sio, New Zealand Minister Of Pacific Peoples And Minister For Courts,
  "n__fiame_naiomi_mata_afa_prime_minister_of_samoa" VARCHAR  -- Fiame Naiomi Mata'afa, Prime Minister Of Samoa,
  "n__ishmael_kalsakau_prime_minister_of_vanuatu" VARCHAR  -- Ishmael Kalsakau, Prime Minister Of Vanuatu,
  "n__jotham_napat_vanuatu_minister_of_foreign_affairs" VARCHAR  -- Jotham Napat, Vanuatu Minister Of Foreign Affairs,
  "n__gloria_julia_king_mp_third_deputy_speaker" VARCHAR  -- Gloria Julia King MP, Third Deputy Speaker,
  "n__jenny_regenvanu_deputy_mayor_port_vila_city_council" VARCHAR  -- Jenny Regenvanu, Deputy Mayor, Port Vila City Council,
  "n__molisa_viran_treif_supreme_court_justice" VARCHAR  -- Molisa Viran Treif, Supreme Court Justice,
  "n__cerol_ala_ianna_dg_prime_minister_office" VARCHAR  -- Cerol Ala-ianna, DG Prime Minister Office,
  "n__eline_garaebiti_dg_ministry_of_climate_change" VARCHAR  -- Eline Garaebiti, DG, Ministry Of Climate Change,
  "n__vanuatu_women_s_centre_event_to_celebrate_women_in__7d538bea" VARCHAR  -- Vanuatu Women's Centre.",Event To Celebrate Women In Leadership In Vanuatu And The Pacific.
);

CREATE TABLE fcdo_ministerial_meetings_october_to_december_2024 (
  "anneliese_dodds_07_10_2024_un_women" VARCHAR  -- Anneliese Dodds ,07/10/2024,UN Women,
  "n__oecd" VARCHAR  -- OECD,
  "n__international_foundation_for_reporting_standards_ifrs" VARCHAR  -- International Foundation For Reporting Standards (IFRS),
  "n__undp" VARCHAR  -- UNDP,
  "n__former_federal_minister_for_economic_cooperation_an_86525154" VARCHAR  -- Former Federal Minister For Economic Cooperation And Development,
  "n__lom_peace_and_security_forum" VARCHAR  -- Lomé Peace And Security Forum,
  "n__centre_for_global_cooperation_research" VARCHAR  -- Centre For Global Cooperation Research,
  "n__the_nature_conservancy_tnc" VARCHAR  -- The Nature Conservancy (TNC),
  "n__pontifical_catholic_university_of_argentina" VARCHAR  -- Pontifical Catholic University Of Argentina,
  "n__south_centre" VARCHAR  -- South Centre,
  "n__institute_of_international_development_and_global_governance" VARCHAR  -- Institute Of International Development And Global Governance,
  "n__policy_bridge_tank_programme_at_auda_nepad_in_south_africa" VARCHAR  -- Policy Bridge Tank Programme At AUDA-NEPAD In South Africa,
  "n__climate_governance_commission" VARCHAR  -- Climate Governance Commission,
  "n__global_fellowship_initiative_of_the_geneva_centre_f_95f689a2" VARCHAR  -- Global Fellowship Initiative Of The Geneva Centre For Security Policy Switzerland,
  "n__centre_for_policy_dialogue_cpd_bangladesh" VARCHAR  -- Centre For Policy Dialogue (CPD) Bangladesh,
  "n__international_development_cooperation_at_the_asia_foundation" VARCHAR  -- International Development Cooperation At The Asia Foundation,
  "n__alliance_for_science" VARCHAR  -- Alliance For Science,
  "n__aspen_institute_energy_and_environment_program_eep" VARCHAR  -- Aspen Institute Energy And Environment Program (EEP),
  "n__interpeace_usa" VARCHAR  -- Interpeace USA,
  "n__kiit_university_and_kiss_university" VARCHAR  -- KIIT University And KISS University,
  "n__india_co_creators" VARCHAR  -- India Co-Creators,
  "n__inclusive_development_ipc_id" VARCHAR  -- Inclusive Development (IPC-id),
  "n__new_south" VARCHAR  -- New South,
  "n__german_institute_of_development_and_sustainability_idos" VARCHAR  -- German Institute Of Development And Sustainability (IDOS),
  "n__international_peace_institute" VARCHAR  -- International Peace Institute,
  "n__private_sector_federation_psf" VARCHAR  -- Private Sector Federation (PSF),
  "n__federal_ministry_for_economic_cooperation_and_devel_70d05aac" VARCHAR  -- Federal Ministry For Economic Cooperation And Development (BMZ),
  "n__centro_de_pensamiento_estrat_gico_internacional_cepei" VARCHAR  -- Centro De Pensamiento Estratégico Internacional – Cepei,
  "n__united_nations_system_staff_college" VARCHAR  -- United Nations System Staff College,
  "n__college_of_humanities_and_development_studies_cohd" VARCHAR  -- College Of Humanities And Development Studies (COHD),
  "n__college_of_international_development_and_global_agr_11308599" VARCHAR  -- College Of International Development And Global Agriculture (CIDGA)/China Institute For South-South Cooperation In Agriculture (CISSCA) China Agricultural University,
  "n__united_nations_systems_staff_college" VARCHAR  -- United Nations Systems Staff College,
  "n__united_nations_systems_staff_college_1" VARCHAR  -- United Nations Systems Staff College.1,
  "n__deutsche_gesellschaft_f_r_internationale_zusammenar_86b3b374" VARCHAR  -- Deutsche Gesellschaft Für Internationale Zusammenarbeit (GIZ) GmbH,
  "n__illustrator" VARCHAR  -- Illustrator,
  "n__graphic_recording_roundtable_to_discuss_multilatera_c6cbb554" VARCHAR  -- Graphic Recording,Roundtable To Discuss Multilateral Cooperation And The System.
);

CREATE TABLE fcdo_ministerial_travel_october_to_december_2022 (
  "minister" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "end_date_of_trip" TIMESTAMP,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "cost_of_private_jet_or_raf_plane_hire_if_relevant" VARCHAR  -- Cost Of Private Jet Or RAF Plane Hire, If Relevant,
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR  -- Number Of Officials Who Accompanied Minister If Non-scheduled Travel Was Used,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend At Public Expense?,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR  -- Total Cost (for Minister Only) Including All Visas, Accommodation, Travel, Meals Etc
);

CREATE TABLE fcdo_ministerial_travel_october_to_december_2024 (
  "minister" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_s_of_transport" VARCHAR  -- Mode(s) Of Transport,
  "number_of_officials_who_accompanied_the_minister_if_no_001f8f33" VARCHAR  -- Number Of Officials Who Accompanied The Minister If Non-scheduled Flight Was Taken,
  "accompanied_by_spouse_partner_at_public_expense" VARCHAR  -- Accompanied By Spouse/ Partner At Public Expense,
  "subtotal_of_all_travel_costs_including_any_non_schedul_7478907f" VARCHAR  -- Subtotal Of All Travel Costs Including Any Non-scheduled/ RAF Flights (£),
  "subtotal_of_associated_costs_for_minister_only_includi_2ab79d48" VARCHAR  -- Subtotal Of Associated Costs (for Minister Only) Including All Visas, Accommodation, Meals Etc. (£),
  "total_cost" VARCHAR  -- Total Cost (£)
);

CREATE TABLE fcdo_s_ministerial_gifts_1_to_4_july_2024 (
  "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 fcdo_s_ministerial_gifts_april_to_june_2021 (
  "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 fcdo_s_ministerial_gifts_april_to_june_2022 (
  "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 fcdo_s_ministerial_gifts_april_to_june_2023 (
  "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 fcdo_s_ministerial_gifts_april_to_june_2024 (
  "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 fcdo_s_ministerial_gifts_january_to_march_2021 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

CREATE TABLE fcdo_s_ministerial_gifts_january_to_march_2022 (
  "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 fcdo_s_ministerial_gifts_january_to_march_2023 (
  "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 fcdo_s_ministerial_gifts_january_to_march_2024 (
  "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 fcdo_s_ministerial_gifts_july_to_september_2021 (
  "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 fcdo_s_ministerial_gifts_july_to_september_2022 (
  "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 fcdo_s_ministerial_gifts_july_to_september_2023 (
  "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 fcdo_s_ministerial_gifts_october_to_december_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 fcdo_s_ministerial_gifts_october_to_december_2021 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome_received_gifts_only" VARCHAR  -- Outcome (received Gifts Only)
);

CREATE TABLE fcdo_s_ministerial_gifts_october_to_december_2023 (
  "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 fcdo_s_ministerial_hospitality_1_to_4_july_2024 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR,
  "value_of_hospitality" VARCHAR  -- Value Of Hospitality (£)
);

CREATE TABLE fcdo_s_ministerial_hospitality_april_to_june_2021 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE fcdo_s_ministerial_hospitality_april_to_june_2022 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE fcdo_s_ministerial_hospitality_april_to_june_2023 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend
);

CREATE TABLE fcdo_s_ministerial_hospitality_april_to_june_2024 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

CREATE TABLE fcdo_s_ministerial_hospitality_january_to_march_2021 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE fcdo_s_ministerial_hospitality_january_to_march_2022 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE fcdo_s_ministerial_hospitality_january_to_march_2023 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend
);

CREATE TABLE fcdo_s_ministerial_hospitality_january_to_march_2024 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

CREATE TABLE fcdo_s_ministerial_hospitality_july_to_september_2021 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE fcdo_s_ministerial_hospitality_july_to_september_2022 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend
);

CREATE TABLE fcdo_s_ministerial_hospitality_july_to_september_2023 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE fcdo_s_ministerial_hospitality_october_to_december_2020 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE fcdo_s_ministerial_hospitality_october_to_december_2021 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

CREATE TABLE fcdo_s_ministerial_hospitality_october_to_december_2023 (
  "minister" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR  -- Accompanied By Spouse, Family Member(s) Or Friend?
);

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

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

CREATE TABLE fcdo_s_ministerial_meetings_april_to_june_2023 (
  "andrew_mitchell_22_06_2023_european_bank_for_reconstru_a76e9d1e" VARCHAR  -- Andrew Mitchell,22/06/2023,European Bank For Reconstruction & Development (EBRD),
  "n__inter_american_development_bank_idb" VARCHAR  -- Inter-American Development Bank (IDB),
  "n__asian_infrastructure_investment_bank" VARCHAR  -- Asian Infrastructure Investment Bank,
  "n__blackrock" VARCHAR  -- BlackRock,
  "n__amundi" VARCHAR  -- Amundi,
  "n__bnp_paribas" VARCHAR  -- BNP Paribas,
  "n__prudential" VARCHAR  -- Prudential,
  "n__bank_of_america" VARCHAR  -- Bank Of America,
  "n__united_nations" VARCHAR  -- United Nations,
  "n__european_union" VARCHAR  -- European Union,
  "n__asian_development_bank" VARCHAR  -- Asian Development Bank,
  "n__glasgow_financial_alliance_for_net_zero_gfanz" VARCHAR  -- Glasgow Financial Alliance For Net Zero (GFANZ),
  "n__world_bank" VARCHAR  -- World Bank,
  "n__international_monetary_fund" VARCHAR  -- International Monetary Fund,
  "n__climate_steering_committee_to_discuss_private_capit_d4abc89b" VARCHAR  -- Climate Data Steering Committee,To Discuss Private Capital Mobilisation
);

CREATE TABLE fcdo_s_ministerial_meetings_january_to_march_2021 (
  "tariq_ahmad_16_03_2021_net_solutions" VARCHAR,
  "n__ids_infotech_ltd" VARCHAR  -- IDS Infotech Ltd,
  "n__adi_group" VARCHAR  -- ADI Group,
  "n__digitech_software_solutions_pvt_ltd" VARCHAR  -- Digitech Software Solutions Pvt. Ltd,
  "n__damco_group_trade" VARCHAR  -- DAMCO Group Trade,
  "n__technico_agri_sciences_ltd" VARCHAR  -- Technico Agri Sciences Ltd,
  "n__sangha_group_of_industries" VARCHAR  -- Sangha Group Of Industries,
  "n__agnext_technologies_discussion_of_trade_and_investment" VARCHAR  -- AgNext Technologies ,Discussion Of Trade And Investment
);

CREATE TABLE fcdo_s_ministerial_meetings_january_to_march_2022 (
  "vicky_ford_23_02_2022_standard_chartered" VARCHAR  -- Vicky Ford ,23/02/2022,"Standard Chartered,
  "n__shell" VARCHAR  -- Shell,
  "n__azura" VARCHAR  -- Azura,
  "n__west_africa_enrg" VARCHAR  -- West Africa ENRG,
  "n__unilever" VARCHAR  -- Unilever,
  "n__diageo_guinness" VARCHAR  -- Diageo/Guinness,
  "n__savannah_accugas" VARCHAR  -- Savannah/Accugas,
  "n__pernod_ricard_konexa_globeleq_bbox_reckitt_benckiser" VARCHAR  -- Pernod Ricard, Konexa, Globeleq, Bbox, Reckitt Benckiser,
  "n__pz_cussons" VARCHAR  -- PZ Cussons,
  "n__prudential" VARCHAR  -- Prudential,
  "n__control_risks" VARCHAR  -- Control Risks,
  "n__zeberced_group" VARCHAR  -- Zeberced Group,
  "n__nigerstar7_and_british_investment_international_mee_5071cf6e" VARCHAR  -- NigerStar7 And British Investment International ",Meeting With Senior UK Company Executives About The Opportunities And Risks Of Doing Business In Nigeria
);

CREATE TABLE fcdo_s_ministerial_meetings_january_to_march_2023 (
  "andrew_mitchell_23_02_2023_aspire" VARCHAR,
  "n__tamatem" VARCHAR  -- Tamatem,
  "n__estarta" VARCHAR  -- Estarta,
  "n__adam_wa_meshmesh" VARCHAR  -- Adam Wa MeshMesh,
  "n__kaleela" VARCHAR  -- Kaleela,
  "n__galaxy_organisation_for_technology" VARCHAR  -- Galaxy Organisation For Technology,
  "n__the_boston_counsulting_group" VARCHAR  -- The Boston Counsulting Group,
  "n__webhelp" VARCHAR  -- WebHelp,
  "n__luminus_education" VARCHAR  -- Luminus Education,
  "n__crystel" VARCHAR  -- Crystel,
  "n__extensya" VARCHAR  -- Extensya,
  "n__little_thinking_minds" VARCHAR  -- Little Thinking Minds,
  "n__habaybna" VARCHAR  -- Habaybna,
  "n__repzo" VARCHAR  -- Repzo,
  "n__flat6labs" VARCHAR  -- Flat6Labs,
  "n__maysalward" VARCHAR  -- Maysalward,
  "n__decapolis" VARCHAR  -- Decapolis,
  "n__ot_engineering_solutions_to_understand_the_jordania_c1833bcf" VARCHAR  -- OT Engineering Solutions,To Understand The Jordanian Entrepreneurship Ecosystem And Its Opportunities And Challenges In Growing And Creating Jobs.
);

CREATE TABLE fcdo_s_ministerial_meetings_january_to_march_2024 (
  "andrew_mitchell_20_02_2024_vishal_group" VARCHAR,
  "n__high_himalaya_hydro" VARCHAR  -- High Himalaya Hydro,
  "n__worldlink" VARCHAR  -- WorldLink,
  "n__standard_chartered_bank_nepal" VARCHAR  -- Standard Chartered Bank Nepal,
  "n__fusemachines" VARCHAR  -- Fusemachines,
  "n__goldstar" VARCHAR  -- Goldstar,
  "n__kgh_group" VARCHAR  -- KGH Group,
  "n__nmb_bank_business_oxygen_to_discuss_the_opportuniti_c706d6ae" VARCHAR  -- NMB Bank & Business Oxygen,To Discuss The Opportunities And Challenges In Nepal’s Economy
);

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

CREATE TABLE fcdo_s_ministerial_meetings_july_to_september_2022 (
  "victoria_ford_11_07_2022_energy_intensive_users_group_eiug" VARCHAR  -- Victoria Ford,11/07/2022,Energy Intensive Users Group (EIUG),
  "n__sibanye_stillwater" VARCHAR  -- Sibanye-Stillwater,
  "n__glencore" VARCHAR  -- Glencore,
  "n__sasol" VARCHAR  -- Sasol,
  "n__ittcc" VARCHAR  -- ITTCC,
  "n__exxaro" VARCHAR  -- Exxaro,
  "n__ferroglobe" VARCHAR  -- Ferroglobe,
  "n__fapa" VARCHAR  -- FAPA,
  "n__minerals_council_south_africa" VARCHAR  -- Minerals Council South Africa,
  "n__globeleq" VARCHAR  -- Globeleq,
  "n__mainstream_renewable_power" VARCHAR  -- Mainstream Renewable Power,
  "n__busa_environmental_sub_committee_meeting_with_membe_fae91109" VARCHAR  -- BUSA Environmental Sub-Committee,"Meeting With Members Of The Energy Intensive Users Group SA, The Minerals Council SA, Business Unity SA, And The Largest UK Renewable Energy Companies Operating In South Africa. "
);

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

CREATE TABLE fcdo_s_ministerial_meetings_july_to_september_2024 (
  "catherine_west_2024_09_17_british_chamber_of_commerce_singapore" VARCHAR  -- Catherine West,2024-09-17,"British Chamber Of Commerce, Singapore,
  "n__standard_chartered_bank" VARCHAR  -- Standard Chartered Bank,
  "n__cushman_wakefield" VARCHAR  -- Cushman & Wakefield,
  "n__jaguar_land_rover" VARCHAR  -- Jaguar Land Rover,
  "n__mott_macdonald" VARCHAR  -- Mott MacDonald,
  "n__arup" VARCHAR  -- Arup,
  "n__diageo" VARCHAR  -- Diageo,
  "n__barclays" VARCHAR  -- Barclays,
  "n__rolls_royce" VARCHAR  -- Rolls-Royce,
  "n__hsbc_to_hear_perspectives_of_british_businesses_in__4a138917" VARCHAR  -- HSBC",To Hear Perspectives Of British Businesses In Asia-Pacific.
);

CREATE TABLE fcdo_s_ministerial_meetings_october_to_december_2020 (
  "liz_sugg_19_11_2020_education_commission" VARCHAR  -- Liz Sugg,19/11/2020,"Education Commission,
  "n__akdn" VARCHAR  -- AKDN,
  "n__gates_foundation" VARCHAR  -- Gates Foundation,
  "n__malala_fund" VARCHAR  -- Malala Fund,
  "n__purposeful_sierra_leone" VARCHAR  -- Purposeful Sierra Leone,
  "n__plan_international" VARCHAR  -- Plan International,
  "n__center_for_global_development" VARCHAR  -- Center For Global Development,
  "n__leonard_cheshire" VARCHAR  -- Leonard Cheshire,
  "n__girls_not_brides" VARCHAR  -- Girls Not Brides,
  "n__girls_education_challenge_fund" VARCHAR  -- Girls' Education Challenge Fund,
  "n__save_the_children" VARCHAR  -- Save The Children,
  "n__actionaid" VARCHAR  -- ActionAid,
  "n__one_campaign" VARCHAR  -- ONE Campaign,
  "n__results_uk" VARCHAR  -- Results UK,
  "n__global_citizen" VARCHAR  -- Global Citizen,
  "n__institute_for_financial_management_and_research_india" VARCHAR  -- Institute For Financial Management And Research, India,
  "n__theirworld" VARCHAR  -- Theirworld,
  "n__vso_international" VARCHAR  -- VSO International,
  "n__camfed_to_discuss_upcoming_girls_education_action_plan" VARCHAR  -- CAMFED",To Discuss Upcoming Girls' Education Action Plan
);

CREATE TABLE fcdo_s_ministerial_meetings_october_to_december_2021 (
  "wendy_morton_21_10_2021_unicef" VARCHAR,
  "n__world_health_organisation" VARCHAR  -- World Health Organisation,
  "n__bill_and_melinda_gates_foundation" VARCHAR  -- Bill And Melinda Gates Foundation,
  "n__the_eleanor_crook_foundation" VARCHAR  -- The Eleanor Crook Foundation,
  "n__save_the_children" VARCHAR  -- Save The Children,
  "n__action_against_hunger_uk" VARCHAR  -- Action Against Hunger UK,
  "n__world_vision_international" VARCHAR  -- World Vision International,
  "n__m_decins_sans_fronti_res" VARCHAR  -- Médecins Sans Frontičres,
  "n__united_nations_world_food_programme" VARCHAR  -- United Nations World Food Programme,
  "n__concern_worldwide" VARCHAR  -- Concern Worldwide,
  "n__international_rescue_committee" VARCHAR  -- International Rescue Committee,
  "n__global_affairs_canada" VARCHAR  -- Global Affairs Canada,
  "n__u_s_agency_for_international_development" VARCHAR  -- U.S. Agency For International Development,
  "n__children_s_investment_fund_foundation" VARCHAR  -- Children’s Investment Fund Foundation,
  "n__european_commission_co_chairing_an_action_review_pa_cd5ff4da" VARCHAR  -- European Commission,Co-chairing An Action Review Panel On Child Wasting
);

CREATE TABLE fcdo_s_ministerial_meetings_october_to_december_2023 (
  "leo_docherty_2023_11_17_had_meetings_with_ko_holdings__f8dea3de" VARCHAR  -- Leo Docherty,2023-11-17,"Had Meetings With: Koç Holdings, Chatham House. Others In Attendance At The Event: Koç Holding,
  "n__chatham_house" VARCHAR  -- Chatham House,
  "n__vodafone" VARCHAR  -- Vodafone,
  "n__boyner_group" VARCHAR  -- Boyner Group,
  "n__brussels_city_of_london" VARCHAR  -- Brussels, City Of London,
  "n__intesa" VARCHAR  -- Intesa,
  "n__mott_macdonald" VARCHAR  -- Mott MacDonald,
  "n__rolls_royce" VARCHAR  -- Rolls-Royce,
  "n__flint_global" VARCHAR  -- Flint Global,
  "n__microsoft" VARCHAR  -- Microsoft,
  "n__kale_group" VARCHAR  -- Kale Group,
  "n__global_counsel" VARCHAR  -- Global Counsel,
  "n__financial_times" VARCHAR  -- Financial Times,
  "n__goldman_sachs" VARCHAR  -- Goldman Sachs,
  "n__arup" VARCHAR  -- Arup,
  "n__thecityuk" VARCHAR  -- TheCityUK,
  "n__adviser_to_the_minister_of_foreign_affairs_governme_ac179c51" VARCHAR  -- Adviser To The Minister Of Foreign Affairs, Government Of Türkiye","Spoke On A Panel At A At Chatham House And Koç Istanbul Event Hosted At The Rahmi M. Koç Museum (İstanbul). To Demonstrate UK Leadership On, And Commitment To, The Security And Prosperity Of Europe, Whilst Underlining The Strength Of The UK-Turkey Bilateral Relationship. "
);