candidates

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

4 rows where contest_id = 9005

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
21972 MICHAEL KOSLOW Republican UNITED STATES REPRESENTATIVE, 26th District 9005 4897
23017 JULIA BROWNLEY Democratic UNITED STATES REPRESENTATIVE, 26th District 9005 7811
23018 CHRIS ANSTEAD Democratic UNITED STATES REPRESENTATIVE, 26th District 9005 1158
23277 BRUCE BOYER Republican UNITED STATES REPRESENTATIVE, 26th District 9005 1117

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