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-19 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
449654 | 449654 | 2020-08-19 | Anderson | Tennessee | 47001 | 799 | 6 |
449655 | 449655 | 2020-08-19 | Bedford | Tennessee | 47003 | 1006 | 13 |
449656 | 449656 | 2020-08-19 | Benton | Tennessee | 47005 | 197 | 2 |
449657 | 449657 | 2020-08-19 | Bledsoe | Tennessee | 47007 | 758 | 3 |
449658 | 449658 | 2020-08-19 | Blount | Tennessee | 47009 | 1584 | 15 |
449659 | 449659 | 2020-08-19 | Bradley | Tennessee | 47011 | 2232 | 16 |
449660 | 449660 | 2020-08-19 | Campbell | Tennessee | 47013 | 284 | 2 |
449661 | 449661 | 2020-08-19 | Cannon | Tennessee | 47015 | 172 | 0 |
449662 | 449662 | 2020-08-19 | Carroll | Tennessee | 47017 | 426 | 6 |
449663 | 449663 | 2020-08-19 | Carter | Tennessee | 47019 | 679 | 9 |
449664 | 449664 | 2020-08-19 | Cheatham | Tennessee | 47021 | 670 | 9 |
449665 | 449665 | 2020-08-19 | Chester | Tennessee | 47023 | 295 | 2 |
449666 | 449666 | 2020-08-19 | Claiborne | Tennessee | 47025 | 323 | 1 |
449667 | 449667 | 2020-08-19 | Clay | Tennessee | 47027 | 94 | 0 |
449668 | 449668 | 2020-08-19 | Cocke | Tennessee | 47029 | 578 | 6 |
449669 | 449669 | 2020-08-19 | Coffee | Tennessee | 47031 | 650 | 5 |
449670 | 449670 | 2020-08-19 | Crockett | Tennessee | 47033 | 320 | 8 |
449671 | 449671 | 2020-08-19 | Cumberland | Tennessee | 47035 | 627 | 7 |
449672 | 449672 | 2020-08-19 | Davidson | Tennessee | 47037 | 24696 | 235 |
449673 | 449673 | 2020-08-19 | DeKalb | Tennessee | 47041 | 398 | 4 |
449674 | 449674 | 2020-08-19 | Decatur | Tennessee | 47039 | 250 | 3 |
449675 | 449675 | 2020-08-19 | Dickson | Tennessee | 47043 | 807 | 5 |
449676 | 449676 | 2020-08-19 | Dyer | Tennessee | 47045 | 772 | 9 |
449677 | 449677 | 2020-08-19 | Fayette | Tennessee | 47047 | 787 | 10 |
449678 | 449678 | 2020-08-19 | Fentress | Tennessee | 47049 | 135 | 0 |
449679 | 449679 | 2020-08-19 | Franklin | Tennessee | 47051 | 391 | 4 |
449680 | 449680 | 2020-08-19 | Gibson | Tennessee | 47053 | 877 | 11 |
449681 | 449681 | 2020-08-19 | Giles | Tennessee | 47055 | 420 | 14 |
449682 | 449682 | 2020-08-19 | Grainger | Tennessee | 47057 | 234 | 1 |
449683 | 449683 | 2020-08-19 | Greene | Tennessee | 47059 | 653 | 9 |
449684 | 449684 | 2020-08-19 | Grundy | Tennessee | 47061 | 136 | 2 |
449685 | 449685 | 2020-08-19 | Hamblen | Tennessee | 47063 | 1530 | 16 |
449686 | 449686 | 2020-08-19 | Hamilton | Tennessee | 47065 | 7145 | 63 |
449687 | 449687 | 2020-08-19 | Hancock | Tennessee | 47067 | 84 | 2 |
449688 | 449688 | 2020-08-19 | Hardeman | Tennessee | 47069 | 1108 | 19 |
449689 | 449689 | 2020-08-19 | Hardin | Tennessee | 47071 | 549 | 8 |
449690 | 449690 | 2020-08-19 | Hawkins | Tennessee | 47073 | 606 | 10 |
449691 | 449691 | 2020-08-19 | Haywood | Tennessee | 47075 | 648 | 9 |
449692 | 449692 | 2020-08-19 | Henderson | Tennessee | 47077 | 732 | 4 |
449693 | 449693 | 2020-08-19 | Henry | Tennessee | 47079 | 357 | 3 |
449694 | 449694 | 2020-08-19 | Hickman | Tennessee | 47081 | 319 | 1 |
449695 | 449695 | 2020-08-19 | Houston | Tennessee | 47083 | 68 | 0 |
449696 | 449696 | 2020-08-19 | Humphreys | Tennessee | 47085 | 146 | 3 |
449697 | 449697 | 2020-08-19 | Jackson | Tennessee | 47087 | 170 | 1 |
449698 | 449698 | 2020-08-19 | Jefferson | Tennessee | 47089 | 667 | 4 |
449699 | 449699 | 2020-08-19 | Johnson | Tennessee | 47091 | 362 | 1 |
449700 | 449700 | 2020-08-19 | Knox | Tennessee | 47093 | 5731 | 52 |
449701 | 449701 | 2020-08-19 | Lake | Tennessee | 47095 | 807 | 1 |
449702 | 449702 | 2020-08-19 | Lauderdale | Tennessee | 47097 | 578 | 10 |
449703 | 449703 | 2020-08-19 | Lawrence | Tennessee | 47099 | 671 | 8 |
449704 | 449704 | 2020-08-19 | Lewis | Tennessee | 47101 | 93 | 1 |
449705 | 449705 | 2020-08-19 | Lincoln | Tennessee | 47103 | 362 | 1 |
449706 | 449706 | 2020-08-19 | Loudon | Tennessee | 47105 | 823 | 3 |
449707 | 449707 | 2020-08-19 | Macon | Tennessee | 47111 | 876 | 14 |
449708 | 449708 | 2020-08-19 | Madison | Tennessee | 47113 | 1458 | 28 |
449709 | 449709 | 2020-08-19 | Marion | Tennessee | 47115 | 276 | 5 |
449710 | 449710 | 2020-08-19 | Marshall | Tennessee | 47117 | 400 | 4 |
449711 | 449711 | 2020-08-19 | Maury | Tennessee | 47119 | 1470 | 11 |
449712 | 449712 | 2020-08-19 | McMinn | Tennessee | 47107 | 651 | 20 |
449713 | 449713 | 2020-08-19 | McNairy | Tennessee | 47109 | 445 | 7 |
449714 | 449714 | 2020-08-19 | Meigs | Tennessee | 47121 | 124 | 1 |
449715 | 449715 | 2020-08-19 | Monroe | Tennessee | 47123 | 547 | 10 |
449716 | 449716 | 2020-08-19 | Montgomery | Tennessee | 47125 | 2212 | 21 |
449717 | 449717 | 2020-08-19 | Moore | Tennessee | 47127 | 80 | 0 |
449718 | 449718 | 2020-08-19 | Morgan | Tennessee | 47129 | 162 | 1 |
449719 | 449719 | 2020-08-19 | Obion | Tennessee | 47131 | 700 | 4 |
449720 | 449720 | 2020-08-19 | Overton | Tennessee | 47133 | 307 | 1 |
449721 | 449721 | 2020-08-19 | Perry | Tennessee | 47135 | 93 | 0 |
449722 | 449722 | 2020-08-19 | Pickett | Tennessee | 47137 | 41 | 1 |
449723 | 449723 | 2020-08-19 | Polk | Tennessee | 47139 | 288 | 10 |
449724 | 449724 | 2020-08-19 | Putnam | Tennessee | 47141 | 2008 | 22 |
449725 | 449725 | 2020-08-19 | Rhea | Tennessee | 47143 | 596 | 2 |
449726 | 449726 | 2020-08-19 | Roane | Tennessee | 47145 | 559 | 2 |
449727 | 449727 | 2020-08-19 | Robertson | Tennessee | 47147 | 1678 | 23 |
449728 | 449728 | 2020-08-19 | Rutherford | Tennessee | 47149 | 7223 | 61 |
449729 | 449729 | 2020-08-19 | Scott | Tennessee | 47151 | 145 | 2 |
449730 | 449730 | 2020-08-19 | Sequatchie | Tennessee | 47153 | 132 | 1 |
449731 | 449731 | 2020-08-19 | Sevier | Tennessee | 47155 | 2096 | 10 |
449732 | 449732 | 2020-08-19 | Shelby | Tennessee | 47157 | 25507 | 341 |
449733 | 449733 | 2020-08-19 | Smith | Tennessee | 47159 | 489 | 5 |
449734 | 449734 | 2020-08-19 | Stewart | Tennessee | 47161 | 89 | 0 |
449735 | 449735 | 2020-08-19 | Sullivan | Tennessee | 47163 | 1221 | 20 |
449736 | 449736 | 2020-08-19 | Sumner | Tennessee | 47165 | 3730 | 78 |
449737 | 449737 | 2020-08-19 | Tipton | Tennessee | 47167 | 1295 | 12 |
449738 | 449738 | 2020-08-19 | Trousdale | Tennessee | 47169 | 1586 | 6 |
449739 | 449739 | 2020-08-19 | Unicoi | Tennessee | 47171 | 191 | 0 |
449740 | 449740 | 2020-08-19 | Union | Tennessee | 47173 | 185 | 0 |
449741 | 449741 | 2020-08-19 | Unknown | Tennessee | 136 | 0 | |
449742 | 449742 | 2020-08-19 | Van Buren | Tennessee | 47175 | 46 | 0 |
449743 | 449743 | 2020-08-19 | Warren | Tennessee | 47177 | 641 | 6 |
449744 | 449744 | 2020-08-19 | Washington | Tennessee | 47179 | 1513 | 4 |
449745 | 449745 | 2020-08-19 | Wayne | Tennessee | 47181 | 244 | 2 |
449746 | 449746 | 2020-08-19 | Weakley | Tennessee | 47183 | 658 | 7 |
449747 | 449747 | 2020-08-19 | White | Tennessee | 47185 | 364 | 6 |
449748 | 449748 | 2020-08-19 | Williamson | Tennessee | 47187 | 3979 | 26 |
449749 | 449749 | 2020-08-19 | Wilson | Tennessee | 47189 | 2563 | 26 |
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);