candidates

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

4 rows where contest_id = 8621

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21667 RICHARD REYES Non Partisan WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 702
21668 FREDRICK SYKES Non Partisan WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 1816
21669 HOSSEIN RAMBOD SOTOODEH Non Partisan WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 172
21670 TONY WU Non Partisan WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 2033

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