results

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

4 rows where candidate_id = 24096

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
255488 255488 JEFF MALONEY 24096 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Third District 9664 0150012A 516 1615 2131
255489 255489 JEFF MALONEY 24096 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Third District 9664 0150025A 414 1013 1427
255490 255490 JEFF MALONEY 24096 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Third District 9664 0150078A 123 271 394
255491 255491 JEFF MALONEY 24096 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Third District 9664 9990375A 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]);