candidacies
Data license: Open Parliament Licence · Data source: UK Parliament election results website
7 rows where election_id = 496
This data as json, CSV (advanced)
Suggested facets: is_winning_candidacy, candidate_gender_id
id ▼ | candidate_given_name | candidate_family_name | candidate_is_sitting_mp | candidate_is_former_mp | is_standing_as_commons_speaker | is_standing_as_independent | is_notional | result_position | is_winning_candidacy | vote_count | vote_share | vote_change | candidate_gender_id | election_id | member_id | democracy_club_person_identifier |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3032 | Stephen | Castens | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 6792 | 0.16153 | -0.011723 | Male 1 | 496 496 | ||
3033 | David | Haslett | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 122 | 0.002901 | Male 1 | 496 496 | |||
3034 | Rita | Wilcock | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 2566 | 0.061025 | 0.036827 | Female 2 | 496 496 | ||
3035 | Louise | Haigh | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 20269 | 0.482044 | 0.056094 | Female 2 | 496 496 | 631 631 | |
3036 | Simon | Clement-Jones | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4746 | 0.112871 | -0.170998 | Male 1 | 496 496 | ||
3037 | Alan | Munro | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 238 | 0.00566 | Male 1 | 496 496 | |||
3038 | Howard | Denby | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 7315 | 0.173968 | 0.136533 | Male 1 | 496 496 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "candidacies" ( [id] INTEGER PRIMARY KEY, [candidate_given_name] TEXT, [candidate_family_name] TEXT, [candidate_is_sitting_mp] INTEGER, [candidate_is_former_mp] INTEGER, [is_standing_as_commons_speaker] INTEGER, [is_standing_as_independent] INTEGER, [is_notional] INTEGER, [result_position] INTEGER, [is_winning_candidacy] INTEGER, [vote_count] INTEGER, [vote_share] FLOAT, [vote_change] FLOAT, [candidate_gender_id] INTEGER REFERENCES [genders]([id]), [election_id] INTEGER REFERENCES [elections]([id]), [member_id] INTEGER REFERENCES [members]([id]), [democracy_club_person_identifier] TEXT ); CREATE INDEX [idx_candidacies_member_id] ON [candidacies] ([member_id]); CREATE INDEX [idx_candidacies_election_id] ON [candidacies] ([election_id]); CREATE INDEX [idx_candidacies_candidate_gender_id] ON [candidacies] ([candidate_gender_id]);