results

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

78 rows where precinct_id = "9000686A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
3740 3740 YES 24221 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ER 9954 9000686A 44 137 181
3741 3741 NO 24222 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE ER 9954 9000686A 23 26 49
7932 7932 NANCY PEARLMAN 23533 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9000686A 26 41 67
7933 7933 DAVID VELA 23624 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9000686A 32 93 125
7934 7934 LOUIS ANTHONY SHAPIRO 23836 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 9000686A 8 20 28
16383 16383 LUZ MARIA RIVAS 23457 UNITED STATES REPRESENTATIVE, 29th District 9534 9000686A 51 125 176
16384 16384 BENITO BENNY BERNAL 23456 UNITED STATES REPRESENTATIVE, 29th District 9534 9000686A 26 43 69
31917 31917 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 9000686A 32 48 80
31918 31918 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 9000686A 2 0 2
31919 31919 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 9000686A 54 144 198
31920 31920 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 9000686A 0 2 2
31921 31921 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 9000686A 0 0 0
31922 31922 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 9000686A 0 2 2
45581 45581 NICHELLE M. HENDERSON 23705 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9000686A 23 108 131
45582 45582 ELAINE ALANIZ 23811 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9000686A 26 29 55
45583 45583 JASON R. AULA 24020 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 9000686A 19 21 40
48787 48787 YES 24215 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE DD 9951 9000686A 49 133 182
48788 48788 NO 24216 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE DD 9951 9000686A 20 34 54
55189 55189 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 9000686A 34 53 87
55190 55190 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 9000686A 45 133 178
63215 63215 YES 23601 STATE MEASURE 36 9874 9000686A 55 106 161
63216 63216 NO 23602 STATE MEASURE 36 9874 9000686A 22 71 93
71924 71924 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 9000686A 32 53 85
71925 71925 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 9000686A 38 110 148
80232 80232 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 9000686A 43 68 111
80233 80233 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 9000686A 32 105 137
83874 83874 YES 24219 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE II 9953 9000686A 53 129 182
83875 83875 NO 24220 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE II 9953 9000686A 17 33 50
91786 91786 YES 23584 STATE MEASURE 3 9867 9000686A 50 123 173
91787 91787 NO 23585 STATE MEASURE 3 9867 9000686A 22 53 75
97378 97378 VICTORIA GARCIA 23411 MEMBER OF THE STATE ASSEMBLY, 43rd District 9511 9000686A 29 49 78
97379 97379 CELESTE RODRIGUEZ 23412 MEMBER OF THE STATE ASSEMBLY, 43rd District 9511 9000686A 48 118 166
102360 102360 YES 23593 STATE MEASURE 33 9871 9000686A 33 102 135
102361 102361 NO 23594 STATE MEASURE 33 9871 9000686A 39 73 112
110846 110846 YES 23599 STATE MEASURE 35 9873 9000686A 58 134 192
110847 110847 NO 23600 STATE MEASURE 35 9873 9000686A 18 43 61
119482 119482 YES 23766 COUNTY MEASURE A 9880 9000686A 42 116 158
119483 119483 NO 23767 COUNTY MEASURE A 9880 9000686A 32 60 92
127562 127562 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 9000686A 48 100 148
127563 127563 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 9000686A 22 58 80
135974 135974 YES 23597 STATE MEASURE 34 9872 9000686A 37 72 109
135975 135975 NO 23598 STATE MEASURE 34 9872 9000686A 35 98 133
146196 146196 YES 23591 STATE MEASURE 32 9870 9000686A 41 121 162
146197 146197 NO 23592 STATE MEASURE 32 9870 9000686A 36 59 95
155098 155098 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 9000686A 42 112 154
155099 155099 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 9000686A 32 51 83
159642 159642 YES 24232 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 9000686A 45 126 171
159643 159643 NO 24233 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 9000686A 21 39 60
164606 164606 JILLIAN BURGOS 23371 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9491 9000686A 46 79 125
164607 164607 ADRIN NAZARIAN 23372 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9491 9000686A 29 89 118
169558 169558 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 9000686A 36 54 90
169559 169559 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 9000686A 45 129 174
177658 177658 YES 23712 STATE MEASURE 2 9878 9000686A 57 134 191
177659 177659 NO 23713 STATE MEASURE 2 9878 9000686A 19 42 61
186366 186366 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 9000686A 47 106 153
186367 186367 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 9000686A 17 55 72
190564 190564 YES 24223 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE FF 9955 9000686A 48 108 156
190565 190565 NO 24224 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE FF 9955 9000686A 22 58 80
197024 197024 YES 23714 STATE MEASURE 4 9879 9000686A 52 135 187
197025 197025 NO 23715 STATE MEASURE 4 9879 9000686A 25 41 66
206900 206900 YES 23589 STATE MEASURE 6 9869 9000686A 37 109 146
206901 206901 NO 23590 STATE MEASURE 6 9869 9000686A 35 58 93
214876 214876 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 9000686A 36 66 102
214877 214877 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 9000686A 35 91 126
222872 222872 YES 23587 STATE MEASURE 5 9868 9000686A 39 105 144
222873 222873 NO 23588 STATE MEASURE 5 9868 9000686A 36 68 104
231864 231864 YES 24217 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE HH 9952 9000686A 58 136 194
231865 231865 NO 24218 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE HH 9952 9000686A 13 28 41
239537 239537 KELSEY IINO 23603 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 9000686A 46 115 161
239538 239538 ROBERT PAYNE 23554 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 9000686A 19 37 56
244461 244461 BALTAZAR FEDALIZO 23870 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9000686A 10 10 20
244462 244462 ANDRA HOFFMAN 23559 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9000686A 35 103 138
244463 244463 PETER V. MANGHERA 23969 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9000686A 16 29 45
244464 244464 CHEYENNE SIMS 24038 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 9000686A 4 13 17
248929 248929 YES 24230 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 9000686A 57 129 186
248930 248930 NO 24231 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 9000686A 16 44 60
262102 262102 YES 24240 COUNTY MEASURE G 9961 9000686A 45 106 151
262103 262103 NO 24241 COUNTY MEASURE G 9961 9000686A 23 55 78

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