ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where deaths = 3, fips = 27077 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1476914 | 1476914 | 2021-07-02 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1473668 | 1473668 | 2021-07-01 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1470422 | 1470422 | 2021-06-30 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1467177 | 1467177 | 2021-06-29 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1463932 | 1463932 | 2021-06-28 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1460687 | 1460687 | 2021-06-27 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1457442 | 1457442 | 2021-06-26 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1454197 | 1454197 | 2021-06-25 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1450952 | 1450952 | 2021-06-24 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1447706 | 1447706 | 2021-06-23 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1444461 | 1444461 | 2021-06-22 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1441216 | 1441216 | 2021-06-21 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1437970 | 1437970 | 2021-06-20 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1434723 | 1434723 | 2021-06-19 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1431476 | 1431476 | 2021-06-18 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1428231 | 1428231 | 2021-06-17 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1424986 | 1424986 | 2021-06-16 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1421738 | 1421738 | 2021-06-15 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1418493 | 1418493 | 2021-06-14 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1415248 | 1415248 | 2021-06-13 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1412002 | 1412002 | 2021-06-12 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1408757 | 1408757 | 2021-06-11 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1405512 | 1405512 | 2021-06-10 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1402266 | 1402266 | 2021-06-09 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1399021 | 1399021 | 2021-06-08 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1395775 | 1395775 | 2021-06-07 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1392529 | 1392529 | 2021-06-06 | Lake of the Woods | Minnesota | 27077 | 345 | 3 |
1389284 | 1389284 | 2021-06-05 | Lake of the Woods | Minnesota | 27077 | 344 | 3 |
1386039 | 1386039 | 2021-06-04 | Lake of the Woods | Minnesota | 27077 | 344 | 3 |
1382794 | 1382794 | 2021-06-03 | Lake of the Woods | Minnesota | 27077 | 343 | 3 |
1379548 | 1379548 | 2021-06-02 | Lake of the Woods | Minnesota | 27077 | 343 | 3 |
1376303 | 1376303 | 2021-06-01 | Lake of the Woods | Minnesota | 27077 | 343 | 3 |
1373057 | 1373057 | 2021-05-31 | Lake of the Woods | Minnesota | 27077 | 343 | 3 |
1369812 | 1369812 | 2021-05-30 | Lake of the Woods | Minnesota | 27077 | 343 | 3 |
1366566 | 1366566 | 2021-05-29 | Lake of the Woods | Minnesota | 27077 | 343 | 3 |
1363320 | 1363320 | 2021-05-28 | Lake of the Woods | Minnesota | 27077 | 341 | 3 |
1360073 | 1360073 | 2021-05-27 | Lake of the Woods | Minnesota | 27077 | 341 | 3 |
1356827 | 1356827 | 2021-05-26 | Lake of the Woods | Minnesota | 27077 | 341 | 3 |
1353581 | 1353581 | 2021-05-25 | Lake of the Woods | Minnesota | 27077 | 340 | 3 |
1350335 | 1350335 | 2021-05-24 | Lake of the Woods | Minnesota | 27077 | 340 | 3 |
1347089 | 1347089 | 2021-05-23 | Lake of the Woods | Minnesota | 27077 | 340 | 3 |
1343841 | 1343841 | 2021-05-22 | Lake of the Woods | Minnesota | 27077 | 338 | 3 |
1340592 | 1340592 | 2021-05-21 | Lake of the Woods | Minnesota | 27077 | 338 | 3 |
1337345 | 1337345 | 2021-05-20 | Lake of the Woods | Minnesota | 27077 | 338 | 3 |
1334098 | 1334098 | 2021-05-19 | Lake of the Woods | Minnesota | 27077 | 335 | 3 |
1330851 | 1330851 | 2021-05-18 | Lake of the Woods | Minnesota | 27077 | 333 | 3 |
1327604 | 1327604 | 2021-05-17 | Lake of the Woods | Minnesota | 27077 | 332 | 3 |
1324358 | 1324358 | 2021-05-16 | Lake of the Woods | Minnesota | 27077 | 327 | 3 |
1321112 | 1321112 | 2021-05-15 | Lake of the Woods | Minnesota | 27077 | 325 | 3 |
1317866 | 1317866 | 2021-05-14 | Lake of the Woods | Minnesota | 27077 | 325 | 3 |
1314618 | 1314618 | 2021-05-13 | Lake of the Woods | Minnesota | 27077 | 324 | 3 |
1311372 | 1311372 | 2021-05-12 | Lake of the Woods | Minnesota | 27077 | 322 | 3 |
1308125 | 1308125 | 2021-05-11 | Lake of the Woods | Minnesota | 27077 | 322 | 3 |
1304879 | 1304879 | 2021-05-10 | Lake of the Woods | Minnesota | 27077 | 322 | 3 |
1301633 | 1301633 | 2021-05-09 | Lake of the Woods | Minnesota | 27077 | 321 | 3 |
1298385 | 1298385 | 2021-05-08 | Lake of the Woods | Minnesota | 27077 | 320 | 3 |
1295139 | 1295139 | 2021-05-07 | Lake of the Woods | Minnesota | 27077 | 319 | 3 |
1291893 | 1291893 | 2021-05-06 | Lake of the Woods | Minnesota | 27077 | 319 | 3 |
1288647 | 1288647 | 2021-05-05 | Lake of the Woods | Minnesota | 27077 | 318 | 3 |
1285401 | 1285401 | 2021-05-04 | Lake of the Woods | Minnesota | 27077 | 317 | 3 |
1282155 | 1282155 | 2021-05-03 | Lake of the Woods | Minnesota | 27077 | 316 | 3 |
1278908 | 1278908 | 2021-05-02 | Lake of the Woods | Minnesota | 27077 | 316 | 3 |
1275661 | 1275661 | 2021-05-01 | Lake of the Woods | Minnesota | 27077 | 315 | 3 |
1272414 | 1272414 | 2021-04-30 | Lake of the Woods | Minnesota | 27077 | 315 | 3 |
1269167 | 1269167 | 2021-04-29 | Lake of the Woods | Minnesota | 27077 | 315 | 3 |
1265920 | 1265920 | 2021-04-28 | Lake of the Woods | Minnesota | 27077 | 315 | 3 |
1262673 | 1262673 | 2021-04-27 | Lake of the Woods | Minnesota | 27077 | 313 | 3 |
1259426 | 1259426 | 2021-04-26 | Lake of the Woods | Minnesota | 27077 | 313 | 3 |
1256179 | 1256179 | 2021-04-25 | Lake of the Woods | Minnesota | 27077 | 312 | 3 |
1252932 | 1252932 | 2021-04-24 | Lake of the Woods | Minnesota | 27077 | 312 | 3 |
1249685 | 1249685 | 2021-04-23 | Lake of the Woods | Minnesota | 27077 | 310 | 3 |
1246438 | 1246438 | 2021-04-22 | Lake of the Woods | Minnesota | 27077 | 308 | 3 |
1243191 | 1243191 | 2021-04-21 | Lake of the Woods | Minnesota | 27077 | 307 | 3 |
1239944 | 1239944 | 2021-04-20 | Lake of the Woods | Minnesota | 27077 | 307 | 3 |
1236697 | 1236697 | 2021-04-19 | Lake of the Woods | Minnesota | 27077 | 307 | 3 |
1233450 | 1233450 | 2021-04-18 | Lake of the Woods | Minnesota | 27077 | 307 | 3 |
1230202 | 1230202 | 2021-04-17 | Lake of the Woods | Minnesota | 27077 | 305 | 3 |
1226954 | 1226954 | 2021-04-16 | Lake of the Woods | Minnesota | 27077 | 305 | 3 |
1223706 | 1223706 | 2021-04-15 | Lake of the Woods | Minnesota | 27077 | 299 | 3 |
1220459 | 1220459 | 2021-04-14 | Lake of the Woods | Minnesota | 27077 | 298 | 3 |
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);