results

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

5,980 rows where contest_id = 8823

✎ 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
25347 25347 YES 20681 STATE MEASURE 26 8823 0050001B 12 17 29
25348 25348 NO 20682 STATE MEASURE 26 8823 0050001B 31 48 79
25349 25349 YES 20681 STATE MEASURE 26 8823 0050002C 3 0 3
25350 25350 NO 20682 STATE MEASURE 26 8823 0050002C 1 0 1
25351 25351 YES 20681 STATE MEASURE 26 8823 0050003A 99 188 287
25352 25352 NO 20682 STATE MEASURE 26 8823 0050003A 312 462 774
25353 25353 YES 20681 STATE MEASURE 26 8823 0050004B 27 43 70
25354 25354 NO 20682 STATE MEASURE 26 8823 0050004B 80 110 190
25355 25355 YES 20681 STATE MEASURE 26 8823 0050011A 0 0 0
25356 25356 NO 20682 STATE MEASURE 26 8823 0050011A 1 1 2
25357 25357 YES 20681 STATE MEASURE 26 8823 0050014A 19 63 82
25358 25358 NO 20682 STATE MEASURE 26 8823 0050014A 89 223 312
25359 25359 YES 20681 STATE MEASURE 26 8823 0050023A 0 0 0
25360 25360 NO 20682 STATE MEASURE 26 8823 0050023A 4 0 4
25361 25361 YES 20681 STATE MEASURE 26 8823 0050042A 0 0 0
25362 25362 NO 20682 STATE MEASURE 26 8823 0050042A 0 2 2
25363 25363 YES 20681 STATE MEASURE 26 8823 0050063A 107 223 330
25364 25364 NO 20682 STATE MEASURE 26 8823 0050063A 365 646 1011
25365 25365 YES 20681 STATE MEASURE 26 8823 0070001B 2 7 9
25366 25366 NO 20682 STATE MEASURE 26 8823 0070001B 3 27 30
25367 25367 YES 20681 STATE MEASURE 26 8823 0070002A 1 10 11
25368 25368 NO 20682 STATE MEASURE 26 8823 0070002A 6 36 42
25369 25369 YES 20681 STATE MEASURE 26 8823 0070004C 5 12 17
25370 25370 NO 20682 STATE MEASURE 26 8823 0070004C 6 27 33
25371 25371 YES 20681 STATE MEASURE 26 8823 0070004E 7 41 48
25372 25372 NO 20682 STATE MEASURE 26 8823 0070004E 24 109 133
25373 25373 YES 20681 STATE MEASURE 26 8823 0070006N 2 8 10
25374 25374 NO 20682 STATE MEASURE 26 8823 0070006N 10 29 39
25375 25375 YES 20681 STATE MEASURE 26 8823 0070007A 28 157 185
25376 25376 NO 20682 STATE MEASURE 26 8823 0070007A 94 317 411
25377 25377 YES 20681 STATE MEASURE 26 8823 0070008A 28 115 143
25378 25378 NO 20682 STATE MEASURE 26 8823 0070008A 66 264 330
25379 25379 YES 20681 STATE MEASURE 26 8823 0070027B 0 2 2
25380 25380 NO 20682 STATE MEASURE 26 8823 0070027B 0 0 0
25381 25381 YES 20681 STATE MEASURE 26 8823 0070041A 41 199 240
25382 25382 NO 20682 STATE MEASURE 26 8823 0070041A 128 411 539
25383 25383 YES 20681 STATE MEASURE 26 8823 0070041B 19 48 67
25384 25384 NO 20682 STATE MEASURE 26 8823 0070041B 20 78 98
25385 25385 YES 20681 STATE MEASURE 26 8823 0070041K 0 1 1
25386 25386 NO 20682 STATE MEASURE 26 8823 0070041K 3 9 12
25387 25387 YES 20681 STATE MEASURE 26 8823 0070207A 0 11 11
25388 25388 NO 20682 STATE MEASURE 26 8823 0070207A 1 23 24
25389 25389 YES 20681 STATE MEASURE 26 8823 0080004A 87 355 442
25390 25390 NO 20682 STATE MEASURE 26 8823 0080004A 168 714 882
25391 25391 YES 20681 STATE MEASURE 26 8823 0080012A 56 362 418
25392 25392 NO 20682 STATE MEASURE 26 8823 0080012A 151 847 998
25393 25393 YES 20681 STATE MEASURE 26 8823 0080021A 70 482 552
25394 25394 NO 20682 STATE MEASURE 26 8823 0080021A 235 971 1206
25395 25395 YES 20681 STATE MEASURE 26 8823 0080025A 64 309 373
25396 25396 NO 20682 STATE MEASURE 26 8823 0080025A 144 642 786
25397 25397 YES 20681 STATE MEASURE 26 8823 0080038A 62 247 309
25398 25398 NO 20682 STATE MEASURE 26 8823 0080038A 126 448 574
25399 25399 YES 20681 STATE MEASURE 26 8823 0080043A 61 341 402
25400 25400 NO 20682 STATE MEASURE 26 8823 0080043A 132 615 747
25401 25401 YES 20681 STATE MEASURE 26 8823 0080050A 72 342 414
25402 25402 NO 20682 STATE MEASURE 26 8823 0080050A 173 769 942
25403 25403 YES 20681 STATE MEASURE 26 8823 0090002B 5 6 11
25404 25404 NO 20682 STATE MEASURE 26 8823 0090002B 1 8 9
25405 25405 YES 20681 STATE MEASURE 26 8823 0090003A 112 292 404
25406 25406 NO 20682 STATE MEASURE 26 8823 0090003A 407 816 1223
25407 25407 YES 20681 STATE MEASURE 26 8823 0090006A 2 12 14
25408 25408 NO 20682 STATE MEASURE 26 8823 0090006A 5 16 21
25409 25409 YES 20681 STATE MEASURE 26 8823 0090011A 0 9 9
25410 25410 NO 20682 STATE MEASURE 26 8823 0090011A 0 19 19
25411 25411 YES 20681 STATE MEASURE 26 8823 0090025A 0 3 3
25412 25412 NO 20682 STATE MEASURE 26 8823 0090025A 1 1 2
25413 25413 YES 20681 STATE MEASURE 26 8823 0150004A 55 411 466
25414 25414 NO 20682 STATE MEASURE 26 8823 0150004A 161 669 830
25415 25415 YES 20681 STATE MEASURE 26 8823 0150008A 56 185 241
25416 25416 NO 20682 STATE MEASURE 26 8823 0150008A 85 238 323
25417 25417 YES 20681 STATE MEASURE 26 8823 0150009A 54 250 304
25418 25418 NO 20682 STATE MEASURE 26 8823 0150009A 89 338 427
25419 25419 YES 20681 STATE MEASURE 26 8823 0150011A 69 276 345
25420 25420 NO 20682 STATE MEASURE 26 8823 0150011A 102 503 605
25421 25421 YES 20681 STATE MEASURE 26 8823 0150012A 88 372 460
25422 25422 NO 20682 STATE MEASURE 26 8823 0150012A 145 578 723
25423 25423 YES 20681 STATE MEASURE 26 8823 0150016D 78 424 502
25424 25424 NO 20682 STATE MEASURE 26 8823 0150016D 210 724 934
25425 25425 YES 20681 STATE MEASURE 26 8823 0150018A 91 413 504
25426 25426 NO 20682 STATE MEASURE 26 8823 0150018A 164 684 848
25427 25427 YES 20681 STATE MEASURE 26 8823 0150021A 34 164 198
25428 25428 NO 20682 STATE MEASURE 26 8823 0150021A 61 310 371
25429 25429 YES 20681 STATE MEASURE 26 8823 0150025A 67 351 418
25430 25430 NO 20682 STATE MEASURE 26 8823 0150025A 129 435 564
25431 25431 YES 20681 STATE MEASURE 26 8823 0150028B 28 202 230
25432 25432 NO 20682 STATE MEASURE 26 8823 0150028B 58 336 394
25433 25433 YES 20681 STATE MEASURE 26 8823 0150032A 84 340 424
25434 25434 NO 20682 STATE MEASURE 26 8823 0150032A 152 521 673
25435 25435 YES 20681 STATE MEASURE 26 8823 0150033A 60 232 292
25436 25436 NO 20682 STATE MEASURE 26 8823 0150033A 104 344 448
25437 25437 YES 20681 STATE MEASURE 26 8823 0150037A 39 159 198
25438 25438 NO 20682 STATE MEASURE 26 8823 0150037A 63 302 365
25439 25439 YES 20681 STATE MEASURE 26 8823 0150042A 50 279 329
25440 25440 NO 20682 STATE MEASURE 26 8823 0150042A 105 454 559
25441 25441 YES 20681 STATE MEASURE 26 8823 0150049A 75 328 403
25442 25442 NO 20682 STATE MEASURE 26 8823 0150049A 118 495 613
25443 25443 YES 20681 STATE MEASURE 26 8823 0150060A 49 231 280
25444 25444 NO 20682 STATE MEASURE 26 8823 0150060A 54 319 373
25445 25445 YES 20681 STATE MEASURE 26 8823 0150065A 45 126 171
25446 25446 NO 20682 STATE MEASURE 26 8823 0150065A 82 256 338

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