results

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

56 rows where precinct_id = "3200004G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contest_id, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
15365 15365 SASHA RENÉE PÉREZ 23394 STATE SENATOR, 25th District 9502 3200004G 0 0 0
15366 15366 ELIZABETH WONG AHLERS 23393 STATE SENATOR, 25th District 9502 3200004G 0 4 4
23367 23367 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 3200004G 0 4 4
23368 23368 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 3200004G 0 0 0
23369 23369 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 3200004G 0 0 0
23370 23370 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 3200004G 0 0 0
23371 23371 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 3200004G 0 0 0
23372 23372 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 3200004G 0 0 0
52339 52339 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 3200004G 0 4 4
52340 52340 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 3200004G 0 0 0
60365 60365 YES 23601 STATE MEASURE 36 9874 3200004G 0 4 4
60366 60366 NO 23602 STATE MEASURE 36 9874 3200004G 0 0 0
69074 69074 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3200004G 0 0 0
69075 69075 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 3200004G 0 0 0
77382 77382 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 3200004G 0 4 4
77383 77383 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 3200004G 0 0 0
88936 88936 YES 23584 STATE MEASURE 3 9867 3200004G 0 0 0
88937 88937 NO 23585 STATE MEASURE 3 9867 3200004G 0 3 3
99510 99510 YES 23593 STATE MEASURE 33 9871 3200004G 0 0 0
99511 99511 NO 23594 STATE MEASURE 33 9871 3200004G 0 4 4
107996 107996 YES 23599 STATE MEASURE 35 9873 3200004G 0 0 0
107997 107997 NO 23600 STATE MEASURE 35 9873 3200004G 0 3 3
116632 116632 YES 23766 COUNTY MEASURE A 9880 3200004G 0 0 0
116633 116633 NO 23767 COUNTY MEASURE A 9880 3200004G 0 4 4
124712 124712 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3200004G 0 0 0
124713 124713 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 3200004G 0 0 0
133124 133124 YES 23597 STATE MEASURE 34 9872 3200004G 0 0 0
133125 133125 NO 23598 STATE MEASURE 34 9872 3200004G 0 3 3
139632 139632 JUDY CHU 23454 UNITED STATES REPRESENTATIVE, 28th District 9533 3200004G 0 0 0
139633 139633 APRIL A. VERLATO 23455 UNITED STATES REPRESENTATIVE, 28th District 9533 3200004G 0 4 4
143346 143346 YES 23591 STATE MEASURE 32 9870 3200004G 0 0 0
143347 143347 NO 23592 STATE MEASURE 32 9870 3200004G 0 4 4
152248 152248 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3200004G 0 0 0
152249 152249 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 3200004G 0 1 1
166708 166708 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3200004G 0 4 4
166709 166709 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 3200004G 0 0 0
174808 174808 YES 23712 STATE MEASURE 2 9878 3200004G 0 0 0
174809 174809 NO 23713 STATE MEASURE 2 9878 3200004G 0 4 4
183516 183516 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3200004G 0 0 0
183517 183517 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 3200004G 0 0 0
194174 194174 YES 23714 STATE MEASURE 4 9879 3200004G 0 0 0
194175 194175 NO 23715 STATE MEASURE 4 9879 3200004G 0 4 4
204050 204050 YES 23589 STATE MEASURE 6 9869 3200004G 0 3 3
204051 204051 NO 23590 STATE MEASURE 6 9869 3200004G 0 0 0
212026 212026 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3200004G 0 0 0
212027 212027 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 3200004G 0 0 0
220022 220022 YES 23587 STATE MEASURE 5 9868 3200004G 0 0 0
220023 220023 NO 23588 STATE MEASURE 5 9868 3200004G 0 4 4
228171 228171 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3200004G 0 0 0
228172 228172 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 3200004G 0 3 3
236124 236124 YES 24014 GLENDALE COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE GCC 9917 3200004G 0 0 0
236125 236125 NO 24015 GLENDALE COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE GCC 9917 3200004G 0 3 3
251084 251084 TONY RODRIGUEZ 23414 MEMBER OF THE STATE ASSEMBLY, 44th District 9512 3200004G 0 4 4
251085 251085 NICK SCHULTZ 23413 MEMBER OF THE STATE ASSEMBLY, 44th District 9512 3200004G 0 0 0
259252 259252 YES 24240 COUNTY MEASURE G 9961 3200004G 0 0 0
259253 259253 NO 24241 COUNTY MEASURE G 9961 3200004G 0 3 3

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