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

results

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

9 rows where candidate_id = 21667

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
314654 314654 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700020A 80 210 290
314658 314658 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700030A 0 0 0
314662 314662 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700057A 17 51 68
314666 314666 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700080A 15 64 79
314670 314670 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700115A 19 101 120
314674 314674 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700122A 4 29 33
314678 314678 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700164A 21 64 85
314682 314682 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700169A 7 14 21
314686 314686 RICHARD REYES 21667 WEST COVINA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, 5th District 8621 7700313B 2 4 6

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