About this Dataset

Honours Lists

Lists of those who have received honours at New Year and on the Queen’s official birthday in June each year since 2012. Information is updated after each List is published and includes the level of award, list, name of the recipient, their occupation / position, and details of citation.
Publisher name: Cabinet Office
Last updated: 2022-07-01T04:04:22Z

Tables

Birthday Honours List 2017

@ukgov.honours_lists.birthday_honours_list_2017

70.22 kB
1,110 rows
6 columns

CREATE TABLE birthday_honours_list_2017 (
  "birthday_honours_list_2017" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Birthday Honours List 2018

@ukgov.honours_lists.birthday_honours_list_2018

69.3 kB
1,058 rows
6 columns

CREATE TABLE birthday_honours_list_2018 (
  "birthday_honours_list_2018" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Birthday Honours List 2019

@ukgov.honours_lists.birthday_honours_list_2019

67.4 kB
1,074 rows
8 columns

CREATE TABLE birthday_honours_list_2019 (
  "birthday_honours_list_2019" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

Honours Lists

@ukgov.honours_lists.honours_lists

71.92 kB
1,201 rows
8 columns

CREATE TABLE honours_lists (
  "year" BIGINT,
  "honours_list" VARCHAR,
  "order" VARCHAR,
  "level" VARCHAR,
  "award" VARCHAR,
  "name" VARCHAR,
  "citation" VARCHAR,
  "county" VARCHAR
);

New Year Honours List 2017

@ukgov.honours_lists.new_year_honours_list_2017

75.33 kB
1,198 rows
6 columns

CREATE TABLE new_year_honours_list_2017 (
  "new_year_honours_list_2017" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

New Year Honours List 2018

@ukgov.honours_lists.new_year_honours_list_2018

70.31 kB
1,124 rows
6 columns

CREATE TABLE new_year_honours_list_2018 (
  "new_year_honours_list_2018" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

New Year Honours List 2019

@ukgov.honours_lists.new_year_honours_list_2019

70.71 kB
1,149 rows
6 columns

CREATE TABLE new_year_honours_list_2019 (
  "new_year_honours_list_2019" VARCHAR,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);