candidates

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

4 rows where contest_id = 9697

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24061 SHAUNNA ELIAS Non Partisan GLENDORA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 3rd District 9697 1641
24065 ERICA LANDMANN Non Partisan GLENDORA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 3rd District 9697 937
24070 DUSTIN SNYDER Non Partisan GLENDORA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 3rd District 9697 570
24075 JENNY CHAN Non Partisan GLENDORA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 3rd District 9697 1273

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