csvbase is a simple website for sharing table data. Join the discord.
| Column name | Column type | Column value |
|---|---|---|
| Row ID | integer | 13 |
| Parliament number | integer | 58 |
| Parliament summoned on | date | 2019-12-17 |
| Parliament dissolved on | date | 2024-05-30 |
| Parliament Wikidata ID | string | Q77685395 |
| Parliament London Gazette citation | string | issue 64411 |
| Parliament URL | string | http://electionresults.parliament.uk/parliament-periods/58 |
| General election polling date | date | 2019-12-12 |
| General election is notional | boolean | No |
| Total electorate in general election | integer | 47562702 |
| Total valid votes in general election | integer | 32014110 |
| Total invalid votes in general election | integer | 117919 |
| General election URL | string | http://electionresults.parliament.uk/general-elections/4 |
| Country name | string | Scotland |
| Country geographic code | string | S92000003 |
| Country URL | string | http://electionresults.parliament.uk/countries/5 |
| English region name | string | <NA> |
| English region geographic code | string | <NA> |
| English region URL | string | <NA> |
| Constituency name | string | Aberdeen North |
| Constituency geographic code | string | S14000001 |
| Constituency designation | string | Burgh |
| Constituency URL | string | http://electionresults.parliament.uk/constituency-areas/3 |
| Boundary set start date | date | 2005-04-12 |
| Boundary set end date | date | 2024-05-30 |
| Boundary set URL | string | http://electionresults.parliament.uk/boundary-sets/8 |
| Electorate | integer | 62489 |
| Election polling date | date | 2019-12-12 |
| Election is by-election | boolean | No |
| Declaration time | string | 2019-12-13 03:13:00 UTC |
| Election valid vote count | integer | 37413 |
| Election invalid vote count | integer | 72 |
| Election URL | string | http://electionresults.parliament.uk/elections/1303 |
| Election result summary | string | SNP hold |
| Candidate family name | string | Houghton |
| Candidate given name | string | Ryan |
| Candidate MNIS ID | integer | <NA> |
| Candidate is sitting MP | boolean | No |
| Candidate is former MP | boolean | No |
| Candidate Member URL | string | <NA> |
| Main party name | string | Conservative |
| Main party abbreviation | string | Con |
| Main party Electoral Commission ID | string | PP52 |
| Main party MNIS ID | integer | 4 |
| Main party URL | string | http://electionresults.parliament.uk/political-parties/1 |
| Adjunct party name | string | <NA> |
| Adjunct party abbreviation | string | <NA> |
| Adjunct party Electoral Commission ID | string | <NA> |
| Candidate is standing as Commons Speaker | boolean | No |
| Candidate is standing as independent | boolean | No |
| Candidate vote count | integer | 7535 |
| Candidate vote share | float | 0.201401 |
| Candidate vote change | float | -0.025522 |
| Majority | integer | <NA> |
| Candidate result position | integer | 2 |