results

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

2,990 rows where candidate_id = 20686

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
116735 116735 YES 20686 STATE MEASURE 28 8825 0050001B 17 26 43
116737 116737 YES 20686 STATE MEASURE 28 8825 0050002C 2 0 2
116739 116739 YES 20686 STATE MEASURE 28 8825 0050003A 108 303 411
116741 116741 YES 20686 STATE MEASURE 28 8825 0050004B 28 73 101
116743 116743 YES 20686 STATE MEASURE 28 8825 0050011A 0 0 0
116745 116745 YES 20686 STATE MEASURE 28 8825 0050014A 34 133 167
116747 116747 YES 20686 STATE MEASURE 28 8825 0050023A 0 0 0
116749 116749 YES 20686 STATE MEASURE 28 8825 0050042A 0 0 0
116751 116751 YES 20686 STATE MEASURE 28 8825 0050063A 133 384 517
116753 116753 YES 20686 STATE MEASURE 28 8825 0070001B 2 18 20
116755 116755 YES 20686 STATE MEASURE 28 8825 0070002A 4 24 28
116757 116757 YES 20686 STATE MEASURE 28 8825 0070004C 3 23 26
116759 116759 YES 20686 STATE MEASURE 28 8825 0070004E 15 113 128
116761 116761 YES 20686 STATE MEASURE 28 8825 0070006N 9 20 29
116763 116763 YES 20686 STATE MEASURE 28 8825 0070007A 63 360 423
116765 116765 YES 20686 STATE MEASURE 28 8825 0070008A 36 204 240
116767 116767 YES 20686 STATE MEASURE 28 8825 0070027B 0 2 2
116769 116769 YES 20686 STATE MEASURE 28 8825 0070041A 75 361 436
116771 116771 YES 20686 STATE MEASURE 28 8825 0070041B 18 98 116
116773 116773 YES 20686 STATE MEASURE 28 8825 0070041K 1 8 9
116775 116775 YES 20686 STATE MEASURE 28 8825 0070207A 0 14 14
116777 116777 YES 20686 STATE MEASURE 28 8825 0080004A 113 705 818
116779 116779 YES 20686 STATE MEASURE 28 8825 0080012A 93 749 842
116781 116781 YES 20686 STATE MEASURE 28 8825 0080021A 142 980 1122
116783 116783 YES 20686 STATE MEASURE 28 8825 0080025A 88 671 759
116785 116785 YES 20686 STATE MEASURE 28 8825 0080038A 81 438 519
116787 116787 YES 20686 STATE MEASURE 28 8825 0080043A 100 659 759
116789 116789 YES 20686 STATE MEASURE 28 8825 0080050A 114 702 816
116791 116791 YES 20686 STATE MEASURE 28 8825 0090002B 2 3 5
116793 116793 YES 20686 STATE MEASURE 28 8825 0090003A 139 510 649
116795 116795 YES 20686 STATE MEASURE 28 8825 0090006A 4 10 14
116797 116797 YES 20686 STATE MEASURE 28 8825 0090011A 1 15 16
116799 116799 YES 20686 STATE MEASURE 28 8825 0090025A 1 4 5
116801 116801 YES 20686 STATE MEASURE 28 8825 0150004A 124 773 897
116803 116803 YES 20686 STATE MEASURE 28 8825 0150008A 87 312 399
116805 116805 YES 20686 STATE MEASURE 28 8825 0150009A 106 467 573
116807 116807 YES 20686 STATE MEASURE 28 8825 0150011A 100 601 701
116809 116809 YES 20686 STATE MEASURE 28 8825 0150012A 154 721 875
116811 116811 YES 20686 STATE MEASURE 28 8825 0150016D 150 815 965
116813 116813 YES 20686 STATE MEASURE 28 8825 0150018A 157 855 1012
116815 116815 YES 20686 STATE MEASURE 28 8825 0150021A 47 327 374
116817 116817 YES 20686 STATE MEASURE 28 8825 0150025A 129 603 732
116819 116819 YES 20686 STATE MEASURE 28 8825 0150028B 50 366 416
116821 116821 YES 20686 STATE MEASURE 28 8825 0150032A 149 624 773
116823 116823 YES 20686 STATE MEASURE 28 8825 0150033A 116 406 522
116825 116825 YES 20686 STATE MEASURE 28 8825 0150037A 56 322 378
116827 116827 YES 20686 STATE MEASURE 28 8825 0150042A 94 527 621
116829 116829 YES 20686 STATE MEASURE 28 8825 0150049A 115 558 673
116831 116831 YES 20686 STATE MEASURE 28 8825 0150060A 64 423 487
116833 116833 YES 20686 STATE MEASURE 28 8825 0150065A 84 271 355
116835 116835 YES 20686 STATE MEASURE 28 8825 0150067A 150 632 782
116837 116837 YES 20686 STATE MEASURE 28 8825 0150070A 36 149 185
116839 116839 YES 20686 STATE MEASURE 28 8825 0150071A 70 369 439
116841 116841 YES 20686 STATE MEASURE 28 8825 0180002A 47 167 214
116843 116843 YES 20686 STATE MEASURE 28 8825 0200002A 99 522 621
116845 116845 YES 20686 STATE MEASURE 28 8825 0200007B 7 76 83
116847 116847 YES 20686 STATE MEASURE 28 8825 0200013A 189 1162 1351
116849 116849 YES 20686 STATE MEASURE 28 8825 0200014A 203 868 1071
116851 116851 YES 20686 STATE MEASURE 28 8825 0200016A 165 886 1051
116853 116853 YES 20686 STATE MEASURE 28 8825 0200017A 113 619 732
116855 116855 YES 20686 STATE MEASURE 28 8825 0200019B 140 738 878
116857 116857 YES 20686 STATE MEASURE 28 8825 0200028A 123 734 857
116859 116859 YES 20686 STATE MEASURE 28 8825 0200030A 241 1500 1741
116861 116861 YES 20686 STATE MEASURE 28 8825 0200031A 0 3 3
116863 116863 YES 20686 STATE MEASURE 28 8825 0200040A 153 919 1072
116865 116865 YES 20686 STATE MEASURE 28 8825 0200051A 93 661 754
116867 116867 YES 20686 STATE MEASURE 28 8825 0200087A 237 1148 1385
116869 116869 YES 20686 STATE MEASURE 28 8825 0200088A 202 1183 1385
116871 116871 YES 20686 STATE MEASURE 28 8825 0200091A 128 628 756
116873 116873 YES 20686 STATE MEASURE 28 8825 0300001D 8 25 33
116875 116875 YES 20686 STATE MEASURE 28 8825 0300002A 9 23 32
116877 116877 YES 20686 STATE MEASURE 28 8825 0300002B 2 8 10
116879 116879 YES 20686 STATE MEASURE 28 8825 0300002D 0 0 0
116881 116881 YES 20686 STATE MEASURE 28 8825 0300003A 1 8 9
116883 116883 YES 20686 STATE MEASURE 28 8825 0300013A 16 46 62
116885 116885 YES 20686 STATE MEASURE 28 8825 0350005B 26 184 210
116887 116887 YES 20686 STATE MEASURE 28 8825 0350007A 54 588 642
116889 116889 YES 20686 STATE MEASURE 28 8825 0350008A 103 774 877
116891 116891 YES 20686 STATE MEASURE 28 8825 0350012A 62 295 357
116893 116893 YES 20686 STATE MEASURE 28 8825 0350017A 84 776 860
116895 116895 YES 20686 STATE MEASURE 28 8825 0350022A 158 738 896
116897 116897 YES 20686 STATE MEASURE 28 8825 0350027A 94 449 543
116899 116899 YES 20686 STATE MEASURE 28 8825 0350029A 102 746 848
116901 116901 YES 20686 STATE MEASURE 28 8825 0350038A 31 187 218
116903 116903 YES 20686 STATE MEASURE 28 8825 0350043A 104 605 709
116905 116905 YES 20686 STATE MEASURE 28 8825 0350049A 81 576 657
116907 116907 YES 20686 STATE MEASURE 28 8825 0350052A 0 7 7
116909 116909 YES 20686 STATE MEASURE 28 8825 0350057A 50 272 322
116911 116911 YES 20686 STATE MEASURE 28 8825 0350058C 104 807 911
116913 116913 YES 20686 STATE MEASURE 28 8825 0350061A 2 7 9
116915 116915 YES 20686 STATE MEASURE 28 8825 0350101A 0 0 0
116917 116917 YES 20686 STATE MEASURE 28 8825 0350102A 35 218 253
116919 116919 YES 20686 STATE MEASURE 28 8825 0350104E 5 28 33
116921 116921 YES 20686 STATE MEASURE 28 8825 0350105A 0 9 9
116923 116923 YES 20686 STATE MEASURE 28 8825 0350106A 1 12 13
116925 116925 YES 20686 STATE MEASURE 28 8825 0350106B 4 18 22
116927 116927 YES 20686 STATE MEASURE 28 8825 0400001A 52 179 231
116929 116929 YES 20686 STATE MEASURE 28 8825 0400006A 120 350 470
116931 116931 YES 20686 STATE MEASURE 28 8825 0400008A 118 396 514
116933 116933 YES 20686 STATE MEASURE 28 8825 0400010A 162 664 826

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