candidates

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

5 rows where contest_id = 9018

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
21958 CHRIS B. WIGGINS Democratic UNITED STATES REPRESENTATIVE, 43rd District 9018 4999
22116 STEVE WILLIAMS Republican UNITED STATES REPRESENTATIVE, 43rd District 9018 10896
22323 GREGORY EDWARD JACKSON CHEADLE Democratic UNITED STATES REPRESENTATIVE, 43rd District 9018 2075
22559 MAXINE WATERS Democratic UNITED STATES REPRESENTATIVE, 43rd District 9018 54673
22712 DAVID KNIGHT Republican UNITED STATES REPRESENTATIVE, 43rd District 9018 5647

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