results

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

15 rows where candidate_id = 24017

✎ 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
5333 5333 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 0600030D 0 0 0
5337 5337 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 0670143B 0 0 0
5341 5341 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 2930010D 0 0 0
5345 5345 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 2930017A 0 0 0
5349 5349 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 2930019A 1 1 2
5353 5353 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 3330001A 6 22 28
5357 5357 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 3330003A 74 111 185
5361 5361 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 3330004A 40 90 130
5365 5365 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 3330005B 2 6 8
5369 5369 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 7410002A 4 9 13
5373 5373 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 9990307A 0 0 0
5377 5377 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 9990314A 0 0 0
5381 5381 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 9990361A 0 0 0
5385 5385 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 9990561A 0 0 0
5389 5389 VINCENT MATTHEW SANTANA 24017 LA PUENTE VALLEY COUNTY WATER DISTRICT Member, Board of Directors 9434 9990563A 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]);