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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 760 ✖
- 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
- 30875 2
- 33850 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
- 29695 1
- 29820 1
- 29900 1
- 30021 1
- 30058 1
- 30099 1
- 30148 1
- 30206 1
- 30250 1
- 30275 1
- 30352 1
- 30375 1
- 30406 1
- 30439 1
- 30476 1
- 30506 1
- 30601 1
- 30623 1
- 30637 1
- 30652 1
- 30670 1
- 30703 1
- 30725 1
- 30789 1
- 30802 1
- 30812 1
- 30822 1
- 30851 1
- 30904 1
- 30946 1
- 30960 1
- 30968 1
- 30977 1
- 30989 1
- 31008 1
- 31026 1
- 31035 1
- 31038 1
- 31047 1
- 31060 1
- 31072 1
- 31079 1
- 31093 1
- 31115 1
- 31124 1
- 31130 1
- 31145 1
- 31155 1
- 31177 1
- 31201 1
- 31210 1
- 31219 1
- 31230 1
- 31274 1
- 31291 1
- 31313 1
- 31345 1
- 31395 1
- 31408 1
- 31420 1
- 31457 1
- 31492 1
- 31526 1
- 31559 1
- 31650 1
- 31674 1
- 31704 1
- 31740 1
- 31779 1
- 31836 1
- 31883 1
- 32000 1
- 32026 1
- 32062 1
- 32105 1
- 32184 1
- 32255 1
- 32316 1
- 32417 1
- 32463 1
- 32509 1
- 32574 1
- 32679 1
- 32774 1
- 32822 1
- 32971 1
- 33010 1
- 33059 1
- 33134 1
- 33241 1
- 33325 1
- 33414 1
- 33522 1
- 33567 1
- 33625 1
- 33730 1
state 1
- New York 788
fips 1
- 36083 788
county 1
- Rensselaer · 788 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
3555 | 3555 | 2020-03-17 | Rensselaer | New York | 36083 | 1 | 0 |
4156 | 4156 | 2020-03-18 | Rensselaer | New York | 36083 | 4 | 0 |
4885 | 4885 | 2020-03-19 | Rensselaer | New York | 36083 | 4 | 0 |
5736 | 5736 | 2020-03-20 | Rensselaer | New York | 36083 | 8 | 0 |
6730 | 6730 | 2020-03-21 | Rensselaer | New York | 36083 | 20 | 0 |
7825 | 7825 | 2020-03-22 | Rensselaer | New York | 36083 | 26 | 0 |
9025 | 9025 | 2020-03-23 | Rensselaer | New York | 36083 | 29 | 0 |
10333 | 10333 | 2020-03-24 | Rensselaer | New York | 36083 | 30 | 0 |
11769 | 11769 | 2020-03-25 | Rensselaer | New York | 36083 | 31 | 0 |
13372 | 13372 | 2020-03-26 | Rensselaer | New York | 36083 | 32 | 0 |
15106 | 15106 | 2020-03-27 | Rensselaer | New York | 36083 | 35 | 0 |
16936 | 16936 | 2020-03-28 | Rensselaer | New York | 36083 | 38 | 0 |
18861 | 18861 | 2020-03-29 | Rensselaer | New York | 36083 | 39 | 0 |
20900 | 20900 | 2020-03-30 | Rensselaer | New York | 36083 | 40 | 0 |
23023 | 23023 | 2020-03-31 | Rensselaer | New York | 36083 | 55 | 0 |
25217 | 25217 | 2020-04-01 | Rensselaer | New York | 36083 | 60 | 0 |
27477 | 27477 | 2020-04-02 | Rensselaer | New York | 36083 | 67 | 1 |
29801 | 29801 | 2020-04-03 | Rensselaer | New York | 36083 | 71 | 1 |
32187 | 32187 | 2020-04-04 | Rensselaer | New York | 36083 | 73 | 1 |
34618 | 34618 | 2020-04-05 | Rensselaer | New York | 36083 | 74 | 1 |
37088 | 37088 | 2020-04-06 | Rensselaer | New York | 36083 | 78 | 1 |
39603 | 39603 | 2020-04-07 | Rensselaer | New York | 36083 | 91 | 3 |
42160 | 42160 | 2020-04-08 | Rensselaer | New York | 36083 | 91 | 1 |
44743 | 44743 | 2020-04-09 | Rensselaer | New York | 36083 | 79 | 3 |
47356 | 47356 | 2020-04-10 | Rensselaer | New York | 36083 | 91 | 4 |
50011 | 50011 | 2020-04-11 | Rensselaer | New York | 36083 | 96 | 4 |
52684 | 52684 | 2020-04-12 | Rensselaer | New York | 36083 | 105 | 6 |
55367 | 55367 | 2020-04-13 | Rensselaer | New York | 36083 | 113 | 6 |
58067 | 58067 | 2020-04-14 | Rensselaer | New York | 36083 | 120 | 7 |
60781 | 60781 | 2020-04-15 | Rensselaer | New York | 36083 | 124 | 8 |
63507 | 63507 | 2020-04-16 | Rensselaer | New York | 36083 | 137 | 9 |
66249 | 66249 | 2020-04-17 | Rensselaer | New York | 36083 | 150 | 9 |
69006 | 69006 | 2020-04-18 | Rensselaer | New York | 36083 | 164 | 9 |
71773 | 71773 | 2020-04-19 | Rensselaer | New York | 36083 | 173 | 10 |
74548 | 74548 | 2020-04-20 | Rensselaer | New York | 36083 | 177 | 10 |
77329 | 77329 | 2020-04-21 | Rensselaer | New York | 36083 | 183 | 11 |
80118 | 80118 | 2020-04-22 | Rensselaer | New York | 36083 | 186 | 11 |
82917 | 82917 | 2020-04-23 | Rensselaer | New York | 36083 | 191 | 12 |
85721 | 85721 | 2020-04-24 | Rensselaer | New York | 36083 | 198 | 12 |
88533 | 88533 | 2020-04-25 | Rensselaer | New York | 36083 | 221 | 12 |
91348 | 91348 | 2020-04-26 | Rensselaer | New York | 36083 | 242 | 13 |
94173 | 94173 | 2020-04-27 | Rensselaer | New York | 36083 | 246 | 17 |
97009 | 97009 | 2020-04-28 | Rensselaer | New York | 36083 | 250 | 17 |
99856 | 99856 | 2020-04-29 | Rensselaer | New York | 36083 | 262 | 17 |
102709 | 102709 | 2020-04-30 | Rensselaer | New York | 36083 | 287 | 20 |
105571 | 105571 | 2020-05-01 | Rensselaer | New York | 36083 | 298 | 20 |
108438 | 108438 | 2020-05-02 | Rensselaer | New York | 36083 | 311 | 21 |
111311 | 111311 | 2020-05-03 | Rensselaer | New York | 36083 | 322 | 23 |
114192 | 114192 | 2020-05-04 | Rensselaer | New York | 36083 | 337 | 23 |
117072 | 117072 | 2020-05-05 | Rensselaer | New York | 36083 | 339 | 23 |
120033 | 120033 | 2020-05-06 | Rensselaer | New York | 36083 | 347 | 28 |
123008 | 123008 | 2020-05-07 | Rensselaer | New York | 36083 | 367 | 28 |
125991 | 125991 | 2020-05-08 | Rensselaer | New York | 36083 | 380 | 28 |
128980 | 128980 | 2020-05-09 | Rensselaer | New York | 36083 | 407 | 29 |
131969 | 131969 | 2020-05-10 | Rensselaer | New York | 36083 | 409 | 29 |
134960 | 134960 | 2020-05-11 | Rensselaer | New York | 36083 | 411 | 30 |
137950 | 137950 | 2020-05-12 | Rensselaer | New York | 36083 | 416 | 30 |
140946 | 140946 | 2020-05-13 | Rensselaer | New York | 36083 | 420 | 30 |
143941 | 143941 | 2020-05-14 | Rensselaer | New York | 36083 | 423 | 30 |
146942 | 146942 | 2020-05-15 | Rensselaer | New York | 36083 | 428 | 30 |
149949 | 149949 | 2020-05-16 | Rensselaer | New York | 36083 | 438 | 30 |
152959 | 152959 | 2020-05-17 | Rensselaer | New York | 36083 | 439 | 32 |
155976 | 155976 | 2020-05-18 | Rensselaer | New York | 36083 | 444 | 32 |
158994 | 158994 | 2020-05-19 | Rensselaer | New York | 36083 | 444 | 32 |
162021 | 162021 | 2020-05-20 | Rensselaer | New York | 36083 | 453 | 32 |
165050 | 165050 | 2020-05-21 | Rensselaer | New York | 36083 | 456 | 32 |
168085 | 168085 | 2020-05-22 | Rensselaer | New York | 36083 | 460 | 32 |
171124 | 171124 | 2020-05-23 | Rensselaer | New York | 36083 | 463 | 32 |
174166 | 174166 | 2020-05-24 | Rensselaer | New York | 36083 | 463 | 32 |
177210 | 177210 | 2020-05-25 | Rensselaer | New York | 36083 | 465 | 32 |
180253 | 180253 | 2020-05-26 | Rensselaer | New York | 36083 | 466 | 32 |
183301 | 183301 | 2020-05-27 | Rensselaer | New York | 36083 | 466 | 32 |
186358 | 186358 | 2020-05-28 | Rensselaer | New York | 36083 | 469 | 32 |
189418 | 189418 | 2020-05-29 | Rensselaer | New York | 36083 | 478 | 32 |
192482 | 192482 | 2020-05-30 | Rensselaer | New York | 36083 | 486 | 32 |
195552 | 195552 | 2020-05-31 | Rensselaer | New York | 36083 | 491 | 32 |
198625 | 198625 | 2020-06-01 | Rensselaer | New York | 36083 | 492 | 32 |
201699 | 201699 | 2020-06-02 | Rensselaer | New York | 36083 | 493 | 32 |
204776 | 204776 | 2020-06-03 | Rensselaer | New York | 36083 | 495 | 32 |
207857 | 207857 | 2020-06-04 | Rensselaer | New York | 36083 | 495 | 32 |
210939 | 210939 | 2020-06-05 | Rensselaer | New York | 36083 | 497 | 32 |
214023 | 214023 | 2020-06-06 | Rensselaer | New York | 36083 | 499 | 32 |
217113 | 217113 | 2020-06-07 | Rensselaer | New York | 36083 | 502 | 32 |
220205 | 220205 | 2020-06-08 | Rensselaer | New York | 36083 | 503 | 32 |
223299 | 223299 | 2020-06-09 | Rensselaer | New York | 36083 | 505 | 32 |
226399 | 226399 | 2020-06-10 | Rensselaer | New York | 36083 | 507 | 33 |
229503 | 229503 | 2020-06-11 | Rensselaer | New York | 36083 | 508 | 33 |
232608 | 232608 | 2020-06-12 | Rensselaer | New York | 36083 | 510 | 33 |
235713 | 235713 | 2020-06-13 | Rensselaer | New York | 36083 | 511 | 34 |
238821 | 238821 | 2020-06-14 | Rensselaer | New York | 36083 | 513 | 34 |
241930 | 241930 | 2020-06-15 | Rensselaer | New York | 36083 | 514 | 34 |
245042 | 245042 | 2020-06-16 | Rensselaer | New York | 36083 | 514 | 34 |
248155 | 248155 | 2020-06-17 | Rensselaer | New York | 36083 | 515 | 37 |
251270 | 251270 | 2020-06-18 | Rensselaer | New York | 36083 | 515 | 36 |
254385 | 254385 | 2020-06-19 | Rensselaer | New York | 36083 | 519 | 36 |
257508 | 257508 | 2020-06-20 | Rensselaer | New York | 36083 | 521 | 37 |
260635 | 260635 | 2020-06-21 | Rensselaer | New York | 36083 | 524 | 37 |
263763 | 263763 | 2020-06-22 | Rensselaer | New York | 36083 | 528 | 37 |
266891 | 266891 | 2020-06-23 | Rensselaer | New York | 36083 | 533 | 37 |
270025 | 270025 | 2020-06-24 | Rensselaer | New York | 36083 | 534 | 37 |
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);