candidates

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

4 rows where contest_id = 9248

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23083 HERLINDA CHICO Non Partisan LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9248 3413
23085 DARYL SUPERNAW Non Partisan LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9248 6481
23087 GERRIE SCHIPSKE Non Partisan LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9248 2912
23088 AMRIT SINGH Non Partisan LONG BEACH CITY PRIMARY NOMINATING ELECTION Member of the City Council, 4th District 9248 572

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