candidates

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

3 rows where contest_id = 8562

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21379 KIMBERLY HUFF Non Partisan AZUSA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8562 2786
21380 EDWARD J. ALVAREZ Non Partisan AZUSA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8562 4208
21381 ANDREW N. MENDEZ Non Partisan AZUSA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8562 4945

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