results

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

56 rows where precinct_id = "2020004A"

✎ 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
5535 5535 YES 23549 SAN MARINO UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE M 9865 2020004A 40 193 233
5536 5536 NO 23550 SAN MARINO UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE M 9865 2020004A 16 90 106
15155 15155 SASHA RENÉE PÉREZ 23394 STATE SENATOR, 25th District 9502 2020004A 21 128 149
15156 15156 ELIZABETH WONG AHLERS 23393 STATE SENATOR, 25th District 9502 2020004A 29 142 171
21327 21327 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 2020004A 25 113 138
21328 21328 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 2020004A 0 2 2
21329 21329 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 2020004A 31 176 207
21330 21330 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 2020004A 1 3 4
21331 21331 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 2020004A 0 2 2
21332 21332 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 2020004A 0 3 3
51659 51659 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 2020004A 30 118 148
51660 51660 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 2020004A 21 159 180
59685 59685 YES 23601 STATE MEASURE 36 9874 2020004A 40 223 263
59686 59686 NO 23602 STATE MEASURE 36 9874 2020004A 11 59 70
68394 68394 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 2020004A 20 102 122
68395 68395 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 2020004A 20 88 108
76702 76702 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 2020004A 33 189 222
76703 76703 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 2020004A 11 74 85
88256 88256 YES 23584 STATE MEASURE 3 9867 2020004A 28 163 191
88257 88257 NO 23585 STATE MEASURE 3 9867 2020004A 24 115 139
98830 98830 YES 23593 STATE MEASURE 33 9871 2020004A 17 59 76
98831 98831 NO 23594 STATE MEASURE 33 9871 2020004A 32 227 259
107316 107316 YES 23599 STATE MEASURE 35 9873 2020004A 25 136 161
107317 107317 NO 23600 STATE MEASURE 35 9873 2020004A 25 135 160
115952 115952 YES 23766 COUNTY MEASURE A 9880 2020004A 15 87 102
115953 115953 NO 23767 COUNTY MEASURE A 9880 2020004A 36 183 219
124032 124032 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 2020004A 12 67 79
124033 124033 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 2020004A 27 117 144
132444 132444 YES 23597 STATE MEASURE 34 9872 2020004A 29 136 165
132445 132445 NO 23598 STATE MEASURE 34 9872 2020004A 21 138 159
139552 139552 JUDY CHU 23454 UNITED STATES REPRESENTATIVE, 28th District 9533 2020004A 32 174 206
139553 139553 APRIL A. VERLATO 23455 UNITED STATES REPRESENTATIVE, 28th District 9533 2020004A 22 105 127
142666 142666 YES 23591 STATE MEASURE 32 9870 2020004A 21 83 104
142667 142667 NO 23592 STATE MEASURE 32 9870 2020004A 32 202 234
151568 151568 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 2020004A 19 93 112
151569 151569 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 2020004A 21 111 132
166028 166028 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 2020004A 30 118 148
166029 166029 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 2020004A 22 156 178
174128 174128 YES 23712 STATE MEASURE 2 9878 2020004A 27 131 158
174129 174129 NO 23713 STATE MEASURE 2 9878 2020004A 25 146 171
182836 182836 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 2020004A 13 63 76
182837 182837 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 2020004A 27 132 159
193494 193494 YES 23714 STATE MEASURE 4 9879 2020004A 21 127 148
193495 193495 NO 23715 STATE MEASURE 4 9879 2020004A 29 148 177
203370 203370 YES 23589 STATE MEASURE 6 9869 2020004A 21 99 120
203371 203371 NO 23590 STATE MEASURE 6 9869 2020004A 28 169 197
211346 211346 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 2020004A 12 41 53
211347 211347 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 2020004A 25 141 166
219342 219342 YES 23587 STATE MEASURE 5 9868 2020004A 17 80 97
219343 219343 NO 23588 STATE MEASURE 5 9868 2020004A 34 195 229
227591 227591 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 2020004A 20 101 121
227592 227592 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 2020004A 27 169 196
258572 258572 YES 24240 COUNTY MEASURE G 9961 2020004A 22 99 121
258573 258573 NO 24241 COUNTY MEASURE G 9961 2020004A 24 154 178
265330 265330 MIKE FONG 23420 MEMBER OF THE STATE ASSEMBLY, 49th District 9515 2020004A 18 148 166
265331 265331 LONG "DAVID" LIU 23419 MEMBER OF THE STATE ASSEMBLY, 49th District 9515 2020004A 32 127 159

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