candidates

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

3 rows where contest_id = 9042

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
21970 LISA CALDERON Democratic MEMBER OF THE STATE ASSEMBLY, 56th District 9042 38003
22597 JESSICA MARTINEZ Republican MEMBER OF THE STATE ASSEMBLY, 56th District 9042 21678
22884 NATASHA SERRANO Republican MEMBER OF THE STATE ASSEMBLY, 56th District 9042 7751

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