ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2022-03-24" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2339337 | 2339337 | 2022-03-24 | Anderson | Tennessee | 47001 | 22047 | 321 |
2339338 | 2339338 | 2022-03-24 | Bedford | Tennessee | 47003 | 14933 | 230 |
2339339 | 2339339 | 2022-03-24 | Benton | Tennessee | 47005 | 4471 | 90 |
2339340 | 2339340 | 2022-03-24 | Bledsoe | Tennessee | 47007 | 4652 | 56 |
2339341 | 2339341 | 2022-03-24 | Blount | Tennessee | 47009 | 39027 | 418 |
2339342 | 2339342 | 2022-03-24 | Bradley | Tennessee | 47011 | 33065 | 402 |
2339343 | 2339343 | 2022-03-24 | Campbell | Tennessee | 47013 | 12204 | 160 |
2339344 | 2339344 | 2022-03-24 | Cannon | Tennessee | 47015 | 4187 | 58 |
2339345 | 2339345 | 2022-03-24 | Carroll | Tennessee | 47017 | 8940 | 155 |
2339346 | 2339346 | 2022-03-24 | Carter | Tennessee | 47019 | 16432 | 328 |
2339347 | 2339347 | 2022-03-24 | Cheatham | Tennessee | 47021 | 10896 | 119 |
2339348 | 2339348 | 2022-03-24 | Chester | Tennessee | 47023 | 5823 | 96 |
2339349 | 2339349 | 2022-03-24 | Claiborne | Tennessee | 47025 | 9084 | 176 |
2339350 | 2339350 | 2022-03-24 | Clay | Tennessee | 47027 | 2224 | 49 |
2339351 | 2339351 | 2022-03-24 | Cocke | Tennessee | 47029 | 11553 | 209 |
2339352 | 2339352 | 2022-03-24 | Coffee | Tennessee | 47031 | 16925 | 261 |
2339353 | 2339353 | 2022-03-24 | Crockett | Tennessee | 47033 | 5171 | 84 |
2339354 | 2339354 | 2022-03-24 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2339355 | 2339355 | 2022-03-24 | Davidson | Tennessee | 47037 | 206775 | 1631 |
2339356 | 2339356 | 2022-03-24 | DeKalb | Tennessee | 47041 | 6276 | 100 |
2339357 | 2339357 | 2022-03-24 | Decatur | Tennessee | 47039 | 3726 | 67 |
2339358 | 2339358 | 2022-03-24 | Dickson | Tennessee | 47043 | 15853 | 240 |
2339359 | 2339359 | 2022-03-24 | Dyer | Tennessee | 47045 | 12764 | 199 |
2339360 | 2339360 | 2022-03-24 | Fayette | Tennessee | 47047 | 11395 | 180 |
2339361 | 2339361 | 2022-03-24 | Fentress | Tennessee | 47049 | 5691 | 125 |
2339362 | 2339362 | 2022-03-24 | Franklin | Tennessee | 47051 | 12829 | 176 |
2339363 | 2339363 | 2022-03-24 | Gibson | Tennessee | 47053 | 17366 | 254 |
2339364 | 2339364 | 2022-03-24 | Giles | Tennessee | 47055 | 9397 | 186 |
2339365 | 2339365 | 2022-03-24 | Grainger | Tennessee | 47057 | 6765 | 107 |
2339366 | 2339366 | 2022-03-24 | Greene | Tennessee | 47059 | 22029 | 363 |
2339367 | 2339367 | 2022-03-24 | Grundy | Tennessee | 47061 | 3980 | 71 |
2339368 | 2339368 | 2022-03-24 | Hamblen | Tennessee | 47063 | 19679 | 347 |
2339369 | 2339369 | 2022-03-24 | Hamilton | Tennessee | 47065 | 99558 | 1116 |
2339370 | 2339370 | 2022-03-24 | Hancock | Tennessee | 47067 | 2002 | 34 |
2339371 | 2339371 | 2022-03-24 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2339372 | 2339372 | 2022-03-24 | Hardin | Tennessee | 47071 | 8732 | 141 |
2339373 | 2339373 | 2022-03-24 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2339374 | 2339374 | 2022-03-24 | Haywood | Tennessee | 47075 | 6150 | 99 |
2339375 | 2339375 | 2022-03-24 | Henderson | Tennessee | 47077 | 9094 | 154 |
2339376 | 2339376 | 2022-03-24 | Henry | Tennessee | 47079 | 8244 | 154 |
2339377 | 2339377 | 2022-03-24 | Hickman | Tennessee | 47081 | 6815 | 108 |
2339378 | 2339378 | 2022-03-24 | Houston | Tennessee | 47083 | 2673 | 60 |
2339379 | 2339379 | 2022-03-24 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2339380 | 2339380 | 2022-03-24 | Jackson | Tennessee | 47087 | 3202 | 62 |
2339381 | 2339381 | 2022-03-24 | Jefferson | Tennessee | 47089 | 15692 | 259 |
2339382 | 2339382 | 2022-03-24 | Johnson | Tennessee | 47091 | 5139 | 88 |
2339383 | 2339383 | 2022-03-24 | Knox | Tennessee | 47093 | 127542 | 1335 |
2339384 | 2339384 | 2022-03-24 | Lake | Tennessee | 47095 | 2737 | 40 |
2339385 | 2339385 | 2022-03-24 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2339386 | 2339386 | 2022-03-24 | Lawrence | Tennessee | 47099 | 14258 | 191 |
2339387 | 2339387 | 2022-03-24 | Lewis | Tennessee | 47101 | 3568 | 57 |
2339388 | 2339388 | 2022-03-24 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2339389 | 2339389 | 2022-03-24 | Loudon | Tennessee | 47105 | 14424 | 188 |
2339390 | 2339390 | 2022-03-24 | Macon | Tennessee | 47111 | 8422 | 145 |
2339391 | 2339391 | 2022-03-24 | Madison | Tennessee | 47113 | 29784 | 418 |
2339392 | 2339392 | 2022-03-24 | Marion | Tennessee | 47115 | 8833 | 127 |
2339393 | 2339393 | 2022-03-24 | Marshall | Tennessee | 47117 | 10351 | 119 |
2339394 | 2339394 | 2022-03-24 | Maury | Tennessee | 47119 | 28867 | 330 |
2339395 | 2339395 | 2022-03-24 | McMinn | Tennessee | 47107 | 16652 | 251 |
2339396 | 2339396 | 2022-03-24 | McNairy | Tennessee | 47109 | 7629 | 118 |
2339397 | 2339397 | 2022-03-24 | Meigs | Tennessee | 47121 | 3351 | 55 |
2339398 | 2339398 | 2022-03-24 | Monroe | Tennessee | 47123 | 14482 | 235 |
2339399 | 2339399 | 2022-03-24 | Montgomery | Tennessee | 47125 | 50080 | 561 |
2339400 | 2339400 | 2022-03-24 | Moore | Tennessee | 47127 | 2237 | 40 |
2339401 | 2339401 | 2022-03-24 | Morgan | Tennessee | 47129 | 6158 | 80 |
2339402 | 2339402 | 2022-03-24 | Obion | Tennessee | 47131 | 10753 | 187 |
2339403 | 2339403 | 2022-03-24 | Overton | Tennessee | 47133 | 7147 | 121 |
2339404 | 2339404 | 2022-03-24 | Perry | Tennessee | 47135 | 2328 | 55 |
2339405 | 2339405 | 2022-03-24 | Pickett | Tennessee | 47137 | 1764 | 36 |
2339406 | 2339406 | 2022-03-24 | Polk | Tennessee | 47139 | 4722 | 70 |
2339407 | 2339407 | 2022-03-24 | Putnam | Tennessee | 47141 | 25068 | 302 |
2339408 | 2339408 | 2022-03-24 | Rhea | Tennessee | 47143 | 9959 | 154 |
2339409 | 2339409 | 2022-03-24 | Roane | Tennessee | 47145 | 15764 | 231 |
2339410 | 2339410 | 2022-03-24 | Robertson | Tennessee | 47147 | 21503 | 295 |
2339411 | 2339411 | 2022-03-24 | Rutherford | Tennessee | 47149 | 95505 | 879 |
2339412 | 2339412 | 2022-03-24 | Scott | Tennessee | 47151 | 9029 | 115 |
2339413 | 2339413 | 2022-03-24 | Sequatchie | Tennessee | 47153 | 4204 | 66 |
2339414 | 2339414 | 2022-03-24 | Sevier | Tennessee | 47155 | 30246 | 401 |
2339415 | 2339415 | 2022-03-24 | Shelby | Tennessee | 47157 | 237491 | 3232 |
2339416 | 2339416 | 2022-03-24 | Smith | Tennessee | 47159 | 6157 | 83 |
2339417 | 2339417 | 2022-03-24 | Stewart | Tennessee | 47161 | 3283 | 56 |
2339418 | 2339418 | 2022-03-24 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2339419 | 2339419 | 2022-03-24 | Sumner | Tennessee | 47165 | 53057 | 713 |
2339420 | 2339420 | 2022-03-24 | Tipton | Tennessee | 47167 | 17588 | 230 |
2339421 | 2339421 | 2022-03-24 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2339422 | 2339422 | 2022-03-24 | Unicoi | Tennessee | 47171 | 5156 | 94 |
2339423 | 2339423 | 2022-03-24 | Union | Tennessee | 47173 | 5393 | 72 |
2339424 | 2339424 | 2022-03-24 | Unknown | Tennessee | 18770 | 275 | |
2339425 | 2339425 | 2022-03-24 | Van Buren | Tennessee | 47175 | 1845 | 47 |
2339426 | 2339426 | 2022-03-24 | Warren | Tennessee | 47177 | 12982 | 175 |
2339427 | 2339427 | 2022-03-24 | Washington | Tennessee | 47179 | 38465 | 486 |
2339428 | 2339428 | 2022-03-24 | Wayne | Tennessee | 47181 | 5687 | 63 |
2339429 | 2339429 | 2022-03-24 | Weakley | Tennessee | 47183 | 9491 | 140 |
2339430 | 2339430 | 2022-03-24 | White | Tennessee | 47185 | 8224 | 127 |
2339431 | 2339431 | 2022-03-24 | Williamson | Tennessee | 47187 | 61839 | 395 |
2339432 | 2339432 | 2022-03-24 | Wilson | Tennessee | 47189 | 41556 | 475 |
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);