results

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

5,980 rows where contest_id = 8878

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
264245 264245 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050001B 15 30 45
264246 264246 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050001B 16 19 35
264247 264247 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050002C 2 0 2
264248 264248 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050002C 1 0 1
264249 264249 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050003A 97 265 362
264250 264250 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050003A 234 208 442
264251 264251 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050004B 12 72 84
264252 264252 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050004B 63 41 104
264253 264253 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050011A 0 0 0
264254 264254 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050011A 0 1 1
264255 264255 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050014A 23 93 116
264256 264256 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050014A 58 104 162
264257 264257 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050023A 0 0 0
264258 264258 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050023A 3 0 3
264259 264259 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050042A 0 2 2
264260 264260 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050042A 0 0 0
264261 264261 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050063A 119 335 454
264262 264262 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050063A 251 318 569
264263 264263 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070001B 3 20 23
264264 264264 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070001B 2 3 5
264265 264265 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070002A 2 25 27
264266 264266 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070002A 3 13 16
264267 264267 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070004C 4 21 25
264268 264268 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070004C 3 11 14
264269 264269 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070004E 13 88 101
264270 264270 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070004E 10 22 32
264271 264271 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070006N 8 15 23
264272 264272 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070006N 2 15 17
264273 264273 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070007A 45 286 331
264274 264274 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070007A 41 62 103
264275 264275 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070008A 33 198 231
264276 264276 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070008A 39 78 117
264277 264277 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070027B 0 2 2
264278 264278 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070027B 0 0 0
264279 264279 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070041A 54 294 348
264280 264280 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070041A 81 139 220
264281 264281 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070041B 16 69 85
264282 264282 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070041B 18 21 39
264283 264283 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070041K 1 7 8
264284 264284 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070041K 1 1 2
264285 264285 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070207A 1 16 17
264286 264286 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070207A 0 12 12
264287 264287 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080004A 94 583 677
264288 264288 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080004A 92 188 280
264289 264289 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080012A 69 644 713
264290 264290 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080012A 79 195 274
264291 264291 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080021A 108 788 896
264292 264292 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080021A 123 246 369
264293 264293 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080025A 77 530 607
264294 264294 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080025A 77 142 219
264295 264295 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080038A 73 346 419
264296 264296 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080038A 68 135 203
264297 264297 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080043A 73 511 584
264298 264298 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080043A 64 162 226
264299 264299 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080050A 91 597 688
264300 264300 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080050A 92 219 311
264301 264301 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090002B 1 3 4
264302 264302 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090002B 1 1 2
264303 264303 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090003A 102 423 525
264304 264304 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090003A 307 376 683
264305 264305 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090006A 0 7 7
264306 264306 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090006A 7 10 17
264307 264307 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090011A 0 13 13
264308 264308 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090011A 0 8 8
264309 264309 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090025A 1 4 5
264310 264310 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090025A 0 0 0
264311 264311 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150004A 111 611 722
264312 264312 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150004A 64 163 227
264313 264313 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150008A 73 252 325
264314 264314 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150008A 43 60 103
264315 264315 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150009A 76 414 490
264316 264316 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150009A 45 67 112
264317 264317 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150011A 77 497 574
264318 264318 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150011A 61 95 156
264319 264319 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150012A 119 616 735
264320 264320 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150012A 71 124 195
264321 264321 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150016D 109 706 815
264322 264322 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150016D 120 186 306
264323 264323 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150018A 139 712 851
264324 264324 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150018A 68 172 240
264325 264325 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150021A 45 313 358
264326 264326 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150021A 28 55 83
264327 264327 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150025A 107 513 620
264328 264328 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150025A 54 131 185
264329 264329 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150028B 42 332 374
264330 264330 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150028B 26 70 96
264331 264331 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150032A 123 513 636
264332 264332 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150032A 66 143 209
264333 264333 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150033A 94 352 446
264334 264334 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150033A 41 98 139
264335 264335 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150037A 48 285 333
264336 264336 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150037A 34 68 102
264337 264337 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150042A 77 461 538
264338 264338 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150042A 40 107 147
264339 264339 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150049A 107 506 613
264340 264340 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150049A 58 130 188
264341 264341 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150060A 58 362 420
264342 264342 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150060A 29 91 120
264343 264343 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150065A 61 251 312
264344 264344 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150065A 44 58 102

Next page

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