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-12 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1711927 | 1711927 | 2021-09-12 | Anderson | Tennessee | 47001 | 11107 | 185 |
1711928 | 1711928 | 2021-09-12 | Bedford | Tennessee | 47003 | 8056 | 136 |
1711929 | 1711929 | 2021-09-12 | Benton | Tennessee | 47005 | 2265 | 44 |
1711930 | 1711930 | 2021-09-12 | Bledsoe | Tennessee | 47007 | 3050 | 13 |
1711931 | 1711931 | 2021-09-12 | Blount | Tennessee | 47009 | 20285 | 218 |
1711932 | 1711932 | 2021-09-12 | Bradley | Tennessee | 47011 | 19716 | 164 |
1711933 | 1711933 | 2021-09-12 | Campbell | Tennessee | 47013 | 5422 | 68 |
1711934 | 1711934 | 2021-09-12 | Cannon | Tennessee | 47015 | 2450 | 36 |
1711935 | 1711935 | 2021-09-12 | Carroll | Tennessee | 47017 | 4856 | 91 |
1711936 | 1711936 | 2021-09-12 | Carter | Tennessee | 47019 | 9013 | 188 |
1711937 | 1711937 | 2021-09-12 | Cheatham | Tennessee | 47021 | 6111 | 58 |
1711938 | 1711938 | 2021-09-12 | Chester | Tennessee | 47023 | 3051 | 57 |
1711939 | 1711939 | 2021-09-12 | Claiborne | Tennessee | 47025 | 4333 | 80 |
1711940 | 1711940 | 2021-09-12 | Clay | Tennessee | 47027 | 1290 | 32 |
1711941 | 1711941 | 2021-09-12 | Cocke | Tennessee | 47029 | 6204 | 104 |
1711942 | 1711942 | 2021-09-12 | Coffee | Tennessee | 47031 | 9104 | 136 |
1711943 | 1711943 | 2021-09-12 | Crockett | Tennessee | 47033 | 3060 | 54 |
1711944 | 1711944 | 2021-09-12 | Cumberland | Tennessee | 47035 | 9470 | 168 |
1711945 | 1711945 | 2021-09-12 | Davidson | Tennessee | 47037 | 119511 | 1029 |
1711946 | 1711946 | 2021-09-12 | DeKalb | Tennessee | 47041 | 3757 | 59 |
1711947 | 1711947 | 2021-09-12 | Decatur | Tennessee | 47039 | 2138 | 41 |
1711948 | 1711948 | 2021-09-12 | Dickson | Tennessee | 47043 | 9004 | 136 |
1711949 | 1711949 | 2021-09-12 | Dyer | Tennessee | 47045 | 7360 | 119 |
1711950 | 1711950 | 2021-09-12 | Fayette | Tennessee | 47047 | 6585 | 93 |
1711951 | 1711951 | 2021-09-12 | Fentress | Tennessee | 47049 | 3084 | 50 |
1711952 | 1711952 | 2021-09-12 | Franklin | Tennessee | 47051 | 6966 | 94 |
1711953 | 1711953 | 2021-09-12 | Gibson | Tennessee | 47053 | 9471 | 169 |
1711954 | 1711954 | 2021-09-12 | Giles | Tennessee | 47055 | 5114 | 103 |
1711955 | 1711955 | 2021-09-12 | Grainger | Tennessee | 47057 | 3630 | 52 |
1711956 | 1711956 | 2021-09-12 | Greene | Tennessee | 47059 | 11119 | 187 |
1711957 | 1711957 | 2021-09-12 | Grundy | Tennessee | 47061 | 2344 | 36 |
1711958 | 1711958 | 2021-09-12 | Hamblen | Tennessee | 47063 | 11614 | 183 |
1711959 | 1711959 | 2021-09-12 | Hamilton | Tennessee | 47065 | 57877 | 578 |
1711960 | 1711960 | 2021-09-12 | Hancock | Tennessee | 47067 | 954 | 15 |
1711961 | 1711961 | 2021-09-12 | Hardeman | Tennessee | 47069 | 4623 | 70 |
1711962 | 1711962 | 2021-09-12 | Hardin | Tennessee | 47071 | 4888 | 71 |
1711963 | 1711963 | 2021-09-12 | Hawkins | Tennessee | 47073 | 8540 | 134 |
1711964 | 1711964 | 2021-09-12 | Haywood | Tennessee | 47075 | 3453 | 66 |
1711965 | 1711965 | 2021-09-12 | Henderson | Tennessee | 47077 | 4836 | 82 |
1711966 | 1711966 | 2021-09-12 | Henry | Tennessee | 47079 | 4835 | 76 |
1711967 | 1711967 | 2021-09-12 | Hickman | Tennessee | 47081 | 4063 | 53 |
1711968 | 1711968 | 2021-09-12 | Houston | Tennessee | 47083 | 1577 | 38 |
1711969 | 1711969 | 2021-09-12 | Humphreys | Tennessee | 47085 | 2632 | 37 |
1711970 | 1711970 | 2021-09-12 | Jackson | Tennessee | 47087 | 1768 | 37 |
1711971 | 1711971 | 2021-09-12 | Jefferson | Tennessee | 47089 | 8540 | 132 |
1711972 | 1711972 | 2021-09-12 | Johnson | Tennessee | 47091 | 3015 | 41 |
1711973 | 1711973 | 2021-09-12 | Knox | Tennessee | 47093 | 66798 | 734 |
1711974 | 1711974 | 2021-09-12 | Lake | Tennessee | 47095 | 1875 | 31 |
1711975 | 1711975 | 2021-09-12 | Lauderdale | Tennessee | 47097 | 4679 | 52 |
1711976 | 1711976 | 2021-09-12 | Lawrence | Tennessee | 47099 | 8167 | 106 |
1711977 | 1711977 | 2021-09-12 | Lewis | Tennessee | 47101 | 2316 | 30 |
1711978 | 1711978 | 2021-09-12 | Lincoln | Tennessee | 47103 | 5809 | 76 |
1711979 | 1711979 | 2021-09-12 | Loudon | Tennessee | 47105 | 7903 | 78 |
1711980 | 1711980 | 2021-09-12 | Macon | Tennessee | 47111 | 4799 | 81 |
1711981 | 1711981 | 2021-09-12 | Madison | Tennessee | 47113 | 15869 | 274 |
1711982 | 1711982 | 2021-09-12 | Marion | Tennessee | 47115 | 5016 | 51 |
1711983 | 1711983 | 2021-09-12 | Marshall | Tennessee | 47117 | 6072 | 70 |
1711984 | 1711984 | 2021-09-12 | Maury | Tennessee | 47119 | 17344 | 192 |
1711985 | 1711985 | 2021-09-12 | McMinn | Tennessee | 47107 | 9093 | 112 |
1711986 | 1711986 | 2021-09-12 | McNairy | Tennessee | 47109 | 3984 | 61 |
1711987 | 1711987 | 2021-09-12 | Meigs | Tennessee | 47121 | 1888 | 24 |
1711988 | 1711988 | 2021-09-12 | Monroe | Tennessee | 47123 | 8388 | 106 |
1711989 | 1711989 | 2021-09-12 | Montgomery | Tennessee | 47125 | 28295 | 248 |
1711990 | 1711990 | 2021-09-12 | Moore | Tennessee | 47127 | 1264 | 19 |
1711991 | 1711991 | 2021-09-12 | Morgan | Tennessee | 47129 | 3204 | 41 |
1711992 | 1711992 | 2021-09-12 | Obion | Tennessee | 47131 | 5808 | 101 |
1711993 | 1711993 | 2021-09-12 | Overton | Tennessee | 47133 | 4068 | 65 |
1711994 | 1711994 | 2021-09-12 | Perry | Tennessee | 47135 | 1385 | 31 |
1711995 | 1711995 | 2021-09-12 | Pickett | Tennessee | 47137 | 921 | 24 |
1711996 | 1711996 | 2021-09-12 | Polk | Tennessee | 47139 | 2759 | 25 |
1711997 | 1711997 | 2021-09-12 | Putnam | Tennessee | 47141 | 14650 | 190 |
1711998 | 1711998 | 2021-09-12 | Rhea | Tennessee | 47143 | 5980 | 86 |
1711999 | 1711999 | 2021-09-12 | Roane | Tennessee | 47145 | 8574 | 126 |
1712000 | 1712000 | 2021-09-12 | Robertson | Tennessee | 47147 | 12509 | 160 |
1712001 | 1712001 | 2021-09-12 | Rutherford | Tennessee | 47149 | 55172 | 478 |
1712002 | 1712002 | 2021-09-12 | Scott | Tennessee | 47151 | 4080 | 51 |
1712003 | 1712003 | 2021-09-12 | Sequatchie | Tennessee | 47153 | 2547 | 30 |
1712004 | 1712004 | 2021-09-12 | Sevier | Tennessee | 47155 | 17351 | 204 |
1712005 | 1712005 | 2021-09-12 | Shelby | Tennessee | 47157 | 134275 | 1937 |
1712006 | 1712006 | 2021-09-12 | Smith | Tennessee | 47159 | 3694 | 42 |
1712007 | 1712007 | 2021-09-12 | Stewart | Tennessee | 47161 | 1773 | 28 |
1712008 | 1712008 | 2021-09-12 | Sullivan | Tennessee | 47163 | 22746 | 356 |
1712009 | 1712009 | 2021-09-12 | Sumner | Tennessee | 47165 | 31121 | 388 |
1712010 | 1712010 | 2021-09-12 | Tipton | Tennessee | 47167 | 10165 | 115 |
1712011 | 1712011 | 2021-09-12 | Trousdale | Tennessee | 47169 | 2877 | 23 |
1712012 | 1712012 | 2021-09-12 | Unicoi | Tennessee | 47171 | 2707 | 56 |
1712013 | 1712013 | 2021-09-12 | Union | Tennessee | 47173 | 2499 | 37 |
1712014 | 1712014 | 2021-09-12 | Unknown | Tennessee | 5124 | 100 | |
1712015 | 1712015 | 2021-09-12 | Van Buren | Tennessee | 47175 | 1043 | 24 |
1712016 | 1712016 | 2021-09-12 | Warren | Tennessee | 47177 | 7362 | 94 |
1712017 | 1712017 | 2021-09-12 | Washington | Tennessee | 47179 | 19021 | 280 |
1712018 | 1712018 | 2021-09-12 | Wayne | Tennessee | 47181 | 3639 | 37 |
1712019 | 1712019 | 2021-09-12 | Weakley | Tennessee | 47183 | 5383 | 74 |
1712020 | 1712020 | 2021-09-12 | White | Tennessee | 47185 | 4808 | 82 |
1712021 | 1712021 | 2021-09-12 | Williamson | Tennessee | 47187 | 35818 | 246 |
1712022 | 1712022 | 2021-09-12 | Wilson | Tennessee | 47189 | 24355 | 289 |
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);