boundary_set_general_election_party_performances
Data license: Open Parliament Licence · Data source: Original Data Source
16 rows where political_party_id = 2
This data as json, CSV (advanced)
Suggested facets: constituency_contested_count, constituency_won_count, general_election_id, boundary_set_id
id ▼ | constituency_contested_count | constituency_won_count | cumulative_vote_count | general_election_id | political_party_id | boundary_set_id |
---|---|---|---|---|---|---|
1 | 5 | 0 | 6822 | 2 2 | Green Party 2 | 5 5 |
2 | 7 | 0 | 7452 | 3 3 | Green Party 2 | 5 5 |
3 | 3 | 0 | 1996 | 4 4 | Green Party 2 | 5 5 |
24 | 502 | 1 | 1073259 | 2 2 | Green Party 2 | 6 6 |
25 | 447 | 1 | 507199 | 3 3 | Green Party 2 | 6 6 |
26 | 454 | 1 | 819769 | 4 4 | Green Party 2 | 6 6 |
39 | 35 | 0 | 38344 | 2 2 | Green Party 2 | 7 7 |
40 | 10 | 0 | 5128 | 3 3 | Green Party 2 | 7 7 |
41 | 18 | 0 | 15828 | 4 4 | Green Party 2 | 7 7 |
56 | 31 | 0 | 39205 | 2 2 | Green Party 2 | 8 8 |
57 | 3 | 0 | 5886 | 3 3 | Green Party 2 | 8 8 |
58 | 22 | 0 | 28122 | 4 4 | Green Party 2 | 8 8 |
76 | 4 | 0 | 3542 | 1 1 | Green Party 2 | 5 5 |
81 | 298 | 1 | 258950 | 1 1 | Green Party 2 | 6 6 |
86 | 13 | 0 | 6293 | 1 1 | Green Party 2 | 7 7 |
92 | 20 | 0 | 16827 | 1 1 | Green Party 2 | 8 8 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "boundary_set_general_election_party_performances" ( [id] INTEGER PRIMARY KEY, [constituency_contested_count] INTEGER, [constituency_won_count] INTEGER, [cumulative_vote_count] INTEGER, [general_election_id] INTEGER REFERENCES [general_elections]([id]), [political_party_id] INTEGER REFERENCES [political_parties]([id]), [boundary_set_id] INTEGER REFERENCES [boundary_sets]([id]) ); CREATE INDEX [idx_boundary_set_general_election_party_performances_boundary_set_id] ON [boundary_set_general_election_party_performances] ([boundary_set_id]); CREATE INDEX [idx_boundary_set_general_election_party_performances_political_party_id] ON [boundary_set_general_election_party_performances] ([political_party_id]); CREATE INDEX [idx_boundary_set_general_election_party_performances_general_election_id] ON [boundary_set_general_election_party_performances] ([general_election_id]);