results

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

3,988 rows where candidate_id = 23585

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
86931 86931 NO 23585 STATE MEASURE 3 9867 0050002B 18 1 19
86933 86933 NO 23585 STATE MEASURE 3 9867 0050002G 0 0 0
86935 86935 NO 23585 STATE MEASURE 3 9867 0050003A 354 381 735
86937 86937 NO 23585 STATE MEASURE 3 9867 0050005A 731 785 1516
86939 86939 NO 23585 STATE MEASURE 3 9867 0050007B 0 0 0
86941 86941 NO 23585 STATE MEASURE 3 9867 0050010A 2 0 2
86943 86943 NO 23585 STATE MEASURE 3 9867 0050014A 120 172 292
86945 86945 NO 23585 STATE MEASURE 3 9867 0050015A 1 0 1
86947 86947 NO 23585 STATE MEASURE 3 9867 0050022D 0 1 1
86949 86949 NO 23585 STATE MEASURE 3 9867 0050023D 0 0 0
86951 86951 NO 23585 STATE MEASURE 3 9867 0050025H 0 0 0
86953 86953 NO 23585 STATE MEASURE 3 9867 0050027A 1 0 1
86955 86955 NO 23585 STATE MEASURE 3 9867 0050029A 0 0 0
86957 86957 NO 23585 STATE MEASURE 3 9867 0050037A 0 0 0
86959 86959 NO 23585 STATE MEASURE 3 9867 0050042A 0 0 0
86961 86961 NO 23585 STATE MEASURE 3 9867 0050055A 0 0 0
86963 86963 NO 23585 STATE MEASURE 3 9867 0050066A 0 0 0
86965 86965 NO 23585 STATE MEASURE 3 9867 0070001A 95 162 257
86967 86967 NO 23585 STATE MEASURE 3 9867 0070002A 7 18 25
86969 86969 NO 23585 STATE MEASURE 3 9867 0070005A 100 242 342
86971 86971 NO 23585 STATE MEASURE 3 9867 0070005B 2 0 2
86973 86973 NO 23585 STATE MEASURE 3 9867 0070006A 116 201 317
86975 86975 NO 23585 STATE MEASURE 3 9867 0070027A 0 0 0
86977 86977 NO 23585 STATE MEASURE 3 9867 0070027B 2 0 2
86979 86979 NO 23585 STATE MEASURE 3 9867 0070027C 0 0 0
86981 86981 NO 23585 STATE MEASURE 3 9867 0070041B 18 29 47
86983 86983 NO 23585 STATE MEASURE 3 9867 0070041F 3 4 7
86985 86985 NO 23585 STATE MEASURE 3 9867 0070207A 0 9 9
86987 86987 NO 23585 STATE MEASURE 3 9867 0080004A 190 319 509
86989 86989 NO 23585 STATE MEASURE 3 9867 0080007A 222 507 729
86991 86991 NO 23585 STATE MEASURE 3 9867 0080050A 348 720 1068
86993 86993 NO 23585 STATE MEASURE 3 9867 0080054A 139 268 407
86995 86995 NO 23585 STATE MEASURE 3 9867 0080070A 205 463 668
86997 86997 NO 23585 STATE MEASURE 3 9867 0090002A 0 0 0
86999 86999 NO 23585 STATE MEASURE 3 9867 0090002B 0 6 6
87001 87001 NO 23585 STATE MEASURE 3 9867 0090002C 0 0 0
87003 87003 NO 23585 STATE MEASURE 3 9867 0090005C 0 0 0
87005 87005 NO 23585 STATE MEASURE 3 9867 0090005G 0 1 1
87007 87007 NO 23585 STATE MEASURE 3 9867 0090006A 11 3 14
87009 87009 NO 23585 STATE MEASURE 3 9867 0090007C 0 0 0
87011 87011 NO 23585 STATE MEASURE 3 9867 0090009A 0 0 0
87013 87013 NO 23585 STATE MEASURE 3 9867 0090010A 0 0 0
87015 87015 NO 23585 STATE MEASURE 3 9867 0090011B 3 9 12
87017 87017 NO 23585 STATE MEASURE 3 9867 0090012A 0 6 6
87019 87019 NO 23585 STATE MEASURE 3 9867 0090017A 0 0 0
87021 87021 NO 23585 STATE MEASURE 3 9867 0090019A 0 0 0
87023 87023 NO 23585 STATE MEASURE 3 9867 0090021A 0 0 0
87025 87025 NO 23585 STATE MEASURE 3 9867 0090023A 0 0 0
87027 87027 NO 23585 STATE MEASURE 3 9867 0090025A 0 0 0
87029 87029 NO 23585 STATE MEASURE 3 9867 0090025B 0 0 0
87031 87031 NO 23585 STATE MEASURE 3 9867 0090026A 434 665 1099
87033 87033 NO 23585 STATE MEASURE 3 9867 0150003A 360 737 1097
87035 87035 NO 23585 STATE MEASURE 3 9867 0150005D 1 4 5
87037 87037 NO 23585 STATE MEASURE 3 9867 0150005E 0 0 0
87039 87039 NO 23585 STATE MEASURE 3 9867 0150012A 279 601 880
87041 87041 NO 23585 STATE MEASURE 3 9867 0150016D 343 660 1003
87043 87043 NO 23585 STATE MEASURE 3 9867 0150023A 236 375 611
87045 87045 NO 23585 STATE MEASURE 3 9867 0150025A 217 409 626
87047 87047 NO 23585 STATE MEASURE 3 9867 0150032B 4 2 6
87049 87049 NO 23585 STATE MEASURE 3 9867 0150034A 228 471 699
87051 87051 NO 23585 STATE MEASURE 3 9867 0150042A 133 287 420
87053 87053 NO 23585 STATE MEASURE 3 9867 0150045A 225 497 722
87055 87055 NO 23585 STATE MEASURE 3 9867 0150049A 86 213 299
87057 87057 NO 23585 STATE MEASURE 3 9867 0150055A 35 80 115
87059 87059 NO 23585 STATE MEASURE 3 9867 0150065A 284 597 881
87061 87061 NO 23585 STATE MEASURE 3 9867 0150070A 45 133 178
87063 87063 NO 23585 STATE MEASURE 3 9867 0150071A 271 558 829
87065 87065 NO 23585 STATE MEASURE 3 9867 0150078A 57 105 162
87067 87067 NO 23585 STATE MEASURE 3 9867 0150079A 143 349 492
87069 87069 NO 23585 STATE MEASURE 3 9867 0150082A 213 278 491
87071 87071 NO 23585 STATE MEASURE 3 9867 0150085A 83 185 268
87073 87073 NO 23585 STATE MEASURE 3 9867 0180002A 77 169 246
87075 87075 NO 23585 STATE MEASURE 3 9867 0200005A 218 519 737
87077 87077 NO 23585 STATE MEASURE 3 9867 0200015A 221 437 658
87079 87079 NO 23585 STATE MEASURE 3 9867 0200016A 257 638 895
87081 87081 NO 23585 STATE MEASURE 3 9867 0200018A 35 67 102
87083 87083 NO 23585 STATE MEASURE 3 9867 0200019A 103 218 321
87085 87085 NO 23585 STATE MEASURE 3 9867 0200025B 133 296 429
87087 87087 NO 23585 STATE MEASURE 3 9867 0200027A 0 0 0
87089 87089 NO 23585 STATE MEASURE 3 9867 0200029A 78 191 269
87091 87091 NO 23585 STATE MEASURE 3 9867 0200030C 0 0 0
87093 87093 NO 23585 STATE MEASURE 3 9867 0200031A 0 0 0
87095 87095 NO 23585 STATE MEASURE 3 9867 0200040A 376 668 1044
87097 87097 NO 23585 STATE MEASURE 3 9867 0200041A 0 0 0
87099 87099 NO 23585 STATE MEASURE 3 9867 0200046A 125 267 392
87101 87101 NO 23585 STATE MEASURE 3 9867 0200048A 0 0 0
87103 87103 NO 23585 STATE MEASURE 3 9867 0200053A 0 0 0
87105 87105 NO 23585 STATE MEASURE 3 9867 0200064A 45 52 97
87107 87107 NO 23585 STATE MEASURE 3 9867 0200087A 253 480 733
87109 87109 NO 23585 STATE MEASURE 3 9867 0200094A 0 0 0
87111 87111 NO 23585 STATE MEASURE 3 9867 0200094H 0 0 0
87113 87113 NO 23585 STATE MEASURE 3 9867 0300001D 1 2 3
87115 87115 NO 23585 STATE MEASURE 3 9867 0300001G 31 45 76
87117 87117 NO 23585 STATE MEASURE 3 9867 0300002A 38 71 109
87119 87119 NO 23585 STATE MEASURE 3 9867 0300002B 4 2 6
87121 87121 NO 23585 STATE MEASURE 3 9867 0300002C 3 12 15
87123 87123 NO 23585 STATE MEASURE 3 9867 0300003A 11 10 21
87125 87125 NO 23585 STATE MEASURE 3 9867 0300005A 0 0 0
87127 87127 NO 23585 STATE MEASURE 3 9867 0300006B 0 0 0
87129 87129 NO 23585 STATE MEASURE 3 9867 0300012A 51 76 127

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