candidates

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

5 rows where contest_id = 9443

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23645 STEVEN HOFBAUER Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 50382
23675 JAWAD BERMANI Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 8824
23743 KRISTINA S. HONG Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 69763
23783 ABDALLAH S. FARRUKH Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 70973
23791 MATEO B. OLIVAREZ Non Partisan ANTELOPE VALLEY HEALTH CARE DISTRICT Member, Board of Directors 9443 45073

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