results

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

24 rows where contest_id = 8568

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place, vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
110216 110216 ELIZABETH ALCANTAR 21423 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550001A 39 207 246
110217 110217 PATRICIA COVARRUBIAS 21425 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550001A 17 41 58
110218 110218 MARTIN U. FUENTES 21422 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550001A 20 103 123
110219 110219 BLANCA LOZOYA 21424 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550001A 24 83 107
110220 110220 MARIA JIMENEZ 21426 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550001A 13 43 56
110221 110221 CYNTHIA GONZALEZ 21427 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550001A 16 166 182
110222 110222 ELIZABETH ALCANTAR 21423 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550005A 87 233 320
110223 110223 PATRICIA COVARRUBIAS 21425 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550005A 36 67 103
110224 110224 MARTIN U. FUENTES 21422 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550005A 48 125 173
110225 110225 BLANCA LOZOYA 21424 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550005A 54 93 147
110226 110226 MARIA JIMENEZ 21426 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550005A 43 70 113
110227 110227 CYNTHIA GONZALEZ 21427 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550005A 55 200 255
110228 110228 ELIZABETH ALCANTAR 21423 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550006A 88 218 306
110229 110229 PATRICIA COVARRUBIAS 21425 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550006A 23 65 88
110230 110230 MARTIN U. FUENTES 21422 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550006A 44 119 163
110231 110231 BLANCA LOZOYA 21424 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550006A 44 86 130
110232 110232 MARIA JIMENEZ 21426 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550006A 16 65 81
110233 110233 CYNTHIA GONZALEZ 21427 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550006A 56 194 250
110234 110234 ELIZABETH ALCANTAR 21423 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550020A 61 232 293
110235 110235 PATRICIA COVARRUBIAS 21425 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550020A 29 53 82
110236 110236 MARTIN U. FUENTES 21422 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550020A 37 97 134
110237 110237 BLANCA LOZOYA 21424 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550020A 39 60 99
110238 110238 MARIA JIMENEZ 21426 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550020A 27 62 89
110239 110239 CYNTHIA GONZALEZ 21427 CUDAHY CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8568 1550020A 37 156 193

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