ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Clay" and fips = 46027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
906684 | 906684 | 2021-01-07 | Clay | South Dakota | 46027 | 1665 | 12 |
903438 | 903438 | 2021-01-06 | Clay | South Dakota | 46027 | 1660 | 12 |
900193 | 900193 | 2021-01-05 | Clay | South Dakota | 46027 | 1652 | 12 |
896948 | 896948 | 2021-01-04 | Clay | South Dakota | 46027 | 1649 | 12 |
893702 | 893702 | 2021-01-03 | Clay | South Dakota | 46027 | 1645 | 12 |
890456 | 890456 | 2021-01-02 | Clay | South Dakota | 46027 | 1634 | 12 |
887209 | 887209 | 2021-01-01 | Clay | South Dakota | 46027 | 1625 | 12 |
883964 | 883964 | 2020-12-31 | Clay | South Dakota | 46027 | 1625 | 12 |
880719 | 880719 | 2020-12-30 | Clay | South Dakota | 46027 | 1623 | 11 |
877474 | 877474 | 2020-12-29 | Clay | South Dakota | 46027 | 1613 | 11 |
874229 | 874229 | 2020-12-28 | Clay | South Dakota | 46027 | 1607 | 11 |
870984 | 870984 | 2020-12-27 | Clay | South Dakota | 46027 | 1602 | 11 |
867739 | 867739 | 2020-12-26 | Clay | South Dakota | 46027 | 1597 | 11 |
864494 | 864494 | 2020-12-25 | Clay | South Dakota | 46027 | 1592 | 11 |
861249 | 861249 | 2020-12-24 | Clay | South Dakota | 46027 | 1592 | 11 |
858004 | 858004 | 2020-12-23 | Clay | South Dakota | 46027 | 1582 | 11 |
854759 | 854759 | 2020-12-22 | Clay | South Dakota | 46027 | 1578 | 11 |
851514 | 851514 | 2020-12-21 | Clay | South Dakota | 46027 | 1569 | 11 |
848269 | 848269 | 2020-12-20 | Clay | South Dakota | 46027 | 1561 | 11 |
845024 | 845024 | 2020-12-19 | Clay | South Dakota | 46027 | 1558 | 11 |
841778 | 841778 | 2020-12-18 | Clay | South Dakota | 46027 | 1546 | 11 |
838533 | 838533 | 2020-12-17 | Clay | South Dakota | 46027 | 1535 | 11 |
835287 | 835287 | 2020-12-16 | Clay | South Dakota | 46027 | 1527 | 11 |
832041 | 832041 | 2020-12-15 | Clay | South Dakota | 46027 | 1513 | 11 |
828794 | 828794 | 2020-12-14 | Clay | South Dakota | 46027 | 1508 | 11 |
825548 | 825548 | 2020-12-13 | Clay | South Dakota | 46027 | 1508 | 11 |
822301 | 822301 | 2020-12-12 | Clay | South Dakota | 46027 | 1506 | 11 |
819055 | 819055 | 2020-12-11 | Clay | South Dakota | 46027 | 1495 | 11 |
815809 | 815809 | 2020-12-10 | Clay | South Dakota | 46027 | 1481 | 11 |
812563 | 812563 | 2020-12-09 | Clay | South Dakota | 46027 | 1468 | 11 |
809319 | 809319 | 2020-12-08 | Clay | South Dakota | 46027 | 1458 | 11 |
806074 | 806074 | 2020-12-07 | Clay | South Dakota | 46027 | 1441 | 11 |
802829 | 802829 | 2020-12-06 | Clay | South Dakota | 46027 | 1429 | 11 |
799584 | 799584 | 2020-12-05 | Clay | South Dakota | 46027 | 1422 | 11 |
796339 | 796339 | 2020-12-04 | Clay | South Dakota | 46027 | 1413 | 11 |
793094 | 793094 | 2020-12-03 | Clay | South Dakota | 46027 | 1391 | 11 |
789849 | 789849 | 2020-12-02 | Clay | South Dakota | 46027 | 1381 | 11 |
786604 | 786604 | 2020-12-01 | Clay | South Dakota | 46027 | 1377 | 10 |
783360 | 783360 | 2020-11-30 | Clay | South Dakota | 46027 | 1373 | 10 |
780115 | 780115 | 2020-11-29 | Clay | South Dakota | 46027 | 1368 | 10 |
776869 | 776869 | 2020-11-28 | Clay | South Dakota | 46027 | 1349 | 10 |
773624 | 773624 | 2020-11-27 | Clay | South Dakota | 46027 | 1338 | 10 |
770379 | 770379 | 2020-11-26 | Clay | South Dakota | 46027 | 1296 | 9 |
767133 | 767133 | 2020-11-25 | Clay | South Dakota | 46027 | 1296 | 9 |
763888 | 763888 | 2020-11-24 | Clay | South Dakota | 46027 | 1270 | 9 |
760643 | 760643 | 2020-11-23 | Clay | South Dakota | 46027 | 1245 | 9 |
757398 | 757398 | 2020-11-22 | Clay | South Dakota | 46027 | 1219 | 9 |
754151 | 754151 | 2020-11-21 | Clay | South Dakota | 46027 | 1214 | 9 |
750905 | 750905 | 2020-11-20 | Clay | South Dakota | 46027 | 1198 | 9 |
747659 | 747659 | 2020-11-19 | Clay | South Dakota | 46027 | 1167 | 9 |
744413 | 744413 | 2020-11-18 | Clay | South Dakota | 46027 | 1159 | 8 |
741166 | 741166 | 2020-11-17 | Clay | South Dakota | 46027 | 1142 | 8 |
737920 | 737920 | 2020-11-16 | Clay | South Dakota | 46027 | 1136 | 8 |
734676 | 734676 | 2020-11-15 | Clay | South Dakota | 46027 | 1117 | 8 |
731430 | 731430 | 2020-11-14 | Clay | South Dakota | 46027 | 1100 | 8 |
728186 | 728186 | 2020-11-13 | Clay | South Dakota | 46027 | 1077 | 8 |
724942 | 724942 | 2020-11-12 | Clay | South Dakota | 46027 | 1051 | 8 |
721699 | 721699 | 2020-11-11 | Clay | South Dakota | 46027 | 1008 | 8 |
718456 | 718456 | 2020-11-10 | Clay | South Dakota | 46027 | 979 | 8 |
715213 | 715213 | 2020-11-09 | Clay | South Dakota | 46027 | 972 | 8 |
711969 | 711969 | 2020-11-08 | Clay | South Dakota | 46027 | 960 | 8 |
708725 | 708725 | 2020-11-07 | Clay | South Dakota | 46027 | 947 | 8 |
705482 | 705482 | 2020-11-06 | Clay | South Dakota | 46027 | 936 | 8 |
702239 | 702239 | 2020-11-05 | Clay | South Dakota | 46027 | 925 | 8 |
698995 | 698995 | 2020-11-04 | Clay | South Dakota | 46027 | 914 | 8 |
695752 | 695752 | 2020-11-03 | Clay | South Dakota | 46027 | 896 | 8 |
692510 | 692510 | 2020-11-02 | Clay | South Dakota | 46027 | 884 | 8 |
689266 | 689266 | 2020-11-01 | Clay | South Dakota | 46027 | 877 | 8 |
686021 | 686021 | 2020-10-31 | Clay | South Dakota | 46027 | 865 | 8 |
682778 | 682778 | 2020-10-30 | Clay | South Dakota | 46027 | 852 | 8 |
679535 | 679535 | 2020-10-29 | Clay | South Dakota | 46027 | 829 | 8 |
676292 | 676292 | 2020-10-28 | Clay | South Dakota | 46027 | 817 | 8 |
673049 | 673049 | 2020-10-27 | Clay | South Dakota | 46027 | 801 | 8 |
669807 | 669807 | 2020-10-26 | Clay | South Dakota | 46027 | 788 | 8 |
666563 | 666563 | 2020-10-25 | Clay | South Dakota | 46027 | 784 | 8 |
663318 | 663318 | 2020-10-24 | Clay | South Dakota | 46027 | 757 | 8 |
660074 | 660074 | 2020-10-23 | Clay | South Dakota | 46027 | 751 | 8 |
656830 | 656830 | 2020-10-22 | Clay | South Dakota | 46027 | 735 | 8 |
653585 | 653585 | 2020-10-21 | Clay | South Dakota | 46027 | 724 | 8 |
650340 | 650340 | 2020-10-20 | Clay | South Dakota | 46027 | 721 | 8 |
647096 | 647096 | 2020-10-19 | Clay | South Dakota | 46027 | 710 | 8 |
643850 | 643850 | 2020-10-18 | Clay | South Dakota | 46027 | 700 | 8 |
640602 | 640602 | 2020-10-17 | Clay | South Dakota | 46027 | 693 | 8 |
637356 | 637356 | 2020-10-16 | Clay | South Dakota | 46027 | 683 | 8 |
634110 | 634110 | 2020-10-15 | Clay | South Dakota | 46027 | 677 | 8 |
630865 | 630865 | 2020-10-14 | Clay | South Dakota | 46027 | 667 | 8 |
627621 | 627621 | 2020-10-13 | Clay | South Dakota | 46027 | 654 | 8 |
624379 | 624379 | 2020-10-12 | Clay | South Dakota | 46027 | 650 | 8 |
621136 | 621136 | 2020-10-11 | Clay | South Dakota | 46027 | 643 | 8 |
617893 | 617893 | 2020-10-10 | Clay | South Dakota | 46027 | 634 | 8 |
614651 | 614651 | 2020-10-09 | Clay | South Dakota | 46027 | 619 | 7 |
611410 | 611410 | 2020-10-08 | Clay | South Dakota | 46027 | 606 | 7 |
608168 | 608168 | 2020-10-07 | Clay | South Dakota | 46027 | 603 | 7 |
604925 | 604925 | 2020-10-06 | Clay | South Dakota | 46027 | 589 | 7 |
601683 | 601683 | 2020-10-05 | Clay | South Dakota | 46027 | 586 | 7 |
598440 | 598440 | 2020-10-04 | Clay | South Dakota | 46027 | 585 | 7 |
595197 | 595197 | 2020-10-03 | Clay | South Dakota | 46027 | 581 | 7 |
591956 | 591956 | 2020-10-02 | Clay | South Dakota | 46027 | 576 | 7 |
588715 | 588715 | 2020-10-01 | Clay | South Dakota | 46027 | 572 | 7 |
585475 | 585475 | 2020-09-30 | Clay | South Dakota | 46027 | 568 | 6 |
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);