results

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

64 rows where precinct_id = "3700042D"

✎ 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
14115 14115 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 3700042D 25 52 77
14116 14116 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 3700042D 6 21 27
24255 24255 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 3700042D 24 51 75
24256 24256 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 3700042D 1 0 1
24257 24257 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 3700042D 6 25 31
24258 24258 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 3700042D 1 0 1
24259 24259 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 3700042D 0 0 0
24260 24260 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 3700042D 0 0 0
52635 52635 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 3700042D 23 54 77
52636 52636 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 3700042D 7 18 25
60661 60661 YES 23601 STATE MEASURE 36 9874 3700042D 27 57 84
60662 60662 NO 23602 STATE MEASURE 36 9874 3700042D 3 11 14
69370 69370 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3700042D 19 23 42
69371 69371 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3700042D 7 26 33
77678 77678 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 3700042D 24 59 83
77679 77679 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 3700042D 5 12 17
85964 85964 ABDALLAH S. FARRUKH 23783 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700042D 16 38 54
85965 85965 STEVEN HOFBAUER 23645 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700042D 12 25 37
85966 85966 KRISTINA S. HONG 23743 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700042D 16 32 48
85967 85967 JAWAD BERMANI 23675 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700042D 3 5 8
85968 85968 MATEO B. OLIVAREZ 23791 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700042D 14 16 30
89232 89232 YES 23584 STATE MEASURE 3 9867 3700042D 7 34 41
89233 89233 NO 23585 STATE MEASURE 3 9867 3700042D 23 39 62
96224 96224 PAUL ANDRE MARSH 23404 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 3700042D 22 50 72
96225 96225 JUAN CARRILLO VENTURA 23403 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 3700042D 8 24 32
99806 99806 YES 23593 STATE MEASURE 33 9871 3700042D 8 14 22
99807 99807 NO 23594 STATE MEASURE 33 9871 3700042D 21 57 78
108292 108292 YES 23599 STATE MEASURE 35 9873 3700042D 13 37 50
108293 108293 NO 23600 STATE MEASURE 35 9873 3700042D 16 32 48
116928 116928 YES 23766 COUNTY MEASURE A 9880 3700042D 9 31 40
116929 116929 NO 23767 COUNTY MEASURE A 9880 3700042D 20 38 58
125008 125008 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3700042D 16 21 37
125009 125009 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3700042D 6 30 36
130846 130846 YES 23912 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 3700042D 16 42 58
130847 130847 NO 23913 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 3700042D 12 29 41
133420 133420 YES 23597 STATE MEASURE 34 9872 3700042D 9 33 42
133421 133421 NO 23598 STATE MEASURE 34 9872 3700042D 20 37 57
143642 143642 YES 23591 STATE MEASURE 32 9870 3700042D 7 23 30
143643 143643 NO 23592 STATE MEASURE 32 9870 3700042D 23 50 73
152544 152544 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3700042D 11 31 42
152545 152545 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3700042D 15 22 37
167004 167004 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3700042D 22 53 75
167005 167005 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3700042D 7 20 27
175104 175104 YES 23712 STATE MEASURE 2 9878 3700042D 12 29 41
175105 175105 NO 23713 STATE MEASURE 2 9878 3700042D 17 39 56
183812 183812 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3700042D 11 27 38
183813 183813 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3700042D 13 26 39
194470 194470 YES 23714 STATE MEASURE 4 9879 3700042D 14 29 43
194471 194471 NO 23715 STATE MEASURE 4 9879 3700042D 16 42 58
204346 204346 YES 23589 STATE MEASURE 6 9869 3700042D 7 21 28
204347 204347 NO 23590 STATE MEASURE 6 9869 3700042D 21 50 71
212322 212322 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3700042D 7 17 24
212323 212323 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3700042D 19 32 51
220318 220318 YES 23587 STATE MEASURE 5 9868 3700042D 10 21 31
220319 220319 NO 23588 STATE MEASURE 5 9868 3700042D 20 50 70
228437 228437 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3700042D 12 27 39
228438 228438 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3700042D 17 38 55
234936 234936 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 3700042D 23 51 74
234937 234937 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 3700042D 7 23 30
237441 237441 MICHELLE DENEEN HARVEY 23841 ANTELOPE VALLEY COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 1 9483 3700042D 10 31 41
237442 237442 RYAN D. BEARDSLEY 23792 ANTELOPE VALLEY COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 1 9483 3700042D 6 10 16
237443 237443 RICK SHAW 23751 ANTELOPE VALLEY COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 1 9483 3700042D 8 17 25
259548 259548 YES 24240 COUNTY MEASURE G 9961 3700042D 9 17 26
259549 259549 NO 24241 COUNTY MEASURE G 9961 3700042D 18 54 72

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