candidates

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

7 rows where contest_id = 8588

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21488 STEWART L. FOURNIER Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 890
21489 FRANK CHIELLA Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 3589
21490 DAVID LESSER Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 7197
21491 AMY HOWORTH Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 7518
21492 MARK BURTON Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 3067
21493 RITA CRABTREE-KAMPE Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 3256
21494 SUZANNE HADLEY Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8588 5522

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