results

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

66 rows where precinct_id = "0300001G"

✎ 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
13831 13831 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 0300001G 28 33 61
13832 13832 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 0300001G 12 30 42
17901 17901 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 0300001G 32 40 72
17902 17902 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 0300001G 0 0 0
17903 17903 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 0300001G 9 26 35
17904 17904 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 0300001G 0 2 2
17905 17905 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 0300001G 0 1 1
17906 17906 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 0300001G 0 0 0
50517 50517 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 0300001G 29 39 68
50518 50518 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 0300001G 12 25 37
58543 58543 YES 23601 STATE MEASURE 36 9874 0300001G 30 39 69
58544 58544 NO 23602 STATE MEASURE 36 9874 0300001G 11 21 32
67252 67252 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300001G 17 29 46
67253 67253 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0300001G 18 28 46
75560 75560 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 0300001G 26 52 78
75561 75561 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 0300001G 12 12 24
85554 85554 ABDALLAH S. FARRUKH 23783 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300001G 17 36 53
85555 85555 STEVEN HOFBAUER 23645 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300001G 14 20 34
85556 85556 KRISTINA S. HONG 23743 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300001G 23 38 61
85557 85557 JAWAD BERMANI 23675 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300001G 3 4 7
85558 85558 MATEO B. OLIVAREZ 23791 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 0300001G 15 27 42
87114 87114 YES 23584 STATE MEASURE 3 9867 0300001G 10 20 30
87115 87115 NO 23585 STATE MEASURE 3 9867 0300001G 31 45 76
95988 95988 YES 23917 LANCASTER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE LS 9896 0300001G 25 30 55
95989 95989 NO 23918 LANCASTER SCHOOL DISTRICT SPECIAL ELECTION - MEASURE LS 9896 0300001G 14 31 45
96136 96136 PAUL ANDRE MARSH 23404 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 0300001G 26 38 64
96137 96137 JUAN CARRILLO VENTURA 23403 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 0300001G 13 25 38
97688 97688 YES 23593 STATE MEASURE 33 9871 0300001G 12 14 26
97689 97689 NO 23594 STATE MEASURE 33 9871 0300001G 29 50 79
106174 106174 YES 23599 STATE MEASURE 35 9873 0300001G 25 35 60
106175 106175 NO 23600 STATE MEASURE 35 9873 0300001G 16 30 46
114810 114810 YES 23766 COUNTY MEASURE A 9880 0300001G 20 21 41
114811 114811 NO 23767 COUNTY MEASURE A 9880 0300001G 21 44 65
122890 122890 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0300001G 23 39 62
122891 122891 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0300001G 12 19 31
130686 130686 YES 23912 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 0300001G 24 33 57
130687 130687 NO 23913 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 0300001G 15 29 44
131302 131302 YES 23597 STATE MEASURE 34 9872 0300001G 22 29 51
131303 131303 NO 23598 STATE MEASURE 34 9872 0300001G 19 35 54
141524 141524 YES 23591 STATE MEASURE 32 9870 0300001G 23 24 47
141525 141525 NO 23592 STATE MEASURE 32 9870 0300001G 19 41 60
150426 150426 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0300001G 24 33 57
150427 150427 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0300001G 14 25 39
164886 164886 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0300001G 28 40 68
164887 164887 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0300001G 12 24 36
172986 172986 YES 23712 STATE MEASURE 2 9878 0300001G 22 24 46
172987 172987 NO 23713 STATE MEASURE 2 9878 0300001G 19 41 60
181694 181694 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0300001G 22 30 52
181695 181695 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0300001G 13 29 42
192352 192352 YES 23714 STATE MEASURE 4 9879 0300001G 20 28 48
192353 192353 NO 23715 STATE MEASURE 4 9879 0300001G 21 36 57
202228 202228 YES 23589 STATE MEASURE 6 9869 0300001G 16 29 45
202229 202229 NO 23590 STATE MEASURE 6 9869 0300001G 25 36 61
210204 210204 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0300001G 13 31 44
210205 210205 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0300001G 22 24 46
218200 218200 YES 23587 STATE MEASURE 5 9868 0300001G 16 22 38
218201 218201 NO 23588 STATE MEASURE 5 9868 0300001G 25 43 68
226799 226799 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0300001G 20 26 46
226800 226800 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0300001G 20 33 53
234652 234652 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 0300001G 30 38 68
234653 234653 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 0300001G 10 26 36
237765 237765 ROBERT DENNIS LUNDERGAN 24197 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 9472 0300001G 11 14 25
237766 237766 L. ROSEMARY MANN 23793 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 9472 0300001G 16 26 42
237767 237767 LAURA K. GILES 24094 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT Governing Board Member, Trustee Area No. 2 9472 0300001G 11 20 31
257430 257430 YES 24240 COUNTY MEASURE G 9961 0300001G 14 28 42
257431 257431 NO 24241 COUNTY MEASURE G 9961 0300001G 24 37 61

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