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 deaths
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-05 | Colombia | Santander | 20822 | 865 | 13375 | 6582 | 6.6437 | -73.6536 | 2020-09-06 04:28:33 | Santander, Colombia | ||
2020-09-07 | Colombia | Santander | 21755 | 923 | 14377 | 6455 | 6.6437 | -73.6536 | 2020-09-08 04:28:25 | Santander, Colombia | ||
2020-09-06 | Colombia | Santander | 21755 | 923 | 14377 | 6455 | 6.6437 | -73.6536 | 2020-09-07 04:28:30 | Santander, Colombia | ||
2020-09-08 | Colombia | Santander | 21962 | 947 | 15274 | 5741 | 6.6437 | -73.6536 | 2020-09-09 04:28:48 | Santander, Colombia | ||
2020-09-09 | Colombia | Santander | 22860 | 987 | 16554 | 5319 | 6.6437 | -73.6536 | 2020-09-10 04:29:01 | Santander, Colombia | ||
2020-09-10 | Colombia | Santander | 23335 | 1005 | 17731 | 4599 | 6.6437 | -73.6536 | 2020-09-11 04:46:23 | Santander, Colombia | ||
2020-09-11 | Colombia | Santander | 23769 | 1023 | 18124 | 4622 | 6.6437 | -73.6536 | 2020-09-12 04:25:05 | Santander, Colombia | ||
2020-09-12 | Colombia | Santander | 24215 | 1047 | 18470 | 4698 | 6.6437 | -73.6536 | 2020-09-13 04:30:52 | Santander, Colombia | ||
2020-09-13 | Colombia | Santander | 24727 | 1058 | 18943 | 4726 | 6.6437 | -73.6536 | 2020-09-14 04:26:00 | Santander, Colombia | ||
2020-09-14 | Colombia | Santander | 24976 | 1071 | 19403 | 4502 | 6.6437 | -73.6536 | 2020-09-15 03:22:50 | Santander, Colombia | ||
2020-09-15 | Colombia | Santander | 25441 | 1089 | 19454 | 4898 | 6.6437 | -73.6536 | 2020-09-16 04:22:53 | Santander, Colombia | ||
2020-09-16 | Colombia | Santander | 25854 | 1105 | 19579 | 5170 | 6.6437 | -73.6536 | 2020-09-17 04:22:00 | Santander, Colombia | ||
2020-09-17 | Colombia | Santander | 26296 | 1118 | 19877 | 5301 | 6.6437 | -73.6536 | 2020-09-18 05:05:00 | Santander, Colombia | ||
2020-09-18 | Colombia | Santander | 26612 | 1118 | 19877 | 5617 | 6.6437 | -73.6536 | 2020-09-19 04:22:00 | Santander, Colombia | ||
2020-09-19 | Colombia | Santander | 27012 | 1158 | 20338 | 5516 | 6.6437 | -73.6536 | 2020-09-20 04:22:00 | Santander, Colombia | ||
2020-09-20 | Colombia | Santander | 27463 | 1172 | 20653 | 5638 | 6.6437 | -73.6536 | 2020-09-21 04:23:00 | Santander, Colombia | ||
2020-09-21 | Colombia | Santander | 27884 | 1186 | 21035 | 5663 | 6.6437 | -73.6536 | 2020-09-22 04:23:00 | Santander, Colombia | ||
2020-09-22 | Colombia | Santander | 28309 | 1186 | 21035 | 6088 | 6.6437 | -73.6536 | 2020-09-23 04:23:00 | Santander, Colombia | ||
2020-09-23 | Colombia | Santander | 28751 | 1209 | 22261 | 5281 | 6.6437 | -73.6536 | 2020-09-24 04:23:00 | Santander, Colombia | ||
2020-09-24 | Colombia | Santander | 29109 | 1223 | 22733 | 5153 | 6.6437 | -73.6536 | 2020-09-25 04:23:00 | Santander, Colombia | ||
2020-09-25 | Colombia | Santander | 29468 | 1236 | 23267 | 4965 | 6.6437 | -73.6536 | 2020-09-26 04:23:00 | Santander, Colombia | ||
2020-09-26 | Colombia | Santander | 29952 | 1249 | 24084 | 4619 | 6.6437 | -73.6536 | 2020-09-27 04:23:00 | Santander, Colombia | ||
2020-09-27 | Colombia | Santander | 30413 | 1271 | 24722 | 4420 | 6.6437 | -73.6536 | 2020-09-28 04:23:00 | Santander, Colombia | ||
2020-09-28 | Colombia | Santander | 30549 | 1288 | 25479 | 3782 | 6.6437 | -73.6536 | 2020-09-29 04:23:42 | Santander, Colombia | ||
2020-09-29 | Colombia | Santander | 30976 | 1305 | 26309 | 3362 | 6.6437 | -73.6536 | 2020-09-30 04:23:33 | Santander, Colombia | ||
2020-09-30 | Colombia | Santander | 31278 | 1316 | 26919 | 3043 | 6.6437 | -73.6536 | 2020-10-01 04:23:42 | Santander, Colombia | ||
2020-10-01 | Colombia | Santander | 31559 | 1324 | 27496 | 2739 | 6.6437 | -73.6536 | 2020-10-02 04:23:51 | Santander, Colombia | ||
2020-10-02 | Colombia | Santander | 31776 | 1341 | 27608 | 2827 | 6.6437 | -73.6536 | 2020-10-03 04:23:40 | Santander, Colombia | ||
2020-10-03 | Colombia | Santander | 32298 | 1351 | 27831 | 3116 | 6.6437 | -73.6536 | 2020-10-04 04:23:44 | Santander, Colombia | ||
2020-10-04 | Colombia | Santander | 32586 | 1359 | 28076 | 3151 | 6.6437 | -73.6536 | 2020-10-05 04:23:33 | Santander, Colombia | ||
2020-10-05 | Colombia | Santander | 32808 | 1372 | 28075 | 3361 | 6.6437 | -73.6536 | 2020-10-06 04:23:33 | Santander, Colombia | ||
2020-10-06 | Colombia | Santander | 33143 | 1393 | 28116 | 3634 | 6.6437 | -73.6536 | 2020-10-07 04:23:40 | Santander, Colombia | ||
2020-10-07 | Colombia | Santander | 33510 | 1404 | 28166 | 3940 | 6.6437 | -73.6536 | 2020-10-08 04:23:56 | Santander, Colombia | ||
2020-10-08 | Colombia | Santander | 33870 | 1404 | 28166 | 4300 | 6.6437 | -73.6536 | 2020-10-09 04:23:59 | Santander, Colombia | ||
2020-10-09 | Colombia | Santander | 34574 | 1412 | 28312 | 4850 | 6.6437 | -73.6536 | 2020-10-10 04:23:57 | Santander, Colombia | ||
2020-10-10 | Colombia | Santander | 34859 | 1443 | 28510 | 4906 | 6.6437 | -73.6536 | 2020-10-11 04:23:46 | Santander, Colombia | ||
2020-10-11 | Colombia | Santander | 35213 | 1443 | 28510 | 5260 | 6.6437 | -73.6536 | 2020-10-12 04:23:45 | Santander, Colombia | ||
2020-10-12 | Colombia | Santander | 35495 | 1462 | 29360 | 4673 | 6.6437 | -73.6536 | 2020-10-13 04:24:02 | Santander, Colombia | ||
2020-10-13 | Colombia | Santander | 35771 | 1474 | 29953 | 4344 | 6.6437 | -73.6536 | 2020-10-14 04:24:05 | Santander, Colombia | ||
2020-10-14 | Colombia | Santander | 36231 | 1488 | 30311 | 4432 | 6.6437 | -73.6536 | 2020-10-15 04:24:28 | Santander, Colombia | ||
2020-10-15 | Colombia | Santander | 36441 | 1501 | 30697 | 4243 | 6.6437 | -73.6536 | 2020-10-16 04:24:01 | Santander, Colombia | ||
2020-10-16 | Colombia | Santander | 36902 | 1501 | 30697 | 4704 | 6.6437 | -73.6536 | 2020-10-17 04:24:12 | Santander, Colombia | ||
2020-10-17 | Colombia | Santander | 37190 | 1518 | 31735 | 3937 | 6.6437 | -73.6536 | 2020-10-18 04:24:25 | Santander, Colombia | ||
2020-10-18 | Colombia | Santander | 37439 | 1527 | 32343 | 3569 | 6.6437 | -73.6536 | 2020-10-19 04:24:16 | Santander, Colombia | ||
2020-10-19 | Colombia | Santander | 37799 | 1541 | 32807 | 3451 | 6.6437 | -73.6536 | 2020-10-20 04:24:22 | Santander, Colombia | ||
2020-10-20 | Colombia | Santander | 38175 | 1554 | 33327 | 3294 | 6.6437 | -73.6536 | 2020-10-21 04:24:14 | Santander, Colombia | ||
2020-10-21 | Colombia | Santander | 38379 | 1569 | 33713 | 3097 | 6.6437 | -73.6536 | 2020-10-22 04:24:27 | Santander, Colombia | ||
2020-10-22 | Colombia | Santander | 38814 | 1580 | 34187 | 3047 | 6.6437 | -73.6536 | 2020-10-23 04:24:46 | Santander, Colombia | ||
2020-10-23 | Colombia | Santander | 39224 | 1593 | 34586 | 3045 | 6.6437 | -73.6536 | 2020-10-24 04:24:46 | Santander, Colombia | ||
2020-10-24 | Colombia | Santander | 39535 | 1606 | 34965 | 2964 | 6.6437 | -73.6536 | 2020-10-25 04:24:36 | Santander, Colombia | ||
2020-10-25 | Colombia | Santander | 39825 | 1614 | 35212 | 2999 | 6.6437 | -73.6536 | 2020-10-26 04:25:02 | Santander, Colombia | ||
2020-10-26 | Colombia | Santander | 40238 | 1622 | 35383 | 3233 | 6.6437 | -73.6536 | 2020-10-27 04:24:45 | Santander, Colombia | ||
2020-10-27 | Colombia | Santander | 40604 | 1644 | 35656 | 3304 | 6.6437 | -73.6536 | 2020-10-28 04:24:39 | Santander, Colombia | ||
2020-10-29 | Colombia | Santander | 41504 | 1658 | 36071 | 3775 | 6.6437 | -73.6536 | 2020-10-30 04:24:49 | Santander, Colombia | ||
2020-10-28 | Colombia | Santander | 41024 | 1658 | 36071 | 3295 | 6.6437 | -73.6536 | 2020-10-29 04:24:49 | Santander, Colombia | ||
2020-10-30 | Colombia | Santander | 41504 | 1658 | 36403 | 3443 | 6.6437 | -73.6536 | 2020-10-31 04:24:44 | Santander, Colombia | ||
2020-10-31 | Colombia | Santander | 42328 | 1693 | 37101 | 3534 | 6.6437 | -73.6536 | 2020-11-01 04:36:19 | Santander, Colombia | ||
2020-11-01 | Colombia | Santander | 42806 | 1700 | 37609 | 3497 | 6.6437 | -73.6536 | 2020-11-02 05:25:04 | Santander, Colombia | ||
2020-11-02 | Colombia | Santander | 85073 | 1710 | 37942 | 45421 | 6.6437 | -73.6536 | 2020-11-03 06:00:16 | Santander, Colombia | ||
2020-11-03 | Colombia | Santander | 43442 | 1717 | 38253 | 3472 | 6.6437 | -73.6536 | 2020-11-04 05:25:09 | Santander, Colombia | ||
2020-11-04 | Colombia | Santander | 43854 | 1730 | 38611 | 3513 | 6.6437 | -73.6536 | 2020-11-05 06:05:03 | Santander, Colombia | ||
2020-11-05 | Colombia | Santander | 44184 | 1742 | 38885 | 3557 | 6.6437 | -73.6536 | 2020-11-06 05:24:55 | Santander, Colombia | ||
2020-11-06 | Colombia | Santander | 44881 | 1756 | 39236 | 3889 | 6.6437 | -73.6536 | 2020-11-07 05:24:52 | Santander, Colombia | ||
2020-11-07 | Colombia | Santander | 45274 | 1765 | 39930 | 3579 | 6.6437 | -73.6536 | 2020-11-08 05:24:56 | Santander, Colombia | ||
2020-11-08 | Colombia | Santander | 45561 | 1778 | 40356 | 3427 | 6.6437 | -73.6536 | 2020-11-09 05:25:45 | Santander, Colombia | ||
2020-11-09 | Colombia | Santander | 45763 | 1792 | 40865 | 3106 | 6.6437 | -73.6536 | 2020-11-10 05:40:07 | Santander, Colombia | ||
2020-11-10 | Colombia | Santander | 46044 | 1804 | 41145 | 3095 | 6.6437 | -73.6536 | 2020-11-11 05:25:30 | Santander, Colombia | ||
2020-11-11 | Colombia | Santander | 46482 | 1809 | 41508 | 3165 | 6.6437 | -73.6536 | 2020-11-12 05:25:55 | Santander, Colombia | ||
2020-11-12 | Colombia | Santander | 46810 | 1816 | 42000 | 2994 | 6.6437 | -73.6536 | 2020-11-13 05:25:30 | Santander, Colombia | ||
2020-11-13 | Colombia | Santander | 47347 | 1816 | 42000 | 3531 | 6.6437 | -73.6536 | 2020-11-14 05:25:37 | Santander, Colombia | ||
2020-11-14 | Colombia | Santander | 47655 | 1824 | 42307 | 3524 | 6.6437 | -73.6536 | 2020-11-15 05:26:53 | Santander, Colombia | ||
2020-11-15 | Colombia | Santander | 48009 | 1851 | 43006 | 3152 | 6.6437 | -73.6536 | 2020-11-16 05:25:57 | Santander, Colombia | ||
2020-11-16 | Colombia | Santander | 48342 | 1854 | 43349 | 3139 | 6.6437 | -73.6536 | 2020-11-17 05:25:54 | Santander, Colombia | ||
2020-11-17 | Colombia | Santander | 48616 | 1871 | 43643 | 3102 | 6.6437 | -73.6536 | 2020-11-18 05:40:31 | Santander, Colombia | ||
2020-11-18 | Colombia | Santander | 48871 | 1887 | 43948 | 3036 | 6.6437 | -73.6536 | 2020-11-19 05:25:23 | Santander, Colombia | ||
2020-11-19 | Colombia | Santander | 49204 | 1900 | 44318 | 2986 | 6.6437 | -73.6536 | 2020-11-20 05:26:28 | Santander, Colombia | ||
2020-11-20 | Colombia | Santander | 49505 | 1909 | 44617 | 2979 | 6.6437 | -73.6536 | 2020-11-21 05:25:51 | Santander, Colombia | ||
2020-11-21 | Colombia | Santander | 49806 | 1922 | 44869 | 3015 | 6.6437 | -73.6536 | 2020-11-22 05:25:45 | Santander, Colombia | ||
2020-11-22 | Colombia | Santander | 50131 | 1930 | 45153 | 3048 | 6.6437 | -73.6536 | 2020-11-23 05:25:26 | Santander, Colombia | ||
2020-11-23 | Colombia | Santander | 50419 | 1938 | 45537 | 2944 | 6.6437 | -73.6536 | 2020-11-24 05:27:31 | Santander, Colombia | ||
2020-11-24 | Colombia | Santander | 50587 | 1950 | 45733 | 2904 | 6.6437 | -73.6536 | 2020-11-25 05:27:20 | Santander, Colombia | ||
2020-11-25 | Colombia | Santander | 51000 | 1964 | 45987 | 3049 | 6.6437 | -73.6536 | 2020-11-26 05:27:44 | Santander, Colombia | ||
2020-11-26 | Colombia | Santander | 51502 | 1976 | 46279 | 3247 | 6.6437 | -73.6536 | 2020-11-27 05:26:53 | Santander, Colombia | ||
2020-11-27 | Colombia | Santander | 52029 | 1988 | 46657 | 3384 | 6.6437 | -73.6536 | 2020-11-28 05:25:50 | Santander, Colombia | ||
2020-11-28 | Colombia | Santander | 52455 | 1997 | 47048 | 3410 | 6.6437 | -73.6536 | 2020-11-29 05:25:55 | Santander, Colombia | ||
2020-11-29 | Colombia | Santander | 52896 | 2013 | 47455 | 3428 | 6.6437 | -73.6536 | 2020-11-30 05:26:13 | Santander, Colombia | ||
2020-11-30 | Colombia | Santander | 53314 | 2020 | 47749 | 3545 | 6.6437 | -73.6536 | 2020-12-01 05:26:18 | Santander, Colombia | ||
2020-12-01 | Colombia | Santander | 53660 | 2032 | 48041 | 3587 | 6.6437 | -73.6536 | 2020-12-02 05:27:41 | Santander, Colombia | ||
2020-12-02 | Colombia | Santander | 54160 | 2038 | 48412 | 3710 | 6.6437 | -73.6536 | 2020-12-03 05:28:22 | Santander, Colombia | ||
2020-12-03 | Colombia | Santander | 54535 | 2056 | 48885 | 3594 | 6.6437 | -73.6536 | 2020-12-04 05:27:27 | Santander, Colombia | ||
2020-12-04 | Colombia | Santander | 55034 | 2062 | 49282 | 3690 | 6.6437 | -73.6536 | 2020-12-05 05:27:36 | Santander, Colombia | ||
2020-12-05 | Colombia | Santander | 55434 | 2067 | 49845 | 3522 | 6.6437 | -73.6536 | 2020-12-06 05:26:18 | Santander, Colombia | ||
2020-12-06 | Colombia | Santander | 55815 | 2078 | 50139 | 3598 | 6.6437 | -73.6536 | 2020-12-07 05:26:14 | Santander, Colombia | ||
2020-12-07 | Colombia | Santander | 56061 | 2083 | 50506 | 3472 | 6.6437 | -73.6536 | 2020-12-08 05:27:42 | Santander, Colombia | ||
2020-12-08 | Colombia | Santander | 56279 | 2092 | 51046 | 3141 | 6.6437 | -73.6536 | 2020-12-09 05:28:01 | Santander, Colombia | ||
2020-12-09 | Colombia | Santander | 56785 | 2098 | 51323 | 3364 | 6.6437 | -73.6536 | 2020-12-10 05:26:19 | Santander, Colombia | ||
2020-12-10 | Colombia | Santander | 57176 | 2107 | 51793 | 3276 | 6.6437 | -73.6536 | 2020-12-11 05:26:59 | Santander, Colombia | ||
2020-12-11 | Colombia | Santander | 57559 | 2121 | 52143 | 3295 | 6.6437 | -73.6536 | 2020-12-12 05:26:19 | Santander, Colombia | ||
2020-12-12 | Colombia | Santander | 57940 | 2130 | 52404 | 3406 | 6.6437 | -73.6536 | 2020-12-13 05:27:20 | Santander, Colombia | ||
2020-12-13 | Colombia | Santander | 58307 | 2140 | 52532 | 3635 | 6.6437 | -73.6536 | 2020-12-14 05:26:27 | Santander, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;