ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where county = "Westchester" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
471631 | 471631 | 2020-08-26 | Westchester | New York | 36119 | 36779 | 1449 |
474865 | 474865 | 2020-08-27 | Westchester | New York | 36119 | 36824 | 1450 |
478098 | 478098 | 2020-08-28 | Westchester | New York | 36119 | 36862 | 1450 |
481331 | 481331 | 2020-08-29 | Westchester | New York | 36119 | 36894 | 1450 |
171141 | 171141 | 2020-05-23 | Westchester | New York | 36119 | 32880 | 1451 |
484566 | 484566 | 2020-08-30 | Westchester | New York | 36119 | 36948 | 1451 |
487799 | 487799 | 2020-08-31 | Westchester | New York | 36119 | 36983 | 1452 |
491032 | 491032 | 2020-09-01 | Westchester | New York | 36119 | 37020 | 1452 |
494266 | 494266 | 2020-09-02 | Westchester | New York | 36119 | 37056 | 1452 |
497499 | 497499 | 2020-09-03 | Westchester | New York | 36119 | 37105 | 1452 |
500733 | 500733 | 2020-09-04 | Westchester | New York | 36119 | 37151 | 1452 |
503967 | 503967 | 2020-09-05 | Westchester | New York | 36119 | 37204 | 1452 |
507199 | 507199 | 2020-09-06 | Westchester | New York | 36119 | 37245 | 1452 |
510432 | 510432 | 2020-09-07 | Westchester | New York | 36119 | 37276 | 1452 |
513665 | 513665 | 2020-09-08 | Westchester | New York | 36119 | 37313 | 1452 |
516900 | 516900 | 2020-09-09 | Westchester | New York | 36119 | 37354 | 1452 |
520136 | 520136 | 2020-09-10 | Westchester | New York | 36119 | 37404 | 1452 |
523372 | 523372 | 2020-09-11 | Westchester | New York | 36119 | 37453 | 1452 |
526608 | 526608 | 2020-09-12 | Westchester | New York | 36119 | 37485 | 1452 |
529845 | 529845 | 2020-09-13 | Westchester | New York | 36119 | 37530 | 1452 |
533080 | 533080 | 2020-09-14 | Westchester | New York | 36119 | 37570 | 1453 |
536316 | 536316 | 2020-09-15 | Westchester | New York | 36119 | 37600 | 1453 |
539553 | 539553 | 2020-09-16 | Westchester | New York | 36119 | 37633 | 1454 |
542789 | 542789 | 2020-09-17 | Westchester | New York | 36119 | 37671 | 1454 |
546026 | 546026 | 2020-09-18 | Westchester | New York | 36119 | 37717 | 1454 |
549265 | 549265 | 2020-09-19 | Westchester | New York | 36119 | 37754 | 1454 |
552504 | 552504 | 2020-09-20 | Westchester | New York | 36119 | 37800 | 1454 |
555741 | 555741 | 2020-09-21 | Westchester | New York | 36119 | 37836 | 1454 |
558978 | 558978 | 2020-09-22 | Westchester | New York | 36119 | 37865 | 1454 |
562215 | 562215 | 2020-09-23 | Westchester | New York | 36119 | 37902 | 1455 |
565456 | 565456 | 2020-09-24 | Westchester | New York | 36119 | 37947 | 1455 |
568697 | 568697 | 2020-09-25 | Westchester | New York | 36119 | 38000 | 1456 |
571939 | 571939 | 2020-09-26 | Westchester | New York | 36119 | 38050 | 1456 |
575183 | 575183 | 2020-09-27 | Westchester | New York | 36119 | 38097 | 1456 |
578424 | 578424 | 2020-09-28 | Westchester | New York | 36119 | 38132 | 1456 |
581664 | 581664 | 2020-09-29 | Westchester | New York | 36119 | 38181 | 1456 |
584905 | 584905 | 2020-09-30 | Westchester | New York | 36119 | 38238 | 1456 |
588145 | 588145 | 2020-10-01 | Westchester | New York | 36119 | 38299 | 1456 |
591386 | 591386 | 2020-10-02 | Westchester | New York | 36119 | 38345 | 1456 |
594627 | 594627 | 2020-10-03 | Westchester | New York | 36119 | 38430 | 1456 |
597870 | 597870 | 2020-10-04 | Westchester | New York | 36119 | 38474 | 1457 |
601113 | 601113 | 2020-10-05 | Westchester | New York | 36119 | 38514 | 1457 |
604355 | 604355 | 2020-10-06 | Westchester | New York | 36119 | 38566 | 1457 |
607598 | 607598 | 2020-10-07 | Westchester | New York | 36119 | 38627 | 1458 |
610840 | 610840 | 2020-10-08 | Westchester | New York | 36119 | 38693 | 1459 |
614081 | 614081 | 2020-10-09 | Westchester | New York | 36119 | 38770 | 1460 |
617323 | 617323 | 2020-10-10 | Westchester | New York | 36119 | 38846 | 1461 |
620565 | 620565 | 2020-10-11 | Westchester | New York | 36119 | 38893 | 1461 |
174183 | 174183 | 2020-05-24 | Westchester | New York | 36119 | 32967 | 1462 |
623808 | 623808 | 2020-10-12 | Westchester | New York | 36119 | 39000 | 1462 |
627050 | 627050 | 2020-10-13 | Westchester | New York | 36119 | 39063 | 1462 |
630294 | 630294 | 2020-10-14 | Westchester | New York | 36119 | 39117 | 1462 |
633539 | 633539 | 2020-10-15 | Westchester | New York | 36119 | 39199 | 1463 |
636785 | 636785 | 2020-10-16 | Westchester | New York | 36119 | 39287 | 1465 |
640031 | 640031 | 2020-10-17 | Westchester | New York | 36119 | 39397 | 1466 |
177227 | 177227 | 2020-05-25 | Westchester | New York | 36119 | 33048 | 1467 |
643279 | 643279 | 2020-10-18 | Westchester | New York | 36119 | 39475 | 1467 |
180270 | 180270 | 2020-05-26 | Westchester | New York | 36119 | 33106 | 1469 |
646525 | 646525 | 2020-10-19 | Westchester | New York | 36119 | 39547 | 1469 |
649769 | 649769 | 2020-10-20 | Westchester | New York | 36119 | 39615 | 1469 |
653014 | 653014 | 2020-10-21 | Westchester | New York | 36119 | 39693 | 1470 |
656259 | 656259 | 2020-10-22 | Westchester | New York | 36119 | 39788 | 1470 |
659503 | 659503 | 2020-10-23 | Westchester | New York | 36119 | 39889 | 1470 |
662747 | 662747 | 2020-10-24 | Westchester | New York | 36119 | 40040 | 1471 |
665992 | 665992 | 2020-10-25 | Westchester | New York | 36119 | 40130 | 1471 |
669236 | 669236 | 2020-10-26 | Westchester | New York | 36119 | 40201 | 1471 |
685450 | 685450 | 2020-10-31 | Westchester | New York | 36119 | 40796 | 1471 |
672478 | 672478 | 2020-10-27 | Westchester | New York | 36119 | 40321 | 1472 |
675721 | 675721 | 2020-10-28 | Westchester | New York | 36119 | 40437 | 1472 |
688695 | 688695 | 2020-11-01 | Westchester | New York | 36119 | 40945 | 1472 |
678964 | 678964 | 2020-10-29 | Westchester | New York | 36119 | 40553 | 1473 |
682207 | 682207 | 2020-10-30 | Westchester | New York | 36119 | 40680 | 1473 |
691939 | 691939 | 2020-11-02 | Westchester | New York | 36119 | 41060 | 1473 |
695181 | 695181 | 2020-11-03 | Westchester | New York | 36119 | 41225 | 1473 |
698424 | 698424 | 2020-11-04 | Westchester | New York | 36119 | 41359 | 1473 |
701668 | 701668 | 2020-11-05 | Westchester | New York | 36119 | 41541 | 1474 |
704911 | 704911 | 2020-11-06 | Westchester | New York | 36119 | 41719 | 1475 |
183318 | 183318 | 2020-05-27 | Westchester | New York | 36119 | 33185 | 1476 |
708154 | 708154 | 2020-11-07 | Westchester | New York | 36119 | 41953 | 1476 |
711398 | 711398 | 2020-11-08 | Westchester | New York | 36119 | 42178 | 1477 |
714642 | 714642 | 2020-11-09 | Westchester | New York | 36119 | 42453 | 1479 |
717885 | 717885 | 2020-11-10 | Westchester | New York | 36119 | 42695 | 1480 |
186375 | 186375 | 2020-05-28 | Westchester | New York | 36119 | 33292 | 1481 |
721128 | 721128 | 2020-11-11 | Westchester | New York | 36119 | 42939 | 1482 |
724371 | 724371 | 2020-11-12 | Westchester | New York | 36119 | 43291 | 1482 |
727615 | 727615 | 2020-11-13 | Westchester | New York | 36119 | 43655 | 1483 |
189435 | 189435 | 2020-05-29 | Westchester | New York | 36119 | 33348 | 1484 |
730859 | 730859 | 2020-11-14 | Westchester | New York | 36119 | 44092 | 1486 |
734105 | 734105 | 2020-11-15 | Westchester | New York | 36119 | 44345 | 1488 |
737349 | 737349 | 2020-11-16 | Westchester | New York | 36119 | 44575 | 1490 |
740594 | 740594 | 2020-11-17 | Westchester | New York | 36119 | 44974 | 1490 |
192499 | 192499 | 2020-05-30 | Westchester | New York | 36119 | 33428 | 1492 |
743841 | 743841 | 2020-11-18 | Westchester | New York | 36119 | 45334 | 1493 |
747087 | 747087 | 2020-11-19 | Westchester | New York | 36119 | 45671 | 1494 |
750333 | 750333 | 2020-11-20 | Westchester | New York | 36119 | 46063 | 1498 |
195569 | 195569 | 2020-05-31 | Westchester | New York | 36119 | 33480 | 1499 |
753579 | 753579 | 2020-11-21 | Westchester | New York | 36119 | 46468 | 1499 |
756826 | 756826 | 2020-11-22 | Westchester | New York | 36119 | 46840 | 1500 |
760072 | 760072 | 2020-11-23 | Westchester | New York | 36119 | 47261 | 1500 |
198642 | 198642 | 2020-06-01 | Westchester | New York | 36119 | 33551 | 1501 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);