johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where country_or_region = "Chile" and deaths = 497 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, latitude, longitude, combined_key
province_or_state 7
- Magallanes 18
- Arica y Parinacota 7
- Araucania 3
- Coquimbo 1
- Nuble 1
- Tarapaca 1
- Valparaiso 1
country_or_region 1
- Chile · 32 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2278949 | 2278949 | 2021-09-08 | Chile | Magallanes | 29245 | 497 | 0 | -52.368 | -70.9863 | 2021-09-09 04:21:27 | Magallanes, Chile | |||
641728 | 641728 | 2021-09-07 | Chile | Magallanes | 29244 | 497 | 0 | -52.368 | -70.9863 | 2021-09-08 04:21:31 | Magallanes, Chile | |||
3193791 | 3193791 | 2021-09-06 | Chile | Magallanes | 29244 | 497 | 0 | -52.368 | -70.9863 | 2021-09-07 04:21:35 | Magallanes, Chile | |||
3280659 | 3280659 | 2021-09-05 | Chile | Magallanes | 29244 | 497 | 0 | -52.368 | -70.9863 | 2021-09-06 04:21:22 | Magallanes, Chile | |||
249073 | 249073 | 2021-09-04 | Chile | Magallanes | 29243 | 497 | 0 | -52.368 | -70.9863 | 2021-09-05 04:21:33 | Magallanes, Chile | |||
3974354 | 3974354 | 2021-09-03 | Chile | Magallanes | 29243 | 497 | 0 | -52.368 | -70.9863 | 2021-09-04 04:21:28 | Magallanes, Chile | |||
177816 | 177816 | 2021-09-02 | Chile | Magallanes | 29242 | 497 | 0 | -52.368 | -70.9863 | 2021-09-03 04:21:20 | Magallanes, Chile | |||
66851 | 66851 | 2021-09-01 | Chile | Magallanes | 29242 | 497 | 0 | -52.368 | -70.9863 | 2021-09-02 04:21:15 | Magallanes, Chile | |||
2067693 | 2067693 | 2021-08-31 | Chile | Magallanes | 29240 | 497 | 0 | -52.368 | -70.9863 | 2021-09-01 04:21:38 | Magallanes, Chile | |||
1775147 | 1775147 | 2021-08-30 | Chile | Magallanes | 29239 | 497 | 0 | -52.368 | -70.9863 | 2021-08-31 04:21:46 | Magallanes, Chile | |||
3891721 | 3891721 | 2021-08-29 | Chile | Magallanes | 29239 | 497 | 0 | -52.368 | -70.9863 | 2021-08-30 04:21:23 | Magallanes, Chile | |||
2792824 | 2792824 | 2021-08-28 | Chile | Magallanes | 29238 | 497 | 0 | -52.368 | -70.9863 | 2021-08-29 04:21:14 | Magallanes, Chile | |||
2922983 | 2922983 | 2021-08-27 | Chile | Magallanes | 29237 | 497 | 0 | -52.368 | -70.9863 | 2021-08-28 04:21:28 | Magallanes, Chile | |||
1595997 | 1595997 | 2021-08-26 | Chile | Magallanes | 29237 | 497 | 0 | -52.368 | -70.9863 | 2021-08-27 04:21:37 | Magallanes, Chile | |||
32206 | 32206 | 2021-08-25 | Chile | Magallanes | 29235 | 497 | 0 | -52.368 | -70.9863 | 2021-08-26 04:21:28 | Magallanes, Chile | |||
3105245 | 3105245 | 2021-08-24 | Chile | Magallanes | 29234 | 497 | 0 | -52.368 | -70.9863 | 2021-08-25 04:21:41 | Magallanes, Chile | |||
3165416 | 3165416 | 2021-08-23 | Chile | Magallanes | 29233 | 497 | 0 | -52.368 | -70.9863 | 2021-08-24 04:21:19 | Magallanes, Chile | |||
2175343 | 2175343 | 2021-08-22 | Chile | Magallanes | 29226 | 497 | 0 | -52.368 | -70.9863 | 2021-08-23 04:21:27 | Magallanes, Chile | |||
3331313 | 3331313 | 2021-07-21 | Chile | Arica y Parinacota | 26147 | 497 | 25425 | 225 | -18.594 | -69.4785 | 2021-07-22 04:21:19 | Arica y Parinacota, Chile | ||
2371294 | 2371294 | 2021-07-20 | Chile | Arica y Parinacota | 26134 | 497 | 25380 | 257 | -18.594 | -69.4785 | 2021-07-21 04:21:40 | Arica y Parinacota, Chile | ||
483373 | 483373 | 2021-07-19 | Chile | Arica y Parinacota | 26126 | 497 | 25341 | 288 | -18.594 | -69.4785 | 2021-07-20 04:21:48 | Arica y Parinacota, Chile | ||
2673596 | 2673596 | 2021-07-18 | Chile | Arica y Parinacota | 26113 | 497 | 25307 | 309 | -18.594 | -69.4785 | 2021-07-19 04:21:24 | Arica y Parinacota, Chile | ||
3705908 | 3705908 | 2021-07-17 | Chile | Arica y Parinacota | 26092 | 497 | 25261 | 334 | -18.594 | -69.4785 | 2021-07-18 04:22:07 | Arica y Parinacota, Chile | ||
2947139 | 2947139 | 2021-07-16 | Chile | Arica y Parinacota | 26008 | 497 | 25147 | 364 | -18.594 | -69.4785 | 2021-07-17 04:22:22 | Arica y Parinacota, Chile | ||
295795 | 295795 | 2021-07-15 | Chile | Arica y Parinacota | 25897 | 497 | 25028 | 372 | -18.594 | -69.4785 | 2021-07-16 04:21:22 | Arica y Parinacota, Chile | ||
1806538 | 1806538 | 2021-05-27 | Chile | Nuble | 29530 | 497 | 28074 | 959 | -36.7226 | -71.7622 | 2021-05-28 04:20:36 | Nuble, Chile | ||
1535715 | 1535715 | 2021-03-28 | Chile | Coquimbo | 26395 | 497 | 24691 | 1207 | -29.959 | -71.3389 | 2021-03-29 04:28:35 | Coquimbo, Chile | ||
1535723 | 1535723 | 2021-03-28 | Chile | Tarapaca | 28339 | 497 | 26715 | 1127 | -19.9232 | -69.5132 | 2021-03-29 04:28:35 | Tarapaca, Chile | ||
279965 | 279965 | 2021-02-24 | Chile | Araucania | 38681 | 497 | 36674 | 1510 | -38.9489 | -72.3311 | 2021-02-25 05:24:57 | Araucania, Chile | ||
1936233 | 1936233 | 2021-02-23 | Chile | Araucania | 38382 | 497 | 36331 | 1554 | -38.9489 | -72.3311 | 2021-02-24 05:29:16 | Araucania, Chile | ||
530488 | 530488 | 2021-02-22 | Chile | Araucania | 38191 | 497 | 36055 | 1639 | -38.9489 | -72.3311 | 2021-02-23 05:23:41 | Araucania, Chile | ||
3264923 | 3264923 | 2020-07-31 | Chile | Valparaiso | 17580 | 497 | 15731 | 1352 | -33.0472 | -71.6127 | 2020-08-01 04:36:27 | Valparaiso, Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);