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

100 rows where "last_update" is on date 2020-05-10 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 · 100 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-05-09 US Illinois Adams 17001 41 1 0 40 39.98815591 -91.18786813 2020-05-10 02:32:30 Adams, Illinois, US
2020-05-09 US Illinois Alexander 17003 6 0 0 6 37.18049267 -89.32910838 2020-05-10 02:32:30 Alexander, Illinois, US
2020-05-09 US Illinois Bond 17005 8 1 0 7 38.88829622 -89.43534887 2020-05-10 02:32:30 Bond, Illinois, US
2020-05-09 US Illinois Boone 17007 185 11 0 174 42.32359279 -88.82345779 2020-05-10 02:32:30 Boone, Illinois, US
2020-05-09 US Illinois Brown 17009 8 0 0 8 39.96209138 -90.75068024 2020-05-10 02:32:30 Brown, Illinois, US
2020-05-09 US Illinois Bureau 17011 12 1 0 11 41.40385234 -89.5283051 2020-05-10 02:32:30 Bureau, Illinois, US
2020-05-09 US Illinois Calhoun 17013 1 0 0 1 39.16840183 -90.66330078 2020-05-10 02:32:30 Calhoun, Illinois, US
2020-05-09 US Illinois Carroll 17015 10 2 0 8 42.06823429 -89.93395545 2020-05-10 02:32:30 Carroll, Illinois, US
2020-05-09 US Illinois Cass 17017 56 0 0 56 39.96991073 -90.24734436 2020-05-10 02:32:30 Cass, Illinois, US
2020-05-09 US Illinois Champaign 17019 256 6 0 250 40.13919438 -88.20046615 2020-05-10 02:32:30 Champaign, Illinois, US
2020-05-09 US Illinois Christian 17021 29 4 0 25 39.54581621 -89.27780482 2020-05-10 02:32:30 Christian, Illinois, US
2020-05-09 US Illinois Clark 17023 7 0 0 7 39.33425789 -87.78705622 2020-05-10 02:32:30 Clark, Illinois, US
2020-05-09 US Illinois Clay 17025 2 0 0 2 38.75388572 -88.48914513 2020-05-10 02:32:30 Clay, Illinois, US
2020-05-09 US Illinois Clinton 17027 126 10 0 116 38.60704876 -89.42385254 2020-05-10 02:32:30 Clinton, Illinois, US
2020-05-09 US Illinois Coles 17029 23 1 0 22 39.51949084 -88.22358557 2020-05-10 02:32:30 Coles, Illinois, US
2020-05-09 US Illinois Cook 17031 51674 2264 0 49410 41.84144849 -87.81658794 2020-05-10 02:32:30 Cook, Illinois, US
2020-05-09 US Illinois Crawford 17033 10 0 0 10 39.0032229 -87.75954624 2020-05-10 02:32:30 Crawford, Illinois, US
2020-05-09 US Illinois Cumberland 17035 4 0 0 4 39.27432424 -88.2401158 2020-05-10 02:32:30 Cumberland, Illinois, US
2020-05-09 US Illinois De Witt 17039 3 0 0 3 40.17514519 -88.90959682 2020-05-10 02:32:30 De Witt, Illinois, US
2020-05-09 US Illinois DeKalb 17037 170 2 0 168 41.89373302 -88.76958483 2020-05-10 02:32:30 DeKalb, Illinois, US
2020-05-09 US Illinois Douglas 17041 20 0 0 20 39.76768052 -88.21854195 2020-05-10 02:32:30 Douglas, Illinois, US
2020-05-09 US Illinois DuPage 17043 4493 247 0 4246 41.85116968 -88.08642662 2020-05-10 02:32:30 DuPage, Illinois, US
2020-05-09 US Illinois Effingham 17049 6 1 0 5 39.05935711 -88.58969584 2020-05-10 02:32:30 Effingham, Illinois, US
2020-05-09 US Illinois Fayette 17051 17 2 0 15 39.00072038 -89.02452658 2020-05-10 02:32:30 Fayette, Illinois, US
2020-05-09 US Illinois Ford 17053 13 1 0 12 40.59706922 -88.22350769 2020-05-10 02:32:30 Ford, Illinois, US
2020-05-09 US Illinois Franklin 17055 10 0 0 10 37.99189086 -88.92567818 2020-05-10 02:32:30 Franklin, Illinois, US
2020-05-09 US Illinois Fulton 17057 3 0 0 3 40.47289135 -90.20862357 2020-05-10 02:32:30 Fulton, Illinois, US
2020-05-09 US Illinois Gallatin 17059 2 0 0 2 37.76430935 -88.22953869 2020-05-10 02:32:30 Gallatin, Illinois, US
2020-05-09 US Illinois Greene 17061 4 0 0 4 39.35907414 -90.388865 2020-05-10 02:32:30 Greene, Illinois, US
2020-05-09 US Illinois Grundy 17063 58 1 0 57 41.28569601 -88.41905692 2020-05-10 02:32:30 Grundy, Illinois, US
2020-05-09 US Illinois Hamilton 17065 2 0 0 2 38.08163641 -88.53883373 2020-05-10 02:32:30 Hamilton, Illinois, US
2020-05-09 US Illinois Hancock 17067 11 0 0 11 40.40423981 -91.16313899 2020-05-10 02:32:30 Hancock, Illinois, US
2020-05-09 US Illinois Hardin 17069 1 0 0 1 37.51810645 -88.26873022 2020-05-10 02:32:30 Hardin, Illinois, US
2020-05-09 US Illinois Henderson 17071 6 0 0 6 40.81908672 -90.92491462 2020-05-10 02:32:30 Henderson, Illinois, US
2020-05-09 US Illinois Henry 17073 58 0 0 58 41.3533994 -90.13296166 2020-05-10 02:32:30 Henry, Illinois, US
2020-05-09 US Illinois Iroquois 17075 89 2 0 87 40.74717633 -87.82466784 2020-05-10 02:32:30 Iroquois, Illinois, US
2020-05-09 US Illinois Jackson 17077 162 10 0 152 37.78595185 -89.38232563 2020-05-10 02:32:30 Jackson, Illinois, US
2020-05-09 US Illinois Jasper 17079 46 6 0 40 39.01054275 -88.15437049 2020-05-10 02:32:30 Jasper, Illinois, US
2020-05-09 US Illinois Jefferson 17081 94 15 0 79 38.29980057 -88.9240025 2020-05-10 02:32:30 Jefferson, Illinois, US
2020-05-09 US Illinois Jersey 17083 16 1 0 15 39.08869046 -90.35393073 2020-05-10 02:32:30 Jersey, Illinois, US
2020-05-09 US Illinois Jo Daviess 17085 18 0 0 18 42.36542373 -90.21094405 2020-05-10 02:32:30 Jo Daviess, Illinois, US
2020-05-09 US Illinois Johnson 17087 4 0 0 4 37.45939802 -88.88165419 2020-05-10 02:32:30 Johnson, Illinois, US
2020-05-09 US Illinois Kane 17089 2818 88 0 2730 41.93842729 -88.42861412 2020-05-10 02:32:30 Kane, Illinois, US
2020-05-09 US Illinois Kankakee 17091 479 29 0 450 41.13746989 -87.86205334 2020-05-10 02:32:30 Kankakee, Illinois, US
2020-05-09 US Illinois Kendall 17093 388 12 0 376 41.59081014 -88.42869583 2020-05-10 02:32:30 Kendall, Illinois, US
2020-05-09 US Illinois Knox 17095 71 0 0 71 40.93148779 -90.21330340000002 2020-05-10 02:32:30 Knox, Illinois, US
2020-05-09 US Illinois LaSalle 17099 102 5 0 97 41.34426129999999 -88.88633881 2020-05-10 02:32:30 LaSalle, Illinois, US
2020-05-09 US Illinois Lake 17097 5199 173 0 5026 42.3224907 -88.00367925 2020-05-10 02:32:30 Lake, Illinois, US
2020-05-09 US Illinois Lawrence 17101 4 0 0 4 38.71987914 -87.72884035 2020-05-10 02:32:30 Lawrence, Illinois, US
2020-05-09 US Illinois Lee 17103 63 0 0 63 41.74583951 -89.29977132 2020-05-10 02:32:30 Lee, Illinois, US
2020-05-09 US Illinois Livingston 17105 24 1 0 23 40.89188292 -88.55784752 2020-05-10 02:32:30 Livingston, Illinois, US
2020-05-09 US Illinois Logan 17107 9 0 0 9 40.12581572 -89.36638784 2020-05-10 02:32:30 Logan, Illinois, US
2020-05-09 US Illinois Macon 17115 140 15 0 125 39.86064913 -88.96342505 2020-05-10 02:32:30 Macon, Illinois, US
2020-05-09 US Illinois Macoupin 17117 38 1 0 37 39.26119767 -89.92424028 2020-05-10 02:32:30 Macoupin, Illinois, US
2020-05-09 US Illinois Madison 17119 414 31 0 383 38.83042506 -89.90422563 2020-05-10 02:32:30 Madison, Illinois, US
2020-05-09 US Illinois Marion 17121 43 0 0 43 38.64963204 -88.91899208 2020-05-10 02:32:30 Marion, Illinois, US
2020-05-09 US Illinois Marshall 17123 4 0 0 4 41.0327901 -89.34510444 2020-05-10 02:32:30 Marshall, Illinois, US
2020-05-09 US Illinois Mason 17125 15 0 0 15 40.23917274 -89.91824452 2020-05-10 02:32:30 Mason, Illinois, US
2020-05-09 US Illinois Massac 17127 6 0 0 6 37.22078441 -88.71036614 2020-05-10 02:32:30 Massac, Illinois, US
2020-05-09 US Illinois McDonough 17109 49 2 0 47 40.45674722 -90.67775541 2020-05-10 02:32:30 McDonough, Illinois, US
2020-05-09 US Illinois McHenry 17111 936 52 0 884 42.32451172 -88.45248227 2020-05-10 02:32:30 McHenry, Illinois, US
2020-05-09 US Illinois McLean 17113 115 3 0 112 40.48996987 -88.84621113 2020-05-10 02:32:30 McLean, Illinois, US
2020-05-09 US Illinois Menard 17129 17 0 0 17 40.02742725 -89.80246001 2020-05-10 02:32:30 Menard, Illinois, US
2020-05-09 US Illinois Mercer 17131 11 0 0 11 41.20596782 -90.74290052 2020-05-10 02:32:30 Mercer, Illinois, US
2020-05-09 US Illinois Monroe 17133 79 11 0 68 38.27594376 -90.17761038 2020-05-10 02:32:30 Monroe, Illinois, US
2020-05-09 US Illinois Montgomery 17135 34 1 0 33 39.23198845 -89.47809254 2020-05-10 02:32:30 Montgomery, Illinois, US
2020-05-09 US Illinois Morgan 17137 30 1 0 29 39.71654544 -90.20255104 2020-05-10 02:32:30 Morgan, Illinois, US
2020-05-09 US Illinois Moultrie 17139 6 0 0 6 39.64187451 -88.62099969 2020-05-10 02:32:30 Moultrie, Illinois, US
2020-05-09 US Illinois Ogle 17141 148 1 0 147 42.04165196 -89.32184679 2020-05-10 02:32:30 Ogle, Illinois, US
2020-05-09 US Illinois Out of IL 80017 77 3 0 74 42.36542373 0.0 2020-05-10 02:32:30 Out of IL, Illinois, US
2020-05-09 US Illinois Peoria 17143 136 4 0 132 40.78702156 -89.76078901 2020-05-10 02:32:30 Peoria, Illinois, US
2020-05-09 US Illinois Perry 17145 36 0 0 36 38.08510853 -89.36856219 2020-05-10 02:32:30 Perry, Illinois, US
2020-05-09 US Illinois Piatt 17147 7 0 0 7 40.01360584 -88.59319339 2020-05-10 02:32:30 Piatt, Illinois, US
2020-05-09 US Illinois Pike 17149 1 0 0 1 39.62265059 -90.8877017 2020-05-10 02:32:30 Pike, Illinois, US
2020-05-09 US Illinois Pope 17151 1 0 0 1 37.41391284 -88.56152109 2020-05-10 02:32:30 Pope, Illinois, US
2020-05-09 US Illinois Pulaski 17153 27 0 0 27 37.22631423 -89.13085001 2020-05-10 02:32:30 Pulaski, Illinois, US
2020-05-09 US Illinois Randolph 17157 217 2 0 215 38.05095369 -89.82512254 2020-05-10 02:32:30 Randolph, Illinois, US
2020-05-09 US Illinois Richland 17159 3 0 0 3 38.71240969 -88.08475366 2020-05-10 02:32:30 Richland, Illinois, US
2020-05-09 US Illinois Rock Island 17161 507 16 0 491 41.46613806 -90.57042164 2020-05-10 02:32:30 Rock Island, Illinois, US
2020-05-09 US Illinois Saline 17165 5 0 0 5 37.75332999 -88.54119706 2020-05-10 02:32:30 Saline, Illinois, US
2020-05-09 US Illinois Sangamon 17167 256 19 0 237 39.75836914 -89.65872023 2020-05-10 02:32:30 Sangamon, Illinois, US
2020-05-09 US Illinois Schuyler 17169 7 0 0 7 40.1571798 -90.61114163 2020-05-10 02:32:30 Schuyler, Illinois, US
2020-05-09 US Illinois Shelby 17173 10 1 0 9 39.39133527 -88.80611122 2020-05-10 02:32:30 Shelby, Illinois, US
2020-05-09 US Illinois St. Clair 17163 689 49 0 640 38.46996033 -89.93063427 2020-05-10 02:32:30 St. Clair, Illinois, US
2020-05-09 US Illinois Stark 17175 1 0 0 1 41.09309773 -89.79745866 2020-05-10 02:32:30 Stark, Illinois, US
2020-05-09 US Illinois Stephenson 17177 88 0 0 88 42.35129217 -89.662598 2020-05-10 02:32:30 Stephenson, Illinois, US
2020-05-09 US Illinois Tazewell 17179 59 4 0 55 40.50716185 -89.51404662 2020-05-10 02:32:30 Tazewell, Illinois, US
2020-05-09 US Illinois Unassigned 90017 73 0 0 73 42.36542373 0.0 2020-05-10 02:32:30 Unassigned, Illinois, US
2020-05-09 US Illinois Union 17181 62 1 0 61 37.47119609 -89.25548938 2020-05-10 02:32:30 Union, Illinois, US
2020-05-09 US Illinois Vermilion 17183 25 1 0 24 40.18417171 -87.73384359 2020-05-10 02:32:30 Vermilion, Illinois, US
2020-05-09 US Illinois Wabash 17185 1 0 0 1 38.44272901 -87.84922065 2020-05-10 02:32:30 Wabash, Illinois, US
2020-05-09 US Illinois Warren 17187 97 0 0 97 40.84925021 -90.6147432 2020-05-10 02:32:30 Warren, Illinois, US
2020-05-09 US Illinois Washington 17189 15 0 0 15 38.35309213 -89.40982703 2020-05-10 02:32:30 Washington, Illinois, US
2020-05-09 US Illinois Wayne 17191 3 0 0 3 38.42955355 -88.42586459 2020-05-10 02:32:30 Wayne, Illinois, US
2020-05-09 US Illinois White 17193 2 0 0 2 38.08706198 -88.17657461 2020-05-10 02:32:30 White, Illinois, US
2020-05-09 US Illinois Whiteside 17195 102 6 0 96 41.75509713 -89.91556058 2020-05-10 02:32:30 Whiteside, Illinois, US
2020-05-09 US Illinois Will 17197 3636 202 0 3434 41.44619267 -87.97862712 2020-05-10 02:32:30 Will, Illinois, US
2020-05-09 US Illinois Williamson 17199 44 1 0 43 37.73033511 -88.92994027 2020-05-10 02:32:30 Williamson, Illinois, US
2020-05-09 US Illinois Winnebago 17201 877 24 0 853 42.33641854 -89.16085327 2020-05-10 02:32:30 Winnebago, Illinois, US
2020-05-09 US Illinois Woodford 17203 15 1 0 14 40.78579374 -89.20973757 2020-05-10 02:32:30 Woodford, Illinois, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;