ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Rensselaer" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
cases 662 ✖
- 91 3
- 11229 3
- 11244 3
- 11247 3
- 11252 3
- 11253 3
- 4 2
- 444 2
- 463 2
- 466 2
- 495 2
- 514 2
- 515 2
- 553 2
- 795 2
- 879 2
- 901 2
- 11217 2
- 11239 2
- 20014 2
- 1 1
- 8 1
- 20 1
- 26 1
- 29 1
- 30 1
- 31 1
- 32 1
- 35 1
- 38 1
- 39 1
- 40 1
- 55 1
- 60 1
- 67 1
- 71 1
- 73 1
- 74 1
- 78 1
- 79 1
- 96 1
- 105 1
- 113 1
- 120 1
- 124 1
- 137 1
- 150 1
- 164 1
- 173 1
- 177 1
- 183 1
- 186 1
- 191 1
- 198 1
- 221 1
- 242 1
- 246 1
- 250 1
- 262 1
- 287 1
- 298 1
- 311 1
- 322 1
- 337 1
- 339 1
- 347 1
- 367 1
- 380 1
- 407 1
- 409 1
- 411 1
- 416 1
- 420 1
- 423 1
- 428 1
- 438 1
- 439 1
- 453 1
- 456 1
- 460 1
- 465 1
- 469 1
- 478 1
- 486 1
- 491 1
- 492 1
- 493 1
- 497 1
- 499 1
- 502 1
- 503 1
- 505 1
- 507 1
- 508 1
- 510 1
- 511 1
- 513 1
- 519 1
- 521 1
- 524 1
- 528 1
- 533 1
- 534 1
- 541 1
- 549 1
- 550 1
- 551 1
- 555 1
- 556 1
- 559 1
- 563 1
- 565 1
- 568 1
- 571 1
- 580 1
- 586 1
- 588 1
- 593 1
- 616 1
- 617 1
- 625 1
- 632 1
- 639 1
- 643 1
- 650 1
- 651 1
- 653 1
- 658 1
- 668 1
- 669 1
- 676 1
- 681 1
- 684 1
- 687 1
- 690 1
- 694 1
- 718 1
- 724 1
- 734 1
- 736 1
- 740 1
- 748 1
- 755 1
- 758 1
- 759 1
- 761 1
- 765 1
- 766 1
- 770 1
- 780 1
- 782 1
- 785 1
- 789 1
- 801 1
- 804 1
- 809 1
- 810 1
- 813 1
- 817 1
- 818 1
- 819 1
- 822 1
- 823 1
- 826 1
- 830 1
- 833 1
- 838 1
- 841 1
- 844 1
- 848 1
- 854 1
- 858 1
- 859 1
- 860 1
- 865 1
- 866 1
- 867 1
- 870 1
- 876 1
- 884 1
- 887 1
- 892 1
- 895 1
- 896 1
- 899 1
- 902 1
- 903 1
- 905 1
- 908 1
- 911 1
- 913 1
- 916 1
- 919 1
- 923 1
- 931 1
- 937 1
- 944 1
- 945 1
- 952 1
- 957 1
- 958 1
- 964 1
- 970 1
- 980 1
- 985 1
- 994 1
- 1002 1
- 1007 1
- 1020 1
- 1021 1
- 1027 1
- 1034 1
- 1040 1
- 1047 1
- 1058 1
- 1064 1
- 1073 1
- 1080 1
- 1088 1
- 1094 1
- 1099 1
- 1110 1
- 1111 1
- 1116 1
- 1124 1
- 1131 1
- 1135 1
- 1142 1
- 1161 1
- 1175 1
- 1184 1
- 1198 1
- 1213 1
- 1230 1
- 1243 1
- 1258 1
- 1278 1
- 1304 1
- 1321 1
- 1333 1
- 1364 1
- 1389 1
- 1411 1
- 1449 1
- 1494 1
- 1515 1
- 1528 1
- 1554 1
- 1587 1
- 1625 1
- 1666 1
- 1686 1
- 1720 1
- 1746 1
- 1795 1
- 1837 1
- 1891 1
- 1968 1
- 2034 1
- 2100 1
- 2145 1
- 2210 1
- 2269 1
- 2351 1
- 2411 1
- 2477 1
- 2569 1
- 2631 1
- 2712 1
- 2789 1
- 2904 1
- 2991 1
- 3091 1
- 3168 1
- 3226 1
- 3332 1
- 3412 1
- 3534 1
- 3645 1
- 3751 1
- 3824 1
- 3925 1
- 4015 1
- 4133 1
- 4269 1
- 4415 1
- 4575 1
- 4724 1
- 4796 1
- 4933 1
- 5067 1
- 5249 1
- 5440 1
- 5566 1
- 5714 1
- 5860 1
- 6040 1
- 6117 1
- 6275 1
- 6454 1
- 6596 1
- 6693 1
- 6772 1
- 6874 1
- 6965 1
- 7112 1
- 7262 1
- 7349 1
- 7450 1
- 7502 1
- 7574 1
- 7642 1
- 7720 1
- 7807 1
- 7874 1
- 7960 1
- 8006 1
- 8035 1
- 8064 1
- 8133 1
- 8185 1
- 8264 1
- 8301 1
- 8341 1
- 8369 1
- 8407 1
- 8459 1
- 8483 1
- 8527 1
- 8561 1
- 8592 1
- 8621 1
- 8641 1
- 8690 1
- 8733 1
- 8760 1
- 8788 1
- 8810 1
- 8839 1
- 8860 1
- 8902 1
- 8935 1
- 8965 1
- 9013 1
- 9039 1
- 9059 1
- 9103 1
- 9124 1
- 9160 1
- 9205 1
- 9233 1
- 9275 1
- 9296 1
- 9310 1
- 9342 1
- 9376 1
- 9408 1
- 9450 1
- 9484 1
- 9518 1
- 9531 1
- 9570 1
- 9601 1
- 9625 1
- 9657 1
- 9679 1
- 9705 1
- 9739 1
- 9777 1
- 9824 1
- 9856 1
- 9901 1
- 9931 1
- 9973 1
- 10004 1
- 10053 1
- 10091 1
- 10137 1
- 10181 1
- 10217 1
- 10248 1
- 10285 1
- 10317 1
- 10359 1
- 10402 1
- 10439 1
- 10465 1
- 10495 1
- 10526 1
- 10567 1
- 10592 1
- 10642 1
- 10679 1
- 10709 1
- 10726 1
- 10745 1
- 10776 1
- 10802 1
- 10811 1
- 10823 1
- 10846 1
- 10857 1
- 10867 1
- 10890 1
- 10912 1
- 10928 1
- 10942 1
- 10952 1
- 10957 1
- 10964 1
- 10977 1
- 11002 1
- 11011 1
- 11026 1
- 11037 1
- 11049 1
- 11054 1
- 11072 1
- 11089 1
- 11104 1
- 11114 1
- 11123 1
- 11133 1
- 11139 1
- 11148 1
- 11156 1
- 11161 1
- 11164 1
- 11170 1
- 11174 1
- 11176 1
- 11180 1
- 11185 1
- 11186 1
- 11188 1
- 11189 1
- 11192 1
- 11194 1
- 11195 1
- 11204 1
- 11205 1
- 11208 1
- 11215 1
- 11220 1
- 11222 1
- 11223 1
- 11225 1
- 11228 1
- 11232 1
- 11235 1
- 11238 1
- 11242 1
- 11249 1
- 11251 1
- 11254 1
- 11259 1
- 11262 1
- 11264 1
- 11271 1
- 11273 1
- 11277 1
- 11282 1
- 11288 1
- 11293 1
- 11302 1
- 11305 1
- 11311 1
- 11314 1
- 11320 1
- 11329 1
- 11333 1
- 11347 1
- 11355 1
- 11370 1
- 11390 1
- 11405 1
- 11422 1
- 11439 1
- 11463 1
- 11474 1
- 11494 1
- 11506 1
- 11530 1
- 11557 1
- 11604 1
- 11625 1
- 11639 1
- 11662 1
- 11687 1
- 11720 1
- 11755 1
- 11793 1
- 11828 1
- 11859 1
- 11888 1
- 11926 1
- 11955 1
- 11991 1
- 12039 1
- 12067 1
- 12099 1
- 12121 1
- 12143 1
- 12166 1
- 12237 1
- 12278 1
- 12315 1
- 12351 1
- 12386 1
- 12422 1
- 12458 1
- 12512 1
- 12570 1
- 12601 1
- 12642 1
- 12667 1
- 12694 1
- 12738 1
- 12780 1
- 12838 1
- 12874 1
- 12913 1
- 12944 1
- 12971 1
- 13038 1
- 13084 1
- 13126 1
- 13180 1
- 13209 1
- 13276 1
- 13319 1
- 13364 1
- 13442 1
- 13483 1
- 13522 1
- 13565 1
- 13604 1
- 13657 1
- 13708 1
- 13771 1
- 13823 1
- 13879 1
- 13903 1
- 13946 1
- 14015 1
- 14067 1
- 14145 1
- 14209 1
- 14239 1
- 14324 1
- 14358 1
- 14398 1
- 14443 1
- 14517 1
- 14570 1
- 14618 1
- 14669 1
- 14692 1
- 14761 1
- 14808 1
- 14839 1
- 14902 1
- 14947 1
- 15006 1
- 15024 1
- 15081 1
- 15127 1
- 15213 1
- 15274 1
- 15312 1
- 15339 1
- 15389 1
- 15432 1
- 15490 1
- 15562 1
- 15630 1
- 15702 1
- 15757 1
- 15809 1
- 15865 1
- 16003 1
- 16073 1
- 16144 1
- 16194 1
- 16240 1
- 16273 1
- 16342 1
- 16466 1
- 16540 1
- 16649 1
- 16716 1
- 16790 1
- 16851 1
- 16941 1
- 17067 1
- 17147 1
- 17188 1
- 17260 1
- 17336 1
- 17411 1
- 17502 1
- 17633 1
- 17811 1
- 17938 1
- 18059 1
- 18137 1
- 18229 1
- 18322 1
- 18447 1
- 18581 1
- 18703 1
- 18819 1
- 18862 1
- 18914 1
- 19015 1
- 19102 1
- 19222 1
- 19331 1
- 19438 1
- 19516 1
- 19610 1
- 19737 1
- 19880 1
- 20247 1
- 20307 1
- 20431 1
- 20635 1
- 20809 1
- 21133 1
- 21441 1
- 21708 1
- 21915 1
- 22025 1
- 22423 1
- 22852 1
- 23354 1
- 23915 1
- 24329 1
- 24707 1
- 25022 1
- 25358 1
- 25800 1
- 26206 1
- 26560 1
- 26855 1
- 27033 1
- 27231 1
- 27378 1
- 27722 1
- 27956 1
- 28200 1
- 28357 1
- 28468 1
- 28589 1
- 28771 1
- 28966 1
- 29089 1
- 29259 1
- 29353 1
- 29399 1
- 29456 1
- 29572 1
state 1
- New York 688
fips 1
- 36083 688
county 1
- Rensselaer · 688 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176082 | 2176082 | 2022-02-02 | Rensselaer | New York | 36083 | 29572 | 237 |
2172829 | 2172829 | 2022-02-01 | Rensselaer | New York | 36083 | 29456 | 236 |
2169576 | 2169576 | 2022-01-31 | Rensselaer | New York | 36083 | 29399 | 236 |
2166321 | 2166321 | 2022-01-30 | Rensselaer | New York | 36083 | 29353 | 235 |
2163066 | 2163066 | 2022-01-29 | Rensselaer | New York | 36083 | 29259 | 234 |
2159811 | 2159811 | 2022-01-28 | Rensselaer | New York | 36083 | 29089 | 234 |
2156556 | 2156556 | 2022-01-27 | Rensselaer | New York | 36083 | 28966 | 234 |
2153303 | 2153303 | 2022-01-26 | Rensselaer | New York | 36083 | 28771 | 233 |
2150051 | 2150051 | 2022-01-25 | Rensselaer | New York | 36083 | 28589 | 233 |
2146799 | 2146799 | 2022-01-24 | Rensselaer | New York | 36083 | 28468 | 232 |
2143545 | 2143545 | 2022-01-23 | Rensselaer | New York | 36083 | 28357 | 232 |
2140290 | 2140290 | 2022-01-22 | Rensselaer | New York | 36083 | 28200 | 231 |
2137034 | 2137034 | 2022-01-21 | Rensselaer | New York | 36083 | 27956 | 230 |
2133781 | 2133781 | 2022-01-20 | Rensselaer | New York | 36083 | 27722 | 228 |
2130529 | 2130529 | 2022-01-19 | Rensselaer | New York | 36083 | 27378 | 228 |
2127275 | 2127275 | 2022-01-18 | Rensselaer | New York | 36083 | 27231 | 228 |
2124023 | 2124023 | 2022-01-17 | Rensselaer | New York | 36083 | 27033 | 228 |
2120771 | 2120771 | 2022-01-16 | Rensselaer | New York | 36083 | 26855 | 228 |
2117519 | 2117519 | 2022-01-15 | Rensselaer | New York | 36083 | 26560 | 227 |
2114268 | 2114268 | 2022-01-14 | Rensselaer | New York | 36083 | 26206 | 226 |
2111016 | 2111016 | 2022-01-13 | Rensselaer | New York | 36083 | 25800 | 226 |
2107764 | 2107764 | 2022-01-12 | Rensselaer | New York | 36083 | 25358 | 224 |
2104513 | 2104513 | 2022-01-11 | Rensselaer | New York | 36083 | 25022 | 223 |
2101262 | 2101262 | 2022-01-10 | Rensselaer | New York | 36083 | 24707 | 222 |
2098011 | 2098011 | 2022-01-09 | Rensselaer | New York | 36083 | 24329 | 221 |
2094759 | 2094759 | 2022-01-08 | Rensselaer | New York | 36083 | 23915 | 219 |
2091507 | 2091507 | 2022-01-07 | Rensselaer | New York | 36083 | 23354 | 219 |
2088256 | 2088256 | 2022-01-06 | Rensselaer | New York | 36083 | 22852 | 218 |
2085004 | 2085004 | 2022-01-05 | Rensselaer | New York | 36083 | 22423 | 218 |
2081752 | 2081752 | 2022-01-04 | Rensselaer | New York | 36083 | 22025 | 217 |
2078500 | 2078500 | 2022-01-03 | Rensselaer | New York | 36083 | 21915 | 216 |
2075249 | 2075249 | 2022-01-02 | Rensselaer | New York | 36083 | 21708 | 215 |
2071998 | 2071998 | 2022-01-01 | Rensselaer | New York | 36083 | 21441 | 215 |
2068747 | 2068747 | 2021-12-31 | Rensselaer | New York | 36083 | 21133 | 213 |
2065496 | 2065496 | 2021-12-30 | Rensselaer | New York | 36083 | 20809 | 213 |
2062246 | 2062246 | 2021-12-29 | Rensselaer | New York | 36083 | 20635 | 212 |
2058997 | 2058997 | 2021-12-28 | Rensselaer | New York | 36083 | 20431 | 209 |
2055748 | 2055748 | 2021-12-27 | Rensselaer | New York | 36083 | 20307 | 208 |
2052498 | 2052498 | 2021-12-26 | Rensselaer | New York | 36083 | 20247 | 208 |
2049248 | 2049248 | 2021-12-25 | Rensselaer | New York | 36083 | 20014 | 208 |
2045998 | 2045998 | 2021-12-24 | Rensselaer | New York | 36083 | 20014 | 208 |
2042748 | 2042748 | 2021-12-23 | Rensselaer | New York | 36083 | 19880 | 208 |
2039499 | 2039499 | 2021-12-22 | Rensselaer | New York | 36083 | 19737 | 208 |
2036249 | 2036249 | 2021-12-21 | Rensselaer | New York | 36083 | 19610 | 206 |
2032999 | 2032999 | 2021-12-20 | Rensselaer | New York | 36083 | 19516 | 204 |
2029749 | 2029749 | 2021-12-19 | Rensselaer | New York | 36083 | 19438 | 204 |
2026498 | 2026498 | 2021-12-18 | Rensselaer | New York | 36083 | 19331 | 204 |
2023247 | 2023247 | 2021-12-17 | Rensselaer | New York | 36083 | 19222 | 203 |
2019996 | 2019996 | 2021-12-16 | Rensselaer | New York | 36083 | 19102 | 203 |
2016745 | 2016745 | 2021-12-15 | Rensselaer | New York | 36083 | 19015 | 203 |
2013495 | 2013495 | 2021-12-14 | Rensselaer | New York | 36083 | 18914 | 203 |
2010244 | 2010244 | 2021-12-13 | Rensselaer | New York | 36083 | 18862 | 201 |
2006993 | 2006993 | 2021-12-12 | Rensselaer | New York | 36083 | 18819 | 201 |
2003742 | 2003742 | 2021-12-11 | Rensselaer | New York | 36083 | 18703 | 201 |
2000491 | 2000491 | 2021-12-10 | Rensselaer | New York | 36083 | 18581 | 201 |
1997241 | 1997241 | 2021-12-09 | Rensselaer | New York | 36083 | 18447 | 201 |
1993990 | 1993990 | 2021-12-08 | Rensselaer | New York | 36083 | 18322 | 200 |
1990739 | 1990739 | 2021-12-07 | Rensselaer | New York | 36083 | 18229 | 199 |
1987488 | 1987488 | 2021-12-06 | Rensselaer | New York | 36083 | 18137 | 198 |
1984238 | 1984238 | 2021-12-05 | Rensselaer | New York | 36083 | 18059 | 197 |
1980988 | 1980988 | 2021-12-04 | Rensselaer | New York | 36083 | 17938 | 197 |
1977738 | 1977738 | 2021-12-03 | Rensselaer | New York | 36083 | 17811 | 197 |
1974488 | 1974488 | 2021-12-02 | Rensselaer | New York | 36083 | 17633 | 195 |
1971239 | 1971239 | 2021-12-01 | Rensselaer | New York | 36083 | 17502 | 193 |
1967989 | 1967989 | 2021-11-30 | Rensselaer | New York | 36083 | 17411 | 193 |
1964738 | 1964738 | 2021-11-29 | Rensselaer | New York | 36083 | 17336 | 192 |
1961486 | 1961486 | 2021-11-28 | Rensselaer | New York | 36083 | 17260 | 192 |
1958235 | 1958235 | 2021-11-27 | Rensselaer | New York | 36083 | 17188 | 192 |
1954984 | 1954984 | 2021-11-26 | Rensselaer | New York | 36083 | 17147 | 192 |
1951733 | 1951733 | 2021-11-25 | Rensselaer | New York | 36083 | 17067 | 192 |
1948482 | 1948482 | 2021-11-24 | Rensselaer | New York | 36083 | 16941 | 190 |
1945231 | 1945231 | 2021-11-23 | Rensselaer | New York | 36083 | 16851 | 190 |
1941980 | 1941980 | 2021-11-22 | Rensselaer | New York | 36083 | 16790 | 190 |
1938730 | 1938730 | 2021-11-21 | Rensselaer | New York | 36083 | 16716 | 189 |
1935480 | 1935480 | 2021-11-20 | Rensselaer | New York | 36083 | 16649 | 189 |
1932230 | 1932230 | 2021-11-19 | Rensselaer | New York | 36083 | 16540 | 189 |
1928979 | 1928979 | 2021-11-18 | Rensselaer | New York | 36083 | 16466 | 188 |
1925729 | 1925729 | 2021-11-17 | Rensselaer | New York | 36083 | 16342 | 188 |
1922480 | 1922480 | 2021-11-16 | Rensselaer | New York | 36083 | 16273 | 187 |
1919230 | 1919230 | 2021-11-15 | Rensselaer | New York | 36083 | 16240 | 186 |
1915980 | 1915980 | 2021-11-14 | Rensselaer | New York | 36083 | 16194 | 186 |
1912730 | 1912730 | 2021-11-13 | Rensselaer | New York | 36083 | 16144 | 186 |
1909480 | 1909480 | 2021-11-12 | Rensselaer | New York | 36083 | 16073 | 185 |
1906231 | 1906231 | 2021-11-11 | Rensselaer | New York | 36083 | 16003 | 184 |
1902982 | 1902982 | 2021-11-10 | Rensselaer | New York | 36083 | 15865 | 183 |
1899732 | 1899732 | 2021-11-09 | Rensselaer | New York | 36083 | 15809 | 181 |
1896482 | 1896482 | 2021-11-08 | Rensselaer | New York | 36083 | 15757 | 181 |
1893232 | 1893232 | 2021-11-07 | Rensselaer | New York | 36083 | 15702 | 180 |
1889982 | 1889982 | 2021-11-06 | Rensselaer | New York | 36083 | 15630 | 179 |
1886732 | 1886732 | 2021-11-05 | Rensselaer | New York | 36083 | 15562 | 178 |
1883483 | 1883483 | 2021-11-04 | Rensselaer | New York | 36083 | 15490 | 178 |
1880234 | 1880234 | 2021-11-03 | Rensselaer | New York | 36083 | 15432 | 175 |
1876985 | 1876985 | 2021-11-02 | Rensselaer | New York | 36083 | 15389 | 174 |
1873736 | 1873736 | 2021-11-01 | Rensselaer | New York | 36083 | 15339 | 173 |
1870487 | 1870487 | 2021-10-31 | Rensselaer | New York | 36083 | 15312 | 173 |
1867238 | 1867238 | 2021-10-30 | Rensselaer | New York | 36083 | 15274 | 172 |
1863989 | 1863989 | 2021-10-29 | Rensselaer | New York | 36083 | 15213 | 172 |
1860740 | 1860740 | 2021-10-28 | Rensselaer | New York | 36083 | 15127 | 172 |
1857491 | 1857491 | 2021-10-27 | Rensselaer | New York | 36083 | 15081 | 172 |
1854242 | 1854242 | 2021-10-26 | Rensselaer | New York | 36083 | 15024 | 171 |
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);