results

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

7,976 rows where contest_id = 9871

✎ 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
97504 97504 YES 23593 STATE MEASURE 33 9871 0050002B 24 0 24
97505 97505 NO 23594 STATE MEASURE 33 9871 0050002B 14 1 15
97506 97506 YES 23593 STATE MEASURE 33 9871 0050002G 1 0 1
97507 97507 NO 23594 STATE MEASURE 33 9871 0050002G 0 0 0
97508 97508 YES 23593 STATE MEASURE 33 9871 0050003A 92 173 265
97509 97509 NO 23594 STATE MEASURE 33 9871 0050003A 410 519 929
97510 97510 YES 23593 STATE MEASURE 33 9871 0050005A 215 371 586
97511 97511 NO 23594 STATE MEASURE 33 9871 0050005A 821 1120 1941
97512 97512 YES 23593 STATE MEASURE 33 9871 0050007B 0 0 0
97513 97513 NO 23594 STATE MEASURE 33 9871 0050007B 0 0 0
97514 97514 YES 23593 STATE MEASURE 33 9871 0050010A 0 0 0
97515 97515 NO 23594 STATE MEASURE 33 9871 0050010A 2 1 3
97516 97516 YES 23593 STATE MEASURE 33 9871 0050014A 39 98 137
97517 97517 NO 23594 STATE MEASURE 33 9871 0050014A 137 231 368
97518 97518 YES 23593 STATE MEASURE 33 9871 0050015A 0 0 0
97519 97519 NO 23594 STATE MEASURE 33 9871 0050015A 1 0 1
97520 97520 YES 23593 STATE MEASURE 33 9871 0050022D 0 0 0
97521 97521 NO 23594 STATE MEASURE 33 9871 0050022D 0 2 2
97522 97522 YES 23593 STATE MEASURE 33 9871 0050023D 0 0 0
97523 97523 NO 23594 STATE MEASURE 33 9871 0050023D 0 0 0
97524 97524 YES 23593 STATE MEASURE 33 9871 0050025H 0 0 0
97525 97525 NO 23594 STATE MEASURE 33 9871 0050025H 0 0 0
97526 97526 YES 23593 STATE MEASURE 33 9871 0050027A 1 0 1
97527 97527 NO 23594 STATE MEASURE 33 9871 0050027A 0 0 0
97528 97528 YES 23593 STATE MEASURE 33 9871 0050029A 0 0 0
97529 97529 NO 23594 STATE MEASURE 33 9871 0050029A 0 0 0
97530 97530 YES 23593 STATE MEASURE 33 9871 0050037A 0 0 0
97531 97531 NO 23594 STATE MEASURE 33 9871 0050037A 0 0 0
97532 97532 YES 23593 STATE MEASURE 33 9871 0050042A 1 0 1
97533 97533 NO 23594 STATE MEASURE 33 9871 0050042A 0 2 2
97534 97534 YES 23593 STATE MEASURE 33 9871 0050055A 0 0 0
97535 97535 NO 23594 STATE MEASURE 33 9871 0050055A 0 0 0
97536 97536 YES 23593 STATE MEASURE 33 9871 0050066A 0 0 0
97537 97537 NO 23594 STATE MEASURE 33 9871 0050066A 0 0 0
97538 97538 YES 23593 STATE MEASURE 33 9871 0070001A 36 121 157
97539 97539 NO 23594 STATE MEASURE 33 9871 0070001A 154 392 546
97540 97540 YES 23593 STATE MEASURE 33 9871 0070002A 0 14 14
97541 97541 NO 23594 STATE MEASURE 33 9871 0070002A 13 39 52
97542 97542 YES 23593 STATE MEASURE 33 9871 0070005A 59 211 270
97543 97543 NO 23594 STATE MEASURE 33 9871 0070005A 189 584 773
97544 97544 YES 23593 STATE MEASURE 33 9871 0070005B 2 2 4
97545 97545 NO 23594 STATE MEASURE 33 9871 0070005B 2 5 7
97546 97546 YES 23593 STATE MEASURE 33 9871 0070006A 104 240 344
97547 97547 NO 23594 STATE MEASURE 33 9871 0070006A 238 651 889
97548 97548 YES 23593 STATE MEASURE 33 9871 0070027A 0 0 0
97549 97549 NO 23594 STATE MEASURE 33 9871 0070027A 0 0 0
97550 97550 YES 23593 STATE MEASURE 33 9871 0070027B 0 1 1
97551 97551 NO 23594 STATE MEASURE 33 9871 0070027B 2 0 2
97552 97552 YES 23593 STATE MEASURE 33 9871 0070027C 0 0 0
97553 97553 NO 23594 STATE MEASURE 33 9871 0070027C 0 0 0
97554 97554 YES 23593 STATE MEASURE 33 9871 0070041B 10 28 38
97555 97555 NO 23594 STATE MEASURE 33 9871 0070041B 31 71 102
97556 97556 YES 23593 STATE MEASURE 33 9871 0070041F 3 3 6
97557 97557 NO 23594 STATE MEASURE 33 9871 0070041F 7 10 17
97558 97558 YES 23593 STATE MEASURE 33 9871 0070207A 0 4 4
97559 97559 NO 23594 STATE MEASURE 33 9871 0070207A 6 26 32
97560 97560 YES 23593 STATE MEASURE 33 9871 0080004A 76 388 464
97561 97561 NO 23594 STATE MEASURE 33 9871 0080004A 315 1028 1343
97562 97562 YES 23593 STATE MEASURE 33 9871 0080007A 155 730 885
97563 97563 NO 23594 STATE MEASURE 33 9871 0080007A 448 1358 1806
97564 97564 YES 23593 STATE MEASURE 33 9871 0080050A 211 877 1088
97565 97565 NO 23594 STATE MEASURE 33 9871 0080050A 576 1552 2128
97566 97566 YES 23593 STATE MEASURE 33 9871 0080054A 88 304 392
97567 97567 NO 23594 STATE MEASURE 33 9871 0080054A 228 581 809
97568 97568 YES 23593 STATE MEASURE 33 9871 0080070A 106 546 652
97569 97569 NO 23594 STATE MEASURE 33 9871 0080070A 375 1333 1708
97570 97570 YES 23593 STATE MEASURE 33 9871 0090002A 0 0 0
97571 97571 NO 23594 STATE MEASURE 33 9871 0090002A 1 0 1
97572 97572 YES 23593 STATE MEASURE 33 9871 0090002B 0 1 1
97573 97573 NO 23594 STATE MEASURE 33 9871 0090002B 0 6 6
97574 97574 YES 23593 STATE MEASURE 33 9871 0090002C 0 0 0
97575 97575 NO 23594 STATE MEASURE 33 9871 0090002C 0 0 0
97576 97576 YES 23593 STATE MEASURE 33 9871 0090005C 0 0 0
97577 97577 NO 23594 STATE MEASURE 33 9871 0090005C 0 0 0
97578 97578 YES 23593 STATE MEASURE 33 9871 0090005G 0 0 0
97579 97579 NO 23594 STATE MEASURE 33 9871 0090005G 0 1 1
97580 97580 YES 23593 STATE MEASURE 33 9871 0090006A 7 9 16
97581 97581 NO 23594 STATE MEASURE 33 9871 0090006A 9 9 18
97582 97582 YES 23593 STATE MEASURE 33 9871 0090007C 0 0 0
97583 97583 NO 23594 STATE MEASURE 33 9871 0090007C 0 1 1
97584 97584 YES 23593 STATE MEASURE 33 9871 0090009A 0 0 0
97585 97585 NO 23594 STATE MEASURE 33 9871 0090009A 0 0 0
97586 97586 YES 23593 STATE MEASURE 33 9871 0090010A 0 0 0
97587 97587 NO 23594 STATE MEASURE 33 9871 0090010A 0 0 0
97588 97588 YES 23593 STATE MEASURE 33 9871 0090011B 2 7 9
97589 97589 NO 23594 STATE MEASURE 33 9871 0090011B 3 7 10
97590 97590 YES 23593 STATE MEASURE 33 9871 0090012A 0 0 0
97591 97591 NO 23594 STATE MEASURE 33 9871 0090012A 1 9 10
97592 97592 YES 23593 STATE MEASURE 33 9871 0090017A 0 0 0
97593 97593 NO 23594 STATE MEASURE 33 9871 0090017A 0 0 0
97594 97594 YES 23593 STATE MEASURE 33 9871 0090019A 0 0 0
97595 97595 NO 23594 STATE MEASURE 33 9871 0090019A 0 0 0
97596 97596 YES 23593 STATE MEASURE 33 9871 0090021A 0 0 0
97597 97597 NO 23594 STATE MEASURE 33 9871 0090021A 0 0 0
97598 97598 YES 23593 STATE MEASURE 33 9871 0090023A 0 0 0
97599 97599 NO 23594 STATE MEASURE 33 9871 0090023A 0 0 0
97600 97600 YES 23593 STATE MEASURE 33 9871 0090025A 0 4 4
97601 97601 NO 23594 STATE MEASURE 33 9871 0090025A 0 0 0
97602 97602 YES 23593 STATE MEASURE 33 9871 0090025B 0 0 0
97603 97603 NO 23594 STATE MEASURE 33 9871 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]);