results

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

8 rows where candidate_id = 23250

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
16123 16123 JONATHAN SANABRIA 23250 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850006A 61 100 161
16129 16129 JONATHAN SANABRIA 23250 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850008A 49 147 196
16135 16135 JONATHAN SANABRIA 23250 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850011A 26 147 173
16141 16141 JONATHAN SANABRIA 23250 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850014A 57 188 245
16147 16147 JONATHAN SANABRIA 23250 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850015B 27 124 151
16153 16153 JONATHAN SANABRIA 23250 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850017A 52 165 217
16159 16159 JONATHAN SANABRIA 23250 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850022A 48 118 166
16165 16165 JONATHAN SANABRIA 23250 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850029A 33 122 155

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