ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 17027 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 607 ✖
- 3 7
- 5789 6
- 5787 5
- 7379 5
- 5798 4
- 5807 4
- 6580 4
- 7017 4
- 7976 4
- 8266 4
- 10171 4
- 11650 4
- 11764 4
- 5 3
- 8 3
- 186 3
- 193 3
- 224 3
- 5571 3
- 5603 3
- 5678 3
- 5689 3
- 5751 3
- 5766 3
- 5775 3
- 5777 3
- 5782 3
- 5793 3
- 5831 3
- 5858 3
- 5942 3
- 6031 3
- 6171 3
- 6271 3
- 6418 3
- 6674 3
- 6764 3
- 6837 3
- 6902 3
- 7095 3
- 7136 3
- 7168 3
- 7223 3
- 7278 3
- 7338 3
- 7518 3
- 7687 3
- 7822 3
- 9146 3
- 10879 3
- 11301 3
- 11515 3
- 11801 3
- 11821 3
- 11851 3
- 11864 3
- 11892 3
- 11952 3
- 11965 3
- 11969 3
- 11981 3
- 12000 3
- 12023 3
- 1 2
- 6 2
- 10 2
- 11 2
- 37 2
- 38 2
- 39 2
- 45 2
- 110 2
- 126 2
- 161 2
- 176 2
- 178 2
- 188 2
- 220 2
- 236 2
- 242 2
- 244 2
- 246 2
- 1877 2
- 4485 2
- 5581 2
- 5583 2
- 5661 2
- 5696 2
- 5721 2
- 5726 2
- 5732 2
- 5776 2
- 5778 2
- 5783 2
- 7264 2
- 11480 2
- 11966 2
- 11968 2
- 11971 2
- 12009 2
- 2 1
- 4 1
- 7 1
- 13 1
- 31 1
- 32 1
- 42 1
- 44 1
- 46 1
- 49 1
- 51 1
- 73 1
- 82 1
- 84 1
- 85 1
- 90 1
- 101 1
- 106 1
- 112 1
- 114 1
- 115 1
- 116 1
- 122 1
- 125 1
- 127 1
- 128 1
- 142 1
- 155 1
- 159 1
- 162 1
- 165 1
- 167 1
- 169 1
- 173 1
- 177 1
- 180 1
- 181 1
- 189 1
- 190 1
- 196 1
- 197 1
- 198 1
- 203 1
- 207 1
- 209 1
- 213 1
- 214 1
- 216 1
- 223 1
- 225 1
- 226 1
- 229 1
- 231 1
- 233 1
- 237 1
- 239 1
- 240 1
- 241 1
- 243 1
- 245 1
- 247 1
- 252 1
- 256 1
- 260 1
- 264 1
- 267 1
- 268 1
- 271 1
- 273 1
- 278 1
- 288 1
- 292 1
- 294 1
- 298 1
- 306 1
- 311 1
- 319 1
- 321 1
- 330 1
- 333 1
- 338 1
- 349 1
- 353 1
- 366 1
- 378 1
- 387 1
- 396 1
- 407 1
- 411 1
- 415 1
- 419 1
- 433 1
- 454 1
- 468 1
- 485 1
- 492 1
- 512 1
- 524 1
- 548 1
- 553 1
- 574 1
- 582 1
- 606 1
- 632 1
- 647 1
- 667 1
- 670 1
- 691 1
- 692 1
- 715 1
- 740 1
- 765 1
- 771 1
- 809 1
- 832 1
- 842 1
- 857 1
- 869 1
- 884 1
- 902 1
- 922 1
- 936 1
- 950 1
- 961 1
- 971 1
- 987 1
- 1004 1
- 1022 1
- 1051 1
- 1064 1
- 1071 1
- 1084 1
- 1088 1
- 1101 1
- 1129 1
- 1153 1
- 1169 1
- 1190 1
- 1203 1
- 1222 1
- 1239 1
- 1261 1
- 1279 1
- 1297 1
- 1309 1
- 1319 1
- 1338 1
- 1355 1
- 1377 1
- 1400 1
- 1411 1
- 1430 1
- 1438 1
- 1452 1
- 1480 1
- 1515 1
- 1541 1
- 1560 1
- 1587 1
- 1631 1
- 1663 1
- 1687 1
- 1709 1
- 1733 1
- 1755 1
- 1789 1
- 1811 1
- 1828 1
- 1856 1
- 1919 1
- 1936 1
- 1966 1
- 1988 1
- 2031 1
- 2100 1
- 2142 1
- 2164 1
- 2207 1
- 2294 1
- 2368 1
- 2392 1
- 2453 1
- 2512 1
- 2542 1
- 2579 1
- 2647 1
- 2727 1
- 2784 1
- 2875 1
- 2910 1
- 2943 1
- 2984 1
- 3035 1
- 3109 1
- 3235 1
- 3247 1
- 3279 1
- 3308 1
- 3337 1
- 3380 1
- 3453 1
- 3491 1
- 3557 1
- 3584 1
- 3617 1
- 3649 1
- 3684 1
- 3751 1
- 3796 1
- 3854 1
- 3878 1
- 3908 1
- 3926 1
- 3979 1
- 4040 1
- 4070 1
- 4117 1
- 4133 1
- 4156 1
- 4175 1
- 4209 1
- 4267 1
- 4307 1
- 4322 1
- 4328 1
- 4342 1
- 4352 1
- 4381 1
- 4420 1
- 4531 1
- 4547 1
- 4573 1
- 4600 1
- 4663 1
- 4695 1
- 4754 1
- 4777 1
- 4790 1
- 4813 1
- 4831 1
- 4885 1
- 4910 1
- 4953 1
- 4979 1
- 4989 1
- 5006 1
- 5032 1
- 5082 1
- 5107 1
- 5145 1
- 5162 1
- 5174 1
- 5188 1
- 5208 1
- 5247 1
- 5265 1
- 5289 1
- 5305 1
- 5318 1
- 5325 1
- 5349 1
- 5372 1
- 5407 1
- 5428 1
- 5449 1
- 5456 1
- 5462 1
- 5474 1
- 5500 1
- 5507 1
- 5515 1
- 5517 1
- 5520 1
- 5522 1
- 5525 1
- 5527 1
- 5528 1
- 5537 1
- 5540 1
- 5544 1
- 5548 1
- 5551 1
- 5556 1
- 5563 1
- 5566 1
- 5575 1
- 5578 1
- 5579 1
- 5582 1
- 5596 1
- 5598 1
- 5604 1
- 5608 1
- 5626 1
- 5633 1
- 5638 1
- 5642 1
- 5646 1
- 5647 1
- 5654 1
- 5657 1
- 5658 1
- 5663 1
- 5664 1
- 5667 1
- 5672 1
- 5674 1
- 5676 1
- 5677 1
- 5680 1
- 5682 1
- 5687 1
- 5691 1
- 5693 1
- 5698 1
- 5702 1
- 5703 1
- 5705 1
- 5708 1
- 5718 1
- 5722 1
- 5731 1
- 5735 1
- 5737 1
- 5739 1
- 5741 1
- 5744 1
- 5746 1
- 5748 1
- 5754 1
- 5755 1
- 5757 1
- 5760 1
- 5761 1
- 5763 1
- 5765 1
- 5768 1
- 5769 1
- 5770 1
- 5772 1
- 5774 1
- 5781 1
- 5784 1
- 5788 1
- 5790 1
- 5794 1
- 5795 1
- 5796 1
- 5797 1
- 5801 1
- 5803 1
- 5814 1
- 5816 1
- 5817 1
- 5821 1
- 5838 1
- 5842 1
- 5844 1
- 5852 1
- 5889 1
- 5906 1
- 5919 1
- 5928 1
- 5965 1
- 5983 1
- 6001 1
- 6021 1
- 6065 1
- 6096 1
- 6124 1
- 6146 1
- 6204 1
- 6224 1
- 6242 1
- 6253 1
- 6304 1
- 6323 1
- 6355 1
- 6375 1
- 6470 1
- 6500 1
- 6533 1
- 6545 1
- 6621 1
- 6641 1
- 6660 1
- 6702 1
- 6719 1
- 6735 1
- 6746 1
- 6783 1
- 6805 1
- 6814 1
- 6820 1
- 6849 1
- 6865 1
- 6873 1
- 6883 1
- 6936 1
- 6948 1
- 6958 1
- 6980 1
- 7036 1
- 7060 1
- 7080 1
- 7113 1
- 7115 1
- 7124 1
- 7129 1
- 7143 1
- 7149 1
- 7152 1
- 7158 1
- 7180 1
- 7185 1
- 7191 1
- 7210 1
- 7238 1
- 7255 1
- 7296 1
- 7316 1
- 7324 1
- 7328 1
- 7349 1
- 7368 1
- 7414 1
- 7451 1
- 7472 1
- 7485 1
- 7560 1
- 7596 1
- 7639 1
- 7662 1
- 7726 1
- 7756 1
- 7780 1
- 7794 1
- 7872 1
- 7913 1
- 7937 1
- 8048 1
- 8115 1
- 8155 1
- 8453 1
- 8680 1
- 8840 1
- 9021 1
- 9492 1
- 9692 1
- 9817 1
- 10035 1
- 10480 1
- 10639 1
- 10770 1
- 11046 1
- 11130 1
- 11194 1
- 11247 1
- 11387 1
- 11450 1
- 11569 1
- 11600 1
- 11623 1
- 11696 1
- 11735 1
- 11738 1
- 11751 1
- 11783 1
- 11790 1
- 11799 1
- 11810 1
- 11814 1
- 11816 1
- 11817 1
- 11834 1
- 11840 1
- 11844 1
- 11849 1
- 11856 1
- 11858 1
- 11862 1
- 11863 1
- 11866 1
- 11868 1
- 11883 1
- 11887 1
- 11901 1
- 11904 1
- 11941 1
- 11947 1
- 11957 1
- 11960 1
- 11961 1
- 11964 1
- 11974 1
- 11978 1
- 11988 1
- 11992 1
- 11995 1
- 11998 1
- 12007 1
- 12010 1
- 12028 1
- 12037 1
- 12043 1
- 12053 1
- 12066 1
state 1
- Illinois 790
fips 1
- 17027 · 790 ✖
county 1
- Clinton 790
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2430 | 2430 | 2020-03-15 | Clinton | Illinois | 17027 | 1 | 0 |
2871 | 2871 | 2020-03-16 | Clinton | Illinois | 17027 | 1 | 0 |
3360 | 3360 | 2020-03-17 | Clinton | Illinois | 17027 | 2 | 0 |
3923 | 3923 | 2020-03-18 | Clinton | Illinois | 17027 | 3 | 0 |
4599 | 4599 | 2020-03-19 | Clinton | Illinois | 17027 | 3 | 0 |
5404 | 5404 | 2020-03-20 | Clinton | Illinois | 17027 | 3 | 0 |
6338 | 6338 | 2020-03-21 | Clinton | Illinois | 17027 | 3 | 0 |
7388 | 7388 | 2020-03-22 | Clinton | Illinois | 17027 | 3 | 0 |
8543 | 8543 | 2020-03-23 | Clinton | Illinois | 17027 | 3 | 0 |
9806 | 9806 | 2020-03-24 | Clinton | Illinois | 17027 | 3 | 0 |
11196 | 11196 | 2020-03-25 | Clinton | Illinois | 17027 | 4 | 0 |
12751 | 12751 | 2020-03-26 | Clinton | Illinois | 17027 | 5 | 0 |
14427 | 14427 | 2020-03-27 | Clinton | Illinois | 17027 | 5 | 0 |
16221 | 16221 | 2020-03-28 | Clinton | Illinois | 17027 | 5 | 0 |
18120 | 18120 | 2020-03-29 | Clinton | Illinois | 17027 | 6 | 0 |
20121 | 20121 | 2020-03-30 | Clinton | Illinois | 17027 | 6 | 0 |
22212 | 22212 | 2020-03-31 | Clinton | Illinois | 17027 | 7 | 0 |
24380 | 24380 | 2020-04-01 | Clinton | Illinois | 17027 | 8 | 0 |
26613 | 26613 | 2020-04-02 | Clinton | Illinois | 17027 | 8 | 0 |
28920 | 28920 | 2020-04-03 | Clinton | Illinois | 17027 | 8 | 0 |
31282 | 31282 | 2020-04-04 | Clinton | Illinois | 17027 | 10 | 0 |
33691 | 33691 | 2020-04-05 | Clinton | Illinois | 17027 | 10 | 0 |
36142 | 36142 | 2020-04-06 | Clinton | Illinois | 17027 | 11 | 0 |
38636 | 38636 | 2020-04-07 | Clinton | Illinois | 17027 | 11 | 0 |
41180 | 41180 | 2020-04-08 | Clinton | Illinois | 17027 | 13 | 0 |
43754 | 43754 | 2020-04-09 | Clinton | Illinois | 17027 | 31 | 0 |
46356 | 46356 | 2020-04-10 | Clinton | Illinois | 17027 | 32 | 0 |
48987 | 48987 | 2020-04-11 | Clinton | Illinois | 17027 | 37 | 0 |
51649 | 51649 | 2020-04-12 | Clinton | Illinois | 17027 | 37 | 0 |
54329 | 54329 | 2020-04-13 | Clinton | Illinois | 17027 | 38 | 0 |
57022 | 57022 | 2020-04-14 | Clinton | Illinois | 17027 | 38 | 0 |
59729 | 59729 | 2020-04-15 | Clinton | Illinois | 17027 | 39 | 0 |
62450 | 62450 | 2020-04-16 | Clinton | Illinois | 17027 | 39 | 0 |
65182 | 65182 | 2020-04-17 | Clinton | Illinois | 17027 | 42 | 0 |
67930 | 67930 | 2020-04-18 | Clinton | Illinois | 17027 | 44 | 0 |
70692 | 70692 | 2020-04-19 | Clinton | Illinois | 17027 | 45 | 0 |
73462 | 73462 | 2020-04-20 | Clinton | Illinois | 17027 | 45 | 0 |
76238 | 76238 | 2020-04-21 | Clinton | Illinois | 17027 | 46 | 0 |
79022 | 79022 | 2020-04-22 | Clinton | Illinois | 17027 | 49 | 0 |
81815 | 81815 | 2020-04-23 | Clinton | Illinois | 17027 | 51 | 0 |
84615 | 84615 | 2020-04-24 | Clinton | Illinois | 17027 | 73 | 1 |
87425 | 87425 | 2020-04-25 | Clinton | Illinois | 17027 | 82 | 1 |
90241 | 90241 | 2020-04-26 | Clinton | Illinois | 17027 | 84 | 1 |
93060 | 93060 | 2020-04-27 | Clinton | Illinois | 17027 | 85 | 1 |
95892 | 95892 | 2020-04-28 | Clinton | Illinois | 17027 | 90 | 1 |
98736 | 98736 | 2020-04-29 | Clinton | Illinois | 17027 | 101 | 1 |
101587 | 101587 | 2020-04-30 | Clinton | Illinois | 17027 | 106 | 3 |
104443 | 104443 | 2020-05-01 | Clinton | Illinois | 17027 | 110 | 4 |
107308 | 107308 | 2020-05-02 | Clinton | Illinois | 17027 | 110 | 5 |
110178 | 110178 | 2020-05-03 | Clinton | Illinois | 17027 | 112 | 5 |
113053 | 113053 | 2020-05-04 | Clinton | Illinois | 17027 | 114 | 5 |
115936 | 115936 | 2020-05-05 | Clinton | Illinois | 17027 | 115 | 7 |
118896 | 118896 | 2020-05-06 | Clinton | Illinois | 17027 | 116 | 7 |
121866 | 121866 | 2020-05-07 | Clinton | Illinois | 17027 | 122 | 8 |
124845 | 124845 | 2020-05-08 | Clinton | Illinois | 17027 | 125 | 8 |
127832 | 127832 | 2020-05-09 | Clinton | Illinois | 17027 | 126 | 10 |
130823 | 130823 | 2020-05-10 | Clinton | Illinois | 17027 | 126 | 10 |
133814 | 133814 | 2020-05-11 | Clinton | Illinois | 17027 | 127 | 10 |
136803 | 136803 | 2020-05-12 | Clinton | Illinois | 17027 | 128 | 12 |
139794 | 139794 | 2020-05-13 | Clinton | Illinois | 17027 | 142 | 13 |
142790 | 142790 | 2020-05-14 | Clinton | Illinois | 17027 | 155 | 13 |
145790 | 145790 | 2020-05-15 | Clinton | Illinois | 17027 | 159 | 13 |
148793 | 148793 | 2020-05-16 | Clinton | Illinois | 17027 | 162 | 14 |
151802 | 151802 | 2020-05-17 | Clinton | Illinois | 17027 | 161 | 14 |
154814 | 154814 | 2020-05-18 | Clinton | Illinois | 17027 | 161 | 14 |
157830 | 157830 | 2020-05-19 | Clinton | Illinois | 17027 | 165 | 14 |
160856 | 160856 | 2020-05-20 | Clinton | Illinois | 17027 | 167 | 16 |
163884 | 163884 | 2020-05-21 | Clinton | Illinois | 17027 | 169 | 16 |
166917 | 166917 | 2020-05-22 | Clinton | Illinois | 17027 | 173 | 16 |
169954 | 169954 | 2020-05-23 | Clinton | Illinois | 17027 | 176 | 16 |
172995 | 172995 | 2020-05-24 | Clinton | Illinois | 17027 | 176 | 16 |
176039 | 176039 | 2020-05-25 | Clinton | Illinois | 17027 | 177 | 16 |
179083 | 179083 | 2020-05-26 | Clinton | Illinois | 17027 | 178 | 16 |
325677 | 325677 | 2020-07-12 | Clinton | Illinois | 17027 | 246 | 16 |
328863 | 328863 | 2020-07-13 | Clinton | Illinois | 17027 | 246 | 16 |
332050 | 332050 | 2020-07-14 | Clinton | Illinois | 17027 | 252 | 16 |
338439 | 338439 | 2020-07-16 | Clinton | Illinois | 17027 | 260 | 16 |
341635 | 341635 | 2020-07-17 | Clinton | Illinois | 17027 | 264 | 16 |
344835 | 344835 | 2020-07-18 | Clinton | Illinois | 17027 | 267 | 16 |
348036 | 348036 | 2020-07-19 | Clinton | Illinois | 17027 | 268 | 16 |
182127 | 182127 | 2020-05-27 | Clinton | Illinois | 17027 | 178 | 17 |
185181 | 185181 | 2020-05-28 | Clinton | Illinois | 17027 | 180 | 17 |
188238 | 188238 | 2020-05-29 | Clinton | Illinois | 17027 | 181 | 17 |
191303 | 191303 | 2020-05-30 | Clinton | Illinois | 17027 | 186 | 17 |
194370 | 194370 | 2020-05-31 | Clinton | Illinois | 17027 | 186 | 17 |
197440 | 197440 | 2020-06-01 | Clinton | Illinois | 17027 | 186 | 17 |
200513 | 200513 | 2020-06-02 | Clinton | Illinois | 17027 | 188 | 17 |
203589 | 203589 | 2020-06-03 | Clinton | Illinois | 17027 | 188 | 17 |
206669 | 206669 | 2020-06-04 | Clinton | Illinois | 17027 | 189 | 17 |
209750 | 209750 | 2020-06-05 | Clinton | Illinois | 17027 | 190 | 17 |
212835 | 212835 | 2020-06-06 | Clinton | Illinois | 17027 | 193 | 17 |
215922 | 215922 | 2020-06-07 | Clinton | Illinois | 17027 | 193 | 17 |
219013 | 219013 | 2020-06-08 | Clinton | Illinois | 17027 | 193 | 17 |
222108 | 222108 | 2020-06-09 | Clinton | Illinois | 17027 | 196 | 17 |
225203 | 225203 | 2020-06-10 | Clinton | Illinois | 17027 | 197 | 17 |
228305 | 228305 | 2020-06-11 | Clinton | Illinois | 17027 | 198 | 17 |
231408 | 231408 | 2020-06-12 | Clinton | Illinois | 17027 | 203 | 17 |
234514 | 234514 | 2020-06-13 | Clinton | Illinois | 17027 | 207 | 17 |
237621 | 237621 | 2020-06-14 | Clinton | Illinois | 17027 | 209 | 17 |
240729 | 240729 | 2020-06-15 | Clinton | Illinois | 17027 | 213 | 17 |
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);