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 · 971 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
51598 | 51598 | 2022-09-20 | Illinois | 17 | 3746966 | 39576 |
51542 | 51542 | 2022-09-19 | Illinois | 17 | 3744944 | 39551 |
51486 | 51486 | 2022-09-18 | Illinois | 17 | 3740470 | 39536 |
51430 | 51430 | 2022-09-17 | Illinois | 17 | 3740470 | 39536 |
51374 | 51374 | 2022-09-16 | Illinois | 17 | 3740470 | 39536 |
51318 | 51318 | 2022-09-15 | Illinois | 17 | 3737992 | 39524 |
51262 | 51262 | 2022-09-14 | Illinois | 17 | 3734881 | 39498 |
51206 | 51206 | 2022-09-13 | Illinois | 17 | 3731968 | 39480 |
51150 | 51150 | 2022-09-12 | Illinois | 17 | 3729492 | 39461 |
51094 | 51094 | 2022-09-11 | Illinois | 17 | 3722867 | 39445 |
51038 | 51038 | 2022-09-10 | Illinois | 17 | 3722867 | 39445 |
50982 | 50982 | 2022-09-09 | Illinois | 17 | 3722867 | 39445 |
50926 | 50926 | 2022-09-08 | Illinois | 17 | 3719546 | 39426 |
50870 | 50870 | 2022-09-07 | Illinois | 17 | 3715467 | 39407 |
50814 | 50814 | 2022-09-06 | Illinois | 17 | 3712832 | 39381 |
50758 | 50758 | 2022-09-05 | Illinois | 17 | 3702948 | 39370 |
50702 | 50702 | 2022-09-04 | Illinois | 17 | 3702948 | 39370 |
50646 | 50646 | 2022-09-03 | Illinois | 17 | 3702948 | 39370 |
50590 | 50590 | 2022-09-02 | Illinois | 17 | 3702948 | 39370 |
50534 | 50534 | 2022-09-01 | Illinois | 17 | 3698673 | 39351 |
50478 | 50478 | 2022-08-31 | Illinois | 17 | 3694055 | 39328 |
50422 | 50422 | 2022-08-30 | Illinois | 17 | 3689365 | 39310 |
50366 | 50366 | 2022-08-29 | Illinois | 17 | 3684755 | 39296 |
50310 | 50310 | 2022-08-28 | Illinois | 17 | 3676762 | 39284 |
50254 | 50254 | 2022-08-27 | Illinois | 17 | 3676762 | 39284 |
50198 | 50198 | 2022-08-26 | Illinois | 17 | 3676762 | 39284 |
50142 | 50142 | 2022-08-25 | Illinois | 17 | 3672933 | 39265 |
50086 | 50086 | 2022-08-24 | Illinois | 17 | 3667814 | 39235 |
50030 | 50030 | 2022-08-23 | Illinois | 17 | 3664217 | 39219 |
49974 | 49974 | 2022-08-22 | Illinois | 17 | 3660411 | 39199 |
49918 | 49918 | 2022-08-21 | Illinois | 17 | 3652375 | 39180 |
49862 | 49862 | 2022-08-20 | Illinois | 17 | 3652375 | 39180 |
49806 | 49806 | 2022-08-19 | Illinois | 17 | 3652375 | 39180 |
49750 | 49750 | 2022-08-18 | Illinois | 17 | 3647504 | 39160 |
49694 | 49694 | 2022-08-17 | Illinois | 17 | 3642465 | 39145 |
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );