results

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

9 rows where candidate_id = 23265

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
41682 41682 SHARON PERSOVSKI 23265 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900002A 13 63 76
41692 41692 SHARON PERSOVSKI 23265 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900004A 16 45 61
41702 41702 SHARON PERSOVSKI 23265 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900010A 9 40 49
41712 41712 SHARON PERSOVSKI 23265 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900024A 11 48 59
41722 41722 SHARON PERSOVSKI 23265 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900026A 14 58 72
41732 41732 SHARON PERSOVSKI 23265 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900030A 4 40 44
41742 41742 SHARON PERSOVSKI 23265 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900033B 0 0 0
41752 41752 SHARON PERSOVSKI 23265 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900038A 0 0 0
41762 41762 SHARON PERSOVSKI 23265 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900047A 17 47 64

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