daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where confirmed = 57486 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 4
- Mexico 1
- Netherlands 1
- Russia 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-03-29 | US | Texas | McLennan | 48309 | 57486 | 897 | 0 | 31.55255453 | -97.20217694 | 2022-03-30 04:20:45 | McLennan, Texas, US | |
2021-10-26 | Netherlands | Friesland | 57486 | 493 | 0 | 53.087337 | 5.7925 | 2021-10-27 04:22:32 | Friesland, Netherlands | |||
2021-08-14 | US | Pennsylvania | Lancaster | 42071 | 57486 | 1177 | 0 | 40.03904563 | -76.24770128 | 2021-08-15 04:21:41 | Lancaster, Pennsylvania, US | |
2021-08-10 | Russia | Karelia Republic | 57486 | 740 | 0 | 62.61940309999999 | 33.4920267 | 2021-08-11 04:21:58 | Karelia Republic, Russia | |||
2021-06-21 | Mexico | Chihuahua | 57486 | 7493 | 0 | 49993 | 28.633000000000006 | -106.0691 | 2021-06-22 04:21:34 | Chihuahua, Mexico | ||
2021-05-03 | US | Illinois | Kane | 17089 | 57486 | 767 | 0 | 41.93842729 | -88.42861412 | 2021-05-04 04:20:34 | Kane, Illinois, US | |
2021-02-10 | US | Illinois | Lake | 17097 | 57486 | 892 | 0 | 56594 | 42.3224907 | -88.00367925 | 2021-02-11 05:23:55 | Lake, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;