candidates

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

3 rows where contest_id = 9810

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24401 JOAQUIN BELTRAN Non Partisan CITY OF DOWNEY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 9810 9388
24402 RUDY SANDOVAL Non Partisan CITY OF DOWNEY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 9810 3939
24403 MARIO TRUJILLO Non Partisan CITY OF DOWNEY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 9810 24512

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