candidates

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

5 rows where contest_id = 8566

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21678 ALEJANDRA AVILA Non Partisan BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8566 3903
21679 JEAN M. AYALA Non Partisan BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8566 3295
21680 PAUL C. HERNANDEZ Non Partisan BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8566 3082
21681 RALPH GALVAN Non Partisan BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8566 2530
21682 RICARDO VAZQUES Non Partisan BALDWIN PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8566 3205

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