ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where county = "Richland" and deaths = 18 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Montana 134
- Ohio 15
- Illinois 10
- Louisiana 8
- North Dakota 5
- South Carolina 1
county 1
- Richland · 173 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1831266 | 1831266 | 2021-10-19 | Richland | Montana | 30083 | 1671 | 18 |
1828017 | 1828017 | 2021-10-18 | Richland | Montana | 30083 | 1652 | 18 |
1824768 | 1824768 | 2021-10-17 | Richland | Montana | 30083 | 1637 | 18 |
1821519 | 1821519 | 2021-10-16 | Richland | Montana | 30083 | 1637 | 18 |
1818270 | 1818270 | 2021-10-15 | Richland | Montana | 30083 | 1637 | 18 |
1815021 | 1815021 | 2021-10-14 | Richland | Montana | 30083 | 1621 | 18 |
1811773 | 1811773 | 2021-10-13 | Richland | Montana | 30083 | 1600 | 18 |
1808524 | 1808524 | 2021-10-12 | Richland | Montana | 30083 | 1600 | 18 |
1805273 | 1805273 | 2021-10-11 | Richland | Montana | 30083 | 1588 | 18 |
1802024 | 1802024 | 2021-10-10 | Richland | Montana | 30083 | 1588 | 18 |
1798775 | 1798775 | 2021-10-09 | Richland | Montana | 30083 | 1588 | 18 |
1795526 | 1795526 | 2021-10-08 | Richland | Montana | 30083 | 1588 | 18 |
1792277 | 1792277 | 2021-10-07 | Richland | Montana | 30083 | 1577 | 18 |
1789028 | 1789028 | 2021-10-06 | Richland | Montana | 30083 | 1575 | 18 |
1785780 | 1785780 | 2021-10-05 | Richland | Montana | 30083 | 1571 | 18 |
1782531 | 1782531 | 2021-10-04 | Richland | Montana | 30083 | 1570 | 18 |
1779281 | 1779281 | 2021-10-03 | Richland | Montana | 30083 | 1542 | 18 |
1776031 | 1776031 | 2021-10-02 | Richland | Montana | 30083 | 1542 | 18 |
1772781 | 1772781 | 2021-10-01 | Richland | Montana | 30083 | 1542 | 18 |
1769532 | 1769532 | 2021-09-30 | Richland | Montana | 30083 | 1541 | 18 |
1766283 | 1766283 | 2021-09-29 | Richland | Montana | 30083 | 1538 | 18 |
1763034 | 1763034 | 2021-09-28 | Richland | Montana | 30083 | 1533 | 18 |
1759785 | 1759785 | 2021-09-27 | Richland | Montana | 30083 | 1529 | 18 |
1756537 | 1756537 | 2021-09-26 | Richland | Montana | 30083 | 1487 | 18 |
1753289 | 1753289 | 2021-09-25 | Richland | Montana | 30083 | 1487 | 18 |
1750041 | 1750041 | 2021-09-24 | Richland | Montana | 30083 | 1487 | 18 |
1746791 | 1746791 | 2021-09-23 | Richland | Montana | 30083 | 1484 | 18 |
1743542 | 1743542 | 2021-09-22 | Richland | Montana | 30083 | 1484 | 18 |
1740293 | 1740293 | 2021-09-21 | Richland | Montana | 30083 | 1482 | 18 |
1737044 | 1737044 | 2021-09-20 | Richland | Montana | 30083 | 1481 | 18 |
1733794 | 1733794 | 2021-09-19 | Richland | Montana | 30083 | 1438 | 18 |
1730544 | 1730544 | 2021-09-18 | Richland | Montana | 30083 | 1438 | 18 |
1727294 | 1727294 | 2021-09-17 | Richland | Montana | 30083 | 1438 | 18 |
1724045 | 1724045 | 2021-09-16 | Richland | Montana | 30083 | 1437 | 18 |
1720796 | 1720796 | 2021-09-15 | Richland | Montana | 30083 | 1435 | 18 |
1717548 | 1717548 | 2021-09-14 | Richland | Montana | 30083 | 1435 | 18 |
1714300 | 1714300 | 2021-09-13 | Richland | Montana | 30083 | 1433 | 18 |
1711054 | 1711054 | 2021-09-12 | Richland | Montana | 30083 | 1414 | 18 |
1707807 | 1707807 | 2021-09-11 | Richland | Montana | 30083 | 1414 | 18 |
1704560 | 1704560 | 2021-09-10 | Richland | Montana | 30083 | 1414 | 18 |
1701310 | 1701310 | 2021-09-09 | Richland | Montana | 30083 | 1408 | 18 |
1698061 | 1698061 | 2021-09-08 | Richland | Montana | 30083 | 1380 | 18 |
1694813 | 1694813 | 2021-09-07 | Richland | Montana | 30083 | 1375 | 18 |
1691564 | 1691564 | 2021-09-06 | Richland | Montana | 30083 | 1364 | 18 |
1688314 | 1688314 | 2021-09-05 | Richland | Montana | 30083 | 1364 | 18 |
1685064 | 1685064 | 2021-09-04 | Richland | Montana | 30083 | 1364 | 18 |
1681813 | 1681813 | 2021-09-03 | Richland | Montana | 30083 | 1364 | 18 |
1678565 | 1678565 | 2021-09-02 | Richland | Montana | 30083 | 1362 | 18 |
1675317 | 1675317 | 2021-09-01 | Richland | Montana | 30083 | 1353 | 18 |
1672069 | 1672069 | 2021-08-31 | Richland | Montana | 30083 | 1349 | 18 |
1672458 | 1672458 | 2021-08-31 | Richland | North Dakota | 38077 | 2109 | 18 |
1668822 | 1668822 | 2021-08-30 | Richland | Montana | 30083 | 1340 | 18 |
1669210 | 1669210 | 2021-08-30 | Richland | North Dakota | 38077 | 2099 | 18 |
1665575 | 1665575 | 2021-08-29 | Richland | Montana | 30083 | 1322 | 18 |
1665963 | 1665963 | 2021-08-29 | Richland | North Dakota | 38077 | 2095 | 18 |
1662327 | 1662327 | 2021-08-28 | Richland | Montana | 30083 | 1322 | 18 |
1662715 | 1662715 | 2021-08-28 | Richland | North Dakota | 38077 | 2095 | 18 |
1659079 | 1659079 | 2021-08-27 | Richland | Montana | 30083 | 1322 | 18 |
1659467 | 1659467 | 2021-08-27 | Richland | North Dakota | 38077 | 2091 | 18 |
1655830 | 1655830 | 2021-08-26 | Richland | Montana | 30083 | 1309 | 18 |
1652583 | 1652583 | 2021-08-25 | Richland | Montana | 30083 | 1305 | 18 |
1649335 | 1649335 | 2021-08-24 | Richland | Montana | 30083 | 1300 | 18 |
1646086 | 1646086 | 2021-08-23 | Richland | Montana | 30083 | 1300 | 18 |
1642837 | 1642837 | 2021-08-22 | Richland | Montana | 30083 | 1292 | 18 |
1639587 | 1639587 | 2021-08-21 | Richland | Montana | 30083 | 1292 | 18 |
1636337 | 1636337 | 2021-08-20 | Richland | Montana | 30083 | 1292 | 18 |
1633087 | 1633087 | 2021-08-19 | Richland | Montana | 30083 | 1289 | 18 |
1629840 | 1629840 | 2021-08-18 | Richland | Montana | 30083 | 1288 | 18 |
1626593 | 1626593 | 2021-08-17 | Richland | Montana | 30083 | 1281 | 18 |
1623346 | 1623346 | 2021-08-16 | Richland | Montana | 30083 | 1276 | 18 |
1620099 | 1620099 | 2021-08-15 | Richland | Montana | 30083 | 1274 | 18 |
1616851 | 1616851 | 2021-08-14 | Richland | Montana | 30083 | 1274 | 18 |
1613603 | 1613603 | 2021-08-13 | Richland | Montana | 30083 | 1274 | 18 |
1610354 | 1610354 | 2021-08-12 | Richland | Montana | 30083 | 1271 | 18 |
1607106 | 1607106 | 2021-08-11 | Richland | Montana | 30083 | 1270 | 18 |
1603857 | 1603857 | 2021-08-10 | Richland | Montana | 30083 | 1269 | 18 |
1600608 | 1600608 | 2021-08-09 | Richland | Montana | 30083 | 1269 | 18 |
1597360 | 1597360 | 2021-08-08 | Richland | Montana | 30083 | 1269 | 18 |
1594111 | 1594111 | 2021-08-07 | Richland | Montana | 30083 | 1269 | 18 |
1590862 | 1590862 | 2021-08-06 | Richland | Montana | 30083 | 1269 | 18 |
1587613 | 1587613 | 2021-08-05 | Richland | Montana | 30083 | 1268 | 18 |
1584362 | 1584362 | 2021-08-04 | Richland | Montana | 30083 | 1268 | 18 |
1581113 | 1581113 | 2021-08-03 | Richland | Montana | 30083 | 1268 | 18 |
1577864 | 1577864 | 2021-08-02 | Richland | Montana | 30083 | 1268 | 18 |
1574616 | 1574616 | 2021-08-01 | Richland | Montana | 30083 | 1265 | 18 |
1571368 | 1571368 | 2021-07-31 | Richland | Montana | 30083 | 1265 | 18 |
1568120 | 1568120 | 2021-07-30 | Richland | Montana | 30083 | 1265 | 18 |
1564872 | 1564872 | 2021-07-29 | Richland | Montana | 30083 | 1264 | 18 |
1561624 | 1561624 | 2021-07-28 | Richland | Montana | 30083 | 1263 | 18 |
1558376 | 1558376 | 2021-07-27 | Richland | Montana | 30083 | 1263 | 18 |
1555129 | 1555129 | 2021-07-26 | Richland | Montana | 30083 | 1263 | 18 |
1551882 | 1551882 | 2021-07-25 | Richland | Montana | 30083 | 1262 | 18 |
1548635 | 1548635 | 2021-07-24 | Richland | Montana | 30083 | 1262 | 18 |
1545388 | 1545388 | 2021-07-23 | Richland | Montana | 30083 | 1262 | 18 |
1542140 | 1542140 | 2021-07-22 | Richland | Montana | 30083 | 1262 | 18 |
1538893 | 1538893 | 2021-07-21 | Richland | Montana | 30083 | 1262 | 18 |
1535646 | 1535646 | 2021-07-20 | Richland | Montana | 30083 | 1260 | 18 |
1532398 | 1532398 | 2021-07-19 | Richland | Montana | 30083 | 1258 | 18 |
1529151 | 1529151 | 2021-07-18 | Richland | Montana | 30083 | 1258 | 18 |
1525904 | 1525904 | 2021-07-17 | Richland | Montana | 30083 | 1258 | 18 |
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);