results

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

2,990 rows where candidate_id = 20683

✎ View and edit SQL

This data as json, CSV (advanced)

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
17228 17228 YES 20683 STATE MEASURE 27 8824 0050002C 3 0 3
17230 17230 YES 20683 STATE MEASURE 27 8824 0050003A 63 101 164
17232 17232 YES 20683 STATE MEASURE 27 8824 0050004B 23 25 48
17234 17234 YES 20683 STATE MEASURE 27 8824 0050011A 0 0 0
17236 17236 YES 20683 STATE MEASURE 27 8824 0050014A 12 27 39
17238 17238 YES 20683 STATE MEASURE 27 8824 0050023A 0 0 0
17240 17240 YES 20683 STATE MEASURE 27 8824 0050042A 0 0 0
17242 17242 YES 20683 STATE MEASURE 27 8824 0050063A 89 134 223
17244 17244 YES 20683 STATE MEASURE 27 8824 0070001B 1 5 6
17246 17246 YES 20683 STATE MEASURE 27 8824 0070002A 1 5 6
17248 17248 YES 20683 STATE MEASURE 27 8824 0070004C 3 7 10
17250 17250 YES 20683 STATE MEASURE 27 8824 0070004E 6 30 36
17252 17252 YES 20683 STATE MEASURE 27 8824 0070006N 0 7 7
17254 17254 YES 20683 STATE MEASURE 27 8824 0070007A 27 79 106
17256 17256 YES 20683 STATE MEASURE 27 8824 0070008A 24 68 92
17258 17258 YES 20683 STATE MEASURE 27 8824 0070027B 0 0 0
17260 17260 YES 20683 STATE MEASURE 27 8824 0070041A 29 109 138
17262 17262 YES 20683 STATE MEASURE 27 8824 0070041B 14 25 39
17264 17264 YES 20683 STATE MEASURE 27 8824 0070041K 0 0 0
17266 17266 YES 20683 STATE MEASURE 27 8824 0070207A 0 7 7
17268 17268 YES 20683 STATE MEASURE 27 8824 0080004A 73 214 287
17270 17270 YES 20683 STATE MEASURE 27 8824 0080012A 40 239 279
17272 17272 YES 20683 STATE MEASURE 27 8824 0080021A 56 275 331
17274 17274 YES 20683 STATE MEASURE 27 8824 0080025A 46 180 226
17276 17276 YES 20683 STATE MEASURE 27 8824 0080038A 47 131 178
17278 17278 YES 20683 STATE MEASURE 27 8824 0080043A 40 197 237
17280 17280 YES 20683 STATE MEASURE 27 8824 0080050A 56 212 268
17282 17282 YES 20683 STATE MEASURE 27 8824 0090002B 6 6 12
17284 17284 YES 20683 STATE MEASURE 27 8824 0090003A 61 153 214
17286 17286 YES 20683 STATE MEASURE 27 8824 0090006A 0 13 13
17288 17288 YES 20683 STATE MEASURE 27 8824 0090011A 0 3 3
17290 17290 YES 20683 STATE MEASURE 27 8824 0090025A 0 0 0
17292 17292 YES 20683 STATE MEASURE 27 8824 0150004A 39 223 262
17294 17294 YES 20683 STATE MEASURE 27 8824 0150008A 40 100 140
17296 17296 YES 20683 STATE MEASURE 27 8824 0150009A 34 133 167
17298 17298 YES 20683 STATE MEASURE 27 8824 0150011A 32 108 140
17300 17300 YES 20683 STATE MEASURE 27 8824 0150012A 50 178 228
17302 17302 YES 20683 STATE MEASURE 27 8824 0150016D 45 197 242
17304 17304 YES 20683 STATE MEASURE 27 8824 0150018A 60 171 231
17306 17306 YES 20683 STATE MEASURE 27 8824 0150021A 24 83 107
17308 17308 YES 20683 STATE MEASURE 27 8824 0150025A 45 172 217
17310 17310 YES 20683 STATE MEASURE 27 8824 0150028B 17 105 122
17312 17312 YES 20683 STATE MEASURE 27 8824 0150032A 55 176 231
17314 17314 YES 20683 STATE MEASURE 27 8824 0150033A 30 129 159
17316 17316 YES 20683 STATE MEASURE 27 8824 0150037A 24 75 99
17318 17318 YES 20683 STATE MEASURE 27 8824 0150042A 31 159 190
17320 17320 YES 20683 STATE MEASURE 27 8824 0150049A 37 174 211
17322 17322 YES 20683 STATE MEASURE 27 8824 0150060A 33 99 132
17324 17324 YES 20683 STATE MEASURE 27 8824 0150065A 27 62 89
17326 17326 YES 20683 STATE MEASURE 27 8824 0150067A 69 174 243
17328 17328 YES 20683 STATE MEASURE 27 8824 0150070A 14 38 52
17330 17330 YES 20683 STATE MEASURE 27 8824 0150071A 14 92 106
17332 17332 YES 20683 STATE MEASURE 27 8824 0180002A 14 47 61
17334 17334 YES 20683 STATE MEASURE 27 8824 0200002A 31 103 134
17336 17336 YES 20683 STATE MEASURE 27 8824 0200007B 1 14 15
17338 17338 YES 20683 STATE MEASURE 27 8824 0200013A 48 205 253
17340 17340 YES 20683 STATE MEASURE 27 8824 0200014A 46 144 190
17342 17342 YES 20683 STATE MEASURE 27 8824 0200016A 46 182 228
17344 17344 YES 20683 STATE MEASURE 27 8824 0200017A 25 142 167
17346 17346 YES 20683 STATE MEASURE 27 8824 0200019B 28 124 152
17348 17348 YES 20683 STATE MEASURE 27 8824 0200028A 26 122 148
17350 17350 YES 20683 STATE MEASURE 27 8824 0200030A 60 258 318
17352 17352 YES 20683 STATE MEASURE 27 8824 0200031A 0 1 1
17354 17354 YES 20683 STATE MEASURE 27 8824 0200040A 49 187 236
17356 17356 YES 20683 STATE MEASURE 27 8824 0200051A 20 117 137
17358 17358 YES 20683 STATE MEASURE 27 8824 0200087A 61 183 244
17360 17360 YES 20683 STATE MEASURE 27 8824 0200088A 39 200 239
17362 17362 YES 20683 STATE MEASURE 27 8824 0200091A 23 104 127
17364 17364 YES 20683 STATE MEASURE 27 8824 0300001D 4 11 15
17366 17366 YES 20683 STATE MEASURE 27 8824 0300002A 3 4 7
17368 17368 YES 20683 STATE MEASURE 27 8824 0300002B 1 2 3
17370 17370 YES 20683 STATE MEASURE 27 8824 0300002D 0 0 0
17372 17372 YES 20683 STATE MEASURE 27 8824 0300003A 0 7 7
17374 17374 YES 20683 STATE MEASURE 27 8824 0300013A 9 10 19
17376 17376 YES 20683 STATE MEASURE 27 8824 0350005B 7 66 73
17378 17378 YES 20683 STATE MEASURE 27 8824 0350007A 35 166 201
17380 17380 YES 20683 STATE MEASURE 27 8824 0350008A 48 208 256
17382 17382 YES 20683 STATE MEASURE 27 8824 0350012A 25 110 135
17384 17384 YES 20683 STATE MEASURE 27 8824 0350017A 46 191 237
17386 17386 YES 20683 STATE MEASURE 27 8824 0350022A 74 219 293
17388 17388 YES 20683 STATE MEASURE 27 8824 0350027A 35 154 189
17390 17390 YES 20683 STATE MEASURE 27 8824 0350029A 39 253 292
17392 17392 YES 20683 STATE MEASURE 27 8824 0350038A 10 54 64
17394 17394 YES 20683 STATE MEASURE 27 8824 0350043A 44 210 254
17396 17396 YES 20683 STATE MEASURE 27 8824 0350049A 32 197 229
17398 17398 YES 20683 STATE MEASURE 27 8824 0350052A 0 1 1
17400 17400 YES 20683 STATE MEASURE 27 8824 0350057A 22 83 105
17402 17402 YES 20683 STATE MEASURE 27 8824 0350058C 49 289 338
17404 17404 YES 20683 STATE MEASURE 27 8824 0350061A 1 0 1
17406 17406 YES 20683 STATE MEASURE 27 8824 0350101A 0 0 0
17408 17408 YES 20683 STATE MEASURE 27 8824 0350102A 12 74 86
17410 17410 YES 20683 STATE MEASURE 27 8824 0350104E 0 6 6
17412 17412 YES 20683 STATE MEASURE 27 8824 0350105A 0 1 1
17414 17414 YES 20683 STATE MEASURE 27 8824 0350106A 0 8 8
17416 17416 YES 20683 STATE MEASURE 27 8824 0350106B 0 4 4
17418 17418 YES 20683 STATE MEASURE 27 8824 0400001A 21 58 79
17420 17420 YES 20683 STATE MEASURE 27 8824 0400006A 48 114 162
17422 17422 YES 20683 STATE MEASURE 27 8824 0400008A 54 123 177
17424 17424 YES 20683 STATE MEASURE 27 8824 0400010A 72 265 337

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