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

68.58 KB
1110 rows
6 columns


CREATE TABLE birthday_honours_list_2017 (
  "birthday_honours_list_2017" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

Birthday Honours List 2018

@ukgov.honours_lists.birthday_honours_list_2018

67.68 KB
1058 rows
6 columns


CREATE TABLE birthday_honours_list_2018 (
  "birthday_honours_list_2018" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

Birthday Honours List 2019

@ukgov.honours_lists.birthday_honours_list_2019

65.82 KB
1074 rows
8 columns


CREATE TABLE birthday_honours_list_2019 (
  "birthday_honours_list_2019" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

Honours Lists

@ukgov.honours_lists.honours_lists

70.24 KB
1201 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

73.57 KB
1198 rows
6 columns


CREATE TABLE new_year_honours_list_2017 (
  "new_year_honours_list_2017" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

New Year Honours List 2018

@ukgov.honours_lists.new_year_honours_list_2018

68.66 KB
1124 rows
6 columns


CREATE TABLE new_year_honours_list_2018 (
  "new_year_honours_list_2018" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

New Year Honours List 2019

@ukgov.honours_lists.new_year_honours_list_2019

69.05 KB
1149 rows
6 columns


CREATE TABLE new_year_honours_list_2019 (
  "new_year_honours_list_2019" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);