results

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

3 rows where candidate_id = 21626

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
253510 253510 RYAN EMBREE 21626 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8587 4050002A 54 148 202
253516 253516 RYAN EMBREE 21626 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8587 4050051A 59 316 375
253522 253522 RYAN EMBREE 21626 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8587 4050063A 46 144 190

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]);