results

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

61 rows where precinct_id = "1770070A"

✎ 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
14025 14025 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 1770070A 2 3 5
14026 14026 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 1770070A 1 7 8
20703 20703 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1770070A 3 2 5
20704 20704 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1770070A 0 0 0
20705 20705 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1770070A 0 8 8
20706 20706 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1770070A 0 0 0
20707 20707 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1770070A 0 0 0
20708 20708 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1770070A 0 0 0
51451 51451 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1770070A 3 2 5
51452 51452 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1770070A 0 8 8
59477 59477 YES 23601 STATE MEASURE 36 9874 1770070A 2 5 7
59478 59478 NO 23602 STATE MEASURE 36 9874 1770070A 1 5 6
68186 68186 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1770070A 1 0 1
68187 68187 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1770070A 2 8 10
76494 76494 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1770070A 2 4 6
76495 76495 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1770070A 1 6 7
85739 85739 ABDALLAH S. FARRUKH 23783 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770070A 1 2 3
85740 85740 STEVEN HOFBAUER 23645 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770070A 2 3 5
85741 85741 KRISTINA S. HONG 23743 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770070A 1 7 8
85742 85742 JAWAD BERMANI 23675 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770070A 0 3 3
85743 85743 MATEO B. OLIVAREZ 23791 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770070A 3 7 10
88048 88048 YES 23584 STATE MEASURE 3 9867 1770070A 0 6 6
88049 88049 NO 23585 STATE MEASURE 3 9867 1770070A 2 4 6
96170 96170 PAUL ANDRE MARSH 23404 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 1770070A 2 2 4
96171 96171 JUAN CARRILLO VENTURA 23403 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 1770070A 1 8 9
98622 98622 YES 23593 STATE MEASURE 33 9871 1770070A 2 8 10
98623 98623 NO 23594 STATE MEASURE 33 9871 1770070A 1 2 3
107108 107108 YES 23599 STATE MEASURE 35 9873 1770070A 3 7 10
107109 107109 NO 23600 STATE MEASURE 35 9873 1770070A 0 2 2
115744 115744 YES 23766 COUNTY MEASURE A 9880 1770070A 2 8 10
115745 115745 NO 23767 COUNTY MEASURE A 9880 1770070A 0 2 2
123824 123824 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1770070A 3 8 11
123825 123825 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1770070A 0 0 0
130754 130754 YES 23912 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 1770070A 2 9 11
130755 130755 NO 23913 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 1770070A 1 0 1
132236 132236 YES 23597 STATE MEASURE 34 9872 1770070A 2 4 6
132237 132237 NO 23598 STATE MEASURE 34 9872 1770070A 1 4 5
142458 142458 YES 23591 STATE MEASURE 32 9870 1770070A 2 9 11
142459 142459 NO 23592 STATE MEASURE 32 9870 1770070A 1 0 1
151360 151360 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1770070A 0 7 7
151361 151361 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1770070A 3 1 4
165820 165820 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1770070A 3 2 5
165821 165821 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1770070A 0 8 8
173920 173920 YES 23712 STATE MEASURE 2 9878 1770070A 2 8 10
173921 173921 NO 23713 STATE MEASURE 2 9878 1770070A 0 1 1
182628 182628 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1770070A 1 8 9
182629 182629 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1770070A 2 0 2
193286 193286 YES 23714 STATE MEASURE 4 9879 1770070A 2 8 10
193287 193287 NO 23715 STATE MEASURE 4 9879 1770070A 0 2 2
203162 203162 YES 23589 STATE MEASURE 6 9869 1770070A 1 7 8
203163 203163 NO 23590 STATE MEASURE 6 9869 1770070A 2 2 4
211138 211138 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1770070A 2 6 8
211139 211139 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1770070A 1 2 3
219134 219134 YES 23587 STATE MEASURE 5 9868 1770070A 2 7 9
219135 219135 NO 23588 STATE MEASURE 5 9868 1770070A 0 2 2
227463 227463 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1770070A 3 5 8
227464 227464 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1770070A 0 4 4
234842 234842 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 1770070A 3 2 5
234843 234843 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 1770070A 0 8 8
258364 258364 YES 24240 COUNTY MEASURE G 9961 1770070A 2 3 5
258365 258365 NO 24241 COUNTY MEASURE G 9961 1770070A 0 5 5

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