candidates

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

5 rows where contest_id = 8603

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21816 SYLVIA BALLIN Non Partisan SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8603 1413
21817 MARY SOLORIO Non Partisan SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8603 1556
21818 MARY MENDOZA Non Partisan SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8603 1713
21819 JOEL FAJARDO Non Partisan SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8603 2175
21820 VICTORIA GARCIA Non Partisan SAN FERNANDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8603 1346

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