results

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

59 rows where precinct_id = "2100007A"

✎ 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
1515 1515 YES 23929 EL MONTE CITY SPECIAL MUNICIPAL ELECTION - MEASURE EM 9903 2100007A 39 64 103
1516 1516 NO 23930 EL MONTE CITY SPECIAL MUNICIPAL ELECTION - MEASURE EM 9903 2100007A 23 47 70
11619 11619 RON ESQUIVEL 23667 ROSEMEAD SCHOOL DISTRICT Governing Board Member 9633 2100007A 32 58 90
11620 11620 VERONICA PENA 23798 ROSEMEAD SCHOOL DISTRICT Governing Board Member 9633 2100007A 32 73 105
11621 11621 JONATHAN SMITH 23531 ROSEMEAD SCHOOL DISTRICT Governing Board Member 9633 2100007A 15 20 35
21477 21477 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 2100007A 29 45 74
21478 21478 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 2100007A 0 3 3
21479 21479 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 2100007A 34 72 106
21480 21480 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 2100007A 0 0 0
21481 21481 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 2100007A 0 0 0
21482 21482 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 2100007A 2 0 2
51709 51709 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 2100007A 29 46 75
51710 51710 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 2100007A 33 71 104
59735 59735 YES 23601 STATE MEASURE 36 9874 2100007A 41 81 122
59736 59736 NO 23602 STATE MEASURE 36 9874 2100007A 22 32 54
68444 68444 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 2100007A 26 32 58
68445 68445 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 2100007A 24 70 94
76752 76752 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 2100007A 31 61 92
76753 76753 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 2100007A 23 43 66
88306 88306 YES 23584 STATE MEASURE 3 9867 2100007A 38 62 100
88307 88307 NO 23585 STATE MEASURE 3 9867 2100007A 24 53 77
98880 98880 YES 23593 STATE MEASURE 33 9871 2100007A 42 66 108
98881 98881 NO 23594 STATE MEASURE 33 9871 2100007A 20 47 67
107366 107366 YES 23599 STATE MEASURE 35 9873 2100007A 50 90 140
107367 107367 NO 23600 STATE MEASURE 35 9873 2100007A 12 22 34
116002 116002 YES 23766 COUNTY MEASURE A 9880 2100007A 40 78 118
116003 116003 NO 23767 COUNTY MEASURE A 9880 2100007A 20 39 59
124082 124082 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 2100007A 29 59 88
124083 124083 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 2100007A 18 45 63
132494 132494 YES 23597 STATE MEASURE 34 9872 2100007A 33 66 99
132495 132495 NO 23598 STATE MEASURE 34 9872 2100007A 24 45 69
140416 140416 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 2100007A 33 37 70
140417 140417 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 2100007A 28 73 101
142716 142716 YES 23591 STATE MEASURE 32 9870 2100007A 44 60 104
142717 142717 NO 23592 STATE MEASURE 32 9870 2100007A 19 55 74
151618 151618 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 2100007A 31 59 90
151619 151619 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 2100007A 19 40 59
166078 166078 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 2100007A 32 44 76
166079 166079 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 2100007A 31 69 100
174178 174178 YES 23712 STATE MEASURE 2 9878 2100007A 42 73 115
174179 174179 NO 23713 STATE MEASURE 2 9878 2100007A 18 41 59
182886 182886 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 2100007A 34 49 83
182887 182887 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 2100007A 15 51 66
193544 193544 YES 23714 STATE MEASURE 4 9879 2100007A 47 75 122
193545 193545 NO 23715 STATE MEASURE 4 9879 2100007A 15 38 53
203420 203420 YES 23589 STATE MEASURE 6 9869 2100007A 37 63 100
203421 203421 NO 23590 STATE MEASURE 6 9869 2100007A 22 50 72
211396 211396 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 2100007A 19 40 59
211397 211397 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 2100007A 31 62 93
219392 219392 YES 23587 STATE MEASURE 5 9868 2100007A 39 65 104
219393 219393 NO 23588 STATE MEASURE 5 9868 2100007A 23 53 76
227641 227641 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 2100007A 41 63 104
227642 227642 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 2100007A 16 48 64
251883 251883 JESSICA ANCONA 24378 EL MONTE CITY GENERAL MUNICIPAL ELECTION Mayor 9688 2100007A 24 60 84
251884 251884 MARISOL CORTEZ 24379 EL MONTE CITY GENERAL MUNICIPAL ELECTION Mayor 9688 2100007A 34 50 84
258622 258622 YES 24240 COUNTY MEASURE G 9961 2100007A 25 63 88
258623 258623 NO 24241 COUNTY MEASURE G 9961 2100007A 33 49 82
265352 265352 MIKE FONG 23420 MEMBER OF THE STATE ASSEMBLY, 49th District 9515 2100007A 28 72 100
265353 265353 LONG "DAVID" LIU 23419 MEMBER OF THE STATE ASSEMBLY, 49th District 9515 2100007A 35 44 79

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