results

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

57 rows where precinct_id = "0550019A"

✎ 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
3145 3145 YES 24143 AZUSA CITY GENERAL MUNICIPAL ELECTION - MEASURE ZZ 9927 0550019A 37 65 102
3146 3146 NO 24144 AZUSA CITY GENERAL MUNICIPAL ELECTION - MEASURE ZZ 9927 0550019A 7 11 18
18267 18267 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 0550019A 26 22 48
18268 18268 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 0550019A 2 0 2
18269 18269 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 0550019A 23 56 79
18270 18270 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 0550019A 0 1 1
18271 18271 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 0550019A 0 0 0
18272 18272 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 0550019A 1 1 2
50639 50639 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 0550019A 22 24 46
50640 50640 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 0550019A 23 54 77
58665 58665 YES 23601 STATE MEASURE 36 9874 0550019A 29 45 74
58666 58666 NO 23602 STATE MEASURE 36 9874 0550019A 15 35 50
66573 66573 JESSE AVILA 24254 AZUSA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, District 4 9774 0550019A 40 66 106
67374 67374 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0550019A 14 20 34
67375 67375 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 0550019A 24 51 75
75682 75682 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 0550019A 25 36 61
75683 75683 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 0550019A 20 32 52
87236 87236 YES 23584 STATE MEASURE 3 9867 0550019A 26 58 84
87237 87237 NO 23585 STATE MEASURE 3 9867 0550019A 20 24 44
94976 94976 YES 24127 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 0550019A 33 61 94
94977 94977 NO 24128 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 0550019A 10 18 28
97810 97810 YES 23593 STATE MEASURE 33 9871 0550019A 30 57 87
97811 97811 NO 23594 STATE MEASURE 33 9871 0550019A 15 26 41
106296 106296 YES 23599 STATE MEASURE 35 9873 0550019A 33 67 100
106297 106297 NO 23600 STATE MEASURE 35 9873 0550019A 11 14 25
114932 114932 YES 23766 COUNTY MEASURE A 9880 0550019A 31 58 89
114933 114933 NO 23767 COUNTY MEASURE A 9880 0550019A 14 23 37
123012 123012 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0550019A 24 45 69
123013 123013 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 0550019A 13 23 36
131424 131424 YES 23597 STATE MEASURE 34 9872 0550019A 25 33 58
131425 131425 NO 23598 STATE MEASURE 34 9872 0550019A 17 47 64
140210 140210 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 0550019A 22 15 37
140211 140211 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 0550019A 25 67 92
141646 141646 YES 23591 STATE MEASURE 32 9870 0550019A 30 59 89
141647 141647 NO 23592 STATE MEASURE 32 9870 0550019A 18 24 42
150548 150548 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0550019A 29 50 79
150549 150549 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 0550019A 10 22 32
162714 162714 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 0550019A 22 20 42
162715 162715 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 0550019A 25 60 85
165008 165008 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0550019A 21 22 43
165009 165009 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 0550019A 24 55 79
173108 173108 YES 23712 STATE MEASURE 2 9878 0550019A 33 65 98
173109 173109 NO 23713 STATE MEASURE 2 9878 0550019A 13 18 31
181816 181816 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0550019A 29 47 76
181817 181817 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 0550019A 9 20 29
192474 192474 YES 23714 STATE MEASURE 4 9879 0550019A 35 62 97
192475 192475 NO 23715 STATE MEASURE 4 9879 0550019A 11 21 32
202350 202350 YES 23589 STATE MEASURE 6 9869 0550019A 20 60 80
202351 202351 NO 23590 STATE MEASURE 6 9869 0550019A 23 21 44
210326 210326 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0550019A 22 41 63
210327 210327 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 0550019A 16 29 45
218322 218322 YES 23587 STATE MEASURE 5 9868 0550019A 30 52 82
218323 218323 NO 23588 STATE MEASURE 5 9868 0550019A 15 30 45
226873 226873 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0550019A 28 57 85
226874 226874 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 0550019A 15 20 35
257552 257552 YES 24240 COUNTY MEASURE G 9961 0550019A 28 47 75
257553 257553 NO 24241 COUNTY MEASURE G 9961 0550019A 15 26 41

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