ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 17021 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386545 | 386545 | 2020-07-31 | Christian | Illinois | 17021 | 101 | 5 |
383327 | 383327 | 2020-07-30 | Christian | Illinois | 17021 | 97 | 5 |
380110 | 380110 | 2020-07-29 | Christian | Illinois | 17021 | 89 | 5 |
376893 | 376893 | 2020-07-28 | Christian | Illinois | 17021 | 80 | 5 |
373678 | 373678 | 2020-07-27 | Christian | Illinois | 17021 | 80 | 5 |
370466 | 370466 | 2020-07-26 | Christian | Illinois | 17021 | 78 | 5 |
367256 | 367256 | 2020-07-25 | Christian | Illinois | 17021 | 76 | 5 |
364049 | 364049 | 2020-07-24 | Christian | Illinois | 17021 | 75 | 5 |
360842 | 360842 | 2020-07-23 | Christian | Illinois | 17021 | 65 | 5 |
357637 | 357637 | 2020-07-22 | Christian | Illinois | 17021 | 60 | 5 |
354435 | 354435 | 2020-07-21 | Christian | Illinois | 17021 | 56 | 5 |
351233 | 351233 | 2020-07-20 | Christian | Illinois | 17021 | 55 | 5 |
348033 | 348033 | 2020-07-19 | Christian | Illinois | 17021 | 55 | 5 |
344832 | 344832 | 2020-07-18 | Christian | Illinois | 17021 | 55 | 5 |
341632 | 341632 | 2020-07-17 | Christian | Illinois | 17021 | 54 | 5 |
338436 | 338436 | 2020-07-16 | Christian | Illinois | 17021 | 53 | 5 |
335240 | 335240 | 2020-07-15 | Christian | Illinois | 17021 | 53 | 5 |
332047 | 332047 | 2020-07-14 | Christian | Illinois | 17021 | 52 | 5 |
328860 | 328860 | 2020-07-13 | Christian | Illinois | 17021 | 53 | 5 |
325674 | 325674 | 2020-07-12 | Christian | Illinois | 17021 | 51 | 5 |
322493 | 322493 | 2020-07-11 | Christian | Illinois | 17021 | 50 | 5 |
319314 | 319314 | 2020-07-10 | Christian | Illinois | 17021 | 49 | 5 |
316141 | 316141 | 2020-07-09 | Christian | Illinois | 17021 | 48 | 5 |
312967 | 312967 | 2020-07-08 | Christian | Illinois | 17021 | 47 | 5 |
309797 | 309797 | 2020-07-07 | Christian | Illinois | 17021 | 47 | 5 |
306629 | 306629 | 2020-07-06 | Christian | Illinois | 17021 | 47 | 5 |
303464 | 303464 | 2020-07-05 | Christian | Illinois | 17021 | 45 | 5 |
300300 | 300300 | 2020-07-04 | Christian | Illinois | 17021 | 45 | 5 |
297138 | 297138 | 2020-07-03 | Christian | Illinois | 17021 | 45 | 5 |
293981 | 293981 | 2020-07-02 | Christian | Illinois | 17021 | 45 | 5 |
290827 | 290827 | 2020-07-01 | Christian | Illinois | 17021 | 43 | 5 |
287677 | 287677 | 2020-06-30 | Christian | Illinois | 17021 | 43 | 5 |
284528 | 284528 | 2020-06-29 | Christian | Illinois | 17021 | 43 | 5 |
281383 | 281383 | 2020-06-28 | Christian | Illinois | 17021 | 43 | 5 |
278235 | 278235 | 2020-06-27 | Christian | Illinois | 17021 | 43 | 5 |
275087 | 275087 | 2020-06-26 | Christian | Illinois | 17021 | 42 | 5 |
271945 | 271945 | 2020-06-25 | Christian | Illinois | 17021 | 42 | 5 |
268808 | 268808 | 2020-06-24 | Christian | Illinois | 17021 | 42 | 5 |
265678 | 265678 | 2020-06-23 | Christian | Illinois | 17021 | 42 | 5 |
262550 | 262550 | 2020-06-22 | Christian | Illinois | 17021 | 42 | 5 |
259423 | 259423 | 2020-06-21 | Christian | Illinois | 17021 | 42 | 5 |
256297 | 256297 | 2020-06-20 | Christian | Illinois | 17021 | 42 | 5 |
253177 | 253177 | 2020-06-19 | Christian | Illinois | 17021 | 42 | 5 |
250062 | 250062 | 2020-06-18 | Christian | Illinois | 17021 | 42 | 5 |
246950 | 246950 | 2020-06-17 | Christian | Illinois | 17021 | 39 | 5 |
243837 | 243837 | 2020-06-16 | Christian | Illinois | 17021 | 39 | 5 |
240726 | 240726 | 2020-06-15 | Christian | Illinois | 17021 | 39 | 5 |
237618 | 237618 | 2020-06-14 | Christian | Illinois | 17021 | 37 | 5 |
234511 | 234511 | 2020-06-13 | Christian | Illinois | 17021 | 35 | 5 |
231405 | 231405 | 2020-06-12 | Christian | Illinois | 17021 | 35 | 5 |
228302 | 228302 | 2020-06-11 | Christian | Illinois | 17021 | 35 | 5 |
225200 | 225200 | 2020-06-10 | Christian | Illinois | 17021 | 35 | 5 |
222105 | 222105 | 2020-06-09 | Christian | Illinois | 17021 | 35 | 5 |
219010 | 219010 | 2020-06-08 | Christian | Illinois | 17021 | 35 | 5 |
215919 | 215919 | 2020-06-07 | Christian | Illinois | 17021 | 35 | 5 |
212832 | 212832 | 2020-06-06 | Christian | Illinois | 17021 | 35 | 5 |
209747 | 209747 | 2020-06-05 | Christian | Illinois | 17021 | 35 | 5 |
206666 | 206666 | 2020-06-04 | Christian | Illinois | 17021 | 35 | 5 |
203586 | 203586 | 2020-06-03 | Christian | Illinois | 17021 | 35 | 5 |
200510 | 200510 | 2020-06-02 | Christian | Illinois | 17021 | 35 | 5 |
197437 | 197437 | 2020-06-01 | Christian | Illinois | 17021 | 35 | 5 |
194367 | 194367 | 2020-05-31 | Christian | Illinois | 17021 | 35 | 5 |
191300 | 191300 | 2020-05-30 | Christian | Illinois | 17021 | 35 | 5 |
188235 | 188235 | 2020-05-29 | Christian | Illinois | 17021 | 33 | 5 |
185178 | 185178 | 2020-05-28 | Christian | Illinois | 17021 | 33 | 5 |
182124 | 182124 | 2020-05-27 | Christian | Illinois | 17021 | 33 | 5 |
179080 | 179080 | 2020-05-26 | Christian | Illinois | 17021 | 33 | 5 |
176036 | 176036 | 2020-05-25 | Christian | Illinois | 17021 | 33 | 5 |
172992 | 172992 | 2020-05-24 | Christian | Illinois | 17021 | 33 | 5 |
169951 | 169951 | 2020-05-23 | Christian | Illinois | 17021 | 33 | 5 |
166914 | 166914 | 2020-05-22 | Christian | Illinois | 17021 | 32 | 5 |
163881 | 163881 | 2020-05-21 | Christian | Illinois | 17021 | 32 | 5 |
160853 | 160853 | 2020-05-20 | Christian | Illinois | 17021 | 32 | 5 |
157827 | 157827 | 2020-05-19 | Christian | Illinois | 17021 | 32 | 5 |
154811 | 154811 | 2020-05-18 | Christian | Illinois | 17021 | 32 | 5 |
151799 | 151799 | 2020-05-17 | Christian | Illinois | 17021 | 31 | 5 |
148790 | 148790 | 2020-05-16 | Christian | Illinois | 17021 | 30 | 5 |
145787 | 145787 | 2020-05-15 | Christian | Illinois | 17021 | 30 | 5 |
142787 | 142787 | 2020-05-14 | Christian | Illinois | 17021 | 30 | 5 |
139791 | 139791 | 2020-05-13 | Christian | Illinois | 17021 | 30 | 5 |
136800 | 136800 | 2020-05-12 | Christian | Illinois | 17021 | 30 | 5 |
133811 | 133811 | 2020-05-11 | Christian | Illinois | 17021 | 29 | 5 |
130820 | 130820 | 2020-05-10 | Christian | Illinois | 17021 | 29 | 5 |
127829 | 127829 | 2020-05-09 | Christian | Illinois | 17021 | 29 | 5 |
124842 | 124842 | 2020-05-08 | Christian | Illinois | 17021 | 29 | 5 |
121863 | 121863 | 2020-05-07 | Christian | Illinois | 17021 | 27 | 5 |
118893 | 118893 | 2020-05-06 | Christian | Illinois | 17021 | 28 | 5 |
115933 | 115933 | 2020-05-05 | Christian | Illinois | 17021 | 28 | 5 |
113050 | 113050 | 2020-05-04 | Christian | Illinois | 17021 | 28 | 5 |
110175 | 110175 | 2020-05-03 | Christian | Illinois | 17021 | 28 | 5 |
107305 | 107305 | 2020-05-02 | Christian | Illinois | 17021 | 28 | 5 |
104440 | 104440 | 2020-05-01 | Christian | Illinois | 17021 | 29 | 5 |
101584 | 101584 | 2020-04-30 | Christian | Illinois | 17021 | 30 | 5 |
98733 | 98733 | 2020-04-29 | Christian | Illinois | 17021 | 30 | 5 |
95889 | 95889 | 2020-04-28 | Christian | Illinois | 17021 | 28 | 5 |
93057 | 93057 | 2020-04-27 | Christian | Illinois | 17021 | 28 | 5 |
90238 | 90238 | 2020-04-26 | Christian | Illinois | 17021 | 28 | 5 |
87422 | 87422 | 2020-04-25 | Christian | Illinois | 17021 | 28 | 5 |
84612 | 84612 | 2020-04-24 | Christian | Illinois | 17021 | 27 | 5 |
81812 | 81812 | 2020-04-23 | Christian | Illinois | 17021 | 26 | 5 |
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);