results

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

107 rows where precinct_id = "0700001A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
6086 6086 KAREN A. BRAKO 20586 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 0700001A 35 89 124
6087 6087 PATRICK HARE 20585 JUDGE OF THE SUPERIOR COURT Office No. 151 8779 0700001A 63 121 184
14311 14311 JOHN BRISCOE 20546 UNITED STATES REPRESENTATIVE, 42nd District 8758 0700001A 44 33 77
14312 14312 ROBERT GARCIA 20545 UNITED STATES REPRESENTATIVE, 42nd District 8758 0700001A 70 191 261
17522 17522 YES 20683 STATE MEASURE 27 8824 0700001A 31 54 85
17523 17523 NO 20684 STATE MEASURE 27 8824 0700001A 81 172 253
25643 25643 YES 20681 STATE MEASURE 26 8823 0700001A 46 84 130
25644 25644 NO 20682 STATE MEASURE 26 8823 0700001A 69 137 206
32577 32577 YES 20897 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 0700001A 64 157 221
32578 32578 NO 20898 For Associate Justice, Court of Appeal, Second District, Division Five - LAMAR W. BAKER 8888 0700001A 26 39 65
38641 38641 RENEE YOLANDE CHANG 20580 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 0700001A 33 74 107
38642 38642 HOLLY L. HANCOCK 20579 JUDGE OF THE SUPERIOR COURT Office No. 70 8776 0700001A 64 138 202
45014 45014 YES 20875 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 0700001A 62 146 208
45015 45015 NO 20876 For Associate Justice of the Supreme Court - JOSHUA P. GROBAN 8881 0700001A 31 50 81
51134 51134 YES 20894 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 0700001A 66 152 218
51135 51135 NO 20895 For Presiding Justice, Court of Appeal, Second District, Division Five - LAURENCE D. RUBIN 8887 0700001A 27 42 69
57260 57260 YES 20888 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 0700001A 62 153 215
57261 57261 NO 20889 For Associate Justice, Court of Appeal, Second District, Division Four - AUDREY B. COLLINS 8885 0700001A 28 41 69
64189 64189 ANGELA E. UNDERWOOD JACOBS 20555 LIEUTENANT GOVERNOR 8763 0700001A 48 43 91
64190 64190 ELENI KOUNALAKIS 20556 LIEUTENANT GOVERNOR 8763 0700001A 64 187 251
70169 70169 FIONA MA 20562 TREASURER 8766 0700001A 58 180 238
70170 70170 JACK M. GUERRERO 20561 TREASURER 8766 0700001A 54 49 103
76149 76149 ROBERT HOWELL 20565 INSURANCE COMMISSIONER 8768 0700001A 43 35 78
76150 76150 RICARDO LARA 20566 INSURANCE COMMISSIONER 8768 0700001A 68 197 265
82251 82251 GABRIEL BUELNA 20672 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 6 8517 0700001A 67 163 230
82252 82252 ROBERT L. PAYNE 20756 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 6 8517 0700001A 36 47 83
86181 86181 ALEX PADILLA 20460 UNITED STATES SENATOR - Full Term 8712 0700001A 69 210 279
86182 86182 MARK P. MEUSER 20461 UNITED STATES SENATOR - Full Term 8712 0700001A 45 26 71
92341 92341 FERNANDA MARIA BARRETO 20578 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 0700001A 55 126 181
92342 92342 ELIZABETH LASHLEY-HAYNES 20577 JUDGE OF THE SUPERIOR COURT Office No. 67 8775 0700001A 43 89 132
98148 98148 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 0700001A 37 108 145
98149 98149 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 0700001A 14 20 34
98150 98150 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 0700001A 48 78 126
103814 103814 YES 20688 STATE MEASURE 29 8826 0700001A 50 99 149
103815 103815 NO 20689 STATE MEASURE 29 8826 0700001A 63 133 196
111035 111035 YES 21263 COUNTY MEASURE C 8943 0700001A 64 150 214
111036 111036 NO 21264 COUNTY MEASURE C 8943 0700001A 43 69 112
117031 117031 YES 20686 STATE MEASURE 28 8825 0700001A 80 180 260
117032 117032 NO 20687 STATE MEASURE 28 8825 0700001A 35 54 89
124389 124389 TONY VAZQUEZ 20567 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 0700001A 62 171 233
124390 124390 Y. MARIE MANVEL 20568 MEMBER STATE BOARD OF EQUALIZATION 3rd District 8769 0700001A 45 56 101
130459 130459 YES 20690 STATE MEASURE 30 8827 0700001A 53 117 170
130460 130460 NO 20691 STATE MEASURE 30 8827 0700001A 62 112 174
136655 136655 ABBY BARON 20576 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 0700001A 49 119 168
136656 136656 ANNA SLOTKY REITANO 20575 JUDGE OF THE SUPERIOR COURT Office No. 60 8774 0700001A 49 96 145
143087 143087 YES 20679 STATE MEASURE 1 8822 0700001A 68 180 248
143088 143088 NO 20680 STATE MEASURE 1 8822 0700001A 46 54 100
149437 149437 ALEX PADILLA 20587 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 0700001A 66 204 270
149438 149438 MARK P. MEUSER 20588 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2023) 8780 0700001A 47 29 76
155943 155943 YES 21778 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 0700001A 65 158 223
155944 155944 NO 21779 For Associate Justice, Court of Appeal, Second District, Division Eight - ELIZABETH ANNETTE GRIMES 8975 0700001A 25 35 60
161885 161885 BLANCA PACHECO 20510 MEMBER OF THE STATE ASSEMBLY, 64th District 8740 0700001A 72 194 266
161886 161886 RAUL ORTIZ, JR. 20509 MEMBER OF THE STATE ASSEMBLY, 64th District 8740 0700001A 41 34 75
164552 164552 YES 20885 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 0700001A 61 139 200
164553 164553 NO 20886 For Associate Justice, Court of Appeal, Second District, Division Three - LUIS A. LAVIN 8884 0700001A 31 54 85
174156 174156 BRIAN DAHLE 20554 GOVERNOR 8762 0700001A 47 40 87
174157 174157 GAVIN NEWSOM 20553 GOVERNOR 8762 0700001A 66 197 263
180640 180640 MALIA M. COHEN 20560 CONTROLLER 8765 0700001A 62 183 245
180641 180641 LANHEE J. CHEN 20559 CONTROLLER 8765 0700001A 48 49 97
187866 187866 YES 21200 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE LA 8934 0700001A 79 141 220
187867 187867 NO 21201 LOS ANGELES COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE LA 8934 0700001A 31 73 104
192414 192414 ROB BONTA 20564 ATTORNEY GENERAL 8767 0700001A 69 191 260
192415 192415 NATHAN HOCHMAN 20563 ATTORNEY GENERAL 8767 0700001A 43 39 82
198394 198394 YES 20692 STATE MEASURE 31 8828 0700001A 76 176 252
198395 198395 NO 20693 STATE MEASURE 31 8828 0700001A 36 59 95
204730 204730 YES 21153 COUNTY MEASURE A 8930 0700001A 84 176 260
204731 204731 NO 21154 COUNTY MEASURE A 8930 0700001A 28 56 84
210710 210710 CAROLYN "JIYOUNG" PARK 20583 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 0700001A 39 79 118
210711 210711 MELISSA HAMMOND 20584 JUDGE OF THE SUPERIOR COURT Office No. 118 8778 0700001A 59 136 195
219262 219262 ROB BERNOSKY 20557 SECRETARY OF STATE 8764 0700001A 44 42 86
219263 219263 SHIRLEY N. WEBER 20558 SECRETARY OF STATE 8764 0700001A 69 191 260
225480 225480 YES 20863 For Chief Justice of California - PATRICIA GUERRERO 8877 0700001A 74 177 251
225481 225481 NO 20864 For Chief Justice of California - PATRICIA GUERRERO 8877 0700001A 29 29 58
231836 231836 ALEX VILLANUEVA 20574 SHERIFF 8772 0700001A 53 101 154
231837 231837 ROBERT LUNA 20573 SHERIFF 8772 0700001A 56 122 178
238092 238092 YES 21775 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 0700001A 65 147 212
238093 238093 NO 21776 For Presiding Justice, Court of Appeal, Second District, Division Eight - MARIA E. STRATTON 8974 0700001A 28 51 79
247817 247817 YES 21299 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 0700001A 63 160 223
247818 247818 NO 21300 For Associate Justice, Court of Appeal, Second District, Division Six - HERNALDO J. BALTODANO 8947 0700001A 24 33 57
253915 253915 ERNEST H. MORENO 21011 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 4 8516 0700001A 31 78 109
253916 253916 SARA HERNANDEZ 20788 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 4 8516 0700001A 55 108 163
253917 253917 CHRISTINE T. LAMONICA 20699 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 4 8516 0700001A 17 28 45
258561 258561 LANCE RAY CHRISTENSEN 20569 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 0700001A 40 50 90
258562 258562 TONY K. THURMOND 20570 SUPERINTENDENT OF PUBLIC INSTRUCTION 8770 0700001A 57 164 221
264541 264541 YES 20866 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0700001A 66 144 210
264542 264542 NO 20867 For Associate Justice of the Supreme Court - GOODWIN LIU 8878 0700001A 34 60 94
270521 270521 YES 20900 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 0700001A 61 139 200
270522 270522 NO 20901 For Associate Justice, Court of Appeal, Second District, Division Seven - JOHN L. SEGAL 8889 0700001A 28 52 80
276525 276525 YES 21781 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 0700001A 61 140 201
276526 276526 NO 21782 For Associate Justice, Court of Appeal, Second District, Division Eight - JOHN SHEPARD WILEY JR. 8976 0700001A 28 52 80
282906 282906 SERGIO JOSEPH CALDERON 21041 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 4 8425 0700001A 61 131 192
282907 282907 JOSE R. GONZALEZ 21023 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 4 8425 0700001A 37 72 109
284143 284143 MELISSA LYONS 20582 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 0700001A 33 76 109
284144 284144 LESLIE GUTIERREZ 20581 JUDGE OF THE SUPERIOR COURT Office No. 90 8777 0700001A 70 134 204
290161 290161 YES 20869 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 0700001A 66 154 220
290162 290162 NO 20870 For Associate Justice of the Supreme Court - MARTIN J. JENKINS 8879 0700001A 28 47 75
297737 297737 YES 20879 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 0700001A 67 143 210
297738 297738 NO 20880 For Presiding Justice, Court of Appeal, Second District, Division One - FRANCES ROTHSCHILD 8882 0700001A 30 53 83
304282 304282 ARTURO CHACON 20592 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8403 0700001A 63 156 219
304283 304283 LEONARD MENDOZA 21317 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 3 8403 0700001A 31 46 77

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