daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Valle del Cauca" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) >30 ✖
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- 2020-06-19 1
- 2020-06-20 1
- 2020-06-21 1
- 2020-06-22 1
- 2020-06-23 1
- 2020-06-24 1
- 2020-06-25 1
- 2020-06-26 1
- …
province_or_state 1
- Valle del Cauca · 946 ✖
country_or_region 1
- Colombia · 946 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Colombia | Valle del Cauca | 417045 | 13189 | 0 | 3.8009 | -76.6413 | 2021-12-03 04:23:05 | Valle del Cauca, Colombia | |||
2021-10-28 | Colombia | Valle del Cauca | 411198 | 13024 | 0 | 3.8009 | -76.6413 | 2021-10-29 04:22:03 | Valle del Cauca, Colombia | |||
2021-09-18 | Colombia | Valle del Cauca | 405280 | 12842 | 0 | 3.8009 | -76.6413 | 2021-09-19 04:21:34 | Valle del Cauca, Colombia | |||
2022-03-20 | Colombia | Valle del Cauca | 539988 | 14992 | 0 | 3.8009 | -76.6413 | 2022-03-21 04:20:50 | Valle del Cauca, Colombia | |||
2021-11-11 | Colombia | Valle del Cauca | 413075 | 13064 | 0 | 3.8009 | -76.6413 | 2021-11-12 04:22:01 | Valle del Cauca, Colombia | |||
2021-08-25 | Colombia | Valle del Cauca | 400176 | 12658 | 0 | 3.8009 | -76.6413 | 2021-08-26 04:21:28 | Valle del Cauca, Colombia | |||
2021-11-02 | Colombia | Valle del Cauca | 411724 | 13042 | 0 | 3.8009 | -76.6413 | 2021-11-03 06:22:09 | Valle del Cauca, Colombia | |||
2022-11-12 | Colombia | Valle del Cauca | 564019 | 15339 | 0 | 3.8009 | -76.6413 | 2022-11-13 04:21:14 | Valle del Cauca, Colombia | |||
2021-09-01 | Colombia | Valle del Cauca | 401948 | 12733 | 0 | 3.8009 | -76.6413 | 2021-09-02 04:21:15 | Valle del Cauca, Colombia | |||
2022-02-07 | Colombia | Valle del Cauca | 533494 | 14620 | 0 | 3.8009 | -76.6413 | 2022-02-08 04:21:15 | Valle del Cauca, Colombia | |||
2021-11-09 | Colombia | Valle del Cauca | 412755 | 13061 | 0 | 3.8009 | -76.6413 | 2021-11-10 04:21:38 | Valle del Cauca, Colombia | |||
2022-07-23 | Colombia | Valle del Cauca | 556348 | 15187 | 0 | 3.8009 | -76.6413 | 2022-07-24 04:20:47 | Valle del Cauca, Colombia | |||
2022-01-14 | Colombia | Valle del Cauca | 494164 | 13553 | 0 | 3.8009 | -76.6413 | 2022-01-15 04:21:07 | Valle del Cauca, Colombia | |||
2021-08-15 | Colombia | Valle del Cauca | 394788 | 12491 | 0 | 3.8009 | -76.6413 | 2021-08-16 04:21:31 | Valle del Cauca, Colombia | |||
2022-09-06 | Colombia | Valle del Cauca | 563198 | 15322 | 0 | 3.8009 | -76.6413 | 2022-09-07 04:20:59 | Valle del Cauca, Colombia | |||
2022-01-09 | Colombia | Valle del Cauca | 471497 | 13441 | 0 | 3.8009 | -76.6413 | 2022-01-10 04:22:07 | Valle del Cauca, Colombia | |||
2022-10-04 | Colombia | Valle del Cauca | 563490 | 15333 | 0 | 3.8009 | -76.6413 | 2022-10-05 04:23:06 | Valle del Cauca, Colombia | |||
2021-12-04 | Colombia | Valle del Cauca | 417564 | 13194 | 0 | 3.8009 | -76.6413 | 2021-12-05 04:22:25 | Valle del Cauca, Colombia | |||
2022-07-09 | Colombia | Valle del Cauca | 551933 | 15095 | 0 | 3.8009 | -76.6413 | 2022-07-10 04:20:54 | Valle del Cauca, Colombia | |||
2021-11-29 | Colombia | Valle del Cauca | 416370 | 13167 | 0 | 3.8009 | -76.6413 | 2021-11-30 04:22:53 | Valle del Cauca, Colombia | |||
2022-03-29 | Colombia | Valle del Cauca | 540303 | 15015 | 0 | 3.8009 | -76.6413 | 2022-03-30 04:20:45 | Valle del Cauca, Colombia | |||
2021-11-19 | Colombia | Valle del Cauca | 414495 | 13110 | 0 | 3.8009 | -76.6413 | 2021-11-20 04:22:17 | Valle del Cauca, Colombia | |||
2022-06-21 | Colombia | Valle del Cauca | 543544 | 15062 | 0 | 3.8009 | -76.6413 | 2022-06-22 04:20:54 | Valle del Cauca, Colombia | |||
2021-09-02 | Colombia | Valle del Cauca | 402139 | 12743 | 0 | 3.8009 | -76.6413 | 2021-09-03 04:21:20 | Valle del Cauca, Colombia | |||
2022-02-13 | Colombia | Valle del Cauca | 535979 | 14764 | 0 | 3.8009 | -76.6413 | 2022-02-14 04:20:51 | Valle del Cauca, Colombia | |||
2022-10-19 | Colombia | Valle del Cauca | 563788 | 15334 | 0 | 3.8009 | -76.6413 | 2022-10-20 04:22:59 | Valle del Cauca, Colombia | |||
2022-12-26 | Colombia | Valle del Cauca | 566582 | 15363 | 0 | 3.8009 | -76.6413 | 2022-12-27 04:21:07 | Valle del Cauca, Colombia | |||
2022-05-09 | Colombia | Valle del Cauca | 540979 | 15049 | 0 | 3.8009 | -76.6413 | 2022-05-10 04:20:50 | Valle del Cauca, Colombia | |||
2022-05-31 | Colombia | Valle del Cauca | 541560 | 15053 | 0 | 3.8009 | -76.6413 | 2022-06-01 04:20:55 | Valle del Cauca, Colombia | |||
2022-02-11 | Colombia | Valle del Cauca | 534788 | 14703 | 0 | 3.8009 | -76.6413 | 2022-02-12 04:21:06 | Valle del Cauca, Colombia | |||
2021-08-17 | Colombia | Valle del Cauca | 396514 | 12522 | 0 | 3.8009 | -76.6413 | 2021-08-18 04:21:35 | Valle del Cauca, Colombia | |||
2021-09-04 | Colombia | Valle del Cauca | 402580 | 12763 | 0 | 3.8009 | -76.6413 | 2021-09-05 04:21:33 | Valle del Cauca, Colombia | |||
2022-09-08 | Colombia | Valle del Cauca | 563327 | 15322 | 0 | 3.8009 | -76.6413 | 2022-09-09 04:21:11 | Valle del Cauca, Colombia | |||
2022-12-10 | Colombia | Valle del Cauca | 564876 | 15346 | 0 | 3.8009 | -76.6413 | 2022-12-11 04:20:50 | Valle del Cauca, Colombia | |||
2022-03-15 | Colombia | Valle del Cauca | 539768 | 14989 | 0 | 3.8009 | -76.6413 | 2022-03-16 04:20:50 | Valle del Cauca, Colombia | |||
2021-11-03 | Colombia | Valle del Cauca | 411908 | 13042 | 0 | 3.8009 | -76.6413 | 2021-11-04 04:22:20 | Valle del Cauca, Colombia | |||
2021-10-31 | Colombia | Valle del Cauca | 411564 | 13032 | 0 | 3.8009 | -76.6413 | 2021-11-01 04:22:01 | Valle del Cauca, Colombia | |||
2022-11-15 | Colombia | Valle del Cauca | 564019 | 15339 | 0 | 3.8009 | -76.6413 | 2022-11-16 04:21:09 | Valle del Cauca, Colombia | |||
2022-04-16 | Colombia | Valle del Cauca | 540733 | 15040 | 0 | 3.8009 | -76.6413 | 2022-04-17 04:20:59 | Valle del Cauca, Colombia | |||
2022-12-13 | Colombia | Valle del Cauca | 564876 | 15346 | 0 | 3.8009 | -76.6413 | 2022-12-14 04:21:04 | Valle del Cauca, Colombia | |||
2022-11-13 | Colombia | Valle del Cauca | 564019 | 15339 | 0 | 3.8009 | -76.6413 | 2022-11-14 04:21:09 | Valle del Cauca, Colombia | |||
2022-02-12 | Colombia | Valle del Cauca | 535426 | 14723 | 0 | 3.8009 | -76.6413 | 2022-02-13 04:21:00 | Valle del Cauca, Colombia | |||
2022-10-30 | Colombia | Valle del Cauca | 563900 | 15337 | 0 | 3.8009 | -76.6413 | 2022-10-31 04:21:36 | Valle del Cauca, Colombia | |||
2022-12-27 | Colombia | Valle del Cauca | 566582 | 15363 | 0 | 3.8009 | -76.6413 | 2022-12-28 04:21:04 | Valle del Cauca, Colombia | |||
2022-03-18 | Colombia | Valle del Cauca | 539882 | 14990 | 0 | 3.8009 | -76.6413 | 2022-03-19 04:20:47 | Valle del Cauca, Colombia | |||
2022-12-14 | Colombia | Valle del Cauca | 564876 | 15346 | 0 | 3.8009 | -76.6413 | 2022-12-15 04:20:58 | Valle del Cauca, Colombia | |||
2022-03-11 | Colombia | Valle del Cauca | 539613 | 14980 | 0 | 3.8009 | -76.6413 | 2022-03-12 04:20:50 | Valle del Cauca, Colombia | |||
2022-05-07 | Colombia | Valle del Cauca | 540979 | 15049 | 0 | 3.8009 | -76.6413 | 2022-05-08 04:20:49 | Valle del Cauca, Colombia | |||
2022-09-13 | Colombia | Valle del Cauca | 563327 | 15326 | 0 | 3.8009 | -76.6413 | 2022-09-14 04:20:44 | Valle del Cauca, Colombia | |||
2022-09-23 | Colombia | Valle del Cauca | 563490 | 15330 | 0 | 3.8009 | -76.6413 | 2022-09-24 04:21:40 | Valle del Cauca, Colombia | |||
2022-10-07 | Colombia | Valle del Cauca | 563691 | 15333 | 0 | 3.8009 | -76.6413 | 2022-10-08 04:22:56 | Valle del Cauca, Colombia | |||
2021-12-07 | Colombia | Valle del Cauca | 417925 | 13207 | 0 | 3.8009 | -76.6413 | 2021-12-08 04:22:46 | Valle del Cauca, Colombia | |||
2022-09-18 | Colombia | Valle del Cauca | 563412 | 15328 | 0 | 3.8009 | -76.6413 | 2022-09-19 04:21:49 | Valle del Cauca, Colombia | |||
2021-10-10 | Colombia | Valle del Cauca | 408670 | 12953 | 0 | 3.8009 | -76.6413 | 2021-10-11 04:21:31 | Valle del Cauca, Colombia | |||
2022-11-03 | Colombia | Valle del Cauca | 563941 | 15337 | 0 | 3.8009 | -76.6413 | 2022-11-04 04:22:11 | Valle del Cauca, Colombia | |||
2021-10-20 | Colombia | Valle del Cauca | 409983 | 12984 | 0 | 3.8009 | -76.6413 | 2021-10-21 04:21:18 | Valle del Cauca, Colombia | |||
2021-11-17 | Colombia | Valle del Cauca | 414107 | 13097 | 0 | 3.8009 | -76.6413 | 2021-11-18 04:21:33 | Valle del Cauca, Colombia | |||
2022-12-21 | Colombia | Valle del Cauca | 565776 | 15353 | 0 | 3.8009 | -76.6413 | 2022-12-22 04:20:56 | Valle del Cauca, Colombia | |||
2022-02-02 | Colombia | Valle del Cauca | 530714 | 14484 | 0 | 3.8009 | -76.6413 | 2022-02-03 04:21:21 | Valle del Cauca, Colombia | |||
2022-05-02 | Colombia | Valle del Cauca | 540919 | 15046 | 0 | 3.8009 | -76.6413 | 2022-05-03 04:21:00 | Valle del Cauca, Colombia | |||
2021-10-07 | Colombia | Valle del Cauca | 408260 | 12936 | 0 | 3.8009 | -76.6413 | 2021-10-08 04:21:25 | Valle del Cauca, Colombia | |||
2022-06-26 | Colombia | Valle del Cauca | 545451 | 15064 | 0 | 3.8009 | -76.6413 | 2022-06-27 04:21:00 | Valle del Cauca, Colombia | |||
2022-11-08 | Colombia | Valle del Cauca | 563941 | 15339 | 0 | 3.8009 | -76.6413 | 2022-11-09 04:21:22 | Valle del Cauca, Colombia | |||
2022-11-25 | Colombia | Valle del Cauca | 564150 | 15340 | 0 | 3.8009 | -76.6413 | 2022-11-26 04:21:11 | Valle del Cauca, Colombia | |||
2021-10-14 | Colombia | Valle del Cauca | 409153 | 12964 | 0 | 3.8009 | -76.6413 | 2021-10-15 04:21:26 | Valle del Cauca, Colombia | |||
2021-11-06 | Colombia | Valle del Cauca | 412342 | 13054 | 0 | 3.8009 | -76.6413 | 2021-11-07 04:21:53 | Valle del Cauca, Colombia | |||
2022-04-02 | Colombia | Valle del Cauca | 540421 | 15022 | 0 | 3.8009 | -76.6413 | 2022-04-03 04:20:48 | Valle del Cauca, Colombia | |||
2022-12-17 | Colombia | Valle del Cauca | 565776 | 15353 | 0 | 3.8009 | -76.6413 | 2022-12-18 04:21:03 | Valle del Cauca, Colombia | |||
2021-08-14 | Colombia | Valle del Cauca | 394788 | 12466 | 0 | 3.8009 | -76.6413 | 2021-08-15 04:21:41 | Valle del Cauca, Colombia | |||
2021-08-19 | Colombia | Valle del Cauca | 397938 | 12553 | 0 | 3.8009 | -76.6413 | 2021-08-20 04:21:33 | Valle del Cauca, Colombia | |||
2022-10-15 | Colombia | Valle del Cauca | 563788 | 15334 | 0 | 3.8009 | -76.6413 | 2022-10-16 04:22:39 | Valle del Cauca, Colombia | |||
2021-10-27 | Colombia | Valle del Cauca | 411065 | 13016 | 0 | 3.8009 | -76.6413 | 2021-10-28 04:22:08 | Valle del Cauca, Colombia | |||
2022-10-26 | Colombia | Valle del Cauca | 563850 | 15337 | 0 | 3.8009 | -76.6413 | 2022-10-27 04:22:01 | Valle del Cauca, Colombia | |||
2022-12-15 | Colombia | Valle del Cauca | 565776 | 15353 | 0 | 3.8009 | -76.6413 | 2022-12-16 04:21:01 | Valle del Cauca, Colombia | |||
2021-12-08 | Colombia | Valle del Cauca | 418415 | 13207 | 0 | 3.8009 | -76.6413 | 2021-12-09 04:22:49 | Valle del Cauca, Colombia | |||
2022-01-16 | Colombia | Valle del Cauca | 502154 | 13635 | 0 | 3.8009 | -76.6413 | 2022-01-17 04:21:08 | Valle del Cauca, Colombia | |||
2022-06-16 | Colombia | Valle del Cauca | 543544 | 15062 | 0 | 3.8009 | -76.6413 | 2022-06-17 04:20:56 | Valle del Cauca, Colombia | |||
2021-10-29 | Colombia | Valle del Cauca | 411350 | 13029 | 0 | 3.8009 | -76.6413 | 2021-10-30 04:22:03 | Valle del Cauca, Colombia | |||
2022-02-25 | Colombia | Valle del Cauca | 538175 | 14895 | 0 | 3.8009 | -76.6413 | 2022-02-26 04:21:12 | Valle del Cauca, Colombia | |||
2021-08-08 | Colombia | Valle del Cauca | 390850 | 12319 | 0 | 3.8009 | -76.6413 | 2021-08-09 04:21:24 | Valle del Cauca, Colombia | |||
2022-07-01 | Colombia | Valle del Cauca | 548874 | 15070 | 0 | 3.8009 | -76.6413 | 2022-07-02 04:21:16 | Valle del Cauca, Colombia | |||
2021-10-19 | Colombia | Valle del Cauca | 409827 | 12982 | 0 | 3.8009 | -76.6413 | 2021-10-20 04:21:00 | Valle del Cauca, Colombia | |||
2021-09-23 | Colombia | Valle del Cauca | 405999 | 12870 | 0 | 3.8009 | -76.6413 | 2021-09-24 04:21:44 | Valle del Cauca, Colombia | |||
2022-11-05 | Colombia | Valle del Cauca | 563941 | 15337 | 0 | 3.8009 | -76.6413 | 2022-11-06 04:21:24 | Valle del Cauca, Colombia | |||
2022-05-22 | Colombia | Valle del Cauca | 541231 | 15051 | 0 | 3.8009 | -76.6413 | 2022-05-26 04:20:50 | Valle del Cauca, Colombia | |||
2022-07-12 | Colombia | Valle del Cauca | 551933 | 15095 | 0 | 3.8009 | -76.6413 | 2022-07-13 04:20:58 | Valle del Cauca, Colombia | |||
2021-10-13 | Colombia | Valle del Cauca | 408999 | 12959 | 0 | 3.8009 | -76.6413 | 2021-10-14 04:21:29 | Valle del Cauca, Colombia | |||
2021-09-07 | Colombia | Valle del Cauca | 403011 | 12790 | 0 | 3.8009 | -76.6413 | 2021-09-08 04:21:31 | Valle del Cauca, Colombia | |||
2021-08-09 | Colombia | Valle del Cauca | 391120 | 12338 | 0 | 3.8009 | -76.6413 | 2021-08-10 04:21:27 | Valle del Cauca, Colombia | |||
2021-10-22 | Colombia | Valle del Cauca | 410290 | 12993 | 0 | 3.8009 | -76.6413 | 2021-10-23 04:21:32 | Valle del Cauca, Colombia | |||
2022-05-13 | Colombia | Valle del Cauca | 541062 | 15050 | 0 | 3.8009 | -76.6413 | 2022-05-14 04:20:48 | Valle del Cauca, Colombia | |||
2022-07-21 | Colombia | Valle del Cauca | 551933 | 15125 | 0 | 3.8009 | -76.6413 | 2022-07-22 04:21:15 | Valle del Cauca, Colombia | |||
2022-07-30 | Colombia | Valle del Cauca | 560769 | 15230 | 0 | 3.8009 | -76.6413 | 2022-07-31 04:21:02 | Valle del Cauca, Colombia | |||
2021-10-24 | Colombia | Valle del Cauca | 410650 | 13000 | 0 | 3.8009 | -76.6413 | 2021-10-25 04:22:31 | Valle del Cauca, Colombia | |||
2021-11-13 | Colombia | Valle del Cauca | 413504 | 13077 | 0 | 3.8009 | -76.6413 | 2021-11-14 04:21:31 | Valle del Cauca, Colombia | |||
2022-12-23 | Colombia | Valle del Cauca | 566582 | 15363 | 0 | 3.8009 | -76.6413 | 2022-12-24 04:21:02 | Valle del Cauca, Colombia | |||
2022-03-17 | Colombia | Valle del Cauca | 539837 | 14989 | 0 | 3.8009 | -76.6413 | 2022-03-18 04:20:55 | Valle del Cauca, Colombia | |||
2021-11-04 | Colombia | Valle del Cauca | 412040 | 13048 | 0 | 3.8009 | -76.6413 | 2021-11-05 04:21:54 | Valle del Cauca, Colombia | |||
2021-09-29 | Colombia | Valle del Cauca | 406936 | 12902 | 0 | 3.8009 | -76.6413 | 2021-09-30 04:21:20 | Valle del Cauca, Colombia | |||
2022-11-01 | Colombia | Valle del Cauca | 563900 | 15337 | 0 | 3.8009 | -76.6413 | 2022-11-02 04:22:09 | Valle del Cauca, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;