results

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

5 rows where candidate_id = 24468

✎ 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
158836 158836 ROBERT T. PARKHURST 24468 SIERRA MADRE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9745 6400008A 13 52 65
158838 158838 ROBERT T. PARKHURST 24468 SIERRA MADRE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9745 6400010A 396 1692 2088
158840 158840 ROBERT T. PARKHURST 24468 SIERRA MADRE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9745 6400013A 400 1697 2097
158842 158842 ROBERT T. PARKHURST 24468 SIERRA MADRE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9745 9990182A 0 0 0
158844 158844 ROBERT T. PARKHURST 24468 SIERRA MADRE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9745 9990197A 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]);