results

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

2,990 rows where candidate_id = 20691

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
130164 130164 NO 20691 STATE MEASURE 30 8827 0050001B 33 48 81
130166 130166 NO 20691 STATE MEASURE 30 8827 0050002C 1 0 1
130168 130168 NO 20691 STATE MEASURE 30 8827 0050003A 367 487 854
130170 130170 NO 20691 STATE MEASURE 30 8827 0050004B 95 116 211
130172 130172 NO 20691 STATE MEASURE 30 8827 0050011A 1 1 2
130174 130174 NO 20691 STATE MEASURE 30 8827 0050014A 98 230 328
130176 130176 NO 20691 STATE MEASURE 30 8827 0050023A 4 0 4
130178 130178 NO 20691 STATE MEASURE 30 8827 0050042A 0 1 1
130180 130180 NO 20691 STATE MEASURE 30 8827 0050063A 429 686 1115
130182 130182 NO 20691 STATE MEASURE 30 8827 0070001B 2 18 20
130184 130184 NO 20691 STATE MEASURE 30 8827 0070002A 7 30 37
130186 130186 NO 20691 STATE MEASURE 30 8827 0070004C 7 29 36
130188 130188 NO 20691 STATE MEASURE 30 8827 0070004E 24 82 106
130190 130190 NO 20691 STATE MEASURE 30 8827 0070006N 10 27 37
130192 130192 NO 20691 STATE MEASURE 30 8827 0070007A 95 285 380
130194 130194 NO 20691 STATE MEASURE 30 8827 0070008A 72 256 328
130196 130196 NO 20691 STATE MEASURE 30 8827 0070027B 0 2 2
130198 130198 NO 20691 STATE MEASURE 30 8827 0070041A 134 407 541
130200 130200 NO 20691 STATE MEASURE 30 8827 0070041B 31 79 110
130202 130202 NO 20691 STATE MEASURE 30 8827 0070041K 1 5 6
130204 130204 NO 20691 STATE MEASURE 30 8827 0070207A 0 25 25
130206 130206 NO 20691 STATE MEASURE 30 8827 0080004A 188 672 860
130208 130208 NO 20691 STATE MEASURE 30 8827 0080012A 161 784 945
130210 130210 NO 20691 STATE MEASURE 30 8827 0080021A 244 866 1110
130212 130212 NO 20691 STATE MEASURE 30 8827 0080025A 160 577 737
130214 130214 NO 20691 STATE MEASURE 30 8827 0080038A 132 418 550
130216 130216 NO 20691 STATE MEASURE 30 8827 0080043A 146 551 697
130218 130218 NO 20691 STATE MEASURE 30 8827 0080050A 184 700 884
130220 130220 NO 20691 STATE MEASURE 30 8827 0090002B 5 12 17
130222 130222 NO 20691 STATE MEASURE 30 8827 0090003A 468 853 1321
130224 130224 NO 20691 STATE MEASURE 30 8827 0090006A 5 23 28
130226 130226 NO 20691 STATE MEASURE 30 8827 0090011A 1 23 24
130228 130228 NO 20691 STATE MEASURE 30 8827 0090025A 0 0 0
130230 130230 NO 20691 STATE MEASURE 30 8827 0150004A 151 598 749
130232 130232 NO 20691 STATE MEASURE 30 8827 0150008A 70 214 284
130234 130234 NO 20691 STATE MEASURE 30 8827 0150009A 87 296 383
130236 130236 NO 20691 STATE MEASURE 30 8827 0150011A 111 457 568
130238 130238 NO 20691 STATE MEASURE 30 8827 0150012A 144 489 633
130240 130240 NO 20691 STATE MEASURE 30 8827 0150016D 204 617 821
130242 130242 NO 20691 STATE MEASURE 30 8827 0150018A 160 588 748
130244 130244 NO 20691 STATE MEASURE 30 8827 0150021A 71 262 333
130246 130246 NO 20691 STATE MEASURE 30 8827 0150025A 113 387 500
130248 130248 NO 20691 STATE MEASURE 30 8827 0150028B 54 289 343
130250 130250 NO 20691 STATE MEASURE 30 8827 0150032A 151 450 601
130252 130252 NO 20691 STATE MEASURE 30 8827 0150033A 93 262 355
130254 130254 NO 20691 STATE MEASURE 30 8827 0150037A 63 256 319
130256 130256 NO 20691 STATE MEASURE 30 8827 0150042A 93 397 490
130258 130258 NO 20691 STATE MEASURE 30 8827 0150049A 127 413 540
130260 130260 NO 20691 STATE MEASURE 30 8827 0150060A 64 263 327
130262 130262 NO 20691 STATE MEASURE 30 8827 0150065A 73 198 271
130264 130264 NO 20691 STATE MEASURE 30 8827 0150067A 192 480 672
130266 130266 NO 20691 STATE MEASURE 30 8827 0150070A 43 121 164
130268 130268 NO 20691 STATE MEASURE 30 8827 0150071A 79 265 344
130270 130270 NO 20691 STATE MEASURE 30 8827 0180002A 40 93 133
130272 130272 NO 20691 STATE MEASURE 30 8827 0200002A 73 383 456
130274 130274 NO 20691 STATE MEASURE 30 8827 0200007B 13 57 70
130276 130276 NO 20691 STATE MEASURE 30 8827 0200013A 142 742 884
130278 130278 NO 20691 STATE MEASURE 30 8827 0200014A 154 586 740
130280 130280 NO 20691 STATE MEASURE 30 8827 0200016A 178 671 849
130282 130282 NO 20691 STATE MEASURE 30 8827 0200017A 90 367 457
130284 130284 NO 20691 STATE MEASURE 30 8827 0200019B 102 484 586
130286 130286 NO 20691 STATE MEASURE 30 8827 0200028A 126 559 685
130288 130288 NO 20691 STATE MEASURE 30 8827 0200030A 294 1317 1611
130290 130290 NO 20691 STATE MEASURE 30 8827 0200031A 0 0 0
130292 130292 NO 20691 STATE MEASURE 30 8827 0200040A 170 680 850
130294 130294 NO 20691 STATE MEASURE 30 8827 0200051A 100 458 558
130296 130296 NO 20691 STATE MEASURE 30 8827 0200087A 221 833 1054
130298 130298 NO 20691 STATE MEASURE 30 8827 0200088A 173 748 921
130300 130300 NO 20691 STATE MEASURE 30 8827 0200091A 104 418 522
130302 130302 NO 20691 STATE MEASURE 30 8827 0300001D 9 39 48
130304 130304 NO 20691 STATE MEASURE 30 8827 0300002A 23 38 61
130306 130306 NO 20691 STATE MEASURE 30 8827 0300002B 3 8 11
130308 130308 NO 20691 STATE MEASURE 30 8827 0300002D 0 2 2
130310 130310 NO 20691 STATE MEASURE 30 8827 0300003A 7 21 28
130312 130312 NO 20691 STATE MEASURE 30 8827 0300013A 47 90 137
130314 130314 NO 20691 STATE MEASURE 30 8827 0350005B 47 228 275
130316 130316 NO 20691 STATE MEASURE 30 8827 0350007A 150 681 831
130318 130318 NO 20691 STATE MEASURE 30 8827 0350008A 168 801 969
130320 130320 NO 20691 STATE MEASURE 30 8827 0350012A 81 304 385
130322 130322 NO 20691 STATE MEASURE 30 8827 0350017A 151 874 1025
130324 130324 NO 20691 STATE MEASURE 30 8827 0350022A 163 511 674
130326 130326 NO 20691 STATE MEASURE 30 8827 0350027A 110 298 408
130328 130328 NO 20691 STATE MEASURE 30 8827 0350029A 171 767 938
130330 130330 NO 20691 STATE MEASURE 30 8827 0350038A 35 188 223
130332 130332 NO 20691 STATE MEASURE 30 8827 0350043A 137 483 620
130334 130334 NO 20691 STATE MEASURE 30 8827 0350049A 127 622 749
130336 130336 NO 20691 STATE MEASURE 30 8827 0350052A 4 9 13
130338 130338 NO 20691 STATE MEASURE 30 8827 0350057A 84 303 387
130340 130340 NO 20691 STATE MEASURE 30 8827 0350058C 162 851 1013
130342 130342 NO 20691 STATE MEASURE 30 8827 0350061A 5 5 10
130344 130344 NO 20691 STATE MEASURE 30 8827 0350101A 0 3 3
130346 130346 NO 20691 STATE MEASURE 30 8827 0350102A 40 176 216
130348 130348 NO 20691 STATE MEASURE 30 8827 0350104E 4 33 37
130350 130350 NO 20691 STATE MEASURE 30 8827 0350105A 2 13 15
130352 130352 NO 20691 STATE MEASURE 30 8827 0350106A 8 27 35
130354 130354 NO 20691 STATE MEASURE 30 8827 0350106B 1 17 18
130356 130356 NO 20691 STATE MEASURE 30 8827 0400001A 51 121 172
130358 130358 NO 20691 STATE MEASURE 30 8827 0400006A 143 349 492
130360 130360 NO 20691 STATE MEASURE 30 8827 0400008A 135 334 469
130362 130362 NO 20691 STATE MEASURE 30 8827 0400010A 190 603 793

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