ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36019 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 641 ✖
- 101 10
- 152 10
- 95 9
- 97 9
- 127 9
- 4835 8
- 4858 8
- 154 7
- 94 5
- 98 5
- 100 5
- 4855 5
- 59 4
- 99 4
- 111 4
- 4839 4
- 4868 4
- 1 3
- 25 3
- 43 3
- 51 3
- 69 3
- 76 3
- 114 3
- 129 3
- 150 3
- 162 3
- 4824 3
- 4827 3
- 4833 3
- 4846 3
- 4 2
- 11 2
- 45 2
- 103 2
- 107 2
- 109 2
- 113 2
- 120 2
- 123 2
- 134 2
- 141 2
- 151 2
- 153 2
- 173 2
- 178 2
- 179 2
- 4762 2
- 4815 2
- 4830 2
- 4832 2
- 4836 2
- 4859 2
- 4867 2
- 9400 2
- 16337 2
- 18034 2
- 2 1
- 6 1
- 8 1
- 10 1
- 12 1
- 13 1
- 17 1
- 21 1
- 31 1
- 33 1
- 36 1
- 37 1
- 39 1
- 40 1
- 44 1
- 46 1
- 47 1
- 48 1
- 49 1
- 52 1
- 53 1
- 54 1
- 57 1
- 61 1
- 62 1
- 66 1
- 68 1
- 74 1
- 77 1
- 78 1
- 81 1
- 85 1
- 91 1
- 92 1
- 96 1
- 105 1
- 106 1
- 108 1
- 110 1
- 117 1
- 119 1
- 125 1
- 126 1
- 128 1
- 130 1
- 131 1
- 132 1
- 133 1
- 135 1
- 136 1
- 142 1
- 146 1
- 147 1
- 148 1
- 149 1
- 155 1
- 156 1
- 157 1
- 158 1
- 159 1
- 160 1
- 161 1
- 164 1
- 165 1
- 166 1
- 170 1
- 177 1
- 182 1
- 183 1
- 187 1
- 190 1
- 192 1
- 197 1
- 199 1
- 215 1
- 220 1
- 224 1
- 232 1
- 236 1
- 240 1
- 242 1
- 244 1
- 246 1
- 248 1
- 255 1
- 263 1
- 270 1
- 273 1
- 279 1
- 282 1
- 288 1
- 292 1
- 297 1
- 301 1
- 303 1
- 313 1
- 331 1
- 344 1
- 356 1
- 372 1
- 377 1
- 380 1
- 384 1
- 389 1
- 397 1
- 406 1
- 412 1
- 418 1
- 428 1
- 430 1
- 434 1
- 443 1
- 448 1
- 456 1
- 459 1
- 461 1
- 480 1
- 488 1
- 495 1
- 524 1
- 532 1
- 540 1
- 549 1
- 568 1
- 574 1
- 586 1
- 597 1
- 627 1
- 657 1
- 698 1
- 712 1
- 731 1
- 738 1
- 749 1
- 777 1
- 795 1
- 804 1
- 818 1
- 841 1
- 863 1
- 890 1
- 921 1
- 951 1
- 980 1
- 1028 1
- 1050 1
- 1075 1
- 1158 1
- 1210 1
- 1268 1
- 1312 1
- 1352 1
- 1405 1
- 1500 1
- 1556 1
- 1619 1
- 1681 1
- 1719 1
- 1793 1
- 1848 1
- 1900 1
- 1977 1
- 2040 1
- 2091 1
- 2129 1
- 2180 1
- 2209 1
- 2264 1
- 2317 1
- 2360 1
- 2424 1
- 2458 1
- 2505 1
- 2542 1
- 2583 1
- 2636 1
- 2670 1
- 2720 1
- 2749 1
- 2779 1
- 2799 1
- 2824 1
- 2856 1
- 2891 1
- 2928 1
- 2970 1
- 2999 1
- 3026 1
- 3103 1
- 3129 1
- 3161 1
- 3205 1
- 3239 1
- 3258 1
- 3278 1
- 3297 1
- 3352 1
- 3369 1
- 3390 1
- 3415 1
- 3452 1
- 3468 1
- 3507 1
- 3530 1
- 3558 1
- 3586 1
- 3610 1
- 3645 1
- 3682 1
- 3704 1
- 3741 1
- 3761 1
- 3788 1
- 3803 1
- 3830 1
- 3843 1
- 3854 1
- 3870 1
- 3882 1
- 3891 1
- 3900 1
- 3914 1
- 3936 1
- 3950 1
- 3962 1
- 3971 1
- 3987 1
- 4002 1
- 4031 1
- 4055 1
- 4061 1
- 4077 1
- 4111 1
- 4128 1
- 4155 1
- 4177 1
- 4187 1
- 4222 1
- 4230 1
- 4250 1
- 4274 1
- 4296 1
- 4319 1
- 4342 1
- 4364 1
- 4391 1
- 4417 1
- 4437 1
- 4441 1
- 4465 1
- 4472 1
- 4501 1
- 4511 1
- 4528 1
- 4550 1
- 4563 1
- 4577 1
- 4582 1
- 4591 1
- 4611 1
- 4633 1
- 4642 1
- 4654 1
- 4662 1
- 4666 1
- 4675 1
- 4683 1
- 4693 1
- 4701 1
- 4713 1
- 4720 1
- 4731 1
- 4744 1
- 4751 1
- 4757 1
- 4769 1
- 4773 1
- 4784 1
- 4789 1
- 4803 1
- 4807 1
- 4810 1
- 4811 1
- 4817 1
- 4818 1
- 4821 1
- 4826 1
- 4834 1
- 4837 1
- 4838 1
- 4841 1
- 4843 1
- 4845 1
- 4847 1
- 4856 1
- 4857 1
- 4861 1
- 4866 1
- 4869 1
- 4870 1
- 4873 1
- 4875 1
- 4878 1
- 4883 1
- 4885 1
- 4888 1
- 4891 1
- 4893 1
- 4895 1
- 4901 1
- 4911 1
- 4916 1
- 4920 1
- 4923 1
- 4926 1
- 4934 1
- 4936 1
- 4944 1
- 4948 1
- 4952 1
- 4953 1
- 4955 1
- 4962 1
- 4967 1
- 4970 1
- 4979 1
- 4990 1
- 4992 1
- 4995 1
- 5017 1
- 5023 1
- 5051 1
- 5065 1
- 5082 1
- 5091 1
- 5097 1
- 5108 1
- 5131 1
- 5150 1
- 5173 1
- 5194 1
- 5204 1
- 5214 1
- 5229 1
- 5260 1
- 5295 1
- 5329 1
- 5351 1
- 5359 1
- 5387 1
- 5431 1
- 5464 1
- 5529 1
- 5585 1
- 5615 1
- 5655 1
- 5674 1
- 5716 1
- 5774 1
- 5830 1
- 5866 1
- 5915 1
- 5937 1
- 5980 1
- 6025 1
- 6071 1
- 6126 1
- 6163 1
- 6193 1
- 6223 1
- 6255 1
- 6288 1
- 6339 1
- 6386 1
- 6396 1
- 6455 1
- 6480 1
- 6507 1
- 6530 1
- 6561 1
- 6603 1
- 6631 1
- 6654 1
- 6665 1
- 6679 1
- 6725 1
- 6750 1
- 6787 1
- 6807 1
- 6837 1
- 6853 1
- 6880 1
- 6909 1
- 6962 1
- 6994 1
- 7029 1
- 7052 1
- 7063 1
- 7095 1
- 7134 1
- 7175 1
- 7217 1
- 7239 1
- 7300 1
- 7330 1
- 7358 1
- 7401 1
- 7447 1
- 7487 1
- 7507 1
- 7537 1
- 7565 1
- 7582 1
- 7640 1
- 7684 1
- 7727 1
- 7772 1
- 7806 1
- 7827 1
- 7853 1
- 7904 1
- 7953 1
- 7980 1
- 8017 1
- 8063 1
- 8099 1
- 8146 1
- 8218 1
- 8279 1
- 8349 1
- 8408 1
- 8441 1
- 8469 1
- 8503 1
- 8567 1
- 8619 1
- 8676 1
- 8746 1
- 8785 1
- 8809 1
- 8847 1
- 8917 1
- 8969 1
- 9046 1
- 9109 1
- 9152 1
- 9204 1
- 9240 1
- 9333 1
- 9519 1
- 9533 1
- 9568 1
- 9615 1
- 9744 1
- 9900 1
- 10057 1
- 10170 1
- 10259 1
- 10294 1
- 10404 1
- 10640 1
- 10889 1
- 11178 1
- 11401 1
- 11655 1
- 11771 1
- 11909 1
- 12130 1
- 12432 1
- 12662 1
- 12883 1
- 13010 1
- 13116 1
- 13227 1
- 13315 1
- 13570 1
- 13733 1
- 13881 1
- 13968 1
- 14094 1
- 14189 1
- 14338 1
- 14543 1
- 14672 1
- 14776 1
- 14853 1
- 14918 1
- 15012 1
- 15134 1
- 15242 1
- 15327 1
- 15371 1
- 15424 1
- 15451 1
- 15500 1
- 15581 1
- 15677 1
- 15758 1
- 15813 1
- 15859 1
- 15882 1
- 15914 1
- 15981 1
- 16034 1
- 16066 1
- 16100 1
- 16122 1
- 16141 1
- 16161 1
- 16195 1
- 16223 1
- 16242 1
- 16260 1
- 16276 1
- 16289 1
- 16305 1
- 16368 1
- 16389 1
- 16405 1
- 16417 1
- 16422 1
- 16434 1
- 16460 1
- 16467 1
- 16479 1
- 16485 1
- 16489 1
- 16501 1
- 16511 1
- 16531 1
- 16546 1
- 16552 1
- 16558 1
- 16562 1
- 16574 1
- 16602 1
- 16628 1
- 16641 1
- 16655 1
- 16665 1
- 16668 1
- 16682 1
- 16700 1
- 16717 1
- 16732 1
- 16745 1
- 16757 1
- 16775 1
- 16791 1
- 16825 1
- 16860 1
- 16893 1
- 16920 1
- 16941 1
- 16952 1
- 16976 1
- 16992 1
- 17032 1
- 17073 1
- 17109 1
- 17142 1
- 17156 1
- 17173 1
- 17222 1
- 17259 1
- 17289 1
- 17322 1
- 17348 1
- 17373 1
- 17407 1
- 17457 1
- 17528 1
- 17567 1
- 17602 1
- 17630 1
- 17649 1
- 17671 1
- 17736 1
- 17777 1
- 17832 1
- 17888 1
- 17912 1
- 17948 1
- 17976 1
state 1
- New York 788
fips 1
- 36019 · 788 ✖
county 1
- Clinton 788
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3541 | 3541 | 2020-03-17 | Clinton | New York | 36019 | 1 | 0 |
4138 | 4138 | 2020-03-18 | Clinton | New York | 36019 | 1 | 0 |
4867 | 4867 | 2020-03-19 | Clinton | New York | 36019 | 1 | 0 |
5713 | 5713 | 2020-03-20 | Clinton | New York | 36019 | 2 | 0 |
6707 | 6707 | 2020-03-21 | Clinton | New York | 36019 | 4 | 0 |
7800 | 7800 | 2020-03-22 | Clinton | New York | 36019 | 4 | 0 |
8998 | 8998 | 2020-03-23 | Clinton | New York | 36019 | 6 | 0 |
10305 | 10305 | 2020-03-24 | Clinton | New York | 36019 | 8 | 0 |
11740 | 11740 | 2020-03-25 | Clinton | New York | 36019 | 10 | 0 |
13343 | 13343 | 2020-03-26 | Clinton | New York | 36019 | 11 | 0 |
15077 | 15077 | 2020-03-27 | Clinton | New York | 36019 | 11 | 0 |
16907 | 16907 | 2020-03-28 | Clinton | New York | 36019 | 12 | 0 |
18831 | 18831 | 2020-03-29 | Clinton | New York | 36019 | 13 | 0 |
20870 | 20870 | 2020-03-30 | Clinton | New York | 36019 | 17 | 0 |
22993 | 22993 | 2020-03-31 | Clinton | New York | 36019 | 21 | 0 |
25187 | 25187 | 2020-04-01 | Clinton | New York | 36019 | 25 | 0 |
27447 | 27447 | 2020-04-02 | Clinton | New York | 36019 | 25 | 0 |
29771 | 29771 | 2020-04-03 | Clinton | New York | 36019 | 25 | 0 |
32157 | 32157 | 2020-04-04 | Clinton | New York | 36019 | 31 | 0 |
34588 | 34588 | 2020-04-05 | Clinton | New York | 36019 | 33 | 0 |
37058 | 37058 | 2020-04-06 | Clinton | New York | 36019 | 36 | 0 |
39573 | 39573 | 2020-04-07 | Clinton | New York | 36019 | 37 | 0 |
42130 | 42130 | 2020-04-08 | Clinton | New York | 36019 | 39 | 0 |
44713 | 44713 | 2020-04-09 | Clinton | New York | 36019 | 40 | 0 |
47326 | 47326 | 2020-04-10 | Clinton | New York | 36019 | 43 | 0 |
49981 | 49981 | 2020-04-11 | Clinton | New York | 36019 | 43 | 0 |
52654 | 52654 | 2020-04-12 | Clinton | New York | 36019 | 43 | 2 |
55337 | 55337 | 2020-04-13 | Clinton | New York | 36019 | 44 | 3 |
58037 | 58037 | 2020-04-14 | Clinton | New York | 36019 | 45 | 3 |
60751 | 60751 | 2020-04-15 | Clinton | New York | 36019 | 45 | 3 |
63477 | 63477 | 2020-04-16 | Clinton | New York | 36019 | 46 | 3 |
66219 | 66219 | 2020-04-17 | Clinton | New York | 36019 | 47 | 3 |
68976 | 68976 | 2020-04-18 | Clinton | New York | 36019 | 48 | 3 |
71743 | 71743 | 2020-04-19 | Clinton | New York | 36019 | 49 | 3 |
74518 | 74518 | 2020-04-20 | Clinton | New York | 36019 | 51 | 3 |
77299 | 77299 | 2020-04-21 | Clinton | New York | 36019 | 51 | 3 |
80088 | 80088 | 2020-04-22 | Clinton | New York | 36019 | 51 | 3 |
82887 | 82887 | 2020-04-23 | Clinton | New York | 36019 | 52 | 4 |
85691 | 85691 | 2020-04-24 | Clinton | New York | 36019 | 53 | 4 |
88503 | 88503 | 2020-04-25 | Clinton | New York | 36019 | 54 | 4 |
91318 | 91318 | 2020-04-26 | Clinton | New York | 36019 | 57 | 4 |
94143 | 94143 | 2020-04-27 | Clinton | New York | 36019 | 59 | 4 |
96979 | 96979 | 2020-04-28 | Clinton | New York | 36019 | 59 | 4 |
99826 | 99826 | 2020-04-29 | Clinton | New York | 36019 | 59 | 4 |
102679 | 102679 | 2020-04-30 | Clinton | New York | 36019 | 59 | 4 |
105541 | 105541 | 2020-05-01 | Clinton | New York | 36019 | 61 | 4 |
108408 | 108408 | 2020-05-02 | Clinton | New York | 36019 | 62 | 4 |
111281 | 111281 | 2020-05-03 | Clinton | New York | 36019 | 66 | 4 |
114162 | 114162 | 2020-05-04 | Clinton | New York | 36019 | 68 | 4 |
117042 | 117042 | 2020-05-05 | Clinton | New York | 36019 | 69 | 4 |
120003 | 120003 | 2020-05-06 | Clinton | New York | 36019 | 69 | 4 |
122978 | 122978 | 2020-05-07 | Clinton | New York | 36019 | 69 | 4 |
125961 | 125961 | 2020-05-08 | Clinton | New York | 36019 | 74 | 4 |
128950 | 128950 | 2020-05-09 | Clinton | New York | 36019 | 76 | 4 |
131939 | 131939 | 2020-05-10 | Clinton | New York | 36019 | 76 | 4 |
134930 | 134930 | 2020-05-11 | Clinton | New York | 36019 | 76 | 4 |
137920 | 137920 | 2020-05-12 | Clinton | New York | 36019 | 77 | 4 |
140916 | 140916 | 2020-05-13 | Clinton | New York | 36019 | 78 | 4 |
143911 | 143911 | 2020-05-14 | Clinton | New York | 36019 | 81 | 4 |
146912 | 146912 | 2020-05-15 | Clinton | New York | 36019 | 85 | 4 |
149919 | 149919 | 2020-05-16 | Clinton | New York | 36019 | 91 | 4 |
152929 | 152929 | 2020-05-17 | Clinton | New York | 36019 | 92 | 4 |
155946 | 155946 | 2020-05-18 | Clinton | New York | 36019 | 94 | 4 |
158964 | 158964 | 2020-05-19 | Clinton | New York | 36019 | 94 | 4 |
161991 | 161991 | 2020-05-20 | Clinton | New York | 36019 | 94 | 4 |
165020 | 165020 | 2020-05-21 | Clinton | New York | 36019 | 94 | 4 |
168055 | 168055 | 2020-05-22 | Clinton | New York | 36019 | 94 | 4 |
171094 | 171094 | 2020-05-23 | Clinton | New York | 36019 | 95 | 4 |
174136 | 174136 | 2020-05-24 | Clinton | New York | 36019 | 95 | 4 |
177180 | 177180 | 2020-05-25 | Clinton | New York | 36019 | 95 | 4 |
180223 | 180223 | 2020-05-26 | Clinton | New York | 36019 | 95 | 4 |
183271 | 183271 | 2020-05-27 | Clinton | New York | 36019 | 95 | 4 |
186328 | 186328 | 2020-05-28 | Clinton | New York | 36019 | 95 | 4 |
189388 | 189388 | 2020-05-29 | Clinton | New York | 36019 | 95 | 4 |
192452 | 192452 | 2020-05-30 | Clinton | New York | 36019 | 95 | 4 |
195522 | 195522 | 2020-05-31 | Clinton | New York | 36019 | 95 | 4 |
198595 | 198595 | 2020-06-01 | Clinton | New York | 36019 | 96 | 4 |
201669 | 201669 | 2020-06-02 | Clinton | New York | 36019 | 97 | 4 |
204746 | 204746 | 2020-06-03 | Clinton | New York | 36019 | 97 | 4 |
207827 | 207827 | 2020-06-04 | Clinton | New York | 36019 | 97 | 4 |
210909 | 210909 | 2020-06-05 | Clinton | New York | 36019 | 97 | 4 |
213993 | 213993 | 2020-06-06 | Clinton | New York | 36019 | 97 | 4 |
217083 | 217083 | 2020-06-07 | Clinton | New York | 36019 | 97 | 4 |
220175 | 220175 | 2020-06-08 | Clinton | New York | 36019 | 97 | 4 |
223269 | 223269 | 2020-06-09 | Clinton | New York | 36019 | 97 | 4 |
226369 | 226369 | 2020-06-10 | Clinton | New York | 36019 | 97 | 4 |
229473 | 229473 | 2020-06-11 | Clinton | New York | 36019 | 98 | 4 |
232578 | 232578 | 2020-06-12 | Clinton | New York | 36019 | 98 | 4 |
235683 | 235683 | 2020-06-13 | Clinton | New York | 36019 | 98 | 4 |
238791 | 238791 | 2020-06-14 | Clinton | New York | 36019 | 98 | 4 |
241900 | 241900 | 2020-06-15 | Clinton | New York | 36019 | 98 | 4 |
245012 | 245012 | 2020-06-16 | Clinton | New York | 36019 | 99 | 4 |
248125 | 248125 | 2020-06-17 | Clinton | New York | 36019 | 99 | 4 |
251240 | 251240 | 2020-06-18 | Clinton | New York | 36019 | 99 | 4 |
254355 | 254355 | 2020-06-19 | Clinton | New York | 36019 | 99 | 4 |
257478 | 257478 | 2020-06-20 | Clinton | New York | 36019 | 100 | 4 |
260605 | 260605 | 2020-06-21 | Clinton | New York | 36019 | 100 | 4 |
263733 | 263733 | 2020-06-22 | Clinton | New York | 36019 | 100 | 4 |
266861 | 266861 | 2020-06-23 | Clinton | New York | 36019 | 100 | 4 |
269995 | 269995 | 2020-06-24 | Clinton | New York | 36019 | 100 | 4 |
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);