results

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

26 rows where candidate_id = 22607

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vote_by_mail

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
107730 107730 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250001A 130 485 615
107732 107732 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250009A 66 227 293
107734 107734 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250010A 102 242 344
107736 107736 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250016A 95 402 497
107738 107738 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250022D 44 147 191
107740 107740 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250024A 73 299 372
107742 107742 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250025A 53 211 264
107744 107744 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250030A 60 188 248
107746 107746 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250042A 103 337 440
107748 107748 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250048A 85 346 431
107750 107750 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250049A 47 216 263
107752 107752 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250053B 82 278 360
107754 107754 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250055A 56 206 262
107756 107756 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250057A 41 152 193
107758 107758 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250062A 76 252 328
107760 107760 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250063C 36 174 210
107762 107762 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250067A 58 184 242
107764 107764 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250070B 45 157 202
107766 107766 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250076A 39 176 215
107768 107768 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250087A 86 328 414
107770 107770 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250090A 38 127 165
107772 107772 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250097A 51 227 278
107774 107774 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250146A 52 230 282
107776 107776 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250147A 65 253 318
107778 107778 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250314A 121 646 767
107780 107780 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250319A 137 519 656

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