results

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

7 rows where candidate_id = 21789

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
32194 32194 STEVEN JONES 21789 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200001A 15 70 85
32201 32201 STEVEN JONES 21789 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200004A 1 17 18
32208 32208 STEVEN JONES 21789 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200006A 16 70 86
32215 32215 STEVEN JONES 21789 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200006C 0 0 0
32222 32222 STEVEN JONES 21789 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200007A 39 204 243
32229 32229 STEVEN JONES 21789 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200012A 19 97 116
32236 32236 STEVEN JONES 21789 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8973 6200016A 24 95 119

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