results

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

2,990 rows where candidate_id = 20684

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
17227 17227 NO 20684 STATE MEASURE 27 8824 0050001B 31 57 88
17229 17229 NO 20684 STATE MEASURE 27 8824 0050002C 1 0 1
17231 17231 NO 20684 STATE MEASURE 27 8824 0050003A 345 556 901
17233 17233 NO 20684 STATE MEASURE 27 8824 0050004B 84 128 212
17235 17235 NO 20684 STATE MEASURE 27 8824 0050011A 1 1 2
17237 17237 NO 20684 STATE MEASURE 27 8824 0050014A 96 260 356
17239 17239 NO 20684 STATE MEASURE 27 8824 0050023A 4 0 4
17241 17241 NO 20684 STATE MEASURE 27 8824 0050042A 0 2 2
17243 17243 NO 20684 STATE MEASURE 27 8824 0050063A 387 743 1130
17245 17245 NO 20684 STATE MEASURE 27 8824 0070001B 4 31 35
17247 17247 NO 20684 STATE MEASURE 27 8824 0070002A 6 42 48
17249 17249 NO 20684 STATE MEASURE 27 8824 0070004C 5 33 38
17251 17251 NO 20684 STATE MEASURE 27 8824 0070004E 25 124 149
17253 17253 NO 20684 STATE MEASURE 27 8824 0070006N 12 32 44
17255 17255 NO 20684 STATE MEASURE 27 8824 0070007A 95 397 492
17257 17257 NO 20684 STATE MEASURE 27 8824 0070008A 70 307 377
17259 17259 NO 20684 STATE MEASURE 27 8824 0070027B 0 2 2
17261 17261 NO 20684 STATE MEASURE 27 8824 0070041A 139 514 653
17263 17263 NO 20684 STATE MEASURE 27 8824 0070041B 25 105 130
17265 17265 NO 20684 STATE MEASURE 27 8824 0070041K 3 10 13
17267 17267 NO 20684 STATE MEASURE 27 8824 0070207A 1 27 28
17269 17269 NO 20684 STATE MEASURE 27 8824 0080004A 182 868 1050
17271 17271 NO 20684 STATE MEASURE 27 8824 0080012A 168 985 1153
17273 17273 NO 20684 STATE MEASURE 27 8824 0080021A 251 1196 1447
17275 17275 NO 20684 STATE MEASURE 27 8824 0080025A 163 786 949
17277 17277 NO 20684 STATE MEASURE 27 8824 0080038A 140 566 706
17279 17279 NO 20684 STATE MEASURE 27 8824 0080043A 154 779 933
17281 17281 NO 20684 STATE MEASURE 27 8824 0080050A 194 917 1111
17283 17283 NO 20684 STATE MEASURE 27 8824 0090002B 0 8 8
17285 17285 NO 20684 STATE MEASURE 27 8824 0090003A 455 956 1411
17287 17287 NO 20684 STATE MEASURE 27 8824 0090006A 7 16 23
17289 17289 NO 20684 STATE MEASURE 27 8824 0090011A 1 25 26
17291 17291 NO 20684 STATE MEASURE 27 8824 0090025A 1 3 4
17293 17293 NO 20684 STATE MEASURE 27 8824 0150004A 176 867 1043
17295 17295 NO 20684 STATE MEASURE 27 8824 0150008A 100 330 430
17297 17297 NO 20684 STATE MEASURE 27 8824 0150009A 112 467 579
17299 17299 NO 20684 STATE MEASURE 27 8824 0150011A 140 681 821
17301 17301 NO 20684 STATE MEASURE 27 8824 0150012A 183 779 962
17303 17303 NO 20684 STATE MEASURE 27 8824 0150016D 240 963 1203
17305 17305 NO 20684 STATE MEASURE 27 8824 0150018A 199 935 1134
17307 17307 NO 20684 STATE MEASURE 27 8824 0150021A 70 406 476
17309 17309 NO 20684 STATE MEASURE 27 8824 0150025A 155 624 779
17311 17311 NO 20684 STATE MEASURE 27 8824 0150028B 72 442 514
17313 17313 NO 20684 STATE MEASURE 27 8824 0150032A 184 702 886
17315 17315 NO 20684 STATE MEASURE 27 8824 0150033A 134 460 594
17317 17317 NO 20684 STATE MEASURE 27 8824 0150037A 77 395 472
17319 17319 NO 20684 STATE MEASURE 27 8824 0150042A 124 587 711
17321 17321 NO 20684 STATE MEASURE 27 8824 0150049A 157 663 820
17323 17323 NO 20684 STATE MEASURE 27 8824 0150060A 71 456 527
17325 17325 NO 20684 STATE MEASURE 27 8824 0150065A 97 323 420
17327 17327 NO 20684 STATE MEASURE 27 8824 0150067A 201 751 952
17329 17329 NO 20684 STATE MEASURE 27 8824 0150070A 52 175 227
17331 17331 NO 20684 STATE MEASURE 27 8824 0150071A 98 430 528
17333 17333 NO 20684 STATE MEASURE 27 8824 0180002A 48 174 222
17335 17335 NO 20684 STATE MEASURE 27 8824 0200002A 104 566 670
17337 17337 NO 20684 STATE MEASURE 27 8824 0200007B 16 83 99
17339 17339 NO 20684 STATE MEASURE 27 8824 0200013A 202 1166 1368
17341 17341 NO 20684 STATE MEASURE 27 8824 0200014A 224 910 1134
17343 17343 NO 20684 STATE MEASURE 27 8824 0200016A 228 1005 1233
17345 17345 NO 20684 STATE MEASURE 27 8824 0200017A 119 586 705
17347 17347 NO 20684 STATE MEASURE 27 8824 0200019B 141 759 900
17349 17349 NO 20684 STATE MEASURE 27 8824 0200028A 170 816 986
17351 17351 NO 20684 STATE MEASURE 27 8824 0200030A 358 1854 2212
17353 17353 NO 20684 STATE MEASURE 27 8824 0200031A 0 2 2
17355 17355 NO 20684 STATE MEASURE 27 8824 0200040A 222 1054 1276
17357 17357 NO 20684 STATE MEASURE 27 8824 0200051A 128 707 835
17359 17359 NO 20684 STATE MEASURE 27 8824 0200087A 285 1243 1528
17361 17361 NO 20684 STATE MEASURE 27 8824 0200088A 263 1215 1478
17363 17363 NO 20684 STATE MEASURE 27 8824 0200091A 140 637 777
17365 17365 NO 20684 STATE MEASURE 27 8824 0300001D 11 38 49
17367 17367 NO 20684 STATE MEASURE 27 8824 0300002A 23 43 66
17369 17369 NO 20684 STATE MEASURE 27 8824 0300002B 4 12 16
17371 17371 NO 20684 STATE MEASURE 27 8824 0300002D 0 2 2
17373 17373 NO 20684 STATE MEASURE 27 8824 0300003A 8 18 26
17375 17375 NO 20684 STATE MEASURE 27 8824 0300013A 45 106 151
17377 17377 NO 20684 STATE MEASURE 27 8824 0350005B 48 270 318
17379 17379 NO 20684 STATE MEASURE 27 8824 0350007A 144 881 1025
17381 17381 NO 20684 STATE MEASURE 27 8824 0350008A 173 1110 1283
17383 17383 NO 20684 STATE MEASURE 27 8824 0350012A 101 398 499
17385 17385 NO 20684 STATE MEASURE 27 8824 0350017A 152 1169 1321
17387 17387 NO 20684 STATE MEASURE 27 8824 0350022A 179 813 992
17389 17389 NO 20684 STATE MEASURE 27 8824 0350027A 136 466 602
17391 17391 NO 20684 STATE MEASURE 27 8824 0350029A 197 1038 1235
17393 17393 NO 20684 STATE MEASURE 27 8824 0350038A 43 271 314
17395 17395 NO 20684 STATE MEASURE 27 8824 0350043A 143 687 830
17397 17397 NO 20684 STATE MEASURE 27 8824 0350049A 147 870 1017
17399 17399 NO 20684 STATE MEASURE 27 8824 0350052A 4 14 18
17401 17401 NO 20684 STATE MEASURE 27 8824 0350057A 96 392 488
17403 17403 NO 20684 STATE MEASURE 27 8824 0350058C 183 1118 1301
17405 17405 NO 20684 STATE MEASURE 27 8824 0350061A 6 9 15
17407 17407 NO 20684 STATE MEASURE 27 8824 0350101A 0 5 5
17409 17409 NO 20684 STATE MEASURE 27 8824 0350102A 50 249 299
17411 17411 NO 20684 STATE MEASURE 27 8824 0350104E 5 42 47
17413 17413 NO 20684 STATE MEASURE 27 8824 0350105A 2 14 16
17415 17415 NO 20684 STATE MEASURE 27 8824 0350106A 8 33 41
17417 17417 NO 20684 STATE MEASURE 27 8824 0350106B 6 26 32
17419 17419 NO 20684 STATE MEASURE 27 8824 0400001A 61 205 266
17421 17421 NO 20684 STATE MEASURE 27 8824 0400006A 156 486 642
17423 17423 NO 20684 STATE MEASURE 27 8824 0400008A 146 468 614
17425 17425 NO 20684 STATE MEASURE 27 8824 0400010A 227 828 1055

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