daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where confirmed = 1320, country_or_region = "US" and province_or_state = "Illinois" sorted by day descending
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-09-18 | US | Illinois | Putnam | 17155 | 1320 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-09-19 04:21:49 | Putnam, Illinois, US | |
| 2022-09-17 | US | Illinois | Putnam | 17155 | 1320 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-09-18 04:22:50 | Putnam, Illinois, US | |
| 2022-09-16 | US | Illinois | Putnam | 17155 | 1320 | 10 | 0 | 41.2013541 | -89.2869272 | 2022-09-17 04:20:19 | Putnam, Illinois, US | |
| 2022-06-21 | US | Illinois | Scott | 17171 | 1320 | 12 | 0 | 39.6429169 | -90.47814431 | 2022-06-22 04:20:54 | Scott, Illinois, US | |
| 2022-06-13 | US | Illinois | Alexander | 17003 | 1320 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-06-14 04:20:52 | Alexander, Illinois, US | |
| 2022-06-12 | US | Illinois | Alexander | 17003 | 1320 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-06-13 04:21:14 | Alexander, Illinois, US | |
| 2022-06-11 | US | Illinois | Alexander | 17003 | 1320 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-06-12 04:20:53 | Alexander, Illinois, US | |
| 2022-06-10 | US | Illinois | Alexander | 17003 | 1320 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-06-11 04:21:01 | Alexander, Illinois, US | |
| 2022-06-09 | US | Illinois | Alexander | 17003 | 1320 | 15 | 0 | 37.18049267 | -89.32910838 | 2022-06-10 04:20:55 | Alexander, Illinois, US | |
| 2021-10-07 | US | Illinois | Hamilton | 17065 | 1320 | 22 | 0 | 38.08163641 | -88.53883373 | 2021-10-08 04:21:25 | Hamilton, Illinois, US | |
| 2021-08-02 | US | Illinois | Cumberland | 17035 | 1320 | 20 | 0 | 39.27432424 | -88.2401158 | 2021-08-03 04:21:39 | Cumberland, Illinois, US | |
| 2021-03-31 | US | Illinois | Mercer | 17131 | 1320 | 33 | 0 | 41.20596782 | -90.74290052 | 2021-04-01 04:27:05 | Mercer, Illinois, US | |
| 2021-03-28 | US | Illinois | De Witt | 17039 | 1320 | 23 | 0 | 40.17514519 | -88.90959682 | 2021-03-29 04:28:35 | De Witt, Illinois, US | |
| 2020-12-29 | US | Illinois | Carroll | 17015 | 1320 | 31 | 0 | 1289 | 42.06823429 | -89.93395545 | 2020-12-30 05:22:34 | Carroll, Illinois, US |
| 2020-12-07 | US | Illinois | Union | 17181 | 1320 | 28 | 0 | 1292 | 37.47119609 | -89.25548938 | 2020-12-08 05:27:42 | Union, Illinois, US |
| 2020-12-01 | US | Illinois | Jersey | 17083 | 1320 | 22 | 0 | 1298 | 39.08869046 | -90.35393073 | 2020-12-02 05:27:41 | Jersey, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;