results

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

4 rows where candidate_id = 21546

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
180337 180337 AUNDRÉ JOHNSON 21546 CLAREMONT CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 8645 1300009A 102 256 358
180339 180339 AUNDRÉ JOHNSON 21546 CLAREMONT CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 8645 1300018A 122 320 442
180341 180341 AUNDRÉ JOHNSON 21546 CLAREMONT CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 8645 1300063A 124 377 501
180343 180343 AUNDRÉ JOHNSON 21546 CLAREMONT CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 4th District 8645 9990518A 2 0 2

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