results

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

6 rows where candidate_id = 24074

✎ 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
163675 163675 GLORIA OLMOS 24074 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Mayor 9748 6530002A 281 427 708
163677 163677 GLORIA OLMOS 24074 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Mayor 9748 6530040A 322 629 951
163679 163679 GLORIA OLMOS 24074 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Mayor 9748 6530044A 468 1097 1565
163681 163681 GLORIA OLMOS 24074 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Mayor 9748 9990556A 0 0 0
163683 163683 GLORIA OLMOS 24074 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Mayor 9748 9990557A 0 0 0
163685 163685 GLORIA OLMOS 24074 SOUTH EL MONTE CITY GENERAL MUNICIPAL ELECTION Mayor 9748 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]);