candidates
Data source: Los Angeles County Registrar-Recorder/County Clerk
2 rows where contest_id = 8743
This data as json, CSV (advanced)
id ▼ | name | party | contest_id | total_votes |
---|---|---|---|---|
20515 | SHARON QUIRK-SILVA | Democratic | MEMBER OF THE STATE ASSEMBLY, 67th District 8743 | 12075 |
20516 | SOO YOO | Republican | MEMBER OF THE STATE ASSEMBLY, 67th District 8743 | 9774 |
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]);