results

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

2,990 rows where candidate_id = 20688

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
103518 103518 YES 20688 STATE MEASURE 29 8826 0050001B 12 15 27
103520 103520 YES 20688 STATE MEASURE 29 8826 0050002C 1 0 1
103522 103522 YES 20688 STATE MEASURE 29 8826 0050003A 64 166 230
103524 103524 YES 20688 STATE MEASURE 29 8826 0050004B 10 30 40
103526 103526 YES 20688 STATE MEASURE 29 8826 0050011A 0 0 0
103528 103528 YES 20688 STATE MEASURE 29 8826 0050014A 19 48 67
103530 103530 YES 20688 STATE MEASURE 29 8826 0050023A 0 0 0
103532 103532 YES 20688 STATE MEASURE 29 8826 0050042A 0 0 0
103534 103534 YES 20688 STATE MEASURE 29 8826 0050063A 80 174 254
103536 103536 YES 20688 STATE MEASURE 29 8826 0070001B 3 10 13
103538 103538 YES 20688 STATE MEASURE 29 8826 0070002A 1 7 8
103540 103540 YES 20688 STATE MEASURE 29 8826 0070004C 2 10 12
103542 103542 YES 20688 STATE MEASURE 29 8826 0070004E 9 54 63
103544 103544 YES 20688 STATE MEASURE 29 8826 0070006N 4 8 12
103546 103546 YES 20688 STATE MEASURE 29 8826 0070007A 28 147 175
103548 103548 YES 20688 STATE MEASURE 29 8826 0070008A 22 88 110
103550 103550 YES 20688 STATE MEASURE 29 8826 0070027B 0 2 2
103552 103552 YES 20688 STATE MEASURE 29 8826 0070041A 27 157 184
103554 103554 YES 20688 STATE MEASURE 29 8826 0070041B 11 33 44
103556 103556 YES 20688 STATE MEASURE 29 8826 0070041K 1 4 5
103558 103558 YES 20688 STATE MEASURE 29 8826 0070207A 1 9 10
103560 103560 YES 20688 STATE MEASURE 29 8826 0080004A 55 278 333
103562 103562 YES 20688 STATE MEASURE 29 8826 0080012A 39 293 332
103564 103564 YES 20688 STATE MEASURE 29 8826 0080021A 76 405 481
103566 103566 YES 20688 STATE MEASURE 29 8826 0080025A 42 295 337
103568 103568 YES 20688 STATE MEASURE 29 8826 0080038A 46 189 235
103570 103570 YES 20688 STATE MEASURE 29 8826 0080043A 48 322 370
103572 103572 YES 20688 STATE MEASURE 29 8826 0080050A 54 313 367
103574 103574 YES 20688 STATE MEASURE 29 8826 0090002B 0 3 3
103576 103576 YES 20688 STATE MEASURE 29 8826 0090003A 77 253 330
103578 103578 YES 20688 STATE MEASURE 29 8826 0090006A 2 8 10
103580 103580 YES 20688 STATE MEASURE 29 8826 0090011A 1 5 6
103582 103582 YES 20688 STATE MEASURE 29 8826 0090025A 1 0 1
103584 103584 YES 20688 STATE MEASURE 29 8826 0150004A 71 420 491
103586 103586 YES 20688 STATE MEASURE 29 8826 0150008A 60 187 247
103588 103588 YES 20688 STATE MEASURE 29 8826 0150009A 62 265 327
103590 103590 YES 20688 STATE MEASURE 29 8826 0150011A 66 315 381
103592 103592 YES 20688 STATE MEASURE 29 8826 0150012A 95 406 501
103594 103594 YES 20688 STATE MEASURE 29 8826 0150016D 101 482 583
103596 103596 YES 20688 STATE MEASURE 29 8826 0150018A 97 456 553
103598 103598 YES 20688 STATE MEASURE 29 8826 0150021A 25 179 204
103600 103600 YES 20688 STATE MEASURE 29 8826 0150025A 65 318 383
103602 103602 YES 20688 STATE MEASURE 29 8826 0150028B 35 200 235
103604 103604 YES 20688 STATE MEASURE 29 8826 0150032A 88 400 488
103606 103606 YES 20688 STATE MEASURE 29 8826 0150033A 76 237 313
103608 103608 YES 20688 STATE MEASURE 29 8826 0150037A 43 178 221
103610 103610 YES 20688 STATE MEASURE 29 8826 0150042A 64 353 417
103612 103612 YES 20688 STATE MEASURE 29 8826 0150049A 73 354 427
103614 103614 YES 20688 STATE MEASURE 29 8826 0150060A 45 258 303
103616 103616 YES 20688 STATE MEASURE 29 8826 0150065A 56 158 214
103618 103618 YES 20688 STATE MEASURE 29 8826 0150067A 96 369 465
103620 103620 YES 20688 STATE MEASURE 29 8826 0150070A 22 74 96
103622 103622 YES 20688 STATE MEASURE 29 8826 0150071A 32 205 237
103624 103624 YES 20688 STATE MEASURE 29 8826 0180002A 24 119 143
103626 103626 YES 20688 STATE MEASURE 29 8826 0200002A 55 210 265
103628 103628 YES 20688 STATE MEASURE 29 8826 0200007B 3 29 32
103630 103630 YES 20688 STATE MEASURE 29 8826 0200013A 120 556 676
103632 103632 YES 20688 STATE MEASURE 29 8826 0200014A 106 405 511
103634 103634 YES 20688 STATE MEASURE 29 8826 0200016A 89 375 464
103636 103636 YES 20688 STATE MEASURE 29 8826 0200017A 54 315 369
103638 103638 YES 20688 STATE MEASURE 29 8826 0200019B 85 333 418
103640 103640 YES 20688 STATE MEASURE 29 8826 0200028A 62 296 358
103642 103642 YES 20688 STATE MEASURE 29 8826 0200030A 112 601 713
103644 103644 YES 20688 STATE MEASURE 29 8826 0200031A 0 3 3
103646 103646 YES 20688 STATE MEASURE 29 8826 0200040A 84 463 547
103648 103648 YES 20688 STATE MEASURE 29 8826 0200051A 49 287 336
103650 103650 YES 20688 STATE MEASURE 29 8826 0200087A 130 523 653
103652 103652 YES 20688 STATE MEASURE 29 8826 0200088A 107 510 617
103654 103654 YES 20688 STATE MEASURE 29 8826 0200091A 67 313 380
103656 103656 YES 20688 STATE MEASURE 29 8826 0300001D 5 14 19
103658 103658 YES 20688 STATE MEASURE 29 8826 0300002A 7 10 17
103660 103660 YES 20688 STATE MEASURE 29 8826 0300002B 2 3 5
103662 103662 YES 20688 STATE MEASURE 29 8826 0300002D 0 0 0
103664 103664 YES 20688 STATE MEASURE 29 8826 0300003A 1 2 3
103666 103666 YES 20688 STATE MEASURE 29 8826 0300013A 16 30 46
103668 103668 YES 20688 STATE MEASURE 29 8826 0350005B 11 113 124
103670 103670 YES 20688 STATE MEASURE 29 8826 0350007A 41 251 292
103672 103672 YES 20688 STATE MEASURE 29 8826 0350008A 69 387 456
103674 103674 YES 20688 STATE MEASURE 29 8826 0350012A 40 153 193
103676 103676 YES 20688 STATE MEASURE 29 8826 0350017A 56 424 480
103678 103678 YES 20688 STATE MEASURE 29 8826 0350022A 92 447 539
103680 103680 YES 20688 STATE MEASURE 29 8826 0350027A 62 244 306
103682 103682 YES 20688 STATE MEASURE 29 8826 0350029A 59 394 453
103684 103684 YES 20688 STATE MEASURE 29 8826 0350038A 18 109 127
103686 103686 YES 20688 STATE MEASURE 29 8826 0350043A 61 365 426
103688 103688 YES 20688 STATE MEASURE 29 8826 0350049A 51 351 402
103690 103690 YES 20688 STATE MEASURE 29 8826 0350052A 0 3 3
103692 103692 YES 20688 STATE MEASURE 29 8826 0350057A 31 161 192
103694 103694 YES 20688 STATE MEASURE 29 8826 0350058C 64 412 476
103696 103696 YES 20688 STATE MEASURE 29 8826 0350061A 0 3 3
103698 103698 YES 20688 STATE MEASURE 29 8826 0350101A 0 0 0
103700 103700 YES 20688 STATE MEASURE 29 8826 0350102A 20 120 140
103702 103702 YES 20688 STATE MEASURE 29 8826 0350104E 3 9 12
103704 103704 YES 20688 STATE MEASURE 29 8826 0350105A 0 9 9
103706 103706 YES 20688 STATE MEASURE 29 8826 0350106A 1 6 7
103708 103708 YES 20688 STATE MEASURE 29 8826 0350106B 4 7 11
103710 103710 YES 20688 STATE MEASURE 29 8826 0400001A 30 116 146
103712 103712 YES 20688 STATE MEASURE 29 8826 0400006A 73 249 322
103714 103714 YES 20688 STATE MEASURE 29 8826 0400008A 73 200 273
103716 103716 YES 20688 STATE MEASURE 29 8826 0400010A 108 432 540

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