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

results

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

8 rows where candidate_id = 24088

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
149890 149890 HUNTER CHANG 24088 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200001A 170 687 857
149894 149894 HUNTER CHANG 24088 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200001B 0 3 3
149898 149898 HUNTER CHANG 24088 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200006A 195 1102 1297
149902 149902 HUNTER CHANG 24088 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200006C 2 1 3
149906 149906 HUNTER CHANG 24088 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 6200016A 221 928 1149
149910 149910 HUNTER CHANG 24088 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 9990397A 0 0 0
149914 149914 HUNTER CHANG 24088 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 9990398A 0 0 0
149918 149918 HUNTER CHANG 24088 SAN MARINO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9739 9990399A 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]);
Powered by Datasette · Queries took 10.487ms · Data source: Los Angeles County Registrar-Recorder/County Clerk