daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Huila" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-28 | Colombia | Huila | 244 | 13 | 151 | 80 | 2.5359 | -75.5277 | 2020-05-29 02:32:50 | Huila, Colombia | ||
2020-05-31 | Colombia | Huila | 247 | 13 | 161 | 73 | 2.5359 | -75.5277 | 2020-06-01 02:32:46 | Huila, Colombia | ||
2020-05-30 | Colombia | Huila | 247 | 13 | 160 | 74 | 2.5359 | -75.5277 | 2020-05-31 02:32:45 | Huila, Colombia | ||
2020-06-01 | Colombia | Huila | 249 | 13 | 171 | 65 | 2.5359 | -75.5277 | 2020-06-02 02:33:08 | Huila, Colombia | ||
2020-05-29 | Colombia | Huila | 251 | 13 | 158 | 80 | 2.5359 | -75.5277 | 2020-05-30 02:32:48 | Huila, Colombia | ||
2020-06-02 | Colombia | Huila | 251 | 13 | 189 | 49 | 2.5359 | -75.5277 | 2020-06-03 02:33:13 | Huila, Colombia | ||
2020-06-03 | Colombia | Huila | 251 | 13 | 191 | 47 | 2.5359 | -75.5277 | 2020-06-04 02:33:14 | Huila, Colombia | ||
2020-06-04 | Colombia | Huila | 252 | 13 | 196 | 43 | 2.5359 | -75.5277 | 2020-06-05 02:33:06 | Huila, Colombia | ||
2020-06-06 | Colombia | Huila | 253 | 13 | 211 | 29 | 2.5359 | -75.5277 | 2020-06-07 03:53:30 | Huila, Colombia | ||
2020-06-05 | Colombia | Huila | 253 | 13 | 211 | 29 | 2.5359 | -75.5277 | 2020-06-06 02:33:00 | Huila, Colombia | ||
2020-06-07 | Colombia | Huila | 253 | 13 | 217 | 23 | 2.5359 | -75.5277 | 2020-06-08 03:33:22 | Huila, Colombia | ||
2020-06-08 | Colombia | Huila | 259 | 13 | 222 | 24 | 2.5359 | -75.5277 | 2020-06-09 03:33:03 | Huila, Colombia | ||
2020-06-09 | Colombia | Huila | 259 | 13 | 222 | 24 | 2.5359 | -75.5277 | 2020-06-10 04:07:00 | Huila, Colombia | ||
2020-06-11 | Colombia | Huila | 259 | 13 | 225 | 21 | 2.5359 | -75.5277 | 2020-06-12 05:09:52 | Huila, Colombia | ||
2020-06-10 | Colombia | Huila | 259 | 13 | 222 | 24 | 2.5359 | -75.5277 | 2020-06-11 03:33:41 | Huila, Colombia | ||
2020-06-12 | Colombia | Huila | 267 | 13 | 227 | 27 | 2.5359 | -75.5277 | 2020-06-13 03:33:14 | Huila, Colombia | ||
2020-06-13 | Colombia | Huila | 267 | 13 | 227 | 27 | 2.5359 | -75.5277 | 2020-06-14 03:33:15 | Huila, Colombia | ||
2020-06-14 | Colombia | Huila | 272 | 13 | 232 | 27 | 2.5359 | -75.5277 | 2020-06-15 03:33:14 | Huila, Colombia | ||
2020-06-15 | Colombia | Huila | 276 | 13 | 233 | 30 | 2.5359 | -75.5277 | 2020-06-16 04:33:09 | Huila, Colombia | ||
2020-06-16 | Colombia | Huila | 276 | 13 | 233 | 30 | 2.5359 | -75.5277 | 2020-06-17 04:33:21 | Huila, Colombia | ||
2020-06-17 | Colombia | Huila | 281 | 13 | 236 | 32 | 2.5359 | -75.5277 | 2020-06-18 04:33:18 | Huila, Colombia | ||
2020-06-18 | Colombia | Huila | 282 | 13 | 235 | 34 | 2.5359 | -75.5277 | 2020-06-19 04:33:17 | Huila, Colombia | ||
2020-06-19 | Colombia | Huila | 286 | 13 | 236 | 37 | 2.5359 | -75.5277 | 2020-06-20 04:33:19 | Huila, Colombia | ||
2020-06-20 | Colombia | Huila | 289 | 13 | 236 | 40 | 2.5359 | -75.5277 | 2020-06-21 04:33:19 | Huila, Colombia | ||
2020-06-21 | Colombia | Huila | 307 | 13 | 237 | 57 | 2.5359 | -75.5277 | 2020-06-22 04:33:20 | Huila, Colombia | ||
2020-06-22 | Colombia | Huila | 310 | 13 | 239 | 58 | 2.5359 | -75.5277 | 2020-06-23 04:33:22 | Huila, Colombia | ||
2020-06-23 | Colombia | Huila | 314 | 13 | 240 | 61 | 2.5359 | -75.5277 | 2020-06-24 04:33:28 | Huila, Colombia | ||
2020-06-24 | Colombia | Huila | 314 | 13 | 240 | 61 | 2.5359 | -75.5277 | 2020-06-25 05:26:54 | Huila, Colombia | ||
2020-06-25 | Colombia | Huila | 315 | 13 | 241 | 61 | 2.5359 | -75.5277 | 2020-06-26 04:33:43 | Huila, Colombia | ||
2020-06-26 | Colombia | Huila | 317 | 13 | 241 | 63 | 2.5359 | -75.5277 | 2020-06-27 04:33:35 | Huila, Colombia | ||
2020-06-27 | Colombia | Huila | 321 | 13 | 243 | 65 | 2.5359 | -75.5277 | 2020-06-28 04:34:04 | Huila, Colombia | ||
2020-06-28 | Colombia | Huila | 325 | 14 | 244 | 67 | 2.5359 | -75.5277 | 2020-06-29 04:33:44 | Huila, Colombia | ||
2020-06-29 | Colombia | Huila | 325 | 14 | 244 | 67 | 2.5359 | -75.5277 | 2020-06-30 04:33:48 | Huila, Colombia | ||
2020-06-30 | Colombia | Huila | 332 | 14 | 246 | 72 | 2.5359 | -75.5277 | 2020-07-01 04:33:52 | Huila, Colombia | ||
2020-07-02 | Colombia | Huila | 340 | 14 | 252 | 74 | 2.5359 | -75.5277 | 2020-07-03 04:33:54 | Huila, Colombia | ||
2020-07-01 | Colombia | Huila | 341 | 14 | 252 | 75 | 2.5359 | -75.5277 | 2020-07-02 04:33:46 | Huila, Colombia | ||
2020-07-03 | Colombia | Huila | 365 | 14 | 254 | 97 | 2.5359 | -75.5277 | 2020-07-04 04:33:51 | Huila, Colombia | ||
2020-07-04 | Colombia | Huila | 369 | 15 | 255 | 99 | 2.5359 | -75.5277 | 2020-07-05 04:33:46 | Huila, Colombia | ||
2020-07-05 | Colombia | Huila | 374 | 15 | 256 | 103 | 2.5359 | -75.5277 | 2020-07-06 04:33:57 | Huila, Colombia | ||
2020-07-06 | Colombia | Huila | 380 | 15 | 260 | 105 | 2.5359 | -75.5277 | 2020-07-07 04:34:00 | Huila, Colombia | ||
2020-07-07 | Colombia | Huila | 385 | 15 | 273 | 97 | 2.5359 | -75.5277 | 2020-07-08 05:33:48 | Huila, Colombia | ||
2020-07-08 | Colombia | Huila | 389 | 15 | 278 | 96 | 2.5359 | -75.5277 | 2020-07-09 04:34:23 | Huila, Colombia | ||
2020-07-09 | Colombia | Huila | 397 | 16 | 280 | 101 | 2.5359 | -75.5277 | 2020-07-10 04:34:24 | Huila, Colombia | ||
2020-07-10 | Colombia | Huila | 403 | 17 | 285 | 101 | 2.5359 | -75.5277 | 2020-07-11 04:34:26 | Huila, Colombia | ||
2020-07-11 | Colombia | Huila | 416 | 17 | 290 | 109 | 2.5359 | -75.5277 | 2020-07-12 04:34:30 | Huila, Colombia | ||
2020-07-12 | Colombia | Huila | 418 | 17 | 293 | 108 | 2.5359 | -75.5277 | 2020-07-13 04:43:04 | Huila, Colombia | ||
2020-07-14 | Colombia | Huila | 424 | 17 | 321 | 86 | 2.5359 | -75.5277 | 2020-07-15 04:34:39 | Huila, Colombia | ||
2020-07-13 | Colombia | Huila | 424 | 17 | 321 | 86 | 2.5359 | -75.5277 | 2020-07-14 04:34:46 | Huila, Colombia | ||
2020-07-15 | Colombia | Huila | 434 | 17 | 331 | 86 | 2.5359 | -75.5277 | 2020-07-16 04:44:59 | Huila, Colombia | ||
2020-07-16 | Colombia | Huila | 458 | 18 | 333 | 107 | 2.5359 | -75.5277 | 2020-07-17 04:34:50 | Huila, Colombia | ||
2020-07-17 | Colombia | Huila | 492 | 15 | 346 | 131 | 2.5359 | -75.5277 | 2020-07-18 04:34:45 | Huila, Colombia | ||
2020-07-18 | Colombia | Huila | 520 | 15 | 348 | 157 | 2.5359 | -75.5277 | 2020-07-19 04:34:58 | Huila, Colombia | ||
2020-07-19 | Colombia | Huila | 535 | 15 | 358 | 162 | 2.5359 | -75.5277 | 2020-07-20 05:34:40 | Huila, Colombia | ||
2020-07-20 | Colombia | Huila | 559 | 15 | 360 | 184 | 2.5359 | -75.5277 | 2020-07-21 04:38:46 | Huila, Colombia | ||
2020-07-21 | Colombia | Huila | 578 | 17 | 360 | 201 | 2.5359 | -75.5277 | 2020-07-22 04:34:42 | Huila, Colombia | ||
2020-07-22 | Colombia | Huila | 590 | 17 | 360 | 213 | 2.5359 | -75.5277 | 2020-07-23 05:15:04 | Huila, Colombia | ||
2020-07-23 | Colombia | Huila | 625 | 18 | 362 | 245 | 2.5359 | -75.5277 | 2020-07-24 05:30:40 | Huila, Colombia | ||
2020-07-24 | Colombia | Huila | 646 | 18 | 365 | 263 | 2.5359 | -75.5277 | 2020-07-25 04:47:39 | Huila, Colombia | ||
2020-07-26 | Colombia | Huila | 673 | 18 | 367 | 288 | 2.5359 | -75.5277 | 2020-07-27 04:35:02 | Huila, Colombia | ||
2020-07-25 | Colombia | Huila | 673 | 18 | 367 | 288 | 2.5359 | -75.5277 | 2020-07-26 04:35:00 | Huila, Colombia | ||
2020-07-27 | Colombia | Huila | 721 | 18 | 391 | 312 | 2.5359 | -75.5277 | 2020-07-28 04:58:43 | Huila, Colombia | ||
2020-07-28 | Colombia | Huila | 746 | 18 | 395 | 333 | 2.5359 | -75.5277 | 2020-07-29 04:35:11 | Huila, Colombia | ||
2020-07-29 | Colombia | Huila | 778 | 20 | 413 | 345 | 2.5359 | -75.5277 | 2020-07-30 04:35:05 | Huila, Colombia | ||
2020-07-30 | Colombia | Huila | 890 | 20 | 419 | 451 | 2.5359 | -75.5277 | 2020-07-31 04:35:18 | Huila, Colombia | ||
2020-07-31 | Colombia | Huila | 908 | 26 | 426 | 456 | 2.5359 | -75.5277 | 2020-08-01 04:36:27 | Huila, Colombia | ||
2020-08-01 | Colombia | Huila | 950 | 26 | 434 | 490 | 2.5359 | -75.5277 | 2020-08-02 04:34:47 | Huila, Colombia | ||
2020-08-02 | Colombia | Huila | 986 | 27 | 453 | 506 | 2.5359 | -75.5277 | 2020-08-03 04:34:35 | Huila, Colombia | ||
2020-08-03 | Colombia | Huila | 1128 | 27 | 477 | 624 | 2.5359 | -75.5277 | 2020-08-04 04:41:59 | Huila, Colombia | ||
2020-08-04 | Colombia | Huila | 1164 | 27 | 512 | 625 | 2.5359 | -75.5277 | 2020-08-05 04:34:43 | Huila, Colombia | ||
2020-08-05 | Colombia | Huila | 1206 | 27 | 530 | 649 | 2.5359 | -75.5277 | 2020-08-06 04:35:02 | Huila, Colombia | ||
2020-08-06 | Colombia | Huila | 1271 | 27 | 544 | 700 | 2.5359 | -75.5277 | 2020-08-07 04:35:11 | Huila, Colombia | ||
2020-08-07 | Colombia | Huila | 1363 | 32 | 562 | 769 | 2.5359 | -75.5277 | 2020-08-08 04:34:53 | Huila, Colombia | ||
2020-08-08 | Colombia | Huila | 1470 | 34 | 585 | 851 | 2.5359 | -75.5277 | 2020-08-09 04:34:54 | Huila, Colombia | ||
2020-08-09 | Colombia | Huila | 1614 | 36 | 621 | 957 | 2.5359 | -75.5277 | 2020-08-10 04:34:55 | Huila, Colombia | ||
2020-08-10 | Colombia | Huila | 1747 | 42 | 661 | 1044 | 2.5359 | -75.5277 | 2020-08-11 04:35:08 | Huila, Colombia | ||
2020-08-11 | Colombia | Huila | 1855 | 49 | 677 | 1129 | 2.5359 | -75.5277 | 2020-08-12 04:27:29 | Huila, Colombia | ||
2020-08-12 | Colombia | Huila | 1998 | 54 | 691 | 1253 | 2.5359 | -75.5277 | 2020-08-13 04:29:15 | Huila, Colombia | ||
2020-08-13 | Colombia | Huila | 2130 | 56 | 728 | 1346 | 2.5359 | -75.5277 | 2020-08-14 04:51:19 | Huila, Colombia | ||
2020-08-14 | Colombia | Huila | 2184 | 59 | 780 | 1345 | 2.5359 | -75.5277 | 2020-08-15 04:27:31 | Huila, Colombia | ||
2020-08-15 | Colombia | Huila | 2343 | 60 | 875 | 1408 | 2.5359 | -75.5277 | 2020-08-16 04:27:42 | Huila, Colombia | ||
2020-08-16 | Colombia | Huila | 2513 | 67 | 957 | 1489 | 2.5359 | -75.5277 | 2020-08-17 04:27:20 | Huila, Colombia | ||
2020-08-17 | Colombia | Huila | 2688 | 69 | 1063 | 1556 | 2.5359 | -75.5277 | 2020-08-18 04:27:56 | Huila, Colombia | ||
2020-08-18 | Colombia | Huila | 2845 | 72 | 1137 | 1636 | 2.5359 | -75.5277 | 2020-08-19 04:27:00 | Huila, Colombia | ||
2020-08-19 | Colombia | Huila | 3040 | 77 | 1245 | 1718 | 2.5359 | -75.5277 | 2020-08-20 04:27:43 | Huila, Colombia | ||
2020-08-20 | Colombia | Huila | 3148 | 78 | 1429 | 1641 | 2.5359 | -75.5277 | 2020-08-21 04:27:41 | Huila, Colombia | ||
2020-08-21 | Colombia | Huila | 3325 | 81 | 1521 | 1723 | 2.5359 | -75.5277 | 2020-08-22 04:27:49 | Huila, Colombia | ||
2020-08-22 | Colombia | Huila | 3325 | 81 | 1521 | 1723 | 2.5359 | -75.5277 | 2020-08-23 04:27:48 | Huila, Colombia | ||
2020-08-23 | Colombia | Huila | 3530 | 90 | 1806 | 1634 | 2.5359 | -75.5277 | 2020-08-24 04:27:56 | Huila, Colombia | ||
2020-08-24 | Colombia | Huila | 3690 | 94 | 1888 | 1708 | 2.5359 | -75.5277 | 2020-08-25 04:28:02 | Huila, Colombia | ||
2020-08-25 | Colombia | Huila | 3891 | 93 | 2055 | 1743 | 2.5359 | -75.5277 | 2020-08-26 04:28:11 | Huila, Colombia | ||
2020-08-26 | Colombia | Huila | 4050 | 99 | 2212 | 1739 | 2.5359 | -75.5277 | 2020-08-27 04:28:15 | Huila, Colombia | ||
2020-08-27 | Colombia | Huila | 4303 | 109 | 2424 | 1770 | 2.5359 | -75.5277 | 2020-08-28 04:28:11 | Huila, Colombia | ||
2020-08-28 | Colombia | Huila | 4529 | 111 | 2557 | 1861 | 2.5359 | -75.5277 | 2020-08-29 04:28:19 | Huila, Colombia | ||
2020-08-29 | Colombia | Huila | 4737 | 122 | 2666 | 1949 | 2.5359 | -75.5277 | 2020-08-30 04:28:22 | Huila, Colombia | ||
2020-08-30 | Colombia | Huila | 5007 | 131 | 2817 | 2059 | 2.5359 | -75.5277 | 2020-08-31 04:28:27 | Huila, Colombia | ||
2020-08-31 | Colombia | Huila | 5167 | 137 | 2980 | 2050 | 2.5359 | -75.5277 | 2020-09-01 04:28:31 | Huila, Colombia | ||
2020-09-01 | Colombia | Huila | 5360 | 143 | 3071 | 2146 | 2.5359 | -75.5277 | 2020-09-02 04:28:25 | Huila, Colombia | ||
2020-09-02 | Colombia | Huila | 5521 | 149 | 3181 | 2191 | 2.5359 | -75.5277 | 2020-09-03 04:28:22 | Huila, Colombia | ||
2020-09-03 | Colombia | Huila | 5636 | 162 | 3570 | 1904 | 2.5359 | -75.5277 | 2020-09-04 04:28:26 | Huila, Colombia | ||
2020-09-04 | Colombia | Huila | 5636 | 162 | 3570 | 1904 | 2.5359 | -75.5277 | 2020-09-05 04:28:19 | Huila, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;