candidates

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

4 rows where contest_id = 8584

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21590 HECTOR "MANUEL" ORTIZ Non Partisan IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8584 324
21591 ALBERT F. "ALBIE" AMBRIZ Non Partisan IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8584 295
21592 ROSEMARY P. MARTINEZ Non Partisan IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8584 170
21593 JASON L. HICKMAN Non Partisan IRWINDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8584 210

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