results

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

24 rows where contest_id = 8920

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place, vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
38261 38261 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600002A 74 481 555
38262 38262 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600002A 83 260 343
38263 38263 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600003A 140 1012 1152
38264 38264 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600003A 103 484 587
38265 38265 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600005A 76 746 822
38266 38266 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600005A 57 294 351
38267 38267 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600006A 150 1072 1222
38268 38268 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600006A 160 668 828
38269 38269 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600009A 1 0 1
38270 38270 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600009A 0 0 0
38271 38271 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600010A 92 562 654
38272 38272 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600010A 93 345 438
38273 38273 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600016A 138 1241 1379
38274 38274 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600016A 161 938 1099
38275 38275 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600024A 63 437 500
38276 38276 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600024A 70 201 271
38277 38277 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600035A 12 128 140
38278 38278 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600035A 23 102 125
38279 38279 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600044B 111 978 1089
38280 38280 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600044B 127 602 729
38281 38281 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600071A 92 893 985
38282 38282 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600071A 158 721 879
38283 38283 YES 21132 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600073A 147 1124 1271
38284 38284 NO 21133 CULVER CITY GENERAL MUNICIPAL ELECTION - MEASURE BL 8920 1600073A 121 501 622

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]);