ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 47189 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280166 | 1280166 | 2021-05-02 | Wilson | Tennessee | 47189 | 18700 | 233 |
1276919 | 1276919 | 2021-05-01 | Wilson | Tennessee | 47189 | 18700 | 233 |
1273672 | 1273672 | 2021-04-30 | Wilson | Tennessee | 47189 | 18700 | 233 |
1270425 | 1270425 | 2021-04-29 | Wilson | Tennessee | 47189 | 18693 | 232 |
1267178 | 1267178 | 2021-04-28 | Wilson | Tennessee | 47189 | 18684 | 231 |
1263931 | 1263931 | 2021-04-27 | Wilson | Tennessee | 47189 | 18663 | 231 |
1260684 | 1260684 | 2021-04-26 | Wilson | Tennessee | 47189 | 18631 | 230 |
1257437 | 1257437 | 2021-04-25 | Wilson | Tennessee | 47189 | 18598 | 230 |
1254190 | 1254190 | 2021-04-24 | Wilson | Tennessee | 47189 | 18598 | 230 |
1250943 | 1250943 | 2021-04-23 | Wilson | Tennessee | 47189 | 18598 | 230 |
1247696 | 1247696 | 2021-04-22 | Wilson | Tennessee | 47189 | 18569 | 230 |
1244449 | 1244449 | 2021-04-21 | Wilson | Tennessee | 47189 | 18547 | 229 |
1241202 | 1241202 | 2021-04-20 | Wilson | Tennessee | 47189 | 18496 | 229 |
1237955 | 1237955 | 2021-04-19 | Wilson | Tennessee | 47189 | 18472 | 229 |
1234708 | 1234708 | 2021-04-18 | Wilson | Tennessee | 47189 | 17979 | 224 |
1231460 | 1231460 | 2021-04-17 | Wilson | Tennessee | 47189 | 17979 | 224 |
1228212 | 1228212 | 2021-04-16 | Wilson | Tennessee | 47189 | 17979 | 224 |
1224964 | 1224964 | 2021-04-15 | Wilson | Tennessee | 47189 | 17930 | 223 |
1221717 | 1221717 | 2021-04-14 | Wilson | Tennessee | 47189 | 17885 | 223 |
1218469 | 1218469 | 2021-04-13 | Wilson | Tennessee | 47189 | 17854 | 223 |
1215221 | 1215221 | 2021-04-12 | Wilson | Tennessee | 47189 | 17815 | 223 |
1211974 | 1211974 | 2021-04-11 | Wilson | Tennessee | 47189 | 17747 | 223 |
1208725 | 1208725 | 2021-04-10 | Wilson | Tennessee | 47189 | 17747 | 223 |
1205477 | 1205477 | 2021-04-09 | Wilson | Tennessee | 47189 | 17747 | 223 |
1202229 | 1202229 | 2021-04-08 | Wilson | Tennessee | 47189 | 17736 | 223 |
1198980 | 1198980 | 2021-04-07 | Wilson | Tennessee | 47189 | 17695 | 223 |
1195731 | 1195731 | 2021-04-06 | Wilson | Tennessee | 47189 | 17658 | 222 |
1192483 | 1192483 | 2021-04-05 | Wilson | Tennessee | 47189 | 17645 | 219 |
1189234 | 1189234 | 2021-04-04 | Wilson | Tennessee | 47189 | 17557 | 219 |
1185987 | 1185987 | 2021-04-03 | Wilson | Tennessee | 47189 | 17557 | 219 |
1182740 | 1182740 | 2021-04-02 | Wilson | Tennessee | 47189 | 17557 | 219 |
1179493 | 1179493 | 2021-04-01 | Wilson | Tennessee | 47189 | 17557 | 219 |
1176246 | 1176246 | 2021-03-31 | Wilson | Tennessee | 47189 | 17520 | 219 |
1172999 | 1172999 | 2021-03-30 | Wilson | Tennessee | 47189 | 17475 | 219 |
1169752 | 1169752 | 2021-03-29 | Wilson | Tennessee | 47189 | 17456 | 220 |
1166504 | 1166504 | 2021-03-28 | Wilson | Tennessee | 47189 | 17381 | 218 |
1163256 | 1163256 | 2021-03-27 | Wilson | Tennessee | 47189 | 17381 | 218 |
1160007 | 1160007 | 2021-03-26 | Wilson | Tennessee | 47189 | 17381 | 218 |
1156760 | 1156760 | 2021-03-25 | Wilson | Tennessee | 47189 | 17353 | 218 |
1153513 | 1153513 | 2021-03-24 | Wilson | Tennessee | 47189 | 17316 | 218 |
1150266 | 1150266 | 2021-03-23 | Wilson | Tennessee | 47189 | 17296 | 216 |
1147019 | 1147019 | 2021-03-22 | Wilson | Tennessee | 47189 | 17258 | 214 |
1143772 | 1143772 | 2021-03-21 | Wilson | Tennessee | 47189 | 17172 | 214 |
1140525 | 1140525 | 2021-03-20 | Wilson | Tennessee | 47189 | 17172 | 214 |
1137279 | 1137279 | 2021-03-19 | Wilson | Tennessee | 47189 | 17172 | 214 |
1134033 | 1134033 | 2021-03-18 | Wilson | Tennessee | 47189 | 17104 | 214 |
1130785 | 1130785 | 2021-03-17 | Wilson | Tennessee | 47189 | 17084 | 214 |
1127538 | 1127538 | 2021-03-16 | Wilson | Tennessee | 47189 | 17018 | 214 |
1124292 | 1124292 | 2021-03-15 | Wilson | Tennessee | 47189 | 16969 | 213 |
1121046 | 1121046 | 2021-03-14 | Wilson | Tennessee | 47189 | 16880 | 212 |
1117799 | 1117799 | 2021-03-13 | Wilson | Tennessee | 47189 | 16880 | 212 |
1114552 | 1114552 | 2021-03-12 | Wilson | Tennessee | 47189 | 16880 | 212 |
1111306 | 1111306 | 2021-03-11 | Wilson | Tennessee | 47189 | 16846 | 212 |
1108060 | 1108060 | 2021-03-10 | Wilson | Tennessee | 47189 | 16786 | 212 |
1104814 | 1104814 | 2021-03-09 | Wilson | Tennessee | 47189 | 16732 | 212 |
1101568 | 1101568 | 2021-03-08 | Wilson | Tennessee | 47189 | 16683 | 211 |
1098322 | 1098322 | 2021-03-07 | Wilson | Tennessee | 47189 | 16662 | 211 |
1095074 | 1095074 | 2021-03-06 | Wilson | Tennessee | 47189 | 16618 | 211 |
1091828 | 1091828 | 2021-03-05 | Wilson | Tennessee | 47189 | 16553 | 211 |
1088582 | 1088582 | 2021-03-04 | Wilson | Tennessee | 47189 | 16510 | 211 |
1085337 | 1085337 | 2021-03-03 | Wilson | Tennessee | 47189 | 16479 | 210 |
1082091 | 1082091 | 2021-03-02 | Wilson | Tennessee | 47189 | 16423 | 210 |
1078845 | 1078845 | 2021-03-01 | Wilson | Tennessee | 47189 | 16399 | 210 |
1075600 | 1075600 | 2021-02-28 | Wilson | Tennessee | 47189 | 16371 | 210 |
1072354 | 1072354 | 2021-02-27 | Wilson | Tennessee | 47189 | 16323 | 210 |
1069108 | 1069108 | 2021-02-26 | Wilson | Tennessee | 47189 | 16293 | 212 |
1065863 | 1065863 | 2021-02-25 | Wilson | Tennessee | 47189 | 16258 | 211 |
1062618 | 1062618 | 2021-02-24 | Wilson | Tennessee | 47189 | 16194 | 209 |
1059373 | 1059373 | 2021-02-23 | Wilson | Tennessee | 47189 | 16157 | 208 |
1056127 | 1056127 | 2021-02-22 | Wilson | Tennessee | 47189 | 16114 | 208 |
1052881 | 1052881 | 2021-02-21 | Wilson | Tennessee | 47189 | 16090 | 206 |
1049634 | 1049634 | 2021-02-20 | Wilson | Tennessee | 47189 | 16063 | 206 |
1046387 | 1046387 | 2021-02-19 | Wilson | Tennessee | 47189 | 16029 | 206 |
1043142 | 1043142 | 2021-02-18 | Wilson | Tennessee | 47189 | 15991 | 206 |
1039897 | 1039897 | 2021-02-17 | Wilson | Tennessee | 47189 | 15974 | 205 |
1036652 | 1036652 | 2021-02-16 | Wilson | Tennessee | 47189 | 15957 | 205 |
1033407 | 1033407 | 2021-02-15 | Wilson | Tennessee | 47189 | 15948 | 205 |
1030161 | 1030161 | 2021-02-14 | Wilson | Tennessee | 47189 | 15921 | 205 |
1026914 | 1026914 | 2021-02-13 | Wilson | Tennessee | 47189 | 15884 | 205 |
1023669 | 1023669 | 2021-02-12 | Wilson | Tennessee | 47189 | 15841 | 205 |
1020424 | 1020424 | 2021-02-11 | Wilson | Tennessee | 47189 | 15792 | 204 |
1017179 | 1017179 | 2021-02-10 | Wilson | Tennessee | 47189 | 15731 | 201 |
1013934 | 1013934 | 2021-02-09 | Wilson | Tennessee | 47189 | 15640 | 194 |
1010689 | 1010689 | 2021-02-08 | Wilson | Tennessee | 47189 | 15617 | 193 |
1007443 | 1007443 | 2021-02-07 | Wilson | Tennessee | 47189 | 15602 | 191 |
1004197 | 1004197 | 2021-02-06 | Wilson | Tennessee | 47189 | 15558 | 191 |
1000951 | 1000951 | 2021-02-05 | Wilson | Tennessee | 47189 | 15477 | 191 |
997705 | 997705 | 2021-02-04 | Wilson | Tennessee | 47189 | 15417 | 189 |
994459 | 994459 | 2021-02-03 | Wilson | Tennessee | 47189 | 15354 | 186 |
991213 | 991213 | 2021-02-02 | Wilson | Tennessee | 47189 | 15314 | 185 |
987967 | 987967 | 2021-02-01 | Wilson | Tennessee | 47189 | 15266 | 182 |
984720 | 984720 | 2021-01-31 | Wilson | Tennessee | 47189 | 15223 | 181 |
981473 | 981473 | 2021-01-30 | Wilson | Tennessee | 47189 | 15153 | 179 |
978227 | 978227 | 2021-01-29 | Wilson | Tennessee | 47189 | 15123 | 178 |
974982 | 974982 | 2021-01-28 | Wilson | Tennessee | 47189 | 15046 | 177 |
971737 | 971737 | 2021-01-27 | Wilson | Tennessee | 47189 | 14984 | 175 |
968492 | 968492 | 2021-01-26 | Wilson | Tennessee | 47189 | 14907 | 170 |
965248 | 965248 | 2021-01-25 | Wilson | Tennessee | 47189 | 14878 | 167 |
962003 | 962003 | 2021-01-24 | Wilson | Tennessee | 47189 | 14846 | 164 |
958758 | 958758 | 2021-01-23 | Wilson | Tennessee | 47189 | 14797 | 164 |
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);