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

results

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

13 rows where candidate_id = 20994

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
25321 25321 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500004A 17 51 68
25323 25323 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500009A 45 230 275
25325 25325 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500016A 47 133 180
25327 25327 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500017A 38 140 178
25329 25329 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500021A 26 86 112
25331 25331 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500022A 43 199 242
25333 25333 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500034A 36 148 184
25335 25335 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500040A 9 44 53
25337 25337 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500044A 34 219 253
25339 25339 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 4500047C 2 19 21
25341 25341 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 5750027A 20 92 112
25343 25343 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 5750027C 0 0 0
25345 25345 WEN "TONY" FAN 20994 ALHAMBRA UNIFIED SCHOOL DISTRICT Member, Board of Education, Trustee Area No. 4 8806 6650034A 26 70 96

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 9.276ms · Data source: Los Angeles County Registrar-Recorder/County Clerk