results

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

63 rows where precinct_id = "1040005A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contest_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
13879 13879 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 1040005A 48 39 87
13880 13880 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 1040005A 7 30 37
19299 19299 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1040005A 46 38 84
19300 19300 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1040005A 0 0 0
19301 19301 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1040005A 7 35 42
19302 19302 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1040005A 2 1 3
19303 19303 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1040005A 0 0 0
19304 19304 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1040005A 0 0 0
50983 50983 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1040005A 48 36 84
50984 50984 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1040005A 6 29 35
59009 59009 YES 23601 STATE MEASURE 36 9874 1040005A 35 50 85
59010 59010 NO 23602 STATE MEASURE 36 9874 1040005A 11 18 29
67718 67718 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1040005A 18 20 38
67719 67719 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1040005A 11 28 39
76026 76026 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1040005A 39 50 89
76027 76027 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1040005A 4 13 17
87580 87580 YES 23584 STATE MEASURE 3 9867 1040005A 16 37 53
87581 87581 NO 23585 STATE MEASURE 3 9867 1040005A 30 29 59
98154 98154 YES 23593 STATE MEASURE 33 9871 1040005A 15 30 45
98155 98155 NO 23594 STATE MEASURE 33 9871 1040005A 30 37 67
106640 106640 YES 23599 STATE MEASURE 35 9873 1040005A 20 43 63
106641 106641 NO 23600 STATE MEASURE 35 9873 1040005A 24 25 49
115276 115276 YES 23766 COUNTY MEASURE A 9880 1040005A 10 36 46
115277 115277 NO 23767 COUNTY MEASURE A 9880 1040005A 35 28 63
123356 123356 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1040005A 14 20 34
123357 123357 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1040005A 15 28 43
131768 131768 YES 23597 STATE MEASURE 34 9872 1040005A 22 26 48
131769 131769 NO 23598 STATE MEASURE 34 9872 1040005A 19 36 55
141990 141990 YES 23591 STATE MEASURE 32 9870 1040005A 9 30 39
141991 141991 NO 23592 STATE MEASURE 32 9870 1040005A 40 38 78
150892 150892 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1040005A 14 30 44
150893 150893 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1040005A 19 19 38
158224 158224 STACY FORTNER 23804 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Two-Year Term 9864 1040005A 9 27 36
158225 158225 KENNETH "KEN" PETERSEN 23744 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Two-Year Term 9864 1040005A 23 30 53
158680 158680 DARLENE TREVINO 23954 SANTA CLARITA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION Member of the Board of Trustees, Trustee Area 1 (Unexpired term ending December 11, 2026) 9863 1040005A 24 33 57
158681 158681 MICHELLE KAMPBELL 23765 SANTA CLARITA COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION Member of the Board of Trustees, Trustee Area 1 (Unexpired term ending December 11, 2026) 9863 1040005A 9 20 29
165352 165352 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1040005A 49 37 86
165353 165353 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1040005A 5 31 36
173452 173452 YES 23712 STATE MEASURE 2 9878 1040005A 16 29 45
173453 173453 NO 23713 STATE MEASURE 2 9878 1040005A 29 37 66
180830 180830 PATRICK LEE GIPSON 23405 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 1040005A 47 35 82
180831 180831 PILAR SCHIAVO 23406 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 1040005A 5 30 35
182160 182160 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1040005A 13 29 42
182161 182161 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1040005A 16 18 34
192818 192818 YES 23714 STATE MEASURE 4 9879 1040005A 16 34 50
192819 192819 NO 23715 STATE MEASURE 4 9879 1040005A 28 30 58
202694 202694 YES 23589 STATE MEASURE 6 9869 1040005A 5 30 35
202695 202695 NO 23590 STATE MEASURE 6 9869 1040005A 38 36 74
210670 210670 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1040005A 11 14 25
210671 210671 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1040005A 18 35 53
218666 218666 YES 23587 STATE MEASURE 5 9868 1040005A 11 32 43
218667 218667 NO 23588 STATE MEASURE 5 9868 1040005A 33 32 65
227149 227149 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1040005A 21 32 53
227150 227150 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1040005A 24 31 55
234696 234696 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 1040005A 44 34 78
234697 234697 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 1040005A 8 31 39
251384 251384 KATHYE ARMITAGE 23653 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Full Term 9803 1040005A 20 28 48
251385 251385 HOLLY SCHROEDER 23734 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Full Term 9803 1040005A 14 27 41
256713 256713 GLORIA MERCADO-FORTINE 24010 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9658 1040005A 15 17 32
256714 256714 AAKASH AHUJA 23810 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9658 1040005A 10 15 25
256715 256715 LINDA HOVIS STORLI 23694 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9658 1040005A 12 25 37
257896 257896 YES 24240 COUNTY MEASURE G 9961 1040005A 10 28 38
257897 257897 NO 24241 COUNTY MEASURE G 9961 1040005A 33 35 68

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