results

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

3,988 rows where candidate_id = 23589

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
202044 202044 YES 23589 STATE MEASURE 6 9869 0050002B 20 0 20
202046 202046 YES 23589 STATE MEASURE 6 9869 0050002G 1 0 1
202048 202048 YES 23589 STATE MEASURE 6 9869 0050003A 80 193 273
202050 202050 YES 23589 STATE MEASURE 6 9869 0050005A 219 418 637
202052 202052 YES 23589 STATE MEASURE 6 9869 0050007B 0 0 0
202054 202054 YES 23589 STATE MEASURE 6 9869 0050010A 0 0 0
202056 202056 YES 23589 STATE MEASURE 6 9869 0050014A 35 99 134
202058 202058 YES 23589 STATE MEASURE 6 9869 0050015A 0 0 0
202060 202060 YES 23589 STATE MEASURE 6 9869 0050022D 0 1 1
202062 202062 YES 23589 STATE MEASURE 6 9869 0050023D 0 0 0
202064 202064 YES 23589 STATE MEASURE 6 9869 0050025H 0 0 0
202066 202066 YES 23589 STATE MEASURE 6 9869 0050027A 1 0 1
202068 202068 YES 23589 STATE MEASURE 6 9869 0050029A 0 0 0
202070 202070 YES 23589 STATE MEASURE 6 9869 0050037A 0 0 0
202072 202072 YES 23589 STATE MEASURE 6 9869 0050042A 1 0 1
202074 202074 YES 23589 STATE MEASURE 6 9869 0050055A 0 0 0
202076 202076 YES 23589 STATE MEASURE 6 9869 0050066A 0 0 0
202078 202078 YES 23589 STATE MEASURE 6 9869 0070001A 46 200 246
202080 202080 YES 23589 STATE MEASURE 6 9869 0070002A 3 19 22
202082 202082 YES 23589 STATE MEASURE 6 9869 0070005A 96 365 461
202084 202084 YES 23589 STATE MEASURE 6 9869 0070005B 2 6 8
202086 202086 YES 23589 STATE MEASURE 6 9869 0070006A 148 450 598
202088 202088 YES 23589 STATE MEASURE 6 9869 0070027A 0 0 0
202090 202090 YES 23589 STATE MEASURE 6 9869 0070027B 0 0 0
202092 202092 YES 23589 STATE MEASURE 6 9869 0070027C 0 0 0
202094 202094 YES 23589 STATE MEASURE 6 9869 0070041B 15 36 51
202096 202096 YES 23589 STATE MEASURE 6 9869 0070041F 4 4 8
202098 202098 YES 23589 STATE MEASURE 6 9869 0070207A 0 15 15
202100 202100 YES 23589 STATE MEASURE 6 9869 0080004A 98 706 804
202102 202102 YES 23589 STATE MEASURE 6 9869 0080007A 207 1102 1309
202104 202104 YES 23589 STATE MEASURE 6 9869 0080050A 288 1194 1482
202106 202106 YES 23589 STATE MEASURE 6 9869 0080054A 119 411 530
202108 202108 YES 23589 STATE MEASURE 6 9869 0080070A 140 863 1003
202110 202110 YES 23589 STATE MEASURE 6 9869 0090002A 1 0 1
202112 202112 YES 23589 STATE MEASURE 6 9869 0090002B 0 0 0
202114 202114 YES 23589 STATE MEASURE 6 9869 0090002C 0 0 0
202116 202116 YES 23589 STATE MEASURE 6 9869 0090005C 0 0 0
202118 202118 YES 23589 STATE MEASURE 6 9869 0090005G 0 1 1
202120 202120 YES 23589 STATE MEASURE 6 9869 0090006A 4 8 12
202122 202122 YES 23589 STATE MEASURE 6 9869 0090007C 0 0 0
202124 202124 YES 23589 STATE MEASURE 6 9869 0090009A 0 0 0
202126 202126 YES 23589 STATE MEASURE 6 9869 0090010A 0 0 0
202128 202128 YES 23589 STATE MEASURE 6 9869 0090011B 1 6 7
202130 202130 YES 23589 STATE MEASURE 6 9869 0090012A 0 0 0
202132 202132 YES 23589 STATE MEASURE 6 9869 0090017A 0 0 0
202134 202134 YES 23589 STATE MEASURE 6 9869 0090019A 0 0 0
202136 202136 YES 23589 STATE MEASURE 6 9869 0090021A 0 0 0
202138 202138 YES 23589 STATE MEASURE 6 9869 0090023A 0 0 0
202140 202140 YES 23589 STATE MEASURE 6 9869 0090025A 0 4 4
202142 202142 YES 23589 STATE MEASURE 6 9869 0090025B 0 0 0
202144 202144 YES 23589 STATE MEASURE 6 9869 0090026A 143 381 524
202146 202146 YES 23589 STATE MEASURE 6 9869 0150003A 324 1286 1610
202148 202148 YES 23589 STATE MEASURE 6 9869 0150005D 0 0 0
202150 202150 YES 23589 STATE MEASURE 6 9869 0150005E 0 2 2
202152 202152 YES 23589 STATE MEASURE 6 9869 0150012A 311 1122 1433
202154 202154 YES 23589 STATE MEASURE 6 9869 0150016D 356 1051 1407
202156 202156 YES 23589 STATE MEASURE 6 9869 0150023A 236 712 948
202158 202158 YES 23589 STATE MEASURE 6 9869 0150025A 260 740 1000
202160 202160 YES 23589 STATE MEASURE 6 9869 0150032B 3 5 8
202162 202162 YES 23589 STATE MEASURE 6 9869 0150034A 233 916 1149
202164 202164 YES 23589 STATE MEASURE 6 9869 0150042A 141 428 569
202166 202166 YES 23589 STATE MEASURE 6 9869 0150045A 201 654 855
202168 202168 YES 23589 STATE MEASURE 6 9869 0150049A 51 244 295
202170 202170 YES 23589 STATE MEASURE 6 9869 0150055A 19 93 112
202172 202172 YES 23589 STATE MEASURE 6 9869 0150065A 279 801 1080
202174 202174 YES 23589 STATE MEASURE 6 9869 0150070A 37 139 176
202176 202176 YES 23589 STATE MEASURE 6 9869 0150071A 277 843 1120
202178 202178 YES 23589 STATE MEASURE 6 9869 0150078A 63 192 255
202180 202180 YES 23589 STATE MEASURE 6 9869 0150079A 133 493 626
202182 202182 YES 23589 STATE MEASURE 6 9869 0150082A 264 665 929
202184 202184 YES 23589 STATE MEASURE 6 9869 0150085A 83 225 308
202186 202186 YES 23589 STATE MEASURE 6 9869 0180002A 105 236 341
202188 202188 YES 23589 STATE MEASURE 6 9869 0200005A 383 1600 1983
202190 202190 YES 23589 STATE MEASURE 6 9869 0200015A 404 1097 1501
202192 202192 YES 23589 STATE MEASURE 6 9869 0200016A 338 1714 2052
202194 202194 YES 23589 STATE MEASURE 6 9869 0200018A 64 208 272
202196 202196 YES 23589 STATE MEASURE 6 9869 0200019A 188 766 954
202198 202198 YES 23589 STATE MEASURE 6 9869 0200025B 238 1070 1308
202200 202200 YES 23589 STATE MEASURE 6 9869 0200027A 0 0 0
202202 202202 YES 23589 STATE MEASURE 6 9869 0200029A 136 672 808
202204 202204 YES 23589 STATE MEASURE 6 9869 0200030C 0 0 0
202206 202206 YES 23589 STATE MEASURE 6 9869 0200031A 0 3 3
202208 202208 YES 23589 STATE MEASURE 6 9869 0200040A 388 1426 1814
202210 202210 YES 23589 STATE MEASURE 6 9869 0200041A 0 0 0
202212 202212 YES 23589 STATE MEASURE 6 9869 0200046A 237 709 946
202214 202214 YES 23589 STATE MEASURE 6 9869 0200048A 0 1 1
202216 202216 YES 23589 STATE MEASURE 6 9869 0200053A 0 0 0
202218 202218 YES 23589 STATE MEASURE 6 9869 0200064A 71 272 343
202220 202220 YES 23589 STATE MEASURE 6 9869 0200087A 432 1632 2064
202222 202222 YES 23589 STATE MEASURE 6 9869 0200094A 0 0 0
202224 202224 YES 23589 STATE MEASURE 6 9869 0200094H 0 0 0
202226 202226 YES 23589 STATE MEASURE 6 9869 0300001D 1 4 5
202228 202228 YES 23589 STATE MEASURE 6 9869 0300001G 16 29 45
202230 202230 YES 23589 STATE MEASURE 6 9869 0300002A 10 36 46
202232 202232 YES 23589 STATE MEASURE 6 9869 0300002B 1 2 3
202234 202234 YES 23589 STATE MEASURE 6 9869 0300002C 3 2 5
202236 202236 YES 23589 STATE MEASURE 6 9869 0300003A 5 4 9
202238 202238 YES 23589 STATE MEASURE 6 9869 0300005A 0 0 0
202240 202240 YES 23589 STATE MEASURE 6 9869 0300006B 0 0 0
202242 202242 YES 23589 STATE MEASURE 6 9869 0300012A 13 18 31

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