results

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

18 rows where contest_id = 8611

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id, polling_place, vote_by_mail, total

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
304481 304481 ZHEN TAO 21623 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600005A 21 116 137
304482 304482 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600010A 135 444 579
304483 304483 ZHEN TAO 21623 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600010A 147 870 1017
304484 304484 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600011A 154 586 740
304485 304485 ZHEN TAO 21623 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600011A 229 1126 1355
304486 304486 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600014A 9 22 31
304487 304487 ZHEN TAO 21623 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600014A 11 50 61
304488 304488 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600016A 123 538 661
304489 304489 ZHEN TAO 21623 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600016A 165 1223 1388
304490 304490 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600019A 5 16 21
304491 304491 ZHEN TAO 21623 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600019A 4 30 34
304492 304492 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600026A 78 419 497
304493 304493 ZHEN TAO 21623 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600026A 141 1004 1145
304494 304494 ALAN M. EHRLICH 21624 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600028J 0 2 2
304495 304495 ZHEN TAO 21623 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
304497 304497 ZHEN TAO 21623 SOUTH PASADENA CITY GENERAL MUNICIPAL ELECTION City Treasurer 8611 6600033A 124 827 951

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