results

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

8 rows where candidate_id = 24275

✎ 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
234566 234566 LORI Y. WOODS 24275 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450002C 165 573 738
234570 234570 LORI Y. WOODS 24275 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450004A 41 187 228
234574 234574 LORI Y. WOODS 24275 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450005A 23 134 157
234578 234578 LORI Y. WOODS 24275 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450006B 0 5 5
234582 234582 LORI Y. WOODS 24275 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450007A 0 0 0
234586 234586 LORI Y. WOODS 24275 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 6450009A 240 1054 1294
234590 234590 LORI Y. WOODS 24275 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 9990883A 0 0 0
234594 234594 LORI Y. WOODS 24275 SIGNAL HILL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9747 9990890A 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]);