results

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

8 rows where candidate_id = 23172

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
161019 161019 LARRY J. SPICER 23172 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400004A 40 93 133
161021 161021 LARRY J. SPICER 23172 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400008A 39 189 228
161023 161023 LARRY J. SPICER 23172 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400019A 4 13 17
161025 161025 LARRY J. SPICER 23172 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400021A 112 370 482
161027 161027 LARRY J. SPICER 23172 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400037A 123 352 475
161029 161029 LARRY J. SPICER 23172 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400061A 110 333 443
161031 161031 LARRY J. SPICER 23172 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400063A 164 431 595
161033 161033 LARRY J. SPICER 23172 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400064A 114 335 449

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