ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 25013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 524 ✖
- 1537 13
- 1539 11
- 1542 9
- 1781 9
- 709 8
- 1535 8
- 1538 8
- 0 7
- 1564 6
- 1802 6
- 746 5
- 767 5
- 792 5
- 1549 5
- 1765 5
- 1786 5
- 1 4
- 681 4
- 759 4
- 1526 4
- 1551 4
- 1593 4
- 1624 4
- 1636 4
- 1643 4
- 1720 4
- 1774 4
- 1793 4
- 1821 4
- 2022 4
- 5 3
- 672 3
- 678 3
- 699 3
- 791 3
- 1487 3
- 1496 3
- 1497 3
- 1498 3
- 1536 3
- 1543 3
- 1553 3
- 1555 3
- 1573 3
- 1609 3
- 1655 3
- 1664 3
- 1672 3
- 1681 3
- 1691 3
- 1698 3
- 1704 3
- 1730 3
- 1742 3
- 1757 3
- 1769 3
- 1771 3
- 1779 3
- 1789 3
- 1861 3
- 1914 3
- 1955 3
- 1992 3
- 2045 3
- 2063 3
- 2077 3
- 2 2
- 35 2
- 640 2
- 647 2
- 648 2
- 654 2
- 659 2
- 664 2
- 679 2
- 680 2
- 682 2
- 692 2
- 707 2
- 732 2
- 734 2
- 768 2
- 772 2
- 773 2
- 774 2
- 789 2
- 794 2
- 798 2
- 799 2
- 812 2
- 816 2
- 842 2
- 892 2
- 1024 2
- 1046 2
- 1175 2
- 1207 2
- 1332 2
- 1372 2
- 1446 2
- 1455 2
- 1467 2
- 1485 2
- 1500 2
- 1504 2
- 1507 2
- 1514 2
- 1515 2
- 1530 2
- 1532 2
- 1534 2
- 1548 2
- 1563 2
- 1678 2
- 1690 2
- 1696 2
- 1767 2
- 1768 2
- 1777 2
- 12 1
- 17 1
- 20 1
- 28 1
- 39 1
- 56 1
- 64 1
- 81 1
- 88 1
- 94 1
- 104 1
- 115 1
- 134 1
- 153 1
- 163 1
- 183 1
- 202 1
- 213 1
- 224 1
- 244 1
- 271 1
- 287 1
- 299 1
- 315 1
- 327 1
- 337 1
- 346 1
- 358 1
- 373 1
- 381 1
- 387 1
- 398 1
- 408 1
- 415 1
- 425 1
- 434 1
- 441 1
- 445 1
- 449 1
- 458 1
- 464 1
- 475 1
- 487 1
- 494 1
- 506 1
- 516 1
- 517 1
- 521 1
- 526 1
- 533 1
- 537 1
- 541 1
- 542 1
- 543 1
- 546 1
- 554 1
- 562 1
- 569 1
- 572 1
- 580 1
- 601 1
- 603 1
- 608 1
- 609 1
- 610 1
- 618 1
- 620 1
- 622 1
- 625 1
- 629 1
- 632 1
- 633 1
- 637 1
- 642 1
- 645 1
- 646 1
- 649 1
- 655 1
- 657 1
- 661 1
- 662 1
- 663 1
- 666 1
- 670 1
- 671 1
- 674 1
- 683 1
- 687 1
- 688 1
- 689 1
- 696 1
- 697 1
- 698 1
- 700 1
- 703 1
- 704 1
- 729 1
- 737 1
- 739 1
- 744 1
- 747 1
- 751 1
- 754 1
- 755 1
- 756 1
- 762 1
- 769 1
- 771 1
- 775 1
- 776 1
- 778 1
- 779 1
- 781 1
- 786 1
- 787 1
- 790 1
- 796 1
- 800 1
- 804 1
- 807 1
- 809 1
- 811 1
- 815 1
- 817 1
- 821 1
- 822 1
- 824 1
- 825 1
- 830 1
- 834 1
- 836 1
- 838 1
- 839 1
- 844 1
- 845 1
- 849 1
- 855 1
- 856 1
- 859 1
- 866 1
- 873 1
- 876 1
- 880 1
- 883 1
- 884 1
- 885 1
- 897 1
- 907 1
- 910 1
- 911 1
- 913 1
- 917 1
- 920 1
- 922 1
- 926 1
- 931 1
- 935 1
- 939 1
- 951 1
- 957 1
- 961 1
- 962 1
- 963 1
- 967 1
- 974 1
- 979 1
- 986 1
- 991 1
- 994 1
- 1003 1
- 1005 1
- 1007 1
- 1017 1
- 1028 1
- 1033 1
- 1035 1
- 1037 1
- 1044 1
- 1055 1
- 1063 1
- 1066 1
- 1068 1
- 1078 1
- 1085 1
- 1088 1
- 1093 1
- 1101 1
- 1105 1
- 1108 1
- 1114 1
- 1118 1
- 1124 1
- 1127 1
- 1134 1
- 1135 1
- 1138 1
- 1144 1
- 1152 1
- 1163 1
- 1169 1
- 1178 1
- 1186 1
- 1189 1
- 1192 1
- 1200 1
- 1204 1
- 1210 1
- 1215 1
- 1221 1
- 1227 1
- 1232 1
- 1238 1
- 1244 1
- 1253 1
- 1259 1
- 1266 1
- 1269 1
- 1274 1
- 1278 1
- 1282 1
- 1286 1
- 1292 1
- 1298 1
- 1301 1
- 1305 1
- 1308 1
- 1311 1
- 1316 1
- 1320 1
- 1322 1
- 1328 1
- 1340 1
- 1347 1
- 1351 1
- 1357 1
- 1365 1
- 1371 1
- 1379 1
- 1386 1
- 1388 1
- 1393 1
- 1395 1
- 1396 1
- 1397 1
- 1405 1
- 1407 1
- 1412 1
- 1414 1
- 1417 1
- 1419 1
- 1422 1
- 1427 1
- 1433 1
- 1434 1
- 1436 1
- 1440 1
- 1441 1
- 1443 1
- 1453 1
- 1458 1
- 1459 1
- 1461 1
- 1465 1
- 1468 1
- 1469 1
- 1471 1
- 1472 1
- 1474 1
- 1476 1
- 1479 1
- 1480 1
- 1481 1
- 1482 1
- 1483 1
- 1484 1
- 1489 1
- 1490 1
- 1495 1
- 1506 1
- 1508 1
- 1510 1
- 1511 1
- 1513 1
- 1516 1
- 1517 1
- 1520 1
- 1521 1
- 1524 1
- 1525 1
- 1528 1
- 1529 1
- 1531 1
- 1540 1
- 1541 1
- 1544 1
- 1547 1
- 1550 1
- 1552 1
- 1560 1
- 1562 1
- 1566 1
- 1576 1
- 1584 1
- 1585 1
- 1589 1
- 1598 1
- 1601 1
- 1606 1
- 1611 1
- 1615 1
- 1617 1
- 1621 1
- 1628 1
- 1632 1
- 1634 1
- 1637 1
- 1638 1
- 1640 1
- 1648 1
- 1649 1
- 1652 1
- 1658 1
- 1659 1
- 1660 1
- 1661 1
- 1665 1
- 1666 1
- 1668 1
- 1670 1
- 1673 1
- 1677 1
- 1684 1
- 1687 1
- 1693 1
- 1695 1
- 1699 1
- 1700 1
- 1702 1
- 1703 1
- 1706 1
- 1710 1
- 1712 1
- 1714 1
- 1723 1
- 1725 1
- 1727 1
- 1731 1
- 1736 1
- 1738 1
- 1739 1
- 1744 1
- 1748 1
- 1750 1
- 1752 1
- 1760 1
- 1761 1
- 1762 1
- 1766 1
- 1773 1
- 1775 1
- 1778 1
- 1780 1
- 1787 1
- 1788 1
- 1790 1
- 1794 1
- 1795 1
- 1798 1
- 1799 1
- 1800 1
- 1801 1
- 1803 1
- 1804 1
- 1809 1
- 1814 1
- 1824 1
- 1848 1
- 1855 1
- 1870 1
- 1882 1
- 1893 1
- 1905 1
- 1923 1
- 1931 1
- 1943 1
- 1951 1
- 1958 1
- 1969 1
- 1977 1
- 1984 1
- 2000 1
- 2010 1
- 2017 1
- 2019 1
- 2024 1
- 2035 1
- 2041 1
- 2048 1
- 2055 1
- 2058 1
- 2061 1
- 2067 1
- 2070 1
- 2074 1
- 2076 1
state 1
- Massachusetts 790
fips 1
- 25013 · 790 ✖
county 1
- Hampden 790
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500812 | 2500812 | 2022-05-13 | Hampden | Massachusetts | 25013 | 139047 | 1804 |
2497554 | 2497554 | 2022-05-12 | Hampden | Massachusetts | 25013 | 138649 | 1803 |
2494296 | 2494296 | 2022-05-11 | Hampden | Massachusetts | 25013 | 138220 | 1802 |
2491038 | 2491038 | 2022-05-10 | Hampden | Massachusetts | 25013 | 137917 | 1802 |
2487781 | 2487781 | 2022-05-09 | Hampden | Massachusetts | 25013 | 137700 | 1801 |
2484523 | 2484523 | 2022-05-08 | Hampden | Massachusetts | 25013 | 137100 | 1802 |
2481265 | 2481265 | 2022-05-07 | Hampden | Massachusetts | 25013 | 137100 | 1802 |
2478007 | 2478007 | 2022-05-06 | Hampden | Massachusetts | 25013 | 137100 | 1802 |
2474749 | 2474749 | 2022-05-05 | Hampden | Massachusetts | 25013 | 136856 | 1800 |
2471492 | 2471492 | 2022-05-04 | Hampden | Massachusetts | 25013 | 136569 | 1799 |
2468236 | 2468236 | 2022-05-03 | Hampden | Massachusetts | 25013 | 136372 | 1798 |
2464981 | 2464981 | 2022-05-02 | Hampden | Massachusetts | 25013 | 136214 | 1795 |
2461725 | 2461725 | 2022-05-01 | Hampden | Massachusetts | 25013 | 135721 | 1793 |
2458469 | 2458469 | 2022-04-30 | Hampden | Massachusetts | 25013 | 135721 | 1793 |
2455213 | 2455213 | 2022-04-29 | Hampden | Massachusetts | 25013 | 135721 | 1793 |
2451957 | 2451957 | 2022-04-28 | Hampden | Massachusetts | 25013 | 135522 | 1793 |
2448701 | 2448701 | 2022-04-27 | Hampden | Massachusetts | 25013 | 135326 | 1790 |
2445445 | 2445445 | 2022-04-26 | Hampden | Massachusetts | 25013 | 135131 | 1788 |
2442189 | 2442189 | 2022-04-25 | Hampden | Massachusetts | 25013 | 135002 | 1787 |
2438933 | 2438933 | 2022-04-24 | Hampden | Massachusetts | 25013 | 134648 | 1786 |
2435677 | 2435677 | 2022-04-23 | Hampden | Massachusetts | 25013 | 134648 | 1786 |
2432421 | 2432421 | 2022-04-22 | Hampden | Massachusetts | 25013 | 134648 | 1786 |
2429165 | 2429165 | 2022-04-21 | Hampden | Massachusetts | 25013 | 134504 | 1786 |
2425909 | 2425909 | 2022-04-20 | Hampden | Massachusetts | 25013 | 134351 | 1786 |
2422653 | 2422653 | 2022-04-19 | Hampden | Massachusetts | 25013 | 134176 | 1781 |
2419397 | 2419397 | 2022-04-18 | Hampden | Massachusetts | 25013 | 133782 | 1781 |
2416141 | 2416141 | 2022-04-17 | Hampden | Massachusetts | 25013 | 133782 | 1781 |
2412885 | 2412885 | 2022-04-16 | Hampden | Massachusetts | 25013 | 133782 | 1781 |
2409629 | 2409629 | 2022-04-15 | Hampden | Massachusetts | 25013 | 133782 | 1781 |
2406373 | 2406373 | 2022-04-14 | Hampden | Massachusetts | 25013 | 133658 | 1781 |
2403117 | 2403117 | 2022-04-13 | Hampden | Massachusetts | 25013 | 133548 | 1781 |
2399863 | 2399863 | 2022-04-12 | Hampden | Massachusetts | 25013 | 133434 | 1781 |
2396607 | 2396607 | 2022-04-11 | Hampden | Massachusetts | 25013 | 133346 | 1780 |
2393352 | 2393352 | 2022-04-10 | Hampden | Massachusetts | 25013 | 133079 | 1779 |
2390096 | 2390096 | 2022-04-09 | Hampden | Massachusetts | 25013 | 133079 | 1779 |
2386840 | 2386840 | 2022-04-08 | Hampden | Massachusetts | 25013 | 133079 | 1779 |
2383585 | 2383585 | 2022-04-07 | Hampden | Massachusetts | 25013 | 132988 | 1778 |
2380330 | 2380330 | 2022-04-06 | Hampden | Massachusetts | 25013 | 132913 | 1777 |
2377075 | 2377075 | 2022-04-05 | Hampden | Massachusetts | 25013 | 132856 | 1777 |
2373823 | 2373823 | 2022-04-04 | Hampden | Massachusetts | 25013 | 132813 | 1775 |
2370570 | 2370570 | 2022-04-03 | Hampden | Massachusetts | 25013 | 132669 | 1774 |
2367317 | 2367317 | 2022-04-02 | Hampden | Massachusetts | 25013 | 132669 | 1774 |
2364064 | 2364064 | 2022-04-01 | Hampden | Massachusetts | 25013 | 132669 | 1774 |
2360810 | 2360810 | 2022-03-31 | Hampden | Massachusetts | 25013 | 132602 | 1773 |
2357556 | 2357556 | 2022-03-30 | Hampden | Massachusetts | 25013 | 132500 | 1771 |
2354303 | 2354303 | 2022-03-29 | Hampden | Massachusetts | 25013 | 132447 | 1771 |
2351051 | 2351051 | 2022-03-28 | Hampden | Massachusetts | 25013 | 132422 | 1771 |
2347798 | 2347798 | 2022-03-27 | Hampden | Massachusetts | 25013 | 132288 | 1769 |
2344545 | 2344545 | 2022-03-26 | Hampden | Massachusetts | 25013 | 132288 | 1769 |
2341292 | 2341292 | 2022-03-25 | Hampden | Massachusetts | 25013 | 132288 | 1769 |
2338039 | 2338039 | 2022-03-24 | Hampden | Massachusetts | 25013 | 132234 | 1768 |
2334785 | 2334785 | 2022-03-23 | Hampden | Massachusetts | 25013 | 132173 | 1768 |
2331531 | 2331531 | 2022-03-22 | Hampden | Massachusetts | 25013 | 132111 | 1767 |
2328279 | 2328279 | 2022-03-21 | Hampden | Massachusetts | 25013 | 132079 | 1766 |
2325026 | 2325026 | 2022-03-20 | Hampden | Massachusetts | 25013 | 131985 | 1765 |
2321772 | 2321772 | 2022-03-19 | Hampden | Massachusetts | 25013 | 131985 | 1765 |
2318518 | 2318518 | 2022-03-18 | Hampden | Massachusetts | 25013 | 131985 | 1765 |
2315265 | 2315265 | 2022-03-17 | Hampden | Massachusetts | 25013 | 131934 | 1765 |
2312012 | 2312012 | 2022-03-16 | Hampden | Massachusetts | 25013 | 131874 | 1765 |
2308759 | 2308759 | 2022-03-15 | Hampden | Massachusetts | 25013 | 131842 | 1762 |
2305508 | 2305508 | 2022-03-14 | Hampden | Massachusetts | 25013 | 131827 | 1760 |
2302256 | 2302256 | 2022-03-13 | Hampden | Massachusetts | 25013 | 131741 | 2077 |
2299004 | 2299004 | 2022-03-12 | Hampden | Massachusetts | 25013 | 131741 | 2077 |
2295752 | 2295752 | 2022-03-11 | Hampden | Massachusetts | 25013 | 131741 | 2077 |
2292500 | 2292500 | 2022-03-10 | Hampden | Massachusetts | 25013 | 131696 | 2076 |
2289248 | 2289248 | 2022-03-09 | Hampden | Massachusetts | 25013 | 131638 | 2074 |
2285997 | 2285997 | 2022-03-08 | Hampden | Massachusetts | 25013 | 131589 | 2070 |
2282745 | 2282745 | 2022-03-07 | Hampden | Massachusetts | 25013 | 131556 | 2067 |
2279492 | 2279492 | 2022-03-06 | Hampden | Massachusetts | 25013 | 131443 | 2063 |
2276239 | 2276239 | 2022-03-05 | Hampden | Massachusetts | 25013 | 131443 | 2063 |
2272986 | 2272986 | 2022-03-04 | Hampden | Massachusetts | 25013 | 131443 | 2063 |
2269734 | 2269734 | 2022-03-03 | Hampden | Massachusetts | 25013 | 131384 | 2061 |
2266481 | 2266481 | 2022-03-02 | Hampden | Massachusetts | 25013 | 131322 | 2058 |
2263230 | 2263230 | 2022-03-01 | Hampden | Massachusetts | 25013 | 131253 | 2055 |
2259979 | 2259979 | 2022-02-28 | Hampden | Massachusetts | 25013 | 131183 | 2048 |
2256728 | 2256728 | 2022-02-27 | Hampden | Massachusetts | 25013 | 131064 | 2045 |
2253477 | 2253477 | 2022-02-26 | Hampden | Massachusetts | 25013 | 131064 | 2045 |
2250226 | 2250226 | 2022-02-25 | Hampden | Massachusetts | 25013 | 131064 | 2045 |
2246975 | 2246975 | 2022-02-24 | Hampden | Massachusetts | 25013 | 130982 | 2041 |
2243724 | 2243724 | 2022-02-23 | Hampden | Massachusetts | 25013 | 130814 | 2035 |
2240473 | 2240473 | 2022-02-22 | Hampden | Massachusetts | 25013 | 130777 | 2024 |
2237222 | 2237222 | 2022-02-21 | Hampden | Massachusetts | 25013 | 130428 | 2022 |
2233971 | 2233971 | 2022-02-20 | Hampden | Massachusetts | 25013 | 130428 | 2022 |
2230720 | 2230720 | 2022-02-19 | Hampden | Massachusetts | 25013 | 130428 | 2022 |
2227469 | 2227469 | 2022-02-18 | Hampden | Massachusetts | 25013 | 130428 | 2022 |
2224218 | 2224218 | 2022-02-17 | Hampden | Massachusetts | 25013 | 130277 | 2019 |
2220967 | 2220967 | 2022-02-16 | Hampden | Massachusetts | 25013 | 130081 | 2017 |
2217716 | 2217716 | 2022-02-15 | Hampden | Massachusetts | 25013 | 129982 | 2010 |
2214465 | 2214465 | 2022-02-14 | Hampden | Massachusetts | 25013 | 129824 | 2000 |
2211213 | 2211213 | 2022-02-13 | Hampden | Massachusetts | 25013 | 129485 | 1992 |
2207960 | 2207960 | 2022-02-12 | Hampden | Massachusetts | 25013 | 129485 | 1992 |
2204707 | 2204707 | 2022-02-11 | Hampden | Massachusetts | 25013 | 129485 | 1992 |
2201454 | 2201454 | 2022-02-10 | Hampden | Massachusetts | 25013 | 129245 | 1984 |
2198200 | 2198200 | 2022-02-09 | Hampden | Massachusetts | 25013 | 129009 | 1977 |
2194946 | 2194946 | 2022-02-08 | Hampden | Massachusetts | 25013 | 128779 | 1969 |
2191692 | 2191692 | 2022-02-07 | Hampden | Massachusetts | 25013 | 128561 | 1958 |
2188439 | 2188439 | 2022-02-06 | Hampden | Massachusetts | 25013 | 127853 | 1955 |
2185186 | 2185186 | 2022-02-05 | Hampden | Massachusetts | 25013 | 127853 | 1955 |
2181934 | 2181934 | 2022-02-04 | Hampden | Massachusetts | 25013 | 127853 | 1955 |
2178682 | 2178682 | 2022-02-03 | Hampden | Massachusetts | 25013 | 127425 | 1951 |
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);