results

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

2,990 rows where candidate_id = 20866

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
264245 264245 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050001B 15 30 45
264247 264247 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050002C 2 0 2
264249 264249 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050003A 97 265 362
264251 264251 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050004B 12 72 84
264253 264253 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050011A 0 0 0
264255 264255 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050014A 23 93 116
264257 264257 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050023A 0 0 0
264259 264259 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050042A 0 2 2
264261 264261 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0050063A 119 335 454
264263 264263 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070001B 3 20 23
264265 264265 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070002A 2 25 27
264267 264267 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070004C 4 21 25
264269 264269 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070004E 13 88 101
264271 264271 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070006N 8 15 23
264273 264273 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070007A 45 286 331
264275 264275 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070008A 33 198 231
264277 264277 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070027B 0 2 2
264279 264279 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070041A 54 294 348
264281 264281 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070041B 16 69 85
264283 264283 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070041K 1 7 8
264285 264285 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0070207A 1 16 17
264287 264287 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080004A 94 583 677
264289 264289 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080012A 69 644 713
264291 264291 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080021A 108 788 896
264293 264293 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080025A 77 530 607
264295 264295 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080038A 73 346 419
264297 264297 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080043A 73 511 584
264299 264299 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0080050A 91 597 688
264301 264301 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090002B 1 3 4
264303 264303 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090003A 102 423 525
264305 264305 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090006A 0 7 7
264307 264307 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090011A 0 13 13
264309 264309 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0090025A 1 4 5
264311 264311 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150004A 111 611 722
264313 264313 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150008A 73 252 325
264315 264315 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150009A 76 414 490
264317 264317 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150011A 77 497 574
264319 264319 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150012A 119 616 735
264321 264321 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150016D 109 706 815
264323 264323 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150018A 139 712 851
264325 264325 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150021A 45 313 358
264327 264327 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150025A 107 513 620
264329 264329 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150028B 42 332 374
264331 264331 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150032A 123 513 636
264333 264333 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150033A 94 352 446
264335 264335 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150037A 48 285 333
264337 264337 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150042A 77 461 538
264339 264339 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150049A 107 506 613
264341 264341 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150060A 58 362 420
264343 264343 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150065A 61 251 312
264345 264345 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150067A 133 580 713
264347 264347 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150070A 33 137 170
264349 264349 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0150071A 53 317 370
264351 264351 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0180002A 37 133 170
264353 264353 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200002A 70 443 513
264355 264355 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200007B 15 50 65
264357 264357 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200013A 146 902 1048
264359 264359 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200014A 152 695 847
264361 264361 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200016A 131 732 863
264363 264363 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200017A 78 487 565
264365 264365 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200019B 96 599 695
264367 264367 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200028A 110 640 750
264369 264369 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200030A 222 1260 1482
264371 264371 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200031A 0 0 0
264373 264373 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200040A 111 707 818
264375 264375 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200051A 84 545 629
264377 264377 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200087A 189 925 1114
264379 264379 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200088A 165 944 1109
264381 264381 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0200091A 95 507 602
264383 264383 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0300001D 6 24 30
264385 264385 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0300002A 11 21 32
264387 264387 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0300002B 4 8 12
264389 264389 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0300002D 0 0 0
264391 264391 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0300003A 1 10 11
264393 264393 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0300013A 19 31 50
264395 264395 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350005B 15 176 191
264397 264397 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350007A 50 529 579
264399 264399 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350008A 77 745 822
264401 264401 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350012A 53 277 330
264403 264403 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350017A 64 753 817
264405 264405 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350022A 125 623 748
264407 264407 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350027A 76 383 459
264409 264409 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350029A 105 722 827
264411 264411 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350038A 25 179 204
264413 264413 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350043A 81 544 625
264415 264415 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350049A 76 618 694
264417 264417 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350052A 0 7 7
264419 264419 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350057A 60 260 320
264421 264421 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350058C 100 845 945
264423 264423 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350061A 2 5 7
264425 264425 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350101A 0 2 2
264427 264427 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350102A 28 206 234
264429 264429 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350104E 2 19 21
264431 264431 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350105A 0 9 9
264433 264433 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350106A 2 21 23
264435 264435 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0350106B 4 22 26
264437 264437 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0400001A 47 161 208
264439 264439 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0400006A 90 322 412
264441 264441 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0400008A 107 340 447
264443 264443 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0400010A 144 617 761

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