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

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