results

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

62 rows where precinct_id = "2930019A"

✎ 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
5346 5346 DAVID "LUCERO" HASTINGS 23526 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 2930019A 0 5 5
5347 5347 DAVID E. ARGUDO 24044 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 2930019A 1 1 2
5348 5348 WILLIAM R. ROJAS 23787 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 2930019A 2 3 5
5349 5349 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 2930019A 1 1 2
22947 22947 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 2930019A 2 2 4
22948 22948 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 2930019A 0 0 0
22949 22949 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 2930019A 0 3 3
22950 22950 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 2930019A 0 0 0
22951 22951 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 2930019A 0 0 0
22952 22952 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 2930019A 0 0 0
52199 52199 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 2930019A 2 2 4
52200 52200 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 2930019A 0 3 3
60225 60225 YES 23601 STATE MEASURE 36 9874 2930019A 2 2 4
60226 60226 NO 23602 STATE MEASURE 36 9874 2930019A 0 3 3
68934 68934 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 2930019A 2 1 3
68935 68935 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 2930019A 0 4 4
77242 77242 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 2930019A 2 3 5
77243 77243 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 2930019A 0 2 2
88796 88796 YES 23584 STATE MEASURE 3 9867 2930019A 0 4 4
88797 88797 NO 23585 STATE MEASURE 3 9867 2930019A 2 1 3
95188 95188 YES 24127 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 2930019A 0 3 3
95189 95189 NO 24128 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 2930019A 2 2 4
95956 95956 ADRIANA QUINONES 23540 HACIENDA LA PUENTE UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 3 9598 2930019A 0 2 2
95957 95957 CHRISTINE HELEN SALAZAR 23719 HACIENDA LA PUENTE UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 3 9598 2930019A 2 3 5
99370 99370 YES 23593 STATE MEASURE 33 9871 2930019A 0 2 2
99371 99371 NO 23594 STATE MEASURE 33 9871 2930019A 2 3 5
107856 107856 YES 23599 STATE MEASURE 35 9873 2930019A 0 1 1
107857 107857 NO 23600 STATE MEASURE 35 9873 2930019A 2 4 6
116492 116492 YES 23766 COUNTY MEASURE A 9880 2930019A 0 2 2
116493 116493 NO 23767 COUNTY MEASURE A 9880 2930019A 2 3 5
124572 124572 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 2930019A 1 2 3
124573 124573 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 2930019A 1 3 4
132984 132984 YES 23597 STATE MEASURE 34 9872 2930019A 1 3 4
132985 132985 NO 23598 STATE MEASURE 34 9872 2930019A 1 2 3
140570 140570 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 2930019A 2 2 4
140571 140571 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 2930019A 0 3 3
143206 143206 YES 23591 STATE MEASURE 32 9870 2930019A 0 1 1
143207 143207 NO 23592 STATE MEASURE 32 9870 2930019A 2 4 6
152108 152108 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 2930019A 0 3 3
152109 152109 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 2930019A 2 2 4
161946 161946 JAY CHEN 23808 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 9623 2930019A 2 2 4
161947 161947 JOSEPH K. CHANG 23725 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT Governing Board Member, Trustee Area No. 5 9623 2930019A 0 2 2
166568 166568 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 2930019A 2 2 4
166569 166569 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 2930019A 0 3 3
174668 174668 YES 23712 STATE MEASURE 2 9878 2930019A 0 3 3
174669 174669 NO 23713 STATE MEASURE 2 9878 2930019A 2 2 4
183376 183376 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 2930019A 1 3 4
183377 183377 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 2930019A 1 2 3
194034 194034 YES 23714 STATE MEASURE 4 9879 2930019A 0 3 3
194035 194035 NO 23715 STATE MEASURE 4 9879 2930019A 2 2 4
203910 203910 YES 23589 STATE MEASURE 6 9869 2930019A 1 0 1
203911 203911 NO 23590 STATE MEASURE 6 9869 2930019A 1 5 6
211886 211886 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 2930019A 0 1 1
211887 211887 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 2930019A 2 3 5
219882 219882 YES 23587 STATE MEASURE 5 9868 2930019A 0 1 1
219883 219883 NO 23588 STATE MEASURE 5 9868 2930019A 2 4 6
228031 228031 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 2930019A 0 3 3
228032 228032 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 2930019A 2 2 4
253980 253980 JESSICA MARTINEZ 23432 MEMBER OF THE STATE ASSEMBLY, 56th District 9521 2930019A 1 2 3
253981 253981 LISA CALDERON 23431 MEMBER OF THE STATE ASSEMBLY, 56th District 9521 2930019A 1 3 4
259112 259112 YES 24240 COUNTY MEASURE G 9961 2930019A 0 1 1
259113 259113 NO 24241 COUNTY MEASURE G 9961 2930019A 2 4 6

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