results

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

7 rows where candidate_id = 24105

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
3240 3240 STEVE RHEE 24105 ARCADIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9667 0350011A 29 54 83
3242 3242 STEVE RHEE 24105 ARCADIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9667 0350030A 73 195 268
3244 3244 STEVE RHEE 24105 ARCADIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9667 0350034A 183 533 716
3246 3246 STEVE RHEE 24105 ARCADIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9667 0350102B 31 75 106
3248 3248 STEVE RHEE 24105 ARCADIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9667 0350103A 0 0 0
3250 3250 STEVE RHEE 24105 ARCADIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9667 9990371A 0 0 0
3252 3252 STEVE RHEE 24105 ARCADIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 9667 9990378A 0 0 0

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