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 2020-08-01 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
391657 | 391657 | 2020-08-01 | Anderson | Tennessee | 47001 | 583 | 5 |
391658 | 391658 | 2020-08-01 | Bedford | Tennessee | 47003 | 851 | 10 |
391659 | 391659 | 2020-08-01 | Benton | Tennessee | 47005 | 91 | 1 |
391660 | 391660 | 2020-08-01 | Bledsoe | Tennessee | 47007 | 661 | 1 |
391661 | 391661 | 2020-08-01 | Blount | Tennessee | 47009 | 1089 | 7 |
391662 | 391662 | 2020-08-01 | Bradley | Tennessee | 47011 | 1681 | 10 |
391663 | 391663 | 2020-08-01 | Campbell | Tennessee | 47013 | 203 | 1 |
391664 | 391664 | 2020-08-01 | Cannon | Tennessee | 47015 | 115 | 0 |
391665 | 391665 | 2020-08-01 | Carroll | Tennessee | 47017 | 216 | 3 |
391666 | 391666 | 2020-08-01 | Carter | Tennessee | 47019 | 407 | 5 |
391667 | 391667 | 2020-08-01 | Cheatham | Tennessee | 47021 | 533 | 5 |
391668 | 391668 | 2020-08-01 | Chester | Tennessee | 47023 | 190 | 1 |
391669 | 391669 | 2020-08-01 | Claiborne | Tennessee | 47025 | 210 | 0 |
391670 | 391670 | 2020-08-01 | Clay | Tennessee | 47027 | 61 | 0 |
391671 | 391671 | 2020-08-01 | Cocke | Tennessee | 47029 | 385 | 1 |
391672 | 391672 | 2020-08-01 | Coffee | Tennessee | 47031 | 395 | 2 |
391673 | 391673 | 2020-08-01 | Crockett | Tennessee | 47033 | 220 | 3 |
391674 | 391674 | 2020-08-01 | Cumberland | Tennessee | 47035 | 374 | 6 |
391675 | 391675 | 2020-08-01 | Davidson | Tennessee | 47037 | 21410 | 198 |
391676 | 391676 | 2020-08-01 | DeKalb | Tennessee | 47041 | 303 | 1 |
391677 | 391677 | 2020-08-01 | Decatur | Tennessee | 47039 | 159 | 1 |
391678 | 391678 | 2020-08-01 | Dickson | Tennessee | 47043 | 580 | 1 |
391679 | 391679 | 2020-08-01 | Dyer | Tennessee | 47045 | 534 | 7 |
391680 | 391680 | 2020-08-01 | Fayette | Tennessee | 47047 | 616 | 8 |
391681 | 391681 | 2020-08-01 | Fentress | Tennessee | 47049 | 73 | 0 |
391682 | 391682 | 2020-08-01 | Franklin | Tennessee | 47051 | 271 | 4 |
391683 | 391683 | 2020-08-01 | Gibson | Tennessee | 47053 | 550 | 2 |
391684 | 391684 | 2020-08-01 | Giles | Tennessee | 47055 | 334 | 9 |
391685 | 391685 | 2020-08-01 | Grainger | Tennessee | 47057 | 164 | 0 |
391686 | 391686 | 2020-08-01 | Greene | Tennessee | 47059 | 362 | 5 |
391687 | 391687 | 2020-08-01 | Grundy | Tennessee | 47061 | 98 | 2 |
391688 | 391688 | 2020-08-01 | Hamblen | Tennessee | 47063 | 1208 | 13 |
391689 | 391689 | 2020-08-01 | Hamilton | Tennessee | 47065 | 5549 | 48 |
391690 | 391690 | 2020-08-01 | Hancock | Tennessee | 47067 | 72 | 1 |
391691 | 391691 | 2020-08-01 | Hardeman | Tennessee | 47069 | 787 | 11 |
391692 | 391692 | 2020-08-01 | Hardin | Tennessee | 47071 | 394 | 7 |
391693 | 391693 | 2020-08-01 | Hawkins | Tennessee | 47073 | 304 | 4 |
391694 | 391694 | 2020-08-01 | Haywood | Tennessee | 47075 | 366 | 5 |
391695 | 391695 | 2020-08-01 | Henderson | Tennessee | 47077 | 423 | 0 |
391696 | 391696 | 2020-08-01 | Henry | Tennessee | 47079 | 205 | 0 |
391697 | 391697 | 2020-08-01 | Hickman | Tennessee | 47081 | 218 | 0 |
391698 | 391698 | 2020-08-01 | Houston | Tennessee | 47083 | 54 | 0 |
391699 | 391699 | 2020-08-01 | Humphreys | Tennessee | 47085 | 100 | 3 |
391700 | 391700 | 2020-08-01 | Jackson | Tennessee | 47087 | 105 | 1 |
391701 | 391701 | 2020-08-01 | Jefferson | Tennessee | 47089 | 480 | 2 |
391702 | 391702 | 2020-08-01 | Johnson | Tennessee | 47091 | 141 | 0 |
391703 | 391703 | 2020-08-01 | Knox | Tennessee | 47093 | 4037 | 35 |
391704 | 391704 | 2020-08-01 | Lake | Tennessee | 47095 | 740 | 0 |
391705 | 391705 | 2020-08-01 | Lauderdale | Tennessee | 47097 | 420 | 6 |
391706 | 391706 | 2020-08-01 | Lawrence | Tennessee | 47099 | 458 | 6 |
391707 | 391707 | 2020-08-01 | Lewis | Tennessee | 47101 | 51 | 1 |
391708 | 391708 | 2020-08-01 | Lincoln | Tennessee | 47103 | 250 | 1 |
391709 | 391709 | 2020-08-01 | Loudon | Tennessee | 47105 | 643 | 3 |
391710 | 391710 | 2020-08-01 | Macon | Tennessee | 47111 | 834 | 13 |
391711 | 391711 | 2020-08-01 | Madison | Tennessee | 47113 | 863 | 12 |
391712 | 391712 | 2020-08-01 | Marion | Tennessee | 47115 | 199 | 4 |
391713 | 391713 | 2020-08-01 | Marshall | Tennessee | 47117 | 261 | 2 |
391714 | 391714 | 2020-08-01 | Maury | Tennessee | 47119 | 1050 | 5 |
391715 | 391715 | 2020-08-01 | McMinn | Tennessee | 47107 | 472 | 20 |
391716 | 391716 | 2020-08-01 | McNairy | Tennessee | 47109 | 309 | 5 |
391717 | 391717 | 2020-08-01 | Meigs | Tennessee | 47121 | 96 | 0 |
391718 | 391718 | 2020-08-01 | Monroe | Tennessee | 47123 | 352 | 9 |
391719 | 391719 | 2020-08-01 | Montgomery | Tennessee | 47125 | 1677 | 11 |
391720 | 391720 | 2020-08-01 | Moore | Tennessee | 47127 | 43 | 0 |
391721 | 391721 | 2020-08-01 | Morgan | Tennessee | 47129 | 76 | 1 |
391722 | 391722 | 2020-08-01 | Obion | Tennessee | 47131 | 419 | 4 |
391723 | 391723 | 2020-08-01 | Overton | Tennessee | 47133 | 134 | 1 |
391724 | 391724 | 2020-08-01 | Perry | Tennessee | 47135 | 73 | 0 |
391725 | 391725 | 2020-08-01 | Pickett | Tennessee | 47137 | 22 | 1 |
391726 | 391726 | 2020-08-01 | Polk | Tennessee | 47139 | 157 | 1 |
391727 | 391727 | 2020-08-01 | Putnam | Tennessee | 47141 | 1543 | 13 |
391728 | 391728 | 2020-08-01 | Rhea | Tennessee | 47143 | 491 | 1 |
391729 | 391729 | 2020-08-01 | Roane | Tennessee | 47145 | 347 | 1 |
391730 | 391730 | 2020-08-01 | Robertson | Tennessee | 47147 | 1417 | 16 |
391731 | 391731 | 2020-08-01 | Rutherford | Tennessee | 47149 | 5999 | 51 |
391732 | 391732 | 2020-08-01 | Scott | Tennessee | 47151 | 98 | 0 |
391733 | 391733 | 2020-08-01 | Sequatchie | Tennessee | 47153 | 94 | 0 |
391734 | 391734 | 2020-08-01 | Sevier | Tennessee | 47155 | 1679 | 5 |
391735 | 391735 | 2020-08-01 | Shelby | Tennessee | 47157 | 21461 | 284 |
391736 | 391736 | 2020-08-01 | Smith | Tennessee | 47159 | 360 | 3 |
391737 | 391737 | 2020-08-01 | Stewart | Tennessee | 47161 | 67 | 0 |
391738 | 391738 | 2020-08-01 | Sullivan | Tennessee | 47163 | 758 | 8 |
391739 | 391739 | 2020-08-01 | Sumner | Tennessee | 47165 | 3136 | 69 |
391740 | 391740 | 2020-08-01 | Tipton | Tennessee | 47167 | 1094 | 9 |
391741 | 391741 | 2020-08-01 | Trousdale | Tennessee | 47169 | 1572 | 6 |
391742 | 391742 | 2020-08-01 | Unicoi | Tennessee | 47171 | 136 | 0 |
391743 | 391743 | 2020-08-01 | Union | Tennessee | 47173 | 114 | 0 |
391744 | 391744 | 2020-08-01 | Unknown | Tennessee | 25 | 0 | |
391745 | 391745 | 2020-08-01 | Van Buren | Tennessee | 47175 | 32 | 0 |
391746 | 391746 | 2020-08-01 | Warren | Tennessee | 47177 | 393 | 4 |
391747 | 391747 | 2020-08-01 | Washington | Tennessee | 47179 | 993 | 2 |
391748 | 391748 | 2020-08-01 | Wayne | Tennessee | 47181 | 212 | 1 |
391749 | 391749 | 2020-08-01 | Weakley | Tennessee | 47183 | 251 | 3 |
391750 | 391750 | 2020-08-01 | White | Tennessee | 47185 | 188 | 3 |
391751 | 391751 | 2020-08-01 | Williamson | Tennessee | 47187 | 3193 | 22 |
391752 | 391752 | 2020-08-01 | Wilson | Tennessee | 47189 | 2041 | 20 |
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);