daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

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

104 rows where "last_update" is on date 2021-01-24 and province_or_state = "Illinois" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • Illinois · 104 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-01-23 US Illinois Adams 17001 7529 101 0 7428 39.98815591 -91.18786813 2021-01-24 05:22:35 Adams, Illinois, US
2021-01-23 US Illinois Alexander 17003 404 7 0 397 37.18049267 -89.32910838 2021-01-24 05:22:35 Alexander, Illinois, US
2021-01-23 US Illinois Bond 17005 1779 20 0 1759 38.88829622 -89.43534887 2021-01-24 05:22:35 Bond, Illinois, US
2021-01-23 US Illinois Boone 17007 5640 67 0 5573 42.32359279 -88.82345779 2021-01-24 05:22:35 Boone, Illinois, US
2021-01-23 US Illinois Brown 17009 622 5 0 617 39.96209138 -90.75068024 2021-01-24 05:22:35 Brown, Illinois, US
2021-01-23 US Illinois Bureau 17011 3048 72 0 2976 41.40385234 -89.5283051 2021-01-24 05:22:35 Bureau, Illinois, US
2021-01-23 US Illinois Calhoun 17013 450 1 0 449 39.16840183 -90.66330078 2021-01-24 05:22:35 Calhoun, Illinois, US
2021-01-23 US Illinois Carroll 17015 1458 32 0 1426 42.06823429 -89.93395545 2021-01-24 05:22:35 Carroll, Illinois, US
2021-01-23 US Illinois Cass 17017 1790 21 0 1769 39.96991073 -90.24734436 2021-01-24 05:22:35 Cass, Illinois, US
2021-01-23 US Illinois Champaign 17019 15799 99 0 15700 40.13919438 -88.20046615 2021-01-24 05:22:35 Champaign, Illinois, US
2021-01-23 US Illinois Christian 17021 3052 61 0 2991 39.54581621 -89.27780482 2021-01-24 05:22:35 Christian, Illinois, US
2021-01-23 US Illinois Clark 17023 1527 27 0 1500 39.33425789 -87.78705622 2021-01-24 05:22:35 Clark, Illinois, US
2021-01-23 US Illinois Clay 17025 1339 35 0 1304 38.75388572 -88.48914513 2021-01-24 05:22:35 Clay, Illinois, US
2021-01-23 US Illinois Clinton 17027 5162 78 0 5084 38.60704876 -89.42385254 2021-01-24 05:22:35 Clinton, Illinois, US
2021-01-23 US Illinois Coles 17029 4783 83 0 4700 39.51949084 -88.22358557 2021-01-24 05:22:35 Coles, Illinois, US
2021-01-23 US Illinois Cook 17031 443600 8686 0 434914 41.84144849 -87.81658794 2021-01-24 05:22:35 Cook, Illinois, US
2021-01-23 US Illinois Crawford 17033 1828 20 0 1808 39.0032229 -87.75954624 2021-01-24 05:22:35 Crawford, Illinois, US
2021-01-23 US Illinois Cumberland 17035 1115 15 0 1100 39.27432424 -88.2401158 2021-01-24 05:22:35 Cumberland, Illinois, US
2021-01-23 US Illinois De Witt 17039 1189 20 0 1169 40.17514519 -88.90959682 2021-01-24 05:22:35 De Witt, Illinois, US
2021-01-23 US Illinois DeKalb 17037 7648 90 0 7558 41.89373302 -88.76958483 2021-01-24 05:22:35 DeKalb, Illinois, US
2021-01-23 US Illinois Douglas 17041 2044 28 0 2016 39.76768052 -88.21854195 2021-01-24 05:22:35 Douglas, Illinois, US
2021-01-23 US Illinois DuPage 17043 70712 1083 0 69629 41.85116968 -88.08642662 2021-01-24 05:22:35 DuPage, Illinois, US
2021-01-23 US Illinois Edgar 17045 1491 32 0 1459 39.6809186 -87.74759563 2021-01-24 05:22:35 Edgar, Illinois, US
2021-01-23 US Illinois Edwards 17047 477 8 0 469 38.41353228 -88.05720863 2021-01-24 05:22:35 Edwards, Illinois, US
2021-01-23 US Illinois Effingham 17049 4366 60 0 4306 39.05935711 -88.58969584 2021-01-24 05:22:35 Effingham, Illinois, US
2021-01-23 US Illinois Fayette 17051 2961 50 0 2911 39.00072038 -89.02452658 2021-01-24 05:22:35 Fayette, Illinois, US
2021-01-23 US Illinois Ford 17053 1404 43 0 1361 40.59706922 -88.22350769 2021-01-24 05:22:35 Ford, Illinois, US
2021-01-23 US Illinois Franklin 17055 3917 60 0 3857 37.99189086 -88.92567818 2021-01-24 05:22:35 Franklin, Illinois, US
2021-01-23 US Illinois Fulton 17057 2615 41 0 2574 40.47289135 -90.20862357 2021-01-24 05:22:35 Fulton, Illinois, US
2021-01-23 US Illinois Gallatin 17059 394 3 0 391 37.76430935 -88.22953869 2021-01-24 05:22:35 Gallatin, Illinois, US
2021-01-23 US Illinois Greene 17061 1279 30 0 1249 39.35907414 -90.388865 2021-01-24 05:22:35 Greene, Illinois, US
2021-01-23 US Illinois Grundy 17063 4518 50 0 4468 41.28569601 -88.41905692 2021-01-24 05:22:35 Grundy, Illinois, US
2021-01-23 US Illinois Hamilton 17065 730 14 0 716 38.08163641 -88.53883373 2021-01-24 05:22:35 Hamilton, Illinois, US
2021-01-23 US Illinois Hancock 17067 1550 25 0 1525 40.40423981 -91.16313899 2021-01-24 05:22:35 Hancock, Illinois, US
2021-01-23 US Illinois Hardin 17069 311 8 0 303 37.51810645 -88.26873022 2021-01-24 05:22:35 Hardin, Illinois, US
2021-01-23 US Illinois Henderson 17071 466 7 0 459 40.81908672 -90.92491462 2021-01-24 05:22:35 Henderson, Illinois, US
2021-01-23 US Illinois Henry 17073 4097 50 0 4047 41.3533994 -90.13296166 2021-01-24 05:22:35 Henry, Illinois, US
2021-01-23 US Illinois Iroquois 17075 2619 56 0 2563 40.74717633 -87.82466784 2021-01-24 05:22:35 Iroquois, Illinois, US
2021-01-23 US Illinois Jackson 17077 4296 59 0 4237 37.78595185 -89.38232563 2021-01-24 05:22:35 Jackson, Illinois, US
2021-01-23 US Illinois Jasper 17079 1060 14 0 1046 39.01054275 -88.15437049 2021-01-24 05:22:35 Jasper, Illinois, US
2021-01-23 US Illinois Jefferson 17081 3545 103 0 3442 38.29980057 -88.9240025 2021-01-24 05:22:35 Jefferson, Illinois, US
2021-01-23 US Illinois Jersey 17083 2294 43 0 2251 39.08869046 -90.35393073 2021-01-24 05:22:35 Jersey, Illinois, US
2021-01-23 US Illinois Jo Daviess 17085 1519 22 0 1497 42.36542373 -90.21094405 2021-01-24 05:22:35 Jo Daviess, Illinois, US
2021-01-23 US Illinois Johnson 17087 1253 9 0 1244 37.45939802 -88.88165419 2021-01-24 05:22:35 Johnson, Illinois, US
2021-01-23 US Illinois Kane 17089 47054 656 0 46398 41.93842729 -88.42861412 2021-01-24 05:22:35 Kane, Illinois, US
2021-01-23 US Illinois Kankakee 17091 11692 179 0 11513 41.13746989 -87.86205334 2021-01-24 05:22:35 Kankakee, Illinois, US
2021-01-23 US Illinois Kendall 17093 9970 72 0 9898 41.59081014 -88.42869583 2021-01-24 05:22:35 Kendall, Illinois, US
2021-01-23 US Illinois Knox 17095 4686 116 0 4570 40.93148779 -90.21330340000002 2021-01-24 05:22:35 Knox, Illinois, US
2021-01-23 US Illinois LaSalle 17099 9757 197 0 9560 41.34426129999999 -88.88633881 2021-01-24 05:22:35 LaSalle, Illinois, US
2021-01-23 US Illinois Lake 17097 54489 848 0 53641 42.3224907 -88.00367925 2021-01-24 05:22:35 Lake, Illinois, US
2021-01-23 US Illinois Lawrence 17101 2208 21 0 2187 38.71987914 -87.72884035 2021-01-24 05:22:35 Lawrence, Illinois, US
2021-01-23 US Illinois Lee 17103 3133 37 0 3096 41.74583951 -89.29977132 2021-01-24 05:22:35 Lee, Illinois, US
2021-01-23 US Illinois Livingston 17105 3779 60 0 3719 40.89188292 -88.55784752 2021-01-24 05:22:35 Livingston, Illinois, US
2021-01-23 US Illinois Logan 17107 3165 45 0 3120 40.12581572 -89.36638784 2021-01-24 05:22:35 Logan, Illinois, US
2021-01-23 US Illinois Macon 17115 8963 171 0 8792 39.86064913 -88.96342505 2021-01-24 05:22:35 Macon, Illinois, US
2021-01-23 US Illinois Macoupin 17117 4002 70 0 3932 39.26119767 -89.92424028 2021-01-24 05:22:35 Macoupin, Illinois, US
2021-01-23 US Illinois Madison 17119 25198 410 0 24788 38.83042506 -89.90422563 2021-01-24 05:22:35 Madison, Illinois, US
2021-01-23 US Illinois Marion 17121 4063 107 0 3956 38.64963204 -88.91899208 2021-01-24 05:22:35 Marion, Illinois, US
2021-01-23 US Illinois Marshall 17123 703 13 0 690 41.0327901 -89.34510444 2021-01-24 05:22:35 Marshall, Illinois, US
2021-01-23 US Illinois Mason 17125 1190 40 0 1150 40.23917274 -89.91824452 2021-01-24 05:22:35 Mason, Illinois, US
2021-01-23 US Illinois Massac 17127 1066 30 0 1036 37.22078441 -88.71036614 2021-01-24 05:22:35 Massac, Illinois, US
2021-01-23 US Illinois McDonough 17109 2192 39 0 2153 40.45674722 -90.67775541 2021-01-24 05:22:35 McDonough, Illinois, US
2021-01-23 US Illinois McHenry 17111 22153 231 0 21922 42.32451172 -88.45248227 2021-01-24 05:22:35 McHenry, Illinois, US
2021-01-23 US Illinois McLean 17113 13537 136 0 13401 40.48996987 -88.84621113 2021-01-24 05:22:35 McLean, Illinois, US
2021-01-23 US Illinois Menard 17129 912 6 0 906 40.02742725 -89.80246001 2021-01-24 05:22:35 Menard, Illinois, US
2021-01-23 US Illinois Mercer 17131 1182 30 0 1152 41.20596782 -90.74290052 2021-01-24 05:22:35 Mercer, Illinois, US
2021-01-23 US Illinois Monroe 17133 3667 71 0 3596 38.27594376 -90.17761038 2021-01-24 05:22:35 Monroe, Illinois, US
2021-01-23 US Illinois Montgomery 17135 3154 50 0 3104 39.23198845 -89.47809254 2021-01-24 05:22:35 Montgomery, Illinois, US
2021-01-23 US Illinois Morgan 17137 3309 74 0 3235 39.71654544 -90.20255104 2021-01-24 05:22:35 Morgan, Illinois, US
2021-01-23 US Illinois Moultrie 17139 1412 20 0 1392 39.64187451 -88.62099969 2021-01-24 05:22:35 Moultrie, Illinois, US
2021-01-23 US Illinois Ogle 17141 4694 65 0 4629 42.04165196 -89.32184679 2021-01-24 05:22:35 Ogle, Illinois, US
2021-01-23 US Illinois Out of IL 80017 34 0 0 34 42.36542373 0.0 2021-01-24 05:22:35 Out of IL, Illinois, US
2021-01-23 US Illinois Peoria 17143 15398 237 0 15161 40.78702156 -89.76078901 2021-01-24 05:22:35 Peoria, Illinois, US
2021-01-23 US Illinois Perry 17145 2764 53 0 2711 38.08510853 -89.36856219 2021-01-24 05:22:35 Perry, Illinois, US
2021-01-23 US Illinois Piatt 17147 1193 12 0 1181 40.01360584 -88.59319339 2021-01-24 05:22:35 Piatt, Illinois, US
2021-01-23 US Illinois Pike 17149 1593 45 0 1548 39.62265059 -90.8877017 2021-01-24 05:22:35 Pike, Illinois, US
2021-01-23 US Illinois Pope 17151 256 3 0 253 37.41391284 -88.56152109 2021-01-24 05:22:35 Pope, Illinois, US
2021-01-23 US Illinois Pulaski 17153 623 3 0 620 37.22631423 -89.13085001 2021-01-24 05:22:35 Pulaski, Illinois, US
2021-01-23 US Illinois Putnam 17155 356 1 0 355 41.2013541 -89.2869272 2021-01-24 05:22:35 Putnam, Illinois, US
2021-01-23 US Illinois Randolph 17157 3798 68 0 3730 38.05095369 -89.82512254 2021-01-24 05:22:35 Randolph, Illinois, US
2021-01-23 US Illinois Richland 17159 1569 37 0 1532 38.71240969 -88.08475366 2021-01-24 05:22:35 Richland, Illinois, US
2021-01-23 US Illinois Rock Island 17161 12168 266 0 11902 41.46613806 -90.57042164 2021-01-24 05:22:35 Rock Island, Illinois, US
2021-01-23 US Illinois Saline 17165 2082 39 0 2043 37.75332999 -88.54119706 2021-01-24 05:22:35 Saline, Illinois, US
2021-01-23 US Illinois Sangamon 17167 14842 205 0 14637 39.75836914 -89.65872023 2021-01-24 05:22:35 Sangamon, Illinois, US
2021-01-23 US Illinois Schuyler 17169 646 5 0 641 40.1571798 -90.61114163 2021-01-24 05:22:35 Schuyler, Illinois, US
2021-01-23 US Illinois Scott 17171 407 1 0 406 39.6429169 -90.47814431 2021-01-24 05:22:35 Scott, Illinois, US
2021-01-23 US Illinois Shelby 17173 2017 32 0 1985 39.39133527 -88.80611122 2021-01-24 05:22:35 Shelby, Illinois, US
2021-01-23 US Illinois St. Clair 17163 22904 409 0 22495 38.46996033 -89.93063427 2021-01-24 05:22:35 St. Clair, Illinois, US
2021-01-23 US Illinois Stark 17175 498 20 0 478 41.09309773 -89.79745866 2021-01-24 05:22:35 Stark, Illinois, US
2021-01-23 US Illinois Stephenson 17177 3618 57 0 3561 42.35129217 -89.662598 2021-01-24 05:22:35 Stephenson, Illinois, US
2021-01-23 US Illinois Tazewell 17179 12248 218 0 12030 40.50716185 -89.51404662 2021-01-24 05:22:35 Tazewell, Illinois, US
2021-01-23 US Illinois Unassigned 90017 129 1934 0 0 42.36542373 0.0 2021-01-24 05:22:35 Unassigned, Illinois, US
2021-01-23 US Illinois Union 17181 2034 30 0 2004 37.47119609 -89.25548938 2021-01-24 05:22:35 Union, Illinois, US
2021-01-23 US Illinois Vermilion 17183 7758 100 0 7658 40.18417171 -87.73384359 2021-01-24 05:22:35 Vermilion, Illinois, US
2021-01-23 US Illinois Wabash 17185 1216 12 0 1204 38.44272901 -87.84922065 2021-01-24 05:22:35 Wabash, Illinois, US
2021-01-23 US Illinois Warren 17187 1601 41 0 1560 40.84925021 -90.6147432 2021-01-24 05:22:35 Warren, Illinois, US
2021-01-23 US Illinois Washington 17189 1490 20 0 1470 38.35309213 -89.40982703 2021-01-24 05:22:35 Washington, Illinois, US
2021-01-23 US Illinois Wayne 17191 1546 42 0 1504 38.42955355 -88.42586459 2021-01-24 05:22:35 Wayne, Illinois, US
2021-01-23 US Illinois White 17193 1389 23 0 1366 38.08706198 -88.17657461 2021-01-24 05:22:35 White, Illinois, US
2021-01-23 US Illinois Whiteside 17195 5422 135 0 5287 41.75509713 -89.91556058 2021-01-24 05:22:35 Whiteside, Illinois, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;