results

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

6 rows where candidate_id = 24282

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
233421 233421 KAYLEE MAY LAW 24282 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600012A 199 626 825
233427 233427 KAYLEE MAY LAW 24282 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600030A 139 529 668
233433 233433 KAYLEE MAY LAW 24282 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600031C 139 554 693
233439 233439 KAYLEE MAY LAW 24282 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600032A 181 1045 1226
233445 233445 KAYLEE MAY LAW 24282 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600033A 172 759 931
233451 233451 KAYLEE MAY LAW 24282 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 9990608A 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]);