candidates

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

5 rows where contest_id = 9714

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24121 HAYLYNN CONRAD Non Partisan MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9714 2444
24123 C. CHANNING FRYKMAN Non Partisan MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9714 1478
24135 BRUCE LEE SILVERSTEIN Non Partisan MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9714 2943
24137 STEVE UHRING Non Partisan MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9714 2723
24142 PAUL GRISANTI Non Partisan MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9714 2291

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