results

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

25 rows where candidate_id = 24305

✎ 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
66944 66944 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550001B 159 489 648
66949 66949 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550003A 135 315 450
66954 66954 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550006A 168 329 497
66959 66959 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550010A 172 375 547
66964 66964 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550013A 185 398 583
66969 66969 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550018E 126 395 521
66974 66974 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550019G 0 0 0
66979 66979 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550021B 139 262 401
66984 66984 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550028A 142 340 482
66989 66989 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550029A 188 429 617
66994 66994 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550033A 119 381 500
66999 66999 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550035A 157 345 502
67004 67004 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550050A 118 304 422
67009 67009 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550052A 196 507 703
67014 67014 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550053A 211 450 661
67019 67019 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550060C 0 0 0
67024 67024 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550061A 154 365 519
67029 67029 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550062B 86 202 288
67034 67034 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550073A 13 38 51
67039 67039 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 6550083A 116 303 419
67044 67044 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 9990701A 0 0 0
67049 67049 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 9990702A 0 0 0
67054 67054 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 9990703A 0 0 0
67059 67059 GIL HURTADO 24305 SOUTH GATE CITY GENERAL MUNICIPAL ELECTION Member of the City Council 9750 9990704A 0 0 0
67064 67064 GIL HURTADO 24305 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]);