candidates
Data source: Los Angeles County Registrar-Recorder/County Clerk
2 rows where contest_id = 8643
This data as json, CSV (advanced)
id ▼ | name | party | contest_id | total_votes |
---|---|---|---|---|
21541 | PETER S. YAO | Non Partisan | CLAREMONT CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8643 | 1109 |
21542 | ED REECE | Non Partisan | CLAREMONT CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 8643 | 1298 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [candidates] ( [id] INTEGER PRIMARY KEY, [name] TEXT, [party] TEXT, [contest_id] INTEGER REFERENCES [contests]([id]), [total_votes] INTEGER ); CREATE INDEX [idx_candidates_contest_id] ON [candidates] ([contest_id]);