candidates

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

4 rows where contest_id = 9016

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
21976 ERIC J. CHING Republican UNITED STATES REPRESENTATIVE, 38th District 9016 24213
22019 ROBERT ZHANG OCHOA Republican UNITED STATES REPRESENTATIVE, 38th District 9016 7209
22169 LINDA T. SÁNCHEZ Democratic UNITED STATES REPRESENTATIVE, 38th District 9016 57436
22660 JOHN SAREGA Republican UNITED STATES REPRESENTATIVE, 38th District 9016 12101

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