johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "Magdalena" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462643 | 2462643 | 2021-09-14 | Colombia | Magdalena | 92963 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-15 03:22:37 | Magdalena, Colombia | |||
1385482 | 1385482 | 2021-09-13 | Colombia | Magdalena | 92892 | 3300 | 0 | 10.4113 | -74.4057 | 2021-09-14 04:21:41 | Magdalena, Colombia | |||
1884851 | 1884851 | 2021-09-12 | Colombia | Magdalena | 92868 | 3297 | 0 | 10.4113 | -74.4057 | 2021-09-13 04:21:15 | Magdalena, Colombia | |||
3805754 | 3805754 | 2021-09-11 | Colombia | Magdalena | 92799 | 3296 | 0 | 10.4113 | -74.4057 | 2021-09-12 04:21:13 | Magdalena, Colombia | |||
3448694 | 3448694 | 2021-09-10 | Colombia | Magdalena | 92766 | 3295 | 0 | 10.4113 | -74.4057 | 2021-09-11 04:21:30 | Magdalena, Colombia | |||
1262640 | 1262640 | 2021-09-09 | Colombia | Magdalena | 92697 | 3293 | 0 | 10.4113 | -74.4057 | 2021-09-10 04:21:20 | Magdalena, Colombia | |||
2279010 | 2279010 | 2021-09-08 | Colombia | Magdalena | 92633 | 3291 | 0 | 10.4113 | -74.4057 | 2021-09-09 04:21:27 | Magdalena, Colombia | |||
641789 | 641789 | 2021-09-07 | Colombia | Magdalena | 92541 | 3290 | 0 | 10.4113 | -74.4057 | 2021-09-08 04:21:31 | Magdalena, Colombia | |||
3193852 | 3193852 | 2021-09-06 | Colombia | Magdalena | 92496 | 3289 | 0 | 10.4113 | -74.4057 | 2021-09-07 04:21:35 | Magdalena, Colombia | |||
3280720 | 3280720 | 2021-09-05 | Colombia | Magdalena | 92449 | 3288 | 0 | 10.4113 | -74.4057 | 2021-09-06 04:21:22 | Magdalena, Colombia | |||
249134 | 249134 | 2021-09-04 | Colombia | Magdalena | 92351 | 3286 | 0 | 10.4113 | -74.4057 | 2021-09-05 04:21:33 | Magdalena, Colombia | |||
3974415 | 3974415 | 2021-09-03 | Colombia | Magdalena | 92265 | 3286 | 0 | 10.4113 | -74.4057 | 2021-09-04 04:21:28 | Magdalena, Colombia | |||
177877 | 177877 | 2021-09-02 | Colombia | Magdalena | 92203 | 3286 | 0 | 10.4113 | -74.4057 | 2021-09-03 04:21:20 | Magdalena, Colombia | |||
66912 | 66912 | 2021-09-01 | Colombia | Magdalena | 92123 | 3281 | 0 | 10.4113 | -74.4057 | 2021-09-02 04:21:15 | Magdalena, Colombia | |||
2067754 | 2067754 | 2021-08-31 | Colombia | Magdalena | 92047 | 3280 | 0 | 10.4113 | -74.4057 | 2021-09-01 04:21:38 | Magdalena, Colombia | |||
1775208 | 1775208 | 2021-08-30 | Colombia | Magdalena | 91982 | 3280 | 0 | 10.4113 | -74.4057 | 2021-08-31 04:21:46 | Magdalena, Colombia | |||
3891782 | 3891782 | 2021-08-29 | Colombia | Magdalena | 91900 | 3279 | 0 | 10.4113 | -74.4057 | 2021-08-30 04:21:23 | Magdalena, Colombia | |||
2792885 | 2792885 | 2021-08-28 | Colombia | Magdalena | 91826 | 3278 | 0 | 10.4113 | -74.4057 | 2021-08-29 04:21:14 | Magdalena, Colombia | |||
2923044 | 2923044 | 2021-08-27 | Colombia | Magdalena | 91737 | 3277 | 0 | 10.4113 | -74.4057 | 2021-08-28 04:21:28 | Magdalena, Colombia | |||
1596058 | 1596058 | 2021-08-26 | Colombia | Magdalena | 91686 | 3275 | 0 | 10.4113 | -74.4057 | 2021-08-27 04:21:37 | Magdalena, Colombia | |||
32267 | 32267 | 2021-08-25 | Colombia | Magdalena | 91581 | 3273 | 0 | 10.4113 | -74.4057 | 2021-08-26 04:21:28 | Magdalena, Colombia | |||
3105306 | 3105306 | 2021-08-24 | Colombia | Magdalena | 91581 | 3269 | 0 | 10.4113 | -74.4057 | 2021-08-25 04:21:41 | Magdalena, Colombia | |||
3165477 | 3165477 | 2021-08-23 | Colombia | Magdalena | 91424 | 3268 | 0 | 10.4113 | -74.4057 | 2021-08-24 04:21:19 | Magdalena, Colombia | |||
2175404 | 2175404 | 2021-08-22 | Colombia | Magdalena | 91251 | 3264 | 0 | 10.4113 | -74.4057 | 2021-08-23 04:21:27 | Magdalena, Colombia | |||
3555500 | 3555500 | 2021-08-21 | Colombia | Magdalena | 91120 | 3258 | 0 | 10.4113 | -74.4057 | 2021-08-22 04:21:29 | Magdalena, Colombia | |||
1853842 | 1853842 | 2021-08-20 | Colombia | Magdalena | 91057 | 3258 | 0 | 10.4113 | -74.4057 | 2021-08-21 04:21:38 | Magdalena, Colombia | |||
511549 | 511549 | 2021-08-19 | Colombia | Magdalena | 90924 | 3256 | 0 | 10.4113 | -74.4057 | 2021-08-20 04:21:33 | Magdalena, Colombia | |||
2518028 | 2518028 | 2021-08-18 | Colombia | Magdalena | 90765 | 3252 | 0 | 10.4113 | -74.4057 | 2021-08-19 04:21:15 | Magdalena, Colombia | |||
245120 | 245120 | 2021-08-17 | Colombia | Magdalena | 90613 | 3249 | 0 | 10.4113 | -74.4057 | 2021-08-18 04:21:35 | Magdalena, Colombia | |||
1604083 | 1604083 | 2021-08-16 | Colombia | Magdalena | 90572 | 3246 | 0 | 10.4113 | -74.4057 | 2021-08-17 04:21:49 | Magdalena, Colombia | |||
103177 | 103177 | 2021-08-15 | Colombia | Magdalena | 90477 | 3244 | 0 | 10.4113 | -74.4057 | 2021-08-16 04:21:31 | Magdalena, Colombia | |||
507535 | 507535 | 2021-08-14 | Colombia | Magdalena | 90477 | 3241 | 0 | 10.4113 | -74.4057 | 2021-08-15 04:21:41 | Magdalena, Colombia | |||
1483407 | 1483407 | 2021-08-13 | Colombia | Magdalena | 90332 | 3235 | 0 | 10.4113 | -74.4057 | 2021-08-14 04:21:25 | Magdalena, Colombia | |||
2899537 | 2899537 | 2021-08-12 | Colombia | Magdalena | 90225 | 3233 | 0 | 10.4113 | -74.4057 | 2021-08-13 04:21:24 | Magdalena, Colombia | |||
1342141 | 1342141 | 2021-08-11 | Colombia | Magdalena | 90101 | 3232 | 0 | 10.4113 | -74.4057 | 2021-08-12 04:21:25 | Magdalena, Colombia | |||
2351288 | 2351288 | 2021-08-10 | Colombia | Magdalena | 90004 | 3227 | 0 | 10.4113 | -74.4057 | 2021-08-11 04:21:58 | Magdalena, Colombia | |||
649817 | 649817 | 2021-08-09 | Colombia | Magdalena | 89879 | 3223 | 0 | 10.4113 | -74.4057 | 2021-08-10 04:21:27 | Magdalena, Colombia | |||
589479 | 589479 | 2021-08-08 | Colombia | Magdalena | 89772 | 3221 | 0 | 10.4113 | -74.4057 | 2021-08-09 04:21:24 | Magdalena, Colombia | |||
2203491 | 2203491 | 2021-08-07 | Colombia | Magdalena | 89756 | 3219 | 0 | 10.4113 | -74.4057 | 2021-08-08 04:21:33 | Magdalena, Colombia | |||
1117441 | 1117441 | 2021-08-06 | Colombia | Magdalena | 89576 | 3212 | 0 | 10.4113 | -74.4057 | 2021-08-07 04:21:30 | Magdalena, Colombia | |||
1956378 | 1956378 | 2021-08-05 | Colombia | Magdalena | 89132 | 3205 | 0 | 10.4113 | -74.4057 | 2021-08-06 04:21:18 | Magdalena, Colombia | |||
331757 | 331757 | 2021-08-04 | Colombia | Magdalena | 89055 | 3198 | 84764 | 1093 | 10.4113 | -74.4057 | 2021-08-05 04:21:51 | Magdalena, Colombia | ||
3468028 | 3468028 | 2021-08-03 | Colombia | Magdalena | 88889 | 3195 | 84597 | 1097 | 10.4113 | -74.4057 | 2021-08-04 04:21:25 | Magdalena, Colombia | ||
3683302 | 3683302 | 2021-08-02 | Colombia | Magdalena | 88738 | 3193 | 84528 | 1017 | 10.4113 | -74.4057 | 2021-08-03 04:21:39 | Magdalena, Colombia | ||
3015201 | 3015201 | 2021-08-01 | Colombia | Magdalena | 88659 | 3192 | 84395 | 1072 | 10.4113 | -74.4057 | 2021-08-02 04:21:36 | Magdalena, Colombia | ||
3903824 | 3903824 | 2021-07-31 | Colombia | Magdalena | 88514 | 3183 | 84217 | 1114 | 10.4113 | -74.4057 | 2021-08-01 04:21:50 | Magdalena, Colombia | ||
3296029 | 3296029 | 2021-07-30 | Colombia | Magdalena | 88313 | 3180 | 84124 | 1009 | 10.4113 | -74.4057 | 2021-07-31 04:21:35 | Magdalena, Colombia | ||
3385240 | 3385240 | 2021-07-29 | Colombia | Magdalena | 88201 | 3175 | 83944 | 1082 | 10.4113 | -74.4057 | 2021-07-30 04:21:34 | Magdalena, Colombia | ||
408145 | 408145 | 2021-07-28 | Colombia | Magdalena | 88039 | 3166 | 83663 | 1210 | 10.4113 | -74.4057 | 2021-07-29 04:21:33 | Magdalena, Colombia | ||
1306006 | 1306006 | 2021-07-27 | Colombia | Magdalena | 87844 | 3162 | 83283 | 1399 | 10.4113 | -74.4057 | 2021-07-28 04:21:39 | Magdalena, Colombia | ||
3218149 | 3218149 | 2021-07-26 | Colombia | Magdalena | 87629 | 3155 | 82997 | 1477 | 10.4113 | -74.4057 | 2021-07-27 04:21:18 | Magdalena, Colombia | ||
1378358 | 1378358 | 2021-07-25 | Colombia | Magdalena | 87457 | 3147 | 82794 | 1516 | 10.4113 | -74.4057 | 2021-07-26 04:21:28 | Magdalena, Colombia | ||
1330098 | 1330098 | 2021-07-24 | Colombia | Magdalena | 87269 | 3142 | 82573 | 1554 | 10.4113 | -74.4057 | 2021-07-25 04:22:12 | Magdalena, Colombia | ||
3137402 | 3137402 | 2021-07-23 | Colombia | Magdalena | 86877 | 3129 | 82072 | 1676 | 10.4113 | -74.4057 | 2021-07-24 00:21:36 | Magdalena, Colombia | ||
3476162 | 3476162 | 2021-07-22 | Colombia | Magdalena | 86877 | 3129 | 82072 | 1676 | 10.4113 | -74.4057 | 2021-07-23 04:21:29 | Magdalena, Colombia | ||
3331381 | 3331381 | 2021-07-21 | Colombia | Magdalena | 86650 | 3123 | 81861 | 1666 | 10.4113 | -74.4057 | 2021-07-22 04:21:19 | Magdalena, Colombia | ||
2371362 | 2371362 | 2021-07-20 | Colombia | Magdalena | 85581 | 3117 | 81640 | 824 | 10.4113 | -74.4057 | 2021-07-21 04:21:40 | Magdalena, Colombia | ||
483441 | 483441 | 2021-07-19 | Colombia | Magdalena | 85581 | 3111 | 81241 | 1229 | 10.4113 | -74.4057 | 2021-07-20 04:21:48 | Magdalena, Colombia | ||
2673664 | 2673664 | 2021-07-18 | Colombia | Magdalena | 85581 | 3098 | 80988 | 1495 | 10.4113 | -74.4057 | 2021-07-19 04:21:24 | Magdalena, Colombia | ||
3705976 | 3705976 | 2021-07-17 | Colombia | Magdalena | 85581 | 3088 | 80923 | 1570 | 10.4113 | -74.4057 | 2021-07-18 04:22:07 | Magdalena, Colombia | ||
2947207 | 2947207 | 2021-07-16 | Colombia | Magdalena | 85402 | 3077 | 80740 | 1585 | 10.4113 | -74.4057 | 2021-07-17 04:22:22 | Magdalena, Colombia | ||
295863 | 295863 | 2021-07-15 | Colombia | Magdalena | 85123 | 3077 | 80497 | 1549 | 10.4113 | -74.4057 | 2021-07-16 04:21:22 | Magdalena, Colombia | ||
3631808 | 3631808 | 2021-07-14 | Colombia | Magdalena | 84964 | 3070 | 80242 | 1652 | 10.4113 | -74.4057 | 2021-07-15 04:21:48 | Magdalena, Colombia | ||
578683 | 578683 | 2021-07-13 | Colombia | Magdalena | 84794 | 3065 | 79895 | 1834 | 10.4113 | -74.4057 | 2021-07-14 04:21:35 | Magdalena, Colombia | ||
3740932 | 3740932 | 2021-07-12 | Colombia | Magdalena | 83996 | 3057 | 79230 | 1709 | 10.4113 | -74.4057 | 2021-07-13 04:21:18 | Magdalena, Colombia | ||
3659445 | 3659445 | 2021-07-11 | Colombia | Magdalena | 84003 | 3047 | 78451 | 2505 | 10.4113 | -74.4057 | 2021-07-12 04:21:34 | Magdalena, Colombia | ||
625729 | 625729 | 2021-07-10 | Colombia | Magdalena | 83796 | 3047 | 78451 | 2298 | 10.4113 | -74.4057 | 2021-07-11 04:21:43 | Magdalena, Colombia | ||
829448 | 829448 | 2021-07-09 | Colombia | Magdalena | 83474 | 3047 | 78038 | 2389 | 10.4113 | -74.4057 | 2021-07-10 04:21:25 | Magdalena, Colombia | ||
778212 | 778212 | 2021-07-08 | Colombia | Magdalena | 83162 | 3041 | 78038 | 2083 | 10.4113 | -74.4057 | 2021-07-09 04:21:21 | Magdalena, Colombia | ||
1440434 | 1440434 | 2021-07-07 | Colombia | Magdalena | 82930 | 3034 | 77726 | 2170 | 10.4113 | -74.4057 | 2021-07-08 04:21:26 | Magdalena, Colombia | ||
2693539 | 2693539 | 2021-07-06 | Colombia | Magdalena | 82734 | 3033 | 77550 | 2151 | 10.4113 | -74.4057 | 2021-07-07 04:21:20 | Magdalena, Colombia | ||
1932288 | 1932288 | 2021-07-05 | Colombia | Magdalena | 82309 | 3029 | 76959 | 2321 | 10.4113 | -74.4057 | 2021-07-06 04:21:32 | Magdalena, Colombia | ||
1165019 | 1165019 | 2021-07-04 | Colombia | Magdalena | 81839 | 3018 | 76565 | 2256 | 10.4113 | -74.4057 | 2021-07-05 04:21:28 | Magdalena, Colombia | ||
1495453 | 1495453 | 2021-07-03 | Colombia | Magdalena | 81294 | 3014 | 76299 | 1981 | 10.4113 | -74.4057 | 2021-07-04 04:21:38 | Magdalena, Colombia | ||
2071768 | 2071768 | 2021-07-02 | Colombia | Magdalena | 81008 | 3006 | 76081 | 1921 | 10.4113 | -74.4057 | 2021-07-03 04:21:37 | Magdalena, Colombia | ||
2764784 | 2764784 | 2021-07-01 | Colombia | Magdalena | 80832 | 2991 | 75762 | 2079 | 10.4113 | -74.4057 | 2021-07-02 04:21:47 | Magdalena, Colombia | ||
1892992 | 1892992 | 2021-06-30 | Colombia | Magdalena | 80576 | 2979 | 75511 | 2086 | 10.4113 | -74.4057 | 2021-07-01 04:21:19 | Magdalena, Colombia | ||
400115 | 400115 | 2021-06-29 | Colombia | Magdalena | 80335 | 2971 | 75216 | 2148 | 10.4113 | -74.4057 | 2021-06-30 04:21:41 | Magdalena, Colombia | ||
3125358 | 3125358 | 2021-06-28 | Colombia | Magdalena | 79932 | 2952 | 74964 | 2016 | 10.4113 | -74.4057 | 2021-06-29 04:21:28 | Magdalena, Colombia | ||
2589853 | 2589853 | 2021-06-27 | Colombia | Magdalena | 79750 | 2941 | 74276 | 2533 | 10.4113 | -74.4057 | 2021-06-28 04:21:29 | Magdalena, Colombia | ||
3958357 | 3958357 | 2021-06-26 | Colombia | Magdalena | 79032 | 2935 | 73832 | 2265 | 10.4113 | -74.4057 | 2021-06-27 04:21:39 | Magdalena, Colombia | ||
1712176 | 1712176 | 2021-06-25 | Colombia | Magdalena | 78468 | 2904 | 73515 | 2049 | 10.4113 | -74.4057 | 2021-06-26 04:21:43 | Magdalena, Colombia | ||
2295301 | 2295301 | 2021-06-24 | Colombia | Magdalena | 77987 | 2897 | 73330 | 1760 | 10.4113 | -74.4057 | 2021-06-25 04:21:33 | Magdalena, Colombia | ||
2422741 | 2422741 | 2021-06-23 | Colombia | Magdalena | 77848 | 2891 | 72960 | 1997 | 10.4113 | -74.4057 | 2021-06-24 04:21:55 | Magdalena, Colombia | ||
562818 | 562818 | 2021-06-22 | Colombia | Magdalena | 77475 | 2883 | 72612 | 1980 | 10.4113 | -74.4057 | 2021-06-23 04:21:46 | Magdalena, Colombia | ||
3358520 | 3358520 | 2021-06-21 | Colombia | Magdalena | 77125 | 2877 | 72249 | 1999 | 10.4113 | -74.4057 | 2021-06-22 04:21:34 | Magdalena, Colombia | ||
2884219 | 2884219 | 2021-06-20 | Colombia | Magdalena | 76762 | 2860 | 72112 | 1790 | 10.4113 | -74.4057 | 2021-06-21 04:21:41 | Magdalena, Colombia | ||
107302 | 107302 | 2021-06-19 | Colombia | Magdalena | 76432 | 2856 | 72026 | 1550 | 10.4113 | -74.4057 | 2021-06-20 04:21:48 | Magdalena, Colombia | ||
1125445 | 1125445 | 2021-06-18 | Colombia | Magdalena | 76303 | 2845 | 71832 | 1626 | 10.4113 | -74.4057 | 2021-06-19 04:22:33 | Magdalena, Colombia | ||
2911023 | 2911023 | 2021-06-17 | Colombia | Magdalena | 76028 | 2841 | 71507 | 1680 | 10.4113 | -74.4057 | 2021-06-18 04:22:16 | Magdalena, Colombia | ||
3030141 | 3030141 | 2021-06-16 | Colombia | Magdalena | 75460 | 2824 | 70874 | 1762 | 10.4113 | -74.4057 | 2021-06-17 04:22:36 | Magdalena, Colombia | ||
2339247 | 2339247 | 2021-06-15 | Colombia | Magdalena | 74450 | 2802 | 70566 | 1082 | 10.4113 | -74.4057 | 2021-06-16 04:22:32 | Magdalena, Colombia | ||
1563943 | 1563943 | 2021-06-14 | Colombia | Magdalena | 74450 | 2802 | 70566 | 1082 | 10.4113 | -74.4057 | 2021-06-15 04:22:22 | Magdalena, Colombia | ||
3381226 | 3381226 | 2021-06-13 | Colombia | Magdalena | 74450 | 2800 | 70179 | 1471 | 10.4113 | -74.4057 | 2021-06-14 04:22:46 | Magdalena, Colombia | ||
1736360 | 1736360 | 2021-06-12 | Colombia | Magdalena | 74450 | 2800 | 69994 | 1656 | 10.4113 | -74.4057 | 2021-06-13 04:22:44 | Magdalena, Colombia | ||
3970401 | 3970401 | 2021-06-11 | Colombia | Magdalena | 74117 | 2793 | 69706 | 1618 | 10.4113 | -74.4057 | 2021-06-12 04:22:22 | Magdalena, Colombia | ||
2716823 | 2716823 | 2021-06-10 | Colombia | Magdalena | 73794 | 2787 | 69329 | 1678 | 10.4113 | -74.4057 | 2021-06-11 04:23:20 | Magdalena, Colombia | ||
522708 | 522708 | 2021-06-09 | Colombia | Magdalena | 73145 | 2741 | 69117 | 1287 | 10.4113 | -74.4057 | 2021-06-10 04:23:17 | Magdalena, Colombia | ||
3472148 | 3472148 | 2021-06-08 | Colombia | Magdalena | 73145 | 2741 | 68766 | 1638 | 10.4113 | -74.4057 | 2021-06-09 04:23:31 | Magdalena, Colombia | ||
3145432 | 3145432 | 2021-06-07 | Colombia | Magdalena | 73145 | 2741 | 68766 | 1638 | 10.4113 | -74.4057 | 2021-06-08 04:22:35 | Magdalena, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);