candidates

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

5 rows where contest_id = 9039

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

id ▼ name party contest_id total_votes
22027 ROBERT S. TORRES Democratic MEMBER OF THE STATE ASSEMBLY, 53rd District 9039 3040
22653 CARLOS GOYTIA Democratic MEMBER OF THE STATE ASSEMBLY, 53rd District 9039 1410
22684 MICHELLE RODRIGUEZ Democratic MEMBER OF THE STATE ASSEMBLY, 53rd District 9039 3447
22913 JAVIER HERNANDEZ Democratic MEMBER OF THE STATE ASSEMBLY, 53rd District 9039 2447
23009 NICK WILSON Republican MEMBER OF THE STATE ASSEMBLY, 53rd District 9039 4691

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