results

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

63 rows where precinct_id = "3900068A"

✎ 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
10820 10820 YES 23821 RIO HONDO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE RH 9886 3900068A 17 36 53
10821 10821 NO 23822 RIO HONDO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE RH 9886 3900068A 7 10 17
16841 16841 JOHN PAUL DRAYER 23842 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 3900068A 10 18 28
16842 16842 VERA ROBLES DEWITT 23889 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 3900068A 9 21 30
25095 25095 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 3900068A 10 13 23
25096 25096 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 3900068A 2 0 2
25097 25097 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 3900068A 13 37 50
25098 25098 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 3900068A 0 0 0
25099 25099 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 3900068A 0 0 0
25100 25100 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 3900068A 0 2 2
52915 52915 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 3900068A 10 12 22
52916 52916 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 3900068A 15 35 50
60941 60941 YES 23601 STATE MEASURE 36 9874 3900068A 17 35 52
60942 60942 NO 23602 STATE MEASURE 36 9874 3900068A 6 11 17
69650 69650 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3900068A 8 13 21
69651 69651 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3900068A 12 24 36
77958 77958 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 3900068A 19 28 47
77959 77959 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 3900068A 6 15 21
89512 89512 YES 23584 STATE MEASURE 3 9867 3900068A 10 37 47
89513 89513 NO 23585 STATE MEASURE 3 9867 3900068A 12 7 19
100086 100086 YES 23593 STATE MEASURE 33 9871 3900068A 9 17 26
100087 100087 NO 23594 STATE MEASURE 33 9871 3900068A 14 27 41
108572 108572 YES 23599 STATE MEASURE 35 9873 3900068A 15 33 48
108573 108573 NO 23600 STATE MEASURE 35 9873 3900068A 7 11 18
117208 117208 YES 23766 COUNTY MEASURE A 9880 3900068A 15 25 40
117209 117209 NO 23767 COUNTY MEASURE A 9880 3900068A 10 20 30
125288 125288 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3900068A 13 26 39
125289 125289 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3900068A 6 12 18
133700 133700 YES 23597 STATE MEASURE 34 9872 3900068A 13 23 36
133701 133701 NO 23598 STATE MEASURE 34 9872 3900068A 10 21 31
143922 143922 YES 23591 STATE MEASURE 32 9870 3900068A 12 20 32
143923 143923 NO 23592 STATE MEASURE 32 9870 3900068A 11 23 34
152824 152824 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3900068A 11 22 33
152825 152825 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3900068A 8 14 22
163946 163946 ERIC J. CHING 23472 UNITED STATES REPRESENTATIVE, 38th District 9542 3900068A 9 8 17
163947 163947 LINDA T. SÁNCHEZ 23473 UNITED STATES REPRESENTATIVE, 38th District 9542 3900068A 16 40 56
167284 167284 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3900068A 10 9 19
167285 167285 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3900068A 15 39 54
175384 175384 YES 23712 STATE MEASURE 2 9878 3900068A 17 27 44
175385 175385 NO 23713 STATE MEASURE 2 9878 3900068A 7 17 24
184092 184092 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3900068A 17 22 39
184093 184093 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3900068A 2 14 16
194750 194750 YES 23714 STATE MEASURE 4 9879 3900068A 15 32 47
194751 194751 NO 23715 STATE MEASURE 4 9879 3900068A 7 10 17
204626 204626 YES 23589 STATE MEASURE 6 9869 3900068A 15 21 36
204627 204627 NO 23590 STATE MEASURE 6 9869 3900068A 7 24 31
212602 212602 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3900068A 7 7 14
212603 212603 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3900068A 13 29 42
220598 220598 YES 23587 STATE MEASURE 5 9868 3900068A 11 16 27
220599 220599 NO 23588 STATE MEASURE 5 9868 3900068A 10 28 38
228505 228505 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3900068A 12 20 32
228506 228506 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3900068A 12 22 34
233758 233758 YES 23823 WHITTIER CITY SCHOOL DISTRICT SPECIAL ELECTION - MEASURE W 9887 3900068A 18 33 51
233759 233759 NO 23824 WHITTIER CITY SCHOOL DISTRICT SPECIAL ELECTION - MEASURE W 9887 3900068A 5 12 17
252809 252809 FERNANDO ISLAS 23993 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 3900068A 0 2 2
252810 252810 LISSETH M. FLORES-FRANCO 24051 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 3900068A 9 10 19
252811 252811 GARY MENDEZ 23785 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 3900068A 6 15 21
252812 252812 JOSUE ALVARADO 24006 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 3900068A 0 0 0
252813 252813 MAX A. ORDONEZ 23716 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 3900068A 2 11 13
254060 254060 JESSICA MARTINEZ 23432 MEMBER OF THE STATE ASSEMBLY, 56th District 9521 3900068A 11 10 21
254061 254061 LISA CALDERON 23431 MEMBER OF THE STATE ASSEMBLY, 56th District 9521 3900068A 14 38 52
259828 259828 YES 24240 COUNTY MEASURE G 9961 3900068A 16 22 38
259829 259829 NO 24241 COUNTY MEASURE G 9961 3900068A 9 22 31

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