results

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

52 rows where contest_id = 9408

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id, precinct_id

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
107731 107731 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250001A 131 350 481
107732 107732 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250009A 66 227 293
107733 107733 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250009A 29 124 153
107734 107734 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250010A 102 242 344
107735 107735 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250010A 80 157 237
107736 107736 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250016A 95 402 497
107737 107737 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250016A 117 305 422
107738 107738 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250022D 44 147 191
107739 107739 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250022D 31 83 114
107740 107740 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250024A 73 299 372
107741 107741 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250024A 47 150 197
107742 107742 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250025A 53 211 264
107743 107743 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250025A 48 162 210
107744 107744 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250030A 60 188 248
107745 107745 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250030A 56 94 150
107746 107746 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250042A 103 337 440
107747 107747 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250042A 81 235 316
107748 107748 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250048A 85 346 431
107749 107749 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250048A 96 214 310
107750 107750 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250049A 47 216 263
107751 107751 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250049A 37 102 139
107752 107752 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250053B 82 278 360
107753 107753 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250053B 70 165 235
107754 107754 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250055A 56 206 262
107755 107755 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250055A 97 189 286
107756 107756 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250057A 41 152 193
107757 107757 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250057A 27 72 99
107758 107758 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250062A 76 252 328
107759 107759 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250062A 39 102 141
107760 107760 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250063C 36 174 210
107761 107761 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250063C 34 118 152
107762 107762 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250067A 58 184 242
107763 107763 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250067A 35 69 104
107764 107764 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250070B 45 157 202
107765 107765 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250070B 38 96 134
107766 107766 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250076A 39 176 215
107767 107767 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250076A 53 86 139
107768 107768 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250087A 86 328 414
107769 107769 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250087A 71 176 247
107770 107770 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250090A 38 127 165
107771 107771 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250090A 14 62 76
107772 107772 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250097A 51 227 278
107773 107773 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250097A 38 132 170
107774 107774 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250146A 52 230 282
107775 107775 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250146A 60 180 240
107776 107776 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250147A 65 253 318
107777 107777 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250147A 83 195 278
107778 107778 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250314A 121 646 767
107779 107779 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250314A 94 252 346
107780 107780 YES 22607 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250319A 137 519 656
107781 107781 NO 22608 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE P 9408 5250319A 152 350 502

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