candidates

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

2 rows where contest_id = 9557

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23789 ANNALYNN C. APOLINARIO Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT SPECIAL ELECTION Governing Board Member (Unexpired term ending December 11, 2026) 9557 6479
23998 NORMA OLMOS Non Partisan BALDWIN PARK UNIFIED SCHOOL DISTRICT SPECIAL ELECTION Governing Board Member (Unexpired term ending December 11, 2026) 9557 8332

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