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-10-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 |
---|---|---|---|---|---|---|---|
1832139 | 1832139 | 2021-10-19 | Anderson | Tennessee | 47001 | 12789 | 213 |
1832140 | 1832140 | 2021-10-19 | Bedford | Tennessee | 47003 | 9066 | 154 |
1832141 | 1832141 | 2021-10-19 | Benton | Tennessee | 47005 | 2748 | 50 |
1832142 | 1832142 | 2021-10-19 | Bledsoe | Tennessee | 47007 | 3473 | 17 |
1832143 | 1832143 | 2021-10-19 | Blount | Tennessee | 47009 | 23518 | 265 |
1832144 | 1832144 | 2021-10-19 | Bradley | Tennessee | 47011 | 21943 | 189 |
1832145 | 1832145 | 2021-10-19 | Campbell | Tennessee | 47013 | 7117 | 79 |
1832146 | 1832146 | 2021-10-19 | Cannon | Tennessee | 47015 | 2777 | 40 |
1832147 | 1832147 | 2021-10-19 | Carroll | Tennessee | 47017 | 5685 | 100 |
1832148 | 1832148 | 2021-10-19 | Carter | Tennessee | 47019 | 10433 | 212 |
1832149 | 1832149 | 2021-10-19 | Cheatham | Tennessee | 47021 | 6957 | 69 |
1832150 | 1832150 | 2021-10-19 | Chester | Tennessee | 47023 | 3500 | 72 |
1832151 | 1832151 | 2021-10-19 | Claiborne | Tennessee | 47025 | 5352 | 108 |
1832152 | 1832152 | 2021-10-19 | Clay | Tennessee | 47027 | 1506 | 36 |
1832153 | 1832153 | 2021-10-19 | Cocke | Tennessee | 47029 | 7305 | 105 |
1832154 | 1832154 | 2021-10-19 | Coffee | Tennessee | 47031 | 10451 | 153 |
1832155 | 1832155 | 2021-10-19 | Crockett | Tennessee | 47033 | 3338 | 62 |
1832156 | 1832156 | 2021-10-19 | Cumberland | Tennessee | 47035 | 10969 | 215 |
1832157 | 1832157 | 2021-10-19 | Davidson | Tennessee | 47037 | 131447 | 1141 |
1832158 | 1832158 | 2021-10-19 | DeKalb | Tennessee | 47041 | 4165 | 68 |
1832159 | 1832159 | 2021-10-19 | Decatur | Tennessee | 47039 | 2409 | 44 |
1832160 | 1832160 | 2021-10-19 | Dickson | Tennessee | 47043 | 10292 | 162 |
1832161 | 1832161 | 2021-10-19 | Dyer | Tennessee | 47045 | 8052 | 142 |
1832162 | 1832162 | 2021-10-19 | Fayette | Tennessee | 47047 | 7240 | 101 |
1832163 | 1832163 | 2021-10-19 | Fentress | Tennessee | 47049 | 3591 | 64 |
1832164 | 1832164 | 2021-10-19 | Franklin | Tennessee | 47051 | 7862 | 100 |
1832165 | 1832165 | 2021-10-19 | Gibson | Tennessee | 47053 | 10595 | 188 |
1832166 | 1832166 | 2021-10-19 | Giles | Tennessee | 47055 | 5999 | 116 |
1832167 | 1832167 | 2021-10-19 | Grainger | Tennessee | 47057 | 4298 | 65 |
1832168 | 1832168 | 2021-10-19 | Greene | Tennessee | 47059 | 13443 | 237 |
1832169 | 1832169 | 2021-10-19 | Grundy | Tennessee | 47061 | 2790 | 37 |
1832170 | 1832170 | 2021-10-19 | Hamblen | Tennessee | 47063 | 12920 | 194 |
1832171 | 1832171 | 2021-10-19 | Hamilton | Tennessee | 47065 | 63454 | 645 |
1832172 | 1832172 | 2021-10-19 | Hancock | Tennessee | 47067 | 1197 | 20 |
1832173 | 1832173 | 2021-10-19 | Hardeman | Tennessee | 47069 | 5079 | 79 |
1832174 | 1832174 | 2021-10-19 | Hardin | Tennessee | 47071 | 5501 | 81 |
1832175 | 1832175 | 2021-10-19 | Hawkins | Tennessee | 47073 | 10093 | 166 |
1832176 | 1832176 | 2021-10-19 | Haywood | Tennessee | 47075 | 3791 | 73 |
1832177 | 1832177 | 2021-10-19 | Henderson | Tennessee | 47077 | 5696 | 99 |
1832178 | 1832178 | 2021-10-19 | Henry | Tennessee | 47079 | 5436 | 85 |
1832179 | 1832179 | 2021-10-19 | Hickman | Tennessee | 47081 | 4552 | 74 |
1832180 | 1832180 | 2021-10-19 | Houston | Tennessee | 47083 | 1825 | 43 |
1832181 | 1832181 | 2021-10-19 | Humphreys | Tennessee | 47085 | 3195 | 45 |
1832182 | 1832182 | 2021-10-19 | Jackson | Tennessee | 47087 | 2060 | 40 |
1832183 | 1832183 | 2021-10-19 | Jefferson | Tennessee | 47089 | 9836 | 141 |
1832184 | 1832184 | 2021-10-19 | Johnson | Tennessee | 47091 | 3505 | 47 |
1832185 | 1832185 | 2021-10-19 | Knox | Tennessee | 47093 | 77772 | 903 |
1832186 | 1832186 | 2021-10-19 | Lake | Tennessee | 47095 | 2009 | 31 |
1832187 | 1832187 | 2021-10-19 | Lauderdale | Tennessee | 47097 | 5192 | 61 |
1832188 | 1832188 | 2021-10-19 | Lawrence | Tennessee | 47099 | 9480 | 117 |
1832189 | 1832189 | 2021-10-19 | Lewis | Tennessee | 47101 | 2509 | 38 |
1832190 | 1832190 | 2021-10-19 | Lincoln | Tennessee | 47103 | 6612 | 81 |
1832191 | 1832191 | 2021-10-19 | Loudon | Tennessee | 47105 | 9045 | 93 |
1832192 | 1832192 | 2021-10-19 | Macon | Tennessee | 47111 | 5434 | 90 |
1832193 | 1832193 | 2021-10-19 | Madison | Tennessee | 47113 | 17487 | 309 |
1832194 | 1832194 | 2021-10-19 | Marion | Tennessee | 47115 | 5712 | 52 |
1832195 | 1832195 | 2021-10-19 | Marshall | Tennessee | 47117 | 6797 | 84 |
1832196 | 1832196 | 2021-10-19 | Maury | Tennessee | 47119 | 19222 | 225 |
1832197 | 1832197 | 2021-10-19 | McMinn | Tennessee | 47107 | 10403 | 127 |
1832198 | 1832198 | 2021-10-19 | McNairy | Tennessee | 47109 | 4569 | 67 |
1832199 | 1832199 | 2021-10-19 | Meigs | Tennessee | 47121 | 2158 | 28 |
1832200 | 1832200 | 2021-10-19 | Monroe | Tennessee | 47123 | 9610 | 122 |
1832201 | 1832201 | 2021-10-19 | Montgomery | Tennessee | 47125 | 32612 | 327 |
1832202 | 1832202 | 2021-10-19 | Moore | Tennessee | 47127 | 1427 | 22 |
1832203 | 1832203 | 2021-10-19 | Morgan | Tennessee | 47129 | 3758 | 47 |
1832204 | 1832204 | 2021-10-19 | Obion | Tennessee | 47131 | 6572 | 110 |
1832205 | 1832205 | 2021-10-19 | Overton | Tennessee | 47133 | 4753 | 79 |
1832206 | 1832206 | 2021-10-19 | Perry | Tennessee | 47135 | 1595 | 34 |
1832207 | 1832207 | 2021-10-19 | Pickett | Tennessee | 47137 | 1071 | 24 |
1832208 | 1832208 | 2021-10-19 | Polk | Tennessee | 47139 | 3164 | 29 |
1832209 | 1832209 | 2021-10-19 | Putnam | Tennessee | 47141 | 16565 | 214 |
1832210 | 1832210 | 2021-10-19 | Rhea | Tennessee | 47143 | 6921 | 92 |
1832211 | 1832211 | 2021-10-19 | Roane | Tennessee | 47145 | 9878 | 149 |
1832212 | 1832212 | 2021-10-19 | Robertson | Tennessee | 47147 | 13967 | 177 |
1832213 | 1832213 | 2021-10-19 | Rutherford | Tennessee | 47149 | 61297 | 535 |
1832214 | 1832214 | 2021-10-19 | Scott | Tennessee | 47151 | 5117 | 58 |
1832215 | 1832215 | 2021-10-19 | Sequatchie | Tennessee | 47153 | 2958 | 32 |
1832216 | 1832216 | 2021-10-19 | Sevier | Tennessee | 47155 | 19858 | 263 |
1832217 | 1832217 | 2021-10-19 | Shelby | Tennessee | 47157 | 144874 | 2211 |
1832218 | 1832218 | 2021-10-19 | Smith | Tennessee | 47159 | 4144 | 52 |
1832219 | 1832219 | 2021-10-19 | Stewart | Tennessee | 47161 | 2119 | 34 |
1832220 | 1832220 | 2021-10-19 | Sullivan | Tennessee | 47163 | 26429 | 413 |
1832221 | 1832221 | 2021-10-19 | Sumner | Tennessee | 47165 | 33979 | 404 |
1832222 | 1832222 | 2021-10-19 | Tipton | Tennessee | 47167 | 11256 | 126 |
1832223 | 1832223 | 2021-10-19 | Trousdale | Tennessee | 47169 | 3146 | 26 |
1832224 | 1832224 | 2021-10-19 | Unicoi | Tennessee | 47171 | 3119 | 65 |
1832225 | 1832225 | 2021-10-19 | Union | Tennessee | 47173 | 3066 | 45 |
1832226 | 1832226 | 2021-10-19 | Unknown | Tennessee | 8482 | 128 | |
1832227 | 1832227 | 2021-10-19 | Van Buren | Tennessee | 47175 | 1228 | 27 |
1832228 | 1832228 | 2021-10-19 | Warren | Tennessee | 47177 | 8524 | 116 |
1832229 | 1832229 | 2021-10-19 | Washington | Tennessee | 47179 | 21447 | 321 |
1832230 | 1832230 | 2021-10-19 | Wayne | Tennessee | 47181 | 4013 | 39 |
1832231 | 1832231 | 2021-10-19 | Weakley | Tennessee | 47183 | 6218 | 87 |
1832232 | 1832232 | 2021-10-19 | White | Tennessee | 47185 | 5571 | 95 |
1832233 | 1832233 | 2021-10-19 | Williamson | Tennessee | 47187 | 39334 | 266 |
1832234 | 1832234 | 2021-10-19 | Wilson | Tennessee | 47189 | 26871 | 329 |
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);