ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
175 rows where county = "Colfax", deaths = 47 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811936 | 1811936 | 2021-10-13 | Colfax | New Mexico | 35007 | 1377 | 47 |
1808687 | 1808687 | 2021-10-12 | Colfax | New Mexico | 35007 | 1375 | 47 |
1805436 | 1805436 | 2021-10-11 | Colfax | New Mexico | 35007 | 1360 | 47 |
1802187 | 1802187 | 2021-10-10 | Colfax | New Mexico | 35007 | 1360 | 47 |
1798938 | 1798938 | 2021-10-09 | Colfax | New Mexico | 35007 | 1360 | 47 |
1795689 | 1795689 | 2021-10-08 | Colfax | New Mexico | 35007 | 1360 | 47 |
1792440 | 1792440 | 2021-10-07 | Colfax | New Mexico | 35007 | 1347 | 47 |
1789191 | 1789191 | 2021-10-06 | Colfax | New Mexico | 35007 | 1340 | 47 |
1785943 | 1785943 | 2021-10-05 | Colfax | New Mexico | 35007 | 1328 | 47 |
1782694 | 1782694 | 2021-10-04 | Colfax | New Mexico | 35007 | 1324 | 47 |
1779444 | 1779444 | 2021-10-03 | Colfax | New Mexico | 35007 | 1318 | 47 |
1776194 | 1776194 | 2021-10-02 | Colfax | New Mexico | 35007 | 1318 | 47 |
1772944 | 1772944 | 2021-10-01 | Colfax | New Mexico | 35007 | 1318 | 47 |
1769695 | 1769695 | 2021-09-30 | Colfax | New Mexico | 35007 | 1309 | 47 |
1766446 | 1766446 | 2021-09-29 | Colfax | New Mexico | 35007 | 1291 | 47 |
1763197 | 1763197 | 2021-09-28 | Colfax | New Mexico | 35007 | 1289 | 47 |
1759948 | 1759948 | 2021-09-27 | Colfax | New Mexico | 35007 | 1282 | 47 |
1756700 | 1756700 | 2021-09-26 | Colfax | New Mexico | 35007 | 1267 | 47 |
1753452 | 1753452 | 2021-09-25 | Colfax | New Mexico | 35007 | 1267 | 47 |
1750204 | 1750204 | 2021-09-24 | Colfax | New Mexico | 35007 | 1267 | 47 |
1746954 | 1746954 | 2021-09-23 | Colfax | New Mexico | 35007 | 1258 | 47 |
1743705 | 1743705 | 2021-09-22 | Colfax | New Mexico | 35007 | 1254 | 47 |
1740456 | 1740456 | 2021-09-21 | Colfax | New Mexico | 35007 | 1241 | 47 |
1737207 | 1737207 | 2021-09-20 | Colfax | New Mexico | 35007 | 1233 | 47 |
1733957 | 1733957 | 2021-09-19 | Colfax | New Mexico | 35007 | 1220 | 47 |
1730707 | 1730707 | 2021-09-18 | Colfax | New Mexico | 35007 | 1220 | 47 |
1727457 | 1727457 | 2021-09-17 | Colfax | New Mexico | 35007 | 1220 | 47 |
1724208 | 1724208 | 2021-09-16 | Colfax | New Mexico | 35007 | 1208 | 47 |
1720959 | 1720959 | 2021-09-15 | Colfax | New Mexico | 35007 | 1202 | 47 |
1717711 | 1717711 | 2021-09-14 | Colfax | New Mexico | 35007 | 1188 | 47 |
1714463 | 1714463 | 2021-09-13 | Colfax | New Mexico | 35007 | 1181 | 47 |
1711217 | 1711217 | 2021-09-12 | Colfax | New Mexico | 35007 | 1174 | 47 |
1707970 | 1707970 | 2021-09-11 | Colfax | New Mexico | 35007 | 1174 | 47 |
1704723 | 1704723 | 2021-09-10 | Colfax | New Mexico | 35007 | 1174 | 47 |
1701473 | 1701473 | 2021-09-09 | Colfax | New Mexico | 35007 | 1151 | 47 |
1698224 | 1698224 | 2021-09-08 | Colfax | New Mexico | 35007 | 1145 | 47 |
1694976 | 1694976 | 2021-09-07 | Colfax | New Mexico | 35007 | 1144 | 47 |
1691727 | 1691727 | 2021-09-06 | Colfax | New Mexico | 35007 | 1129 | 47 |
1688477 | 1688477 | 2021-09-05 | Colfax | New Mexico | 35007 | 1129 | 47 |
1685227 | 1685227 | 2021-09-04 | Colfax | New Mexico | 35007 | 1129 | 47 |
1681976 | 1681976 | 2021-09-03 | Colfax | New Mexico | 35007 | 1129 | 47 |
1678728 | 1678728 | 2021-09-02 | Colfax | New Mexico | 35007 | 1112 | 47 |
1675480 | 1675480 | 2021-09-01 | Colfax | New Mexico | 35007 | 1106 | 47 |
1672232 | 1672232 | 2021-08-31 | Colfax | New Mexico | 35007 | 1091 | 47 |
1668985 | 1668985 | 2021-08-30 | Colfax | New Mexico | 35007 | 1089 | 47 |
1665738 | 1665738 | 2021-08-29 | Colfax | New Mexico | 35007 | 1071 | 47 |
1662490 | 1662490 | 2021-08-28 | Colfax | New Mexico | 35007 | 1071 | 47 |
1659242 | 1659242 | 2021-08-27 | Colfax | New Mexico | 35007 | 1071 | 47 |
1655993 | 1655993 | 2021-08-26 | Colfax | New Mexico | 35007 | 1054 | 47 |
1652746 | 1652746 | 2021-08-25 | Colfax | New Mexico | 35007 | 1052 | 47 |
1649498 | 1649498 | 2021-08-24 | Colfax | New Mexico | 35007 | 1045 | 47 |
1646249 | 1646249 | 2021-08-23 | Colfax | New Mexico | 35007 | 1042 | 47 |
1643000 | 1643000 | 2021-08-22 | Colfax | New Mexico | 35007 | 1038 | 47 |
1639750 | 1639750 | 2021-08-21 | Colfax | New Mexico | 35007 | 1038 | 47 |
1636500 | 1636500 | 2021-08-20 | Colfax | New Mexico | 35007 | 1038 | 47 |
1633250 | 1633250 | 2021-08-19 | Colfax | New Mexico | 35007 | 1026 | 47 |
1630003 | 1630003 | 2021-08-18 | Colfax | New Mexico | 35007 | 1017 | 47 |
1626756 | 1626756 | 2021-08-17 | Colfax | New Mexico | 35007 | 1005 | 47 |
1623509 | 1623509 | 2021-08-16 | Colfax | New Mexico | 35007 | 997 | 47 |
1620262 | 1620262 | 2021-08-15 | Colfax | New Mexico | 35007 | 997 | 47 |
1617014 | 1617014 | 2021-08-14 | Colfax | New Mexico | 35007 | 997 | 47 |
1613766 | 1613766 | 2021-08-13 | Colfax | New Mexico | 35007 | 997 | 47 |
1610517 | 1610517 | 2021-08-12 | Colfax | New Mexico | 35007 | 990 | 47 |
1607269 | 1607269 | 2021-08-11 | Colfax | New Mexico | 35007 | 988 | 47 |
1604020 | 1604020 | 2021-08-10 | Colfax | New Mexico | 35007 | 981 | 47 |
1600771 | 1600771 | 2021-08-09 | Colfax | New Mexico | 35007 | 977 | 47 |
1597523 | 1597523 | 2021-08-08 | Colfax | New Mexico | 35007 | 974 | 47 |
1594274 | 1594274 | 2021-08-07 | Colfax | New Mexico | 35007 | 974 | 47 |
1591025 | 1591025 | 2021-08-06 | Colfax | New Mexico | 35007 | 974 | 47 |
1587776 | 1587776 | 2021-08-05 | Colfax | New Mexico | 35007 | 972 | 47 |
1584525 | 1584525 | 2021-08-04 | Colfax | New Mexico | 35007 | 972 | 47 |
1581276 | 1581276 | 2021-08-03 | Colfax | New Mexico | 35007 | 972 | 47 |
1578027 | 1578027 | 2021-08-02 | Colfax | New Mexico | 35007 | 972 | 47 |
1574779 | 1574779 | 2021-08-01 | Colfax | New Mexico | 35007 | 969 | 47 |
1571531 | 1571531 | 2021-07-31 | Colfax | New Mexico | 35007 | 969 | 47 |
1568283 | 1568283 | 2021-07-30 | Colfax | New Mexico | 35007 | 969 | 47 |
1565035 | 1565035 | 2021-07-29 | Colfax | New Mexico | 35007 | 969 | 47 |
1561787 | 1561787 | 2021-07-28 | Colfax | New Mexico | 35007 | 969 | 47 |
1558539 | 1558539 | 2021-07-27 | Colfax | New Mexico | 35007 | 964 | 47 |
1555292 | 1555292 | 2021-07-26 | Colfax | New Mexico | 35007 | 959 | 47 |
1552045 | 1552045 | 2021-07-25 | Colfax | New Mexico | 35007 | 958 | 47 |
1548798 | 1548798 | 2021-07-24 | Colfax | New Mexico | 35007 | 958 | 47 |
1545551 | 1545551 | 2021-07-23 | Colfax | New Mexico | 35007 | 958 | 47 |
1542303 | 1542303 | 2021-07-22 | Colfax | New Mexico | 35007 | 958 | 47 |
1539056 | 1539056 | 2021-07-21 | Colfax | New Mexico | 35007 | 958 | 47 |
1535809 | 1535809 | 2021-07-20 | Colfax | New Mexico | 35007 | 954 | 47 |
1532561 | 1532561 | 2021-07-19 | Colfax | New Mexico | 35007 | 954 | 47 |
1529314 | 1529314 | 2021-07-18 | Colfax | New Mexico | 35007 | 954 | 47 |
1526067 | 1526067 | 2021-07-17 | Colfax | New Mexico | 35007 | 954 | 47 |
1522820 | 1522820 | 2021-07-16 | Colfax | New Mexico | 35007 | 954 | 47 |
1519571 | 1519571 | 2021-07-15 | Colfax | New Mexico | 35007 | 951 | 47 |
1516324 | 1516324 | 2021-07-14 | Colfax | New Mexico | 35007 | 951 | 47 |
1513077 | 1513077 | 2021-07-13 | Colfax | New Mexico | 35007 | 951 | 47 |
1509830 | 1509830 | 2021-07-12 | Colfax | New Mexico | 35007 | 951 | 47 |
1506584 | 1506584 | 2021-07-11 | Colfax | New Mexico | 35007 | 951 | 47 |
1503338 | 1503338 | 2021-07-10 | Colfax | New Mexico | 35007 | 951 | 47 |
1500092 | 1500092 | 2021-07-09 | Colfax | New Mexico | 35007 | 951 | 47 |
1496846 | 1496846 | 2021-07-08 | Colfax | New Mexico | 35007 | 950 | 47 |
1493599 | 1493599 | 2021-07-07 | Colfax | New Mexico | 35007 | 950 | 47 |
1490352 | 1490352 | 2021-07-06 | Colfax | New Mexico | 35007 | 950 | 47 |
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);