candidates

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

3 rows where contest_id = 8392

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
20861 NOEL LEE CHUN Non Partisan BEACH CITIES HEALTH DISTRICT Member, Board of Directors 8392 27199
21040 MICHELLE ANNE BHOLAT Non Partisan BEACH CITIES HEALTH DISTRICT Member, Board of Directors 8392 29273
21298 MICHAEL KELLY MARTIN Non Partisan BEACH CITIES HEALTH DISTRICT Member, Board of Directors 8392 7720

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