candidates

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

5 rows where contest_id = 9430

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: total_votes

id ▼ name party contest_id total_votes
23957 DAN GOULD Non Partisan WRIGHTWOOD COMMUNITY SERVICES DISTRICT Member, Board of Directors 9430 49
24033 MARTHA MCFAULS Non Partisan WRIGHTWOOD COMMUNITY SERVICES DISTRICT Member, Board of Directors 9430 22
24034 RICK J. CHRISTENSEN Non Partisan WRIGHTWOOD COMMUNITY SERVICES DISTRICT Member, Board of Directors 9430 25
24035 CHAD MICHAEL KEEL Non Partisan WRIGHTWOOD COMMUNITY SERVICES DISTRICT Member, Board of Directors 9430 25
24386 JILL M. CARLTONPAYNE Non Partisan WRIGHTWOOD COMMUNITY SERVICES DISTRICT Member, Board of Directors 9430 20

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