results

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

4 rows where candidate_id = 21399

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
16780 16780 MICHAEL KEMPS 21399 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8594 5050002A 194 789 983
16784 16784 MICHAEL KEMPS 21399 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8594 5050004A 141 644 785
16788 16788 MICHAEL KEMPS 21399 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8594 5050008A 241 1127 1368
16792 16792 MICHAEL KEMPS 21399 PALOS VERDES ESTATES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8594 5050012A 197 789 986

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