⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

35,525 rows where province_or_state = "Illinois" sorted by day descending

View and edit SQL

province_or_state

  • Illinois · 35,525

country_or_region

  • US 35,525
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
901634 2021-03-04 US Illinois Adams 17001 8029 114 0 7915 39.98815591 -91.18786813 2021-03-05 05:26:29 Adams, Illinois, US
901635 2021-03-04 US Illinois Alexander 17003 452 9 0 443 37.18049267 -89.32910838 2021-03-05 05:26:29 Alexander, Illinois, US
901636 2021-03-04 US Illinois Bond 17005 1917 24 0 1893 38.88829622 -89.43534887 2021-03-05 05:26:29 Bond, Illinois, US
901637 2021-03-04 US Illinois Boone 17007 5936 71 0 5865 42.32359279 -88.82345779 2021-03-05 05:26:29 Boone, Illinois, US
901638 2021-03-04 US Illinois Brown 17009 665 6 0 659 39.96209138 -90.75068024 2021-03-05 05:26:29 Brown, Illinois, US
901639 2021-03-04 US Illinois Bureau 17011 3321 76 0 3245 41.40385234 -89.5283051 2021-03-05 05:26:29 Bureau, Illinois, US
901640 2021-03-04 US Illinois Calhoun 17013 482 2 0 480 39.16840183 -90.66330078 2021-03-05 05:26:29 Calhoun, Illinois, US
901641 2021-03-04 US Illinois Carroll 17015 1580 34 0 1546 42.06823429 -89.93395545 2021-03-05 05:26:29 Carroll, Illinois, US
901642 2021-03-04 US Illinois Cass 17017 1894 22 0 1872 39.96991073 -90.24734436 2021-03-05 05:26:29 Cass, Illinois, US
901643 2021-03-04 US Illinois Champaign 17019 18222 127 0 18095 40.13919438 -88.20046615 2021-03-05 05:26:29 Champaign, Illinois, US
901644 2021-03-04 US Illinois Christian 17021 3324 68 0 3256 39.54581621 -89.27780482 2021-03-05 05:26:29 Christian, Illinois, US
901645 2021-03-04 US Illinois Clark 17023 1688 31 0 1657 39.33425789 -87.78705622 2021-03-05 05:26:29 Clark, Illinois, US
901646 2021-03-04 US Illinois Clay 17025 1431 42 0 1389 38.75388572 -88.48914513 2021-03-05 05:26:29 Clay, Illinois, US
901647 2021-03-04 US Illinois Clinton 17027 5579 89 0 5490 38.60704876 -89.42385254 2021-03-05 05:26:29 Clinton, Illinois, US
901648 2021-03-04 US Illinois Coles 17029 5228 92 0 5136 39.51949084 -88.22358557 2021-03-05 05:26:29 Coles, Illinois, US
901649 2021-03-04 US Illinois Cook 17031 476835 9417 0 467418 41.84144849 -87.81658794 2021-03-05 05:26:29 Cook, Illinois, US
901650 2021-03-04 US Illinois Crawford 17033 2013 24 0 1989 39.0032229 -87.75954624 2021-03-05 05:26:29 Crawford, Illinois, US
901651 2021-03-04 US Illinois Cumberland 17035 1195 18 0 1177 39.27432424 -88.2401158 2021-03-05 05:26:29 Cumberland, Illinois, US
901652 2021-03-04 US Illinois De Witt 17039 1282 22 0 1260 40.17514519 -88.90959682 2021-03-05 05:26:29 De Witt, Illinois, US
901653 2021-03-04 US Illinois DeKalb 17037 8338 113 0 8225 41.89373302 -88.76958483 2021-03-05 05:26:29 DeKalb, Illinois, US
901654 2021-03-04 US Illinois Douglas 17041 2467 33 0 2434 39.76768052 -88.21854195 2021-03-05 05:26:29 Douglas, Illinois, US
901655 2021-03-04 US Illinois DuPage 17043 77406 1204 0 76202 41.85116968 -88.08642662 2021-03-05 05:26:29 DuPage, Illinois, US
901656 2021-03-04 US Illinois Edgar 17045 1551 38 0 1513 39.6809186 -87.74759563 2021-03-05 05:26:29 Edgar, Illinois, US
901657 2021-03-04 US Illinois Edwards 17047 527 10 0 517 38.41353228 -88.05720863 2021-03-05 05:26:29 Edwards, Illinois, US
901658 2021-03-04 US Illinois Effingham 17049 4502 69 0 4433 39.05935711 -88.58969584 2021-03-05 05:26:29 Effingham, Illinois, US
901659 2021-03-04 US Illinois Fayette 17051 3068 52 0 3016 39.00072038 -89.02452658 2021-03-05 05:26:29 Fayette, Illinois, US
901660 2021-03-04 US Illinois Ford 17053 1593 45 0 1548 40.59706922 -88.22350769 2021-03-05 05:26:29 Ford, Illinois, US
901661 2021-03-04 US Illinois Franklin 17055 4157 66 0 4091 37.99189086 -88.92567818 2021-03-05 05:26:29 Franklin, Illinois, US
901662 2021-03-04 US Illinois Fulton 17057 2875 45 0 2830 40.47289135 -90.20862357 2021-03-05 05:26:29 Fulton, Illinois, US
901663 2021-03-04 US Illinois Gallatin 17059 437 4 0 433 37.76430935 -88.22953869 2021-03-05 05:26:29 Gallatin, Illinois, US
901664 2021-03-04 US Illinois Greene 17061 1381 32 0 1349 39.35907414 -90.388865 2021-03-05 05:26:29 Greene, Illinois, US
901665 2021-03-04 US Illinois Grundy 17063 5178 63 0 5115 41.28569601 -88.41905692 2021-03-05 05:26:29 Grundy, Illinois, US
901666 2021-03-04 US Illinois Hamilton 17065 791 15 0 776 38.08163641 -88.53883373 2021-03-05 05:26:29 Hamilton, Illinois, US
901667 2021-03-04 US Illinois Hancock 17067 1681 29 0 1652 40.40423981 -91.16313899 2021-03-05 05:26:29 Hancock, Illinois, US
901668 2021-03-04 US Illinois Hardin 17069 346 12 0 334 37.51810645 -88.26873022 2021-03-05 05:26:29 Hardin, Illinois, US
901669 2021-03-04 US Illinois Henderson 17071 501 14 0 487 40.81908672 -90.92491462 2021-03-05 05:26:29 Henderson, Illinois, US
901670 2021-03-04 US Illinois Henry 17073 4343 58 0 4285 41.3533994 -90.13296166 2021-03-05 05:26:29 Henry, Illinois, US
901671 2021-03-04 US Illinois Iroquois 17075 2788 62 0 2726 40.74717633 -87.82466784 2021-03-05 05:26:29 Iroquois, Illinois, US
901672 2021-03-04 US Illinois Jackson 17077 4613 60 0 4553 37.78595185 -89.38232563 2021-03-05 05:26:29 Jackson, Illinois, US
901673 2021-03-04 US Illinois Jasper 17079 1110 17 0 1093 39.01054275 -88.15437049 2021-03-05 05:26:29 Jasper, Illinois, US
901674 2021-03-04 US Illinois Jefferson 17081 3994 116 0 3878 38.29980057 -88.9240025 2021-03-05 05:26:29 Jefferson, Illinois, US
901675 2021-03-04 US Illinois Jersey 17083 2496 47 0 2449 39.08869046 -90.35393073 2021-03-05 05:26:29 Jersey, Illinois, US
901676 2021-03-04 US Illinois Jo Daviess 17085 1609 22 0 1587 42.36542373 -90.21094405 2021-03-05 05:26:29 Jo Daviess, Illinois, US
901677 2021-03-04 US Illinois Johnson 17087 1353 12 0 1341 37.45939802 -88.88165419 2021-03-05 05:26:29 Johnson, Illinois, US
901678 2021-03-04 US Illinois Kane 17089 51052 723 0 50329 41.93842729 -88.42861412 2021-03-05 05:26:29 Kane, Illinois, US
901679 2021-03-04 US Illinois Kankakee 17091 12555 189 0 12366 41.13746989 -87.86205334 2021-03-05 05:26:29 Kankakee, Illinois, US
901680 2021-03-04 US Illinois Kendall 17093 11141 86 0 11055 41.59081014 -88.42869583 2021-03-05 05:26:29 Kendall, Illinois, US
901681 2021-03-04 US Illinois Knox 17095 5020 132 0 4888 40.93148779 -90.21330340000002 2021-03-05 05:26:29 Knox, Illinois, US
901682 2021-03-04 US Illinois LaSalle 17099 10861 221 0 10640 41.34426129999999 -88.88633881 2021-03-05 05:26:29 LaSalle, Illinois, US
901683 2021-03-04 US Illinois Lake 17097 59899 929 0 58970 42.3224907 -88.00367925 2021-03-05 05:26:29 Lake, Illinois, US
901684 2021-03-04 US Illinois Lawrence 17101 2306 24 0 2282 38.71987914 -87.72884035 2021-03-05 05:26:29 Lawrence, Illinois, US
901685 2021-03-04 US Illinois Lee 17103 3367 43 0 3324 41.74583951 -89.29977132 2021-03-05 05:26:29 Lee, Illinois, US
901686 2021-03-04 US Illinois Livingston 17105 4244 77 0 4167 40.89188292 -88.55784752 2021-03-05 05:26:29 Livingston, Illinois, US
901687 2021-03-04 US Illinois Logan 17107 3313 53 0 3260 40.12581572 -89.36638784 2021-03-05 05:26:29 Logan, Illinois, US
901688 2021-03-04 US Illinois Macon 17115 9500 186 0 9314 39.86064913 -88.96342505 2021-03-05 05:26:29 Macon, Illinois, US
901689 2021-03-04 US Illinois Macoupin 17117 4370 80 0 4290 39.26119767 -89.92424028 2021-03-05 05:26:29 Macoupin, Illinois, US
901690 2021-03-04 US Illinois Madison 17119 28163 460 0 27703 38.83042506 -89.90422563 2021-03-05 05:26:29 Madison, Illinois, US
901691 2021-03-04 US Illinois Marion 17121 4270 112 0 4158 38.64963204 -88.91899208 2021-03-05 05:26:29 Marion, Illinois, US
901692 2021-03-04 US Illinois Marshall 17123 843 15 0 828 41.0327901 -89.34510444 2021-03-05 05:26:29 Marshall, Illinois, US
901693 2021-03-04 US Illinois Mason 17125 1286 41 0 1245 40.23917274 -89.91824452 2021-03-05 05:26:29 Mason, Illinois, US
901694 2021-03-04 US Illinois Massac 17127 1280 33 0 1247 37.22078441 -88.71036614 2021-03-05 05:26:29 Massac, Illinois, US
901695 2021-03-04 US Illinois McDonough 17109 2336 40 0 2296 40.45674722 -90.67775541 2021-03-05 05:26:29 McDonough, Illinois, US
901696 2021-03-04 US Illinois McHenry 17111 24554 266 0 24288 42.32451172 -88.45248227 2021-03-05 05:26:29 McHenry, Illinois, US
901697 2021-03-04 US Illinois McLean 17113 14681 160 0 14521 40.48996987 -88.84621113 2021-03-05 05:26:29 McLean, Illinois, US
901698 2021-03-04 US Illinois Menard 17129 1040 8 0 1032 40.02742725 -89.80246001 2021-03-05 05:26:29 Menard, Illinois, US
901699 2021-03-04 US Illinois Mercer 17131 1284 33 0 1251 41.20596782 -90.74290052 2021-03-05 05:26:29 Mercer, Illinois, US
901700 2021-03-04 US Illinois Monroe 17133 4078 84 0 3994 38.27594376 -90.17761038 2021-03-05 05:26:29 Monroe, Illinois, US
901701 2021-03-04 US Illinois Montgomery 17135 3524 69 0 3455 39.23198845 -89.47809254 2021-03-05 05:26:29 Montgomery, Illinois, US
901702 2021-03-04 US Illinois Morgan 17137 3605 77 0 3528 39.71654544 -90.20255104 2021-03-05 05:26:29 Morgan, Illinois, US
901703 2021-03-04 US Illinois Moultrie 17139 1502 24 0 1478 39.64187451 -88.62099969 2021-03-05 05:26:29 Moultrie, Illinois, US
901704 2021-03-04 US Illinois Ogle 17141 5051 74 0 4977 42.04165196 -89.32184679 2021-03-05 05:26:29 Ogle, Illinois, US
901705 2021-03-04 US Illinois Out of IL 80017 6 0 0 6 42.36542373 0.0 2021-03-05 05:26:29 Out of IL, Illinois, US
901706 2021-03-04 US Illinois Peoria 17143 16964 265 0 16699 40.78702156 -89.76078901 2021-03-05 05:26:29 Peoria, Illinois, US
901707 2021-03-04 US Illinois Perry 17145 3061 57 0 3004 38.08510853 -89.36856219 2021-03-05 05:26:29 Perry, Illinois, US
901708 2021-03-04 US Illinois Piatt 17147 1338 14 0 1324 40.01360584 -88.59319339 2021-03-05 05:26:29 Piatt, Illinois, US
901709 2021-03-04 US Illinois Pike 17149 1701 50 0 1651 39.62265059 -90.8877017 2021-03-05 05:26:29 Pike, Illinois, US
901710 2021-03-04 US Illinois Pope 17151 284 3 0 281 37.41391284 -88.56152109 2021-03-05 05:26:29 Pope, Illinois, US
901711 2021-03-04 US Illinois Pulaski 17153 671 6 0 665 37.22631423 -89.13085001 2021-03-05 05:26:29 Pulaski, Illinois, US
901712 2021-03-04 US Illinois Putnam 17155 419 3 0 416 41.2013541 -89.2869272 2021-03-05 05:26:29 Putnam, Illinois, US
901713 2021-03-04 US Illinois Randolph 17157 3975 79 0 3896 38.05095369 -89.82512254 2021-03-05 05:26:29 Randolph, Illinois, US
901714 2021-03-04 US Illinois Richland 17159 1636 38 0 1598 38.71240969 -88.08475366 2021-03-05 05:26:29 Richland, Illinois, US
901715 2021-03-04 US Illinois Rock Island 17161 13132 288 0 12844 41.46613806 -90.57042164 2021-03-05 05:26:29 Rock Island, Illinois, US
901716 2021-03-04 US Illinois Saline 17165 2324 48 0 2276 37.75332999 -88.54119706 2021-03-05 05:26:29 Saline, Illinois, US
901717 2021-03-04 US Illinois Sangamon 17167 16217 221 0 15996 39.75836914 -89.65872023 2021-03-05 05:26:29 Sangamon, Illinois, US
901718 2021-03-04 US Illinois Schuyler 17169 682 5 0 677 40.1571798 -90.61114163 2021-03-05 05:26:29 Schuyler, Illinois, US
901719 2021-03-04 US Illinois Scott 17171 449 1 0 448 39.6429169 -90.47814431 2021-03-05 05:26:29 Scott, Illinois, US
901720 2021-03-04 US Illinois Shelby 17173 2148 34 0 2114 39.39133527 -88.80611122 2021-03-05 05:26:29 Shelby, Illinois, US
901721 2021-03-04 US Illinois St. Clair 17163 25618 468 0 25150 38.46996033 -89.93063427 2021-03-05 05:26:29 St. Clair, Illinois, US
901722 2021-03-04 US Illinois Stark 17175 543 22 0 521 41.09309773 -89.79745866 2021-03-05 05:26:29 Stark, Illinois, US
901723 2021-03-04 US Illinois Stephenson 17177 4102 76 0 4026 42.35129217 -89.662598 2021-03-05 05:26:29 Stephenson, Illinois, US
901724 2021-03-04 US Illinois Tazewell 17179 13615 240 0 13375 40.50716185 -89.51404662 2021-03-05 05:26:29 Tazewell, Illinois, US
901725 2021-03-04 US Illinois Unassigned 90017 0 2234 0 -2234 42.36542373 0.0 2021-03-05 05:26:29 Unassigned, Illinois, US
901726 2021-03-04 US Illinois Union 17181 2201 38 0 2163 37.47119609 -89.25548938 2021-03-05 05:26:29 Union, Illinois, US
901727 2021-03-04 US Illinois Vermilion 17183 8608 118 0 8490 40.18417171 -87.73384359 2021-03-05 05:26:29 Vermilion, Illinois, US
901728 2021-03-04 US Illinois Wabash 17185 1303 12 0 1291 38.44272901 -87.84922065 2021-03-05 05:26:29 Wabash, Illinois, US
901729 2021-03-04 US Illinois Warren 17187 1665 44 0 1621 40.84925021 -90.6147432 2021-03-05 05:26:29 Warren, Illinois, US
901730 2021-03-04 US Illinois Washington 17189 1587 24 0 1563 38.35309213 -89.40982703 2021-03-05 05:26:29 Washington, Illinois, US
901731 2021-03-04 US Illinois Wayne 17191 1687 49 0 1638 38.42955355 -88.42586459 2021-03-05 05:26:29 Wayne, Illinois, US
901732 2021-03-04 US Illinois White 17193 1614 25 0 1589 38.08706198 -88.17657461 2021-03-05 05:26:29 White, Illinois, US
901733 2021-03-04 US Illinois Whiteside 17195 5943 148 0 5795 41.75509713 -89.91556058 2021-03-05 05:26:29 Whiteside, Illinois, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);