home / la-county-general-election-results-2022

results

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

8 rows where candidate_id = 21608

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
31331 31331 JORGE HERRERA AVILA 21608 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100001C 9 27 36
31338 31338 JORGE HERRERA AVILA 21608 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100008A 106 404 510
31345 31345 JORGE HERRERA AVILA 21608 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100011A 53 193 246
31352 31352 JORGE HERRERA AVILA 21608 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100021A 54 224 278
31359 31359 JORGE HERRERA AVILA 21608 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100024A 80 243 323
31366 31366 JORGE HERRERA AVILA 21608 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100031A 28 190 218
31373 31373 JORGE HERRERA AVILA 21608 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100034A 34 85 119
31380 31380 JORGE HERRERA AVILA 21608 SAN GABRIEL CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8602 6100043A 61 257 318

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]);
Powered by Datasette · Queries took 14.558ms · Data source: Los Angeles County Registrar-Recorder/County Clerk