results

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

54 rows where precinct_id = "7700042A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contest_id, polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
30351 30351 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 7700042A 1 0 1
30352 30352 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 7700042A 0 0 0
30353 30353 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 7700042A 0 1 1
30354 30354 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 7700042A 0 0 0
30355 30355 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 7700042A 0 0 0
30356 30356 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 7700042A 0 0 0
54667 54667 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 7700042A 1 0 1
54668 54668 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 7700042A 0 1 1
62693 62693 YES 23601 STATE MEASURE 36 9874 7700042A 1 1 2
62694 62694 NO 23602 STATE MEASURE 36 9874 7700042A 0 0 0
71402 71402 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7700042A 1 0 1
71403 71403 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7700042A 0 1 1
79710 79710 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 7700042A 1 1 2
79711 79711 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 7700042A 0 0 0
91264 91264 YES 23584 STATE MEASURE 3 9867 7700042A 0 1 1
91265 91265 NO 23585 STATE MEASURE 3 9867 7700042A 1 0 1
95556 95556 YES 24127 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 7700042A 0 0 0
95557 95557 NO 24128 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 7700042A 1 1 2
101838 101838 YES 23593 STATE MEASURE 33 9871 7700042A 1 1 2
101839 101839 NO 23594 STATE MEASURE 33 9871 7700042A 0 0 0
110324 110324 YES 23599 STATE MEASURE 35 9873 7700042A 1 1 2
110325 110325 NO 23600 STATE MEASURE 35 9873 7700042A 0 0 0
118960 118960 YES 23766 COUNTY MEASURE A 9880 7700042A 0 1 1
118961 118961 NO 23767 COUNTY MEASURE A 9880 7700042A 1 0 1
127040 127040 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7700042A 1 0 1
127041 127041 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7700042A 0 1 1
135452 135452 YES 23597 STATE MEASURE 34 9872 7700042A 1 0 1
135453 135453 NO 23598 STATE MEASURE 34 9872 7700042A 0 1 1
140848 140848 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 7700042A 1 0 1
140849 140849 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 7700042A 0 1 1
145674 145674 YES 23591 STATE MEASURE 32 9870 7700042A 0 0 0
145675 145675 NO 23592 STATE MEASURE 32 9870 7700042A 1 1 2
154576 154576 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7700042A 0 1 1
154577 154577 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7700042A 1 0 1
163114 163114 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 7700042A 1 0 1
163115 163115 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 7700042A 0 1 1
169036 169036 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7700042A 1 0 1
169037 169037 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7700042A 0 1 1
177136 177136 YES 23712 STATE MEASURE 2 9878 7700042A 0 1 1
177137 177137 NO 23713 STATE MEASURE 2 9878 7700042A 1 0 1
185844 185844 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7700042A 0 1 1
185845 185845 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7700042A 1 0 1
190196 190196 BRIAN GUTIERREZ 24234 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 9755 7700042A 0 0 0
190197 190197 BRIAN CALDERÓN TABATABAI 24229 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 9755 7700042A 1 1 2
196502 196502 YES 23714 STATE MEASURE 4 9879 7700042A 0 1 1
196503 196503 NO 23715 STATE MEASURE 4 9879 7700042A 1 0 1
206378 206378 YES 23589 STATE MEASURE 6 9869 7700042A 0 1 1
206379 206379 NO 23590 STATE MEASURE 6 9869 7700042A 1 0 1
214354 214354 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7700042A 0 0 0
214355 214355 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7700042A 1 1 2
222350 222350 YES 23587 STATE MEASURE 5 9868 7700042A 0 0 0
222351 222351 NO 23588 STATE MEASURE 5 9868 7700042A 1 1 2
261580 261580 YES 24240 COUNTY MEASURE G 9961 7700042A 1 1 2
261581 261581 NO 24241 COUNTY MEASURE G 9961 7700042A 0 0 0

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