results

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

104 rows where precinct_id = "6220142A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
9118 9118 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6220142A 27 60 87
9119 9119 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 6220142A 14 70 84
20554 20554 YES 20683 STATE MEASURE 27 8824 6220142A 7 45 52
20555 20555 NO 20684 STATE MEASURE 27 8824 6220142A 54 111 165
23938 23938 CHRISTY SMITH 20523 UNITED STATES REPRESENTATIVE, 27th District 8747 6220142A 14 77 91
23939 23939 MIKE GARCIA 20524 UNITED STATES REPRESENTATIVE, 27th District 8747 6220142A 48 78 126
28675 28675 YES 20681 STATE MEASURE 26 8823 6220142A 8 63 71
28676 28676 NO 20682 STATE MEASURE 26 8823 6220142A 52 90 142
35609 35609 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6220142A 17 88 105
35610 35610 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 6220142A 22 34 56
41673 41673 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6220142A 24 55 79
41674 41674 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 6220142A 18 77 95
48046 48046 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6220142A 17 80 97
48047 48047 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 6220142A 23 47 70
54166 54166 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6220142A 16 92 108
54167 54167 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 6220142A 24 33 57
60292 60292 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6220142A 12 97 109
60293 60293 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 6220142A 27 28 55
63535 63535 MELISSA K. CANTU 21044 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 8782 6220142A 5 39 44
63536 63536 BILL COOPER 20603 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 8782 6220142A 41 82 123
63537 63537 NICOLE WILSON 21293 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 8782 6220142A 7 17 24
67221 67221 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 6220142A 45 64 109
67222 67222 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 6220142A 15 90 105
73201 73201 FIONA MA 20562 TREASURER 8766 6220142A 15 91 106
73202 73202 JACK M. GUERRERO 20561 TREASURER 8766 6220142A 45 63 108
79181 79181 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 6220142A 45 55 100
79182 79182 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 6220142A 15 95 110
89213 89213 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 6220142A 19 95 114
89214 89214 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 6220142A 43 59 102
95373 95373 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6220142A 24 52 76
95374 95374 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 6220142A 16 79 95
106846 106846 YES 20688 STATE MEASURE 29 8826 6220142A 4 53 57
106847 106847 NO 20689 STATE MEASURE 29 8826 6220142A 56 98 154
114067 114067 YES 21263 COUNTY MEASURE C 8943 6220142A 25 66 91
114068 114068 NO 21264 COUNTY MEASURE C 8943 6220142A 32 78 110
120063 120063 YES 20686 STATE MEASURE 28 8825 6220142A 19 91 110
120064 120064 NO 20687 STATE MEASURE 28 8825 6220142A 40 65 105
127421 127421 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6220142A 18 89 107
127422 127422 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 6220142A 30 54 84
133491 133491 YES 20690 STATE MEASURE 30 8827 6220142A 10 65 75
133492 133492 NO 20691 STATE MEASURE 30 8827 6220142A 51 93 144
139687 139687 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6220142A 16 67 83
139688 139688 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 6220142A 20 63 83
146119 146119 YES 20679 STATE MEASURE 1 8822 6220142A 20 106 126
146120 146120 NO 20680 STATE MEASURE 1 8822 6220142A 38 51 89
152469 152469 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6220142A 19 95 114
152470 152470 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 6220142A 43 57 100
158975 158975 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6220142A 21 86 107
158976 158976 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 6220142A 18 41 59
167584 167584 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6220142A 16 88 104
167585 167585 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 6220142A 23 36 59
177188 177188 BRIAN DAHLE 20554 GOVERNOR 8762 6220142A 47 66 113
177189 177189 GAVIN NEWSOM 20553 GOVERNOR 8762 6220142A 15 91 106
183672 183672 MALIA M. COHEN 20560 CONTROLLER 8765 6220142A 18 89 107
183673 183673 LANHEE J. CHEN 20559 CONTROLLER 8765 6220142A 41 67 108
195446 195446 ROB BONTA 20564 ATTORNEY GENERAL 8767 6220142A 17 92 109
195447 195447 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 6220142A 43 63 106
201426 201426 YES 20692 STATE MEASURE 31 8828 6220142A 23 80 103
201427 201427 NO 20693 STATE MEASURE 31 8828 6220142A 37 74 111
204114 204114 TERESA TODD 21061 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 3 8495 6220142A 31 42 73
204115 204115 CHERISE MOORE 20645 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 3 8495 6220142A 21 89 110
207762 207762 YES 21153 COUNTY MEASURE A 8930 6220142A 18 97 115
207763 207763 NO 21154 COUNTY MEASURE A 8930 6220142A 43 53 96
213742 213742 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6220142A 20 51 71
213743 213743 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 6220142A 17 80 97
222294 222294 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 6220142A 44 63 107
222295 222295 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 6220142A 16 94 110
228512 228512 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 6220142A 22 91 113
228513 228513 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 6220142A 20 48 68
234868 234868 ALEX VILLANUEVA 20574 SHERIFF 8772 6220142A 47 74 121
234869 234869 ROBERT LUNA 20573 SHERIFF 8772 6220142A 14 74 88
241124 241124 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6220142A 16 84 100
241125 241125 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 6220142A 24 41 65
246821 246821 SUZETTE MARTINEZ VALLADARES 20481 MEMBER OF THE STATE ASSEMBLY, 40th District 8723 6220142A 47 69 116
246822 246822 PILAR SCHIAVO 20480 MEMBER OF THE STATE ASSEMBLY, 40th District 8723 6220142A 13 84 97
250849 250849 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6220142A 18 82 100
250850 250850 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 6220142A 23 39 62
261593 261593 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6220142A 34 52 86
261594 261594 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 6220142A 16 81 97
267573 267573 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6220142A 17 80 97
267574 267574 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 6220142A 24 55 79
273553 273553 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6220142A 18 84 102
273554 273554 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 6220142A 21 40 61
279557 279557 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6220142A 15 82 97
279558 279558 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 6220142A 24 42 66
282762 282762 KODY AMOUR 21479 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8604 6220142A 1 3 4
282763 282763 DAVID BARLAVI 21476 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8604 6220142A 3 34 37
282764 282764 SELINA M. THOMAS 21473 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8604 6220142A 6 30 36
282765 282765 BILL MIRANDA 21481 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8604 6220142A 32 60 92
282766 282766 JEFFREY MALICK 21474 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8604 6220142A 5 22 27
282767 282767 MARSHA MCLEAN 21480 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8604 6220142A 22 60 82
282768 282768 DOUGLAS FRASER 21475 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8604 6220142A 2 14 16
282769 282769 LAURENE WESTE 21478 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8604 6220142A 31 46 77
282770 282770 DENISE LITE 21477 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8604 6220142A 24 56 80
287175 287175 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6220142A 13 74 87
287176 287176 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 6220142A 28 59 87
293193 293193 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6220142A 19 87 106
293194 293194 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 6220142A 20 48 68
300769 300769 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6220142A 16 85 101
300770 300770 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 6220142A 24 40 64

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