results

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

93 rows where precinct_id = "1020017A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
6284 6284 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 1020017A 10 60 70
6285 6285 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 1020017A 4 42 46
17720 17720 YES 20683 STATE MEASURE 27 8824 1020017A 6 27 33
17721 17721 NO 20684 STATE MEASURE 27 8824 1020017A 14 105 119
23492 23492 CHRISTY SMITH 20523 UNITED STATES REPRESENTATIVE, 27th District 8747 1020017A 5 47 52
23493 23493 MIKE GARCIA 20524 UNITED STATES REPRESENTATIVE, 27th District 8747 1020017A 15 85 100
25841 25841 YES 20681 STATE MEASURE 26 8823 1020017A 11 37 48
25842 25842 NO 20682 STATE MEASURE 26 8823 1020017A 9 95 104
32775 32775 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 1020017A 4 58 62
32776 32776 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 1020017A 7 39 46
38839 38839 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 1020017A 6 69 75
38840 38840 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 1020017A 9 39 48
45212 45212 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 1020017A 3 58 61
45213 45213 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 1020017A 9 42 51
51332 51332 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 1020017A 4 60 64
51333 51333 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 1020017A 7 36 43
57458 57458 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 1020017A 4 57 61
57459 57459 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 1020017A 7 40 47
63460 63460 MELISSA K. CANTU 21044 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 8782 1020017A 4 12 16
63461 63461 BILL COOPER 20603 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 8782 1020017A 11 94 105
63462 63462 NICOLE WILSON 21293 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 8782 1020017A 0 11 11
64387 64387 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 1020017A 14 87 101
64388 64388 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 1020017A 4 43 47
70367 70367 FIONA MA 20562 TREASURER 8766 1020017A 4 43 47
70368 70368 JACK M. GUERRERO 20561 TREASURER 8766 1020017A 15 83 98
76347 76347 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 1020017A 15 84 99
76348 76348 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 1020017A 4 43 47
86379 86379 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 1020017A 5 46 51
86380 86380 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 1020017A 15 86 101
92539 92539 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 1020017A 7 76 83
92540 92540 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 1020017A 8 34 42
104012 104012 YES 20688 STATE MEASURE 29 8826 1020017A 3 27 30
104013 104013 NO 20689 STATE MEASURE 29 8826 1020017A 16 100 116
111233 111233 YES 21263 COUNTY MEASURE C 8943 1020017A 8 53 61
111234 111234 NO 21264 COUNTY MEASURE C 8943 1020017A 12 71 83
117229 117229 YES 20686 STATE MEASURE 28 8825 1020017A 8 48 56
117230 117230 NO 20687 STATE MEASURE 28 8825 1020017A 11 80 91
124587 124587 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 1020017A 5 51 56
124588 124588 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 1020017A 13 62 75
130657 130657 YES 20690 STATE MEASURE 30 8827 1020017A 2 27 29
130658 130658 NO 20691 STATE MEASURE 30 8827 1020017A 17 100 117
136853 136853 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 1020017A 10 80 90
136854 136854 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 1020017A 5 24 29
143285 143285 YES 20679 STATE MEASURE 1 8822 1020017A 5 64 69
143286 143286 NO 20680 STATE MEASURE 1 8822 1020017A 14 63 77
149635 149635 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 1020017A 5 45 50
149636 149636 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 1020017A 15 84 99
156141 156141 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 1020017A 8 68 76
156142 156142 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 1020017A 3 29 32
164750 164750 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 1020017A 3 59 62
164751 164751 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 1020017A 7 38 45
174354 174354 BRIAN DAHLE 20554 GOVERNOR 8762 1020017A 15 85 100
174355 174355 GAVIN NEWSOM 20553 GOVERNOR 8762 1020017A 4 44 48
180838 180838 MALIA M. COHEN 20560 CONTROLLER 8765 1020017A 3 40 43
180839 180839 LANHEE J. CHEN 20559 CONTROLLER 8765 1020017A 17 87 104
192612 192612 ROB BONTA 20564 ATTORNEY GENERAL 8767 1020017A 4 46 50
192613 192613 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 1020017A 14 82 96
198592 198592 YES 20692 STATE MEASURE 31 8828 1020017A 8 63 71
198593 198593 NO 20693 STATE MEASURE 31 8828 1020017A 12 65 77
204928 204928 YES 21153 COUNTY MEASURE A 8930 1020017A 6 50 56
204929 204929 NO 21154 COUNTY MEASURE A 8930 1020017A 13 73 86
210908 210908 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 1020017A 3 25 28
210909 210909 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 1020017A 10 76 86
219460 219460 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 1020017A 15 85 100
219461 219461 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 1020017A 5 44 49
225678 225678 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 1020017A 3 58 61
225679 225679 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 1020017A 9 43 52
232034 232034 ALEX VILLANUEVA 20574 SHERIFF 8772 1020017A 15 74 89
232035 232035 ROBERT LUNA 20573 SHERIFF 8772 1020017A 4 52 56
238290 238290 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 1020017A 3 61 64
238291 238291 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 1020017A 8 36 44
246675 246675 SUZETTE MARTINEZ VALLADARES 20481 MEMBER OF THE STATE ASSEMBLY, 40th District 8723 1020017A 15 86 101
246676 246676 PILAR SCHIAVO 20480 MEMBER OF THE STATE ASSEMBLY, 40th District 8723 1020017A 5 42 47
248015 248015 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 1020017A 3 58 61
248016 248016 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 1020017A 8 39 47
258759 258759 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 1020017A 10 53 63
258760 258760 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 1020017A 4 59 63
264739 264739 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 1020017A 3 58 61
264740 264740 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 1020017A 9 43 52
270719 270719 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 1020017A 3 62 65
270720 270720 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 1020017A 7 35 42
276723 276723 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 1020017A 4 60 64
276724 276724 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 1020017A 7 37 44
284341 284341 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 1020017A 5 58 63
284342 284342 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 1020017A 10 44 54
290359 290359 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 1020017A 3 59 62
290360 290360 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 1020017A 9 43 52
297935 297935 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 1020017A 6 64 70
297936 297936 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 1020017A 6 33 39
309126 309126 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 1020017A 6 67 73
309127 309127 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 1020017A 5 29 34
317874 317874 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 1020017A 3 59 62
317875 317875 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 1020017A 8 37 45

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