results

Data source: Los Angeles County Registrar-Recorder/County Clerk

36 rows where contest_id = 8953

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
186738 186738 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600001A 110 338 448
186739 186739 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600001A 37 137 174
186740 186740 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600006A 65 339 404
186741 186741 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600006A 38 104 142
186742 186742 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600009A 55 251 306
186743 186743 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600009A 50 65 115
186744 186744 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600012A 103 547 650
186745 186745 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600012A 57 169 226
186746 186746 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600014A 121 551 672
186747 186747 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600014A 49 142 191
186748 186748 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600016A 117 505 622
186749 186749 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600016A 44 134 178
186750 186750 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600021E 86 347 433
186751 186751 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600021E 42 83 125
186752 186752 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600024B 78 334 412
186753 186753 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600024B 38 109 147
186754 186754 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600025A 102 442 544
186755 186755 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600025A 48 117 165
186756 186756 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600026B 112 467 579
186757 186757 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600026B 48 150 198
186758 186758 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600027A 97 367 464
186759 186759 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600027A 61 106 167
186760 186760 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600029C 92 335 427
186761 186761 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600029C 44 102 146
186762 186762 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600030G 0 4 4
186763 186763 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600030G 0 1 1
186764 186764 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600030L 9 16 25
186765 186765 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600030L 3 2 5
186766 186766 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600035A 85 501 586
186767 186767 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600035A 59 104 163
186768 186768 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600036A 54 200 254
186769 186769 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600036A 17 40 57
186770 186770 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600041A 112 525 637
186771 186771 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600041A 63 133 196
186772 186772 YES 21330 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600046A 0 18 18
186773 186773 NO 21331 BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION - MEASURE CN 8953 0600046A 3 4 7

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [results] (
   [candidate_id] INTEGER REFERENCES [candidates]([id]),
   [contest_id] INTEGER REFERENCES [contests]([id]),
   [precinct_id] TEXT REFERENCES [precincts]([precinct]),
   [polling_place] INTEGER,
   [vote_by_mail] INTEGER,
   [total] INTEGER
);
CREATE INDEX [idx_results_precinct_id]
    ON [results] ([precinct_id]);
CREATE INDEX [idx_results_contest_id]
    ON [results] ([contest_id]);
CREATE INDEX [idx_results_candidate_id]
    ON [results] ([candidate_id]);