psephology: english_region_general_election_party_performances: 52 rows where constituency_contested_count = 1 and english_region

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

52 rows where constituency_contested_count = 1 and english_region_id = 7

descending

id ▼	constituency_contested_count	cumulative_vote_count	general_election_id	political_party_id	english_region_id
377	1	294	2 2	Official Monster Raving Loony Party 12	East of England 7
378	1	667	3 3	Official Monster Raving Loony Party 12	East of England 7
382	1	532	4 4	English Democrats 15	East of England 7
383	1	31	2 2	All People's Party 26	East of England 7
386	1	108	2 2	British National Party 40	East of England 7
388	1	340	3 3	Pirate Party UK 46	East of England 7
389	1	187	2 2	Rebooting Democracy 52	East of England 7
390	1	133	3 3	Rebooting Democracy 52	East of England 7
391	1	67	4 4	Rebooting Democracy 52	East of England 7
396	1	96	2 2	Class War 58	East of England 7
397	1	80	2 2	Young People's Party 72	East of England 7
398	1	110	3 3	Young People's Party 72	East of England 7
399	1	181	4 4	Young People's Party 72	East of England 7
400	1	116	2 2	The Sustainable Population Party 90	East of England 7
401	1	1658	2 2	Residents for Uttlesford 104	East of England 7
414	1	256	2 2	Common Sense Party 111	East of England 7
415	1	149	4 4	Women's Equality Party 141	East of England 7
416	1	305	3 3	Southend Independent Association 150	East of England 7
418	1	363	4 4	The Universal Good Party 158	East of England 7
419	1	101	4 4	Advance Together 163	East of England 7
420	1	631	4 4	Veterans and People's Party 167	East of England 7
421	1	268	4 4	The Best for Luton Party 170	East of England 7
422	1	367	4 4	Psychedelic Movement 174	East of England 7
615	1	101	5 5	Trade Unionist and Socialist Coalition 7	East of England 7
617	1	532	5 5	English Democrats 15	East of England 7
619	1	67	5 5	Rebooting Democracy 52	East of England 7
621	1	181	5 5	Young People's Party 72	East of England 7
626	1	149	5 5	Women's Equality Party 141	East of England 7
628	1	363	5 5	The Universal Good Party 158	East of England 7
629	1	631	5 5	Veterans and People's Party 167	East of England 7
630	1	268	5 5	The Best for Luton Party 170	East of England 7
631	1	367	5 5	Psychedelic Movement 174	East of England 7
842	1	548	1 1	Official Monster Raving Loony Party 12	East of England 7
853	1	108	1 1	Citizens for Undead Rights and Equality 198	East of England 7
854	1	362	1 1	Cambridge Socialists 202	East of England 7
855	1	12174	1 1	Independent Save Our Green Belt 205	East of England 7
856	1	118	1 1	The New Party 206	East of England 7
857	1	153	1 1	Reduce Tax On Beer 207	East of England 7
858	1	1078	1 1	Tendring First 209	East of England 7
859	1	35	1 1	Peoples Party Essex 210	East of England 7
860	1	100	1 1	Matriarchal Party United Kingdom Great Britain 220	East of England 7
862	1	181	1 1	Animal Protection Party 226	East of England 7
863	1	327	1 1	No Candidate Deserves My Vote! 247	East of England 7
2366	1	192	6 6	Trade Unionist and Socialist Coalition 7	East of England 7
2371	1	373	6 6	British Democratic Party 45	East of England 7
2372	1	265	6 6	Rebooting Democracy 52	East of England 7
2377	1	230	6 6	Independent Network 168	East of England 7
2378	1	99	6 6	Psychedelic Movement 174	East of England 7
2386	1	139	6 6	Alliance for Democracy and Freedom 268	East of England 7
2387	1	87	6 6	English Constitution Party 272	East of England 7
2388	1	150	6 6	UK Voice 296	East of England 7
2391	1	568	6 6	Shared Ground 303	East of England 7

Advanced export

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

CREATE TABLE "english_region_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]),
   [english_region_id] INTEGER REFERENCES [english_regions]([id])
);
CREATE INDEX [idx_english_region_general_election_party_performances_english_region_id]
    ON [english_region_general_election_party_performances] ([english_region_id]);
CREATE INDEX [idx_english_region_general_election_party_performances_political_party_id]
    ON [english_region_general_election_party_performances] ([political_party_id]);
CREATE INDEX [idx_english_region_general_election_party_performances_general_election_id]
    ON [english_region_general_election_party_performances] ([general_election_id]);