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-01-18 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
942434 | 942434 | 2021-01-18 | Anderson | Tennessee | 47001 | 6792 | 103 |
942435 | 942435 | 2021-01-18 | Bedford | Tennessee | 47003 | 5325 | 89 |
942436 | 942436 | 2021-01-18 | Benton | Tennessee | 47005 | 1321 | 35 |
942437 | 942437 | 2021-01-18 | Bledsoe | Tennessee | 47007 | 1742 | 10 |
942438 | 942438 | 2021-01-18 | Blount | Tennessee | 47009 | 11914 | 125 |
942439 | 942439 | 2021-01-18 | Bradley | Tennessee | 47011 | 10791 | 91 |
942440 | 942440 | 2021-01-18 | Campbell | Tennessee | 47013 | 3245 | 40 |
942441 | 942441 | 2021-01-18 | Cannon | Tennessee | 47015 | 1577 | 19 |
942442 | 942442 | 2021-01-18 | Carroll | Tennessee | 47017 | 3104 | 59 |
942443 | 942443 | 2021-01-18 | Carter | Tennessee | 47019 | 5109 | 112 |
942444 | 942444 | 2021-01-18 | Cheatham | Tennessee | 47021 | 3362 | 30 |
942445 | 942445 | 2021-01-18 | Chester | Tennessee | 47023 | 1738 | 37 |
942446 | 942446 | 2021-01-18 | Claiborne | Tennessee | 47025 | 2127 | 29 |
942447 | 942447 | 2021-01-18 | Clay | Tennessee | 47027 | 939 | 26 |
942448 | 942448 | 2021-01-18 | Cocke | Tennessee | 47029 | 3438 | 56 |
942449 | 942449 | 2021-01-18 | Coffee | Tennessee | 47031 | 5628 | 82 |
942450 | 942450 | 2021-01-18 | Crockett | Tennessee | 47033 | 1807 | 38 |
942451 | 942451 | 2021-01-18 | Cumberland | Tennessee | 47035 | 5400 | 72 |
942452 | 942452 | 2021-01-18 | Davidson | Tennessee | 47037 | 80154 | 665 |
942453 | 942453 | 2021-01-18 | DeKalb | Tennessee | 47041 | 2423 | 41 |
942454 | 942454 | 2021-01-18 | Decatur | Tennessee | 47039 | 1473 | 26 |
942455 | 942455 | 2021-01-18 | Dickson | Tennessee | 47043 | 5363 | 78 |
942456 | 942456 | 2021-01-18 | Dyer | Tennessee | 47045 | 4749 | 82 |
942457 | 942457 | 2021-01-18 | Fayette | Tennessee | 47047 | 3978 | 51 |
942458 | 942458 | 2021-01-18 | Fentress | Tennessee | 47049 | 2128 | 31 |
942459 | 942459 | 2021-01-18 | Franklin | Tennessee | 47051 | 4121 | 61 |
942460 | 942460 | 2021-01-18 | Gibson | Tennessee | 47053 | 5639 | 111 |
942461 | 942461 | 2021-01-18 | Giles | Tennessee | 47055 | 3217 | 72 |
942462 | 942462 | 2021-01-18 | Grainger | Tennessee | 47057 | 2090 | 35 |
942463 | 942463 | 2021-01-18 | Greene | Tennessee | 47059 | 6598 | 108 |
942464 | 942464 | 2021-01-18 | Grundy | Tennessee | 47061 | 1393 | 21 |
942465 | 942465 | 2021-01-18 | Hamblen | Tennessee | 47063 | 6990 | 109 |
942466 | 942466 | 2021-01-18 | Hamilton | Tennessee | 47065 | 35891 | 327 |
942467 | 942467 | 2021-01-18 | Hancock | Tennessee | 47067 | 405 | 6 |
942468 | 942468 | 2021-01-18 | Hardeman | Tennessee | 47069 | 3094 | 52 |
942469 | 942469 | 2021-01-18 | Hardin | Tennessee | 47071 | 2981 | 47 |
942470 | 942470 | 2021-01-18 | Hawkins | Tennessee | 47073 | 4462 | 68 |
942471 | 942471 | 2021-01-18 | Haywood | Tennessee | 47075 | 2398 | 45 |
942472 | 942472 | 2021-01-18 | Henderson | Tennessee | 47077 | 3330 | 57 |
942473 | 942473 | 2021-01-18 | Henry | Tennessee | 47079 | 2608 | 58 |
942474 | 942474 | 2021-01-18 | Hickman | Tennessee | 47081 | 2235 | 34 |
942475 | 942475 | 2021-01-18 | Houston | Tennessee | 47083 | 939 | 22 |
942476 | 942476 | 2021-01-18 | Humphreys | Tennessee | 47085 | 1328 | 17 |
942477 | 942477 | 2021-01-18 | Jackson | Tennessee | 47087 | 1040 | 21 |
942478 | 942478 | 2021-01-18 | Jefferson | Tennessee | 47089 | 4779 | 75 |
942479 | 942479 | 2021-01-18 | Johnson | Tennessee | 47091 | 2018 | 32 |
942480 | 942480 | 2021-01-18 | Knox | Tennessee | 47093 | 40145 | 407 |
942481 | 942481 | 2021-01-18 | Lake | Tennessee | 47095 | 1555 | 19 |
942482 | 942482 | 2021-01-18 | Lauderdale | Tennessee | 47097 | 2937 | 31 |
942483 | 942483 | 2021-01-18 | Lawrence | Tennessee | 47099 | 5089 | 69 |
942484 | 942484 | 2021-01-18 | Lewis | Tennessee | 47101 | 1275 | 20 |
942485 | 942485 | 2021-01-18 | Lincoln | Tennessee | 47103 | 3794 | 44 |
942486 | 942486 | 2021-01-18 | Loudon | Tennessee | 47105 | 4955 | 50 |
942487 | 942487 | 2021-01-18 | Macon | Tennessee | 47111 | 2888 | 50 |
942488 | 942488 | 2021-01-18 | Madison | Tennessee | 47113 | 9131 | 179 |
942489 | 942489 | 2021-01-18 | Marion | Tennessee | 47115 | 2284 | 31 |
942490 | 942490 | 2021-01-18 | Marshall | Tennessee | 47117 | 3454 | 36 |
942491 | 942491 | 2021-01-18 | Maury | Tennessee | 47119 | 10962 | 123 |
942492 | 942492 | 2021-01-18 | McMinn | Tennessee | 47107 | 5085 | 73 |
942493 | 942493 | 2021-01-18 | McNairy | Tennessee | 47109 | 2386 | 42 |
942494 | 942494 | 2021-01-18 | Meigs | Tennessee | 47121 | 1144 | 16 |
942495 | 942495 | 2021-01-18 | Monroe | Tennessee | 47123 | 4571 | 62 |
942496 | 942496 | 2021-01-18 | Montgomery | Tennessee | 47125 | 14450 | 149 |
942497 | 942497 | 2021-01-18 | Moore | Tennessee | 47127 | 800 | 9 |
942498 | 942498 | 2021-01-18 | Morgan | Tennessee | 47129 | 1890 | 15 |
942499 | 942499 | 2021-01-18 | Obion | Tennessee | 47131 | 3996 | 79 |
942500 | 942500 | 2021-01-18 | Overton | Tennessee | 47133 | 2538 | 43 |
942501 | 942501 | 2021-01-18 | Perry | Tennessee | 47135 | 947 | 25 |
942502 | 942502 | 2021-01-18 | Pickett | Tennessee | 47137 | 679 | 19 |
942503 | 942503 | 2021-01-18 | Polk | Tennessee | 47139 | 1436 | 17 |
942504 | 942504 | 2021-01-18 | Putnam | Tennessee | 47141 | 9952 | 136 |
942505 | 942505 | 2021-01-18 | Rhea | Tennessee | 47143 | 3824 | 56 |
942506 | 942506 | 2021-01-18 | Roane | Tennessee | 47145 | 5212 | 79 |
942507 | 942507 | 2021-01-18 | Robertson | Tennessee | 47147 | 7645 | 85 |
942508 | 942508 | 2021-01-18 | Rutherford | Tennessee | 47149 | 33228 | 285 |
942509 | 942509 | 2021-01-18 | Scott | Tennessee | 47151 | 2254 | 31 |
942510 | 942510 | 2021-01-18 | Sequatchie | Tennessee | 47153 | 1371 | 18 |
942511 | 942511 | 2021-01-18 | Sevier | Tennessee | 47155 | 10495 | 108 |
942512 | 942512 | 2021-01-18 | Shelby | Tennessee | 47157 | 78020 | 1140 |
942513 | 942513 | 2021-01-18 | Smith | Tennessee | 47159 | 2313 | 27 |
942514 | 942514 | 2021-01-18 | Stewart | Tennessee | 47161 | 1055 | 20 |
942515 | 942515 | 2021-01-18 | Sullivan | Tennessee | 47163 | 12606 | 211 |
942516 | 942516 | 2021-01-18 | Sumner | Tennessee | 47165 | 18262 | 232 |
942517 | 942517 | 2021-01-18 | Tipton | Tennessee | 47167 | 6210 | 65 |
942518 | 942518 | 2021-01-18 | Trousdale | Tennessee | 47169 | 2288 | 14 |
942519 | 942519 | 2021-01-18 | Unicoi | Tennessee | 47171 | 1670 | 43 |
942520 | 942520 | 2021-01-18 | Union | Tennessee | 47173 | 1394 | 22 |
942521 | 942521 | 2021-01-18 | Unknown | Tennessee | 12961 | 107 | |
942522 | 942522 | 2021-01-18 | Van Buren | Tennessee | 47175 | 660 | 7 |
942523 | 942523 | 2021-01-18 | Warren | Tennessee | 47177 | 4987 | 53 |
942524 | 942524 | 2021-01-18 | Washington | Tennessee | 47179 | 11911 | 191 |
942525 | 942525 | 2021-01-18 | Wayne | Tennessee | 47181 | 2613 | 19 |
942526 | 942526 | 2021-01-18 | Weakley | Tennessee | 47183 | 3399 | 48 |
942527 | 942527 | 2021-01-18 | White | Tennessee | 47185 | 3113 | 43 |
942528 | 942528 | 2021-01-18 | Williamson | Tennessee | 47187 | 21449 | 140 |
942529 | 942529 | 2021-01-18 | Wilson | Tennessee | 47189 | 14449 | 157 |
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);