ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where fips = 47033 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091749 | 1091749 | 2021-03-05 | Crockett | Tennessee | 47033 | 1976 | 47 |
1088503 | 1088503 | 2021-03-04 | Crockett | Tennessee | 47033 | 1975 | 47 |
1085258 | 1085258 | 2021-03-03 | Crockett | Tennessee | 47033 | 1973 | 47 |
1082012 | 1082012 | 2021-03-02 | Crockett | Tennessee | 47033 | 1972 | 47 |
1078766 | 1078766 | 2021-03-01 | Crockett | Tennessee | 47033 | 1972 | 47 |
1075521 | 1075521 | 2021-02-28 | Crockett | Tennessee | 47033 | 1971 | 47 |
1072275 | 1072275 | 2021-02-27 | Crockett | Tennessee | 47033 | 1970 | 47 |
1069029 | 1069029 | 2021-02-26 | Crockett | Tennessee | 47033 | 1971 | 47 |
1065784 | 1065784 | 2021-02-25 | Crockett | Tennessee | 47033 | 1971 | 47 |
1062539 | 1062539 | 2021-02-24 | Crockett | Tennessee | 47033 | 1969 | 46 |
1059294 | 1059294 | 2021-02-23 | Crockett | Tennessee | 47033 | 1967 | 46 |
1056048 | 1056048 | 2021-02-22 | Crockett | Tennessee | 47033 | 1967 | 46 |
1052802 | 1052802 | 2021-02-21 | Crockett | Tennessee | 47033 | 1965 | 46 |
1049555 | 1049555 | 2021-02-20 | Crockett | Tennessee | 47033 | 1958 | 46 |
1046308 | 1046308 | 2021-02-19 | Crockett | Tennessee | 47033 | 1958 | 46 |
1043063 | 1043063 | 2021-02-18 | Crockett | Tennessee | 47033 | 1957 | 46 |
1039818 | 1039818 | 2021-02-17 | Crockett | Tennessee | 47033 | 1957 | 46 |
1036573 | 1036573 | 2021-02-16 | Crockett | Tennessee | 47033 | 1957 | 46 |
1033328 | 1033328 | 2021-02-15 | Crockett | Tennessee | 47033 | 1949 | 46 |
1030082 | 1030082 | 2021-02-14 | Crockett | Tennessee | 47033 | 1939 | 46 |
1026835 | 1026835 | 2021-02-13 | Crockett | Tennessee | 47033 | 1930 | 44 |
1023590 | 1023590 | 2021-02-12 | Crockett | Tennessee | 47033 | 1919 | 44 |
1020345 | 1020345 | 2021-02-11 | Crockett | Tennessee | 47033 | 1915 | 44 |
1017100 | 1017100 | 2021-02-10 | Crockett | Tennessee | 47033 | 1902 | 43 |
1013855 | 1013855 | 2021-02-09 | Crockett | Tennessee | 47033 | 1895 | 43 |
1010610 | 1010610 | 2021-02-08 | Crockett | Tennessee | 47033 | 1889 | 43 |
1007364 | 1007364 | 2021-02-07 | Crockett | Tennessee | 47033 | 1885 | 43 |
1004118 | 1004118 | 2021-02-06 | Crockett | Tennessee | 47033 | 1884 | 43 |
1000872 | 1000872 | 2021-02-05 | Crockett | Tennessee | 47033 | 1876 | 43 |
997626 | 997626 | 2021-02-04 | Crockett | Tennessee | 47033 | 1872 | 42 |
994380 | 994380 | 2021-02-03 | Crockett | Tennessee | 47033 | 1865 | 40 |
991134 | 991134 | 2021-02-02 | Crockett | Tennessee | 47033 | 1864 | 39 |
987888 | 987888 | 2021-02-01 | Crockett | Tennessee | 47033 | 1862 | 39 |
984641 | 984641 | 2021-01-31 | Crockett | Tennessee | 47033 | 1861 | 39 |
981394 | 981394 | 2021-01-30 | Crockett | Tennessee | 47033 | 1858 | 39 |
978148 | 978148 | 2021-01-29 | Crockett | Tennessee | 47033 | 1857 | 39 |
974903 | 974903 | 2021-01-28 | Crockett | Tennessee | 47033 | 1849 | 39 |
971658 | 971658 | 2021-01-27 | Crockett | Tennessee | 47033 | 1844 | 39 |
968413 | 968413 | 2021-01-26 | Crockett | Tennessee | 47033 | 1841 | 39 |
965169 | 965169 | 2021-01-25 | Crockett | Tennessee | 47033 | 1837 | 38 |
961924 | 961924 | 2021-01-24 | Crockett | Tennessee | 47033 | 1834 | 38 |
958679 | 958679 | 2021-01-23 | Crockett | Tennessee | 47033 | 1831 | 38 |
955433 | 955433 | 2021-01-22 | Crockett | Tennessee | 47033 | 1824 | 38 |
952188 | 952188 | 2021-01-21 | Crockett | Tennessee | 47033 | 1821 | 38 |
948943 | 948943 | 2021-01-20 | Crockett | Tennessee | 47033 | 1813 | 38 |
945697 | 945697 | 2021-01-19 | Crockett | Tennessee | 47033 | 1809 | 38 |
942450 | 942450 | 2021-01-18 | Crockett | Tennessee | 47033 | 1807 | 38 |
939205 | 939205 | 2021-01-17 | Crockett | Tennessee | 47033 | 1803 | 38 |
935960 | 935960 | 2021-01-16 | Crockett | Tennessee | 47033 | 1800 | 38 |
932715 | 932715 | 2021-01-15 | Crockett | Tennessee | 47033 | 1796 | 38 |
929470 | 929470 | 2021-01-14 | Crockett | Tennessee | 47033 | 1789 | 38 |
926225 | 926225 | 2021-01-13 | Crockett | Tennessee | 47033 | 1785 | 38 |
922979 | 922979 | 2021-01-12 | Crockett | Tennessee | 47033 | 1775 | 37 |
919734 | 919734 | 2021-01-11 | Crockett | Tennessee | 47033 | 1777 | 37 |
916489 | 916489 | 2021-01-10 | Crockett | Tennessee | 47033 | 1774 | 37 |
913244 | 913244 | 2021-01-09 | Crockett | Tennessee | 47033 | 1763 | 36 |
909999 | 909999 | 2021-01-08 | Crockett | Tennessee | 47033 | 1751 | 35 |
906754 | 906754 | 2021-01-07 | Crockett | Tennessee | 47033 | 1745 | 34 |
903508 | 903508 | 2021-01-06 | Crockett | Tennessee | 47033 | 1724 | 31 |
900263 | 900263 | 2021-01-05 | Crockett | Tennessee | 47033 | 1713 | 32 |
897018 | 897018 | 2021-01-04 | Crockett | Tennessee | 47033 | 1686 | 30 |
893772 | 893772 | 2021-01-03 | Crockett | Tennessee | 47033 | 1673 | 30 |
890526 | 890526 | 2021-01-02 | Crockett | Tennessee | 47033 | 1669 | 29 |
887279 | 887279 | 2021-01-01 | Crockett | Tennessee | 47033 | 1641 | 29 |
884034 | 884034 | 2020-12-31 | Crockett | Tennessee | 47033 | 1641 | 29 |
880789 | 880789 | 2020-12-30 | Crockett | Tennessee | 47033 | 1628 | 29 |
877544 | 877544 | 2020-12-29 | Crockett | Tennessee | 47033 | 1604 | 29 |
874299 | 874299 | 2020-12-28 | Crockett | Tennessee | 47033 | 1585 | 29 |
871054 | 871054 | 2020-12-27 | Crockett | Tennessee | 47033 | 1576 | 29 |
867809 | 867809 | 2020-12-26 | Crockett | Tennessee | 47033 | 1568 | 30 |
864564 | 864564 | 2020-12-25 | Crockett | Tennessee | 47033 | 1559 | 30 |
861319 | 861319 | 2020-12-24 | Crockett | Tennessee | 47033 | 1544 | 30 |
858074 | 858074 | 2020-12-23 | Crockett | Tennessee | 47033 | 1536 | 30 |
854829 | 854829 | 2020-12-22 | Crockett | Tennessee | 47033 | 1526 | 30 |
851584 | 851584 | 2020-12-21 | Crockett | Tennessee | 47033 | 1513 | 29 |
848339 | 848339 | 2020-12-20 | Crockett | Tennessee | 47033 | 1492 | 29 |
845094 | 845094 | 2020-12-19 | Crockett | Tennessee | 47033 | 1468 | 29 |
841848 | 841848 | 2020-12-18 | Crockett | Tennessee | 47033 | 1451 | 29 |
838603 | 838603 | 2020-12-17 | Crockett | Tennessee | 47033 | 1422 | 29 |
835357 | 835357 | 2020-12-16 | Crockett | Tennessee | 47033 | 1393 | 29 |
832111 | 832111 | 2020-12-15 | Crockett | Tennessee | 47033 | 1373 | 29 |
828864 | 828864 | 2020-12-14 | Crockett | Tennessee | 47033 | 1360 | 29 |
825618 | 825618 | 2020-12-13 | Crockett | Tennessee | 47033 | 1329 | 29 |
822371 | 822371 | 2020-12-12 | Crockett | Tennessee | 47033 | 1315 | 29 |
819125 | 819125 | 2020-12-11 | Crockett | Tennessee | 47033 | 1285 | 29 |
815879 | 815879 | 2020-12-10 | Crockett | Tennessee | 47033 | 1274 | 29 |
812633 | 812633 | 2020-12-09 | Crockett | Tennessee | 47033 | 1255 | 29 |
809389 | 809389 | 2020-12-08 | Crockett | Tennessee | 47033 | 1245 | 29 |
806144 | 806144 | 2020-12-07 | Crockett | Tennessee | 47033 | 1221 | 29 |
802899 | 802899 | 2020-12-06 | Crockett | Tennessee | 47033 | 1209 | 29 |
799654 | 799654 | 2020-12-05 | Crockett | Tennessee | 47033 | 1200 | 29 |
796409 | 796409 | 2020-12-04 | Crockett | Tennessee | 47033 | 1193 | 29 |
793164 | 793164 | 2020-12-03 | Crockett | Tennessee | 47033 | 1184 | 28 |
789919 | 789919 | 2020-12-02 | Crockett | Tennessee | 47033 | 1182 | 28 |
786674 | 786674 | 2020-12-01 | Crockett | Tennessee | 47033 | 1177 | 27 |
783430 | 783430 | 2020-11-30 | Crockett | Tennessee | 47033 | 1171 | 26 |
780185 | 780185 | 2020-11-29 | Crockett | Tennessee | 47033 | 1156 | 26 |
776939 | 776939 | 2020-11-28 | Crockett | Tennessee | 47033 | 1155 | 26 |
773694 | 773694 | 2020-11-27 | Crockett | Tennessee | 47033 | 1133 | 26 |
770449 | 770449 | 2020-11-26 | Crockett | Tennessee | 47033 | 1128 | 26 |
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);