results

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

25 rows where candidate_id = 24309

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
66945 66945 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550001B 138 234 372
66950 66950 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550003A 134 207 341
66955 66955 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550006A 156 287 443
66960 66960 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550010A 154 240 394
66965 66965 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550013A 214 307 521
66970 66970 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550018E 152 287 439
66975 66975 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550019G 0 0 0
66980 66980 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550021B 166 195 361
66985 66985 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550028A 110 234 344
66990 66990 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550029A 219 270 489
66995 66995 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550033A 139 290 429
67000 67000 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550035A 173 232 405
67005 67005 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550050A 144 260 404
67010 67010 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550052A 191 363 554
67015 67015 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550053A 185 343 528
67020 67020 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550060C 0 0 0
67025 67025 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550061A 156 253 409
67030 67030 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550062B 80 110 190
67035 67035 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550073A 22 31 53
67040 67040 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550083A 118 230 348
67045 67045 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 9990701A 0 0 0
67050 67050 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 9990702A 0 0 0
67055 67055 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 9990703A 0 0 0
67060 67060 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 9990704A 0 0 0
67065 67065 ALAN GARCIA 24309 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 9990705A 0 0 0

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