results

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

8 rows where candidate_id = 21636

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
191049 191049 STEVE MARTIN FIGUEROA 21636 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800002A 28 67 95
191059 191059 STEVE MARTIN FIGUEROA 21636 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800005A 17 49 66
191069 191069 STEVE MARTIN FIGUEROA 21636 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800006A 20 79 99
191079 191079 STEVE MARTIN FIGUEROA 21636 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800007A 16 90 106
191089 191089 STEVE MARTIN FIGUEROA 21636 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800009A 21 72 93
191099 191099 STEVE MARTIN FIGUEROA 21636 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800010A 0 14 14
191109 191109 STEVE MARTIN FIGUEROA 21636 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800016A 29 81 110
191119 191119 STEVE MARTIN FIGUEROA 21636 BELL GARDENS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8874 0800017B 0 8 8

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