ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
833 rows where fips = 25025 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 502 ✖
- 0 48
- 1985 9
- 1076 8
- 1847 8
- 1851 8
- 1858 8
- 1845 7
- 1142 6
- 1820 6
- 1838 6
- 1853 6
- 1867 6
- 1873 6
- 1989 6
- 1834 5
- 1842 5
- 1849 5
- 1852 5
- 1961 5
- 1979 5
- 2000 5
- 2001 5
- 1008 4
- 1131 4
- 1811 4
- 1833 4
- 1857 4
- 1862 4
- 1864 4
- 1871 4
- 1883 4
- 1901 4
- 1920 4
- 1945 4
- 2055 4
- 2256 4
- 3 3
- 1004 3
- 1035 3
- 1107 3
- 1110 3
- 1111 3
- 1135 3
- 1201 3
- 1801 3
- 1802 3
- 1808 3
- 1810 3
- 1848 3
- 1863 3
- 1878 3
- 1892 3
- 1908 3
- 1914 3
- 1924 3
- 1928 3
- 1932 3
- 1934 3
- 1937 3
- 1952 3
- 1967 3
- 1970 3
- 1973 3
- 1975 3
- 1994 3
- 1995 3
- 2021 3
- 2099 3
- 2144 3
- 2185 3
- 2216 3
- 2281 3
- 2295 3
- 2309 3
- 1 2
- 4 2
- 5 2
- 1007 2
- 1020 2
- 1039 2
- 1048 2
- 1055 2
- 1074 2
- 1093 2
- 1106 2
- 1116 2
- 1122 2
- 1143 2
- 1147 2
- 1156 2
- 1168 2
- 1171 2
- 1184 2
- 1224 2
- 1231 2
- 1298 2
- 1310 2
- 1341 2
- 1374 2
- 1666 2
- 1720 2
- 1752 2
- 1773 2
- 1784 2
- 1795 2
- 1804 2
- 1813 2
- 1822 2
- 1823 2
- 1835 2
- 1844 2
- 1850 2
- 1855 2
- 1865 2
- 1879 2
- 1893 2
- 1906 2
- 1912 2
- 1913 2
- 1918 2
- 1921 2
- 1929 2
- 1936 2
- 1946 2
- 1960 2
- 1965 2
- 1966 2
- 1976 2
- 1983 2
- 1992 2
- 2178 2
- 2 1
- 7 1
- 8 1
- 15 1
- 21 1
- 23 1
- 28 1
- 29 1
- 33 1
- 42 1
- 50 1
- 56 1
- 73 1
- 81 1
- 88 1
- 106 1
- 120 1
- 147 1
- 166 1
- 190 1
- 214 1
- 238 1
- 263 1
- 285 1
- 318 1
- 346 1
- 372 1
- 391 1
- 424 1
- 448 1
- 469 1
- 504 1
- 524 1
- 550 1
- 569 1
- 588 1
- 596 1
- 609 1
- 642 1
- 663 1
- 683 1
- 703 1
- 718 1
- 731 1
- 732 1
- 749 1
- 759 1
- 768 1
- 778 1
- 787 1
- 793 1
- 797 1
- 807 1
- 813 1
- 818 1
- 827 1
- 838 1
- 839 1
- 844 1
- 850 1
- 852 1
- 861 1
- 868 1
- 871 1
- 896 1
- 902 1
- 908 1
- 913 1
- 922 1
- 923 1
- 924 1
- 931 1
- 935 1
- 936 1
- 938 1
- 941 1
- 943 1
- 950 1
- 951 1
- 952 1
- 959 1
- 963 1
- 971 1
- 973 1
- 976 1
- 978 1
- 979 1
- 984 1
- 990 1
- 997 1
- 1002 1
- 1009 1
- 1012 1
- 1013 1
- 1016 1
- 1018 1
- 1022 1
- 1024 1
- 1027 1
- 1030 1
- 1042 1
- 1044 1
- 1046 1
- 1052 1
- 1054 1
- 1057 1
- 1058 1
- 1059 1
- 1062 1
- 1063 1
- 1066 1
- 1071 1
- 1073 1
- 1090 1
- 1091 1
- 1092 1
- 1095 1
- 1097 1
- 1101 1
- 1104 1
- 1105 1
- 1109 1
- 1113 1
- 1114 1
- 1119 1
- 1120 1
- 1124 1
- 1128 1
- 1132 1
- 1133 1
- 1134 1
- 1137 1
- 1144 1
- 1145 1
- 1148 1
- 1150 1
- 1153 1
- 1155 1
- 1160 1
- 1161 1
- 1163 1
- 1166 1
- 1169 1
- 1173 1
- 1177 1
- 1180 1
- 1181 1
- 1183 1
- 1187 1
- 1189 1
- 1191 1
- 1193 1
- 1198 1
- 1203 1
- 1204 1
- 1205 1
- 1208 1
- 1209 1
- 1210 1
- 1215 1
- 1218 1
- 1225 1
- 1227 1
- 1228 1
- 1234 1
- 1239 1
- 1246 1
- 1248 1
- 1250 1
- 1256 1
- 1261 1
- 1266 1
- 1273 1
- 1275 1
- 1276 1
- 1278 1
- 1288 1
- 1291 1
- 1294 1
- 1296 1
- 1306 1
- 1309 1
- 1312 1
- 1315 1
- 1320 1
- 1325 1
- 1332 1
- 1343 1
- 1352 1
- 1357 1
- 1361 1
- 1369 1
- 1377 1
- 1382 1
- 1387 1
- 1395 1
- 1401 1
- 1406 1
- 1412 1
- 1415 1
- 1426 1
- 1430 1
- 1439 1
- 1448 1
- 1459 1
- 1465 1
- 1478 1
- 1481 1
- 1487 1
- 1490 1
- 1498 1
- 1506 1
- 1508 1
- 1519 1
- 1525 1
- 1530 1
- 1535 1
- 1541 1
- 1548 1
- 1556 1
- 1561 1
- 1563 1
- 1566 1
- 1568 1
- 1572 1
- 1581 1
- 1588 1
- 1592 1
- 1597 1
- 1603 1
- 1606 1
- 1617 1
- 1627 1
- 1633 1
- 1642 1
- 1646 1
- 1651 1
- 1654 1
- 1659 1
- 1668 1
- 1673 1
- 1674 1
- 1677 1
- 1681 1
- 1685 1
- 1687 1
- 1693 1
- 1697 1
- 1700 1
- 1701 1
- 1707 1
- 1712 1
- 1713 1
- 1718 1
- 1721 1
- 1729 1
- 1738 1
- 1741 1
- 1747 1
- 1749 1
- 1758 1
- 1760 1
- 1762 1
- 1763 1
- 1768 1
- 1769 1
- 1771 1
- 1776 1
- 1781 1
- 1783 1
- 1788 1
- 1791 1
- 1794 1
- 1799 1
- 1807 1
- 1809 1
- 1812 1
- 1814 1
- 1817 1
- 1819 1
- 1826 1
- 1827 1
- 1829 1
- 1830 1
- 1831 1
- 1836 1
- 1841 1
- 1846 1
- 1859 1
- 1860 1
- 1861 1
- 1866 1
- 1869 1
- 1872 1
- 1874 1
- 1875 1
- 1876 1
- 1881 1
- 1882 1
- 1886 1
- 1888 1
- 1890 1
- 1895 1
- 1899 1
- 1905 1
- 1915 1
- 1919 1
- 1923 1
- 1925 1
- 1926 1
- 1930 1
- 1933 1
- 1935 1
- 1940 1
- 1941 1
- 1942 1
- 1943 1
- 1950 1
- 1955 1
- 1957 1
- 1958 1
- 1962 1
- 1968 1
- 1972 1
- 1974 1
- 1978 1
- 1981 1
- 1982 1
- 1984 1
- 1987 1
- 1990 1
- 1993 1
- 1998 1
- 2002 1
- 2005 1
- 2006 1
- 2010 1
- 2014 1
- 2017 1
- 2028 1
- 2039 1
- 2049 1
- 2051 1
- 2063 1
- 2084 1
- 2090 1
- 2109 1
- 2125 1
- 2132 1
- 2138 1
- 2156 1
- 2169 1
- 2190 1
- 2200 1
- 2205 1
- 2213 1
- 2226 1
- 2240 1
- 2242 1
- 2250 1
- 2262 1
- 2270 1
- 2277 1
- 2286 1
- 2290 1
- 2292 1
- 2293 1
- 2299 1
- 2301 1
- 2305 1
- 2307 1
state 1
- Massachusetts 833
fips 1
- 25025 · 833 ✖
county 1
- Suffolk 833
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
45 | 45 | 2020-02-01 | Suffolk | Massachusetts | 25025 | 1 | 0 |
53 | 53 | 2020-02-02 | Suffolk | Massachusetts | 25025 | 1 | 0 |
61 | 61 | 2020-02-03 | Suffolk | Massachusetts | 25025 | 1 | 0 |
69 | 69 | 2020-02-04 | Suffolk | Massachusetts | 25025 | 1 | 0 |
77 | 77 | 2020-02-05 | Suffolk | Massachusetts | 25025 | 1 | 0 |
86 | 86 | 2020-02-06 | Suffolk | Massachusetts | 25025 | 1 | 0 |
95 | 95 | 2020-02-07 | Suffolk | Massachusetts | 25025 | 1 | 0 |
104 | 104 | 2020-02-08 | Suffolk | Massachusetts | 25025 | 1 | 0 |
113 | 113 | 2020-02-09 | Suffolk | Massachusetts | 25025 | 1 | 0 |
123 | 123 | 2020-02-10 | Suffolk | Massachusetts | 25025 | 1 | 0 |
133 | 133 | 2020-02-11 | Suffolk | Massachusetts | 25025 | 1 | 0 |
143 | 143 | 2020-02-12 | Suffolk | Massachusetts | 25025 | 1 | 0 |
154 | 154 | 2020-02-13 | Suffolk | Massachusetts | 25025 | 1 | 0 |
165 | 165 | 2020-02-14 | Suffolk | Massachusetts | 25025 | 1 | 0 |
176 | 176 | 2020-02-15 | Suffolk | Massachusetts | 25025 | 1 | 0 |
187 | 187 | 2020-02-16 | Suffolk | Massachusetts | 25025 | 1 | 0 |
198 | 198 | 2020-02-17 | Suffolk | Massachusetts | 25025 | 1 | 0 |
210 | 210 | 2020-02-18 | Suffolk | Massachusetts | 25025 | 1 | 0 |
222 | 222 | 2020-02-19 | Suffolk | Massachusetts | 25025 | 1 | 0 |
235 | 235 | 2020-02-20 | Suffolk | Massachusetts | 25025 | 1 | 0 |
249 | 249 | 2020-02-21 | Suffolk | Massachusetts | 25025 | 1 | 0 |
263 | 263 | 2020-02-22 | Suffolk | Massachusetts | 25025 | 1 | 0 |
277 | 277 | 2020-02-23 | Suffolk | Massachusetts | 25025 | 1 | 0 |
292 | 292 | 2020-02-24 | Suffolk | Massachusetts | 25025 | 1 | 0 |
308 | 308 | 2020-02-25 | Suffolk | Massachusetts | 25025 | 1 | 0 |
328 | 328 | 2020-02-26 | Suffolk | Massachusetts | 25025 | 1 | 0 |
348 | 348 | 2020-02-27 | Suffolk | Massachusetts | 25025 | 1 | 0 |
368 | 368 | 2020-02-28 | Suffolk | Massachusetts | 25025 | 1 | 0 |
390 | 390 | 2020-02-29 | Suffolk | Massachusetts | 25025 | 1 | 0 |
415 | 415 | 2020-03-01 | Suffolk | Massachusetts | 25025 | 1 | 0 |
446 | 446 | 2020-03-02 | Suffolk | Massachusetts | 25025 | 1 | 0 |
480 | 480 | 2020-03-03 | Suffolk | Massachusetts | 25025 | 1 | 0 |
515 | 515 | 2020-03-04 | Suffolk | Massachusetts | 25025 | 1 | 0 |
559 | 559 | 2020-03-05 | Suffolk | Massachusetts | 25025 | 1 | 0 |
619 | 619 | 2020-03-06 | Suffolk | Massachusetts | 25025 | 4 | 0 |
705 | 705 | 2020-03-07 | Suffolk | Massachusetts | 25025 | 4 | 0 |
807 | 807 | 2020-03-08 | Suffolk | Massachusetts | 25025 | 9 | 0 |
931 | 931 | 2020-03-09 | Suffolk | Massachusetts | 25025 | 10 | 0 |
1078 | 1078 | 2020-03-10 | Suffolk | Massachusetts | 25025 | 20 | 0 |
1258 | 1258 | 2020-03-11 | Suffolk | Massachusetts | 25025 | 20 | 0 |
1476 | 1476 | 2020-03-12 | Suffolk | Massachusetts | 25025 | 22 | 0 |
1755 | 1755 | 2020-03-13 | Suffolk | Massachusetts | 25025 | 26 | 0 |
2098 | 2098 | 2020-03-14 | Suffolk | Massachusetts | 25025 | 27 | 0 |
2501 | 2501 | 2020-03-15 | Suffolk | Massachusetts | 25025 | 31 | 0 |
2950 | 2950 | 2020-03-16 | Suffolk | Massachusetts | 25025 | 42 | 0 |
3451 | 3451 | 2020-03-17 | Suffolk | Massachusetts | 25025 | 42 | 0 |
4034 | 4034 | 2020-03-18 | Suffolk | Massachusetts | 25025 | 51 | 0 |
4739 | 4739 | 2020-03-19 | Suffolk | Massachusetts | 25025 | 72 | 0 |
5558 | 5558 | 2020-03-20 | Suffolk | Massachusetts | 25025 | 87 | 1 |
6518 | 6518 | 2020-03-21 | Suffolk | Massachusetts | 25025 | 108 | 1 |
7595 | 7595 | 2020-03-22 | Suffolk | Massachusetts | 25025 | 126 | 2 |
8767 | 8767 | 2020-03-23 | Suffolk | Massachusetts | 25025 | 154 | 3 |
10056 | 10056 | 2020-03-24 | Suffolk | Massachusetts | 25025 | 234 | 3 |
11468 | 11468 | 2020-03-25 | Suffolk | Massachusetts | 25025 | 342 | 3 |
13049 | 13049 | 2020-03-26 | Suffolk | Massachusetts | 25025 | 448 | 4 |
14757 | 14757 | 2020-03-27 | Suffolk | Massachusetts | 25025 | 631 | 4 |
16577 | 16577 | 2020-03-28 | Suffolk | Massachusetts | 25025 | 843 | 5 |
18492 | 18492 | 2020-03-29 | Suffolk | Massachusetts | 25025 | 940 | 5 |
20508 | 20508 | 2020-03-30 | Suffolk | Massachusetts | 25025 | 1115 | 7 |
22617 | 22617 | 2020-03-31 | Suffolk | Massachusetts | 25025 | 1373 | 8 |
24796 | 24796 | 2020-04-01 | Suffolk | Massachusetts | 25025 | 1624 | 15 |
27048 | 27048 | 2020-04-02 | Suffolk | Massachusetts | 25025 | 1896 | 21 |
29366 | 29366 | 2020-04-03 | Suffolk | Massachusetts | 25025 | 2183 | 23 |
31744 | 31744 | 2020-04-04 | Suffolk | Massachusetts | 25025 | 2429 | 28 |
34169 | 34169 | 2020-04-05 | Suffolk | Massachusetts | 25025 | 2658 | 29 |
36628 | 36628 | 2020-04-06 | Suffolk | Massachusetts | 25025 | 2929 | 33 |
39136 | 39136 | 2020-04-07 | Suffolk | Massachusetts | 25025 | 3245 | 42 |
41688 | 41688 | 2020-04-08 | Suffolk | Massachusetts | 25025 | 3600 | 50 |
44264 | 44264 | 2020-04-09 | Suffolk | Massachusetts | 25025 | 4041 | 56 |
46872 | 46872 | 2020-04-10 | Suffolk | Massachusetts | 25025 | 4534 | 73 |
49514 | 49514 | 2020-04-11 | Suffolk | Massachusetts | 25025 | 4926 | 81 |
52184 | 52184 | 2020-04-12 | Suffolk | Massachusetts | 25025 | 5359 | 88 |
54865 | 54865 | 2020-04-13 | Suffolk | Massachusetts | 25025 | 5579 | 106 |
57563 | 57563 | 2020-04-14 | Suffolk | Massachusetts | 25025 | 5872 | 120 |
60272 | 60272 | 2020-04-15 | Suffolk | Massachusetts | 25025 | 6279 | 147 |
62993 | 62993 | 2020-04-16 | Suffolk | Massachusetts | 25025 | 6820 | 166 |
65731 | 65731 | 2020-04-17 | Suffolk | Massachusetts | 25025 | 7272 | 190 |
68481 | 68481 | 2020-04-18 | Suffolk | Massachusetts | 25025 | 7696 | 214 |
71245 | 71245 | 2020-04-19 | Suffolk | Massachusetts | 25025 | 8074 | 238 |
74017 | 74017 | 2020-04-20 | Suffolk | Massachusetts | 25025 | 8314 | 263 |
76797 | 76797 | 2020-04-21 | Suffolk | Massachusetts | 25025 | 8669 | 285 |
79583 | 79583 | 2020-04-22 | Suffolk | Massachusetts | 25025 | 9060 | 318 |
82378 | 82378 | 2020-04-23 | Suffolk | Massachusetts | 25025 | 9739 | 346 |
85182 | 85182 | 2020-04-24 | Suffolk | Massachusetts | 25025 | 10724 | 372 |
87992 | 87992 | 2020-04-25 | Suffolk | Massachusetts | 25025 | 11218 | 391 |
90808 | 90808 | 2020-04-26 | Suffolk | Massachusetts | 25025 | 11543 | 424 |
93629 | 93629 | 2020-04-27 | Suffolk | Massachusetts | 25025 | 11883 | 448 |
96464 | 96464 | 2020-04-28 | Suffolk | Massachusetts | 25025 | 12140 | 469 |
99310 | 99310 | 2020-04-29 | Suffolk | Massachusetts | 25025 | 12539 | 504 |
102162 | 102162 | 2020-04-30 | Suffolk | Massachusetts | 25025 | 12890 | 524 |
105022 | 105022 | 2020-05-01 | Suffolk | Massachusetts | 25025 | 13295 | 550 |
107886 | 107886 | 2020-05-02 | Suffolk | Massachusetts | 25025 | 13606 | 569 |
110758 | 110758 | 2020-05-03 | Suffolk | Massachusetts | 25025 | 13777 | 588 |
113636 | 113636 | 2020-05-04 | Suffolk | Massachusetts | 25025 | 13941 | 596 |
116517 | 116517 | 2020-05-05 | Suffolk | Massachusetts | 25025 | 14173 | 609 |
119478 | 119478 | 2020-05-06 | Suffolk | Massachusetts | 25025 | 14476 | 642 |
122450 | 122450 | 2020-05-07 | Suffolk | Massachusetts | 25025 | 14732 | 663 |
125432 | 125432 | 2020-05-08 | Suffolk | Massachusetts | 25025 | 14944 | 683 |
128419 | 128419 | 2020-05-09 | Suffolk | Massachusetts | 25025 | 15119 | 703 |
131409 | 131409 | 2020-05-10 | Suffolk | Massachusetts | 25025 | 15279 | 718 |
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);