candidates

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

4 rows where contest_id = 9628

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23534 ERIC ALEGRIA Non Partisan PALOS VERDES PENINSULA UNIFIED SCHOOL DISTRICT Governing Board Member 9628 13709
23551 JEREMY VANDERHAL Non Partisan PALOS VERDES PENINSULA UNIFIED SCHOOL DISTRICT Governing Board Member 9628 12353
23575 AMI GANDHI Non Partisan PALOS VERDES PENINSULA UNIFIED SCHOOL DISTRICT Governing Board Member 9628 16307
23692 ALEXANDRIA KAY BLUMER Non Partisan PALOS VERDES PENINSULA UNIFIED SCHOOL DISTRICT Governing Board Member 9628 8173

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