results

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

61 rows where precinct_id = "1900039A"

✎ 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
2182 2182 FERNANDO VILLEGAS 23761 CITRUS COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 9568 1900039A 20 56 76
2183 2183 VIRGINIA VILLEGAS 24007 CITRUS COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 9568 1900039A 20 38 58
2184 2184 RANDA B. WAHBE 24021 CITRUS COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 9568 1900039A 12 92 104
21141 21141 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1900039A 41 71 112
21142 21142 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1900039A 1 0 1
21143 21143 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1900039A 36 159 195
21144 21144 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1900039A 0 3 3
21145 21145 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1900039A 0 1 1
21146 21146 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1900039A 0 4 4
51597 51597 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1900039A 41 73 114
51598 51598 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1900039A 34 154 188
59623 59623 YES 23601 STATE MEASURE 36 9874 1900039A 49 150 199
59624 59624 NO 23602 STATE MEASURE 36 9874 1900039A 18 84 102
68332 68332 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1900039A 33 78 111
68333 68333 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1900039A 22 96 118
76640 76640 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1900039A 45 118 163
76641 76641 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1900039A 19 87 106
88194 88194 YES 23584 STATE MEASURE 3 9867 1900039A 38 143 181
88195 88195 NO 23585 STATE MEASURE 3 9867 1900039A 33 84 117
98768 98768 YES 23593 STATE MEASURE 33 9871 1900039A 27 87 114
98769 98769 NO 23594 STATE MEASURE 33 9871 1900039A 43 140 183
107254 107254 YES 23599 STATE MEASURE 35 9873 1900039A 45 160 205
107255 107255 NO 23600 STATE MEASURE 35 9873 1900039A 24 66 90
115890 115890 YES 23766 COUNTY MEASURE A 9880 1900039A 36 133 169
115891 115891 NO 23767 COUNTY MEASURE A 9880 1900039A 33 95 128
123970 123970 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1900039A 30 69 99
123971 123971 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1900039A 22 100 122
132382 132382 YES 23597 STATE MEASURE 34 9872 1900039A 37 92 129
132383 132383 NO 23598 STATE MEASURE 34 9872 1900039A 30 124 154
139104 139104 LAURA JASSO 23548 DUARTE UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9848 1900039A 41 158 199
139105 139105 TONETTE PARKER REYES 23884 DUARTE UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9848 1900039A 21 42 63
140398 140398 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 1900039A 38 71 109
140399 140399 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 1900039A 34 152 186
142604 142604 YES 23591 STATE MEASURE 32 9870 1900039A 33 103 136
142605 142605 NO 23592 STATE MEASURE 32 9870 1900039A 41 126 167
151506 151506 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1900039A 29 117 146
151507 151507 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1900039A 25 68 93
162894 162894 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 1900039A 34 72 106
162895 162895 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 1900039A 35 154 189
165966 165966 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1900039A 37 76 113
165967 165967 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1900039A 36 150 186
174066 174066 YES 23712 STATE MEASURE 2 9878 1900039A 42 146 188
174067 174067 NO 23713 STATE MEASURE 2 9878 1900039A 27 84 111
182774 182774 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1900039A 30 104 134
182775 182775 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1900039A 20 71 91
193432 193432 YES 23714 STATE MEASURE 4 9879 1900039A 41 138 179
193433 193433 NO 23715 STATE MEASURE 4 9879 1900039A 26 89 115
203308 203308 YES 23589 STATE MEASURE 6 9869 1900039A 27 122 149
203309 203309 NO 23590 STATE MEASURE 6 9869 1900039A 39 99 138
211284 211284 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1900039A 27 75 102
211285 211285 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1900039A 24 91 115
219280 219280 YES 23587 STATE MEASURE 5 9868 1900039A 31 105 136
219281 219281 NO 23588 STATE MEASURE 5 9868 1900039A 35 122 157
227529 227529 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1900039A 37 108 145
227530 227530 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1900039A 27 106 133
250855 250855 YES 23517 DUARTE CITY GENERAL MUNICIPAL ELECTION - MEASURE QQ 9859 1900039A 29 126 155
250856 250856 NO 23518 DUARTE CITY GENERAL MUNICIPAL ELECTION - MEASURE QQ 9859 1900039A 36 96 132
258510 258510 YES 24240 COUNTY MEASURE G 9961 1900039A 28 99 127
258511 258511 NO 24241 COUNTY MEASURE G 9961 1900039A 34 118 152
265710 265710 VINH TRUONG 24301 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 3rd District 9686 1900039A 41 148 189
265711 265711 HECTOR ARMANDO MARTINEZ 24300 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 3rd District 9686 1900039A 20 64 84

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