results

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

9 rows where candidate_id = 23264

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
41678 41678 RUSSELL STUART 23264 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900002A 77 181 258
41688 41688 RUSSELL STUART 23264 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900004A 168 292 460
41698 41698 RUSSELL STUART 23264 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900010A 127 189 316
41708 41708 RUSSELL STUART 23264 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900024A 81 124 205
41718 41718 RUSSELL STUART 23264 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900026A 71 132 203
41728 41728 RUSSELL STUART 23264 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900030A 53 89 142
41738 41738 RUSSELL STUART 23264 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900033B 0 0 0
41748 41748 RUSSELL STUART 23264 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900038A 0 1 1
41758 41758 RUSSELL STUART 23264 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900047A 77 92 169

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