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,
  "outcome_received_gifts_only" VARCHAR
);

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

CREATE TABLE fcdo_ministerial_meetings_october_to_december_2022 (
  "anne_marie_trevelyan_23_11_2022_nicola_simmonds_nz_hc__fc4cb05d" VARCHAR,
  "n__aupito_william_sio_new_zealand_minister_of_pacific__4427e3a7" VARCHAR,
  "n__fiame_naiomi_mata_afa_prime_minister_of_samoa" VARCHAR,
  "n__ishmael_kalsakau_prime_minister_of_vanuatu" VARCHAR,
  "n__jotham_napat_vanuatu_minister_of_foreign_affairs" VARCHAR,
  "n__gloria_julia_king_mp_third_deputy_speaker" VARCHAR,
  "n__jenny_regenvanu_deputy_mayor_port_vila_city_council" VARCHAR,
  "n__molisa_viran_treif_supreme_court_justice" VARCHAR,
  "n__cerol_ala_ianna_dg_prime_minister_office" VARCHAR,
  "n__eline_garaebiti_dg_ministry_of_climate_change" VARCHAR,
  "n__vanuatu_women_s_centre_event_to_celebrate_women_in__7d538bea" VARCHAR
);

CREATE TABLE fcdo_ministerial_meetings_october_to_december_2024 (
  "anneliese_dodds_07_10_2024_un_women" VARCHAR,
  "n__oecd" VARCHAR,
  "n__international_foundation_for_reporting_standards_ifrs" VARCHAR,
  "n__undp" VARCHAR,
  "n__former_federal_minister_for_economic_cooperation_an_86525154" VARCHAR,
  "n__lom_peace_and_security_forum" VARCHAR,
  "n__centre_for_global_cooperation_research" VARCHAR,
  "n__the_nature_conservancy_tnc" VARCHAR,
  "n__pontifical_catholic_university_of_argentina" VARCHAR,
  "n__south_centre" VARCHAR,
  "n__institute_of_international_development_and_global_governance" VARCHAR,
  "n__policy_bridge_tank_programme_at_auda_nepad_in_south_africa" VARCHAR,
  "n__climate_governance_commission" VARCHAR,
  "n__global_fellowship_initiative_of_the_geneva_centre_f_95f689a2" VARCHAR,
  "n__centre_for_policy_dialogue_cpd_bangladesh" VARCHAR,
  "n__international_development_cooperation_at_the_asia_foundation" VARCHAR,
  "n__alliance_for_science" VARCHAR,
  "n__aspen_institute_energy_and_environment_program_eep" VARCHAR,
  "n__interpeace_usa" VARCHAR,
  "n__kiit_university_and_kiss_university" VARCHAR,
  "n__india_co_creators" VARCHAR,
  "n__inclusive_development_ipc_id" VARCHAR,
  "n__new_south" VARCHAR,
  "n__german_institute_of_development_and_sustainability_idos" VARCHAR,
  "n__international_peace_institute" VARCHAR,
  "n__private_sector_federation_psf" VARCHAR,
  "n__federal_ministry_for_economic_cooperation_and_devel_70d05aac" VARCHAR,
  "n__centro_de_pensamiento_estrat_gico_internacional_cepei" VARCHAR,
  "n__united_nations_system_staff_college" VARCHAR,
  "n__college_of_humanities_and_development_studies_cohd" VARCHAR,
  "n__college_of_international_development_and_global_agr_11308599" VARCHAR,
  "n__united_nations_systems_staff_college" VARCHAR,
  "n__united_nations_systems_staff_college_1" VARCHAR,
  "n__deutsche_gesellschaft_f_r_internationale_zusammenar_86b3b374" VARCHAR,
  "n__illustrator" VARCHAR,
  "n__graphic_recording_roundtable_to_discuss_multilatera_c6cbb554" VARCHAR
);

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,
  "number_of_officials_who_accompanied_minister_if_non_sc_57f864e2" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend_at_pub_09d321dc" VARCHAR,
  "total_cost_for_minister_only_including_all_visas_accom_5e5e5492" VARCHAR
);

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,
  "number_of_officials_who_accompanied_the_minister_if_no_001f8f33" VARCHAR,
  "accompanied_by_spouse_partner_at_public_expense" VARCHAR,
  "subtotal_of_all_travel_costs_including_any_non_schedul_7478907f" VARCHAR,
  "subtotal_of_associated_costs_for_minister_only_includi_2ab79d48" VARCHAR,
  "total_cost" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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,
  "outcome_received_gifts_only" VARCHAR
);

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

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,
  "outcome_received_gifts_only" VARCHAR
);

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

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

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

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