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-29 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1965382 | 1965382 | 2021-11-29 | Anderson | Tennessee | 47001 | 13489 | 235 |
1965383 | 1965383 | 2021-11-29 | Bedford | Tennessee | 47003 | 9513 | 159 |
1965384 | 1965384 | 2021-11-29 | Benton | Tennessee | 47005 | 2962 | 56 |
1965385 | 1965385 | 2021-11-29 | Bledsoe | Tennessee | 47007 | 3556 | 22 |
1965386 | 1965386 | 2021-11-29 | Blount | Tennessee | 47009 | 24470 | 274 |
1965387 | 1965387 | 2021-11-29 | Bradley | Tennessee | 47011 | 22607 | 218 |
1965388 | 1965388 | 2021-11-29 | Campbell | Tennessee | 47013 | 7523 | 88 |
1965389 | 1965389 | 2021-11-29 | Cannon | Tennessee | 47015 | 2853 | 44 |
1965390 | 1965390 | 2021-11-29 | Carroll | Tennessee | 47017 | 5876 | 111 |
1965391 | 1965391 | 2021-11-29 | Carter | Tennessee | 47019 | 10912 | 227 |
1965392 | 1965392 | 2021-11-29 | Cheatham | Tennessee | 47021 | 7173 | 77 |
1965393 | 1965393 | 2021-11-29 | Chester | Tennessee | 47023 | 3589 | 76 |
1965394 | 1965394 | 2021-11-29 | Claiborne | Tennessee | 47025 | 5847 | 115 |
1965395 | 1965395 | 2021-11-29 | Clay | Tennessee | 47027 | 1550 | 37 |
1965396 | 1965396 | 2021-11-29 | Cocke | Tennessee | 47029 | 7587 | 110 |
1965397 | 1965397 | 2021-11-29 | Coffee | Tennessee | 47031 | 10860 | 165 |
1965398 | 1965398 | 2021-11-29 | Crockett | Tennessee | 47033 | 3402 | 63 |
1965399 | 1965399 | 2021-11-29 | Cumberland | Tennessee | 47035 | 11515 | 230 |
1965400 | 1965400 | 2021-11-29 | Davidson | Tennessee | 47037 | 135626 | 1198 |
1965401 | 1965401 | 2021-11-29 | DeKalb | Tennessee | 47041 | 4297 | 76 |
1965402 | 1965402 | 2021-11-29 | Decatur | Tennessee | 47039 | 2478 | 44 |
1965403 | 1965403 | 2021-11-29 | Dickson | Tennessee | 47043 | 10741 | 170 |
1965404 | 1965404 | 2021-11-29 | Dyer | Tennessee | 47045 | 8172 | 150 |
1965405 | 1965405 | 2021-11-29 | Fayette | Tennessee | 47047 | 7455 | 109 |
1965406 | 1965406 | 2021-11-29 | Fentress | Tennessee | 47049 | 3779 | 69 |
1965407 | 1965407 | 2021-11-29 | Franklin | Tennessee | 47051 | 8171 | 104 |
1965408 | 1965408 | 2021-11-29 | Gibson | Tennessee | 47053 | 10801 | 191 |
1965409 | 1965409 | 2021-11-29 | Giles | Tennessee | 47055 | 6177 | 127 |
1965410 | 1965410 | 2021-11-29 | Grainger | Tennessee | 47057 | 4511 | 68 |
1965411 | 1965411 | 2021-11-29 | Greene | Tennessee | 47059 | 14258 | 247 |
1965412 | 1965412 | 2021-11-29 | Grundy | Tennessee | 47061 | 2929 | 42 |
1965413 | 1965413 | 2021-11-29 | Hamblen | Tennessee | 47063 | 13319 | 207 |
1965414 | 1965414 | 2021-11-29 | Hamilton | Tennessee | 47065 | 65405 | 679 |
1965415 | 1965415 | 2021-11-29 | Hancock | Tennessee | 47067 | 1256 | 21 |
1965416 | 1965416 | 2021-11-29 | Hardeman | Tennessee | 47069 | 5172 | 87 |
1965417 | 1965417 | 2021-11-29 | Hardin | Tennessee | 47071 | 5684 | 89 |
1965418 | 1965418 | 2021-11-29 | Hawkins | Tennessee | 47073 | 10751 | 180 |
1965419 | 1965419 | 2021-11-29 | Haywood | Tennessee | 47075 | 3915 | 77 |
1965420 | 1965420 | 2021-11-29 | Henderson | Tennessee | 47077 | 5895 | 106 |
1965421 | 1965421 | 2021-11-29 | Henry | Tennessee | 47079 | 5570 | 93 |
1965422 | 1965422 | 2021-11-29 | Hickman | Tennessee | 47081 | 4754 | 78 |
1965423 | 1965423 | 2021-11-29 | Houston | Tennessee | 47083 | 1884 | 45 |
1965424 | 1965424 | 2021-11-29 | Humphreys | Tennessee | 47085 | 3344 | 48 |
1965425 | 1965425 | 2021-11-29 | Jackson | Tennessee | 47087 | 2111 | 40 |
1965426 | 1965426 | 2021-11-29 | Jefferson | Tennessee | 47089 | 10166 | 152 |
1965427 | 1965427 | 2021-11-29 | Johnson | Tennessee | 47091 | 3928 | 52 |
1965428 | 1965428 | 2021-11-29 | Knox | Tennessee | 47093 | 80776 | 949 |
1965429 | 1965429 | 2021-11-29 | Lake | Tennessee | 47095 | 2024 | 31 |
1965430 | 1965430 | 2021-11-29 | Lauderdale | Tennessee | 47097 | 5263 | 70 |
1965431 | 1965431 | 2021-11-29 | Lawrence | Tennessee | 47099 | 9754 | 127 |
1965432 | 1965432 | 2021-11-29 | Lewis | Tennessee | 47101 | 2567 | 41 |
1965433 | 1965433 | 2021-11-29 | Lincoln | Tennessee | 47103 | 6836 | 92 |
1965434 | 1965434 | 2021-11-29 | Loudon | Tennessee | 47105 | 9429 | 102 |
1965435 | 1965435 | 2021-11-29 | Macon | Tennessee | 47111 | 5558 | 94 |
1965436 | 1965436 | 2021-11-29 | Madison | Tennessee | 47113 | 18074 | 324 |
1965437 | 1965437 | 2021-11-29 | Marion | Tennessee | 47115 | 5895 | 58 |
1965438 | 1965438 | 2021-11-29 | Marshall | Tennessee | 47117 | 6987 | 90 |
1965439 | 1965439 | 2021-11-29 | Maury | Tennessee | 47119 | 19816 | 238 |
1965440 | 1965440 | 2021-11-29 | McMinn | Tennessee | 47107 | 10741 | 137 |
1965441 | 1965441 | 2021-11-29 | McNairy | Tennessee | 47109 | 4798 | 73 |
1965442 | 1965442 | 2021-11-29 | Meigs | Tennessee | 47121 | 2232 | 31 |
1965443 | 1965443 | 2021-11-29 | Monroe | Tennessee | 47123 | 9942 | 129 |
1965444 | 1965444 | 2021-11-29 | Montgomery | Tennessee | 47125 | 33589 | 351 |
1965445 | 1965445 | 2021-11-29 | Moore | Tennessee | 47127 | 1463 | 24 |
1965446 | 1965446 | 2021-11-29 | Morgan | Tennessee | 47129 | 3926 | 50 |
1965447 | 1965447 | 2021-11-29 | Obion | Tennessee | 47131 | 6850 | 111 |
1965448 | 1965448 | 2021-11-29 | Overton | Tennessee | 47133 | 4908 | 83 |
1965449 | 1965449 | 2021-11-29 | Perry | Tennessee | 47135 | 1641 | 34 |
1965450 | 1965450 | 2021-11-29 | Pickett | Tennessee | 47137 | 1122 | 26 |
1965451 | 1965451 | 2021-11-29 | Polk | Tennessee | 47139 | 3247 | 33 |
1965452 | 1965452 | 2021-11-29 | Putnam | Tennessee | 47141 | 17054 | 225 |
1965453 | 1965453 | 2021-11-29 | Rhea | Tennessee | 47143 | 7098 | 99 |
1965454 | 1965454 | 2021-11-29 | Roane | Tennessee | 47145 | 10339 | 160 |
1965455 | 1965455 | 2021-11-29 | Robertson | Tennessee | 47147 | 14359 | 197 |
1965456 | 1965456 | 2021-11-29 | Rutherford | Tennessee | 47149 | 63782 | 580 |
1965457 | 1965457 | 2021-11-29 | Scott | Tennessee | 47151 | 5691 | 66 |
1965458 | 1965458 | 2021-11-29 | Sequatchie | Tennessee | 47153 | 3070 | 35 |
1965459 | 1965459 | 2021-11-29 | Sevier | Tennessee | 47155 | 20616 | 283 |
1965460 | 1965460 | 2021-11-29 | Shelby | Tennessee | 47157 | 148806 | 2327 |
1965461 | 1965461 | 2021-11-29 | Smith | Tennessee | 47159 | 4250 | 53 |
1965462 | 1965462 | 2021-11-29 | Stewart | Tennessee | 47161 | 2187 | 35 |
1965463 | 1965463 | 2021-11-29 | Sullivan | Tennessee | 47163 | 28290 | 449 |
1965464 | 1965464 | 2021-11-29 | Sumner | Tennessee | 47165 | 35193 | 431 |
1965465 | 1965465 | 2021-11-29 | Tipton | Tennessee | 47167 | 11679 | 141 |
1965466 | 1965466 | 2021-11-29 | Trousdale | Tennessee | 47169 | 3237 | 27 |
1965467 | 1965467 | 2021-11-29 | Unicoi | Tennessee | 47171 | 3239 | 65 |
1965468 | 1965468 | 2021-11-29 | Union | Tennessee | 47173 | 3405 | 50 |
1965469 | 1965469 | 2021-11-29 | Unknown | Tennessee | 9061 | 129 | |
1965470 | 1965470 | 2021-11-29 | Van Buren | Tennessee | 47175 | 1284 | 29 |
1965471 | 1965471 | 2021-11-29 | Warren | Tennessee | 47177 | 8815 | 130 |
1965472 | 1965472 | 2021-11-29 | Washington | Tennessee | 47179 | 22938 | 340 |
1965473 | 1965473 | 2021-11-29 | Wayne | Tennessee | 47181 | 4160 | 41 |
1965474 | 1965474 | 2021-11-29 | Weakley | Tennessee | 47183 | 6382 | 89 |
1965475 | 1965475 | 2021-11-29 | White | Tennessee | 47185 | 5751 | 98 |
1965476 | 1965476 | 2021-11-29 | Williamson | Tennessee | 47187 | 40909 | 277 |
1965477 | 1965477 | 2021-11-29 | Wilson | Tennessee | 47189 | 27757 | 350 |
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);