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