candidates

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

5 rows where contest_id = 8615

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21579 MARC BAKERMAN Non Partisan WESTLAKE VILLAGE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8615 1277
21580 RAY PEARL Non Partisan WESTLAKE VILLAGE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8615 2229
21581 SUSAN MCSWEENEY Non Partisan WESTLAKE VILLAGE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8615 2290
21582 BRAD HALPERN Non Partisan WESTLAKE VILLAGE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8615 2716
21583 PAM JOHNSON Non Partisan WESTLAKE VILLAGE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8615 1056

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