daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
104,685 rows where province_or_state = "Illinois" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-17 | US | Illinois | Knox | 17095 | 3 | 0 | 0 | 3 | 40.93148779 | -90.21330340000002 | 2020-04-17 23:30:52 | Knox, Illinois, US |
2020-04-17 | US | Illinois | Lawrence | 17101 | 2 | 0 | 0 | 2 | 38.71987914 | -87.72884035 | 2020-04-17 23:30:52 | Lawrence, Illinois, US |
2020-04-17 | US | Illinois | Lee | 17103 | 17 | 0 | 0 | 17 | 41.74583951 | -89.29977132 | 2020-04-17 23:30:52 | Lee, Illinois, US |
2020-04-17 | US | Illinois | Livingston | 17105 | 18 | 0 | 0 | 18 | 40.89188292 | -88.55784752 | 2020-04-17 23:30:52 | Livingston, Illinois, US |
2020-04-17 | US | Illinois | Logan | 17107 | 5 | 0 | 0 | 5 | 40.12581572 | -89.36638784 | 2020-04-17 23:30:52 | Logan, Illinois, US |
2020-04-17 | US | Illinois | Macoupin | 17117 | 18 | 0 | 0 | 18 | 39.26119767 | -89.92424028 | 2020-04-17 23:30:52 | Macoupin, Illinois, US |
2020-04-17 | US | Illinois | Marion | 17121 | 17 | 0 | 0 | 17 | 38.64963204 | -88.91899208 | 2020-04-17 23:30:52 | Marion, Illinois, US |
2020-04-17 | US | Illinois | Marshall | 17123 | 2 | 0 | 0 | 2 | 41.0327901 | -89.34510444 | 2020-04-17 23:30:52 | Marshall, Illinois, US |
2020-04-17 | US | Illinois | Mason | 17125 | 4 | 0 | 0 | 4 | 40.23917274 | -89.91824452 | 2020-04-17 23:30:52 | Mason, Illinois, US |
2020-04-17 | US | Illinois | Massac | 17127 | 4 | 0 | 0 | 4 | 37.22078441 | -88.71036614 | 2020-04-17 23:30:52 | Massac, Illinois, US |
2020-04-17 | US | Illinois | McDonough | 17109 | 3 | 0 | 0 | 3 | 40.45674722 | -90.67775541 | 2020-04-17 23:30:52 | McDonough, Illinois, US |
2020-04-17 | US | Illinois | Menard | 17129 | 2 | 0 | 0 | 2 | 40.02742725 | -89.80246001 | 2020-04-17 23:30:52 | Menard, Illinois, US |
2020-04-17 | US | Illinois | Mercer | 17131 | 4 | 0 | 0 | 4 | 41.20596782 | -90.74290052 | 2020-04-17 23:30:52 | Mercer, Illinois, US |
2020-04-17 | US | Illinois | Moultrie | 17139 | 2 | 0 | 0 | 2 | 39.64187451 | -88.62099969 | 2020-04-17 23:30:52 | Moultrie, Illinois, US |
2020-04-17 | US | Illinois | Perry | 17145 | 1 | 0 | 0 | 1 | 38.08510853 | -89.36856219 | 2020-04-17 23:30:52 | Perry, Illinois, US |
2020-04-17 | US | Illinois | Piatt | 17147 | 7 | 0 | 0 | 7 | 40.01360584 | -88.59319339 | 2020-04-17 23:30:52 | Piatt, Illinois, US |
2020-04-17 | US | Illinois | Pike | 17149 | 1 | 0 | 0 | 1 | 39.62265059 | -90.8877017 | 2020-04-17 23:30:52 | Pike, Illinois, US |
2020-04-17 | US | Illinois | Pulaski | 17153 | 5 | 0 | 0 | 5 | 37.22631423 | -89.13085001 | 2020-04-17 23:30:52 | Pulaski, Illinois, US |
2020-04-17 | US | Illinois | Richland | 17159 | 2 | 0 | 0 | 2 | 38.71240969 | -88.08475366 | 2020-04-17 23:30:52 | Richland, Illinois, US |
2020-04-17 | US | Illinois | Saline | 17165 | 3 | 0 | 0 | 3 | 37.75332999 | -88.54119706 | 2020-04-17 23:30:52 | Saline, Illinois, US |
2020-04-17 | US | Illinois | Schuyler | 17169 | 1 | 0 | 0 | 1 | 40.157179799999994 | -90.61114163 | 2020-04-17 23:30:52 | Schuyler, Illinois, US |
2020-04-17 | US | Illinois | Shelby | 17173 | 4 | 0 | 0 | 4 | 39.39133527 | -88.80611122 | 2020-04-17 23:30:52 | Shelby, Illinois, US |
2020-04-17 | US | Illinois | Stark | 17175 | 1 | 0 | 0 | 1 | 41.09309773 | -89.79745866 | 2020-04-17 23:30:52 | Stark, Illinois, US |
2020-04-17 | US | Illinois | Stephenson | 17177 | 10 | 0 | 0 | 10 | 42.35129217 | -89.662598 | 2020-04-17 23:30:52 | Stephenson, Illinois, US |
2020-04-17 | US | Illinois | Union | 17181 | 4 | 0 | 0 | 4 | 37.47119609 | -89.25548938 | 2020-04-17 23:30:52 | Union, Illinois, US |
2020-04-17 | US | Illinois | Vermilion | 17183 | 8 | 0 | 0 | 8 | 40.18417171 | -87.73384359 | 2020-04-17 23:30:52 | Vermilion, Illinois, US |
2020-04-17 | US | Illinois | Wabash | 17185 | 1 | 0 | 0 | 1 | 38.44272901 | -87.84922065 | 2020-04-17 23:30:52 | Wabash, Illinois, US |
2020-04-17 | US | Illinois | Warren | 17187 | 2 | 0 | 0 | 2 | 40.84925021 | -90.6147432 | 2020-04-17 23:30:52 | Warren, Illinois, US |
2020-04-17 | US | Illinois | Washington | 17189 | 5 | 0 | 0 | 5 | 38.35309213 | -89.40982703 | 2020-04-17 23:30:52 | Washington, Illinois, US |
2020-04-17 | US | Illinois | Williamson | 17199 | 13 | 0 | 0 | 13 | 37.73033511 | -88.92994027 | 2020-04-17 23:30:52 | Williamson, Illinois, US |
2020-04-17 | US | Illinois | Woodford | 17203 | 11 | 0 | 0 | 11 | 40.78579374 | -89.20973757 | 2020-04-17 23:30:52 | Woodford, Illinois, US |
2021-05-29 | US | Illinois | Out of IL | 80017 | 3 | 0 | 0 | 42.36542373 | 0.0 | 2021-05-30 04:20:55 | Out of IL, Illinois, US | |
2021-03-07 | US | Illinois | Out of IL | 80017 | 2 | 0 | 0 | 42.36542373 | 0.0 | 2021-03-08 05:24:48 | Out of IL, Illinois, US | |
2020-07-23 | US | Illinois | Alexander | 17003 | 33 | 0 | 0 | 33 | 37.18049267 | -89.32910838 | 2020-07-24 05:30:40 | Alexander, Illinois, US |
2020-07-23 | US | Illinois | Brown | 17009 | 12 | 0 | 0 | 12 | 39.96209138 | -90.75068024 | 2020-07-24 05:30:40 | Brown, Illinois, US |
2020-07-23 | US | Illinois | Calhoun | 17013 | 4 | 0 | 0 | 4 | 39.16840183 | -90.66330078 | 2020-07-24 05:30:40 | Calhoun, Illinois, US |
2020-07-23 | US | Illinois | Clark | 17023 | 51 | 0 | 0 | 51 | 39.33425789 | -87.78705622 | 2020-07-24 05:30:40 | Clark, Illinois, US |
2020-07-23 | US | Illinois | Clay | 17025 | 9 | 0 | 0 | 9 | 38.75388572 | -88.48914513 | 2020-07-24 05:30:40 | Clay, Illinois, US |
2020-07-23 | US | Illinois | Crawford | 17033 | 28 | 0 | 0 | 28 | 39.0032229 | -87.75954624 | 2020-07-24 05:30:40 | Crawford, Illinois, US |
2020-07-23 | US | Illinois | De Witt | 17039 | 24 | 0 | 0 | 24 | 40.17514519 | -88.90959682 | 2020-07-24 05:30:40 | De Witt, Illinois, US |
2020-07-23 | US | Illinois | Edgar | 17045 | 20 | 0 | 0 | 20 | 39.6809186 | -87.74759563 | 2020-07-24 05:30:40 | Edgar, Illinois, US |
2020-07-23 | US | Illinois | Edwards | 17047 | 6 | 0 | 0 | 6 | 38.41353228 | -88.05720863 | 2020-07-24 05:30:40 | Edwards, Illinois, US |
2020-07-23 | US | Illinois | Franklin | 17055 | 84 | 0 | 0 | 84 | 37.99189086 | -88.92567818 | 2020-07-24 05:30:40 | Franklin, Illinois, US |
2020-07-23 | US | Illinois | Fulton | 17057 | 20 | 0 | 0 | 20 | 40.47289135 | -90.20862357 | 2020-07-24 05:30:40 | Fulton, Illinois, US |
2020-07-23 | US | Illinois | Gallatin | 17059 | 26 | 0 | 0 | 26 | 37.76430935 | -88.22953869 | 2020-07-24 05:30:40 | Gallatin, Illinois, US |
2020-07-23 | US | Illinois | Greene | 17061 | 14 | 0 | 0 | 14 | 39.35907414 | -90.388865 | 2020-07-24 05:30:40 | Greene, Illinois, US |
2020-07-23 | US | Illinois | Hamilton | 17065 | 11 | 0 | 0 | 11 | 38.08163641 | -88.53883373 | 2020-07-24 05:30:40 | Hamilton, Illinois, US |
2020-07-23 | US | Illinois | Hardin | 17069 | 9 | 0 | 0 | 9 | 37.51810645 | -88.26873022 | 2020-07-24 05:30:40 | Hardin, Illinois, US |
2020-07-23 | US | Illinois | Henderson | 17071 | 8 | 0 | 0 | 8 | 40.81908672 | -90.92491462 | 2020-07-24 05:30:40 | Henderson, Illinois, US |
2020-07-23 | US | Illinois | Johnson | 17087 | 47 | 0 | 0 | 47 | 37.45939802 | -88.88165419 | 2020-07-24 05:30:40 | Johnson, Illinois, US |
2020-07-23 | US | Illinois | Lawrence | 17101 | 32 | 0 | 0 | 32 | 38.71987914 | -87.72884035 | 2020-07-24 05:30:40 | Lawrence, Illinois, US |
2020-07-23 | US | Illinois | Logan | 17107 | 59 | 0 | 0 | 59 | 40.12581572 | -89.36638784 | 2020-07-24 05:30:40 | Logan, Illinois, US |
2020-07-23 | US | Illinois | Marion | 17121 | 107 | 0 | 0 | 107 | 38.64963204 | -88.91899208 | 2020-07-24 05:30:40 | Marion, Illinois, US |
2020-07-23 | US | Illinois | Marshall | 17123 | 15 | 0 | 0 | 15 | 41.0327901 | -89.34510444 | 2020-07-24 05:30:40 | Marshall, Illinois, US |
2020-07-23 | US | Illinois | Mason | 17125 | 36 | 0 | 0 | 36 | 40.23917274 | -89.91824452 | 2020-07-24 05:30:40 | Mason, Illinois, US |
2020-07-23 | US | Illinois | Massac | 17127 | 26 | 0 | 0 | 26 | 37.22078441 | -88.71036614 | 2020-07-24 05:30:40 | Massac, Illinois, US |
2020-07-23 | US | Illinois | Menard | 17129 | 37 | 0 | 0 | 37 | 40.02742725 | -89.80246001 | 2020-07-24 05:30:40 | Menard, Illinois, US |
2020-07-23 | US | Illinois | Mercer | 17131 | 42 | 0 | 0 | 42 | 41.20596782 | -90.74290052 | 2020-07-24 05:30:40 | Mercer, Illinois, US |
2020-07-23 | US | Illinois | Moultrie | 17139 | 37 | 0 | 0 | 37 | 39.64187451 | -88.62099969 | 2020-07-24 05:30:40 | Moultrie, Illinois, US |
2020-07-23 | US | Illinois | Out of IL | 80017 | 0 | 0 | 0 | 0 | 42.36542373 | 0.0 | 2020-07-24 05:30:40 | Out of IL, Illinois, US |
2020-07-23 | US | Illinois | Piatt | 17147 | 30 | 0 | 0 | 30 | 40.01360584 | -88.59319339 | 2020-07-24 05:30:40 | Piatt, Illinois, US |
2020-07-23 | US | Illinois | Pike | 17149 | 9 | 0 | 0 | 9 | 39.62265059 | -90.8877017 | 2020-07-24 05:30:40 | Pike, Illinois, US |
2020-07-23 | US | Illinois | Pope | 17151 | 3 | 0 | 0 | 3 | 37.41391284 | -88.56152109 | 2020-07-24 05:30:40 | Pope, Illinois, US |
2020-07-23 | US | Illinois | Pulaski | 17153 | 88 | 0 | 0 | 88 | 37.22631423 | -89.13085001 | 2020-07-24 05:30:40 | Pulaski, Illinois, US |
2020-07-23 | US | Illinois | Putnam | 17155 | 4 | 0 | 0 | 4 | 41.2013541 | -89.2869272 | 2020-07-24 05:30:40 | Putnam, Illinois, US |
2020-07-23 | US | Illinois | Richland | 17159 | 9 | 0 | 0 | 9 | 38.71240969 | -88.08475366 | 2020-07-24 05:30:40 | Richland, Illinois, US |
2020-07-23 | US | Illinois | Saline | 17165 | 64 | 0 | 0 | 64 | 37.75332999 | -88.54119706 | 2020-07-24 05:30:40 | Saline, Illinois, US |
2020-07-23 | US | Illinois | Schuyler | 17169 | 14 | 0 | 0 | 14 | 40.157179799999994 | -90.61114163 | 2020-07-24 05:30:40 | Schuyler, Illinois, US |
2020-07-23 | US | Illinois | Scott | 17171 | 6 | 0 | 0 | 6 | 39.642916899999996 | -90.47814431 | 2020-07-24 05:30:40 | Scott, Illinois, US |
2020-07-23 | US | Illinois | Stark | 17175 | 6 | 0 | 0 | 6 | 41.09309773 | -89.79745866 | 2020-07-24 05:30:40 | Stark, Illinois, US |
2020-07-23 | US | Illinois | Wabash | 17185 | 25 | 0 | 0 | 25 | 38.44272901 | -87.84922065 | 2020-07-24 05:30:40 | Wabash, Illinois, US |
2020-07-23 | US | Illinois | Warren | 17187 | 160 | 0 | 0 | 160 | 40.84925021 | -90.6147432 | 2020-07-24 05:30:40 | Warren, Illinois, US |
2020-07-23 | US | Illinois | Washington | 17189 | 40 | 0 | 0 | 40 | 38.35309213 | -89.40982703 | 2020-07-24 05:30:40 | Washington, Illinois, US |
2020-07-23 | US | Illinois | White | 17193 | 34 | 0 | 0 | 34 | 38.08706198 | -88.17657461 | 2020-07-24 05:30:40 | White, Illinois, US |
2022-11-12 | US | Illinois | Out of IL | 80017 | 4 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-13 04:21:14 | Out of IL, Illinois, US | |
2021-09-01 | US | Illinois | Out of IL | 80017 | 9 | 0 | 0 | 42.36542373 | 0.0 | 2021-09-02 04:21:15 | Out of IL, Illinois, US | |
2022-02-07 | US | Illinois | Out of IL | 80017 | 10 | 0 | 0 | 42.36542373 | 0.0 | 2022-02-08 04:21:15 | Out of IL, Illinois, US | |
2020-12-03 | US | Illinois | Henderson | 17071 | 306 | 0 | 0 | 306 | 40.81908672 | -90.92491462 | 2020-12-04 05:27:27 | Henderson, Illinois, US |
2020-12-03 | US | Illinois | Out of IL | 80017 | 10 | 0 | 0 | 10 | 42.36542373 | 0.0 | 2020-12-04 05:27:27 | Out of IL, Illinois, US |
2020-12-03 | US | Illinois | Putnam | 17155 | 256 | 0 | 0 | 256 | 41.2013541 | -89.2869272 | 2020-12-04 05:27:27 | Putnam, Illinois, US |
2020-12-03 | US | Illinois | Scott | 17171 | 251 | 0 | 0 | 251 | 39.6429169 | -90.47814431 | 2020-12-04 05:27:27 | Scott, Illinois, US |
2020-10-14 | US | Illinois | Brown | 17009 | 82 | 0 | 0 | 82 | 39.96209138 | -90.75068024 | 2020-10-15 04:24:28 | Brown, Illinois, US |
2020-10-14 | US | Illinois | Calhoun | 17013 | 66 | 0 | 0 | 66 | 39.16840183 | -90.66330078 | 2020-10-15 04:24:28 | Calhoun, Illinois, US |
2020-10-14 | US | Illinois | Edwards | 17047 | 84 | 0 | 0 | 84 | 38.41353228 | -88.05720863 | 2020-10-15 04:24:28 | Edwards, Illinois, US |
2020-10-14 | US | Illinois | Fulton | 17057 | 321 | 0 | 0 | 321 | 40.47289135 | -90.20862357 | 2020-10-15 04:24:28 | Fulton, Illinois, US |
2020-10-14 | US | Illinois | Hardin | 17069 | 47 | 0 | 0 | 47 | 37.51810645 | -88.26873022 | 2020-10-15 04:24:28 | Hardin, Illinois, US |
2020-10-14 | US | Illinois | Henderson | 17071 | 93 | 0 | 0 | 93 | 40.81908672 | -90.92491462 | 2020-10-15 04:24:28 | Henderson, Illinois, US |
2020-10-14 | US | Illinois | Johnson | 17087 | 279 | 0 | 0 | 279 | 37.45939802 | -88.88165419 | 2020-10-15 04:24:28 | Johnson, Illinois, US |
2020-10-14 | US | Illinois | Out of IL | 80017 | 1 | 0 | 0 | 1 | 42.36542373 | 0.0 | 2020-10-15 04:24:28 | Out of IL, Illinois, US |
2020-10-14 | US | Illinois | Piatt | 17147 | 183 | 0 | 0 | 183 | 40.01360584 | -88.59319339 | 2020-10-15 04:24:28 | Piatt, Illinois, US |
2020-10-14 | US | Illinois | Putnam | 17155 | 75 | 0 | 0 | 75 | 41.2013541 | -89.2869272 | 2020-10-15 04:24:28 | Putnam, Illinois, US |
2020-10-14 | US | Illinois | Scott | 17171 | 84 | 0 | 0 | 84 | 39.6429169 | -90.47814431 | 2020-10-15 04:24:28 | Scott, Illinois, US |
2021-05-25 | US | Illinois | Out of IL | 80017 | 1 | 0 | 0 | 42.36542373 | 0.0 | 2021-05-26 04:20:35 | Out of IL, Illinois, US | |
2021-11-09 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2021-11-10 04:21:38 | Out of IL, Illinois, US | |
2022-07-23 | US | Illinois | Out of IL | 80017 | 17 | 0 | 0 | 42.36542373 | 0.0 | 2022-07-24 04:20:47 | Out of IL, Illinois, US | |
2020-08-04 | US | Illinois | Alexander | 17003 | 36 | 0 | 0 | 36 | 37.18049267 | -89.32910838 | 2020-08-05 04:34:43 | Alexander, Illinois, US |
2020-08-04 | US | Illinois | Brown | 17009 | 13 | 0 | 0 | 13 | 39.96209138 | -90.75068024 | 2020-08-05 04:34:43 | Brown, Illinois, US |
2020-08-04 | US | Illinois | Calhoun | 17013 | 8 | 0 | 0 | 8 | 39.16840183 | -90.66330078 | 2020-08-05 04:34:43 | Calhoun, Illinois, US |
2020-08-04 | US | Illinois | Clark | 17023 | 70 | 0 | 0 | 70 | 39.33425789 | -87.78705622 | 2020-08-05 04:34:43 | Clark, Illinois, US |
2020-08-04 | US | Illinois | Clay | 17025 | 15 | 0 | 0 | 15 | 38.75388572 | -88.48914513 | 2020-08-05 04:34:43 | Clay, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;