ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Grainger" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955445 | 955445 | 2021-01-22 | Grainger | Tennessee | 47057 | 2143 | 39 |
952200 | 952200 | 2021-01-21 | Grainger | Tennessee | 47057 | 2119 | 38 |
948955 | 948955 | 2021-01-20 | Grainger | Tennessee | 47057 | 2112 | 37 |
945709 | 945709 | 2021-01-19 | Grainger | Tennessee | 47057 | 2096 | 36 |
942462 | 942462 | 2021-01-18 | Grainger | Tennessee | 47057 | 2090 | 35 |
939217 | 939217 | 2021-01-17 | Grainger | Tennessee | 47057 | 2081 | 35 |
935972 | 935972 | 2021-01-16 | Grainger | Tennessee | 47057 | 2072 | 35 |
932727 | 932727 | 2021-01-15 | Grainger | Tennessee | 47057 | 2049 | 35 |
929482 | 929482 | 2021-01-14 | Grainger | Tennessee | 47057 | 2021 | 34 |
926237 | 926237 | 2021-01-13 | Grainger | Tennessee | 47057 | 2008 | 32 |
922991 | 922991 | 2021-01-12 | Grainger | Tennessee | 47057 | 1997 | 29 |
919746 | 919746 | 2021-01-11 | Grainger | Tennessee | 47057 | 1992 | 28 |
916501 | 916501 | 2021-01-10 | Grainger | Tennessee | 47057 | 1980 | 28 |
913256 | 913256 | 2021-01-09 | Grainger | Tennessee | 47057 | 1949 | 27 |
910011 | 910011 | 2021-01-08 | Grainger | Tennessee | 47057 | 1941 | 27 |
906766 | 906766 | 2021-01-07 | Grainger | Tennessee | 47057 | 1922 | 27 |
903520 | 903520 | 2021-01-06 | Grainger | Tennessee | 47057 | 1895 | 27 |
900275 | 900275 | 2021-01-05 | Grainger | Tennessee | 47057 | 1878 | 26 |
897030 | 897030 | 2021-01-04 | Grainger | Tennessee | 47057 | 1865 | 26 |
893784 | 893784 | 2021-01-03 | Grainger | Tennessee | 47057 | 1858 | 26 |
890538 | 890538 | 2021-01-02 | Grainger | Tennessee | 47057 | 1843 | 26 |
887291 | 887291 | 2021-01-01 | Grainger | Tennessee | 47057 | 1768 | 26 |
884046 | 884046 | 2020-12-31 | Grainger | Tennessee | 47057 | 1768 | 26 |
880801 | 880801 | 2020-12-30 | Grainger | Tennessee | 47057 | 1757 | 25 |
877556 | 877556 | 2020-12-29 | Grainger | Tennessee | 47057 | 1735 | 25 |
874311 | 874311 | 2020-12-28 | Grainger | Tennessee | 47057 | 1735 | 24 |
871066 | 871066 | 2020-12-27 | Grainger | Tennessee | 47057 | 1728 | 23 |
867821 | 867821 | 2020-12-26 | Grainger | Tennessee | 47057 | 1721 | 23 |
864576 | 864576 | 2020-12-25 | Grainger | Tennessee | 47057 | 1694 | 23 |
861331 | 861331 | 2020-12-24 | Grainger | Tennessee | 47057 | 1648 | 23 |
858086 | 858086 | 2020-12-23 | Grainger | Tennessee | 47057 | 1643 | 23 |
854841 | 854841 | 2020-12-22 | Grainger | Tennessee | 47057 | 1630 | 22 |
851596 | 851596 | 2020-12-21 | Grainger | Tennessee | 47057 | 1627 | 22 |
848351 | 848351 | 2020-12-20 | Grainger | Tennessee | 47057 | 1584 | 22 |
845106 | 845106 | 2020-12-19 | Grainger | Tennessee | 47057 | 1549 | 22 |
841860 | 841860 | 2020-12-18 | Grainger | Tennessee | 47057 | 1522 | 22 |
838615 | 838615 | 2020-12-17 | Grainger | Tennessee | 47057 | 1476 | 21 |
835369 | 835369 | 2020-12-16 | Grainger | Tennessee | 47057 | 1449 | 21 |
832123 | 832123 | 2020-12-15 | Grainger | Tennessee | 47057 | 1400 | 21 |
828876 | 828876 | 2020-12-14 | Grainger | Tennessee | 47057 | 1381 | 21 |
825630 | 825630 | 2020-12-13 | Grainger | Tennessee | 47057 | 1344 | 21 |
822383 | 822383 | 2020-12-12 | Grainger | Tennessee | 47057 | 1289 | 21 |
819137 | 819137 | 2020-12-11 | Grainger | Tennessee | 47057 | 1276 | 21 |
815891 | 815891 | 2020-12-10 | Grainger | Tennessee | 47057 | 1242 | 21 |
812645 | 812645 | 2020-12-09 | Grainger | Tennessee | 47057 | 1214 | 21 |
809401 | 809401 | 2020-12-08 | Grainger | Tennessee | 47057 | 1187 | 21 |
806156 | 806156 | 2020-12-07 | Grainger | Tennessee | 47057 | 1161 | 21 |
802911 | 802911 | 2020-12-06 | Grainger | Tennessee | 47057 | 1124 | 19 |
799666 | 799666 | 2020-12-05 | Grainger | Tennessee | 47057 | 1115 | 19 |
796421 | 796421 | 2020-12-04 | Grainger | Tennessee | 47057 | 1099 | 18 |
793176 | 793176 | 2020-12-03 | Grainger | Tennessee | 47057 | 1088 | 18 |
789931 | 789931 | 2020-12-02 | Grainger | Tennessee | 47057 | 1085 | 17 |
786686 | 786686 | 2020-12-01 | Grainger | Tennessee | 47057 | 1082 | 17 |
783442 | 783442 | 2020-11-30 | Grainger | Tennessee | 47057 | 1050 | 17 |
780197 | 780197 | 2020-11-29 | Grainger | Tennessee | 47057 | 1015 | 18 |
776951 | 776951 | 2020-11-28 | Grainger | Tennessee | 47057 | 1012 | 17 |
773706 | 773706 | 2020-11-27 | Grainger | Tennessee | 47057 | 954 | 16 |
770461 | 770461 | 2020-11-26 | Grainger | Tennessee | 47057 | 947 | 16 |
767215 | 767215 | 2020-11-25 | Grainger | Tennessee | 47057 | 939 | 15 |
763970 | 763970 | 2020-11-24 | Grainger | Tennessee | 47057 | 929 | 15 |
760725 | 760725 | 2020-11-23 | Grainger | Tennessee | 47057 | 923 | 15 |
757480 | 757480 | 2020-11-22 | Grainger | Tennessee | 47057 | 913 | 14 |
754233 | 754233 | 2020-11-21 | Grainger | Tennessee | 47057 | 877 | 13 |
750987 | 750987 | 2020-11-20 | Grainger | Tennessee | 47057 | 860 | 13 |
747741 | 747741 | 2020-11-19 | Grainger | Tennessee | 47057 | 842 | 12 |
744495 | 744495 | 2020-11-18 | Grainger | Tennessee | 47057 | 837 | 11 |
741248 | 741248 | 2020-11-17 | Grainger | Tennessee | 47057 | 824 | 10 |
738002 | 738002 | 2020-11-16 | Grainger | Tennessee | 47057 | 824 | 9 |
734758 | 734758 | 2020-11-15 | Grainger | Tennessee | 47057 | 806 | 9 |
731512 | 731512 | 2020-11-14 | Grainger | Tennessee | 47057 | 790 | 9 |
728268 | 728268 | 2020-11-13 | Grainger | Tennessee | 47057 | 785 | 9 |
725024 | 725024 | 2020-11-12 | Grainger | Tennessee | 47057 | 768 | 8 |
721781 | 721781 | 2020-11-11 | Grainger | Tennessee | 47057 | 761 | 5 |
718538 | 718538 | 2020-11-10 | Grainger | Tennessee | 47057 | 757 | 5 |
715295 | 715295 | 2020-11-09 | Grainger | Tennessee | 47057 | 763 | 5 |
712051 | 712051 | 2020-11-08 | Grainger | Tennessee | 47057 | 754 | 5 |
708807 | 708807 | 2020-11-07 | Grainger | Tennessee | 47057 | 740 | 5 |
705564 | 705564 | 2020-11-06 | Grainger | Tennessee | 47057 | 727 | 4 |
702321 | 702321 | 2020-11-05 | Grainger | Tennessee | 47057 | 726 | 4 |
699077 | 699077 | 2020-11-04 | Grainger | Tennessee | 47057 | 722 | 4 |
695834 | 695834 | 2020-11-03 | Grainger | Tennessee | 47057 | 659 | 4 |
692592 | 692592 | 2020-11-02 | Grainger | Tennessee | 47057 | 655 | 4 |
689348 | 689348 | 2020-11-01 | Grainger | Tennessee | 47057 | 649 | 4 |
686103 | 686103 | 2020-10-31 | Grainger | Tennessee | 47057 | 649 | 4 |
682860 | 682860 | 2020-10-30 | Grainger | Tennessee | 47057 | 641 | 4 |
679617 | 679617 | 2020-10-29 | Grainger | Tennessee | 47057 | 636 | 4 |
676374 | 676374 | 2020-10-28 | Grainger | Tennessee | 47057 | 635 | 4 |
673131 | 673131 | 2020-10-27 | Grainger | Tennessee | 47057 | 617 | 4 |
669889 | 669889 | 2020-10-26 | Grainger | Tennessee | 47057 | 612 | 4 |
666645 | 666645 | 2020-10-25 | Grainger | Tennessee | 47057 | 611 | 4 |
663400 | 663400 | 2020-10-24 | Grainger | Tennessee | 47057 | 603 | 4 |
660156 | 660156 | 2020-10-23 | Grainger | Tennessee | 47057 | 566 | 4 |
656912 | 656912 | 2020-10-22 | Grainger | Tennessee | 47057 | 551 | 4 |
653667 | 653667 | 2020-10-21 | Grainger | Tennessee | 47057 | 546 | 4 |
650422 | 650422 | 2020-10-20 | Grainger | Tennessee | 47057 | 539 | 4 |
647178 | 647178 | 2020-10-19 | Grainger | Tennessee | 47057 | 531 | 4 |
643932 | 643932 | 2020-10-18 | Grainger | Tennessee | 47057 | 526 | 4 |
640684 | 640684 | 2020-10-17 | Grainger | Tennessee | 47057 | 517 | 4 |
637438 | 637438 | 2020-10-16 | Grainger | Tennessee | 47057 | 509 | 4 |
634192 | 634192 | 2020-10-15 | Grainger | Tennessee | 47057 | 497 | 4 |
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);