results

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

58 rows where precinct_id = "1800021A"

✎ 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
16669 16669 JOHN PAUL DRAYER 23842 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 1800021A 46 121 167
16670 16670 VERA ROBLES DEWITT 23889 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 1800021A 89 234 323
20787 20787 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1800021A 59 110 169
20788 20788 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1800021A 1 1 2
20789 20789 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1800021A 89 304 393
20790 20790 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1800021A 3 3 6
20791 20791 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1800021A 1 2 3
20792 20792 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1800021A 1 0 1
41479 41479 LAURA RICHARDSON 23400 STATE SENATOR, 35th District 9505 1800021A 69 192 261
41480 41480 MICHELLE CHAMBERS 23399 STATE SENATOR, 35th District 9505 1800021A 59 173 232
51479 51479 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1800021A 57 113 170
51480 51480 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1800021A 93 289 382
59505 59505 YES 23601 STATE MEASURE 36 9874 1800021A 97 269 366
59506 59506 NO 23602 STATE MEASURE 36 9874 1800021A 46 134 180
68214 68214 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1800021A 65 138 203
68215 68215 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1800021A 70 218 288
76522 76522 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1800021A 102 193 295
76523 76523 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1800021A 39 184 223
88076 88076 YES 23584 STATE MEASURE 3 9867 1800021A 70 220 290
88077 88077 NO 23585 STATE MEASURE 3 9867 1800021A 76 178 254
96812 96812 ROGER GROH 23478 UNITED STATES REPRESENTATIVE, 44th District 9545 1800021A 44 79 123
96813 96813 NANETTE DIAZ BARRAGÁN 23479 UNITED STATES REPRESENTATIVE, 44th District 9545 1800021A 101 318 419
98650 98650 YES 23593 STATE MEASURE 33 9871 1800021A 75 226 301
98651 98651 NO 23594 STATE MEASURE 33 9871 1800021A 69 176 245
105644 105644 MIKE GIPSON 23441 MEMBER OF THE STATE ASSEMBLY, 65th District 9526 1800021A 86 297 383
105645 105645 LYDIA A GUTIERREZ 23516 MEMBER OF THE STATE ASSEMBLY, 65th District 9526 1800021A 61 106 167
107136 107136 YES 23599 STATE MEASURE 35 9873 1800021A 99 324 423
107137 107137 NO 23600 STATE MEASURE 35 9873 1800021A 45 77 122
115772 115772 YES 23766 COUNTY MEASURE A 9880 1800021A 96 295 391
115773 115773 NO 23767 COUNTY MEASURE A 9880 1800021A 49 111 160
123852 123852 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1800021A 78 177 255
123853 123853 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1800021A 55 178 233
132264 132264 YES 23597 STATE MEASURE 34 9872 1800021A 79 195 274
132265 132265 NO 23598 STATE MEASURE 34 9872 1800021A 61 192 253
142486 142486 YES 23591 STATE MEASURE 32 9870 1800021A 85 257 342
142487 142487 NO 23592 STATE MEASURE 32 9870 1800021A 62 147 209
151388 151388 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1800021A 90 253 343
151389 151389 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1800021A 45 111 156
161664 161664 YES 23813 COMPTON COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE CC 9882 1800021A 104 303 407
161665 161665 NO 23814 COMPTON COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE CC 9882 1800021A 37 85 122
165848 165848 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1800021A 59 122 181
165849 165849 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1800021A 91 279 370
173948 173948 YES 23712 STATE MEASURE 2 9878 1800021A 90 295 385
173949 173949 NO 23713 STATE MEASURE 2 9878 1800021A 53 109 162
182656 182656 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1800021A 89 215 304
182657 182657 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1800021A 40 141 181
193314 193314 YES 23714 STATE MEASURE 4 9879 1800021A 94 300 394
193315 193315 NO 23715 STATE MEASURE 4 9879 1800021A 48 109 157
203190 203190 YES 23589 STATE MEASURE 6 9869 1800021A 79 242 321
203191 203191 NO 23590 STATE MEASURE 6 9869 1800021A 65 144 209
211166 211166 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1800021A 57 128 185
211167 211167 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1800021A 73 221 294
219162 219162 YES 23587 STATE MEASURE 5 9868 1800021A 69 248 317
219163 219163 NO 23588 STATE MEASURE 5 9868 1800021A 70 159 229
227489 227489 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1800021A 102 267 369
227490 227490 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1800021A 39 106 145
258392 258392 YES 24240 COUNTY MEASURE G 9961 1800021A 76 214 290
258393 258393 NO 24241 COUNTY MEASURE G 9961 1800021A 60 162 222

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