daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where country_or_region = "Colombia" and deaths = 202 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 4
- Choco 9
- Valle del Cauca 2
- Arauca 1
- Putumayo 1
country_or_region 1
- Colombia · 13 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-05-13 | Colombia | Arauca | 6897 | 202 | 6486 | 209 | 7.0762 | -70.7105 | 2021-05-14 04:20:41 | Arauca, Colombia | ||
2021-03-15 | Colombia | Choco | 6612 | 202 | 6324 | 86 | 5.2528 | -76.82600000000002 | 2021-03-16 05:25:13 | Choco, Colombia | ||
2021-03-14 | Colombia | Choco | 6610 | 202 | 6320 | 88 | 5.2528 | -76.82600000000002 | 2021-03-15 05:25:51 | Choco, Colombia | ||
2021-03-13 | Colombia | Choco | 6608 | 202 | 6319 | 87 | 5.2528 | -76.82600000000002 | 2021-03-14 05:25:37 | Choco, Colombia | ||
2021-03-12 | Colombia | Choco | 6607 | 202 | 6317 | 88 | 5.2528 | -76.82600000000002 | 2021-03-13 05:25:15 | Choco, Colombia | ||
2021-03-11 | Colombia | Choco | 6602 | 202 | 6315 | 85 | 5.2528 | -76.82600000000002 | 2021-03-12 05:26:50 | Choco, Colombia | ||
2021-03-10 | Colombia | Choco | 6599 | 202 | 6290 | 107 | 5.2528 | -76.82600000000002 | 2021-03-11 05:25:48 | Choco, Colombia | ||
2021-03-09 | Colombia | Choco | 6572 | 202 | 6287 | 83 | 5.2528 | -76.82600000000002 | 2021-03-10 05:24:35 | Choco, Colombia | ||
2021-03-08 | Colombia | Choco | 6569 | 202 | 6287 | 80 | 5.2528 | -76.82600000000002 | 2021-03-09 05:28:19 | Choco, Colombia | ||
2021-03-07 | Colombia | Choco | 6568 | 202 | 6284 | 82 | 5.2528 | -76.82600000000002 | 2021-03-08 05:24:48 | Choco, Colombia | ||
2020-10-30 | Colombia | Putumayo | 4335 | 202 | 3816 | 317 | 0.436 | -75.5277 | 2020-10-31 04:24:44 | Putumayo, Colombia | ||
2020-06-06 | Colombia | Valle del Cauca | 4206 | 202 | 1430 | 2574 | 3.8009 | -76.6413 | 2020-06-07 03:53:30 | Valle del Cauca, Colombia | ||
2020-06-05 | Colombia | Valle del Cauca | 4206 | 202 | 1430 | 2574 | 3.8009 | -76.6413 | 2020-06-06 02:33:00 | Valle del Cauca, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;