results

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

8 rows where candidate_id = 24091

✎ 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
149891 149891 JOHN CHOU 24091 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200001A 141 636 777
149895 149895 JOHN CHOU 24091 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200001B 1 4 5
149899 149899 JOHN CHOU 24091 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200006A 155 790 945
149903 149903 JOHN CHOU 24091 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200006C 1 0 1
149907 149907 JOHN CHOU 24091 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200016A 171 719 890
149911 149911 JOHN CHOU 24091 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 9990397A 0 0 0
149915 149915 JOHN CHOU 24091 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 9990398A 0 0 0
149919 149919 JOHN CHOU 24091 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 9990399A 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]);