results

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

10 rows where candidate_id = 24442

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
163689 163689 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 7750002A 5 10 15
163699 163699 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 7750003A 37 27 64
163709 163709 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 7750005A 25 52 77
163719 163719 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 7750007A 22 64 86
163729 163729 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 7750017A 11 36 47
163739 163739 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 7750023A 18 49 67
163749 163749 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 7750038A 15 39 54
163759 163759 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 7750043A 17 26 43
163769 163769 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 7750078A 6 17 23
163779 163779 DORIAN J. JACKSON 24442 CITY OF WEST HOLLYWOOD GENERAL MUNICIPAL ELECTION Member of the City Council 9758 9990456A 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]);