candidates

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

4 rows where contest_id = 9680

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24186 LEONARD MENDOZA Non Partisan COMMERCE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9680 1154
24187 HUGO ARGUMEDO Non Partisan COMMERCE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9680 2155
24188 ORALIA REBOLLO Non Partisan COMMERCE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9680 2524
24189 MICHAEL W. PRYOR Non Partisan COMMERCE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9680 531

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