results

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

106 rows where precinct_id = "2300042A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
7048 7048 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 2300042A 40 101 141
7049 7049 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 2300042A 36 113 149
14475 14475 JOHN BRISCOE 20546 UNITED STATES REPRESENTATIVE, 42nd District 8758 2300042A 21 33 54
14476 14476 ROBERT GARCIA 20545 UNITED STATES REPRESENTATIVE, 42nd District 8758 2300042A 60 200 260
18484 18484 YES 20683 STATE MEASURE 27 8824 2300042A 26 53 79
18485 18485 NO 20684 STATE MEASURE 27 8824 2300042A 54 191 245
26605 26605 YES 20681 STATE MEASURE 26 8823 2300042A 40 92 132
26606 26606 NO 20682 STATE MEASURE 26 8823 2300042A 40 148 188
33539 33539 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 2300042A 46 160 206
33540 33540 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 2300042A 24 52 76
39603 39603 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 2300042A 40 89 129
39604 39604 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 2300042A 38 128 166
45976 45976 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 2300042A 47 144 191
45977 45977 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 2300042A 25 69 94
52096 52096 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 2300042A 51 160 211
52097 52097 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 2300042A 22 51 73
58222 58222 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 2300042A 51 164 215
58223 58223 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 2300042A 23 44 67
65151 65151 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 2300042A 25 44 69
65152 65152 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 2300042A 58 195 253
71131 71131 FIONA MA 20562 TREASURER 8766 2300042A 52 210 262
71132 71132 JACK M. GUERRERO 20561 TREASURER 8766 2300042A 29 33 62
77111 77111 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 2300042A 23 38 61
77112 77112 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 2300042A 59 205 264
82577 82577 GABRIEL BUELNA 20672 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 6 8517 2300042A 55 158 213
82578 82578 ROBERT L. PAYNE 20756 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 6 8517 2300042A 20 65 85
87143 87143 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 2300042A 64 211 275
87144 87144 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 2300042A 20 31 51
93303 93303 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 2300042A 48 133 181
93304 93304 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 2300042A 28 83 111
98637 98637 KELSEY IINO 20637 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION Member of the Board of Trustees, Seat 7 (Unexpired term ending December 13, 2024) 8528 2300042A 24 121 145
98638 98638 MARK DUTTON 21252 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION Member of the Board of Trustees, Seat 7 (Unexpired term ending December 13, 2024) 8528 2300042A 7 20 27
98639 98639 NANCY PEARLMAN 21112 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION Member of the Board of Trustees, Seat 7 (Unexpired term ending December 13, 2024) 8528 2300042A 45 88 133
104776 104776 YES 20688 STATE MEASURE 29 8826 2300042A 42 98 140
104777 104777 NO 20689 STATE MEASURE 29 8826 2300042A 37 144 181
111997 111997 YES 21263 COUNTY MEASURE C 8943 2300042A 55 163 218
111998 111998 NO 21264 COUNTY MEASURE C 8943 2300042A 22 67 89
117993 117993 YES 20686 STATE MEASURE 28 8825 2300042A 59 196 255
117994 117994 NO 20687 STATE MEASURE 28 8825 2300042A 24 42 66
125351 125351 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 2300042A 54 188 242
125352 125352 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 2300042A 24 41 65
131421 131421 YES 20690 STATE MEASURE 30 8827 2300042A 35 120 155
131422 131422 NO 20691 STATE MEASURE 30 8827 2300042A 45 122 167
137617 137617 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 2300042A 37 130 167
137618 137618 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 2300042A 38 87 125
144049 144049 YES 20679 STATE MEASURE 1 8822 2300042A 49 179 228
144050 144050 NO 20680 STATE MEASURE 1 8822 2300042A 33 60 93
150399 150399 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 2300042A 63 208 271
150400 150400 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 2300042A 19 30 49
156905 156905 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 2300042A 53 169 222
156906 156906 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 2300042A 19 43 62
165514 165514 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 2300042A 49 160 209
165515 165515 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 2300042A 23 52 75
175118 175118 BRIAN DAHLE 20554 GOVERNOR 8762 2300042A 25 34 59
175119 175119 GAVIN NEWSOM 20553 GOVERNOR 8762 2300042A 59 211 270
181602 181602 MALIA M. COHEN 20560 CONTROLLER 8765 2300042A 57 201 258
181603 181603 LANHEE J. CHEN 20559 CONTROLLER 8765 2300042A 24 41 65
188192 188192 YES 21200 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE LA 8934 2300042A 58 181 239
188193 188193 NO 21201 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE LA 8934 2300042A 23 51 74
193376 193376 ROB BONTA 20564 ATTORNEY GENERAL 8767 2300042A 59 197 256
193377 193377 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 2300042A 21 46 67
199356 199356 YES 20692 STATE MEASURE 31 8828 2300042A 47 152 199
199357 199357 NO 20693 STATE MEASURE 31 8828 2300042A 35 88 123
205692 205692 YES 21153 COUNTY MEASURE A 8930 2300042A 65 189 254
205693 205693 NO 21154 COUNTY MEASURE A 8930 2300042A 13 42 55
211672 211672 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 2300042A 40 76 116
211673 211673 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 2300042A 37 140 177
220224 220224 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 2300042A 21 31 52
220225 220225 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 2300042A 63 209 272
226442 226442 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 2300042A 56 179 235
226443 226443 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 2300042A 19 36 55
232798 232798 ALEX VILLANUEVA 20574 SHERIFF 8772 2300042A 35 104 139
232799 232799 ROBERT LUNA 20573 SHERIFF 8772 2300042A 46 137 183
239054 239054 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 2300042A 52 177 229
239055 239055 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 2300042A 22 35 57
244708 244708 REGGIE JONES-SAWYER 20504 MEMBER OF THE STATE ASSEMBLY, 57th District 8737 2300042A 62 189 251
248779 248779 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 2300042A 51 161 212
248780 248780 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 2300042A 20 51 71
254404 254404 ERNEST H. MORENO 21011 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 4 8516 2300042A 25 82 107
254405 254405 SARA HERNANDEZ 20788 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 4 8516 2300042A 43 112 155
254406 254406 CHRISTINE T. LAMONICA 20699 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 4 8516 2300042A 8 32 40
259523 259523 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 2300042A 38 72 110
259524 259524 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 2300042A 38 154 192
265503 265503 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 2300042A 54 163 217
265504 265504 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 2300042A 23 50 73
271483 271483 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 2300042A 46 155 201
271484 271484 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 2300042A 26 56 82
277487 277487 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 2300042A 46 157 203
277488 277488 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 2300042A 25 54 79
283036 283036 SERGIO JOSEPH CALDERON 21041 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 4 8425 2300042A 47 144 191
283037 283037 JOSE R. GONZALEZ 21023 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 4 8425 2300042A 29 78 107
285105 285105 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 2300042A 30 104 134
285106 285106 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 2300042A 43 114 157
291123 291123 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 2300042A 50 157 207
291124 291124 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 2300042A 25 56 81
298699 298699 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 2300042A 52 152 204
298700 298700 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 2300042A 22 61 83
304388 304388 ARTURO CHACON 20592 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8403 2300042A 57 155 212
304389 304389 LEONARD MENDOZA 21317 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8403 2300042A 18 61 79
305110 305110 JASON R. AULA 21305 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 2 8515 2300042A 15 36 51

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