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-08-19 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1633961 | 1633961 | 2021-08-19 | Anderson | Tennessee | 47001 | 9635 | 182 |
1633962 | 1633962 | 2021-08-19 | Bedford | Tennessee | 47003 | 7231 | 135 |
1633963 | 1633963 | 2021-08-19 | Benton | Tennessee | 47005 | 1908 | 41 |
1633964 | 1633964 | 2021-08-19 | Bledsoe | Tennessee | 47007 | 2479 | 13 |
1633965 | 1633965 | 2021-08-19 | Blount | Tennessee | 47009 | 17690 | 210 |
1633966 | 1633966 | 2021-08-19 | Bradley | Tennessee | 47011 | 16812 | 159 |
1633967 | 1633967 | 2021-08-19 | Campbell | Tennessee | 47013 | 4613 | 64 |
1633968 | 1633968 | 2021-08-19 | Cannon | Tennessee | 47015 | 2101 | 32 |
1633969 | 1633969 | 2021-08-19 | Carroll | Tennessee | 47017 | 4093 | 85 |
1633970 | 1633970 | 2021-08-19 | Carter | Tennessee | 47019 | 7561 | 171 |
1633971 | 1633971 | 2021-08-19 | Cheatham | Tennessee | 47021 | 5073 | 56 |
1633972 | 1633972 | 2021-08-19 | Chester | Tennessee | 47023 | 2579 | 54 |
1633973 | 1633973 | 2021-08-19 | Claiborne | Tennessee | 47025 | 3569 | 78 |
1633974 | 1633974 | 2021-08-19 | Clay | Tennessee | 47027 | 1164 | 30 |
1633975 | 1633975 | 2021-08-19 | Cocke | Tennessee | 47029 | 5250 | 102 |
1633976 | 1633976 | 2021-08-19 | Coffee | Tennessee | 47031 | 7603 | 123 |
1633977 | 1633977 | 2021-08-19 | Crockett | Tennessee | 47033 | 2557 | 53 |
1633978 | 1633978 | 2021-08-19 | Cumberland | Tennessee | 47035 | 7811 | 147 |
1633979 | 1633979 | 2021-08-19 | Davidson | Tennessee | 47037 | 107810 | 986 |
1633980 | 1633980 | 2021-08-19 | DeKalb | Tennessee | 47041 | 3078 | 57 |
1633981 | 1633981 | 2021-08-19 | Decatur | Tennessee | 47039 | 1805 | 39 |
1633982 | 1633982 | 2021-08-19 | Dickson | Tennessee | 47043 | 7771 | 122 |
1633983 | 1633983 | 2021-08-19 | Dyer | Tennessee | 47045 | 6104 | 112 |
1633984 | 1633984 | 2021-08-19 | Fayette | Tennessee | 47047 | 5882 | 85 |
1633985 | 1633985 | 2021-08-19 | Fentress | Tennessee | 47049 | 2679 | 50 |
1633986 | 1633986 | 2021-08-19 | Franklin | Tennessee | 47051 | 5873 | 92 |
1633987 | 1633987 | 2021-08-19 | Gibson | Tennessee | 47053 | 7918 | 154 |
1633988 | 1633988 | 2021-08-19 | Giles | Tennessee | 47055 | 4424 | 100 |
1633989 | 1633989 | 2021-08-19 | Grainger | Tennessee | 47057 | 2963 | 51 |
1633990 | 1633990 | 2021-08-19 | Greene | Tennessee | 47059 | 9040 | 169 |
1633991 | 1633991 | 2021-08-19 | Grundy | Tennessee | 47061 | 1994 | 35 |
1633992 | 1633992 | 2021-08-19 | Hamblen | Tennessee | 47063 | 9875 | 179 |
1633993 | 1633993 | 2021-08-19 | Hamilton | Tennessee | 47065 | 51293 | 539 |
1633994 | 1633994 | 2021-08-19 | Hancock | Tennessee | 47067 | 724 | 13 |
1633995 | 1633995 | 2021-08-19 | Hardeman | Tennessee | 47069 | 4007 | 66 |
1633996 | 1633996 | 2021-08-19 | Hardin | Tennessee | 47071 | 4058 | 70 |
1633997 | 1633997 | 2021-08-19 | Hawkins | Tennessee | 47073 | 7123 | 124 |
1633998 | 1633998 | 2021-08-19 | Haywood | Tennessee | 47075 | 3040 | 66 |
1633999 | 1633999 | 2021-08-19 | Henderson | Tennessee | 47077 | 4185 | 80 |
1634000 | 1634000 | 2021-08-19 | Henry | Tennessee | 47079 | 4007 | 76 |
1634001 | 1634001 | 2021-08-19 | Hickman | Tennessee | 47081 | 3302 | 49 |
1634002 | 1634002 | 2021-08-19 | Houston | Tennessee | 47083 | 1353 | 34 |
1634003 | 1634003 | 2021-08-19 | Humphreys | Tennessee | 47085 | 2233 | 32 |
1634004 | 1634004 | 2021-08-19 | Jackson | Tennessee | 47087 | 1476 | 37 |
1634005 | 1634005 | 2021-08-19 | Jefferson | Tennessee | 47089 | 7101 | 130 |
1634006 | 1634006 | 2021-08-19 | Johnson | Tennessee | 47091 | 2624 | 39 |
1634007 | 1634007 | 2021-08-19 | Knox | Tennessee | 47093 | 57013 | 677 |
1634008 | 1634008 | 2021-08-19 | Lake | Tennessee | 47095 | 1767 | 31 |
1634009 | 1634009 | 2021-08-19 | Lauderdale | Tennessee | 47097 | 3773 | 50 |
1634010 | 1634010 | 2021-08-19 | Lawrence | Tennessee | 47099 | 6758 | 102 |
1634011 | 1634011 | 2021-08-19 | Lewis | Tennessee | 47101 | 1868 | 29 |
1634012 | 1634012 | 2021-08-19 | Lincoln | Tennessee | 47103 | 5003 | 70 |
1634013 | 1634013 | 2021-08-19 | Loudon | Tennessee | 47105 | 6792 | 74 |
1634014 | 1634014 | 2021-08-19 | Macon | Tennessee | 47111 | 4039 | 79 |
1634015 | 1634015 | 2021-08-19 | Madison | Tennessee | 47113 | 13531 | 257 |
1634016 | 1634016 | 2021-08-19 | Marion | Tennessee | 47115 | 3748 | 51 |
1634017 | 1634017 | 2021-08-19 | Marshall | Tennessee | 47117 | 4888 | 65 |
1634018 | 1634018 | 2021-08-19 | Maury | Tennessee | 47119 | 15114 | 184 |
1634019 | 1634019 | 2021-08-19 | McMinn | Tennessee | 47107 | 7460 | 108 |
1634020 | 1634020 | 2021-08-19 | McNairy | Tennessee | 47109 | 3350 | 57 |
1634021 | 1634021 | 2021-08-19 | Meigs | Tennessee | 47121 | 1589 | 24 |
1634022 | 1634022 | 2021-08-19 | Monroe | Tennessee | 47123 | 6685 | 98 |
1634023 | 1634023 | 2021-08-19 | Montgomery | Tennessee | 47125 | 23753 | 238 |
1634024 | 1634024 | 2021-08-19 | Moore | Tennessee | 47127 | 1150 | 19 |
1634025 | 1634025 | 2021-08-19 | Morgan | Tennessee | 47129 | 2813 | 41 |
1634026 | 1634026 | 2021-08-19 | Obion | Tennessee | 47131 | 5010 | 99 |
1634027 | 1634027 | 2021-08-19 | Overton | Tennessee | 47133 | 3300 | 63 |
1634028 | 1634028 | 2021-08-19 | Perry | Tennessee | 47135 | 1186 | 29 |
1634029 | 1634029 | 2021-08-19 | Pickett | Tennessee | 47137 | 826 | 24 |
1634030 | 1634030 | 2021-08-19 | Polk | Tennessee | 47139 | 2351 | 25 |
1634031 | 1634031 | 2021-08-19 | Putnam | Tennessee | 47141 | 12689 | 184 |
1634032 | 1634032 | 2021-08-19 | Rhea | Tennessee | 47143 | 4955 | 83 |
1634033 | 1634033 | 2021-08-19 | Roane | Tennessee | 47145 | 7202 | 117 |
1634034 | 1634034 | 2021-08-19 | Robertson | Tennessee | 47147 | 10907 | 145 |
1634035 | 1634035 | 2021-08-19 | Rutherford | Tennessee | 47149 | 47996 | 462 |
1634036 | 1634036 | 2021-08-19 | Scott | Tennessee | 47151 | 3430 | 49 |
1634037 | 1634037 | 2021-08-19 | Sequatchie | Tennessee | 47153 | 1982 | 30 |
1634038 | 1634038 | 2021-08-19 | Sevier | Tennessee | 47155 | 15226 | 187 |
1634039 | 1634039 | 2021-08-19 | Shelby | Tennessee | 47157 | 116834 | 1806 |
1634040 | 1634040 | 2021-08-19 | Smith | Tennessee | 47159 | 3097 | 40 |
1634041 | 1634041 | 2021-08-19 | Stewart | Tennessee | 47161 | 1490 | 28 |
1634042 | 1634042 | 2021-08-19 | Sullivan | Tennessee | 47163 | 19372 | 328 |
1634043 | 1634043 | 2021-08-19 | Sumner | Tennessee | 47165 | 27498 | 368 |
1634044 | 1634044 | 2021-08-19 | Tipton | Tennessee | 47167 | 8714 | 109 |
1634045 | 1634045 | 2021-08-19 | Trousdale | Tennessee | 47169 | 2680 | 22 |
1634046 | 1634046 | 2021-08-19 | Unicoi | Tennessee | 47171 | 2233 | 51 |
1634047 | 1634047 | 2021-08-19 | Union | Tennessee | 47173 | 2080 | 35 |
1634048 | 1634048 | 2021-08-19 | Unknown | Tennessee | 9092 | 94 | |
1634049 | 1634049 | 2021-08-19 | Van Buren | Tennessee | 47175 | 934 | 23 |
1634050 | 1634050 | 2021-08-19 | Warren | Tennessee | 47177 | 5972 | 87 |
1634051 | 1634051 | 2021-08-19 | Washington | Tennessee | 47179 | 16416 | 260 |
1634052 | 1634052 | 2021-08-19 | Wayne | Tennessee | 47181 | 3214 | 36 |
1634053 | 1634053 | 2021-08-19 | Weakley | Tennessee | 47183 | 4605 | 70 |
1634054 | 1634054 | 2021-08-19 | White | Tennessee | 47185 | 4037 | 75 |
1634055 | 1634055 | 2021-08-19 | Williamson | Tennessee | 47187 | 31945 | 229 |
1634056 | 1634056 | 2021-08-19 | Wilson | Tennessee | 47189 | 21466 | 262 |
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);