candidates

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

8 rows where contest_id = 9026

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
21986 LAMAR LYONS Democratic STATE SENATOR, 35th District 9026 3959
22204 MICHELLE CHAMBERS Democratic STATE SENATOR, 35th District 9026 23670
22219 JENNIFER TRICHELLE-MARIE WILLIAMS Democratic STATE SENATOR, 35th District 9026 5242
22713 LAURA RICHARDSON Democratic STATE SENATOR, 35th District 9026 26916
22715 ALEX MONTEIRO Democratic STATE SENATOR, 35th District 9026 5840
22851 NILO VEGA MICHELIN Democratic STATE SENATOR, 35th District 9026 4628
22902 ALBERT ROBLES Democratic STATE SENATOR, 35th District 9026 8263
22992 JAMES ARLANDUS SPENCER Republican STATE SENATOR, 35th District 9026 18193

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