results

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

67 rows where precinct_id = "7800170A"

✎ 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
11042 11042 YES 23821 RIO HONDO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE RH 9886 7800170A 28 107 135
11043 11043 NO 23822 RIO HONDO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE RH 9886 7800170A 20 47 67
17065 17065 JOHN PAUL DRAYER 23842 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 7800170A 19 48 67
17066 17066 VERA ROBLES DEWITT 23889 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 7800170A 21 88 109
30741 30741 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 7800170A 24 44 68
30742 30742 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 7800170A 0 2 2
30743 30743 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 7800170A 25 126 151
30744 30744 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 7800170A 0 0 0
30745 30745 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 7800170A 0 0 0
30746 30746 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 7800170A 1 0 1
43585 43585 ELIZABETH LEON 23573 WHITTIER CITY SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 9655 7800170A 30 110 140
43586 43586 LLOYD S. REED 23865 WHITTIER CITY SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 9655 7800170A 10 37 47
54797 54797 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 7800170A 23 42 65
54798 54798 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 7800170A 22 123 145
62823 62823 YES 23601 STATE MEASURE 36 9874 7800170A 34 110 144
62824 62824 NO 23602 STATE MEASURE 36 9874 7800170A 12 51 63
71532 71532 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7800170A 17 58 75
71533 71533 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7800170A 20 86 106
79840 79840 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 7800170A 33 93 126
79841 79841 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 7800170A 13 62 75
91394 91394 YES 23584 STATE MEASURE 3 9867 7800170A 22 121 143
91395 91395 NO 23585 STATE MEASURE 3 9867 7800170A 24 43 67
101968 101968 YES 23593 STATE MEASURE 33 9871 7800170A 21 83 104
101969 101969 NO 23594 STATE MEASURE 33 9871 7800170A 25 81 106
110454 110454 YES 23599 STATE MEASURE 35 9873 7800170A 25 112 137
110455 110455 NO 23600 STATE MEASURE 35 9873 7800170A 18 45 63
119090 119090 YES 23766 COUNTY MEASURE A 9880 7800170A 22 106 128
119091 119091 NO 23767 COUNTY MEASURE A 9880 7800170A 26 57 83
127170 127170 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7800170A 25 69 94
127171 127171 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7800170A 13 66 79
135582 135582 YES 23597 STATE MEASURE 34 9872 7800170A 13 86 99
135583 135583 NO 23598 STATE MEASURE 34 9872 7800170A 29 71 100
145804 145804 YES 23591 STATE MEASURE 32 9870 7800170A 16 107 123
145805 145805 NO 23592 STATE MEASURE 32 9870 7800170A 29 59 88
154706 154706 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7800170A 25 105 130
154707 154707 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7800170A 17 45 62
164328 164328 ERIC J. CHING 23472 UNITED STATES REPRESENTATIVE, 38th District 9542 7800170A 18 39 57
164329 164329 LINDA T. SÁNCHEZ 23473 UNITED STATES REPRESENTATIVE, 38th District 9542 7800170A 25 127 152
169166 169166 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7800170A 25 45 70
169167 169167 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7800170A 21 118 139
177266 177266 YES 23712 STATE MEASURE 2 9878 7800170A 20 101 121
177267 177267 NO 23713 STATE MEASURE 2 9878 7800170A 28 58 86
185974 185974 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7800170A 26 97 123
185975 185975 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7800170A 12 40 52
196632 196632 YES 23714 STATE MEASURE 4 9879 7800170A 22 111 133
196633 196633 NO 23715 STATE MEASURE 4 9879 7800170A 26 55 81
200602 200602 YES 23860 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 7800170A 27 123 150
200603 200603 NO 23861 PUENTE HILLS HABITAT PRESERVATION AUTHORITY - MEASURE PH 9892 7800170A 20 32 52
206508 206508 YES 23589 STATE MEASURE 6 9869 7800170A 20 99 119
206509 206509 NO 23590 STATE MEASURE 6 9869 7800170A 24 59 83
214484 214484 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7800170A 16 60 76
214485 214485 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7800170A 19 72 91
222480 222480 YES 23587 STATE MEASURE 5 9868 7800170A 22 86 108
222481 222481 NO 23588 STATE MEASURE 5 9868 7800170A 24 75 99
229875 229875 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 7800170A 21 93 114
229876 229876 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 7800170A 25 60 85
233820 233820 YES 23823 WHITTIER CITY SCHOOL DISTRICT SPECIAL ELECTION - MEASURE W 9887 7800170A 28 115 143
233821 233821 NO 23824 WHITTIER CITY SCHOOL DISTRICT SPECIAL ELECTION - MEASURE W 9887 7800170A 18 42 60
253289 253289 FERNANDO ISLAS 23993 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800170A 3 12 15
253290 253290 LISSETH M. FLORES-FRANCO 24051 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800170A 5 37 42
253291 253291 GARY MENDEZ 23785 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800170A 12 44 56
253292 253292 JOSUE ALVARADO 24006 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800170A 5 9 14
253293 253293 MAX A. ORDONEZ 23716 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 7800170A 11 27 38
254274 254274 JESSICA MARTINEZ 23432 MEMBER OF THE STATE ASSEMBLY, 56th District 9521 7800170A 26 46 72
254275 254275 LISA CALDERON 23431 MEMBER OF THE STATE ASSEMBLY, 56th District 9521 7800170A 17 119 136
261710 261710 YES 24240 COUNTY MEASURE G 9961 7800170A 14 91 105
261711 261711 NO 24241 COUNTY MEASURE G 9961 7800170A 31 66 97

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