results

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

3,988 rows where candidate_id = 23592

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ candidate_id contest_id precinct_id polling_place vote_by_mail total
141341 141341 NO 23592 STATE MEASURE 32 9870 0050002B 18 1 19
141343 141343 NO 23592 STATE MEASURE 32 9870 0050002G 0 0 0
141345 141345 NO 23592 STATE MEASURE 32 9870 0050003A 424 520 944
141347 141347 NO 23592 STATE MEASURE 32 9870 0050005A 831 1066 1897
141349 141349 NO 23592 STATE MEASURE 32 9870 0050007B 0 0 0
141351 141351 NO 23592 STATE MEASURE 32 9870 0050010A 2 1 3
141353 141353 NO 23592 STATE MEASURE 32 9870 0050014A 149 237 386
141355 141355 NO 23592 STATE MEASURE 32 9870 0050015A 1 0 1
141357 141357 NO 23592 STATE MEASURE 32 9870 0050022D 0 1 1
141359 141359 NO 23592 STATE MEASURE 32 9870 0050023D 0 0 0
141361 141361 NO 23592 STATE MEASURE 32 9870 0050025H 0 0 0
141363 141363 NO 23592 STATE MEASURE 32 9870 0050027A 0 0 0
141365 141365 NO 23592 STATE MEASURE 32 9870 0050029A 0 0 0
141367 141367 NO 23592 STATE MEASURE 32 9870 0050037A 0 0 0
141369 141369 NO 23592 STATE MEASURE 32 9870 0050042A 0 2 2
141371 141371 NO 23592 STATE MEASURE 32 9870 0050055A 0 0 0
141373 141373 NO 23592 STATE MEASURE 32 9870 0050066A 0 0 0
141375 141375 NO 23592 STATE MEASURE 32 9870 0070001A 161 347 508
141377 141377 NO 23592 STATE MEASURE 32 9870 0070002A 14 36 50
141379 141379 NO 23592 STATE MEASURE 32 9870 0070005A 164 479 643
141381 141381 NO 23592 STATE MEASURE 32 9870 0070005B 1 2 3
141383 141383 NO 23592 STATE MEASURE 32 9870 0070006A 189 454 643
141385 141385 NO 23592 STATE MEASURE 32 9870 0070027A 0 0 0
141387 141387 NO 23592 STATE MEASURE 32 9870 0070027B 2 0 2
141389 141389 NO 23592 STATE MEASURE 32 9870 0070027C 0 0 0
141391 141391 NO 23592 STATE MEASURE 32 9870 0070041B 25 64 89
141393 141393 NO 23592 STATE MEASURE 32 9870 0070041F 7 8 15
141395 141395 NO 23592 STATE MEASURE 32 9870 0070207A 6 20 26
141397 141397 NO 23592 STATE MEASURE 32 9870 0080004A 285 795 1080
141399 141399 NO 23592 STATE MEASURE 32 9870 0080007A 404 1115 1519
141401 141401 NO 23592 STATE MEASURE 32 9870 0080050A 530 1351 1881
141403 141403 NO 23592 STATE MEASURE 32 9870 0080054A 209 493 702
141405 141405 NO 23592 STATE MEASURE 32 9870 0080070A 336 1097 1433
141407 141407 NO 23592 STATE MEASURE 32 9870 0090002A 1 0 1
141409 141409 NO 23592 STATE MEASURE 32 9870 0090002B 0 7 7
141411 141411 NO 23592 STATE MEASURE 32 9870 0090002C 0 0 0
141413 141413 NO 23592 STATE MEASURE 32 9870 0090005C 0 0 0
141415 141415 NO 23592 STATE MEASURE 32 9870 0090005G 0 1 1
141417 141417 NO 23592 STATE MEASURE 32 9870 0090006A 8 6 14
141419 141419 NO 23592 STATE MEASURE 32 9870 0090007C 0 1 1
141421 141421 NO 23592 STATE MEASURE 32 9870 0090009A 0 0 0
141423 141423 NO 23592 STATE MEASURE 32 9870 0090010A 0 0 0
141425 141425 NO 23592 STATE MEASURE 32 9870 0090011B 4 9 13
141427 141427 NO 23592 STATE MEASURE 32 9870 0090012A 1 10 11
141429 141429 NO 23592 STATE MEASURE 32 9870 0090017A 0 0 0
141431 141431 NO 23592 STATE MEASURE 32 9870 0090019A 0 0 0
141433 141433 NO 23592 STATE MEASURE 32 9870 0090021A 0 0 0
141435 141435 NO 23592 STATE MEASURE 32 9870 0090023A 0 0 0
141437 141437 NO 23592 STATE MEASURE 32 9870 0090025A 0 0 0
141439 141439 NO 23592 STATE MEASURE 32 9870 0090025B 0 0 0
141441 141441 NO 23592 STATE MEASURE 32 9870 0090026A 537 927 1464
141443 141443 NO 23592 STATE MEASURE 32 9870 0150003A 392 1143 1535
141445 141445 NO 23592 STATE MEASURE 32 9870 0150005D 1 3 4
141447 141447 NO 23592 STATE MEASURE 32 9870 0150005E 0 1 1
141449 141449 NO 23592 STATE MEASURE 32 9870 0150012A 291 872 1163
141451 141451 NO 23592 STATE MEASURE 32 9870 0150016D 404 950 1354
141453 141453 NO 23592 STATE MEASURE 32 9870 0150023A 267 590 857
141455 141455 NO 23592 STATE MEASURE 32 9870 0150025A 213 543 756
141457 141457 NO 23592 STATE MEASURE 32 9870 0150032B 3 4 7
141459 141459 NO 23592 STATE MEASURE 32 9870 0150034A 328 807 1135
141461 141461 NO 23592 STATE MEASURE 32 9870 0150042A 160 390 550
141463 141463 NO 23592 STATE MEASURE 32 9870 0150045A 281 705 986
141465 141465 NO 23592 STATE MEASURE 32 9870 0150049A 98 279 377
141467 141467 NO 23592 STATE MEASURE 32 9870 0150055A 50 138 188
141469 141469 NO 23592 STATE MEASURE 32 9870 0150065A 361 914 1275
141471 141471 NO 23592 STATE MEASURE 32 9870 0150070A 69 183 252
141473 141473 NO 23592 STATE MEASURE 32 9870 0150071A 295 786 1081
141475 141475 NO 23592 STATE MEASURE 32 9870 0150078A 64 134 198
141477 141477 NO 23592 STATE MEASURE 32 9870 0150079A 185 513 698
141479 141479 NO 23592 STATE MEASURE 32 9870 0150082A 272 491 763
141481 141481 NO 23592 STATE MEASURE 32 9870 0150085A 87 228 315
141483 141483 NO 23592 STATE MEASURE 32 9870 0180002A 87 150 237
141485 141485 NO 23592 STATE MEASURE 32 9870 0200005A 245 841 1086
141487 141487 NO 23592 STATE MEASURE 32 9870 0200015A 237 542 779
141489 141489 NO 23592 STATE MEASURE 32 9870 0200016A 406 1507 1913
141491 141491 NO 23592 STATE MEASURE 32 9870 0200018A 22 99 121
141493 141493 NO 23592 STATE MEASURE 32 9870 0200019A 114 346 460
141495 141495 NO 23592 STATE MEASURE 32 9870 0200025B 156 645 801
141497 141497 NO 23592 STATE MEASURE 32 9870 0200027A 0 0 0
141499 141499 NO 23592 STATE MEASURE 32 9870 0200029A 114 401 515
141501 141501 NO 23592 STATE MEASURE 32 9870 0200030C 0 0 0
141503 141503 NO 23592 STATE MEASURE 32 9870 0200031A 0 0 0
141505 141505 NO 23592 STATE MEASURE 32 9870 0200040A 455 1075 1530
141507 141507 NO 23592 STATE MEASURE 32 9870 0200041A 0 0 0
141509 141509 NO 23592 STATE MEASURE 32 9870 0200046A 147 320 467
141511 141511 NO 23592 STATE MEASURE 32 9870 0200048A 0 0 0
141513 141513 NO 23592 STATE MEASURE 32 9870 0200053A 0 0 0
141515 141515 NO 23592 STATE MEASURE 32 9870 0200064A 64 131 195
141517 141517 NO 23592 STATE MEASURE 32 9870 0200087A 311 799 1110
141519 141519 NO 23592 STATE MEASURE 32 9870 0200094A 0 0 0
141521 141521 NO 23592 STATE MEASURE 32 9870 0200094H 0 0 0
141523 141523 NO 23592 STATE MEASURE 32 9870 0300001D 0 2 2
141525 141525 NO 23592 STATE MEASURE 32 9870 0300001G 19 41 60
141527 141527 NO 23592 STATE MEASURE 32 9870 0300002A 34 81 115
141529 141529 NO 23592 STATE MEASURE 32 9870 0300002B 4 2 6
141531 141531 NO 23592 STATE MEASURE 32 9870 0300002C 5 10 15
141533 141533 NO 23592 STATE MEASURE 32 9870 0300003A 11 12 23
141535 141535 NO 23592 STATE MEASURE 32 9870 0300005A 0 0 0
141537 141537 NO 23592 STATE MEASURE 32 9870 0300006B 0 0 0
141539 141539 NO 23592 STATE MEASURE 32 9870 0300012A 52 69 121

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