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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, 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 |
---|---|---|---|---|---|---|---|
2497 | 2497 | 2020-03-15 | Hampden | Massachusetts | 25013 | 1 | 0 |
2946 | 2946 | 2020-03-16 | Hampden | Massachusetts | 25013 | 1 | 0 |
3447 | 3447 | 2020-03-17 | Hampden | Massachusetts | 25013 | 1 | 0 |
4030 | 4030 | 2020-03-18 | Hampden | Massachusetts | 25013 | 2 | 0 |
4734 | 4734 | 2020-03-19 | Hampden | Massachusetts | 25013 | 3 | 0 |
5553 | 5553 | 2020-03-20 | Hampden | Massachusetts | 25013 | 3 | 0 |
6512 | 6512 | 2020-03-21 | Hampden | Massachusetts | 25013 | 9 | 0 |
7589 | 7589 | 2020-03-22 | Hampden | Massachusetts | 25013 | 12 | 1 |
8761 | 8761 | 2020-03-23 | Hampden | Massachusetts | 25013 | 15 | 1 |
10050 | 10050 | 2020-03-24 | Hampden | Massachusetts | 25013 | 24 | 1 |
11462 | 11462 | 2020-03-25 | Hampden | Massachusetts | 25013 | 45 | 1 |
13043 | 13043 | 2020-03-26 | Hampden | Massachusetts | 25013 | 55 | 2 |
14751 | 14751 | 2020-03-27 | Hampden | Massachusetts | 25013 | 90 | 2 |
16571 | 16571 | 2020-03-28 | Hampden | Massachusetts | 25013 | 183 | 5 |
18486 | 18486 | 2020-03-29 | Hampden | Massachusetts | 25013 | 201 | 5 |
20502 | 20502 | 2020-03-30 | Hampden | Massachusetts | 25013 | 255 | 5 |
22611 | 22611 | 2020-03-31 | Hampden | Massachusetts | 25013 | 354 | 12 |
24790 | 24790 | 2020-04-01 | Hampden | Massachusetts | 25013 | 475 | 17 |
27042 | 27042 | 2020-04-02 | Hampden | Massachusetts | 25013 | 546 | 20 |
29360 | 29360 | 2020-04-03 | Hampden | Massachusetts | 25013 | 661 | 28 |
31738 | 31738 | 2020-04-04 | Hampden | Massachusetts | 25013 | 733 | 35 |
34163 | 34163 | 2020-04-05 | Hampden | Massachusetts | 25013 | 768 | 35 |
36622 | 36622 | 2020-04-06 | Hampden | Massachusetts | 25013 | 889 | 39 |
39130 | 39130 | 2020-04-07 | Hampden | Massachusetts | 25013 | 997 | 56 |
41682 | 41682 | 2020-04-08 | Hampden | Massachusetts | 25013 | 1081 | 64 |
44258 | 44258 | 2020-04-09 | Hampden | Massachusetts | 25013 | 1276 | 81 |
46866 | 46866 | 2020-04-10 | Hampden | Massachusetts | 25013 | 1394 | 88 |
49508 | 49508 | 2020-04-11 | Hampden | Massachusetts | 25013 | 1545 | 94 |
52178 | 52178 | 2020-04-12 | Hampden | Massachusetts | 25013 | 1647 | 104 |
54859 | 54859 | 2020-04-13 | Hampden | Massachusetts | 25013 | 1694 | 115 |
57557 | 57557 | 2020-04-14 | Hampden | Massachusetts | 25013 | 1798 | 134 |
60266 | 60266 | 2020-04-15 | Hampden | Massachusetts | 25013 | 1885 | 153 |
62987 | 62987 | 2020-04-16 | Hampden | Massachusetts | 25013 | 1985 | 163 |
65725 | 65725 | 2020-04-17 | Hampden | Massachusetts | 25013 | 2134 | 183 |
68475 | 68475 | 2020-04-18 | Hampden | Massachusetts | 25013 | 2254 | 202 |
71239 | 71239 | 2020-04-19 | Hampden | Massachusetts | 25013 | 2337 | 213 |
74011 | 74011 | 2020-04-20 | Hampden | Massachusetts | 25013 | 2438 | 224 |
76791 | 76791 | 2020-04-21 | Hampden | Massachusetts | 25013 | 2533 | 244 |
79577 | 79577 | 2020-04-22 | Hampden | Massachusetts | 25013 | 2678 | 271 |
82372 | 82372 | 2020-04-23 | Hampden | Massachusetts | 25013 | 2836 | 287 |
85176 | 85176 | 2020-04-24 | Hampden | Massachusetts | 25013 | 3060 | 299 |
87986 | 87986 | 2020-04-25 | Hampden | Massachusetts | 25013 | 3229 | 315 |
90802 | 90802 | 2020-04-26 | Hampden | Massachusetts | 25013 | 3295 | 327 |
93623 | 93623 | 2020-04-27 | Hampden | Massachusetts | 25013 | 3381 | 337 |
96458 | 96458 | 2020-04-28 | Hampden | Massachusetts | 25013 | 3546 | 346 |
99304 | 99304 | 2020-04-29 | Hampden | Massachusetts | 25013 | 3698 | 358 |
102156 | 102156 | 2020-04-30 | Hampden | Massachusetts | 25013 | 3777 | 373 |
105016 | 105016 | 2020-05-01 | Hampden | Massachusetts | 25013 | 3900 | 381 |
107880 | 107880 | 2020-05-02 | Hampden | Massachusetts | 25013 | 4003 | 387 |
110752 | 110752 | 2020-05-03 | Hampden | Massachusetts | 25013 | 4066 | 398 |
113630 | 113630 | 2020-05-04 | Hampden | Massachusetts | 25013 | 4114 | 408 |
116511 | 116511 | 2020-05-05 | Hampden | Massachusetts | 25013 | 4203 | 415 |
119472 | 119472 | 2020-05-06 | Hampden | Massachusetts | 25013 | 4321 | 425 |
122444 | 122444 | 2020-05-07 | Hampden | Massachusetts | 25013 | 4441 | 434 |
125426 | 125426 | 2020-05-08 | Hampden | Massachusetts | 25013 | 4522 | 441 |
128413 | 128413 | 2020-05-09 | Hampden | Massachusetts | 25013 | 4647 | 445 |
131403 | 131403 | 2020-05-10 | Hampden | Massachusetts | 25013 | 4714 | 449 |
134394 | 134394 | 2020-05-11 | Hampden | Massachusetts | 25013 | 4763 | 458 |
137384 | 137384 | 2020-05-12 | Hampden | Massachusetts | 25013 | 4831 | 464 |
140378 | 140378 | 2020-05-13 | Hampden | Massachusetts | 25013 | 4889 | 475 |
143373 | 143373 | 2020-05-14 | Hampden | Massachusetts | 25013 | 4974 | 487 |
146373 | 146373 | 2020-05-15 | Hampden | Massachusetts | 25013 | 5038 | 494 |
149378 | 149378 | 2020-05-16 | Hampden | Massachusetts | 25013 | 5133 | 506 |
152389 | 152389 | 2020-05-17 | Hampden | Massachusetts | 25013 | 5205 | 516 |
155403 | 155403 | 2020-05-18 | Hampden | Massachusetts | 25013 | 5264 | 517 |
158421 | 158421 | 2020-05-19 | Hampden | Massachusetts | 25013 | 5335 | 521 |
161447 | 161447 | 2020-05-20 | Hampden | Massachusetts | 25013 | 5418 | 526 |
164476 | 164476 | 2020-05-21 | Hampden | Massachusetts | 25013 | 5492 | 533 |
167512 | 167512 | 2020-05-22 | Hampden | Massachusetts | 25013 | 5568 | 537 |
170549 | 170549 | 2020-05-23 | Hampden | Massachusetts | 25013 | 5621 | 541 |
173591 | 173591 | 2020-05-24 | Hampden | Massachusetts | 25013 | 5687 | 542 |
176634 | 176634 | 2020-05-25 | Hampden | Massachusetts | 25013 | 5755 | 543 |
179678 | 179678 | 2020-05-26 | Hampden | Massachusetts | 25013 | 5796 | 546 |
182724 | 182724 | 2020-05-27 | Hampden | Massachusetts | 25013 | 5845 | 554 |
185779 | 185779 | 2020-05-28 | Hampden | Massachusetts | 25013 | 5878 | 562 |
188837 | 188837 | 2020-05-29 | Hampden | Massachusetts | 25013 | 5942 | 569 |
191901 | 191901 | 2020-05-30 | Hampden | Massachusetts | 25013 | 5982 | 572 |
194969 | 194969 | 2020-05-31 | Hampden | Massachusetts | 25013 | 6035 | 580 |
198040 | 198040 | 2020-06-01 | Hampden | Massachusetts | 25013 | 6188 | 601 |
201112 | 201112 | 2020-06-02 | Hampden | Massachusetts | 25013 | 6201 | 603 |
204189 | 204189 | 2020-06-03 | Hampden | Massachusetts | 25013 | 6237 | 608 |
207270 | 207270 | 2020-06-04 | Hampden | Massachusetts | 25013 | 6268 | 609 |
210351 | 210351 | 2020-06-05 | Hampden | Massachusetts | 25013 | 6297 | 610 |
213435 | 213435 | 2020-06-06 | Hampden | Massachusetts | 25013 | 6337 | 618 |
216523 | 216523 | 2020-06-07 | Hampden | Massachusetts | 25013 | 6353 | 620 |
219615 | 219615 | 2020-06-08 | Hampden | Massachusetts | 25013 | 6365 | 622 |
222710 | 222710 | 2020-06-09 | Hampden | Massachusetts | 25013 | 6380 | 625 |
225806 | 225806 | 2020-06-10 | Hampden | Massachusetts | 25013 | 6395 | 629 |
228908 | 228908 | 2020-06-11 | Hampden | Massachusetts | 25013 | 6415 | 633 |
232012 | 232012 | 2020-06-12 | Hampden | Massachusetts | 25013 | 6431 | 632 |
235117 | 235117 | 2020-06-13 | Hampden | Massachusetts | 25013 | 6460 | 637 |
238224 | 238224 | 2020-06-14 | Hampden | Massachusetts | 25013 | 6481 | 640 |
241333 | 241333 | 2020-06-15 | Hampden | Massachusetts | 25013 | 6489 | 640 |
244444 | 244444 | 2020-06-16 | Hampden | Massachusetts | 25013 | 6503 | 642 |
247557 | 247557 | 2020-06-17 | Hampden | Massachusetts | 25013 | 6518 | 645 |
250669 | 250669 | 2020-06-18 | Hampden | Massachusetts | 25013 | 6537 | 646 |
253784 | 253784 | 2020-06-19 | Hampden | Massachusetts | 25013 | 6556 | 647 |
256904 | 256904 | 2020-06-20 | Hampden | Massachusetts | 25013 | 6584 | 648 |
260030 | 260030 | 2020-06-21 | Hampden | Massachusetts | 25013 | 6598 | 648 |
263159 | 263159 | 2020-06-22 | Hampden | Massachusetts | 25013 | 6610 | 647 |
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);