results

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

70 rows where precinct_id = "2300001A"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
6645 6645 NANCY PEARLMAN 23533 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 2300001A 12 16 28
6646 6646 DAVID VELA 23624 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 2300001A 18 46 64
6647 6647 LOUIS ANTHONY SHAPIRO 23836 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 3 9854 2300001A 5 2 7
21699 21699 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 2300001A 11 16 27
21700 21700 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 2300001A 1 0 1
21701 21701 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 2300001A 31 55 86
21702 21702 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 2300001A 1 0 1
21703 21703 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 2300001A 0 0 0
21704 21704 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 2300001A 0 0 0
41493 41493 LAURA RICHARDSON 23400 STATE SENATOR, 35th District 9505 2300001A 24 30 54
41494 41494 MICHELLE CHAMBERS 23399 STATE SENATOR, 35th District 9505 2300001A 10 36 46
44294 44294 NICHELLE M. HENDERSON 23705 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 2300001A 20 39 59
44295 44295 ELAINE ALANIZ 23811 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 2300001A 10 14 24
44296 44296 JASON R. AULA 24020 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 5 9855 2300001A 2 9 11
51783 51783 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 2300001A 12 18 30
51784 51784 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 2300001A 27 46 73
59809 59809 YES 23601 STATE MEASURE 36 9874 2300001A 29 34 63
59810 59810 NO 23602 STATE MEASURE 36 9874 2300001A 8 37 45
68518 68518 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 2300001A 8 13 21
68519 68519 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 2300001A 25 52 77
76826 76826 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 2300001A 27 24 51
76827 76827 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 2300001A 13 40 53
88380 88380 YES 23584 STATE MEASURE 3 9867 2300001A 25 46 71
88381 88381 NO 23585 STATE MEASURE 3 9867 2300001A 12 23 35
98954 98954 YES 23593 STATE MEASURE 33 9871 2300001A 26 37 63
98955 98955 NO 23594 STATE MEASURE 33 9871 2300001A 14 29 43
107440 107440 YES 23599 STATE MEASURE 35 9873 2300001A 32 58 90
107441 107441 NO 23600 STATE MEASURE 35 9873 2300001A 6 15 21
116076 116076 YES 23766 COUNTY MEASURE A 9880 2300001A 29 52 81
116077 116077 NO 23767 COUNTY MEASURE A 9880 2300001A 7 15 22
124156 124156 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 2300001A 25 40 65
124157 124157 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 2300001A 8 22 30
132568 132568 YES 23597 STATE MEASURE 34 9872 2300001A 16 37 53
132569 132569 NO 23598 STATE MEASURE 34 9872 2300001A 21 30 51
142790 142790 YES 23591 STATE MEASURE 32 9870 2300001A 29 46 75
142791 142791 NO 23592 STATE MEASURE 32 9870 2300001A 9 23 32
151692 151692 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 2300001A 23 48 71
151693 151693 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 2300001A 11 17 28
158998 158998 YES 24232 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 2300001A 21 46 67
158999 158999 NO 24233 LOS ANGELES CITY GENERAL MUNICIPAL ELECTION - MEASURE LL 9959 2300001A 14 19 33
162036 162036 SADE ELHAWARY 23433 MEMBER OF THE STATE ASSEMBLY, 57th District 9522 2300001A 17 35 52
162037 162037 EFREN MARTINEZ 23434 MEMBER OF THE STATE ASSEMBLY, 57th District 9522 2300001A 19 29 48
166152 166152 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 2300001A 12 19 31
166153 166153 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 2300001A 26 45 71
174252 174252 YES 23712 STATE MEASURE 2 9878 2300001A 31 47 78
174253 174253 NO 23713 STATE MEASURE 2 9878 2300001A 8 20 28
182960 182960 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 2300001A 26 43 69
182961 182961 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 2300001A 6 20 26
193618 193618 YES 23714 STATE MEASURE 4 9879 2300001A 34 56 90
193619 193619 NO 23715 STATE MEASURE 4 9879 2300001A 4 11 15
203494 203494 YES 23589 STATE MEASURE 6 9869 2300001A 21 46 67
203495 203495 NO 23590 STATE MEASURE 6 9869 2300001A 15 20 35
211470 211470 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 2300001A 12 29 41
211471 211471 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 2300001A 20 36 56
219466 219466 YES 23587 STATE MEASURE 5 9868 2300001A 28 44 72
219467 219467 NO 23588 STATE MEASURE 5 9868 2300001A 10 20 30
227703 227703 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 2300001A 25 53 78
227704 227704 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 2300001A 11 10 21
238679 238679 KELSEY IINO 23603 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 2300001A 24 48 72
238680 238680 ROBERT PAYNE 23554 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 7 9856 2300001A 7 14 21
242745 242745 BALTAZAR FEDALIZO 23870 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 2300001A 3 1 4
242746 242746 ANDRA HOFFMAN 23559 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 2300001A 17 50 67
242747 242747 PETER V. MANGHERA 23969 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 2300001A 11 5 16
242748 242748 CHEYENNE SIMS 24038 LOS ANGELES COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees, Seat 1 9853 2300001A 2 6 8
248285 248285 YES 24230 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 2300001A 31 65 96
248286 248286 NO 24231 LOS ANGELES UNIFIED SCHOOL DISTRICT GENERAL ELECTION - MEASURE US 9958 2300001A 6 6 12
252279 252279 ROBERT GARCIA 23474 UNITED STATES REPRESENTATIVE, 42nd District 9543 2300001A 29 54 83
252280 252280 JOHN BRISCOE 23475 UNITED STATES REPRESENTATIVE, 42nd District 9543 2300001A 8 12 20
258696 258696 YES 24240 COUNTY MEASURE G 9961 2300001A 25 35 60
258697 258697 NO 24241 COUNTY MEASURE G 9961 2300001A 12 30 42

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