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 · 365 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17904 | 17904 | 2021-01-22 | Illinois | 17 | 1095917 | 20535 |
17849 | 17849 | 2021-01-21 | Illinois | 17 | 1089010 | 20423 |
17794 | 17794 | 2021-01-20 | Illinois | 17 | 1084134 | 20285 |
17739 | 17739 | 2021-01-19 | Illinois | 17 | 1079307 | 20154 |
17684 | 17684 | 2021-01-18 | Illinois | 17 | 1074719 | 20119 |
17629 | 17629 | 2021-01-17 | Illinois | 17 | 1071307 | 20052 |
17574 | 17574 | 2021-01-16 | Illinois | 17 | 1067230 | 20021 |
17519 | 17519 | 2021-01-15 | Illinois | 17 | 1062121 | 19876 |
17464 | 17464 | 2021-01-14 | Illinois | 17 | 1055550 | 19728 |
17409 | 17409 | 2021-01-13 | Illinois | 17 | 1048784 | 19619 |
17354 | 17354 | 2021-01-12 | Illinois | 17 | 1043041 | 19497 |
17299 | 17299 | 2021-01-11 | Illinois | 17 | 1036450 | 19365 |
17244 | 17244 | 2021-01-10 | Illinois | 17 | 1031288 | 19295 |
17189 | 17189 | 2021-01-09 | Illinois | 17 | 1026639 | 19212 |
17134 | 17134 | 2021-01-08 | Illinois | 17 | 1020011 | 19110 |
17079 | 17079 | 2021-01-07 | Illinois | 17 | 1010808 | 18944 |
17024 | 17024 | 2021-01-06 | Illinois | 17 | 1001955 | 18738 |
16969 | 16969 | 2021-01-05 | Illinois | 17 | 994511 | 18569 |
16914 | 16914 | 2021-01-04 | Illinois | 17 | 987459 | 18414 |
16859 | 16859 | 2021-01-03 | Illinois | 17 | 982105 | 18322 |
16804 | 16804 | 2021-01-02 | Illinois | 17 | 977677 | 18217 |
16749 | 16749 | 2021-01-01 | Illinois | 17 | 966287 | 17979 |
16694 | 16694 | 2020-12-31 | Illinois | 17 | 965840 | 17979 |
16639 | 16639 | 2020-12-30 | Illinois | 17 | 957853 | 17813 |
16584 | 16584 | 2020-12-29 | Illinois | 17 | 950122 | 17606 |
16529 | 16529 | 2020-12-28 | Illinois | 17 | 944402 | 17476 |
16474 | 16474 | 2020-12-27 | Illinois | 17 | 939671 | 17336 |
16419 | 16419 | 2020-12-26 | Illinois | 17 | 935849 | 17225 |
16364 | 16364 | 2020-12-25 | Illinois | 17 | 932427 | 17155 |
16309 | 16309 | 2020-12-24 | Illinois | 17 | 926967 | 16964 |
16254 | 16254 | 2020-12-23 | Illinois | 17 | 919992 | 16846 |
16199 | 16199 | 2020-12-22 | Illinois | 17 | 913265 | 16677 |
16144 | 16144 | 2020-12-21 | Illinois | 17 | 906917 | 16530 |
16089 | 16089 | 2020-12-20 | Illinois | 17 | 901924 | 16407 |
16034 | 16034 | 2020-12-19 | Illinois | 17 | 896003 | 16326 |
15979 | 15979 | 2020-12-18 | Illinois | 17 | 888478 | 16206 |
15924 | 15924 | 2020-12-17 | Illinois | 17 | 881229 | 15987 |
15869 | 15869 | 2020-12-16 | Illinois | 17 | 872294 | 15780 |
15814 | 15814 | 2020-12-15 | Illinois | 17 | 865261 | 15591 |
15759 | 15759 | 2020-12-14 | Illinois | 17 | 857860 | 15458 |
15704 | 15704 | 2020-12-13 | Illinois | 17 | 850412 | 15340 |
15649 | 15649 | 2020-12-12 | Illinois | 17 | 843328 | 15232 |
15594 | 15594 | 2020-12-11 | Illinois | 17 | 834668 | 15076 |
15539 | 15539 | 2020-12-10 | Illinois | 17 | 825136 | 14852 |
15484 | 15484 | 2020-12-09 | Illinois | 17 | 813990 | 14621 |
15429 | 15429 | 2020-12-08 | Illinois | 17 | 805794 | 14392 |
15374 | 15374 | 2020-12-07 | Illinois | 17 | 797789 | 14234 |
15319 | 15319 | 2020-12-06 | Illinois | 17 | 788922 | 14127 |
15264 | 15264 | 2020-12-05 | Illinois | 17 | 781441 | 14028 |
15209 | 15209 | 2020-12-04 | Illinois | 17 | 771696 | 13808 |
15154 | 15154 | 2020-12-03 | Illinois | 17 | 761209 | 13650 |
15099 | 15099 | 2020-12-02 | Illinois | 17 | 750208 | 13433 |
15044 | 15044 | 2020-12-01 | Illinois | 17 | 740510 | 13175 |
14989 | 14989 | 2020-11-30 | Illinois | 17 | 727825 | 13015 |
14934 | 14934 | 2020-11-29 | Illinois | 17 | 721487 | 12895 |
14879 | 14879 | 2020-11-28 | Illinois | 17 | 714070 | 12852 |
14824 | 14824 | 2020-11-27 | Illinois | 17 | 706123 | 12705 |
14769 | 14769 | 2020-11-26 | Illinois | 17 | 698364 | 12609 |
14714 | 14714 | 2020-11-25 | Illinois | 17 | 686855 | 12465 |
14659 | 14659 | 2020-11-24 | Illinois | 17 | 675543 | 12294 |
14604 | 14604 | 2020-11-23 | Illinois | 17 | 665865 | 12141 |
14549 | 14549 | 2020-11-22 | Illinois | 17 | 657402 | 12064 |
14494 | 14494 | 2020-11-21 | Illinois | 17 | 647474 | 11967 |
14439 | 14439 | 2020-11-20 | Illinois | 17 | 635823 | 11814 |
14384 | 14384 | 2020-11-19 | Illinois | 17 | 622869 | 11671 |
14329 | 14329 | 2020-11-18 | Illinois | 17 | 608056 | 11488 |
14274 | 14274 | 2020-11-17 | Illinois | 17 | 599358 | 11327 |
14219 | 14219 | 2020-11-16 | Illinois | 17 | 586569 | 11217 |
14164 | 14164 | 2020-11-15 | Illinois | 17 | 574722 | 11170 |
14109 | 14109 | 2020-11-14 | Illinois | 17 | 564086 | 11098 |
14054 | 14054 | 2020-11-13 | Illinois | 17 | 553083 | 10907 |
13999 | 13999 | 2020-11-12 | Illinois | 17 | 537860 | 10855 |
13944 | 13944 | 2020-11-11 | Illinois | 17 | 525072 | 10805 |
13889 | 13889 | 2020-11-10 | Illinois | 17 | 512688 | 10658 |
13834 | 13834 | 2020-11-09 | Illinois | 17 | 500015 | 10577 |
13779 | 13779 | 2020-11-08 | Illinois | 17 | 488980 | 10548 |
13724 | 13724 | 2020-11-07 | Illinois | 17 | 479061 | 10498 |
13669 | 13669 | 2020-11-06 | Illinois | 17 | 466884 | 10412 |
13614 | 13614 | 2020-11-05 | Illinois | 17 | 455528 | 10334 |
13559 | 13559 | 2020-11-04 | Illinois | 17 | 445537 | 10239 |
13504 | 13504 | 2020-11-03 | Illinois | 17 | 437879 | 10177 |
13449 | 13449 | 2020-11-02 | Illinois | 17 | 431281 | 10115 |
13394 | 13394 | 2020-11-01 | Illinois | 17 | 424860 | 10091 |
13339 | 13339 | 2020-10-31 | Illinois | 17 | 416557 | 10030 |
13284 | 13284 | 2020-10-30 | Illinois | 17 | 410141 | 10012 |
13229 | 13229 | 2020-10-29 | Illinois | 17 | 401622 | 9963 |
13174 | 13174 | 2020-10-28 | Illinois | 17 | 395204 | 9912 |
13119 | 13119 | 2020-10-27 | Illinois | 17 | 389088 | 9860 |
13064 | 13064 | 2020-10-26 | Illinois | 17 | 385084 | 9811 |
13009 | 13009 | 2020-10-25 | Illinois | 17 | 380065 | 9788 |
12954 | 12954 | 2020-10-24 | Illinois | 17 | 376034 | 9765 |
12899 | 12899 | 2020-10-23 | Illinois | 17 | 370134 | 9704 |
12844 | 12844 | 2020-10-22 | Illinois | 17 | 365120 | 9663 |
12789 | 12789 | 2020-10-21 | Illinois | 17 | 360160 | 9622 |
12734 | 12734 | 2020-10-20 | Illinois | 17 | 356151 | 9562 |
12679 | 12679 | 2020-10-19 | Illinois | 17 | 352449 | 9520 |
12624 | 12624 | 2020-10-18 | Illinois | 17 | 348870 | 9491 |
12569 | 12569 | 2020-10-17 | Illinois | 17 | 344787 | 9474 |
12514 | 12514 | 2020-10-16 | Illinois | 17 | 341219 | 9447 |
12459 | 12459 | 2020-10-15 | Illinois | 17 | 336211 | 9392 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );