results

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

58 rows where precinct_id = "7410002A"

✎ 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
5366 5366 DAVID "LUCERO" HASTINGS 23526 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 7410002A 14 30 44
5367 5367 DAVID E. ARGUDO 24044 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 7410002A 14 42 56
5368 5368 WILLIAM R. ROJAS 23787 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 7410002A 18 53 71
5369 5369 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 7410002A 4 9 13
29949 29949 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 7410002A 22 37 59
29950 29950 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 7410002A 0 0 0
29951 29951 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 7410002A 21 67 88
29952 29952 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 7410002A 0 3 3
29953 29953 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 7410002A 0 0 0
29954 29954 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 7410002A 0 1 1
54533 54533 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 7410002A 22 31 53
54534 54534 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 7410002A 20 69 89
62559 62559 YES 23601 STATE MEASURE 36 9874 7410002A 27 80 107
62560 62560 NO 23602 STATE MEASURE 36 9874 7410002A 12 21 33
71268 71268 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7410002A 12 46 58
71269 71269 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 7410002A 22 44 66
79576 79576 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 7410002A 20 58 78
79577 79577 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 7410002A 17 41 58
91130 91130 YES 23584 STATE MEASURE 3 9867 7410002A 19 63 82
91131 91131 NO 23585 STATE MEASURE 3 9867 7410002A 20 39 59
95482 95482 YES 24127 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 7410002A 28 70 98
95483 95483 NO 24128 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 7410002A 10 32 42
101704 101704 YES 23593 STATE MEASURE 33 9871 7410002A 23 45 68
101705 101705 NO 23594 STATE MEASURE 33 9871 7410002A 14 54 68
110190 110190 YES 23599 STATE MEASURE 35 9873 7410002A 29 78 107
110191 110191 NO 23600 STATE MEASURE 35 9873 7410002A 10 21 31
118826 118826 YES 23766 COUNTY MEASURE A 9880 7410002A 28 59 87
118827 118827 NO 23767 COUNTY MEASURE A 9880 7410002A 11 44 55
126906 126906 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7410002A 22 61 83
126907 126907 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 7410002A 10 34 44
135318 135318 YES 23597 STATE MEASURE 34 9872 7410002A 20 48 68
135319 135319 NO 23598 STATE MEASURE 34 9872 7410002A 16 52 68
140784 140784 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 7410002A 16 34 50
140785 140785 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 7410002A 25 70 95
145540 145540 YES 23591 STATE MEASURE 32 9870 7410002A 28 54 82
145541 145541 NO 23592 STATE MEASURE 32 9870 7410002A 12 46 58
154442 154442 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7410002A 22 52 74
154443 154443 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 7410002A 11 37 48
163050 163050 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 7410002A 19 28 47
163051 163051 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 7410002A 21 77 98
168902 168902 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7410002A 22 30 52
168903 168903 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 7410002A 19 71 90
177002 177002 YES 23712 STATE MEASURE 2 9878 7410002A 29 63 92
177003 177003 NO 23713 STATE MEASURE 2 9878 7410002A 10 41 51
185710 185710 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7410002A 24 68 92
185711 185711 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 7410002A 8 26 34
196368 196368 YES 23714 STATE MEASURE 4 9879 7410002A 25 65 90
196369 196369 NO 23715 STATE MEASURE 4 9879 7410002A 14 37 51
206244 206244 YES 23589 STATE MEASURE 6 9869 7410002A 14 48 62
206245 206245 NO 23590 STATE MEASURE 6 9869 7410002A 23 55 78
214220 214220 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7410002A 14 33 47
214221 214221 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 7410002A 18 59 77
222216 222216 YES 23587 STATE MEASURE 5 9868 7410002A 20 48 68
222217 222217 NO 23588 STATE MEASURE 5 9868 7410002A 17 54 71
229687 229687 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 7410002A 27 63 90
229688 229688 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 7410002A 11 40 51
261446 261446 YES 24240 COUNTY MEASURE G 9961 7410002A 20 63 83
261447 261447 NO 24241 COUNTY MEASURE G 9961 7410002A 19 36 55

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