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-07-11 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324363 | 324363 | 2020-07-11 | Anderson | Tennessee | 47001 | 195 | 2 |
324364 | 324364 | 2020-07-11 | Bedford | Tennessee | 47003 | 623 | 9 |
324365 | 324365 | 2020-07-11 | Benton | Tennessee | 47005 | 15 | 1 |
324366 | 324366 | 2020-07-11 | Bledsoe | Tennessee | 47007 | 629 | 1 |
324367 | 324367 | 2020-07-11 | Blount | Tennessee | 47009 | 340 | 3 |
324368 | 324368 | 2020-07-11 | Bradley | Tennessee | 47011 | 959 | 4 |
324369 | 324369 | 2020-07-11 | Campbell | Tennessee | 47013 | 69 | 1 |
324370 | 324370 | 2020-07-11 | Cannon | Tennessee | 47015 | 49 | 0 |
324371 | 324371 | 2020-07-11 | Carroll | Tennessee | 47017 | 52 | 1 |
324372 | 324372 | 2020-07-11 | Carter | Tennessee | 47019 | 103 | 1 |
324373 | 324373 | 2020-07-11 | Cheatham | Tennessee | 47021 | 269 | 3 |
324374 | 324374 | 2020-07-11 | Chester | Tennessee | 47023 | 63 | 0 |
324375 | 324375 | 2020-07-11 | Claiborne | Tennessee | 47025 | 68 | 0 |
324376 | 324376 | 2020-07-11 | Clay | Tennessee | 47027 | 20 | 0 |
324377 | 324377 | 2020-07-11 | Cocke | Tennessee | 47029 | 136 | 0 |
324378 | 324378 | 2020-07-11 | Coffee | Tennessee | 47031 | 141 | 0 |
324379 | 324379 | 2020-07-11 | Crockett | Tennessee | 47033 | 52 | 3 |
324380 | 324380 | 2020-07-11 | Cumberland | Tennessee | 47035 | 213 | 4 |
324381 | 324381 | 2020-07-11 | Davidson | Tennessee | 47037 | 14319 | 143 |
324382 | 324382 | 2020-07-11 | DeKalb | Tennessee | 47041 | 85 | 0 |
324383 | 324383 | 2020-07-11 | Decatur | Tennessee | 47039 | 27 | 0 |
324384 | 324384 | 2020-07-11 | Dickson | Tennessee | 47043 | 258 | 0 |
324385 | 324385 | 2020-07-11 | Dyer | Tennessee | 47045 | 291 | 3 |
324386 | 324386 | 2020-07-11 | Fayette | Tennessee | 47047 | 368 | 5 |
324387 | 324387 | 2020-07-11 | Fentress | Tennessee | 47049 | 26 | 0 |
324388 | 324388 | 2020-07-11 | Franklin | Tennessee | 47051 | 116 | 3 |
324389 | 324389 | 2020-07-11 | Gibson | Tennessee | 47053 | 177 | 1 |
324390 | 324390 | 2020-07-11 | Giles | Tennessee | 47055 | 103 | 1 |
324391 | 324391 | 2020-07-11 | Grainger | Tennessee | 47057 | 56 | 0 |
324392 | 324392 | 2020-07-11 | Greene | Tennessee | 47059 | 151 | 2 |
324393 | 324393 | 2020-07-11 | Grundy | Tennessee | 47061 | 65 | 2 |
324394 | 324394 | 2020-07-11 | Hamblen | Tennessee | 47063 | 472 | 4 |
324395 | 324395 | 2020-07-11 | Hamilton | Tennessee | 47065 | 3361 | 38 |
324396 | 324396 | 2020-07-11 | Hancock | Tennessee | 47067 | 11 | 0 |
324397 | 324397 | 2020-07-11 | Hardeman | Tennessee | 47069 | 411 | 4 |
324398 | 324398 | 2020-07-11 | Hardin | Tennessee | 47071 | 125 | 7 |
324399 | 324399 | 2020-07-11 | Hawkins | Tennessee | 47073 | 86 | 2 |
324400 | 324400 | 2020-07-11 | Haywood | Tennessee | 47075 | 118 | 3 |
324401 | 324401 | 2020-07-11 | Henderson | Tennessee | 47077 | 71 | 0 |
324402 | 324402 | 2020-07-11 | Henry | Tennessee | 47079 | 51 | 0 |
324403 | 324403 | 2020-07-11 | Hickman | Tennessee | 47081 | 103 | 0 |
324404 | 324404 | 2020-07-11 | Houston | Tennessee | 47083 | 20 | 0 |
324405 | 324405 | 2020-07-11 | Humphreys | Tennessee | 47085 | 39 | 2 |
324406 | 324406 | 2020-07-11 | Jackson | Tennessee | 47087 | 47 | 0 |
324407 | 324407 | 2020-07-11 | Jefferson | Tennessee | 47089 | 182 | 1 |
324408 | 324408 | 2020-07-11 | Johnson | Tennessee | 47091 | 46 | 0 |
324409 | 324409 | 2020-07-11 | Knox | Tennessee | 47093 | 1618 | 10 |
324410 | 324410 | 2020-07-11 | Lake | Tennessee | 47095 | 697 | 0 |
324411 | 324411 | 2020-07-11 | Lauderdale | Tennessee | 47097 | 180 | 4 |
324412 | 324412 | 2020-07-11 | Lawrence | Tennessee | 47099 | 232 | 6 |
324413 | 324413 | 2020-07-11 | Lewis | Tennessee | 47101 | 11 | 0 |
324414 | 324414 | 2020-07-11 | Lincoln | Tennessee | 47103 | 86 | 0 |
324415 | 324415 | 2020-07-11 | Loudon | Tennessee | 47105 | 332 | 2 |
324416 | 324416 | 2020-07-11 | Macon | Tennessee | 47111 | 597 | 7 |
324417 | 324417 | 2020-07-11 | Madison | Tennessee | 47113 | 352 | 2 |
324418 | 324418 | 2020-07-11 | Marion | Tennessee | 47115 | 94 | 4 |
324419 | 324419 | 2020-07-11 | Marshall | Tennessee | 47117 | 115 | 2 |
324420 | 324420 | 2020-07-11 | Maury | Tennessee | 47119 | 454 | 3 |
324421 | 324421 | 2020-07-11 | McMinn | Tennessee | 47107 | 276 | 19 |
324422 | 324422 | 2020-07-11 | McNairy | Tennessee | 47109 | 101 | 1 |
324423 | 324423 | 2020-07-11 | Meigs | Tennessee | 47121 | 38 | 0 |
324424 | 324424 | 2020-07-11 | Monroe | Tennessee | 47123 | 155 | 6 |
324425 | 324425 | 2020-07-11 | Montgomery | Tennessee | 47125 | 732 | 7 |
324426 | 324426 | 2020-07-11 | Moore | Tennessee | 47127 | 21 | 0 |
324427 | 324427 | 2020-07-11 | Morgan | Tennessee | 47129 | 31 | 1 |
324428 | 324428 | 2020-07-11 | Obion | Tennessee | 47131 | 119 | 2 |
324429 | 324429 | 2020-07-11 | Overton | Tennessee | 47133 | 72 | 1 |
324430 | 324430 | 2020-07-11 | Perry | Tennessee | 47135 | 37 | 0 |
324431 | 324431 | 2020-07-11 | Pickett | Tennessee | 47137 | 7 | 0 |
324432 | 324432 | 2020-07-11 | Polk | Tennessee | 47139 | 55 | 0 |
324433 | 324433 | 2020-07-11 | Putnam | Tennessee | 47141 | 1011 | 7 |
324434 | 324434 | 2020-07-11 | Rhea | Tennessee | 47143 | 315 | 0 |
324435 | 324435 | 2020-07-11 | Roane | Tennessee | 47145 | 81 | 0 |
324436 | 324436 | 2020-07-11 | Robertson | Tennessee | 47147 | 924 | 13 |
324437 | 324437 | 2020-07-11 | Rutherford | Tennessee | 47149 | 3525 | 39 |
324438 | 324438 | 2020-07-11 | Scott | Tennessee | 47151 | 26 | 0 |
324439 | 324439 | 2020-07-11 | Sequatchie | Tennessee | 47153 | 49 | 0 |
324440 | 324440 | 2020-07-11 | Sevier | Tennessee | 47155 | 915 | 3 |
324441 | 324441 | 2020-07-11 | Shelby | Tennessee | 47157 | 13452 | 223 |
324442 | 324442 | 2020-07-11 | Smith | Tennessee | 47159 | 150 | 2 |
324443 | 324443 | 2020-07-11 | Stewart | Tennessee | 47161 | 26 | 0 |
324444 | 324444 | 2020-07-11 | Sullivan | Tennessee | 47163 | 210 | 4 |
324445 | 324445 | 2020-07-11 | Sumner | Tennessee | 47165 | 1897 | 56 |
324446 | 324446 | 2020-07-11 | Tipton | Tennessee | 47167 | 696 | 7 |
324447 | 324447 | 2020-07-11 | Trousdale | Tennessee | 47169 | 1508 | 5 |
324448 | 324448 | 2020-07-11 | Unicoi | Tennessee | 47171 | 59 | 0 |
324449 | 324449 | 2020-07-11 | Union | Tennessee | 47173 | 25 | 0 |
324450 | 324450 | 2020-07-11 | Unknown | Tennessee | 0 | 1 | |
324451 | 324451 | 2020-07-11 | Van Buren | Tennessee | 47175 | 9 | 0 |
324452 | 324452 | 2020-07-11 | Warren | Tennessee | 47177 | 123 | 0 |
324453 | 324453 | 2020-07-11 | Washington | Tennessee | 47179 | 261 | 0 |
324454 | 324454 | 2020-07-11 | Wayne | Tennessee | 47181 | 115 | 0 |
324455 | 324455 | 2020-07-11 | Weakley | Tennessee | 47183 | 70 | 1 |
324456 | 324456 | 2020-07-11 | White | Tennessee | 47185 | 85 | 3 |
324457 | 324457 | 2020-07-11 | Williamson | Tennessee | 47187 | 1708 | 16 |
324458 | 324458 | 2020-07-11 | Wilson | Tennessee | 47189 | 1148 | 17 |
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);