candidates

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

5 rows where contest_id = 8590

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21784 TONY AYALA Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8590 7206
21785 LUIS NAVAS Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8590 4709
21786 PETRA PEÑA Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8590 5571
21787 JENNIFER PEREZ Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8590 7519
21788 DORA SANDOVAL Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8590 4367

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