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 2022-03-28 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2352348 | 2352348 | 2022-03-28 | Anderson | Tennessee | 47001 | 22047 | 321 |
2352349 | 2352349 | 2022-03-28 | Bedford | Tennessee | 47003 | 14933 | 230 |
2352350 | 2352350 | 2022-03-28 | Benton | Tennessee | 47005 | 4471 | 90 |
2352351 | 2352351 | 2022-03-28 | Bledsoe | Tennessee | 47007 | 4652 | 56 |
2352352 | 2352352 | 2022-03-28 | Blount | Tennessee | 47009 | 39027 | 418 |
2352353 | 2352353 | 2022-03-28 | Bradley | Tennessee | 47011 | 33065 | 402 |
2352354 | 2352354 | 2022-03-28 | Campbell | Tennessee | 47013 | 12204 | 160 |
2352355 | 2352355 | 2022-03-28 | Cannon | Tennessee | 47015 | 4187 | 58 |
2352356 | 2352356 | 2022-03-28 | Carroll | Tennessee | 47017 | 8940 | 155 |
2352357 | 2352357 | 2022-03-28 | Carter | Tennessee | 47019 | 16432 | 328 |
2352358 | 2352358 | 2022-03-28 | Cheatham | Tennessee | 47021 | 10896 | 119 |
2352359 | 2352359 | 2022-03-28 | Chester | Tennessee | 47023 | 5823 | 96 |
2352360 | 2352360 | 2022-03-28 | Claiborne | Tennessee | 47025 | 9084 | 176 |
2352361 | 2352361 | 2022-03-28 | Clay | Tennessee | 47027 | 2224 | 49 |
2352362 | 2352362 | 2022-03-28 | Cocke | Tennessee | 47029 | 11553 | 209 |
2352363 | 2352363 | 2022-03-28 | Coffee | Tennessee | 47031 | 16925 | 261 |
2352364 | 2352364 | 2022-03-28 | Crockett | Tennessee | 47033 | 5171 | 84 |
2352365 | 2352365 | 2022-03-28 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2352366 | 2352366 | 2022-03-28 | Davidson | Tennessee | 47037 | 206980 | 1631 |
2352367 | 2352367 | 2022-03-28 | DeKalb | Tennessee | 47041 | 6276 | 100 |
2352368 | 2352368 | 2022-03-28 | Decatur | Tennessee | 47039 | 3726 | 67 |
2352369 | 2352369 | 2022-03-28 | Dickson | Tennessee | 47043 | 15853 | 240 |
2352370 | 2352370 | 2022-03-28 | Dyer | Tennessee | 47045 | 12764 | 199 |
2352371 | 2352371 | 2022-03-28 | Fayette | Tennessee | 47047 | 11395 | 180 |
2352372 | 2352372 | 2022-03-28 | Fentress | Tennessee | 47049 | 5691 | 125 |
2352373 | 2352373 | 2022-03-28 | Franklin | Tennessee | 47051 | 12829 | 176 |
2352374 | 2352374 | 2022-03-28 | Gibson | Tennessee | 47053 | 17366 | 254 |
2352375 | 2352375 | 2022-03-28 | Giles | Tennessee | 47055 | 9397 | 186 |
2352376 | 2352376 | 2022-03-28 | Grainger | Tennessee | 47057 | 6765 | 107 |
2352377 | 2352377 | 2022-03-28 | Greene | Tennessee | 47059 | 22029 | 363 |
2352378 | 2352378 | 2022-03-28 | Grundy | Tennessee | 47061 | 3980 | 71 |
2352379 | 2352379 | 2022-03-28 | Hamblen | Tennessee | 47063 | 19679 | 347 |
2352380 | 2352380 | 2022-03-28 | Hamilton | Tennessee | 47065 | 99558 | 1116 |
2352381 | 2352381 | 2022-03-28 | Hancock | Tennessee | 47067 | 2002 | 34 |
2352382 | 2352382 | 2022-03-28 | Hardeman | Tennessee | 47069 | 7582 | 116 |
2352383 | 2352383 | 2022-03-28 | Hardin | Tennessee | 47071 | 8732 | 141 |
2352384 | 2352384 | 2022-03-28 | Hawkins | Tennessee | 47073 | 16606 | 303 |
2352385 | 2352385 | 2022-03-28 | Haywood | Tennessee | 47075 | 6150 | 99 |
2352386 | 2352386 | 2022-03-28 | Henderson | Tennessee | 47077 | 9094 | 154 |
2352387 | 2352387 | 2022-03-28 | Henry | Tennessee | 47079 | 8244 | 154 |
2352388 | 2352388 | 2022-03-28 | Hickman | Tennessee | 47081 | 6815 | 108 |
2352389 | 2352389 | 2022-03-28 | Houston | Tennessee | 47083 | 2673 | 60 |
2352390 | 2352390 | 2022-03-28 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2352391 | 2352391 | 2022-03-28 | Jackson | Tennessee | 47087 | 3202 | 62 |
2352392 | 2352392 | 2022-03-28 | Jefferson | Tennessee | 47089 | 15692 | 259 |
2352393 | 2352393 | 2022-03-28 | Johnson | Tennessee | 47091 | 5139 | 88 |
2352394 | 2352394 | 2022-03-28 | Knox | Tennessee | 47093 | 127542 | 1335 |
2352395 | 2352395 | 2022-03-28 | Lake | Tennessee | 47095 | 2737 | 40 |
2352396 | 2352396 | 2022-03-28 | Lauderdale | Tennessee | 47097 | 7733 | 103 |
2352397 | 2352397 | 2022-03-28 | Lawrence | Tennessee | 47099 | 14258 | 191 |
2352398 | 2352398 | 2022-03-28 | Lewis | Tennessee | 47101 | 3568 | 57 |
2352399 | 2352399 | 2022-03-28 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2352400 | 2352400 | 2022-03-28 | Loudon | Tennessee | 47105 | 14424 | 188 |
2352401 | 2352401 | 2022-03-28 | Macon | Tennessee | 47111 | 8422 | 145 |
2352402 | 2352402 | 2022-03-28 | Madison | Tennessee | 47113 | 29784 | 418 |
2352403 | 2352403 | 2022-03-28 | Marion | Tennessee | 47115 | 8833 | 127 |
2352404 | 2352404 | 2022-03-28 | Marshall | Tennessee | 47117 | 10351 | 119 |
2352405 | 2352405 | 2022-03-28 | Maury | Tennessee | 47119 | 28867 | 330 |
2352406 | 2352406 | 2022-03-28 | McMinn | Tennessee | 47107 | 16652 | 251 |
2352407 | 2352407 | 2022-03-28 | McNairy | Tennessee | 47109 | 7629 | 118 |
2352408 | 2352408 | 2022-03-28 | Meigs | Tennessee | 47121 | 3351 | 55 |
2352409 | 2352409 | 2022-03-28 | Monroe | Tennessee | 47123 | 14482 | 235 |
2352410 | 2352410 | 2022-03-28 | Montgomery | Tennessee | 47125 | 50080 | 561 |
2352411 | 2352411 | 2022-03-28 | Moore | Tennessee | 47127 | 2237 | 40 |
2352412 | 2352412 | 2022-03-28 | Morgan | Tennessee | 47129 | 6158 | 80 |
2352413 | 2352413 | 2022-03-28 | Obion | Tennessee | 47131 | 10753 | 187 |
2352414 | 2352414 | 2022-03-28 | Overton | Tennessee | 47133 | 7147 | 121 |
2352415 | 2352415 | 2022-03-28 | Perry | Tennessee | 47135 | 2328 | 55 |
2352416 | 2352416 | 2022-03-28 | Pickett | Tennessee | 47137 | 1764 | 36 |
2352417 | 2352417 | 2022-03-28 | Polk | Tennessee | 47139 | 4722 | 70 |
2352418 | 2352418 | 2022-03-28 | Putnam | Tennessee | 47141 | 25068 | 302 |
2352419 | 2352419 | 2022-03-28 | Rhea | Tennessee | 47143 | 9959 | 154 |
2352420 | 2352420 | 2022-03-28 | Roane | Tennessee | 47145 | 15764 | 231 |
2352421 | 2352421 | 2022-03-28 | Robertson | Tennessee | 47147 | 21503 | 295 |
2352422 | 2352422 | 2022-03-28 | Rutherford | Tennessee | 47149 | 95505 | 879 |
2352423 | 2352423 | 2022-03-28 | Scott | Tennessee | 47151 | 9029 | 115 |
2352424 | 2352424 | 2022-03-28 | Sequatchie | Tennessee | 47153 | 4204 | 66 |
2352425 | 2352425 | 2022-03-28 | Sevier | Tennessee | 47155 | 30246 | 401 |
2352426 | 2352426 | 2022-03-28 | Shelby | Tennessee | 47157 | 237562 | 3232 |
2352427 | 2352427 | 2022-03-28 | Smith | Tennessee | 47159 | 6157 | 83 |
2352428 | 2352428 | 2022-03-28 | Stewart | Tennessee | 47161 | 3283 | 56 |
2352429 | 2352429 | 2022-03-28 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2352430 | 2352430 | 2022-03-28 | Sumner | Tennessee | 47165 | 53057 | 713 |
2352431 | 2352431 | 2022-03-28 | Tipton | Tennessee | 47167 | 17588 | 230 |
2352432 | 2352432 | 2022-03-28 | Trousdale | Tennessee | 47169 | 4209 | 45 |
2352433 | 2352433 | 2022-03-28 | Unicoi | Tennessee | 47171 | 5156 | 94 |
2352434 | 2352434 | 2022-03-28 | Union | Tennessee | 47173 | 5393 | 72 |
2352435 | 2352435 | 2022-03-28 | Unknown | Tennessee | 19014 | 312 | |
2352436 | 2352436 | 2022-03-28 | Van Buren | Tennessee | 47175 | 1845 | 47 |
2352437 | 2352437 | 2022-03-28 | Warren | Tennessee | 47177 | 12982 | 175 |
2352438 | 2352438 | 2022-03-28 | Washington | Tennessee | 47179 | 38465 | 486 |
2352439 | 2352439 | 2022-03-28 | Wayne | Tennessee | 47181 | 5687 | 63 |
2352440 | 2352440 | 2022-03-28 | Weakley | Tennessee | 47183 | 9491 | 140 |
2352441 | 2352441 | 2022-03-28 | White | Tennessee | 47185 | 8224 | 127 |
2352442 | 2352442 | 2022-03-28 | Williamson | Tennessee | 47187 | 61839 | 395 |
2352443 | 2352443 | 2022-03-28 | 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);