ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
325 rows where county = "Meagher", deaths = 7 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1782519 | 1782519 | 2021-10-04 | Meagher | Montana | 30059 | 225 | 7 |
1779269 | 1779269 | 2021-10-03 | Meagher | Montana | 30059 | 220 | 7 |
1776019 | 1776019 | 2021-10-02 | Meagher | Montana | 30059 | 220 | 7 |
1772769 | 1772769 | 2021-10-01 | Meagher | Montana | 30059 | 220 | 7 |
1769520 | 1769520 | 2021-09-30 | Meagher | Montana | 30059 | 215 | 7 |
1766271 | 1766271 | 2021-09-29 | Meagher | Montana | 30059 | 213 | 7 |
1763022 | 1763022 | 2021-09-28 | Meagher | Montana | 30059 | 210 | 7 |
1759773 | 1759773 | 2021-09-27 | Meagher | Montana | 30059 | 203 | 7 |
1756525 | 1756525 | 2021-09-26 | Meagher | Montana | 30059 | 198 | 7 |
1753277 | 1753277 | 2021-09-25 | Meagher | Montana | 30059 | 198 | 7 |
1750029 | 1750029 | 2021-09-24 | Meagher | Montana | 30059 | 198 | 7 |
1746779 | 1746779 | 2021-09-23 | Meagher | Montana | 30059 | 194 | 7 |
1743530 | 1743530 | 2021-09-22 | Meagher | Montana | 30059 | 192 | 7 |
1740281 | 1740281 | 2021-09-21 | Meagher | Montana | 30059 | 190 | 7 |
1737032 | 1737032 | 2021-09-20 | Meagher | Montana | 30059 | 186 | 7 |
1733782 | 1733782 | 2021-09-19 | Meagher | Montana | 30059 | 181 | 7 |
1730532 | 1730532 | 2021-09-18 | Meagher | Montana | 30059 | 181 | 7 |
1727282 | 1727282 | 2021-09-17 | Meagher | Montana | 30059 | 181 | 7 |
1724033 | 1724033 | 2021-09-16 | Meagher | Montana | 30059 | 179 | 7 |
1720784 | 1720784 | 2021-09-15 | Meagher | Montana | 30059 | 176 | 7 |
1717536 | 1717536 | 2021-09-14 | Meagher | Montana | 30059 | 174 | 7 |
1714288 | 1714288 | 2021-09-13 | Meagher | Montana | 30059 | 174 | 7 |
1711042 | 1711042 | 2021-09-12 | Meagher | Montana | 30059 | 173 | 7 |
1707795 | 1707795 | 2021-09-11 | Meagher | Montana | 30059 | 173 | 7 |
1704548 | 1704548 | 2021-09-10 | Meagher | Montana | 30059 | 173 | 7 |
1701298 | 1701298 | 2021-09-09 | Meagher | Montana | 30059 | 171 | 7 |
1698049 | 1698049 | 2021-09-08 | Meagher | Montana | 30059 | 171 | 7 |
1694801 | 1694801 | 2021-09-07 | Meagher | Montana | 30059 | 171 | 7 |
1691552 | 1691552 | 2021-09-06 | Meagher | Montana | 30059 | 167 | 7 |
1688302 | 1688302 | 2021-09-05 | Meagher | Montana | 30059 | 167 | 7 |
1685052 | 1685052 | 2021-09-04 | Meagher | Montana | 30059 | 167 | 7 |
1681801 | 1681801 | 2021-09-03 | Meagher | Montana | 30059 | 167 | 7 |
1678553 | 1678553 | 2021-09-02 | Meagher | Montana | 30059 | 167 | 7 |
1675305 | 1675305 | 2021-09-01 | Meagher | Montana | 30059 | 167 | 7 |
1672057 | 1672057 | 2021-08-31 | Meagher | Montana | 30059 | 166 | 7 |
1668810 | 1668810 | 2021-08-30 | Meagher | Montana | 30059 | 165 | 7 |
1665563 | 1665563 | 2021-08-29 | Meagher | Montana | 30059 | 161 | 7 |
1662315 | 1662315 | 2021-08-28 | Meagher | Montana | 30059 | 161 | 7 |
1659067 | 1659067 | 2021-08-27 | Meagher | Montana | 30059 | 161 | 7 |
1655818 | 1655818 | 2021-08-26 | Meagher | Montana | 30059 | 161 | 7 |
1652571 | 1652571 | 2021-08-25 | Meagher | Montana | 30059 | 161 | 7 |
1649323 | 1649323 | 2021-08-24 | Meagher | Montana | 30059 | 160 | 7 |
1646074 | 1646074 | 2021-08-23 | Meagher | Montana | 30059 | 160 | 7 |
1642825 | 1642825 | 2021-08-22 | Meagher | Montana | 30059 | 160 | 7 |
1639575 | 1639575 | 2021-08-21 | Meagher | Montana | 30059 | 160 | 7 |
1636325 | 1636325 | 2021-08-20 | Meagher | Montana | 30059 | 160 | 7 |
1633075 | 1633075 | 2021-08-19 | Meagher | Montana | 30059 | 160 | 7 |
1629828 | 1629828 | 2021-08-18 | Meagher | Montana | 30059 | 160 | 7 |
1626581 | 1626581 | 2021-08-17 | Meagher | Montana | 30059 | 159 | 7 |
1623334 | 1623334 | 2021-08-16 | Meagher | Montana | 30059 | 159 | 7 |
1620087 | 1620087 | 2021-08-15 | Meagher | Montana | 30059 | 159 | 7 |
1616839 | 1616839 | 2021-08-14 | Meagher | Montana | 30059 | 159 | 7 |
1613591 | 1613591 | 2021-08-13 | Meagher | Montana | 30059 | 159 | 7 |
1610342 | 1610342 | 2021-08-12 | Meagher | Montana | 30059 | 159 | 7 |
1607094 | 1607094 | 2021-08-11 | Meagher | Montana | 30059 | 159 | 7 |
1603845 | 1603845 | 2021-08-10 | Meagher | Montana | 30059 | 159 | 7 |
1600596 | 1600596 | 2021-08-09 | Meagher | Montana | 30059 | 156 | 7 |
1597348 | 1597348 | 2021-08-08 | Meagher | Montana | 30059 | 154 | 7 |
1594099 | 1594099 | 2021-08-07 | Meagher | Montana | 30059 | 154 | 7 |
1590850 | 1590850 | 2021-08-06 | Meagher | Montana | 30059 | 154 | 7 |
1587601 | 1587601 | 2021-08-05 | Meagher | Montana | 30059 | 154 | 7 |
1584350 | 1584350 | 2021-08-04 | Meagher | Montana | 30059 | 154 | 7 |
1581101 | 1581101 | 2021-08-03 | Meagher | Montana | 30059 | 154 | 7 |
1577852 | 1577852 | 2021-08-02 | Meagher | Montana | 30059 | 154 | 7 |
1574604 | 1574604 | 2021-08-01 | Meagher | Montana | 30059 | 153 | 7 |
1571356 | 1571356 | 2021-07-31 | Meagher | Montana | 30059 | 153 | 7 |
1568108 | 1568108 | 2021-07-30 | Meagher | Montana | 30059 | 153 | 7 |
1564860 | 1564860 | 2021-07-29 | Meagher | Montana | 30059 | 153 | 7 |
1561612 | 1561612 | 2021-07-28 | Meagher | Montana | 30059 | 153 | 7 |
1558364 | 1558364 | 2021-07-27 | Meagher | Montana | 30059 | 153 | 7 |
1555117 | 1555117 | 2021-07-26 | Meagher | Montana | 30059 | 152 | 7 |
1551870 | 1551870 | 2021-07-25 | Meagher | Montana | 30059 | 152 | 7 |
1548623 | 1548623 | 2021-07-24 | Meagher | Montana | 30059 | 152 | 7 |
1545376 | 1545376 | 2021-07-23 | Meagher | Montana | 30059 | 152 | 7 |
1542128 | 1542128 | 2021-07-22 | Meagher | Montana | 30059 | 152 | 7 |
1538881 | 1538881 | 2021-07-21 | Meagher | Montana | 30059 | 152 | 7 |
1535634 | 1535634 | 2021-07-20 | Meagher | Montana | 30059 | 152 | 7 |
1532386 | 1532386 | 2021-07-19 | Meagher | Montana | 30059 | 152 | 7 |
1529139 | 1529139 | 2021-07-18 | Meagher | Montana | 30059 | 152 | 7 |
1525892 | 1525892 | 2021-07-17 | Meagher | Montana | 30059 | 152 | 7 |
1522645 | 1522645 | 2021-07-16 | Meagher | Montana | 30059 | 152 | 7 |
1519396 | 1519396 | 2021-07-15 | Meagher | Montana | 30059 | 152 | 7 |
1516149 | 1516149 | 2021-07-14 | Meagher | Montana | 30059 | 152 | 7 |
1512903 | 1512903 | 2021-07-13 | Meagher | Montana | 30059 | 152 | 7 |
1509656 | 1509656 | 2021-07-12 | Meagher | Montana | 30059 | 152 | 7 |
1506410 | 1506410 | 2021-07-11 | Meagher | Montana | 30059 | 152 | 7 |
1503164 | 1503164 | 2021-07-10 | Meagher | Montana | 30059 | 152 | 7 |
1499918 | 1499918 | 2021-07-09 | Meagher | Montana | 30059 | 152 | 7 |
1496672 | 1496672 | 2021-07-08 | Meagher | Montana | 30059 | 153 | 7 |
1493425 | 1493425 | 2021-07-07 | Meagher | Montana | 30059 | 153 | 7 |
1490178 | 1490178 | 2021-07-06 | Meagher | Montana | 30059 | 152 | 7 |
1486931 | 1486931 | 2021-07-05 | Meagher | Montana | 30059 | 152 | 7 |
1483685 | 1483685 | 2021-07-04 | Meagher | Montana | 30059 | 152 | 7 |
1480439 | 1480439 | 2021-07-03 | Meagher | Montana | 30059 | 152 | 7 |
1477192 | 1477192 | 2021-07-02 | Meagher | Montana | 30059 | 152 | 7 |
1473946 | 1473946 | 2021-07-01 | Meagher | Montana | 30059 | 152 | 7 |
1470700 | 1470700 | 2021-06-30 | Meagher | Montana | 30059 | 152 | 7 |
1467455 | 1467455 | 2021-06-29 | Meagher | Montana | 30059 | 152 | 7 |
1464210 | 1464210 | 2021-06-28 | Meagher | Montana | 30059 | 152 | 7 |
1460965 | 1460965 | 2021-06-27 | Meagher | Montana | 30059 | 152 | 7 |
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);