ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where date = "2022-03-15" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2310057 | 2310057 | 2022-03-15 | Anderson | Tennessee | 47001 | 21942 | 312 |
2310058 | 2310058 | 2022-03-15 | Bedford | Tennessee | 47003 | 14906 | 221 |
2310059 | 2310059 | 2022-03-15 | Benton | Tennessee | 47005 | 4453 | 90 |
2310060 | 2310060 | 2022-03-15 | Bledsoe | Tennessee | 47007 | 4645 | 53 |
2310061 | 2310061 | 2022-03-15 | Blount | Tennessee | 47009 | 38940 | 399 |
2310062 | 2310062 | 2022-03-15 | Bradley | Tennessee | 47011 | 33031 | 387 |
2310063 | 2310063 | 2022-03-15 | Campbell | Tennessee | 47013 | 12010 | 153 |
2310064 | 2310064 | 2022-03-15 | Cannon | Tennessee | 47015 | 4170 | 56 |
2310065 | 2310065 | 2022-03-15 | Carroll | Tennessee | 47017 | 8914 | 150 |
2310066 | 2310066 | 2022-03-15 | Carter | Tennessee | 47019 | 16377 | 316 |
2310067 | 2310067 | 2022-03-15 | Cheatham | Tennessee | 47021 | 10876 | 117 |
2310068 | 2310068 | 2022-03-15 | Chester | Tennessee | 47023 | 5768 | 94 |
2310069 | 2310069 | 2022-03-15 | Claiborne | Tennessee | 47025 | 9027 | 167 |
2310070 | 2310070 | 2022-03-15 | Clay | Tennessee | 47027 | 2219 | 47 |
2310071 | 2310071 | 2022-03-15 | Cocke | Tennessee | 47029 | 11508 | 201 |
2310072 | 2310072 | 2022-03-15 | Coffee | Tennessee | 47031 | 16894 | 250 |
2310073 | 2310073 | 2022-03-15 | Crockett | Tennessee | 47033 | 5150 | 82 |
2310074 | 2310074 | 2022-03-15 | Cumberland | Tennessee | 47035 | 16042 | 310 |
2310075 | 2310075 | 2022-03-15 | Davidson | Tennessee | 47037 | 206440 | 1601 |
2310076 | 2310076 | 2022-03-15 | DeKalb | Tennessee | 47041 | 6268 | 97 |
2310077 | 2310077 | 2022-03-15 | Decatur | Tennessee | 47039 | 3715 | 64 |
2310078 | 2310078 | 2022-03-15 | Dickson | Tennessee | 47043 | 15826 | 235 |
2310079 | 2310079 | 2022-03-15 | Dyer | Tennessee | 47045 | 12720 | 192 |
2310080 | 2310080 | 2022-03-15 | Fayette | Tennessee | 47047 | 11387 | 171 |
2310081 | 2310081 | 2022-03-15 | Fentress | Tennessee | 47049 | 5681 | 117 |
2310082 | 2310082 | 2022-03-15 | Franklin | Tennessee | 47051 | 12802 | 165 |
2310083 | 2310083 | 2022-03-15 | Gibson | Tennessee | 47053 | 17286 | 252 |
2310084 | 2310084 | 2022-03-15 | Giles | Tennessee | 47055 | 9382 | 172 |
2310085 | 2310085 | 2022-03-15 | Grainger | Tennessee | 47057 | 6747 | 103 |
2310086 | 2310086 | 2022-03-15 | Greene | Tennessee | 47059 | 21952 | 353 |
2310087 | 2310087 | 2022-03-15 | Grundy | Tennessee | 47061 | 3974 | 69 |
2310088 | 2310088 | 2022-03-15 | Hamblen | Tennessee | 47063 | 19651 | 345 |
2310089 | 2310089 | 2022-03-15 | Hamilton | Tennessee | 47065 | 99176 | 1103 |
2310090 | 2310090 | 2022-03-15 | Hancock | Tennessee | 47067 | 1998 | 32 |
2310091 | 2310091 | 2022-03-15 | Hardeman | Tennessee | 47069 | 7550 | 113 |
2310092 | 2310092 | 2022-03-15 | Hardin | Tennessee | 47071 | 8695 | 137 |
2310093 | 2310093 | 2022-03-15 | Hawkins | Tennessee | 47073 | 16546 | 291 |
2310094 | 2310094 | 2022-03-15 | Haywood | Tennessee | 47075 | 6131 | 97 |
2310095 | 2310095 | 2022-03-15 | Henderson | Tennessee | 47077 | 9035 | 147 |
2310096 | 2310096 | 2022-03-15 | Henry | Tennessee | 47079 | 8221 | 148 |
2310097 | 2310097 | 2022-03-15 | Hickman | Tennessee | 47081 | 6808 | 104 |
2310098 | 2310098 | 2022-03-15 | Houston | Tennessee | 47083 | 2667 | 59 |
2310099 | 2310099 | 2022-03-15 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2310100 | 2310100 | 2022-03-15 | Jackson | Tennessee | 47087 | 3199 | 60 |
2310101 | 2310101 | 2022-03-15 | Jefferson | Tennessee | 47089 | 15650 | 255 |
2310102 | 2310102 | 2022-03-15 | Johnson | Tennessee | 47091 | 5131 | 87 |
2310103 | 2310103 | 2022-03-15 | Knox | Tennessee | 47093 | 127157 | 1298 |
2310104 | 2310104 | 2022-03-15 | Lake | Tennessee | 47095 | 2733 | 40 |
2310105 | 2310105 | 2022-03-15 | Lauderdale | Tennessee | 47097 | 7713 | 99 |
2310106 | 2310106 | 2022-03-15 | Lawrence | Tennessee | 47099 | 14241 | 187 |
2310107 | 2310107 | 2022-03-15 | Lewis | Tennessee | 47101 | 3567 | 50 |
2310108 | 2310108 | 2022-03-15 | Lincoln | Tennessee | 47103 | 9949 | 157 |
2310109 | 2310109 | 2022-03-15 | Loudon | Tennessee | 47105 | 14363 | 186 |
2310110 | 2310110 | 2022-03-15 | Macon | Tennessee | 47111 | 8405 | 138 |
2310111 | 2310111 | 2022-03-15 | Madison | Tennessee | 47113 | 29657 | 411 |
2310112 | 2310112 | 2022-03-15 | Marion | Tennessee | 47115 | 8810 | 124 |
2310113 | 2310113 | 2022-03-15 | Marshall | Tennessee | 47117 | 10334 | 116 |
2310114 | 2310114 | 2022-03-15 | Maury | Tennessee | 47119 | 28815 | 320 |
2310115 | 2310115 | 2022-03-15 | McMinn | Tennessee | 47107 | 16630 | 240 |
2310116 | 2310116 | 2022-03-15 | McNairy | Tennessee | 47109 | 7608 | 113 |
2310117 | 2310117 | 2022-03-15 | Meigs | Tennessee | 47121 | 3347 | 54 |
2310118 | 2310118 | 2022-03-15 | Monroe | Tennessee | 47123 | 14442 | 217 |
2310119 | 2310119 | 2022-03-15 | Montgomery | Tennessee | 47125 | 49919 | 550 |
2310120 | 2310120 | 2022-03-15 | Moore | Tennessee | 47127 | 2235 | 39 |
2310121 | 2310121 | 2022-03-15 | Morgan | Tennessee | 47129 | 6145 | 78 |
2310122 | 2310122 | 2022-03-15 | Obion | Tennessee | 47131 | 10742 | 179 |
2310123 | 2310123 | 2022-03-15 | Overton | Tennessee | 47133 | 7139 | 120 |
2310124 | 2310124 | 2022-03-15 | Perry | Tennessee | 47135 | 2327 | 48 |
2310125 | 2310125 | 2022-03-15 | Pickett | Tennessee | 47137 | 1763 | 31 |
2310126 | 2310126 | 2022-03-15 | Polk | Tennessee | 47139 | 4711 | 65 |
2310127 | 2310127 | 2022-03-15 | Putnam | Tennessee | 47141 | 25037 | 295 |
2310128 | 2310128 | 2022-03-15 | Rhea | Tennessee | 47143 | 9936 | 148 |
2310129 | 2310129 | 2022-03-15 | Roane | Tennessee | 47145 | 15712 | 225 |
2310130 | 2310130 | 2022-03-15 | Robertson | Tennessee | 47147 | 21471 | 290 |
2310131 | 2310131 | 2022-03-15 | Rutherford | Tennessee | 47149 | 95362 | 865 |
2310132 | 2310132 | 2022-03-15 | Scott | Tennessee | 47151 | 8987 | 111 |
2310133 | 2310133 | 2022-03-15 | Sequatchie | Tennessee | 47153 | 4194 | 66 |
2310134 | 2310134 | 2022-03-15 | Sevier | Tennessee | 47155 | 30156 | 393 |
2310135 | 2310135 | 2022-03-15 | Shelby | Tennessee | 47157 | 237279 | 3199 |
2310136 | 2310136 | 2022-03-15 | Smith | Tennessee | 47159 | 6154 | 76 |
2310137 | 2310137 | 2022-03-15 | Stewart | Tennessee | 47161 | 3280 | 52 |
2310138 | 2310138 | 2022-03-15 | Sullivan | Tennessee | 47163 | 45533 | 670 |
2310139 | 2310139 | 2022-03-15 | Sumner | Tennessee | 47165 | 52955 | 688 |
2310140 | 2310140 | 2022-03-15 | Tipton | Tennessee | 47167 | 17564 | 221 |
2310141 | 2310141 | 2022-03-15 | Trousdale | Tennessee | 47169 | 4206 | 45 |
2310142 | 2310142 | 2022-03-15 | Unicoi | Tennessee | 47171 | 5138 | 90 |
2310143 | 2310143 | 2022-03-15 | Union | Tennessee | 47173 | 5382 | 70 |
2310144 | 2310144 | 2022-03-15 | Unknown | Tennessee | 20756 | 734 | |
2310145 | 2310145 | 2022-03-15 | Van Buren | Tennessee | 47175 | 1845 | 46 |
2310146 | 2310146 | 2022-03-15 | Warren | Tennessee | 47177 | 12970 | 167 |
2310147 | 2310147 | 2022-03-15 | Washington | Tennessee | 47179 | 38342 | 471 |
2310148 | 2310148 | 2022-03-15 | Wayne | Tennessee | 47181 | 5672 | 60 |
2310149 | 2310149 | 2022-03-15 | Weakley | Tennessee | 47183 | 9474 | 138 |
2310150 | 2310150 | 2022-03-15 | White | Tennessee | 47185 | 8216 | 126 |
2310151 | 2310151 | 2022-03-15 | Williamson | Tennessee | 47187 | 61684 | 386 |
2310152 | 2310152 | 2022-03-15 | 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);