results

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

7 rows where candidate_id = 23243

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
195668 195668 LIZZETTE COLIN 23243 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700001A 36 61 97
195676 195676 LIZZETTE COLIN 23243 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700005E 0 0 0
195684 195684 LIZZETTE COLIN 23243 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700007B 59 100 159
195692 195692 LIZZETTE COLIN 23243 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700010A 23 74 97
195700 195700 LIZZETTE COLIN 23243 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700011B 28 60 88
195708 195708 LIZZETTE COLIN 23243 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700012A 24 54 78
195716 195716 LIZZETTE COLIN 23243 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700018A 29 56 85

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [results] (
   [candidate_id] INTEGER REFERENCES [candidates]([id]),
   [contest_id] INTEGER REFERENCES [contests]([id]),
   [precinct_id] TEXT REFERENCES [precincts]([precinct]),
   [polling_place] INTEGER,
   [vote_by_mail] INTEGER,
   [total] INTEGER
);
CREATE INDEX [idx_results_precinct_id]
    ON [results] ([precinct_id]);
CREATE INDEX [idx_results_contest_id]
    ON [results] ([contest_id]);
CREATE INDEX [idx_results_candidate_id]
    ON [results] ([candidate_id]);