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-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 |
---|---|---|---|---|---|---|---|
1137184 | 1137184 | 2021-03-19 | Anderson | Tennessee | 47001 | 8334 | 160 |
1137185 | 1137185 | 2021-03-19 | Bedford | Tennessee | 47003 | 6030 | 123 |
1137186 | 1137186 | 2021-03-19 | Benton | Tennessee | 47005 | 1540 | 39 |
1137187 | 1137187 | 2021-03-19 | Bledsoe | Tennessee | 47007 | 2047 | 10 |
1137188 | 1137188 | 2021-03-19 | Blount | Tennessee | 47009 | 14498 | 189 |
1137189 | 1137189 | 2021-03-19 | Bradley | Tennessee | 47011 | 13655 | 142 |
1137190 | 1137190 | 2021-03-19 | Campbell | Tennessee | 47013 | 3955 | 59 |
1137191 | 1137191 | 2021-03-19 | Cannon | Tennessee | 47015 | 1826 | 31 |
1137192 | 1137192 | 2021-03-19 | Carroll | Tennessee | 47017 | 3520 | 81 |
1137193 | 1137193 | 2021-03-19 | Carter | Tennessee | 47019 | 6083 | 155 |
1137194 | 1137194 | 2021-03-19 | Cheatham | Tennessee | 47021 | 4130 | 47 |
1137195 | 1137195 | 2021-03-19 | Chester | Tennessee | 47023 | 2056 | 48 |
1137196 | 1137196 | 2021-03-19 | Claiborne | Tennessee | 47025 | 2927 | 71 |
1137197 | 1137197 | 2021-03-19 | Clay | Tennessee | 47027 | 1074 | 31 |
1137198 | 1137198 | 2021-03-19 | Cocke | Tennessee | 47029 | 4234 | 96 |
1137199 | 1137199 | 2021-03-19 | Coffee | Tennessee | 47031 | 6593 | 117 |
1137200 | 1137200 | 2021-03-19 | Crockett | Tennessee | 47033 | 1975 | 48 |
1137201 | 1137201 | 2021-03-19 | Cumberland | Tennessee | 47035 | 6243 | 123 |
1137202 | 1137202 | 2021-03-19 | Davidson | Tennessee | 47037 | 92607 | 881 |
1137203 | 1137203 | 2021-03-19 | DeKalb | Tennessee | 47041 | 2701 | 52 |
1137204 | 1137204 | 2021-03-19 | Decatur | Tennessee | 47039 | 1555 | 37 |
1137205 | 1137205 | 2021-03-19 | Dickson | Tennessee | 47043 | 6407 | 107 |
1137206 | 1137206 | 2021-03-19 | Dyer | Tennessee | 47045 | 5291 | 103 |
1137207 | 1137207 | 2021-03-19 | Fayette | Tennessee | 47047 | 4756 | 75 |
1137208 | 1137208 | 2021-03-19 | Fentress | Tennessee | 47049 | 2328 | 45 |
1137209 | 1137209 | 2021-03-19 | Franklin | Tennessee | 47051 | 4890 | 87 |
1137210 | 1137210 | 2021-03-19 | Gibson | Tennessee | 47053 | 6249 | 141 |
1137211 | 1137211 | 2021-03-19 | Giles | Tennessee | 47055 | 3807 | 98 |
1137212 | 1137212 | 2021-03-19 | Grainger | Tennessee | 47057 | 2489 | 47 |
1137213 | 1137213 | 2021-03-19 | Greene | Tennessee | 47059 | 7402 | 149 |
1137214 | 1137214 | 2021-03-19 | Grundy | Tennessee | 47061 | 1725 | 30 |
1137215 | 1137215 | 2021-03-19 | Hamblen | Tennessee | 47063 | 8245 | 169 |
1137216 | 1137216 | 2021-03-19 | Hamilton | Tennessee | 47065 | 41878 | 469 |
1137217 | 1137217 | 2021-03-19 | Hancock | Tennessee | 47067 | 515 | 12 |
1137218 | 1137218 | 2021-03-19 | Hardeman | Tennessee | 47069 | 3412 | 63 |
1137219 | 1137219 | 2021-03-19 | Hardin | Tennessee | 47071 | 3358 | 64 |
1137220 | 1137220 | 2021-03-19 | Hawkins | Tennessee | 47073 | 5417 | 102 |
1137221 | 1137221 | 2021-03-19 | Haywood | Tennessee | 47075 | 2663 | 60 |
1137222 | 1137222 | 2021-03-19 | Henderson | Tennessee | 47077 | 3647 | 74 |
1137223 | 1137223 | 2021-03-19 | Henry | Tennessee | 47079 | 3052 | 76 |
1137224 | 1137224 | 2021-03-19 | Hickman | Tennessee | 47081 | 2723 | 43 |
1137225 | 1137225 | 2021-03-19 | Houston | Tennessee | 47083 | 1048 | 33 |
1137226 | 1137226 | 2021-03-19 | Humphreys | Tennessee | 47085 | 1589 | 21 |
1137227 | 1137227 | 2021-03-19 | Jackson | Tennessee | 47087 | 1270 | 35 |
1137228 | 1137228 | 2021-03-19 | Jefferson | Tennessee | 47089 | 5850 | 121 |
1137229 | 1137229 | 2021-03-19 | Johnson | Tennessee | 47091 | 2194 | 38 |
1137230 | 1137230 | 2021-03-19 | Knox | Tennessee | 47093 | 48446 | 602 |
1137231 | 1137231 | 2021-03-19 | Lake | Tennessee | 47095 | 1683 | 26 |
1137232 | 1137232 | 2021-03-19 | Lauderdale | Tennessee | 47097 | 3105 | 44 |
1137233 | 1137233 | 2021-03-19 | Lawrence | Tennessee | 47099 | 5626 | 86 |
1137234 | 1137234 | 2021-03-19 | Lewis | Tennessee | 47101 | 1492 | 25 |
1137235 | 1137235 | 2021-03-19 | Lincoln | Tennessee | 47103 | 4201 | 62 |
1137236 | 1137236 | 2021-03-19 | Loudon | Tennessee | 47105 | 5830 | 68 |
1137237 | 1137237 | 2021-03-19 | Macon | Tennessee | 47111 | 3420 | 74 |
1137238 | 1137238 | 2021-03-19 | Madison | Tennessee | 47113 | 10289 | 236 |
1137239 | 1137239 | 2021-03-19 | Marion | Tennessee | 47115 | 3020 | 45 |
1137240 | 1137240 | 2021-03-19 | Marshall | Tennessee | 47117 | 3981 | 57 |
1137241 | 1137241 | 2021-03-19 | Maury | Tennessee | 47119 | 12486 | 162 |
1137242 | 1137242 | 2021-03-19 | McMinn | Tennessee | 47107 | 6093 | 94 |
1137243 | 1137243 | 2021-03-19 | McNairy | Tennessee | 47109 | 2716 | 53 |
1137244 | 1137244 | 2021-03-19 | Meigs | Tennessee | 47121 | 1287 | 23 |
1137245 | 1137245 | 2021-03-19 | Monroe | Tennessee | 47123 | 5499 | 93 |
1137246 | 1137246 | 2021-03-19 | Montgomery | Tennessee | 47125 | 17951 | 214 |
1137247 | 1137247 | 2021-03-19 | Moore | Tennessee | 47127 | 959 | 17 |
1137248 | 1137248 | 2021-03-19 | Morgan | Tennessee | 47129 | 2348 | 38 |
1137249 | 1137249 | 2021-03-19 | Obion | Tennessee | 47131 | 4403 | 95 |
1137250 | 1137250 | 2021-03-19 | Overton | Tennessee | 47133 | 2899 | 58 |
1137251 | 1137251 | 2021-03-19 | Perry | Tennessee | 47135 | 1048 | 28 |
1137252 | 1137252 | 2021-03-19 | Pickett | Tennessee | 47137 | 751 | 23 |
1137253 | 1137253 | 2021-03-19 | Polk | Tennessee | 47139 | 1868 | 24 |
1137254 | 1137254 | 2021-03-19 | Putnam | Tennessee | 47141 | 10841 | 172 |
1137255 | 1137255 | 2021-03-19 | Rhea | Tennessee | 47143 | 4213 | 75 |
1137256 | 1137256 | 2021-03-19 | Roane | Tennessee | 47145 | 6031 | 97 |
1137257 | 1137257 | 2021-03-19 | Robertson | Tennessee | 47147 | 9204 | 124 |
1137258 | 1137258 | 2021-03-19 | Rutherford | Tennessee | 47149 | 39910 | 398 |
1137259 | 1137259 | 2021-03-19 | Scott | Tennessee | 47151 | 2937 | 44 |
1137260 | 1137260 | 2021-03-19 | Sequatchie | Tennessee | 47153 | 1606 | 26 |
1137261 | 1137261 | 2021-03-19 | Sevier | Tennessee | 47155 | 12553 | 166 |
1137262 | 1137262 | 2021-03-19 | Shelby | Tennessee | 47157 | 89960 | 1544 |
1137263 | 1137263 | 2021-03-19 | Smith | Tennessee | 47159 | 2635 | 36 |
1137264 | 1137264 | 2021-03-19 | Stewart | Tennessee | 47161 | 1265 | 25 |
1137265 | 1137265 | 2021-03-19 | Sullivan | Tennessee | 47163 | 14983 | 279 |
1137266 | 1137266 | 2021-03-19 | Sumner | Tennessee | 47165 | 22074 | 327 |
1137267 | 1137267 | 2021-03-19 | Tipton | Tennessee | 47167 | 7062 | 104 |
1137268 | 1137268 | 2021-03-19 | Trousdale | Tennessee | 47169 | 2429 | 22 |
1137269 | 1137269 | 2021-03-19 | Unicoi | Tennessee | 47171 | 1849 | 47 |
1137270 | 1137270 | 2021-03-19 | Union | Tennessee | 47173 | 1790 | 34 |
1137271 | 1137271 | 2021-03-19 | Unknown | Tennessee | 8837 | 121 | |
1137272 | 1137272 | 2021-03-19 | Van Buren | Tennessee | 47175 | 807 | 20 |
1137273 | 1137273 | 2021-03-19 | Warren | Tennessee | 47177 | 5386 | 79 |
1137274 | 1137274 | 2021-03-19 | Washington | Tennessee | 47179 | 13112 | 235 |
1137275 | 1137275 | 2021-03-19 | Wayne | Tennessee | 47181 | 2918 | 31 |
1137276 | 1137276 | 2021-03-19 | Weakley | Tennessee | 47183 | 3857 | 60 |
1137277 | 1137277 | 2021-03-19 | White | Tennessee | 47185 | 3442 | 67 |
1137278 | 1137278 | 2021-03-19 | Williamson | Tennessee | 47187 | 26058 | 210 |
1137279 | 1137279 | 2021-03-19 | Wilson | Tennessee | 47189 | 17172 | 214 |
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);