candidates

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

5 rows where contest_id = 8455

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
20662 DAWN GARRETT Non Partisan EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 2456
20701 MEREDITH J. BEACHLY Non Partisan EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 3465
20736 FRANK GLYNN Non Partisan EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 2970
20746 TRACEY I. MILLER-ZARNEKE Non Partisan EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 3782
20815 YADRANKA LUCIA DRASKOVIC Non Partisan EL SEGUNDO UNIFIED SCHOOL DISTRICT Governing Board Member 8455 2283

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