results

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

26 rows where candidate_id = 22609

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: polling_place, vote_by_mail, total

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
1413 1413 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250001A 142 394 536
1415 1415 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250009A 58 212 270
1417 1417 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250010A 106 228 334
1419 1419 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250016A 109 363 472
1421 1421 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250022D 38 129 167
1423 1423 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250024A 81 269 350
1425 1425 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250025A 56 206 262
1427 1427 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250030A 61 134 195
1429 1429 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250042A 83 281 364
1431 1431 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250048A 103 313 416
1433 1433 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250049A 58 184 242
1435 1435 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250053B 82 266 348
1437 1437 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250055A 62 197 259
1439 1439 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250057A 34 134 168
1441 1441 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250062A 65 208 273
1443 1443 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250063C 40 172 212
1445 1445 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250067A 52 138 190
1447 1447 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250070B 46 131 177
1449 1449 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250076A 52 153 205
1451 1451 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250087A 72 199 271
1453 1453 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250090A 32 122 154
1455 1455 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250097A 50 202 252
1457 1457 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250146A 58 212 270
1459 1459 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250147A 68 193 261
1461 1461 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250314A 120 396 516
1463 1463 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250319A 138 425 563

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