maiden_speeches

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

3 rows where constituency_group_id = 151

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session_number, parliament_period_id, made_on (date)

id ▼ made_on session_number hansard_reference hansard_url member_id constituency_group_id parliament_period_id
494 2010-06-10 1 vol 511 cc525-7 https://hansard.parliament.uk/Commons/2010-06-10/debates/5028a7d7-be23-4c72-9826-8da5c29ca71e/CommonsChamber#contribution-10061031000649 1056 1056 Corby 151 55 55
587 2012-11-22 2 vol 553 cc807-9 https://hansard.parliament.uk/Commons/2012-11-22/debates/5264e81d-dcd9-41bd-847b-43f0df097207/CommonsChamber#contribution-12112237000812 195 195 Corby 151 55 55
707 2015-06-11 1 vol 596 cc1414-6 https://hansard.parliament.uk/Commons/2015-06-11/debates/747daf6e-704b-444a-bff3-c56c44cbf5ad/CommonsChamber#contribution-15061144000157 194 194 Corby 151 56 56

Advanced export

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

CSV options: 

CREATE TABLE "maiden_speeches" (
   [id] INTEGER PRIMARY KEY,
   [made_on] TEXT,
   [session_number] INTEGER,
   [hansard_reference] TEXT,
   [hansard_url] TEXT,
   [member_id] INTEGER REFERENCES [members]([id]),
   [constituency_group_id] INTEGER REFERENCES [constituency_groups]([id]),
   [parliament_period_id] INTEGER REFERENCES [parliament_periods]([id])
);
CREATE INDEX [idx_maiden_speeches_parliament_period_id]
    ON [maiden_speeches] ([parliament_period_id]);
CREATE INDEX [idx_maiden_speeches_constituency_group_id]
    ON [maiden_speeches] ([constituency_group_id]);
CREATE INDEX [idx_maiden_speeches_member_id]
    ON [maiden_speeches] ([member_id]);