ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Madison" and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1802010 | 1802010 | 2021-10-10 | Madison | Montana | 30057 | 1165 | 8 |
1798761 | 1798761 | 2021-10-09 | Madison | Montana | 30057 | 1165 | 8 |
1795512 | 1795512 | 2021-10-08 | Madison | Montana | 30057 | 1165 | 8 |
1792263 | 1792263 | 2021-10-07 | Madison | Montana | 30057 | 1149 | 8 |
1789014 | 1789014 | 2021-10-06 | Madison | Montana | 30057 | 1141 | 8 |
1785766 | 1785766 | 2021-10-05 | Madison | Montana | 30057 | 1130 | 8 |
1782517 | 1782517 | 2021-10-04 | Madison | Montana | 30057 | 1121 | 8 |
1779267 | 1779267 | 2021-10-03 | Madison | Montana | 30057 | 1097 | 8 |
1776017 | 1776017 | 2021-10-02 | Madison | Montana | 30057 | 1097 | 8 |
1772767 | 1772767 | 2021-10-01 | Madison | Montana | 30057 | 1097 | 8 |
1769518 | 1769518 | 2021-09-30 | Madison | Montana | 30057 | 1091 | 8 |
1766269 | 1766269 | 2021-09-29 | Madison | Montana | 30057 | 1082 | 8 |
1763020 | 1763020 | 2021-09-28 | Madison | Montana | 30057 | 1067 | 8 |
1759771 | 1759771 | 2021-09-27 | Madison | Montana | 30057 | 1062 | 8 |
1756523 | 1756523 | 2021-09-26 | Madison | Montana | 30057 | 1044 | 8 |
1753275 | 1753275 | 2021-09-25 | Madison | Montana | 30057 | 1044 | 8 |
1750027 | 1750027 | 2021-09-24 | Madison | Montana | 30057 | 1044 | 8 |
1746777 | 1746777 | 2021-09-23 | Madison | Montana | 30057 | 1043 | 8 |
1743528 | 1743528 | 2021-09-22 | Madison | Montana | 30057 | 1019 | 8 |
1740279 | 1740279 | 2021-09-21 | Madison | Montana | 30057 | 1010 | 8 |
1737030 | 1737030 | 2021-09-20 | Madison | Montana | 30057 | 996 | 8 |
1733780 | 1733780 | 2021-09-19 | Madison | Montana | 30057 | 990 | 8 |
1730530 | 1730530 | 2021-09-18 | Madison | Montana | 30057 | 990 | 8 |
1727280 | 1727280 | 2021-09-17 | Madison | Montana | 30057 | 990 | 8 |
1724031 | 1724031 | 2021-09-16 | Madison | Montana | 30057 | 980 | 8 |
1720782 | 1720782 | 2021-09-15 | Madison | Montana | 30057 | 973 | 8 |
1717534 | 1717534 | 2021-09-14 | Madison | Montana | 30057 | 960 | 8 |
1714286 | 1714286 | 2021-09-13 | Madison | Montana | 30057 | 933 | 8 |
1711040 | 1711040 | 2021-09-12 | Madison | Montana | 30057 | 921 | 8 |
1707793 | 1707793 | 2021-09-11 | Madison | Montana | 30057 | 921 | 8 |
1704546 | 1704546 | 2021-09-10 | Madison | Montana | 30057 | 921 | 8 |
1701296 | 1701296 | 2021-09-09 | Madison | Montana | 30057 | 906 | 8 |
1698047 | 1698047 | 2021-09-08 | Madison | Montana | 30057 | 902 | 8 |
1694799 | 1694799 | 2021-09-07 | Madison | Montana | 30057 | 897 | 8 |
1691550 | 1691550 | 2021-09-06 | Madison | Montana | 30057 | 892 | 8 |
1688300 | 1688300 | 2021-09-05 | Madison | Montana | 30057 | 892 | 8 |
1685050 | 1685050 | 2021-09-04 | Madison | Montana | 30057 | 892 | 8 |
1681799 | 1681799 | 2021-09-03 | Madison | Montana | 30057 | 892 | 8 |
1678551 | 1678551 | 2021-09-02 | Madison | Montana | 30057 | 881 | 8 |
1675303 | 1675303 | 2021-09-01 | Madison | Montana | 30057 | 875 | 8 |
1672055 | 1672055 | 2021-08-31 | Madison | Montana | 30057 | 874 | 8 |
1668808 | 1668808 | 2021-08-30 | Madison | Montana | 30057 | 870 | 8 |
1665561 | 1665561 | 2021-08-29 | Madison | Montana | 30057 | 863 | 8 |
1662313 | 1662313 | 2021-08-28 | Madison | Montana | 30057 | 863 | 8 |
1659065 | 1659065 | 2021-08-27 | Madison | Montana | 30057 | 863 | 8 |
1655816 | 1655816 | 2021-08-26 | Madison | Montana | 30057 | 860 | 8 |
1652569 | 1652569 | 2021-08-25 | Madison | Montana | 30057 | 858 | 8 |
1649321 | 1649321 | 2021-08-24 | Madison | Montana | 30057 | 854 | 8 |
1646072 | 1646072 | 2021-08-23 | Madison | Montana | 30057 | 850 | 8 |
1642823 | 1642823 | 2021-08-22 | Madison | Montana | 30057 | 845 | 8 |
1639573 | 1639573 | 2021-08-21 | Madison | Montana | 30057 | 845 | 8 |
1636323 | 1636323 | 2021-08-20 | Madison | Montana | 30057 | 845 | 8 |
1633073 | 1633073 | 2021-08-19 | Madison | Montana | 30057 | 841 | 8 |
1629826 | 1629826 | 2021-08-18 | Madison | Montana | 30057 | 840 | 8 |
1626579 | 1626579 | 2021-08-17 | Madison | Montana | 30057 | 837 | 8 |
1623332 | 1623332 | 2021-08-16 | Madison | Montana | 30057 | 834 | 8 |
1620085 | 1620085 | 2021-08-15 | Madison | Montana | 30057 | 834 | 8 |
1616837 | 1616837 | 2021-08-14 | Madison | Montana | 30057 | 834 | 8 |
1613589 | 1613589 | 2021-08-13 | Madison | Montana | 30057 | 834 | 8 |
1610340 | 1610340 | 2021-08-12 | Madison | Montana | 30057 | 834 | 8 |
1607092 | 1607092 | 2021-08-11 | Madison | Montana | 30057 | 832 | 8 |
1603843 | 1603843 | 2021-08-10 | Madison | Montana | 30057 | 828 | 8 |
1600594 | 1600594 | 2021-08-09 | Madison | Montana | 30057 | 826 | 8 |
1597346 | 1597346 | 2021-08-08 | Madison | Montana | 30057 | 823 | 8 |
1594097 | 1594097 | 2021-08-07 | Madison | Montana | 30057 | 823 | 8 |
1590848 | 1590848 | 2021-08-06 | Madison | Montana | 30057 | 823 | 8 |
1587599 | 1587599 | 2021-08-05 | Madison | Montana | 30057 | 821 | 8 |
1584348 | 1584348 | 2021-08-04 | Madison | Montana | 30057 | 818 | 8 |
1581099 | 1581099 | 2021-08-03 | Madison | Montana | 30057 | 815 | 8 |
1577850 | 1577850 | 2021-08-02 | Madison | Montana | 30057 | 815 | 8 |
1574602 | 1574602 | 2021-08-01 | Madison | Montana | 30057 | 811 | 8 |
1571354 | 1571354 | 2021-07-31 | Madison | Montana | 30057 | 811 | 8 |
1568106 | 1568106 | 2021-07-30 | Madison | Montana | 30057 | 811 | 8 |
1564858 | 1564858 | 2021-07-29 | Madison | Montana | 30057 | 806 | 8 |
1561610 | 1561610 | 2021-07-28 | Madison | Montana | 30057 | 806 | 8 |
1558362 | 1558362 | 2021-07-27 | Madison | Montana | 30057 | 804 | 8 |
1555115 | 1555115 | 2021-07-26 | Madison | Montana | 30057 | 803 | 8 |
1551868 | 1551868 | 2021-07-25 | Madison | Montana | 30057 | 802 | 8 |
1548621 | 1548621 | 2021-07-24 | Madison | Montana | 30057 | 802 | 8 |
1545374 | 1545374 | 2021-07-23 | Madison | Montana | 30057 | 802 | 8 |
1542126 | 1542126 | 2021-07-22 | Madison | Montana | 30057 | 801 | 8 |
1538879 | 1538879 | 2021-07-21 | Madison | Montana | 30057 | 798 | 8 |
1535632 | 1535632 | 2021-07-20 | Madison | Montana | 30057 | 798 | 8 |
1532384 | 1532384 | 2021-07-19 | Madison | Montana | 30057 | 798 | 8 |
1529137 | 1529137 | 2021-07-18 | Madison | Montana | 30057 | 798 | 8 |
1525890 | 1525890 | 2021-07-17 | Madison | Montana | 30057 | 798 | 8 |
1522643 | 1522643 | 2021-07-16 | Madison | Montana | 30057 | 798 | 8 |
1519394 | 1519394 | 2021-07-15 | Madison | Montana | 30057 | 798 | 8 |
1516147 | 1516147 | 2021-07-14 | Madison | Montana | 30057 | 798 | 8 |
1512901 | 1512901 | 2021-07-13 | Madison | Montana | 30057 | 798 | 8 |
1509654 | 1509654 | 2021-07-12 | Madison | Montana | 30057 | 797 | 8 |
1506408 | 1506408 | 2021-07-11 | Madison | Montana | 30057 | 798 | 8 |
1503162 | 1503162 | 2021-07-10 | Madison | Montana | 30057 | 798 | 8 |
1499916 | 1499916 | 2021-07-09 | Madison | Montana | 30057 | 798 | 8 |
1496670 | 1496670 | 2021-07-08 | Madison | Montana | 30057 | 797 | 8 |
1493423 | 1493423 | 2021-07-07 | Madison | Montana | 30057 | 796 | 8 |
1490176 | 1490176 | 2021-07-06 | Madison | Montana | 30057 | 796 | 8 |
1486929 | 1486929 | 2021-07-05 | Madison | Montana | 30057 | 796 | 8 |
1483683 | 1483683 | 2021-07-04 | Madison | Montana | 30057 | 796 | 8 |
1480437 | 1480437 | 2021-07-03 | Madison | Montana | 30057 | 796 | 8 |
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);