daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where country_or_region = "Chile" and deaths = 42 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, longitude, combined_key, last_update (date)
province_or_state 5
- Coquimbo 2
- Los Lagos 2
- Antofagasta 1
- Biobio 1
- Los Rios 1
country_or_region 1
- Chile · 7 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-11-14 | Chile | Los Rios | 4703 | 42 | 4046 | 615 | -40.231 | -72.3311 | 2020-11-15 05:26:53 | Los Rios, Chile | ||
2020-08-03 | Chile | Los Lagos | 4241 | 42 | 3217 | 982 | -41.9198 | -72.1416 | 2020-08-04 04:41:59 | Los Lagos, Chile | ||
2020-08-02 | Chile | Los Lagos | 4179 | 42 | 3142 | 995 | -41.9198 | -72.1416 | 2020-08-03 04:34:35 | Los Lagos, Chile | ||
2020-07-16 | Chile | Coquimbo | 4361 | 42 | 3612 | 707 | -29.959 | -71.3389 | 2020-07-17 04:34:50 | Coquimbo, Chile | ||
2020-07-15 | Chile | Coquimbo | 4277 | 42 | 3508 | 727 | -29.959 | -71.3389 | 2020-07-16 04:44:59 | Coquimbo, Chile | ||
2020-06-25 | Chile | Biobio | 5702 | 42 | 0 | 5660 | -37.4464 | -72.1416 | 2020-06-26 04:33:43 | Biobio, Chile | ||
2020-06-05 | Chile | Antofagasta | 2924 | 42 | 0 | 2882 | -23.6509 | -70.3975 | 2020-06-06 02:33:00 | Antofagasta, Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;