candidates

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

5 rows where contest_id = 9020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
22850 MICHELLE STEEL Republican UNITED STATES REPRESENTATIVE, 45th District 9020 6170
23039 DEREK TRAN Democratic UNITED STATES REPRESENTATIVE, 45th District 9020 2352
23043 CHEYENNE HUNT Democratic UNITED STATES REPRESENTATIVE, 45th District 9020 1418
23055 KIM BERNICE NGUYEN-PENALOZA Democratic UNITED STATES REPRESENTATIVE, 45th District 9020 2167
23077 ADITYA PAI Democratic UNITED STATES REPRESENTATIVE, 45th District 9020 1378

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