results

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

8 rows where candidate_id = 21445

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
162157 162157 ROBERT PULLEN-MILES 21445 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650001B 0 3 3
162159 162159 ROBERT PULLEN-MILES 21445 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650002A 132 609 741
162161 162161 ROBERT PULLEN-MILES 21445 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650004A 67 233 300
162163 162163 ROBERT PULLEN-MILES 21445 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650005A 63 186 249
162165 162165 ROBERT PULLEN-MILES 21445 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650006A 113 311 424
162167 162167 ROBERT PULLEN-MILES 21445 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650011A 142 474 616
162169 162169 ROBERT PULLEN-MILES 21445 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650015A 115 524 639
162171 162171 ROBERT PULLEN-MILES 21445 LAWNDALE CITY GENERAL MUNICIPAL ELECTION Mayor 8795 3650018B 147 556 703

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