candidates

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

4 rows where contest_id = 9706

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24146 MARK A. BRECEDA Non Partisan IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9706 384
24147 MANUEL R. GARCIA Non Partisan IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9706 398
24149 LARRY G. BURROLA Non Partisan IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9706 358
24151 MARGUERITE S. LOPEZ-SAPIEN Non Partisan IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9706 323

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