results

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

61 rows where precinct_id = "3700004A"

✎ 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
14109 14109 MIKE GARCIA 23452 UNITED STATES REPRESENTATIVE, 27th District 9532 3700004A 1 6 7
14110 14110 GEORGE WHITESIDES 23453 UNITED STATES REPRESENTATIVE, 27th District 9532 3700004A 2 7 9
24237 24237 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 3700004A 3 7 10
24238 24238 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 3700004A 0 0 0
24239 24239 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 3700004A 1 6 7
24240 24240 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 3700004A 0 1 1
24241 24241 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 3700004A 0 0 0
24242 24242 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 3700004A 0 0 0
52629 52629 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 3700004A 2 5 7
52630 52630 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 3700004A 1 8 9
60655 60655 YES 23601 STATE MEASURE 36 9874 3700004A 1 10 11
60656 60656 NO 23602 STATE MEASURE 36 9874 3700004A 2 3 5
69364 69364 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3700004A 1 2 3
69365 69365 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3700004A 1 8 9
77672 77672 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 3700004A 2 8 10
77673 77673 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 3700004A 0 4 4
85949 85949 ABDALLAH S. FARRUKH 23783 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700004A 3 9 12
85950 85950 STEVEN HOFBAUER 23645 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700004A 0 5 5
85951 85951 KRISTINA S. HONG 23743 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700004A 1 3 4
85952 85952 JAWAD BERMANI 23675 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700004A 0 0 0
85953 85953 MATEO B. OLIVAREZ 23791 ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 3700004A 2 6 8
89226 89226 YES 23584 STATE MEASURE 3 9867 3700004A 1 9 10
89227 89227 NO 23585 STATE MEASURE 3 9867 3700004A 2 5 7
96218 96218 PAUL ANDRE MARSH 23404 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 3700004A 2 5 7
96219 96219 JUAN CARRILLO VENTURA 23403 MEMBER OF THE STATE ASSEMBLY, 39th District 9507 3700004A 1 7 8
99800 99800 YES 23593 STATE MEASURE 33 9871 3700004A 2 7 9
99801 99801 NO 23594 STATE MEASURE 33 9871 3700004A 1 7 8
108286 108286 YES 23599 STATE MEASURE 35 9873 3700004A 3 9 12
108287 108287 NO 23600 STATE MEASURE 35 9873 3700004A 0 4 4
116922 116922 YES 23766 COUNTY MEASURE A 9880 3700004A 2 9 11
116923 116923 NO 23767 COUNTY MEASURE A 9880 3700004A 1 5 6
125002 125002 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3700004A 1 7 8
125003 125003 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3700004A 1 5 6
130840 130840 YES 23912 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 3700004A 3 12 15
130841 130841 NO 23913 ANTELOPE VALLEY JOINT UNION HIGH SCHOOL DISTRICT SPECIAL ELECTION - MEASURE AVH 9894 3700004A 0 1 1
133414 133414 YES 23597 STATE MEASURE 34 9872 3700004A 1 9 10
133415 133415 NO 23598 STATE MEASURE 34 9872 3700004A 2 5 7
143636 143636 YES 23591 STATE MEASURE 32 9870 3700004A 2 7 9
143637 143637 NO 23592 STATE MEASURE 32 9870 3700004A 1 7 8
152538 152538 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3700004A 1 7 8
152539 152539 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3700004A 1 5 6
166998 166998 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3700004A 2 6 8
166999 166999 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3700004A 1 7 8
175098 175098 YES 23712 STATE MEASURE 2 9878 3700004A 2 8 10
175099 175099 NO 23713 STATE MEASURE 2 9878 3700004A 1 5 6
183806 183806 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3700004A 1 6 7
183807 183807 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3700004A 1 6 7
194464 194464 YES 23714 STATE MEASURE 4 9879 3700004A 2 8 10
194465 194465 NO 23715 STATE MEASURE 4 9879 3700004A 1 6 7
204340 204340 YES 23589 STATE MEASURE 6 9869 3700004A 2 7 9
204341 204341 NO 23590 STATE MEASURE 6 9869 3700004A 1 6 7
212316 212316 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3700004A 2 6 8
212317 212317 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3700004A 0 6 6
220312 220312 YES 23587 STATE MEASURE 5 9868 3700004A 2 9 11
220313 220313 NO 23588 STATE MEASURE 5 9868 3700004A 1 5 6
228431 228431 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3700004A 1 10 11
228432 228432 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3700004A 1 3 4
234930 234930 SUZETTE MARTINEZ VALLADARES 23391 STATE SENATOR, 23rd District 9501 3700004A 2 6 8
234931 234931 KIPP MUELLER 23392 STATE SENATOR, 23rd District 9501 3700004A 1 7 8
259542 259542 YES 24240 COUNTY MEASURE G 9961 3700004A 3 6 9
259543 259543 NO 24241 COUNTY MEASURE G 9961 3700004A 0 7 7

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