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-04-21 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1244354 | 1244354 | 2021-04-21 | Anderson | Tennessee | 47001 | 8639 | 171 |
1244355 | 1244355 | 2021-04-21 | Bedford | Tennessee | 47003 | 6439 | 129 |
1244356 | 1244356 | 2021-04-21 | Benton | Tennessee | 47005 | 1634 | 40 |
1244357 | 1244357 | 2021-04-21 | Bledsoe | Tennessee | 47007 | 2101 | 11 |
1244358 | 1244358 | 2021-04-21 | Blount | Tennessee | 47009 | 15213 | 194 |
1244359 | 1244359 | 2021-04-21 | Bradley | Tennessee | 47011 | 14670 | 148 |
1244360 | 1244360 | 2021-04-21 | Campbell | Tennessee | 47013 | 4105 | 62 |
1244361 | 1244361 | 2021-04-21 | Cannon | Tennessee | 47015 | 1892 | 31 |
1244362 | 1244362 | 2021-04-21 | Carroll | Tennessee | 47017 | 3577 | 82 |
1244363 | 1244363 | 2021-04-21 | Carter | Tennessee | 47019 | 6487 | 156 |
1244364 | 1244364 | 2021-04-21 | Cheatham | Tennessee | 47021 | 4459 | 54 |
1244365 | 1244365 | 2021-04-21 | Chester | Tennessee | 47023 | 2096 | 51 |
1244366 | 1244366 | 2021-04-21 | Claiborne | Tennessee | 47025 | 3073 | 73 |
1244367 | 1244367 | 2021-04-21 | Clay | Tennessee | 47027 | 1094 | 31 |
1244368 | 1244368 | 2021-04-21 | Cocke | Tennessee | 47029 | 4442 | 98 |
1244369 | 1244369 | 2021-04-21 | Coffee | Tennessee | 47031 | 6833 | 121 |
1244370 | 1244370 | 2021-04-21 | Crockett | Tennessee | 47033 | 2015 | 48 |
1244371 | 1244371 | 2021-04-21 | Cumberland | Tennessee | 47035 | 6586 | 128 |
1244372 | 1244372 | 2021-04-21 | Davidson | Tennessee | 47037 | 97371 | 926 |
1244373 | 1244373 | 2021-04-21 | DeKalb | Tennessee | 47041 | 2757 | 53 |
1244374 | 1244374 | 2021-04-21 | Decatur | Tennessee | 47039 | 1575 | 38 |
1244375 | 1244375 | 2021-04-21 | Dickson | Tennessee | 47043 | 6740 | 109 |
1244376 | 1244376 | 2021-04-21 | Dyer | Tennessee | 47045 | 5371 | 104 |
1244377 | 1244377 | 2021-04-21 | Fayette | Tennessee | 47047 | 4936 | 78 |
1244378 | 1244378 | 2021-04-21 | Fentress | Tennessee | 47049 | 2384 | 46 |
1244379 | 1244379 | 2021-04-21 | Franklin | Tennessee | 47051 | 5094 | 88 |
1244380 | 1244380 | 2021-04-21 | Gibson | Tennessee | 47053 | 6410 | 144 |
1244381 | 1244381 | 2021-04-21 | Giles | Tennessee | 47055 | 3962 | 99 |
1244382 | 1244382 | 2021-04-21 | Grainger | Tennessee | 47057 | 2596 | 49 |
1244383 | 1244383 | 2021-04-21 | Greene | Tennessee | 47059 | 7746 | 152 |
1244384 | 1244384 | 2021-04-21 | Grundy | Tennessee | 47061 | 1784 | 33 |
1244385 | 1244385 | 2021-04-21 | Hamblen | Tennessee | 47063 | 8522 | 171 |
1244386 | 1244386 | 2021-04-21 | Hamilton | Tennessee | 47065 | 43719 | 488 |
1244387 | 1244387 | 2021-04-21 | Hancock | Tennessee | 47067 | 557 | 12 |
1244388 | 1244388 | 2021-04-21 | Hardeman | Tennessee | 47069 | 3467 | 64 |
1244389 | 1244389 | 2021-04-21 | Hardin | Tennessee | 47071 | 3505 | 66 |
1244390 | 1244390 | 2021-04-21 | Hawkins | Tennessee | 47073 | 5802 | 106 |
1244391 | 1244391 | 2021-04-21 | Haywood | Tennessee | 47075 | 2684 | 61 |
1244392 | 1244392 | 2021-04-21 | Henderson | Tennessee | 47077 | 3732 | 76 |
1244393 | 1244393 | 2021-04-21 | Henry | Tennessee | 47079 | 3126 | 75 |
1244394 | 1244394 | 2021-04-21 | Hickman | Tennessee | 47081 | 2807 | 46 |
1244395 | 1244395 | 2021-04-21 | Houston | Tennessee | 47083 | 1086 | 33 |
1244396 | 1244396 | 2021-04-21 | Humphreys | Tennessee | 47085 | 1746 | 22 |
1244397 | 1244397 | 2021-04-21 | Jackson | Tennessee | 47087 | 1300 | 35 |
1244398 | 1244398 | 2021-04-21 | Jefferson | Tennessee | 47089 | 6089 | 124 |
1244399 | 1244399 | 2021-04-21 | Johnson | Tennessee | 47091 | 2322 | 38 |
1244400 | 1244400 | 2021-04-21 | Knox | Tennessee | 47093 | 51087 | 626 |
1244401 | 1244401 | 2021-04-21 | Lake | Tennessee | 47095 | 1696 | 26 |
1244402 | 1244402 | 2021-04-21 | Lauderdale | Tennessee | 47097 | 3144 | 44 |
1244403 | 1244403 | 2021-04-21 | Lawrence | Tennessee | 47099 | 5820 | 86 |
1244404 | 1244404 | 2021-04-21 | Lewis | Tennessee | 47101 | 1566 | 26 |
1244405 | 1244405 | 2021-04-21 | Lincoln | Tennessee | 47103 | 4309 | 63 |
1244406 | 1244406 | 2021-04-21 | Loudon | Tennessee | 47105 | 6024 | 69 |
1244407 | 1244407 | 2021-04-21 | Macon | Tennessee | 47111 | 3586 | 77 |
1244408 | 1244408 | 2021-04-21 | Madison | Tennessee | 47113 | 10853 | 241 |
1244409 | 1244409 | 2021-04-21 | Marion | Tennessee | 47115 | 3108 | 46 |
1244410 | 1244410 | 2021-04-21 | Marshall | Tennessee | 47117 | 4123 | 58 |
1244411 | 1244411 | 2021-04-21 | Maury | Tennessee | 47119 | 13261 | 170 |
1244412 | 1244412 | 2021-04-21 | McMinn | Tennessee | 47107 | 6378 | 97 |
1244413 | 1244413 | 2021-04-21 | McNairy | Tennessee | 47109 | 2772 | 54 |
1244414 | 1244414 | 2021-04-21 | Meigs | Tennessee | 47121 | 1351 | 24 |
1244415 | 1244415 | 2021-04-21 | Monroe | Tennessee | 47123 | 5724 | 95 |
1244416 | 1244416 | 2021-04-21 | Montgomery | Tennessee | 47125 | 19740 | 224 |
1244417 | 1244417 | 2021-04-21 | Moore | Tennessee | 47127 | 1002 | 17 |
1244418 | 1244418 | 2021-04-21 | Morgan | Tennessee | 47129 | 2463 | 39 |
1244419 | 1244419 | 2021-04-21 | Obion | Tennessee | 47131 | 4503 | 96 |
1244420 | 1244420 | 2021-04-21 | Overton | Tennessee | 47133 | 2981 | 61 |
1244421 | 1244421 | 2021-04-21 | Perry | Tennessee | 47135 | 1057 | 28 |
1244422 | 1244422 | 2021-04-21 | Pickett | Tennessee | 47137 | 757 | 24 |
1244423 | 1244423 | 2021-04-21 | Polk | Tennessee | 47139 | 2003 | 24 |
1244424 | 1244424 | 2021-04-21 | Putnam | Tennessee | 47141 | 11193 | 173 |
1244425 | 1244425 | 2021-04-21 | Rhea | Tennessee | 47143 | 4315 | 75 |
1244426 | 1244426 | 2021-04-21 | Roane | Tennessee | 47145 | 6197 | 102 |
1244427 | 1244427 | 2021-04-21 | Robertson | Tennessee | 47147 | 9627 | 129 |
1244428 | 1244428 | 2021-04-21 | Rutherford | Tennessee | 47149 | 42422 | 423 |
1244429 | 1244429 | 2021-04-21 | Scott | Tennessee | 47151 | 3057 | 45 |
1244430 | 1244430 | 2021-04-21 | Sequatchie | Tennessee | 47153 | 1670 | 28 |
1244431 | 1244431 | 2021-04-21 | Sevier | Tennessee | 47155 | 13204 | 175 |
1244432 | 1244432 | 2021-04-21 | Shelby | Tennessee | 47157 | 94069 | 1600 |
1244433 | 1244433 | 2021-04-21 | Smith | Tennessee | 47159 | 2752 | 38 |
1244434 | 1244434 | 2021-04-21 | Stewart | Tennessee | 47161 | 1310 | 28 |
1244435 | 1244435 | 2021-04-21 | Sullivan | Tennessee | 47163 | 16266 | 287 |
1244436 | 1244436 | 2021-04-21 | Sumner | Tennessee | 47165 | 23549 | 345 |
1244437 | 1244437 | 2021-04-21 | Tipton | Tennessee | 47167 | 7235 | 104 |
1244438 | 1244438 | 2021-04-21 | Trousdale | Tennessee | 47169 | 2491 | 22 |
1244439 | 1244439 | 2021-04-21 | Unicoi | Tennessee | 47171 | 1952 | 49 |
1244440 | 1244440 | 2021-04-21 | Union | Tennessee | 47173 | 1865 | 34 |
1244441 | 1244441 | 2021-04-21 | Unknown | Tennessee | 9221 | 123 | |
1244442 | 1244442 | 2021-04-21 | Van Buren | Tennessee | 47175 | 836 | 22 |
1244443 | 1244443 | 2021-04-21 | Warren | Tennessee | 47177 | 5518 | 81 |
1244444 | 1244444 | 2021-04-21 | Washington | Tennessee | 47179 | 14243 | 244 |
1244445 | 1244445 | 2021-04-21 | Wayne | Tennessee | 47181 | 2944 | 34 |
1244446 | 1244446 | 2021-04-21 | Weakley | Tennessee | 47183 | 4037 | 63 |
1244447 | 1244447 | 2021-04-21 | White | Tennessee | 47185 | 3562 | 69 |
1244448 | 1244448 | 2021-04-21 | Williamson | Tennessee | 47187 | 27589 | 215 |
1244449 | 1244449 | 2021-04-21 | Wilson | Tennessee | 47189 | 18547 | 229 |
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);