results

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

2,990 rows where candidate_id = 20863

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
225184 225184 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050001B 16 28 44
225186 225186 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050002C 1 0 1
225188 225188 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050003A 99 279 378
225190 225190 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050004B 13 82 95
225192 225192 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050011A 0 0 0
225194 225194 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050014A 21 101 122
225196 225196 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050023A 0 0 0
225198 225198 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050042A 0 2 2
225200 225200 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0050063A 126 332 458
225202 225202 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070001B 3 19 22
225204 225204 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070002A 2 23 25
225206 225206 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070004C 4 20 24
225208 225208 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070004E 15 88 103
225210 225210 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070006N 9 14 23
225212 225212 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070007A 43 311 354
225214 225214 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070008A 37 201 238
225216 225216 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070027B 0 2 2
225218 225218 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041A 52 301 353
225220 225220 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041B 15 78 93
225222 225222 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070041K 1 7 8
225224 225224 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0070207A 1 16 17
225226 225226 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080004A 89 587 676
225228 225228 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080012A 75 634 709
225230 225230 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080021A 115 807 922
225232 225232 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080025A 77 528 605
225234 225234 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080038A 67 356 423
225236 225236 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080043A 75 525 600
225238 225238 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0080050A 103 601 704
225240 225240 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090002B 1 3 4
225242 225242 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090003A 102 432 534
225244 225244 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090006A 4 7 11
225246 225246 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090011A 0 14 14
225248 225248 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0090025A 1 4 5
225250 225250 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150004A 114 611 725
225252 225252 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150008A 74 265 339
225254 225254 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150009A 79 397 476
225256 225256 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150011A 80 525 605
225258 225258 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150012A 120 617 737
225260 225260 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150016D 119 724 843
225262 225262 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150018A 153 768 921
225264 225264 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150021A 51 286 337
225266 225266 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150025A 118 512 630
225268 225268 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150028B 44 315 359
225270 225270 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150032A 128 546 674
225272 225272 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150033A 95 369 464
225274 225274 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150037A 50 308 358
225276 225276 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150042A 81 445 526
225278 225278 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150049A 103 481 584
225280 225280 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150060A 64 359 423
225282 225282 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150065A 73 263 336
225284 225284 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150067A 142 571 713
225286 225286 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150070A 32 137 169
225288 225288 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0150071A 60 325 385
225290 225290 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0180002A 36 144 180
225292 225292 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200002A 77 456 533
225294 225294 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200007B 15 50 65
225296 225296 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200013A 148 939 1087
225298 225298 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200014A 157 698 855
225300 225300 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200016A 140 762 902
225302 225302 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200017A 89 525 614
225304 225304 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200019B 101 627 728
225306 225306 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200028A 117 658 775
225308 225308 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200030A 228 1312 1540
225310 225310 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200031A 0 0 0
225312 225312 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200040A 123 757 880
225314 225314 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200051A 91 564 655
225316 225316 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200087A 194 937 1131
225318 225318 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200088A 172 963 1135
225320 225320 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0200091A 98 522 620
225322 225322 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0300001D 7 27 34
225324 225324 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0300002A 11 25 36
225326 225326 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0300002B 4 8 12
225328 225328 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0300002D 0 0 0
225330 225330 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0300003A 2 9 11
225332 225332 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0300013A 17 37 54
225334 225334 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350005B 11 164 175
225336 225336 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350007A 50 468 518
225338 225338 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350008A 70 672 742
225340 225340 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350012A 52 259 311
225342 225342 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350017A 70 694 764
225344 225344 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350022A 129 595 724
225346 225346 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350027A 76 370 446
225348 225348 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350029A 91 626 717
225350 225350 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350038A 21 157 178
225352 225352 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350043A 75 510 585
225354 225354 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350049A 62 524 586
225356 225356 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350052A 1 8 9
225358 225358 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350057A 50 209 259
225360 225360 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350058C 87 750 837
225362 225362 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350061A 1 7 8
225364 225364 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350101A 0 3 3
225366 225366 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350102A 23 181 204
225368 225368 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350104E 2 16 18
225370 225370 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350105A 0 9 9
225372 225372 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350106A 2 20 22
225374 225374 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0350106B 4 17 21
225376 225376 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0400001A 45 194 239
225378 225378 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0400006A 102 337 439
225380 225380 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0400008A 120 355 475
225382 225382 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0400010A 153 641 794

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