candidates

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

10 rows where contest_id = 9038

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
21978 SOFIA G. QUINONES Democratic MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 2080
22006 GENESIS CORONADO Democratic MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 2583
22023 DAVID GIRÓN Democratic MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 9184
22025 CARLOS J. LEÓN Democratic MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 2628
22082 ANTHONY LIBERTINO FANARA Democratic MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 992
22431 SHANNEL PITTMAN Green MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 1160
22528 JESSICA CALOZA Democratic MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 23391
22592 ARI RUIZ Democratic MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 5832
22661 FRANKY CARRILLO Democratic MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 20569
23111 STEPHEN SILLS Republican MEMBER OF THE STATE ASSEMBLY, 52nd District 9038 10082

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