candidates

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

8 rows where contest_id = 9241

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
23241 VIOLETA ALVAREZ Non Partisan BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 817
23242 MONICA ARROYO Non Partisan BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 1517
23243 LIZZETTE COLIN Non Partisan BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 604
23244 FRANCIS FLORES Non Partisan BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 1013
23245 NESTOR ENRIQUE VALENCIA Non Partisan BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 890
23246 ALI SALEH Non Partisan BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 1347
23247 PABLO SIFUENTES Non Partisan BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 712
23248 ELIZABETH "BETTY" DE LA TORRE Non Partisan BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 494

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