results

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

61 rows where precinct_id = "0300020C"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contest_id, polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
13847 13847 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 0300020C 8 2 10
13848 13848 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 0300020C 1 4 5
17955 17955 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 0300020C 8 3 11
17956 17956 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 0300020C 0 0 0
17957 17957 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 0300020C 1 3 4
17958 17958 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 0300020C 0 0 0
17959 17959 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 0300020C 0 0 0
17960 17960 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 0300020C 0 0 0
50535 50535 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 0300020C 8 2 10
50536 50536 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 0300020C 1 3 4
58561 58561 YES 23601 STATE MEASURE 36 9874 0300020C 7 5 12
58562 58562 NO 23602 STATE MEASURE 36 9874 0300020C 1 1 2
67270 67270 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300020C 6 1 7
67271 67271 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300020C 1 3 4
75578 75578 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 0300020C 9 5 14
75579 75579 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 0300020C 0 0 0
85594 85594 ABDALLAH S. FARRUKH 23783 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300020C 6 2 8
85595 85595 STEVEN HOFBAUER 23645 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300020C 4 3 7
85596 85596 KRISTINA S. HONG 23743 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300020C 4 2 6
85597 85597 JAWAD BERMANI 23675 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300020C 0 0 0
85598 85598 MATEO B. OLIVAREZ 23791 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300020C 1 2 3
87132 87132 YES 23584 STATE MEASURE 3 9867 0300020C 1 4 5
87133 87133 NO 23585 STATE MEASURE 3 9867 0300020C 7 2 9
96152 96152 PAUL ANDRE MARSH 23404 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 0300020C 7 2 9
96153 96153 JUAN CARRILLO VENTURA 23403 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 0300020C 2 3 5
97706 97706 YES 23593 STATE MEASURE 33 9871 0300020C 1 4 5
97707 97707 NO 23594 STATE MEASURE 33 9871 0300020C 7 1 8
106192 106192 YES 23599 STATE MEASURE 35 9873 0300020C 2 5 7
106193 106193 NO 23600 STATE MEASURE 35 9873 0300020C 6 0 6
114828 114828 YES 23766 COUNTY MEASURE A 9880 0300020C 1 4 5
114829 114829 NO 23767 COUNTY MEASURE A 9880 0300020C 7 1 8
122908 122908 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0300020C 1 2 3
122909 122909 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0300020C 6 1 7
130704 130704 YES 23912 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 0300020C 6 6 12
130705 130705 NO 23913 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 0300020C 3 0 3
131320 131320 YES 23597 STATE MEASURE 34 9872 0300020C 6 4 10
131321 131321 NO 23598 STATE MEASURE 34 9872 0300020C 2 0 2
141542 141542 YES 23591 STATE MEASURE 32 9870 0300020C 1 3 4
141543 141543 NO 23592 STATE MEASURE 32 9870 0300020C 7 2 9
150444 150444 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0300020C 3 3 6
150445 150445 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0300020C 4 1 5
164904 164904 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0300020C 8 3 11
164905 164905 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0300020C 1 3 4
173004 173004 YES 23712 STATE MEASURE 2 9878 0300020C 1 5 6
173005 173005 NO 23713 STATE MEASURE 2 9878 0300020C 7 0 7
181712 181712 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0300020C 5 0 5
181713 181713 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0300020C 2 3 5
192370 192370 YES 23714 STATE MEASURE 4 9879 0300020C 2 5 7
192371 192371 NO 23715 STATE MEASURE 4 9879 0300020C 6 0 6
202246 202246 YES 23589 STATE MEASURE 6 9869 0300020C 1 4 5
202247 202247 NO 23590 STATE MEASURE 6 9869 0300020C 7 0 7
210222 210222 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0300020C 0 3 3
210223 210223 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0300020C 6 1 7
218218 218218 YES 23587 STATE MEASURE 5 9868 0300020C 1 4 5
218219 218219 NO 23588 STATE MEASURE 5 9868 0300020C 7 1 8
226817 226817 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0300020C 4 4 8
226818 226818 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0300020C 5 1 6
234670 234670 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 0300020C 8 2 10
234671 234671 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 0300020C 1 3 4
257448 257448 YES 24240 COUNTY MEASURE G 9961 0300020C 1 2 3
257449 257449 NO 24241 COUNTY MEASURE G 9961 0300020C 7 2 9

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