candidates

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

8 rows where contest_id = 9033

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
22013 ELEN ASATRYAN Democratic MEMBER OF THE STATE ASSEMBLY, 44th District 9033 14692
22035 STEVE PIERSON Democratic MEMBER OF THE STATE ASSEMBLY, 44th District 9033 8508
22050 ADAM PRYOR Democratic MEMBER OF THE STATE ASSEMBLY, 44th District 9033 1566
22064 TONY RODRIGUEZ Republican MEMBER OF THE STATE ASSEMBLY, 44th District 9033 28280
22694 NICK SCHULTZ Democratic MEMBER OF THE STATE ASSEMBLY, 44th District 9033 31121
22874 ED HAN Democratic MEMBER OF THE STATE ASSEMBLY, 44th District 9033 17589
22918 CARMENITA HELLIGAR Democratic MEMBER OF THE STATE ASSEMBLY, 44th District 9033 6178
22926 ADAM SUMMER Non Partisan MEMBER OF THE STATE ASSEMBLY, 44th District 9033 2224

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