candidates

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

5 rows where contest_id = 8681

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21659 SION ROY Non Partisan SANTA MONICA COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees 8681 23270
21660 TOM PETERS Non Partisan SANTA MONICA COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees 8681 22250
21661 BARRY SNELL Non Partisan SANTA MONICA COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees 8681 21742
21662 NANCY GREENSTEIN Non Partisan SANTA MONICA COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees 8681 23141
21815 PATRICK ACOSTA II Non Partisan SANTA MONICA COMMUNITY COLLEGE DISTRICT Member of the Board of Trustees 8681 8682

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