results

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

4 rows where candidate_id = 21485

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
247448 247448 ROSS J. MAZA 21485 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Second District 8692 0150021A 73 359 432
247449 247449 ROSS J. MAZA 21485 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Second District 8692 0150028B 60 426 486
247450 247450 ROSS J. MAZA 21485 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Second District 8692 0150042A 105 573 678
247451 247451 ROSS J. MAZA 21485 ALHAMBRA CITY GENERAL MUNICIPAL ELECTION Member of the City Council, Second District 8692 0150049A 148 623 771

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