results

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

65 rows where precinct_id = "1040035A"

✎ 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
13911 13911 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 1040035A 93 142 235
13912 13912 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 1040035A 24 48 72
19395 19395 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1040035A 95 134 229
19396 19396 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1040035A 0 0 0
19397 19397 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1040035A 26 59 85
19398 19398 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1040035A 2 1 3
19399 19399 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1040035A 0 5 5
19400 19400 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1040035A 0 0 0
51015 51015 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1040035A 94 140 234
51016 51016 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1040035A 20 53 73
59041 59041 YES 23601 STATE MEASURE 36 9874 1040035A 89 153 242
59042 59042 NO 23602 STATE MEASURE 36 9874 1040035A 27 30 57
66891 66891 ERIK L. RICHARDSON 23721 CASTAIC UNION SCHOOL DISTRICT Governing Board Member, Trustee Area A 9766 1040035A 63 97 160
66892 66892 STEVEN S. SANSONE 24000 CASTAIC UNION SCHOOL DISTRICT Governing Board Member, Trustee Area A 9766 1040035A 36 58 94
67750 67750 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1040035A 72 93 165
67751 67751 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1040035A 23 61 84
76058 76058 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1040035A 81 155 236
76059 76059 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1040035A 23 29 52
87612 87612 YES 23584 STATE MEASURE 3 9867 1040035A 33 73 106
87613 87613 NO 23585 STATE MEASURE 3 9867 1040035A 82 112 194
98186 98186 YES 23593 STATE MEASURE 33 9871 1040035A 29 39 68
98187 98187 NO 23594 STATE MEASURE 33 9871 1040035A 85 142 227
106672 106672 YES 23599 STATE MEASURE 35 9873 1040035A 42 82 124
106673 106673 NO 23600 STATE MEASURE 35 9873 1040035A 73 98 171
115308 115308 YES 23766 COUNTY MEASURE A 9880 1040035A 28 55 83
115309 115309 NO 23767 COUNTY MEASURE A 9880 1040035A 83 133 216
123388 123388 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1040035A 31 57 88
123389 123389 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1040035A 59 91 150
131800 131800 YES 23597 STATE MEASURE 34 9872 1040035A 65 91 156
131801 131801 NO 23598 STATE MEASURE 34 9872 1040035A 45 85 130
142022 142022 YES 23591 STATE MEASURE 32 9870 1040035A 25 43 68
142023 142023 NO 23592 STATE MEASURE 32 9870 1040035A 91 142 233
150924 150924 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1040035A 37 69 106
150925 150925 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1040035A 61 88 149
158238 158238 STACY FORTNER 23804 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Two-Year Term 9864 1040035A 33 50 83
158239 158239 KENNETH "KEN" PETERSEN 23744 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Two-Year Term 9864 1040035A 60 112 172
158706 158706 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 1040035A 70 99 169
158707 158707 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 1040035A 21 56 77
165384 165384 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1040035A 97 144 241
165385 165385 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1040035A 19 52 71
173484 173484 YES 23712 STATE MEASURE 2 9878 1040035A 33 54 87
173485 173485 NO 23713 STATE MEASURE 2 9878 1040035A 79 127 206
180848 180848 PATRICK LEE GIPSON 23405 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 1040035A 87 137 224
180849 180849 PILAR SCHIAVO 23406 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 1040035A 23 50 73
182192 182192 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1040035A 38 64 102
182193 182193 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1040035A 52 87 139
192850 192850 YES 23714 STATE MEASURE 4 9879 1040035A 33 62 95
192851 192851 NO 23715 STATE MEASURE 4 9879 1040035A 83 123 206
202726 202726 YES 23589 STATE MEASURE 6 9869 1040035A 34 58 92
202727 202727 NO 23590 STATE MEASURE 6 9869 1040035A 78 126 204
210702 210702 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1040035A 20 34 54
210703 210703 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1040035A 72 116 188
218698 218698 YES 23587 STATE MEASURE 5 9868 1040035A 21 41 62
218699 218699 NO 23588 STATE MEASURE 5 9868 1040035A 96 146 242
227181 227181 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1040035A 29 51 80
227182 227182 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1040035A 82 120 202
234728 234728 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 1040035A 88 141 229
234729 234729 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 1040035A 23 43 66
251398 251398 KATHYE ARMITAGE 23653 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Full Term 9803 1040035A 41 85 126
251399 251399 HOLLY SCHROEDER 23734 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Full Term 9803 1040035A 53 83 136
256755 256755 GLORIA MERCADO-FORTINE 24010 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9658 1040035A 32 50 82
256756 256756 AAKASH AHUJA 23810 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9658 1040035A 55 85 140
256757 256757 LINDA HOVIS STORLI 23694 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9658 1040035A 12 43 55
257928 257928 YES 24240 COUNTY MEASURE G 9961 1040035A 31 41 72
257929 257929 NO 24241 COUNTY MEASURE G 9961 1040035A 78 133 211

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