results

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

58 rows where precinct_id = "0200018A"

✎ 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
15025 15025 SASHA RENÉE PÉREZ 23394 STATE SENATOR, 25th District 9502 0200018A 75 267 342
15026 15026 ELIZABETH WONG AHLERS 23393 STATE SENATOR, 25th District 9502 0200018A 24 41 65
17799 17799 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 0200018A 30 43 73
17800 17800 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 0200018A 2 2 4
17801 17801 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 0200018A 76 272 348
17802 17802 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 0200018A 0 1 1
17803 17803 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 0200018A 0 0 0
17804 17804 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 0200018A 1 8 9
50483 50483 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 0200018A 27 43 70
50484 50484 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 0200018A 74 267 341
58509 58509 YES 23601 STATE MEASURE 36 9874 0200018A 43 158 201
58510 58510 NO 23602 STATE MEASURE 36 9874 0200018A 58 157 215
67218 67218 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200018A 29 95 124
67219 67219 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200018A 58 188 246
75526 75526 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 0200018A 35 134 169
75527 75527 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 0200018A 60 168 228
87080 87080 YES 23584 STATE MEASURE 3 9867 0200018A 64 237 301
87081 87081 NO 23585 STATE MEASURE 3 9867 0200018A 35 67 102
97654 97654 YES 23593 STATE MEASURE 33 9871 0200018A 65 168 233
97655 97655 NO 23594 STATE MEASURE 33 9871 0200018A 36 145 181
106140 106140 YES 23599 STATE MEASURE 35 9873 0200018A 73 237 310
106141 106141 NO 23600 STATE MEASURE 35 9873 0200018A 27 67 94
114776 114776 YES 23766 COUNTY MEASURE A 9880 0200018A 76 222 298
114777 114777 NO 23767 COUNTY MEASURE A 9880 0200018A 26 83 109
122856 122856 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0200018A 43 142 185
122857 122857 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0200018A 39 130 169
131268 131268 YES 23597 STATE MEASURE 34 9872 0200018A 42 124 166
131269 131269 NO 23598 STATE MEASURE 34 9872 0200018A 54 178 232
139228 139228 YES 23523 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE R 9862 0200018A 68 204 272
139229 139229 NO 23524 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE R 9862 0200018A 31 103 134
139430 139430 JUDY CHU 23454 UNITED STATES REPRESENTATIVE, 28th District 9533 0200018A 81 276 357
139431 139431 APRIL A. VERLATO 23455 UNITED STATES REPRESENTATIVE, 28th District 9533 0200018A 20 39 59
141490 141490 YES 23591 STATE MEASURE 32 9870 0200018A 82 217 299
141491 141491 NO 23592 STATE MEASURE 32 9870 0200018A 22 99 121
150392 150392 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0200018A 66 204 270
150393 150393 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0200018A 29 83 112
164852 164852 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0200018A 27 48 75
164853 164853 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0200018A 72 264 336
172952 172952 YES 23712 STATE MEASURE 2 9878 0200018A 69 214 283
172953 172953 NO 23713 STATE MEASURE 2 9878 0200018A 29 101 130
181660 181660 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0200018A 58 193 251
181661 181661 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0200018A 24 74 98
192318 192318 YES 23714 STATE MEASURE 4 9879 0200018A 76 243 319
192319 192319 NO 23715 STATE MEASURE 4 9879 0200018A 26 66 92
202194 202194 YES 23589 STATE MEASURE 6 9869 0200018A 64 208 272
202195 202195 NO 23590 STATE MEASURE 6 9869 0200018A 33 100 133
210170 210170 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0200018A 47 129 176
210171 210171 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0200018A 39 153 192
218166 218166 YES 23587 STATE MEASURE 5 9868 0200018A 67 196 263
218167 218167 NO 23588 STATE MEASURE 5 9868 0200018A 33 116 149
226765 226765 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0200018A 62 222 284
226766 226766 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0200018A 34 87 121
255154 255154 YES 23521 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE EE 9861 0200018A 73 220 293
255155 255155 NO 23522 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE EE 9861 0200018A 30 87 117
255955 255955 JOHN HARABEDIAN 23407 MEMBER OF THE STATE ASSEMBLY, 41st District 9509 0200018A 70 257 327
255956 255956 MICHELLE DEL ROSARIO MARTINEZ 23408 MEMBER OF THE STATE ASSEMBLY, 41st District 9509 0200018A 29 47 76
257396 257396 YES 24240 COUNTY MEASURE G 9961 0200018A 57 165 222
257397 257397 NO 24241 COUNTY MEASURE G 9961 0200018A 36 133 169

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