candidates

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

6 rows where contest_id = 9716

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24267 JOE FRANKLIN Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 11599
24268 KAREN KOMATINSKY Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 7041
24269 STEVE CHARELIAN Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 7658
24271 NINA TARNAY Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 9961
24272 JOE MARCY Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4296
24273 BRENDA O'LEARY Non Partisan MANHATTAN BEACH CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9716 4171

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