results

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

7,976 rows where contest_id = 9874

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
58359 58359 YES 23601 STATE MEASURE 36 9874 0050002B 28 1 29
58360 58360 NO 23602 STATE MEASURE 36 9874 0050002B 13 0 13
58361 58361 YES 23601 STATE MEASURE 36 9874 0050002G 0 0 0
58362 58362 NO 23602 STATE MEASURE 36 9874 0050002G 1 0 1
58363 58363 YES 23601 STATE MEASURE 36 9874 0050003A 406 588 994
58364 58364 NO 23602 STATE MEASURE 36 9874 0050003A 93 121 214
58365 58365 YES 23601 STATE MEASURE 36 9874 0050005A 851 1191 2042
58366 58366 NO 23602 STATE MEASURE 36 9874 0050005A 206 319 525
58367 58367 YES 23601 STATE MEASURE 36 9874 0050007B 0 0 0
58368 58368 NO 23602 STATE MEASURE 36 9874 0050007B 0 0 0
58369 58369 YES 23601 STATE MEASURE 36 9874 0050010A 2 1 3
58370 58370 NO 23602 STATE MEASURE 36 9874 0050010A 0 0 0
58371 58371 YES 23601 STATE MEASURE 36 9874 0050014A 142 243 385
58372 58372 NO 23602 STATE MEASURE 36 9874 0050014A 40 84 124
58373 58373 YES 23601 STATE MEASURE 36 9874 0050015A 0 0 0
58374 58374 NO 23602 STATE MEASURE 36 9874 0050015A 1 0 1
58375 58375 YES 23601 STATE MEASURE 36 9874 0050022D 0 2 2
58376 58376 NO 23602 STATE MEASURE 36 9874 0050022D 0 0 0
58377 58377 YES 23601 STATE MEASURE 36 9874 0050023D 0 0 0
58378 58378 NO 23602 STATE MEASURE 36 9874 0050023D 0 0 0
58379 58379 YES 23601 STATE MEASURE 36 9874 0050025H 0 0 0
58380 58380 NO 23602 STATE MEASURE 36 9874 0050025H 0 0 0
58381 58381 YES 23601 STATE MEASURE 36 9874 0050027A 0 0 0
58382 58382 NO 23602 STATE MEASURE 36 9874 0050027A 1 0 1
58383 58383 YES 23601 STATE MEASURE 36 9874 0050029A 0 0 0
58384 58384 NO 23602 STATE MEASURE 36 9874 0050029A 0 0 0
58385 58385 YES 23601 STATE MEASURE 36 9874 0050037A 0 0 0
58386 58386 NO 23602 STATE MEASURE 36 9874 0050037A 0 0 0
58387 58387 YES 23601 STATE MEASURE 36 9874 0050042A 0 2 2
58388 58388 NO 23602 STATE MEASURE 36 9874 0050042A 1 0 1
58389 58389 YES 23601 STATE MEASURE 36 9874 0050055A 0 0 0
58390 58390 NO 23602 STATE MEASURE 36 9874 0050055A 0 0 0
58391 58391 YES 23601 STATE MEASURE 36 9874 0050066A 0 0 0
58392 58392 NO 23602 STATE MEASURE 36 9874 0050066A 0 0 0
58393 58393 YES 23601 STATE MEASURE 36 9874 0070001A 155 412 567
58394 58394 NO 23602 STATE MEASURE 36 9874 0070001A 39 104 143
58395 58395 YES 23601 STATE MEASURE 36 9874 0070002A 8 39 47
58396 58396 NO 23602 STATE MEASURE 36 9874 0070002A 6 15 21
58397 58397 YES 23601 STATE MEASURE 36 9874 0070005A 196 563 759
58398 58398 NO 23602 STATE MEASURE 36 9874 0070005A 50 231 281
58399 58399 YES 23601 STATE MEASURE 36 9874 0070005B 3 2 5
58400 58400 NO 23602 STATE MEASURE 36 9874 0070005B 1 5 6
58401 58401 YES 23601 STATE MEASURE 36 9874 0070006A 235 578 813
58402 58402 NO 23602 STATE MEASURE 36 9874 0070006A 109 325 434
58403 58403 YES 23601 STATE MEASURE 36 9874 0070027A 0 0 0
58404 58404 NO 23602 STATE MEASURE 36 9874 0070027A 0 0 0
58405 58405 YES 23601 STATE MEASURE 36 9874 0070027B 2 0 2
58406 58406 NO 23602 STATE MEASURE 36 9874 0070027B 0 1 1
58407 58407 YES 23601 STATE MEASURE 36 9874 0070027C 0 0 0
58408 58408 NO 23602 STATE MEASURE 36 9874 0070027C 0 0 0
58409 58409 YES 23601 STATE MEASURE 36 9874 0070041B 30 64 94
58410 58410 NO 23602 STATE MEASURE 36 9874 0070041B 12 38 50
58411 58411 YES 23601 STATE MEASURE 36 9874 0070041F 8 11 19
58412 58412 NO 23602 STATE MEASURE 36 9874 0070041F 2 2 4
58413 58413 YES 23601 STATE MEASURE 36 9874 0070207A 6 23 29
58414 58414 NO 23602 STATE MEASURE 36 9874 0070207A 0 9 9
58415 58415 YES 23601 STATE MEASURE 36 9874 0080004A 319 933 1252
58416 58416 NO 23602 STATE MEASURE 36 9874 0080004A 79 472 551
58417 58417 YES 23601 STATE MEASURE 36 9874 0080007A 466 1335 1801
58418 58418 NO 23602 STATE MEASURE 36 9874 0080007A 148 750 898
58419 58419 YES 23601 STATE MEASURE 36 9874 0080050A 576 1579 2155
58420 58420 NO 23602 STATE MEASURE 36 9874 0080050A 216 865 1081
58421 58421 YES 23601 STATE MEASURE 36 9874 0080054A 233 589 822
58422 58422 NO 23602 STATE MEASURE 36 9874 0080054A 78 278 356
58423 58423 YES 23601 STATE MEASURE 36 9874 0080070A 376 1321 1697
58424 58424 NO 23602 STATE MEASURE 36 9874 0080070A 113 541 654
58425 58425 YES 23601 STATE MEASURE 36 9874 0090002A 1 0 1
58426 58426 NO 23602 STATE MEASURE 36 9874 0090002A 0 0 0
58427 58427 YES 23601 STATE MEASURE 36 9874 0090002B 0 6 6
58428 58428 NO 23602 STATE MEASURE 36 9874 0090002B 0 1 1
58429 58429 YES 23601 STATE MEASURE 36 9874 0090002C 0 0 0
58430 58430 NO 23602 STATE MEASURE 36 9874 0090002C 0 0 0
58431 58431 YES 23601 STATE MEASURE 36 9874 0090005C 0 0 0
58432 58432 NO 23602 STATE MEASURE 36 9874 0090005C 0 0 0
58433 58433 YES 23601 STATE MEASURE 36 9874 0090005G 0 0 0
58434 58434 NO 23602 STATE MEASURE 36 9874 0090005G 0 1 1
58435 58435 YES 23601 STATE MEASURE 36 9874 0090006A 4 13 17
58436 58436 NO 23602 STATE MEASURE 36 9874 0090006A 11 5 16
58437 58437 YES 23601 STATE MEASURE 36 9874 0090007C 0 1 1
58438 58438 NO 23602 STATE MEASURE 36 9874 0090007C 0 0 0
58439 58439 YES 23601 STATE MEASURE 36 9874 0090009A 0 0 0
58440 58440 NO 23602 STATE MEASURE 36 9874 0090009A 0 0 0
58441 58441 YES 23601 STATE MEASURE 36 9874 0090010A 0 0 0
58442 58442 NO 23602 STATE MEASURE 36 9874 0090010A 0 0 0
58443 58443 YES 23601 STATE MEASURE 36 9874 0090011B 2 7 9
58444 58444 NO 23602 STATE MEASURE 36 9874 0090011B 3 4 7
58445 58445 YES 23601 STATE MEASURE 36 9874 0090012A 1 8 9
58446 58446 NO 23602 STATE MEASURE 36 9874 0090012A 0 1 1
58447 58447 YES 23601 STATE MEASURE 36 9874 0090017A 0 0 0
58448 58448 NO 23602 STATE MEASURE 36 9874 0090017A 0 0 0
58449 58449 YES 23601 STATE MEASURE 36 9874 0090019A 0 0 0
58450 58450 NO 23602 STATE MEASURE 36 9874 0090019A 0 0 0
58451 58451 YES 23601 STATE MEASURE 36 9874 0090021A 0 0 0
58452 58452 NO 23602 STATE MEASURE 36 9874 0090021A 0 0 0
58453 58453 YES 23601 STATE MEASURE 36 9874 0090023A 0 0 0
58454 58454 NO 23602 STATE MEASURE 36 9874 0090023A 0 0 0
58455 58455 YES 23601 STATE MEASURE 36 9874 0090025A 0 2 2
58456 58456 NO 23602 STATE MEASURE 36 9874 0090025A 1 2 3
58457 58457 YES 23601 STATE MEASURE 36 9874 0090025B 0 0 0
58458 58458 NO 23602 STATE MEASURE 36 9874 0090025B 0 0 0

Next page

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