johns_hopkins_csse_daily_reports

⚠️ 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

13,893 rows where province_or_state = "Illinois" sorted by day descending

View and edit SQL

province_or_state

  • Illinois · 13,893

country_or_region

  • US 13,893
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391092 2020-08-08 US Illinois Adams 17001 517 5 0 512 39.98815591 -91.18786813 2020-08-09 04:34:54 Adams, Illinois, US
391121 2020-08-08 US Illinois Alexander 17003 37 0 0 37 37.18049267 -89.32910838 2020-08-09 04:34:54 Alexander, Illinois, US
391321 2020-08-08 US Illinois Bond 17005 60 3 0 57 38.88829622 -89.43534887 2020-08-09 04:34:54 Bond, Illinois, US
391325 2020-08-08 US Illinois Boone 17007 761 23 0 738 42.32359279 -88.82345779 2020-08-09 04:34:54 Boone, Illinois, US
391375 2020-08-08 US Illinois Brown 17009 13 0 0 13 39.96209138 -90.75068024 2020-08-09 04:34:54 Brown, Illinois, US
391403 2020-08-08 US Illinois Bureau 17011 190 3 0 187 41.40385234 -89.5283051 2020-08-09 04:34:54 Bureau, Illinois, US
391442 2020-08-08 US Illinois Calhoun 17013 9 0 0 9 39.16840183 -90.66330078 2020-08-09 04:34:54 Calhoun, Illinois, US
391488 2020-08-08 US Illinois Carroll 17015 54 4 0 50 42.06823429 -89.93395545 2020-08-09 04:34:54 Carroll, Illinois, US
391509 2020-08-08 US Illinois Cass 17017 230 11 0 219 39.96991073 -90.24734436 2020-08-09 04:34:54 Cass, Illinois, US
391541 2020-08-08 US Illinois Champaign 17019 1663 19 0 1644 40.13919438 -88.20046615 2020-08-09 04:34:54 Champaign, Illinois, US
391601 2020-08-08 US Illinois Christian 17021 137 4 0 133 39.54581621 -89.27780482 2020-08-09 04:34:54 Christian, Illinois, US
391620 2020-08-08 US Illinois Clark 17023 81 2 0 79 39.33425789 -87.78705622 2020-08-09 04:34:54 Clark, Illinois, US
391640 2020-08-08 US Illinois Clay 17025 23 0 0 23 38.75388572 -88.48914513 2020-08-09 04:34:54 Clay, Illinois, US
391667 2020-08-08 US Illinois Clinton 17027 396 17 0 379 38.60704876 -89.42385254 2020-08-09 04:34:54 Clinton, Illinois, US
391694 2020-08-08 US Illinois Coles 17029 474 20 0 454 39.51949084 -88.22358557 2020-08-09 04:34:54 Coles, Illinois, US
391728 2020-08-08 US Illinois Cook 17031 110865 4924 0 105941 41.84144849 -87.81658794 2020-08-09 04:34:54 Cook, Illinois, US
391758 2020-08-08 US Illinois Crawford 17033 29 0 0 29 39.0032229 -87.75954624 2020-08-09 04:34:54 Crawford, Illinois, US
391784 2020-08-08 US Illinois Cumberland 17035 54 2 0 52 39.27432424 -88.2401158 2020-08-09 04:34:54 Cumberland, Illinois, US
391838 2020-08-08 US Illinois De Witt 17039 32 0 0 32 40.17514519 -88.90959682 2020-08-09 04:34:54 De Witt, Illinois, US
391841 2020-08-08 US Illinois DeKalb 17037 927 30 0 897 41.89373302 -88.76958483 2020-08-09 04:34:54 DeKalb, Illinois, US
391910 2020-08-08 US Illinois Douglas 17041 115 2 0 113 39.76768052 -88.21854195 2020-08-09 04:34:54 Douglas, Illinois, US
391921 2020-08-08 US Illinois DuPage 17043 12155 520 0 11635 41.85116968 -88.08642662 2020-08-09 04:34:54 DuPage, Illinois, US
391947 2020-08-08 US Illinois Edgar 17045 29 0 0 29 39.6809186 -87.74759563 2020-08-09 04:34:54 Edgar, Illinois, US
391952 2020-08-08 US Illinois Edwards 17047 17 0 0 17 38.41353228 -88.05720863 2020-08-09 04:34:54 Edwards, Illinois, US
391956 2020-08-08 US Illinois Effingham 17049 150 1 0 149 39.05935711 -88.58969584 2020-08-09 04:34:54 Effingham, Illinois, US
392014 2020-08-08 US Illinois Fayette 17051 65 3 0 62 39.00072038 -89.02452658 2020-08-09 04:34:54 Fayette, Illinois, US
392046 2020-08-08 US Illinois Ford 17053 49 2 0 47 40.59706922 -88.22350769 2020-08-09 04:34:54 Ford, Illinois, US
392061 2020-08-08 US Illinois Franklin 17055 168 0 0 168 37.99189086 -88.92567818 2020-08-09 04:34:54 Franklin, Illinois, US
392096 2020-08-08 US Illinois Fulton 17057 33 0 0 33 40.47289135 -90.20862357 2020-08-09 04:34:54 Fulton, Illinois, US
392107 2020-08-08 US Illinois Gallatin 17059 51 2 0 49 37.76430935 -88.22953869 2020-08-09 04:34:54 Gallatin, Illinois, US
392212 2020-08-08 US Illinois Greene 17061 39 0 0 39 39.35907414 -90.388865 2020-08-09 04:34:54 Greene, Illinois, US
392235 2020-08-08 US Illinois Grundy 17063 316 5 0 311 41.28569601 -88.41905692 2020-08-09 04:34:54 Grundy, Illinois, US
392264 2020-08-08 US Illinois Hamilton 17065 29 0 0 29 38.08163641 -88.53883373 2020-08-09 04:34:54 Hamilton, Illinois, US
392280 2020-08-08 US Illinois Hancock 17067 53 1 0 52 40.40423981 -91.16313899 2020-08-09 04:34:54 Hancock, Illinois, US
392297 2020-08-08 US Illinois Hardin 17069 18 0 0 18 37.51810645 -88.26873022 2020-08-09 04:34:54 Hardin, Illinois, US
392342 2020-08-08 US Illinois Henderson 17071 12 0 0 12 40.81908672 -90.92491462 2020-08-09 04:34:54 Henderson, Illinois, US
392353 2020-08-08 US Illinois Henry 17073 234 1 0 233 41.3533994 -90.13296166 2020-08-09 04:34:54 Henry, Illinois, US
392456 2020-08-08 US Illinois Iroquois 17075 261 11 0 250 40.74717633 -87.82466784 2020-08-09 04:34:54 Iroquois, Illinois, US
392473 2020-08-08 US Illinois Jackson 17077 708 19 0 689 37.78595185 -89.38232563 2020-08-09 04:34:54 Jackson, Illinois, US
392494 2020-08-08 US Illinois Jasper 17079 58 7 0 51 39.01054275 -88.15437049 2020-08-09 04:34:54 Jasper, Illinois, US
392511 2020-08-08 US Illinois Jefferson 17081 282 19 0 263 38.29980057 -88.9240025 2020-08-09 04:34:54 Jefferson, Illinois, US
392537 2020-08-08 US Illinois Jersey 17083 104 2 0 102 39.08869046 -90.35393073 2020-08-09 04:34:54 Jersey, Illinois, US
392542 2020-08-08 US Illinois Jo Daviess 17085 124 1 0 123 42.36542373 -90.21094405 2020-08-09 04:34:54 Jo Daviess, Illinois, US
392545 2020-08-08 US Illinois Johnson 17087 66 0 0 66 37.45939802 -88.88165419 2020-08-09 04:34:54 Johnson, Illinois, US
392575 2020-08-08 US Illinois Kane 17089 9710 305 0 9405 41.93842729 -88.42861412 2020-08-09 04:34:54 Kane, Illinois, US
392576 2020-08-08 US Illinois Kankakee 17091 1768 68 0 1700 41.13746989 -87.86205334 2020-08-09 04:34:54 Kankakee, Illinois, US
392587 2020-08-08 US Illinois Kendall 17093 1364 23 0 1341 41.59081014 -88.42869583 2020-08-09 04:34:54 Kendall, Illinois, US
392629 2020-08-08 US Illinois Knox 17095 297 1 0 296 40.93148779 -90.21330340000002 2020-08-09 04:34:54 Knox, Illinois, US
392651 2020-08-08 US Illinois LaSalle 17099 739 24 0 715 41.34426129999999 -88.88633881 2020-08-09 04:34:54 LaSalle, Illinois, US
392668 2020-08-08 US Illinois Lake 17097 12617 446 0 12171 42.3224907 -88.00367925 2020-08-09 04:34:54 Lake, Illinois, US
392714 2020-08-08 US Illinois Lawrence 17101 48 0 0 48 38.71987914 -87.72884035 2020-08-09 04:34:54 Lawrence, Illinois, US
392733 2020-08-08 US Illinois Lee 17103 170 1 0 169 41.74583951 -89.29977132 2020-08-09 04:34:54 Lee, Illinois, US
392800 2020-08-08 US Illinois Livingston 17105 110 2 0 108 40.89188292 -88.55784752 2020-08-09 04:34:54 Livingston, Illinois, US
392809 2020-08-08 US Illinois Logan 17107 111 0 0 111 40.12581572 -89.36638784 2020-08-09 04:34:54 Logan, Illinois, US
392855 2020-08-08 US Illinois Macon 17115 611 23 0 588 39.86064913 -88.96342505 2020-08-09 04:34:54 Macon, Illinois, US
392859 2020-08-08 US Illinois Macoupin 17117 170 3 0 167 39.26119767 -89.92424028 2020-08-09 04:34:54 Macoupin, Illinois, US
392866 2020-08-08 US Illinois Madison 17119 2530 76 0 2454 38.83042506 -89.90422563 2020-08-09 04:34:54 Madison, Illinois, US
392904 2020-08-08 US Illinois Marion 17121 156 0 0 156 38.64963204 -88.91899208 2020-08-09 04:34:54 Marion, Illinois, US
392922 2020-08-08 US Illinois Marshall 17123 26 0 0 26 41.0327901 -89.34510444 2020-08-09 04:34:54 Marshall, Illinois, US
392940 2020-08-08 US Illinois Mason 17125 47 0 0 47 40.23917274 -89.91824452 2020-08-09 04:34:54 Mason, Illinois, US
392946 2020-08-08 US Illinois Massac 17127 39 0 0 39 37.22078441 -88.71036614 2020-08-09 04:34:54 Massac, Illinois, US
392965 2020-08-08 US Illinois McDonough 17109 141 15 0 126 40.45674722 -90.67775541 2020-08-09 04:34:54 McDonough, Illinois, US
392969 2020-08-08 US Illinois McHenry 17111 3163 114 0 3049 42.32451172 -88.45248227 2020-08-09 04:34:54 McHenry, Illinois, US
392977 2020-08-08 US Illinois McLean 17113 638 15 0 623 40.48996987 -88.84621113 2020-08-09 04:34:54 McLean, Illinois, US
393001 2020-08-08 US Illinois Menard 17129 54 0 0 54 40.02742725 -89.80246001 2020-08-09 04:34:54 Menard, Illinois, US
393008 2020-08-08 US Illinois Mercer 17131 74 4 0 70 41.20596782 -90.74290052 2020-08-09 04:34:54 Mercer, Illinois, US
393071 2020-08-08 US Illinois Monroe 17133 312 13 0 299 38.27594376 -90.17761038 2020-08-09 04:34:54 Monroe, Illinois, US
393091 2020-08-08 US Illinois Montgomery 17135 165 7 0 158 39.23198845 -89.47809254 2020-08-09 04:34:54 Montgomery, Illinois, US
393118 2020-08-08 US Illinois Morgan 17137 242 6 0 236 39.71654544 -90.20255104 2020-08-09 04:34:54 Morgan, Illinois, US
393136 2020-08-08 US Illinois Moultrie 17139 73 0 0 73 39.64187451 -88.62099969 2020-08-09 04:34:54 Moultrie, Illinois, US
393231 2020-08-08 US Illinois Ogle 17141 409 5 0 404 42.04165196 -89.32184679 2020-08-09 04:34:54 Ogle, Illinois, US
393293 2020-08-08 US Illinois Out of IL 80017 0 0 0 0 42.36542373 0.0 2020-08-09 04:34:54 Out of IL, Illinois, US
393348 2020-08-08 US Illinois Peoria 17143 1574 35 0 1539 40.78702156 -89.76078901 2020-08-09 04:34:54 Peoria, Illinois, US
393355 2020-08-08 US Illinois Perry 17145 156 1 0 155 38.08510853 -89.36856219 2020-08-09 04:34:54 Perry, Illinois, US
393375 2020-08-08 US Illinois Piatt 17147 61 0 0 61 40.01360584 -88.59319339 2020-08-09 04:34:54 Piatt, Illinois, US
393389 2020-08-08 US Illinois Pike 17149 21 0 0 21 39.62265059 -90.8877017 2020-08-09 04:34:54 Pike, Illinois, US
393436 2020-08-08 US Illinois Pope 17151 9 0 0 9 37.41391284 -88.56152109 2020-08-09 04:34:54 Pope, Illinois, US
393475 2020-08-08 US Illinois Pulaski 17153 93 0 0 93 37.22631423 -89.13085001 2020-08-09 04:34:54 Pulaski, Illinois, US
393483 2020-08-08 US Illinois Putnam 17155 11 0 0 11 41.2013541 -89.2869272 2020-08-09 04:34:54 Putnam, Illinois, US
393507 2020-08-08 US Illinois Randolph 17157 457 7 0 450 38.05095369 -89.82512254 2020-08-09 04:34:54 Randolph, Illinois, US
393537 2020-08-08 US Illinois Richland 17159 19 0 0 19 38.71240969 -88.08475366 2020-08-09 04:34:54 Richland, Illinois, US
393572 2020-08-08 US Illinois Rock Island 17161 1731 36 0 1695 41.46613806 -90.57042164 2020-08-09 04:34:54 Rock Island, Illinois, US
393618 2020-08-08 US Illinois Saline 17165 131 2 0 129 37.75332999 -88.54119706 2020-08-09 04:34:54 Saline, Illinois, US
393650 2020-08-08 US Illinois Sangamon 17167 1229 33 0 1196 39.75836914 -89.65872023 2020-08-09 04:34:54 Sangamon, Illinois, US
393671 2020-08-08 US Illinois Schuyler 17169 18 0 0 18 40.157179799999994 -90.61114163 2020-08-09 04:34:54 Schuyler, Illinois, US
393679 2020-08-08 US Illinois Scott 17171 19 0 0 19 39.642916899999996 -90.47814431 2020-08-09 04:34:54 Scott, Illinois, US
393716 2020-08-08 US Illinois Shelby 17173 79 1 0 78 39.39133527 -88.80611122 2020-08-09 04:34:54 Shelby, Illinois, US
393781 2020-08-08 US Illinois St. Clair 17163 3953 161 0 3792 38.46996033 -89.93063427 2020-08-09 04:34:54 St. Clair, Illinois, US
393810 2020-08-08 US Illinois Stark 17175 7 0 0 7 41.09309773 -89.79745866 2020-08-09 04:34:54 Stark, Illinois, US
393823 2020-08-08 US Illinois Stephenson 17177 327 6 0 321 42.35129217 -89.662598 2020-08-09 04:34:54 Stephenson, Illinois, US
393900 2020-08-08 US Illinois Tazewell 17179 497 8 0 489 40.50716185 -89.51404662 2020-08-09 04:34:54 Tazewell, Illinois, US
393994 2020-08-08 US Illinois Unassigned 90017 1353 209 0 1144 42.36542373 0.0 2020-08-09 04:34:54 Unassigned, Illinois, US
394035 2020-08-08 US Illinois Union 17181 321 23 0 298 37.47119609 -89.25548938 2020-08-09 04:34:54 Union, Illinois, US
394075 2020-08-08 US Illinois Vermilion 17183 234 2 0 232 40.18417171 -87.73384359 2020-08-09 04:34:54 Vermilion, Illinois, US
394089 2020-08-08 US Illinois Wabash 17185 34 0 0 34 38.44272901 -87.84922065 2020-08-09 04:34:54 Wabash, Illinois, US
394116 2020-08-08 US Illinois Warren 17187 190 0 0 190 40.84925021 -90.6147432 2020-08-09 04:34:54 Warren, Illinois, US
394141 2020-08-08 US Illinois Washington 17189 66 0 0 66 38.35309213 -89.40982703 2020-08-09 04:34:54 Washington, Illinois, US
394174 2020-08-08 US Illinois Wayne 17191 61 1 0 60 38.42955355 -88.42586459 2020-08-09 04:34:54 Wayne, Illinois, US
394220 2020-08-08 US Illinois White 17193 67 0 0 67 38.08706198 -88.17657461 2020-08-09 04:34:54 White, Illinois, US
394224 2020-08-08 US Illinois Whiteside 17195 351 17 0 334 41.75509713 -89.91556058 2020-08-09 04:34:54 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]);
Powered by Datasette · Query took 2167.092ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette