candidates

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

6 rows where contest_id = 8469

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
20694 JENNIFER "JEN" FENTON Non Partisan MANHATTAN BEACH UNIFIED SCHOOL DISTRICT Governing Board Member 8469 9130
20798 MIKE WELSH Non Partisan MANHATTAN BEACH UNIFIED SCHOOL DISTRICT Governing Board Member 8469 5470
20820 KRISTEN "WYSH" WEINSTEIN Non Partisan MANHATTAN BEACH UNIFIED SCHOOL DISTRICT Governing Board Member 8469 8184
20906 JOHN GEORGE URIOSTEGUI Non Partisan MANHATTAN BEACH UNIFIED SCHOOL DISTRICT Governing Board Member 8469 5507
21164 CHRISTY BARNES Non Partisan MANHATTAN BEACH UNIFIED SCHOOL DISTRICT Governing Board Member 8469 5575
21229 CHRISTINA "TINA" SHIVPURI Non Partisan MANHATTAN BEACH UNIFIED SCHOOL DISTRICT Governing Board Member 8469 8711

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