candidates

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

3 rows where contest_id = 9414

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23116 SYLVIA BALLIN Non Partisan SAN FERNANDO CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 3, 2024) 9414 800
23117 SEAN M. RIVAS Non Partisan SAN FERNANDO CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 3, 2024) 9414 729
23118 VICTORIA GARCIA Non Partisan SAN FERNANDO CITY SPECIAL MUNICIPAL ELECTION Member of the City Council (Unexpired term ending December 3, 2024) 9414 981

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