results

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

6 rows where candidate_id = 24337

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
235731 235731 PENNY SYLVESTER 24337 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080004A 166 823 989
235734 235734 PENNY SYLVESTER 24337 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080007A 230 1178 1408
235737 235737 PENNY SYLVESTER 24337 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080050A 299 1234 1533
235740 235740 PENNY SYLVESTER 24337 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080054A 120 421 541
235743 235743 PENNY SYLVESTER 24337 CITY OF AGOURA HILLS GENERAL MUNICIPAL ELECTION Member of the City Council 9663 0080070A 225 1094 1319
235746 235746 PENNY SYLVESTER 24337 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]);