results

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

3,988 rows where candidate_id = 23587

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
218016 218016 YES 23587 STATE MEASURE 5 9868 0050002B 30 0 30
218018 218018 YES 23587 STATE MEASURE 5 9868 0050002G 1 0 1
218020 218020 YES 23587 STATE MEASURE 5 9868 0050003A 71 140 211
218022 218022 YES 23587 STATE MEASURE 5 9868 0050005A 165 383 548
218024 218024 YES 23587 STATE MEASURE 5 9868 0050007B 0 0 0
218026 218026 YES 23587 STATE MEASURE 5 9868 0050010A 0 0 0
218028 218028 YES 23587 STATE MEASURE 5 9868 0050014A 25 73 98
218030 218030 YES 23587 STATE MEASURE 5 9868 0050015A 1 0 1
218032 218032 YES 23587 STATE MEASURE 5 9868 0050022D 0 1 1
218034 218034 YES 23587 STATE MEASURE 5 9868 0050023D 0 0 0
218036 218036 YES 23587 STATE MEASURE 5 9868 0050025H 0 0 0
218038 218038 YES 23587 STATE MEASURE 5 9868 0050027A 1 0 1
218040 218040 YES 23587 STATE MEASURE 5 9868 0050029A 0 0 0
218042 218042 YES 23587 STATE MEASURE 5 9868 0050037A 0 0 0
218044 218044 YES 23587 STATE MEASURE 5 9868 0050042A 1 0 1
218046 218046 YES 23587 STATE MEASURE 5 9868 0050055A 0 0 0
218048 218048 YES 23587 STATE MEASURE 5 9868 0050066A 0 0 0
218050 218050 YES 23587 STATE MEASURE 5 9868 0070001A 34 143 177
218052 218052 YES 23587 STATE MEASURE 5 9868 0070002A 1 15 16
218054 218054 YES 23587 STATE MEASURE 5 9868 0070005A 76 282 358
218056 218056 YES 23587 STATE MEASURE 5 9868 0070005B 2 5 7
218058 218058 YES 23587 STATE MEASURE 5 9868 0070006A 129 401 530
218060 218060 YES 23587 STATE MEASURE 5 9868 0070027A 0 0 0
218062 218062 YES 23587 STATE MEASURE 5 9868 0070027B 0 1 1
218064 218064 YES 23587 STATE MEASURE 5 9868 0070027C 0 0 0
218066 218066 YES 23587 STATE MEASURE 5 9868 0070041B 7 31 38
218068 218068 YES 23587 STATE MEASURE 5 9868 0070041F 3 7 10
218070 218070 YES 23587 STATE MEASURE 5 9868 0070207A 0 6 6
218072 218072 YES 23587 STATE MEASURE 5 9868 0080004A 91 588 679
218074 218074 YES 23587 STATE MEASURE 5 9868 0080007A 194 926 1120
218076 218076 YES 23587 STATE MEASURE 5 9868 0080050A 267 1043 1310
218078 218078 YES 23587 STATE MEASURE 5 9868 0080054A 106 365 471
218080 218080 YES 23587 STATE MEASURE 5 9868 0080070A 114 746 860
218082 218082 YES 23587 STATE MEASURE 5 9868 0090002A 0 0 0
218084 218084 YES 23587 STATE MEASURE 5 9868 0090002B 0 0 0
218086 218086 YES 23587 STATE MEASURE 5 9868 0090002C 0 0 0
218088 218088 YES 23587 STATE MEASURE 5 9868 0090005C 0 0 0
218090 218090 YES 23587 STATE MEASURE 5 9868 0090005G 0 0 0
218092 218092 YES 23587 STATE MEASURE 5 9868 0090006A 8 8 16
218094 218094 YES 23587 STATE MEASURE 5 9868 0090007C 0 1 1
218096 218096 YES 23587 STATE MEASURE 5 9868 0090009A 0 0 0
218098 218098 YES 23587 STATE MEASURE 5 9868 0090010A 0 0 0
218100 218100 YES 23587 STATE MEASURE 5 9868 0090011B 1 3 4
218102 218102 YES 23587 STATE MEASURE 5 9868 0090012A 0 0 0
218104 218104 YES 23587 STATE MEASURE 5 9868 0090017A 0 0 0
218106 218106 YES 23587 STATE MEASURE 5 9868 0090019A 0 0 0
218108 218108 YES 23587 STATE MEASURE 5 9868 0090021A 0 0 0
218110 218110 YES 23587 STATE MEASURE 5 9868 0090023A 0 0 0
218112 218112 YES 23587 STATE MEASURE 5 9868 0090025A 0 3 3
218114 218114 YES 23587 STATE MEASURE 5 9868 0090025B 0 0 0
218116 218116 YES 23587 STATE MEASURE 5 9868 0090026A 92 328 420
218118 218118 YES 23587 STATE MEASURE 5 9868 0150003A 343 1259 1602
218120 218120 YES 23587 STATE MEASURE 5 9868 0150005D 0 0 0
218122 218122 YES 23587 STATE MEASURE 5 9868 0150005E 0 1 1
218124 218124 YES 23587 STATE MEASURE 5 9868 0150012A 349 1109 1458
218126 218126 YES 23587 STATE MEASURE 5 9868 0150016D 346 1013 1359
218128 218128 YES 23587 STATE MEASURE 5 9868 0150023A 229 722 951
218130 218130 YES 23587 STATE MEASURE 5 9868 0150025A 296 740 1036
218132 218132 YES 23587 STATE MEASURE 5 9868 0150032B 4 8 12
218134 218134 YES 23587 STATE MEASURE 5 9868 0150034A 220 801 1021
218136 218136 YES 23587 STATE MEASURE 5 9868 0150042A 136 450 586
218138 218138 YES 23587 STATE MEASURE 5 9868 0150045A 214 664 878
218140 218140 YES 23587 STATE MEASURE 5 9868 0150049A 52 236 288
218142 218142 YES 23587 STATE MEASURE 5 9868 0150055A 17 101 118
218144 218144 YES 23587 STATE MEASURE 5 9868 0150065A 275 757 1032
218146 218146 YES 23587 STATE MEASURE 5 9868 0150070A 43 137 180
218148 218148 YES 23587 STATE MEASURE 5 9868 0150071A 291 782 1073
218150 218150 YES 23587 STATE MEASURE 5 9868 0150078A 79 191 270
218152 218152 YES 23587 STATE MEASURE 5 9868 0150079A 130 481 611
218154 218154 YES 23587 STATE MEASURE 5 9868 0150082A 246 631 877
218156 218156 YES 23587 STATE MEASURE 5 9868 0150085A 81 258 339
218158 218158 YES 23587 STATE MEASURE 5 9868 0180002A 106 228 334
218160 218160 YES 23587 STATE MEASURE 5 9868 0200005A 365 1413 1778
218162 218162 YES 23587 STATE MEASURE 5 9868 0200015A 410 1046 1456
218164 218164 YES 23587 STATE MEASURE 5 9868 0200016A 291 1504 1795
218166 218166 YES 23587 STATE MEASURE 5 9868 0200018A 67 196 263
218168 218168 YES 23587 STATE MEASURE 5 9868 0200019A 184 715 899
218170 218170 YES 23587 STATE MEASURE 5 9868 0200025B 219 1032 1251
218172 218172 YES 23587 STATE MEASURE 5 9868 0200027A 0 0 0
218174 218174 YES 23587 STATE MEASURE 5 9868 0200029A 128 596 724
218176 218176 YES 23587 STATE MEASURE 5 9868 0200030C 0 0 0
218178 218178 YES 23587 STATE MEASURE 5 9868 0200031A 0 3 3
218180 218180 YES 23587 STATE MEASURE 5 9868 0200040A 355 1251 1606
218182 218182 YES 23587 STATE MEASURE 5 9868 0200041A 0 0 0
218184 218184 YES 23587 STATE MEASURE 5 9868 0200046A 261 673 934
218186 218186 YES 23587 STATE MEASURE 5 9868 0200048A 0 1 1
218188 218188 YES 23587 STATE MEASURE 5 9868 0200053A 0 0 0
218190 218190 YES 23587 STATE MEASURE 5 9868 0200064A 65 252 317
218192 218192 YES 23587 STATE MEASURE 5 9868 0200087A 410 1517 1927
218194 218194 YES 23587 STATE MEASURE 5 9868 0200094A 0 0 0
218196 218196 YES 23587 STATE MEASURE 5 9868 0200094H 0 0 0
218198 218198 YES 23587 STATE MEASURE 5 9868 0300001D 1 2 3
218200 218200 YES 23587 STATE MEASURE 5 9868 0300001G 16 22 38
218202 218202 YES 23587 STATE MEASURE 5 9868 0300002A 15 29 44
218204 218204 YES 23587 STATE MEASURE 5 9868 0300002B 1 2 3
218206 218206 YES 23587 STATE MEASURE 5 9868 0300002C 2 4 6
218208 218208 YES 23587 STATE MEASURE 5 9868 0300003A 3 6 9
218210 218210 YES 23587 STATE MEASURE 5 9868 0300005A 0 0 0
218212 218212 YES 23587 STATE MEASURE 5 9868 0300006B 0 0 0
218214 218214 YES 23587 STATE MEASURE 5 9868 0300012A 16 23 39

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