results

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

8 rows where candidate_id = 23249

✎ 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
16125 16125 STACEY MARTINEZ 23249 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850006A 22 78 100
16131 16131 STACEY MARTINEZ 23249 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850008A 32 88 120
16137 16137 STACEY MARTINEZ 23249 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850011A 24 89 113
16143 16143 STACEY MARTINEZ 23249 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850014A 53 123 176
16149 16149 STACEY MARTINEZ 23249 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850015B 17 101 118
16155 16155 STACEY MARTINEZ 23249 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850017A 24 92 116
16161 16161 STACEY MARTINEZ 23249 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850022A 30 107 137
16167 16167 STACEY MARTINEZ 23249 HUNTINGTON PARK CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9387 2850029A 20 117 137

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