candidates

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

4 rows where contest_id = 9017

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
22313 JOHN BRISCOE Republican UNITED STATES REPRESENTATIVE, 42nd District 9017 30599
22642 J. NICOLE LOPEZ Democratic UNITED STATES REPRESENTATIVE, 42nd District 9017 8758
22894 ROBERT GARCIA Democratic UNITED STATES REPRESENTATIVE, 42nd District 9017 49891
23052 JOAQUÍN BELTRÁN Democratic UNITED STATES REPRESENTATIVE, 42nd District 9017 6532

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