results

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

7 rows where candidate_id = 20677

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
218914 218914 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700003A 57 210 267
218918 218918 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700005A 69 186 255
218922 218922 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700007B 10 43 53
218926 218926 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700024A 11 45 56
218930 218930 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700025A 14 31 45
218934 218934 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700057A 55 181 236
218938 218938 KEVIN NOONAN 20677 ORCHARD DALE WATER DISTRICT Member, Board of Directors 8385 6700064A 12 25 37

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