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 = "La Guajira" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462642 | 2462642 | 2021-09-14 | Colombia | La Guajira | 42198 | 1332 | 0 | 11.3548 | -72.5205 | 2021-09-15 03:22:37 | La Guajira, Colombia | |||
1385481 | 1385481 | 2021-09-13 | Colombia | La Guajira | 42184 | 1332 | 0 | 11.3548 | -72.5205 | 2021-09-14 04:21:41 | La Guajira, Colombia | |||
1884850 | 1884850 | 2021-09-12 | Colombia | La Guajira | 42177 | 1332 | 0 | 11.3548 | -72.5205 | 2021-09-13 04:21:15 | La Guajira, Colombia | |||
3805753 | 3805753 | 2021-09-11 | Colombia | La Guajira | 42158 | 1330 | 0 | 11.3548 | -72.5205 | 2021-09-12 04:21:13 | La Guajira, Colombia | |||
3448693 | 3448693 | 2021-09-10 | Colombia | La Guajira | 42153 | 1330 | 0 | 11.3548 | -72.5205 | 2021-09-11 04:21:30 | La Guajira, Colombia | |||
1262639 | 1262639 | 2021-09-09 | Colombia | La Guajira | 42143 | 1330 | 0 | 11.3548 | -72.5205 | 2021-09-10 04:21:20 | La Guajira, Colombia | |||
2279009 | 2279009 | 2021-09-08 | Colombia | La Guajira | 42127 | 1329 | 0 | 11.3548 | -72.5205 | 2021-09-09 04:21:27 | La Guajira, Colombia | |||
641788 | 641788 | 2021-09-07 | Colombia | La Guajira | 42120 | 1328 | 0 | 11.3548 | -72.5205 | 2021-09-08 04:21:31 | La Guajira, Colombia | |||
3193851 | 3193851 | 2021-09-06 | Colombia | La Guajira | 42115 | 1328 | 0 | 11.3548 | -72.5205 | 2021-09-07 04:21:35 | La Guajira, Colombia | |||
3280719 | 3280719 | 2021-09-05 | Colombia | La Guajira | 42102 | 1327 | 0 | 11.3548 | -72.5205 | 2021-09-06 04:21:22 | La Guajira, Colombia | |||
249133 | 249133 | 2021-09-04 | Colombia | La Guajira | 42094 | 1324 | 0 | 11.3548 | -72.5205 | 2021-09-05 04:21:33 | La Guajira, Colombia | |||
3974414 | 3974414 | 2021-09-03 | Colombia | La Guajira | 42090 | 1324 | 0 | 11.3548 | -72.5205 | 2021-09-04 04:21:28 | La Guajira, Colombia | |||
177876 | 177876 | 2021-09-02 | Colombia | La Guajira | 42064 | 1323 | 0 | 11.3548 | -72.5205 | 2021-09-03 04:21:20 | La Guajira, Colombia | |||
66911 | 66911 | 2021-09-01 | Colombia | La Guajira | 42061 | 1322 | 0 | 11.3548 | -72.5205 | 2021-09-02 04:21:15 | La Guajira, Colombia | |||
2067753 | 2067753 | 2021-08-31 | Colombia | La Guajira | 42053 | 1321 | 0 | 11.3548 | -72.5205 | 2021-09-01 04:21:38 | La Guajira, Colombia | |||
1775207 | 1775207 | 2021-08-30 | Colombia | La Guajira | 42042 | 1320 | 0 | 11.3548 | -72.5205 | 2021-08-31 04:21:46 | La Guajira, Colombia | |||
3891781 | 3891781 | 2021-08-29 | Colombia | La Guajira | 42020 | 1320 | 0 | 11.3548 | -72.5205 | 2021-08-30 04:21:23 | La Guajira, Colombia | |||
2792884 | 2792884 | 2021-08-28 | Colombia | La Guajira | 42009 | 1320 | 0 | 11.3548 | -72.5205 | 2021-08-29 04:21:14 | La Guajira, Colombia | |||
2923043 | 2923043 | 2021-08-27 | Colombia | La Guajira | 42008 | 1318 | 0 | 11.3548 | -72.5205 | 2021-08-28 04:21:28 | La Guajira, Colombia | |||
1596057 | 1596057 | 2021-08-26 | Colombia | La Guajira | 42005 | 1318 | 0 | 11.3548 | -72.5205 | 2021-08-27 04:21:37 | La Guajira, Colombia | |||
32266 | 32266 | 2021-08-25 | Colombia | La Guajira | 41986 | 1318 | 0 | 11.3548 | -72.5205 | 2021-08-26 04:21:28 | La Guajira, Colombia | |||
3105305 | 3105305 | 2021-08-24 | Colombia | La Guajira | 41986 | 1317 | 0 | 11.3548 | -72.5205 | 2021-08-25 04:21:41 | La Guajira, Colombia | |||
3165476 | 3165476 | 2021-08-23 | Colombia | La Guajira | 41957 | 1317 | 0 | 11.3548 | -72.5205 | 2021-08-24 04:21:19 | La Guajira, Colombia | |||
2175403 | 2175403 | 2021-08-22 | Colombia | La Guajira | 41937 | 1314 | 0 | 11.3548 | -72.5205 | 2021-08-23 04:21:27 | La Guajira, Colombia | |||
3555499 | 3555499 | 2021-08-21 | Colombia | La Guajira | 41922 | 1314 | 0 | 11.3548 | -72.5205 | 2021-08-22 04:21:29 | La Guajira, Colombia | |||
1853841 | 1853841 | 2021-08-20 | Colombia | La Guajira | 41920 | 1314 | 0 | 11.3548 | -72.5205 | 2021-08-21 04:21:38 | La Guajira, Colombia | |||
511548 | 511548 | 2021-08-19 | Colombia | La Guajira | 41894 | 1314 | 0 | 11.3548 | -72.5205 | 2021-08-20 04:21:33 | La Guajira, Colombia | |||
2518027 | 2518027 | 2021-08-18 | Colombia | La Guajira | 41883 | 1313 | 0 | 11.3548 | -72.5205 | 2021-08-19 04:21:15 | La Guajira, Colombia | |||
245119 | 245119 | 2021-08-17 | Colombia | La Guajira | 41866 | 1312 | 0 | 11.3548 | -72.5205 | 2021-08-18 04:21:35 | La Guajira, Colombia | |||
1604082 | 1604082 | 2021-08-16 | Colombia | La Guajira | 41859 | 1312 | 0 | 11.3548 | -72.5205 | 2021-08-17 04:21:49 | La Guajira, Colombia | |||
103176 | 103176 | 2021-08-15 | Colombia | La Guajira | 41839 | 1311 | 0 | 11.3548 | -72.5205 | 2021-08-16 04:21:31 | La Guajira, Colombia | |||
507534 | 507534 | 2021-08-14 | Colombia | La Guajira | 41839 | 1311 | 0 | 11.3548 | -72.5205 | 2021-08-15 04:21:41 | La Guajira, Colombia | |||
1483406 | 1483406 | 2021-08-13 | Colombia | La Guajira | 41820 | 1310 | 0 | 11.3548 | -72.5205 | 2021-08-14 04:21:25 | La Guajira, Colombia | |||
2899536 | 2899536 | 2021-08-12 | Colombia | La Guajira | 41793 | 1310 | 0 | 11.3548 | -72.5205 | 2021-08-13 04:21:24 | La Guajira, Colombia | |||
1342140 | 1342140 | 2021-08-11 | Colombia | La Guajira | 41757 | 1309 | 0 | 11.3548 | -72.5205 | 2021-08-12 04:21:25 | La Guajira, Colombia | |||
2351287 | 2351287 | 2021-08-10 | Colombia | La Guajira | 41732 | 1308 | 0 | 11.3548 | -72.5205 | 2021-08-11 04:21:58 | La Guajira, Colombia | |||
649816 | 649816 | 2021-08-09 | Colombia | La Guajira | 41699 | 1308 | 0 | 11.3548 | -72.5205 | 2021-08-10 04:21:27 | La Guajira, Colombia | |||
589478 | 589478 | 2021-08-08 | Colombia | La Guajira | 41665 | 1307 | 0 | 11.3548 | -72.5205 | 2021-08-09 04:21:24 | La Guajira, Colombia | |||
2203490 | 2203490 | 2021-08-07 | Colombia | La Guajira | 41650 | 1306 | 0 | 11.3548 | -72.5205 | 2021-08-08 04:21:33 | La Guajira, Colombia | |||
1117440 | 1117440 | 2021-08-06 | Colombia | La Guajira | 41627 | 1305 | 0 | 11.3548 | -72.5205 | 2021-08-07 04:21:30 | La Guajira, Colombia | |||
1956377 | 1956377 | 2021-08-05 | Colombia | La Guajira | 41580 | 1305 | 0 | 11.3548 | -72.5205 | 2021-08-06 04:21:18 | La Guajira, Colombia | |||
331756 | 331756 | 2021-08-04 | Colombia | La Guajira | 41552 | 1304 | 39944 | 304 | 11.3548 | -72.5205 | 2021-08-05 04:21:51 | La Guajira, Colombia | ||
3468027 | 3468027 | 2021-08-03 | Colombia | La Guajira | 41497 | 1304 | 39889 | 304 | 11.3548 | -72.5205 | 2021-08-04 04:21:25 | La Guajira, Colombia | ||
3683301 | 3683301 | 2021-08-02 | Colombia | La Guajira | 41445 | 1303 | 39868 | 274 | 11.3548 | -72.5205 | 2021-08-03 04:21:39 | La Guajira, Colombia | ||
3015200 | 3015200 | 2021-08-01 | Colombia | La Guajira | 41429 | 1302 | 39819 | 308 | 11.3548 | -72.5205 | 2021-08-02 04:21:36 | La Guajira, Colombia | ||
3903823 | 3903823 | 2021-07-31 | Colombia | La Guajira | 41365 | 1302 | 39795 | 268 | 11.3548 | -72.5205 | 2021-08-01 04:21:50 | La Guajira, Colombia | ||
3296028 | 3296028 | 2021-07-30 | Colombia | La Guajira | 41342 | 1300 | 39768 | 274 | 11.3548 | -72.5205 | 2021-07-31 04:21:35 | La Guajira, Colombia | ||
3385239 | 3385239 | 2021-07-29 | Colombia | La Guajira | 41318 | 1299 | 39742 | 277 | 11.3548 | -72.5205 | 2021-07-30 04:21:34 | La Guajira, Colombia | ||
408144 | 408144 | 2021-07-28 | Colombia | La Guajira | 41297 | 1298 | 39697 | 302 | 11.3548 | -72.5205 | 2021-07-29 04:21:33 | La Guajira, Colombia | ||
1306005 | 1306005 | 2021-07-27 | Colombia | La Guajira | 41265 | 1293 | 39624 | 348 | 11.3548 | -72.5205 | 2021-07-28 04:21:39 | La Guajira, Colombia | ||
3218148 | 3218148 | 2021-07-26 | Colombia | La Guajira | 41214 | 1293 | 39558 | 363 | 11.3548 | -72.5205 | 2021-07-27 04:21:18 | La Guajira, Colombia | ||
1378357 | 1378357 | 2021-07-25 | Colombia | La Guajira | 41191 | 1290 | 39500 | 401 | 11.3548 | -72.5205 | 2021-07-26 04:21:28 | La Guajira, Colombia | ||
1330097 | 1330097 | 2021-07-24 | Colombia | La Guajira | 41162 | 1290 | 39427 | 445 | 11.3548 | -72.5205 | 2021-07-25 04:22:12 | La Guajira, Colombia | ||
3137401 | 3137401 | 2021-07-23 | Colombia | La Guajira | 41027 | 1287 | 39284 | 456 | 11.3548 | -72.5205 | 2021-07-24 00:21:36 | La Guajira, Colombia | ||
3476161 | 3476161 | 2021-07-22 | Colombia | La Guajira | 41027 | 1287 | 39284 | 456 | 11.3548 | -72.5205 | 2021-07-23 04:21:29 | La Guajira, Colombia | ||
3331380 | 3331380 | 2021-07-21 | Colombia | La Guajira | 40977 | 1287 | 39245 | 445 | 11.3548 | -72.5205 | 2021-07-22 04:21:19 | La Guajira, Colombia | ||
2371361 | 2371361 | 2021-07-20 | Colombia | La Guajira | 40606 | 1287 | 39144 | 175 | 11.3548 | -72.5205 | 2021-07-21 04:21:40 | La Guajira, Colombia | ||
483440 | 483440 | 2021-07-19 | Colombia | La Guajira | 40606 | 1285 | 39055 | 266 | 11.3548 | -72.5205 | 2021-07-20 04:21:48 | La Guajira, Colombia | ||
2673663 | 2673663 | 2021-07-18 | Colombia | La Guajira | 40606 | 1283 | 38898 | 425 | 11.3548 | -72.5205 | 2021-07-19 04:21:24 | La Guajira, Colombia | ||
3705975 | 3705975 | 2021-07-17 | Colombia | La Guajira | 40606 | 1276 | 38889 | 441 | 11.3548 | -72.5205 | 2021-07-18 04:22:07 | La Guajira, Colombia | ||
2947206 | 2947206 | 2021-07-16 | Colombia | La Guajira | 40579 | 1276 | 38832 | 471 | 11.3548 | -72.5205 | 2021-07-17 04:22:22 | La Guajira, Colombia | ||
295862 | 295862 | 2021-07-15 | Colombia | La Guajira | 40532 | 1276 | 38807 | 449 | 11.3548 | -72.5205 | 2021-07-16 04:21:22 | La Guajira, Colombia | ||
3631807 | 3631807 | 2021-07-14 | Colombia | La Guajira | 40511 | 1276 | 38770 | 465 | 11.3548 | -72.5205 | 2021-07-15 04:21:48 | La Guajira, Colombia | ||
578682 | 578682 | 2021-07-13 | Colombia | La Guajira | 40478 | 1276 | 38690 | 512 | 11.3548 | -72.5205 | 2021-07-14 04:21:35 | La Guajira, Colombia | ||
3740931 | 3740931 | 2021-07-12 | Colombia | La Guajira | 40216 | 1274 | 38507 | 435 | 11.3548 | -72.5205 | 2021-07-13 04:21:18 | La Guajira, Colombia | ||
3659444 | 3659444 | 2021-07-11 | Colombia | La Guajira | 40219 | 1270 | 38422 | 527 | 11.3548 | -72.5205 | 2021-07-12 04:21:34 | La Guajira, Colombia | ||
625728 | 625728 | 2021-07-10 | Colombia | La Guajira | 40187 | 1270 | 38422 | 495 | 11.3548 | -72.5205 | 2021-07-11 04:21:43 | La Guajira, Colombia | ||
829447 | 829447 | 2021-07-09 | Colombia | La Guajira | 40154 | 1270 | 38288 | 596 | 11.3548 | -72.5205 | 2021-07-10 04:21:25 | La Guajira, Colombia | ||
778211 | 778211 | 2021-07-08 | Colombia | La Guajira | 40127 | 1270 | 38288 | 569 | 11.3548 | -72.5205 | 2021-07-09 04:21:21 | La Guajira, Colombia | ||
1440433 | 1440433 | 2021-07-07 | Colombia | La Guajira | 40033 | 1270 | 38201 | 562 | 11.3548 | -72.5205 | 2021-07-08 04:21:26 | La Guajira, Colombia | ||
2693538 | 2693538 | 2021-07-06 | Colombia | La Guajira | 39924 | 1268 | 38139 | 517 | 11.3548 | -72.5205 | 2021-07-07 04:21:20 | La Guajira, Colombia | ||
1932287 | 1932287 | 2021-07-05 | Colombia | La Guajira | 39845 | 1264 | 37957 | 624 | 11.3548 | -72.5205 | 2021-07-06 04:21:32 | La Guajira, Colombia | ||
1165018 | 1165018 | 2021-07-04 | Colombia | La Guajira | 39692 | 1258 | 37824 | 610 | 11.3548 | -72.5205 | 2021-07-05 04:21:28 | La Guajira, Colombia | ||
1495452 | 1495452 | 2021-07-03 | Colombia | La Guajira | 39567 | 1258 | 37751 | 558 | 11.3548 | -72.5205 | 2021-07-04 04:21:38 | La Guajira, Colombia | ||
2071767 | 2071767 | 2021-07-02 | Colombia | La Guajira | 39487 | 1258 | 37701 | 528 | 11.3548 | -72.5205 | 2021-07-03 04:21:37 | La Guajira, Colombia | ||
2764783 | 2764783 | 2021-07-01 | Colombia | La Guajira | 39437 | 1258 | 37675 | 504 | 11.3548 | -72.5205 | 2021-07-02 04:21:47 | La Guajira, Colombia | ||
1892991 | 1892991 | 2021-06-30 | Colombia | La Guajira | 39403 | 1257 | 37652 | 494 | 11.3548 | -72.5205 | 2021-07-01 04:21:19 | La Guajira, Colombia | ||
400114 | 400114 | 2021-06-29 | Colombia | La Guajira | 39365 | 1255 | 37522 | 588 | 11.3548 | -72.5205 | 2021-06-30 04:21:41 | La Guajira, Colombia | ||
3125357 | 3125357 | 2021-06-28 | Colombia | La Guajira | 39247 | 1252 | 37480 | 515 | 11.3548 | -72.5205 | 2021-06-29 04:21:28 | La Guajira, Colombia | ||
2589852 | 2589852 | 2021-06-27 | Colombia | La Guajira | 39240 | 1239 | 37416 | 585 | 11.3548 | -72.5205 | 2021-06-28 04:21:29 | La Guajira, Colombia | ||
3958356 | 3958356 | 2021-06-26 | Colombia | La Guajira | 39168 | 1232 | 37276 | 660 | 11.3548 | -72.5205 | 2021-06-27 04:21:39 | La Guajira, Colombia | ||
1712175 | 1712175 | 2021-06-25 | Colombia | La Guajira | 39024 | 1228 | 37146 | 650 | 11.3548 | -72.5205 | 2021-06-26 04:21:43 | La Guajira, Colombia | ||
2295300 | 2295300 | 2021-06-24 | Colombia | La Guajira | 38917 | 1225 | 37111 | 581 | 11.3548 | -72.5205 | 2021-06-25 04:21:33 | La Guajira, Colombia | ||
2422740 | 2422740 | 2021-06-23 | Colombia | La Guajira | 38882 | 1225 | 36934 | 723 | 11.3548 | -72.5205 | 2021-06-24 04:21:55 | La Guajira, Colombia | ||
562817 | 562817 | 2021-06-22 | Colombia | La Guajira | 38698 | 1221 | 36787 | 690 | 11.3548 | -72.5205 | 2021-06-23 04:21:46 | La Guajira, Colombia | ||
3358519 | 3358519 | 2021-06-21 | Colombia | La Guajira | 38548 | 1219 | 36719 | 610 | 11.3548 | -72.5205 | 2021-06-22 04:21:34 | La Guajira, Colombia | ||
2884218 | 2884218 | 2021-06-20 | Colombia | La Guajira | 38492 | 1215 | 36701 | 576 | 11.3548 | -72.5205 | 2021-06-21 04:21:41 | La Guajira, Colombia | ||
107301 | 107301 | 2021-06-19 | Colombia | La Guajira | 38456 | 1213 | 36647 | 596 | 11.3548 | -72.5205 | 2021-06-20 04:21:48 | La Guajira, Colombia | ||
1125444 | 1125444 | 2021-06-18 | Colombia | La Guajira | 38407 | 1211 | 36595 | 601 | 11.3548 | -72.5205 | 2021-06-19 04:22:33 | La Guajira, Colombia | ||
2911022 | 2911022 | 2021-06-17 | Colombia | La Guajira | 38266 | 1207 | 36554 | 505 | 11.3548 | -72.5205 | 2021-06-18 04:22:16 | La Guajira, Colombia | ||
3030140 | 3030140 | 2021-06-16 | Colombia | La Guajira | 38111 | 1203 | 36404 | 504 | 11.3548 | -72.5205 | 2021-06-17 04:22:36 | La Guajira, Colombia | ||
2339246 | 2339246 | 2021-06-15 | Colombia | La Guajira | 37707 | 1194 | 36312 | 201 | 11.3548 | -72.5205 | 2021-06-16 04:22:32 | La Guajira, Colombia | ||
1563942 | 1563942 | 2021-06-14 | Colombia | La Guajira | 37707 | 1194 | 36312 | 201 | 11.3548 | -72.5205 | 2021-06-15 04:22:22 | La Guajira, Colombia | ||
3381225 | 3381225 | 2021-06-13 | Colombia | La Guajira | 37707 | 1192 | 36057 | 458 | 11.3548 | -72.5205 | 2021-06-14 04:22:46 | La Guajira, Colombia | ||
1736359 | 1736359 | 2021-06-12 | Colombia | La Guajira | 37707 | 1192 | 35969 | 546 | 11.3548 | -72.5205 | 2021-06-13 04:22:44 | La Guajira, Colombia | ||
3970400 | 3970400 | 2021-06-11 | Colombia | La Guajira | 37604 | 1183 | 35839 | 582 | 11.3548 | -72.5205 | 2021-06-12 04:22:22 | La Guajira, Colombia | ||
2716822 | 2716822 | 2021-06-10 | Colombia | La Guajira | 37449 | 1178 | 35665 | 606 | 11.3548 | -72.5205 | 2021-06-11 04:23:20 | La Guajira, Colombia | ||
522707 | 522707 | 2021-06-09 | Colombia | La Guajira | 37271 | 1175 | 35471 | 625 | 11.3548 | -72.5205 | 2021-06-10 04:23:17 | La Guajira, Colombia | ||
3472147 | 3472147 | 2021-06-08 | Colombia | La Guajira | 37046 | 1173 | 35332 | 541 | 11.3548 | -72.5205 | 2021-06-09 04:23:31 | La Guajira, Colombia | ||
3145431 | 3145431 | 2021-06-07 | Colombia | La Guajira | 37046 | 1173 | 35332 | 541 | 11.3548 | -72.5205 | 2021-06-08 04:22:35 | La Guajira, 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]);