candidates

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

3 rows where contest_id = 9369

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23188 ELY DE LA CRUZ AYAO Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9369 2485
23189 IMELDA PADILLA Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9369 16476
23190 CARMENLINA MINASOVA Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 6th District 9369 2067

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