results

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

8 rows where candidate_id = 24278

✎ 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
234567 234567 SONIA SAVOULIAN 24278 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450002C 123 382 505
234571 234571 SONIA SAVOULIAN 24278 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450004A 31 112 143
234575 234575 SONIA SAVOULIAN 24278 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450005A 11 64 75
234579 234579 SONIA SAVOULIAN 24278 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450006B 0 2 2
234583 234583 SONIA SAVOULIAN 24278 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450007A 0 0 0
234587 234587 SONIA SAVOULIAN 24278 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450009A 126 580 706
234591 234591 SONIA SAVOULIAN 24278 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 9990883A 0 0 0
234595 234595 SONIA SAVOULIAN 24278 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 9990890A 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]);