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-02-07 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1007348 | 1007348 | 2021-02-07 | Anderson | Tennessee | 47001 | 7377 | 143 |
1007349 | 1007349 | 2021-02-07 | Bedford | Tennessee | 47003 | 5642 | 109 |
1007350 | 1007350 | 2021-02-07 | Benton | Tennessee | 47005 | 1396 | 37 |
1007351 | 1007351 | 2021-02-07 | Bledsoe | Tennessee | 47007 | 1882 | 11 |
1007352 | 1007352 | 2021-02-07 | Blount | Tennessee | 47009 | 12972 | 158 |
1007353 | 1007353 | 2021-02-07 | Bradley | Tennessee | 47011 | 11954 | 128 |
1007354 | 1007354 | 2021-02-07 | Campbell | Tennessee | 47013 | 3555 | 51 |
1007355 | 1007355 | 2021-02-07 | Cannon | Tennessee | 47015 | 1693 | 25 |
1007356 | 1007356 | 2021-02-07 | Carroll | Tennessee | 47017 | 3340 | 78 |
1007357 | 1007357 | 2021-02-07 | Carter | Tennessee | 47019 | 5424 | 139 |
1007358 | 1007358 | 2021-02-07 | Cheatham | Tennessee | 47021 | 3700 | 38 |
1007359 | 1007359 | 2021-02-07 | Chester | Tennessee | 47023 | 1897 | 44 |
1007360 | 1007360 | 2021-02-07 | Claiborne | Tennessee | 47025 | 2493 | 52 |
1007361 | 1007361 | 2021-02-07 | Clay | Tennessee | 47027 | 995 | 29 |
1007362 | 1007362 | 2021-02-07 | Cocke | Tennessee | 47029 | 3770 | 84 |
1007363 | 1007363 | 2021-02-07 | Coffee | Tennessee | 47031 | 6028 | 104 |
1007364 | 1007364 | 2021-02-07 | Crockett | Tennessee | 47033 | 1885 | 43 |
1007365 | 1007365 | 2021-02-07 | Cumberland | Tennessee | 47035 | 5744 | 103 |
1007366 | 1007366 | 2021-02-07 | Davidson | Tennessee | 47037 | 85718 | 790 |
1007367 | 1007367 | 2021-02-07 | DeKalb | Tennessee | 47041 | 2578 | 48 |
1007368 | 1007368 | 2021-02-07 | Decatur | Tennessee | 47039 | 1517 | 32 |
1007369 | 1007369 | 2021-02-07 | Dickson | Tennessee | 47043 | 5892 | 98 |
1007370 | 1007370 | 2021-02-07 | Dyer | Tennessee | 47045 | 5059 | 92 |
1007371 | 1007371 | 2021-02-07 | Fayette | Tennessee | 47047 | 4345 | 65 |
1007372 | 1007372 | 2021-02-07 | Fentress | Tennessee | 47049 | 2224 | 41 |
1007373 | 1007373 | 2021-02-07 | Franklin | Tennessee | 47051 | 4470 | 76 |
1007374 | 1007374 | 2021-02-07 | Gibson | Tennessee | 47053 | 5980 | 129 |
1007375 | 1007375 | 2021-02-07 | Giles | Tennessee | 47055 | 3477 | 89 |
1007376 | 1007376 | 2021-02-07 | Grainger | Tennessee | 47057 | 2284 | 45 |
1007377 | 1007377 | 2021-02-07 | Greene | Tennessee | 47059 | 7013 | 134 |
1007378 | 1007378 | 2021-02-07 | Grundy | Tennessee | 47061 | 1531 | 26 |
1007379 | 1007379 | 2021-02-07 | Hamblen | Tennessee | 47063 | 7626 | 151 |
1007380 | 1007380 | 2021-02-07 | Hamilton | Tennessee | 47065 | 38822 | 410 |
1007381 | 1007381 | 2021-02-07 | Hancock | Tennessee | 47067 | 452 | 9 |
1007382 | 1007382 | 2021-02-07 | Hardeman | Tennessee | 47069 | 3259 | 62 |
1007383 | 1007383 | 2021-02-07 | Hardin | Tennessee | 47071 | 3138 | 58 |
1007384 | 1007384 | 2021-02-07 | Hawkins | Tennessee | 47073 | 4936 | 88 |
1007385 | 1007385 | 2021-02-07 | Haywood | Tennessee | 47075 | 2543 | 58 |
1007386 | 1007386 | 2021-02-07 | Henderson | Tennessee | 47077 | 3496 | 70 |
1007387 | 1007387 | 2021-02-07 | Henry | Tennessee | 47079 | 2808 | 70 |
1007388 | 1007388 | 2021-02-07 | Hickman | Tennessee | 47081 | 2393 | 39 |
1007389 | 1007389 | 2021-02-07 | Houston | Tennessee | 47083 | 973 | 27 |
1007390 | 1007390 | 2021-02-07 | Humphreys | Tennessee | 47085 | 1457 | 20 |
1007391 | 1007391 | 2021-02-07 | Jackson | Tennessee | 47087 | 1110 | 27 |
1007392 | 1007392 | 2021-02-07 | Jefferson | Tennessee | 47089 | 5246 | 95 |
1007393 | 1007393 | 2021-02-07 | Johnson | Tennessee | 47091 | 2130 | 37 |
1007394 | 1007394 | 2021-02-07 | Knox | Tennessee | 47093 | 44043 | 523 |
1007395 | 1007395 | 2021-02-07 | Lake | Tennessee | 47095 | 1658 | 24 |
1007396 | 1007396 | 2021-02-07 | Lauderdale | Tennessee | 47097 | 3083 | 41 |
1007397 | 1007397 | 2021-02-07 | Lawrence | Tennessee | 47099 | 5467 | 78 |
1007398 | 1007398 | 2021-02-07 | Lewis | Tennessee | 47101 | 1387 | 23 |
1007399 | 1007399 | 2021-02-07 | Lincoln | Tennessee | 47103 | 4019 | 55 |
1007400 | 1007400 | 2021-02-07 | Loudon | Tennessee | 47105 | 5444 | 62 |
1007401 | 1007401 | 2021-02-07 | Macon | Tennessee | 47111 | 3046 | 66 |
1007402 | 1007402 | 2021-02-07 | Madison | Tennessee | 47113 | 9754 | 206 |
1007403 | 1007403 | 2021-02-07 | Marion | Tennessee | 47115 | 2474 | 38 |
1007404 | 1007404 | 2021-02-07 | Marshall | Tennessee | 47117 | 3779 | 50 |
1007405 | 1007405 | 2021-02-07 | Maury | Tennessee | 47119 | 11927 | 152 |
1007406 | 1007406 | 2021-02-07 | McMinn | Tennessee | 47107 | 5515 | 84 |
1007407 | 1007407 | 2021-02-07 | McNairy | Tennessee | 47109 | 2606 | 46 |
1007408 | 1007408 | 2021-02-07 | Meigs | Tennessee | 47121 | 1245 | 19 |
1007409 | 1007409 | 2021-02-07 | Monroe | Tennessee | 47123 | 4991 | 80 |
1007410 | 1007410 | 2021-02-07 | Montgomery | Tennessee | 47125 | 16294 | 184 |
1007411 | 1007411 | 2021-02-07 | Moore | Tennessee | 47127 | 863 | 13 |
1007412 | 1007412 | 2021-02-07 | Morgan | Tennessee | 47129 | 2058 | 23 |
1007413 | 1007413 | 2021-02-07 | Obion | Tennessee | 47131 | 4172 | 90 |
1007414 | 1007414 | 2021-02-07 | Overton | Tennessee | 47133 | 2671 | 53 |
1007415 | 1007415 | 2021-02-07 | Perry | Tennessee | 47135 | 991 | 25 |
1007416 | 1007416 | 2021-02-07 | Pickett | Tennessee | 47137 | 713 | 21 |
1007417 | 1007417 | 2021-02-07 | Polk | Tennessee | 47139 | 1617 | 21 |
1007418 | 1007418 | 2021-02-07 | Putnam | Tennessee | 47141 | 10608 | 165 |
1007419 | 1007419 | 2021-02-07 | Rhea | Tennessee | 47143 | 4069 | 65 |
1007420 | 1007420 | 2021-02-07 | Roane | Tennessee | 47145 | 5593 | 97 |
1007421 | 1007421 | 2021-02-07 | Robertson | Tennessee | 47147 | 8327 | 106 |
1007422 | 1007422 | 2021-02-07 | Rutherford | Tennessee | 47149 | 35950 | 337 |
1007423 | 1007423 | 2021-02-07 | Scott | Tennessee | 47151 | 2416 | 39 |
1007424 | 1007424 | 2021-02-07 | Sequatchie | Tennessee | 47153 | 1505 | 24 |
1007425 | 1007425 | 2021-02-07 | Sevier | Tennessee | 47155 | 11372 | 146 |
1007426 | 1007426 | 2021-02-07 | Shelby | Tennessee | 47157 | 84798 | 1378 |
1007427 | 1007427 | 2021-02-07 | Smith | Tennessee | 47159 | 2431 | 33 |
1007428 | 1007428 | 2021-02-07 | Stewart | Tennessee | 47161 | 1178 | 25 |
1007429 | 1007429 | 2021-02-07 | Sullivan | Tennessee | 47163 | 13550 | 254 |
1007430 | 1007430 | 2021-02-07 | Sumner | Tennessee | 47165 | 19803 | 285 |
1007431 | 1007431 | 2021-02-07 | Tipton | Tennessee | 47167 | 6647 | 91 |
1007432 | 1007432 | 2021-02-07 | Trousdale | Tennessee | 47169 | 2347 | 19 |
1007433 | 1007433 | 2021-02-07 | Unicoi | Tennessee | 47171 | 1733 | 48 |
1007434 | 1007434 | 2021-02-07 | Union | Tennessee | 47173 | 1538 | 26 |
1007435 | 1007435 | 2021-02-07 | Unknown | Tennessee | 13932 | 177 | |
1007436 | 1007436 | 2021-02-07 | Van Buren | Tennessee | 47175 | 691 | 15 |
1007437 | 1007437 | 2021-02-07 | Warren | Tennessee | 47177 | 5264 | 66 |
1007438 | 1007438 | 2021-02-07 | Washington | Tennessee | 47179 | 12583 | 222 |
1007439 | 1007439 | 2021-02-07 | Wayne | Tennessee | 47181 | 2779 | 26 |
1007440 | 1007440 | 2021-02-07 | Weakley | Tennessee | 47183 | 3589 | 53 |
1007441 | 1007441 | 2021-02-07 | White | Tennessee | 47185 | 3276 | 59 |
1007442 | 1007442 | 2021-02-07 | Williamson | Tennessee | 47187 | 23767 | 184 |
1007443 | 1007443 | 2021-02-07 | Wilson | Tennessee | 47189 | 15602 | 191 |
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);