results

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

12 rows where candidate_id = 21028

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
14828 14828 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550002C 0 7 7
14832 14832 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550019D 0 1 1
14836 14836 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 2550148A 23 81 104
14840 14840 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150005A 0 4 4
14844 14844 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150040D 20 72 92
14848 14848 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150060D 5 59 64
14852 14852 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3150064D 6 11 17
14856 14856 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200001A 136 798 934
14860 14860 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200004A 159 784 943
14864 14864 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200018C 7 30 37
14868 14868 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 3200019A 154 667 821
14872 14872 KERRY ERICKSON 21028 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 8381 4610025A 87 375 462

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