ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2021-01-28 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
974887 | 974887 | 2021-01-28 | Anderson | Tennessee | 47001 | 7103 | 124 |
974888 | 974888 | 2021-01-28 | Bedford | Tennessee | 47003 | 5490 | 98 |
974889 | 974889 | 2021-01-28 | Benton | Tennessee | 47005 | 1353 | 35 |
974890 | 974890 | 2021-01-28 | Bledsoe | Tennessee | 47007 | 1796 | 11 |
974891 | 974891 | 2021-01-28 | Blount | Tennessee | 47009 | 12550 | 140 |
974892 | 974892 | 2021-01-28 | Bradley | Tennessee | 47011 | 11427 | 107 |
974893 | 974893 | 2021-01-28 | Campbell | Tennessee | 47013 | 3424 | 44 |
974894 | 974894 | 2021-01-28 | Cannon | Tennessee | 47015 | 1626 | 23 |
974895 | 974895 | 2021-01-28 | Carroll | Tennessee | 47017 | 3219 | 64 |
974896 | 974896 | 2021-01-28 | Carter | Tennessee | 47019 | 5267 | 127 |
974897 | 974897 | 2021-01-28 | Cheatham | Tennessee | 47021 | 3534 | 33 |
974898 | 974898 | 2021-01-28 | Chester | Tennessee | 47023 | 1807 | 39 |
974899 | 974899 | 2021-01-28 | Claiborne | Tennessee | 47025 | 2349 | 36 |
974900 | 974900 | 2021-01-28 | Clay | Tennessee | 47027 | 970 | 26 |
974901 | 974901 | 2021-01-28 | Cocke | Tennessee | 47029 | 3635 | 70 |
974902 | 974902 | 2021-01-28 | Coffee | Tennessee | 47031 | 5814 | 97 |
974903 | 974903 | 2021-01-28 | Crockett | Tennessee | 47033 | 1849 | 39 |
974904 | 974904 | 2021-01-28 | Cumberland | Tennessee | 47035 | 5595 | 80 |
974905 | 974905 | 2021-01-28 | Davidson | Tennessee | 47037 | 83768 | 723 |
974906 | 974906 | 2021-01-28 | DeKalb | Tennessee | 47041 | 2491 | 45 |
974907 | 974907 | 2021-01-28 | Decatur | Tennessee | 47039 | 1493 | 28 |
974908 | 974908 | 2021-01-28 | Dickson | Tennessee | 47043 | 5631 | 85 |
974909 | 974909 | 2021-01-28 | Dyer | Tennessee | 47045 | 4910 | 87 |
974910 | 974910 | 2021-01-28 | Fayette | Tennessee | 47047 | 4192 | 54 |
974911 | 974911 | 2021-01-28 | Fentress | Tennessee | 47049 | 2192 | 37 |
974912 | 974912 | 2021-01-28 | Franklin | Tennessee | 47051 | 4305 | 69 |
974913 | 974913 | 2021-01-28 | Gibson | Tennessee | 47053 | 5800 | 122 |
974914 | 974914 | 2021-01-28 | Giles | Tennessee | 47055 | 3379 | 76 |
974915 | 974915 | 2021-01-28 | Grainger | Tennessee | 47057 | 2192 | 41 |
974916 | 974916 | 2021-01-28 | Greene | Tennessee | 47059 | 6799 | 121 |
974917 | 974917 | 2021-01-28 | Grundy | Tennessee | 47061 | 1453 | 24 |
974918 | 974918 | 2021-01-28 | Hamblen | Tennessee | 47063 | 7341 | 141 |
974919 | 974919 | 2021-01-28 | Hamilton | Tennessee | 47065 | 37680 | 358 |
974920 | 974920 | 2021-01-28 | Hancock | Tennessee | 47067 | 431 | 7 |
974921 | 974921 | 2021-01-28 | Hardeman | Tennessee | 47069 | 3187 | 57 |
974922 | 974922 | 2021-01-28 | Hardin | Tennessee | 47071 | 3081 | 54 |
974923 | 974923 | 2021-01-28 | Hawkins | Tennessee | 47073 | 4653 | 81 |
974924 | 974924 | 2021-01-28 | Haywood | Tennessee | 47075 | 2463 | 55 |
974925 | 974925 | 2021-01-28 | Henderson | Tennessee | 47077 | 3396 | 63 |
974926 | 974926 | 2021-01-28 | Henry | Tennessee | 47079 | 2718 | 62 |
974927 | 974927 | 2021-01-28 | Hickman | Tennessee | 47081 | 2319 | 38 |
974928 | 974928 | 2021-01-28 | Houston | Tennessee | 47083 | 954 | 26 |
974929 | 974929 | 2021-01-28 | Humphreys | Tennessee | 47085 | 1389 | 18 |
974930 | 974930 | 2021-01-28 | Jackson | Tennessee | 47087 | 1074 | 24 |
974931 | 974931 | 2021-01-28 | Jefferson | Tennessee | 47089 | 5042 | 83 |
974932 | 974932 | 2021-01-28 | Johnson | Tennessee | 47091 | 2065 | 36 |
974933 | 974933 | 2021-01-28 | Knox | Tennessee | 47093 | 42299 | 476 |
974934 | 974934 | 2021-01-28 | Lake | Tennessee | 47095 | 1591 | 22 |
974935 | 974935 | 2021-01-28 | Lauderdale | Tennessee | 47097 | 3012 | 35 |
974936 | 974936 | 2021-01-28 | Lawrence | Tennessee | 47099 | 5289 | 73 |
974937 | 974937 | 2021-01-28 | Lewis | Tennessee | 47101 | 1328 | 21 |
974938 | 974938 | 2021-01-28 | Lincoln | Tennessee | 47103 | 3905 | 53 |
974939 | 974939 | 2021-01-28 | Loudon | Tennessee | 47105 | 5178 | 57 |
974940 | 974940 | 2021-01-28 | Macon | Tennessee | 47111 | 2977 | 56 |
974941 | 974941 | 2021-01-28 | Madison | Tennessee | 47113 | 9458 | 193 |
974942 | 974942 | 2021-01-28 | Marion | Tennessee | 47115 | 2385 | 34 |
974943 | 974943 | 2021-01-28 | Marshall | Tennessee | 47117 | 3602 | 42 |
974944 | 974944 | 2021-01-28 | Maury | Tennessee | 47119 | 11445 | 138 |
974945 | 974945 | 2021-01-28 | McMinn | Tennessee | 47107 | 5294 | 76 |
974946 | 974946 | 2021-01-28 | McNairy | Tennessee | 47109 | 2511 | 43 |
974947 | 974947 | 2021-01-28 | Meigs | Tennessee | 47121 | 1204 | 17 |
974948 | 974948 | 2021-01-28 | Monroe | Tennessee | 47123 | 4760 | 67 |
974949 | 974949 | 2021-01-28 | Montgomery | Tennessee | 47125 | 15455 | 160 |
974950 | 974950 | 2021-01-28 | Moore | Tennessee | 47127 | 844 | 10 |
974951 | 974951 | 2021-01-28 | Morgan | Tennessee | 47129 | 1982 | 17 |
974952 | 974952 | 2021-01-28 | Obion | Tennessee | 47131 | 4091 | 86 |
974953 | 974953 | 2021-01-28 | Overton | Tennessee | 47133 | 2614 | 46 |
974954 | 974954 | 2021-01-28 | Perry | Tennessee | 47135 | 971 | 25 |
974955 | 974955 | 2021-01-28 | Pickett | Tennessee | 47137 | 698 | 21 |
974956 | 974956 | 2021-01-28 | Polk | Tennessee | 47139 | 1533 | 17 |
974957 | 974957 | 2021-01-28 | Putnam | Tennessee | 47141 | 10273 | 155 |
974958 | 974958 | 2021-01-28 | Rhea | Tennessee | 47143 | 3946 | 61 |
974959 | 974959 | 2021-01-28 | Roane | Tennessee | 47145 | 5406 | 90 |
974960 | 974960 | 2021-01-28 | Robertson | Tennessee | 47147 | 7997 | 90 |
974961 | 974961 | 2021-01-28 | Rutherford | Tennessee | 47149 | 34645 | 310 |
974962 | 974962 | 2021-01-28 | Scott | Tennessee | 47151 | 2321 | 33 |
974963 | 974963 | 2021-01-28 | Sequatchie | Tennessee | 47153 | 1436 | 20 |
974964 | 974964 | 2021-01-28 | Sevier | Tennessee | 47155 | 10981 | 132 |
974965 | 974965 | 2021-01-28 | Shelby | Tennessee | 47157 | 81657 | 1241 |
974966 | 974966 | 2021-01-28 | Smith | Tennessee | 47159 | 2364 | 30 |
974967 | 974967 | 2021-01-28 | Stewart | Tennessee | 47161 | 1133 | 21 |
974968 | 974968 | 2021-01-28 | Sullivan | Tennessee | 47163 | 13109 | 230 |
974969 | 974969 | 2021-01-28 | Sumner | Tennessee | 47165 | 19035 | 250 |
974970 | 974970 | 2021-01-28 | Tipton | Tennessee | 47167 | 6451 | 79 |
974971 | 974971 | 2021-01-28 | Trousdale | Tennessee | 47169 | 2310 | 17 |
974972 | 974972 | 2021-01-28 | Unicoi | Tennessee | 47171 | 1709 | 47 |
974973 | 974973 | 2021-01-28 | Union | Tennessee | 47173 | 1478 | 25 |
974974 | 974974 | 2021-01-28 | Unknown | Tennessee | 13419 | 151 | |
974975 | 974975 | 2021-01-28 | Van Buren | Tennessee | 47175 | 675 | 9 |
974976 | 974976 | 2021-01-28 | Warren | Tennessee | 47177 | 5143 | 60 |
974977 | 974977 | 2021-01-28 | Washington | Tennessee | 47179 | 12299 | 213 |
974978 | 974978 | 2021-01-28 | Wayne | Tennessee | 47181 | 2723 | 25 |
974979 | 974979 | 2021-01-28 | Weakley | Tennessee | 47183 | 3490 | 52 |
974980 | 974980 | 2021-01-28 | White | Tennessee | 47185 | 3193 | 51 |
974981 | 974981 | 2021-01-28 | Williamson | Tennessee | 47187 | 22593 | 170 |
974982 | 974982 | 2021-01-28 | Wilson | Tennessee | 47189 | 15046 | 177 |
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);