candidates

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

4 rows where contest_id = 8453

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
20931 LISETTE IDALIA MENDEZ Non Partisan EL MONTE CITY SCHOOL DISTRICT Governing Board Member 8453 5584
21222 V. "MAJOR" PATEL Non Partisan EL MONTE CITY SCHOOL DISTRICT Governing Board Member 8453 3579
21271 ELIZABETH "BETH" RIVAS Non Partisan EL MONTE CITY SCHOOL DISTRICT Governing Board Member 8453 5330
21306 CHRISTINA FLORES Non Partisan EL MONTE CITY SCHOOL DISTRICT Governing Board Member 8453 4308

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