ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36031 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 589 ✖
- 63 14
- 59 13
- 1601 12
- 48 11
- 44 10
- 40 7
- 49 7
- 12 6
- 46 6
- 50 6
- 1603 6
- 1605 6
- 4 5
- 7 5
- 62 5
- 1606 5
- 1598 4
- 1599 4
- 1600 4
- 1 3
- 3 3
- 6 3
- 30 3
- 34 3
- 38 3
- 57 3
- 64 3
- 67 3
- 157 3
- 159 3
- 177 3
- 202 3
- 205 3
- 224 3
- 232 3
- 1419 3
- 1589 3
- 1594 3
- 1596 3
- 5 2
- 22 2
- 28 2
- 35 2
- 39 2
- 41 2
- 42 2
- 45 2
- 55 2
- 71 2
- 93 2
- 108 2
- 134 2
- 158 2
- 162 2
- 168 2
- 169 2
- 172 2
- 175 2
- 176 2
- 178 2
- 186 2
- 189 2
- 203 2
- 207 2
- 211 2
- 1512 2
- 1519 2
- 1554 2
- 1581 2
- 1585 2
- 1597 2
- 1622 2
- 1623 2
- 1637 2
- 1640 2
- 1644 2
- 1780 2
- 3501 2
- 5476 2
- 6124 2
- 2 1
- 8 1
- 10 1
- 15 1
- 24 1
- 26 1
- 27 1
- 32 1
- 33 1
- 47 1
- 54 1
- 56 1
- 65 1
- 106 1
- 109 1
- 113 1
- 127 1
- 136 1
- 137 1
- 139 1
- 143 1
- 149 1
- 153 1
- 155 1
- 156 1
- 161 1
- 165 1
- 166 1
- 179 1
- 180 1
- 182 1
- 184 1
- 185 1
- 187 1
- 190 1
- 192 1
- 198 1
- 200 1
- 204 1
- 206 1
- 212 1
- 215 1
- 218 1
- 220 1
- 221 1
- 226 1
- 237 1
- 238 1
- 239 1
- 242 1
- 244 1
- 247 1
- 248 1
- 254 1
- 256 1
- 258 1
- 260 1
- 271 1
- 283 1
- 286 1
- 287 1
- 293 1
- 294 1
- 297 1
- 304 1
- 310 1
- 313 1
- 319 1
- 324 1
- 329 1
- 336 1
- 342 1
- 356 1
- 363 1
- 376 1
- 381 1
- 383 1
- 390 1
- 410 1
- 422 1
- 430 1
- 438 1
- 447 1
- 451 1
- 461 1
- 470 1
- 487 1
- 506 1
- 523 1
- 531 1
- 537 1
- 545 1
- 562 1
- 578 1
- 616 1
- 627 1
- 650 1
- 659 1
- 671 1
- 687 1
- 724 1
- 786 1
- 840 1
- 855 1
- 861 1
- 876 1
- 894 1
- 908 1
- 937 1
- 960 1
- 967 1
- 980 1
- 988 1
- 996 1
- 1005 1
- 1025 1
- 1033 1
- 1045 1
- 1054 1
- 1064 1
- 1073 1
- 1086 1
- 1099 1
- 1108 1
- 1119 1
- 1125 1
- 1131 1
- 1142 1
- 1161 1
- 1168 1
- 1180 1
- 1186 1
- 1191 1
- 1197 1
- 1205 1
- 1210 1
- 1223 1
- 1233 1
- 1243 1
- 1250 1
- 1257 1
- 1268 1
- 1270 1
- 1280 1
- 1299 1
- 1306 1
- 1310 1
- 1322 1
- 1325 1
- 1336 1
- 1340 1
- 1344 1
- 1349 1
- 1350 1
- 1355 1
- 1360 1
- 1364 1
- 1368 1
- 1371 1
- 1372 1
- 1379 1
- 1380 1
- 1382 1
- 1386 1
- 1394 1
- 1399 1
- 1403 1
- 1406 1
- 1407 1
- 1408 1
- 1412 1
- 1417 1
- 1422 1
- 1426 1
- 1428 1
- 1430 1
- 1436 1
- 1440 1
- 1443 1
- 1445 1
- 1447 1
- 1455 1
- 1462 1
- 1465 1
- 1468 1
- 1469 1
- 1474 1
- 1477 1
- 1482 1
- 1484 1
- 1487 1
- 1490 1
- 1491 1
- 1493 1
- 1497 1
- 1501 1
- 1503 1
- 1504 1
- 1514 1
- 1516 1
- 1518 1
- 1521 1
- 1523 1
- 1530 1
- 1532 1
- 1540 1
- 1542 1
- 1545 1
- 1553 1
- 1559 1
- 1560 1
- 1571 1
- 1572 1
- 1575 1
- 1576 1
- 1578 1
- 1583 1
- 1586 1
- 1588 1
- 1595 1
- 1602 1
- 1607 1
- 1608 1
- 1609 1
- 1610 1
- 1616 1
- 1618 1
- 1620 1
- 1626 1
- 1628 1
- 1629 1
- 1631 1
- 1633 1
- 1636 1
- 1645 1
- 1647 1
- 1653 1
- 1657 1
- 1658 1
- 1659 1
- 1662 1
- 1668 1
- 1674 1
- 1678 1
- 1687 1
- 1693 1
- 1703 1
- 1709 1
- 1714 1
- 1728 1
- 1738 1
- 1741 1
- 1745 1
- 1748 1
- 1753 1
- 1759 1
- 1761 1
- 1769 1
- 1773 1
- 1781 1
- 1787 1
- 1790 1
- 1807 1
- 1817 1
- 1822 1
- 1826 1
- 1832 1
- 1837 1
- 1844 1
- 1858 1
- 1866 1
- 1870 1
- 1876 1
- 1884 1
- 1888 1
- 1900 1
- 1922 1
- 1930 1
- 1937 1
- 1940 1
- 1942 1
- 1947 1
- 1959 1
- 1978 1
- 1985 1
- 2008 1
- 2020 1
- 2036 1
- 2044 1
- 2052 1
- 2069 1
- 2090 1
- 2096 1
- 2107 1
- 2115 1
- 2125 1
- 2135 1
- 2152 1
- 2158 1
- 2163 1
- 2170 1
- 2177 1
- 2186 1
- 2194 1
- 2209 1
- 2232 1
- 2253 1
- 2271 1
- 2276 1
- 2300 1
- 2315 1
- 2335 1
- 2355 1
- 2370 1
- 2383 1
- 2388 1
- 2401 1
- 2414 1
- 2441 1
- 2456 1
- 2484 1
- 2501 1
- 2512 1
- 2542 1
- 2566 1
- 2591 1
- 2612 1
- 2642 1
- 2659 1
- 2678 1
- 2693 1
- 2705 1
- 2731 1
- 2755 1
- 2775 1
- 2786 1
- 2794 1
- 2802 1
- 2813 1
- 2848 1
- 2868 1
- 2878 1
- 2890 1
- 2898 1
- 2915 1
- 2935 1
- 2954 1
- 2961 1
- 2972 1
- 2983 1
- 2992 1
- 3013 1
- 3043 1
- 3067 1
- 3081 1
- 3097 1
- 3110 1
- 3127 1
- 3159 1
- 3185 1
- 3213 1
- 3228 1
- 3256 1
- 3266 1
- 3272 1
- 3299 1
- 3317 1
- 3354 1
- 3381 1
- 3403 1
- 3418 1
- 3427 1
- 3451 1
- 3478 1
- 3535 1
- 3538 1
- 3545 1
- 3585 1
- 3632 1
- 3702 1
- 3767 1
- 3833 1
- 3857 1
- 3887 1
- 3943 1
- 3995 1
- 4070 1
- 4177 1
- 4238 1
- 4285 1
- 4320 1
- 4378 1
- 4446 1
- 4491 1
- 4555 1
- 4603 1
- 4626 1
- 4639 1
- 4677 1
- 4728 1
- 4765 1
- 4829 1
- 4880 1
- 4897 1
- 4911 1
- 4951 1
- 4985 1
- 5022 1
- 5070 1
- 5098 1
- 5115 1
- 5133 1
- 5147 1
- 5179 1
- 5197 1
- 5213 1
- 5227 1
- 5238 1
- 5249 1
- 5261 1
- 5286 1
- 5298 1
- 5320 1
- 5327 1
- 5336 1
- 5337 1
- 5343 1
- 5356 1
- 5369 1
- 5378 1
- 5386 1
- 5391 1
- 5394 1
- 5406 1
- 5434 1
- 5441 1
- 5451 1
- 5457 1
- 5460 1
- 5465 1
- 5469 1
- 5485 1
- 5488 1
- 5490 1
- 5492 1
- 5497 1
- 5498 1
- 5502 1
- 5508 1
- 5513 1
- 5514 1
- 5517 1
- 5533 1
- 5543 1
- 5556 1
- 5565 1
- 5571 1
- 5576 1
- 5579 1
- 5591 1
- 5601 1
- 5605 1
- 5612 1
- 5616 1
- 5620 1
- 5624 1
- 5636 1
- 5650 1
- 5668 1
- 5680 1
- 5695 1
- 5699 1
- 5703 1
- 5712 1
- 5720 1
- 5728 1
- 5748 1
- 5759 1
- 5770 1
- 5781 1
- 5793 1
- 5799 1
- 5810 1
- 5818 1
- 5824 1
- 5827 1
- 5830 1
- 5837 1
- 5850 1
- 5860 1
- 5868 1
- 5880 1
- 5889 1
- 5893 1
- 5902 1
- 5914 1
- 5926 1
- 5951 1
- 5961 1
- 5969 1
- 5979 1
- 5987 1
- 6006 1
- 6026 1
- 6054 1
- 6067 1
- 6072 1
- 6081 1
- 6103 1
state 1
- New York 787
fips 1
- 36031 · 787 ✖
county 1
- Essex 787
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
4142 | 4142 | 2020-03-18 | Essex | New York | 36031 | 1 | 0 |
4871 | 4871 | 2020-03-19 | Essex | New York | 36031 | 1 | 0 |
5718 | 5718 | 2020-03-20 | Essex | New York | 36031 | 1 | 0 |
6712 | 6712 | 2020-03-21 | Essex | New York | 36031 | 2 | 0 |
7806 | 7806 | 2020-03-22 | Essex | New York | 36031 | 3 | 0 |
9004 | 9004 | 2020-03-23 | Essex | New York | 36031 | 3 | 0 |
10311 | 10311 | 2020-03-24 | Essex | New York | 36031 | 3 | 0 |
11746 | 11746 | 2020-03-25 | Essex | New York | 36031 | 4 | 0 |
13349 | 13349 | 2020-03-26 | Essex | New York | 36031 | 4 | 0 |
15083 | 15083 | 2020-03-27 | Essex | New York | 36031 | 4 | 0 |
16913 | 16913 | 2020-03-28 | Essex | New York | 36031 | 4 | 0 |
18837 | 18837 | 2020-03-29 | Essex | New York | 36031 | 4 | 0 |
20876 | 20876 | 2020-03-30 | Essex | New York | 36031 | 5 | 0 |
22999 | 22999 | 2020-03-31 | Essex | New York | 36031 | 5 | 0 |
25193 | 25193 | 2020-04-01 | Essex | New York | 36031 | 6 | 0 |
27453 | 27453 | 2020-04-02 | Essex | New York | 36031 | 6 | 0 |
29777 | 29777 | 2020-04-03 | Essex | New York | 36031 | 6 | 0 |
32163 | 32163 | 2020-04-04 | Essex | New York | 36031 | 7 | 0 |
34594 | 34594 | 2020-04-05 | Essex | New York | 36031 | 7 | 0 |
37064 | 37064 | 2020-04-06 | Essex | New York | 36031 | 7 | 0 |
39579 | 39579 | 2020-04-07 | Essex | New York | 36031 | 7 | 0 |
42136 | 42136 | 2020-04-08 | Essex | New York | 36031 | 7 | 0 |
44719 | 44719 | 2020-04-09 | Essex | New York | 36031 | 8 | 0 |
47332 | 47332 | 2020-04-10 | Essex | New York | 36031 | 10 | 0 |
49987 | 49987 | 2020-04-11 | Essex | New York | 36031 | 12 | 0 |
52660 | 52660 | 2020-04-12 | Essex | New York | 36031 | 12 | 0 |
55343 | 55343 | 2020-04-13 | Essex | New York | 36031 | 12 | 0 |
58043 | 58043 | 2020-04-14 | Essex | New York | 36031 | 12 | 0 |
60757 | 60757 | 2020-04-15 | Essex | New York | 36031 | 12 | 0 |
63483 | 63483 | 2020-04-16 | Essex | New York | 36031 | 12 | 0 |
66225 | 66225 | 2020-04-17 | Essex | New York | 36031 | 15 | 0 |
68982 | 68982 | 2020-04-18 | Essex | New York | 36031 | 22 | 0 |
71749 | 71749 | 2020-04-19 | Essex | New York | 36031 | 24 | 0 |
74524 | 74524 | 2020-04-20 | Essex | New York | 36031 | 26 | 0 |
77305 | 77305 | 2020-04-21 | Essex | New York | 36031 | 27 | 0 |
80094 | 80094 | 2020-04-22 | Essex | New York | 36031 | 28 | 0 |
82893 | 82893 | 2020-04-23 | Essex | New York | 36031 | 22 | 0 |
85697 | 85697 | 2020-04-24 | Essex | New York | 36031 | 28 | 0 |
88509 | 88509 | 2020-04-25 | Essex | New York | 36031 | 30 | 0 |
91324 | 91324 | 2020-04-26 | Essex | New York | 36031 | 30 | 0 |
94149 | 94149 | 2020-04-27 | Essex | New York | 36031 | 30 | 0 |
96985 | 96985 | 2020-04-28 | Essex | New York | 36031 | 32 | 0 |
99832 | 99832 | 2020-04-29 | Essex | New York | 36031 | 33 | 0 |
102685 | 102685 | 2020-04-30 | Essex | New York | 36031 | 34 | 0 |
105547 | 105547 | 2020-05-01 | Essex | New York | 36031 | 34 | 0 |
108414 | 108414 | 2020-05-02 | Essex | New York | 36031 | 34 | 0 |
111287 | 111287 | 2020-05-03 | Essex | New York | 36031 | 35 | 0 |
114168 | 114168 | 2020-05-04 | Essex | New York | 36031 | 35 | 0 |
117048 | 117048 | 2020-05-05 | Essex | New York | 36031 | 38 | 0 |
120009 | 120009 | 2020-05-06 | Essex | New York | 36031 | 38 | 0 |
122984 | 122984 | 2020-05-07 | Essex | New York | 36031 | 38 | 0 |
125967 | 125967 | 2020-05-08 | Essex | New York | 36031 | 39 | 0 |
128956 | 128956 | 2020-05-09 | Essex | New York | 36031 | 39 | 0 |
131945 | 131945 | 2020-05-10 | Essex | New York | 36031 | 40 | 0 |
134936 | 134936 | 2020-05-11 | Essex | New York | 36031 | 40 | 0 |
137926 | 137926 | 2020-05-12 | Essex | New York | 36031 | 40 | 0 |
140922 | 140922 | 2020-05-13 | Essex | New York | 36031 | 40 | 0 |
143917 | 143917 | 2020-05-14 | Essex | New York | 36031 | 40 | 0 |
146918 | 146918 | 2020-05-15 | Essex | New York | 36031 | 40 | 0 |
149925 | 149925 | 2020-05-16 | Essex | New York | 36031 | 40 | 0 |
152935 | 152935 | 2020-05-17 | Essex | New York | 36031 | 41 | 0 |
155952 | 155952 | 2020-05-18 | Essex | New York | 36031 | 41 | 0 |
158970 | 158970 | 2020-05-19 | Essex | New York | 36031 | 42 | 0 |
161997 | 161997 | 2020-05-20 | Essex | New York | 36031 | 42 | 0 |
165026 | 165026 | 2020-05-21 | Essex | New York | 36031 | 44 | 0 |
168061 | 168061 | 2020-05-22 | Essex | New York | 36031 | 44 | 0 |
171100 | 171100 | 2020-05-23 | Essex | New York | 36031 | 44 | 0 |
174142 | 174142 | 2020-05-24 | Essex | New York | 36031 | 44 | 0 |
177186 | 177186 | 2020-05-25 | Essex | New York | 36031 | 44 | 0 |
180229 | 180229 | 2020-05-26 | Essex | New York | 36031 | 44 | 0 |
183277 | 183277 | 2020-05-27 | Essex | New York | 36031 | 44 | 0 |
186334 | 186334 | 2020-05-28 | Essex | New York | 36031 | 44 | 0 |
189394 | 189394 | 2020-05-29 | Essex | New York | 36031 | 44 | 0 |
192458 | 192458 | 2020-05-30 | Essex | New York | 36031 | 44 | 0 |
195528 | 195528 | 2020-05-31 | Essex | New York | 36031 | 45 | 0 |
198601 | 198601 | 2020-06-01 | Essex | New York | 36031 | 45 | 0 |
201675 | 201675 | 2020-06-02 | Essex | New York | 36031 | 46 | 0 |
204752 | 204752 | 2020-06-03 | Essex | New York | 36031 | 46 | 0 |
207833 | 207833 | 2020-06-04 | Essex | New York | 36031 | 46 | 0 |
210915 | 210915 | 2020-06-05 | Essex | New York | 36031 | 46 | 0 |
213999 | 213999 | 2020-06-06 | Essex | New York | 36031 | 46 | 0 |
217089 | 217089 | 2020-06-07 | Essex | New York | 36031 | 46 | 0 |
220181 | 220181 | 2020-06-08 | Essex | New York | 36031 | 47 | 0 |
223275 | 223275 | 2020-06-09 | Essex | New York | 36031 | 48 | 0 |
226375 | 226375 | 2020-06-10 | Essex | New York | 36031 | 48 | 0 |
229479 | 229479 | 2020-06-11 | Essex | New York | 36031 | 48 | 0 |
232584 | 232584 | 2020-06-12 | Essex | New York | 36031 | 48 | 0 |
235689 | 235689 | 2020-06-13 | Essex | New York | 36031 | 48 | 0 |
238797 | 238797 | 2020-06-14 | Essex | New York | 36031 | 48 | 0 |
241906 | 241906 | 2020-06-15 | Essex | New York | 36031 | 48 | 0 |
245018 | 245018 | 2020-06-16 | Essex | New York | 36031 | 48 | 0 |
248131 | 248131 | 2020-06-17 | Essex | New York | 36031 | 48 | 0 |
251246 | 251246 | 2020-06-18 | Essex | New York | 36031 | 48 | 0 |
254361 | 254361 | 2020-06-19 | Essex | New York | 36031 | 48 | 0 |
257484 | 257484 | 2020-06-20 | Essex | New York | 36031 | 49 | 0 |
260611 | 260611 | 2020-06-21 | Essex | New York | 36031 | 49 | 0 |
263739 | 263739 | 2020-06-22 | Essex | New York | 36031 | 49 | 0 |
266867 | 266867 | 2020-06-23 | Essex | New York | 36031 | 49 | 0 |
270001 | 270001 | 2020-06-24 | Essex | New York | 36031 | 49 | 0 |
273140 | 273140 | 2020-06-25 | Essex | New York | 36031 | 49 | 0 |
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);