candidates

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

4 rows where contest_id = 9013

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
22024 NORMA J. TORRES Democratic UNITED STATES REPRESENTATIVE, 35th District 9013 8012
23073 MIKE CARGILE Republican UNITED STATES REPRESENTATIVE, 35th District 9013 4148
23279 MELISSA MAY Democratic UNITED STATES REPRESENTATIVE, 35th District 9013 1891
23280 VIJAL SUTHAR Republican UNITED STATES REPRESENTATIVE, 35th District 9013 655

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