ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8113 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810419 | 1810419 | 2021-10-13 | San Miguel | Colorado | 8113 | 1151 | 4 |
1807170 | 1807170 | 2021-10-12 | San Miguel | Colorado | 8113 | 1148 | 3 |
1803919 | 1803919 | 2021-10-11 | San Miguel | Colorado | 8113 | 1147 | 3 |
1800670 | 1800670 | 2021-10-10 | San Miguel | Colorado | 8113 | 1142 | 3 |
1797421 | 1797421 | 2021-10-09 | San Miguel | Colorado | 8113 | 1142 | 3 |
1794172 | 1794172 | 2021-10-08 | San Miguel | Colorado | 8113 | 1142 | 3 |
1790924 | 1790924 | 2021-10-07 | San Miguel | Colorado | 8113 | 1136 | 3 |
1787675 | 1787675 | 2021-10-06 | San Miguel | Colorado | 8113 | 1135 | 3 |
1784426 | 1784426 | 2021-10-05 | San Miguel | Colorado | 8113 | 1134 | 3 |
1781177 | 1781177 | 2021-10-04 | San Miguel | Colorado | 8113 | 1133 | 3 |
1777927 | 1777927 | 2021-10-03 | San Miguel | Colorado | 8113 | 1096 | 3 |
1774677 | 1774677 | 2021-10-02 | San Miguel | Colorado | 8113 | 1096 | 3 |
1771427 | 1771427 | 2021-10-01 | San Miguel | Colorado | 8113 | 1096 | 3 |
1768178 | 1768178 | 2021-09-30 | San Miguel | Colorado | 8113 | 1123 | 3 |
1764929 | 1764929 | 2021-09-29 | San Miguel | Colorado | 8113 | 1118 | 3 |
1761680 | 1761680 | 2021-09-28 | San Miguel | Colorado | 8113 | 1117 | 3 |
1758432 | 1758432 | 2021-09-27 | San Miguel | Colorado | 8113 | 1110 | 3 |
1755184 | 1755184 | 2021-09-26 | San Miguel | Colorado | 8113 | 1110 | 3 |
1751936 | 1751936 | 2021-09-25 | San Miguel | Colorado | 8113 | 1110 | 3 |
1748687 | 1748687 | 2021-09-24 | San Miguel | Colorado | 8113 | 1110 | 3 |
1745437 | 1745437 | 2021-09-23 | San Miguel | Colorado | 8113 | 1103 | 3 |
1742188 | 1742188 | 2021-09-22 | San Miguel | Colorado | 8113 | 1102 | 3 |
1738939 | 1738939 | 2021-09-21 | San Miguel | Colorado | 8113 | 1099 | 3 |
1735690 | 1735690 | 2021-09-20 | San Miguel | Colorado | 8113 | 1098 | 3 |
1732440 | 1732440 | 2021-09-19 | San Miguel | Colorado | 8113 | 1085 | 3 |
1729190 | 1729190 | 2021-09-18 | San Miguel | Colorado | 8113 | 1085 | 3 |
1725940 | 1725940 | 2021-09-17 | San Miguel | Colorado | 8113 | 1085 | 3 |
1722691 | 1722691 | 2021-09-16 | San Miguel | Colorado | 8113 | 1079 | 3 |
1719442 | 1719442 | 2021-09-15 | San Miguel | Colorado | 8113 | 1076 | 3 |
1716194 | 1716194 | 2021-09-14 | San Miguel | Colorado | 8113 | 1072 | 3 |
1712948 | 1712948 | 2021-09-13 | San Miguel | Colorado | 8113 | 1068 | 3 |
1709701 | 1709701 | 2021-09-12 | San Miguel | Colorado | 8113 | 1055 | 3 |
1706454 | 1706454 | 2021-09-11 | San Miguel | Colorado | 8113 | 1055 | 3 |
1703206 | 1703206 | 2021-09-10 | San Miguel | Colorado | 8113 | 1055 | 3 |
1699956 | 1699956 | 2021-09-09 | San Miguel | Colorado | 8113 | 1053 | 3 |
1696707 | 1696707 | 2021-09-08 | San Miguel | Colorado | 8113 | 1053 | 3 |
1693459 | 1693459 | 2021-09-07 | San Miguel | Colorado | 8113 | 1049 | 3 |
1690210 | 1690210 | 2021-09-06 | San Miguel | Colorado | 8113 | 1047 | 3 |
1686960 | 1686960 | 2021-09-05 | San Miguel | Colorado | 8113 | 1044 | 3 |
1683710 | 1683710 | 2021-09-04 | San Miguel | Colorado | 8113 | 1044 | 3 |
1680459 | 1680459 | 2021-09-03 | San Miguel | Colorado | 8113 | 1044 | 3 |
1677211 | 1677211 | 2021-09-02 | San Miguel | Colorado | 8113 | 1041 | 3 |
1673964 | 1673964 | 2021-09-01 | San Miguel | Colorado | 8113 | 1039 | 3 |
1670716 | 1670716 | 2021-08-31 | San Miguel | Colorado | 8113 | 1037 | 3 |
1667469 | 1667469 | 2021-08-30 | San Miguel | Colorado | 8113 | 1036 | 2 |
1664222 | 1664222 | 2021-08-29 | San Miguel | Colorado | 8113 | 1023 | 2 |
1660974 | 1660974 | 2021-08-28 | San Miguel | Colorado | 8113 | 1023 | 2 |
1657726 | 1657726 | 2021-08-27 | San Miguel | Colorado | 8113 | 1023 | 2 |
1654478 | 1654478 | 2021-08-26 | San Miguel | Colorado | 8113 | 999 | 1 |
1651231 | 1651231 | 2021-08-25 | San Miguel | Colorado | 8113 | 998 | 1 |
1647982 | 1647982 | 2021-08-24 | San Miguel | Colorado | 8113 | 994 | 1 |
1644734 | 1644734 | 2021-08-23 | San Miguel | Colorado | 8113 | 991 | 1 |
1641484 | 1641484 | 2021-08-22 | San Miguel | Colorado | 8113 | 988 | 1 |
1638234 | 1638234 | 2021-08-21 | San Miguel | Colorado | 8113 | 988 | 1 |
1634984 | 1634984 | 2021-08-20 | San Miguel | Colorado | 8113 | 988 | 1 |
1631735 | 1631735 | 2021-08-19 | San Miguel | Colorado | 8113 | 986 | 1 |
1628488 | 1628488 | 2021-08-18 | San Miguel | Colorado | 8113 | 982 | 1 |
1625241 | 1625241 | 2021-08-17 | San Miguel | Colorado | 8113 | 982 | 1 |
1621994 | 1621994 | 2021-08-16 | San Miguel | Colorado | 8113 | 982 | 1 |
1618747 | 1618747 | 2021-08-15 | San Miguel | Colorado | 8113 | 970 | 1 |
1615499 | 1615499 | 2021-08-14 | San Miguel | Colorado | 8113 | 970 | 1 |
1612250 | 1612250 | 2021-08-13 | San Miguel | Colorado | 8113 | 970 | 1 |
1609002 | 1609002 | 2021-08-12 | San Miguel | Colorado | 8113 | 970 | 1 |
1605753 | 1605753 | 2021-08-11 | San Miguel | Colorado | 8113 | 966 | 1 |
1602504 | 1602504 | 2021-08-10 | San Miguel | Colorado | 8113 | 963 | 1 |
1599255 | 1599255 | 2021-08-09 | San Miguel | Colorado | 8113 | 963 | 1 |
1596006 | 1596006 | 2021-08-08 | San Miguel | Colorado | 8113 | 960 | 1 |
1592757 | 1592757 | 2021-08-07 | San Miguel | Colorado | 8113 | 960 | 1 |
1589508 | 1589508 | 2021-08-06 | San Miguel | Colorado | 8113 | 960 | 1 |
1586259 | 1586259 | 2021-08-05 | San Miguel | Colorado | 8113 | 957 | 1 |
1583009 | 1583009 | 2021-08-04 | San Miguel | Colorado | 8113 | 954 | 1 |
1579759 | 1579759 | 2021-08-03 | San Miguel | Colorado | 8113 | 953 | 1 |
1576511 | 1576511 | 2021-08-02 | San Miguel | Colorado | 8113 | 952 | 1 |
1573263 | 1573263 | 2021-08-01 | San Miguel | Colorado | 8113 | 952 | 1 |
1570015 | 1570015 | 2021-07-31 | San Miguel | Colorado | 8113 | 952 | 1 |
1566767 | 1566767 | 2021-07-30 | San Miguel | Colorado | 8113 | 952 | 1 |
1563519 | 1563519 | 2021-07-29 | San Miguel | Colorado | 8113 | 949 | 1 |
1560271 | 1560271 | 2021-07-28 | San Miguel | Colorado | 8113 | 948 | 1 |
1557024 | 1557024 | 2021-07-27 | San Miguel | Colorado | 8113 | 946 | 1 |
1553777 | 1553777 | 2021-07-26 | San Miguel | Colorado | 8113 | 946 | 1 |
1550530 | 1550530 | 2021-07-25 | San Miguel | Colorado | 8113 | 944 | 1 |
1547283 | 1547283 | 2021-07-24 | San Miguel | Colorado | 8113 | 944 | 1 |
1544036 | 1544036 | 2021-07-23 | San Miguel | Colorado | 8113 | 944 | 1 |
1540788 | 1540788 | 2021-07-22 | San Miguel | Colorado | 8113 | 942 | 1 |
1537541 | 1537541 | 2021-07-21 | San Miguel | Colorado | 8113 | 943 | 1 |
1534293 | 1534293 | 2021-07-20 | San Miguel | Colorado | 8113 | 937 | 1 |
1531046 | 1531046 | 2021-07-19 | San Miguel | Colorado | 8113 | 937 | 1 |
1527799 | 1527799 | 2021-07-18 | San Miguel | Colorado | 8113 | 937 | 1 |
1524552 | 1524552 | 2021-07-17 | San Miguel | Colorado | 8113 | 937 | 1 |
1521304 | 1521304 | 2021-07-16 | San Miguel | Colorado | 8113 | 937 | 1 |
1518056 | 1518056 | 2021-07-15 | San Miguel | Colorado | 8113 | 936 | 1 |
1514809 | 1514809 | 2021-07-14 | San Miguel | Colorado | 8113 | 935 | 1 |
1511563 | 1511563 | 2021-07-13 | San Miguel | Colorado | 8113 | 934 | 1 |
1508316 | 1508316 | 2021-07-12 | San Miguel | Colorado | 8113 | 933 | 1 |
1505070 | 1505070 | 2021-07-11 | San Miguel | Colorado | 8113 | 933 | 1 |
1501824 | 1501824 | 2021-07-10 | San Miguel | Colorado | 8113 | 931 | 1 |
1498578 | 1498578 | 2021-07-09 | San Miguel | Colorado | 8113 | 931 | 1 |
1495331 | 1495331 | 2021-07-08 | San Miguel | Colorado | 8113 | 930 | 1 |
1492085 | 1492085 | 2021-07-07 | San Miguel | Colorado | 8113 | 929 | 1 |
1488838 | 1488838 | 2021-07-06 | San Miguel | Colorado | 8113 | 926 | 1 |
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);