results

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

8 rows where candidate_id = 23276

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
169875 169875 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 0300016A 3 9 12
169877 169877 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 3700048A 1 1 2
169879 169879 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 3750003A 0 14 14
169881 169881 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 3750005A 8 63 71
169883 169883 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 5200043A 5 131 136
169885 169885 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900007B 2 15 17
169887 169887 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900008A 51 250 301
169889 169889 DEREK MARSHALL 23276 UNITED STATES REPRESENTATIVE, 23rd District 9004 7900009A 45 266 311

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