results

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

7 rows where candidate_id = 21791

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
32192 32192 GRANT FUJIWARA 21791 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200001A 18 135 153
32199 32199 GRANT FUJIWARA 21791 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 3 25 28
32206 32206 GRANT FUJIWARA 21791 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200006A 9 101 110
32213 32213 GRANT FUJIWARA 21791 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200006C 0 1 1
32220 32220 GRANT FUJIWARA 21791 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200007A 49 289 338
32227 32227 GRANT FUJIWARA 21791 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200012A 21 111 132
32234 32234 GRANT FUJIWARA 21791 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200016A 36 191 227

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