results

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

58 rows where precinct_id = "3000004C"

✎ 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
23241 23241 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 3000004C 13 26 39
23242 23242 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 3000004C 2 4 6
23243 23243 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 3000004C 18 60 78
23244 23244 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 3000004C 0 5 5
23245 23245 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 3000004C 0 0 0
23246 23246 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 3000004C 0 0 0
52297 52297 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 3000004C 8 27 35
52298 52298 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 3000004C 20 64 84
60323 60323 YES 23601 STATE MEASURE 36 9874 3000004C 24 64 88
60324 60324 NO 23602 STATE MEASURE 36 9874 3000004C 0 24 24
69032 69032 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3000004C 11 34 45
69033 69033 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3000004C 11 31 42
77340 77340 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 3000004C 19 51 70
77341 77341 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 3000004C 8 24 32
83368 83368 MARGUERITE S. LOPEZ-SAPIEN 24151 IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9706 3000004C 11 40 51
83369 83369 MANUEL R. GARCIA 24147 IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9706 3000004C 18 51 69
83370 83370 MARK A. BRECEDA 24146 IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9706 3000004C 16 41 57
83371 83371 LARRY G. BURROLA 24149 IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9706 3000004C 20 39 59
85472 85472 YES 24160 IRWINDALE CITY SPECIAL MUNICIPAL ELECTION - MEASURE IR 9929 3000004C 22 38 60
85473 85473 NO 24161 IRWINDALE CITY SPECIAL MUNICIPAL ELECTION - MEASURE IR 9929 3000004C 8 49 57
88894 88894 YES 23584 STATE MEASURE 3 9867 3000004C 19 53 72
88895 88895 NO 23585 STATE MEASURE 3 9867 3000004C 9 40 49
99468 99468 YES 23593 STATE MEASURE 33 9871 3000004C 13 34 47
99469 99469 NO 23594 STATE MEASURE 33 9871 3000004C 11 51 62
107954 107954 YES 23599 STATE MEASURE 35 9873 3000004C 23 60 83
107955 107955 NO 23600 STATE MEASURE 35 9873 3000004C 4 24 28
116590 116590 YES 23766 COUNTY MEASURE A 9880 3000004C 10 38 48
116591 116591 NO 23767 COUNTY MEASURE A 9880 3000004C 12 50 62
124670 124670 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3000004C 16 45 61
124671 124671 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3000004C 7 22 29
133082 133082 YES 23597 STATE MEASURE 34 9872 3000004C 12 41 53
133083 133083 NO 23598 STATE MEASURE 34 9872 3000004C 13 45 58
140588 140588 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 3000004C 7 27 34
140589 140589 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 3000004C 22 60 82
143304 143304 YES 23591 STATE MEASURE 32 9870 3000004C 12 32 44
143305 143305 NO 23592 STATE MEASURE 32 9870 3000004C 15 57 72
152206 152206 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3000004C 17 48 65
152207 152207 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3000004C 7 22 29
162978 162978 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 3000004C 6 26 32
162979 162979 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 3000004C 24 64 88
166666 166666 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3000004C 8 25 33
166667 166667 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3000004C 20 64 84
174766 174766 YES 23712 STATE MEASURE 2 9878 3000004C 21 50 71
174767 174767 NO 23713 STATE MEASURE 2 9878 3000004C 7 41 48
183474 183474 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3000004C 18 54 72
183475 183475 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3000004C 5 14 19
194132 194132 YES 23714 STATE MEASURE 4 9879 3000004C 20 46 66
194133 194133 NO 23715 STATE MEASURE 4 9879 3000004C 5 44 49
204008 204008 YES 23589 STATE MEASURE 6 9869 3000004C 8 34 42
204009 204009 NO 23590 STATE MEASURE 6 9869 3000004C 17 52 69
211984 211984 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3000004C 8 28 36
211985 211985 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3000004C 13 34 47
219980 219980 YES 23587 STATE MEASURE 5 9868 3000004C 11 37 48
219981 219981 NO 23588 STATE MEASURE 5 9868 3000004C 16 51 67
228129 228129 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3000004C 18 36 54
228130 228130 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3000004C 10 44 54
259210 259210 YES 24240 COUNTY MEASURE G 9961 3000004C 15 39 54
259211 259211 NO 24241 COUNTY MEASURE G 9961 3000004C 11 42 53

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