results

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

42 rows where contest_id = 8686

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place

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
257945 257945 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550001A 71 308 379
257946 257946 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550003A 60 157 217
257947 257947 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550003A 38 183 221
257948 257948 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550009A 22 61 83
257949 257949 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550009A 20 63 83
257950 257950 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550009D 38 149 187
257951 257951 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550009D 27 148 175
257952 257952 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550011B 53 156 209
257953 257953 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550011B 35 184 219
257954 257954 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550012B 96 251 347
257955 257955 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550012B 63 217 280
257956 257956 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550016A 56 189 245
257957 257957 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550016A 49 162 211
257958 257958 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550018E 53 202 255
257959 257959 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550018E 44 207 251
257960 257960 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550019B 60 188 248
257961 257961 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550019B 46 182 228
257962 257962 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550020A 52 212 264
257963 257963 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550020A 49 168 217
257964 257964 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550021B 71 173 244
257965 257965 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550021B 51 189 240
257966 257966 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550026A 60 218 278
257967 257967 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550026A 50 188 238
257968 257968 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550029A 64 212 276
257969 257969 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550029A 43 204 247
257970 257970 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550032A 58 237 295
257971 257971 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550032A 43 235 278
257972 257972 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550033A 43 248 291
257973 257973 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550033A 38 208 246
257974 257974 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550036A 47 194 241
257975 257975 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550036A 53 198 251
257976 257976 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550050A 70 304 374
257977 257977 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550050A 52 247 299
257978 257978 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550052A 83 297 380
257979 257979 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550052A 73 294 367
257980 257980 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550061A 48 147 195
257981 257981 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550061A 40 130 170
257982 257982 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550064A 62 226 288
257983 257983 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550064A 51 224 275
257984 257984 JOSE DELAPAZ 21578 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550073A 4 27 31
257985 257985 GREG MARTINEZ 21577 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION City Treasurer 8686 6550073A 6 37 43

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