results

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

65 rows where precinct_id = "7800079D"

✎ 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
17047 17047 JOHN PAUL DRAYER 23842 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 7800079D 46 97 143
17048 17048 VERA ROBLES DEWITT 23889 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 7800079D 59 201 260
30681 30681 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 7800079D 90 210 300
30682 30682 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 7800079D 0 1 1
30683 30683 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 7800079D 58 229 287
30684 30684 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 7800079D 0 5 5
30685 30685 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 7800079D 0 0 0
30686 30686 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 7800079D 0 3 3
54777 54777 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 7800079D 90 206 296
54778 54778 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 7800079D 60 208 268
58343 58343 YES 23914 FULLERTON JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE L 9895 7800079D 71 215 286
58344 58344 NO 23915 FULLERTON JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE L 9895 7800079D 72 196 268
62803 62803 YES 23601 STATE MEASURE 36 9874 7800079D 115 337 452
62804 62804 NO 23602 STATE MEASURE 36 9874 7800079D 29 83 112
71512 71512 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7800079D 61 183 244
71513 71513 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7800079D 55 147 202
79820 79820 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 7800079D 112 299 411
79821 79821 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 7800079D 28 98 126
91374 91374 YES 23584 STATE MEASURE 3 9867 7800079D 61 213 274
91375 91375 NO 23585 STATE MEASURE 3 9867 7800079D 79 200 279
101948 101948 YES 23593 STATE MEASURE 33 9871 7800079D 42 118 160
101949 101949 NO 23594 STATE MEASURE 33 9871 7800079D 95 289 384
110434 110434 YES 23599 STATE MEASURE 35 9873 7800079D 86 264 350
110435 110435 NO 23600 STATE MEASURE 35 9873 7800079D 55 153 208
119070 119070 YES 23766 COUNTY MEASURE A 9880 7800079D 45 146 191
119071 119071 NO 23767 COUNTY MEASURE A 9880 7800079D 97 263 360
127150 127150 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7800079D 56 146 202
127151 127151 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7800079D 57 183 240
135562 135562 YES 23597 STATE MEASURE 34 9872 7800079D 85 235 320
135563 135563 NO 23598 STATE MEASURE 34 9872 7800079D 48 160 208
145784 145784 YES 23591 STATE MEASURE 32 9870 7800079D 43 150 193
145785 145785 NO 23592 STATE MEASURE 32 9870 7800079D 95 261 356
154686 154686 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7800079D 55 187 242
154687 154687 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7800079D 69 155 224
164308 164308 ERIC J. CHING 23472 UNITED STATES REPRESENTATIVE, 38th District 9542 7800079D 83 200 283
164309 164309 LINDA T. SÁNCHEZ 23473 UNITED STATES REPRESENTATIVE, 38th District 9542 7800079D 63 220 283
169146 169146 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7800079D 91 217 308
169147 169147 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7800079D 59 208 267
177246 177246 YES 23712 STATE MEASURE 2 9878 7800079D 64 167 231
177247 177247 NO 23713 STATE MEASURE 2 9878 7800079D 78 243 321
185954 185954 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7800079D 62 208 270
185955 185955 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7800079D 51 121 172
196612 196612 YES 23714 STATE MEASURE 4 9879 7800079D 55 161 216
196613 196613 NO 23715 STATE MEASURE 4 9879 7800079D 85 251 336
200586 200586 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 7800079D 76 255 331
200587 200587 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 7800079D 62 129 191
206488 206488 YES 23589 STATE MEASURE 6 9869 7800079D 44 170 214
206489 206489 NO 23590 STATE MEASURE 6 9869 7800079D 90 235 325
214464 214464 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7800079D 39 115 154
214465 214465 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7800079D 74 187 261
222460 222460 YES 23587 STATE MEASURE 5 9868 7800079D 37 128 165
222461 222461 NO 23588 STATE MEASURE 5 9868 7800079D 103 279 382
229855 229855 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 7800079D 62 159 221
229856 229856 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 7800079D 76 228 304
253244 253244 FERNANDO ISLAS 23993 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800079D 10 32 42
253245 253245 LISSETH M. FLORES-FRANCO 24051 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800079D 9 41 50
253246 253246 GARY MENDEZ 23785 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800079D 49 95 144
253247 253247 JOSUE ALVARADO 24006 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800079D 12 20 32
253248 253248 MAX A. ORDONEZ 23716 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800079D 27 92 119
254254 254254 JESSICA MARTINEZ 23432 MEMBER OF THE STATE ASSEMBLY, 56th District 9521 7800079D 88 206 294
254255 254255 LISA CALDERON 23431 MEMBER OF THE STATE ASSEMBLY, 56th District 9521 7800079D 58 208 266
261690 261690 YES 24240 COUNTY MEASURE G 9961 7800079D 43 118 161
261691 261691 NO 24241 COUNTY MEASURE G 9961 7800079D 92 274 366
266032 266032 YES 23817 LOWELL JOINT SCHOOL DISTRICT SPECIAL ELECTION - MEASURE P 9884 7800079D 83 233 316
266033 266033 NO 23818 LOWELL JOINT SCHOOL DISTRICT SPECIAL ELECTION - MEASURE P 9884 7800079D 60 172 232

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