results

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

9 rows where candidate_id = 23257

✎ 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
41680 41680 TIFFANY DAVIS 23257 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900002A 25 64 89
41690 41690 TIFFANY DAVIS 23257 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900004A 14 50 64
41700 41700 TIFFANY DAVIS 23257 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900010A 5 16 21
41710 41710 TIFFANY DAVIS 23257 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900024A 13 41 54
41720 41720 TIFFANY DAVIS 23257 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900026A 26 58 84
41730 41730 TIFFANY DAVIS 23257 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900030A 19 43 62
41740 41740 TIFFANY DAVIS 23257 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900033B 0 0 0
41750 41750 TIFFANY DAVIS 23257 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900038A 0 0 0
41760 41760 TIFFANY DAVIS 23257 BEVERLY HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9382 0900047A 14 23 37

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