results

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

8 rows where candidate_id = 21456

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
244584 244584 ERICA HARBISON 21456 LAWNDALE CITY GENERAL MUNICIPAL ELECTION City Clerk 8796 3650001B 0 2 2
244585 244585 ERICA HARBISON 21456 LAWNDALE CITY GENERAL MUNICIPAL ELECTION City Clerk 8796 3650002A 144 582 726
244586 244586 ERICA HARBISON 21456 LAWNDALE CITY GENERAL MUNICIPAL ELECTION City Clerk 8796 3650004A 74 201 275
244587 244587 ERICA HARBISON 21456 LAWNDALE CITY GENERAL MUNICIPAL ELECTION City Clerk 8796 3650005A 65 195 260
244588 244588 ERICA HARBISON 21456 LAWNDALE CITY GENERAL MUNICIPAL ELECTION City Clerk 8796 3650006A 118 313 431
244589 244589 ERICA HARBISON 21456 LAWNDALE CITY GENERAL MUNICIPAL ELECTION City Clerk 8796 3650011A 165 487 652
244590 244590 ERICA HARBISON 21456 LAWNDALE CITY GENERAL MUNICIPAL ELECTION City Clerk 8796 3650015A 135 535 670
244591 244591 ERICA HARBISON 21456 LAWNDALE CITY GENERAL MUNICIPAL ELECTION City Clerk 8796 3650018B 156 536 692

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