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 = "Capital District" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462631 | 2462631 | 2021-09-14 | Colombia | Capital District | 1446549 | 27424 | 0 | 4.711 | -74.0721 | 2021-09-15 03:22:37 | Capital District, Colombia | |||
1385470 | 1385470 | 2021-09-13 | Colombia | Capital District | 1446300 | 27421 | 0 | 4.711 | -74.0721 | 2021-09-14 04:21:41 | Capital District, Colombia | |||
1884839 | 1884839 | 2021-09-12 | Colombia | Capital District | 1446066 | 27413 | 0 | 4.711 | -74.0721 | 2021-09-13 04:21:15 | Capital District, Colombia | |||
3805742 | 3805742 | 2021-09-11 | Colombia | Capital District | 1445705 | 27404 | 0 | 4.711 | -74.0721 | 2021-09-12 04:21:13 | Capital District, Colombia | |||
3448682 | 3448682 | 2021-09-10 | Colombia | Capital District | 1445083 | 27401 | 0 | 4.711 | -74.0721 | 2021-09-11 04:21:30 | Capital District, Colombia | |||
1262628 | 1262628 | 2021-09-09 | Colombia | Capital District | 1444775 | 27399 | 0 | 4.711 | -74.0721 | 2021-09-10 04:21:20 | Capital District, Colombia | |||
2278998 | 2278998 | 2021-09-08 | Colombia | Capital District | 1444379 | 27394 | 0 | 4.711 | -74.0721 | 2021-09-09 04:21:27 | Capital District, Colombia | |||
641777 | 641777 | 2021-09-07 | Colombia | Capital District | 1444105 | 27379 | 0 | 4.711 | -74.0721 | 2021-09-08 04:21:31 | Capital District, Colombia | |||
3193840 | 3193840 | 2021-09-06 | Colombia | Capital District | 1443408 | 27373 | 0 | 4.711 | -74.0721 | 2021-09-07 04:21:35 | Capital District, Colombia | |||
3280708 | 3280708 | 2021-09-05 | Colombia | Capital District | 1443178 | 27364 | 0 | 4.711 | -74.0721 | 2021-09-06 04:21:22 | Capital District, Colombia | |||
249122 | 249122 | 2021-09-04 | Colombia | Capital District | 1442868 | 27355 | 0 | 4.711 | -74.0721 | 2021-09-05 04:21:33 | Capital District, Colombia | |||
3974403 | 3974403 | 2021-09-03 | Colombia | Capital District | 1442269 | 27346 | 0 | 4.711 | -74.0721 | 2021-09-04 04:21:28 | Capital District, Colombia | |||
177865 | 177865 | 2021-09-02 | Colombia | Capital District | 1441891 | 27341 | 0 | 4.711 | -74.0721 | 2021-09-03 04:21:20 | Capital District, Colombia | |||
66900 | 66900 | 2021-09-01 | Colombia | Capital District | 1441483 | 27321 | 0 | 4.711 | -74.0721 | 2021-09-02 04:21:15 | Capital District, Colombia | |||
2067742 | 2067742 | 2021-08-31 | Colombia | Capital District | 1441190 | 27314 | 0 | 4.711 | -74.0721 | 2021-09-01 04:21:38 | Capital District, Colombia | |||
1775196 | 1775196 | 2021-08-30 | Colombia | Capital District | 1440811 | 27304 | 0 | 4.711 | -74.0721 | 2021-08-31 04:21:46 | Capital District, Colombia | |||
3891770 | 3891770 | 2021-08-29 | Colombia | Capital District | 1440381 | 27292 | 0 | 4.711 | -74.0721 | 2021-08-30 04:21:23 | Capital District, Colombia | |||
2792873 | 2792873 | 2021-08-28 | Colombia | Capital District | 1439931 | 27286 | 0 | 4.711 | -74.0721 | 2021-08-29 04:21:14 | Capital District, Colombia | |||
2923032 | 2923032 | 2021-08-27 | Colombia | Capital District | 1439487 | 27275 | 0 | 4.711 | -74.0721 | 2021-08-28 04:21:28 | Capital District, Colombia | |||
1596046 | 1596046 | 2021-08-26 | Colombia | Capital District | 1438970 | 27257 | 0 | 4.711 | -74.0721 | 2021-08-27 04:21:37 | Capital District, Colombia | |||
32255 | 32255 | 2021-08-25 | Colombia | Capital District | 1438030 | 27242 | 0 | 4.711 | -74.0721 | 2021-08-26 04:21:28 | Capital District, Colombia | |||
3105294 | 3105294 | 2021-08-24 | Colombia | Capital District | 1438030 | 27236 | 0 | 4.711 | -74.0721 | 2021-08-25 04:21:41 | Capital District, Colombia | |||
3165465 | 3165465 | 2021-08-23 | Colombia | Capital District | 1437570 | 27220 | 0 | 4.711 | -74.0721 | 2021-08-24 04:21:19 | Capital District, Colombia | |||
2175392 | 2175392 | 2021-08-22 | Colombia | Capital District | 1437018 | 27205 | 0 | 4.711 | -74.0721 | 2021-08-23 04:21:27 | Capital District, Colombia | |||
3555488 | 3555488 | 2021-08-21 | Colombia | Capital District | 1436508 | 27182 | 0 | 4.711 | -74.0721 | 2021-08-22 04:21:29 | Capital District, Colombia | |||
1853830 | 1853830 | 2021-08-20 | Colombia | Capital District | 1435900 | 27182 | 0 | 4.711 | -74.0721 | 2021-08-21 04:21:38 | Capital District, Colombia | |||
511537 | 511537 | 2021-08-19 | Colombia | Capital District | 1435462 | 27164 | 0 | 4.711 | -74.0721 | 2021-08-20 04:21:33 | Capital District, Colombia | |||
2518016 | 2518016 | 2021-08-18 | Colombia | Capital District | 1434633 | 27153 | 0 | 4.711 | -74.0721 | 2021-08-19 04:21:15 | Capital District, Colombia | |||
245108 | 245108 | 2021-08-17 | Colombia | Capital District | 1434287 | 27135 | 0 | 4.711 | -74.0721 | 2021-08-18 04:21:35 | Capital District, Colombia | |||
1604071 | 1604071 | 2021-08-16 | Colombia | Capital District | 1433604 | 27110 | 0 | 4.711 | -74.0721 | 2021-08-17 04:21:49 | Capital District, Colombia | |||
103165 | 103165 | 2021-08-15 | Colombia | Capital District | 1431941 | 27078 | 0 | 4.711 | -74.0721 | 2021-08-16 04:21:31 | Capital District, Colombia | |||
507523 | 507523 | 2021-08-14 | Colombia | Capital District | 1431941 | 27067 | 0 | 4.711 | -74.0721 | 2021-08-15 04:21:41 | Capital District, Colombia | |||
1483395 | 1483395 | 2021-08-13 | Colombia | Capital District | 1430951 | 27045 | 0 | 4.711 | -74.0721 | 2021-08-14 04:21:25 | Capital District, Colombia | |||
2899525 | 2899525 | 2021-08-12 | Colombia | Capital District | 1430111 | 27029 | 0 | 4.711 | -74.0721 | 2021-08-13 04:21:24 | Capital District, Colombia | |||
1342129 | 1342129 | 2021-08-11 | Colombia | Capital District | 1429091 | 27005 | 0 | 4.711 | -74.0721 | 2021-08-12 04:21:25 | Capital District, Colombia | |||
2351276 | 2351276 | 2021-08-10 | Colombia | Capital District | 1428252 | 26979 | 0 | 4.711 | -74.0721 | 2021-08-11 04:21:58 | Capital District, Colombia | |||
649805 | 649805 | 2021-08-09 | Colombia | Capital District | 1427741 | 26964 | 0 | 4.711 | -74.0721 | 2021-08-10 04:21:27 | Capital District, Colombia | |||
589467 | 589467 | 2021-08-08 | Colombia | Capital District | 1426815 | 26934 | 0 | 4.711 | -74.0721 | 2021-08-09 04:21:24 | Capital District, Colombia | |||
2203479 | 2203479 | 2021-08-07 | Colombia | Capital District | 1425602 | 26896 | 0 | 4.711 | -74.0721 | 2021-08-08 04:21:33 | Capital District, Colombia | |||
1117429 | 1117429 | 2021-08-06 | Colombia | Capital District | 1424073 | 26854 | 0 | 4.711 | -74.0721 | 2021-08-07 04:21:30 | Capital District, Colombia | |||
1956366 | 1956366 | 2021-08-05 | Colombia | Capital District | 1422489 | 26829 | 0 | 4.711 | -74.0721 | 2021-08-06 04:21:18 | Capital District, Colombia | |||
331745 | 331745 | 2021-08-04 | Colombia | Capital District | 1420779 | 26797 | 1369593 | 24389 | 4.711 | -74.0721 | 2021-08-05 04:21:51 | Capital District, Colombia | ||
3468016 | 3468016 | 2021-08-03 | Colombia | Capital District | 1419195 | 26766 | 1366681 | 25748 | 4.711 | -74.0721 | 2021-08-04 04:21:25 | Capital District, Colombia | ||
3683290 | 3683290 | 2021-08-02 | Colombia | Capital District | 1417642 | 26724 | 1364394 | 26524 | 4.711 | -74.0721 | 2021-08-03 04:21:39 | Capital District, Colombia | ||
3015189 | 3015189 | 2021-08-01 | Colombia | Capital District | 1416037 | 26667 | 1361169 | 28201 | 4.711 | -74.0721 | 2021-08-02 04:21:36 | Capital District, Colombia | ||
3903812 | 3903812 | 2021-07-31 | Colombia | Capital District | 1413905 | 26621 | 1358640 | 28644 | 4.711 | -74.0721 | 2021-08-01 04:21:50 | Capital District, Colombia | ||
3296017 | 3296017 | 2021-07-30 | Colombia | Capital District | 1411317 | 26558 | 1354234 | 30525 | 4.711 | -74.0721 | 2021-07-31 04:21:35 | Capital District, Colombia | ||
3385228 | 3385228 | 2021-07-29 | Colombia | Capital District | 1408458 | 26509 | 1350659 | 31290 | 4.711 | -74.0721 | 2021-07-30 04:21:34 | Capital District, Colombia | ||
408133 | 408133 | 2021-07-28 | Colombia | Capital District | 1405585 | 26459 | 1346804 | 32322 | 4.711 | -74.0721 | 2021-07-29 04:21:33 | Capital District, Colombia | ||
1305994 | 1305994 | 2021-07-27 | Colombia | Capital District | 1403613 | 26402 | 1341515 | 35696 | 4.711 | -74.0721 | 2021-07-28 04:21:39 | Capital District, Colombia | ||
3218137 | 3218137 | 2021-07-26 | Colombia | Capital District | 1400870 | 26350 | 1332952 | 41568 | 4.711 | -74.0721 | 2021-07-27 04:21:18 | Capital District, Colombia | ||
1378346 | 1378346 | 2021-07-25 | Colombia | Capital District | 1399105 | 26298 | 1328268 | 44539 | 4.711 | -74.0721 | 2021-07-26 04:21:28 | Capital District, Colombia | ||
1330086 | 1330086 | 2021-07-24 | Colombia | Capital District | 1396235 | 26243 | 1327287 | 42705 | 4.711 | -74.0721 | 2021-07-25 04:22:12 | Capital District, Colombia | ||
3137390 | 3137390 | 2021-07-23 | Colombia | Capital District | 1389729 | 26106 | 1317269 | 46354 | 4.711 | -74.0721 | 2021-07-24 00:21:36 | Capital District, Colombia | ||
3476150 | 3476150 | 2021-07-22 | Colombia | Capital District | 1389729 | 26106 | 1317269 | 46354 | 4.711 | -74.0721 | 2021-07-23 04:21:29 | Capital District, Colombia | ||
3331369 | 3331369 | 2021-07-21 | Colombia | Capital District | 1386268 | 26044 | 1312234 | 47990 | 4.711 | -74.0721 | 2021-07-22 04:21:19 | Capital District, Colombia | ||
2371350 | 2371350 | 2021-07-20 | Colombia | Capital District | 1371462 | 25980 | 1311248 | 34234 | 4.711 | -74.0721 | 2021-07-21 04:21:40 | Capital District, Colombia | ||
483429 | 483429 | 2021-07-19 | Colombia | Capital District | 1371462 | 25923 | 1307302 | 38237 | 4.711 | -74.0721 | 2021-07-20 04:21:48 | Capital District, Colombia | ||
2673652 | 2673652 | 2021-07-18 | Colombia | Capital District | 1371462 | 25820 | 1302119 | 43523 | 4.711 | -74.0721 | 2021-07-19 04:21:24 | Capital District, Colombia | ||
3705964 | 3705964 | 2021-07-17 | Colombia | Capital District | 1371462 | 25680 | 1294627 | 51155 | 4.711 | -74.0721 | 2021-07-18 04:22:07 | Capital District, Colombia | ||
2947195 | 2947195 | 2021-07-16 | Colombia | Capital District | 1362009 | 25573 | 1288803 | 47633 | 4.711 | -74.0721 | 2021-07-17 04:22:22 | Capital District, Colombia | ||
295851 | 295851 | 2021-07-15 | Colombia | Capital District | 1358292 | 25468 | 1281867 | 50957 | 4.711 | -74.0721 | 2021-07-16 04:21:22 | Capital District, Colombia | ||
3631796 | 3631796 | 2021-07-14 | Colombia | Capital District | 1351273 | 25356 | 1275343 | 50574 | 4.711 | -74.0721 | 2021-07-15 04:21:48 | Capital District, Colombia | ||
578671 | 578671 | 2021-07-13 | Colombia | Capital District | 1346959 | 25247 | 1269777 | 51935 | 4.711 | -74.0721 | 2021-07-14 04:21:35 | Capital District, Colombia | ||
3740920 | 3740920 | 2021-07-12 | Colombia | Capital District | 1338285 | 25152 | 1264009 | 49124 | 4.711 | -74.0721 | 2021-07-13 04:21:18 | Capital District, Colombia | ||
3659433 | 3659433 | 2021-07-11 | Colombia | Capital District | 1338230 | 24896 | 1234157 | 79177 | 4.711 | -74.0721 | 2021-07-12 04:21:34 | Capital District, Colombia | ||
625717 | 625717 | 2021-07-10 | Colombia | Capital District | 1332993 | 24896 | 1234157 | 73940 | 4.711 | -74.0721 | 2021-07-11 04:21:43 | Capital District, Colombia | ||
829436 | 829436 | 2021-07-09 | Colombia | Capital District | 1325534 | 24896 | 1228330 | 72308 | 4.711 | -74.0721 | 2021-07-10 04:21:25 | Capital District, Colombia | ||
778200 | 778200 | 2021-07-08 | Colombia | Capital District | 1319074 | 24773 | 1228330 | 65971 | 4.711 | -74.0721 | 2021-07-09 04:21:21 | Capital District, Colombia | ||
1440422 | 1440422 | 2021-07-07 | Colombia | Capital District | 1313549 | 24652 | 1218623 | 70274 | 4.711 | -74.0721 | 2021-07-08 04:21:26 | Capital District, Colombia | ||
2693527 | 2693527 | 2021-07-06 | Colombia | Capital District | 1306739 | 24519 | 1201136 | 81084 | 4.711 | -74.0721 | 2021-07-07 04:21:20 | Capital District, Colombia | ||
1932276 | 1932276 | 2021-07-05 | Colombia | Capital District | 1298245 | 24420 | 1196411 | 77414 | 4.711 | -74.0721 | 2021-07-06 04:21:32 | Capital District, Colombia | ||
1165007 | 1165007 | 2021-07-04 | Colombia | Capital District | 1291549 | 24258 | 1186465 | 80826 | 4.711 | -74.0721 | 2021-07-05 04:21:28 | Capital District, Colombia | ||
1495441 | 1495441 | 2021-07-03 | Colombia | Capital District | 1284662 | 24119 | 1176930 | 83613 | 4.711 | -74.0721 | 2021-07-04 04:21:38 | Capital District, Colombia | ||
2071756 | 2071756 | 2021-07-02 | Colombia | Capital District | 1276491 | 23957 | 1167763 | 84771 | 4.711 | -74.0721 | 2021-07-03 04:21:37 | Capital District, Colombia | ||
2764772 | 2764772 | 2021-07-01 | Colombia | Capital District | 1267637 | 23847 | 1157388 | 86402 | 4.711 | -74.0721 | 2021-07-02 04:21:47 | Capital District, Colombia | ||
1892980 | 1892980 | 2021-06-30 | Colombia | Capital District | 1256087 | 23688 | 1144897 | 87502 | 4.711 | -74.0721 | 2021-07-01 04:21:19 | Capital District, Colombia | ||
400103 | 400103 | 2021-06-29 | Colombia | Capital District | 1244585 | 23566 | 1134791 | 86228 | 4.711 | -74.0721 | 2021-06-30 04:21:41 | Capital District, Colombia | ||
3125346 | 3125346 | 2021-06-28 | Colombia | Capital District | 1235250 | 23372 | 1125110 | 86768 | 4.711 | -74.0721 | 2021-06-29 04:21:28 | Capital District, Colombia | ||
2589841 | 2589841 | 2021-06-27 | Colombia | Capital District | 1225804 | 23218 | 1119486 | 83100 | 4.711 | -74.0721 | 2021-06-28 04:21:29 | Capital District, Colombia | ||
3958345 | 3958345 | 2021-06-26 | Colombia | Capital District | 1218716 | 23020 | 1112585 | 83111 | 4.711 | -74.0721 | 2021-06-27 04:21:39 | Capital District, Colombia | ||
1712164 | 1712164 | 2021-06-25 | Colombia | Capital District | 1207677 | 22822 | 1103756 | 81099 | 4.711 | -74.0721 | 2021-06-26 04:21:43 | Capital District, Colombia | ||
2295289 | 2295289 | 2021-06-24 | Colombia | Capital District | 1197968 | 22583 | 1088086 | 87299 | 4.711 | -74.0721 | 2021-06-25 04:21:33 | Capital District, Colombia | ||
2422729 | 2422729 | 2021-06-23 | Colombia | Capital District | 1182399 | 22427 | 1077595 | 82377 | 4.711 | -74.0721 | 2021-06-24 04:21:55 | Capital District, Colombia | ||
562806 | 562806 | 2021-06-22 | Colombia | Capital District | 1173051 | 22270 | 1069079 | 81702 | 4.711 | -74.0721 | 2021-06-23 04:21:46 | Capital District, Colombia | ||
3358508 | 3358508 | 2021-06-21 | Colombia | Capital District | 1165221 | 22105 | 1059077 | 84039 | 4.711 | -74.0721 | 2021-06-22 04:21:34 | Capital District, Colombia | ||
2884207 | 2884207 | 2021-06-20 | Colombia | Capital District | 1157637 | 21905 | 1052665 | 83067 | 4.711 | -74.0721 | 2021-06-21 04:21:41 | Capital District, Colombia | ||
107290 | 107290 | 2021-06-19 | Colombia | Capital District | 1147845 | 21720 | 1045932 | 80193 | 4.711 | -74.0721 | 2021-06-20 04:21:48 | Capital District, Colombia | ||
1125433 | 1125433 | 2021-06-18 | Colombia | Capital District | 1136113 | 21615 | 1033864 | 80634 | 4.711 | -74.0721 | 2021-06-19 04:22:33 | Capital District, Colombia | ||
2911011 | 2911011 | 2021-06-17 | Colombia | Capital District | 1124977 | 21442 | 1024506 | 79029 | 4.711 | -74.0721 | 2021-06-18 04:22:16 | Capital District, Colombia | ||
3030129 | 3030129 | 2021-06-16 | Colombia | Capital District | 1104052 | 21123 | 1006595 | 76334 | 4.711 | -74.0721 | 2021-06-17 04:22:36 | Capital District, Colombia | ||
2339235 | 2339235 | 2021-06-15 | Colombia | Capital District | 1079120 | 20831 | 996172 | 62117 | 4.711 | -74.0721 | 2021-06-16 04:22:32 | Capital District, Colombia | ||
1563931 | 1563931 | 2021-06-14 | Colombia | Capital District | 1079120 | 20831 | 996172 | 62117 | 4.711 | -74.0721 | 2021-06-15 04:22:22 | Capital District, Colombia | ||
3381214 | 3381214 | 2021-06-13 | Colombia | Capital District | 1079120 | 20675 | 983380 | 75065 | 4.711 | -74.0721 | 2021-06-14 04:22:46 | Capital District, Colombia | ||
1736348 | 1736348 | 2021-06-12 | Colombia | Capital District | 1079120 | 20645 | 977725 | 80750 | 4.711 | -74.0721 | 2021-06-13 04:22:44 | Capital District, Colombia | ||
3970389 | 3970389 | 2021-06-11 | Colombia | Capital District | 1069000 | 20476 | 969803 | 78721 | 4.711 | -74.0721 | 2021-06-12 04:22:22 | Capital District, Colombia | ||
2716811 | 2716811 | 2021-06-10 | Colombia | Capital District | 1058524 | 20323 | 961475 | 76726 | 4.711 | -74.0721 | 2021-06-11 04:23:20 | Capital District, Colombia | ||
522696 | 522696 | 2021-06-09 | Colombia | Capital District | 1047822 | 20182 | 952606 | 75034 | 4.711 | -74.0721 | 2021-06-10 04:23:17 | Capital District, Colombia | ||
3472136 | 3472136 | 2021-06-08 | Colombia | Capital District | 1031680 | 19931 | 934928 | 76821 | 4.711 | -74.0721 | 2021-06-09 04:23:31 | Capital District, Colombia | ||
3145420 | 3145420 | 2021-06-07 | Colombia | Capital District | 1031680 | 19931 | 934928 | 76821 | 4.711 | -74.0721 | 2021-06-08 04:22:35 | Capital District, 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]);