daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Santander" sorted by confirmed
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
- Santander · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-31 | Colombia | Santander | 58 | 3 | 39 | 16 | 6.6437 | -73.6536 | 2020-06-01 02:32:46 | Santander, Colombia | ||
2020-05-28 | Colombia | Santander | 58 | 3 | 38 | 17 | 6.6437 | -73.6536 | 2020-05-29 02:32:50 | Santander, Colombia | ||
2020-05-29 | Colombia | Santander | 59 | 3 | 38 | 18 | 6.6437 | -73.6536 | 2020-05-30 02:32:48 | Santander, Colombia | ||
2020-05-30 | Colombia | Santander | 59 | 3 | 38 | 18 | 6.6437 | -73.6536 | 2020-05-31 02:32:45 | Santander, Colombia | ||
2020-06-01 | Colombia | Santander | 69 | 3 | 42 | 24 | 6.6437 | -73.6536 | 2020-06-02 02:33:08 | Santander, Colombia | ||
2020-06-02 | Colombia | Santander | 72 | 3 | 43 | 26 | 6.6437 | -73.6536 | 2020-06-03 02:33:13 | Santander, Colombia | ||
2020-06-03 | Colombia | Santander | 84 | 4 | 47 | 33 | 6.6437 | -73.6536 | 2020-06-04 02:33:14 | Santander, Colombia | ||
2020-06-04 | Colombia | Santander | 114 | 4 | 47 | 63 | 6.6437 | -73.6536 | 2020-06-05 02:33:06 | Santander, Colombia | ||
2020-06-06 | Colombia | Santander | 131 | 4 | 50 | 77 | 6.6437 | -73.6536 | 2020-06-07 03:53:30 | Santander, Colombia | ||
2020-06-05 | Colombia | Santander | 131 | 4 | 50 | 77 | 6.6437 | -73.6536 | 2020-06-06 02:33:00 | Santander, Colombia | ||
2020-06-07 | Colombia | Santander | 150 | 4 | 50 | 96 | 6.6437 | -73.6536 | 2020-06-08 03:33:22 | Santander, Colombia | ||
2020-06-08 | Colombia | Santander | 167 | 6 | 50 | 111 | 6.6437 | -73.6536 | 2020-06-09 03:33:03 | Santander, Colombia | ||
2020-06-09 | Colombia | Santander | 167 | 6 | 50 | 111 | 6.6437 | -73.6536 | 2020-06-10 04:07:00 | Santander, Colombia | ||
2020-06-10 | Colombia | Santander | 194 | 7 | 50 | 137 | 6.6437 | -73.6536 | 2020-06-11 03:33:41 | Santander, Colombia | ||
2020-06-11 | Colombia | Santander | 202 | 7 | 50 | 145 | 6.6437 | -73.6536 | 2020-06-12 05:09:52 | Santander, Colombia | ||
2020-06-12 | Colombia | Santander | 208 | 8 | 52 | 148 | 6.6437 | -73.6536 | 2020-06-13 03:33:14 | Santander, Colombia | ||
2020-06-13 | Colombia | Santander | 211 | 9 | 54 | 148 | 6.6437 | -73.6536 | 2020-06-14 03:33:15 | Santander, Colombia | ||
2020-06-14 | Colombia | Santander | 222 | 9 | 54 | 159 | 6.6437 | -73.6536 | 2020-06-15 03:33:14 | Santander, Colombia | ||
2020-06-15 | Colombia | Santander | 253 | 9 | 54 | 190 | 6.6437 | -73.6536 | 2020-06-16 04:33:09 | Santander, Colombia | ||
2020-06-16 | Colombia | Santander | 253 | 9 | 54 | 190 | 6.6437 | -73.6536 | 2020-06-17 04:33:21 | Santander, Colombia | ||
2020-06-17 | Colombia | Santander | 267 | 10 | 55 | 202 | 6.6437 | -73.6536 | 2020-06-18 04:33:18 | Santander, Colombia | ||
2020-06-18 | Colombia | Santander | 295 | 10 | 60 | 225 | 6.6437 | -73.6536 | 2020-06-19 04:33:17 | Santander, Colombia | ||
2020-06-19 | Colombia | Santander | 323 | 10 | 70 | 243 | 6.6437 | -73.6536 | 2020-06-20 04:33:19 | Santander, Colombia | ||
2020-06-20 | Colombia | Santander | 343 | 10 | 80 | 253 | 6.6437 | -73.6536 | 2020-06-21 04:33:19 | Santander, Colombia | ||
2020-06-21 | Colombia | Santander | 462 | 10 | 99 | 353 | 6.6437 | -73.6536 | 2020-06-22 04:33:20 | Santander, Colombia | ||
2020-06-22 | Colombia | Santander | 490 | 11 | 106 | 373 | 6.6437 | -73.6536 | 2020-06-23 04:33:22 | Santander, Colombia | ||
2020-06-23 | Colombia | Santander | 499 | 12 | 122 | 365 | 6.6437 | -73.6536 | 2020-06-24 04:33:28 | Santander, Colombia | ||
2020-06-24 | Colombia | Santander | 499 | 12 | 122 | 365 | 6.6437 | -73.6536 | 2020-06-25 05:26:54 | Santander, Colombia | ||
2020-06-25 | Colombia | Santander | 505 | 12 | 134 | 359 | 6.6437 | -73.6536 | 2020-06-26 04:33:43 | Santander, Colombia | ||
2020-06-26 | Colombia | Santander | 534 | 13 | 139 | 382 | 6.6437 | -73.6536 | 2020-06-27 04:33:35 | Santander, Colombia | ||
2020-06-27 | Colombia | Santander | 562 | 13 | 157 | 392 | 6.6437 | -73.6536 | 2020-06-28 04:34:04 | Santander, Colombia | ||
2020-06-28 | Colombia | Santander | 646 | 14 | 168 | 464 | 6.6437 | -73.6536 | 2020-06-29 04:33:44 | Santander, Colombia | ||
2020-06-29 | Colombia | Santander | 646 | 14 | 168 | 464 | 6.6437 | -73.6536 | 2020-06-30 04:33:48 | Santander, Colombia | ||
2020-06-30 | Colombia | Santander | 690 | 14 | 189 | 487 | 6.6437 | -73.6536 | 2020-07-01 04:33:52 | Santander, Colombia | ||
2020-07-01 | Colombia | Santander | 713 | 14 | 199 | 500 | 6.6437 | -73.6536 | 2020-07-02 04:33:46 | Santander, Colombia | ||
2020-07-02 | Colombia | Santander | 757 | 15 | 204 | 538 | 6.6437 | -73.6536 | 2020-07-03 04:33:54 | Santander, Colombia | ||
2020-07-03 | Colombia | Santander | 812 | 15 | 211 | 586 | 6.6437 | -73.6536 | 2020-07-04 04:33:51 | Santander, Colombia | ||
2020-07-04 | Colombia | Santander | 846 | 15 | 216 | 615 | 6.6437 | -73.6536 | 2020-07-05 04:33:46 | Santander, Colombia | ||
2020-07-05 | Colombia | Santander | 945 | 20 | 227 | 698 | 6.6437 | -73.6536 | 2020-07-06 04:33:57 | Santander, Colombia | ||
2020-07-06 | Colombia | Santander | 994 | 21 | 241 | 732 | 6.6437 | -73.6536 | 2020-07-07 04:34:00 | Santander, Colombia | ||
2020-07-07 | Colombia | Santander | 1006 | 21 | 268 | 717 | 6.6437 | -73.6536 | 2020-07-08 05:33:48 | Santander, Colombia | ||
2020-07-08 | Colombia | Santander | 1064 | 21 | 284 | 759 | 6.6437 | -73.6536 | 2020-07-09 04:34:23 | Santander, Colombia | ||
2020-07-09 | Colombia | Santander | 1105 | 21 | 299 | 785 | 6.6437 | -73.6536 | 2020-07-10 04:34:24 | Santander, Colombia | ||
2020-07-10 | Colombia | Santander | 1159 | 24 | 325 | 810 | 6.6437 | -73.6536 | 2020-07-11 04:34:26 | Santander, Colombia | ||
2020-07-11 | Colombia | Santander | 1244 | 25 | 340 | 879 | 6.6437 | -73.6536 | 2020-07-12 04:34:30 | Santander, Colombia | ||
2020-07-12 | Colombia | Santander | 1261 | 25 | 351 | 885 | 6.6437 | -73.6536 | 2020-07-13 04:43:04 | Santander, Colombia | ||
2020-07-13 | Colombia | Santander | 1329 | 26 | 371 | 932 | 6.6437 | -73.6536 | 2020-07-14 04:34:46 | Santander, Colombia | ||
2020-07-14 | Colombia | Santander | 1362 | 30 | 389 | 943 | 6.6437 | -73.6536 | 2020-07-15 04:34:39 | Santander, Colombia | ||
2020-07-15 | Colombia | Santander | 1431 | 31 | 455 | 945 | 6.6437 | -73.6536 | 2020-07-16 04:44:59 | Santander, Colombia | ||
2020-07-16 | Colombia | Santander | 1529 | 32 | 482 | 1015 | 6.6437 | -73.6536 | 2020-07-17 04:34:50 | Santander, Colombia | ||
2020-07-17 | Colombia | Santander | 1783 | 34 | 592 | 1157 | 6.6437 | -73.6536 | 2020-07-18 04:34:45 | Santander, Colombia | ||
2020-07-18 | Colombia | Santander | 1863 | 39 | 625 | 1199 | 6.6437 | -73.6536 | 2020-07-19 04:34:58 | Santander, Colombia | ||
2020-07-19 | Colombia | Santander | 1922 | 43 | 663 | 1216 | 6.6437 | -73.6536 | 2020-07-20 05:34:40 | Santander, Colombia | ||
2020-07-20 | Colombia | Santander | 1998 | 48 | 682 | 1268 | 6.6437 | -73.6536 | 2020-07-21 04:38:46 | Santander, Colombia | ||
2020-07-21 | Colombia | Santander | 2046 | 53 | 725 | 1268 | 6.6437 | -73.6536 | 2020-07-22 04:34:42 | Santander, Colombia | ||
2020-07-22 | Colombia | Santander | 2134 | 54 | 752 | 1328 | 6.6437 | -73.6536 | 2020-07-23 05:15:04 | Santander, Colombia | ||
2020-07-23 | Colombia | Santander | 2254 | 58 | 801 | 1395 | 6.6437 | -73.6536 | 2020-07-24 05:30:40 | Santander, Colombia | ||
2020-07-24 | Colombia | Santander | 2403 | 59 | 861 | 1483 | 6.6437 | -73.6536 | 2020-07-25 04:47:39 | Santander, Colombia | ||
2020-07-26 | Colombia | Santander | 2564 | 64 | 901 | 1599 | 6.6437 | -73.6536 | 2020-07-27 04:35:02 | Santander, Colombia | ||
2020-07-25 | Colombia | Santander | 2564 | 64 | 901 | 1599 | 6.6437 | -73.6536 | 2020-07-26 04:35:00 | Santander, Colombia | ||
2020-07-27 | Colombia | Santander | 2797 | 68 | 1058 | 1671 | 6.6437 | -73.6536 | 2020-07-28 04:58:43 | Santander, Colombia | ||
2020-07-28 | Colombia | Santander | 3050 | 69 | 1108 | 1873 | 6.6437 | -73.6536 | 2020-07-29 04:35:11 | Santander, Colombia | ||
2020-07-29 | Colombia | Santander | 3289 | 79 | 1169 | 2041 | 6.6437 | -73.6536 | 2020-07-30 04:35:05 | Santander, Colombia | ||
2020-07-30 | Colombia | Santander | 3482 | 84 | 1220 | 2178 | 6.6437 | -73.6536 | 2020-07-31 04:35:18 | Santander, Colombia | ||
2020-07-31 | Colombia | Santander | 3749 | 88 | 1283 | 2378 | 6.6437 | -73.6536 | 2020-08-01 04:36:27 | Santander, Colombia | ||
2020-08-01 | Colombia | Santander | 3993 | 110 | 1335 | 2548 | 6.6437 | -73.6536 | 2020-08-02 04:34:47 | Santander, Colombia | ||
2020-08-02 | Colombia | Santander | 4188 | 124 | 1399 | 2665 | 6.6437 | -73.6536 | 2020-08-03 04:34:35 | Santander, Colombia | ||
2020-08-03 | Colombia | Santander | 4434 | 137 | 1529 | 2768 | 6.6437 | -73.6536 | 2020-08-04 04:41:59 | Santander, Colombia | ||
2020-08-04 | Colombia | Santander | 4752 | 145 | 1682 | 2925 | 6.6437 | -73.6536 | 2020-08-05 04:34:43 | Santander, Colombia | ||
2020-08-05 | Colombia | Santander | 5087 | 163 | 1765 | 3159 | 6.6437 | -73.6536 | 2020-08-06 04:35:02 | Santander, Colombia | ||
2020-08-06 | Colombia | Santander | 5510 | 185 | 1831 | 3494 | 6.6437 | -73.6536 | 2020-08-07 04:35:11 | Santander, Colombia | ||
2020-08-07 | Colombia | Santander | 5942 | 200 | 1916 | 3826 | 6.6437 | -73.6536 | 2020-08-08 04:34:53 | Santander, Colombia | ||
2020-08-08 | Colombia | Santander | 6346 | 222 | 2030 | 4094 | 6.6437 | -73.6536 | 2020-08-09 04:34:54 | Santander, Colombia | ||
2020-08-09 | Colombia | Santander | 6713 | 236 | 2187 | 4290 | 6.6437 | -73.6536 | 2020-08-10 04:34:55 | Santander, Colombia | ||
2020-08-10 | Colombia | Santander | 6958 | 266 | 2436 | 4256 | 6.6437 | -73.6536 | 2020-08-11 04:35:08 | Santander, Colombia | ||
2020-08-11 | Colombia | Santander | 7678 | 289 | 2563 | 4826 | 6.6437 | -73.6536 | 2020-08-12 04:27:29 | Santander, Colombia | ||
2020-08-12 | Colombia | Santander | 8060 | 304 | 2687 | 5069 | 6.6437 | -73.6536 | 2020-08-13 04:29:15 | Santander, Colombia | ||
2020-08-13 | Colombia | Santander | 8578 | 329 | 2812 | 5437 | 6.6437 | -73.6536 | 2020-08-14 04:51:19 | Santander, Colombia | ||
2020-08-14 | Colombia | Santander | 9239 | 352 | 3107 | 5780 | 6.6437 | -73.6536 | 2020-08-15 04:27:31 | Santander, Colombia | ||
2020-08-15 | Colombia | Santander | 9608 | 378 | 3417 | 5813 | 6.6437 | -73.6536 | 2020-08-16 04:27:42 | Santander, Colombia | ||
2020-08-16 | Colombia | Santander | 10018 | 397 | 3747 | 5874 | 6.6437 | -73.6536 | 2020-08-17 04:27:20 | Santander, Colombia | ||
2020-08-17 | Colombia | Santander | 10247 | 426 | 4190 | 5631 | 6.6437 | -73.6536 | 2020-08-18 04:27:56 | Santander, Colombia | ||
2020-08-18 | Colombia | Santander | 10702 | 437 | 4487 | 5778 | 6.6437 | -73.6536 | 2020-08-19 04:27:00 | Santander, Colombia | ||
2020-08-19 | Colombia | Santander | 11332 | 454 | 5024 | 5854 | 6.6437 | -73.6536 | 2020-08-20 04:27:43 | Santander, Colombia | ||
2020-08-20 | Colombia | Santander | 11855 | 470 | 5659 | 5726 | 6.6437 | -73.6536 | 2020-08-21 04:27:41 | Santander, Colombia | ||
2020-08-21 | Colombia | Santander | 12392 | 506 | 6122 | 5764 | 6.6437 | -73.6536 | 2020-08-22 04:27:49 | Santander, Colombia | ||
2020-08-22 | Colombia | Santander | 12392 | 506 | 6122 | 5764 | 6.6437 | -73.6536 | 2020-08-23 04:27:48 | Santander, Colombia | ||
2020-08-23 | Colombia | Santander | 13687 | 563 | 7053 | 6071 | 6.6437 | -73.6536 | 2020-08-24 04:27:56 | Santander, Colombia | ||
2020-08-24 | Colombia | Santander | 14235 | 587 | 7490 | 6158 | 6.6437 | -73.6536 | 2020-08-25 04:28:02 | Santander, Colombia | ||
2020-08-25 | Colombia | Santander | 14752 | 619 | 7857 | 6276 | 6.6437 | -73.6536 | 2020-08-26 04:28:11 | Santander, Colombia | ||
2020-08-26 | Colombia | Santander | 15424 | 643 | 8478 | 6303 | 6.6437 | -73.6536 | 2020-08-27 04:28:15 | Santander, Colombia | ||
2020-08-27 | Colombia | Santander | 16187 | 668 | 9189 | 6330 | 6.6437 | -73.6536 | 2020-08-28 04:28:11 | Santander, Colombia | ||
2020-08-28 | Colombia | Santander | 16812 | 689 | 9630 | 6493 | 6.6437 | -73.6536 | 2020-08-29 04:28:19 | Santander, Colombia | ||
2020-08-29 | Colombia | Santander | 17310 | 723 | 10038 | 6549 | 6.6437 | -73.6536 | 2020-08-30 04:28:22 | Santander, Colombia | ||
2020-08-30 | Colombia | Santander | 17773 | 752 | 10483 | 6538 | 6.6437 | -73.6536 | 2020-08-31 04:28:27 | Santander, Colombia | ||
2020-08-31 | Colombia | Santander | 18211 | 774 | 10981 | 6456 | 6.6437 | -73.6536 | 2020-09-01 04:28:31 | Santander, Colombia | ||
2020-09-01 | Colombia | Santander | 19088 | 785 | 11311 | 6992 | 6.6437 | -73.6536 | 2020-09-02 04:28:25 | Santander, Colombia | ||
2020-09-02 | Colombia | Santander | 19674 | 821 | 11710 | 7143 | 6.6437 | -73.6536 | 2020-09-03 04:28:22 | Santander, Colombia | ||
2020-09-03 | Colombia | Santander | 20358 | 844 | 12254 | 7260 | 6.6437 | -73.6536 | 2020-09-04 04:28:26 | Santander, Colombia | ||
2020-09-04 | Colombia | Santander | 20358 | 844 | 12254 | 7260 | 6.6437 | -73.6536 | 2020-09-05 04:28:19 | Santander, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;