results

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

59 rows where precinct_id = "7050078A"

✎ 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
11643 11643 RON ESQUIVEL 23667 ROSEMEAD SCHOOL DISTRICT Governing Board Member 9633 7050078A 11 49 60
11644 11644 VERONICA PENA 23798 ROSEMEAD SCHOOL DISTRICT Governing Board Member 9633 7050078A 19 48 67
11645 11645 JONATHAN SMITH 23531 ROSEMEAD SCHOOL DISTRICT Governing Board Member 9633 7050078A 10 27 37
15699 15699 SASHA RENÉE PÉREZ 23394 STATE SENATOR, 25th District 9502 7050078A 14 60 74
15700 15700 ELIZABETH WONG AHLERS 23393 STATE SENATOR, 25th District 9502 7050078A 16 41 57
29673 29673 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 7050078A 15 40 55
29674 29674 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 7050078A 0 0 0
29675 29675 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 7050078A 17 71 88
29676 29676 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 7050078A 0 2 2
29677 29677 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 7050078A 0 0 0
29678 29678 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 7050078A 0 0 0
54441 54441 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 7050078A 16 38 54
54442 54442 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 7050078A 14 69 83
62467 62467 YES 23601 STATE MEASURE 36 9874 7050078A 18 92 110
62468 62468 NO 23602 STATE MEASURE 36 9874 7050078A 6 15 21
71176 71176 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7050078A 10 51 61
71177 71177 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7050078A 11 29 40
79484 79484 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 7050078A 16 67 83
79485 79485 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 7050078A 11 28 39
91038 91038 YES 23584 STATE MEASURE 3 9867 7050078A 10 68 78
91039 91039 NO 23585 STATE MEASURE 3 9867 7050078A 18 41 59
101612 101612 YES 23593 STATE MEASURE 33 9871 7050078A 12 43 55
101613 101613 NO 23594 STATE MEASURE 33 9871 7050078A 14 63 77
110098 110098 YES 23599 STATE MEASURE 35 9873 7050078A 17 77 94
110099 110099 NO 23600 STATE MEASURE 35 9873 7050078A 8 28 36
118734 118734 YES 23766 COUNTY MEASURE A 9880 7050078A 15 48 63
118735 118735 NO 23767 COUNTY MEASURE A 9880 7050078A 13 60 73
126814 126814 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7050078A 14 25 39
126815 126815 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7050078A 10 49 59
135226 135226 YES 23597 STATE MEASURE 34 9872 7050078A 12 55 67
135227 135227 NO 23598 STATE MEASURE 34 9872 7050078A 12 43 55
139940 139940 JUDY CHU 23454 UNITED STATES REPRESENTATIVE, 28th District 9533 7050078A 14 72 86
139941 139941 APRIL A. VERLATO 23455 UNITED STATES REPRESENTATIVE, 28th District 9533 7050078A 16 34 50
145448 145448 YES 23591 STATE MEASURE 32 9870 7050078A 12 49 61
145449 145449 NO 23592 STATE MEASURE 32 9870 7050078A 14 60 74
154350 154350 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7050078A 13 46 59
154351 154351 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7050078A 13 37 50
161440 161440 CHARLES MANUEL TREVINO 23676 UPPER SAN GABRIEL VALLEY MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9815 7050078A 19 60 79
161441 161441 MINDY YEH 24002 UPPER SAN GABRIEL VALLEY MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9815 7050078A 7 32 39
168810 168810 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7050078A 18 40 58
168811 168811 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7050078A 12 67 79
176910 176910 YES 23712 STATE MEASURE 2 9878 7050078A 20 53 73
176911 176911 NO 23713 STATE MEASURE 2 9878 7050078A 8 56 64
185618 185618 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7050078A 18 32 50
185619 185619 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7050078A 6 44 50
196276 196276 YES 23714 STATE MEASURE 4 9879 7050078A 14 68 82
196277 196277 NO 23715 STATE MEASURE 4 9879 7050078A 13 39 52
206152 206152 YES 23589 STATE MEASURE 6 9869 7050078A 11 50 61
206153 206153 NO 23590 STATE MEASURE 6 9869 7050078A 15 54 69
214128 214128 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7050078A 12 21 33
214129 214129 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7050078A 11 54 65
222124 222124 YES 23587 STATE MEASURE 5 9868 7050078A 12 39 51
222125 222125 NO 23588 STATE MEASURE 5 9868 7050078A 14 66 80
229665 229665 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 7050078A 17 49 66
229666 229666 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 7050078A 8 52 60
261354 261354 YES 24240 COUNTY MEASURE G 9961 7050078A 12 38 50
261355 261355 NO 24241 COUNTY MEASURE G 9961 7050078A 13 57 70
265548 265548 MIKE FONG 23420 MEMBER OF THE STATE ASSEMBLY, 49th District 9515 7050078A 12 69 81
265549 265549 LONG "DAVID" LIU 23419 MEMBER OF THE STATE ASSEMBLY, 49th District 9515 7050078A 16 34 50

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