candidates

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

4 rows where contest_id = 8798

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21710 EDWARD FRANCO Non Partisan MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8798 334
21712 KIMBERLY A. COBOS-CAWTHORNE Non Partisan MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8798 1041
21713 GEORGINA TAMAYO Non Partisan MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8798 1205
21720 ROSIE VASQUEZ Non Partisan MONTEBELLO CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 1st District 8798 742

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