results

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

59 rows where precinct_id = "6700007A"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contest_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
859 859 BLANCA PACHECO 23439 MEMBER OF THE STATE ASSEMBLY, 64th District 9525 6700007A 38 94 132
860 860 RAUL ORTIZ JR. 23440 MEMBER OF THE STATE ASSEMBLY, 64th District 9525 6700007A 55 55 110
16965 16965 JOHN PAUL DRAYER 23842 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 6700007A 32 49 81
16966 16966 VERA ROBLES DEWITT 23889 WATER REPLENISHMENT DISTRICT OF SOUTHERN CALIFORNIA Member, Board of Directors, Division 5 9475 6700007A 39 75 114
29295 29295 DONALD J. TRUMP 24470 PRESIDENT AND VICE PRESIDENT 9857 6700007A 59 65 124
29296 29296 CLAUDIA DE LA CRUZ 24474 PRESIDENT AND VICE PRESIDENT 9857 6700007A 3 0 3
29297 29297 KAMALA D. HARRIS 24469 PRESIDENT AND VICE PRESIDENT 9857 6700007A 33 95 128
29298 29298 ROBERT F. KENNEDY JR. 24471 PRESIDENT AND VICE PRESIDENT 9857 6700007A 1 2 3
29299 29299 CHASE OLIVER 24473 PRESIDENT AND VICE PRESIDENT 9857 6700007A 1 0 1
29300 29300 JILL STEIN 24472 PRESIDENT AND VICE PRESIDENT 9857 6700007A 1 0 1
54315 54315 STEVE GARVEY 23494 UNITED STATES SENATOR - Full Term 9553 6700007A 61 63 124
54316 54316 ADAM B. SCHIFF 23495 UNITED STATES SENATOR - Full Term 9553 6700007A 33 86 119
62341 62341 YES 23601 STATE MEASURE 36 9874 6700007A 67 119 186
62342 62342 NO 23602 STATE MEASURE 36 9874 6700007A 22 36 58
71050 71050 RENEE ROSE 23487 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 6700007A 43 72 115
71051 71051 ERICKA J. WILEY 23486 JUDGE OF THE SUPERIOR COURT Office No. 48 9549 6700007A 26 55 81
79358 79358 NATHAN HOCHMAN 23483 DISTRICT ATTORNEY 9547 6700007A 74 110 184
79359 79359 GEORGE GASCÓN 23482 DISTRICT ATTORNEY 9547 6700007A 16 36 52
90912 90912 YES 23584 STATE MEASURE 3 9867 6700007A 37 87 124
90913 90913 NO 23585 STATE MEASURE 3 9867 6700007A 54 67 121
101486 101486 YES 23593 STATE MEASURE 33 9871 6700007A 30 40 70
101487 101487 NO 23594 STATE MEASURE 33 9871 6700007A 57 110 167
109972 109972 YES 23599 STATE MEASURE 35 9873 6700007A 45 111 156
109973 109973 NO 23600 STATE MEASURE 35 9873 6700007A 42 44 86
118608 118608 YES 23766 COUNTY MEASURE A 9880 6700007A 32 77 109
118609 118609 NO 23767 COUNTY MEASURE A 9880 6700007A 55 79 134
126688 126688 LUZ E. HERRERA 23492 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 6700007A 41 62 103
126689 126689 TRACEY M. BLOUNT 23493 JUDGE OF THE SUPERIOR COURT Office No. 137 9552 6700007A 28 63 91
135100 135100 YES 23597 STATE MEASURE 34 9872 6700007A 52 80 132
135101 135101 NO 23598 STATE MEASURE 34 9872 6700007A 34 70 104
145322 145322 YES 23591 STATE MEASURE 32 9870 6700007A 33 64 97
145323 145323 NO 23592 STATE MEASURE 32 9870 6700007A 61 87 148
154224 154224 GEORGE A. TURNER JR. 23484 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 6700007A 35 61 96
154225 154225 STEVE NAPOLITANO 23485 JUDGE OF THE SUPERIOR COURT Office No. 39 9548 6700007A 38 66 104
164222 164222 ERIC J. CHING 23472 UNITED STATES REPRESENTATIVE, 38th District 9542 6700007A 56 58 114
164223 164223 LINDA T. SÁNCHEZ 23473 UNITED STATES REPRESENTATIVE, 38th District 9542 6700007A 38 91 129
168684 168684 STEVE GARVEY 23496 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 6700007A 60 66 126
168685 168685 ADAM B. SCHIFF 23497 UNITED STATES SENATOR - Short Term (Unexpired term ending January 3, 2025) 9554 6700007A 33 84 117
176784 176784 YES 23712 STATE MEASURE 2 9878 6700007A 44 89 133
176785 176785 NO 23713 STATE MEASURE 2 9878 6700007A 45 68 113
185492 185492 GEORGIA HUERTA 23490 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 6700007A 38 77 115
185493 185493 STEVEN YEE MAC 23491 JUDGE OF THE SUPERIOR COURT Office No. 135 9551 6700007A 28 48 76
196150 196150 YES 23714 STATE MEASURE 4 9879 6700007A 33 80 113
196151 196151 NO 23715 STATE MEASURE 4 9879 6700007A 54 74 128
206026 206026 YES 23589 STATE MEASURE 6 9869 6700007A 35 70 105
206027 206027 NO 23590 STATE MEASURE 6 9869 6700007A 53 74 127
214002 214002 LA SHAE HENDERSON 23488 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 6700007A 16 49 65
214003 214003 SHARON RANSOM 23489 JUDGE OF THE SUPERIOR COURT Office No. 97 9550 6700007A 55 75 130
221998 221998 YES 23587 STATE MEASURE 5 9868 6700007A 22 49 71
221999 221999 NO 23588 STATE MEASURE 5 9868 6700007A 69 102 171
229539 229539 YES 23768 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 6700007A 35 72 107
229540 229540 NO 23769 FIRE PROTECTION SPECIAL TAX MEASURE ELECTION - MEASURE E 9881 6700007A 52 71 123
253059 253059 FERNANDO ISLAS 23993 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 6700007A 3 11 14
253060 253060 LISSETH M. FLORES-FRANCO 24051 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 6700007A 6 21 27
253061 253061 GARY MENDEZ 23785 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 6700007A 23 52 75
253062 253062 JOSUE ALVARADO 24006 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 6700007A 6 6 12
253063 253063 MAX A. ORDONEZ 23716 CENTRAL BASIN MUNICIPAL WATER DISTRICT Member, Board of Directors, Division 2 9852 6700007A 30 27 57
261228 261228 YES 24240 COUNTY MEASURE G 9961 6700007A 33 61 94
261229 261229 NO 24241 COUNTY MEASURE G 9961 6700007A 48 81 129

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