results

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

15 rows where candidate_id = 21377

✎ 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
303711 303711 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550001B 31 123 154
303713 303713 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550002B 93 267 360
303715 303715 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550006A 62 340 402
303717 303717 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550008A 141 258 399
303719 303719 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550009B 85 238 323
303721 303721 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550010C 1 0 1
303723 303723 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550010G 6 13 19
303725 303725 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550012A 27 57 84
303727 303727 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550019A 6 13 19
303729 303729 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550023F 2 7 9
303731 303731 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550024A 11 47 58
303733 303733 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550025B 86 212 298
303735 303735 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550075A 201 500 701
303737 303737 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550080A 93 266 359
303739 303739 JONNY M. LIU 21377 AZUSA CITY GENERAL MUNICIPAL ELECTION Mayor 8561 0550086A 52 200 252

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