results

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

21 rows where candidate_id = 21572

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
191651 191651 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550001A 49 270 319
191657 191657 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550003A 33 151 184
191663 191663 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550009A 14 57 71
191669 191669 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550009D 32 118 150
191675 191675 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550011B 35 135 170
191681 191681 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550012B 60 229 289
191687 191687 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550016A 44 157 201
191693 191693 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550018E 36 200 236
191699 191699 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550019B 50 167 217
191705 191705 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550020A 42 161 203
191711 191711 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550021B 48 165 213
191717 191717 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550026A 58 220 278
191723 191723 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550029A 49 195 244
191729 191729 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550032A 53 253 306
191735 191735 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550033A 32 218 250
191741 191741 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550036A 37 200 237
191747 191747 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550050A 47 310 357
191753 191753 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550052A 68 280 348
191759 191759 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550061A 46 152 198
191765 191765 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550064A 51 240 291
191771 191771 AL RIOS 21572 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8610 6550073A 2 25 27

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]);