legislation_items

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

1 row where "statute_book_on" is on date 2007-06-13

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ title uri url_key made_on royal_assent_on statute_book_on legislation_type_id
11 Parliamentary Constituencies (England) Order 2007 https://www.legislation.gov.uk/id/uksi/2007/1681 uksi-2007-1681 2007-06-13   2007-06-13 2 2

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]);