results

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

3 rows where candidate_id = 21542

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
191645 191645 ED REECE 21542 CLAREMONT CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8643 1300014C 84 375 459
191647 191647 ED REECE 21542 CLAREMONT CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8643 1300020A 22 100 122
191649 191649 ED REECE 21542 CLAREMONT CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8643 1300037C 166 551 717

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