results

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

78 rows where precinct_id = "9004127A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
4806 4806 YES 24221 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ER 9954 9004127A 53 178 231
4807 4807 NO 24222 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ER 9954 9004127A 13 22 35
9519 9519 NANCY PEARLMAN 23533 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9004127A 19 72 91
9520 9520 DAVID VELA 23624 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9004127A 28 111 139
9521 9521 LOUIS ANTHONY SHAPIRO 23836 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9004127A 13 12 25
11527 11527 KEVIN DE LEÓN 23376 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 14th District 9493 9004127A 18 32 50
11528 11528 YSABEL J. JURADO 23375 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 14th District 9493 9004127A 50 179 229
35115 35115 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 9004127A 13 14 27
35116 35116 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 9004127A 1 3 4
35117 35117 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 9004127A 56 209 265
35118 35118 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 9004127A 0 1 1
35119 35119 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 9004127A 0 0 0
35120 35120 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 9004127A 0 8 8
47168 47168 NICHELLE M. HENDERSON 23705 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9004127A 34 156 190
47169 47169 ELAINE ALANIZ 23811 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9004127A 9 16 25
47170 47170 JASON R. AULA 24020 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9004127A 10 19 29
49853 49853 YES 24215 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE DD 9951 9004127A 48 193 241
49854 49854 NO 24216 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE DD 9951 9004127A 16 16 32
56255 56255 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 9004127A 12 19 31
56256 56256 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 9004127A 58 207 265
64281 64281 YES 23601 STATE MEASURE 36 9874 9004127A 24 64 88
64282 64282 NO 23602 STATE MEASURE 36 9874 9004127A 43 156 199
72990 72990 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 9004127A 18 26 44
72991 72991 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 9004127A 37 171 208
75310 75310 JIMMY GOMEZ 23464 UNITED STATES REPRESENTATIVE, 34th District 9538 9004127A 30 93 123
75311 75311 DAVID KIM 23465 UNITED STATES REPRESENTATIVE, 34th District 9538 9004127A 34 110 144
81298 81298 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 9004127A 23 65 88
81299 81299 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 9004127A 42 144 186
84940 84940 YES 24219 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE II 9953 9004127A 52 185 237
84941 84941 NO 24220 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE II 9953 9004127A 12 13 25
92852 92852 YES 23584 STATE MEASURE 3 9867 9004127A 60 211 271
92853 92853 NO 23585 STATE MEASURE 3 9867 9004127A 9 14 23
103426 103426 YES 23593 STATE MEASURE 33 9871 9004127A 48 168 216
103427 103427 NO 23594 STATE MEASURE 33 9871 9004127A 19 59 78
111912 111912 YES 23599 STATE MEASURE 35 9873 9004127A 44 134 178
111913 111913 NO 23600 STATE MEASURE 35 9873 9004127A 21 84 105
120548 120548 YES 23766 COUNTY MEASURE A 9880 9004127A 60 190 250
120549 120549 NO 23767 COUNTY MEASURE A 9880 9004127A 9 31 40
128628 128628 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 9004127A 28 66 94
128629 128629 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 9004127A 25 117 142
137040 137040 YES 23597 STATE MEASURE 34 9872 9004127A 26 47 73
137041 137041 NO 23598 STATE MEASURE 34 9872 9004127A 39 162 201
147262 147262 YES 23591 STATE MEASURE 32 9870 9004127A 57 181 238
147263 147263 NO 23592 STATE MEASURE 32 9870 9004127A 12 42 54
156164 156164 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 9004127A 44 149 193
156165 156165 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 9004127A 15 54 69
160690 160690 YES 24232 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 9004127A 49 190 239
160691 160691 NO 24233 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 9004127A 14 18 32
162638 162638 MARK GONZALEZ 23427 MEMBER OF THE STATE ASSEMBLY, 54th District 9519 9004127A 31 95 126
162639 162639 JOHN K. YI 23428 MEMBER OF THE STATE ASSEMBLY, 54th District 9519 9004127A 33 102 135
170624 170624 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 9004127A 14 20 34
170625 170625 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 9004127A 56 210 266
178724 178724 YES 23712 STATE MEASURE 2 9878 9004127A 54 190 244
178725 178725 NO 23713 STATE MEASURE 2 9878 9004127A 14 31 45
187432 187432 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 9004127A 40 122 162
187433 187433 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 9004127A 15 71 86
191630 191630 YES 24223 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE FF 9955 9004127A 35 119 154
191631 191631 NO 24224 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE FF 9955 9004127A 28 86 114
198090 198090 YES 23714 STATE MEASURE 4 9879 9004127A 58 204 262
198091 198091 NO 23715 STATE MEASURE 4 9879 9004127A 8 20 28
207966 207966 YES 23589 STATE MEASURE 6 9869 9004127A 49 183 232
207967 207967 NO 23590 STATE MEASURE 6 9869 9004127A 18 38 56
215942 215942 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 9004127A 27 106 133
215943 215943 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 9004127A 26 90 116
223938 223938 YES 23587 STATE MEASURE 5 9868 9004127A 56 187 243
223939 223939 NO 23588 STATE MEASURE 5 9868 9004127A 12 37 49
232930 232930 YES 24217 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE HH 9952 9004127A 54 192 246
232931 232931 NO 24218 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE HH 9952 9004127A 9 11 20
240595 240595 KELSEY IINO 23603 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 9004127A 38 154 192
240596 240596 ROBERT PAYNE 23554 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 9004127A 17 39 56
246577 246577 BALTAZAR FEDALIZO 23870 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9004127A 5 10 15
246578 246578 ANDRA HOFFMAN 23559 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9004127A 34 128 162
246579 246579 PETER V. MANGHERA 23969 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9004127A 12 34 46
246580 246580 CHEYENNE SIMS 24038 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9004127A 6 24 30
249977 249977 YES 24230 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 9004127A 54 180 234
249978 249978 NO 24231 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 9004127A 10 27 37
263168 263168 YES 24240 COUNTY MEASURE G 9961 9004127A 50 145 195
263169 263169 NO 24241 COUNTY MEASURE G 9961 9004127A 18 65 83

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