results

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

9 rows where candidate_id = 21624

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
304480 304480 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600005A 30 85 115
304482 304482 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600010A 135 444 579
304484 304484 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600011A 154 586 740
304486 304486 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600014A 9 22 31
304488 304488 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600016A 123 538 661
304490 304490 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600019A 5 16 21
304492 304492 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600026A 78 419 497
304494 304494 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600028J 0 2 2
304496 304496 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600033A 107 385 492

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