daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 40609 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-28 | US | Illinois | Kendall | 17093 | 40609 | 170 | 0 | 41.59081014 | -88.42869583 | 2022-12-29 04:21:01 | Kendall, Illinois, US | |
2022-08-03 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-08-04 04:20:58 | Jackson, Mississippi, US | |
2022-08-02 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-08-03 04:20:59 | Jackson, Mississippi, US | |
2022-08-01 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-08-02 04:20:53 | Jackson, Mississippi, US | |
2022-07-31 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-08-01 04:21:03 | Jackson, Mississippi, US | |
2022-07-30 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-07-31 04:21:02 | Jackson, Mississippi, US | |
2022-07-29 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-07-30 04:20:42 | Jackson, Mississippi, US | |
2022-07-28 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-07-29 04:20:45 | Jackson, Mississippi, US | |
2022-07-27 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-07-28 04:20:56 | Jackson, Mississippi, US | |
2022-07-26 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-07-27 04:21:04 | Jackson, Mississippi, US | |
2022-07-25 | US | Mississippi | Jackson | 28059 | 40609 | 471 | 0 | 30.54020656 | -88.64184064 | 2022-07-26 04:20:58 | Jackson, Mississippi, US | |
2022-04-18 | Russia | North Ossetia - Alania Republic | 40609 | 1248 | 0 | 42.79336110000001 | 44.6324493 | 2022-04-19 04:21:00 | North Ossetia - Alania Republic, Russia | |||
2022-04-17 | Russia | Ingushetia Republic | 40609 | 549 | 0 | 43.11542075 | 45.01713552 | 2022-04-18 04:21:12 | Ingushetia Republic, Russia | |||
2022-02-02 | US | Wisconsin | Rock | 55105 | 40609 | 331 | 0 | 42.67151616 | -89.07147900000002 | 2022-02-03 04:21:21 | Rock, Wisconsin, US | |
2021-05-03 | US | Minnesota | Anoka | 27003 | 40609 | 432 | 0 | 45.27476015 | -93.24604565 | 2021-05-04 04:20:34 | Anoka, Minnesota, US | |
2021-03-23 | Colombia | Magdalena | 40609 | 1513 | 37214 | 1882 | 10.4113 | -74.4057 | 2021-03-24 05:25:40 | Magdalena, Colombia | ||
2021-02-26 | Russia | Karelia Republic | 40609 | 300 | 36445 | 3864 | 62.61940309999999 | 33.4920267 | 2021-02-27 05:22:28 | Karelia Republic, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;