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-09-15 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1721669 | 1721669 | 2021-09-15 | Anderson | Tennessee | 47001 | 11535 | 191 |
1721670 | 1721670 | 2021-09-15 | Bedford | Tennessee | 47003 | 8306 | 139 |
1721671 | 1721671 | 2021-09-15 | Benton | Tennessee | 47005 | 2402 | 44 |
1721672 | 1721672 | 2021-09-15 | Bledsoe | Tennessee | 47007 | 3179 | 13 |
1721673 | 1721673 | 2021-09-15 | Blount | Tennessee | 47009 | 21155 | 226 |
1721674 | 1721674 | 2021-09-15 | Bradley | Tennessee | 47011 | 20399 | 166 |
1721675 | 1721675 | 2021-09-15 | Campbell | Tennessee | 47013 | 5713 | 70 |
1721676 | 1721676 | 2021-09-15 | Cannon | Tennessee | 47015 | 2581 | 36 |
1721677 | 1721677 | 2021-09-15 | Carroll | Tennessee | 47017 | 5051 | 93 |
1721678 | 1721678 | 2021-09-15 | Carter | Tennessee | 47019 | 9408 | 191 |
1721679 | 1721679 | 2021-09-15 | Cheatham | Tennessee | 47021 | 6371 | 59 |
1721680 | 1721680 | 2021-09-15 | Chester | Tennessee | 47023 | 3174 | 58 |
1721681 | 1721681 | 2021-09-15 | Claiborne | Tennessee | 47025 | 4566 | 80 |
1721682 | 1721682 | 2021-09-15 | Clay | Tennessee | 47027 | 1339 | 33 |
1721683 | 1721683 | 2021-09-15 | Cocke | Tennessee | 47029 | 6487 | 104 |
1721684 | 1721684 | 2021-09-15 | Coffee | Tennessee | 47031 | 9493 | 136 |
1721685 | 1721685 | 2021-09-15 | Crockett | Tennessee | 47033 | 3119 | 54 |
1721686 | 1721686 | 2021-09-15 | Cumberland | Tennessee | 47035 | 9879 | 169 |
1721687 | 1721687 | 2021-09-15 | Davidson | Tennessee | 47037 | 122946 | 1048 |
1721688 | 1721688 | 2021-09-15 | DeKalb | Tennessee | 47041 | 3876 | 60 |
1721689 | 1721689 | 2021-09-15 | Decatur | Tennessee | 47039 | 2218 | 41 |
1721690 | 1721690 | 2021-09-15 | Dickson | Tennessee | 47043 | 9396 | 143 |
1721691 | 1721691 | 2021-09-15 | Dyer | Tennessee | 47045 | 7548 | 119 |
1721692 | 1721692 | 2021-09-15 | Fayette | Tennessee | 47047 | 6770 | 93 |
1721693 | 1721693 | 2021-09-15 | Fentress | Tennessee | 47049 | 3210 | 51 |
1721694 | 1721694 | 2021-09-15 | Franklin | Tennessee | 47051 | 7248 | 95 |
1721695 | 1721695 | 2021-09-15 | Gibson | Tennessee | 47053 | 9794 | 171 |
1721696 | 1721696 | 2021-09-15 | Giles | Tennessee | 47055 | 5294 | 104 |
1721697 | 1721697 | 2021-09-15 | Grainger | Tennessee | 47057 | 3803 | 54 |
1721698 | 1721698 | 2021-09-15 | Greene | Tennessee | 47059 | 11736 | 198 |
1721699 | 1721699 | 2021-09-15 | Grundy | Tennessee | 47061 | 2426 | 36 |
1721700 | 1721700 | 2021-09-15 | Hamblen | Tennessee | 47063 | 11991 | 183 |
1721701 | 1721701 | 2021-09-15 | Hamilton | Tennessee | 47065 | 59310 | 591 |
1721702 | 1721702 | 2021-09-15 | Hancock | Tennessee | 47067 | 1000 | 15 |
1721703 | 1721703 | 2021-09-15 | Hardeman | Tennessee | 47069 | 4732 | 71 |
1721704 | 1721704 | 2021-09-15 | Hardin | Tennessee | 47071 | 5061 | 75 |
1721705 | 1721705 | 2021-09-15 | Hawkins | Tennessee | 47073 | 9031 | 139 |
1721706 | 1721706 | 2021-09-15 | Haywood | Tennessee | 47075 | 3545 | 67 |
1721707 | 1721707 | 2021-09-15 | Henderson | Tennessee | 47077 | 5083 | 83 |
1721708 | 1721708 | 2021-09-15 | Henry | Tennessee | 47079 | 5022 | 76 |
1721709 | 1721709 | 2021-09-15 | Hickman | Tennessee | 47081 | 4258 | 58 |
1721710 | 1721710 | 2021-09-15 | Houston | Tennessee | 47083 | 1646 | 38 |
1721711 | 1721711 | 2021-09-15 | Humphreys | Tennessee | 47085 | 2774 | 39 |
1721712 | 1721712 | 2021-09-15 | Jackson | Tennessee | 47087 | 1837 | 37 |
1721713 | 1721713 | 2021-09-15 | Jefferson | Tennessee | 47089 | 8897 | 134 |
1721714 | 1721714 | 2021-09-15 | Johnson | Tennessee | 47091 | 3114 | 43 |
1721715 | 1721715 | 2021-09-15 | Knox | Tennessee | 47093 | 69961 | 771 |
1721716 | 1721716 | 2021-09-15 | Lake | Tennessee | 47095 | 1895 | 31 |
1721717 | 1721717 | 2021-09-15 | Lauderdale | Tennessee | 47097 | 4851 | 55 |
1721718 | 1721718 | 2021-09-15 | Lawrence | Tennessee | 47099 | 8577 | 107 |
1721719 | 1721719 | 2021-09-15 | Lewis | Tennessee | 47101 | 2396 | 31 |
1721720 | 1721720 | 2021-09-15 | Lincoln | Tennessee | 47103 | 6033 | 78 |
1721721 | 1721721 | 2021-09-15 | Loudon | Tennessee | 47105 | 8285 | 84 |
1721722 | 1721722 | 2021-09-15 | Macon | Tennessee | 47111 | 4999 | 82 |
1721723 | 1721723 | 2021-09-15 | Madison | Tennessee | 47113 | 16403 | 278 |
1721724 | 1721724 | 2021-09-15 | Marion | Tennessee | 47115 | 5227 | 52 |
1721725 | 1721725 | 2021-09-15 | Marshall | Tennessee | 47117 | 6286 | 72 |
1721726 | 1721726 | 2021-09-15 | Maury | Tennessee | 47119 | 17937 | 201 |
1721727 | 1721727 | 2021-09-15 | McMinn | Tennessee | 47107 | 9572 | 114 |
1721728 | 1721728 | 2021-09-15 | McNairy | Tennessee | 47109 | 4144 | 61 |
1721729 | 1721729 | 2021-09-15 | Meigs | Tennessee | 47121 | 1950 | 24 |
1721730 | 1721730 | 2021-09-15 | Monroe | Tennessee | 47123 | 8825 | 108 |
1721731 | 1721731 | 2021-09-15 | Montgomery | Tennessee | 47125 | 29587 | 282 |
1721732 | 1721732 | 2021-09-15 | Moore | Tennessee | 47127 | 1308 | 19 |
1721733 | 1721733 | 2021-09-15 | Morgan | Tennessee | 47129 | 3328 | 41 |
1721734 | 1721734 | 2021-09-15 | Obion | Tennessee | 47131 | 6024 | 102 |
1721735 | 1721735 | 2021-09-15 | Overton | Tennessee | 47133 | 4251 | 65 |
1721736 | 1721736 | 2021-09-15 | Perry | Tennessee | 47135 | 1448 | 31 |
1721737 | 1721737 | 2021-09-15 | Pickett | Tennessee | 47137 | 959 | 24 |
1721738 | 1721738 | 2021-09-15 | Polk | Tennessee | 47139 | 2879 | 25 |
1721739 | 1721739 | 2021-09-15 | Putnam | Tennessee | 47141 | 15308 | 191 |
1721740 | 1721740 | 2021-09-15 | Rhea | Tennessee | 47143 | 6285 | 89 |
1721741 | 1721741 | 2021-09-15 | Roane | Tennessee | 47145 | 8904 | 132 |
1721742 | 1721742 | 2021-09-15 | Robertson | Tennessee | 47147 | 12995 | 161 |
1721743 | 1721743 | 2021-09-15 | Rutherford | Tennessee | 47149 | 57271 | 485 |
1721744 | 1721744 | 2021-09-15 | Scott | Tennessee | 47151 | 4283 | 54 |
1721745 | 1721745 | 2021-09-15 | Sequatchie | Tennessee | 47153 | 2685 | 30 |
1721746 | 1721746 | 2021-09-15 | Sevier | Tennessee | 47155 | 18033 | 223 |
1721747 | 1721747 | 2021-09-15 | Shelby | Tennessee | 47157 | 136212 | 1958 |
1721748 | 1721748 | 2021-09-15 | Smith | Tennessee | 47159 | 3842 | 42 |
1721749 | 1721749 | 2021-09-15 | Stewart | Tennessee | 47161 | 1871 | 30 |
1721750 | 1721750 | 2021-09-15 | Sullivan | Tennessee | 47163 | 23775 | 368 |
1721751 | 1721751 | 2021-09-15 | Sumner | Tennessee | 47165 | 31992 | 391 |
1721752 | 1721752 | 2021-09-15 | Tipton | Tennessee | 47167 | 10450 | 115 |
1721753 | 1721753 | 2021-09-15 | Trousdale | Tennessee | 47169 | 2935 | 24 |
1721754 | 1721754 | 2021-09-15 | Unicoi | Tennessee | 47171 | 2836 | 56 |
1721755 | 1721755 | 2021-09-15 | Union | Tennessee | 47173 | 2643 | 37 |
1721756 | 1721756 | 2021-09-15 | Unknown | Tennessee | 8312 | 105 | |
1721757 | 1721757 | 2021-09-15 | Van Buren | Tennessee | 47175 | 1105 | 25 |
1721758 | 1721758 | 2021-09-15 | Warren | Tennessee | 47177 | 7710 | 96 |
1721759 | 1721759 | 2021-09-15 | Washington | Tennessee | 47179 | 19684 | 288 |
1721760 | 1721760 | 2021-09-15 | Wayne | Tennessee | 47181 | 3741 | 38 |
1721761 | 1721761 | 2021-09-15 | Weakley | Tennessee | 47183 | 5619 | 74 |
1721762 | 1721762 | 2021-09-15 | White | Tennessee | 47185 | 5042 | 83 |
1721763 | 1721763 | 2021-09-15 | Williamson | Tennessee | 47187 | 36824 | 249 |
1721764 | 1721764 | 2021-09-15 | Wilson | Tennessee | 47189 | 25110 | 301 |
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);