ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Winnebago" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386636 | 386636 | 2020-07-31 | Winnebago | Illinois | 17201 | 3641 | 122 |
383418 | 383418 | 2020-07-30 | Winnebago | Illinois | 17201 | 3610 | 122 |
380201 | 380201 | 2020-07-29 | Winnebago | Illinois | 17201 | 3582 | 121 |
376984 | 376984 | 2020-07-28 | Winnebago | Illinois | 17201 | 3570 | 120 |
373769 | 373769 | 2020-07-27 | Winnebago | Illinois | 17201 | 3539 | 118 |
370557 | 370557 | 2020-07-26 | Winnebago | Illinois | 17201 | 3516 | 115 |
367347 | 367347 | 2020-07-25 | Winnebago | Illinois | 17201 | 3486 | 115 |
364140 | 364140 | 2020-07-24 | Winnebago | Illinois | 17201 | 3457 | 115 |
360933 | 360933 | 2020-07-23 | Winnebago | Illinois | 17201 | 3424 | 113 |
357728 | 357728 | 2020-07-22 | Winnebago | Illinois | 17201 | 3394 | 113 |
354526 | 354526 | 2020-07-21 | Winnebago | Illinois | 17201 | 3369 | 111 |
351324 | 351324 | 2020-07-20 | Winnebago | Illinois | 17201 | 3362 | 108 |
348124 | 348124 | 2020-07-19 | Winnebago | Illinois | 17201 | 3342 | 108 |
344923 | 344923 | 2020-07-18 | Winnebago | Illinois | 17201 | 3318 | 108 |
341723 | 341723 | 2020-07-17 | Winnebago | Illinois | 17201 | 3303 | 108 |
338527 | 338527 | 2020-07-16 | Winnebago | Illinois | 17201 | 3264 | 108 |
335331 | 335331 | 2020-07-15 | Winnebago | Illinois | 17201 | 3228 | 106 |
332138 | 332138 | 2020-07-14 | Winnebago | Illinois | 17201 | 3212 | 106 |
328951 | 328951 | 2020-07-13 | Winnebago | Illinois | 17201 | 3191 | 106 |
325765 | 325765 | 2020-07-12 | Winnebago | Illinois | 17201 | 3169 | 106 |
322584 | 322584 | 2020-07-11 | Winnebago | Illinois | 17201 | 3156 | 105 |
319405 | 319405 | 2020-07-10 | Winnebago | Illinois | 17201 | 3161 | 104 |
316232 | 316232 | 2020-07-09 | Winnebago | Illinois | 17201 | 3143 | 101 |
313058 | 313058 | 2020-07-08 | Winnebago | Illinois | 17201 | 3131 | 101 |
309888 | 309888 | 2020-07-07 | Winnebago | Illinois | 17201 | 3118 | 97 |
306720 | 306720 | 2020-07-06 | Winnebago | Illinois | 17201 | 3109 | 96 |
303555 | 303555 | 2020-07-05 | Winnebago | Illinois | 17201 | 3091 | 96 |
300391 | 300391 | 2020-07-04 | Winnebago | Illinois | 17201 | 3084 | 96 |
297229 | 297229 | 2020-07-03 | Winnebago | Illinois | 17201 | 3067 | 96 |
294071 | 294071 | 2020-07-02 | Winnebago | Illinois | 17201 | 3054 | 96 |
290917 | 290917 | 2020-07-01 | Winnebago | Illinois | 17201 | 3046 | 95 |
287767 | 287767 | 2020-06-30 | Winnebago | Illinois | 17201 | 3030 | 94 |
284618 | 284618 | 2020-06-29 | Winnebago | Illinois | 17201 | 3014 | 93 |
281473 | 281473 | 2020-06-28 | Winnebago | Illinois | 17201 | 3004 | 92 |
278325 | 278325 | 2020-06-27 | Winnebago | Illinois | 17201 | 2992 | 91 |
275177 | 275177 | 2020-06-26 | Winnebago | Illinois | 17201 | 2959 | 90 |
272035 | 272035 | 2020-06-25 | Winnebago | Illinois | 17201 | 2947 | 89 |
268898 | 268898 | 2020-06-24 | Winnebago | Illinois | 17201 | 2933 | 88 |
265768 | 265768 | 2020-06-23 | Winnebago | Illinois | 17201 | 2916 | 85 |
262640 | 262640 | 2020-06-22 | Winnebago | Illinois | 17201 | 2903 | 85 |
259513 | 259513 | 2020-06-21 | Winnebago | Illinois | 17201 | 2884 | 85 |
256387 | 256387 | 2020-06-20 | Winnebago | Illinois | 17201 | 2849 | 85 |
253267 | 253267 | 2020-06-19 | Winnebago | Illinois | 17201 | 2824 | 85 |
250152 | 250152 | 2020-06-18 | Winnebago | Illinois | 17201 | 2824 | 85 |
247040 | 247040 | 2020-06-17 | Winnebago | Illinois | 17201 | 2806 | 85 |
243927 | 243927 | 2020-06-16 | Winnebago | Illinois | 17201 | 2785 | 85 |
240816 | 240816 | 2020-06-15 | Winnebago | Illinois | 17201 | 2774 | 85 |
237708 | 237708 | 2020-06-14 | Winnebago | Illinois | 17201 | 2765 | 79 |
234601 | 234601 | 2020-06-13 | Winnebago | Illinois | 17201 | 2730 | 79 |
231495 | 231495 | 2020-06-12 | Winnebago | Illinois | 17201 | 2701 | 79 |
228392 | 228392 | 2020-06-11 | Winnebago | Illinois | 17201 | 2669 | 78 |
225290 | 225290 | 2020-06-10 | Winnebago | Illinois | 17201 | 2634 | 78 |
222195 | 222195 | 2020-06-09 | Winnebago | Illinois | 17201 | 2619 | 78 |
219100 | 219100 | 2020-06-08 | Winnebago | Illinois | 17201 | 2594 | 76 |
216008 | 216008 | 2020-06-07 | Winnebago | Illinois | 17201 | 2562 | 76 |
212921 | 212921 | 2020-06-06 | Winnebago | Illinois | 17201 | 2528 | 76 |
209836 | 209836 | 2020-06-05 | Winnebago | Illinois | 17201 | 2501 | 76 |
206755 | 206755 | 2020-06-04 | Winnebago | Illinois | 17201 | 2421 | 69 |
203675 | 203675 | 2020-06-03 | Winnebago | Illinois | 17201 | 2354 | 69 |
200599 | 200599 | 2020-06-02 | Winnebago | Illinois | 17201 | 2313 | 63 |
197526 | 197526 | 2020-06-01 | Winnebago | Illinois | 17201 | 2290 | 63 |
194456 | 194456 | 2020-05-31 | Winnebago | Illinois | 17201 | 2251 | 59 |
191389 | 191389 | 2020-05-30 | Winnebago | Illinois | 17201 | 2209 | 59 |
188324 | 188324 | 2020-05-29 | Winnebago | Illinois | 17201 | 2156 | 59 |
185266 | 185266 | 2020-05-28 | Winnebago | Illinois | 17201 | 2091 | 58 |
182212 | 182212 | 2020-05-27 | Winnebago | Illinois | 17201 | 2001 | 54 |
179168 | 179168 | 2020-05-26 | Winnebago | Illinois | 17201 | 1993 | 52 |
176124 | 176124 | 2020-05-25 | Winnebago | Illinois | 17201 | 1953 | 52 |
173080 | 173080 | 2020-05-24 | Winnebago | Illinois | 17201 | 1925 | 52 |
170039 | 170039 | 2020-05-23 | Winnebago | Illinois | 17201 | 1838 | 52 |
167002 | 167002 | 2020-05-22 | Winnebago | Illinois | 17201 | 1780 | 52 |
163969 | 163969 | 2020-05-21 | Winnebago | Illinois | 17201 | 1684 | 52 |
160941 | 160941 | 2020-05-20 | Winnebago | Illinois | 17201 | 1648 | 44 |
157915 | 157915 | 2020-05-19 | Winnebago | Illinois | 17201 | 1588 | 44 |
154899 | 154899 | 2020-05-18 | Winnebago | Illinois | 17201 | 1558 | 41 |
151887 | 151887 | 2020-05-17 | Winnebago | Illinois | 17201 | 1501 | 41 |
148878 | 148878 | 2020-05-16 | Winnebago | Illinois | 17201 | 1444 | 41 |
145874 | 145874 | 2020-05-15 | Winnebago | Illinois | 17201 | 1390 | 39 |
142874 | 142874 | 2020-05-14 | Winnebago | Illinois | 17201 | 1337 | 39 |
139878 | 139878 | 2020-05-13 | Winnebago | Illinois | 17201 | 1208 | 39 |
136886 | 136886 | 2020-05-12 | Winnebago | Illinois | 17201 | 1159 | 28 |
133897 | 133897 | 2020-05-11 | Winnebago | Illinois | 17201 | 932 | 26 |
130907 | 130907 | 2020-05-10 | Winnebago | Illinois | 17201 | 917 | 26 |
127916 | 127916 | 2020-05-09 | Winnebago | Illinois | 17201 | 877 | 26 |
124929 | 124929 | 2020-05-08 | Winnebago | Illinois | 17201 | 830 | 26 |
121949 | 121949 | 2020-05-07 | Winnebago | Illinois | 17201 | 759 | 26 |
118979 | 118979 | 2020-05-06 | Winnebago | Illinois | 17201 | 696 | 22 |
116019 | 116019 | 2020-05-05 | Winnebago | Illinois | 17201 | 649 | 22 |
113136 | 113136 | 2020-05-04 | Winnebago | Illinois | 17201 | 638 | 21 |
110261 | 110261 | 2020-05-03 | Winnebago | Illinois | 17201 | 579 | 19 |
107391 | 107391 | 2020-05-02 | Winnebago | Illinois | 17201 | 521 | 18 |
104526 | 104526 | 2020-05-01 | Winnebago | Illinois | 17201 | 485 | 14 |
101670 | 101670 | 2020-04-30 | Winnebago | Illinois | 17201 | 442 | 14 |
98819 | 98819 | 2020-04-29 | Winnebago | Illinois | 17201 | 392 | 14 |
95975 | 95975 | 2020-04-28 | Winnebago | Illinois | 17201 | 365 | 14 |
93143 | 93143 | 2020-04-27 | Winnebago | Illinois | 17201 | 343 | 14 |
90324 | 90324 | 2020-04-26 | Winnebago | Illinois | 17201 | 318 | 14 |
87508 | 87508 | 2020-04-25 | Winnebago | Illinois | 17201 | 302 | 14 |
84698 | 84698 | 2020-04-24 | Winnebago | Illinois | 17201 | 279 | 12 |
81898 | 81898 | 2020-04-23 | Winnebago | Illinois | 17201 | 252 | 12 |
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);