daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where country_or_region = "Colombia" and deaths = 498 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Colombia · 8 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-01-29 | Colombia | Arauca | 15171 | 498 | 0 | 7.0762 | -70.7105 | 2022-01-30 04:21:26 | Arauca, Colombia | |||
2022-01-28 | Colombia | Arauca | 15092 | 498 | 0 | 7.0762 | -70.7105 | 2022-01-29 04:21:10 | Arauca, Colombia | |||
2021-06-03 | Colombia | Casanare | 21870 | 498 | 20155 | 1217 | 5.7589 | -71.5724 | 2021-06-04 04:23:37 | Casanare, Colombia | ||
2020-12-15 | Colombia | Caqueta | 14056 | 498 | 12787 | 771 | 0.8699 | -73.8419 | 2020-12-16 05:28:04 | Caqueta, Colombia | ||
2020-12-09 | Colombia | La Guajira | 12615 | 498 | 11651 | 466 | 11.3548 | -72.5205 | 2020-12-10 05:26:19 | La Guajira, Colombia | ||
2020-12-08 | Colombia | Quindio | 18632 | 498 | 17115 | 1019 | 4.461 | -75.6674 | 2020-12-09 05:28:01 | Quindio, Colombia | ||
2020-11-18 | Colombia | Risaralda | 21006 | 498 | 19156 | 1352 | 5.3158 | -75.9928 | 2020-11-19 05:25:23 | Risaralda, Colombia | ||
2020-08-15 | Colombia | Magdalena | 9915 | 498 | 6037 | 3380 | 10.4113 | -74.4057 | 2020-08-16 04:27:42 | Magdalena, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;