results

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

3 rows where candidate_id = 21628

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
253512 253512 BILL SAMPSON 21628 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8587 4050002A 108 348 456
253518 253518 BILL SAMPSON 21628 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8587 4050051A 164 557 721
253524 253524 BILL SAMPSON 21628 MALIBU CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8587 4050063A 115 329 444

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