results

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

22 rows where candidate_id = 23717

✎ 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
122640 122640 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550002C 1 5 6
122643 122643 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550003A 0 0 0
122646 122646 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019D 0 0 0
122649 122649 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019E 0 0 0
122652 122652 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019F 0 0 0
122655 122655 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019G 1 0 1
122658 122658 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019H 0 0 0
122661 122661 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550057A 21 57 78
122664 122664 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550148A 17 39 56
122667 122667 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150001L 0 0 0
122670 122670 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150005A 0 0 0
122673 122673 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150041A 20 57 77
122676 122676 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150060D 11 35 46
122679 122679 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150064D 3 20 23
122682 122682 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3200001A 222 656 878
122685 122685 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3200008A 97 264 361
122688 122688 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3200018A 201 614 815
122691 122691 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 4610025A 196 453 649
122694 122694 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 9990199A 0 0 0
122697 122697 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 9990200A 0 0 0
122700 122700 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 9990255A 0 0 0
122703 122703 ALEC HYELER 23717 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 9990257A 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]);