candidates

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

3 rows where contest_id = 9049

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
22574 SHARON QUIRK-SILVA Democratic MEMBER OF THE STATE ASSEMBLY, 67th District 9049 6809
22917 JACOB WOO HO LEE Non Partisan MEMBER OF THE STATE ASSEMBLY, 67th District 9049 1099
23282 ELIZABETH "BETH" CULVER Republican MEMBER OF THE STATE ASSEMBLY, 67th District 9049 4697

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