results

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

6 rows where candidate_id = 24280

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
233425 233425 HONG "DIANA" ZHAO 24280 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600012A 106 502 608
233431 233431 HONG "DIANA" ZHAO 24280 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600030A 70 334 404
233437 233437 HONG "DIANA" ZHAO 24280 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600031C 104 416 520
233443 233443 HONG "DIANA" ZHAO 24280 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600032A 151 842 993
233449 233449 HONG "DIANA" ZHAO 24280 WALNUT CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9754 7600033A 139 607 746
233455 233455 HONG "DIANA" ZHAO 24280 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]);