results

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

2,990 rows where candidate_id = 20681

✎ View and edit SQL

This data as json, CSV (advanced)

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
25349 25349 YES 20681 STATE MEASURE 26 8823 0050002C 3 0 3
25351 25351 YES 20681 STATE MEASURE 26 8823 0050003A 99 188 287
25353 25353 YES 20681 STATE MEASURE 26 8823 0050004B 27 43 70
25355 25355 YES 20681 STATE MEASURE 26 8823 0050011A 0 0 0
25357 25357 YES 20681 STATE MEASURE 26 8823 0050014A 19 63 82
25359 25359 YES 20681 STATE MEASURE 26 8823 0050023A 0 0 0
25361 25361 YES 20681 STATE MEASURE 26 8823 0050042A 0 0 0
25363 25363 YES 20681 STATE MEASURE 26 8823 0050063A 107 223 330
25365 25365 YES 20681 STATE MEASURE 26 8823 0070001B 2 7 9
25367 25367 YES 20681 STATE MEASURE 26 8823 0070002A 1 10 11
25369 25369 YES 20681 STATE MEASURE 26 8823 0070004C 5 12 17
25371 25371 YES 20681 STATE MEASURE 26 8823 0070004E 7 41 48
25373 25373 YES 20681 STATE MEASURE 26 8823 0070006N 2 8 10
25375 25375 YES 20681 STATE MEASURE 26 8823 0070007A 28 157 185
25377 25377 YES 20681 STATE MEASURE 26 8823 0070008A 28 115 143
25379 25379 YES 20681 STATE MEASURE 26 8823 0070027B 0 2 2
25381 25381 YES 20681 STATE MEASURE 26 8823 0070041A 41 199 240
25383 25383 YES 20681 STATE MEASURE 26 8823 0070041B 19 48 67
25385 25385 YES 20681 STATE MEASURE 26 8823 0070041K 0 1 1
25387 25387 YES 20681 STATE MEASURE 26 8823 0070207A 0 11 11
25389 25389 YES 20681 STATE MEASURE 26 8823 0080004A 87 355 442
25391 25391 YES 20681 STATE MEASURE 26 8823 0080012A 56 362 418
25393 25393 YES 20681 STATE MEASURE 26 8823 0080021A 70 482 552
25395 25395 YES 20681 STATE MEASURE 26 8823 0080025A 64 309 373
25397 25397 YES 20681 STATE MEASURE 26 8823 0080038A 62 247 309
25399 25399 YES 20681 STATE MEASURE 26 8823 0080043A 61 341 402
25401 25401 YES 20681 STATE MEASURE 26 8823 0080050A 72 342 414
25403 25403 YES 20681 STATE MEASURE 26 8823 0090002B 5 6 11
25405 25405 YES 20681 STATE MEASURE 26 8823 0090003A 112 292 404
25407 25407 YES 20681 STATE MEASURE 26 8823 0090006A 2 12 14
25409 25409 YES 20681 STATE MEASURE 26 8823 0090011A 0 9 9
25411 25411 YES 20681 STATE MEASURE 26 8823 0090025A 0 3 3
25413 25413 YES 20681 STATE MEASURE 26 8823 0150004A 55 411 466
25415 25415 YES 20681 STATE MEASURE 26 8823 0150008A 56 185 241
25417 25417 YES 20681 STATE MEASURE 26 8823 0150009A 54 250 304
25419 25419 YES 20681 STATE MEASURE 26 8823 0150011A 69 276 345
25421 25421 YES 20681 STATE MEASURE 26 8823 0150012A 88 372 460
25423 25423 YES 20681 STATE MEASURE 26 8823 0150016D 78 424 502
25425 25425 YES 20681 STATE MEASURE 26 8823 0150018A 91 413 504
25427 25427 YES 20681 STATE MEASURE 26 8823 0150021A 34 164 198
25429 25429 YES 20681 STATE MEASURE 26 8823 0150025A 67 351 418
25431 25431 YES 20681 STATE MEASURE 26 8823 0150028B 28 202 230
25433 25433 YES 20681 STATE MEASURE 26 8823 0150032A 84 340 424
25435 25435 YES 20681 STATE MEASURE 26 8823 0150033A 60 232 292
25437 25437 YES 20681 STATE MEASURE 26 8823 0150037A 39 159 198
25439 25439 YES 20681 STATE MEASURE 26 8823 0150042A 50 279 329
25441 25441 YES 20681 STATE MEASURE 26 8823 0150049A 75 328 403
25443 25443 YES 20681 STATE MEASURE 26 8823 0150060A 49 231 280
25445 25445 YES 20681 STATE MEASURE 26 8823 0150065A 45 126 171
25447 25447 YES 20681 STATE MEASURE 26 8823 0150067A 88 344 432
25449 25449 YES 20681 STATE MEASURE 26 8823 0150070A 32 80 112
25451 25451 YES 20681 STATE MEASURE 26 8823 0150071A 36 207 243
25453 25453 YES 20681 STATE MEASURE 26 8823 0180002A 22 79 101
25455 25455 YES 20681 STATE MEASURE 26 8823 0200002A 48 191 239
25457 25457 YES 20681 STATE MEASURE 26 8823 0200007B 2 24 26
25459 25459 YES 20681 STATE MEASURE 26 8823 0200013A 105 501 606
25461 25461 YES 20681 STATE MEASURE 26 8823 0200014A 92 392 484
25463 25463 YES 20681 STATE MEASURE 26 8823 0200016A 76 355 431
25465 25465 YES 20681 STATE MEASURE 26 8823 0200017A 42 264 306
25467 25467 YES 20681 STATE MEASURE 26 8823 0200019B 53 269 322
25469 25469 YES 20681 STATE MEASURE 26 8823 0200028A 58 270 328
25471 25471 YES 20681 STATE MEASURE 26 8823 0200030A 95 491 586
25473 25473 YES 20681 STATE MEASURE 26 8823 0200031A 0 3 3
25475 25475 YES 20681 STATE MEASURE 26 8823 0200040A 80 390 470
25477 25477 YES 20681 STATE MEASURE 26 8823 0200051A 37 239 276
25479 25479 YES 20681 STATE MEASURE 26 8823 0200087A 104 450 554
25481 25481 YES 20681 STATE MEASURE 26 8823 0200088A 88 480 568
25483 25483 YES 20681 STATE MEASURE 26 8823 0200091A 49 251 300
25485 25485 YES 20681 STATE MEASURE 26 8823 0300001D 4 12 16
25487 25487 YES 20681 STATE MEASURE 26 8823 0300002A 7 19 26
25489 25489 YES 20681 STATE MEASURE 26 8823 0300002B 3 4 7
25491 25491 YES 20681 STATE MEASURE 26 8823 0300002D 0 0 0
25493 25493 YES 20681 STATE MEASURE 26 8823 0300003A 1 5 6
25495 25495 YES 20681 STATE MEASURE 26 8823 0300013A 7 33 40
25497 25497 YES 20681 STATE MEASURE 26 8823 0350005B 12 110 122
25499 25499 YES 20681 STATE MEASURE 26 8823 0350007A 33 348 381
25501 25501 YES 20681 STATE MEASURE 26 8823 0350008A 68 406 474
25503 25503 YES 20681 STATE MEASURE 26 8823 0350012A 26 187 213
25505 25505 YES 20681 STATE MEASURE 26 8823 0350017A 47 393 440
25507 25507 YES 20681 STATE MEASURE 26 8823 0350022A 96 418 514
25509 25509 YES 20681 STATE MEASURE 26 8823 0350027A 62 243 305
25511 25511 YES 20681 STATE MEASURE 26 8823 0350029A 61 421 482
25513 25513 YES 20681 STATE MEASURE 26 8823 0350038A 29 126 155
25515 25515 YES 20681 STATE MEASURE 26 8823 0350043A 69 352 421
25517 25517 YES 20681 STATE MEASURE 26 8823 0350049A 56 432 488
25519 25519 YES 20681 STATE MEASURE 26 8823 0350052A 0 4 4
25521 25521 YES 20681 STATE MEASURE 26 8823 0350057A 36 157 193
25523 25523 YES 20681 STATE MEASURE 26 8823 0350058C 84 510 594
25525 25525 YES 20681 STATE MEASURE 26 8823 0350061A 1 3 4
25527 25527 YES 20681 STATE MEASURE 26 8823 0350101A 0 3 3
25529 25529 YES 20681 STATE MEASURE 26 8823 0350102A 21 122 143
25531 25531 YES 20681 STATE MEASURE 26 8823 0350104E 3 14 17
25533 25533 YES 20681 STATE MEASURE 26 8823 0350105A 0 7 7
25535 25535 YES 20681 STATE MEASURE 26 8823 0350106A 3 11 14
25537 25537 YES 20681 STATE MEASURE 26 8823 0350106B 1 8 9
25539 25539 YES 20681 STATE MEASURE 26 8823 0400001A 28 87 115
25541 25541 YES 20681 STATE MEASURE 26 8823 0400006A 70 185 255
25543 25543 YES 20681 STATE MEASURE 26 8823 0400008A 76 203 279
25545 25545 YES 20681 STATE MEASURE 26 8823 0400010A 111 399 510

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