candidates

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

4 rows where contest_id = 8560

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21612 ALI TAJ Non Partisan ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8560 1992
21613 ALMA L. GRIFFIN Non Partisan ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8560 812
21615 RENE J. TREVINO Non Partisan ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8560 1753
21618 MELISSA RAMOSO Non Partisan ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8560 2149

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