candidates

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

4 rows where contest_id = 8557

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21015 SHELLEY RYAN Non Partisan SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 3274
21016 C. JOSEPH CHANG Non Partisan SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 3398
21019 JAMES F. BARGER Non Partisan SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 1877
21184 JOANNA LAM Non Partisan SAN MARINO UNIFIED SCHOOL DISTRICT Governing Board Member 8557 2152

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