results

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

6 rows where candidate_id = 24336

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
235732 235732 ARTIN SODAIFY 24336 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080004A 138 266 404
235735 235735 ARTIN SODAIFY 24336 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080007A 179 374 553
235738 235738 ARTIN SODAIFY 24336 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080050A 260 554 814
235741 235741 ARTIN SODAIFY 24336 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080054A 99 197 296
235744 235744 ARTIN SODAIFY 24336 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080070A 158 385 543
235747 235747 ARTIN SODAIFY 24336 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]);