results

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

96 rows where precinct_id = "5750023A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
8890 8890 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 5750023A 33 90 123
8891 8891 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 5750023A 38 95 133
20326 20326 YES 20683 STATE MEASURE 27 8824 5750023A 11 59 70
20327 20327 NO 20684 STATE MEASURE 27 8824 5750023A 78 196 274
24618 24618 BURTON BRINK 20492 MEMBER OF THE STATE ASSEMBLY, 49th District 8730 5750023A 34 84 118
24619 24619 MIKE FONG 20491 MEMBER OF THE STATE ASSEMBLY, 49th District 8730 5750023A 55 177 232
25122 25122 YES 21290 PASADENA AREA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE PCC 8946 5750023A 60 158 218
25123 25123 NO 21291 PASADENA AREA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE PCC 8946 5750023A 26 83 109
28447 28447 YES 20681 STATE MEASURE 26 8823 5750023A 21 101 122
28448 28448 NO 20682 STATE MEASURE 26 8823 5750023A 66 150 216
35381 35381 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 5750023A 51 140 191
35382 35382 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 5750023A 24 35 59
41445 41445 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 5750023A 46 128 174
41446 41446 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 5750023A 32 71 103
47818 47818 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 5750023A 45 148 193
47819 47819 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 5750023A 30 41 71
53938 53938 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 5750023A 52 146 198
53939 53939 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 5750023A 23 36 59
60064 60064 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 5750023A 52 135 187
60065 60065 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 5750023A 22 43 65
66993 66993 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 5750023A 39 85 124
66994 66994 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 5750023A 50 162 212
72973 72973 FIONA MA 20562 TREASURER 8766 5750023A 53 161 214
72974 72974 JACK M. GUERRERO 20561 TREASURER 8766 5750023A 38 86 124
78953 78953 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 5750023A 36 82 118
78954 78954 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 5750023A 52 160 212
88985 88985 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 5750023A 51 173 224
88986 88986 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 5750023A 37 85 122
95145 95145 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 5750023A 38 115 153
95146 95146 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 5750023A 36 81 117
103506 103506 NANCY ARMENTA 20649 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750023A 54 139 193
103507 103507 DIANE BENITEZ 20650 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750023A 40 127 167
103508 103508 JONATHAN L. SMITH 20843 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750023A 13 54 67
103509 103509 JOHN QUINTANILLA 20622 ROSEMEAD SCHOOL DISTRICT Governing Board Member 8484 5750023A 42 123 165
106618 106618 YES 20688 STATE MEASURE 29 8826 5750023A 36 99 135
106619 106619 NO 20689 STATE MEASURE 29 8826 5750023A 53 156 209
113839 113839 YES 21263 COUNTY MEASURE C 8943 5750023A 53 161 214
113840 113840 NO 21264 COUNTY MEASURE C 8943 5750023A 32 79 111
119835 119835 YES 20686 STATE MEASURE 28 8825 5750023A 54 165 219
119836 119836 NO 20687 STATE MEASURE 28 8825 5750023A 35 85 120
127193 127193 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 5750023A 48 153 201
127194 127194 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 5750023A 36 71 107
133263 133263 YES 20690 STATE MEASURE 30 8827 5750023A 43 122 165
133264 133264 NO 20691 STATE MEASURE 30 8827 5750023A 46 139 185
139459 139459 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 5750023A 29 102 131
139460 139460 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 5750023A 39 86 125
145891 145891 YES 20679 STATE MEASURE 1 8822 5750023A 55 180 235
145892 145892 NO 20680 STATE MEASURE 1 8822 5750023A 34 75 109
152241 152241 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 5750023A 51 171 222
152242 152242 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 5750023A 38 83 121
158747 158747 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 5750023A 53 136 189
158748 158748 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 5750023A 20 37 57
167356 167356 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 5750023A 50 138 188
167357 167357 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 5750023A 25 39 64
176960 176960 BRIAN DAHLE 20554 GOVERNOR 8762 5750023A 36 90 126
176961 176961 GAVIN NEWSOM 20553 GOVERNOR 8762 5750023A 55 175 230
183444 183444 MALIA M. COHEN 20560 CONTROLLER 8765 5750023A 49 140 189
183445 183445 LANHEE J. CHEN 20559 CONTROLLER 8765 5750023A 42 110 152
191532 191532 JUDY CHU 20526 UNITED STATES REPRESENTATIVE, 28th District 8748 5750023A 54 191 245
191533 191533 WES HALLMAN 20525 UNITED STATES REPRESENTATIVE, 28th District 8748 5750023A 33 70 103
195218 195218 ROB BONTA 20564 ATTORNEY GENERAL 8767 5750023A 54 161 215
195219 195219 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 5750023A 36 88 124
201198 201198 YES 20692 STATE MEASURE 31 8828 5750023A 51 172 223
201199 201199 NO 20693 STATE MEASURE 31 8828 5750023A 36 82 118
207534 207534 YES 21153 COUNTY MEASURE A 8930 5750023A 58 178 236
207535 207535 NO 21154 COUNTY MEASURE A 8930 5750023A 27 66 93
213514 213514 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 5750023A 29 78 107
213515 213515 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 5750023A 48 117 165
222066 222066 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 5750023A 35 85 120
222067 222067 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 5750023A 55 158 213
228284 228284 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 5750023A 56 149 205
228285 228285 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 5750023A 23 48 71
234640 234640 ALEX VILLANUEVA 20574 SHERIFF 8772 5750023A 36 101 137
234641 234641 ROBERT LUNA 20573 SHERIFF 8772 5750023A 49 141 190
240896 240896 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 5750023A 52 133 185
240897 240897 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 5750023A 23 45 68
250621 250621 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 5750023A 47 135 182
250622 250622 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 5750023A 25 40 65
261365 261365 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 5750023A 32 74 106
261366 261366 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 5750023A 45 122 167
267345 267345 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 5750023A 56 160 216
267346 267346 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 5750023A 21 35 56
273325 273325 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 5750023A 47 137 184
273326 273326 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 5750023A 24 38 62
279329 279329 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 5750023A 45 129 174
279330 279330 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 5750023A 27 44 71
286947 286947 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 5750023A 27 98 125
286948 286948 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 5750023A 49 87 136
292965 292965 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 5750023A 55 148 203
292966 292966 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 5750023A 24 42 66
300541 300541 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 5750023A 45 136 181
300542 300542 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 5750023A 32 49 81
311732 311732 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 5750023A 61 140 201
311733 311733 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 5750023A 14 36 50
320480 320480 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 5750023A 46 135 181
320481 320481 NO 20892 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 5750023A 27 41 68

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