candidates

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

5 rows where contest_id = 9022

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
21979 JAMES "DJ" HAMBURGER Republican STATE SENATOR, 23rd District 9022 25825
21983 OLLIE M. MCCAULLEY Democratic STATE SENATOR, 23rd District 9022 5768
22055 SUZETTE MARTINEZ VALLADARES Republican STATE SENATOR, 23rd District 9022 40972
22060 KIPP MUELLER Democratic STATE SENATOR, 23rd District 9022 36781
23275 BLANCA AZUCENA GOMEZ Democratic STATE SENATOR, 23rd District 9022 10481

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