results

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

5,980 rows where contest_id = 8825

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id

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
116736 116736 NO 20687 STATE MEASURE 28 8825 0050001B 26 40 66
116737 116737 YES 20686 STATE MEASURE 28 8825 0050002C 2 0 2
116738 116738 NO 20687 STATE MEASURE 28 8825 0050002C 2 0 2
116739 116739 YES 20686 STATE MEASURE 28 8825 0050003A 108 303 411
116740 116740 NO 20687 STATE MEASURE 28 8825 0050003A 302 356 658
116741 116741 YES 20686 STATE MEASURE 28 8825 0050004B 28 73 101
116742 116742 NO 20687 STATE MEASURE 28 8825 0050004B 78 78 156
116743 116743 YES 20686 STATE MEASURE 28 8825 0050011A 0 0 0
116744 116744 NO 20687 STATE MEASURE 28 8825 0050011A 1 1 2
116745 116745 YES 20686 STATE MEASURE 28 8825 0050014A 34 133 167
116746 116746 NO 20687 STATE MEASURE 28 8825 0050014A 74 156 230
116747 116747 YES 20686 STATE MEASURE 28 8825 0050023A 0 0 0
116748 116748 NO 20687 STATE MEASURE 28 8825 0050023A 4 0 4
116749 116749 YES 20686 STATE MEASURE 28 8825 0050042A 0 0 0
116750 116750 NO 20687 STATE MEASURE 28 8825 0050042A 0 2 2
116751 116751 YES 20686 STATE MEASURE 28 8825 0050063A 133 384 517
116752 116752 NO 20687 STATE MEASURE 28 8825 0050063A 340 486 826
116753 116753 YES 20686 STATE MEASURE 28 8825 0070001B 2 18 20
116754 116754 NO 20687 STATE MEASURE 28 8825 0070001B 3 14 17
116755 116755 YES 20686 STATE MEASURE 28 8825 0070002A 4 24 28
116756 116756 NO 20687 STATE MEASURE 28 8825 0070002A 3 22 25
116757 116757 YES 20686 STATE MEASURE 28 8825 0070004C 3 23 26
116758 116758 NO 20687 STATE MEASURE 28 8825 0070004C 7 16 23
116759 116759 YES 20686 STATE MEASURE 28 8825 0070004E 15 113 128
116760 116760 NO 20687 STATE MEASURE 28 8825 0070004E 20 41 61
116761 116761 YES 20686 STATE MEASURE 28 8825 0070006N 9 20 29
116762 116762 NO 20687 STATE MEASURE 28 8825 0070006N 3 19 22
116763 116763 YES 20686 STATE MEASURE 28 8825 0070007A 63 360 423
116764 116764 NO 20687 STATE MEASURE 28 8825 0070007A 62 125 187
116765 116765 YES 20686 STATE MEASURE 28 8825 0070008A 36 204 240
116766 116766 NO 20687 STATE MEASURE 28 8825 0070008A 58 171 229
116767 116767 YES 20686 STATE MEASURE 28 8825 0070027B 0 2 2
116768 116768 NO 20687 STATE MEASURE 28 8825 0070027B 0 0 0
116769 116769 YES 20686 STATE MEASURE 28 8825 0070041A 75 361 436
116770 116770 NO 20687 STATE MEASURE 28 8825 0070041A 95 260 355
116771 116771 YES 20686 STATE MEASURE 28 8825 0070041B 18 98 116
116772 116772 NO 20687 STATE MEASURE 28 8825 0070041B 21 34 55
116773 116773 YES 20686 STATE MEASURE 28 8825 0070041K 1 8 9
116774 116774 NO 20687 STATE MEASURE 28 8825 0070041K 2 2 4
116775 116775 YES 20686 STATE MEASURE 28 8825 0070207A 0 14 14
116776 116776 NO 20687 STATE MEASURE 28 8825 0070207A 1 18 19
116777 116777 YES 20686 STATE MEASURE 28 8825 0080004A 113 705 818
116778 116778 NO 20687 STATE MEASURE 28 8825 0080004A 147 375 522
116779 116779 YES 20686 STATE MEASURE 28 8825 0080012A 93 749 842
116780 116780 NO 20687 STATE MEASURE 28 8825 0080012A 115 451 566
116781 116781 YES 20686 STATE MEASURE 28 8825 0080021A 142 980 1122
116782 116782 NO 20687 STATE MEASURE 28 8825 0080021A 174 506 680
116783 116783 YES 20686 STATE MEASURE 28 8825 0080025A 88 671 759
116784 116784 NO 20687 STATE MEASURE 28 8825 0080025A 121 301 422
116785 116785 YES 20686 STATE MEASURE 28 8825 0080038A 81 438 519
116786 116786 NO 20687 STATE MEASURE 28 8825 0080038A 114 272 386
116787 116787 YES 20686 STATE MEASURE 28 8825 0080043A 100 659 759
116788 116788 NO 20687 STATE MEASURE 28 8825 0080043A 96 321 417
116789 116789 YES 20686 STATE MEASURE 28 8825 0080050A 114 702 816
116790 116790 NO 20687 STATE MEASURE 28 8825 0080050A 136 427 563
116791 116791 YES 20686 STATE MEASURE 28 8825 0090002B 2 3 5
116792 116792 NO 20687 STATE MEASURE 28 8825 0090002B 3 11 14
116793 116793 YES 20686 STATE MEASURE 28 8825 0090003A 139 510 649
116794 116794 NO 20687 STATE MEASURE 28 8825 0090003A 380 600 980
116795 116795 YES 20686 STATE MEASURE 28 8825 0090006A 4 10 14
116796 116796 NO 20687 STATE MEASURE 28 8825 0090006A 3 17 20
116797 116797 YES 20686 STATE MEASURE 28 8825 0090011A 1 15 16
116798 116798 NO 20687 STATE MEASURE 28 8825 0090011A 0 11 11
116799 116799 YES 20686 STATE MEASURE 28 8825 0090025A 1 4 5
116800 116800 NO 20687 STATE MEASURE 28 8825 0090025A 0 0 0
116801 116801 YES 20686 STATE MEASURE 28 8825 0150004A 124 773 897
116802 116802 NO 20687 STATE MEASURE 28 8825 0150004A 95 317 412
116803 116803 YES 20686 STATE MEASURE 28 8825 0150008A 87 312 399
116804 116804 NO 20687 STATE MEASURE 28 8825 0150008A 54 118 172
116805 116805 YES 20686 STATE MEASURE 28 8825 0150009A 106 467 573
116806 116806 NO 20687 STATE MEASURE 28 8825 0150009A 39 133 172
116807 116807 YES 20686 STATE MEASURE 28 8825 0150011A 100 601 701
116808 116808 NO 20687 STATE MEASURE 28 8825 0150011A 74 193 267
116809 116809 YES 20686 STATE MEASURE 28 8825 0150012A 154 721 875
116810 116810 NO 20687 STATE MEASURE 28 8825 0150012A 87 248 335
116811 116811 YES 20686 STATE MEASURE 28 8825 0150016D 150 815 965
116812 116812 NO 20687 STATE MEASURE 28 8825 0150016D 143 343 486
116813 116813 YES 20686 STATE MEASURE 28 8825 0150018A 157 855 1012
116814 116814 NO 20687 STATE MEASURE 28 8825 0150018A 100 254 354
116815 116815 YES 20686 STATE MEASURE 28 8825 0150021A 47 327 374
116816 116816 NO 20687 STATE MEASURE 28 8825 0150021A 50 162 212
116817 116817 YES 20686 STATE MEASURE 28 8825 0150025A 129 603 732
116818 116818 NO 20687 STATE MEASURE 28 8825 0150025A 72 206 278
116819 116819 YES 20686 STATE MEASURE 28 8825 0150028B 50 366 416
116820 116820 NO 20687 STATE MEASURE 28 8825 0150028B 41 176 217
116821 116821 YES 20686 STATE MEASURE 28 8825 0150032A 149 624 773
116822 116822 NO 20687 STATE MEASURE 28 8825 0150032A 92 247 339
116823 116823 YES 20686 STATE MEASURE 28 8825 0150033A 116 406 522
116824 116824 NO 20687 STATE MEASURE 28 8825 0150033A 47 177 224
116825 116825 YES 20686 STATE MEASURE 28 8825 0150037A 56 322 378
116826 116826 NO 20687 STATE MEASURE 28 8825 0150037A 47 152 199
116827 116827 YES 20686 STATE MEASURE 28 8825 0150042A 94 527 621
116828 116828 NO 20687 STATE MEASURE 28 8825 0150042A 62 221 283
116829 116829 YES 20686 STATE MEASURE 28 8825 0150049A 115 558 673
116830 116830 NO 20687 STATE MEASURE 28 8825 0150049A 87 279 366
116831 116831 YES 20686 STATE MEASURE 28 8825 0150060A 64 423 487
116832 116832 NO 20687 STATE MEASURE 28 8825 0150060A 45 141 186
116833 116833 YES 20686 STATE MEASURE 28 8825 0150065A 84 271 355
116834 116834 NO 20687 STATE MEASURE 28 8825 0150065A 45 112 157

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