results

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

8 rows where candidate_id = 23171

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
161018 161018 BECKY A. SHEVLIN 23171 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400004A 103 373 476
161020 161020 BECKY A. SHEVLIN 23171 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400008A 132 422 554
161022 161022 BECKY A. SHEVLIN 23171 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400019A 1 30 31
161024 161024 BECKY A. SHEVLIN 23171 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400021A 237 1006 1243
161026 161026 BECKY A. SHEVLIN 23171 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400037A 214 751 965
161028 161028 BECKY A. SHEVLIN 23171 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400061A 222 848 1070
161030 161030 BECKY A. SHEVLIN 23171 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400063A 167 627 794
161032 161032 BECKY A. SHEVLIN 23171 MONROVIA CITY GENERAL MUNICIPAL ELECTION Mayor 9262 4400064A 159 573 732

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