results

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

76 rows where precinct_id = "9000143A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
2761 2761 LAURA FRIEDMAN 23459 UNITED STATES REPRESENTATIVE, 30th District 9535 9000143A 1 0 1
2762 2762 ALEX BALEKIAN 23458 UNITED STATES REPRESENTATIVE, 30th District 9535 9000143A 0 1 1
3484 3484 YES 24221 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ER 9954 9000143A 1 1 2
3485 3485 NO 24222 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ER 9954 9000143A 0 0 0
7548 7548 NANCY PEARLMAN 23533 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9000143A 0 0 0
7549 7549 DAVID VELA 23624 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9000143A 1 1 2
7550 7550 LOUIS ANTHONY SHAPIRO 23836 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9000143A 0 0 0
31149 31149 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 9000143A 0 1 1
31150 31150 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 9000143A 0 0 0
31151 31151 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 9000143A 1 0 1
31152 31152 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 9000143A 0 0 0
31153 31153 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 9000143A 0 0 0
31154 31154 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 9000143A 0 0 0
45197 45197 NICHELLE M. HENDERSON 23705 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9000143A 1 0 1
45198 45198 ELAINE ALANIZ 23811 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9000143A 0 0 0
45199 45199 JASON R. AULA 24020 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9000143A 0 1 1
48531 48531 YES 24215 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE DD 9951 9000143A 0 1 1
48532 48532 NO 24216 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE DD 9951 9000143A 0 0 0
54933 54933 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 9000143A 0 1 1
54934 54934 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 9000143A 1 0 1
62959 62959 YES 23601 STATE MEASURE 36 9874 9000143A 0 1 1
62960 62960 NO 23602 STATE MEASURE 36 9874 9000143A 1 0 1
71668 71668 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 9000143A 0 1 1
71669 71669 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 9000143A 1 0 1
79976 79976 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 9000143A 0 1 1
79977 79977 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 9000143A 1 0 1
83618 83618 YES 24219 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE II 9953 9000143A 1 1 2
83619 83619 NO 24220 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE II 9953 9000143A 0 0 0
91530 91530 YES 23584 STATE MEASURE 3 9867 9000143A 1 0 1
91531 91531 NO 23585 STATE MEASURE 3 9867 9000143A 0 1 1
102104 102104 YES 23593 STATE MEASURE 33 9871 9000143A 1 0 1
102105 102105 NO 23594 STATE MEASURE 33 9871 9000143A 0 1 1
110590 110590 YES 23599 STATE MEASURE 35 9873 9000143A 1 0 1
110591 110591 NO 23600 STATE MEASURE 35 9873 9000143A 0 1 1
119226 119226 YES 23766 COUNTY MEASURE A 9880 9000143A 1 1 2
119227 119227 NO 23767 COUNTY MEASURE A 9880 9000143A 0 0 0
127306 127306 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 9000143A 1 1 2
127307 127307 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 9000143A 0 0 0
135718 135718 YES 23597 STATE MEASURE 34 9872 9000143A 0 1 1
135719 135719 NO 23598 STATE MEASURE 34 9872 9000143A 0 0 0
145940 145940 YES 23591 STATE MEASURE 32 9870 9000143A 1 0 1
145941 145941 NO 23592 STATE MEASURE 32 9870 9000143A 0 1 1
154842 154842 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 9000143A 1 0 1
154843 154843 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 9000143A 0 0 0
159386 159386 YES 24232 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 9000143A 0 1 1
159387 159387 NO 24233 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 9000143A 0 0 0
169302 169302 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 9000143A 0 1 1
169303 169303 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 9000143A 1 0 1
177402 177402 YES 23712 STATE MEASURE 2 9878 9000143A 1 1 2
177403 177403 NO 23713 STATE MEASURE 2 9878 9000143A 0 0 0
186110 186110 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 9000143A 1 0 1
186111 186111 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 9000143A 0 1 1
190308 190308 YES 24223 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE FF 9955 9000143A 1 1 2
190309 190309 NO 24224 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE FF 9955 9000143A 0 0 0
196768 196768 YES 23714 STATE MEASURE 4 9879 9000143A 1 1 2
196769 196769 NO 23715 STATE MEASURE 4 9879 9000143A 0 0 0
206644 206644 YES 23589 STATE MEASURE 6 9869 9000143A 0 0 0
206645 206645 NO 23590 STATE MEASURE 6 9869 9000143A 0 1 1
214620 214620 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 9000143A 1 0 1
214621 214621 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 9000143A 0 1 1
222616 222616 YES 23587 STATE MEASURE 5 9868 9000143A 1 1 2
222617 222617 NO 23588 STATE MEASURE 5 9868 9000143A 0 0 0
226182 226182 STEPHAN HOHIL 23421 MEMBER OF THE STATE ASSEMBLY, 51st District 9516 9000143A 0 1 1
226183 226183 RICK CHAVEZ ZBUR 23422 MEMBER OF THE STATE ASSEMBLY, 51st District 9516 9000143A 1 0 1
231608 231608 YES 24217 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE HH 9952 9000143A 1 0 1
231609 231609 NO 24218 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE HH 9952 9000143A 0 1 1
239281 239281 KELSEY IINO 23603 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 9000143A 1 1 2
239282 239282 ROBERT PAYNE 23554 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 9000143A 0 0 0
243949 243949 BALTAZAR FEDALIZO 23870 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9000143A 0 1 1
243950 243950 ANDRA HOFFMAN 23559 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9000143A 1 0 1
243951 243951 PETER V. MANGHERA 23969 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9000143A 0 0 0
243952 243952 CHEYENNE SIMS 24038 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9000143A 0 0 0
248673 248673 YES 24230 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 9000143A 1 1 2
248674 248674 NO 24231 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 9000143A 0 0 0
261846 261846 YES 24240 COUNTY MEASURE G 9961 9000143A 1 0 1
261847 261847 NO 24241 COUNTY MEASURE G 9961 9000143A 0 1 1

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