ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,030 rows where state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Colorado · 1,030 ✖
| Link | rowid | date ▲ | state | fips | cases | deaths |
|---|---|---|---|---|---|---|
| 57189 | 57189 | 2022-12-29 | Colorado | 8 | 1733812 | 13891 |
| 57133 | 57133 | 2022-12-28 | Colorado | 8 | 1732984 | 13882 |
| 57077 | 57077 | 2022-12-27 | Colorado | 8 | 1731997 | 13859 |
| 57021 | 57021 | 2022-12-26 | Colorado | 8 | 1731721 | 13859 |
| 56965 | 56965 | 2022-12-25 | Colorado | 8 | 1730237 | 13857 |
| 56909 | 56909 | 2022-12-24 | Colorado | 8 | 1730237 | 13857 |
| 56853 | 56853 | 2022-12-23 | Colorado | 8 | 1730237 | 13857 |
| 56797 | 56797 | 2022-12-22 | Colorado | 8 | 1729516 | 13831 |
| 56741 | 56741 | 2022-12-21 | Colorado | 8 | 1728600 | 13826 |
| 56685 | 56685 | 2022-12-20 | Colorado | 8 | 1727215 | 13813 |
| 56629 | 56629 | 2022-12-19 | Colorado | 8 | 1725982 | 13802 |
| 56573 | 56573 | 2022-12-18 | Colorado | 8 | 1724056 | 13791 |
| 56517 | 56517 | 2022-12-17 | Colorado | 8 | 1724056 | 13791 |
| 56461 | 56461 | 2022-12-16 | Colorado | 8 | 1724056 | 13791 |
| 56405 | 56405 | 2022-12-15 | Colorado | 8 | 1723043 | 13769 |
| 56349 | 56349 | 2022-12-14 | Colorado | 8 | 1722079 | 13762 |
| 56293 | 56293 | 2022-12-13 | Colorado | 8 | 1720900 | 13759 |
| 56237 | 56237 | 2022-12-12 | Colorado | 8 | 1719935 | 13735 |
| 56181 | 56181 | 2022-12-11 | Colorado | 8 | 1718247 | 13724 |
| 56125 | 56125 | 2022-12-10 | Colorado | 8 | 1718247 | 13724 |
| 56069 | 56069 | 2022-12-09 | Colorado | 8 | 1718247 | 13724 |
| 56013 | 56013 | 2022-12-08 | Colorado | 8 | 1716945 | 13718 |
| 55957 | 55957 | 2022-12-07 | Colorado | 8 | 1715828 | 13701 |
| 55901 | 55901 | 2022-12-06 | Colorado | 8 | 1714697 | 13687 |
| 55845 | 55845 | 2022-12-05 | Colorado | 8 | 1713488 | 13671 |
| 55789 | 55789 | 2022-12-04 | Colorado | 8 | 1711236 | 13651 |
| 55733 | 55733 | 2022-12-03 | Colorado | 8 | 1711236 | 13651 |
| 55677 | 55677 | 2022-12-02 | Colorado | 8 | 1711236 | 13651 |
| 55621 | 55621 | 2022-12-01 | Colorado | 8 | 1709483 | 13646 |
| 55565 | 55565 | 2022-11-30 | Colorado | 8 | 1708152 | 13628 |
| 55509 | 55509 | 2022-11-29 | Colorado | 8 | 1706600 | 13628 |
| 55453 | 55453 | 2022-11-28 | Colorado | 8 | 1705158 | 13605 |
| 55397 | 55397 | 2022-11-27 | Colorado | 8 | 1702894 | 13605 |
| 55341 | 55341 | 2022-11-26 | Colorado | 8 | 1700918 | 13591 |
| 55285 | 55285 | 2022-11-25 | Colorado | 8 | 1700918 | 13591 |
| 55229 | 55229 | 2022-11-24 | Colorado | 8 | 1700918 | 13591 |
| 55173 | 55173 | 2022-11-23 | Colorado | 8 | 1700918 | 13591 |
| 55117 | 55117 | 2022-11-22 | Colorado | 8 | 1699558 | 13577 |
| 55061 | 55061 | 2022-11-21 | Colorado | 8 | 1697898 | 13546 |
| 55005 | 55005 | 2022-11-20 | Colorado | 8 | 1695257 | 13546 |
| 54949 | 54949 | 2022-11-19 | Colorado | 8 | 1695257 | 13546 |
| 54893 | 54893 | 2022-11-18 | Colorado | 8 | 1695257 | 13546 |
| 54837 | 54837 | 2022-11-17 | Colorado | 8 | 1693616 | 13541 |
| 54781 | 54781 | 2022-11-16 | Colorado | 8 | 1692199 | 13526 |
| 54725 | 54725 | 2022-11-15 | Colorado | 8 | 1697542 | 13724 |
| 54669 | 54669 | 2022-11-14 | Colorado | 8 | 1695579 | 13712 |
| 54613 | 54613 | 2022-11-13 | Colorado | 8 | 1692864 | 13707 |
| 54557 | 54557 | 2022-11-12 | Colorado | 8 | 1692864 | 13707 |
| 54501 | 54501 | 2022-11-11 | Colorado | 8 | 1692864 | 13707 |
| 54445 | 54445 | 2022-11-10 | Colorado | 8 | 1691976 | 13684 |
| 54389 | 54389 | 2022-11-09 | Colorado | 8 | 1691057 | 13678 |
| 54333 | 54333 | 2022-11-08 | Colorado | 8 | 1689838 | 13671 |
| 54277 | 54277 | 2022-11-07 | Colorado | 8 | 1688375 | 13658 |
| 54221 | 54221 | 2022-11-06 | Colorado | 8 | 1686535 | 13653 |
| 54165 | 54165 | 2022-11-05 | Colorado | 8 | 1686535 | 13653 |
| 54109 | 54109 | 2022-11-04 | Colorado | 8 | 1686535 | 13653 |
| 54053 | 54053 | 2022-11-03 | Colorado | 8 | 1685037 | 13643 |
| 53997 | 53997 | 2022-11-02 | Colorado | 8 | 1684272 | 13635 |
| 53941 | 53941 | 2022-11-01 | Colorado | 8 | 1683042 | 13631 |
| 53885 | 53885 | 2022-10-31 | Colorado | 8 | 1681928 | 13626 |
| 53829 | 53829 | 2022-10-30 | Colorado | 8 | 1680534 | 13618 |
| 53773 | 53773 | 2022-10-29 | Colorado | 8 | 1680534 | 13618 |
| 53717 | 53717 | 2022-10-28 | Colorado | 8 | 1680534 | 13618 |
| 53661 | 53661 | 2022-10-27 | Colorado | 8 | 1679515 | 13614 |
| 53605 | 53605 | 2022-10-26 | Colorado | 8 | 1678736 | 13606 |
| 53549 | 53549 | 2022-10-25 | Colorado | 8 | 1677845 | 13601 |
| 53493 | 53493 | 2022-10-24 | Colorado | 8 | 1676838 | 13596 |
| 53437 | 53437 | 2022-10-23 | Colorado | 8 | 1675374 | 13592 |
| 53381 | 53381 | 2022-10-22 | Colorado | 8 | 1675374 | 13592 |
| 53325 | 53325 | 2022-10-21 | Colorado | 8 | 1675374 | 13592 |
| 53269 | 53269 | 2022-10-20 | Colorado | 8 | 1674460 | 13588 |
| 53213 | 53213 | 2022-10-19 | Colorado | 8 | 1673522 | 13583 |
| 53157 | 53157 | 2022-10-18 | Colorado | 8 | 1672464 | 13578 |
| 53101 | 53101 | 2022-10-17 | Colorado | 8 | 1671792 | 13572 |
| 53045 | 53045 | 2022-10-16 | Colorado | 8 | 1670653 | 13569 |
| 52989 | 52989 | 2022-10-15 | Colorado | 8 | 1670653 | 13569 |
| 52933 | 52933 | 2022-10-14 | Colorado | 8 | 1670653 | 13569 |
| 52877 | 52877 | 2022-10-13 | Colorado | 8 | 1669742 | 13566 |
| 52821 | 52821 | 2022-10-12 | Colorado | 8 | 1668964 | 13556 |
| 52765 | 52765 | 2022-10-11 | Colorado | 8 | 1668303 | 13550 |
| 52709 | 52709 | 2022-10-10 | Colorado | 8 | 1667452 | 13541 |
| 52653 | 52653 | 2022-10-09 | Colorado | 8 | 1666305 | 13536 |
| 52597 | 52597 | 2022-10-08 | Colorado | 8 | 1666305 | 13536 |
| 52541 | 52541 | 2022-10-07 | Colorado | 8 | 1666305 | 13536 |
| 52485 | 52485 | 2022-10-06 | Colorado | 8 | 1665527 | 13536 |
| 52429 | 52429 | 2022-10-05 | Colorado | 8 | 1664888 | 13534 |
| 52373 | 52373 | 2022-10-04 | Colorado | 8 | 1664007 | 13522 |
| 52317 | 52317 | 2022-10-03 | Colorado | 8 | 1662369 | 13519 |
| 52261 | 52261 | 2022-10-02 | Colorado | 8 | 1661882 | 13516 |
| 52205 | 52205 | 2022-10-01 | Colorado | 8 | 1661882 | 13516 |
| 52149 | 52149 | 2022-09-30 | Colorado | 8 | 1661882 | 13516 |
| 52093 | 52093 | 2022-09-29 | Colorado | 8 | 1660985 | 13509 |
| 52037 | 52037 | 2022-09-28 | Colorado | 8 | 1659878 | 13499 |
| 51981 | 51981 | 2022-09-27 | Colorado | 8 | 1659034 | 13489 |
| 51925 | 51925 | 2022-09-26 | Colorado | 8 | 1658115 | 13481 |
| 51869 | 51869 | 2022-09-25 | Colorado | 8 | 1656816 | 13474 |
| 51813 | 51813 | 2022-09-24 | Colorado | 8 | 1656816 | 13474 |
| 51757 | 51757 | 2022-09-23 | Colorado | 8 | 1656816 | 13474 |
| 51701 | 51701 | 2022-09-22 | Colorado | 8 | 1656008 | 13465 |
| 51645 | 51645 | 2022-09-21 | Colorado | 8 | 1655107 | 13459 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );