results

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

5,980 rows where contest_id = 8824

✎ 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
17226 17226 YES 20683 STATE MEASURE 27 8824 0050001B 12 9 21
17227 17227 NO 20684 STATE MEASURE 27 8824 0050001B 31 57 88
17228 17228 YES 20683 STATE MEASURE 27 8824 0050002C 3 0 3
17229 17229 NO 20684 STATE MEASURE 27 8824 0050002C 1 0 1
17230 17230 YES 20683 STATE MEASURE 27 8824 0050003A 63 101 164
17231 17231 NO 20684 STATE MEASURE 27 8824 0050003A 345 556 901
17232 17232 YES 20683 STATE MEASURE 27 8824 0050004B 23 25 48
17233 17233 NO 20684 STATE MEASURE 27 8824 0050004B 84 128 212
17234 17234 YES 20683 STATE MEASURE 27 8824 0050011A 0 0 0
17235 17235 NO 20684 STATE MEASURE 27 8824 0050011A 1 1 2
17236 17236 YES 20683 STATE MEASURE 27 8824 0050014A 12 27 39
17237 17237 NO 20684 STATE MEASURE 27 8824 0050014A 96 260 356
17238 17238 YES 20683 STATE MEASURE 27 8824 0050023A 0 0 0
17239 17239 NO 20684 STATE MEASURE 27 8824 0050023A 4 0 4
17240 17240 YES 20683 STATE MEASURE 27 8824 0050042A 0 0 0
17241 17241 NO 20684 STATE MEASURE 27 8824 0050042A 0 2 2
17242 17242 YES 20683 STATE MEASURE 27 8824 0050063A 89 134 223
17243 17243 NO 20684 STATE MEASURE 27 8824 0050063A 387 743 1130
17244 17244 YES 20683 STATE MEASURE 27 8824 0070001B 1 5 6
17245 17245 NO 20684 STATE MEASURE 27 8824 0070001B 4 31 35
17246 17246 YES 20683 STATE MEASURE 27 8824 0070002A 1 5 6
17247 17247 NO 20684 STATE MEASURE 27 8824 0070002A 6 42 48
17248 17248 YES 20683 STATE MEASURE 27 8824 0070004C 3 7 10
17249 17249 NO 20684 STATE MEASURE 27 8824 0070004C 5 33 38
17250 17250 YES 20683 STATE MEASURE 27 8824 0070004E 6 30 36
17251 17251 NO 20684 STATE MEASURE 27 8824 0070004E 25 124 149
17252 17252 YES 20683 STATE MEASURE 27 8824 0070006N 0 7 7
17253 17253 NO 20684 STATE MEASURE 27 8824 0070006N 12 32 44
17254 17254 YES 20683 STATE MEASURE 27 8824 0070007A 27 79 106
17255 17255 NO 20684 STATE MEASURE 27 8824 0070007A 95 397 492
17256 17256 YES 20683 STATE MEASURE 27 8824 0070008A 24 68 92
17257 17257 NO 20684 STATE MEASURE 27 8824 0070008A 70 307 377
17258 17258 YES 20683 STATE MEASURE 27 8824 0070027B 0 0 0
17259 17259 NO 20684 STATE MEASURE 27 8824 0070027B 0 2 2
17260 17260 YES 20683 STATE MEASURE 27 8824 0070041A 29 109 138
17261 17261 NO 20684 STATE MEASURE 27 8824 0070041A 139 514 653
17262 17262 YES 20683 STATE MEASURE 27 8824 0070041B 14 25 39
17263 17263 NO 20684 STATE MEASURE 27 8824 0070041B 25 105 130
17264 17264 YES 20683 STATE MEASURE 27 8824 0070041K 0 0 0
17265 17265 NO 20684 STATE MEASURE 27 8824 0070041K 3 10 13
17266 17266 YES 20683 STATE MEASURE 27 8824 0070207A 0 7 7
17267 17267 NO 20684 STATE MEASURE 27 8824 0070207A 1 27 28
17268 17268 YES 20683 STATE MEASURE 27 8824 0080004A 73 214 287
17269 17269 NO 20684 STATE MEASURE 27 8824 0080004A 182 868 1050
17270 17270 YES 20683 STATE MEASURE 27 8824 0080012A 40 239 279
17271 17271 NO 20684 STATE MEASURE 27 8824 0080012A 168 985 1153
17272 17272 YES 20683 STATE MEASURE 27 8824 0080021A 56 275 331
17273 17273 NO 20684 STATE MEASURE 27 8824 0080021A 251 1196 1447
17274 17274 YES 20683 STATE MEASURE 27 8824 0080025A 46 180 226
17275 17275 NO 20684 STATE MEASURE 27 8824 0080025A 163 786 949
17276 17276 YES 20683 STATE MEASURE 27 8824 0080038A 47 131 178
17277 17277 NO 20684 STATE MEASURE 27 8824 0080038A 140 566 706
17278 17278 YES 20683 STATE MEASURE 27 8824 0080043A 40 197 237
17279 17279 NO 20684 STATE MEASURE 27 8824 0080043A 154 779 933
17280 17280 YES 20683 STATE MEASURE 27 8824 0080050A 56 212 268
17281 17281 NO 20684 STATE MEASURE 27 8824 0080050A 194 917 1111
17282 17282 YES 20683 STATE MEASURE 27 8824 0090002B 6 6 12
17283 17283 NO 20684 STATE MEASURE 27 8824 0090002B 0 8 8
17284 17284 YES 20683 STATE MEASURE 27 8824 0090003A 61 153 214
17285 17285 NO 20684 STATE MEASURE 27 8824 0090003A 455 956 1411
17286 17286 YES 20683 STATE MEASURE 27 8824 0090006A 0 13 13
17287 17287 NO 20684 STATE MEASURE 27 8824 0090006A 7 16 23
17288 17288 YES 20683 STATE MEASURE 27 8824 0090011A 0 3 3
17289 17289 NO 20684 STATE MEASURE 27 8824 0090011A 1 25 26
17290 17290 YES 20683 STATE MEASURE 27 8824 0090025A 0 0 0
17291 17291 NO 20684 STATE MEASURE 27 8824 0090025A 1 3 4
17292 17292 YES 20683 STATE MEASURE 27 8824 0150004A 39 223 262
17293 17293 NO 20684 STATE MEASURE 27 8824 0150004A 176 867 1043
17294 17294 YES 20683 STATE MEASURE 27 8824 0150008A 40 100 140
17295 17295 NO 20684 STATE MEASURE 27 8824 0150008A 100 330 430
17296 17296 YES 20683 STATE MEASURE 27 8824 0150009A 34 133 167
17297 17297 NO 20684 STATE MEASURE 27 8824 0150009A 112 467 579
17298 17298 YES 20683 STATE MEASURE 27 8824 0150011A 32 108 140
17299 17299 NO 20684 STATE MEASURE 27 8824 0150011A 140 681 821
17300 17300 YES 20683 STATE MEASURE 27 8824 0150012A 50 178 228
17301 17301 NO 20684 STATE MEASURE 27 8824 0150012A 183 779 962
17302 17302 YES 20683 STATE MEASURE 27 8824 0150016D 45 197 242
17303 17303 NO 20684 STATE MEASURE 27 8824 0150016D 240 963 1203
17304 17304 YES 20683 STATE MEASURE 27 8824 0150018A 60 171 231
17305 17305 NO 20684 STATE MEASURE 27 8824 0150018A 199 935 1134
17306 17306 YES 20683 STATE MEASURE 27 8824 0150021A 24 83 107
17307 17307 NO 20684 STATE MEASURE 27 8824 0150021A 70 406 476
17308 17308 YES 20683 STATE MEASURE 27 8824 0150025A 45 172 217
17309 17309 NO 20684 STATE MEASURE 27 8824 0150025A 155 624 779
17310 17310 YES 20683 STATE MEASURE 27 8824 0150028B 17 105 122
17311 17311 NO 20684 STATE MEASURE 27 8824 0150028B 72 442 514
17312 17312 YES 20683 STATE MEASURE 27 8824 0150032A 55 176 231
17313 17313 NO 20684 STATE MEASURE 27 8824 0150032A 184 702 886
17314 17314 YES 20683 STATE MEASURE 27 8824 0150033A 30 129 159
17315 17315 NO 20684 STATE MEASURE 27 8824 0150033A 134 460 594
17316 17316 YES 20683 STATE MEASURE 27 8824 0150037A 24 75 99
17317 17317 NO 20684 STATE MEASURE 27 8824 0150037A 77 395 472
17318 17318 YES 20683 STATE MEASURE 27 8824 0150042A 31 159 190
17319 17319 NO 20684 STATE MEASURE 27 8824 0150042A 124 587 711
17320 17320 YES 20683 STATE MEASURE 27 8824 0150049A 37 174 211
17321 17321 NO 20684 STATE MEASURE 27 8824 0150049A 157 663 820
17322 17322 YES 20683 STATE MEASURE 27 8824 0150060A 33 99 132
17323 17323 NO 20684 STATE MEASURE 27 8824 0150060A 71 456 527
17324 17324 YES 20683 STATE MEASURE 27 8824 0150065A 27 62 89
17325 17325 NO 20684 STATE MEASURE 27 8824 0150065A 97 323 420

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