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-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 |
---|---|---|---|---|---|---|---|
2323071 | 2323071 | 2022-03-19 | Anderson | Tennessee | 47001 | 22027 | 317 |
2323072 | 2323072 | 2022-03-19 | Bedford | Tennessee | 47003 | 14917 | 228 |
2323073 | 2323073 | 2022-03-19 | Benton | Tennessee | 47005 | 4466 | 90 |
2323074 | 2323074 | 2022-03-19 | Bledsoe | Tennessee | 47007 | 4651 | 54 |
2323075 | 2323075 | 2022-03-19 | Blount | Tennessee | 47009 | 38990 | 413 |
2323076 | 2323076 | 2022-03-19 | Bradley | Tennessee | 47011 | 33047 | 399 |
2323077 | 2323077 | 2022-03-19 | Campbell | Tennessee | 47013 | 12127 | 157 |
2323078 | 2323078 | 2022-03-19 | Cannon | Tennessee | 47015 | 4181 | 57 |
2323079 | 2323079 | 2022-03-19 | Carroll | Tennessee | 47017 | 8926 | 155 |
2323080 | 2323080 | 2022-03-19 | Carter | Tennessee | 47019 | 16416 | 323 |
2323081 | 2323081 | 2022-03-19 | Cheatham | Tennessee | 47021 | 10883 | 118 |
2323082 | 2323082 | 2022-03-19 | Chester | Tennessee | 47023 | 5798 | 96 |
2323083 | 2323083 | 2022-03-19 | Claiborne | Tennessee | 47025 | 9070 | 175 |
2323084 | 2323084 | 2022-03-19 | Clay | Tennessee | 47027 | 2223 | 49 |
2323085 | 2323085 | 2022-03-19 | Cocke | Tennessee | 47029 | 11534 | 207 |
2323086 | 2323086 | 2022-03-19 | Coffee | Tennessee | 47031 | 16916 | 255 |
2323087 | 2323087 | 2022-03-19 | Crockett | Tennessee | 47033 | 5169 | 82 |
2323088 | 2323088 | 2022-03-19 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2323089 | 2323089 | 2022-03-19 | Davidson | Tennessee | 47037 | 206615 | 1623 |
2323090 | 2323090 | 2022-03-19 | DeKalb | Tennessee | 47041 | 6272 | 99 |
2323091 | 2323091 | 2022-03-19 | Decatur | Tennessee | 47039 | 3725 | 67 |
2323092 | 2323092 | 2022-03-19 | Dickson | Tennessee | 47043 | 15842 | 239 |
2323093 | 2323093 | 2022-03-19 | Dyer | Tennessee | 47045 | 12737 | 198 |
2323094 | 2323094 | 2022-03-19 | Fayette | Tennessee | 47047 | 11393 | 177 |
2323095 | 2323095 | 2022-03-19 | Fentress | Tennessee | 47049 | 5686 | 123 |
2323096 | 2323096 | 2022-03-19 | Franklin | Tennessee | 47051 | 12815 | 173 |
2323097 | 2323097 | 2022-03-19 | Gibson | Tennessee | 47053 | 17339 | 254 |
2323098 | 2323098 | 2022-03-19 | Giles | Tennessee | 47055 | 9390 | 185 |
2323099 | 2323099 | 2022-03-19 | Grainger | Tennessee | 47057 | 6754 | 106 |
2323100 | 2323100 | 2022-03-19 | Greene | Tennessee | 47059 | 21992 | 360 |
2323101 | 2323101 | 2022-03-19 | Grundy | Tennessee | 47061 | 3979 | 70 |
2323102 | 2323102 | 2022-03-19 | Hamblen | Tennessee | 47063 | 19671 | 346 |
2323103 | 2323103 | 2022-03-19 | Hamilton | Tennessee | 47065 | 99400 | 1113 |
2323104 | 2323104 | 2022-03-19 | Hancock | Tennessee | 47067 | 2001 | 34 |
2323105 | 2323105 | 2022-03-19 | Hardeman | Tennessee | 47069 | 7578 | 116 |
2323106 | 2323106 | 2022-03-19 | Hardin | Tennessee | 47071 | 8717 | 140 |
2323107 | 2323107 | 2022-03-19 | Hawkins | Tennessee | 47073 | 16585 | 299 |
2323108 | 2323108 | 2022-03-19 | Haywood | Tennessee | 47075 | 6147 | 99 |
2323109 | 2323109 | 2022-03-19 | Henderson | Tennessee | 47077 | 9087 | 153 |
2323110 | 2323110 | 2022-03-19 | Henry | Tennessee | 47079 | 8237 | 154 |
2323111 | 2323111 | 2022-03-19 | Hickman | Tennessee | 47081 | 6811 | 108 |
2323112 | 2323112 | 2022-03-19 | Houston | Tennessee | 47083 | 2672 | 60 |
2323113 | 2323113 | 2022-03-19 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2323114 | 2323114 | 2022-03-19 | Jackson | Tennessee | 47087 | 3200 | 62 |
2323115 | 2323115 | 2022-03-19 | Jefferson | Tennessee | 47089 | 15674 | 257 |
2323116 | 2323116 | 2022-03-19 | Johnson | Tennessee | 47091 | 5132 | 88 |
2323117 | 2323117 | 2022-03-19 | Knox | Tennessee | 47093 | 127369 | 1318 |
2323118 | 2323118 | 2022-03-19 | Lake | Tennessee | 47095 | 2736 | 40 |
2323119 | 2323119 | 2022-03-19 | Lauderdale | Tennessee | 47097 | 7729 | 103 |
2323120 | 2323120 | 2022-03-19 | Lawrence | Tennessee | 47099 | 14249 | 190 |
2323121 | 2323121 | 2022-03-19 | Lewis | Tennessee | 47101 | 3568 | 56 |
2323122 | 2323122 | 2022-03-19 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2323123 | 2323123 | 2022-03-19 | Loudon | Tennessee | 47105 | 14399 | 187 |
2323124 | 2323124 | 2022-03-19 | Macon | Tennessee | 47111 | 8417 | 142 |
2323125 | 2323125 | 2022-03-19 | Madison | Tennessee | 47113 | 29729 | 415 |
2323126 | 2323126 | 2022-03-19 | Marion | Tennessee | 47115 | 8821 | 127 |
2323127 | 2323127 | 2022-03-19 | Marshall | Tennessee | 47117 | 10343 | 117 |
2323128 | 2323128 | 2022-03-19 | Maury | Tennessee | 47119 | 28852 | 327 |
2323129 | 2323129 | 2022-03-19 | McMinn | Tennessee | 47107 | 16646 | 250 |
2323130 | 2323130 | 2022-03-19 | McNairy | Tennessee | 47109 | 7627 | 117 |
2323131 | 2323131 | 2022-03-19 | Meigs | Tennessee | 47121 | 3349 | 55 |
2323132 | 2323132 | 2022-03-19 | Monroe | Tennessee | 47123 | 14460 | 233 |
2323133 | 2323133 | 2022-03-19 | Montgomery | Tennessee | 47125 | 50043 | 556 |
2323134 | 2323134 | 2022-03-19 | Moore | Tennessee | 47127 | 2236 | 40 |
2323135 | 2323135 | 2022-03-19 | Morgan | Tennessee | 47129 | 6151 | 80 |
2323136 | 2323136 | 2022-03-19 | Obion | Tennessee | 47131 | 10750 | 185 |
2323137 | 2323137 | 2022-03-19 | Overton | Tennessee | 47133 | 7145 | 120 |
2323138 | 2323138 | 2022-03-19 | Perry | Tennessee | 47135 | 2327 | 54 |
2323139 | 2323139 | 2022-03-19 | Pickett | Tennessee | 47137 | 1764 | 36 |
2323140 | 2323140 | 2022-03-19 | Polk | Tennessee | 47139 | 4715 | 68 |
2323141 | 2323141 | 2022-03-19 | Putnam | Tennessee | 47141 | 25056 | 301 |
2323142 | 2323142 | 2022-03-19 | Rhea | Tennessee | 47143 | 9941 | 153 |
2323143 | 2323143 | 2022-03-19 | Roane | Tennessee | 47145 | 15740 | 228 |
2323144 | 2323144 | 2022-03-19 | Robertson | Tennessee | 47147 | 21488 | 295 |
2323145 | 2323145 | 2022-03-19 | Rutherford | Tennessee | 47149 | 95446 | 875 |
2323146 | 2323146 | 2022-03-19 | Scott | Tennessee | 47151 | 9018 | 112 |
2323147 | 2323147 | 2022-03-19 | Sequatchie | Tennessee | 47153 | 4200 | 66 |
2323148 | 2323148 | 2022-03-19 | Sevier | Tennessee | 47155 | 30214 | 398 |
2323149 | 2323149 | 2022-03-19 | Shelby | Tennessee | 47157 | 237393 | 3219 |
2323150 | 2323150 | 2022-03-19 | Smith | Tennessee | 47159 | 6159 | 80 |
2323151 | 2323151 | 2022-03-19 | Stewart | Tennessee | 47161 | 3281 | 55 |
2323152 | 2323152 | 2022-03-19 | Sullivan | Tennessee | 47163 | 45622 | 688 |
2323153 | 2323153 | 2022-03-19 | Sumner | Tennessee | 47165 | 53026 | 707 |
2323154 | 2323154 | 2022-03-19 | Tipton | Tennessee | 47167 | 17578 | 230 |
2323155 | 2323155 | 2022-03-19 | Trousdale | Tennessee | 47169 | 4208 | 45 |
2323156 | 2323156 | 2022-03-19 | Unicoi | Tennessee | 47171 | 5147 | 93 |
2323157 | 2323157 | 2022-03-19 | Union | Tennessee | 47173 | 5392 | 72 |
2323158 | 2323158 | 2022-03-19 | Unknown | Tennessee | 19378 | 423 | |
2323159 | 2323159 | 2022-03-19 | Van Buren | Tennessee | 47175 | 1845 | 47 |
2323160 | 2323160 | 2022-03-19 | Warren | Tennessee | 47177 | 12975 | 174 |
2323161 | 2323161 | 2022-03-19 | Washington | Tennessee | 47179 | 38408 | 482 |
2323162 | 2323162 | 2022-03-19 | Wayne | Tennessee | 47181 | 5682 | 62 |
2323163 | 2323163 | 2022-03-19 | Weakley | Tennessee | 47183 | 9489 | 140 |
2323164 | 2323164 | 2022-03-19 | White | Tennessee | 47185 | 8221 | 126 |
2323165 | 2323165 | 2022-03-19 | Williamson | Tennessee | 47187 | 61783 | 393 |
2323166 | 2323166 | 2022-03-19 | Wilson | Tennessee | 47189 | 41503 | 471 |
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);