ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,071 rows where state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Illinois · 130 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
4979 | 4979 | 2020-06-01 | Illinois | 17 | 121666 | 5458 |
4924 | 4924 | 2020-05-31 | Illinois | 17 | 120588 | 5426 |
4869 | 4869 | 2020-05-30 | Illinois | 17 | 119290 | 5368 |
4814 | 4814 | 2020-05-29 | Illinois | 17 | 117794 | 5308 |
4759 | 4759 | 2020-05-28 | Illinois | 17 | 116128 | 5225 |
4704 | 4704 | 2020-05-27 | Illinois | 17 | 114612 | 5118 |
4649 | 4649 | 2020-05-26 | Illinois | 17 | 113486 | 4960 |
4594 | 4594 | 2020-05-25 | Illinois | 17 | 112248 | 4912 |
4539 | 4539 | 2020-05-24 | Illinois | 17 | 110541 | 4884 |
4484 | 4484 | 2020-05-23 | Illinois | 17 | 108100 | 4817 |
4429 | 4429 | 2020-05-22 | Illinois | 17 | 105710 | 4740 |
4374 | 4374 | 2020-05-21 | Illinois | 17 | 102995 | 4634 |
4319 | 4319 | 2020-05-20 | Illinois | 17 | 100713 | 4547 |
4264 | 4264 | 2020-05-19 | Illinois | 17 | 98298 | 4399 |
4209 | 4209 | 2020-05-18 | Illinois | 17 | 96778 | 4257 |
4154 | 4154 | 2020-05-17 | Illinois | 17 | 94360 | 4198 |
4099 | 4099 | 2020-05-16 | Illinois | 17 | 92669 | 4149 |
4044 | 4044 | 2020-05-15 | Illinois | 17 | 90528 | 4075 |
3989 | 3989 | 2020-05-14 | Illinois | 17 | 88081 | 3945 |
3934 | 3934 | 2020-05-13 | Illinois | 17 | 84874 | 3815 |
3879 | 3879 | 2020-05-12 | Illinois | 17 | 83168 | 3617 |
3824 | 3824 | 2020-05-11 | Illinois | 17 | 79123 | 3480 |
3769 | 3769 | 2020-05-10 | Illinois | 17 | 77662 | 3426 |
3714 | 3714 | 2020-05-09 | Illinois | 17 | 76008 | 3362 |
3659 | 3659 | 2020-05-08 | Illinois | 17 | 73688 | 3262 |
3604 | 3604 | 2020-05-07 | Illinois | 17 | 70802 | 3139 |
3549 | 3549 | 2020-05-06 | Illinois | 17 | 68164 | 2977 |
3494 | 3494 | 2020-05-05 | Illinois | 17 | 65889 | 2843 |
3439 | 3439 | 2020-05-04 | Illinois | 17 | 63840 | 2673 |
3384 | 3384 | 2020-05-03 | Illinois | 17 | 61499 | 2632 |
3329 | 3329 | 2020-05-02 | Illinois | 17 | 58505 | 2576 |
3274 | 3274 | 2020-05-01 | Illinois | 17 | 56055 | 2464 |
3219 | 3219 | 2020-04-30 | Illinois | 17 | 52918 | 2361 |
3164 | 3164 | 2020-04-29 | Illinois | 17 | 50355 | 2221 |
3109 | 3109 | 2020-04-28 | Illinois | 17 | 48102 | 2132 |
3054 | 3054 | 2020-04-27 | Illinois | 17 | 45883 | 1992 |
2999 | 2999 | 2020-04-26 | Illinois | 17 | 43903 | 1943 |
2944 | 2944 | 2020-04-25 | Illinois | 17 | 41777 | 1884 |
2889 | 2889 | 2020-04-24 | Illinois | 17 | 39658 | 1804 |
2834 | 2834 | 2020-04-23 | Illinois | 17 | 36935 | 1696 |
2779 | 2779 | 2020-04-22 | Illinois | 17 | 35108 | 1577 |
2724 | 2724 | 2020-04-21 | Illinois | 17 | 33059 | 1479 |
2669 | 2669 | 2020-04-20 | Illinois | 17 | 31508 | 1359 |
2614 | 2614 | 2020-04-19 | Illinois | 17 | 30357 | 1302 |
2559 | 2559 | 2020-04-18 | Illinois | 17 | 29160 | 1272 |
2504 | 2504 | 2020-04-17 | Illinois | 17 | 27575 | 1142 |
2449 | 2449 | 2020-04-16 | Illinois | 17 | 25734 | 1081 |
2394 | 2394 | 2020-04-15 | Illinois | 17 | 24593 | 958 |
2339 | 2339 | 2020-04-14 | Illinois | 17 | 23247 | 878 |
2284 | 2284 | 2020-04-13 | Illinois | 17 | 22025 | 800 |
2229 | 2229 | 2020-04-12 | Illinois | 17 | 20852 | 727 |
2174 | 2174 | 2020-04-11 | Illinois | 17 | 19180 | 682 |
2119 | 2119 | 2020-04-10 | Illinois | 17 | 17887 | 607 |
2064 | 2064 | 2020-04-09 | Illinois | 17 | 16422 | 534 |
2009 | 2009 | 2020-04-08 | Illinois | 17 | 15078 | 464 |
1954 | 1954 | 2020-04-07 | Illinois | 17 | 13549 | 384 |
1899 | 1899 | 2020-04-06 | Illinois | 17 | 12262 | 309 |
1844 | 1844 | 2020-04-05 | Illinois | 17 | 11276 | 283 |
1789 | 1789 | 2020-04-04 | Illinois | 17 | 10357 | 248 |
1734 | 1734 | 2020-04-03 | Illinois | 17 | 8904 | 212 |
1679 | 1679 | 2020-04-02 | Illinois | 17 | 7695 | 165 |
1624 | 1624 | 2020-04-01 | Illinois | 17 | 6978 | 146 |
1569 | 1569 | 2020-03-31 | Illinois | 17 | 5992 | 107 |
1514 | 1514 | 2020-03-30 | Illinois | 17 | 5070 | 84 |
1459 | 1459 | 2020-03-29 | Illinois | 17 | 4615 | 71 |
1404 | 1404 | 2020-03-28 | Illinois | 17 | 3547 | 50 |
1350 | 1350 | 2020-03-27 | Illinois | 17 | 3029 | 37 |
1296 | 1296 | 2020-03-26 | Illinois | 17 | 2538 | 26 |
1242 | 1242 | 2020-03-25 | Illinois | 17 | 1874 | 21 |
1188 | 1188 | 2020-03-24 | Illinois | 17 | 1535 | 16 |
1134 | 1134 | 2020-03-23 | Illinois | 17 | 1285 | 12 |
1080 | 1080 | 2020-03-22 | Illinois | 17 | 1047 | 9 |
1026 | 1026 | 2020-03-21 | Illinois | 17 | 751 | 6 |
972 | 972 | 2020-03-20 | Illinois | 17 | 583 | 5 |
918 | 918 | 2020-03-19 | Illinois | 17 | 420 | 4 |
864 | 864 | 2020-03-18 | Illinois | 17 | 286 | 1 |
810 | 810 | 2020-03-17 | Illinois | 17 | 159 | 1 |
757 | 757 | 2020-03-16 | Illinois | 17 | 104 | 0 |
704 | 704 | 2020-03-15 | Illinois | 17 | 94 | 0 |
651 | 651 | 2020-03-14 | Illinois | 17 | 66 | 0 |
600 | 600 | 2020-03-13 | Illinois | 17 | 46 | 0 |
551 | 551 | 2020-03-12 | Illinois | 17 | 32 | 0 |
505 | 505 | 2020-03-11 | Illinois | 17 | 25 | 0 |
464 | 464 | 2020-03-10 | Illinois | 17 | 19 | 0 |
427 | 427 | 2020-03-09 | Illinois | 17 | 11 | 0 |
392 | 392 | 2020-03-08 | Illinois | 17 | 7 | 0 |
358 | 358 | 2020-03-07 | Illinois | 17 | 6 | 0 |
329 | 329 | 2020-03-06 | Illinois | 17 | 6 | 0 |
307 | 307 | 2020-03-05 | Illinois | 17 | 5 | 0 |
289 | 289 | 2020-03-04 | Illinois | 17 | 4 | 0 |
273 | 273 | 2020-03-03 | Illinois | 17 | 4 | 0 |
258 | 258 | 2020-03-02 | Illinois | 17 | 4 | 0 |
244 | 244 | 2020-03-01 | Illinois | 17 | 3 | 0 |
233 | 233 | 2020-02-29 | Illinois | 17 | 3 | 0 |
223 | 223 | 2020-02-28 | Illinois | 17 | 2 | 0 |
214 | 214 | 2020-02-27 | Illinois | 17 | 2 | 0 |
205 | 205 | 2020-02-26 | Illinois | 17 | 2 | 0 |
196 | 196 | 2020-02-25 | Illinois | 17 | 2 | 0 |
188 | 188 | 2020-02-24 | Illinois | 17 | 2 | 0 |
180 | 180 | 2020-02-23 | Illinois | 17 | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );