results

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

8 rows where candidate_id = 24093

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
149888 149888 STEVEN M. JONES 24093 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200001A 91 379 470
149892 149892 STEVEN M. JONES 24093 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200001B 0 1 1
149896 149896 STEVEN M. JONES 24093 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200006A 120 516 636
149900 149900 STEVEN M. JONES 24093 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200006C 0 0 0
149904 149904 STEVEN M. JONES 24093 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200016A 137 430 567
149908 149908 STEVEN M. JONES 24093 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 9990397A 0 0 0
149912 149912 STEVEN M. JONES 24093 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 9990398A 0 0 0
149916 149916 STEVEN M. JONES 24093 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 9990399A 0 0 0

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