candidates

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

3 rows where contest_id = 8618

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21671 SUE AUGINO Non Partisan WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8618 3831
21672 MARSHA SOLORIO Non Partisan WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8618 6626
21673 COLLEEN B. ROZATTI Non Partisan WEST COVINA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8618 9436

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