results

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

5 rows where candidate_id = 24420

✎ 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
231328 231328 WILLIAM MORANTE SR. 24420 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 0400001A 219 430 649
231332 231332 WILLIAM MORANTE SR. 24420 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 0400004A 266 608 874
231336 231336 WILLIAM MORANTE SR. 24420 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 0400010A 46 126 172
231340 231340 WILLIAM MORANTE SR. 24420 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 9990876A 0 0 0
231344 231344 WILLIAM MORANTE SR. 24420 ARTESIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9668 9990877A 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]);