candidates

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

6 rows where contest_id = 8610

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21570 JOSHUA BARRON Non Partisan SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 4042
21571 ROBERT MONTALVO Non Partisan SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 1699
21572 AL RIOS Non Partisan SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 4789
21573 JOVANNA LABORIN Non Partisan SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 2162
21574 ADOLFO VARAS Non Partisan SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 706
21575 RUBY M. NAVARRO Non Partisan SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 3003

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