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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2440 | 2440 | 2020-03-15 | Winnebago | Illinois | 17201 | 1 | 0 |
2883 | 2883 | 2020-03-16 | Winnebago | Illinois | 17201 | 1 | 0 |
3372 | 3372 | 2020-03-17 | Winnebago | Illinois | 17201 | 1 | 0 |
3942 | 3942 | 2020-03-18 | Winnebago | Illinois | 17201 | 1 | 0 |
4618 | 4618 | 2020-03-19 | Winnebago | Illinois | 17201 | 1 | 0 |
5424 | 5424 | 2020-03-20 | Winnebago | Illinois | 17201 | 2 | 0 |
6359 | 6359 | 2020-03-21 | Winnebago | Illinois | 17201 | 4 | 0 |
7413 | 7413 | 2020-03-22 | Winnebago | Illinois | 17201 | 4 | 0 |
8570 | 8570 | 2020-03-23 | Winnebago | Illinois | 17201 | 5 | 0 |
9834 | 9834 | 2020-03-24 | Winnebago | Illinois | 17201 | 5 | 0 |
11227 | 11227 | 2020-03-25 | Winnebago | Illinois | 17201 | 7 | 0 |
12783 | 12783 | 2020-03-26 | Winnebago | Illinois | 17201 | 8 | 0 |
14461 | 14461 | 2020-03-27 | Winnebago | Illinois | 17201 | 8 | 0 |
16258 | 16258 | 2020-03-28 | Winnebago | Illinois | 17201 | 9 | 0 |
18159 | 18159 | 2020-03-29 | Winnebago | Illinois | 17201 | 12 | 0 |
20165 | 20165 | 2020-03-30 | Winnebago | Illinois | 17201 | 13 | 0 |
22258 | 22258 | 2020-03-31 | Winnebago | Illinois | 17201 | 15 | 0 |
24428 | 24428 | 2020-04-01 | Winnebago | Illinois | 17201 | 18 | 1 |
26666 | 26666 | 2020-04-02 | Winnebago | Illinois | 17201 | 24 | 1 |
28976 | 28976 | 2020-04-03 | Winnebago | Illinois | 17201 | 28 | 1 |
31342 | 31342 | 2020-04-04 | Winnebago | Illinois | 17201 | 36 | 1 |
33752 | 33752 | 2020-04-05 | Winnebago | Illinois | 17201 | 42 | 1 |
36205 | 36205 | 2020-04-06 | Winnebago | Illinois | 17201 | 49 | 1 |
38703 | 38703 | 2020-04-07 | Winnebago | Illinois | 17201 | 59 | 3 |
41249 | 41249 | 2020-04-08 | Winnebago | Illinois | 17201 | 63 | 3 |
43825 | 43825 | 2020-04-09 | Winnebago | Illinois | 17201 | 66 | 3 |
54406 | 54406 | 2020-04-13 | Winnebago | Illinois | 17201 | 99 | 4 |
46429 | 46429 | 2020-04-10 | Winnebago | Illinois | 17201 | 77 | 7 |
49063 | 49063 | 2020-04-11 | Winnebago | Illinois | 17201 | 80 | 7 |
51725 | 51725 | 2020-04-12 | Winnebago | Illinois | 17201 | 94 | 7 |
57099 | 57099 | 2020-04-14 | Winnebago | Illinois | 17201 | 101 | 7 |
59807 | 59807 | 2020-04-15 | Winnebago | Illinois | 17201 | 119 | 8 |
62528 | 62528 | 2020-04-16 | Winnebago | Illinois | 17201 | 121 | 8 |
65262 | 65262 | 2020-04-17 | Winnebago | Illinois | 17201 | 145 | 8 |
68011 | 68011 | 2020-04-18 | Winnebago | Illinois | 17201 | 172 | 9 |
70773 | 70773 | 2020-04-19 | Winnebago | Illinois | 17201 | 178 | 9 |
73544 | 73544 | 2020-04-20 | Winnebago | Illinois | 17201 | 195 | 9 |
76321 | 76321 | 2020-04-21 | Winnebago | Illinois | 17201 | 207 | 11 |
79105 | 79105 | 2020-04-22 | Winnebago | Illinois | 17201 | 238 | 11 |
81898 | 81898 | 2020-04-23 | Winnebago | Illinois | 17201 | 252 | 12 |
84698 | 84698 | 2020-04-24 | Winnebago | Illinois | 17201 | 279 | 12 |
87508 | 87508 | 2020-04-25 | Winnebago | Illinois | 17201 | 302 | 14 |
90324 | 90324 | 2020-04-26 | Winnebago | Illinois | 17201 | 318 | 14 |
93143 | 93143 | 2020-04-27 | Winnebago | Illinois | 17201 | 343 | 14 |
95975 | 95975 | 2020-04-28 | Winnebago | Illinois | 17201 | 365 | 14 |
98819 | 98819 | 2020-04-29 | Winnebago | Illinois | 17201 | 392 | 14 |
101670 | 101670 | 2020-04-30 | Winnebago | Illinois | 17201 | 442 | 14 |
104526 | 104526 | 2020-05-01 | Winnebago | Illinois | 17201 | 485 | 14 |
107391 | 107391 | 2020-05-02 | Winnebago | Illinois | 17201 | 521 | 18 |
110261 | 110261 | 2020-05-03 | Winnebago | Illinois | 17201 | 579 | 19 |
113136 | 113136 | 2020-05-04 | Winnebago | Illinois | 17201 | 638 | 21 |
116019 | 116019 | 2020-05-05 | Winnebago | Illinois | 17201 | 649 | 22 |
118979 | 118979 | 2020-05-06 | Winnebago | Illinois | 17201 | 696 | 22 |
121949 | 121949 | 2020-05-07 | Winnebago | Illinois | 17201 | 759 | 26 |
124929 | 124929 | 2020-05-08 | Winnebago | Illinois | 17201 | 830 | 26 |
127916 | 127916 | 2020-05-09 | Winnebago | Illinois | 17201 | 877 | 26 |
130907 | 130907 | 2020-05-10 | Winnebago | Illinois | 17201 | 917 | 26 |
133897 | 133897 | 2020-05-11 | Winnebago | Illinois | 17201 | 932 | 26 |
136886 | 136886 | 2020-05-12 | Winnebago | Illinois | 17201 | 1159 | 28 |
139878 | 139878 | 2020-05-13 | Winnebago | Illinois | 17201 | 1208 | 39 |
142874 | 142874 | 2020-05-14 | Winnebago | Illinois | 17201 | 1337 | 39 |
145874 | 145874 | 2020-05-15 | Winnebago | Illinois | 17201 | 1390 | 39 |
148878 | 148878 | 2020-05-16 | Winnebago | Illinois | 17201 | 1444 | 41 |
151887 | 151887 | 2020-05-17 | Winnebago | Illinois | 17201 | 1501 | 41 |
154899 | 154899 | 2020-05-18 | Winnebago | Illinois | 17201 | 1558 | 41 |
157915 | 157915 | 2020-05-19 | Winnebago | Illinois | 17201 | 1588 | 44 |
160941 | 160941 | 2020-05-20 | Winnebago | Illinois | 17201 | 1648 | 44 |
163969 | 163969 | 2020-05-21 | Winnebago | Illinois | 17201 | 1684 | 52 |
167002 | 167002 | 2020-05-22 | Winnebago | Illinois | 17201 | 1780 | 52 |
170039 | 170039 | 2020-05-23 | Winnebago | Illinois | 17201 | 1838 | 52 |
173080 | 173080 | 2020-05-24 | Winnebago | Illinois | 17201 | 1925 | 52 |
176124 | 176124 | 2020-05-25 | Winnebago | Illinois | 17201 | 1953 | 52 |
179168 | 179168 | 2020-05-26 | Winnebago | Illinois | 17201 | 1993 | 52 |
182212 | 182212 | 2020-05-27 | Winnebago | Illinois | 17201 | 2001 | 54 |
185266 | 185266 | 2020-05-28 | Winnebago | Illinois | 17201 | 2091 | 58 |
188324 | 188324 | 2020-05-29 | Winnebago | Illinois | 17201 | 2156 | 59 |
191389 | 191389 | 2020-05-30 | Winnebago | Illinois | 17201 | 2209 | 59 |
194456 | 194456 | 2020-05-31 | Winnebago | Illinois | 17201 | 2251 | 59 |
197526 | 197526 | 2020-06-01 | Winnebago | Illinois | 17201 | 2290 | 63 |
200599 | 200599 | 2020-06-02 | Winnebago | Illinois | 17201 | 2313 | 63 |
203675 | 203675 | 2020-06-03 | Winnebago | Illinois | 17201 | 2354 | 69 |
206755 | 206755 | 2020-06-04 | Winnebago | Illinois | 17201 | 2421 | 69 |
209836 | 209836 | 2020-06-05 | Winnebago | Illinois | 17201 | 2501 | 76 |
212921 | 212921 | 2020-06-06 | Winnebago | Illinois | 17201 | 2528 | 76 |
216008 | 216008 | 2020-06-07 | Winnebago | Illinois | 17201 | 2562 | 76 |
219100 | 219100 | 2020-06-08 | Winnebago | Illinois | 17201 | 2594 | 76 |
222195 | 222195 | 2020-06-09 | Winnebago | Illinois | 17201 | 2619 | 78 |
225290 | 225290 | 2020-06-10 | Winnebago | Illinois | 17201 | 2634 | 78 |
228392 | 228392 | 2020-06-11 | Winnebago | Illinois | 17201 | 2669 | 78 |
231495 | 231495 | 2020-06-12 | Winnebago | Illinois | 17201 | 2701 | 79 |
234601 | 234601 | 2020-06-13 | Winnebago | Illinois | 17201 | 2730 | 79 |
237708 | 237708 | 2020-06-14 | Winnebago | Illinois | 17201 | 2765 | 79 |
240816 | 240816 | 2020-06-15 | Winnebago | Illinois | 17201 | 2774 | 85 |
243927 | 243927 | 2020-06-16 | Winnebago | Illinois | 17201 | 2785 | 85 |
247040 | 247040 | 2020-06-17 | Winnebago | Illinois | 17201 | 2806 | 85 |
250152 | 250152 | 2020-06-18 | Winnebago | Illinois | 17201 | 2824 | 85 |
253267 | 253267 | 2020-06-19 | Winnebago | Illinois | 17201 | 2824 | 85 |
256387 | 256387 | 2020-06-20 | Winnebago | Illinois | 17201 | 2849 | 85 |
259513 | 259513 | 2020-06-21 | Winnebago | Illinois | 17201 | 2884 | 85 |
262640 | 262640 | 2020-06-22 | Winnebago | Illinois | 17201 | 2903 | 85 |
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);