results

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

61 rows where precinct_id = "1770019D"

✎ 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
14023 14023 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 1770019D 43 86 129
14024 14024 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 1770019D 21 91 112
20697 20697 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 1770019D 47 78 125
20698 20698 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 1770019D 0 1 1
20699 20699 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 1770019D 18 98 116
20700 20700 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 1770019D 0 2 2
20701 20701 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 1770019D 0 1 1
20702 20702 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 1770019D 0 1 1
51449 51449 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 1770019D 44 91 135
51450 51450 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 1770019D 21 83 104
59475 59475 YES 23601 STATE MEASURE 36 9874 1770019D 45 133 178
59476 59476 NO 23602 STATE MEASURE 36 9874 1770019D 18 38 56
68184 68184 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1770019D 32 68 100
68185 68185 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 1770019D 23 72 95
76492 76492 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 1770019D 45 126 171
76493 76493 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 1770019D 15 44 59
85734 85734 ABDALLAH S. FARRUKH 23783 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770019D 34 99 133
85735 85735 STEVEN HOFBAUER 23645 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770019D 27 68 95
85736 85736 KRISTINA S. HONG 23743 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770019D 36 103 139
85737 85737 JAWAD BERMANI 23675 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770019D 4 16 20
85738 85738 MATEO B. OLIVAREZ 23791 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 1770019D 21 62 83
88046 88046 YES 23584 STATE MEASURE 3 9867 1770019D 21 83 104
88047 88047 NO 23585 STATE MEASURE 3 9867 1770019D 41 94 135
96168 96168 PAUL ANDRE MARSH 23404 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 1770019D 43 72 115
96169 96169 JUAN CARRILLO VENTURA 23403 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 1770019D 19 94 113
98620 98620 YES 23593 STATE MEASURE 33 9871 1770019D 25 62 87
98621 98621 NO 23594 STATE MEASURE 33 9871 1770019D 37 113 150
107106 107106 YES 23599 STATE MEASURE 35 9873 1770019D 22 102 124
107107 107107 NO 23600 STATE MEASURE 35 9873 1770019D 40 78 118
115742 115742 YES 23766 COUNTY MEASURE A 9880 1770019D 19 76 95
115743 115743 NO 23767 COUNTY MEASURE A 9880 1770019D 41 101 142
123822 123822 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1770019D 26 72 98
123823 123823 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 1770019D 27 60 87
130752 130752 YES 23912 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 1770019D 30 100 130
130753 130753 NO 23913 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 1770019D 31 71 102
132234 132234 YES 23597 STATE MEASURE 34 9872 1770019D 36 74 110
132235 132235 NO 23598 STATE MEASURE 34 9872 1770019D 25 98 123
142456 142456 YES 23591 STATE MEASURE 32 9870 1770019D 22 76 98
142457 142457 NO 23592 STATE MEASURE 32 9870 1770019D 41 102 143
151358 151358 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1770019D 32 82 114
151359 151359 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 1770019D 24 66 90
165818 165818 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1770019D 44 90 134
165819 165819 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 1770019D 21 87 108
173918 173918 YES 23712 STATE MEASURE 2 9878 1770019D 22 84 106
173919 173919 NO 23713 STATE MEASURE 2 9878 1770019D 41 94 135
182626 182626 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1770019D 33 67 100
182627 182627 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 1770019D 21 60 81
193284 193284 YES 23714 STATE MEASURE 4 9879 1770019D 26 79 105
193285 193285 NO 23715 STATE MEASURE 4 9879 1770019D 36 98 134
203160 203160 YES 23589 STATE MEASURE 6 9869 1770019D 18 65 83
203161 203161 NO 23590 STATE MEASURE 6 9869 1770019D 44 108 152
211136 211136 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1770019D 15 49 64
211137 211137 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 1770019D 36 87 123
219132 219132 YES 23587 STATE MEASURE 5 9868 1770019D 17 68 85
219133 219133 NO 23588 STATE MEASURE 5 9868 1770019D 46 109 155
227461 227461 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1770019D 26 73 99
227462 227462 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 1770019D 31 90 121
234840 234840 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 1770019D 47 90 137
234841 234841 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 1770019D 15 82 97
258362 258362 YES 24240 COUNTY MEASURE G 9961 1770019D 21 65 86
258363 258363 NO 24241 COUNTY MEASURE G 9961 1770019D 38 109 147

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