results

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

5,980 rows where contest_id = 8827

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate_id

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
130163 130163 YES 20690 STATE MEASURE 30 8827 0050001B 11 18 29
130164 130164 NO 20691 STATE MEASURE 30 8827 0050001B 33 48 81
130165 130165 YES 20690 STATE MEASURE 30 8827 0050002C 2 0 2
130166 130166 NO 20691 STATE MEASURE 30 8827 0050002C 1 0 1
130167 130167 YES 20690 STATE MEASURE 30 8827 0050003A 46 179 225
130168 130168 NO 20691 STATE MEASURE 30 8827 0050003A 367 487 854
130169 130169 YES 20690 STATE MEASURE 30 8827 0050004B 14 39 53
130170 130170 NO 20691 STATE MEASURE 30 8827 0050004B 95 116 211
130171 130171 YES 20690 STATE MEASURE 30 8827 0050011A 0 0 0
130172 130172 NO 20691 STATE MEASURE 30 8827 0050011A 1 1 2
130173 130173 YES 20690 STATE MEASURE 30 8827 0050014A 11 60 71
130174 130174 NO 20691 STATE MEASURE 30 8827 0050014A 98 230 328
130175 130175 YES 20690 STATE MEASURE 30 8827 0050023A 0 0 0
130176 130176 NO 20691 STATE MEASURE 30 8827 0050023A 4 0 4
130177 130177 YES 20690 STATE MEASURE 30 8827 0050042A 0 1 1
130178 130178 NO 20691 STATE MEASURE 30 8827 0050042A 0 1 1
130179 130179 YES 20690 STATE MEASURE 30 8827 0050063A 51 189 240
130180 130180 NO 20691 STATE MEASURE 30 8827 0050063A 429 686 1115
130181 130181 YES 20690 STATE MEASURE 30 8827 0070001B 3 17 20
130182 130182 NO 20691 STATE MEASURE 30 8827 0070001B 2 18 20
130183 130183 YES 20690 STATE MEASURE 30 8827 0070002A 0 16 16
130184 130184 NO 20691 STATE MEASURE 30 8827 0070002A 7 30 37
130185 130185 YES 20690 STATE MEASURE 30 8827 0070004C 3 10 13
130186 130186 NO 20691 STATE MEASURE 30 8827 0070004C 7 29 36
130187 130187 YES 20690 STATE MEASURE 30 8827 0070004E 11 72 83
130188 130188 NO 20691 STATE MEASURE 30 8827 0070004E 24 82 106
130189 130189 YES 20690 STATE MEASURE 30 8827 0070006N 2 13 15
130190 130190 NO 20691 STATE MEASURE 30 8827 0070006N 10 27 37
130191 130191 YES 20690 STATE MEASURE 30 8827 0070007A 32 199 231
130192 130192 NO 20691 STATE MEASURE 30 8827 0070007A 95 285 380
130193 130193 YES 20690 STATE MEASURE 30 8827 0070008A 22 127 149
130194 130194 NO 20691 STATE MEASURE 30 8827 0070008A 72 256 328
130195 130195 YES 20690 STATE MEASURE 30 8827 0070027B 0 0 0
130196 130196 NO 20691 STATE MEASURE 30 8827 0070027B 0 2 2
130197 130197 YES 20690 STATE MEASURE 30 8827 0070041A 36 213 249
130198 130198 NO 20691 STATE MEASURE 30 8827 0070041A 134 407 541
130199 130199 YES 20690 STATE MEASURE 30 8827 0070041B 8 56 64
130200 130200 NO 20691 STATE MEASURE 30 8827 0070041B 31 79 110
130201 130201 YES 20690 STATE MEASURE 30 8827 0070041K 2 5 7
130202 130202 NO 20691 STATE MEASURE 30 8827 0070041K 1 5 6
130203 130203 YES 20690 STATE MEASURE 30 8827 0070207A 1 9 10
130204 130204 NO 20691 STATE MEASURE 30 8827 0070207A 0 25 25
130205 130205 YES 20690 STATE MEASURE 30 8827 0080004A 71 402 473
130206 130206 NO 20691 STATE MEASURE 30 8827 0080004A 188 672 860
130207 130207 YES 20690 STATE MEASURE 30 8827 0080012A 49 432 481
130208 130208 NO 20691 STATE MEASURE 30 8827 0080012A 161 784 945
130209 130209 YES 20690 STATE MEASURE 30 8827 0080021A 65 613 678
130210 130210 NO 20691 STATE MEASURE 30 8827 0080021A 244 866 1110
130211 130211 YES 20690 STATE MEASURE 30 8827 0080025A 48 395 443
130212 130212 NO 20691 STATE MEASURE 30 8827 0080025A 160 577 737
130213 130213 YES 20690 STATE MEASURE 30 8827 0080038A 61 295 356
130214 130214 NO 20691 STATE MEASURE 30 8827 0080038A 132 418 550
130215 130215 YES 20690 STATE MEASURE 30 8827 0080043A 48 434 482
130216 130216 NO 20691 STATE MEASURE 30 8827 0080043A 146 551 697
130217 130217 YES 20690 STATE MEASURE 30 8827 0080050A 66 442 508
130218 130218 NO 20691 STATE MEASURE 30 8827 0080050A 184 700 884
130219 130219 YES 20690 STATE MEASURE 30 8827 0090002B 0 2 2
130220 130220 NO 20691 STATE MEASURE 30 8827 0090002B 5 12 17
130221 130221 YES 20690 STATE MEASURE 30 8827 0090003A 54 270 324
130222 130222 NO 20691 STATE MEASURE 30 8827 0090003A 468 853 1321
130223 130223 YES 20690 STATE MEASURE 30 8827 0090006A 2 6 8
130224 130224 NO 20691 STATE MEASURE 30 8827 0090006A 5 23 28
130225 130225 YES 20690 STATE MEASURE 30 8827 0090011A 0 5 5
130226 130226 NO 20691 STATE MEASURE 30 8827 0090011A 1 23 24
130227 130227 YES 20690 STATE MEASURE 30 8827 0090025A 1 4 5
130228 130228 NO 20691 STATE MEASURE 30 8827 0090025A 0 0 0
130229 130229 YES 20690 STATE MEASURE 30 8827 0150004A 68 506 574
130230 130230 NO 20691 STATE MEASURE 30 8827 0150004A 151 598 749
130231 130231 YES 20690 STATE MEASURE 30 8827 0150008A 71 218 289
130232 130232 NO 20691 STATE MEASURE 30 8827 0150008A 70 214 284
130233 130233 YES 20690 STATE MEASURE 30 8827 0150009A 58 303 361
130234 130234 NO 20691 STATE MEASURE 30 8827 0150009A 87 296 383
130235 130235 YES 20690 STATE MEASURE 30 8827 0150011A 65 338 403
130236 130236 NO 20691 STATE MEASURE 30 8827 0150011A 111 457 568
130237 130237 YES 20690 STATE MEASURE 30 8827 0150012A 92 487 579
130238 130238 NO 20691 STATE MEASURE 30 8827 0150012A 144 489 633
130239 130239 YES 20690 STATE MEASURE 30 8827 0150016D 86 551 637
130240 130240 NO 20691 STATE MEASURE 30 8827 0150016D 204 617 821
130241 130241 YES 20690 STATE MEASURE 30 8827 0150018A 97 539 636
130242 130242 NO 20691 STATE MEASURE 30 8827 0150018A 160 588 748
130243 130243 YES 20690 STATE MEASURE 30 8827 0150021A 26 224 250
130244 130244 NO 20691 STATE MEASURE 30 8827 0150021A 71 262 333
130245 130245 YES 20690 STATE MEASURE 30 8827 0150025A 86 428 514
130246 130246 NO 20691 STATE MEASURE 30 8827 0150025A 113 387 500
130247 130247 YES 20690 STATE MEASURE 30 8827 0150028B 35 260 295
130248 130248 NO 20691 STATE MEASURE 30 8827 0150028B 54 289 343
130249 130249 YES 20690 STATE MEASURE 30 8827 0150032A 88 428 516
130250 130250 NO 20691 STATE MEASURE 30 8827 0150032A 151 450 601
130251 130251 YES 20690 STATE MEASURE 30 8827 0150033A 73 320 393
130252 130252 NO 20691 STATE MEASURE 30 8827 0150033A 93 262 355
130253 130253 YES 20690 STATE MEASURE 30 8827 0150037A 38 215 253
130254 130254 NO 20691 STATE MEASURE 30 8827 0150037A 63 256 319
130255 130255 YES 20690 STATE MEASURE 30 8827 0150042A 59 357 416
130256 130256 NO 20691 STATE MEASURE 30 8827 0150042A 93 397 490
130257 130257 YES 20690 STATE MEASURE 30 8827 0150049A 69 425 494
130258 130258 NO 20691 STATE MEASURE 30 8827 0150049A 127 413 540
130259 130259 YES 20690 STATE MEASURE 30 8827 0150060A 46 307 353
130260 130260 NO 20691 STATE MEASURE 30 8827 0150060A 64 263 327
130261 130261 YES 20690 STATE MEASURE 30 8827 0150065A 58 198 256
130262 130262 NO 20691 STATE MEASURE 30 8827 0150065A 73 198 271

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