ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Adams" and fips = 53001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1793681 | 1793681 | 2021-10-07 | Adams | Washington | 53001 | 3096 | 28 |
1790432 | 1790432 | 2021-10-06 | Adams | Washington | 53001 | 3086 | 27 |
1787184 | 1787184 | 2021-10-05 | Adams | Washington | 53001 | 3079 | 27 |
1783935 | 1783935 | 2021-10-04 | Adams | Washington | 53001 | 3073 | 27 |
1780686 | 1780686 | 2021-10-03 | Adams | Washington | 53001 | 3043 | 27 |
1777436 | 1777436 | 2021-10-02 | Adams | Washington | 53001 | 3043 | 27 |
1774186 | 1774186 | 2021-10-01 | Adams | Washington | 53001 | 3043 | 27 |
1770936 | 1770936 | 2021-09-30 | Adams | Washington | 53001 | 3023 | 27 |
1767687 | 1767687 | 2021-09-29 | Adams | Washington | 53001 | 3003 | 27 |
1764438 | 1764438 | 2021-09-28 | Adams | Washington | 53001 | 3001 | 27 |
1761189 | 1761189 | 2021-09-27 | Adams | Washington | 53001 | 2994 | 26 |
1757941 | 1757941 | 2021-09-26 | Adams | Washington | 53001 | 2958 | 26 |
1754693 | 1754693 | 2021-09-25 | Adams | Washington | 53001 | 2958 | 26 |
1751445 | 1751445 | 2021-09-24 | Adams | Washington | 53001 | 2958 | 26 |
1748196 | 1748196 | 2021-09-23 | Adams | Washington | 53001 | 2940 | 26 |
1744946 | 1744946 | 2021-09-22 | Adams | Washington | 53001 | 2918 | 26 |
1741697 | 1741697 | 2021-09-21 | Adams | Washington | 53001 | 2907 | 25 |
1738448 | 1738448 | 2021-09-20 | Adams | Washington | 53001 | 2897 | 25 |
1735199 | 1735199 | 2021-09-19 | Adams | Washington | 53001 | 2849 | 25 |
1731949 | 1731949 | 2021-09-18 | Adams | Washington | 53001 | 2849 | 25 |
1728699 | 1728699 | 2021-09-17 | Adams | Washington | 53001 | 2849 | 25 |
1725449 | 1725449 | 2021-09-16 | Adams | Washington | 53001 | 2820 | 25 |
1722200 | 1722200 | 2021-09-15 | Adams | Washington | 53001 | 2796 | 25 |
1718952 | 1718952 | 2021-09-14 | Adams | Washington | 53001 | 2777 | 25 |
1715704 | 1715704 | 2021-09-13 | Adams | Washington | 53001 | 2770 | 25 |
1712458 | 1712458 | 2021-09-12 | Adams | Washington | 53001 | 2713 | 25 |
1709211 | 1709211 | 2021-09-11 | Adams | Washington | 53001 | 2713 | 25 |
1705964 | 1705964 | 2021-09-10 | Adams | Washington | 53001 | 2713 | 25 |
1702714 | 1702714 | 2021-09-09 | Adams | Washington | 53001 | 2705 | 25 |
1699465 | 1699465 | 2021-09-08 | Adams | Washington | 53001 | 2687 | 25 |
1696217 | 1696217 | 2021-09-07 | Adams | Washington | 53001 | 2684 | 25 |
1692969 | 1692969 | 2021-09-06 | Adams | Washington | 53001 | 2630 | 25 |
1689720 | 1689720 | 2021-09-05 | Adams | Washington | 53001 | 2630 | 25 |
1686470 | 1686470 | 2021-09-04 | Adams | Washington | 53001 | 2630 | 25 |
1683219 | 1683219 | 2021-09-03 | Adams | Washington | 53001 | 2630 | 25 |
1679969 | 1679969 | 2021-09-02 | Adams | Washington | 53001 | 2604 | 25 |
1676721 | 1676721 | 2021-09-01 | Adams | Washington | 53001 | 2587 | 25 |
1673474 | 1673474 | 2021-08-31 | Adams | Washington | 53001 | 2577 | 25 |
1670226 | 1670226 | 2021-08-30 | Adams | Washington | 53001 | 2573 | 25 |
1666979 | 1666979 | 2021-08-29 | Adams | Washington | 53001 | 2532 | 25 |
1663731 | 1663731 | 2021-08-28 | Adams | Washington | 53001 | 2532 | 25 |
1660483 | 1660483 | 2021-08-27 | Adams | Washington | 53001 | 2532 | 25 |
1657235 | 1657235 | 2021-08-26 | Adams | Washington | 53001 | 2512 | 25 |
1653987 | 1653987 | 2021-08-25 | Adams | Washington | 53001 | 2501 | 25 |
1650741 | 1650741 | 2021-08-24 | Adams | Washington | 53001 | 2500 | 25 |
1647492 | 1647492 | 2021-08-23 | Adams | Washington | 53001 | 2493 | 25 |
1644243 | 1644243 | 2021-08-22 | Adams | Washington | 53001 | 2461 | 25 |
1640993 | 1640993 | 2021-08-21 | Adams | Washington | 53001 | 2461 | 25 |
1637743 | 1637743 | 2021-08-20 | Adams | Washington | 53001 | 2461 | 25 |
1634493 | 1634493 | 2021-08-19 | Adams | Washington | 53001 | 2443 | 25 |
1631245 | 1631245 | 2021-08-18 | Adams | Washington | 53001 | 2425 | 25 |
1627998 | 1627998 | 2021-08-17 | Adams | Washington | 53001 | 2409 | 25 |
1624751 | 1624751 | 2021-08-16 | Adams | Washington | 53001 | 2400 | 25 |
1621504 | 1621504 | 2021-08-15 | Adams | Washington | 53001 | 2376 | 25 |
1618256 | 1618256 | 2021-08-14 | Adams | Washington | 53001 | 2376 | 25 |
1615008 | 1615008 | 2021-08-13 | Adams | Washington | 53001 | 2376 | 25 |
1611759 | 1611759 | 2021-08-12 | Adams | Washington | 53001 | 2364 | 24 |
1608512 | 1608512 | 2021-08-11 | Adams | Washington | 53001 | 2350 | 24 |
1605263 | 1605263 | 2021-08-10 | Adams | Washington | 53001 | 2346 | 24 |
1602013 | 1602013 | 2021-08-09 | Adams | Washington | 53001 | 2344 | 24 |
1598765 | 1598765 | 2021-08-08 | Adams | Washington | 53001 | 2334 | 24 |
1595516 | 1595516 | 2021-08-07 | Adams | Washington | 53001 | 2334 | 24 |
1592267 | 1592267 | 2021-08-06 | Adams | Washington | 53001 | 2334 | 24 |
1589018 | 1589018 | 2021-08-05 | Adams | Washington | 53001 | 2328 | 24 |
1585769 | 1585769 | 2021-08-04 | Adams | Washington | 53001 | 2320 | 24 |
1582519 | 1582519 | 2021-08-03 | Adams | Washington | 53001 | 2312 | 24 |
1579269 | 1579269 | 2021-08-02 | Adams | Washington | 53001 | 2300 | 24 |
1576021 | 1576021 | 2021-08-01 | Adams | Washington | 53001 | 2295 | 24 |
1572773 | 1572773 | 2021-07-31 | Adams | Washington | 53001 | 2295 | 24 |
1569525 | 1569525 | 2021-07-30 | Adams | Washington | 53001 | 2295 | 24 |
1566277 | 1566277 | 2021-07-29 | Adams | Washington | 53001 | 2294 | 24 |
1563029 | 1563029 | 2021-07-28 | Adams | Washington | 53001 | 2293 | 24 |
1559781 | 1559781 | 2021-07-27 | Adams | Washington | 53001 | 2292 | 24 |
1556534 | 1556534 | 2021-07-26 | Adams | Washington | 53001 | 2289 | 24 |
1553287 | 1553287 | 2021-07-25 | Adams | Washington | 53001 | 2280 | 24 |
1550040 | 1550040 | 2021-07-24 | Adams | Washington | 53001 | 2280 | 24 |
1546793 | 1546793 | 2021-07-23 | Adams | Washington | 53001 | 2280 | 24 |
1543546 | 1543546 | 2021-07-22 | Adams | Washington | 53001 | 2282 | 24 |
1540298 | 1540298 | 2021-07-21 | Adams | Washington | 53001 | 2279 | 24 |
1537051 | 1537051 | 2021-07-20 | Adams | Washington | 53001 | 2279 | 24 |
1533803 | 1533803 | 2021-07-19 | Adams | Washington | 53001 | 2279 | 24 |
1530556 | 1530556 | 2021-07-18 | Adams | Washington | 53001 | 2279 | 24 |
1527309 | 1527309 | 2021-07-17 | Adams | Washington | 53001 | 2279 | 24 |
1524062 | 1524062 | 2021-07-16 | Adams | Washington | 53001 | 2279 | 24 |
1520814 | 1520814 | 2021-07-15 | Adams | Washington | 53001 | 2280 | 24 |
1517566 | 1517566 | 2021-07-14 | Adams | Washington | 53001 | 2279 | 24 |
1514319 | 1514319 | 2021-07-13 | Adams | Washington | 53001 | 2278 | 24 |
1511073 | 1511073 | 2021-07-12 | Adams | Washington | 53001 | 2276 | 24 |
1507826 | 1507826 | 2021-07-11 | Adams | Washington | 53001 | 2273 | 24 |
1504580 | 1504580 | 2021-07-10 | Adams | Washington | 53001 | 2273 | 24 |
1501334 | 1501334 | 2021-07-09 | Adams | Washington | 53001 | 2273 | 24 |
1498088 | 1498088 | 2021-07-08 | Adams | Washington | 53001 | 2272 | 24 |
1494841 | 1494841 | 2021-07-07 | Adams | Washington | 53001 | 2271 | 24 |
1491594 | 1491594 | 2021-07-06 | Adams | Washington | 53001 | 2271 | 24 |
1488347 | 1488347 | 2021-07-05 | Adams | Washington | 53001 | 2270 | 24 |
1485100 | 1485100 | 2021-07-04 | Adams | Washington | 53001 | 2270 | 24 |
1481854 | 1481854 | 2021-07-03 | Adams | Washington | 53001 | 2270 | 24 |
1478607 | 1478607 | 2021-07-02 | Adams | Washington | 53001 | 2270 | 24 |
1475361 | 1475361 | 2021-07-01 | Adams | Washington | 53001 | 2267 | 24 |
1472115 | 1472115 | 2021-06-30 | Adams | Washington | 53001 | 2262 | 24 |
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);