candidates

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

3 rows where contest_id = 9247

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23079 CINDY ALLEN Non Partisan LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 4587
23080 KETTY CITTERIO Non Partisan LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 3474
23081 SARA ZAIDI Non Partisan LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 2nd District 9247 421

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