results

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

101 rows where precinct_id = "0400001A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
5982 5982 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 0400001A 38 111 149
5983 5983 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 0400001A 30 103 133
17418 17418 YES 20683 STATE MEASURE 27 8824 0400001A 21 58 79
17419 17419 NO 20684 STATE MEASURE 27 8824 0400001A 61 205 266
25539 25539 YES 20681 STATE MEASURE 26 8823 0400001A 28 87 115
25540 25540 NO 20682 STATE MEASURE 26 8823 0400001A 53 166 219
31422 31422 YES 21320 CERRITOS COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE CC 8948 0400001A 50 174 224
31423 31423 NO 21321 CERRITOS COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE CC 8948 0400001A 33 81 114
32473 32473 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 0400001A 33 159 192
32474 32474 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 0400001A 36 46 82
38537 38537 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 0400001A 38 81 119
38538 38538 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 0400001A 30 133 163
44910 44910 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 0400001A 41 168 209
44911 44911 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 0400001A 31 42 73
51030 51030 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 0400001A 41 170 211
51031 51031 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 0400001A 29 39 68
57156 57156 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 0400001A 40 159 199
57157 57157 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 0400001A 27 47 74
64085 64085 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 0400001A 39 54 93
64086 64086 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 0400001A 43 202 245
70065 70065 FIONA MA 20562 TREASURER 8766 0400001A 44 191 235
70066 70066 JACK M. GUERRERO 20561 TREASURER 8766 0400001A 41 61 102
76045 76045 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 0400001A 39 54 93
76046 76046 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0400001A 43 201 244
86077 86077 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 0400001A 46 216 262
86078 86078 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 0400001A 37 48 85
92237 92237 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 0400001A 43 138 181
92238 92238 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 0400001A 24 77 101
103710 103710 YES 20688 STATE MEASURE 29 8826 0400001A 30 116 146
103711 103711 NO 20689 STATE MEASURE 29 8826 0400001A 53 142 195
110931 110931 YES 21263 COUNTY MEASURE C 8943 0400001A 38 173 211
110932 110932 NO 21264 COUNTY MEASURE C 8943 0400001A 39 69 108
116927 116927 YES 20686 STATE MEASURE 28 8825 0400001A 52 179 231
116928 116928 NO 20687 STATE MEASURE 28 8825 0400001A 28 76 104
124285 124285 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 0400001A 42 199 241
124286 124286 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 0400001A 38 39 77
130355 130355 YES 20690 STATE MEASURE 30 8827 0400001A 29 135 164
130356 130356 NO 20691 STATE MEASURE 30 8827 0400001A 51 121 172
136199 136199 MELISSA RAMOSO 21618 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8560 0400001A 44 174 218
136200 136200 ALI TAJ 21612 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8560 0400001A 53 167 220
136201 136201 RENE J. TREVINO 21615 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8560 0400001A 42 123 165
136202 136202 ALMA L. GRIFFIN 21613 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8560 0400001A 20 57 77
136551 136551 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 0400001A 32 111 143
136552 136552 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 0400001A 33 103 136
142983 142983 YES 20679 STATE MEASURE 1 8822 0400001A 35 184 219
142984 142984 NO 20680 STATE MEASURE 1 8822 0400001A 46 76 122
149333 149333 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 0400001A 45 206 251
149334 149334 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 0400001A 36 54 90
155839 155839 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 0400001A 42 166 208
155840 155840 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 0400001A 24 38 62
164448 164448 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 0400001A 39 169 208
164449 164449 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 0400001A 30 37 67
174052 174052 BRIAN DAHLE 20554 GOVERNOR 8762 0400001A 36 58 94
174053 174053 GAVIN NEWSOM 20553 GOVERNOR 8762 0400001A 48 206 254
180536 180536 MALIA M. COHEN 20560 CONTROLLER 8765 0400001A 43 191 234
180537 180537 LANHEE J. CHEN 20559 CONTROLLER 8765 0400001A 39 60 99
192310 192310 ROB BONTA 20564 ATTORNEY GENERAL 8767 0400001A 42 199 241
192311 192311 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 0400001A 41 56 97
198290 198290 YES 20692 STATE MEASURE 31 8828 0400001A 44 166 210
198291 198291 NO 20693 STATE MEASURE 31 8828 0400001A 38 91 129
204626 204626 YES 21153 COUNTY MEASURE A 8930 0400001A 47 191 238
204627 204627 NO 21154 COUNTY MEASURE A 8930 0400001A 34 57 91
210606 210606 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 0400001A 27 81 108
210607 210607 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 0400001A 40 137 177
216394 216394 JAY F. CHEN 20552 UNITED STATES REPRESENTATIVE, 45th District 8761 0400001A 42 191 233
216395 216395 MICHELLE STEEL 20551 UNITED STATES REPRESENTATIVE, 45th District 8761 0400001A 40 69 109
219158 219158 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 0400001A 36 47 83
219159 219159 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 0400001A 47 210 257
225376 225376 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0400001A 45 194 239
225377 225377 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0400001A 28 29 57
231732 231732 ALEX VILLANUEVA 20574 SHERIFF 8772 0400001A 54 113 167
231733 231733 ROBERT LUNA 20573 SHERIFF 8772 0400001A 27 146 173
237596 237596 SOO YOO 20516 MEMBER OF THE STATE ASSEMBLY, 67th District 8743 0400001A 40 60 100
237597 237597 SHARON QUIRK-SILVA 20515 MEMBER OF THE STATE ASSEMBLY, 67th District 8743 0400001A 44 200 244
237988 237988 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 0400001A 43 167 210
237989 237989 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 0400001A 29 42 71
247713 247713 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 0400001A 41 161 202
247714 247714 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 0400001A 30 43 73
258457 258457 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 0400001A 34 90 124
258458 258458 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 0400001A 35 138 173
264437 264437 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0400001A 47 161 208
264438 264438 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0400001A 24 51 75
270417 270417 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 0400001A 36 151 187
270418 270418 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 0400001A 33 51 84
276421 276421 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 0400001A 35 159 194
276422 276422 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 0400001A 32 45 77
284039 284039 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 0400001A 26 90 116
284040 284040 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 0400001A 46 126 172
290057 290057 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 0400001A 44 174 218
290058 290058 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 0400001A 27 37 64
297633 297633 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 0400001A 42 162 204
297634 297634 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 0400001A 31 49 80
304234 304234 KIM CARR 20474 STATE SENATOR, 36th District 8720 0400001A 38 191 229
304235 304235 JANET NGUYEN 20475 STATE SENATOR, 36th District 8720 0400001A 43 72 115
308824 308824 YES 20882 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 0400001A 39 168 207
308825 308825 NO 20883 For Associate Justice, Court of Appeal, Second District, Division Two - JUDITH M. ASHMANN 8883 0400001A 29 43 72
316309 316309 JOHN ALLEN 20591 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 3 8424 0400001A 35 123 158
316310 316310 GERRIE SCHIPSKE 21258 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 3 8424 0400001A 9 40 49
316311 316311 MIKE MURCHISON 20639 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 3 8424 0400001A 24 53 77
317572 317572 YES 20891 For Associate Justice, Court of Appeal, Second District, Division Four - BRIAN S. CURREY 8886 0400001A 46 153 199

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