results

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

9 rows where candidate_id = 23255

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
41676 41676 CRAIG CORMAN 23255 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900002A 95 452 547
41686 41686 CRAIG CORMAN 23255 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900004A 130 722 852
41696 41696 CRAIG CORMAN 23255 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900010A 83 387 470
41706 41706 CRAIG CORMAN 23255 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900024A 91 447 538
41716 41716 CRAIG CORMAN 23255 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900026A 81 363 444
41726 41726 CRAIG CORMAN 23255 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900030A 58 286 344
41736 41736 CRAIG CORMAN 23255 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900033B 0 6 6
41746 41746 CRAIG CORMAN 23255 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900038A 1 2 3
41756 41756 CRAIG CORMAN 23255 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900047A 72 288 360

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