candidates

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

6 rows where contest_id = 9253

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23160 ISABEL AGUAYO Non Partisan PARAMOUNT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9253 1605
23161 YESENIA MARIA CUARENTA Non Partisan PARAMOUNT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9253 1139
23162 JOSE DE LEON Non Partisan PARAMOUNT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9253 796
23163 CARMEN PATRICIA GOMEZ Non Partisan PARAMOUNT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9253 861
23164 BRENDA OLMOS Non Partisan PARAMOUNT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9253 2158
23165 VILMA CUELLAR STALLINGS Non Partisan PARAMOUNT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9253 1363

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