candidates

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

3 rows where contest_id = 9831

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24450 GREG P. STEFFLRE Non Partisan CITY OF LA HABRA HEIGHTS GENERAL MUNICIPAL ELECTION Member of the City Council 9831 1477
24451 CAROL ENGELHARDT Non Partisan CITY OF LA HABRA HEIGHTS GENERAL MUNICIPAL ELECTION Member of the City Council 9831 1763
24452 CHRISTABELLE GARCIA Non Partisan CITY OF LA HABRA HEIGHTS GENERAL MUNICIPAL ELECTION Member of the City Council 9831 756

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