candidates

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

4 rows where contest_id = 9350

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23112 MARK E. HENDERSON Non Partisan GARDENA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9350 4592
23113 PAULETTE C. FRANCIS Non Partisan GARDENA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9350 3798
23114 AIMEE MIDORI YAMADA Non Partisan GARDENA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9350 2449
23115 ANTHONY DIXON Non Partisan GARDENA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9350 3268

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