results

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

63 rows where precinct_id = "6220202A"

✎ 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
14429 14429 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 6220202A 29 50 79
14430 14430 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 6220202A 14 77 91
28509 28509 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 6220202A 27 49 76
28510 28510 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 6220202A 0 0 0
28511 28511 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 6220202A 15 81 96
28512 28512 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 6220202A 0 2 2
28513 28513 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 6220202A 0 0 0
28514 28514 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 6220202A 0 0 0
54053 54053 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 6220202A 28 51 79
54054 54054 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 6220202A 15 78 93
62079 62079 YES 23601 STATE MEASURE 36 9874 6220202A 32 80 112
62080 62080 NO 23602 STATE MEASURE 36 9874 6220202A 7 38 45
70788 70788 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 6220202A 30 48 78
70789 70789 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 6220202A 10 45 55
79096 79096 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 6220202A 34 83 117
79097 79097 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 6220202A 8 39 47
90650 90650 YES 23584 STATE MEASURE 3 9867 6220202A 12 66 78
90651 90651 NO 23585 STATE MEASURE 3 9867 6220202A 26 56 82
101224 101224 YES 23593 STATE MEASURE 33 9871 6220202A 16 34 50
101225 101225 NO 23594 STATE MEASURE 33 9871 6220202A 21 86 107
109710 109710 YES 23599 STATE MEASURE 35 9873 6220202A 13 68 81
109711 109711 NO 23600 STATE MEASURE 35 9873 6220202A 24 55 79
118346 118346 YES 23766 COUNTY MEASURE A 9880 6220202A 14 48 62
118347 118347 NO 23767 COUNTY MEASURE A 9880 6220202A 26 72 98
126426 126426 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 6220202A 12 26 38
126427 126427 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 6220202A 25 68 93
134838 134838 YES 23597 STATE MEASURE 34 9872 6220202A 23 51 74
134839 134839 NO 23598 STATE MEASURE 34 9872 6220202A 16 61 77
145060 145060 YES 23591 STATE MEASURE 32 9870 6220202A 15 53 68
145061 145061 NO 23592 STATE MEASURE 32 9870 6220202A 24 69 93
153962 153962 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 6220202A 15 46 61
153963 153963 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 6220202A 26 51 77
158306 158306 STACY FORTNER 23804 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Two-Year Term 9864 6220202A 9 41 50
158307 158307 KENNETH "KEN" PETERSEN 23744 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Two-Year Term 9864 6220202A 30 75 105
168422 168422 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 6220202A 28 54 82
168423 168423 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 6220202A 15 77 92
176522 176522 YES 23712 STATE MEASURE 2 9878 6220202A 12 57 69
176523 176523 NO 23713 STATE MEASURE 2 9878 6220202A 27 68 95
181062 181062 PATRICK LEE GIPSON 23405 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 6220202A 28 53 81
181063 181063 PILAR SCHIAVO 23406 MEMBER OF THE STATE ASSEMBLY, 40th District 9508 6220202A 13 74 87
185230 185230 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 6220202A 15 43 58
185231 185231 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 6220202A 24 51 75
195888 195888 YES 23714 STATE MEASURE 4 9879 6220202A 12 55 67
195889 195889 NO 23715 STATE MEASURE 4 9879 6220202A 27 67 94
205764 205764 YES 23589 STATE MEASURE 6 9869 6220202A 11 56 67
205765 205765 NO 23590 STATE MEASURE 6 9869 6220202A 27 65 92
213740 213740 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 6220202A 6 27 33
213741 213741 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 6220202A 34 70 104
221736 221736 YES 23587 STATE MEASURE 5 9868 6220202A 7 43 50
221737 221737 NO 23588 STATE MEASURE 5 9868 6220202A 32 79 111
229351 229351 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 6220202A 11 39 50
229352 229352 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 6220202A 28 77 105
235264 235264 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 6220202A 28 61 89
235265 235265 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 6220202A 14 67 81
237919 237919 EDEL ALONSO 23571 SANTA CLARITA COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Trustee Area 2 9638 6220202A 10 70 80
237920 237920 SCOTT SCHAUER 23964 SANTA CLARITA COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Trustee Area 2 9638 6220202A 29 46 75
251466 251466 KATHYE ARMITAGE 23653 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Full Term 9803 6220202A 14 75 89
251467 251467 HOLLY SCHROEDER 23734 SANTA CLARITA VALLEY WATER AGENCY Member, Board of Directors, Division 3 - Full Term 9803 6220202A 26 42 68
256860 256860 GLORIA MERCADO-FORTINE 24010 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9658 6220202A 2 21 23
256861 256861 AAKASH AHUJA 23810 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9658 6220202A 20 47 67
256862 256862 LINDA HOVIS STORLI 23694 WILLIAM S. HART UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 1 9658 6220202A 18 45 63
260966 260966 YES 24240 COUNTY MEASURE G 9961 6220202A 12 36 48
260967 260967 NO 24241 COUNTY MEASURE G 9961 6220202A 25 80 105

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