results

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

8 rows where candidate_id = 21452

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
162578 162578 DAN REID 21452 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650001B 0 0 0
162583 162583 DAN REID 21452 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650002A 35 146 181
162588 162588 DAN REID 21452 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650004A 11 65 76
162593 162593 DAN REID 21452 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650005A 16 56 72
162598 162598 DAN REID 21452 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650006A 35 92 127
162603 162603 DAN REID 21452 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650011A 62 117 179
162608 162608 DAN REID 21452 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650015A 38 127 165
162613 162613 DAN REID 21452 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 3650018B 51 137 188

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