ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17203 and state = "Illinois" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2048 | 2048 | 2020-03-14 | Woodford | Illinois | 17203 | 1 | 0 |
2441 | 2441 | 2020-03-15 | Woodford | Illinois | 17203 | 1 | 0 |
2884 | 2884 | 2020-03-16 | Woodford | Illinois | 17203 | 1 | 0 |
3373 | 3373 | 2020-03-17 | Woodford | Illinois | 17203 | 1 | 0 |
3943 | 3943 | 2020-03-18 | Woodford | Illinois | 17203 | 2 | 0 |
4619 | 4619 | 2020-03-19 | Woodford | Illinois | 17203 | 2 | 0 |
5425 | 5425 | 2020-03-20 | Woodford | Illinois | 17203 | 2 | 0 |
6360 | 6360 | 2020-03-21 | Woodford | Illinois | 17203 | 2 | 0 |
7414 | 7414 | 2020-03-22 | Woodford | Illinois | 17203 | 2 | 0 |
8571 | 8571 | 2020-03-23 | Woodford | Illinois | 17203 | 2 | 0 |
9835 | 9835 | 2020-03-24 | Woodford | Illinois | 17203 | 3 | 0 |
11228 | 11228 | 2020-03-25 | Woodford | Illinois | 17203 | 3 | 0 |
12784 | 12784 | 2020-03-26 | Woodford | Illinois | 17203 | 3 | 0 |
14462 | 14462 | 2020-03-27 | Woodford | Illinois | 17203 | 3 | 0 |
16259 | 16259 | 2020-03-28 | Woodford | Illinois | 17203 | 3 | 0 |
18160 | 18160 | 2020-03-29 | Woodford | Illinois | 17203 | 3 | 0 |
20166 | 20166 | 2020-03-30 | Woodford | Illinois | 17203 | 3 | 0 |
22259 | 22259 | 2020-03-31 | Woodford | Illinois | 17203 | 3 | 0 |
24429 | 24429 | 2020-04-01 | Woodford | Illinois | 17203 | 3 | 0 |
26667 | 26667 | 2020-04-02 | Woodford | Illinois | 17203 | 3 | 0 |
28977 | 28977 | 2020-04-03 | Woodford | Illinois | 17203 | 4 | 0 |
31343 | 31343 | 2020-04-04 | Woodford | Illinois | 17203 | 6 | 0 |
33753 | 33753 | 2020-04-05 | Woodford | Illinois | 17203 | 6 | 0 |
36206 | 36206 | 2020-04-06 | Woodford | Illinois | 17203 | 6 | 0 |
38704 | 38704 | 2020-04-07 | Woodford | Illinois | 17203 | 7 | 0 |
41250 | 41250 | 2020-04-08 | Woodford | Illinois | 17203 | 7 | 0 |
43826 | 43826 | 2020-04-09 | Woodford | Illinois | 17203 | 7 | 0 |
46430 | 46430 | 2020-04-10 | Woodford | Illinois | 17203 | 7 | 0 |
49064 | 49064 | 2020-04-11 | Woodford | Illinois | 17203 | 7 | 0 |
51726 | 51726 | 2020-04-12 | Woodford | Illinois | 17203 | 7 | 0 |
54407 | 54407 | 2020-04-13 | Woodford | Illinois | 17203 | 9 | 0 |
57100 | 57100 | 2020-04-14 | Woodford | Illinois | 17203 | 10 | 0 |
59808 | 59808 | 2020-04-15 | Woodford | Illinois | 17203 | 11 | 0 |
62529 | 62529 | 2020-04-16 | Woodford | Illinois | 17203 | 11 | 0 |
65263 | 65263 | 2020-04-17 | Woodford | Illinois | 17203 | 11 | 0 |
68012 | 68012 | 2020-04-18 | Woodford | Illinois | 17203 | 11 | 0 |
70774 | 70774 | 2020-04-19 | Woodford | Illinois | 17203 | 11 | 0 |
73545 | 73545 | 2020-04-20 | Woodford | Illinois | 17203 | 11 | 0 |
76322 | 76322 | 2020-04-21 | Woodford | Illinois | 17203 | 11 | 1 |
79106 | 79106 | 2020-04-22 | Woodford | Illinois | 17203 | 11 | 1 |
81899 | 81899 | 2020-04-23 | Woodford | Illinois | 17203 | 11 | 1 |
84699 | 84699 | 2020-04-24 | Woodford | Illinois | 17203 | 11 | 1 |
87509 | 87509 | 2020-04-25 | Woodford | Illinois | 17203 | 11 | 1 |
90325 | 90325 | 2020-04-26 | Woodford | Illinois | 17203 | 11 | 1 |
93144 | 93144 | 2020-04-27 | Woodford | Illinois | 17203 | 11 | 1 |
95976 | 95976 | 2020-04-28 | Woodford | Illinois | 17203 | 12 | 1 |
98820 | 98820 | 2020-04-29 | Woodford | Illinois | 17203 | 12 | 1 |
101671 | 101671 | 2020-04-30 | Woodford | Illinois | 17203 | 13 | 1 |
104527 | 104527 | 2020-05-01 | Woodford | Illinois | 17203 | 14 | 1 |
107392 | 107392 | 2020-05-02 | Woodford | Illinois | 17203 | 13 | 1 |
110262 | 110262 | 2020-05-03 | Woodford | Illinois | 17203 | 13 | 1 |
113137 | 113137 | 2020-05-04 | Woodford | Illinois | 17203 | 13 | 1 |
116020 | 116020 | 2020-05-05 | Woodford | Illinois | 17203 | 13 | 1 |
118980 | 118980 | 2020-05-06 | Woodford | Illinois | 17203 | 15 | 1 |
121950 | 121950 | 2020-05-07 | Woodford | Illinois | 17203 | 15 | 1 |
124930 | 124930 | 2020-05-08 | Woodford | Illinois | 17203 | 15 | 1 |
127917 | 127917 | 2020-05-09 | Woodford | Illinois | 17203 | 15 | 1 |
130908 | 130908 | 2020-05-10 | Woodford | Illinois | 17203 | 15 | 1 |
133898 | 133898 | 2020-05-11 | Woodford | Illinois | 17203 | 15 | 1 |
136887 | 136887 | 2020-05-12 | Woodford | Illinois | 17203 | 15 | 1 |
139879 | 139879 | 2020-05-13 | Woodford | Illinois | 17203 | 15 | 1 |
142875 | 142875 | 2020-05-14 | Woodford | Illinois | 17203 | 14 | 1 |
145875 | 145875 | 2020-05-15 | Woodford | Illinois | 17203 | 14 | 1 |
148879 | 148879 | 2020-05-16 | Woodford | Illinois | 17203 | 14 | 1 |
151888 | 151888 | 2020-05-17 | Woodford | Illinois | 17203 | 14 | 1 |
154900 | 154900 | 2020-05-18 | Woodford | Illinois | 17203 | 16 | 1 |
157916 | 157916 | 2020-05-19 | Woodford | Illinois | 17203 | 16 | 1 |
160942 | 160942 | 2020-05-20 | Woodford | Illinois | 17203 | 18 | 2 |
163970 | 163970 | 2020-05-21 | Woodford | Illinois | 17203 | 18 | 2 |
167003 | 167003 | 2020-05-22 | Woodford | Illinois | 17203 | 18 | 2 |
170040 | 170040 | 2020-05-23 | Woodford | Illinois | 17203 | 18 | 2 |
173081 | 173081 | 2020-05-24 | Woodford | Illinois | 17203 | 18 | 2 |
176125 | 176125 | 2020-05-25 | Woodford | Illinois | 17203 | 18 | 2 |
179169 | 179169 | 2020-05-26 | Woodford | Illinois | 17203 | 19 | 2 |
182213 | 182213 | 2020-05-27 | Woodford | Illinois | 17203 | 19 | 2 |
185267 | 185267 | 2020-05-28 | Woodford | Illinois | 17203 | 19 | 2 |
188325 | 188325 | 2020-05-29 | Woodford | Illinois | 17203 | 19 | 2 |
191390 | 191390 | 2020-05-30 | Woodford | Illinois | 17203 | 20 | 2 |
194457 | 194457 | 2020-05-31 | Woodford | Illinois | 17203 | 21 | 2 |
197527 | 197527 | 2020-06-01 | Woodford | Illinois | 17203 | 22 | 2 |
200600 | 200600 | 2020-06-02 | Woodford | Illinois | 17203 | 22 | 2 |
203676 | 203676 | 2020-06-03 | Woodford | Illinois | 17203 | 22 | 2 |
206756 | 206756 | 2020-06-04 | Woodford | Illinois | 17203 | 22 | 2 |
209837 | 209837 | 2020-06-05 | Woodford | Illinois | 17203 | 22 | 2 |
212922 | 212922 | 2020-06-06 | Woodford | Illinois | 17203 | 22 | 2 |
216009 | 216009 | 2020-06-07 | Woodford | Illinois | 17203 | 23 | 2 |
219101 | 219101 | 2020-06-08 | Woodford | Illinois | 17203 | 23 | 2 |
222196 | 222196 | 2020-06-09 | Woodford | Illinois | 17203 | 23 | 2 |
225291 | 225291 | 2020-06-10 | Woodford | Illinois | 17203 | 23 | 2 |
228393 | 228393 | 2020-06-11 | Woodford | Illinois | 17203 | 24 | 2 |
231496 | 231496 | 2020-06-12 | Woodford | Illinois | 17203 | 24 | 2 |
234602 | 234602 | 2020-06-13 | Woodford | Illinois | 17203 | 25 | 2 |
237709 | 237709 | 2020-06-14 | Woodford | Illinois | 17203 | 25 | 2 |
240817 | 240817 | 2020-06-15 | Woodford | Illinois | 17203 | 28 | 2 |
243928 | 243928 | 2020-06-16 | Woodford | Illinois | 17203 | 29 | 2 |
247041 | 247041 | 2020-06-17 | Woodford | Illinois | 17203 | 31 | 2 |
250153 | 250153 | 2020-06-18 | Woodford | Illinois | 17203 | 31 | 2 |
253268 | 253268 | 2020-06-19 | Woodford | Illinois | 17203 | 32 | 2 |
256388 | 256388 | 2020-06-20 | Woodford | Illinois | 17203 | 33 | 2 |
259514 | 259514 | 2020-06-21 | Woodford | Illinois | 17203 | 33 | 2 |
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);