johns_hopkins_csse_daily_reports
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)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48697 | 48697 | 2020-04-17 | US | Illinois | Knox | 17095 | 3 | 0 | 0 | 3 | 40.93148779 | -90.21330340000002 | 2020-04-17 23:30:52 | Knox, Illinois, US |
48767 | 48767 | 2020-04-17 | US | Illinois | Lawrence | 17101 | 2 | 0 | 0 | 2 | 38.71987914 | -87.72884035 | 2020-04-17 23:30:52 | Lawrence, Illinois, US |
48785 | 48785 | 2020-04-17 | US | Illinois | Lee | 17103 | 17 | 0 | 0 | 17 | 41.74583951 | -89.29977132 | 2020-04-17 23:30:52 | Lee, Illinois, US |
48846 | 48846 | 2020-04-17 | US | Illinois | Livingston | 17105 | 18 | 0 | 0 | 18 | 40.89188292 | -88.55784752 | 2020-04-17 23:30:52 | Livingston, Illinois, US |
48855 | 48855 | 2020-04-17 | US | Illinois | Logan | 17107 | 5 | 0 | 0 | 5 | 40.12581572 | -89.36638784 | 2020-04-17 23:30:52 | Logan, Illinois, US |
48898 | 48898 | 2020-04-17 | US | Illinois | Macoupin | 17117 | 18 | 0 | 0 | 18 | 39.26119767 | -89.92424028 | 2020-04-17 23:30:52 | Macoupin, Illinois, US |
48939 | 48939 | 2020-04-17 | US | Illinois | Marion | 17121 | 17 | 0 | 0 | 17 | 38.64963204 | -88.91899208 | 2020-04-17 23:30:52 | Marion, Illinois, US |
48955 | 48955 | 2020-04-17 | US | Illinois | Marshall | 17123 | 2 | 0 | 0 | 2 | 41.0327901 | -89.34510444 | 2020-04-17 23:30:52 | Marshall, Illinois, US |
48971 | 48971 | 2020-04-17 | US | Illinois | Mason | 17125 | 4 | 0 | 0 | 4 | 40.23917274 | -89.91824452 | 2020-04-17 23:30:52 | Mason, Illinois, US |
48977 | 48977 | 2020-04-17 | US | Illinois | Massac | 17127 | 4 | 0 | 0 | 4 | 37.22078441 | -88.71036614 | 2020-04-17 23:30:52 | Massac, Illinois, US |
48993 | 48993 | 2020-04-17 | US | Illinois | McDonough | 17109 | 3 | 0 | 0 | 3 | 40.45674722 | -90.67775541 | 2020-04-17 23:30:52 | McDonough, Illinois, US |
49024 | 49024 | 2020-04-17 | US | Illinois | Menard | 17129 | 2 | 0 | 0 | 2 | 40.02742725 | -89.80246001 | 2020-04-17 23:30:52 | Menard, Illinois, US |
49030 | 49030 | 2020-04-17 | US | Illinois | Mercer | 17131 | 4 | 0 | 0 | 4 | 41.20596782 | -90.74290052 | 2020-04-17 23:30:52 | Mercer, Illinois, US |
49145 | 49145 | 2020-04-17 | US | Illinois | Moultrie | 17139 | 2 | 0 | 0 | 2 | 39.64187451 | -88.62099969 | 2020-04-17 23:30:52 | Moultrie, Illinois, US |
49334 | 49334 | 2020-04-17 | US | Illinois | Perry | 17145 | 1 | 0 | 0 | 1 | 38.08510853 | -89.36856219 | 2020-04-17 23:30:52 | Perry, Illinois, US |
49352 | 49352 | 2020-04-17 | US | Illinois | Piatt | 17147 | 7 | 0 | 0 | 7 | 40.01360584 | -88.59319339 | 2020-04-17 23:30:52 | Piatt, Illinois, US |
49365 | 49365 | 2020-04-17 | US | Illinois | Pike | 17149 | 1 | 0 | 0 | 1 | 39.62265059 | -90.8877017 | 2020-04-17 23:30:52 | Pike, Illinois, US |
49440 | 49440 | 2020-04-17 | US | Illinois | Pulaski | 17153 | 5 | 0 | 0 | 5 | 37.22631423 | -89.13085001 | 2020-04-17 23:30:52 | Pulaski, Illinois, US |
49490 | 49490 | 2020-04-17 | US | Illinois | Richland | 17159 | 2 | 0 | 0 | 2 | 38.71240969 | -88.08475366 | 2020-04-17 23:30:52 | Richland, Illinois, US |
49557 | 49557 | 2020-04-17 | US | Illinois | Saline | 17165 | 3 | 0 | 0 | 3 | 37.75332999 | -88.54119706 | 2020-04-17 23:30:52 | Saline, Illinois, US |
49601 | 49601 | 2020-04-17 | US | Illinois | Schuyler | 17169 | 1 | 0 | 0 | 1 | 40.157179799999994 | -90.61114163 | 2020-04-17 23:30:52 | Schuyler, Illinois, US |
49641 | 49641 | 2020-04-17 | US | Illinois | Shelby | 17173 | 4 | 0 | 0 | 4 | 39.39133527 | -88.80611122 | 2020-04-17 23:30:52 | Shelby, Illinois, US |
49721 | 49721 | 2020-04-17 | US | Illinois | Stark | 17175 | 1 | 0 | 0 | 1 | 41.09309773 | -89.79745866 | 2020-04-17 23:30:52 | Stark, Illinois, US |
49733 | 49733 | 2020-04-17 | US | Illinois | Stephenson | 17177 | 10 | 0 | 0 | 10 | 42.35129217 | -89.662598 | 2020-04-17 23:30:52 | Stephenson, Illinois, US |
49915 | 49915 | 2020-04-17 | US | Illinois | Union | 17181 | 4 | 0 | 0 | 4 | 37.47119609 | -89.25548938 | 2020-04-17 23:30:52 | Union, Illinois, US |
49947 | 49947 | 2020-04-17 | US | Illinois | Vermilion | 17183 | 8 | 0 | 0 | 8 | 40.18417171 | -87.73384359 | 2020-04-17 23:30:52 | Vermilion, Illinois, US |
49957 | 49957 | 2020-04-17 | US | Illinois | Wabash | 17185 | 1 | 0 | 0 | 1 | 38.44272901 | -87.84922065 | 2020-04-17 23:30:52 | Wabash, Illinois, US |
49982 | 49982 | 2020-04-17 | US | Illinois | Warren | 17187 | 2 | 0 | 0 | 2 | 40.84925021 | -90.6147432 | 2020-04-17 23:30:52 | Warren, Illinois, US |
50007 | 50007 | 2020-04-17 | US | Illinois | Washington | 17189 | 5 | 0 | 0 | 5 | 38.35309213 | -89.40982703 | 2020-04-17 23:30:52 | Washington, Illinois, US |
50100 | 50100 | 2020-04-17 | US | Illinois | Williamson | 17199 | 13 | 0 | 0 | 13 | 37.73033511 | -88.92994027 | 2020-04-17 23:30:52 | Williamson, Illinois, US |
50128 | 50128 | 2020-04-17 | US | Illinois | Woodford | 17203 | 11 | 0 | 0 | 11 | 40.78579374 | -89.20973757 | 2020-04-17 23:30:52 | Woodford, Illinois, US |
51816 | 51816 | 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 | |
55827 | 55827 | 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 | |
58545 | 58545 | 2020-07-23 | US | Illinois | Alexander | 17003 | 33 | 0 | 0 | 33 | 37.18049267 | -89.32910838 | 2020-07-24 05:30:40 | Alexander, Illinois, US |
58798 | 58798 | 2020-07-23 | US | Illinois | Brown | 17009 | 12 | 0 | 0 | 12 | 39.96209138 | -90.75068024 | 2020-07-24 05:30:40 | Brown, Illinois, US |
58865 | 58865 | 2020-07-23 | US | Illinois | Calhoun | 17013 | 4 | 0 | 0 | 4 | 39.16840183 | -90.66330078 | 2020-07-24 05:30:40 | Calhoun, Illinois, US |
59043 | 59043 | 2020-07-23 | US | Illinois | Clark | 17023 | 51 | 0 | 0 | 51 | 39.33425789 | -87.78705622 | 2020-07-24 05:30:40 | Clark, Illinois, US |
59063 | 59063 | 2020-07-23 | US | Illinois | Clay | 17025 | 9 | 0 | 0 | 9 | 38.75388572 | -88.48914513 | 2020-07-24 05:30:40 | Clay, Illinois, US |
59181 | 59181 | 2020-07-23 | US | Illinois | Crawford | 17033 | 28 | 0 | 0 | 28 | 39.0032229 | -87.75954624 | 2020-07-24 05:30:40 | Crawford, Illinois, US |
59260 | 59260 | 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 |
59367 | 59367 | 2020-07-23 | US | Illinois | Edgar | 17045 | 20 | 0 | 0 | 20 | 39.6809186 | -87.74759563 | 2020-07-24 05:30:40 | Edgar, Illinois, US |
59372 | 59372 | 2020-07-23 | US | Illinois | Edwards | 17047 | 6 | 0 | 0 | 6 | 38.41353228 | -88.05720863 | 2020-07-24 05:30:40 | Edwards, Illinois, US |
59481 | 59481 | 2020-07-23 | US | Illinois | Franklin | 17055 | 84 | 0 | 0 | 84 | 37.99189086 | -88.92567818 | 2020-07-24 05:30:40 | Franklin, Illinois, US |
59516 | 59516 | 2020-07-23 | US | Illinois | Fulton | 17057 | 20 | 0 | 0 | 20 | 40.47289135 | -90.20862357 | 2020-07-24 05:30:40 | Fulton, Illinois, US |
59527 | 59527 | 2020-07-23 | US | Illinois | Gallatin | 17059 | 26 | 0 | 0 | 26 | 37.76430935 | -88.22953869 | 2020-07-24 05:30:40 | Gallatin, Illinois, US |
59632 | 59632 | 2020-07-23 | US | Illinois | Greene | 17061 | 14 | 0 | 0 | 14 | 39.35907414 | -90.388865 | 2020-07-24 05:30:40 | Greene, Illinois, US |
59684 | 59684 | 2020-07-23 | US | Illinois | Hamilton | 17065 | 11 | 0 | 0 | 11 | 38.08163641 | -88.53883373 | 2020-07-24 05:30:40 | Hamilton, Illinois, US |
59717 | 59717 | 2020-07-23 | US | Illinois | Hardin | 17069 | 9 | 0 | 0 | 9 | 37.51810645 | -88.26873022 | 2020-07-24 05:30:40 | Hardin, Illinois, US |
59762 | 59762 | 2020-07-23 | US | Illinois | Henderson | 17071 | 8 | 0 | 0 | 8 | 40.81908672 | -90.92491462 | 2020-07-24 05:30:40 | Henderson, Illinois, US |
59965 | 59965 | 2020-07-23 | US | Illinois | Johnson | 17087 | 47 | 0 | 0 | 47 | 37.45939802 | -88.88165419 | 2020-07-24 05:30:40 | Johnson, Illinois, US |
60133 | 60133 | 2020-07-23 | US | Illinois | Lawrence | 17101 | 32 | 0 | 0 | 32 | 38.71987914 | -87.72884035 | 2020-07-24 05:30:40 | Lawrence, Illinois, US |
60228 | 60228 | 2020-07-23 | US | Illinois | Logan | 17107 | 59 | 0 | 0 | 59 | 40.12581572 | -89.36638784 | 2020-07-24 05:30:40 | Logan, Illinois, US |
60322 | 60322 | 2020-07-23 | US | Illinois | Marion | 17121 | 107 | 0 | 0 | 107 | 38.64963204 | -88.91899208 | 2020-07-24 05:30:40 | Marion, Illinois, US |
60340 | 60340 | 2020-07-23 | US | Illinois | Marshall | 17123 | 15 | 0 | 0 | 15 | 41.0327901 | -89.34510444 | 2020-07-24 05:30:40 | Marshall, Illinois, US |
60358 | 60358 | 2020-07-23 | US | Illinois | Mason | 17125 | 36 | 0 | 0 | 36 | 40.23917274 | -89.91824452 | 2020-07-24 05:30:40 | Mason, Illinois, US |
60364 | 60364 | 2020-07-23 | US | Illinois | Massac | 17127 | 26 | 0 | 0 | 26 | 37.22078441 | -88.71036614 | 2020-07-24 05:30:40 | Massac, Illinois, US |
60418 | 60418 | 2020-07-23 | US | Illinois | Menard | 17129 | 37 | 0 | 0 | 37 | 40.02742725 | -89.80246001 | 2020-07-24 05:30:40 | Menard, Illinois, US |
60425 | 60425 | 2020-07-23 | US | Illinois | Mercer | 17131 | 42 | 0 | 0 | 42 | 41.20596782 | -90.74290052 | 2020-07-24 05:30:40 | Mercer, Illinois, US |
60552 | 60552 | 2020-07-23 | US | Illinois | Moultrie | 17139 | 37 | 0 | 0 | 37 | 39.64187451 | -88.62099969 | 2020-07-24 05:30:40 | Moultrie, Illinois, US |
60709 | 60709 | 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 |
60789 | 60789 | 2020-07-23 | US | Illinois | Piatt | 17147 | 30 | 0 | 0 | 30 | 40.01360584 | -88.59319339 | 2020-07-24 05:30:40 | Piatt, Illinois, US |
60803 | 60803 | 2020-07-23 | US | Illinois | Pike | 17149 | 9 | 0 | 0 | 9 | 39.62265059 | -90.8877017 | 2020-07-24 05:30:40 | Pike, Illinois, US |
60850 | 60850 | 2020-07-23 | US | Illinois | Pope | 17151 | 3 | 0 | 0 | 3 | 37.41391284 | -88.56152109 | 2020-07-24 05:30:40 | Pope, Illinois, US |
60887 | 60887 | 2020-07-23 | US | Illinois | Pulaski | 17153 | 88 | 0 | 0 | 88 | 37.22631423 | -89.13085001 | 2020-07-24 05:30:40 | Pulaski, Illinois, US |
60895 | 60895 | 2020-07-23 | US | Illinois | Putnam | 17155 | 4 | 0 | 0 | 4 | 41.2013541 | -89.2869272 | 2020-07-24 05:30:40 | Putnam, Illinois, US |
60949 | 60949 | 2020-07-23 | US | Illinois | Richland | 17159 | 9 | 0 | 0 | 9 | 38.71240969 | -88.08475366 | 2020-07-24 05:30:40 | Richland, Illinois, US |
61030 | 61030 | 2020-07-23 | US | Illinois | Saline | 17165 | 64 | 0 | 0 | 64 | 37.75332999 | -88.54119706 | 2020-07-24 05:30:40 | Saline, Illinois, US |
61083 | 61083 | 2020-07-23 | US | Illinois | Schuyler | 17169 | 14 | 0 | 0 | 14 | 40.157179799999994 | -90.61114163 | 2020-07-24 05:30:40 | Schuyler, Illinois, US |
61091 | 61091 | 2020-07-23 | US | Illinois | Scott | 17171 | 6 | 0 | 0 | 6 | 39.642916899999996 | -90.47814431 | 2020-07-24 05:30:40 | Scott, Illinois, US |
61222 | 61222 | 2020-07-23 | US | Illinois | Stark | 17175 | 6 | 0 | 0 | 6 | 41.09309773 | -89.79745866 | 2020-07-24 05:30:40 | Stark, Illinois, US |
61504 | 61504 | 2020-07-23 | US | Illinois | Wabash | 17185 | 25 | 0 | 0 | 25 | 38.44272901 | -87.84922065 | 2020-07-24 05:30:40 | Wabash, Illinois, US |
61531 | 61531 | 2020-07-23 | US | Illinois | Warren | 17187 | 160 | 0 | 0 | 160 | 40.84925021 | -90.6147432 | 2020-07-24 05:30:40 | Warren, Illinois, US |
61556 | 61556 | 2020-07-23 | US | Illinois | Washington | 17189 | 40 | 0 | 0 | 40 | 38.35309213 | -89.40982703 | 2020-07-24 05:30:40 | Washington, Illinois, US |
61635 | 61635 | 2020-07-23 | US | Illinois | White | 17193 | 34 | 0 | 0 | 34 | 38.08706198 | -88.17657461 | 2020-07-24 05:30:40 | White, Illinois, US |
64098 | 64098 | 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 | |
68089 | 68089 | 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 | |
72123 | 72123 | 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 | |
76074 | 76074 | 2020-12-03 | US | Illinois | Henderson | 17071 | 306 | 0 | 0 | 306 | 40.81908672 | -90.92491462 | 2020-12-04 05:27:27 | Henderson, Illinois, US |
76110 | 76110 | 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 |
76117 | 76117 | 2020-12-03 | US | Illinois | Putnam | 17155 | 256 | 0 | 0 | 256 | 41.2013541 | -89.2869272 | 2020-12-04 05:27:27 | Putnam, Illinois, US |
76124 | 76124 | 2020-12-03 | US | Illinois | Scott | 17171 | 251 | 0 | 0 | 251 | 39.6429169 | -90.47814431 | 2020-12-04 05:27:27 | Scott, Illinois, US |
80037 | 80037 | 2020-10-14 | US | Illinois | Brown | 17009 | 82 | 0 | 0 | 82 | 39.96209138 | -90.75068024 | 2020-10-15 04:24:28 | Brown, Illinois, US |
80039 | 80039 | 2020-10-14 | US | Illinois | Calhoun | 17013 | 66 | 0 | 0 | 66 | 39.16840183 | -90.66330078 | 2020-10-15 04:24:28 | Calhoun, Illinois, US |
80056 | 80056 | 2020-10-14 | US | Illinois | Edwards | 17047 | 84 | 0 | 0 | 84 | 38.41353228 | -88.05720863 | 2020-10-15 04:24:28 | Edwards, Illinois, US |
80061 | 80061 | 2020-10-14 | US | Illinois | Fulton | 17057 | 321 | 0 | 0 | 321 | 40.47289135 | -90.20862357 | 2020-10-15 04:24:28 | Fulton, Illinois, US |
80067 | 80067 | 2020-10-14 | US | Illinois | Hardin | 17069 | 47 | 0 | 0 | 47 | 37.51810645 | -88.26873022 | 2020-10-15 04:24:28 | Hardin, Illinois, US |
80068 | 80068 | 2020-10-14 | US | Illinois | Henderson | 17071 | 93 | 0 | 0 | 93 | 40.81908672 | -90.92491462 | 2020-10-15 04:24:28 | Henderson, Illinois, US |
80076 | 80076 | 2020-10-14 | US | Illinois | Johnson | 17087 | 279 | 0 | 0 | 279 | 37.45939802 | -88.88165419 | 2020-10-15 04:24:28 | Johnson, Illinois, US |
80104 | 80104 | 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 |
80107 | 80107 | 2020-10-14 | US | Illinois | Piatt | 17147 | 183 | 0 | 0 | 183 | 40.01360584 | -88.59319339 | 2020-10-15 04:24:28 | Piatt, Illinois, US |
80111 | 80111 | 2020-10-14 | US | Illinois | Putnam | 17155 | 75 | 0 | 0 | 75 | 41.2013541 | -89.2869272 | 2020-10-15 04:24:28 | Putnam, Illinois, US |
80118 | 80118 | 2020-10-14 | US | Illinois | Scott | 17171 | 84 | 0 | 0 | 84 | 39.6429169 | -90.47814431 | 2020-10-15 04:24:28 | Scott, Illinois, US |
84119 | 84119 | 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 | |
88157 | 88157 | 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 | |
92175 | 92175 | 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 | |
94867 | 94867 | 2020-08-04 | US | Illinois | Alexander | 17003 | 36 | 0 | 0 | 36 | 37.18049267 | -89.32910838 | 2020-08-05 04:34:43 | Alexander, Illinois, US |
95120 | 95120 | 2020-08-04 | US | Illinois | Brown | 17009 | 13 | 0 | 0 | 13 | 39.96209138 | -90.75068024 | 2020-08-05 04:34:43 | Brown, Illinois, US |
95187 | 95187 | 2020-08-04 | US | Illinois | Calhoun | 17013 | 8 | 0 | 0 | 8 | 39.16840183 | -90.66330078 | 2020-08-05 04:34:43 | Calhoun, Illinois, US |
95365 | 95365 | 2020-08-04 | US | Illinois | Clark | 17023 | 70 | 0 | 0 | 70 | 39.33425789 | -87.78705622 | 2020-08-05 04:34:43 | Clark, Illinois, US |
95385 | 95385 | 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 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] TEXT, [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]);