results

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

60 rows where precinct_id = "0200064A"

✎ 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
15049 15049 SASHA RENÉE PÉREZ 23394 STATE SENATOR, 25th District 9502 0200064A 77 338 415
15050 15050 ELIZABETH WONG AHLERS 23393 STATE SENATOR, 25th District 9502 0200064A 60 52 112
17871 17871 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 0200064A 49 41 90
17872 17872 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 0200064A 2 0 2
17873 17873 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 0200064A 79 364 443
17874 17874 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 0200064A 2 5 7
17875 17875 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 0200064A 2 0 2
17876 17876 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 0200064A 3 1 4
50507 50507 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 0200064A 53 52 105
50508 50508 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 0200064A 85 349 434
58533 58533 YES 23601 STATE MEASURE 36 9874 0200064A 75 168 243
58534 58534 NO 23602 STATE MEASURE 36 9874 0200064A 61 227 288
67242 67242 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200064A 52 106 158
67243 67243 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0200064A 56 219 275
75550 75550 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 0200064A 72 150 222
75551 75551 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 0200064A 60 209 269
87104 87104 YES 23584 STATE MEASURE 3 9867 0200064A 86 344 430
87105 87105 NO 23585 STATE MEASURE 3 9867 0200064A 45 52 97
97678 97678 YES 23593 STATE MEASURE 33 9871 0200064A 35 170 205
97679 97679 NO 23594 STATE MEASURE 33 9871 0200064A 100 216 316
106164 106164 YES 23599 STATE MEASURE 35 9873 0200064A 68 253 321
106165 106165 NO 23600 STATE MEASURE 35 9873 0200064A 64 135 199
114800 114800 YES 23766 COUNTY MEASURE A 9880 0200064A 72 267 339
114801 114801 NO 23767 COUNTY MEASURE A 9880 0200064A 62 122 184
122880 122880 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0200064A 39 109 148
122881 122881 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0200064A 67 208 275
131292 131292 YES 23597 STATE MEASURE 34 9872 0200064A 52 108 160
131293 131293 NO 23598 STATE MEASURE 34 9872 0200064A 79 277 356
139244 139244 YES 23523 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE R 9862 0200064A 66 241 307
139245 139245 NO 23524 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE R 9862 0200064A 66 138 204
139454 139454 JUDY CHU 23454 UNITED STATES REPRESENTATIVE, 28th District 9533 0200064A 82 354 436
139455 139455 APRIL A. VERLATO 23455 UNITED STATES REPRESENTATIVE, 28th District 9533 0200064A 55 45 100
141514 141514 YES 23591 STATE MEASURE 32 9870 0200064A 72 265 337
141515 141515 NO 23592 STATE MEASURE 32 9870 0200064A 64 131 195
150416 150416 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0200064A 65 197 262
150417 150417 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0200064A 48 132 180
164876 164876 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0200064A 53 53 106
164877 164877 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0200064A 85 352 437
172976 172976 YES 23712 STATE MEASURE 2 9878 0200064A 65 257 322
172977 172977 NO 23713 STATE MEASURE 2 9878 0200064A 69 130 199
181684 181684 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0200064A 60 160 220
181685 181685 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0200064A 47 153 200
192342 192342 YES 23714 STATE MEASURE 4 9879 0200064A 78 303 381
192343 192343 NO 23715 STATE MEASURE 4 9879 0200064A 56 94 150
202218 202218 YES 23589 STATE MEASURE 6 9869 0200064A 71 272 343
202219 202219 NO 23590 STATE MEASURE 6 9869 0200064A 59 118 177
210194 210194 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0200064A 41 99 140
210195 210195 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0200064A 68 226 294
218190 218190 YES 23587 STATE MEASURE 5 9868 0200064A 65 252 317
218191 218191 NO 23588 STATE MEASURE 5 9868 0200064A 69 140 209
226789 226789 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0200064A 68 234 302
226790 226790 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0200064A 61 131 192
250898 250898 MARTHA HOUSE 23967 ALTADENA LIBRARY DISTRICT Member, Board of Trustees, Trustee Area No. 5 9837 0200064A 27 64 91
250899 250899 KATIE CLARK 23807 ALTADENA LIBRARY DISTRICT Member, Board of Trustees, Trustee Area No. 5 9837 0200064A 82 262 344
255170 255170 YES 23521 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE EE 9861 0200064A 72 258 330
255171 255171 NO 23522 PASADENA UNIFIED SCHOOL DISTRICT SPECIAL ELECTION - MEASURE EE 9861 0200064A 65 122 187
255979 255979 JOHN HARABEDIAN 23407 MEMBER OF THE STATE ASSEMBLY, 41st District 9509 0200064A 77 342 419
255980 255980 MICHELLE DEL ROSARIO MARTINEZ 23408 MEMBER OF THE STATE ASSEMBLY, 41st District 9509 0200064A 56 48 104
257420 257420 YES 24240 COUNTY MEASURE G 9961 0200064A 58 196 254
257421 257421 NO 24241 COUNTY MEASURE G 9961 0200064A 71 176 247

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