candidates

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

5 rows where contest_id = 9712

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
24312 LORRAINE AVILA MOORE Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9712 6868
24313 REBECCA CASTRO Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9712 1669
24314 LUIS GERARDO CUELLAR Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9712 4054
24315 JOSE LUIS PINA Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9712 2140
24316 RITA SOTO Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9712 7592

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