candidates

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

5 rows where contest_id = 8567

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21704 EDWARD ALBRECHT Non Partisan CALABASAS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8567 2954
21705 JAMES R. BOZAJIAN Non Partisan CALABASAS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8567 5888
21706 BRIAN CAMERON Non Partisan CALABASAS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8567 2636
21707 JASJEET (MONICA) KAUR PARMAR Non Partisan CALABASAS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8567 2832
21708 DAVID J. SHAPIRO Non Partisan CALABASAS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8567 5622

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