results

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

7 rows where candidate_id = 21566

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
11899 11899 DAVID BRAMANTE 21566 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080004A 87 266 353
11904 11904 DAVID BRAMANTE 21566 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080012A 100 282 382
11909 11909 DAVID BRAMANTE 21566 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080021A 110 287 397
11914 11914 DAVID BRAMANTE 21566 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080025A 85 201 286
11919 11919 DAVID BRAMANTE 21566 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080038A 77 184 261
11924 11924 DAVID BRAMANTE 21566 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080043A 71 226 297
11929 11929 DAVID BRAMANTE 21566 AGOURA HILLS CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8559 0080050A 96 295 391

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