candidates

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

6 rows where contest_id = 8586

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21735 LORRAINE AVILA MOORE Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8586 2398
21736 GABRIELA CAMACHO Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8586 3143
21737 JORGE CASANOVA Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8586 1544
21738 JUAN MUÑOZ-GUEVARA Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8586 2949
21739 MARISELA SANTANA Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8586 2923
21740 JOSE LUIS SOLACHE Non Partisan LYNWOOD CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8586 3151

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