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 = "Casanare" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462633 | 2462633 | 2021-09-14 | Colombia | Casanare | 35431 | 914 | 0 | 5.7589 | -71.5724 | 2021-09-15 03:22:37 | Casanare, Colombia | |||
1385472 | 1385472 | 2021-09-13 | Colombia | Casanare | 35420 | 914 | 0 | 5.7589 | -71.5724 | 2021-09-14 04:21:41 | Casanare, Colombia | |||
1884841 | 1884841 | 2021-09-12 | Colombia | Casanare | 35418 | 914 | 0 | 5.7589 | -71.5724 | 2021-09-13 04:21:15 | Casanare, Colombia | |||
3805744 | 3805744 | 2021-09-11 | Colombia | Casanare | 35410 | 914 | 0 | 5.7589 | -71.5724 | 2021-09-12 04:21:13 | Casanare, Colombia | |||
3448684 | 3448684 | 2021-09-10 | Colombia | Casanare | 35402 | 914 | 0 | 5.7589 | -71.5724 | 2021-09-11 04:21:30 | Casanare, Colombia | |||
1262630 | 1262630 | 2021-09-09 | Colombia | Casanare | 35388 | 914 | 0 | 5.7589 | -71.5724 | 2021-09-10 04:21:20 | Casanare, Colombia | |||
2279000 | 2279000 | 2021-09-08 | Colombia | Casanare | 35379 | 913 | 0 | 5.7589 | -71.5724 | 2021-09-09 04:21:27 | Casanare, Colombia | |||
641779 | 641779 | 2021-09-07 | Colombia | Casanare | 35377 | 913 | 0 | 5.7589 | -71.5724 | 2021-09-08 04:21:31 | Casanare, Colombia | |||
3193842 | 3193842 | 2021-09-06 | Colombia | Casanare | 35370 | 913 | 0 | 5.7589 | -71.5724 | 2021-09-07 04:21:35 | Casanare, Colombia | |||
3280710 | 3280710 | 2021-09-05 | Colombia | Casanare | 35363 | 913 | 0 | 5.7589 | -71.5724 | 2021-09-06 04:21:22 | Casanare, Colombia | |||
249124 | 249124 | 2021-09-04 | Colombia | Casanare | 35360 | 913 | 0 | 5.7589 | -71.5724 | 2021-09-05 04:21:33 | Casanare, Colombia | |||
3974405 | 3974405 | 2021-09-03 | Colombia | Casanare | 35346 | 912 | 0 | 5.7589 | -71.5724 | 2021-09-04 04:21:28 | Casanare, Colombia | |||
177867 | 177867 | 2021-09-02 | Colombia | Casanare | 35336 | 911 | 0 | 5.7589 | -71.5724 | 2021-09-03 04:21:20 | Casanare, Colombia | |||
66902 | 66902 | 2021-09-01 | Colombia | Casanare | 35331 | 909 | 0 | 5.7589 | -71.5724 | 2021-09-02 04:21:15 | Casanare, Colombia | |||
2067744 | 2067744 | 2021-08-31 | Colombia | Casanare | 35321 | 909 | 0 | 5.7589 | -71.5724 | 2021-09-01 04:21:38 | Casanare, Colombia | |||
1775198 | 1775198 | 2021-08-30 | Colombia | Casanare | 35311 | 909 | 0 | 5.7589 | -71.5724 | 2021-08-31 04:21:46 | Casanare, Colombia | |||
3891772 | 3891772 | 2021-08-29 | Colombia | Casanare | 35299 | 909 | 0 | 5.7589 | -71.5724 | 2021-08-30 04:21:23 | Casanare, Colombia | |||
2792875 | 2792875 | 2021-08-28 | Colombia | Casanare | 35286 | 909 | 0 | 5.7589 | -71.5724 | 2021-08-29 04:21:14 | Casanare, Colombia | |||
2923034 | 2923034 | 2021-08-27 | Colombia | Casanare | 35274 | 909 | 0 | 5.7589 | -71.5724 | 2021-08-28 04:21:28 | Casanare, Colombia | |||
1596048 | 1596048 | 2021-08-26 | Colombia | Casanare | 35246 | 907 | 0 | 5.7589 | -71.5724 | 2021-08-27 04:21:37 | Casanare, Colombia | |||
32257 | 32257 | 2021-08-25 | Colombia | Casanare | 35209 | 904 | 0 | 5.7589 | -71.5724 | 2021-08-26 04:21:28 | Casanare, Colombia | |||
3105296 | 3105296 | 2021-08-24 | Colombia | Casanare | 35209 | 904 | 0 | 5.7589 | -71.5724 | 2021-08-25 04:21:41 | Casanare, Colombia | |||
3165467 | 3165467 | 2021-08-23 | Colombia | Casanare | 35178 | 904 | 0 | 5.7589 | -71.5724 | 2021-08-24 04:21:19 | Casanare, Colombia | |||
2175394 | 2175394 | 2021-08-22 | Colombia | Casanare | 35142 | 902 | 0 | 5.7589 | -71.5724 | 2021-08-23 04:21:27 | Casanare, Colombia | |||
3555490 | 3555490 | 2021-08-21 | Colombia | Casanare | 35094 | 902 | 0 | 5.7589 | -71.5724 | 2021-08-22 04:21:29 | Casanare, Colombia | |||
1853832 | 1853832 | 2021-08-20 | Colombia | Casanare | 35065 | 902 | 0 | 5.7589 | -71.5724 | 2021-08-21 04:21:38 | Casanare, Colombia | |||
511539 | 511539 | 2021-08-19 | Colombia | Casanare | 35032 | 901 | 0 | 5.7589 | -71.5724 | 2021-08-20 04:21:33 | Casanare, Colombia | |||
2518018 | 2518018 | 2021-08-18 | Colombia | Casanare | 35002 | 900 | 0 | 5.7589 | -71.5724 | 2021-08-19 04:21:15 | Casanare, Colombia | |||
245110 | 245110 | 2021-08-17 | Colombia | Casanare | 34968 | 900 | 0 | 5.7589 | -71.5724 | 2021-08-18 04:21:35 | Casanare, Colombia | |||
1604073 | 1604073 | 2021-08-16 | Colombia | Casanare | 34966 | 900 | 0 | 5.7589 | -71.5724 | 2021-08-17 04:21:49 | Casanare, Colombia | |||
103167 | 103167 | 2021-08-15 | Colombia | Casanare | 34932 | 898 | 0 | 5.7589 | -71.5724 | 2021-08-16 04:21:31 | Casanare, Colombia | |||
507525 | 507525 | 2021-08-14 | Colombia | Casanare | 34932 | 898 | 0 | 5.7589 | -71.5724 | 2021-08-15 04:21:41 | Casanare, Colombia | |||
1483397 | 1483397 | 2021-08-13 | Colombia | Casanare | 34902 | 897 | 0 | 5.7589 | -71.5724 | 2021-08-14 04:21:25 | Casanare, Colombia | |||
2899527 | 2899527 | 2021-08-12 | Colombia | Casanare | 34861 | 896 | 0 | 5.7589 | -71.5724 | 2021-08-13 04:21:24 | Casanare, Colombia | |||
1342131 | 1342131 | 2021-08-11 | Colombia | Casanare | 34830 | 893 | 0 | 5.7589 | -71.5724 | 2021-08-12 04:21:25 | Casanare, Colombia | |||
2351278 | 2351278 | 2021-08-10 | Colombia | Casanare | 34780 | 890 | 0 | 5.7589 | -71.5724 | 2021-08-11 04:21:58 | Casanare, Colombia | |||
649807 | 649807 | 2021-08-09 | Colombia | Casanare | 34705 | 888 | 0 | 5.7589 | -71.5724 | 2021-08-10 04:21:27 | Casanare, Colombia | |||
589469 | 589469 | 2021-08-08 | Colombia | Casanare | 34667 | 888 | 0 | 5.7589 | -71.5724 | 2021-08-09 04:21:24 | Casanare, Colombia | |||
2203481 | 2203481 | 2021-08-07 | Colombia | Casanare | 34641 | 885 | 0 | 5.7589 | -71.5724 | 2021-08-08 04:21:33 | Casanare, Colombia | |||
1117431 | 1117431 | 2021-08-06 | Colombia | Casanare | 34567 | 884 | 0 | 5.7589 | -71.5724 | 2021-08-07 04:21:30 | Casanare, Colombia | |||
1956368 | 1956368 | 2021-08-05 | Colombia | Casanare | 34511 | 881 | 0 | 5.7589 | -71.5724 | 2021-08-06 04:21:18 | Casanare, Colombia | |||
331747 | 331747 | 2021-08-04 | Colombia | Casanare | 34425 | 880 | 32835 | 710 | 5.7589 | -71.5724 | 2021-08-05 04:21:51 | Casanare, Colombia | ||
3468018 | 3468018 | 2021-08-03 | Colombia | Casanare | 34357 | 878 | 32736 | 743 | 5.7589 | -71.5724 | 2021-08-04 04:21:25 | Casanare, Colombia | ||
3683292 | 3683292 | 2021-08-02 | Colombia | Casanare | 34276 | 871 | 32644 | 761 | 5.7589 | -71.5724 | 2021-08-03 04:21:39 | Casanare, Colombia | ||
3015191 | 3015191 | 2021-08-01 | Colombia | Casanare | 34181 | 869 | 32549 | 763 | 5.7589 | -71.5724 | 2021-08-02 04:21:36 | Casanare, Colombia | ||
3903814 | 3903814 | 2021-07-31 | Colombia | Casanare | 34092 | 866 | 32455 | 771 | 5.7589 | -71.5724 | 2021-08-01 04:21:50 | Casanare, Colombia | ||
3296019 | 3296019 | 2021-07-30 | Colombia | Casanare | 33999 | 864 | 32398 | 737 | 5.7589 | -71.5724 | 2021-07-31 04:21:35 | Casanare, Colombia | ||
3385230 | 3385230 | 2021-07-29 | Colombia | Casanare | 33928 | 858 | 32336 | 734 | 5.7589 | -71.5724 | 2021-07-30 04:21:34 | Casanare, Colombia | ||
408135 | 408135 | 2021-07-28 | Colombia | Casanare | 33883 | 852 | 32211 | 820 | 5.7589 | -71.5724 | 2021-07-29 04:21:33 | Casanare, Colombia | ||
1305996 | 1305996 | 2021-07-27 | Colombia | Casanare | 33734 | 844 | 31992 | 898 | 5.7589 | -71.5724 | 2021-07-28 04:21:39 | Casanare, Colombia | ||
3218139 | 3218139 | 2021-07-26 | Colombia | Casanare | 33603 | 837 | 31848 | 918 | 5.7589 | -71.5724 | 2021-07-27 04:21:18 | Casanare, Colombia | ||
1378348 | 1378348 | 2021-07-25 | Colombia | Casanare | 33535 | 833 | 31710 | 992 | 5.7589 | -71.5724 | 2021-07-26 04:21:28 | Casanare, Colombia | ||
1330088 | 1330088 | 2021-07-24 | Colombia | Casanare | 33467 | 829 | 31594 | 1044 | 5.7589 | -71.5724 | 2021-07-25 04:22:12 | Casanare, Colombia | ||
3137392 | 3137392 | 2021-07-23 | Colombia | Casanare | 33268 | 820 | 31330 | 1118 | 5.7589 | -71.5724 | 2021-07-24 00:21:36 | Casanare, Colombia | ||
3476152 | 3476152 | 2021-07-22 | Colombia | Casanare | 33268 | 820 | 31330 | 1118 | 5.7589 | -71.5724 | 2021-07-23 04:21:29 | Casanare, Colombia | ||
3331371 | 3331371 | 2021-07-21 | Colombia | Casanare | 33221 | 815 | 31205 | 1201 | 5.7589 | -71.5724 | 2021-07-22 04:21:19 | Casanare, Colombia | ||
2371352 | 2371352 | 2021-07-20 | Colombia | Casanare | 32700 | 811 | 31092 | 797 | 5.7589 | -71.5724 | 2021-07-21 04:21:40 | Casanare, Colombia | ||
483431 | 483431 | 2021-07-19 | Colombia | Casanare | 32700 | 808 | 30970 | 922 | 5.7589 | -71.5724 | 2021-07-20 04:21:48 | Casanare, Colombia | ||
2673654 | 2673654 | 2021-07-18 | Colombia | Casanare | 32700 | 804 | 30901 | 995 | 5.7589 | -71.5724 | 2021-07-19 04:21:24 | Casanare, Colombia | ||
3705966 | 3705966 | 2021-07-17 | Colombia | Casanare | 32700 | 804 | 30757 | 1139 | 5.7589 | -71.5724 | 2021-07-18 04:22:07 | Casanare, Colombia | ||
2947197 | 2947197 | 2021-07-16 | Colombia | Casanare | 32533 | 801 | 30663 | 1069 | 5.7589 | -71.5724 | 2021-07-17 04:22:22 | Casanare, Colombia | ||
295853 | 295853 | 2021-07-15 | Colombia | Casanare | 32352 | 797 | 30524 | 1031 | 5.7589 | -71.5724 | 2021-07-16 04:21:22 | Casanare, Colombia | ||
3631798 | 3631798 | 2021-07-14 | Colombia | Casanare | 32250 | 794 | 30345 | 1111 | 5.7589 | -71.5724 | 2021-07-15 04:21:48 | Casanare, Colombia | ||
578673 | 578673 | 2021-07-13 | Colombia | Casanare | 32040 | 789 | 30200 | 1051 | 5.7589 | -71.5724 | 2021-07-14 04:21:35 | Casanare, Colombia | ||
3740922 | 3740922 | 2021-07-12 | Colombia | Casanare | 31807 | 785 | 29968 | 1054 | 5.7589 | -71.5724 | 2021-07-13 04:21:18 | Casanare, Colombia | ||
3659435 | 3659435 | 2021-07-11 | Colombia | Casanare | 31807 | 771 | 29490 | 1546 | 5.7589 | -71.5724 | 2021-07-12 04:21:34 | Casanare, Colombia | ||
625719 | 625719 | 2021-07-10 | Colombia | Casanare | 31654 | 771 | 29490 | 1393 | 5.7589 | -71.5724 | 2021-07-11 04:21:43 | Casanare, Colombia | ||
829438 | 829438 | 2021-07-09 | Colombia | Casanare | 31506 | 771 | 29091 | 1644 | 5.7589 | -71.5724 | 2021-07-10 04:21:25 | Casanare, Colombia | ||
778202 | 778202 | 2021-07-08 | Colombia | Casanare | 31325 | 764 | 29091 | 1470 | 5.7589 | -71.5724 | 2021-07-09 04:21:21 | Casanare, Colombia | ||
1440424 | 1440424 | 2021-07-07 | Colombia | Casanare | 31061 | 760 | 28810 | 1491 | 5.7589 | -71.5724 | 2021-07-08 04:21:26 | Casanare, Colombia | ||
2693529 | 2693529 | 2021-07-06 | Colombia | Casanare | 30788 | 759 | 28650 | 1379 | 5.7589 | -71.5724 | 2021-07-07 04:21:20 | Casanare, Colombia | ||
1932278 | 1932278 | 2021-07-05 | Colombia | Casanare | 30607 | 742 | 28339 | 1526 | 5.7589 | -71.5724 | 2021-07-06 04:21:32 | Casanare, Colombia | ||
1165009 | 1165009 | 2021-07-04 | Colombia | Casanare | 30433 | 733 | 28098 | 1602 | 5.7589 | -71.5724 | 2021-07-05 04:21:28 | Casanare, Colombia | ||
1495443 | 1495443 | 2021-07-03 | Colombia | Casanare | 30144 | 733 | 27920 | 1491 | 5.7589 | -71.5724 | 2021-07-04 04:21:38 | Casanare, Colombia | ||
2071758 | 2071758 | 2021-07-02 | Colombia | Casanare | 29918 | 731 | 27659 | 1528 | 5.7589 | -71.5724 | 2021-07-03 04:21:37 | Casanare, Colombia | ||
2764774 | 2764774 | 2021-07-01 | Colombia | Casanare | 29692 | 726 | 27448 | 1518 | 5.7589 | -71.5724 | 2021-07-02 04:21:47 | Casanare, Colombia | ||
1892982 | 1892982 | 2021-06-30 | Colombia | Casanare | 29486 | 718 | 27224 | 1544 | 5.7589 | -71.5724 | 2021-07-01 04:21:19 | Casanare, Colombia | ||
400105 | 400105 | 2021-06-29 | Colombia | Casanare | 29314 | 705 | 26892 | 1717 | 5.7589 | -71.5724 | 2021-06-30 04:21:41 | Casanare, Colombia | ||
3125348 | 3125348 | 2021-06-28 | Colombia | Casanare | 29057 | 695 | 26628 | 1734 | 5.7589 | -71.5724 | 2021-06-29 04:21:28 | Casanare, Colombia | ||
2589843 | 2589843 | 2021-06-27 | Colombia | Casanare | 28820 | 695 | 26367 | 1758 | 5.7589 | -71.5724 | 2021-06-28 04:21:29 | Casanare, Colombia | ||
3958347 | 3958347 | 2021-06-26 | Colombia | Casanare | 28585 | 690 | 26039 | 1856 | 5.7589 | -71.5724 | 2021-06-27 04:21:39 | Casanare, Colombia | ||
1712166 | 1712166 | 2021-06-25 | Colombia | Casanare | 28176 | 682 | 25785 | 1709 | 5.7589 | -71.5724 | 2021-06-26 04:21:43 | Casanare, Colombia | ||
2295291 | 2295291 | 2021-06-24 | Colombia | Casanare | 27770 | 678 | 25636 | 1456 | 5.7589 | -71.5724 | 2021-06-25 04:21:33 | Casanare, Colombia | ||
2422731 | 2422731 | 2021-06-23 | Colombia | Casanare | 27565 | 664 | 25244 | 1657 | 5.7589 | -71.5724 | 2021-06-24 04:21:55 | Casanare, Colombia | ||
562808 | 562808 | 2021-06-22 | Colombia | Casanare | 27136 | 662 | 24771 | 1703 | 5.7589 | -71.5724 | 2021-06-23 04:21:46 | Casanare, Colombia | ||
3358510 | 3358510 | 2021-06-21 | Colombia | Casanare | 26703 | 655 | 24469 | 1579 | 5.7589 | -71.5724 | 2021-06-22 04:21:34 | Casanare, Colombia | ||
2884209 | 2884209 | 2021-06-20 | Colombia | Casanare | 26491 | 632 | 24365 | 1494 | 5.7589 | -71.5724 | 2021-06-21 04:21:41 | Casanare, Colombia | ||
107292 | 107292 | 2021-06-19 | Colombia | Casanare | 26164 | 622 | 24137 | 1405 | 5.7589 | -71.5724 | 2021-06-20 04:21:48 | Casanare, Colombia | ||
1125435 | 1125435 | 2021-06-18 | Colombia | Casanare | 25989 | 615 | 23966 | 1408 | 5.7589 | -71.5724 | 2021-06-19 04:22:33 | Casanare, Colombia | ||
2911013 | 2911013 | 2021-06-17 | Colombia | Casanare | 25705 | 612 | 23741 | 1352 | 5.7589 | -71.5724 | 2021-06-18 04:22:16 | Casanare, Colombia | ||
3030131 | 3030131 | 2021-06-16 | Colombia | Casanare | 25164 | 597 | 23129 | 1438 | 5.7589 | -71.5724 | 2021-06-17 04:22:36 | Casanare, Colombia | ||
2339237 | 2339237 | 2021-06-15 | Colombia | Casanare | 24409 | 588 | 22861 | 960 | 5.7589 | -71.5724 | 2021-06-16 04:22:32 | Casanare, Colombia | ||
1563933 | 1563933 | 2021-06-14 | Colombia | Casanare | 24409 | 588 | 22861 | 960 | 5.7589 | -71.5724 | 2021-06-15 04:22:22 | Casanare, Colombia | ||
3381216 | 3381216 | 2021-06-13 | Colombia | Casanare | 24409 | 582 | 22524 | 1303 | 5.7589 | -71.5724 | 2021-06-14 04:22:46 | Casanare, Colombia | ||
1736350 | 1736350 | 2021-06-12 | Colombia | Casanare | 24409 | 573 | 22324 | 1512 | 5.7589 | -71.5724 | 2021-06-13 04:22:44 | Casanare, Colombia | ||
3970391 | 3970391 | 2021-06-11 | Colombia | Casanare | 24052 | 565 | 22129 | 1358 | 5.7589 | -71.5724 | 2021-06-12 04:22:22 | Casanare, Colombia | ||
2716813 | 2716813 | 2021-06-10 | Colombia | Casanare | 23700 | 560 | 21758 | 1382 | 5.7589 | -71.5724 | 2021-06-11 04:23:20 | Casanare, Colombia | ||
522698 | 522698 | 2021-06-09 | Colombia | Casanare | 23366 | 550 | 21514 | 1302 | 5.7589 | -71.5724 | 2021-06-10 04:23:17 | Casanare, Colombia | ||
3472138 | 3472138 | 2021-06-08 | Colombia | Casanare | 22913 | 540 | 21176 | 1197 | 5.7589 | -71.5724 | 2021-06-09 04:23:31 | Casanare, Colombia | ||
3145422 | 3145422 | 2021-06-07 | Colombia | Casanare | 22913 | 540 | 21176 | 1197 | 5.7589 | -71.5724 | 2021-06-08 04:22:35 | Casanare, 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]);