results

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

58 rows where precinct_id = "1900004C"

✎ 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
21045 21045 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1900004C 27 48 75
21046 21046 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1900004C 0 0 0
21047 21047 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1900004C 15 60 75
21048 21048 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1900004C 1 2 3
21049 21049 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1900004C 0 1 1
21050 21050 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1900004C 1 1 2
51565 51565 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1900004C 29 46 75
51566 51566 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1900004C 13 58 71
59591 59591 YES 23601 STATE MEASURE 36 9874 1900004C 27 69 96
59592 59592 NO 23602 STATE MEASURE 36 9874 1900004C 14 35 49
68300 68300 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1900004C 22 38 60
68301 68301 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1900004C 14 46 60
76608 76608 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1900004C 34 66 100
76609 76609 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1900004C 9 36 45
88162 88162 YES 23584 STATE MEASURE 3 9867 1900004C 11 63 74
88163 88163 NO 23585 STATE MEASURE 3 9867 1900004C 30 39 69
98736 98736 YES 23593 STATE MEASURE 33 9871 1900004C 18 50 68
98737 98737 NO 23594 STATE MEASURE 33 9871 1900004C 25 52 77
107222 107222 YES 23599 STATE MEASURE 35 9873 1900004C 21 68 89
107223 107223 NO 23600 STATE MEASURE 35 9873 1900004C 22 34 56
115858 115858 YES 23766 COUNTY MEASURE A 9880 1900004C 19 58 77
115859 115859 NO 23767 COUNTY MEASURE A 9880 1900004C 23 42 65
123938 123938 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1900004C 17 39 56
123939 123939 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1900004C 17 44 61
132350 132350 YES 23597 STATE MEASURE 34 9872 1900004C 21 39 60
132351 132351 NO 23598 STATE MEASURE 34 9872 1900004C 21 62 83
140366 140366 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 1900004C 25 40 65
140367 140367 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 1900004C 16 57 73
142572 142572 YES 23591 STATE MEASURE 32 9870 1900004C 23 47 70
142573 142573 NO 23592 STATE MEASURE 32 9870 1900004C 20 56 76
151474 151474 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1900004C 19 56 75
151475 151475 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1900004C 18 32 50
161492 161492 EDDIE HOWARD 23908 DUARTE UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 3 9850 1900004C 5 38 43
161493 161493 TOM N. REYES 23749 DUARTE UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 3 9850 1900004C 31 54 85
162864 162864 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 1900004C 27 41 68
162865 162865 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 1900004C 15 57 72
165934 165934 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1900004C 30 45 75
165935 165935 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1900004C 13 58 71
174034 174034 YES 23712 STATE MEASURE 2 9878 1900004C 22 63 85
174035 174035 NO 23713 STATE MEASURE 2 9878 1900004C 20 39 59
182742 182742 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1900004C 17 50 67
182743 182743 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1900004C 15 33 48
193400 193400 YES 23714 STATE MEASURE 4 9879 1900004C 26 71 97
193401 193401 NO 23715 STATE MEASURE 4 9879 1900004C 15 30 45
203276 203276 YES 23589 STATE MEASURE 6 9869 1900004C 12 50 62
203277 203277 NO 23590 STATE MEASURE 6 9869 1900004C 27 52 79
211252 211252 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1900004C 14 33 47
211253 211253 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1900004C 19 48 67
219248 219248 YES 23587 STATE MEASURE 5 9868 1900004C 19 47 66
219249 219249 NO 23588 STATE MEASURE 5 9868 1900004C 24 54 78
227497 227497 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1900004C 26 62 88
227498 227498 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1900004C 17 37 54
237752 237752 MARTIN CALDERON 24298 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9685 1900004C 21 50 71
237753 237753 JIM KIRCHNER 24299 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9685 1900004C 15 36 51
250823 250823 YES 23517 DUARTE CITY GENERAL MUNICIPAL ELECTION - MEASURE QQ 9859 1900004C 19 50 69
250824 250824 NO 23518 DUARTE CITY GENERAL MUNICIPAL ELECTION - MEASURE QQ 9859 1900004C 19 50 69
258478 258478 YES 24240 COUNTY MEASURE G 9961 1900004C 15 48 63
258479 258479 NO 24241 COUNTY MEASURE G 9961 1900004C 26 48 74

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