results

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

7 rows where candidate_id = 21792

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
32193 32193 CALVIN LO 21792 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200001A 25 271 296
32200 32200 CALVIN LO 21792 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 5 34 39
32207 32207 CALVIN LO 21792 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200006A 37 240 277
32214 32214 CALVIN LO 21792 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200006C 0 3 3
32221 32221 CALVIN LO 21792 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200007A 92 720 812
32228 32228 CALVIN LO 21792 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200012A 29 283 312
32235 32235 CALVIN LO 21792 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200016A 55 426 481

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