results

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

5,980 rows where contest_id = 8822

✎ 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
142791 142791 YES 20679 STATE MEASURE 1 8822 0050001B 16 36 52
142792 142792 NO 20680 STATE MEASURE 1 8822 0050001B 28 28 56
142793 142793 YES 20679 STATE MEASURE 1 8822 0050002C 2 0 2
142794 142794 NO 20680 STATE MEASURE 1 8822 0050002C 2 0 2
142795 142795 YES 20679 STATE MEASURE 1 8822 0050003A 96 330 426
142796 142796 NO 20680 STATE MEASURE 1 8822 0050003A 316 322 638
142797 142797 YES 20679 STATE MEASURE 1 8822 0050004B 21 94 115
142798 142798 NO 20680 STATE MEASURE 1 8822 0050004B 86 61 147
142799 142799 YES 20679 STATE MEASURE 1 8822 0050011A 0 1 1
142800 142800 NO 20680 STATE MEASURE 1 8822 0050011A 1 0 1
142801 142801 YES 20679 STATE MEASURE 1 8822 0050014A 31 137 168
142802 142802 NO 20680 STATE MEASURE 1 8822 0050014A 78 148 226
142803 142803 YES 20679 STATE MEASURE 1 8822 0050023A 2 0 2
142804 142804 NO 20680 STATE MEASURE 1 8822 0050023A 2 0 2
142805 142805 YES 20679 STATE MEASURE 1 8822 0050042A 0 2 2
142806 142806 NO 20680 STATE MEASURE 1 8822 0050042A 0 0 0
142807 142807 YES 20679 STATE MEASURE 1 8822 0050063A 132 436 568
142808 142808 NO 20680 STATE MEASURE 1 8822 0050063A 349 435 784
142809 142809 YES 20679 STATE MEASURE 1 8822 0070001B 3 28 31
142810 142810 NO 20680 STATE MEASURE 1 8822 0070001B 2 5 7
142811 142811 YES 20679 STATE MEASURE 1 8822 0070002A 3 31 34
142812 142812 NO 20680 STATE MEASURE 1 8822 0070002A 4 14 18
142813 142813 YES 20679 STATE MEASURE 1 8822 0070004C 7 27 34
142814 142814 NO 20680 STATE MEASURE 1 8822 0070004C 5 13 18
142815 142815 YES 20679 STATE MEASURE 1 8822 0070004E 22 121 143
142816 142816 NO 20680 STATE MEASURE 1 8822 0070004E 13 34 47
142817 142817 YES 20679 STATE MEASURE 1 8822 0070006N 10 22 32
142818 142818 NO 20680 STATE MEASURE 1 8822 0070006N 2 17 19
142819 142819 YES 20679 STATE MEASURE 1 8822 0070007A 67 414 481
142820 142820 NO 20680 STATE MEASURE 1 8822 0070007A 59 85 144
142821 142821 YES 20679 STATE MEASURE 1 8822 0070008A 52 278 330
142822 142822 NO 20680 STATE MEASURE 1 8822 0070008A 43 102 145
142823 142823 YES 20679 STATE MEASURE 1 8822 0070027B 0 2 2
142824 142824 NO 20680 STATE MEASURE 1 8822 0070027B 0 0 0
142825 142825 YES 20679 STATE MEASURE 1 8822 0070041A 67 434 501
142826 142826 NO 20680 STATE MEASURE 1 8822 0070041A 105 180 285
142827 142827 YES 20679 STATE MEASURE 1 8822 0070041B 21 108 129
142828 142828 NO 20680 STATE MEASURE 1 8822 0070041B 18 24 42
142829 142829 YES 20679 STATE MEASURE 1 8822 0070041K 1 8 9
142830 142830 NO 20680 STATE MEASURE 1 8822 0070041K 2 2 4
142831 142831 YES 20679 STATE MEASURE 1 8822 0070207A 1 17 18
142832 142832 NO 20680 STATE MEASURE 1 8822 0070207A 0 17 17
142833 142833 YES 20679 STATE MEASURE 1 8822 0080004A 143 844 987
142834 142834 NO 20680 STATE MEASURE 1 8822 0080004A 121 223 344
142835 142835 YES 20679 STATE MEASURE 1 8822 0080012A 102 960 1062
142836 142836 NO 20680 STATE MEASURE 1 8822 0080012A 109 270 379
142837 142837 YES 20679 STATE MEASURE 1 8822 0080021A 153 1164 1317
142838 142838 NO 20680 STATE MEASURE 1 8822 0080021A 163 331 494
142839 142839 YES 20679 STATE MEASURE 1 8822 0080025A 99 787 886
142840 142840 NO 20680 STATE MEASURE 1 8822 0080025A 109 184 293
142841 142841 YES 20679 STATE MEASURE 1 8822 0080038A 89 545 634
142842 142842 NO 20680 STATE MEASURE 1 8822 0080038A 108 169 277
142843 142843 YES 20679 STATE MEASURE 1 8822 0080043A 96 728 824
142844 142844 NO 20680 STATE MEASURE 1 8822 0080043A 94 247 341
142845 142845 YES 20679 STATE MEASURE 1 8822 0080050A 129 848 977
142846 142846 NO 20680 STATE MEASURE 1 8822 0080050A 120 285 405
142847 142847 YES 20679 STATE MEASURE 1 8822 0090002B 0 3 3
142848 142848 NO 20680 STATE MEASURE 1 8822 0090002B 5 11 16
142849 142849 YES 20679 STATE MEASURE 1 8822 0090003A 134 585 719
142850 142850 NO 20680 STATE MEASURE 1 8822 0090003A 384 542 926
142851 142851 YES 20679 STATE MEASURE 1 8822 0090006A 2 14 16
142852 142852 NO 20680 STATE MEASURE 1 8822 0090006A 4 13 17
142853 142853 YES 20679 STATE MEASURE 1 8822 0090011A 1 14 15
142854 142854 NO 20680 STATE MEASURE 1 8822 0090011A 0 14 14
142855 142855 YES 20679 STATE MEASURE 1 8822 0090025A 1 3 4
142856 142856 NO 20680 STATE MEASURE 1 8822 0090025A 0 1 1
142857 142857 YES 20679 STATE MEASURE 1 8822 0150004A 116 842 958
142858 142858 NO 20680 STATE MEASURE 1 8822 0150004A 105 260 365
142859 142859 YES 20679 STATE MEASURE 1 8822 0150008A 86 339 425
142860 142860 NO 20680 STATE MEASURE 1 8822 0150008A 55 97 152
142861 142861 YES 20679 STATE MEASURE 1 8822 0150009A 84 461 545
142862 142862 NO 20680 STATE MEASURE 1 8822 0150009A 61 147 208
142863 142863 YES 20679 STATE MEASURE 1 8822 0150011A 95 656 751
142864 142864 NO 20680 STATE MEASURE 1 8822 0150011A 78 144 222
142865 142865 YES 20679 STATE MEASURE 1 8822 0150012A 139 772 911
142866 142866 NO 20680 STATE MEASURE 1 8822 0150012A 101 195 296
142867 142867 YES 20679 STATE MEASURE 1 8822 0150016D 135 864 999
142868 142868 NO 20680 STATE MEASURE 1 8822 0150016D 157 301 458
142869 142869 YES 20679 STATE MEASURE 1 8822 0150018A 162 915 1077
142870 142870 NO 20680 STATE MEASURE 1 8822 0150018A 95 201 296
142871 142871 YES 20679 STATE MEASURE 1 8822 0150021A 52 365 417
142872 142872 NO 20680 STATE MEASURE 1 8822 0150021A 45 126 171
142873 142873 YES 20679 STATE MEASURE 1 8822 0150025A 116 629 745
142874 142874 NO 20680 STATE MEASURE 1 8822 0150025A 86 172 258
142875 142875 YES 20679 STATE MEASURE 1 8822 0150028B 51 355 406
142876 142876 NO 20680 STATE MEASURE 1 8822 0150028B 38 181 219
142877 142877 YES 20679 STATE MEASURE 1 8822 0150032A 140 658 798
142878 142878 NO 20680 STATE MEASURE 1 8822 0150032A 97 218 315
142879 142879 YES 20679 STATE MEASURE 1 8822 0150033A 104 441 545
142880 142880 NO 20680 STATE MEASURE 1 8822 0150033A 59 149 208
142881 142881 YES 20679 STATE MEASURE 1 8822 0150037A 65 353 418
142882 142882 NO 20680 STATE MEASURE 1 8822 0150037A 37 118 155
142883 142883 YES 20679 STATE MEASURE 1 8822 0150042A 95 602 697
142884 142884 NO 20680 STATE MEASURE 1 8822 0150042A 62 145 207
142885 142885 YES 20679 STATE MEASURE 1 8822 0150049A 111 638 749
142886 142886 NO 20680 STATE MEASURE 1 8822 0150049A 85 209 294
142887 142887 YES 20679 STATE MEASURE 1 8822 0150060A 65 441 506
142888 142888 NO 20680 STATE MEASURE 1 8822 0150060A 44 123 167
142889 142889 YES 20679 STATE MEASURE 1 8822 0150065A 87 306 393
142890 142890 NO 20680 STATE MEASURE 1 8822 0150065A 44 81 125

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