results

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

6 rows where candidate_id = 24335

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
235730 235730 KATE ANDERSON 24335 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080004A 189 864 1053
235733 235733 KATE ANDERSON 24335 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080007A 338 1359 1697
235736 235736 KATE ANDERSON 24335 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080050A 423 1475 1898
235739 235739 KATE ANDERSON 24335 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080054A 156 518 674
235742 235742 KATE ANDERSON 24335 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080070A 241 1121 1362
235745 235745 KATE ANDERSON 24335 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 9990235A 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]);