candidates

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

5 rows where contest_id = 9053

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
22002 KONSTANTINE ANTHONY Non Partisan SUPERVISOR 5TH DISTRICT 9053 39801
22040 CHRIS HOLDEN Non Partisan SUPERVISOR 5TH DISTRICT 9053 76429
22565 KATHRYN BARGER Non Partisan SUPERVISOR 5TH DISTRICT 9053 198083
22770 PERRY GOLDBERG Non Partisan SUPERVISOR 5TH DISTRICT 9053 26588
22883 MARLON MARROQUIN Non Partisan SUPERVISOR 5TH DISTRICT 9053 7767

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