results

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

8 rows where candidate_id = 21607

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
31332 31332 JOHN WU 21607 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100001C 19 113 132
31339 31339 JOHN WU 21607 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100008A 115 659 774
31346 31346 JOHN WU 21607 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100011A 48 269 317
31353 31353 JOHN WU 21607 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100021A 51 595 646
31360 31360 JOHN WU 21607 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100024A 77 554 631
31367 31367 JOHN WU 21607 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100031A 30 256 286
31374 31374 JOHN WU 21607 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100034A 26 161 187
31381 31381 JOHN WU 21607 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100043A 70 602 672

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