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 "day" is on date 2021-05-09 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-05-09 US Illinois Adams 17001 8407 123 0   39.98815591 -91.18786813 2021-05-10 04:20:38 Adams, Illinois, US
2021-05-09 US Illinois Alexander 17003 467 11 0   37.18049267 -89.32910838 2021-05-10 04:20:38 Alexander, Illinois, US
2021-05-09 US Illinois Bond 17005 2037 24 0   38.88829622 -89.43534887 2021-05-10 04:20:38 Bond, Illinois, US
2021-05-09 US Illinois Boone 17007 6664 72 0   42.32359279 -88.82345779 2021-05-10 04:20:38 Boone, Illinois, US
2021-05-09 US Illinois Brown 17009 703 6 0   39.96209138 -90.75068024 2021-05-10 04:20:38 Brown, Illinois, US
2021-05-09 US Illinois Bureau 17011 3696 82 0   41.40385234 -89.5283051 2021-05-10 04:20:38 Bureau, Illinois, US
2021-05-09 US Illinois Calhoun 17013 516 2 0   39.16840183 -90.66330078 2021-05-10 04:20:38 Calhoun, Illinois, US
2021-05-09 US Illinois Carroll 17015 1745 36 0   42.06823429 -89.93395545 2021-05-10 04:20:38 Carroll, Illinois, US
2021-05-09 US Illinois Cass 17017 1984 25 0   39.96991073 -90.24734436 2021-05-10 04:20:38 Cass, Illinois, US
2021-05-09 US Illinois Champaign 17019 20530 145 0   40.13919438 -88.20046615 2021-05-10 04:20:38 Champaign, Illinois, US
2021-05-09 US Illinois Christian 17021 3644 73 0   39.54581621 -89.27780482 2021-05-10 04:20:38 Christian, Illinois, US
2021-05-09 US Illinois Clark 17023 1785 33 0   39.33425789 -87.78705622 2021-05-10 04:20:38 Clark, Illinois, US
2021-05-09 US Illinois Clay 17025 1480 43 0   38.75388572 -88.48914513 2021-05-10 04:20:38 Clay, Illinois, US
2021-05-09 US Illinois Clinton 17027 5751 90 0   38.60704876 -89.42385254 2021-05-10 04:20:38 Clinton, Illinois, US
2021-05-09 US Illinois Coles 17029 5665 94 0   39.51949084 -88.22358557 2021-05-10 04:20:38 Coles, Illinois, US
2021-05-09 US Illinois Cook 17031 542450 10056 0   41.84144849 -87.81658794 2021-05-10 04:20:38 Cook, Illinois, US
2021-05-09 US Illinois Crawford 17033 2114 26 0   39.0032229 -87.75954624 2021-05-10 04:20:38 Crawford, Illinois, US
2021-05-09 US Illinois Cumberland 17035 1291 19 0   39.27432424 -88.2401158 2021-05-10 04:20:38 Cumberland, Illinois, US
2021-05-09 US Illinois De Witt 17039 1498 24 0   40.17514519 -88.90959682 2021-05-10 04:20:38 De Witt, Illinois, US
2021-05-09 US Illinois DeKalb 17037 9812 119 0   41.89373302 -88.76958483 2021-05-10 04:20:38 DeKalb, Illinois, US
2021-05-09 US Illinois Douglas 17041 2583 35 0   39.76768052 -88.21854195 2021-05-10 04:20:38 Douglas, Illinois, US
2021-05-09 US Illinois DuPage 17043 90032 1276 0   41.85116968 -88.08642662 2021-05-10 04:20:38 DuPage, Illinois, US
2021-05-09 US Illinois Edgar 17045 1685 39 0   39.6809186 -87.74759563 2021-05-10 04:20:38 Edgar, Illinois, US
2021-05-09 US Illinois Edwards 17047 568 12 0   38.41353228 -88.05720863 2021-05-10 04:20:38 Edwards, Illinois, US
2021-05-09 US Illinois Effingham 17049 4721 72 0   39.05935711 -88.58969584 2021-05-10 04:20:38 Effingham, Illinois, US
2021-05-09 US Illinois Fayette 17051 3169 55 0   39.00072038 -89.02452658 2021-05-10 04:20:38 Fayette, Illinois, US
2021-05-09 US Illinois Ford 17053 1774 46 0   40.59706922 -88.22350769 2021-05-10 04:20:38 Ford, Illinois, US
2021-05-09 US Illinois Franklin 17055 4437 74 0   37.99189086 -88.92567818 2021-05-10 04:20:38 Franklin, Illinois, US
2021-05-09 US Illinois Fulton 17057 3895 55 0   40.47289135 -90.20862357 2021-05-10 04:20:38 Fulton, Illinois, US
2021-05-09 US Illinois Gallatin 17059 458 4 0   37.76430935 -88.22953869 2021-05-10 04:20:38 Gallatin, Illinois, US
2021-05-09 US Illinois Greene 17061 1432 33 0   39.35907414 -90.388865 2021-05-10 04:20:38 Greene, Illinois, US
2021-05-09 US Illinois Grundy 17063 5852 75 0   41.28569601 -88.41905692 2021-05-10 04:20:38 Grundy, Illinois, US
2021-05-09 US Illinois Hamilton 17065 831 15 0   38.08163641 -88.53883373 2021-05-10 04:20:38 Hamilton, Illinois, US
2021-05-09 US Illinois Hancock 17067 1752 31 0   40.40423981 -91.16313899 2021-05-10 04:20:38 Hancock, Illinois, US
2021-05-09 US Illinois Hardin 17069 384 12 0   37.51810645 -88.26873022 2021-05-10 04:20:38 Hardin, Illinois, US
2021-05-09 US Illinois Henderson 17071 525 14 0   40.81908672 -90.92491462 2021-05-10 04:20:38 Henderson, Illinois, US
2021-05-09 US Illinois Henry 17073 4929 63 0   41.3533994 -90.13296166 2021-05-10 04:20:38 Henry, Illinois, US
2021-05-09 US Illinois Iroquois 17075 2993 66 0   40.74717633 -87.82466784 2021-05-10 04:20:38 Iroquois, Illinois, US
2021-05-09 US Illinois Jackson 17077 5003 64 0   37.78595185 -89.38232563 2021-05-10 04:20:38 Jackson, Illinois, US
2021-05-09 US Illinois Jasper 17079 1150 18 0   39.01054275 -88.15437049 2021-05-10 04:20:38 Jasper, Illinois, US
2021-05-09 US Illinois Jefferson 17081 4270 120 0   38.29980057 -88.9240025 2021-05-10 04:20:38 Jefferson, Illinois, US
2021-05-09 US Illinois Jersey 17083 2688 49 0   39.08869046 -90.35393073 2021-05-10 04:20:38 Jersey, Illinois, US
2021-05-09 US Illinois Jo Daviess 17085 1805 24 0   42.36542373 -90.21094405 2021-05-10 04:20:38 Jo Daviess, Illinois, US
2021-05-09 US Illinois Johnson 17087 1427 15 0   37.45939802 -88.88165419 2021-05-10 04:20:38 Johnson, Illinois, US
2021-05-09 US Illinois Kane 17089 58044 770 0   41.93842729 -88.42861412 2021-05-10 04:20:38 Kane, Illinois, US
2021-05-09 US Illinois Kankakee 17091 14074 209 0   41.13746989 -87.86205334 2021-05-10 04:20:38 Kankakee, Illinois, US
2021-05-09 US Illinois Kendall 17093 12941 92 0   41.59081014 -88.42869583 2021-05-10 04:20:38 Kendall, Illinois, US
2021-05-09 US Illinois Knox 17095 5525 141 0   40.93148779 -90.21330340000002 2021-05-10 04:20:38 Knox, Illinois, US
2021-05-09 US Illinois LaSalle 17099 12459 243 0   41.34426129999999 -88.88633881 2021-05-10 04:20:38 LaSalle, Illinois, US
2021-05-09 US Illinois Lake 17097 66830 984 0   42.3224907 -88.00367925 2021-05-10 04:20:38 Lake, Illinois, US
2021-05-09 US Illinois Lawrence 17101 2404 25 0   38.71987914 -87.72884035 2021-05-10 04:20:38 Lawrence, Illinois, US
2021-05-09 US Illinois Lee 17103 4141 52 0   41.74583951 -89.29977132 2021-05-10 04:20:38 Lee, Illinois, US
2021-05-09 US Illinois Livingston 17105 4801 85 0   40.89188292 -88.55784752 2021-05-10 04:20:38 Livingston, Illinois, US
2021-05-09 US Illinois Logan 17107 3850 57 0   40.12581572 -89.36638784 2021-05-10 04:20:38 Logan, Illinois, US
2021-05-09 US Illinois Macon 17115 10698 198 0   39.86064913 -88.96342505 2021-05-10 04:20:38 Macon, Illinois, US
2021-05-09 US Illinois Macoupin 17117 4675 81 0   39.26119767 -89.92424028 2021-05-10 04:20:38 Macoupin, Illinois, US
2021-05-09 US Illinois Madison 17119 30392 518 0   38.83042506 -89.90422563 2021-05-10 04:20:38 Madison, Illinois, US
2021-05-09 US Illinois Marion 17121 4459 115 0   38.64963204 -88.91899208 2021-05-10 04:20:38 Marion, Illinois, US
2021-05-09 US Illinois Marshall 17123 1058 18 0   41.0327901 -89.34510444 2021-05-10 04:20:38 Marshall, Illinois, US
2021-05-09 US Illinois Mason 17125 1497 45 0   40.23917274 -89.91824452 2021-05-10 04:20:38 Mason, Illinois, US
2021-05-09 US Illinois Massac 17127 1334 40 0   37.22078441 -88.71036614 2021-05-10 04:20:38 Massac, Illinois, US
2021-05-09 US Illinois McDonough 17109 2819 47 0   40.45674722 -90.67775541 2021-05-10 04:20:38 McDonough, Illinois, US
2021-05-09 US Illinois McHenry 17111 28413 285 0   42.32451172 -88.45248227 2021-05-10 04:20:38 McHenry, Illinois, US
2021-05-09 US Illinois McLean 17113 18041 178 0   40.48996987 -88.84621113 2021-05-10 04:20:38 McLean, Illinois, US
2021-05-09 US Illinois Menard 17129 1229 12 0   40.02742725 -89.80246001 2021-05-10 04:20:38 Menard, Illinois, US
2021-05-09 US Illinois Mercer 17131 1456 33 0   41.20596782 -90.74290052 2021-05-10 04:20:38 Mercer, Illinois, US
2021-05-09 US Illinois Monroe 17133 4355 93 0   38.27594376 -90.17761038 2021-05-10 04:20:38 Monroe, Illinois, US
2021-05-09 US Illinois Montgomery 17135 3708 73 0   39.23198845 -89.47809254 2021-05-10 04:20:38 Montgomery, Illinois, US
2021-05-09 US Illinois Morgan 17137 3869 81 0   39.71654544 -90.20255104 2021-05-10 04:20:38 Morgan, Illinois, US
2021-05-09 US Illinois Moultrie 17139 1604 26 0   39.64187451 -88.62099969 2021-05-10 04:20:38 Moultrie, Illinois, US
2021-05-09 US Illinois Ogle 17141 6076 81 0   42.04165196 -89.32184679 2021-05-10 04:20:38 Ogle, Illinois, US
2021-05-09 US Illinois Out of IL 80017 1 0 0   42.36542373 0.0 2021-05-10 04:20:38 Out of IL, Illinois, US
2021-05-09 US Illinois Peoria 17143 22956 300 0   40.78702156 -89.76078901 2021-05-10 04:20:38 Peoria, Illinois, US
2021-05-09 US Illinois Perry 17145 3158 60 0   38.08510853 -89.36856219 2021-05-10 04:20:38 Perry, Illinois, US
2021-05-09 US Illinois Piatt 17147 1479 14 0   40.01360584 -88.59319339 2021-05-10 04:20:38 Piatt, Illinois, US
2021-05-09 US Illinois Pike 17149 1786 52 0   39.62265059 -90.8877017 2021-05-10 04:20:38 Pike, Illinois, US
2021-05-09 US Illinois Pope 17151 317 4 0   37.41391284 -88.56152109 2021-05-10 04:20:38 Pope, Illinois, US
2021-05-09 US Illinois Pulaski 17153 683 7 0   37.22631423 -89.13085001 2021-05-10 04:20:38 Pulaski, Illinois, US
2021-05-09 US Illinois Putnam 17155 481 3 0   41.2013541 -89.2869272 2021-05-10 04:20:38 Putnam, Illinois, US
2021-05-09 US Illinois Randolph 17157 4126 84 0   38.05095369 -89.82512254 2021-05-10 04:20:38 Randolph, Illinois, US
2021-05-09 US Illinois Richland 17159 1741 40 0   38.71240969 -88.08475366 2021-05-10 04:20:38 Richland, Illinois, US
2021-05-09 US Illinois Rock Island 17161 14861 308 0   41.46613806 -90.57042164 2021-05-10 04:20:38 Rock Island, Illinois, US
2021-05-09 US Illinois Saline 17165 2561 54 0   37.75332999 -88.54119706 2021-05-10 04:20:38 Saline, Illinois, US
2021-05-09 US Illinois Sangamon 17167 18625 234 0   39.75836914 -89.65872023 2021-05-10 04:20:38 Sangamon, Illinois, US
2021-05-09 US Illinois Schuyler 17169 743 5 0   40.1571798 -90.61114163 2021-05-10 04:20:38 Schuyler, Illinois, US
2021-05-09 US Illinois Scott 17171 478 1 0   39.6429169 -90.47814431 2021-05-10 04:20:38 Scott, Illinois, US
2021-05-09 US Illinois Shelby 17173 2290 37 0   39.39133527 -88.80611122 2021-05-10 04:20:38 Shelby, Illinois, US
2021-05-09 US Illinois St. Clair 17163 27762 512 0   38.46996033 -89.93063427 2021-05-10 04:20:38 St. Clair, Illinois, US
2021-05-09 US Illinois Stark 17175 634 23 0   41.09309773 -89.79745866 2021-05-10 04:20:38 Stark, Illinois, US
2021-05-09 US Illinois Stephenson 17177 4733 81 0   42.35129217 -89.662598 2021-05-10 04:20:38 Stephenson, Illinois, US
2021-05-09 US Illinois Tazewell 17179 16843 282 0   40.50716185 -89.51404662 2021-05-10 04:20:38 Tazewell, Illinois, US
2021-05-09 US Illinois Unassigned 90017 98 2354 0   42.36542373 0.0 2021-05-10 04:20:38 Unassigned, Illinois, US
2021-05-09 US Illinois Union 17181 2252 40 0   37.47119609 -89.25548938 2021-05-10 04:20:38 Union, Illinois, US
2021-05-09 US Illinois Vermilion 17183 9545 132 0   40.18417171 -87.73384359 2021-05-10 04:20:38 Vermilion, Illinois, US
2021-05-09 US Illinois Wabash 17185 1346 12 0   38.44272901 -87.84922065 2021-05-10 04:20:38 Wabash, Illinois, US
2021-05-09 US Illinois Warren 17187 1792 46 0   40.84925021 -90.6147432 2021-05-10 04:20:38 Warren, Illinois, US
2021-05-09 US Illinois Washington 17189 1638 25 0   38.35309213 -89.40982703 2021-05-10 04:20:38 Washington, Illinois, US
2021-05-09 US Illinois Wayne 17191 1768 52 0   38.42955355 -88.42586459 2021-05-10 04:20:38 Wayne, Illinois, US
2021-05-09 US Illinois White 17193 1693 26 0   38.08706198 -88.17657461 2021-05-10 04:20:38 White, Illinois, US
2021-05-09 US Illinois Whiteside 17195 7126 171 0   41.75509713 -89.91556058 2021-05-10 04:20:38 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;