results

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

8 rows where candidate_id = 21446

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
162158 162158 WARRENDELL JACKSON 21446 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650001B 0 0 0
162160 162160 WARRENDELL JACKSON 21446 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650002A 43 98 141
162162 162162 WARRENDELL JACKSON 21446 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650004A 19 40 59
162164 162164 WARRENDELL JACKSON 21446 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650005A 10 43 53
162166 162166 WARRENDELL JACKSON 21446 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650006A 24 82 106
162168 162168 WARRENDELL JACKSON 21446 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650011A 54 113 167
162170 162170 WARRENDELL JACKSON 21446 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650015A 57 111 168
162172 162172 WARRENDELL JACKSON 21446 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650018B 73 102 175

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