candidates

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

5 rows where contest_id = 9734

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24414 STEVE PERESTAM Non Partisan RANCHO PALOS VERDES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9734 7511
24415 GEORGE LEWIS Non Partisan RANCHO PALOS VERDES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9734 7469
24416 DAVID CHURA Non Partisan RANCHO PALOS VERDES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9734 7195
24417 JEFF CHEN Non Partisan RANCHO PALOS VERDES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9734 5941
24418 MICHELE PATRICK CARBONE Non Partisan RANCHO PALOS VERDES CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9734 3638

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