daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where country_or_region = "Chile" and deaths = 21 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, latitude, combined_key, day (date)
province_or_state 10
- Los Lagos 11
- Los Rios 8
- Nuble 5
- Antofagasta 3
- Atacama 3
- Aysen 3
- Arica y Parinacota 1
- Maule 1
- OHiggins 1
- Tarapaca 1
country_or_region 1
- Chile · 37 ✖
| day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021-02-06 | Chile | Aysen | 2631 | 21 | 2464 | 146 | -45.9864 | -73.7669 | 2021-02-07 05:23:00 | Aysen, Chile | ||
| 2021-02-05 | Chile | Aysen | 2611 | 21 | 2440 | 150 | -45.9864 | -73.7669 | 2021-02-06 05:23:55 | Aysen, Chile | ||
| 2021-02-04 | Chile | Aysen | 2589 | 21 | 2425 | 143 | -45.9864 | -73.7669 | 2021-02-05 05:22:38 | Aysen, Chile | ||
| 2020-10-10 | Chile | Los Rios | 2378 | 21 | 1892 | 465 | -40.231 | -72.3311 | 2020-10-11 04:23:46 | Los Rios, Chile | ||
| 2020-10-09 | Chile | Los Rios | 2336 | 21 | 1837 | 478 | -40.231 | -72.3311 | 2020-10-10 04:23:57 | Los Rios, Chile | ||
| 2020-10-08 | Chile | Los Rios | 2278 | 21 | 1795 | 462 | -40.231 | -72.3311 | 2020-10-09 04:23:59 | Los Rios, Chile | ||
| 2020-10-07 | Chile | Los Rios | 2239 | 21 | 1748 | 470 | -40.231 | -72.3311 | 2020-10-08 04:23:56 | Los Rios, Chile | ||
| 2020-10-06 | Chile | Los Rios | 2203 | 21 | 1685 | 497 | -40.231 | -72.3311 | 2020-10-07 04:23:40 | Los Rios, Chile | ||
| 2020-10-05 | Chile | Los Rios | 2143 | 21 | 1617 | 505 | -40.231 | -72.3311 | 2020-10-06 04:23:33 | Los Rios, Chile | ||
| 2020-10-04 | Chile | Los Rios | 2116 | 21 | 1584 | 511 | -40.231 | -72.3311 | 2020-10-05 04:23:33 | Los Rios, Chile | ||
| 2020-10-03 | Chile | Los Rios | 2063 | 21 | 1566 | 476 | -40.231 | -72.3311 | 2020-10-04 04:23:44 | Los Rios, Chile | ||
| 2020-08-12 | Chile | Atacama | 4108 | 21 | 3077 | 1010 | -27.5661 | -70.0503 | 2020-08-13 04:29:15 | Atacama, Chile | ||
| 2020-08-11 | Chile | Atacama | 3998 | 21 | 2962 | 1015 | -27.5661 | -70.0503 | 2020-08-12 04:27:29 | Atacama, Chile | ||
| 2020-08-10 | Chile | Atacama | 3868 | 21 | 2843 | 1004 | -27.5661 | -70.0503 | 2020-08-11 04:35:08 | Atacama, Chile | ||
| 2020-07-08 | Chile | Los Lagos | 2047 | 21 | 1613 | 413 | -41.9198 | -72.1416 | 2020-07-09 04:34:23 | Los Lagos, Chile | ||
| 2020-07-07 | Chile | Los Lagos | 1978 | 21 | 1584 | 373 | -41.9198 | -72.1416 | 2020-07-08 05:33:48 | Los Lagos, Chile | ||
| 2020-07-06 | Chile | Los Lagos | 1956 | 21 | 1547 | 388 | -41.9198 | -72.1416 | 2020-07-07 04:34:00 | Los Lagos, Chile | ||
| 2020-07-05 | Chile | Los Lagos | 1930 | 21 | 1524 | 385 | -41.9198 | -72.1416 | 2020-07-06 04:33:57 | Los Lagos, Chile | ||
| 2020-07-04 | Chile | Los Lagos | 1856 | 21 | 1496 | 339 | -41.9198 | -72.1416 | 2020-07-05 04:33:46 | Los Lagos, Chile | ||
| 2020-07-03 | Chile | Los Lagos | 1806 | 21 | 1463 | 322 | -41.9198 | -72.1416 | 2020-07-04 04:33:51 | Los Lagos, Chile | ||
| 2020-07-02 | Chile | Arica y Parinacota | 1832 | 21 | 1408 | 403 | -18.594 | -69.4785 | 2020-07-03 04:33:54 | Arica y Parinacota, Chile | ||
| 2020-07-02 | Chile | Los Lagos | 1734 | 21 | 1415 | 298 | -41.9198 | -72.1416 | 2020-07-03 04:33:54 | Los Lagos, Chile | ||
| 2020-07-01 | Chile | Los Lagos | 1684 | 21 | 1373 | 290 | -41.9198 | -72.1416 | 2020-07-02 04:33:46 | Los Lagos, Chile | ||
| 2020-06-30 | Chile | Los Lagos | 1656 | 21 | 1338 | 297 | -41.9198 | -72.1416 | 2020-07-01 04:33:52 | Los Lagos, Chile | ||
| 2020-06-29 | Chile | Los Lagos | 1642 | 21 | 1311 | 310 | -41.9198 | -72.1416 | 2020-06-30 04:33:48 | Los Lagos, Chile | ||
| 2020-06-28 | Chile | Los Lagos | 1609 | 21 | 0 | 1588 | -41.9198 | -72.1416 | 2020-06-29 04:33:44 | Los Lagos, Chile | ||
| 2020-06-04 | Chile | Maule | 1732 | 21 | 0 | 1711 | -35.5183 | -71.6885 | 2020-06-05 02:33:06 | Maule, Chile | ||
| 2020-06-04 | Chile | OHiggins | 967 | 21 | 0 | 946 | -34.5755 | -71.0022 | 2020-06-05 02:33:06 | OHiggins, Chile | ||
| 2020-05-31 | Chile | Tarapaca | 2361 | 21 | 0 | 2340 | -19.9232 | -69.5132 | 2020-06-01 02:32:46 | Tarapaca, Chile | ||
| 2020-05-25 | Chile | Antofagasta | 2015 | 21 | 0 | 1994 | -23.6509 | -70.3975 | 2020-05-26 02:32:35 | Antofagasta, Chile | ||
| 2020-05-24 | Chile | Antofagasta | 1947 | 21 | 0 | 1926 | -23.6509 | -70.3975 | 2020-05-25 02:32:44 | Antofagasta, Chile | ||
| 2020-05-24 | Chile | Nuble | 1102 | 21 | 0 | 1081 | -36.7226 | -71.7622 | 2020-05-25 02:32:44 | Nuble, Chile | ||
| 2020-05-23 | Chile | Antofagasta | 1897 | 21 | 0 | 1876 | -23.6509 | -70.3975 | 2020-05-24 02:32:43 | Antofagasta, Chile | ||
| 2020-05-23 | Chile | Nuble | 1077 | 21 | 0 | 1056 | -36.7226 | -71.7622 | 2020-05-24 02:32:43 | Nuble, Chile | ||
| 2020-05-22 | Chile | Nuble | 1025 | 21 | 0 | 1004 | -36.7226 | -71.7622 | 2020-05-23 02:32:42 | Nuble, Chile | ||
| 2020-05-21 | Chile | Nuble | 1020 | 21 | 0 | 999 | -36.7226 | -71.7622 | 2020-05-22 02:36:51 | Nuble, Chile | ||
| 2020-05-20 | Chile | Nuble | 1011 | 21 | 0 | 990 | -36.7226 | -71.7622 | 2020-05-21 02:32:48 | Nuble, Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;