results

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

2,210 rows where candidate_id = 21995

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
153913 153913 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0050002B 4 0 4
153915 153915 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0050003A 128 205 333
153917 153917 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0050004A 140 272 412
153919 153919 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0050010A 0 0 0
153921 153921 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0050013A 128 237 365
153923 153923 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0050042A 0 2 2
153925 153925 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0070002A 3 13 16
153927 153927 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0070005A 39 179 218
153929 153929 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0070005B 1 6 7
153931 153931 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0070006A 39 174 213
153933 153933 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0070008A 40 98 138
153935 153935 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0070041B 6 24 30
153937 153937 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0080004A 99 278 377
153939 153939 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0080007A 118 429 547
153941 153941 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0080050A 141 451 592
153943 153943 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0080054A 65 178 243
153945 153945 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0080070A 117 440 557
153947 153947 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0090002A 0 0 0
153949 153949 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0090006A 2 1 3
153951 153951 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0090011B 0 3 3
153953 153953 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0090012A 1 1 2
153955 153955 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0090025A 0 1 1
153957 153957 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0090026A 152 326 478
153959 153959 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150003A 111 342 453
153961 153961 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150012A 82 304 386
153963 153963 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150016D 69 278 347
153965 153965 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150021A 53 226 279
153967 153967 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150023A 74 233 307
153969 153969 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150037A 75 263 338
153971 153971 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150039A 60 242 302
153973 153973 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150049A 55 215 270
153975 153975 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150054A 47 254 301
153977 153977 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150055A 52 189 241
153979 153979 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150065A 118 329 447
153981 153981 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150072A 75 258 333
153983 153983 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150079A 90 319 409
153985 153985 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0150082A 81 248 329
153987 153987 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0180002A 14 39 53
153989 153989 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200011A 113 365 478
153991 153991 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200012A 87 267 354
153993 153993 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200013A 62 281 343
153995 153995 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200015A 102 246 348
153997 153997 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200016A 96 404 500
153999 153999 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200024A 94 407 501
154001 154001 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200025B 48 118 166
154003 154003 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200029A 93 339 432
154005 154005 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200031A 0 0 0
154007 154007 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200038A 105 410 515
154009 154009 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0200087A 96 242 338
154011 154011 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0300001G 2 15 17
154013 154013 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0300002A 19 69 88
154015 154015 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0300002B 9 14 23
154017 154017 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0300016A 4 7 11
154019 154019 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350007A 67 290 357
154021 154021 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350012A 122 502 624
154023 154023 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350020A 77 359 436
154025 154025 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350027A 72 313 385
154027 154027 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350034A 50 322 372
154029 154029 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350038A 52 226 278
154031 154031 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350042A 89 260 349
154033 154033 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350048A 46 233 279
154035 154035 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350054A 59 314 373
154037 154037 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350061A 5 2 7
154039 154039 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350062B 91 464 555
154041 154041 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0350101A 0 1 1
154043 154043 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0400001A 76 205 281
154045 154045 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0400012A 68 191 259
154047 154047 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0400018A 47 201 248
154049 154049 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0450008A 21 117 138
154051 154051 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0450010A 33 118 151
154053 154053 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0450014A 18 85 103
154055 154055 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0500002A 79 150 229
154057 154057 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0520004A 39 149 188
154059 154059 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0520024A 45 129 174
154061 154061 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0520025A 81 298 379
154063 154063 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0520027A 61 70 131
154065 154065 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550010C 2 0 2
154067 154067 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550011A 103 366 469
154069 154069 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550012A 74 197 271
154071 154071 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550016A 79 149 228
154073 154073 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550018A 59 209 268
154075 154075 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550020A 59 186 245
154077 154077 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550024A 11 55 66
154079 154079 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550073A 99 231 330
154081 154081 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550078A 73 225 298
154083 154083 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0550086A 106 323 429
154085 154085 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600008B 62 238 300
154087 154087 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600014A 55 261 316
154089 154089 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600020A 37 157 194
154091 154091 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600029C 44 135 179
154093 154093 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600034A 58 136 194
154095 154095 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600035A 46 158 204
154097 154097 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600036A 47 194 241
154099 154099 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600037A 36 114 150
154101 154101 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600038A 61 147 208
154103 154103 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600039A 58 169 227
154105 154105 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600041A 58 133 191
154107 154107 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600053A 60 164 224
154109 154109 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0600061A 27 176 203
154111 154111 EMILY THERESA SPEAR 21995 JUDGE OF THE SUPERIOR COURT Office No. 124 9084 0670008A 59 184 243

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