results

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

78 rows where precinct_id = "9002860A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
2018 2018 KAHLLID A. AL-ALIM 23383 LOS ANGELES UNIFIED SCHOOL DISTRICT Member of the Board of Education, District 1 9497 9002860A 32 73 105
2019 2019 SHERLETT HENDY NEWBILL 23384 LOS ANGELES UNIFIED SCHOOL DISTRICT Member of the Board of Education, District 1 9497 9002860A 48 147 195
4614 4614 YES 24221 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ER 9954 9002860A 50 175 225
4615 4615 NO 24222 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ER 9954 9002860A 23 45 68
9231 9231 NANCY PEARLMAN 23533 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9002860A 19 43 62
9232 9232 DAVID VELA 23624 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9002860A 41 149 190
9233 9233 LOUIS ANTHONY SHAPIRO 23836 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9002860A 14 30 44
34539 34539 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 9002860A 33 26 59
34540 34540 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 9002860A 0 0 0
34541 34541 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 9002860A 63 220 283
34542 34542 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 9002860A 0 1 1
34543 34543 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 9002860A 0 0 0
34544 34544 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 9002860A 1 1 2
46880 46880 NICHELLE M. HENDERSON 23705 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9002860A 45 171 216
46881 46881 ELAINE ALANIZ 23811 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9002860A 18 40 58
46882 46882 JASON R. AULA 24020 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9002860A 10 13 23
49661 49661 YES 24215 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE DD 9951 9002860A 42 173 215
49662 49662 NO 24216 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE DD 9951 9002860A 32 53 85
56063 56063 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 9002860A 25 33 58
56064 56064 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 9002860A 66 203 269
64089 64089 YES 23601 STATE MEASURE 36 9874 9002860A 42 129 171
64090 64090 NO 23602 STATE MEASURE 36 9874 9002860A 46 116 162
72798 72798 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 9002860A 28 74 102
72799 72799 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 9002860A 53 153 206
81106 81106 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 9002860A 38 113 151
81107 81107 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 9002860A 48 121 169
84748 84748 YES 24219 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE II 9953 9002860A 51 158 209
84749 84749 NO 24220 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE II 9953 9002860A 24 64 88
92660 92660 YES 23584 STATE MEASURE 3 9867 9002860A 54 172 226
92661 92661 NO 23585 STATE MEASURE 3 9867 9002860A 34 72 106
103234 103234 YES 23593 STATE MEASURE 33 9871 9002860A 43 131 174
103235 103235 NO 23594 STATE MEASURE 33 9871 9002860A 46 112 158
111720 111720 YES 23599 STATE MEASURE 35 9873 9002860A 65 203 268
111721 111721 NO 23600 STATE MEASURE 35 9873 9002860A 21 40 61
120356 120356 YES 23766 COUNTY MEASURE A 9880 9002860A 57 191 248
120357 120357 NO 23767 COUNTY MEASURE A 9880 9002860A 31 55 86
128436 128436 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 9002860A 38 111 149
128437 128437 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 9002860A 45 109 154
136848 136848 YES 23597 STATE MEASURE 34 9872 9002860A 47 97 144
136849 136849 NO 23598 STATE MEASURE 34 9872 9002860A 36 137 173
147070 147070 YES 23591 STATE MEASURE 32 9870 9002860A 55 181 236
147071 147071 NO 23592 STATE MEASURE 32 9870 9002860A 33 64 97
155972 155972 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 9002860A 63 170 233
155973 155973 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 9002860A 20 53 73
160502 160502 YES 24232 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 9002860A 50 179 229
160503 160503 NO 24233 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 9002860A 23 38 61
170432 170432 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 9002860A 24 38 62
170433 170433 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 9002860A 65 201 266
178532 178532 YES 23712 STATE MEASURE 2 9878 9002860A 64 180 244
178533 178533 NO 23713 STATE MEASURE 2 9878 9002860A 24 64 88
187240 187240 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 9002860A 50 139 189
187241 187241 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 9002860A 27 81 108
191438 191438 YES 24223 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE FF 9955 9002860A 51 156 207
191439 191439 NO 24224 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE FF 9955 9002860A 26 66 92
197898 197898 YES 23714 STATE MEASURE 4 9879 9002860A 65 190 255
197899 197899 NO 23715 STATE MEASURE 4 9879 9002860A 22 54 76
207774 207774 YES 23589 STATE MEASURE 6 9869 9002860A 49 158 207
207775 207775 NO 23590 STATE MEASURE 6 9869 9002860A 38 82 120
215750 215750 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 9002860A 43 106 149
215751 215751 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 9002860A 39 115 154
223746 223746 YES 23587 STATE MEASURE 5 9868 9002860A 49 162 211
223747 223747 NO 23588 STATE MEASURE 5 9868 9002860A 38 84 122
232738 232738 YES 24217 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE HH 9952 9002860A 54 183 237
232739 232739 NO 24218 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE HH 9952 9002860A 19 38 57
236440 236440 KEITH G. CASCIO 23429 MEMBER OF THE STATE ASSEMBLY, 55th District 9520 9002860A 24 34 58
236441 236441 ISAAC G. BRYAN 23430 MEMBER OF THE STATE ASSEMBLY, 55th District 9520 9002860A 58 197 255
240403 240403 KELSEY IINO 23603 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 9002860A 55 180 235
240404 240404 ROBERT PAYNE 23554 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 9002860A 16 42 58
241647 241647 JUAN REY 23470 UNITED STATES REPRESENTATIVE, 37th District 9541 9002860A 32 40 72
241648 241648 SYDNEY KAMLAGER-DOVE 23471 UNITED STATES REPRESENTATIVE, 37th District 9541 9002860A 52 191 243
246193 246193 BALTAZAR FEDALIZO 23870 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9002860A 12 22 34
246194 246194 ANDRA HOFFMAN 23559 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9002860A 33 148 181
246195 246195 PETER V. MANGHERA 23969 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9002860A 17 31 48
246196 246196 CHEYENNE SIMS 24038 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9002860A 12 22 34
249789 249789 YES 24230 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 9002860A 66 184 250
249790 249790 NO 24231 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 9002860A 22 49 71
262976 262976 YES 24240 COUNTY MEASURE G 9961 9002860A 45 133 178
262977 262977 NO 24241 COUNTY MEASURE G 9961 9002860A 36 96 132

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