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 · 936 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
49638 | 49638 | 2022-08-16 | Illinois | 17 | 3639479 | 39128 |
49582 | 49582 | 2022-08-15 | Illinois | 17 | 3635675 | 39119 |
49526 | 49526 | 2022-08-14 | Illinois | 17 | 3627267 | 39108 |
49470 | 49470 | 2022-08-13 | Illinois | 17 | 3627267 | 39108 |
49414 | 49414 | 2022-08-12 | Illinois | 17 | 3627267 | 39108 |
49358 | 49358 | 2022-08-11 | Illinois | 17 | 3623509 | 39079 |
49302 | 49302 | 2022-08-10 | Illinois | 17 | 3617765 | 39059 |
49246 | 49246 | 2022-08-09 | Illinois | 17 | 3614588 | 39037 |
49190 | 49190 | 2022-08-08 | Illinois | 17 | 3610526 | 38984 |
49134 | 49134 | 2022-08-07 | Illinois | 17 | 3600719 | 38966 |
49078 | 49078 | 2022-08-06 | Illinois | 17 | 3600719 | 38966 |
49022 | 49022 | 2022-08-05 | Illinois | 17 | 3600719 | 38966 |
48966 | 48966 | 2022-08-04 | Illinois | 17 | 3594502 | 38956 |
48910 | 48910 | 2022-08-03 | Illinois | 17 | 3590316 | 38923 |
48854 | 48854 | 2022-08-02 | Illinois | 17 | 3585277 | 38889 |
48798 | 48798 | 2022-08-01 | Illinois | 17 | 3580187 | 38888 |
48742 | 48742 | 2022-07-31 | Illinois | 17 | 3569918 | 38882 |
48686 | 48686 | 2022-07-30 | Illinois | 17 | 3569918 | 38882 |
48630 | 48630 | 2022-07-29 | Illinois | 17 | 3569918 | 38882 |
48574 | 48574 | 2022-07-28 | Illinois | 17 | 3564043 | 38873 |
48518 | 48518 | 2022-07-27 | Illinois | 17 | 3556908 | 38847 |
48462 | 48462 | 2022-07-26 | Illinois | 17 | 3554264 | 38830 |
48406 | 48406 | 2022-07-25 | Illinois | 17 | 3549049 | 38822 |
48350 | 48350 | 2022-07-24 | Illinois | 17 | 3534504 | 38812 |
48294 | 48294 | 2022-07-23 | Illinois | 17 | 3534504 | 38812 |
48238 | 48238 | 2022-07-22 | Illinois | 17 | 3534504 | 38812 |
48182 | 48182 | 2022-07-21 | Illinois | 17 | 3529242 | 38799 |
48126 | 48126 | 2022-07-20 | Illinois | 17 | 3522590 | 38785 |
48070 | 48070 | 2022-07-19 | Illinois | 17 | 3517294 | 38766 |
48014 | 48014 | 2022-07-18 | Illinois | 17 | 3513435 | 38755 |
47958 | 47958 | 2022-07-17 | Illinois | 17 | 3502221 | 38737 |
47902 | 47902 | 2022-07-16 | Illinois | 17 | 3502221 | 38737 |
47846 | 47846 | 2022-07-15 | Illinois | 17 | 3502221 | 38737 |
47790 | 47790 | 2022-07-14 | Illinois | 17 | 3497612 | 38721 |
47734 | 47734 | 2022-07-13 | Illinois | 17 | 3492244 | 38707 |
47678 | 47678 | 2022-07-12 | Illinois | 17 | 3487138 | 38686 |
47622 | 47622 | 2022-07-11 | Illinois | 17 | 3481048 | 38671 |
47566 | 47566 | 2022-07-10 | Illinois | 17 | 3469087 | 38660 |
47510 | 47510 | 2022-07-09 | Illinois | 17 | 3468941 | 38660 |
47454 | 47454 | 2022-07-08 | Illinois | 17 | 3468941 | 38660 |
47398 | 47398 | 2022-07-07 | Illinois | 17 | 3463634 | 38641 |
47342 | 47342 | 2022-07-06 | Illinois | 17 | 3457839 | 38633 |
47286 | 47286 | 2022-07-05 | Illinois | 17 | 3452404 | 38616 |
47230 | 47230 | 2022-07-04 | Illinois | 17 | 3441737 | 38601 |
47174 | 47174 | 2022-07-03 | Illinois | 17 | 3441737 | 38601 |
47118 | 47118 | 2022-07-02 | Illinois | 17 | 3441737 | 38601 |
47062 | 47062 | 2022-07-01 | Illinois | 17 | 3441474 | 38601 |
47006 | 47006 | 2022-06-30 | Illinois | 17 | 3436799 | 38588 |
46950 | 46950 | 2022-06-29 | Illinois | 17 | 3432057 | 38569 |
46894 | 46894 | 2022-06-28 | Illinois | 17 | 3427364 | 38559 |
46838 | 46838 | 2022-06-27 | Illinois | 17 | 3423153 | 38535 |
46782 | 46782 | 2022-06-26 | Illinois | 17 | 3413207 | 38510 |
46726 | 46726 | 2022-06-25 | Illinois | 17 | 3413207 | 38510 |
46670 | 46670 | 2022-06-24 | Illinois | 17 | 3413207 | 38510 |
46614 | 46614 | 2022-06-23 | Illinois | 17 | 3407624 | 38483 |
46558 | 46558 | 2022-06-22 | Illinois | 17 | 3404112 | 38463 |
46502 | 46502 | 2022-06-21 | Illinois | 17 | 3399502 | 38422 |
46446 | 46446 | 2022-06-20 | Illinois | 17 | 3386053 | 38410 |
46390 | 46390 | 2022-06-19 | Illinois | 17 | 3386053 | 38410 |
46334 | 46334 | 2022-06-18 | Illinois | 17 | 3386053 | 38410 |
46278 | 46278 | 2022-06-17 | Illinois | 17 | 3386053 | 38410 |
46222 | 46222 | 2022-06-16 | Illinois | 17 | 3382530 | 38392 |
46166 | 46166 | 2022-06-15 | Illinois | 17 | 3377188 | 38368 |
46110 | 46110 | 2022-06-14 | Illinois | 17 | 3371430 | 38344 |
46054 | 46054 | 2022-06-13 | Illinois | 17 | 3367572 | 38320 |
45998 | 45998 | 2022-06-12 | Illinois | 17 | 3358781 | 38311 |
45942 | 45942 | 2022-06-11 | Illinois | 17 | 3358781 | 38311 |
45886 | 45886 | 2022-06-10 | Illinois | 17 | 3358781 | 38311 |
45830 | 45830 | 2022-06-09 | Illinois | 17 | 3352679 | 38298 |
45774 | 45774 | 2022-06-08 | Illinois | 17 | 3348356 | 38282 |
45718 | 45718 | 2022-06-07 | Illinois | 17 | 3343479 | 38252 |
45662 | 45662 | 2022-06-06 | Illinois | 17 | 3338626 | 38222 |
45606 | 45606 | 2022-06-05 | Illinois | 17 | 3324779 | 38188 |
45550 | 45550 | 2022-06-04 | Illinois | 17 | 3324779 | 38188 |
45494 | 45494 | 2022-06-03 | Illinois | 17 | 3324779 | 38188 |
45438 | 45438 | 2022-06-02 | Illinois | 17 | 3318938 | 38171 |
45382 | 45382 | 2022-06-01 | Illinois | 17 | 3312546 | 38161 |
45326 | 45326 | 2022-05-31 | Illinois | 17 | 3308233 | 38135 |
45270 | 45270 | 2022-05-30 | Illinois | 17 | 3292157 | 38127 |
45214 | 45214 | 2022-05-29 | Illinois | 17 | 3292157 | 38127 |
45158 | 45158 | 2022-05-28 | Illinois | 17 | 3292157 | 38127 |
45102 | 45102 | 2022-05-27 | Illinois | 17 | 3292157 | 38127 |
45046 | 45046 | 2022-05-26 | Illinois | 17 | 3286462 | 38121 |
44990 | 44990 | 2022-05-25 | Illinois | 17 | 3280087 | 38114 |
44934 | 44934 | 2022-05-24 | Illinois | 17 | 3273698 | 38103 |
44878 | 44878 | 2022-05-23 | Illinois | 17 | 3269692 | 38090 |
44822 | 44822 | 2022-05-22 | Illinois | 17 | 3255231 | 38068 |
44766 | 44766 | 2022-05-21 | Illinois | 17 | 3255231 | 38068 |
44710 | 44710 | 2022-05-20 | Illinois | 17 | 3255231 | 38068 |
44654 | 44654 | 2022-05-19 | Illinois | 17 | 3250491 | 38056 |
44598 | 44598 | 2022-05-18 | Illinois | 17 | 3242954 | 38041 |
44542 | 44542 | 2022-05-17 | Illinois | 17 | 3237197 | 38028 |
44486 | 44486 | 2022-05-16 | Illinois | 17 | 3231905 | 38013 |
44430 | 44430 | 2022-05-15 | Illinois | 17 | 3215032 | 38005 |
44374 | 44374 | 2022-05-14 | Illinois | 17 | 3215032 | 38005 |
44318 | 44318 | 2022-05-13 | Illinois | 17 | 3215032 | 38005 |
44262 | 44262 | 2022-05-12 | Illinois | 17 | 3206588 | 37997 |
44206 | 44206 | 2022-05-11 | Illinois | 17 | 3200925 | 37994 |
44150 | 44150 | 2022-05-10 | Illinois | 17 | 3194739 | 37982 |
44094 | 44094 | 2022-05-09 | Illinois | 17 | 3189426 | 37966 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );