candidates

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

4 rows where contest_id = 9468

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23530 DELA PEYKAR RONEN Non Partisan BEVERLY HILLS UNIFIED SCHOOL DISTRICT Governing Board Member 9468 6122
23664 AMANDA E. STERN Non Partisan BEVERLY HILLS UNIFIED SCHOOL DISTRICT Governing Board Member 9468 7102
23671 RUSSELL STUART Non Partisan BEVERLY HILLS UNIFIED SCHOOL DISTRICT Governing Board Member 9468 6542
23893 SIGALIE SABAG Non Partisan BEVERLY HILLS UNIFIED SCHOOL DISTRICT Governing Board Member 9468 6681

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