results

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

7,976 rows where contest_id = 9870

✎ 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
141340 141340 YES 23591 STATE MEASURE 32 9870 0050002B 23 0 23
141341 141341 NO 23592 STATE MEASURE 32 9870 0050002B 18 1 19
141342 141342 YES 23591 STATE MEASURE 32 9870 0050002G 1 0 1
141343 141343 NO 23592 STATE MEASURE 32 9870 0050002G 0 0 0
141344 141344 YES 23591 STATE MEASURE 32 9870 0050003A 80 185 265
141345 141345 NO 23592 STATE MEASURE 32 9870 0050003A 424 520 944
141346 141346 YES 23591 STATE MEASURE 32 9870 0050005A 230 441 671
141347 141347 NO 23592 STATE MEASURE 32 9870 0050005A 831 1066 1897
141348 141348 YES 23591 STATE MEASURE 32 9870 0050007B 0 0 0
141349 141349 NO 23592 STATE MEASURE 32 9870 0050007B 0 0 0
141350 141350 YES 23591 STATE MEASURE 32 9870 0050010A 0 0 0
141351 141351 NO 23592 STATE MEASURE 32 9870 0050010A 2 1 3
141352 141352 YES 23591 STATE MEASURE 32 9870 0050014A 32 95 127
141353 141353 NO 23592 STATE MEASURE 32 9870 0050014A 149 237 386
141354 141354 YES 23591 STATE MEASURE 32 9870 0050015A 0 0 0
141355 141355 NO 23592 STATE MEASURE 32 9870 0050015A 1 0 1
141356 141356 YES 23591 STATE MEASURE 32 9870 0050022D 0 1 1
141357 141357 NO 23592 STATE MEASURE 32 9870 0050022D 0 1 1
141358 141358 YES 23591 STATE MEASURE 32 9870 0050023D 0 0 0
141359 141359 NO 23592 STATE MEASURE 32 9870 0050023D 0 0 0
141360 141360 YES 23591 STATE MEASURE 32 9870 0050025H 0 0 0
141361 141361 NO 23592 STATE MEASURE 32 9870 0050025H 0 0 0
141362 141362 YES 23591 STATE MEASURE 32 9870 0050027A 1 0 1
141363 141363 NO 23592 STATE MEASURE 32 9870 0050027A 0 0 0
141364 141364 YES 23591 STATE MEASURE 32 9870 0050029A 0 0 0
141365 141365 NO 23592 STATE MEASURE 32 9870 0050029A 0 0 0
141366 141366 YES 23591 STATE MEASURE 32 9870 0050037A 0 0 0
141367 141367 NO 23592 STATE MEASURE 32 9870 0050037A 0 0 0
141368 141368 YES 23591 STATE MEASURE 32 9870 0050042A 1 0 1
141369 141369 NO 23592 STATE MEASURE 32 9870 0050042A 0 2 2
141370 141370 YES 23591 STATE MEASURE 32 9870 0050055A 0 0 0
141371 141371 NO 23592 STATE MEASURE 32 9870 0050055A 0 0 0
141372 141372 YES 23591 STATE MEASURE 32 9870 0050066A 0 0 0
141373 141373 NO 23592 STATE MEASURE 32 9870 0050066A 0 0 0
141374 141374 YES 23591 STATE MEASURE 32 9870 0070001A 37 176 213
141375 141375 NO 23592 STATE MEASURE 32 9870 0070001A 161 347 508
141376 141376 YES 23591 STATE MEASURE 32 9870 0070002A 2 17 19
141377 141377 NO 23592 STATE MEASURE 32 9870 0070002A 14 36 50
141378 141378 YES 23591 STATE MEASURE 32 9870 0070005A 90 320 410
141379 141379 NO 23592 STATE MEASURE 32 9870 0070005A 164 479 643
141380 141380 YES 23591 STATE MEASURE 32 9870 0070005B 3 4 7
141381 141381 NO 23592 STATE MEASURE 32 9870 0070005B 1 2 3
141382 141382 YES 23591 STATE MEASURE 32 9870 0070006A 163 458 621
141383 141383 NO 23592 STATE MEASURE 32 9870 0070006A 189 454 643
141384 141384 YES 23591 STATE MEASURE 32 9870 0070027A 0 0 0
141385 141385 NO 23592 STATE MEASURE 32 9870 0070027A 0 0 0
141386 141386 YES 23591 STATE MEASURE 32 9870 0070027B 0 1 1
141387 141387 NO 23592 STATE MEASURE 32 9870 0070027B 2 0 2
141388 141388 YES 23591 STATE MEASURE 32 9870 0070027C 0 0 0
141389 141389 NO 23592 STATE MEASURE 32 9870 0070027C 0 0 0
141390 141390 YES 23591 STATE MEASURE 32 9870 0070041B 18 37 55
141391 141391 NO 23592 STATE MEASURE 32 9870 0070041B 25 64 89
141392 141392 YES 23591 STATE MEASURE 32 9870 0070041F 3 5 8
141393 141393 NO 23592 STATE MEASURE 32 9870 0070041F 7 8 15
141394 141394 YES 23591 STATE MEASURE 32 9870 0070207A 0 12 12
141395 141395 NO 23592 STATE MEASURE 32 9870 0070207A 6 20 26
141396 141396 YES 23591 STATE MEASURE 32 9870 0080004A 110 638 748
141397 141397 NO 23592 STATE MEASURE 32 9870 0080004A 285 795 1080
141398 141398 YES 23591 STATE MEASURE 32 9870 0080007A 209 1010 1219
141399 141399 NO 23592 STATE MEASURE 32 9870 0080007A 404 1115 1519
141400 141400 YES 23591 STATE MEASURE 32 9870 0080050A 280 1141 1421
141401 141401 NO 23592 STATE MEASURE 32 9870 0080050A 530 1351 1881
141402 141402 YES 23591 STATE MEASURE 32 9870 0080054A 121 404 525
141403 141403 NO 23592 STATE MEASURE 32 9870 0080054A 209 493 702
141404 141404 YES 23591 STATE MEASURE 32 9870 0080070A 164 807 971
141405 141405 NO 23592 STATE MEASURE 32 9870 0080070A 336 1097 1433
141406 141406 YES 23591 STATE MEASURE 32 9870 0090002A 0 0 0
141407 141407 NO 23592 STATE MEASURE 32 9870 0090002A 1 0 1
141408 141408 YES 23591 STATE MEASURE 32 9870 0090002B 0 0 0
141409 141409 NO 23592 STATE MEASURE 32 9870 0090002B 0 7 7
141410 141410 YES 23591 STATE MEASURE 32 9870 0090002C 0 0 0
141411 141411 NO 23592 STATE MEASURE 32 9870 0090002C 0 0 0
141412 141412 YES 23591 STATE MEASURE 32 9870 0090005C 0 0 0
141413 141413 NO 23592 STATE MEASURE 32 9870 0090005C 0 0 0
141414 141414 YES 23591 STATE MEASURE 32 9870 0090005G 0 0 0
141415 141415 NO 23592 STATE MEASURE 32 9870 0090005G 0 1 1
141416 141416 YES 23591 STATE MEASURE 32 9870 0090006A 8 12 20
141417 141417 NO 23592 STATE MEASURE 32 9870 0090006A 8 6 14
141418 141418 YES 23591 STATE MEASURE 32 9870 0090007C 0 0 0
141419 141419 NO 23592 STATE MEASURE 32 9870 0090007C 0 1 1
141420 141420 YES 23591 STATE MEASURE 32 9870 0090009A 0 0 0
141421 141421 NO 23592 STATE MEASURE 32 9870 0090009A 0 0 0
141422 141422 YES 23591 STATE MEASURE 32 9870 0090010A 0 0 0
141423 141423 NO 23592 STATE MEASURE 32 9870 0090010A 0 0 0
141424 141424 YES 23591 STATE MEASURE 32 9870 0090011B 1 5 6
141425 141425 NO 23592 STATE MEASURE 32 9870 0090011B 4 9 13
141426 141426 YES 23591 STATE MEASURE 32 9870 0090012A 0 0 0
141427 141427 NO 23592 STATE MEASURE 32 9870 0090012A 1 10 11
141428 141428 YES 23591 STATE MEASURE 32 9870 0090017A 0 0 0
141429 141429 NO 23592 STATE MEASURE 32 9870 0090017A 0 0 0
141430 141430 YES 23591 STATE MEASURE 32 9870 0090019A 0 0 0
141431 141431 NO 23592 STATE MEASURE 32 9870 0090019A 0 0 0
141432 141432 YES 23591 STATE MEASURE 32 9870 0090021A 0 0 0
141433 141433 NO 23592 STATE MEASURE 32 9870 0090021A 0 0 0
141434 141434 YES 23591 STATE MEASURE 32 9870 0090023A 0 0 0
141435 141435 NO 23592 STATE MEASURE 32 9870 0090023A 0 0 0
141436 141436 YES 23591 STATE MEASURE 32 9870 0090025A 0 4 4
141437 141437 NO 23592 STATE MEASURE 32 9870 0090025A 0 0 0
141438 141438 YES 23591 STATE MEASURE 32 9870 0090025B 0 0 0
141439 141439 NO 23592 STATE MEASURE 32 9870 0090025B 0 0 0

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