results

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

60 rows where precinct_id = "6220142A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contest_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
14385 14385 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 6220142A 52 86 138
14386 14386 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 6220142A 28 106 134
28377 28377 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 6220142A 61 82 143
28378 28378 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 6220142A 0 0 0
28379 28379 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 6220142A 22 111 133
28380 28380 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 6220142A 1 5 6
28381 28381 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 6220142A 0 0 0
28382 28382 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 6220142A 0 1 1
54009 54009 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 6220142A 57 84 141
54010 54010 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 6220142A 24 106 130
62035 62035 YES 23601 STATE MEASURE 36 9874 6220142A 64 137 201
62036 62036 NO 23602 STATE MEASURE 36 9874 6220142A 13 51 64
70744 70744 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 6220142A 26 85 111
70745 70745 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 6220142A 34 80 114
79052 79052 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 6220142A 61 130 191
79053 79053 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 6220142A 16 54 70
90606 90606 YES 23584 STATE MEASURE 3 9867 6220142A 31 102 133
90607 90607 NO 23585 STATE MEASURE 3 9867 6220142A 45 86 131
101180 101180 YES 23593 STATE MEASURE 33 9871 6220142A 26 76 102
101181 101181 NO 23594 STATE MEASURE 33 9871 6220142A 51 113 164
109666 109666 YES 23599 STATE MEASURE 35 9873 6220142A 41 118 159
109667 109667 NO 23600 STATE MEASURE 35 9873 6220142A 33 67 100
114527 114527 BRYCE JEPSEN 24184 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, District 1 9776 6220142A 11 42 53
114528 114528 PATSY AYALA 24185 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, District 1 9776 6220142A 20 64 84
114529 114529 TIM BURKHART 24183 SANTA CLARITA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, District 1 9776 6220142A 40 66 106
118302 118302 YES 23766 COUNTY MEASURE A 9880 6220142A 23 92 115
118303 118303 NO 23767 COUNTY MEASURE A 9880 6220142A 54 93 147
126382 126382 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 6220142A 35 82 117
126383 126383 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 6220142A 27 81 108
134794 134794 YES 23597 STATE MEASURE 34 9872 6220142A 36 97 133
134795 134795 NO 23598 STATE MEASURE 34 9872 6220142A 35 83 118
145016 145016 YES 23591 STATE MEASURE 32 9870 6220142A 18 88 106
145017 145017 NO 23592 STATE MEASURE 32 9870 6220142A 60 103 163
149756 149756 GARY MARTIN 23611 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 9801 6220142A 47 100 147
149757 149757 DAN MASNADA 23543 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 9801 6220142A 39 69 108
149758 149758 PAULA OLIVARES 24030 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 1 9801 6220142A 13 64 77
153918 153918 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 6220142A 39 106 145
153919 153919 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 6220142A 29 60 89
168378 168378 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 6220142A 60 87 147
168379 168379 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 6220142A 22 105 127
176478 176478 YES 23712 STATE MEASURE 2 9878 6220142A 29 95 124
176479 176479 NO 23713 STATE MEASURE 2 9878 6220142A 48 95 143
181018 181018 PATRICK LEE GIPSON 23405 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 6220142A 54 81 135
181019 181019 PILAR SCHIAVO 23406 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 6220142A 23 110 133
185186 185186 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 6220142A 31 92 123
185187 185187 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 6220142A 26 72 98
195844 195844 YES 23714 STATE MEASURE 4 9879 6220142A 32 100 132
195845 195845 NO 23715 STATE MEASURE 4 9879 6220142A 47 88 135
205720 205720 YES 23589 STATE MEASURE 6 9869 6220142A 25 86 111
205721 205721 NO 23590 STATE MEASURE 6 9869 6220142A 51 101 152
213696 213696 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 6220142A 22 45 67
213697 213697 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 6220142A 35 115 150
221692 221692 YES 23587 STATE MEASURE 5 9868 6220142A 22 83 105
221693 221693 NO 23588 STATE MEASURE 5 9868 6220142A 56 102 158
229307 229307 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 6220142A 27 74 101
229308 229308 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 6220142A 49 106 155
235220 235220 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 6220142A 56 89 145
235221 235221 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 6220142A 22 102 124
260922 260922 YES 24240 COUNTY MEASURE G 9961 6220142A 25 71 96
260923 260923 NO 24241 COUNTY MEASURE G 9961 6220142A 48 107 155

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