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-11-01 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1874379 | 1874379 | 2021-11-01 | Anderson | Tennessee | 47001 | 13000 | 218 |
1874380 | 1874380 | 2021-11-01 | Bedford | Tennessee | 47003 | 9195 | 155 |
1874381 | 1874381 | 2021-11-01 | Benton | Tennessee | 47005 | 2800 | 53 |
1874382 | 1874382 | 2021-11-01 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1874383 | 1874383 | 2021-11-01 | Blount | Tennessee | 47009 | 23759 | 269 |
1874384 | 1874384 | 2021-11-01 | Bradley | Tennessee | 47011 | 22157 | 197 |
1874385 | 1874385 | 2021-11-01 | Campbell | Tennessee | 47013 | 7268 | 80 |
1874386 | 1874386 | 2021-11-01 | Cannon | Tennessee | 47015 | 2800 | 43 |
1874387 | 1874387 | 2021-11-01 | Carroll | Tennessee | 47017 | 5761 | 103 |
1874388 | 1874388 | 2021-11-01 | Carter | Tennessee | 47019 | 10541 | 215 |
1874389 | 1874389 | 2021-11-01 | Cheatham | Tennessee | 47021 | 7015 | 70 |
1874390 | 1874390 | 2021-11-01 | Chester | Tennessee | 47023 | 3523 | 75 |
1874391 | 1874391 | 2021-11-01 | Claiborne | Tennessee | 47025 | 5452 | 112 |
1874392 | 1874392 | 2021-11-01 | Clay | Tennessee | 47027 | 1530 | 37 |
1874393 | 1874393 | 2021-11-01 | Cocke | Tennessee | 47029 | 7415 | 107 |
1874394 | 1874394 | 2021-11-01 | Coffee | Tennessee | 47031 | 10551 | 159 |
1874395 | 1874395 | 2021-11-01 | Crockett | Tennessee | 47033 | 3357 | 62 |
1874396 | 1874396 | 2021-11-01 | Cumberland | Tennessee | 47035 | 11095 | 224 |
1874397 | 1874397 | 2021-11-01 | Davidson | Tennessee | 47037 | 132939 | 1164 |
1874398 | 1874398 | 2021-11-01 | DeKalb | Tennessee | 47041 | 4211 | 72 |
1874399 | 1874399 | 2021-11-01 | Decatur | Tennessee | 47039 | 2433 | 44 |
1874400 | 1874400 | 2021-11-01 | Dickson | Tennessee | 47043 | 10435 | 165 |
1874401 | 1874401 | 2021-11-01 | Dyer | Tennessee | 47045 | 8083 | 145 |
1874402 | 1874402 | 2021-11-01 | Fayette | Tennessee | 47047 | 7308 | 106 |
1874403 | 1874403 | 2021-11-01 | Fentress | Tennessee | 47049 | 3667 | 67 |
1874404 | 1874404 | 2021-11-01 | Franklin | Tennessee | 47051 | 7963 | 102 |
1874405 | 1874405 | 2021-11-01 | Gibson | Tennessee | 47053 | 10658 | 189 |
1874406 | 1874406 | 2021-11-01 | Giles | Tennessee | 47055 | 6080 | 123 |
1874407 | 1874407 | 2021-11-01 | Grainger | Tennessee | 47057 | 4356 | 67 |
1874408 | 1874408 | 2021-11-01 | Greene | Tennessee | 47059 | 13685 | 242 |
1874409 | 1874409 | 2021-11-01 | Grundy | Tennessee | 47061 | 2847 | 38 |
1874410 | 1874410 | 2021-11-01 | Hamblen | Tennessee | 47063 | 13023 | 202 |
1874411 | 1874411 | 2021-11-01 | Hamilton | Tennessee | 47065 | 64136 | 652 |
1874412 | 1874412 | 2021-11-01 | Hancock | Tennessee | 47067 | 1214 | 20 |
1874413 | 1874413 | 2021-11-01 | Hardeman | Tennessee | 47069 | 5112 | 81 |
1874414 | 1874414 | 2021-11-01 | Hardin | Tennessee | 47071 | 5542 | 81 |
1874415 | 1874415 | 2021-11-01 | Hawkins | Tennessee | 47073 | 10247 | 167 |
1874416 | 1874416 | 2021-11-01 | Haywood | Tennessee | 47075 | 3810 | 76 |
1874417 | 1874417 | 2021-11-01 | Henderson | Tennessee | 47077 | 5756 | 102 |
1874418 | 1874418 | 2021-11-01 | Henry | Tennessee | 47079 | 5472 | 86 |
1874419 | 1874419 | 2021-11-01 | Hickman | Tennessee | 47081 | 4612 | 75 |
1874420 | 1874420 | 2021-11-01 | Houston | Tennessee | 47083 | 1839 | 44 |
1874421 | 1874421 | 2021-11-01 | Humphreys | Tennessee | 47085 | 3240 | 47 |
1874422 | 1874422 | 2021-11-01 | Jackson | Tennessee | 47087 | 2081 | 40 |
1874423 | 1874423 | 2021-11-01 | Jefferson | Tennessee | 47089 | 9952 | 145 |
1874424 | 1874424 | 2021-11-01 | Johnson | Tennessee | 47091 | 3577 | 48 |
1874425 | 1874425 | 2021-11-01 | Knox | Tennessee | 47093 | 78694 | 926 |
1874426 | 1874426 | 2021-11-01 | Lake | Tennessee | 47095 | 2020 | 31 |
1874427 | 1874427 | 2021-11-01 | Lauderdale | Tennessee | 47097 | 5206 | 66 |
1874428 | 1874428 | 2021-11-01 | Lawrence | Tennessee | 47099 | 9557 | 124 |
1874429 | 1874429 | 2021-11-01 | Lewis | Tennessee | 47101 | 2525 | 38 |
1874430 | 1874430 | 2021-11-01 | Lincoln | Tennessee | 47103 | 6692 | 84 |
1874431 | 1874431 | 2021-11-01 | Loudon | Tennessee | 47105 | 9154 | 97 |
1874432 | 1874432 | 2021-11-01 | Macon | Tennessee | 47111 | 5466 | 93 |
1874433 | 1874433 | 2021-11-01 | Madison | Tennessee | 47113 | 17643 | 314 |
1874434 | 1874434 | 2021-11-01 | Marion | Tennessee | 47115 | 5783 | 54 |
1874435 | 1874435 | 2021-11-01 | Marshall | Tennessee | 47117 | 6868 | 88 |
1874436 | 1874436 | 2021-11-01 | Maury | Tennessee | 47119 | 19386 | 230 |
1874437 | 1874437 | 2021-11-01 | McMinn | Tennessee | 47107 | 10529 | 132 |
1874438 | 1874438 | 2021-11-01 | McNairy | Tennessee | 47109 | 4631 | 70 |
1874439 | 1874439 | 2021-11-01 | Meigs | Tennessee | 47121 | 2181 | 28 |
1874440 | 1874440 | 2021-11-01 | Monroe | Tennessee | 47123 | 9715 | 124 |
1874441 | 1874441 | 2021-11-01 | Montgomery | Tennessee | 47125 | 32904 | 338 |
1874442 | 1874442 | 2021-11-01 | Moore | Tennessee | 47127 | 1435 | 22 |
1874443 | 1874443 | 2021-11-01 | Morgan | Tennessee | 47129 | 3815 | 49 |
1874444 | 1874444 | 2021-11-01 | Obion | Tennessee | 47131 | 6625 | 110 |
1874445 | 1874445 | 2021-11-01 | Overton | Tennessee | 47133 | 4791 | 82 |
1874446 | 1874446 | 2021-11-01 | Perry | Tennessee | 47135 | 1616 | 34 |
1874447 | 1874447 | 2021-11-01 | Pickett | Tennessee | 47137 | 1087 | 24 |
1874448 | 1874448 | 2021-11-01 | Polk | Tennessee | 47139 | 3187 | 31 |
1874449 | 1874449 | 2021-11-01 | Putnam | Tennessee | 47141 | 16738 | 218 |
1874450 | 1874450 | 2021-11-01 | Rhea | Tennessee | 47143 | 6988 | 93 |
1874451 | 1874451 | 2021-11-01 | Roane | Tennessee | 47145 | 10026 | 153 |
1874452 | 1874452 | 2021-11-01 | Robertson | Tennessee | 47147 | 14084 | 189 |
1874453 | 1874453 | 2021-11-01 | Rutherford | Tennessee | 47149 | 61914 | 551 |
1874454 | 1874454 | 2021-11-01 | Scott | Tennessee | 47151 | 5293 | 60 |
1874455 | 1874455 | 2021-11-01 | Sequatchie | Tennessee | 47153 | 2997 | 33 |
1874456 | 1874456 | 2021-11-01 | Sevier | Tennessee | 47155 | 20106 | 271 |
1874457 | 1874457 | 2021-11-01 | Shelby | Tennessee | 47157 | 146061 | 2256 |
1874458 | 1874458 | 2021-11-01 | Smith | Tennessee | 47159 | 4175 | 52 |
1874459 | 1874459 | 2021-11-01 | Stewart | Tennessee | 47161 | 2147 | 35 |
1874460 | 1874460 | 2021-11-01 | Sullivan | Tennessee | 47163 | 26816 | 427 |
1874461 | 1874461 | 2021-11-01 | Sumner | Tennessee | 47165 | 34283 | 409 |
1874462 | 1874462 | 2021-11-01 | Tipton | Tennessee | 47167 | 11350 | 130 |
1874463 | 1874463 | 2021-11-01 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1874464 | 1874464 | 2021-11-01 | Unicoi | Tennessee | 47171 | 3147 | 65 |
1874465 | 1874465 | 2021-11-01 | Union | Tennessee | 47173 | 3146 | 46 |
1874466 | 1874466 | 2021-11-01 | Unknown | Tennessee | 7884 | 120 | |
1874467 | 1874467 | 2021-11-01 | Van Buren | Tennessee | 47175 | 1247 | 27 |
1874468 | 1874468 | 2021-11-01 | Warren | Tennessee | 47177 | 8618 | 121 |
1874469 | 1874469 | 2021-11-01 | Washington | Tennessee | 47179 | 21666 | 327 |
1874470 | 1874470 | 2021-11-01 | Wayne | Tennessee | 47181 | 4052 | 39 |
1874471 | 1874471 | 2021-11-01 | Weakley | Tennessee | 47183 | 6247 | 89 |
1874472 | 1874472 | 2021-11-01 | White | Tennessee | 47185 | 5633 | 97 |
1874473 | 1874473 | 2021-11-01 | Williamson | Tennessee | 47187 | 39707 | 269 |
1874474 | 1874474 | 2021-11-01 | Wilson | Tennessee | 47189 | 27123 | 337 |
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);