results

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

7 rows where candidate_id = 21795

✎ 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
32191 32191 DIANA MILKIE NIXON 21795 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200001A 17 93 110
32198 32198 DIANA MILKIE NIXON 21795 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 2 22 24
32205 32205 DIANA MILKIE NIXON 21795 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200006A 17 106 123
32212 32212 DIANA MILKIE NIXON 21795 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200006C 0 0 0
32219 32219 DIANA MILKIE NIXON 21795 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200007A 56 299 355
32226 32226 DIANA MILKIE NIXON 21795 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200012A 13 80 93
32233 32233 DIANA MILKIE NIXON 21795 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200016A 30 136 166

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