results

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

54 rows where precinct_id = "1900018A"

✎ 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
21105 21105 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1900018A 21 40 61
21106 21106 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1900018A 0 1 1
21107 21107 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1900018A 16 82 98
21108 21108 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1900018A 0 0 0
21109 21109 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1900018A 0 0 0
21110 21110 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1900018A 0 3 3
51585 51585 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1900018A 16 34 50
51586 51586 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1900018A 19 84 103
59611 59611 YES 23601 STATE MEASURE 36 9874 1900018A 22 74 96
59612 59612 NO 23602 STATE MEASURE 36 9874 1900018A 11 43 54
68320 68320 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1900018A 10 53 63
68321 68321 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1900018A 16 60 76
76628 76628 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1900018A 17 70 87
76629 76629 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1900018A 15 47 62
88182 88182 YES 23584 STATE MEASURE 3 9867 1900018A 20 94 114
88183 88183 NO 23585 STATE MEASURE 3 9867 1900018A 14 27 41
98756 98756 YES 23593 STATE MEASURE 33 9871 1900018A 13 50 63
98757 98757 NO 23594 STATE MEASURE 33 9871 1900018A 21 66 87
107242 107242 YES 23599 STATE MEASURE 35 9873 1900018A 20 94 114
107243 107243 NO 23600 STATE MEASURE 35 9873 1900018A 14 19 33
115878 115878 YES 23766 COUNTY MEASURE A 9880 1900018A 18 61 79
115879 115879 NO 23767 COUNTY MEASURE A 9880 1900018A 17 55 72
123958 123958 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1900018A 15 59 74
123959 123959 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1900018A 10 50 60
132370 132370 YES 23597 STATE MEASURE 34 9872 1900018A 15 74 89
132371 132371 NO 23598 STATE MEASURE 34 9872 1900018A 18 40 58
140386 140386 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 1900018A 15 34 49
140387 140387 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 1900018A 17 86 103
142592 142592 YES 23591 STATE MEASURE 32 9870 1900018A 14 56 70
142593 142593 NO 23592 STATE MEASURE 32 9870 1900018A 21 65 86
151494 151494 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1900018A 18 57 75
151495 151495 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1900018A 11 55 66
162882 162882 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 1900018A 13 26 39
162883 162883 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 1900018A 20 94 114
165954 165954 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1900018A 15 35 50
165955 165955 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1900018A 19 83 102
174054 174054 YES 23712 STATE MEASURE 2 9878 1900018A 16 70 86
174055 174055 NO 23713 STATE MEASURE 2 9878 1900018A 18 49 67
182762 182762 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1900018A 18 64 82
182763 182763 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1900018A 8 42 50
193420 193420 YES 23714 STATE MEASURE 4 9879 1900018A 17 77 94
193421 193421 NO 23715 STATE MEASURE 4 9879 1900018A 16 42 58
203296 203296 YES 23589 STATE MEASURE 6 9869 1900018A 16 56 72
203297 203297 NO 23590 STATE MEASURE 6 9869 1900018A 17 59 76
211272 211272 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1900018A 8 52 60
211273 211273 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1900018A 17 58 75
219268 219268 YES 23587 STATE MEASURE 5 9868 1900018A 13 61 74
219269 219269 NO 23588 STATE MEASURE 5 9868 1900018A 20 57 77
227517 227517 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1900018A 16 69 85
227518 227518 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1900018A 17 45 62
250843 250843 YES 23517 DUARTE CITY GENERAL MUNICIPAL ELECTION - MEASURE QQ 9859 1900018A 13 72 85
250844 250844 NO 23518 DUARTE CITY GENERAL MUNICIPAL ELECTION - MEASURE QQ 9859 1900018A 21 49 70
258498 258498 YES 24240 COUNTY MEASURE G 9961 1900018A 21 63 84
258499 258499 NO 24241 COUNTY MEASURE G 9961 1900018A 12 54 66

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