results

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

4 rows where candidate_id = 21400

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
16778 16778 DAVID MCGOWAN 21400 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8594 5050002A 172 704 876
16782 16782 DAVID MCGOWAN 21400 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8594 5050004A 133 591 724
16786 16786 DAVID MCGOWAN 21400 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8594 5050008A 194 999 1193
16790 16790 DAVID MCGOWAN 21400 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8594 5050012A 180 685 865

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