Hospitality Received By FCO Senior Staff
Foreign and Commonwealth Office
@ukgov.hospitality_received_by_fco_senior_staff
Foreign and Commonwealth Office
@ukgov.hospitality_received_by_fco_senior_staff
Details of hospitality received by the Foreign and Commonwealth Office's senior London-based staff.
Publisher name: Foreign and Commonwealth Office
Last updated: 2022-07-01T04:04:06Z
CREATE TABLE fco_senior_officials_hospitalilty_received_january_march_2018 (
"name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE fco_senior_officials_hospitality_january_march_2019 (
"name" VARCHAR,
"start_date_of_trip" VARCHAR,
"duration_of_visit_in_days" VARCHAR -- Duration Of Visit (in Days),
"destination" VARCHAR,
"purpose_of_trip" VARCHAR,
"mode_of_transport" VARCHAR,
"class_of_travel" VARCHAR,
"accomodation_meals" VARCHAR,
"other_including_hospitality_given" VARCHAR -- Other (including Hospitality Given),
"total_cost_including_all_visas_accommodation_travel_meals_etc" VARCHAR -- Total Cost, Including All Visas, Accommodation, Travel, Meals Etc. (£),
"total_cost_of_use_of_official_secure_car" VARCHAR
);CREATE TABLE fco_senior_official_s_hosptiality_april_june_2019 (
"name" VARCHAR,
"date" VARCHAR,
"person_or_organisation_that_offered_hospitality" VARCHAR,
"type_of_hospitality_received" VARCHAR,
"accompanied_by_spouse_family_member_or_friend" VARCHAR -- Accompanied By Spouse, Family Member Or Friend
);CREATE TABLE hospitality_received_by_fco_senior_staff (
"senior_official_scs2_and_above" VARCHAR -- Senior Official (SCS2 And Above),
"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?
);Anyone who has the link will be able to view this.