results

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

56 rows where precinct_id = "7700067A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contest_id, polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
30387 30387 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 7700067A 23 28 51
30388 30388 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 7700067A 0 1 1
30389 30389 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 7700067A 23 52 75
30390 30390 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 7700067A 1 1 2
30391 30391 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 7700067A 0 0 0
30392 30392 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 7700067A 0 0 0
42675 42675 SUE L. MAULUCCI 23770 COVINA-VALLEY UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9573 7700067A 11 29 40
42676 42676 STEVE BENNETT 23901 COVINA-VALLEY UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9573 7700067A 19 38 57
54679 54679 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 7700067A 21 18 39
54680 54680 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 7700067A 24 59 83
62705 62705 YES 23601 STATE MEASURE 36 9874 7700067A 26 57 83
62706 62706 NO 23602 STATE MEASURE 36 9874 7700067A 14 18 32
71414 71414 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7700067A 17 35 52
71415 71415 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7700067A 14 37 51
79722 79722 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 7700067A 23 38 61
79723 79723 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 7700067A 12 32 44
91276 91276 YES 23584 STATE MEASURE 3 9867 7700067A 17 45 62
91277 91277 NO 23585 STATE MEASURE 3 9867 7700067A 23 29 52
95568 95568 YES 24127 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 7700067A 30 61 91
95569 95569 NO 24128 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 7700067A 9 11 20
101850 101850 YES 23593 STATE MEASURE 33 9871 7700067A 23 47 70
101851 101851 NO 23594 STATE MEASURE 33 9871 7700067A 17 26 43
110336 110336 YES 23599 STATE MEASURE 35 9873 7700067A 30 65 95
110337 110337 NO 23600 STATE MEASURE 35 9873 7700067A 8 10 18
118972 118972 YES 23766 COUNTY MEASURE A 9880 7700067A 27 53 80
118973 118973 NO 23767 COUNTY MEASURE A 9880 7700067A 11 20 31
127052 127052 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7700067A 17 44 61
127053 127053 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7700067A 12 24 36
135464 135464 YES 23597 STATE MEASURE 34 9872 7700067A 20 31 51
135465 135465 NO 23598 STATE MEASURE 34 9872 7700067A 14 42 56
140860 140860 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 7700067A 23 21 44
140861 140861 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 7700067A 18 51 69
145686 145686 YES 23591 STATE MEASURE 32 9870 7700067A 26 49 75
145687 145687 NO 23592 STATE MEASURE 32 9870 7700067A 14 27 41
154588 154588 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7700067A 19 46 65
154589 154589 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7700067A 13 26 39
163126 163126 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 7700067A 19 18 37
163127 163127 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 7700067A 21 55 76
169048 169048 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7700067A 21 20 41
169049 169049 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7700067A 23 57 80
177148 177148 YES 23712 STATE MEASURE 2 9878 7700067A 31 62 93
177149 177149 NO 23713 STATE MEASURE 2 9878 7700067A 11 13 24
185856 185856 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7700067A 21 53 74
185857 185857 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7700067A 8 18 26
190204 190204 BRIAN GUTIERREZ 24234 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 9755 7700067A 19 25 44
190205 190205 BRIAN CALDERÓN TABATABAI 24229 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 9755 7700067A 18 44 62
196514 196514 YES 23714 STATE MEASURE 4 9879 7700067A 29 53 82
196515 196515 NO 23715 STATE MEASURE 4 9879 7700067A 10 23 33
206390 206390 YES 23589 STATE MEASURE 6 9869 7700067A 26 46 72
206391 206391 NO 23590 STATE MEASURE 6 9869 7700067A 10 28 38
214366 214366 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7700067A 18 44 62
214367 214367 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7700067A 12 26 38
222362 222362 YES 23587 STATE MEASURE 5 9868 7700067A 25 39 64
222363 222363 NO 23588 STATE MEASURE 5 9868 7700067A 12 34 46
261592 261592 YES 24240 COUNTY MEASURE G 9961 7700067A 19 44 63
261593 261593 NO 24241 COUNTY MEASURE G 9961 7700067A 18 29 47

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