results

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

5,980 rows where contest_id = 8828

✎ 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
198098 198098 YES 20692 STATE MEASURE 31 8828 0050001B 17 41 58
198099 198099 NO 20693 STATE MEASURE 31 8828 0050001B 27 24 51
198100 198100 YES 20692 STATE MEASURE 31 8828 0050002C 3 0 3
198101 198101 NO 20693 STATE MEASURE 31 8828 0050002C 1 0 1
198102 198102 YES 20692 STATE MEASURE 31 8828 0050003A 120 308 428
198103 198103 NO 20693 STATE MEASURE 31 8828 0050003A 292 345 637
198104 198104 YES 20692 STATE MEASURE 31 8828 0050004B 35 75 110
198105 198105 NO 20693 STATE MEASURE 31 8828 0050004B 71 79 150
198106 198106 YES 20692 STATE MEASURE 31 8828 0050011A 0 0 0
198107 198107 NO 20693 STATE MEASURE 31 8828 0050011A 1 1 2
198108 198108 YES 20692 STATE MEASURE 31 8828 0050014A 29 146 175
198109 198109 NO 20693 STATE MEASURE 31 8828 0050014A 80 138 218
198110 198110 YES 20692 STATE MEASURE 31 8828 0050023A 1 0 1
198111 198111 NO 20693 STATE MEASURE 31 8828 0050023A 3 0 3
198112 198112 YES 20692 STATE MEASURE 31 8828 0050042A 0 2 2
198113 198113 NO 20693 STATE MEASURE 31 8828 0050042A 0 0 0
198114 198114 YES 20692 STATE MEASURE 31 8828 0050063A 155 426 581
198115 198115 NO 20693 STATE MEASURE 31 8828 0050063A 322 450 772
198116 198116 YES 20692 STATE MEASURE 31 8828 0070001B 4 28 32
198117 198117 NO 20693 STATE MEASURE 31 8828 0070001B 1 6 7
198118 198118 YES 20692 STATE MEASURE 31 8828 0070002A 3 26 29
198119 198119 NO 20693 STATE MEASURE 31 8828 0070002A 4 20 24
198120 198120 YES 20692 STATE MEASURE 31 8828 0070004C 4 26 30
198121 198121 NO 20693 STATE MEASURE 31 8828 0070004C 7 16 23
198122 198122 YES 20692 STATE MEASURE 31 8828 0070004E 15 107 122
198123 198123 NO 20693 STATE MEASURE 31 8828 0070004E 20 46 66
198124 198124 YES 20692 STATE MEASURE 31 8828 0070006N 10 28 38
198125 198125 NO 20693 STATE MEASURE 31 8828 0070006N 2 11 13
198126 198126 YES 20692 STATE MEASURE 31 8828 0070007A 64 389 453
198127 198127 NO 20693 STATE MEASURE 31 8828 0070007A 60 92 152
198128 198128 YES 20692 STATE MEASURE 31 8828 0070008A 58 265 323
198129 198129 NO 20693 STATE MEASURE 31 8828 0070008A 34 111 145
198130 198130 YES 20692 STATE MEASURE 31 8828 0070027B 0 2 2
198131 198131 NO 20693 STATE MEASURE 31 8828 0070027B 0 0 0
198132 198132 YES 20692 STATE MEASURE 31 8828 0070041A 83 401 484
198133 198133 NO 20693 STATE MEASURE 31 8828 0070041A 85 219 304
198134 198134 YES 20692 STATE MEASURE 31 8828 0070041B 13 109 122
198135 198135 NO 20693 STATE MEASURE 31 8828 0070041B 26 25 51
198136 198136 YES 20692 STATE MEASURE 31 8828 0070041K 2 7 9
198137 198137 NO 20693 STATE MEASURE 31 8828 0070041K 1 3 4
198138 198138 YES 20692 STATE MEASURE 31 8828 0070207A 1 17 18
198139 198139 NO 20693 STATE MEASURE 31 8828 0070207A 0 17 17
198140 198140 YES 20692 STATE MEASURE 31 8828 0080004A 128 798 926
198141 198141 NO 20693 STATE MEASURE 31 8828 0080004A 130 281 411
198142 198142 YES 20692 STATE MEASURE 31 8828 0080012A 112 901 1013
198143 198143 NO 20693 STATE MEASURE 31 8828 0080012A 96 314 410
198144 198144 YES 20692 STATE MEASURE 31 8828 0080021A 154 1077 1231
198145 198145 NO 20693 STATE MEASURE 31 8828 0080021A 157 412 569
198146 198146 YES 20692 STATE MEASURE 31 8828 0080025A 104 711 815
198147 198147 NO 20693 STATE MEASURE 31 8828 0080025A 104 260 364
198148 198148 YES 20692 STATE MEASURE 31 8828 0080038A 93 486 579
198149 198149 NO 20693 STATE MEASURE 31 8828 0080038A 101 217 318
198150 198150 YES 20692 STATE MEASURE 31 8828 0080043A 93 679 772
198151 198151 NO 20693 STATE MEASURE 31 8828 0080043A 101 300 401
198152 198152 YES 20692 STATE MEASURE 31 8828 0080050A 141 788 929
198153 198153 NO 20693 STATE MEASURE 31 8828 0080050A 106 346 452
198154 198154 YES 20692 STATE MEASURE 31 8828 0090002B 3 4 7
198155 198155 NO 20693 STATE MEASURE 31 8828 0090002B 2 10 12
198156 198156 YES 20692 STATE MEASURE 31 8828 0090003A 164 560 724
198157 198157 NO 20693 STATE MEASURE 31 8828 0090003A 357 552 909
198158 198158 YES 20692 STATE MEASURE 31 8828 0090006A 2 13 15
198159 198159 NO 20693 STATE MEASURE 31 8828 0090006A 5 15 20
198160 198160 YES 20692 STATE MEASURE 31 8828 0090011A 0 9 9
198161 198161 NO 20693 STATE MEASURE 31 8828 0090011A 1 19 20
198162 198162 YES 20692 STATE MEASURE 31 8828 0090025A 1 4 5
198163 198163 NO 20693 STATE MEASURE 31 8828 0090025A 0 0 0
198164 198164 YES 20692 STATE MEASURE 31 8828 0150004A 120 752 872
198165 198165 NO 20693 STATE MEASURE 31 8828 0150004A 96 334 430
198166 198166 YES 20692 STATE MEASURE 31 8828 0150008A 73 317 390
198167 198167 NO 20693 STATE MEASURE 31 8828 0150008A 65 113 178
198168 198168 YES 20692 STATE MEASURE 31 8828 0150009A 89 435 524
198169 198169 NO 20693 STATE MEASURE 31 8828 0150009A 58 160 218
198170 198170 YES 20692 STATE MEASURE 31 8828 0150011A 95 585 680
198171 198171 NO 20693 STATE MEASURE 31 8828 0150011A 80 200 280
198172 198172 YES 20692 STATE MEASURE 31 8828 0150012A 141 721 862
198173 198173 NO 20693 STATE MEASURE 31 8828 0150012A 98 248 346
198174 198174 YES 20692 STATE MEASURE 31 8828 0150016D 154 812 966
198175 198175 NO 20693 STATE MEASURE 31 8828 0150016D 134 366 500
198176 198176 YES 20692 STATE MEASURE 31 8828 0150018A 157 831 988
198177 198177 NO 20693 STATE MEASURE 31 8828 0150018A 102 287 389
198178 198178 YES 20692 STATE MEASURE 31 8828 0150021A 48 333 381
198179 198179 NO 20693 STATE MEASURE 31 8828 0150021A 47 148 195
198180 198180 YES 20692 STATE MEASURE 31 8828 0150025A 105 557 662
198181 198181 NO 20693 STATE MEASURE 31 8828 0150025A 93 239 332
198182 198182 YES 20692 STATE MEASURE 31 8828 0150028B 47 376 423
198183 198183 NO 20693 STATE MEASURE 31 8828 0150028B 41 168 209
198184 198184 YES 20692 STATE MEASURE 31 8828 0150032A 130 610 740
198185 198185 NO 20693 STATE MEASURE 31 8828 0150032A 109 271 380
198186 198186 YES 20692 STATE MEASURE 31 8828 0150033A 92 412 504
198187 198187 NO 20693 STATE MEASURE 31 8828 0150033A 73 175 248
198188 198188 YES 20692 STATE MEASURE 31 8828 0150037A 58 352 410
198189 198189 NO 20693 STATE MEASURE 31 8828 0150037A 44 115 159
198190 198190 YES 20692 STATE MEASURE 31 8828 0150042A 81 526 607
198191 198191 NO 20693 STATE MEASURE 31 8828 0150042A 68 216 284
198192 198192 YES 20692 STATE MEASURE 31 8828 0150049A 113 589 702
198193 198193 NO 20693 STATE MEASURE 31 8828 0150049A 83 248 331
198194 198194 YES 20692 STATE MEASURE 31 8828 0150060A 57 408 465
198195 198195 NO 20693 STATE MEASURE 31 8828 0150060A 48 155 203
198196 198196 YES 20692 STATE MEASURE 31 8828 0150065A 82 276 358
198197 198197 NO 20693 STATE MEASURE 31 8828 0150065A 48 113 161

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