results

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

3 rows where candidate_id = 21630

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
253514 253514 HAP HENRY 21630 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8587 4050002A 51 194 245
253520 253520 HAP HENRY 21630 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8587 4050051A 154 510 664
253526 253526 HAP HENRY 21630 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8587 4050063A 135 397 532

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