results

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

7 rows where candidate_id = 21565

✎ 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
11898 11898 CHRIS ANSTEAD 21565 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080004A 98 501 599
11903 11903 CHRIS ANSTEAD 21565 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080012A 98 629 727
11908 11908 CHRIS ANSTEAD 21565 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080021A 109 656 765
11913 11913 CHRIS ANSTEAD 21565 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080025A 88 409 497
11918 11918 CHRIS ANSTEAD 21565 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080038A 74 296 370
11923 11923 CHRIS ANSTEAD 21565 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080043A 89 417 506
11928 11928 CHRIS ANSTEAD 21565 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080050A 113 565 678

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