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 195
- 47037 192
- 47157 192
- 47163 190
- 47093 188
- 47065 187
- 47089 187
- 47149 187
- 47013 186
- 47155 184
- 47021 182
- 47147 182
- 47165 182
- 47035 181
- 47045 181
- 47125 181
- 47179 181
- 47189 181
- 47001 180
- 47009 180
- 47011 180
- 47043 180
- 47059 180
- 47063 180
- 47119 180
- 47167 180
- 47017 179
- 47029 179
- 47047 179
- 47123 179
- …
county >30
- Williamson 195
- Davidson 192
- Shelby 192
- Sullivan 190
- Knox 188
- Hamilton 187
- Jefferson 187
- Rutherford 187
- Campbell 186
- Sevier 184
- Cheatham 182
- Robertson 182
- Sumner 182
- Cumberland 181
- Dyer 181
- Montgomery 181
- Washington 181
- Wilson 181
- Anderson 180
- Blount 180
- Bradley 180
- Dickson 180
- Greene 180
- Hamblen 180
- Maury 180
- Tipton 180
- Carroll 179
- Cocke 179
- Fayette 179
- Monroe 179
- …
state 1
- Tennessee · 16,656 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536941 | 536941 | 2020-09-15 | Anderson | Tennessee | 47001 | 1042 | 11 |
536942 | 536942 | 2020-09-15 | Bedford | Tennessee | 47003 | 1250 | 15 |
536943 | 536943 | 2020-09-15 | Benton | Tennessee | 47005 | 314 | 9 |
536944 | 536944 | 2020-09-15 | Bledsoe | Tennessee | 47007 | 832 | 4 |
536945 | 536945 | 2020-09-15 | Blount | Tennessee | 47009 | 2355 | 21 |
536946 | 536946 | 2020-09-15 | Bradley | Tennessee | 47011 | 2747 | 16 |
536947 | 536947 | 2020-09-15 | Campbell | Tennessee | 47013 | 396 | 3 |
536948 | 536948 | 2020-09-15 | Cannon | Tennessee | 47015 | 249 | 0 |
536949 | 536949 | 2020-09-15 | Carroll | Tennessee | 47017 | 766 | 16 |
536950 | 536950 | 2020-09-15 | Carter | Tennessee | 47019 | 1067 | 26 |
536951 | 536951 | 2020-09-15 | Cheatham | Tennessee | 47021 | 765 | 10 |
536952 | 536952 | 2020-09-15 | Chester | Tennessee | 47023 | 538 | 8 |
536953 | 536953 | 2020-09-15 | Claiborne | Tennessee | 47025 | 408 | 4 |
536954 | 536954 | 2020-09-15 | Clay | Tennessee | 47027 | 151 | 4 |
536955 | 536955 | 2020-09-15 | Cocke | Tennessee | 47029 | 712 | 9 |
536956 | 536956 | 2020-09-15 | Coffee | Tennessee | 47031 | 980 | 10 |
536957 | 536957 | 2020-09-15 | Crockett | Tennessee | 47033 | 487 | 19 |
536958 | 536958 | 2020-09-15 | Cumberland | Tennessee | 47035 | 1071 | 15 |
536959 | 536959 | 2020-09-15 | Davidson | Tennessee | 47037 | 27492 | 283 |
536960 | 536960 | 2020-09-15 | DeKalb | Tennessee | 47041 | 524 | 9 |
536961 | 536961 | 2020-09-15 | Decatur | Tennessee | 47039 | 416 | 6 |
536962 | 536962 | 2020-09-15 | Dickson | Tennessee | 47043 | 1138 | 12 |
536963 | 536963 | 2020-09-15 | Dyer | Tennessee | 47045 | 1161 | 13 |
536964 | 536964 | 2020-09-15 | Fayette | Tennessee | 47047 | 1063 | 16 |
536965 | 536965 | 2020-09-15 | Fentress | Tennessee | 47049 | 354 | 3 |
536966 | 536966 | 2020-09-15 | Franklin | Tennessee | 47051 | 788 | 7 |
536967 | 536967 | 2020-09-15 | Gibson | Tennessee | 47053 | 1383 | 19 |
536968 | 536968 | 2020-09-15 | Giles | Tennessee | 47055 | 531 | 17 |
536969 | 536969 | 2020-09-15 | Grainger | Tennessee | 47057 | 322 | 1 |
536970 | 536970 | 2020-09-15 | Greene | Tennessee | 47059 | 1018 | 32 |
536971 | 536971 | 2020-09-15 | Grundy | Tennessee | 47061 | 190 | 4 |
536972 | 536972 | 2020-09-15 | Hamblen | Tennessee | 47063 | 1775 | 22 |
536973 | 536973 | 2020-09-15 | Hamilton | Tennessee | 47065 | 8967 | 87 |
536974 | 536974 | 2020-09-15 | Hancock | Tennessee | 47067 | 105 | 2 |
536975 | 536975 | 2020-09-15 | Hardeman | Tennessee | 47069 | 1472 | 25 |
536976 | 536976 | 2020-09-15 | Hardin | Tennessee | 47071 | 897 | 14 |
536977 | 536977 | 2020-09-15 | Hawkins | Tennessee | 47073 | 718 | 14 |
536978 | 536978 | 2020-09-15 | Haywood | Tennessee | 47075 | 866 | 15 |
536979 | 536979 | 2020-09-15 | Henderson | Tennessee | 47077 | 1058 | 18 |
536980 | 536980 | 2020-09-15 | Henry | Tennessee | 47079 | 561 | 8 |
536981 | 536981 | 2020-09-15 | Hickman | Tennessee | 47081 | 481 | 4 |
536982 | 536982 | 2020-09-15 | Houston | Tennessee | 47083 | 157 | 0 |
536983 | 536983 | 2020-09-15 | Humphreys | Tennessee | 47085 | 209 | 3 |
536984 | 536984 | 2020-09-15 | Jackson | Tennessee | 47087 | 285 | 3 |
536985 | 536985 | 2020-09-15 | Jefferson | Tennessee | 47089 | 1015 | 13 |
536986 | 536986 | 2020-09-15 | Johnson | Tennessee | 47091 | 610 | 2 |
536987 | 536987 | 2020-09-15 | Knox | Tennessee | 47093 | 8914 | 67 |
536988 | 536988 | 2020-09-15 | Lake | Tennessee | 47095 | 863 | 2 |
536989 | 536989 | 2020-09-15 | Lauderdale | Tennessee | 47097 | 887 | 14 |
536990 | 536990 | 2020-09-15 | Lawrence | Tennessee | 47099 | 884 | 11 |
536991 | 536991 | 2020-09-15 | Lewis | Tennessee | 47101 | 158 | 1 |
536992 | 536992 | 2020-09-15 | Lincoln | Tennessee | 47103 | 537 | 1 |
536993 | 536993 | 2020-09-15 | Loudon | Tennessee | 47105 | 1054 | 6 |
536994 | 536994 | 2020-09-15 | Macon | Tennessee | 47111 | 983 | 19 |
536995 | 536995 | 2020-09-15 | Madison | Tennessee | 47113 | 2467 | 54 |
536996 | 536996 | 2020-09-15 | Marion | Tennessee | 47115 | 460 | 7 |
536997 | 536997 | 2020-09-15 | Marshall | Tennessee | 47117 | 658 | 4 |
536998 | 536998 | 2020-09-15 | Maury | Tennessee | 47119 | 2082 | 21 |
536999 | 536999 | 2020-09-15 | McMinn | Tennessee | 47107 | 962 | 24 |
537000 | 537000 | 2020-09-15 | McNairy | Tennessee | 47109 | 735 | 15 |
537001 | 537001 | 2020-09-15 | Meigs | Tennessee | 47121 | 207 | 3 |
537002 | 537002 | 2020-09-15 | Monroe | Tennessee | 47123 | 955 | 16 |
537003 | 537003 | 2020-09-15 | Montgomery | Tennessee | 47125 | 2833 | 41 |
537004 | 537004 | 2020-09-15 | Moore | Tennessee | 47127 | 133 | 1 |
537005 | 537005 | 2020-09-15 | Morgan | Tennessee | 47129 | 282 | 2 |
537006 | 537006 | 2020-09-15 | Obion | Tennessee | 47131 | 1005 | 8 |
537007 | 537007 | 2020-09-15 | Overton | Tennessee | 47133 | 612 | 3 |
537008 | 537008 | 2020-09-15 | Perry | Tennessee | 47135 | 133 | 0 |
537009 | 537009 | 2020-09-15 | Pickett | Tennessee | 47137 | 90 | 2 |
537010 | 537010 | 2020-09-15 | Polk | Tennessee | 47139 | 367 | 11 |
537011 | 537011 | 2020-09-15 | Putnam | Tennessee | 47141 | 2765 | 36 |
537012 | 537012 | 2020-09-15 | Rhea | Tennessee | 47143 | 745 | 9 |
537013 | 537013 | 2020-09-15 | Roane | Tennessee | 47145 | 761 | 4 |
537014 | 537014 | 2020-09-15 | Robertson | Tennessee | 47147 | 2107 | 32 |
537015 | 537015 | 2020-09-15 | Rutherford | Tennessee | 47149 | 8661 | 85 |
537016 | 537016 | 2020-09-15 | Scott | Tennessee | 47151 | 183 | 2 |
537017 | 537017 | 2020-09-15 | Sequatchie | Tennessee | 47153 | 201 | 2 |
537018 | 537018 | 2020-09-15 | Sevier | Tennessee | 47155 | 2443 | 13 |
537019 | 537019 | 2020-09-15 | Shelby | Tennessee | 47157 | 29330 | 433 |
537020 | 537020 | 2020-09-15 | Smith | Tennessee | 47159 | 634 | 10 |
537021 | 537021 | 2020-09-15 | Stewart | Tennessee | 47161 | 126 | 2 |
537022 | 537022 | 2020-09-15 | Sullivan | Tennessee | 47163 | 1963 | 31 |
537023 | 537023 | 2020-09-15 | Sumner | Tennessee | 47165 | 4548 | 92 |
537024 | 537024 | 2020-09-15 | Tipton | Tennessee | 47167 | 1650 | 17 |
537025 | 537025 | 2020-09-15 | Trousdale | Tennessee | 47169 | 1643 | 7 |
537026 | 537026 | 2020-09-15 | Unicoi | Tennessee | 47171 | 258 | 1 |
537027 | 537027 | 2020-09-15 | Union | Tennessee | 47173 | 284 | 1 |
537028 | 537028 | 2020-09-15 | Unknown | Tennessee | 0 | 5 | |
537029 | 537029 | 2020-09-15 | Van Buren | Tennessee | 47175 | 132 | 0 |
537030 | 537030 | 2020-09-15 | Warren | Tennessee | 47177 | 970 | 8 |
537031 | 537031 | 2020-09-15 | Washington | Tennessee | 47179 | 2025 | 26 |
537032 | 537032 | 2020-09-15 | Wayne | Tennessee | 47181 | 1477 | 4 |
537033 | 537033 | 2020-09-15 | Weakley | Tennessee | 47183 | 1037 | 17 |
537034 | 537034 | 2020-09-15 | White | Tennessee | 47185 | 700 | 8 |
537035 | 537035 | 2020-09-15 | Williamson | Tennessee | 47187 | 4879 | 35 |
537036 | 537036 | 2020-09-15 | Wilson | Tennessee | 47189 | 3223 | 37 |
533705 | 533705 | 2020-09-14 | Anderson | Tennessee | 47001 | 1035 | 10 |
533706 | 533706 | 2020-09-14 | Bedford | Tennessee | 47003 | 1241 | 14 |
533707 | 533707 | 2020-09-14 | Benton | Tennessee | 47005 | 310 | 9 |
533708 | 533708 | 2020-09-14 | Bledsoe | Tennessee | 47007 | 831 | 4 |
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);