candidates

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

5 rows where contest_id = 8797

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ name party contest_id total_votes
21447 PAT KEARNEY Non Partisan LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 1648
21448 SAMUEL CRUZ Non Partisan LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 1063
21450 BERNADETTE LOURDES SUAREZ Non Partisan LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 2516
21452 DAN REID Non Partisan LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 988
21454 WANZA TOLLIVER Non Partisan LAWNDALE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8797 844

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