results

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

7 rows where candidate_id = 23246

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
195671 195671 ALI SALEH 23246 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700001A 69 108 177
195679 195679 ALI SALEH 23246 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700005E 1 0 1
195687 195687 ALI SALEH 23246 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700007B 57 137 194
195695 195695 ALI SALEH 23246 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700010A 195 141 336
195703 195703 ALI SALEH 23246 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700011B 39 122 161
195711 195711 ALI SALEH 23246 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700012A 203 163 366
195719 195719 ALI SALEH 23246 BELL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9241 0700018A 42 70 112

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