results

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

52 rows where contest_id = 9409

✎ 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
1413 1413 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250001A 142 394 536
1414 1414 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250001A 105 409 514
1415 1415 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250009A 58 212 270
1416 1416 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250009A 39 141 180
1417 1417 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250010A 106 228 334
1418 1418 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250010A 67 159 226
1419 1419 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250016A 109 363 472
1420 1420 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250016A 95 310 405
1421 1421 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250022D 38 129 167
1422 1422 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250022D 30 90 120
1423 1423 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250024A 81 269 350
1424 1424 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250024A 37 169 206
1425 1425 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250025A 56 206 262
1426 1426 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250025A 39 152 191
1427 1427 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250030A 61 134 195
1428 1428 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250030A 55 136 191
1429 1429 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250042A 83 281 364
1430 1430 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250042A 97 274 371
1431 1431 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250048A 103 313 416
1432 1432 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250048A 78 233 311
1433 1433 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250049A 58 184 242
1434 1434 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250049A 25 119 144
1435 1435 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250053B 82 266 348
1436 1436 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250053B 65 168 233
1437 1437 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250055A 62 197 259
1438 1438 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250055A 89 177 266
1439 1439 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250057A 34 134 168
1440 1440 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250057A 30 78 108
1441 1441 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250062A 65 208 273
1442 1442 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250062A 49 133 182
1443 1443 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250063C 40 172 212
1444 1444 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250063C 25 108 133
1445 1445 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250067A 52 138 190
1446 1446 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250067A 36 102 138
1447 1447 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250070B 46 131 177
1448 1448 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250070B 32 106 138
1449 1449 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250076A 52 153 205
1450 1450 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250076A 44 100 144
1451 1451 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250087A 72 199 271
1452 1452 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250087A 77 277 354
1453 1453 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250090A 32 122 154
1454 1454 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250090A 14 47 61
1455 1455 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250097A 50 202 252
1456 1456 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250097A 38 150 188
1457 1457 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250146A 58 212 270
1458 1458 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250146A 51 181 232
1459 1459 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250147A 68 193 261
1460 1460 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250147A 73 209 282
1461 1461 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250314A 120 396 516
1462 1462 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250314A 92 425 517
1463 1463 YES 22609 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250319A 138 425 563
1464 1464 NO 22610 POMONA CITY PRIMARY MUNICIPAL ELECTION - MEASURE X 9409 5250319A 145 397 542

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