results

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

2,990 rows where candidate_id = 20689

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
103519 103519 NO 20689 STATE MEASURE 29 8826 0050001B 32 51 83
103521 103521 NO 20689 STATE MEASURE 29 8826 0050002C 2 0 2
103523 103523 NO 20689 STATE MEASURE 29 8826 0050003A 341 492 833
103525 103525 NO 20689 STATE MEASURE 29 8826 0050004B 95 120 215
103527 103527 NO 20689 STATE MEASURE 29 8826 0050011A 1 1 2
103529 103529 NO 20689 STATE MEASURE 29 8826 0050014A 88 234 322
103531 103531 NO 20689 STATE MEASURE 29 8826 0050023A 4 0 4
103533 103533 NO 20689 STATE MEASURE 29 8826 0050042A 0 2 2
103535 103535 NO 20689 STATE MEASURE 29 8826 0050063A 391 688 1079
103537 103537 NO 20689 STATE MEASURE 29 8826 0070001B 2 24 26
103539 103539 NO 20689 STATE MEASURE 29 8826 0070002A 6 38 44
103541 103541 NO 20689 STATE MEASURE 29 8826 0070004C 6 28 34
103543 103543 NO 20689 STATE MEASURE 29 8826 0070004E 22 95 117
103545 103545 NO 20689 STATE MEASURE 29 8826 0070006N 8 30 38
103547 103547 NO 20689 STATE MEASURE 29 8826 0070007A 94 327 421
103549 103549 NO 20689 STATE MEASURE 29 8826 0070008A 69 283 352
103551 103551 NO 20689 STATE MEASURE 29 8826 0070027B 0 0 0
103553 103553 NO 20689 STATE MEASURE 29 8826 0070041A 140 454 594
103555 103555 NO 20689 STATE MEASURE 29 8826 0070041B 28 95 123
103557 103557 NO 20689 STATE MEASURE 29 8826 0070041K 2 6 8
103559 103559 NO 20689 STATE MEASURE 29 8826 0070207A 0 24 24
103561 103561 NO 20689 STATE MEASURE 29 8826 0080004A 197 776 973
103563 103563 NO 20689 STATE MEASURE 29 8826 0080012A 169 899 1068
103565 103565 NO 20689 STATE MEASURE 29 8826 0080021A 226 1032 1258
103567 103567 NO 20689 STATE MEASURE 29 8826 0080025A 167 648 815
103569 103569 NO 20689 STATE MEASURE 29 8826 0080038A 139 505 644
103571 103571 NO 20689 STATE MEASURE 29 8826 0080043A 142 642 784
103573 103573 NO 20689 STATE MEASURE 29 8826 0080050A 196 800 996
103575 103575 NO 20689 STATE MEASURE 29 8826 0090002B 5 9 14
103577 103577 NO 20689 STATE MEASURE 29 8826 0090003A 441 857 1298
103579 103579 NO 20689 STATE MEASURE 29 8826 0090006A 5 19 24
103581 103581 NO 20689 STATE MEASURE 29 8826 0090011A 0 24 24
103583 103583 NO 20689 STATE MEASURE 29 8826 0090025A 0 4 4
103585 103585 NO 20689 STATE MEASURE 29 8826 0150004A 147 663 810
103587 103587 NO 20689 STATE MEASURE 29 8826 0150008A 79 242 321
103589 103589 NO 20689 STATE MEASURE 29 8826 0150009A 80 324 404
103591 103591 NO 20689 STATE MEASURE 29 8826 0150011A 110 470 580
103593 103593 NO 20689 STATE MEASURE 29 8826 0150012A 138 551 689
103595 103595 NO 20689 STATE MEASURE 29 8826 0150016D 186 672 858
103597 103597 NO 20689 STATE MEASURE 29 8826 0150018A 156 648 804
103599 103599 NO 20689 STATE MEASURE 29 8826 0150021A 71 296 367
103601 103601 NO 20689 STATE MEASURE 29 8826 0150025A 133 475 608
103603 103603 NO 20689 STATE MEASURE 29 8826 0150028B 50 342 392
103605 103605 NO 20689 STATE MEASURE 29 8826 0150032A 148 469 617
103607 103607 NO 20689 STATE MEASURE 29 8826 0150033A 89 341 430
103609 103609 NO 20689 STATE MEASURE 29 8826 0150037A 59 286 345
103611 103611 NO 20689 STATE MEASURE 29 8826 0150042A 88 393 481
103613 103613 NO 20689 STATE MEASURE 29 8826 0150049A 125 469 594
103615 103615 NO 20689 STATE MEASURE 29 8826 0150060A 60 300 360
103617 103617 NO 20689 STATE MEASURE 29 8826 0150065A 72 233 305
103619 103619 NO 20689 STATE MEASURE 29 8826 0150067A 177 548 725
103621 103621 NO 20689 STATE MEASURE 29 8826 0150070A 47 139 186
103623 103623 NO 20689 STATE MEASURE 29 8826 0150071A 76 310 386
103625 103625 NO 20689 STATE MEASURE 29 8826 0180002A 40 102 142
103627 103627 NO 20689 STATE MEASURE 29 8826 0200002A 75 451 526
103629 103629 NO 20689 STATE MEASURE 29 8826 0200007B 13 69 82
103631 103631 NO 20689 STATE MEASURE 29 8826 0200013A 129 787 916
103633 103633 NO 20689 STATE MEASURE 29 8826 0200014A 160 638 798
103635 103635 NO 20689 STATE MEASURE 29 8826 0200016A 181 797 978
103637 103637 NO 20689 STATE MEASURE 29 8826 0200017A 92 410 502
103639 103639 NO 20689 STATE MEASURE 29 8826 0200019B 87 544 631
103641 103641 NO 20689 STATE MEASURE 29 8826 0200028A 127 630 757
103643 103643 NO 20689 STATE MEASURE 29 8826 0200030A 302 1497 1799
103645 103645 NO 20689 STATE MEASURE 29 8826 0200031A 0 0 0
103647 103647 NO 20689 STATE MEASURE 29 8826 0200040A 181 769 950
103649 103649 NO 20689 STATE MEASURE 29 8826 0200051A 97 536 633
103651 103651 NO 20689 STATE MEASURE 29 8826 0200087A 214 888 1102
103653 103653 NO 20689 STATE MEASURE 29 8826 0200088A 189 872 1061
103655 103655 NO 20689 STATE MEASURE 29 8826 0200091A 98 422 520
103657 103657 NO 20689 STATE MEASURE 29 8826 0300001D 9 34 43
103659 103659 NO 20689 STATE MEASURE 29 8826 0300002A 19 35 54
103661 103661 NO 20689 STATE MEASURE 29 8826 0300002B 3 11 14
103663 103663 NO 20689 STATE MEASURE 29 8826 0300002D 0 2 2
103665 103665 NO 20689 STATE MEASURE 29 8826 0300003A 7 23 30
103667 103667 NO 20689 STATE MEASURE 29 8826 0300013A 38 86 124
103669 103669 NO 20689 STATE MEASURE 29 8826 0350005B 44 221 265
103671 103671 NO 20689 STATE MEASURE 29 8826 0350007A 133 782 915
103673 103673 NO 20689 STATE MEASURE 29 8826 0350008A 150 906 1056
103675 103675 NO 20689 STATE MEASURE 29 8826 0350012A 85 356 441
103677 103677 NO 20689 STATE MEASURE 29 8826 0350017A 142 920 1062
103679 103679 NO 20689 STATE MEASURE 29 8826 0350022A 160 574 734
103681 103681 NO 20689 STATE MEASURE 29 8826 0350027A 111 362 473
103683 103683 NO 20689 STATE MEASURE 29 8826 0350029A 173 893 1066
103685 103685 NO 20689 STATE MEASURE 29 8826 0350038A 35 215 250
103687 103687 NO 20689 STATE MEASURE 29 8826 0350043A 135 524 659
103689 103689 NO 20689 STATE MEASURE 29 8826 0350049A 123 690 813
103691 103691 NO 20689 STATE MEASURE 29 8826 0350052A 4 11 15
103693 103693 NO 20689 STATE MEASURE 29 8826 0350057A 87 300 387
103695 103695 NO 20689 STATE MEASURE 29 8826 0350058C 160 975 1135
103697 103697 NO 20689 STATE MEASURE 29 8826 0350061A 6 6 12
103699 103699 NO 20689 STATE MEASURE 29 8826 0350101A 0 5 5
103701 103701 NO 20689 STATE MEASURE 29 8826 0350102A 45 194 239
103703 103703 NO 20689 STATE MEASURE 29 8826 0350104E 2 39 41
103705 103705 NO 20689 STATE MEASURE 29 8826 0350105A 2 6 8
103707 103707 NO 20689 STATE MEASURE 29 8826 0350106A 7 35 42
103709 103709 NO 20689 STATE MEASURE 29 8826 0350106B 2 23 25
103711 103711 NO 20689 STATE MEASURE 29 8826 0400001A 53 142 195
103713 103713 NO 20689 STATE MEASURE 29 8826 0400006A 131 357 488
103715 103715 NO 20689 STATE MEASURE 29 8826 0400008A 129 397 526
103717 103717 NO 20689 STATE MEASURE 29 8826 0400010A 193 644 837

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