results

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

3,988 rows where candidate_id = 23713

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
172803 172803 NO 23713 STATE MEASURE 2 9878 0050002B 10 1 11
172805 172805 NO 23713 STATE MEASURE 2 9878 0050002G 0 0 0
172807 172807 NO 23713 STATE MEASURE 2 9878 0050003A 378 482 860
172809 172809 NO 23713 STATE MEASURE 2 9878 0050005A 787 984 1771
172811 172811 NO 23713 STATE MEASURE 2 9878 0050007B 0 0 0
172813 172813 NO 23713 STATE MEASURE 2 9878 0050010A 0 1 1
172815 172815 NO 23713 STATE MEASURE 2 9878 0050014A 127 223 350
172817 172817 NO 23713 STATE MEASURE 2 9878 0050015A 1 0 1
172819 172819 NO 23713 STATE MEASURE 2 9878 0050022D 0 0 0
172821 172821 NO 23713 STATE MEASURE 2 9878 0050023D 0 0 0
172823 172823 NO 23713 STATE MEASURE 2 9878 0050025H 0 0 0
172825 172825 NO 23713 STATE MEASURE 2 9878 0050027A 1 0 1
172827 172827 NO 23713 STATE MEASURE 2 9878 0050029A 0 0 0
172829 172829 NO 23713 STATE MEASURE 2 9878 0050037A 0 0 0
172831 172831 NO 23713 STATE MEASURE 2 9878 0050042A 0 2 2
172833 172833 NO 23713 STATE MEASURE 2 9878 0050055A 0 0 0
172835 172835 NO 23713 STATE MEASURE 2 9878 0050066A 0 0 0
172837 172837 NO 23713 STATE MEASURE 2 9878 0070001A 129 280 409
172839 172839 NO 23713 STATE MEASURE 2 9878 0070002A 8 23 31
172841 172841 NO 23713 STATE MEASURE 2 9878 0070005A 154 415 569
172843 172843 NO 23713 STATE MEASURE 2 9878 0070005B 3 5 8
172845 172845 NO 23713 STATE MEASURE 2 9878 0070006A 180 389 569
172847 172847 NO 23713 STATE MEASURE 2 9878 0070027A 0 0 0
172849 172849 NO 23713 STATE MEASURE 2 9878 0070027B 2 0 2
172851 172851 NO 23713 STATE MEASURE 2 9878 0070027C 0 0 0
172853 172853 NO 23713 STATE MEASURE 2 9878 0070041B 21 45 66
172855 172855 NO 23713 STATE MEASURE 2 9878 0070041F 6 6 12
172857 172857 NO 23713 STATE MEASURE 2 9878 0070207A 6 18 24
172859 172859 NO 23713 STATE MEASURE 2 9878 0080004A 252 626 878
172861 172861 NO 23713 STATE MEASURE 2 9878 0080007A 322 925 1247
172863 172863 NO 23713 STATE MEASURE 2 9878 0080050A 423 1056 1479
172865 172865 NO 23713 STATE MEASURE 2 9878 0080054A 183 420 603
172867 172867 NO 23713 STATE MEASURE 2 9878 0080070A 301 891 1192
172869 172869 NO 23713 STATE MEASURE 2 9878 0090002A 0 0 0
172871 172871 NO 23713 STATE MEASURE 2 9878 0090002B 0 6 6
172873 172873 NO 23713 STATE MEASURE 2 9878 0090002C 0 0 0
172875 172875 NO 23713 STATE MEASURE 2 9878 0090005C 0 0 0
172877 172877 NO 23713 STATE MEASURE 2 9878 0090005G 0 1 1
172879 172879 NO 23713 STATE MEASURE 2 9878 0090006A 9 5 14
172881 172881 NO 23713 STATE MEASURE 2 9878 0090007C 0 0 0
172883 172883 NO 23713 STATE MEASURE 2 9878 0090009A 0 0 0
172885 172885 NO 23713 STATE MEASURE 2 9878 0090010A 0 0 0
172887 172887 NO 23713 STATE MEASURE 2 9878 0090011B 2 9 11
172889 172889 NO 23713 STATE MEASURE 2 9878 0090012A 1 7 8
172891 172891 NO 23713 STATE MEASURE 2 9878 0090017A 0 0 0
172893 172893 NO 23713 STATE MEASURE 2 9878 0090019A 0 0 0
172895 172895 NO 23713 STATE MEASURE 2 9878 0090021A 0 0 0
172897 172897 NO 23713 STATE MEASURE 2 9878 0090023A 0 0 0
172899 172899 NO 23713 STATE MEASURE 2 9878 0090025A 0 0 0
172901 172901 NO 23713 STATE MEASURE 2 9878 0090025B 0 0 0
172903 172903 NO 23713 STATE MEASURE 2 9878 0090026A 484 850 1334
172905 172905 NO 23713 STATE MEASURE 2 9878 0150003A 315 823 1138
172907 172907 NO 23713 STATE MEASURE 2 9878 0150005D 1 2 3
172909 172909 NO 23713 STATE MEASURE 2 9878 0150005E 0 0 0
172911 172911 NO 23713 STATE MEASURE 2 9878 0150012A 229 656 885
172913 172913 NO 23713 STATE MEASURE 2 9878 0150016D 324 694 1018
172915 172915 NO 23713 STATE MEASURE 2 9878 0150023A 215 395 610
172917 172917 NO 23713 STATE MEASURE 2 9878 0150025A 165 389 554
172919 172919 NO 23713 STATE MEASURE 2 9878 0150032B 2 0 2
172921 172921 NO 23713 STATE MEASURE 2 9878 0150034A 252 639 891
172923 172923 NO 23713 STATE MEASURE 2 9878 0150042A 128 288 416
172925 172925 NO 23713 STATE MEASURE 2 9878 0150045A 214 545 759
172927 172927 NO 23713 STATE MEASURE 2 9878 0150049A 81 235 316
172929 172929 NO 23713 STATE MEASURE 2 9878 0150055A 32 88 120
172931 172931 NO 23713 STATE MEASURE 2 9878 0150065A 285 689 974
172933 172933 NO 23713 STATE MEASURE 2 9878 0150070A 50 139 189
172935 172935 NO 23713 STATE MEASURE 2 9878 0150071A 266 600 866
172937 172937 NO 23713 STATE MEASURE 2 9878 0150078A 56 104 160
172939 172939 NO 23713 STATE MEASURE 2 9878 0150079A 146 339 485
172941 172941 NO 23713 STATE MEASURE 2 9878 0150082A 200 348 548
172943 172943 NO 23713 STATE MEASURE 2 9878 0150085A 76 206 282
172945 172945 NO 23713 STATE MEASURE 2 9878 0180002A 62 133 195
172947 172947 NO 23713 STATE MEASURE 2 9878 0200005A 260 799 1059
172949 172949 NO 23713 STATE MEASURE 2 9878 0200015A 220 494 714
172951 172951 NO 23713 STATE MEASURE 2 9878 0200016A 375 1331 1706
172953 172953 NO 23713 STATE MEASURE 2 9878 0200018A 29 101 130
172955 172955 NO 23713 STATE MEASURE 2 9878 0200019A 101 330 431
172957 172957 NO 23713 STATE MEASURE 2 9878 0200025B 155 506 661
172959 172959 NO 23713 STATE MEASURE 2 9878 0200027A 0 0 0
172961 172961 NO 23713 STATE MEASURE 2 9878 0200029A 109 364 473
172963 172963 NO 23713 STATE MEASURE 2 9878 0200030C 0 0 0
172965 172965 NO 23713 STATE MEASURE 2 9878 0200031A 0 0 0
172967 172967 NO 23713 STATE MEASURE 2 9878 0200040A 404 934 1338
172969 172969 NO 23713 STATE MEASURE 2 9878 0200041A 0 0 0
172971 172971 NO 23713 STATE MEASURE 2 9878 0200046A 138 265 403
172973 172973 NO 23713 STATE MEASURE 2 9878 0200048A 0 1 1
172975 172975 NO 23713 STATE MEASURE 2 9878 0200053A 0 0 0
172977 172977 NO 23713 STATE MEASURE 2 9878 0200064A 69 130 199
172979 172979 NO 23713 STATE MEASURE 2 9878 0200087A 300 761 1061
172981 172981 NO 23713 STATE MEASURE 2 9878 0200094A 0 0 0
172983 172983 NO 23713 STATE MEASURE 2 9878 0200094H 0 0 0
172985 172985 NO 23713 STATE MEASURE 2 9878 0300001D 0 1 1
172987 172987 NO 23713 STATE MEASURE 2 9878 0300001G 19 41 60
172989 172989 NO 23713 STATE MEASURE 2 9878 0300002A 33 73 106
172991 172991 NO 23713 STATE MEASURE 2 9878 0300002B 4 1 5
172993 172993 NO 23713 STATE MEASURE 2 9878 0300002C 4 9 13
172995 172995 NO 23713 STATE MEASURE 2 9878 0300003A 12 11 23
172997 172997 NO 23713 STATE MEASURE 2 9878 0300005A 0 0 0
172999 172999 NO 23713 STATE MEASURE 2 9878 0300006B 0 0 0
173001 173001 NO 23713 STATE MEASURE 2 9878 0300012A 49 62 111

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