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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1089926 | 1089926 | 2021-03-03 | Colombia | Magdalena | 34453 | 1309 | 31753 | 1391 | 10.4113 | -74.4057 | 2021-03-04 05:24:24 | Magdalena, Colombia | ||
3253998 | 3253998 | 2021-03-02 | Colombia | Magdalena | 34180 | 1299 | 31395 | 1486 | 10.4113 | -74.4057 | 2021-03-03 05:23:28 | Magdalena, Colombia | ||
998290 | 998290 | 2021-03-01 | Colombia | Magdalena | 33845 | 1295 | 31173 | 1377 | 10.4113 | -74.4057 | 2021-03-02 05:23:30 | Magdalena, Colombia | ||
2367348 | 2367348 | 2021-02-28 | Colombia | Magdalena | 33608 | 1291 | 31081 | 1236 | 10.4113 | -74.4057 | 2021-03-01 05:23:01 | Magdalena, Colombia | ||
3065850 | 3065850 | 2021-02-27 | Colombia | Magdalena | 33392 | 1285 | 31020 | 1087 | 10.4113 | -74.4057 | 2021-02-28 05:22:20 | Magdalena, Colombia | ||
2183434 | 2183434 | 2021-02-26 | Colombia | Magdalena | 33253 | 1277 | 30937 | 1039 | 10.4113 | -74.4057 | 2021-02-27 05:22:28 | Magdalena, Colombia | ||
1857856 | 1857856 | 2021-02-25 | Colombia | Magdalena | 33108 | 1274 | 30895 | 939 | 10.4113 | -74.4057 | 2021-02-26 05:22:40 | Magdalena, Colombia | ||
280034 | 280034 | 2021-02-24 | Colombia | Magdalena | 32968 | 1266 | 30817 | 885 | 10.4113 | -74.4057 | 2021-02-25 05:24:57 | Magdalena, Colombia | ||
1936302 | 1936302 | 2021-02-23 | Colombia | Magdalena | 32860 | 1260 | 30748 | 852 | 10.4113 | -74.4057 | 2021-02-24 05:29:16 | Magdalena, Colombia | ||
530557 | 530557 | 2021-02-22 | Colombia | Magdalena | 32752 | 1257 | 30677 | 818 | 10.4113 | -74.4057 | 2021-02-23 05:23:41 | Magdalena, Colombia | ||
181891 | 181891 | 2021-02-21 | Colombia | Magdalena | 32710 | 1251 | 30562 | 897 | 10.4113 | -74.4057 | 2021-02-22 05:24:21 | Magdalena, Colombia | ||
742165 | 742165 | 2021-02-20 | Colombia | Magdalena | 32576 | 1236 | 30373 | 967 | 10.4113 | -74.4057 | 2021-02-21 05:24:33 | Magdalena, Colombia | ||
471263 | 471263 | 2021-02-19 | Colombia | Magdalena | 32342 | 1236 | 30202 | 904 | 10.4113 | -74.4057 | 2021-02-20 05:22:51 | Magdalena, Colombia | ||
1152972 | 1152972 | 2021-02-18 | Colombia | Magdalena | 32160 | 1236 | 30100 | 824 | 10.4113 | -74.4057 | 2021-02-19 05:24:16 | Magdalena, Colombia | ||
3600892 | 3600892 | 2021-02-17 | Colombia | Magdalena | 32019 | 1234 | 30021 | 764 | 10.4113 | -74.4057 | 2021-02-18 05:22:58 | Magdalena, Colombia | ||
3050027 | 3050027 | 2021-02-16 | Colombia | Magdalena | 31932 | 1231 | 29941 | 760 | 10.4113 | -74.4057 | 2021-02-17 05:23:10 | Magdalena, Colombia | ||
1338126 | 1338126 | 2021-02-15 | Colombia | Magdalena | 31835 | 1226 | 29878 | 731 | 10.4113 | -74.4057 | 2021-02-16 05:24:38 | Magdalena, Colombia | ||
2283277 | 2283277 | 2021-02-14 | Colombia | Magdalena | 31786 | 1225 | 29751 | 810 | 10.4113 | -74.4057 | 2021-02-15 05:24:49 | Magdalena, Colombia | ||
2677677 | 2677677 | 2021-02-13 | Colombia | Magdalena | 31592 | 1222 | 29599 | 771 | 10.4113 | -74.4057 | 2021-02-14 05:23:43 | Magdalena, Colombia | ||
3539310 | 3539310 | 2021-02-12 | Colombia | Magdalena | 31423 | 1218 | 29527 | 678 | 10.4113 | -74.4057 | 2021-02-13 05:22:12 | Magdalena, Colombia | ||
2637573 | 2637573 | 2021-02-11 | Colombia | Magdalena | 31345 | 1213 | 29398 | 734 | 10.4113 | -74.4057 | 2021-02-12 05:23:29 | Magdalena, Colombia | ||
3978428 | 3978428 | 2021-02-10 | Colombia | Magdalena | 31222 | 1208 | 29257 | 757 | 10.4113 | -74.4057 | 2021-02-11 05:23:55 | Magdalena, Colombia | ||
1527748 | 1527748 | 2021-02-09 | Colombia | Magdalena | 31088 | 1205 | 29132 | 751 | 10.4113 | -74.4057 | 2021-02-10 05:22:41 | Magdalena, Colombia | ||
613539 | 613539 | 2021-02-08 | Colombia | Magdalena | 30950 | 1200 | 28925 | 825 | 10.4113 | -74.4057 | 2021-02-09 05:23:30 | Magdalena, Colombia | ||
1672308 | 1672308 | 2021-02-07 | Colombia | Magdalena | 30817 | 1198 | 28778 | 841 | 10.4113 | -74.4057 | 2021-02-08 05:22:39 | Magdalena, Colombia | ||
974769 | 974769 | 2021-02-06 | Colombia | Magdalena | 30750 | 1195 | 28749 | 806 | 10.4113 | -74.4057 | 2021-02-07 05:23:00 | Magdalena, Colombia | ||
1588027 | 1588027 | 2021-02-05 | Colombia | Magdalena | 30616 | 1193 | 28578 | 845 | 10.4113 | -74.4057 | 2021-02-06 05:23:55 | Magdalena, Colombia | ||
790234 | 790234 | 2021-02-04 | Colombia | Magdalena | 30510 | 1191 | 28378 | 941 | 10.4113 | -74.4057 | 2021-02-05 05:22:38 | Magdalena, Colombia | ||
340126 | 340126 | 2021-02-03 | Colombia | Magdalena | 30309 | 1189 | 28136 | 984 | 10.4113 | -74.4057 | 2021-02-04 05:22:26 | Magdalena, Colombia | ||
1684352 | 1684352 | 2021-02-02 | Colombia | Magdalena | 30033 | 1186 | 27956 | 891 | 10.4113 | -74.4057 | 2021-02-03 05:22:52 | Magdalena, Colombia | ||
1676322 | 1676322 | 2021-02-01 | Colombia | Magdalena | 29885 | 1182 | 27837 | 866 | 10.4113 | -74.4057 | 2021-02-02 05:22:49 | Magdalena, Colombia | ||
1459610 | 1459610 | 2021-01-31 | Colombia | Magdalena | 29818 | 1181 | 27701 | 936 | 10.4113 | -74.4057 | 2021-02-01 05:22:53 | Magdalena, Colombia | ||
2211518 | 2211518 | 2021-01-30 | Colombia | Magdalena | 29765 | 1178 | 27551 | 1036 | 10.4113 | -74.4057 | 2021-01-31 05:22:42 | Magdalena, Colombia | ||
1897005 | 1897005 | 2021-01-29 | Colombia | Magdalena | 29599 | 1175 | 27389 | 1035 | 10.4113 | -74.4057 | 2021-01-30 05:22:49 | Magdalena, Colombia | ||
2481821 | 2481821 | 2021-01-28 | Colombia | Magdalena | 29425 | 1169 | 27175 | 1081 | 10.4113 | -74.4057 | 2021-01-29 05:22:23 | Magdalena, Colombia | ||
3153456 | 3153456 | 2021-01-27 | Colombia | Magdalena | 29212 | 1165 | 27020 | 1027 | 10.4113 | -74.4057 | 2021-01-28 05:22:24 | Magdalena, Colombia | ||
12191 | 12191 | 2021-01-26 | Colombia | Magdalena | 28892 | 1158 | 26594 | 1140 | 10.4113 | -74.4057 | 2021-01-27 05:23:41 | Magdalena, Colombia | ||
2567515 | 2567515 | 2021-01-25 | Colombia | Magdalena | 28892 | 1158 | 26594 | 1140 | 10.4113 | -74.4057 | 2021-01-26 05:22:02 | Magdalena, Colombia | ||
1759147 | 1759147 | 2021-01-24 | Colombia | Magdalena | 28766 | 1157 | 26374 | 1235 | 10.4113 | -74.4057 | 2021-01-25 05:22:16 | Magdalena, Colombia | ||
2426754 | 2426754 | 2021-01-23 | Colombia | Magdalena | 28649 | 1153 | 26263 | 1233 | 10.4113 | -74.4057 | 2021-01-24 05:22:35 | Magdalena, Colombia | ||
2466656 | 2466656 | 2021-01-22 | Colombia | Magdalena | 28464 | 1152 | 26264 | 1048 | 10.4113 | -74.4057 | 2021-01-23 05:22:03 | Magdalena, Colombia | ||
435207 | 435207 | 2021-01-21 | Colombia | Magdalena | 28338 | 1147 | 26063 | 1128 | 10.4113 | -74.4057 | 2021-01-22 05:22:10 | Magdalena, Colombia | ||
1093939 | 1093939 | 2021-01-20 | Colombia | Magdalena | 28120 | 1144 | 25798 | 1178 | 10.4113 | -74.4057 | 2021-01-21 05:22:01 | Magdalena, Colombia | ||
908029 | 908029 | 2021-01-19 | Colombia | Magdalena | 27821 | 1143 | 25667 | 1011 | 10.4113 | -74.4057 | 2021-01-20 05:21:54 | Magdalena, Colombia | ||
237092 | 237092 | 2021-01-18 | Colombia | Magdalena | 27721 | 1140 | 25399 | 1182 | 10.4113 | -74.4057 | 2021-01-19 05:22:15 | Magdalena, Colombia | ||
3503209 | 3503209 | 2021-01-17 | Colombia | Magdalena | 27527 | 1137 | 25082 | 1308 | 10.4113 | -74.4057 | 2021-01-18 05:22:34 | Magdalena, Colombia | ||
3101292 | 3101292 | 2021-01-16 | Colombia | Magdalena | 27341 | 1135 | 24985 | 1221 | 10.4113 | -74.4057 | 2021-01-17 05:22:17 | Magdalena, Colombia | ||
3515254 | 3515254 | 2021-01-15 | Colombia | Magdalena | 27036 | 1131 | 24916 | 989 | 10.4113 | -74.4057 | 2021-01-16 05:22:40 | Magdalena, Colombia | ||
3879427 | 3879427 | 2021-01-14 | Colombia | Magdalena | 26857 | 1126 | 24792 | 939 | 10.4113 | -74.4057 | 2021-01-15 05:22:24 | Magdalena, Colombia | ||
3308054 | 3308054 | 2021-01-13 | Colombia | Magdalena | 26724 | 1124 | 24658 | 942 | 10.4113 | -74.4057 | 2021-01-14 05:22:32 | Magdalena, Colombia | ||
774199 | 774199 | 2021-01-12 | Colombia | Magdalena | 26501 | 1121 | 24303 | 1077 | 10.4113 | -74.4057 | 2021-01-13 05:22:15 | Magdalena, Colombia | ||
189920 | 189920 | 2021-01-11 | Colombia | Magdalena | 26291 | 1113 | 24081 | 1097 | 10.4113 | -74.4057 | 2021-01-12 05:22:15 | Magdalena, Colombia | ||
2625723 | 2625723 | 2021-01-10 | Colombia | Magdalena | 26128 | 1109 | 23960 | 1059 | 10.4113 | -74.4057 | 2021-01-11 05:21:50 | Magdalena, Colombia | ||
3899811 | 3899811 | 2021-01-09 | Colombia | Magdalena | 25873 | 1107 | 23834 | 932 | 10.4113 | -74.4057 | 2021-01-10 05:22:12 | Magdalena, Colombia | ||
153834 | 153834 | 2021-01-08 | Colombia | Magdalena | 25754 | 1101 | 23703 | 950 | 10.4113 | -74.4057 | 2021-01-09 05:22:18 | Magdalena, Colombia | ||
2541258 | 2541258 | 2021-01-07 | Colombia | Magdalena | 25628 | 1094 | 23462 | 1072 | 10.4113 | -74.4057 | 2021-01-08 05:22:42 | Magdalena, Colombia | ||
2864567 | 2864567 | 2021-01-06 | Colombia | Magdalena | 25515 | 1092 | 23359 | 1064 | 10.4113 | -74.4057 | 2021-01-07 05:22:03 | Magdalena, Colombia | ||
3034154 | 3034154 | 2021-01-05 | Colombia | Magdalena | 25338 | 1090 | 23315 | 933 | 10.4113 | -74.4057 | 2021-01-06 05:22:16 | Magdalena, Colombia | ||
1061699 | 1061699 | 2021-01-04 | Colombia | Magdalena | 25097 | 1085 | 23237 | 775 | 10.4113 | -74.4057 | 2021-01-05 05:21:49 | Magdalena, Colombia | ||
3230302 | 3230302 | 2021-01-03 | Colombia | Magdalena | 25028 | 1085 | 23117 | 826 | 10.4113 | -74.4057 | 2021-01-04 05:22:02 | Magdalena, Colombia | ||
2227372 | 2227372 | 2021-01-02 | Colombia | Magdalena | 24978 | 1079 | 23012 | 887 | 10.4113 | -74.4057 | 2021-01-03 05:22:52 | Magdalena, Colombia | ||
1136736 | 1136736 | 2021-01-01 | Colombia | Magdalena | 24836 | 1075 | 22950 | 811 | 10.4113 | -74.4057 | 2021-01-02 05:22:33 | Magdalena, Colombia | ||
3695342 | 3695342 | 2020-12-31 | Colombia | Magdalena | 24764 | 1072 | 22810 | 882 | 10.4113 | -74.4057 | 2021-01-01 05:23:07 | Magdalena, Colombia | ||
1010157 | 1010157 | 2020-12-30 | Colombia | Magdalena | 24641 | 1059 | 22736 | 846 | 10.4113 | -74.4057 | 2020-12-31 05:22:49 | Magdalena, Colombia | ||
766172 | 766172 | 2020-12-29 | Colombia | Magdalena | 24581 | 1059 | 22564 | 958 | 10.4113 | -74.4057 | 2020-12-30 05:22:34 | Magdalena, Colombia | ||
3761436 | 3761436 | 2020-12-28 | Colombia | Magdalena | 24474 | 1052 | 22418 | 1004 | 10.4113 | -74.4057 | 2020-12-29 05:22:37 | Magdalena, Colombia | ||
3777756 | 3777756 | 2020-12-27 | Colombia | Magdalena | 24285 | 1052 | 22232 | 1001 | 10.4113 | -74.4057 | 2020-12-28 05:22:06 | Magdalena, Colombia | ||
2223361 | 2223361 | 2020-12-26 | Colombia | Magdalena | 24167 | 1051 | 22037 | 1079 | 10.4113 | -74.4057 | 2020-12-27 05:22:55 | Magdalena, Colombia | ||
202108 | 202108 | 2020-12-25 | Colombia | Magdalena | 24057 | 1045 | 21792 | 1220 | 10.4113 | -74.4057 | 2020-12-26 05:22:28 | Magdalena, Colombia | ||
3691331 | 3691331 | 2020-12-24 | Colombia | Magdalena | 23768 | 1045 | 21489 | 1234 | 10.4113 | -74.4057 | 2020-12-25 05:22:48 | Magdalena, Colombia | ||
2406683 | 2406683 | 2020-12-23 | Colombia | Magdalena | 23495 | 1041 | 21283 | 1171 | 10.4113 | -74.4057 | 2020-12-24 05:23:04 | Magdalena, Colombia | ||
3769729 | 3769729 | 2020-12-22 | Colombia | Magdalena | 23298 | 1034 | 21151 | 1113 | 10.4113 | -74.4057 | 2020-12-23 05:22:03 | Magdalena, Colombia | ||
927545 | 927545 | 2020-12-21 | Colombia | Magdalena | 23147 | 1033 | 21023 | 1091 | 10.4113 | -74.4057 | 2020-12-22 05:22:33 | Magdalena, Colombia | ||
2119566 | 2119566 | 2020-12-20 | Colombia | Magdalena | 23014 | 1021 | 20796 | 1197 | 10.4113 | -74.4057 | 2020-12-21 05:27:58 | Magdalena, Colombia | ||
2931073 | 2931073 | 2020-12-19 | Colombia | Magdalena | 22737 | 1020 | 20665 | 1052 | 10.4113 | -74.4057 | 2020-12-20 05:27:32 | Magdalena, Colombia | ||
1901019 | 1901019 | 2020-12-18 | Colombia | Magdalena | 22542 | 1015 | 20528 | 999 | 10.4113 | -74.4057 | 2020-12-19 05:27:52 | Magdalena, Colombia | ||
2127845 | 2127845 | 2020-12-17 | Colombia | Magdalena | 22317 | 1008 | 20366 | 943 | 10.4113 | -74.4057 | 2020-12-18 05:28:18 | Magdalena, Colombia | ||
3149445 | 3149445 | 2020-12-16 | Colombia | Magdalena | 22201 | 1008 | 20268 | 925 | 10.4113 | -74.4057 | 2020-12-17 05:28:12 | Magdalena, Colombia | ||
1034226 | 1034226 | 2020-12-15 | Colombia | Magdalena | 22036 | 1006 | 20126 | 904 | 10.4113 | -74.4057 | 2020-12-16 05:28:04 | Magdalena, Colombia | ||
1751120 | 1751120 | 2020-12-14 | Colombia | Magdalena | 21952 | 1005 | 20033 | 914 | 10.4113 | -74.4057 | 2020-12-15 05:26:38 | Magdalena, Colombia | ||
3847640 | 3847640 | 2020-12-13 | Colombia | Magdalena | 21828 | 998 | 19939 | 891 | 10.4113 | -74.4057 | 2020-12-14 05:26:27 | Magdalena, Colombia | ||
845422 | 845422 | 2020-12-12 | Colombia | Magdalena | 21733 | 995 | 19909 | 829 | 10.4113 | -74.4057 | 2020-12-13 05:27:20 | Magdalena, Colombia | ||
860529 | 860529 | 2020-12-11 | Colombia | Magdalena | 21667 | 994 | 19841 | 832 | 10.4113 | -74.4057 | 2020-12-12 05:26:19 | Magdalena, Colombia | ||
1600071 | 1600071 | 2020-12-10 | Colombia | Magdalena | 21624 | 994 | 19717 | 913 | 10.4113 | -74.4057 | 2020-12-11 05:26:59 | Magdalena, Colombia | ||
2975080 | 2975080 | 2020-12-09 | Colombia | Magdalena | 21508 | 994 | 19599 | 915 | 10.4113 | -74.4057 | 2020-12-10 05:26:19 | Magdalena, Colombia | ||
1818640 | 1818640 | 2020-12-08 | Colombia | Magdalena | 21392 | 993 | 19454 | 945 | 10.4113 | -74.4057 | 2020-12-09 05:28:01 | Magdalena, Colombia | ||
2347276 | 2347276 | 2020-12-07 | Colombia | Magdalena | 21269 | 993 | 19270 | 1006 | 10.4113 | -74.4057 | 2020-12-08 05:27:42 | Magdalena, Colombia | ||
1006146 | 1006146 | 2020-12-06 | Colombia | Magdalena | 21212 | 993 | 19134 | 1085 | 10.4113 | -74.4057 | 2020-12-07 05:26:14 | Magdalena, Colombia | ||
1632155 | 1632155 | 2020-12-05 | Colombia | Magdalena | 21081 | 990 | 18973 | 1118 | 10.4113 | -74.4057 | 2020-12-06 05:26:18 | Magdalena, Colombia | ||
3859683 | 3859683 | 2020-12-04 | Colombia | Magdalena | 20933 | 988 | 18772 | 1173 | 10.4113 | -74.4057 | 2020-12-05 05:27:36 | Magdalena, Colombia | ||
74941 | 74941 | 2020-12-03 | Colombia | Magdalena | 20683 | 986 | 18674 | 1023 | 10.4113 | -74.4057 | 2020-12-04 05:27:27 | Magdalena, Colombia | ||
738153 | 738153 | 2020-12-02 | Colombia | Magdalena | 20517 | 984 | 18590 | 943 | 10.4113 | -74.4057 | 2020-12-03 05:28:22 | Magdalena, Colombia | ||
2537247 | 2537247 | 2020-12-01 | Colombia | Magdalena | 20431 | 978 | 18438 | 1015 | 10.4113 | -74.4057 | 2020-12-02 05:27:41 | Magdalena, Colombia | ||
1584016 | 1584016 | 2020-11-30 | Colombia | Magdalena | 20242 | 973 | 18324 | 945 | 10.4113 | -74.4057 | 2020-12-01 05:26:18 | Magdalena, Colombia | ||
3566419 | 3566419 | 2020-11-29 | Colombia | Magdalena | 20059 | 970 | 18223 | 866 | 10.4113 | -74.4057 | 2020-11-30 05:26:13 | Magdalena, Colombia | ||
2935084 | 2935084 | 2020-11-28 | Colombia | Magdalena | 19933 | 968 | 18041 | 924 | 10.4113 | -74.4057 | 2020-11-29 05:25:55 | Magdalena, Colombia | ||
392087 | 392087 | 2020-11-27 | Colombia | Magdalena | 19760 | 964 | 17907 | 889 | 10.4113 | -74.4057 | 2020-11-28 05:25:50 | Magdalena, Colombia | ||
923534 | 923534 | 2020-11-26 | Colombia | Magdalena | 19578 | 963 | 17826 | 789 | 10.4113 | -74.4057 | 2020-11-27 05:26:53 | Magdalena, Colombia | ||
1972439 | 1972439 | 2020-11-25 | Colombia | Magdalena | 19438 | 960 | 17758 | 720 | 10.4113 | -74.4057 | 2020-11-26 05:27:44 | Magdalena, Colombia | ||
1350170 | 1350170 | 2020-11-24 | Colombia | Magdalena | 19315 | 957 | 17670 | 688 | 10.4113 | -74.4057 | 2020-11-25 05:27:20 | 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]);