results

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

56 rows where precinct_id = "5500117A"

✎ 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
27375 27375 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 5500117A 40 35 75
27376 27376 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 5500117A 1 2 3
27377 27377 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 5500117A 26 78 104
27378 27378 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 5500117A 1 0 1
27379 27379 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 5500117A 0 0 0
27380 27380 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 5500117A 1 1 2
53675 53675 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 5500117A 42 31 73
53676 53676 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 5500117A 26 73 99
61701 61701 YES 23601 STATE MEASURE 36 9874 5500117A 55 69 124
61702 61702 NO 23602 STATE MEASURE 36 9874 5500117A 11 43 54
70410 70410 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 5500117A 28 49 77
70411 70411 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 5500117A 19 33 52
78718 78718 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 5500117A 50 80 130
78719 78719 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 5500117A 10 25 35
90272 90272 YES 23584 STATE MEASURE 3 9867 5500117A 27 69 96
90273 90273 NO 23585 STATE MEASURE 3 9867 5500117A 38 41 79
95400 95400 YES 24127 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 5500117A 32 61 93
95401 95401 NO 24128 MT. SAN ANTONIO COMMUNITY COLLEGE DISTRICT SPECIAL ELECTION - MEASURE V 9923 5500117A 30 47 77
100846 100846 YES 23593 STATE MEASURE 33 9871 5500117A 21 44 65
100847 100847 NO 23594 STATE MEASURE 33 9871 5500117A 43 69 112
109332 109332 YES 23599 STATE MEASURE 35 9873 5500117A 40 67 107
109333 109333 NO 23600 STATE MEASURE 35 9873 5500117A 25 44 69
117968 117968 YES 23766 COUNTY MEASURE A 9880 5500117A 27 50 77
117969 117969 NO 23767 COUNTY MEASURE A 9880 5500117A 35 60 95
126048 126048 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 5500117A 26 56 82
126049 126049 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 5500117A 21 27 48
134460 134460 YES 23597 STATE MEASURE 34 9872 5500117A 33 44 77
134461 134461 NO 23598 STATE MEASURE 34 9872 5500117A 29 67 96
140736 140736 DANIEL JOSE BOCIC MARTINEZ 23461 UNITED STATES REPRESENTATIVE, 31st District 9536 5500117A 39 29 68
140737 140737 GIL CISNEROS 23460 UNITED STATES REPRESENTATIVE, 31st District 9536 5500117A 27 79 106
144682 144682 YES 23591 STATE MEASURE 32 9870 5500117A 20 40 60
144683 144683 NO 23592 STATE MEASURE 32 9870 5500117A 46 71 117
153584 153584 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 5500117A 29 52 81
153585 153585 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 5500117A 22 31 53
163038 163038 DAN T. TRAN 23417 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 5500117A 36 35 71
163039 163039 BLANCA RUBIO 23418 MEMBER OF THE STATE ASSEMBLY, 48th District 9514 5500117A 31 71 102
168044 168044 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 5500117A 40 34 74
168045 168045 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 5500117A 28 73 101
176144 176144 YES 23712 STATE MEASURE 2 9878 5500117A 29 62 91
176145 176145 NO 23713 STATE MEASURE 2 9878 5500117A 36 49 85
184852 184852 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 5500117A 25 56 81
184853 184853 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 5500117A 21 29 50
195510 195510 YES 23714 STATE MEASURE 4 9879 5500117A 30 69 99
195511 195511 NO 23715 STATE MEASURE 4 9879 5500117A 33 44 77
205386 205386 YES 23589 STATE MEASURE 6 9869 5500117A 23 42 65
205387 205387 NO 23590 STATE MEASURE 6 9869 5500117A 42 64 106
213362 213362 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 5500117A 11 22 33
213363 213363 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 5500117A 35 59 94
221358 221358 YES 23587 STATE MEASURE 5 9868 5500117A 24 40 64
221359 221359 NO 23588 STATE MEASURE 5 9868 5500117A 38 69 107
229037 229037 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 5500117A 30 53 83
229038 229038 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 5500117A 31 53 84
250617 250617 MARIA M. CACERES 23891 COVINA-VALLEY UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 9575 5500117A 40 83 123
250618 250618 JASON COOK 24013 COVINA-VALLEY UNIFIED SCHOOL DISTRICT Governing Board Member, Trustee Area No. 5 9575 5500117A 23 21 44
260588 260588 YES 24240 COUNTY MEASURE G 9961 5500117A 27 37 64
260589 260589 NO 24241 COUNTY MEASURE G 9961 5500117A 33 70 103

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