results

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

8 rows where candidate_id = 23046

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
169874 169874 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 0300016A 3 9 12
169876 169876 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 3700048A 0 0 0
169878 169878 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 3750003A 1 8 9
169880 169880 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 3750005A 41 143 184
169882 169882 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 5200043A 89 152 241
169884 169884 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900007B 5 25 30
169886 169886 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900008A 119 163 282
169888 169888 JAY OBERNOLTE 23046 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900009A 126 202 328

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