candidates

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

5 rows where contest_id = 9727

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24257 RICK RAMIREZ Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9727 13304
24258 MARGARITA L. RIOS Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9727 18191
24259 ANA VALENCIA Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9727 15936
24260 NICHOLAS GARCIA Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9727 9124
24261 BRYAN A. LOPEZ Non Partisan NORWALK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9727 7659

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