ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 27027 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418468 | 1418468 | 2021-06-14 | Clay | Minnesota | 27027 | 8254 | 92 |
1415223 | 1415223 | 2021-06-13 | Clay | Minnesota | 27027 | 8254 | 92 |
1411977 | 1411977 | 2021-06-12 | Clay | Minnesota | 27027 | 8254 | 92 |
1408732 | 1408732 | 2021-06-11 | Clay | Minnesota | 27027 | 8252 | 92 |
1405487 | 1405487 | 2021-06-10 | Clay | Minnesota | 27027 | 8251 | 92 |
1402241 | 1402241 | 2021-06-09 | Clay | Minnesota | 27027 | 8251 | 92 |
1398996 | 1398996 | 2021-06-08 | Clay | Minnesota | 27027 | 8251 | 92 |
1395750 | 1395750 | 2021-06-07 | Clay | Minnesota | 27027 | 8250 | 92 |
1392504 | 1392504 | 2021-06-06 | Clay | Minnesota | 27027 | 8250 | 92 |
1389259 | 1389259 | 2021-06-05 | Clay | Minnesota | 27027 | 8249 | 92 |
1386014 | 1386014 | 2021-06-04 | Clay | Minnesota | 27027 | 8246 | 92 |
1382769 | 1382769 | 2021-06-03 | Clay | Minnesota | 27027 | 8246 | 92 |
1379523 | 1379523 | 2021-06-02 | Clay | Minnesota | 27027 | 8241 | 92 |
1376278 | 1376278 | 2021-06-01 | Clay | Minnesota | 27027 | 8241 | 92 |
1373032 | 1373032 | 2021-05-31 | Clay | Minnesota | 27027 | 8238 | 92 |
1369787 | 1369787 | 2021-05-30 | Clay | Minnesota | 27027 | 8238 | 92 |
1366541 | 1366541 | 2021-05-29 | Clay | Minnesota | 27027 | 8235 | 92 |
1363295 | 1363295 | 2021-05-28 | Clay | Minnesota | 27027 | 8232 | 92 |
1360048 | 1360048 | 2021-05-27 | Clay | Minnesota | 27027 | 8230 | 92 |
1356802 | 1356802 | 2021-05-26 | Clay | Minnesota | 27027 | 8224 | 92 |
1353556 | 1353556 | 2021-05-25 | Clay | Minnesota | 27027 | 8216 | 92 |
1350310 | 1350310 | 2021-05-24 | Clay | Minnesota | 27027 | 8213 | 92 |
1347064 | 1347064 | 2021-05-23 | Clay | Minnesota | 27027 | 8208 | 92 |
1343816 | 1343816 | 2021-05-22 | Clay | Minnesota | 27027 | 8200 | 92 |
1340567 | 1340567 | 2021-05-21 | Clay | Minnesota | 27027 | 8198 | 92 |
1337320 | 1337320 | 2021-05-20 | Clay | Minnesota | 27027 | 8194 | 92 |
1334073 | 1334073 | 2021-05-19 | Clay | Minnesota | 27027 | 8193 | 92 |
1330826 | 1330826 | 2021-05-18 | Clay | Minnesota | 27027 | 8180 | 92 |
1327579 | 1327579 | 2021-05-17 | Clay | Minnesota | 27027 | 8172 | 92 |
1324333 | 1324333 | 2021-05-16 | Clay | Minnesota | 27027 | 8167 | 92 |
1321087 | 1321087 | 2021-05-15 | Clay | Minnesota | 27027 | 8163 | 92 |
1317841 | 1317841 | 2021-05-14 | Clay | Minnesota | 27027 | 8157 | 92 |
1314593 | 1314593 | 2021-05-13 | Clay | Minnesota | 27027 | 8144 | 92 |
1311347 | 1311347 | 2021-05-12 | Clay | Minnesota | 27027 | 8141 | 92 |
1308100 | 1308100 | 2021-05-11 | Clay | Minnesota | 27027 | 8127 | 92 |
1304854 | 1304854 | 2021-05-10 | Clay | Minnesota | 27027 | 8124 | 92 |
1301608 | 1301608 | 2021-05-09 | Clay | Minnesota | 27027 | 8117 | 92 |
1298360 | 1298360 | 2021-05-08 | Clay | Minnesota | 27027 | 8109 | 92 |
1295114 | 1295114 | 2021-05-07 | Clay | Minnesota | 27027 | 8099 | 92 |
1291868 | 1291868 | 2021-05-06 | Clay | Minnesota | 27027 | 8092 | 92 |
1288622 | 1288622 | 2021-05-05 | Clay | Minnesota | 27027 | 8074 | 92 |
1285376 | 1285376 | 2021-05-04 | Clay | Minnesota | 27027 | 8068 | 92 |
1282130 | 1282130 | 2021-05-03 | Clay | Minnesota | 27027 | 8057 | 91 |
1278883 | 1278883 | 2021-05-02 | Clay | Minnesota | 27027 | 8046 | 91 |
1275636 | 1275636 | 2021-05-01 | Clay | Minnesota | 27027 | 8038 | 91 |
1272389 | 1272389 | 2021-04-30 | Clay | Minnesota | 27027 | 8031 | 91 |
1269142 | 1269142 | 2021-04-29 | Clay | Minnesota | 27027 | 8005 | 91 |
1265895 | 1265895 | 2021-04-28 | Clay | Minnesota | 27027 | 7983 | 91 |
1262648 | 1262648 | 2021-04-27 | Clay | Minnesota | 27027 | 7968 | 91 |
1259401 | 1259401 | 2021-04-26 | Clay | Minnesota | 27027 | 7956 | 90 |
1256154 | 1256154 | 2021-04-25 | Clay | Minnesota | 27027 | 7949 | 90 |
1252907 | 1252907 | 2021-04-24 | Clay | Minnesota | 27027 | 7931 | 90 |
1249660 | 1249660 | 2021-04-23 | Clay | Minnesota | 27027 | 7910 | 90 |
1246413 | 1246413 | 2021-04-22 | Clay | Minnesota | 27027 | 7900 | 90 |
1243166 | 1243166 | 2021-04-21 | Clay | Minnesota | 27027 | 7873 | 90 |
1239919 | 1239919 | 2021-04-20 | Clay | Minnesota | 27027 | 7860 | 90 |
1236672 | 1236672 | 2021-04-19 | Clay | Minnesota | 27027 | 7847 | 90 |
1233425 | 1233425 | 2021-04-18 | Clay | Minnesota | 27027 | 7834 | 90 |
1230177 | 1230177 | 2021-04-17 | Clay | Minnesota | 27027 | 7812 | 89 |
1226929 | 1226929 | 2021-04-16 | Clay | Minnesota | 27027 | 7806 | 89 |
1223681 | 1223681 | 2021-04-15 | Clay | Minnesota | 27027 | 7773 | 89 |
1220434 | 1220434 | 2021-04-14 | Clay | Minnesota | 27027 | 7738 | 89 |
1217186 | 1217186 | 2021-04-13 | Clay | Minnesota | 27027 | 7716 | 89 |
1213939 | 1213939 | 2021-04-12 | Clay | Minnesota | 27027 | 7690 | 89 |
1210691 | 1210691 | 2021-04-11 | Clay | Minnesota | 27027 | 7658 | 89 |
1207442 | 1207442 | 2021-04-10 | Clay | Minnesota | 27027 | 7651 | 89 |
1204194 | 1204194 | 2021-04-09 | Clay | Minnesota | 27027 | 7634 | 89 |
1200946 | 1200946 | 2021-04-08 | Clay | Minnesota | 27027 | 7598 | 89 |
1197697 | 1197697 | 2021-04-07 | Clay | Minnesota | 27027 | 7559 | 89 |
1194448 | 1194448 | 2021-04-06 | Clay | Minnesota | 27027 | 7507 | 89 |
1191199 | 1191199 | 2021-04-05 | Clay | Minnesota | 27027 | 7467 | 89 |
1187951 | 1187951 | 2021-04-04 | Clay | Minnesota | 27027 | 7461 | 89 |
1184704 | 1184704 | 2021-04-03 | Clay | Minnesota | 27027 | 7461 | 89 |
1181458 | 1181458 | 2021-04-02 | Clay | Minnesota | 27027 | 7409 | 89 |
1178211 | 1178211 | 2021-04-01 | Clay | Minnesota | 27027 | 7382 | 89 |
1174964 | 1174964 | 2021-03-31 | Clay | Minnesota | 27027 | 7356 | 89 |
1171717 | 1171717 | 2021-03-30 | Clay | Minnesota | 27027 | 7324 | 89 |
1168469 | 1168469 | 2021-03-29 | Clay | Minnesota | 27027 | 7294 | 89 |
1165221 | 1165221 | 2021-03-28 | Clay | Minnesota | 27027 | 7265 | 89 |
1161973 | 1161973 | 2021-03-27 | Clay | Minnesota | 27027 | 7250 | 89 |
1158725 | 1158725 | 2021-03-26 | Clay | Minnesota | 27027 | 7239 | 89 |
1155478 | 1155478 | 2021-03-25 | Clay | Minnesota | 27027 | 7206 | 89 |
1152231 | 1152231 | 2021-03-24 | Clay | Minnesota | 27027 | 7194 | 89 |
1148984 | 1148984 | 2021-03-23 | Clay | Minnesota | 27027 | 7169 | 89 |
1145737 | 1145737 | 2021-03-22 | Clay | Minnesota | 27027 | 7152 | 89 |
1142490 | 1142490 | 2021-03-21 | Clay | Minnesota | 27027 | 7129 | 89 |
1139243 | 1139243 | 2021-03-20 | Clay | Minnesota | 27027 | 7120 | 89 |
1135997 | 1135997 | 2021-03-19 | Clay | Minnesota | 27027 | 7106 | 89 |
1132751 | 1132751 | 2021-03-18 | Clay | Minnesota | 27027 | 7098 | 89 |
1129503 | 1129503 | 2021-03-17 | Clay | Minnesota | 27027 | 7077 | 89 |
1126256 | 1126256 | 2021-03-16 | Clay | Minnesota | 27027 | 7064 | 89 |
1123010 | 1123010 | 2021-03-15 | Clay | Minnesota | 27027 | 7047 | 89 |
1119763 | 1119763 | 2021-03-14 | Clay | Minnesota | 27027 | 7039 | 89 |
1116516 | 1116516 | 2021-03-13 | Clay | Minnesota | 27027 | 7018 | 89 |
1113270 | 1113270 | 2021-03-12 | Clay | Minnesota | 27027 | 7009 | 89 |
1110024 | 1110024 | 2021-03-11 | Clay | Minnesota | 27027 | 7003 | 89 |
1106778 | 1106778 | 2021-03-10 | Clay | Minnesota | 27027 | 6995 | 89 |
1103532 | 1103532 | 2021-03-09 | Clay | Minnesota | 27027 | 6975 | 89 |
1100286 | 1100286 | 2021-03-08 | Clay | Minnesota | 27027 | 6965 | 88 |
1097039 | 1097039 | 2021-03-07 | Clay | Minnesota | 27027 | 6962 | 88 |
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);