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-09-24 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1750914 | 1750914 | 2021-09-24 | Anderson | Tennessee | 47001 | 12065 | 194 |
1750915 | 1750915 | 2021-09-24 | Bedford | Tennessee | 47003 | 8603 | 145 |
1750916 | 1750916 | 2021-09-24 | Benton | Tennessee | 47005 | 2565 | 44 |
1750917 | 1750917 | 2021-09-24 | Bledsoe | Tennessee | 47007 | 3281 | 13 |
1750918 | 1750918 | 2021-09-24 | Blount | Tennessee | 47009 | 22212 | 236 |
1750919 | 1750919 | 2021-09-24 | Bradley | Tennessee | 47011 | 21135 | 169 |
1750920 | 1750920 | 2021-09-24 | Campbell | Tennessee | 47013 | 6197 | 70 |
1750921 | 1750921 | 2021-09-24 | Cannon | Tennessee | 47015 | 2675 | 38 |
1750922 | 1750922 | 2021-09-24 | Carroll | Tennessee | 47017 | 5369 | 94 |
1750923 | 1750923 | 2021-09-24 | Carter | Tennessee | 47019 | 9853 | 203 |
1750924 | 1750924 | 2021-09-24 | Cheatham | Tennessee | 47021 | 6607 | 62 |
1750925 | 1750925 | 2021-09-24 | Chester | Tennessee | 47023 | 3333 | 66 |
1750926 | 1750926 | 2021-09-24 | Claiborne | Tennessee | 47025 | 4934 | 85 |
1750927 | 1750927 | 2021-09-24 | Clay | Tennessee | 47027 | 1415 | 35 |
1750928 | 1750928 | 2021-09-24 | Cocke | Tennessee | 47029 | 6786 | 104 |
1750929 | 1750929 | 2021-09-24 | Coffee | Tennessee | 47031 | 9931 | 142 |
1750930 | 1750930 | 2021-09-24 | Crockett | Tennessee | 47033 | 3219 | 59 |
1750931 | 1750931 | 2021-09-24 | Cumberland | Tennessee | 47035 | 10378 | 196 |
1750932 | 1750932 | 2021-09-24 | Davidson | Tennessee | 47037 | 126328 | 1083 |
1750933 | 1750933 | 2021-09-24 | DeKalb | Tennessee | 47041 | 3998 | 60 |
1750934 | 1750934 | 2021-09-24 | Decatur | Tennessee | 47039 | 2299 | 42 |
1750935 | 1750935 | 2021-09-24 | Dickson | Tennessee | 47043 | 9788 | 154 |
1750936 | 1750936 | 2021-09-24 | Dyer | Tennessee | 47045 | 7796 | 131 |
1750937 | 1750937 | 2021-09-24 | Fayette | Tennessee | 47047 | 6962 | 96 |
1750938 | 1750938 | 2021-09-24 | Fentress | Tennessee | 47049 | 3351 | 59 |
1750939 | 1750939 | 2021-09-24 | Franklin | Tennessee | 47051 | 7531 | 96 |
1750940 | 1750940 | 2021-09-24 | Gibson | Tennessee | 47053 | 10164 | 178 |
1750941 | 1750941 | 2021-09-24 | Giles | Tennessee | 47055 | 5558 | 107 |
1750942 | 1750942 | 2021-09-24 | Grainger | Tennessee | 47057 | 4024 | 57 |
1750943 | 1750943 | 2021-09-24 | Greene | Tennessee | 47059 | 12295 | 209 |
1750944 | 1750944 | 2021-09-24 | Grundy | Tennessee | 47061 | 2609 | 36 |
1750945 | 1750945 | 2021-09-24 | Hamblen | Tennessee | 47063 | 12414 | 185 |
1750946 | 1750946 | 2021-09-24 | Hamilton | Tennessee | 47065 | 60893 | 614 |
1750947 | 1750947 | 2021-09-24 | Hancock | Tennessee | 47067 | 1077 | 15 |
1750948 | 1750948 | 2021-09-24 | Hardeman | Tennessee | 47069 | 4913 | 76 |
1750949 | 1750949 | 2021-09-24 | Hardin | Tennessee | 47071 | 5258 | 78 |
1750950 | 1750950 | 2021-09-24 | Hawkins | Tennessee | 47073 | 9475 | 145 |
1750951 | 1750951 | 2021-09-24 | Haywood | Tennessee | 47075 | 3682 | 69 |
1750952 | 1750952 | 2021-09-24 | Henderson | Tennessee | 47077 | 5375 | 90 |
1750953 | 1750953 | 2021-09-24 | Henry | Tennessee | 47079 | 5220 | 79 |
1750954 | 1750954 | 2021-09-24 | Hickman | Tennessee | 47081 | 4384 | 65 |
1750955 | 1750955 | 2021-09-24 | Houston | Tennessee | 47083 | 1745 | 41 |
1750956 | 1750956 | 2021-09-24 | Humphreys | Tennessee | 47085 | 2936 | 43 |
1750957 | 1750957 | 2021-09-24 | Jackson | Tennessee | 47087 | 1939 | 38 |
1750958 | 1750958 | 2021-09-24 | Jefferson | Tennessee | 47089 | 9330 | 134 |
1750959 | 1750959 | 2021-09-24 | Johnson | Tennessee | 47091 | 3283 | 45 |
1750960 | 1750960 | 2021-09-24 | Knox | Tennessee | 47093 | 73389 | 822 |
1750961 | 1750961 | 2021-09-24 | Lake | Tennessee | 47095 | 1939 | 31 |
1750962 | 1750962 | 2021-09-24 | Lauderdale | Tennessee | 47097 | 5008 | 59 |
1750963 | 1750963 | 2021-09-24 | Lawrence | Tennessee | 47099 | 8980 | 109 |
1750964 | 1750964 | 2021-09-24 | Lewis | Tennessee | 47101 | 2442 | 33 |
1750965 | 1750965 | 2021-09-24 | Lincoln | Tennessee | 47103 | 6296 | 79 |
1750966 | 1750966 | 2021-09-24 | Loudon | Tennessee | 47105 | 8653 | 85 |
1750967 | 1750967 | 2021-09-24 | Macon | Tennessee | 47111 | 5207 | 85 |
1750968 | 1750968 | 2021-09-24 | Madison | Tennessee | 47113 | 16893 | 284 |
1750969 | 1750969 | 2021-09-24 | Marion | Tennessee | 47115 | 5461 | 52 |
1750970 | 1750970 | 2021-09-24 | Marshall | Tennessee | 47117 | 6503 | 74 |
1750971 | 1750971 | 2021-09-24 | Maury | Tennessee | 47119 | 18457 | 205 |
1750972 | 1750972 | 2021-09-24 | McMinn | Tennessee | 47107 | 9975 | 115 |
1750973 | 1750973 | 2021-09-24 | McNairy | Tennessee | 47109 | 4352 | 62 |
1750974 | 1750974 | 2021-09-24 | Meigs | Tennessee | 47121 | 2064 | 25 |
1750975 | 1750975 | 2021-09-24 | Monroe | Tennessee | 47123 | 9155 | 112 |
1750976 | 1750976 | 2021-09-24 | Montgomery | Tennessee | 47125 | 30837 | 302 |
1750977 | 1750977 | 2021-09-24 | Moore | Tennessee | 47127 | 1363 | 19 |
1750978 | 1750978 | 2021-09-24 | Morgan | Tennessee | 47129 | 3528 | 43 |
1750979 | 1750979 | 2021-09-24 | Obion | Tennessee | 47131 | 6272 | 105 |
1750980 | 1750980 | 2021-09-24 | Overton | Tennessee | 47133 | 4451 | 76 |
1750981 | 1750981 | 2021-09-24 | Perry | Tennessee | 47135 | 1516 | 31 |
1750982 | 1750982 | 2021-09-24 | Pickett | Tennessee | 47137 | 986 | 24 |
1750983 | 1750983 | 2021-09-24 | Polk | Tennessee | 47139 | 2984 | 25 |
1750984 | 1750984 | 2021-09-24 | Putnam | Tennessee | 47141 | 15982 | 206 |
1750985 | 1750985 | 2021-09-24 | Rhea | Tennessee | 47143 | 6578 | 89 |
1750986 | 1750986 | 2021-09-24 | Roane | Tennessee | 47145 | 9288 | 138 |
1750987 | 1750987 | 2021-09-24 | Robertson | Tennessee | 47147 | 13440 | 170 |
1750988 | 1750988 | 2021-09-24 | Rutherford | Tennessee | 47149 | 59040 | 502 |
1750989 | 1750989 | 2021-09-24 | Scott | Tennessee | 47151 | 4671 | 54 |
1750990 | 1750990 | 2021-09-24 | Sequatchie | Tennessee | 47153 | 2810 | 30 |
1750991 | 1750991 | 2021-09-24 | Sevier | Tennessee | 47155 | 18732 | 235 |
1750992 | 1750992 | 2021-09-24 | Shelby | Tennessee | 47157 | 139945 | 2045 |
1750993 | 1750993 | 2021-09-24 | Smith | Tennessee | 47159 | 3984 | 44 |
1750994 | 1750994 | 2021-09-24 | Stewart | Tennessee | 47161 | 1979 | 30 |
1750995 | 1750995 | 2021-09-24 | Sullivan | Tennessee | 47163 | 24861 | 384 |
1750996 | 1750996 | 2021-09-24 | Sumner | Tennessee | 47165 | 32739 | 395 |
1750997 | 1750997 | 2021-09-24 | Tipton | Tennessee | 47167 | 10792 | 124 |
1750998 | 1750998 | 2021-09-24 | Trousdale | Tennessee | 47169 | 3017 | 24 |
1750999 | 1750999 | 2021-09-24 | Unicoi | Tennessee | 47171 | 2973 | 56 |
1751000 | 1751000 | 2021-09-24 | Union | Tennessee | 47173 | 2777 | 40 |
1751001 | 1751001 | 2021-09-24 | Unknown | Tennessee | 7909 | 112 | |
1751002 | 1751002 | 2021-09-24 | Van Buren | Tennessee | 47175 | 1154 | 25 |
1751003 | 1751003 | 2021-09-24 | Warren | Tennessee | 47177 | 8075 | 101 |
1751004 | 1751004 | 2021-09-24 | Washington | Tennessee | 47179 | 20396 | 299 |
1751005 | 1751005 | 2021-09-24 | Wayne | Tennessee | 47181 | 3861 | 38 |
1751006 | 1751006 | 2021-09-24 | Weakley | Tennessee | 47183 | 5910 | 78 |
1751007 | 1751007 | 2021-09-24 | White | Tennessee | 47185 | 5272 | 85 |
1751008 | 1751008 | 2021-09-24 | Williamson | Tennessee | 47187 | 37785 | 254 |
1751009 | 1751009 | 2021-09-24 | Wilson | Tennessee | 47189 | 25825 | 312 |
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);