results

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

21 rows where candidate_id = 21578

✎ 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
257944 257944 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550001A 78 260 338
257946 257946 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550003A 60 157 217
257948 257948 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550009A 22 61 83
257950 257950 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550009D 38 149 187
257952 257952 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550011B 53 156 209
257954 257954 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550012B 96 251 347
257956 257956 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550016A 56 189 245
257958 257958 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550018E 53 202 255
257960 257960 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550019B 60 188 248
257962 257962 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550020A 52 212 264
257964 257964 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550021B 71 173 244
257966 257966 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550026A 60 218 278
257968 257968 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550029A 64 212 276
257970 257970 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550032A 58 237 295
257972 257972 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550033A 43 248 291
257974 257974 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550036A 47 194 241
257976 257976 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550050A 70 304 374
257978 257978 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550052A 83 297 380
257980 257980 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550061A 48 147 195
257982 257982 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550064A 62 226 288
257984 257984 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550073A 4 27 31

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