About this Dataset

State And Guest Of Government Visits To The UK

This data is for senior foreign dignitaries (or ‘principals’) who were invited to the UK as Guests of Government by the Prime Minister or the Foreign Secretary.
Publisher name: Foreign, Commonwealth and Development Office (FCDO)
Last updated: 2023-10-21T04:13:30Z

Tables

State And Guest Of Government Visits: January 2021 To February 2022

@ukgov.state_and_guest_of_government_visits_to_the_uk.state_and_guest_of_government_visits_january_2021_to_f_27e99bb4

8.96 kB
14 rows
12 columns

CREATE TABLE state_and_guest_of_government_visits_january_2021_to_f_27e99bb4 (
  "date" VARCHAR,
  "country" VARCHAR,
  "position_held" VARCHAR,
  "accommodation" VARCHAR,
  "transport_incl_airport_costs" VARCHAR  -- Transport (incl Airport Costs),
  "programme_printing" VARCHAR,
  "venue_production" VARCHAR,
  "hospitality" VARCHAR,
  "staff_costs" VARCHAR,
  "interpretation" VARCHAR,
  "total" VARCHAR,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);

State And Guest Of Government Visits: March To October 2022

@ukgov.state_and_guest_of_government_visits_to_the_uk.state_and_guest_of_government_visits_march_to_october_2022

10.98 kB
14 rows
14 columns

CREATE TABLE state_and_guest_of_government_visits_march_to_october_2022 (
  "date" VARCHAR,
  "country" VARCHAR,
  "position_held" VARCHAR,
  "size_of_official_delegation" DOUBLE,
  "no_of_nights" DOUBLE  -- No. Of Nights,
  "accommodation" VARCHAR,
  "transport_incl_airport_costs" VARCHAR  -- Transport (incl Airport Costs),
  "programme_printing" VARCHAR,
  "venue_production" VARCHAR,
  "hospitality" VARCHAR,
  "staff_costs_incl_accommodation" VARCHAR  -- Staff Costs (incl Accommodation),
  "interpretation" VARCHAR,
  "total" VARCHAR,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);

State And Guest Of Government Visits: November 2022 To July 2023

@ukgov.state_and_guest_of_government_visits_to_the_uk.state_and_guest_of_government_visits_november_2022_to_july_2023

11.11 kB
13 rows
14 columns

CREATE TABLE state_and_guest_of_government_visits_november_2022_to_july_2023 (
  "date" VARCHAR,
  "country" VARCHAR,
  "position_held" VARCHAR,
  "size_of_official_delegation" DOUBLE,
  "no_of_nights" DOUBLE  -- No. Of Nights,
  "accommodation" VARCHAR,
  "transport_incl_airport_costs" VARCHAR  -- Transport (incl Airport Costs),
  "programme_printing" VARCHAR,
  "venue_production" VARCHAR,
  "hospitality" VARCHAR,
  "staff_costs_incl_accommodation" VARCHAR  -- Staff Costs (incl Accommodation),
  "interpretation" VARCHAR,
  "total" VARCHAR,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);