candidates

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

8 rows where contest_id = 8391

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
20623 STEVE FOX Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 8391 14631
20670 MICHAEL P. RIVES Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 8391 16153
20760 DON V. PARAZO Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 8391 25456
20846 DODDANNA KRISHNA Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 8391 34862
20942 GORDON V. JEFFERSON Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 8391 3405
21051 JOHN BRYSON Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 8391 5588
21178 GETRO F. ELIZE Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 8391 7637
21277 OLLIE M. MCCAULLEY Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 8391 5791

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