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 admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-07 | Colombia | Valle del Cauca | 50179 | 1891 | 41127 | 7161 | 3.8009 | -76.6413 | 2020-09-08 04:28:25 | 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-01-21 | Colombia | Valle del Cauca | 159546 | 4993 | 145649 | 8904 | 3.8009 | -76.6413 | 2021-01-22 05:22:10 | Valle del Cauca, Colombia | ||
2020-07-26 | Colombia | Valle del Cauca | 20875 | 812 | 11243 | 8820 | 3.8009 | -76.6413 | 2020-07-27 04:35:02 | 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 | |||
2020-08-07 | Colombia | Valle del Cauca | 30371 | 1177 | 17553 | 11641 | 3.8009 | -76.6413 | 2020-08-08 04:34:53 | 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 | |||
2021-02-19 | Colombia | Valle del Cauca | 191789 | 6043 | 180925 | 4821 | 3.8009 | -76.6413 | 2021-02-20 05:22:51 | 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 | |||
2021-07-19 | Colombia | Valle del Cauca | 366121 | 11521 | 348724 | 5876 | 3.8009 | -76.6413 | 2021-07-20 04:21:48 | 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-06-09 | Colombia | Valle del Cauca | 282550 | 8972 | 266496 | 7082 | 3.8009 | -76.6413 | 2021-06-10 04:23:17 | Valle del Cauca, Colombia | ||
2020-07-04 | Colombia | Valle del Cauca | 11202 | 452 | 4996 | 5754 | 3.8009 | -76.6413 | 2020-07-05 04:33:46 | Valle del Cauca, Colombia | ||
2021-02-22 | Colombia | Valle del Cauca | 193277 | 6100 | 182532 | 4645 | 3.8009 | -76.6413 | 2021-02-23 05:23:41 | 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 | |||
2020-09-12 | Colombia | Valle del Cauca | 53033 | 2002 | 45331 | 5700 | 3.8009 | -76.6413 | 2020-09-13 04:30:52 | 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-06-22 | Colombia | Valle del Cauca | 308227 | 9755 | 288588 | 9884 | 3.8009 | -76.6413 | 2021-06-23 04:21:46 | 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 | |||
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 | ||
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-07-13 | Colombia | Valle del Cauca | 358370 | 11170 | 337858 | 9342 | 3.8009 | -76.6413 | 2021-07-14 04:21:35 | Valle del Cauca, Colombia | ||
2020-08-13 | Colombia | Valle del Cauca | 35435 | 1321 | 20889 | 13225 | 3.8009 | -76.6413 | 2020-08-14 04:51:19 | 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 | |||
2021-04-09 | Colombia | Valle del Cauca | 214750 | 6668 | 202659 | 5423 | 3.8009 | -76.6413 | 2021-04-10 04:20:59 | Valle del Cauca, Colombia | ||
2020-08-29 | Colombia | Valle del Cauca | 46086 | 1698 | 35126 | 9262 | 3.8009 | -76.6413 | 2020-08-30 04:28:22 | Valle del Cauca, Colombia | ||
2021-02-08 | Colombia | Valle del Cauca | 185034 | 5771 | 171986 | 7277 | 3.8009 | -76.6413 | 2021-02-09 05:23:30 | 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 | |||
2021-07-10 | Colombia | Valle del Cauca | 351690 | 10870 | 328334 | 12486 | 3.8009 | -76.6413 | 2021-07-11 04:21:43 | 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-03-31 | Colombia | Valle del Cauca | 208396 | 6565 | 197183 | 4648 | 3.8009 | -76.6413 | 2021-04-01 04:27:05 | 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-05-05 | Colombia | Valle del Cauca | 240833 | 7502 | 228217 | 5114 | 3.8009 | -76.6413 | 2021-05-06 04:20:38 | 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 | |||
2020-08-11 | Colombia | Valle del Cauca | 32759 | 1268 | 19833 | 11658 | 3.8009 | -76.6413 | 2020-08-12 04:27:29 | Valle del Cauca, Colombia | ||
2020-09-16 | Colombia | Valle del Cauca | 55094 | 2050 | 46406 | 6638 | 3.8009 | -76.6413 | 2020-09-17 04:22:00 | 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 | |||
2020-11-23 | Colombia | Valle del Cauca | 102508 | 3313 | 93030 | 6165 | 3.8009 | -76.6413 | 2020-11-24 05:27:31 | 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-03-16 | Colombia | Valle del Cauca | 200999 | 6364 | 190529 | 4106 | 3.8009 | -76.6413 | 2021-03-17 05:25:07 | 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 | |||
2021-11-12 | Colombia | Valle del Cauca | 413303 | 13070 | 0 | 3.8009 | -76.6413 | 2021-11-13 04:21:38 | Valle del Cauca, Colombia | |||
2022-12-04 | Colombia | Valle del Cauca | 564373 | 15343 | 0 | 3.8009 | -76.6413 | 2022-12-05 04:20:58 | Valle del Cauca, Colombia | |||
2021-11-20 | Colombia | Valle del Cauca | 414761 | 13110 | 0 | 3.8009 | -76.6413 | 2021-11-21 04:22:13 | Valle del Cauca, Colombia | |||
2021-05-22 | Colombia | Valle del Cauca | 257458 | 8162 | 243362 | 5934 | 3.8009 | -76.6413 | 2021-05-23 04:20:51 | Valle del Cauca, Colombia | ||
2021-12-27 | Colombia | Valle del Cauca | 423437 | 13304 | 0 | 3.8009 | -76.6413 | 2021-12-28 04:21:47 | Valle del Cauca, Colombia | |||
2020-06-12 | Colombia | Valle del Cauca | 5258 | 245 | 1891 | 3122 | 3.8009 | -76.6413 | 2020-06-13 03:33:14 | Valle del Cauca, Colombia | ||
2020-12-02 | Colombia | Valle del Cauca | 110006 | 3530 | 99433 | 7043 | 3.8009 | -76.6413 | 2020-12-03 05:28:22 | Valle del Cauca, Colombia | ||
2021-02-20 | Colombia | Valle del Cauca | 192361 | 6046 | 181486 | 4829 | 3.8009 | -76.6413 | 2021-02-21 05:24:33 | Valle del Cauca, Colombia | ||
2022-04-23 | Colombia | Valle del Cauca | 540838 | 15044 | 0 | 3.8009 | -76.6413 | 2022-04-24 04:20:56 | Valle del Cauca, Colombia | |||
2020-08-01 | Colombia | Valle del Cauca | 25628 | 980 | 14411 | 10237 | 3.8009 | -76.6413 | 2020-08-02 04:34:47 | Valle del Cauca, Colombia | ||
2020-10-28 | Colombia | Valle del Cauca | 80962 | 2757 | 72226 | 5979 | 3.8009 | -76.6413 | 2020-10-29 04:24:49 | Valle del Cauca, Colombia | ||
2021-11-26 | Colombia | Valle del Cauca | 415870 | 13151 | 0 | 3.8009 | -76.6413 | 2021-11-27 04:22:45 | Valle del Cauca, Colombia | |||
2020-10-18 | Colombia | Valle del Cauca | 73561 | 2575 | 65153 | 5833 | 3.8009 | -76.6413 | 2020-10-19 04:24:16 | Valle del Cauca, Colombia | ||
2020-12-29 | Colombia | Valle del Cauca | 135455 | 4214 | 122990 | 8251 | 3.8009 | -76.6413 | 2020-12-30 05:22:34 | Valle del Cauca, Colombia | ||
2021-10-23 | Colombia | Valle del Cauca | 410443 | 12996 | 0 | 3.8009 | -76.6413 | 2021-10-24 04:21:22 | Valle del Cauca, Colombia | |||
2021-01-12 | Colombia | Valle del Cauca | 148437 | 4644 | 136214 | 7579 | 3.8009 | -76.6413 | 2021-01-13 05:22:15 | Valle del Cauca, Colombia | ||
2021-07-08 | Colombia | Valle del Cauca | 347022 | 10797 | 325309 | 10916 | 3.8009 | -76.6413 | 2021-07-09 04:21:21 | Valle del Cauca, Colombia | ||
2021-12-13 | Colombia | Valle del Cauca | 419216 | 13237 | 0 | 3.8009 | -76.6413 | 2021-12-14 04:22:38 | Valle del Cauca, Colombia | |||
2020-10-15 | Colombia | Valle del Cauca | 71661 | 2515 | 62127 | 7019 | 3.8009 | -76.6413 | 2020-10-16 04:24:01 | Valle del Cauca, Colombia | ||
2021-02-04 | Colombia | Valle del Cauca | 180679 | 5601 | 167159 | 7919 | 3.8009 | -76.6413 | 2021-02-05 05:22:38 | Valle del Cauca, Colombia | ||
2022-10-24 | Colombia | Valle del Cauca | 563850 | 15337 | 0 | 3.8009 | -76.6413 | 2022-10-25 04:21:53 | Valle del Cauca, Colombia | |||
2021-12-22 | Colombia | Valle del Cauca | 421247 | 13280 | 0 | 3.8009 | -76.6413 | 2021-12-23 04:21:21 | Valle del Cauca, Colombia | |||
2020-06-01 | Colombia | Valle del Cauca | 3471 | 161 | 1041 | 2269 | 3.8009 | -76.6413 | 2020-06-02 02:33:08 | Valle del Cauca, Colombia | ||
2021-09-20 | Colombia | Valle del Cauca | 405502 | 12850 | 0 | 3.8009 | -76.6413 | 2021-09-21 04:21:26 | Valle del Cauca, Colombia | |||
2020-09-05 | Colombia | Valle del Cauca | 48990 | 1851 | 39142 | 7997 | 3.8009 | -76.6413 | 2020-09-06 04:28:33 | Valle del Cauca, Colombia | ||
2020-10-09 | Colombia | Valle del Cauca | 68231 | 2405 | 58240 | 7586 | 3.8009 | -76.6413 | 2020-10-10 04:23:57 | Valle del Cauca, Colombia | ||
2020-11-19 | Colombia | Valle del Cauca | 99067 | 3205 | 89907 | 5955 | 3.8009 | -76.6413 | 2020-11-20 05:26:28 | Valle del Cauca, Colombia | ||
2021-06-06 | Colombia | Valle del Cauca | 277863 | 8837 | 261280 | 7746 | 3.8009 | -76.6413 | 2021-06-07 04:22:51 | Valle del Cauca, Colombia | ||
2021-07-09 | Colombia | Valle del Cauca | 349428 | 10870 | 325309 | 13249 | 3.8009 | -76.6413 | 2021-07-10 04:21:25 | Valle del Cauca, Colombia | ||
2022-12-02 | Colombia | Valle del Cauca | 564373 | 15343 | 0 | 3.8009 | -76.6413 | 2022-12-03 04:21:02 | Valle del Cauca, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;