results

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

57 rows where precinct_id = "1900002A"

✎ 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
2158 2158 FERNANDO VILLEGAS 23761 CITRUS COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 9568 1900002A 13 31 44
2159 2159 VIRGINIA VILLEGAS 24007 CITRUS COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 9568 1900002A 16 34 50
2160 2160 RANDA B. WAHBE 24021 CITRUS COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 9568 1900002A 7 23 30
21039 21039 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1900002A 25 32 57
21040 21040 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1900002A 0 0 0
21041 21041 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1900002A 23 98 121
21042 21042 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1900002A 0 1 1
21043 21043 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1900002A 0 0 0
21044 21044 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1900002A 0 0 0
51563 51563 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1900002A 25 31 56
51564 51564 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1900002A 21 96 117
59589 59589 YES 23601 STATE MEASURE 36 9874 1900002A 30 82 112
59590 59590 NO 23602 STATE MEASURE 36 9874 1900002A 11 31 42
68298 68298 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1900002A 23 41 64
68299 68299 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1900002A 16 43 59
76606 76606 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1900002A 27 77 104
76607 76607 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1900002A 13 32 45
88160 88160 YES 23584 STATE MEASURE 3 9867 1900002A 10 75 85
88161 88161 NO 23585 STATE MEASURE 3 9867 1900002A 31 40 71
98734 98734 YES 23593 STATE MEASURE 33 9871 1900002A 24 60 84
98735 98735 NO 23594 STATE MEASURE 33 9871 1900002A 20 55 75
107220 107220 YES 23599 STATE MEASURE 35 9873 1900002A 29 90 119
107221 107221 NO 23600 STATE MEASURE 35 9873 1900002A 13 23 36
115856 115856 YES 23766 COUNTY MEASURE A 9880 1900002A 24 80 104
115857 115857 NO 23767 COUNTY MEASURE A 9880 1900002A 19 42 61
123936 123936 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1900002A 18 34 52
123937 123937 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1900002A 20 47 67
132348 132348 YES 23597 STATE MEASURE 34 9872 1900002A 22 53 75
132349 132349 NO 23598 STATE MEASURE 34 9872 1900002A 15 48 63
140364 140364 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 1900002A 24 26 50
140365 140365 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 1900002A 19 91 110
142570 142570 YES 23591 STATE MEASURE 32 9870 1900002A 18 67 85
142571 142571 NO 23592 STATE MEASURE 32 9870 1900002A 25 49 74
151472 151472 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1900002A 23 56 79
151473 151473 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1900002A 14 36 50
162862 162862 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 1900002A 18 25 43
162863 162863 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 1900002A 24 92 116
165932 165932 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1900002A 25 31 56
165933 165933 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1900002A 21 99 120
174032 174032 YES 23712 STATE MEASURE 2 9878 1900002A 25 81 106
174033 174033 NO 23713 STATE MEASURE 2 9878 1900002A 16 37 53
182740 182740 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1900002A 20 48 68
182741 182741 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1900002A 16 38 54
193398 193398 YES 23714 STATE MEASURE 4 9879 1900002A 22 86 108
193399 193399 NO 23715 STATE MEASURE 4 9879 1900002A 19 32 51
203274 203274 YES 23589 STATE MEASURE 6 9869 1900002A 20 57 77
203275 203275 NO 23590 STATE MEASURE 6 9869 1900002A 21 48 69
211250 211250 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1900002A 15 32 47
211251 211251 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1900002A 23 50 73
219246 219246 YES 23587 STATE MEASURE 5 9868 1900002A 23 65 88
219247 219247 NO 23588 STATE MEASURE 5 9868 1900002A 20 48 68
227495 227495 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1900002A 24 78 102
227496 227496 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1900002A 18 41 59
250821 250821 YES 23517 DUARTE CITY GENERAL MUNICIPAL ELECTION - MEASURE QQ 9859 1900002A 15 68 83
250822 250822 NO 23518 DUARTE CITY GENERAL MUNICIPAL ELECTION - MEASURE QQ 9859 1900002A 26 41 67
258476 258476 YES 24240 COUNTY MEASURE G 9961 1900002A 22 56 78
258477 258477 NO 24241 COUNTY MEASURE G 9961 1900002A 17 48 65

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