legislation_items

Data license: Open Parliament Licence · Data source: UK Parliament election results website

8 rows where legislation_type_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: royal_assent_on, statute_book_on, royal_assent_on (date), statute_book_on (date)

id ▼ title uri url_key made_on royal_assent_on statute_book_on legislation_type_id
1 Parliamentary Constituencies Act 1986 https://www.legislation.gov.uk/id/ukpga/1986/56 ukpga-1986-56   1986-11-07 1986-11-07 1 1
2 House of Commons (Redistribution of Seats Act) 1949   ukpga-1949-66   1949-11-24 1949-11-24 1 1
3 Northern Ireland Constitution Act 1973 https://www.legislation.gov.uk/id/ukpga/1973/36 ukpga-1973-36   1973-07-18 1973-07-18 1 1
4 Representation of the People Act 1948 https://www.legislation.gov.uk/id/ukpga/1948/65 ukpga-1948-65   1948-07-30 1948-07-30 1 1
5 House of Commons (Redistribution of Seats Act) 1944   ukpga-1944-41   1944-10-26 1944-10-26 1 1
6 Government of Ireland Act 1920 https://www.legislation.gov.uk/id/ukpga/Geo5/10-11/67 ukpga-1920-67   1920-12-23 1920-12-23 1 1
7 Redistribution of Seats (Ireland) Act 1918   ukpga-1918-65   1918-02-06 1918-02-06 1 1
8 Representation of the People Act 1918 https://www.legislation.gov.uk/id/ukpga/1918/64 ukpga-1918-64   1918-02-06 1918-02-06 1 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "legislation_items" (
   [id] INTEGER PRIMARY KEY,
   [title] TEXT,
   [uri] TEXT,
   [url_key] TEXT,
   [made_on] TEXT,
   [royal_assent_on] TEXT,
   [statute_book_on] TEXT,
   [legislation_type_id] INTEGER REFERENCES [legislation_types]([id])
);
CREATE INDEX [idx_legislation_items_legislation_type_id]
    ON [legislation_items] ([legislation_type_id]);