csvbase is a simple website for sharing table data. Join the discord.

robertbrook

Registered 25 Jun 2024

My tables

robertbrook/candidacies-2019
approx. 3,320 rows, last changed 9 months ago
Row ID Parliament number Parliament summoned on Parliament dissolved on Parliament Wikidata ID Parliament London Gazette citation Parliament URL General election polling date General election is notional Total electorate in general election Total valid votes in general election Total invalid votes in general election General election URL Country name Country geographic code Country URL English region name English region geographic code English region URL Constituency name Constituency geographic code Constituency designation Constituency URL Boundary set start date Boundary set end date Boundary set URL Electorate Election polling date Election is by-election Declaration time Election valid vote count Election invalid vote count Election URL Election result summary Candidate family name Candidate given name Candidate MNIS ID Candidate is sitting MP Candidate is former MP Candidate Member URL Main party name Main party abbreviation Main party Electoral Commission ID Main party MNIS ID Main party URL Adjunct party name Adjunct party abbreviation Adjunct party Electoral Commission ID Candidate is standing as Commons Speaker Candidate is standing as independent Candidate vote count Candidate vote share Candidate vote change Majority Candidate result position
1 58 2019-12-17 2024-05-30 Q77685395 issue 64411 http://electionresults.parliament.uk/parliament-periods/58 2019-12-12 No 47562702 32014110 117919 http://electionresults.parliament.uk/general-elections/4 Wales W92000004 http://electionresults.parliament.uk/countries/6 <NA> <NA> <NA> Aberavon W07000049 County http://electionresults.parliament.uk/constituency-areas/1 2010-04-13 2024-05-30 http://electionresults.parliament.uk/boundary-sets/7 50750 2019-12-12 No 2019-12-13 02:30:00 UTC 31598 82 http://electionresults.parliament.uk/elections/1301 Lab hold Kinnock Stephen 4359 Yes Yes http://electionresults.parliament.uk/members/4359 Labour Lab PP53 15 http://electionresults.parliament.uk/political-parties/3 <NA> <NA> <NA> No No 17008 0.538262 -0.142933 10490 1
2 58 2019-12-17 2024-05-30 Q77685395 issue 64411 http://electionresults.parliament.uk/parliament-periods/58 2019-12-12 No 47562702 32014110 117919 http://electionresults.parliament.uk/general-elections/4 Wales W92000004 http://electionresults.parliament.uk/countries/6 <NA> <NA> <NA> Aberavon W07000049 County http://electionresults.parliament.uk/constituency-areas/1 2010-04-13 2024-05-30 http://electionresults.parliament.uk/boundary-sets/7 50750 2019-12-12 No 2019-12-13 02:30:00 UTC 31598 82 http://electionresults.parliament.uk/elections/1301 Lab hold Lang Charlotte <NA> No No <NA> Conservative Con PP52 4 http://electionresults.parliament.uk/political-parties/1 <NA> <NA> <NA> No No 6518 0.206279 0.028901 <NA> 2
3 58 2019-12-17 2024-05-30 Q77685395 issue 64411 http://electionresults.parliament.uk/parliament-periods/58 2019-12-12 No 47562702 32014110 117919 http://electionresults.parliament.uk/general-elections/4 Wales W92000004 http://electionresults.parliament.uk/countries/6 <NA> <NA> <NA> Aberavon W07000049 County http://electionresults.parliament.uk/constituency-areas/1 2010-04-13 2024-05-30 http://electionresults.parliament.uk/boundary-sets/7 50750 2019-12-12 No 2019-12-13 02:30:00 UTC 31598 82 http://electionresults.parliament.uk/elections/1301 Lab hold Davies Glenda <NA> No No <NA> The Brexit Party BRX PP7931 1006 http://electionresults.parliament.uk/political-parties/153 <NA> <NA> <NA> No No 3108 0.098361 <NA> <NA> 3
4 58 2019-12-17 2024-05-30 Q77685395 issue 64411 http://electionresults.parliament.uk/parliament-periods/58 2019-12-12 No 47562702 32014110 117919 http://electionresults.parliament.uk/general-elections/4 Wales W92000004 http://electionresults.parliament.uk/countries/6 <NA> <NA> <NA> Aberavon W07000049 County http://electionresults.parliament.uk/constituency-areas/1 2010-04-13 2024-05-30 http://electionresults.parliament.uk/boundary-sets/7 50750 2019-12-12 No 2019-12-13 02:30:00 UTC 31598 82 http://electionresults.parliament.uk/elections/1301 Lab hold Hunt Nigel <NA> No No <NA> Plaid Cymru PC PP77 22 http://electionresults.parliament.uk/political-parties/5 <NA> <NA> <NA> No No 2711 0.085797 0.002804 <NA> 4
5 58 2019-12-17 2024-05-30 Q77685395 issue 64411 http://electionresults.parliament.uk/parliament-periods/58 2019-12-12 No 47562702 32014110 117919 http://electionresults.parliament.uk/general-elections/4 Wales W92000004 http://electionresults.parliament.uk/countries/6 <NA> <NA> <NA> Aberavon W07000049 County http://electionresults.parliament.uk/constituency-areas/1 2010-04-13 2024-05-30 http://electionresults.parliament.uk/boundary-sets/7 50750 2019-12-12 No 2019-12-13 02:30:00 UTC 31598 82 http://electionresults.parliament.uk/elections/1301 Lab hold Kingston-Jones Sheila <NA> No No <NA> Liberal Democrat LD PP90 17 http://electionresults.parliament.uk/political-parties/4 <NA> <NA> <NA> No No 1072 0.033926 0.015921 <NA> 5
[3315 more rows] ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
robertbrook/parliament-periods
59 rows, last changed 9 months ago
Row ID Number Summoned on State opening on Dissolved on Wikidata ID Commons Library briefing URL London Gazette citation URL
1 59 2024-07-09 2024-07-17 <NA> Q126063704 <NA> <NA> http://127.0.0.1:3000/parliament-periods/59
2 58 2019-12-17 2019-12-19 2024-05-30 Q77685395 https://commonslibrary.parliament.uk/research-briefings/cbp-9225/ <NA> http://127.0.0.1:3000/parliament-periods/58
3 57 2017-06-13 2017-06-21 2019-11-05 Q29974940 https://commonslibrary.parliament.uk/research-briefings/cbp-8280/ issue 62821 http://127.0.0.1:3000/parliament-periods/57
4 56 2015-05-18 2015-05-27 2017-05-03 Q21084473 https://commonslibrary.parliament.uk/research-briefings/cbp-7417/ issue 61920 http://127.0.0.1:3000/parliament-periods/56
5 55 2010-05-18 2010-05-25 2015-03-30 Q21084472 https://commonslibrary.parliament.uk/research-briefings/sn05833/ issue 61188 http://127.0.0.1:3000/parliament-periods/55
[54 more rows] ... ... ... ... ... ... ... ...
robertbrook/acts-of-parliament
8 rows, last changed 9 months ago
Row ID Title URI Date of Royal Assent URL
1 Parliamentary Constituencies Act 1986 https://www.legislation.gov.uk/id/ukpga/1986/56 1986-11-07 http://127.0.0.1:3000/legislation-items/ukpga-1986-56
2 Northern Ireland Constitution Act 1973 https://www.legislation.gov.uk/id/ukpga/1973/36 1973-07-18 http://127.0.0.1:3000/legislation-items/ukpga-1973-36
3 House of Commons (Redistribution of Seats Act) 1949 <NA> 1949-11-24 http://127.0.0.1:3000/legislation-items/ukpga-1949-66
4 Representation of the People Act 1948 https://www.legislation.gov.uk/id/ukpga/1948/65 1948-07-30 http://127.0.0.1:3000/legislation-items/ukpga-1948-65
5 House of Commons (Redistribution of Seats Act) 1944 <NA> 1944-10-26 http://127.0.0.1:3000/legislation-items/ukpga-1944-41
[3 more rows] ... ... ... ...