candidates

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

4 rows where contest_id = 9779

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24365 ISABEL GUILLEN Non Partisan BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9779 3462
24366 GABI GOMEZ Non Partisan BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9779 2769
24367 MICHAEL REVELES Non Partisan BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9779 979
24369 JORGEL CHAVEZ Non Partisan BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9779 4455

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