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

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

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

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

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

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

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

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

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

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,
  "n__inter_american_development_bank_idb" VARCHAR,
  "n__asian_infrastructure_investment_bank" VARCHAR,
  "n__blackrock" VARCHAR,
  "n__amundi" VARCHAR,
  "n__bnp_paribas" VARCHAR,
  "n__prudential" VARCHAR,
  "n__bank_of_america" VARCHAR,
  "n__united_nations" VARCHAR,
  "n__european_union" VARCHAR,
  "n__asian_development_bank" VARCHAR,
  "n__glasgow_financial_alliance_for_net_zero_gfanz" VARCHAR,
  "n__world_bank" VARCHAR,
  "n__international_monetary_fund" VARCHAR,
  "n__climate_steering_committee_to_discuss_private_capit_d4abc89b" VARCHAR
);

CREATE TABLE fcdo_s_ministerial_meetings_january_to_march_2021 (
  "tariq_ahmad_16_03_2021_net_solutions" VARCHAR,
  "n__ids_infotech_ltd" VARCHAR,
  "n__adi_group" VARCHAR,
  "n__digitech_software_solutions_pvt_ltd" VARCHAR,
  "n__damco_group_trade" VARCHAR,
  "n__technico_agri_sciences_ltd" VARCHAR,
  "n__sangha_group_of_industries" VARCHAR,
  "n__agnext_technologies_discussion_of_trade_and_investment" VARCHAR
);

CREATE TABLE fcdo_s_ministerial_meetings_january_to_march_2022 (
  "vicky_ford_23_02_2022_standard_chartered" VARCHAR,
  "n__shell" VARCHAR,
  "n__azura" VARCHAR,
  "n__west_africa_enrg" VARCHAR,
  "n__unilever" VARCHAR,
  "n__diageo_guinness" VARCHAR,
  "n__savannah_accugas" VARCHAR,
  "n__pernod_ricard_konexa_globeleq_bbox_reckitt_benckiser" VARCHAR,
  "n__pz_cussons" VARCHAR,
  "n__prudential" VARCHAR,
  "n__control_risks" VARCHAR,
  "n__zeberced_group" VARCHAR,
  "n__nigerstar7_and_british_investment_international_mee_5071cf6e" VARCHAR
);

CREATE TABLE fcdo_s_ministerial_meetings_january_to_march_2023 (
  "andrew_mitchell_23_02_2023_aspire" VARCHAR,
  "n__tamatem" VARCHAR,
  "n__estarta" VARCHAR,
  "n__adam_wa_meshmesh" VARCHAR,
  "n__kaleela" VARCHAR,
  "n__galaxy_organisation_for_technology" VARCHAR,
  "n__the_boston_counsulting_group" VARCHAR,
  "n__webhelp" VARCHAR,
  "n__luminus_education" VARCHAR,
  "n__crystel" VARCHAR,
  "n__extensya" VARCHAR,
  "n__little_thinking_minds" VARCHAR,
  "n__habaybna" VARCHAR,
  "n__repzo" VARCHAR,
  "n__flat6labs" VARCHAR,
  "n__maysalward" VARCHAR,
  "n__decapolis" VARCHAR,
  "n__ot_engineering_solutions_to_understand_the_jordania_c1833bcf" VARCHAR
);

CREATE TABLE fcdo_s_ministerial_meetings_january_to_march_2024 (
  "andrew_mitchell_20_02_2024_vishal_group" VARCHAR,
  "n__high_himalaya_hydro" VARCHAR,
  "n__worldlink" VARCHAR,
  "n__standard_chartered_bank_nepal" VARCHAR,
  "n__fusemachines" VARCHAR,
  "n__goldstar" VARCHAR,
  "n__kgh_group" VARCHAR,
  "n__nmb_bank_business_oxygen_to_discuss_the_opportuniti_c706d6ae" VARCHAR
);

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,
  "n__sibanye_stillwater" VARCHAR,
  "n__glencore" VARCHAR,
  "n__sasol" VARCHAR,
  "n__ittcc" VARCHAR,
  "n__exxaro" VARCHAR,
  "n__ferroglobe" VARCHAR,
  "n__fapa" VARCHAR,
  "n__minerals_council_south_africa" VARCHAR,
  "n__globeleq" VARCHAR,
  "n__mainstream_renewable_power" VARCHAR,
  "n__busa_environmental_sub_committee_meeting_with_membe_fae91109" VARCHAR
);

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,
  "n__standard_chartered_bank" VARCHAR,
  "n__cushman_wakefield" VARCHAR,
  "n__jaguar_land_rover" VARCHAR,
  "n__mott_macdonald" VARCHAR,
  "n__arup" VARCHAR,
  "n__diageo" VARCHAR,
  "n__barclays" VARCHAR,
  "n__rolls_royce" VARCHAR,
  "n__hsbc_to_hear_perspectives_of_british_businesses_in__4a138917" VARCHAR
);

CREATE TABLE fcdo_s_ministerial_meetings_october_to_december_2020 (
  "liz_sugg_19_11_2020_education_commission" VARCHAR,
  "n__akdn" VARCHAR,
  "n__gates_foundation" VARCHAR,
  "n__malala_fund" VARCHAR,
  "n__purposeful_sierra_leone" VARCHAR,
  "n__plan_international" VARCHAR,
  "n__center_for_global_development" VARCHAR,
  "n__leonard_cheshire" VARCHAR,
  "n__girls_not_brides" VARCHAR,
  "n__girls_education_challenge_fund" VARCHAR,
  "n__save_the_children" VARCHAR,
  "n__actionaid" VARCHAR,
  "n__one_campaign" VARCHAR,
  "n__results_uk" VARCHAR,
  "n__global_citizen" VARCHAR,
  "n__institute_for_financial_management_and_research_india" VARCHAR,
  "n__theirworld" VARCHAR,
  "n__vso_international" VARCHAR,
  "n__camfed_to_discuss_upcoming_girls_education_action_plan" VARCHAR
);

CREATE TABLE fcdo_s_ministerial_meetings_october_to_december_2021 (
  "wendy_morton_21_10_2021_unicef" VARCHAR,
  "n__world_health_organisation" VARCHAR,
  "n__bill_and_melinda_gates_foundation" VARCHAR,
  "n__the_eleanor_crook_foundation" VARCHAR,
  "n__save_the_children" VARCHAR,
  "n__action_against_hunger_uk" VARCHAR,
  "n__world_vision_international" VARCHAR,
  "n__m_decins_sans_fronti_res" VARCHAR,
  "n__united_nations_world_food_programme" VARCHAR,
  "n__concern_worldwide" VARCHAR,
  "n__international_rescue_committee" VARCHAR,
  "n__global_affairs_canada" VARCHAR,
  "n__u_s_agency_for_international_development" VARCHAR,
  "n__children_s_investment_fund_foundation" VARCHAR,
  "n__european_commission_co_chairing_an_action_review_pa_cd5ff4da" VARCHAR
);

CREATE TABLE fcdo_s_ministerial_meetings_october_to_december_2023 (
  "leo_docherty_2023_11_17_had_meetings_with_ko_holdings__f8dea3de" VARCHAR,
  "n__chatham_house" VARCHAR,
  "n__vodafone" VARCHAR,
  "n__boyner_group" VARCHAR,
  "n__brussels_city_of_london" VARCHAR,
  "n__intesa" VARCHAR,
  "n__mott_macdonald" VARCHAR,
  "n__rolls_royce" VARCHAR,
  "n__flint_global" VARCHAR,
  "n__microsoft" VARCHAR,
  "n__kale_group" VARCHAR,
  "n__global_counsel" VARCHAR,
  "n__financial_times" VARCHAR,
  "n__goldman_sachs" VARCHAR,
  "n__arup" VARCHAR,
  "n__thecityuk" VARCHAR,
  "n__adviser_to_the_minister_of_foreign_affairs_governme_ac179c51" VARCHAR
);