ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 27103 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717271 | 1717271 | 2021-09-14 | Nicollet | Minnesota | 27103 | 3699 | 47 |
1714023 | 1714023 | 2021-09-13 | Nicollet | Minnesota | 27103 | 3660 | 47 |
1710777 | 1710777 | 2021-09-12 | Nicollet | Minnesota | 27103 | 3635 | 47 |
1707530 | 1707530 | 2021-09-11 | Nicollet | Minnesota | 27103 | 3635 | 47 |
1704283 | 1704283 | 2021-09-10 | Nicollet | Minnesota | 27103 | 3635 | 47 |
1701033 | 1701033 | 2021-09-09 | Nicollet | Minnesota | 27103 | 3623 | 47 |
1697784 | 1697784 | 2021-09-08 | Nicollet | Minnesota | 27103 | 3614 | 47 |
1694536 | 1694536 | 2021-09-07 | Nicollet | Minnesota | 27103 | 3583 | 47 |
1691287 | 1691287 | 2021-09-06 | Nicollet | Minnesota | 27103 | 3571 | 47 |
1688037 | 1688037 | 2021-09-05 | Nicollet | Minnesota | 27103 | 3571 | 47 |
1684787 | 1684787 | 2021-09-04 | Nicollet | Minnesota | 27103 | 3571 | 47 |
1681536 | 1681536 | 2021-09-03 | Nicollet | Minnesota | 27103 | 3571 | 47 |
1678288 | 1678288 | 2021-09-02 | Nicollet | Minnesota | 27103 | 3557 | 47 |
1675040 | 1675040 | 2021-09-01 | Nicollet | Minnesota | 27103 | 3546 | 46 |
1671792 | 1671792 | 2021-08-31 | Nicollet | Minnesota | 27103 | 3541 | 46 |
1668545 | 1668545 | 2021-08-30 | Nicollet | Minnesota | 27103 | 3524 | 46 |
1665298 | 1665298 | 2021-08-29 | Nicollet | Minnesota | 27103 | 3507 | 46 |
1662050 | 1662050 | 2021-08-28 | Nicollet | Minnesota | 27103 | 3507 | 46 |
1658802 | 1658802 | 2021-08-27 | Nicollet | Minnesota | 27103 | 3507 | 46 |
1655553 | 1655553 | 2021-08-26 | Nicollet | Minnesota | 27103 | 3494 | 46 |
1652306 | 1652306 | 2021-08-25 | Nicollet | Minnesota | 27103 | 3483 | 46 |
1649058 | 1649058 | 2021-08-24 | Nicollet | Minnesota | 27103 | 3477 | 46 |
1645809 | 1645809 | 2021-08-23 | Nicollet | Minnesota | 27103 | 3454 | 46 |
1642560 | 1642560 | 2021-08-22 | Nicollet | Minnesota | 27103 | 3449 | 45 |
1639310 | 1639310 | 2021-08-21 | Nicollet | Minnesota | 27103 | 3449 | 45 |
1636060 | 1636060 | 2021-08-20 | Nicollet | Minnesota | 27103 | 3449 | 45 |
1632810 | 1632810 | 2021-08-19 | Nicollet | Minnesota | 27103 | 3430 | 45 |
1629563 | 1629563 | 2021-08-18 | Nicollet | Minnesota | 27103 | 3422 | 45 |
1626316 | 1626316 | 2021-08-17 | Nicollet | Minnesota | 27103 | 3417 | 45 |
1623069 | 1623069 | 2021-08-16 | Nicollet | Minnesota | 27103 | 3406 | 45 |
1619822 | 1619822 | 2021-08-15 | Nicollet | Minnesota | 27103 | 3397 | 45 |
1616574 | 1616574 | 2021-08-14 | Nicollet | Minnesota | 27103 | 3397 | 45 |
1613326 | 1613326 | 2021-08-13 | Nicollet | Minnesota | 27103 | 3397 | 45 |
1610077 | 1610077 | 2021-08-12 | Nicollet | Minnesota | 27103 | 3392 | 45 |
1606829 | 1606829 | 2021-08-11 | Nicollet | Minnesota | 27103 | 3387 | 45 |
1603580 | 1603580 | 2021-08-10 | Nicollet | Minnesota | 27103 | 3380 | 45 |
1600331 | 1600331 | 2021-08-09 | Nicollet | Minnesota | 27103 | 3372 | 45 |
1597083 | 1597083 | 2021-08-08 | Nicollet | Minnesota | 27103 | 3367 | 45 |
1593834 | 1593834 | 2021-08-07 | Nicollet | Minnesota | 27103 | 3367 | 45 |
1590585 | 1590585 | 2021-08-06 | Nicollet | Minnesota | 27103 | 3367 | 45 |
1587336 | 1587336 | 2021-08-05 | Nicollet | Minnesota | 27103 | 3365 | 45 |
1584085 | 1584085 | 2021-08-04 | Nicollet | Minnesota | 27103 | 3361 | 45 |
1580836 | 1580836 | 2021-08-03 | Nicollet | Minnesota | 27103 | 3357 | 45 |
1577587 | 1577587 | 2021-08-02 | Nicollet | Minnesota | 27103 | 3353 | 45 |
1574339 | 1574339 | 2021-08-01 | Nicollet | Minnesota | 27103 | 3351 | 45 |
1571091 | 1571091 | 2021-07-31 | Nicollet | Minnesota | 27103 | 3351 | 45 |
1567843 | 1567843 | 2021-07-30 | Nicollet | Minnesota | 27103 | 3351 | 45 |
1564595 | 1564595 | 2021-07-29 | Nicollet | Minnesota | 27103 | 3350 | 45 |
1561347 | 1561347 | 2021-07-28 | Nicollet | Minnesota | 27103 | 3346 | 45 |
1558099 | 1558099 | 2021-07-27 | Nicollet | Minnesota | 27103 | 3345 | 45 |
1554852 | 1554852 | 2021-07-26 | Nicollet | Minnesota | 27103 | 3342 | 45 |
1551605 | 1551605 | 2021-07-25 | Nicollet | Minnesota | 27103 | 3340 | 45 |
1548358 | 1548358 | 2021-07-24 | Nicollet | Minnesota | 27103 | 3340 | 45 |
1545111 | 1545111 | 2021-07-23 | Nicollet | Minnesota | 27103 | 3340 | 45 |
1541863 | 1541863 | 2021-07-22 | Nicollet | Minnesota | 27103 | 3338 | 45 |
1538616 | 1538616 | 2021-07-21 | Nicollet | Minnesota | 27103 | 3337 | 45 |
1535369 | 1535369 | 2021-07-20 | Nicollet | Minnesota | 27103 | 3335 | 45 |
1532121 | 1532121 | 2021-07-19 | Nicollet | Minnesota | 27103 | 3331 | 45 |
1528874 | 1528874 | 2021-07-18 | Nicollet | Minnesota | 27103 | 3328 | 45 |
1525627 | 1525627 | 2021-07-17 | Nicollet | Minnesota | 27103 | 3328 | 45 |
1522380 | 1522380 | 2021-07-16 | Nicollet | Minnesota | 27103 | 3328 | 45 |
1519131 | 1519131 | 2021-07-15 | Nicollet | Minnesota | 27103 | 3325 | 45 |
1515884 | 1515884 | 2021-07-14 | Nicollet | Minnesota | 27103 | 3324 | 45 |
1512638 | 1512638 | 2021-07-13 | Nicollet | Minnesota | 27103 | 3324 | 45 |
1509391 | 1509391 | 2021-07-12 | Nicollet | Minnesota | 27103 | 3321 | 45 |
1506145 | 1506145 | 2021-07-11 | Nicollet | Minnesota | 27103 | 3321 | 45 |
1502899 | 1502899 | 2021-07-10 | Nicollet | Minnesota | 27103 | 3321 | 45 |
1499653 | 1499653 | 2021-07-09 | Nicollet | Minnesota | 27103 | 3321 | 45 |
1496407 | 1496407 | 2021-07-08 | Nicollet | Minnesota | 27103 | 3320 | 45 |
1493160 | 1493160 | 2021-07-07 | Nicollet | Minnesota | 27103 | 3319 | 45 |
1489913 | 1489913 | 2021-07-06 | Nicollet | Minnesota | 27103 | 3319 | 45 |
1486666 | 1486666 | 2021-07-05 | Nicollet | Minnesota | 27103 | 3319 | 45 |
1483420 | 1483420 | 2021-07-04 | Nicollet | Minnesota | 27103 | 3319 | 45 |
1480174 | 1480174 | 2021-07-03 | Nicollet | Minnesota | 27103 | 3319 | 45 |
1476927 | 1476927 | 2021-07-02 | Nicollet | Minnesota | 27103 | 3319 | 45 |
1473681 | 1473681 | 2021-07-01 | Nicollet | Minnesota | 27103 | 3317 | 45 |
1470435 | 1470435 | 2021-06-30 | Nicollet | Minnesota | 27103 | 3316 | 45 |
1467190 | 1467190 | 2021-06-29 | Nicollet | Minnesota | 27103 | 3315 | 45 |
1463945 | 1463945 | 2021-06-28 | Nicollet | Minnesota | 27103 | 3315 | 45 |
1460700 | 1460700 | 2021-06-27 | Nicollet | Minnesota | 27103 | 3315 | 45 |
1457455 | 1457455 | 2021-06-26 | Nicollet | Minnesota | 27103 | 3314 | 45 |
1454210 | 1454210 | 2021-06-25 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1450965 | 1450965 | 2021-06-24 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1447719 | 1447719 | 2021-06-23 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1444474 | 1444474 | 2021-06-22 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1441229 | 1441229 | 2021-06-21 | Nicollet | Minnesota | 27103 | 3313 | 45 |
1437983 | 1437983 | 2021-06-20 | Nicollet | Minnesota | 27103 | 3312 | 45 |
1434736 | 1434736 | 2021-06-19 | Nicollet | Minnesota | 27103 | 3312 | 45 |
1431489 | 1431489 | 2021-06-18 | Nicollet | Minnesota | 27103 | 3311 | 45 |
1428244 | 1428244 | 2021-06-17 | Nicollet | Minnesota | 27103 | 3310 | 45 |
1424999 | 1424999 | 2021-06-16 | Nicollet | Minnesota | 27103 | 3310 | 45 |
1421751 | 1421751 | 2021-06-15 | Nicollet | Minnesota | 27103 | 3310 | 45 |
1418506 | 1418506 | 2021-06-14 | Nicollet | Minnesota | 27103 | 3309 | 45 |
1415261 | 1415261 | 2021-06-13 | Nicollet | Minnesota | 27103 | 3309 | 45 |
1412015 | 1412015 | 2021-06-12 | Nicollet | Minnesota | 27103 | 3309 | 45 |
1408770 | 1408770 | 2021-06-11 | Nicollet | Minnesota | 27103 | 3308 | 45 |
1405525 | 1405525 | 2021-06-10 | Nicollet | Minnesota | 27103 | 3309 | 45 |
1402279 | 1402279 | 2021-06-09 | Nicollet | Minnesota | 27103 | 3309 | 45 |
1399034 | 1399034 | 2021-06-08 | Nicollet | Minnesota | 27103 | 3309 | 45 |
1395788 | 1395788 | 2021-06-07 | Nicollet | Minnesota | 27103 | 3309 | 45 |
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);