candidates

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

4 rows where contest_id = 9621

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23970 JACQUELINE SALDANA Non Partisan MOUNTAIN VIEW SCHOOL DISTRICT Governing Board Member 9621 4740
23999 CHRISTIAN DIAZ Non Partisan MOUNTAIN VIEW SCHOOL DISTRICT Governing Board Member 9621 4388
24045 STEVE MACIAS Non Partisan MOUNTAIN VIEW SCHOOL DISTRICT Governing Board Member 9621 1559
24052 JIACLING "JACKIE" CHEN Non Partisan MOUNTAIN VIEW SCHOOL DISTRICT Governing Board Member 9621 2756

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