results

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

5 rows where candidate_id = 24097

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
257188 257188 KATIE CHAN 24097 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fourth District 9665 0150055A 16 71 87
257192 257192 KATIE CHAN 24097 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fourth District 9665 0150065A 192 495 687
257196 257196 KATIE CHAN 24097 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fourth District 9665 0150070A 33 90 123
257200 257200 KATIE CHAN 24097 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fourth District 9665 0150071A 186 510 696
257204 257204 KATIE CHAN 24097 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Fourth District 9665 9990376A 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]);