results

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

22 rows where candidate_id = 23631

✎ 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
122641 122641 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550002C 2 5 7
122644 122644 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550003A 0 0 0
122647 122647 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019D 0 1 1
122650 122650 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019E 0 0 0
122653 122653 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019F 0 0 0
122656 122656 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019G 1 0 1
122659 122659 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550019H 0 0 0
122662 122662 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550057A 15 42 57
122665 122665 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 2550148A 22 44 66
122668 122668 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150001L 0 0 0
122671 122671 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150005A 0 0 0
122674 122674 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150041A 10 48 58
122677 122677 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150060D 12 31 43
122680 122680 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3150064D 1 5 6
122683 122683 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3200001A 195 727 922
122686 122686 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3200008A 84 337 421
122689 122689 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 3200018A 200 641 841
122692 122692 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 4610025A 178 484 662
122695 122695 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 9990199A 0 0 0
122698 122698 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 9990200A 0 0 0
122701 122701 SHARON RAGHAVACHARY 23631 CRESCENTA VALLEY WATER DISTRICT Member, Board of Directors 9431 9990255A 0 0 0
122704 122704 SHARON RAGHAVACHARY 23631 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]);