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-02-03 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179978 | 2179978 | 2022-02-03 | Anderson | Tennessee | 47001 | 19504 | 289 |
2179979 | 2179979 | 2022-02-03 | Bedford | Tennessee | 47003 | 13710 | 211 |
2179980 | 2179980 | 2022-02-03 | Benton | Tennessee | 47005 | 3962 | 84 |
2179981 | 2179981 | 2022-02-03 | Bledsoe | Tennessee | 47007 | 4326 | 43 |
2179982 | 2179982 | 2022-02-03 | Blount | Tennessee | 47009 | 35689 | 357 |
2179983 | 2179983 | 2022-02-03 | Bradley | Tennessee | 47011 | 31292 | 357 |
2179984 | 2179984 | 2022-02-03 | Campbell | Tennessee | 47013 | 10632 | 137 |
2179985 | 2179985 | 2022-02-03 | Cannon | Tennessee | 47015 | 3739 | 52 |
2179986 | 2179986 | 2022-02-03 | Carroll | Tennessee | 47017 | 8246 | 137 |
2179987 | 2179987 | 2022-02-03 | Carter | Tennessee | 47019 | 14517 | 292 |
2179988 | 2179988 | 2022-02-03 | Cheatham | Tennessee | 47021 | 10182 | 106 |
2179989 | 2179989 | 2022-02-03 | Chester | Tennessee | 47023 | 5224 | 86 |
2179990 | 2179990 | 2022-02-03 | Claiborne | Tennessee | 47025 | 7783 | 149 |
2179991 | 2179991 | 2022-02-03 | Clay | Tennessee | 47027 | 2021 | 44 |
2179992 | 2179992 | 2022-02-03 | Cocke | Tennessee | 47029 | 10297 | 190 |
2179993 | 2179993 | 2022-02-03 | Coffee | Tennessee | 47031 | 15417 | 223 |
2179994 | 2179994 | 2022-02-03 | Crockett | Tennessee | 47033 | 4698 | 75 |
2179995 | 2179995 | 2022-02-03 | Cumberland | Tennessee | 47035 | 14622 | 290 |
2179996 | 2179996 | 2022-02-03 | Davidson | Tennessee | 47037 | 197612 | 1485 |
2179997 | 2179997 | 2022-02-03 | DeKalb | Tennessee | 47041 | 5694 | 91 |
2179998 | 2179998 | 2022-02-03 | Decatur | Tennessee | 47039 | 3344 | 53 |
2179999 | 2179999 | 2022-02-03 | Dickson | Tennessee | 47043 | 14412 | 219 |
2180000 | 2180000 | 2022-02-03 | Dyer | Tennessee | 47045 | 11817 | 176 |
2180001 | 2180001 | 2022-02-03 | Fayette | Tennessee | 47047 | 10727 | 149 |
2180002 | 2180002 | 2022-02-03 | Fentress | Tennessee | 47049 | 5041 | 109 |
2180003 | 2180003 | 2022-02-03 | Franklin | Tennessee | 47051 | 11698 | 152 |
2180004 | 2180004 | 2022-02-03 | Gibson | Tennessee | 47053 | 16029 | 227 |
2180005 | 2180005 | 2022-02-03 | Giles | Tennessee | 47055 | 8743 | 161 |
2180006 | 2180006 | 2022-02-03 | Grainger | Tennessee | 47057 | 6149 | 98 |
2180007 | 2180007 | 2022-02-03 | Greene | Tennessee | 47059 | 20077 | 321 |
2180008 | 2180008 | 2022-02-03 | Grundy | Tennessee | 47061 | 3666 | 67 |
2180009 | 2180009 | 2022-02-03 | Hamblen | Tennessee | 47063 | 18184 | 311 |
2180010 | 2180010 | 2022-02-03 | Hamilton | Tennessee | 47065 | 92075 | 1007 |
2180011 | 2180011 | 2022-02-03 | Hancock | Tennessee | 47067 | 1789 | 29 |
2180012 | 2180012 | 2022-02-03 | Hardeman | Tennessee | 47069 | 6873 | 106 |
2180013 | 2180013 | 2022-02-03 | Hardin | Tennessee | 47071 | 7772 | 118 |
2180014 | 2180014 | 2022-02-03 | Hawkins | Tennessee | 47073 | 14743 | 260 |
2180015 | 2180015 | 2022-02-03 | Haywood | Tennessee | 47075 | 5698 | 84 |
2180016 | 2180016 | 2022-02-03 | Henderson | Tennessee | 47077 | 8224 | 126 |
2180017 | 2180017 | 2022-02-03 | Henry | Tennessee | 47079 | 7376 | 132 |
2180018 | 2180018 | 2022-02-03 | Hickman | Tennessee | 47081 | 6289 | 97 |
2180019 | 2180019 | 2022-02-03 | Houston | Tennessee | 47083 | 2418 | 56 |
2180020 | 2180020 | 2022-02-03 | Humphreys | Tennessee | 47085 | 4272 | 61 |
2180021 | 2180021 | 2022-02-03 | Jackson | Tennessee | 47087 | 2864 | 52 |
2180022 | 2180022 | 2022-02-03 | Jefferson | Tennessee | 47089 | 14227 | 232 |
2180023 | 2180023 | 2022-02-03 | Johnson | Tennessee | 47091 | 4742 | 73 |
2180024 | 2180024 | 2022-02-03 | Knox | Tennessee | 47093 | 116195 | 1166 |
2180025 | 2180025 | 2022-02-03 | Lake | Tennessee | 47095 | 2581 | 34 |
2180026 | 2180026 | 2022-02-03 | Lauderdale | Tennessee | 47097 | 7303 | 86 |
2180027 | 2180027 | 2022-02-03 | Lawrence | Tennessee | 47099 | 13326 | 168 |
2180028 | 2180028 | 2022-02-03 | Lewis | Tennessee | 47101 | 3257 | 49 |
2180029 | 2180029 | 2022-02-03 | Lincoln | Tennessee | 47103 | 9310 | 137 |
2180030 | 2180030 | 2022-02-03 | Loudon | Tennessee | 47105 | 13283 | 163 |
2180031 | 2180031 | 2022-02-03 | Macon | Tennessee | 47111 | 7627 | 126 |
2180032 | 2180032 | 2022-02-03 | Madison | Tennessee | 47113 | 27279 | 380 |
2180033 | 2180033 | 2022-02-03 | Marion | Tennessee | 47115 | 7950 | 116 |
2180034 | 2180034 | 2022-02-03 | Marshall | Tennessee | 47117 | 9465 | 108 |
2180035 | 2180035 | 2022-02-03 | Maury | Tennessee | 47119 | 27145 | 289 |
2180036 | 2180036 | 2022-02-03 | McMinn | Tennessee | 47107 | 15201 | 213 |
2180037 | 2180037 | 2022-02-03 | McNairy | Tennessee | 47109 | 6555 | 93 |
2180038 | 2180038 | 2022-02-03 | Meigs | Tennessee | 47121 | 3117 | 48 |
2180039 | 2180039 | 2022-02-03 | Monroe | Tennessee | 47123 | 13183 | 206 |
2180040 | 2180040 | 2022-02-03 | Montgomery | Tennessee | 47125 | 46355 | 503 |
2180041 | 2180041 | 2022-02-03 | Moore | Tennessee | 47127 | 2050 | 35 |
2180042 | 2180042 | 2022-02-03 | Morgan | Tennessee | 47129 | 5392 | 66 |
2180043 | 2180043 | 2022-02-03 | Obion | Tennessee | 47131 | 10086 | 157 |
2180044 | 2180044 | 2022-02-03 | Overton | Tennessee | 47133 | 6404 | 118 |
2180045 | 2180045 | 2022-02-03 | Perry | Tennessee | 47135 | 2133 | 43 |
2180046 | 2180046 | 2022-02-03 | Pickett | Tennessee | 47137 | 1627 | 29 |
2180047 | 2180047 | 2022-02-03 | Polk | Tennessee | 47139 | 4326 | 52 |
2180048 | 2180048 | 2022-02-03 | Putnam | Tennessee | 47141 | 22644 | 275 |
2180049 | 2180049 | 2022-02-03 | Rhea | Tennessee | 47143 | 9237 | 138 |
2180050 | 2180050 | 2022-02-03 | Roane | Tennessee | 47145 | 14288 | 203 |
2180051 | 2180051 | 2022-02-03 | Robertson | Tennessee | 47147 | 20101 | 261 |
2180052 | 2180052 | 2022-02-03 | Rutherford | Tennessee | 47149 | 90041 | 808 |
2180053 | 2180053 | 2022-02-03 | Scott | Tennessee | 47151 | 7744 | 99 |
2180054 | 2180054 | 2022-02-03 | Sequatchie | Tennessee | 47153 | 3773 | 62 |
2180055 | 2180055 | 2022-02-03 | Sevier | Tennessee | 47155 | 28193 | 365 |
2180056 | 2180056 | 2022-02-03 | Shelby | Tennessee | 47157 | 229390 | 2942 |
2180057 | 2180057 | 2022-02-03 | Smith | Tennessee | 47159 | 5523 | 71 |
2180058 | 2180058 | 2022-02-03 | Stewart | Tennessee | 47161 | 3036 | 47 |
2180059 | 2180059 | 2022-02-03 | Sullivan | Tennessee | 47163 | 40582 | 598 |
2180060 | 2180060 | 2022-02-03 | Sumner | Tennessee | 47165 | 49665 | 631 |
2180061 | 2180061 | 2022-02-03 | Tipton | Tennessee | 47167 | 16628 | 192 |
2180062 | 2180062 | 2022-02-03 | Trousdale | Tennessee | 47169 | 3967 | 41 |
2180063 | 2180063 | 2022-02-03 | Unicoi | Tennessee | 47171 | 4309 | 86 |
2180064 | 2180064 | 2022-02-03 | Union | Tennessee | 47173 | 4778 | 68 |
2180065 | 2180065 | 2022-02-03 | Unknown | Tennessee | 38819 | 453 | |
2180066 | 2180066 | 2022-02-03 | Van Buren | Tennessee | 47175 | 1667 | 45 |
2180067 | 2180067 | 2022-02-03 | Warren | Tennessee | 47177 | 11735 | 154 |
2180068 | 2180068 | 2022-02-03 | Washington | Tennessee | 47179 | 33148 | 432 |
2180069 | 2180069 | 2022-02-03 | Wayne | Tennessee | 47181 | 5314 | 52 |
2180070 | 2180070 | 2022-02-03 | Weakley | Tennessee | 47183 | 8825 | 116 |
2180071 | 2180071 | 2022-02-03 | White | Tennessee | 47185 | 7521 | 120 |
2180072 | 2180072 | 2022-02-03 | Williamson | Tennessee | 47187 | 58019 | 356 |
2180073 | 2180073 | 2022-02-03 | Wilson | Tennessee | 47189 | 39029 | 444 |
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);