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-12-03 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 96
- 47001 1
- 47003 1
- 47005 1
- 47007 1
- 47009 1
- 47011 1
- 47013 1
- 47015 1
- 47017 1
- 47019 1
- 47021 1
- 47023 1
- 47025 1
- 47027 1
- 47029 1
- 47031 1
- 47033 1
- 47035 1
- 47037 1
- 47039 1
- 47041 1
- 47043 1
- 47045 1
- 47047 1
- 47049 1
- 47051 1
- 47053 1
- 47055 1
- 47057 1
- 47059 1
- 47061 1
- 47063 1
- 47065 1
- 47067 1
- 47069 1
- 47071 1
- 47073 1
- 47075 1
- 47077 1
- 47079 1
- 47081 1
- 47083 1
- 47085 1
- 47087 1
- 47089 1
- 47091 1
- 47093 1
- 47095 1
- 47097 1
- 47099 1
- 47101 1
- 47103 1
- 47105 1
- 47107 1
- 47109 1
- 47111 1
- 47113 1
- 47115 1
- 47117 1
- 47119 1
- 47121 1
- 47123 1
- 47125 1
- 47127 1
- 47129 1
- 47131 1
- 47133 1
- 47135 1
- 47137 1
- 47139 1
- 47141 1
- 47143 1
- 47145 1
- 47147 1
- 47149 1
- 47151 1
- 47153 1
- 47155 1
- 47157 1
- 47159 1
- 47161 1
- 47163 1
- 47165 1
- 47167 1
- 47169 1
- 47171 1
- 47173 1
- 47175 1
- 47177 1
- 47179 1
- 47181 1
- 47183 1
- 47185 1
- 47187 1
- 47189 1
- - 1
county 96
- Anderson 1
- Bedford 1
- Benton 1
- Bledsoe 1
- Blount 1
- Bradley 1
- Campbell 1
- Cannon 1
- Carroll 1
- Carter 1
- Cheatham 1
- Chester 1
- Claiborne 1
- Clay 1
- Cocke 1
- Coffee 1
- Crockett 1
- Cumberland 1
- Davidson 1
- DeKalb 1
- Decatur 1
- Dickson 1
- Dyer 1
- Fayette 1
- Fentress 1
- Franklin 1
- Gibson 1
- Giles 1
- Grainger 1
- Greene 1
- Grundy 1
- Hamblen 1
- Hamilton 1
- Hancock 1
- Hardeman 1
- Hardin 1
- Hawkins 1
- Haywood 1
- Henderson 1
- Henry 1
- Hickman 1
- Houston 1
- Humphreys 1
- Jackson 1
- Jefferson 1
- Johnson 1
- Knox 1
- Lake 1
- Lauderdale 1
- Lawrence 1
- Lewis 1
- Lincoln 1
- Loudon 1
- Macon 1
- Madison 1
- Marion 1
- Marshall 1
- Maury 1
- McMinn 1
- McNairy 1
- Meigs 1
- Monroe 1
- Montgomery 1
- Moore 1
- Morgan 1
- Obion 1
- Overton 1
- Perry 1
- Pickett 1
- Polk 1
- Putnam 1
- Rhea 1
- Roane 1
- Robertson 1
- Rutherford 1
- Scott 1
- Sequatchie 1
- Sevier 1
- Shelby 1
- Smith 1
- Stewart 1
- Sullivan 1
- Sumner 1
- Tipton 1
- Trousdale 1
- Unicoi 1
- Union 1
- Unknown 1
- Van Buren 1
- Warren 1
- Washington 1
- Wayne 1
- Weakley 1
- White 1
- Williamson 1
- Wilson 1
state 1
- Tennessee · 96 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
793148 | 793148 | 2020-12-03 | Anderson | Tennessee | 47001 | 3239 | 31 |
793149 | 793149 | 2020-12-03 | Bedford | Tennessee | 47003 | 2957 | 34 |
793150 | 793150 | 2020-12-03 | Benton | Tennessee | 47005 | 880 | 16 |
793151 | 793151 | 2020-12-03 | Bledsoe | Tennessee | 47007 | 1224 | 5 |
793152 | 793152 | 2020-12-03 | Blount | Tennessee | 47009 | 6089 | 63 |
793153 | 793153 | 2020-12-03 | Bradley | Tennessee | 47011 | 5716 | 37 |
793154 | 793154 | 2020-12-03 | Campbell | Tennessee | 47013 | 1653 | 24 |
793155 | 793155 | 2020-12-03 | Cannon | Tennessee | 47015 | 810 | 4 |
793156 | 793156 | 2020-12-03 | Carroll | Tennessee | 47017 | 1853 | 36 |
793157 | 793157 | 2020-12-03 | Carter | Tennessee | 47019 | 2983 | 61 |
793158 | 793158 | 2020-12-03 | Cheatham | Tennessee | 47021 | 1696 | 17 |
793159 | 793159 | 2020-12-03 | Chester | Tennessee | 47023 | 1063 | 22 |
793160 | 793160 | 2020-12-03 | Claiborne | Tennessee | 47025 | 964 | 10 |
793161 | 793161 | 2020-12-03 | Clay | Tennessee | 47027 | 571 | 19 |
793162 | 793162 | 2020-12-03 | Cocke | Tennessee | 47029 | 1720 | 30 |
793163 | 793163 | 2020-12-03 | Coffee | Tennessee | 47031 | 3060 | 43 |
793164 | 793164 | 2020-12-03 | Crockett | Tennessee | 47033 | 1184 | 28 |
793165 | 793165 | 2020-12-03 | Cumberland | Tennessee | 47035 | 2729 | 37 |
793166 | 793166 | 2020-12-03 | Davidson | Tennessee | 47037 | 48492 | 429 |
793167 | 793167 | 2020-12-03 | DeKalb | Tennessee | 47041 | 1246 | 24 |
793168 | 793168 | 2020-12-03 | Decatur | Tennessee | 47039 | 974 | 13 |
793169 | 793169 | 2020-12-03 | Dickson | Tennessee | 47043 | 3050 | 37 |
793170 | 793170 | 2020-12-03 | Dyer | Tennessee | 47045 | 3326 | 52 |
793171 | 793171 | 2020-12-03 | Fayette | Tennessee | 47047 | 2369 | 40 |
793172 | 793172 | 2020-12-03 | Fentress | Tennessee | 47049 | 1268 | 24 |
793173 | 793173 | 2020-12-03 | Franklin | Tennessee | 47051 | 2245 | 38 |
793174 | 793174 | 2020-12-03 | Gibson | Tennessee | 47053 | 3393 | 72 |
793175 | 793175 | 2020-12-03 | Giles | Tennessee | 47055 | 1576 | 49 |
793176 | 793176 | 2020-12-03 | Grainger | Tennessee | 47057 | 1088 | 18 |
793177 | 793177 | 2020-12-03 | Greene | Tennessee | 47059 | 3355 | 74 |
793178 | 793178 | 2020-12-03 | Grundy | Tennessee | 47061 | 806 | 14 |
793179 | 793179 | 2020-12-03 | Hamblen | Tennessee | 47063 | 3724 | 62 |
793180 | 793180 | 2020-12-03 | Hamilton | Tennessee | 47065 | 19501 | 164 |
793181 | 793181 | 2020-12-03 | Hancock | Tennessee | 47067 | 196 | 4 |
793182 | 793182 | 2020-12-03 | Hardeman | Tennessee | 47069 | 2295 | 38 |
793183 | 793183 | 2020-12-03 | Hardin | Tennessee | 47071 | 1860 | 27 |
793184 | 793184 | 2020-12-03 | Hawkins | Tennessee | 47073 | 2130 | 35 |
793185 | 793185 | 2020-12-03 | Haywood | Tennessee | 47075 | 1688 | 30 |
793186 | 793186 | 2020-12-03 | Henderson | Tennessee | 47077 | 1959 | 34 |
793187 | 793187 | 2020-12-03 | Henry | Tennessee | 47079 | 1633 | 21 |
793188 | 793188 | 2020-12-03 | Hickman | Tennessee | 47081 | 1246 | 19 |
793189 | 793189 | 2020-12-03 | Houston | Tennessee | 47083 | 605 | 20 |
793190 | 793190 | 2020-12-03 | Humphreys | Tennessee | 47085 | 764 | 8 |
793191 | 793191 | 2020-12-03 | Jackson | Tennessee | 47087 | 725 | 10 |
793192 | 793192 | 2020-12-03 | Jefferson | Tennessee | 47089 | 2454 | 35 |
793193 | 793193 | 2020-12-03 | Johnson | Tennessee | 47091 | 1475 | 23 |
793194 | 793194 | 2020-12-03 | Knox | Tennessee | 47093 | 20633 | 181 |
793195 | 793195 | 2020-12-03 | Lake | Tennessee | 47095 | 1193 | 6 |
793196 | 793196 | 2020-12-03 | Lauderdale | Tennessee | 47097 | 2131 | 23 |
793197 | 793197 | 2020-12-03 | Lawrence | Tennessee | 47099 | 2902 | 37 |
793198 | 793198 | 2020-12-03 | Lewis | Tennessee | 47101 | 815 | 16 |
793199 | 793199 | 2020-12-03 | Lincoln | Tennessee | 47103 | 1775 | 20 |
793200 | 793200 | 2020-12-03 | Loudon | Tennessee | 47105 | 2443 | 20 |
793201 | 793201 | 2020-12-03 | Macon | Tennessee | 47111 | 1908 | 29 |
793202 | 793202 | 2020-12-03 | Madison | Tennessee | 47113 | 5602 | 114 |
793203 | 793203 | 2020-12-03 | Marion | Tennessee | 47115 | 1187 | 19 |
793204 | 793204 | 2020-12-03 | Marshall | Tennessee | 47117 | 1853 | 22 |
793205 | 793205 | 2020-12-03 | Maury | Tennessee | 47119 | 6364 | 72 |
793206 | 793206 | 2020-12-03 | McMinn | Tennessee | 47107 | 2810 | 56 |
793207 | 793207 | 2020-12-03 | McNairy | Tennessee | 47109 | 1437 | 34 |
793208 | 793208 | 2020-12-03 | Meigs | Tennessee | 47121 | 525 | 12 |
793209 | 793209 | 2020-12-03 | Monroe | Tennessee | 47123 | 2341 | 46 |
793210 | 793210 | 2020-12-03 | Montgomery | Tennessee | 47125 | 7172 | 86 |
793211 | 793211 | 2020-12-03 | Moore | Tennessee | 47127 | 420 | 2 |
793212 | 793212 | 2020-12-03 | Morgan | Tennessee | 47129 | 799 | 6 |
793213 | 793213 | 2020-12-03 | Obion | Tennessee | 47131 | 2780 | 53 |
793214 | 793214 | 2020-12-03 | Overton | Tennessee | 47133 | 1577 | 36 |
793215 | 793215 | 2020-12-03 | Perry | Tennessee | 47135 | 509 | 22 |
793216 | 793216 | 2020-12-03 | Pickett | Tennessee | 47137 | 398 | 14 |
793217 | 793217 | 2020-12-03 | Polk | Tennessee | 47139 | 709 | 15 |
793218 | 793218 | 2020-12-03 | Putnam | Tennessee | 47141 | 6142 | 84 |
793219 | 793219 | 2020-12-03 | Rhea | Tennessee | 47143 | 1878 | 36 |
793220 | 793220 | 2020-12-03 | Roane | Tennessee | 47145 | 2557 | 31 |
793221 | 793221 | 2020-12-03 | Robertson | Tennessee | 47147 | 4043 | 56 |
793222 | 793222 | 2020-12-03 | Rutherford | Tennessee | 47149 | 18968 | 169 |
793223 | 793223 | 2020-12-03 | Scott | Tennessee | 47151 | 1173 | 7 |
793224 | 793224 | 2020-12-03 | Sequatchie | Tennessee | 47153 | 584 | 5 |
793225 | 793225 | 2020-12-03 | Sevier | Tennessee | 47155 | 5287 | 35 |
793226 | 793226 | 2020-12-03 | Shelby | Tennessee | 47157 | 49731 | 687 |
793227 | 793227 | 2020-12-03 | Smith | Tennessee | 47159 | 1509 | 20 |
793228 | 793228 | 2020-12-03 | Stewart | Tennessee | 47161 | 633 | 17 |
793229 | 793229 | 2020-12-03 | Sullivan | Tennessee | 47163 | 6979 | 111 |
793230 | 793230 | 2020-12-03 | Sumner | Tennessee | 47165 | 10566 | 142 |
793231 | 793231 | 2020-12-03 | Tipton | Tennessee | 47167 | 3858 | 39 |
793232 | 793232 | 2020-12-03 | Trousdale | Tennessee | 47169 | 1926 | 12 |
793233 | 793233 | 2020-12-03 | Unicoi | Tennessee | 47171 | 960 | 26 |
793234 | 793234 | 2020-12-03 | Union | Tennessee | 47173 | 766 | 5 |
793235 | 793235 | 2020-12-03 | Unknown | Tennessee | 285 | 1 | |
793236 | 793236 | 2020-12-03 | Van Buren | Tennessee | 47175 | 387 | 2 |
793237 | 793237 | 2020-12-03 | Warren | Tennessee | 47177 | 2519 | 19 |
793238 | 793238 | 2020-12-03 | Washington | Tennessee | 47179 | 6572 | 116 |
793239 | 793239 | 2020-12-03 | Wayne | Tennessee | 47181 | 1976 | 10 |
793240 | 793240 | 2020-12-03 | Weakley | Tennessee | 47183 | 2271 | 36 |
793241 | 793241 | 2020-12-03 | White | Tennessee | 47185 | 1886 | 19 |
793242 | 793242 | 2020-12-03 | Williamson | Tennessee | 47187 | 12090 | 86 |
793243 | 793243 | 2020-12-03 | Wilson | Tennessee | 47189 | 8016 | 84 |
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);