candidates

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

3 rows where contest_id = 9037

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
22089 STEPHAN HOHIL Republican MEMBER OF THE STATE ASSEMBLY, 51st District 9037 10710
22239 SHIVA BAGHERI Republican MEMBER OF THE STATE ASSEMBLY, 51st District 9037 10610
22440 RICK CHAVEZ ZBUR Democratic MEMBER OF THE STATE ASSEMBLY, 51st District 9037 76838

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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