results

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

3,988 rows where candidate_id = 23594

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
97505 97505 NO 23594 STATE MEASURE 33 9871 0050002B 14 1 15
97507 97507 NO 23594 STATE MEASURE 33 9871 0050002G 0 0 0
97509 97509 NO 23594 STATE MEASURE 33 9871 0050003A 410 519 929
97511 97511 NO 23594 STATE MEASURE 33 9871 0050005A 821 1120 1941
97513 97513 NO 23594 STATE MEASURE 33 9871 0050007B 0 0 0
97515 97515 NO 23594 STATE MEASURE 33 9871 0050010A 2 1 3
97517 97517 NO 23594 STATE MEASURE 33 9871 0050014A 137 231 368
97519 97519 NO 23594 STATE MEASURE 33 9871 0050015A 1 0 1
97521 97521 NO 23594 STATE MEASURE 33 9871 0050022D 0 2 2
97523 97523 NO 23594 STATE MEASURE 33 9871 0050023D 0 0 0
97525 97525 NO 23594 STATE MEASURE 33 9871 0050025H 0 0 0
97527 97527 NO 23594 STATE MEASURE 33 9871 0050027A 0 0 0
97529 97529 NO 23594 STATE MEASURE 33 9871 0050029A 0 0 0
97531 97531 NO 23594 STATE MEASURE 33 9871 0050037A 0 0 0
97533 97533 NO 23594 STATE MEASURE 33 9871 0050042A 0 2 2
97535 97535 NO 23594 STATE MEASURE 33 9871 0050055A 0 0 0
97537 97537 NO 23594 STATE MEASURE 33 9871 0050066A 0 0 0
97539 97539 NO 23594 STATE MEASURE 33 9871 0070001A 154 392 546
97541 97541 NO 23594 STATE MEASURE 33 9871 0070002A 13 39 52
97543 97543 NO 23594 STATE MEASURE 33 9871 0070005A 189 584 773
97545 97545 NO 23594 STATE MEASURE 33 9871 0070005B 2 5 7
97547 97547 NO 23594 STATE MEASURE 33 9871 0070006A 238 651 889
97549 97549 NO 23594 STATE MEASURE 33 9871 0070027A 0 0 0
97551 97551 NO 23594 STATE MEASURE 33 9871 0070027B 2 0 2
97553 97553 NO 23594 STATE MEASURE 33 9871 0070027C 0 0 0
97555 97555 NO 23594 STATE MEASURE 33 9871 0070041B 31 71 102
97557 97557 NO 23594 STATE MEASURE 33 9871 0070041F 7 10 17
97559 97559 NO 23594 STATE MEASURE 33 9871 0070207A 6 26 32
97561 97561 NO 23594 STATE MEASURE 33 9871 0080004A 315 1028 1343
97563 97563 NO 23594 STATE MEASURE 33 9871 0080007A 448 1358 1806
97565 97565 NO 23594 STATE MEASURE 33 9871 0080050A 576 1552 2128
97567 97567 NO 23594 STATE MEASURE 33 9871 0080054A 228 581 809
97569 97569 NO 23594 STATE MEASURE 33 9871 0080070A 375 1333 1708
97571 97571 NO 23594 STATE MEASURE 33 9871 0090002A 1 0 1
97573 97573 NO 23594 STATE MEASURE 33 9871 0090002B 0 6 6
97575 97575 NO 23594 STATE MEASURE 33 9871 0090002C 0 0 0
97577 97577 NO 23594 STATE MEASURE 33 9871 0090005C 0 0 0
97579 97579 NO 23594 STATE MEASURE 33 9871 0090005G 0 1 1
97581 97581 NO 23594 STATE MEASURE 33 9871 0090006A 9 9 18
97583 97583 NO 23594 STATE MEASURE 33 9871 0090007C 0 1 1
97585 97585 NO 23594 STATE MEASURE 33 9871 0090009A 0 0 0
97587 97587 NO 23594 STATE MEASURE 33 9871 0090010A 0 0 0
97589 97589 NO 23594 STATE MEASURE 33 9871 0090011B 3 7 10
97591 97591 NO 23594 STATE MEASURE 33 9871 0090012A 1 9 10
97593 97593 NO 23594 STATE MEASURE 33 9871 0090017A 0 0 0
97595 97595 NO 23594 STATE MEASURE 33 9871 0090019A 0 0 0
97597 97597 NO 23594 STATE MEASURE 33 9871 0090021A 0 0 0
97599 97599 NO 23594 STATE MEASURE 33 9871 0090023A 0 0 0
97601 97601 NO 23594 STATE MEASURE 33 9871 0090025A 0 0 0
97603 97603 NO 23594 STATE MEASURE 33 9871 0090025B 0 0 0
97605 97605 NO 23594 STATE MEASURE 33 9871 0090026A 536 968 1504
97607 97607 NO 23594 STATE MEASURE 33 9871 0150003A 398 1244 1642
97609 97609 NO 23594 STATE MEASURE 33 9871 0150005D 1 6 7
97611 97611 NO 23594 STATE MEASURE 33 9871 0150005E 0 2 2
97613 97613 NO 23594 STATE MEASURE 33 9871 0150012A 334 998 1332
97615 97615 NO 23594 STATE MEASURE 33 9871 0150016D 424 1096 1520
97617 97617 NO 23594 STATE MEASURE 33 9871 0150023A 266 640 906
97619 97619 NO 23594 STATE MEASURE 33 9871 0150025A 240 583 823
97621 97621 NO 23594 STATE MEASURE 33 9871 0150032B 1 2 3
97623 97623 NO 23594 STATE MEASURE 33 9871 0150034A 342 955 1297
97625 97625 NO 23594 STATE MEASURE 33 9871 0150042A 143 413 556
97627 97627 NO 23594 STATE MEASURE 33 9871 0150045A 294 739 1033
97629 97629 NO 23594 STATE MEASURE 33 9871 0150049A 99 319 418
97631 97631 NO 23594 STATE MEASURE 33 9871 0150055A 46 152 198
97633 97633 NO 23594 STATE MEASURE 33 9871 0150065A 384 1025 1409
97635 97635 NO 23594 STATE MEASURE 33 9871 0150070A 66 211 277
97637 97637 NO 23594 STATE MEASURE 33 9871 0150071A 315 870 1185
97639 97639 NO 23594 STATE MEASURE 33 9871 0150078A 66 139 205
97641 97641 NO 23594 STATE MEASURE 33 9871 0150079A 189 553 742
97643 97643 NO 23594 STATE MEASURE 33 9871 0150082A 308 616 924
97645 97645 NO 23594 STATE MEASURE 33 9871 0150085A 102 246 348
97647 97647 NO 23594 STATE MEASURE 33 9871 0180002A 81 199 280
97649 97649 NO 23594 STATE MEASURE 33 9871 0200005A 339 1363 1702
97651 97651 NO 23594 STATE MEASURE 33 9871 0200015A 341 800 1141
97653 97653 NO 23594 STATE MEASURE 33 9871 0200016A 516 2036 2552
97655 97655 NO 23594 STATE MEASURE 33 9871 0200018A 36 145 181
97657 97657 NO 23594 STATE MEASURE 33 9871 0200019A 174 579 753
97659 97659 NO 23594 STATE MEASURE 33 9871 0200025B 243 959 1202
97661 97661 NO 23594 STATE MEASURE 33 9871 0200027A 0 0 0
97663 97663 NO 23594 STATE MEASURE 33 9871 0200029A 155 646 801
97665 97665 NO 23594 STATE MEASURE 33 9871 0200030C 0 0 0
97667 97667 NO 23594 STATE MEASURE 33 9871 0200031A 0 1 1
97669 97669 NO 23594 STATE MEASURE 33 9871 0200040A 537 1412 1949
97671 97671 NO 23594 STATE MEASURE 33 9871 0200041A 0 0 0
97673 97673 NO 23594 STATE MEASURE 33 9871 0200046A 194 496 690
97675 97675 NO 23594 STATE MEASURE 33 9871 0200048A 0 0 0
97677 97677 NO 23594 STATE MEASURE 33 9871 0200053A 0 0 0
97679 97679 NO 23594 STATE MEASURE 33 9871 0200064A 100 216 316
97681 97681 NO 23594 STATE MEASURE 33 9871 0200087A 428 1312 1740
97683 97683 NO 23594 STATE MEASURE 33 9871 0200094A 0 0 0
97685 97685 NO 23594 STATE MEASURE 33 9871 0200094H 0 0 0
97687 97687 NO 23594 STATE MEASURE 33 9871 0300001D 0 2 2
97689 97689 NO 23594 STATE MEASURE 33 9871 0300001G 29 50 79
97691 97691 NO 23594 STATE MEASURE 33 9871 0300002A 39 84 123
97693 97693 NO 23594 STATE MEASURE 33 9871 0300002B 5 4 9
97695 97695 NO 23594 STATE MEASURE 33 9871 0300002C 5 11 16
97697 97697 NO 23594 STATE MEASURE 33 9871 0300003A 11 14 25
97699 97699 NO 23594 STATE MEASURE 33 9871 0300005A 0 0 0
97701 97701 NO 23594 STATE MEASURE 33 9871 0300006B 0 0 0
97703 97703 NO 23594 STATE MEASURE 33 9871 0300012A 55 70 125

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