results

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

6 rows where candidate_id = 24068

✎ 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
113967 113967 RICHARD ANGEL 24068 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9749 6530002A 83 139 222
113971 113971 RICHARD ANGEL 24068 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9749 6530040A 102 271 373
113975 113975 RICHARD ANGEL 24068 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9749 6530044A 248 629 877
113979 113979 RICHARD ANGEL 24068 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9749 9990556A 0 0 0
113983 113983 RICHARD ANGEL 24068 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9749 9990557A 0 0 0
113987 113987 RICHARD ANGEL 24068 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9749 9990558A 0 0 0

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