results

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

4 rows where contest_id = 9781

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
158632 158632 DAN KOOPS 24435 BELLFLOWER CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9781 0750010A 260 569 829
158633 158633 DAN KOOPS 24435 BELLFLOWER CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9781 0750019A 449 992 1441
158634 158634 DAN KOOPS 24435 BELLFLOWER CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9781 0750021A 348 895 1243
158635 158635 DAN KOOPS 24435 BELLFLOWER CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 2nd District 9781 9990716A 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]);