candidates

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

5 rows where contest_id = 9012

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
22244 DAVID M. FERRELL Democratic UNITED STATES REPRESENTATIVE, 34th District 9012 2312
22255 DAVID KIM Democratic UNITED STATES REPRESENTATIVE, 34th District 9012 22703
22457 AARON REVELES Peace and Freedom UNITED STATES REPRESENTATIVE, 34th District 9012 3223
22546 CALVIN LEE Republican UNITED STATES REPRESENTATIVE, 34th District 9012 11495
22603 JIMMY GOMEZ Democratic UNITED STATES REPRESENTATIVE, 34th District 9012 41611

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