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-11-08 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
712023 | 712023 | 2020-11-08 | Anderson | Tennessee | 47001 | 2123 | 18 |
712024 | 712024 | 2020-11-08 | Bedford | Tennessee | 47003 | 1992 | 23 |
712025 | 712025 | 2020-11-08 | Benton | Tennessee | 47005 | 520 | 11 |
712026 | 712026 | 2020-11-08 | Bledsoe | Tennessee | 47007 | 1070 | 4 |
712027 | 712027 | 2020-11-08 | Blount | Tennessee | 47009 | 3916 | 46 |
712028 | 712028 | 2020-11-08 | Bradley | Tennessee | 47011 | 3948 | 24 |
712029 | 712029 | 2020-11-08 | Campbell | Tennessee | 47013 | 1238 | 15 |
712030 | 712030 | 2020-11-08 | Cannon | Tennessee | 47015 | 494 | 2 |
712031 | 712031 | 2020-11-08 | Carroll | Tennessee | 47017 | 1300 | 30 |
712032 | 712032 | 2020-11-08 | Carter | Tennessee | 47019 | 1946 | 38 |
712033 | 712033 | 2020-11-08 | Cheatham | Tennessee | 47021 | 1225 | 12 |
712034 | 712034 | 2020-11-08 | Chester | Tennessee | 47023 | 801 | 18 |
712035 | 712035 | 2020-11-08 | Claiborne | Tennessee | 47025 | 578 | 8 |
712036 | 712036 | 2020-11-08 | Clay | Tennessee | 47027 | 446 | 17 |
712037 | 712037 | 2020-11-08 | Cocke | Tennessee | 47029 | 1292 | 22 |
712038 | 712038 | 2020-11-08 | Coffee | Tennessee | 47031 | 2182 | 31 |
712039 | 712039 | 2020-11-08 | Crockett | Tennessee | 47033 | 1018 | 24 |
712040 | 712040 | 2020-11-08 | Cumberland | Tennessee | 47035 | 1897 | 29 |
712041 | 712041 | 2020-11-08 | Davidson | Tennessee | 47037 | 37034 | 365 |
712042 | 712042 | 2020-11-08 | DeKalb | Tennessee | 47041 | 861 | 18 |
712043 | 712043 | 2020-11-08 | Decatur | Tennessee | 47039 | 732 | 11 |
712044 | 712044 | 2020-11-08 | Dickson | Tennessee | 47043 | 2030 | 21 |
712045 | 712045 | 2020-11-08 | Dyer | Tennessee | 47045 | 2607 | 39 |
712046 | 712046 | 2020-11-08 | Fayette | Tennessee | 47047 | 1876 | 30 |
712047 | 712047 | 2020-11-08 | Fentress | Tennessee | 47049 | 1011 | 14 |
712048 | 712048 | 2020-11-08 | Franklin | Tennessee | 47051 | 1481 | 27 |
712049 | 712049 | 2020-11-08 | Gibson | Tennessee | 47053 | 2418 | 52 |
712050 | 712050 | 2020-11-08 | Giles | Tennessee | 47055 | 1119 | 38 |
712051 | 712051 | 2020-11-08 | Grainger | Tennessee | 47057 | 754 | 5 |
712052 | 712052 | 2020-11-08 | Greene | Tennessee | 47059 | 2191 | 60 |
712053 | 712053 | 2020-11-08 | Grundy | Tennessee | 47061 | 641 | 14 |
712054 | 712054 | 2020-11-08 | Hamblen | Tennessee | 47063 | 2742 | 51 |
712055 | 712055 | 2020-11-08 | Hamilton | Tennessee | 47065 | 13661 | 117 |
712056 | 712056 | 2020-11-08 | Hancock | Tennessee | 47067 | 128 | 3 |
712057 | 712057 | 2020-11-08 | Hardeman | Tennessee | 47069 | 2038 | 35 |
712058 | 712058 | 2020-11-08 | Hardin | Tennessee | 47071 | 1505 | 23 |
712059 | 712059 | 2020-11-08 | Hawkins | Tennessee | 47073 | 1420 | 30 |
712060 | 712060 | 2020-11-08 | Haywood | Tennessee | 47075 | 1405 | 28 |
712061 | 712061 | 2020-11-08 | Henderson | Tennessee | 47077 | 1525 | 29 |
712062 | 712062 | 2020-11-08 | Henry | Tennessee | 47079 | 1008 | 13 |
712063 | 712063 | 2020-11-08 | Hickman | Tennessee | 47081 | 894 | 16 |
712064 | 712064 | 2020-11-08 | Houston | Tennessee | 47083 | 487 | 18 |
712065 | 712065 | 2020-11-08 | Humphreys | Tennessee | 47085 | 526 | 6 |
712066 | 712066 | 2020-11-08 | Jackson | Tennessee | 47087 | 529 | 7 |
712067 | 712067 | 2020-11-08 | Jefferson | Tennessee | 47089 | 1726 | 25 |
712068 | 712068 | 2020-11-08 | Johnson | Tennessee | 47091 | 1275 | 14 |
712069 | 712069 | 2020-11-08 | Knox | Tennessee | 47093 | 14899 | 116 |
712070 | 712070 | 2020-11-08 | Lake | Tennessee | 47095 | 1042 | 4 |
712071 | 712071 | 2020-11-08 | Lauderdale | Tennessee | 47097 | 1598 | 20 |
712072 | 712072 | 2020-11-08 | Lawrence | Tennessee | 47099 | 1942 | 24 |
712073 | 712073 | 2020-11-08 | Lewis | Tennessee | 47101 | 572 | 7 |
712074 | 712074 | 2020-11-08 | Lincoln | Tennessee | 47103 | 1096 | 8 |
712075 | 712075 | 2020-11-08 | Loudon | Tennessee | 47105 | 1827 | 13 |
712076 | 712076 | 2020-11-08 | Macon | Tennessee | 47111 | 1485 | 26 |
712077 | 712077 | 2020-11-08 | Madison | Tennessee | 47113 | 4259 | 86 |
712078 | 712078 | 2020-11-08 | Marion | Tennessee | 47115 | 905 | 14 |
712079 | 712079 | 2020-11-08 | Marshall | Tennessee | 47117 | 1312 | 12 |
712080 | 712080 | 2020-11-08 | Maury | Tennessee | 47119 | 4195 | 42 |
712081 | 712081 | 2020-11-08 | McMinn | Tennessee | 47107 | 1880 | 44 |
712082 | 712082 | 2020-11-08 | McNairy | Tennessee | 47109 | 1233 | 30 |
712083 | 712083 | 2020-11-08 | Meigs | Tennessee | 47121 | 379 | 8 |
712084 | 712084 | 2020-11-08 | Monroe | Tennessee | 47123 | 1657 | 33 |
712085 | 712085 | 2020-11-08 | Montgomery | Tennessee | 47125 | 4856 | 63 |
712086 | 712086 | 2020-11-08 | Moore | Tennessee | 47127 | 303 | 2 |
712087 | 712087 | 2020-11-08 | Morgan | Tennessee | 47129 | 493 | 6 |
712088 | 712088 | 2020-11-08 | Obion | Tennessee | 47131 | 2051 | 31 |
712089 | 712089 | 2020-11-08 | Overton | Tennessee | 47133 | 1329 | 28 |
712090 | 712090 | 2020-11-08 | Perry | Tennessee | 47135 | 383 | 15 |
712091 | 712091 | 2020-11-08 | Pickett | Tennessee | 47137 | 309 | 10 |
712092 | 712092 | 2020-11-08 | Polk | Tennessee | 47139 | 562 | 13 |
712093 | 712093 | 2020-11-08 | Putnam | Tennessee | 47141 | 4883 | 64 |
712094 | 712094 | 2020-11-08 | Rhea | Tennessee | 47143 | 1252 | 24 |
712095 | 712095 | 2020-11-08 | Roane | Tennessee | 47145 | 1702 | 10 |
712096 | 712096 | 2020-11-08 | Robertson | Tennessee | 47147 | 2868 | 43 |
712097 | 712097 | 2020-11-08 | Rutherford | Tennessee | 47149 | 13640 | 126 |
712098 | 712098 | 2020-11-08 | Scott | Tennessee | 47151 | 543 | 5 |
712099 | 712099 | 2020-11-08 | Sequatchie | Tennessee | 47153 | 402 | 5 |
712100 | 712100 | 2020-11-08 | Sevier | Tennessee | 47155 | 3814 | 26 |
712101 | 712101 | 2020-11-08 | Shelby | Tennessee | 47157 | 39852 | 588 |
712102 | 712102 | 2020-11-08 | Smith | Tennessee | 47159 | 1114 | 16 |
712103 | 712103 | 2020-11-08 | Stewart | Tennessee | 47161 | 420 | 13 |
712104 | 712104 | 2020-11-08 | Sullivan | Tennessee | 47163 | 4607 | 64 |
712105 | 712105 | 2020-11-08 | Sumner | Tennessee | 47165 | 7025 | 120 |
712106 | 712106 | 2020-11-08 | Tipton | Tennessee | 47167 | 2723 | 25 |
712107 | 712107 | 2020-11-08 | Trousdale | Tennessee | 47169 | 1832 | 10 |
712108 | 712108 | 2020-11-08 | Unicoi | Tennessee | 47171 | 571 | 10 |
712109 | 712109 | 2020-11-08 | Union | Tennessee | 47173 | 591 | 5 |
712110 | 712110 | 2020-11-08 | Unknown | Tennessee | 201 | 0 | |
712111 | 712111 | 2020-11-08 | Van Buren | Tennessee | 47175 | 233 | 2 |
712112 | 712112 | 2020-11-08 | Warren | Tennessee | 47177 | 1699 | 11 |
712113 | 712113 | 2020-11-08 | Washington | Tennessee | 47179 | 4395 | 78 |
712114 | 712114 | 2020-11-08 | Wayne | Tennessee | 47181 | 1648 | 7 |
712115 | 712115 | 2020-11-08 | Weakley | Tennessee | 47183 | 1730 | 29 |
712116 | 712116 | 2020-11-08 | White | Tennessee | 47185 | 1381 | 16 |
712117 | 712117 | 2020-11-08 | Williamson | Tennessee | 47187 | 8299 | 61 |
712118 | 712118 | 2020-11-08 | Wilson | Tennessee | 47189 | 5471 | 67 |
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);