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-12-02 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1975132 | 1975132 | 2021-12-02 | Anderson | Tennessee | 47001 | 13578 | 235 |
1975133 | 1975133 | 2021-12-02 | Bedford | Tennessee | 47003 | 9574 | 164 |
1975134 | 1975134 | 2021-12-02 | Benton | Tennessee | 47005 | 2984 | 60 |
1975135 | 1975135 | 2021-12-02 | Bledsoe | Tennessee | 47007 | 3568 | 22 |
1975136 | 1975136 | 2021-12-02 | Blount | Tennessee | 47009 | 24587 | 275 |
1975137 | 1975137 | 2021-12-02 | Bradley | Tennessee | 47011 | 22708 | 229 |
1975138 | 1975138 | 2021-12-02 | Campbell | Tennessee | 47013 | 7572 | 92 |
1975139 | 1975139 | 2021-12-02 | Cannon | Tennessee | 47015 | 2869 | 44 |
1975140 | 1975140 | 2021-12-02 | Carroll | Tennessee | 47017 | 5898 | 112 |
1975141 | 1975141 | 2021-12-02 | Carter | Tennessee | 47019 | 10990 | 228 |
1975142 | 1975142 | 2021-12-02 | Cheatham | Tennessee | 47021 | 7231 | 77 |
1975143 | 1975143 | 2021-12-02 | Chester | Tennessee | 47023 | 3614 | 77 |
1975144 | 1975144 | 2021-12-02 | Claiborne | Tennessee | 47025 | 5870 | 116 |
1975145 | 1975145 | 2021-12-02 | Clay | Tennessee | 47027 | 1556 | 37 |
1975146 | 1975146 | 2021-12-02 | Cocke | Tennessee | 47029 | 7611 | 118 |
1975147 | 1975147 | 2021-12-02 | Coffee | Tennessee | 47031 | 10914 | 167 |
1975148 | 1975148 | 2021-12-02 | Crockett | Tennessee | 47033 | 3410 | 64 |
1975149 | 1975149 | 2021-12-02 | Cumberland | Tennessee | 47035 | 11578 | 234 |
1975150 | 1975150 | 2021-12-02 | Davidson | Tennessee | 47037 | 135846 | 1205 |
1975151 | 1975151 | 2021-12-02 | DeKalb | Tennessee | 47041 | 4319 | 77 |
1975152 | 1975152 | 2021-12-02 | Decatur | Tennessee | 47039 | 2493 | 44 |
1975153 | 1975153 | 2021-12-02 | Dickson | Tennessee | 47043 | 10769 | 171 |
1975154 | 1975154 | 2021-12-02 | Dyer | Tennessee | 47045 | 8215 | 154 |
1975155 | 1975155 | 2021-12-02 | Fayette | Tennessee | 47047 | 7483 | 111 |
1975156 | 1975156 | 2021-12-02 | Fentress | Tennessee | 47049 | 3816 | 71 |
1975157 | 1975157 | 2021-12-02 | Franklin | Tennessee | 47051 | 8200 | 105 |
1975158 | 1975158 | 2021-12-02 | Gibson | Tennessee | 47053 | 10836 | 192 |
1975159 | 1975159 | 2021-12-02 | Giles | Tennessee | 47055 | 6202 | 128 |
1975160 | 1975160 | 2021-12-02 | Grainger | Tennessee | 47057 | 4537 | 72 |
1975161 | 1975161 | 2021-12-02 | Greene | Tennessee | 47059 | 14394 | 247 |
1975162 | 1975162 | 2021-12-02 | Grundy | Tennessee | 47061 | 2941 | 43 |
1975163 | 1975163 | 2021-12-02 | Hamblen | Tennessee | 47063 | 13386 | 218 |
1975164 | 1975164 | 2021-12-02 | Hamilton | Tennessee | 47065 | 65721 | 704 |
1975165 | 1975165 | 2021-12-02 | Hancock | Tennessee | 47067 | 1284 | 21 |
1975166 | 1975166 | 2021-12-02 | Hardeman | Tennessee | 47069 | 5186 | 88 |
1975167 | 1975167 | 2021-12-02 | Hardin | Tennessee | 47071 | 5716 | 90 |
1975168 | 1975168 | 2021-12-02 | Hawkins | Tennessee | 47073 | 10869 | 184 |
1975169 | 1975169 | 2021-12-02 | Haywood | Tennessee | 47075 | 3919 | 79 |
1975170 | 1975170 | 2021-12-02 | Henderson | Tennessee | 47077 | 5915 | 106 |
1975171 | 1975171 | 2021-12-02 | Henry | Tennessee | 47079 | 5595 | 94 |
1975172 | 1975172 | 2021-12-02 | Hickman | Tennessee | 47081 | 4786 | 78 |
1975173 | 1975173 | 2021-12-02 | Houston | Tennessee | 47083 | 1916 | 45 |
1975174 | 1975174 | 2021-12-02 | Humphreys | Tennessee | 47085 | 3358 | 49 |
1975175 | 1975175 | 2021-12-02 | Jackson | Tennessee | 47087 | 2119 | 41 |
1975176 | 1975176 | 2021-12-02 | Jefferson | Tennessee | 47089 | 10234 | 157 |
1975177 | 1975177 | 2021-12-02 | Johnson | Tennessee | 47091 | 3968 | 53 |
1975178 | 1975178 | 2021-12-02 | Knox | Tennessee | 47093 | 81236 | 958 |
1975179 | 1975179 | 2021-12-02 | Lake | Tennessee | 47095 | 2027 | 31 |
1975180 | 1975180 | 2021-12-02 | Lauderdale | Tennessee | 47097 | 5267 | 72 |
1975181 | 1975181 | 2021-12-02 | Lawrence | Tennessee | 47099 | 9778 | 130 |
1975182 | 1975182 | 2021-12-02 | Lewis | Tennessee | 47101 | 2571 | 43 |
1975183 | 1975183 | 2021-12-02 | Lincoln | Tennessee | 47103 | 6850 | 97 |
1975184 | 1975184 | 2021-12-02 | Loudon | Tennessee | 47105 | 9473 | 103 |
1975185 | 1975185 | 2021-12-02 | Macon | Tennessee | 47111 | 5588 | 99 |
1975186 | 1975186 | 2021-12-02 | Madison | Tennessee | 47113 | 18156 | 326 |
1975187 | 1975187 | 2021-12-02 | Marion | Tennessee | 47115 | 5904 | 66 |
1975188 | 1975188 | 2021-12-02 | Marshall | Tennessee | 47117 | 7022 | 91 |
1975189 | 1975189 | 2021-12-02 | Maury | Tennessee | 47119 | 19905 | 242 |
1975190 | 1975190 | 2021-12-02 | McMinn | Tennessee | 47107 | 10782 | 142 |
1975191 | 1975191 | 2021-12-02 | McNairy | Tennessee | 47109 | 4816 | 74 |
1975192 | 1975192 | 2021-12-02 | Meigs | Tennessee | 47121 | 2238 | 32 |
1975193 | 1975193 | 2021-12-02 | Monroe | Tennessee | 47123 | 9978 | 134 |
1975194 | 1975194 | 2021-12-02 | Montgomery | Tennessee | 47125 | 33693 | 362 |
1975195 | 1975195 | 2021-12-02 | Moore | Tennessee | 47127 | 1463 | 25 |
1975196 | 1975196 | 2021-12-02 | Morgan | Tennessee | 47129 | 3941 | 50 |
1975197 | 1975197 | 2021-12-02 | Obion | Tennessee | 47131 | 6911 | 114 |
1975198 | 1975198 | 2021-12-02 | Overton | Tennessee | 47133 | 4932 | 84 |
1975199 | 1975199 | 2021-12-02 | Perry | Tennessee | 47135 | 1647 | 35 |
1975200 | 1975200 | 2021-12-02 | Pickett | Tennessee | 47137 | 1128 | 26 |
1975201 | 1975201 | 2021-12-02 | Polk | Tennessee | 47139 | 3263 | 33 |
1975202 | 1975202 | 2021-12-02 | Putnam | Tennessee | 47141 | 17151 | 227 |
1975203 | 1975203 | 2021-12-02 | Rhea | Tennessee | 47143 | 7145 | 99 |
1975204 | 1975204 | 2021-12-02 | Roane | Tennessee | 47145 | 10393 | 163 |
1975205 | 1975205 | 2021-12-02 | Robertson | Tennessee | 47147 | 14414 | 199 |
1975206 | 1975206 | 2021-12-02 | Rutherford | Tennessee | 47149 | 64066 | 593 |
1975207 | 1975207 | 2021-12-02 | Scott | Tennessee | 47151 | 5744 | 66 |
1975208 | 1975208 | 2021-12-02 | Sequatchie | Tennessee | 47153 | 3071 | 38 |
1975209 | 1975209 | 2021-12-02 | Sevier | Tennessee | 47155 | 20775 | 286 |
1975210 | 1975210 | 2021-12-02 | Shelby | Tennessee | 47157 | 149410 | 2363 |
1975211 | 1975211 | 2021-12-02 | Smith | Tennessee | 47159 | 4257 | 53 |
1975212 | 1975212 | 2021-12-02 | Stewart | Tennessee | 47161 | 2199 | 36 |
1975213 | 1975213 | 2021-12-02 | Sullivan | Tennessee | 47163 | 28650 | 457 |
1975214 | 1975214 | 2021-12-02 | Sumner | Tennessee | 47165 | 35362 | 438 |
1975215 | 1975215 | 2021-12-02 | Tipton | Tennessee | 47167 | 11742 | 143 |
1975216 | 1975216 | 2021-12-02 | Trousdale | Tennessee | 47169 | 3246 | 27 |
1975217 | 1975217 | 2021-12-02 | Unicoi | Tennessee | 47171 | 3253 | 67 |
1975218 | 1975218 | 2021-12-02 | Union | Tennessee | 47173 | 3455 | 50 |
1975219 | 1975219 | 2021-12-02 | Unknown | Tennessee | 9460 | 134 | |
1975220 | 1975220 | 2021-12-02 | Van Buren | Tennessee | 47175 | 1288 | 30 |
1975221 | 1975221 | 2021-12-02 | Warren | Tennessee | 47177 | 8848 | 132 |
1975222 | 1975222 | 2021-12-02 | Washington | Tennessee | 47179 | 23228 | 345 |
1975223 | 1975223 | 2021-12-02 | Wayne | Tennessee | 47181 | 4170 | 41 |
1975224 | 1975224 | 2021-12-02 | Weakley | Tennessee | 47183 | 6431 | 91 |
1975225 | 1975225 | 2021-12-02 | White | Tennessee | 47185 | 5787 | 98 |
1975226 | 1975226 | 2021-12-02 | Williamson | Tennessee | 47187 | 41147 | 277 |
1975227 | 1975227 | 2021-12-02 | Wilson | Tennessee | 47189 | 27887 | 352 |
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);