candidates

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

5 rows where contest_id = 9023

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
22001 ELIZABETH WONG AHLERS Republican STATE SENATOR, 25th District 9023 63247
22039 SASHA RENÉE PÉREZ Democratic STATE SENATOR, 25th District 9023 64665
22074 TEDDY CHOI Democratic STATE SENATOR, 25th District 9023 8500
22189 YVONNE YIU Democratic STATE SENATOR, 25th District 9023 33845
22456 SANDRA ARMENTA Democratic STATE SENATOR, 25th District 9023 18108

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