candidates

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

4 rows where contest_id = 9668

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24419 DAN ROCHA Non Partisan ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 2022
24420 WILLIAM MORANTE SR. Non Partisan ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 1695
24421 ZEEL AHIR Non Partisan ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 2174
24422 MONICA MANALO Non Partisan ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 2100

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