ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74,719 rows where state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 47187 314
- 47037 311
- 47157 311
- 47163 309
- 47093 307
- 47065 306
- 47089 306
- 47149 306
- 47013 305
- 47155 303
- 47021 301
- 47147 301
- 47165 301
- 47035 300
- 47045 300
- 47125 300
- 47179 300
- 47189 300
- 47001 299
- 47009 299
- 47011 299
- 47043 299
- 47059 299
- 47063 299
- 47119 299
- 47167 299
- 47017 298
- 47029 298
- 47047 298
- 47123 298
- …
county >30
- Williamson 314
- Davidson 311
- Shelby 311
- Sullivan 309
- Knox 307
- Hamilton 306
- Jefferson 306
- Rutherford 306
- Campbell 305
- Sevier 303
- Cheatham 301
- Robertson 301
- Sumner 301
- Cumberland 300
- Dyer 300
- Montgomery 300
- Washington 300
- Wilson 300
- Anderson 299
- Blount 299
- Bradley 299
- Dickson 299
- Greene 299
- Hamblen 299
- Maury 299
- Tipton 299
- Carroll 298
- Cocke 298
- Fayette 298
- Monroe 298
- …
state 1
- Tennessee · 28,063 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922963 | 922963 | 2021-01-12 | Anderson | Tennessee | 47001 | 6506 | 93 |
922964 | 922964 | 2021-01-12 | Bedford | Tennessee | 47003 | 5138 | 83 |
922965 | 922965 | 2021-01-12 | Benton | Tennessee | 47005 | 1275 | 32 |
922966 | 922966 | 2021-01-12 | Bledsoe | Tennessee | 47007 | 1703 | 10 |
922967 | 922967 | 2021-01-12 | Blount | Tennessee | 47009 | 11245 | 112 |
922968 | 922968 | 2021-01-12 | Bradley | Tennessee | 47011 | 10246 | 89 |
922969 | 922969 | 2021-01-12 | Campbell | Tennessee | 47013 | 3096 | 39 |
922970 | 922970 | 2021-01-12 | Cannon | Tennessee | 47015 | 1512 | 17 |
922971 | 922971 | 2021-01-12 | Carroll | Tennessee | 47017 | 2984 | 58 |
922972 | 922972 | 2021-01-12 | Carter | Tennessee | 47019 | 4968 | 104 |
922973 | 922973 | 2021-01-12 | Cheatham | Tennessee | 47021 | 3247 | 28 |
922974 | 922974 | 2021-01-12 | Chester | Tennessee | 47023 | 1679 | 36 |
922975 | 922975 | 2021-01-12 | Claiborne | Tennessee | 47025 | 1918 | 20 |
922976 | 922976 | 2021-01-12 | Clay | Tennessee | 47027 | 896 | 25 |
922977 | 922977 | 2021-01-12 | Cocke | Tennessee | 47029 | 3312 | 55 |
922978 | 922978 | 2021-01-12 | Coffee | Tennessee | 47031 | 5432 | 79 |
922979 | 922979 | 2021-01-12 | Crockett | Tennessee | 47033 | 1775 | 37 |
922980 | 922980 | 2021-01-12 | Cumberland | Tennessee | 47035 | 5164 | 68 |
922981 | 922981 | 2021-01-12 | Davidson | Tennessee | 47037 | 77113 | 641 |
922982 | 922982 | 2021-01-12 | DeKalb | Tennessee | 47041 | 2350 | 39 |
922983 | 922983 | 2021-01-12 | Decatur | Tennessee | 47039 | 1442 | 23 |
922984 | 922984 | 2021-01-12 | Dickson | Tennessee | 47043 | 5156 | 75 |
922985 | 922985 | 2021-01-12 | Dyer | Tennessee | 47045 | 4609 | 81 |
922986 | 922986 | 2021-01-12 | Fayette | Tennessee | 47047 | 3806 | 51 |
922987 | 922987 | 2021-01-12 | Fentress | Tennessee | 47049 | 2066 | 30 |
922988 | 922988 | 2021-01-12 | Franklin | Tennessee | 47051 | 3941 | 51 |
922989 | 922989 | 2021-01-12 | Gibson | Tennessee | 47053 | 5490 | 107 |
922990 | 922990 | 2021-01-12 | Giles | Tennessee | 47055 | 3111 | 70 |
922991 | 922991 | 2021-01-12 | Grainger | Tennessee | 47057 | 1997 | 29 |
922992 | 922992 | 2021-01-12 | Greene | Tennessee | 47059 | 6391 | 105 |
922993 | 922993 | 2021-01-12 | Grundy | Tennessee | 47061 | 1359 | 20 |
922994 | 922994 | 2021-01-12 | Hamblen | Tennessee | 47063 | 6660 | 102 |
922995 | 922995 | 2021-01-12 | Hamilton | Tennessee | 47065 | 34744 | 319 |
922996 | 922996 | 2021-01-12 | Hancock | Tennessee | 47067 | 384 | 6 |
922997 | 922997 | 2021-01-12 | Hardeman | Tennessee | 47069 | 3026 | 51 |
922998 | 922998 | 2021-01-12 | Hardin | Tennessee | 47071 | 2911 | 42 |
922999 | 922999 | 2021-01-12 | Hawkins | Tennessee | 47073 | 4287 | 65 |
923000 | 923000 | 2021-01-12 | Haywood | Tennessee | 47075 | 2335 | 44 |
923001 | 923001 | 2021-01-12 | Henderson | Tennessee | 47077 | 3259 | 53 |
923002 | 923002 | 2021-01-12 | Henry | Tennessee | 47079 | 2511 | 56 |
923003 | 923003 | 2021-01-12 | Hickman | Tennessee | 47081 | 2151 | 34 |
923004 | 923004 | 2021-01-12 | Houston | Tennessee | 47083 | 912 | 22 |
923005 | 923005 | 2021-01-12 | Humphreys | Tennessee | 47085 | 1274 | 16 |
923006 | 923006 | 2021-01-12 | Jackson | Tennessee | 47087 | 1020 | 20 |
923007 | 923007 | 2021-01-12 | Jefferson | Tennessee | 47089 | 4495 | 75 |
923008 | 923008 | 2021-01-12 | Johnson | Tennessee | 47091 | 1928 | 30 |
923009 | 923009 | 2021-01-12 | Knox | Tennessee | 47093 | 38472 | 379 |
923010 | 923010 | 2021-01-12 | Lake | Tennessee | 47095 | 1518 | 19 |
923011 | 923011 | 2021-01-12 | Lauderdale | Tennessee | 47097 | 2870 | 31 |
923012 | 923012 | 2021-01-12 | Lawrence | Tennessee | 47099 | 4938 | 68 |
923013 | 923013 | 2021-01-12 | Lewis | Tennessee | 47101 | 1245 | 20 |
923014 | 923014 | 2021-01-12 | Lincoln | Tennessee | 47103 | 3657 | 41 |
923015 | 923015 | 2021-01-12 | Loudon | Tennessee | 47105 | 4752 | 47 |
923016 | 923016 | 2021-01-12 | Macon | Tennessee | 47111 | 2790 | 50 |
923017 | 923017 | 2021-01-12 | Madison | Tennessee | 47113 | 8866 | 168 |
923018 | 923018 | 2021-01-12 | Marion | Tennessee | 47115 | 2160 | 31 |
923019 | 923019 | 2021-01-12 | Marshall | Tennessee | 47117 | 3243 | 34 |
923020 | 923020 | 2021-01-12 | Maury | Tennessee | 47119 | 10591 | 118 |
923021 | 923021 | 2021-01-12 | McMinn | Tennessee | 47107 | 4898 | 72 |
923022 | 923022 | 2021-01-12 | McNairy | Tennessee | 47109 | 2281 | 42 |
923023 | 923023 | 2021-01-12 | Meigs | Tennessee | 47121 | 1085 | 16 |
923024 | 923024 | 2021-01-12 | Monroe | Tennessee | 47123 | 4358 | 62 |
923025 | 923025 | 2021-01-12 | Montgomery | Tennessee | 47125 | 13540 | 142 |
923026 | 923026 | 2021-01-12 | Moore | Tennessee | 47127 | 775 | 6 |
923027 | 923027 | 2021-01-12 | Morgan | Tennessee | 47129 | 1800 | 12 |
923028 | 923028 | 2021-01-12 | Obion | Tennessee | 47131 | 3922 | 74 |
923029 | 923029 | 2021-01-12 | Overton | Tennessee | 47133 | 2447 | 42 |
923030 | 923030 | 2021-01-12 | Perry | Tennessee | 47135 | 919 | 24 |
923031 | 923031 | 2021-01-12 | Pickett | Tennessee | 47137 | 640 | 18 |
923032 | 923032 | 2021-01-12 | Polk | Tennessee | 47139 | 1356 | 17 |
923033 | 923033 | 2021-01-12 | Putnam | Tennessee | 47141 | 9632 | 131 |
923034 | 923034 | 2021-01-12 | Rhea | Tennessee | 47143 | 3664 | 54 |
923035 | 923035 | 2021-01-12 | Roane | Tennessee | 47145 | 5002 | 71 |
923036 | 923036 | 2021-01-12 | Robertson | Tennessee | 47147 | 7319 | 81 |
923037 | 923037 | 2021-01-12 | Rutherford | Tennessee | 47149 | 31972 | 271 |
923038 | 923038 | 2021-01-12 | Scott | Tennessee | 47151 | 2176 | 30 |
923039 | 923039 | 2021-01-12 | Sequatchie | Tennessee | 47153 | 1315 | 18 |
923040 | 923040 | 2021-01-12 | Sevier | Tennessee | 47155 | 10056 | 99 |
923041 | 923041 | 2021-01-12 | Shelby | Tennessee | 47157 | 75016 | 1055 |
923042 | 923042 | 2021-01-12 | Smith | Tennessee | 47159 | 2255 | 26 |
923043 | 923043 | 2021-01-12 | Stewart | Tennessee | 47161 | 1010 | 20 |
923044 | 923044 | 2021-01-12 | Sullivan | Tennessee | 47163 | 12133 | 203 |
923045 | 923045 | 2021-01-12 | Sumner | Tennessee | 47165 | 17584 | 226 |
923046 | 923046 | 2021-01-12 | Tipton | Tennessee | 47167 | 5996 | 61 |
923047 | 923047 | 2021-01-12 | Trousdale | Tennessee | 47169 | 2269 | 13 |
923048 | 923048 | 2021-01-12 | Unicoi | Tennessee | 47171 | 1608 | 43 |
923049 | 923049 | 2021-01-12 | Union | Tennessee | 47173 | 1340 | 20 |
923050 | 923050 | 2021-01-12 | Unknown | Tennessee | 12463 | 105 | |
923051 | 923051 | 2021-01-12 | Van Buren | Tennessee | 47175 | 623 | 7 |
923052 | 923052 | 2021-01-12 | Warren | Tennessee | 47177 | 4833 | 51 |
923053 | 923053 | 2021-01-12 | Washington | Tennessee | 47179 | 11534 | 188 |
923054 | 923054 | 2021-01-12 | Wayne | Tennessee | 47181 | 2566 | 18 |
923055 | 923055 | 2021-01-12 | Weakley | Tennessee | 47183 | 3341 | 48 |
923056 | 923056 | 2021-01-12 | White | Tennessee | 47185 | 3001 | 42 |
923057 | 923057 | 2021-01-12 | Williamson | Tennessee | 47187 | 20592 | 138 |
923058 | 923058 | 2021-01-12 | Wilson | Tennessee | 47189 | 13980 | 147 |
919718 | 919718 | 2021-01-11 | Anderson | Tennessee | 47001 | 6473 | 91 |
919719 | 919719 | 2021-01-11 | Bedford | Tennessee | 47003 | 5104 | 79 |
919720 | 919720 | 2021-01-11 | Benton | Tennessee | 47005 | 1271 | 32 |
919721 | 919721 | 2021-01-11 | Bledsoe | Tennessee | 47007 | 1695 | 10 |
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);