results

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

5 rows where candidate_id = 24299

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
237753 237753 JIM KIRCHNER 24299 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9685 1900004C 15 36 51
237755 237755 JIM KIRCHNER 24299 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9685 1900024A 35 209 244
237757 237757 JIM KIRCHNER 24299 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9685 1900025A 42 88 130
237759 237759 JIM KIRCHNER 24299 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9685 9990317A 0 0 0
237761 237761 JIM KIRCHNER 24299 DUARTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9685 9990334A 0 0 0

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