candidates

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

4 rows where contest_id = 8571

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21503 LAURA MCCORKINDALE Non Partisan HIDDEN HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8571 568
21504 LARRY G. WEBER Non Partisan HIDDEN HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8571 354
21506 JOE LOGGIA Non Partisan HIDDEN HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8571 494
21507 BRET KATZ Non Partisan HIDDEN HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8571 348

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