candidates

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

4 rows where contest_id = 8680

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21394 CHARLIE KLINAKIS Non Partisan LA PUENTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8680 2946
21395 RICARDO MARTINEZ Non Partisan LA PUENTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8680 1853
21396 VALERIE MUÑOZ Non Partisan LA PUENTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8680 2783
21398 AMADEO RODRIGUEZ Non Partisan LA PUENTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8680 1319

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