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-12 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2300301 | 2300301 | 2022-03-12 | Anderson | Tennessee | 47001 | 21942 | 312 |
2300302 | 2300302 | 2022-03-12 | Bedford | Tennessee | 47003 | 14906 | 221 |
2300303 | 2300303 | 2022-03-12 | Benton | Tennessee | 47005 | 4453 | 90 |
2300304 | 2300304 | 2022-03-12 | Bledsoe | Tennessee | 47007 | 4645 | 53 |
2300305 | 2300305 | 2022-03-12 | Blount | Tennessee | 47009 | 38940 | 399 |
2300306 | 2300306 | 2022-03-12 | Bradley | Tennessee | 47011 | 33031 | 387 |
2300307 | 2300307 | 2022-03-12 | Campbell | Tennessee | 47013 | 12010 | 153 |
2300308 | 2300308 | 2022-03-12 | Cannon | Tennessee | 47015 | 4170 | 56 |
2300309 | 2300309 | 2022-03-12 | Carroll | Tennessee | 47017 | 8914 | 150 |
2300310 | 2300310 | 2022-03-12 | Carter | Tennessee | 47019 | 16377 | 316 |
2300311 | 2300311 | 2022-03-12 | Cheatham | Tennessee | 47021 | 10876 | 117 |
2300312 | 2300312 | 2022-03-12 | Chester | Tennessee | 47023 | 5768 | 94 |
2300313 | 2300313 | 2022-03-12 | Claiborne | Tennessee | 47025 | 9027 | 167 |
2300314 | 2300314 | 2022-03-12 | Clay | Tennessee | 47027 | 2219 | 47 |
2300315 | 2300315 | 2022-03-12 | Cocke | Tennessee | 47029 | 11508 | 201 |
2300316 | 2300316 | 2022-03-12 | Coffee | Tennessee | 47031 | 16894 | 250 |
2300317 | 2300317 | 2022-03-12 | Crockett | Tennessee | 47033 | 5150 | 82 |
2300318 | 2300318 | 2022-03-12 | Cumberland | Tennessee | 47035 | 16042 | 310 |
2300319 | 2300319 | 2022-03-12 | Davidson | Tennessee | 47037 | 206359 | 1601 |
2300320 | 2300320 | 2022-03-12 | DeKalb | Tennessee | 47041 | 6268 | 97 |
2300321 | 2300321 | 2022-03-12 | Decatur | Tennessee | 47039 | 3715 | 64 |
2300322 | 2300322 | 2022-03-12 | Dickson | Tennessee | 47043 | 15826 | 235 |
2300323 | 2300323 | 2022-03-12 | Dyer | Tennessee | 47045 | 12720 | 192 |
2300324 | 2300324 | 2022-03-12 | Fayette | Tennessee | 47047 | 11387 | 171 |
2300325 | 2300325 | 2022-03-12 | Fentress | Tennessee | 47049 | 5681 | 117 |
2300326 | 2300326 | 2022-03-12 | Franklin | Tennessee | 47051 | 12802 | 165 |
2300327 | 2300327 | 2022-03-12 | Gibson | Tennessee | 47053 | 17286 | 252 |
2300328 | 2300328 | 2022-03-12 | Giles | Tennessee | 47055 | 9382 | 172 |
2300329 | 2300329 | 2022-03-12 | Grainger | Tennessee | 47057 | 6747 | 103 |
2300330 | 2300330 | 2022-03-12 | Greene | Tennessee | 47059 | 21952 | 353 |
2300331 | 2300331 | 2022-03-12 | Grundy | Tennessee | 47061 | 3974 | 69 |
2300332 | 2300332 | 2022-03-12 | Hamblen | Tennessee | 47063 | 19651 | 345 |
2300333 | 2300333 | 2022-03-12 | Hamilton | Tennessee | 47065 | 99176 | 1082 |
2300334 | 2300334 | 2022-03-12 | Hancock | Tennessee | 47067 | 1998 | 32 |
2300335 | 2300335 | 2022-03-12 | Hardeman | Tennessee | 47069 | 7550 | 113 |
2300336 | 2300336 | 2022-03-12 | Hardin | Tennessee | 47071 | 8695 | 137 |
2300337 | 2300337 | 2022-03-12 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2300338 | 2300338 | 2022-03-12 | Haywood | Tennessee | 47075 | 6131 | 97 |
2300339 | 2300339 | 2022-03-12 | Henderson | Tennessee | 47077 | 9035 | 147 |
2300340 | 2300340 | 2022-03-12 | Henry | Tennessee | 47079 | 8221 | 148 |
2300341 | 2300341 | 2022-03-12 | Hickman | Tennessee | 47081 | 6808 | 104 |
2300342 | 2300342 | 2022-03-12 | Houston | Tennessee | 47083 | 2667 | 59 |
2300343 | 2300343 | 2022-03-12 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2300344 | 2300344 | 2022-03-12 | Jackson | Tennessee | 47087 | 3199 | 60 |
2300345 | 2300345 | 2022-03-12 | Jefferson | Tennessee | 47089 | 15650 | 255 |
2300346 | 2300346 | 2022-03-12 | Johnson | Tennessee | 47091 | 5131 | 87 |
2300347 | 2300347 | 2022-03-12 | Knox | Tennessee | 47093 | 127157 | 1298 |
2300348 | 2300348 | 2022-03-12 | Lake | Tennessee | 47095 | 2733 | 40 |
2300349 | 2300349 | 2022-03-12 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2300350 | 2300350 | 2022-03-12 | Lawrence | Tennessee | 47099 | 14241 | 187 |
2300351 | 2300351 | 2022-03-12 | Lewis | Tennessee | 47101 | 3567 | 50 |
2300352 | 2300352 | 2022-03-12 | Lincoln | Tennessee | 47103 | 9949 | 157 |
2300353 | 2300353 | 2022-03-12 | Loudon | Tennessee | 47105 | 14363 | 186 |
2300354 | 2300354 | 2022-03-12 | Macon | Tennessee | 47111 | 8405 | 138 |
2300355 | 2300355 | 2022-03-12 | Madison | Tennessee | 47113 | 29657 | 411 |
2300356 | 2300356 | 2022-03-12 | Marion | Tennessee | 47115 | 8810 | 124 |
2300357 | 2300357 | 2022-03-12 | Marshall | Tennessee | 47117 | 10334 | 116 |
2300358 | 2300358 | 2022-03-12 | Maury | Tennessee | 47119 | 28815 | 320 |
2300359 | 2300359 | 2022-03-12 | McMinn | Tennessee | 47107 | 16630 | 240 |
2300360 | 2300360 | 2022-03-12 | McNairy | Tennessee | 47109 | 7608 | 113 |
2300361 | 2300361 | 2022-03-12 | Meigs | Tennessee | 47121 | 3347 | 54 |
2300362 | 2300362 | 2022-03-12 | Monroe | Tennessee | 47123 | 14442 | 217 |
2300363 | 2300363 | 2022-03-12 | Montgomery | Tennessee | 47125 | 49919 | 550 |
2300364 | 2300364 | 2022-03-12 | Moore | Tennessee | 47127 | 2235 | 39 |
2300365 | 2300365 | 2022-03-12 | Morgan | Tennessee | 47129 | 6145 | 78 |
2300366 | 2300366 | 2022-03-12 | Obion | Tennessee | 47131 | 10742 | 179 |
2300367 | 2300367 | 2022-03-12 | Overton | Tennessee | 47133 | 7139 | 120 |
2300368 | 2300368 | 2022-03-12 | Perry | Tennessee | 47135 | 2327 | 48 |
2300369 | 2300369 | 2022-03-12 | Pickett | Tennessee | 47137 | 1763 | 31 |
2300370 | 2300370 | 2022-03-12 | Polk | Tennessee | 47139 | 4711 | 65 |
2300371 | 2300371 | 2022-03-12 | Putnam | Tennessee | 47141 | 25037 | 295 |
2300372 | 2300372 | 2022-03-12 | Rhea | Tennessee | 47143 | 9936 | 148 |
2300373 | 2300373 | 2022-03-12 | Roane | Tennessee | 47145 | 15712 | 225 |
2300374 | 2300374 | 2022-03-12 | Robertson | Tennessee | 47147 | 21471 | 290 |
2300375 | 2300375 | 2022-03-12 | Rutherford | Tennessee | 47149 | 95362 | 865 |
2300376 | 2300376 | 2022-03-12 | Scott | Tennessee | 47151 | 8987 | 111 |
2300377 | 2300377 | 2022-03-12 | Sequatchie | Tennessee | 47153 | 4194 | 66 |
2300378 | 2300378 | 2022-03-12 | Sevier | Tennessee | 47155 | 30156 | 393 |
2300379 | 2300379 | 2022-03-12 | Shelby | Tennessee | 47157 | 237234 | 3189 |
2300380 | 2300380 | 2022-03-12 | Smith | Tennessee | 47159 | 6154 | 76 |
2300381 | 2300381 | 2022-03-12 | Stewart | Tennessee | 47161 | 3280 | 52 |
2300382 | 2300382 | 2022-03-12 | Sullivan | Tennessee | 47163 | 45533 | 670 |
2300383 | 2300383 | 2022-03-12 | Sumner | Tennessee | 47165 | 52955 | 688 |
2300384 | 2300384 | 2022-03-12 | Tipton | Tennessee | 47167 | 17564 | 221 |
2300385 | 2300385 | 2022-03-12 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2300386 | 2300386 | 2022-03-12 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2300387 | 2300387 | 2022-03-12 | Union | Tennessee | 47173 | 5382 | 70 |
2300388 | 2300388 | 2022-03-12 | Unknown | Tennessee | 20141 | 545 | |
2300389 | 2300389 | 2022-03-12 | Van Buren | Tennessee | 47175 | 1845 | 46 |
2300390 | 2300390 | 2022-03-12 | Warren | Tennessee | 47177 | 12970 | 167 |
2300391 | 2300391 | 2022-03-12 | Washington | Tennessee | 47179 | 38342 | 471 |
2300392 | 2300392 | 2022-03-12 | Wayne | Tennessee | 47181 | 5672 | 60 |
2300393 | 2300393 | 2022-03-12 | Weakley | Tennessee | 47183 | 9474 | 138 |
2300394 | 2300394 | 2022-03-12 | White | Tennessee | 47185 | 8216 | 126 |
2300395 | 2300395 | 2022-03-12 | Williamson | Tennessee | 47187 | 61684 | 386 |
2300396 | 2300396 | 2022-03-12 | Wilson | Tennessee | 47189 | 41449 | 465 |
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);