candidates

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

8 rows where contest_id = 9373

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23201 GENNY GUERRERO Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 14th District 9373 1457
23202 TERESA Y. HILLERY Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 14th District 9373 1519
23203 YSABEL J. JURADO Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 14th District 9373 8618
23204 WENDY CARRILLO Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 14th District 9373 5321
23205 EDUARDO "LALO" VARGAS Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 14th District 9373 1638
23206 MIGUEL SANTIAGO Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 14th District 9373 7470
23207 KEVIN DE LEÓN Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 14th District 9373 8220
23208 NADINE M. DIAZ Non Partisan LOS ANGELES CITY PRIMARY NOMINATING ELECTION Member of the City Council, 14th District 9373 904

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