results

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

61 rows where precinct_id = "1020017A"

✎ 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
5404 5404 ERIC ANDERSON 23529 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 4 9659 1020017A 8 43 51
5405 5405 ERIN WILSON 23763 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 4 9659 1020017A 25 89 114
13861 13861 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 1020017A 30 96 126
13862 13862 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 1020017A 10 59 69
19065 19065 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1020017A 31 93 124
19066 19066 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1020017A 0 0 0
19067 19067 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1020017A 10 62 72
19068 19068 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1020017A 0 0 0
19069 19069 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1020017A 0 0 0
19070 19070 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1020017A 1 3 4
50905 50905 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1020017A 30 97 127
50906 50906 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1020017A 11 56 67
58931 58931 YES 23601 STATE MEASURE 36 9874 1020017A 29 112 141
58932 58932 NO 23602 STATE MEASURE 36 9874 1020017A 8 41 49
66449 66449 JERRY DANIELSEN 23572 SANTA CLARITA COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Trustee Area 4 9640 1020017A 9 73 82
66450 66450 SHARLENE ROSE JOHNSON 23904 SANTA CLARITA COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Trustee Area 4 9640 1020017A 22 47 69
67640 67640 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1020017A 17 85 102
67641 67641 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1020017A 15 46 61
75948 75948 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1020017A 26 116 142
75949 75949 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1020017A 11 29 40
87502 87502 YES 23584 STATE MEASURE 3 9867 1020017A 11 72 83
87503 87503 NO 23585 STATE MEASURE 3 9867 1020017A 26 82 108
98076 98076 YES 23593 STATE MEASURE 33 9871 1020017A 10 30 40
98077 98077 NO 23594 STATE MEASURE 33 9871 1020017A 26 121 147
106562 106562 YES 23599 STATE MEASURE 35 9873 1020017A 19 90 109
106563 106563 NO 23600 STATE MEASURE 35 9873 1020017A 17 60 77
115198 115198 YES 23766 COUNTY MEASURE A 9880 1020017A 17 34 51
115199 115199 NO 23767 COUNTY MEASURE A 9880 1020017A 19 118 137
123278 123278 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1020017A 22 35 57
123279 123279 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1020017A 9 90 99
131690 131690 YES 23597 STATE MEASURE 34 9872 1020017A 21 88 109
131691 131691 NO 23598 STATE MEASURE 34 9872 1020017A 14 63 77
141912 141912 YES 23591 STATE MEASURE 32 9870 1020017A 13 38 51
141913 141913 NO 23592 STATE MEASURE 32 9870 1020017A 24 113 137
149642 149642 GARY MARTIN 23611 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 9801 1020017A 24 83 107
149643 149643 DAN MASNADA 23543 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 9801 1020017A 15 69 84
149644 149644 PAULA OLIVARES 24030 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 9801 1020017A 10 32 42
150814 150814 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1020017A 15 45 60
150815 150815 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1020017A 16 81 97
165274 165274 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1020017A 30 100 130
165275 165275 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1020017A 11 57 68
173374 173374 YES 23712 STATE MEASURE 2 9878 1020017A 15 51 66
173375 173375 NO 23713 STATE MEASURE 2 9878 1020017A 21 98 119
180806 180806 PATRICK LEE GIPSON 23405 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 1020017A 26 97 123
180807 180807 PILAR SCHIAVO 23406 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 1020017A 11 56 67
182082 182082 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1020017A 15 48 63
182083 182083 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1020017A 14 65 79
192740 192740 YES 23714 STATE MEASURE 4 9879 1020017A 16 56 72
192741 192741 NO 23715 STATE MEASURE 4 9879 1020017A 21 99 120
202616 202616 YES 23589 STATE MEASURE 6 9869 1020017A 14 46 60
202617 202617 NO 23590 STATE MEASURE 6 9869 1020017A 20 105 125
210592 210592 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1020017A 15 39 54
210593 210593 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1020017A 15 90 105
218588 218588 YES 23587 STATE MEASURE 5 9868 1020017A 7 38 45
218589 218589 NO 23588 STATE MEASURE 5 9868 1020017A 28 113 141
227071 227071 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1020017A 12 41 53
227072 227072 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1020017A 23 85 108
234684 234684 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 1020017A 29 99 128
234685 234685 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 1020017A 10 58 68
257818 257818 YES 24240 COUNTY MEASURE G 9961 1020017A 17 50 67
257819 257819 NO 24241 COUNTY MEASURE G 9961 1020017A 15 96 111

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