results

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

6 rows where candidate_id = 21517

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
204404 204404 RYAN W. BALDINO 21517 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250001A 133 411 544
204409 204409 RYAN W. BALDINO 21517 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250003A 120 487 607
204414 204414 RYAN W. BALDINO 21517 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250004A 129 476 605
204419 204419 RYAN W. BALDINO 21517 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250006A 143 449 592
204424 204424 RYAN W. BALDINO 21517 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250011A 142 564 706
204429 204429 RYAN W. BALDINO 21517 EL SEGUNDO CITY GENERAL MUNICIPAL ELECTION Member of the City Council 8570 2250017B 0 1 1

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