results

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

8 rows where candidate_id = 23173

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
45630 45630 EDWARD BELDEN 23173 MONROVIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9263 4400004A 56 212 268
45634 45634 EDWARD BELDEN 23173 MONROVIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9263 4400008A 62 300 362
45638 45638 EDWARD BELDEN 23173 MONROVIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9263 4400019A 1 14 15
45642 45642 EDWARD BELDEN 23173 MONROVIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9263 4400021A 131 643 774
45646 45646 EDWARD BELDEN 23173 MONROVIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9263 4400037A 131 513 644
45650 45650 EDWARD BELDEN 23173 MONROVIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9263 4400061A 125 543 668
45654 45654 EDWARD BELDEN 23173 MONROVIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9263 4400063A 111 413 524
45658 45658 EDWARD BELDEN 23173 MONROVIA CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9263 4400064A 75 350 425

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