candidates

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

5 rows where contest_id = 8454

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
20932 JOHN CONTRERAS Non Partisan EL RANCHO UNIFIED SCHOOL DISTRICT Governing Board Member 8454 4881
21026 ESTHER MEJIA Non Partisan EL RANCHO UNIFIED SCHOOL DISTRICT Governing Board Member 8454 5647
21171 JACQUELINE PEREZ VALENCIA Non Partisan EL RANCHO UNIFIED SCHOOL DISTRICT Governing Board Member 8454 4525
21180 CAROLYN CASTILLO Non Partisan EL RANCHO UNIFIED SCHOOL DISTRICT Governing Board Member 8454 4085
21186 HECTOR LAFARGA JR Non Partisan EL RANCHO UNIFIED SCHOOL DISTRICT Governing Board Member 8454 4685

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