results

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

8 rows where candidate_id = 24063

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
236535 236535 DREW BOYLES 24063 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9694 2250005A 407 1081 1488
236541 236541 DREW BOYLES 24063 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9694 2250011A 596 1618 2214
236547 236547 DREW BOYLES 24063 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9694 2250020A 461 1372 1833
236553 236553 DREW BOYLES 24063 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9694 2250023A 0 0 0
236559 236559 DREW BOYLES 24063 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9694 2250024A 1 1 2
236565 236565 DREW BOYLES 24063 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9694 2250030A 0 0 0
236571 236571 DREW BOYLES 24063 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9694 9990849A 0 0 0
236577 236577 DREW BOYLES 24063 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9694 9990850A 0 0 0

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