results

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

4 rows where candidate_id = 23097

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
198257 198257 JOHN NOLTE 23097 POMONA CITY PRIMARY NOMINATING ELECTION Member of the City Council, 1st District 9405 5250016A 44 235 279
198261 198261 JOHN NOLTE 23097 POMONA CITY PRIMARY NOMINATING ELECTION Member of the City Council, 1st District 9405 5250024A 36 190 226
198265 198265 JOHN NOLTE 23097 POMONA CITY PRIMARY NOMINATING ELECTION Member of the City Council, 1st District 9405 5250025A 25 132 157
198269 198269 JOHN NOLTE 23097 POMONA CITY PRIMARY NOMINATING ELECTION Member of the City Council, 1st District 9405 5250030A 40 140 180

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