results

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

2,990 rows where candidate_id = 20687

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
116736 116736 NO 20687 STATE MEASURE 28 8825 0050001B 26 40 66
116738 116738 NO 20687 STATE MEASURE 28 8825 0050002C 2 0 2
116740 116740 NO 20687 STATE MEASURE 28 8825 0050003A 302 356 658
116742 116742 NO 20687 STATE MEASURE 28 8825 0050004B 78 78 156
116744 116744 NO 20687 STATE MEASURE 28 8825 0050011A 1 1 2
116746 116746 NO 20687 STATE MEASURE 28 8825 0050014A 74 156 230
116748 116748 NO 20687 STATE MEASURE 28 8825 0050023A 4 0 4
116750 116750 NO 20687 STATE MEASURE 28 8825 0050042A 0 2 2
116752 116752 NO 20687 STATE MEASURE 28 8825 0050063A 340 486 826
116754 116754 NO 20687 STATE MEASURE 28 8825 0070001B 3 14 17
116756 116756 NO 20687 STATE MEASURE 28 8825 0070002A 3 22 25
116758 116758 NO 20687 STATE MEASURE 28 8825 0070004C 7 16 23
116760 116760 NO 20687 STATE MEASURE 28 8825 0070004E 20 41 61
116762 116762 NO 20687 STATE MEASURE 28 8825 0070006N 3 19 22
116764 116764 NO 20687 STATE MEASURE 28 8825 0070007A 62 125 187
116766 116766 NO 20687 STATE MEASURE 28 8825 0070008A 58 171 229
116768 116768 NO 20687 STATE MEASURE 28 8825 0070027B 0 0 0
116770 116770 NO 20687 STATE MEASURE 28 8825 0070041A 95 260 355
116772 116772 NO 20687 STATE MEASURE 28 8825 0070041B 21 34 55
116774 116774 NO 20687 STATE MEASURE 28 8825 0070041K 2 2 4
116776 116776 NO 20687 STATE MEASURE 28 8825 0070207A 1 18 19
116778 116778 NO 20687 STATE MEASURE 28 8825 0080004A 147 375 522
116780 116780 NO 20687 STATE MEASURE 28 8825 0080012A 115 451 566
116782 116782 NO 20687 STATE MEASURE 28 8825 0080021A 174 506 680
116784 116784 NO 20687 STATE MEASURE 28 8825 0080025A 121 301 422
116786 116786 NO 20687 STATE MEASURE 28 8825 0080038A 114 272 386
116788 116788 NO 20687 STATE MEASURE 28 8825 0080043A 96 321 417
116790 116790 NO 20687 STATE MEASURE 28 8825 0080050A 136 427 563
116792 116792 NO 20687 STATE MEASURE 28 8825 0090002B 3 11 14
116794 116794 NO 20687 STATE MEASURE 28 8825 0090003A 380 600 980
116796 116796 NO 20687 STATE MEASURE 28 8825 0090006A 3 17 20
116798 116798 NO 20687 STATE MEASURE 28 8825 0090011A 0 11 11
116800 116800 NO 20687 STATE MEASURE 28 8825 0090025A 0 0 0
116802 116802 NO 20687 STATE MEASURE 28 8825 0150004A 95 317 412
116804 116804 NO 20687 STATE MEASURE 28 8825 0150008A 54 118 172
116806 116806 NO 20687 STATE MEASURE 28 8825 0150009A 39 133 172
116808 116808 NO 20687 STATE MEASURE 28 8825 0150011A 74 193 267
116810 116810 NO 20687 STATE MEASURE 28 8825 0150012A 87 248 335
116812 116812 NO 20687 STATE MEASURE 28 8825 0150016D 143 343 486
116814 116814 NO 20687 STATE MEASURE 28 8825 0150018A 100 254 354
116816 116816 NO 20687 STATE MEASURE 28 8825 0150021A 50 162 212
116818 116818 NO 20687 STATE MEASURE 28 8825 0150025A 72 206 278
116820 116820 NO 20687 STATE MEASURE 28 8825 0150028B 41 176 217
116822 116822 NO 20687 STATE MEASURE 28 8825 0150032A 92 247 339
116824 116824 NO 20687 STATE MEASURE 28 8825 0150033A 47 177 224
116826 116826 NO 20687 STATE MEASURE 28 8825 0150037A 47 152 199
116828 116828 NO 20687 STATE MEASURE 28 8825 0150042A 62 221 283
116830 116830 NO 20687 STATE MEASURE 28 8825 0150049A 87 279 366
116832 116832 NO 20687 STATE MEASURE 28 8825 0150060A 45 141 186
116834 116834 NO 20687 STATE MEASURE 28 8825 0150065A 45 112 157
116836 116836 NO 20687 STATE MEASURE 28 8825 0150067A 122 284 406
116838 116838 NO 20687 STATE MEASURE 28 8825 0150070A 30 69 99
116840 116840 NO 20687 STATE MEASURE 28 8825 0150071A 41 157 198
116842 116842 NO 20687 STATE MEASURE 28 8825 0180002A 18 58 76
116844 116844 NO 20687 STATE MEASURE 28 8825 0200002A 39 161 200
116846 116846 NO 20687 STATE MEASURE 28 8825 0200007B 10 21 31
116848 116848 NO 20687 STATE MEASURE 28 8825 0200013A 62 210 272
116850 116850 NO 20687 STATE MEASURE 28 8825 0200014A 68 189 257
116852 116852 NO 20687 STATE MEASURE 28 8825 0200016A 113 307 420
116854 116854 NO 20687 STATE MEASURE 28 8825 0200017A 33 115 148
116856 116856 NO 20687 STATE MEASURE 28 8825 0200019B 35 155 190
116858 116858 NO 20687 STATE MEASURE 28 8825 0200028A 76 210 286
116860 116860 NO 20687 STATE MEASURE 28 8825 0200030A 180 619 799
116862 116862 NO 20687 STATE MEASURE 28 8825 0200031A 0 0 0
116864 116864 NO 20687 STATE MEASURE 28 8825 0200040A 120 327 447
116866 116866 NO 20687 STATE MEASURE 28 8825 0200051A 57 169 226
116868 116868 NO 20687 STATE MEASURE 28 8825 0200087A 110 280 390
116870 116870 NO 20687 STATE MEASURE 28 8825 0200088A 100 237 337
116872 116872 NO 20687 STATE MEASURE 28 8825 0200091A 39 116 155
116874 116874 NO 20687 STATE MEASURE 28 8825 0300001D 7 23 30
116876 116876 NO 20687 STATE MEASURE 28 8825 0300002A 17 23 40
116878 116878 NO 20687 STATE MEASURE 28 8825 0300002B 3 6 9
116880 116880 NO 20687 STATE MEASURE 28 8825 0300002D 0 2 2
116882 116882 NO 20687 STATE MEASURE 28 8825 0300003A 7 17 24
116884 116884 NO 20687 STATE MEASURE 28 8825 0300013A 38 72 110
116886 116886 NO 20687 STATE MEASURE 28 8825 0350005B 29 152 181
116888 116888 NO 20687 STATE MEASURE 28 8825 0350007A 124 447 571
116890 116890 NO 20687 STATE MEASURE 28 8825 0350008A 119 547 666
116892 116892 NO 20687 STATE MEASURE 28 8825 0350012A 65 217 282
116894 116894 NO 20687 STATE MEASURE 28 8825 0350017A 115 588 703
116896 116896 NO 20687 STATE MEASURE 28 8825 0350022A 95 301 396
116898 116898 NO 20687 STATE MEASURE 28 8825 0350027A 82 171 253
116900 116900 NO 20687 STATE MEASURE 28 8825 0350029A 132 558 690
116902 116902 NO 20687 STATE MEASURE 28 8825 0350038A 23 130 153
116904 116904 NO 20687 STATE MEASURE 28 8825 0350043A 90 299 389
116906 116906 NO 20687 STATE MEASURE 28 8825 0350049A 99 482 581
116908 116908 NO 20687 STATE MEASURE 28 8825 0350052A 4 7 11
116910 116910 NO 20687 STATE MEASURE 28 8825 0350057A 68 194 262
116912 116912 NO 20687 STATE MEASURE 28 8825 0350058C 128 587 715
116914 116914 NO 20687 STATE MEASURE 28 8825 0350061A 4 2 6
116916 116916 NO 20687 STATE MEASURE 28 8825 0350101A 0 5 5
116918 116918 NO 20687 STATE MEASURE 28 8825 0350102A 27 103 130
116920 116920 NO 20687 STATE MEASURE 28 8825 0350104E 0 20 20
116922 116922 NO 20687 STATE MEASURE 28 8825 0350105A 2 6 8
116924 116924 NO 20687 STATE MEASURE 28 8825 0350106A 7 29 36
116926 116926 NO 20687 STATE MEASURE 28 8825 0350106B 2 13 15
116928 116928 NO 20687 STATE MEASURE 28 8825 0400001A 28 76 104
116930 116930 NO 20687 STATE MEASURE 28 8825 0400006A 85 246 331
116932 116932 NO 20687 STATE MEASURE 28 8825 0400008A 83 204 287
116934 116934 NO 20687 STATE MEASURE 28 8825 0400010A 139 422 561

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