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-12-21 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2036893 | 2036893 | 2021-12-21 | Anderson | Tennessee | 47001 | 14039 | 242 |
2036894 | 2036894 | 2021-12-21 | Bedford | Tennessee | 47003 | 9792 | 178 |
2036895 | 2036895 | 2021-12-21 | Benton | Tennessee | 47005 | 3070 | 61 |
2036896 | 2036896 | 2021-12-21 | Bledsoe | Tennessee | 47007 | 3605 | 29 |
2036897 | 2036897 | 2021-12-21 | Blount | Tennessee | 47009 | 25295 | 285 |
2036898 | 2036898 | 2021-12-21 | Bradley | Tennessee | 47011 | 23218 | 252 |
2036899 | 2036899 | 2021-12-21 | Campbell | Tennessee | 47013 | 7813 | 98 |
2036900 | 2036900 | 2021-12-21 | Cannon | Tennessee | 47015 | 2935 | 45 |
2036901 | 2036901 | 2021-12-21 | Carroll | Tennessee | 47017 | 6022 | 115 |
2036902 | 2036902 | 2021-12-21 | Carter | Tennessee | 47019 | 11397 | 242 |
2036903 | 2036903 | 2021-12-21 | Cheatham | Tennessee | 47021 | 7416 | 80 |
2036904 | 2036904 | 2021-12-21 | Chester | Tennessee | 47023 | 3700 | 78 |
2036905 | 2036905 | 2021-12-21 | Claiborne | Tennessee | 47025 | 6001 | 122 |
2036906 | 2036906 | 2021-12-21 | Clay | Tennessee | 47027 | 1617 | 37 |
2036907 | 2036907 | 2021-12-21 | Cocke | Tennessee | 47029 | 7827 | 126 |
2036908 | 2036908 | 2021-12-21 | Coffee | Tennessee | 47031 | 11125 | 177 |
2036909 | 2036909 | 2021-12-21 | Crockett | Tennessee | 47033 | 3448 | 65 |
2036910 | 2036910 | 2021-12-21 | Cumberland | Tennessee | 47035 | 11866 | 241 |
2036911 | 2036911 | 2021-12-21 | Davidson | Tennessee | 47037 | 138460 | 1248 |
2036912 | 2036912 | 2021-12-21 | DeKalb | Tennessee | 47041 | 4423 | 79 |
2036913 | 2036913 | 2021-12-21 | Decatur | Tennessee | 47039 | 2531 | 44 |
2036914 | 2036914 | 2021-12-21 | Dickson | Tennessee | 47043 | 10985 | 176 |
2036915 | 2036915 | 2021-12-21 | Dyer | Tennessee | 47045 | 8333 | 157 |
2036916 | 2036916 | 2021-12-21 | Fayette | Tennessee | 47047 | 7695 | 116 |
2036917 | 2036917 | 2021-12-21 | Fentress | Tennessee | 47049 | 3950 | 75 |
2036918 | 2036918 | 2021-12-21 | Franklin | Tennessee | 47051 | 8400 | 110 |
2036919 | 2036919 | 2021-12-21 | Gibson | Tennessee | 47053 | 11036 | 196 |
2036920 | 2036920 | 2021-12-21 | Giles | Tennessee | 47055 | 6334 | 134 |
2036921 | 2036921 | 2021-12-21 | Grainger | Tennessee | 47057 | 4678 | 76 |
2036922 | 2036922 | 2021-12-21 | Greene | Tennessee | 47059 | 14949 | 256 |
2036923 | 2036923 | 2021-12-21 | Grundy | Tennessee | 47061 | 2992 | 47 |
2036924 | 2036924 | 2021-12-21 | Hamblen | Tennessee | 47063 | 13736 | 234 |
2036925 | 2036925 | 2021-12-21 | Hamilton | Tennessee | 47065 | 67670 | 749 |
2036926 | 2036926 | 2021-12-21 | Hancock | Tennessee | 47067 | 1355 | 21 |
2036927 | 2036927 | 2021-12-21 | Hardeman | Tennessee | 47069 | 5302 | 89 |
2036928 | 2036928 | 2021-12-21 | Hardin | Tennessee | 47071 | 5815 | 94 |
2036929 | 2036929 | 2021-12-21 | Hawkins | Tennessee | 47073 | 11223 | 195 |
2036930 | 2036930 | 2021-12-21 | Haywood | Tennessee | 47075 | 3979 | 79 |
2036931 | 2036931 | 2021-12-21 | Henderson | Tennessee | 47077 | 6005 | 112 |
2036932 | 2036932 | 2021-12-21 | Henry | Tennessee | 47079 | 5704 | 97 |
2036933 | 2036933 | 2021-12-21 | Hickman | Tennessee | 47081 | 4910 | 82 |
2036934 | 2036934 | 2021-12-21 | Houston | Tennessee | 47083 | 1978 | 48 |
2036935 | 2036935 | 2021-12-21 | Humphreys | Tennessee | 47085 | 3442 | 52 |
2036936 | 2036936 | 2021-12-21 | Jackson | Tennessee | 47087 | 2172 | 44 |
2036937 | 2036937 | 2021-12-21 | Jefferson | Tennessee | 47089 | 10557 | 170 |
2036938 | 2036938 | 2021-12-21 | Johnson | Tennessee | 47091 | 4129 | 55 |
2036939 | 2036939 | 2021-12-21 | Knox | Tennessee | 47093 | 83291 | 998 |
2036940 | 2036940 | 2021-12-21 | Lake | Tennessee | 47095 | 2043 | 32 |
2036941 | 2036941 | 2021-12-21 | Lauderdale | Tennessee | 47097 | 5313 | 75 |
2036942 | 2036942 | 2021-12-21 | Lawrence | Tennessee | 47099 | 9966 | 135 |
2036943 | 2036943 | 2021-12-21 | Lewis | Tennessee | 47101 | 2596 | 44 |
2036944 | 2036944 | 2021-12-21 | Lincoln | Tennessee | 47103 | 6938 | 108 |
2036945 | 2036945 | 2021-12-21 | Loudon | Tennessee | 47105 | 9720 | 111 |
2036946 | 2036946 | 2021-12-21 | Macon | Tennessee | 47111 | 5722 | 101 |
2036947 | 2036947 | 2021-12-21 | Madison | Tennessee | 47113 | 18589 | 332 |
2036948 | 2036948 | 2021-12-21 | Marion | Tennessee | 47115 | 6001 | 78 |
2036949 | 2036949 | 2021-12-21 | Marshall | Tennessee | 47117 | 7177 | 96 |
2036950 | 2036950 | 2021-12-21 | Maury | Tennessee | 47119 | 20336 | 248 |
2036951 | 2036951 | 2021-12-21 | McMinn | Tennessee | 47107 | 11008 | 152 |
2036952 | 2036952 | 2021-12-21 | McNairy | Tennessee | 47109 | 4902 | 78 |
2036953 | 2036953 | 2021-12-21 | Meigs | Tennessee | 47121 | 2312 | 34 |
2036954 | 2036954 | 2021-12-21 | Monroe | Tennessee | 47123 | 10183 | 145 |
2036955 | 2036955 | 2021-12-21 | Montgomery | Tennessee | 47125 | 34630 | 384 |
2036956 | 2036956 | 2021-12-21 | Moore | Tennessee | 47127 | 1489 | 27 |
2036957 | 2036957 | 2021-12-21 | Morgan | Tennessee | 47129 | 4031 | 52 |
2036958 | 2036958 | 2021-12-21 | Obion | Tennessee | 47131 | 7149 | 127 |
2036959 | 2036959 | 2021-12-21 | Overton | Tennessee | 47133 | 5057 | 90 |
2036960 | 2036960 | 2021-12-21 | Perry | Tennessee | 47135 | 1676 | 35 |
2036961 | 2036961 | 2021-12-21 | Pickett | Tennessee | 47137 | 1146 | 26 |
2036962 | 2036962 | 2021-12-21 | Polk | Tennessee | 47139 | 3332 | 38 |
2036963 | 2036963 | 2021-12-21 | Putnam | Tennessee | 47141 | 17527 | 232 |
2036964 | 2036964 | 2021-12-21 | Rhea | Tennessee | 47143 | 7309 | 105 |
2036965 | 2036965 | 2021-12-21 | Roane | Tennessee | 47145 | 10585 | 172 |
2036966 | 2036966 | 2021-12-21 | Robertson | Tennessee | 47147 | 14776 | 208 |
2036967 | 2036967 | 2021-12-21 | Rutherford | Tennessee | 47149 | 65766 | 625 |
2036968 | 2036968 | 2021-12-21 | Scott | Tennessee | 47151 | 5952 | 71 |
2036969 | 2036969 | 2021-12-21 | Sequatchie | Tennessee | 47153 | 3136 | 45 |
2036970 | 2036970 | 2021-12-21 | Sevier | Tennessee | 47155 | 21420 | 298 |
2036971 | 2036971 | 2021-12-21 | Shelby | Tennessee | 47157 | 153551 | 2442 |
2036972 | 2036972 | 2021-12-21 | Smith | Tennessee | 47159 | 4341 | 55 |
2036973 | 2036973 | 2021-12-21 | Stewart | Tennessee | 47161 | 2279 | 39 |
2036974 | 2036974 | 2021-12-21 | Sullivan | Tennessee | 47163 | 30123 | 488 |
2036975 | 2036975 | 2021-12-21 | Sumner | Tennessee | 47165 | 36389 | 470 |
2036976 | 2036976 | 2021-12-21 | Tipton | Tennessee | 47167 | 12034 | 154 |
2036977 | 2036977 | 2021-12-21 | Trousdale | Tennessee | 47169 | 3294 | 29 |
2036978 | 2036978 | 2021-12-21 | Unicoi | Tennessee | 47171 | 3361 | 73 |
2036979 | 2036979 | 2021-12-21 | Union | Tennessee | 47173 | 3606 | 52 |
2036980 | 2036980 | 2021-12-21 | Unknown | Tennessee | 11147 | 148 | |
2036981 | 2036981 | 2021-12-21 | Van Buren | Tennessee | 47175 | 1340 | 33 |
2036982 | 2036982 | 2021-12-21 | Warren | Tennessee | 47177 | 9005 | 135 |
2036983 | 2036983 | 2021-12-21 | Washington | Tennessee | 47179 | 24574 | 354 |
2036984 | 2036984 | 2021-12-21 | Wayne | Tennessee | 47181 | 4217 | 43 |
2036985 | 2036985 | 2021-12-21 | Weakley | Tennessee | 47183 | 6644 | 102 |
2036986 | 2036986 | 2021-12-21 | White | Tennessee | 47185 | 5878 | 104 |
2036987 | 2036987 | 2021-12-21 | Williamson | Tennessee | 47187 | 42355 | 290 |
2036988 | 2036988 | 2021-12-21 | Wilson | Tennessee | 47189 | 28645 | 364 |
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);