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-09-28 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1763907 | 1763907 | 2021-09-28 | Anderson | Tennessee | 47001 | 12190 | 198 |
1763908 | 1763908 | 2021-09-28 | Bedford | Tennessee | 47003 | 8680 | 148 |
1763909 | 1763909 | 2021-09-28 | Benton | Tennessee | 47005 | 2598 | 44 |
1763910 | 1763910 | 2021-09-28 | Bledsoe | Tennessee | 47007 | 3308 | 13 |
1763911 | 1763911 | 2021-09-28 | Blount | Tennessee | 47009 | 22517 | 241 |
1763912 | 1763912 | 2021-09-28 | Bradley | Tennessee | 47011 | 21316 | 170 |
1763913 | 1763913 | 2021-09-28 | Campbell | Tennessee | 47013 | 6426 | 71 |
1763914 | 1763914 | 2021-09-28 | Cannon | Tennessee | 47015 | 2694 | 38 |
1763915 | 1763915 | 2021-09-28 | Carroll | Tennessee | 47017 | 5418 | 95 |
1763916 | 1763916 | 2021-09-28 | Carter | Tennessee | 47019 | 9970 | 203 |
1763917 | 1763917 | 2021-09-28 | Cheatham | Tennessee | 47021 | 6676 | 63 |
1763918 | 1763918 | 2021-09-28 | Chester | Tennessee | 47023 | 3353 | 66 |
1763919 | 1763919 | 2021-09-28 | Claiborne | Tennessee | 47025 | 5040 | 90 |
1763920 | 1763920 | 2021-09-28 | Clay | Tennessee | 47027 | 1427 | 35 |
1763921 | 1763921 | 2021-09-28 | Cocke | Tennessee | 47029 | 6888 | 104 |
1763922 | 1763922 | 2021-09-28 | Coffee | Tennessee | 47031 | 10016 | 144 |
1763923 | 1763923 | 2021-09-28 | Crockett | Tennessee | 47033 | 3244 | 59 |
1763924 | 1763924 | 2021-09-28 | Cumberland | Tennessee | 47035 | 10476 | 199 |
1763925 | 1763925 | 2021-09-28 | Davidson | Tennessee | 47037 | 127188 | 1090 |
1763926 | 1763926 | 2021-09-28 | DeKalb | Tennessee | 47041 | 4027 | 62 |
1763927 | 1763927 | 2021-09-28 | Decatur | Tennessee | 47039 | 2316 | 42 |
1763928 | 1763928 | 2021-09-28 | Dickson | Tennessee | 47043 | 9862 | 157 |
1763929 | 1763929 | 2021-09-28 | Dyer | Tennessee | 47045 | 7881 | 132 |
1763930 | 1763930 | 2021-09-28 | Fayette | Tennessee | 47047 | 7014 | 97 |
1763931 | 1763931 | 2021-09-28 | Fentress | Tennessee | 47049 | 3397 | 60 |
1763932 | 1763932 | 2021-09-28 | Franklin | Tennessee | 47051 | 7585 | 96 |
1763933 | 1763933 | 2021-09-28 | Gibson | Tennessee | 47053 | 10252 | 181 |
1763934 | 1763934 | 2021-09-28 | Giles | Tennessee | 47055 | 5643 | 113 |
1763935 | 1763935 | 2021-09-28 | Grainger | Tennessee | 47057 | 4071 | 58 |
1763936 | 1763936 | 2021-09-28 | Greene | Tennessee | 47059 | 12483 | 213 |
1763937 | 1763937 | 2021-09-28 | Grundy | Tennessee | 47061 | 2636 | 37 |
1763938 | 1763938 | 2021-09-28 | Hamblen | Tennessee | 47063 | 12512 | 185 |
1763939 | 1763939 | 2021-09-28 | Hamilton | Tennessee | 47065 | 61327 | 621 |
1763940 | 1763940 | 2021-09-28 | Hancock | Tennessee | 47067 | 1097 | 15 |
1763941 | 1763941 | 2021-09-28 | Hardeman | Tennessee | 47069 | 4951 | 76 |
1763942 | 1763942 | 2021-09-28 | Hardin | Tennessee | 47071 | 5293 | 79 |
1763943 | 1763943 | 2021-09-28 | Hawkins | Tennessee | 47073 | 9639 | 152 |
1763944 | 1763944 | 2021-09-28 | Haywood | Tennessee | 47075 | 3712 | 70 |
1763945 | 1763945 | 2021-09-28 | Henderson | Tennessee | 47077 | 5442 | 93 |
1763946 | 1763946 | 2021-09-28 | Henry | Tennessee | 47079 | 5250 | 79 |
1763947 | 1763947 | 2021-09-28 | Hickman | Tennessee | 47081 | 4416 | 65 |
1763948 | 1763948 | 2021-09-28 | Houston | Tennessee | 47083 | 1760 | 41 |
1763949 | 1763949 | 2021-09-28 | Humphreys | Tennessee | 47085 | 2981 | 44 |
1763950 | 1763950 | 2021-09-28 | Jackson | Tennessee | 47087 | 1961 | 38 |
1763951 | 1763951 | 2021-09-28 | Jefferson | Tennessee | 47089 | 9412 | 135 |
1763952 | 1763952 | 2021-09-28 | Johnson | Tennessee | 47091 | 3339 | 45 |
1763953 | 1763953 | 2021-09-28 | Knox | Tennessee | 47093 | 74086 | 844 |
1763954 | 1763954 | 2021-09-28 | Lake | Tennessee | 47095 | 1952 | 31 |
1763955 | 1763955 | 2021-09-28 | Lauderdale | Tennessee | 47097 | 5041 | 59 |
1763956 | 1763956 | 2021-09-28 | Lawrence | Tennessee | 47099 | 9083 | 113 |
1763957 | 1763957 | 2021-09-28 | Lewis | Tennessee | 47101 | 2455 | 35 |
1763958 | 1763958 | 2021-09-28 | Lincoln | Tennessee | 47103 | 6352 | 79 |
1763959 | 1763959 | 2021-09-28 | Loudon | Tennessee | 47105 | 8742 | 87 |
1763960 | 1763960 | 2021-09-28 | Macon | Tennessee | 47111 | 5238 | 86 |
1763961 | 1763961 | 2021-09-28 | Madison | Tennessee | 47113 | 16999 | 291 |
1763962 | 1763962 | 2021-09-28 | Marion | Tennessee | 47115 | 5499 | 52 |
1763963 | 1763963 | 2021-09-28 | Marshall | Tennessee | 47117 | 6556 | 81 |
1763964 | 1763964 | 2021-09-28 | Maury | Tennessee | 47119 | 18613 | 211 |
1763965 | 1763965 | 2021-09-28 | McMinn | Tennessee | 47107 | 10046 | 117 |
1763966 | 1763966 | 2021-09-28 | McNairy | Tennessee | 47109 | 4384 | 63 |
1763967 | 1763967 | 2021-09-28 | Meigs | Tennessee | 47121 | 2079 | 25 |
1763968 | 1763968 | 2021-09-28 | Monroe | Tennessee | 47123 | 9247 | 114 |
1763969 | 1763969 | 2021-09-28 | Montgomery | Tennessee | 47125 | 31197 | 311 |
1763970 | 1763970 | 2021-09-28 | Moore | Tennessee | 47127 | 1386 | 19 |
1763971 | 1763971 | 2021-09-28 | Morgan | Tennessee | 47129 | 3566 | 44 |
1763972 | 1763972 | 2021-09-28 | Obion | Tennessee | 47131 | 6327 | 108 |
1763973 | 1763973 | 2021-09-28 | Overton | Tennessee | 47133 | 4498 | 77 |
1763974 | 1763974 | 2021-09-28 | Perry | Tennessee | 47135 | 1533 | 31 |
1763975 | 1763975 | 2021-09-28 | Pickett | Tennessee | 47137 | 1004 | 24 |
1763976 | 1763976 | 2021-09-28 | Polk | Tennessee | 47139 | 3011 | 27 |
1763977 | 1763977 | 2021-09-28 | Putnam | Tennessee | 47141 | 16094 | 207 |
1763978 | 1763978 | 2021-09-28 | Rhea | Tennessee | 47143 | 6648 | 89 |
1763979 | 1763979 | 2021-09-28 | Roane | Tennessee | 47145 | 9384 | 141 |
1763980 | 1763980 | 2021-09-28 | Robertson | Tennessee | 47147 | 13554 | 170 |
1763981 | 1763981 | 2021-09-28 | Rutherford | Tennessee | 47149 | 59479 | 514 |
1763982 | 1763982 | 2021-09-28 | Scott | Tennessee | 47151 | 4754 | 54 |
1763983 | 1763983 | 2021-09-28 | Sequatchie | Tennessee | 47153 | 2833 | 30 |
1763984 | 1763984 | 2021-09-28 | Sevier | Tennessee | 47155 | 18975 | 240 |
1763985 | 1763985 | 2021-09-28 | Shelby | Tennessee | 47157 | 141020 | 2066 |
1763986 | 1763986 | 2021-09-28 | Smith | Tennessee | 47159 | 4007 | 44 |
1763987 | 1763987 | 2021-09-28 | Stewart | Tennessee | 47161 | 2009 | 30 |
1763988 | 1763988 | 2021-09-28 | Sullivan | Tennessee | 47163 | 25163 | 388 |
1763989 | 1763989 | 2021-09-28 | Sumner | Tennessee | 47165 | 32944 | 399 |
1763990 | 1763990 | 2021-09-28 | Tipton | Tennessee | 47167 | 10872 | 125 |
1763991 | 1763991 | 2021-09-28 | Trousdale | Tennessee | 47169 | 3033 | 24 |
1763992 | 1763992 | 2021-09-28 | Unicoi | Tennessee | 47171 | 3006 | 58 |
1763993 | 1763993 | 2021-09-28 | Union | Tennessee | 47173 | 2830 | 42 |
1763994 | 1763994 | 2021-09-28 | Unknown | Tennessee | 8354 | 116 | |
1763995 | 1763995 | 2021-09-28 | Van Buren | Tennessee | 47175 | 1164 | 25 |
1763996 | 1763996 | 2021-09-28 | Warren | Tennessee | 47177 | 8157 | 101 |
1763997 | 1763997 | 2021-09-28 | Washington | Tennessee | 47179 | 20625 | 306 |
1763998 | 1763998 | 2021-09-28 | Wayne | Tennessee | 47181 | 3895 | 38 |
1763999 | 1763999 | 2021-09-28 | Weakley | Tennessee | 47183 | 5964 | 80 |
1764000 | 1764000 | 2021-09-28 | White | Tennessee | 47185 | 5314 | 87 |
1764001 | 1764001 | 2021-09-28 | Williamson | Tennessee | 47187 | 38060 | 258 |
1764002 | 1764002 | 2021-09-28 | Wilson | Tennessee | 47189 | 26020 | 316 |
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);