results

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

8 rows where candidate_id = 23254

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
16120 16120 VALENTINE PALOS AMEZQUITA 23254 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850006A 30 77 107
16126 16126 VALENTINE PALOS AMEZQUITA 23254 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850008A 32 99 131
16132 16132 VALENTINE PALOS AMEZQUITA 23254 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850011A 27 116 143
16138 16138 VALENTINE PALOS AMEZQUITA 23254 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850014A 65 132 197
16144 16144 VALENTINE PALOS AMEZQUITA 23254 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850015B 21 86 107
16150 16150 VALENTINE PALOS AMEZQUITA 23254 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850017A 33 97 130
16156 16156 VALENTINE PALOS AMEZQUITA 23254 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850022A 34 124 158
16162 16162 VALENTINE PALOS AMEZQUITA 23254 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850029A 21 113 134

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