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 = "Putumayo" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462647 | 2462647 | 2021-09-14 | Colombia | Putumayo | 16168 | 665 | 0 | 0.436 | -75.5277 | 2021-09-15 03:22:37 | Putumayo, Colombia | |||
1385486 | 1385486 | 2021-09-13 | Colombia | Putumayo | 16164 | 665 | 0 | 0.436 | -75.5277 | 2021-09-14 04:21:41 | Putumayo, Colombia | |||
1884855 | 1884855 | 2021-09-12 | Colombia | Putumayo | 16162 | 665 | 0 | 0.436 | -75.5277 | 2021-09-13 04:21:15 | Putumayo, Colombia | |||
3805758 | 3805758 | 2021-09-11 | Colombia | Putumayo | 16161 | 664 | 0 | 0.436 | -75.5277 | 2021-09-12 04:21:13 | Putumayo, Colombia | |||
3448698 | 3448698 | 2021-09-10 | Colombia | Putumayo | 16156 | 664 | 0 | 0.436 | -75.5277 | 2021-09-11 04:21:30 | Putumayo, Colombia | |||
1262644 | 1262644 | 2021-09-09 | Colombia | Putumayo | 16148 | 664 | 0 | 0.436 | -75.5277 | 2021-09-10 04:21:20 | Putumayo, Colombia | |||
2279014 | 2279014 | 2021-09-08 | Colombia | Putumayo | 16143 | 663 | 0 | 0.436 | -75.5277 | 2021-09-09 04:21:27 | Putumayo, Colombia | |||
641793 | 641793 | 2021-09-07 | Colombia | Putumayo | 16137 | 661 | 0 | 0.436 | -75.5277 | 2021-09-08 04:21:31 | Putumayo, Colombia | |||
3193856 | 3193856 | 2021-09-06 | Colombia | Putumayo | 16135 | 660 | 0 | 0.436 | -75.5277 | 2021-09-07 04:21:35 | Putumayo, Colombia | |||
3280724 | 3280724 | 2021-09-05 | Colombia | Putumayo | 16113 | 660 | 0 | 0.436 | -75.5277 | 2021-09-06 04:21:22 | Putumayo, Colombia | |||
249138 | 249138 | 2021-09-04 | Colombia | Putumayo | 16105 | 660 | 0 | 0.436 | -75.5277 | 2021-09-05 04:21:33 | Putumayo, Colombia | |||
3974419 | 3974419 | 2021-09-03 | Colombia | Putumayo | 16104 | 660 | 0 | 0.436 | -75.5277 | 2021-09-04 04:21:28 | Putumayo, Colombia | |||
177881 | 177881 | 2021-09-02 | Colombia | Putumayo | 16089 | 660 | 0 | 0.436 | -75.5277 | 2021-09-03 04:21:20 | Putumayo, Colombia | |||
66916 | 66916 | 2021-09-01 | Colombia | Putumayo | 16087 | 659 | 0 | 0.436 | -75.5277 | 2021-09-02 04:21:15 | Putumayo, Colombia | |||
2067758 | 2067758 | 2021-08-31 | Colombia | Putumayo | 16080 | 659 | 0 | 0.436 | -75.5277 | 2021-09-01 04:21:38 | Putumayo, Colombia | |||
1775212 | 1775212 | 2021-08-30 | Colombia | Putumayo | 16079 | 659 | 0 | 0.436 | -75.5277 | 2021-08-31 04:21:46 | Putumayo, Colombia | |||
3891786 | 3891786 | 2021-08-29 | Colombia | Putumayo | 16067 | 659 | 0 | 0.436 | -75.5277 | 2021-08-30 04:21:23 | Putumayo, Colombia | |||
2792889 | 2792889 | 2021-08-28 | Colombia | Putumayo | 16061 | 658 | 0 | 0.436 | -75.5277 | 2021-08-29 04:21:14 | Putumayo, Colombia | |||
2923048 | 2923048 | 2021-08-27 | Colombia | Putumayo | 16055 | 656 | 0 | 0.436 | -75.5277 | 2021-08-28 04:21:28 | Putumayo, Colombia | |||
1596062 | 1596062 | 2021-08-26 | Colombia | Putumayo | 16051 | 656 | 0 | 0.436 | -75.5277 | 2021-08-27 04:21:37 | Putumayo, Colombia | |||
32271 | 32271 | 2021-08-25 | Colombia | Putumayo | 16035 | 655 | 0 | 0.436 | -75.5277 | 2021-08-26 04:21:28 | Putumayo, Colombia | |||
3105310 | 3105310 | 2021-08-24 | Colombia | Putumayo | 16035 | 654 | 0 | 0.436 | -75.5277 | 2021-08-25 04:21:41 | Putumayo, Colombia | |||
3165481 | 3165481 | 2021-08-23 | Colombia | Putumayo | 16030 | 654 | 0 | 0.436 | -75.5277 | 2021-08-24 04:21:19 | Putumayo, Colombia | |||
2175408 | 2175408 | 2021-08-22 | Colombia | Putumayo | 16004 | 653 | 0 | 0.436 | -75.5277 | 2021-08-23 04:21:27 | Putumayo, Colombia | |||
3555504 | 3555504 | 2021-08-21 | Colombia | Putumayo | 15983 | 653 | 0 | 0.436 | -75.5277 | 2021-08-22 04:21:29 | Putumayo, Colombia | |||
1853846 | 1853846 | 2021-08-20 | Colombia | Putumayo | 15966 | 653 | 0 | 0.436 | -75.5277 | 2021-08-21 04:21:38 | Putumayo, Colombia | |||
511553 | 511553 | 2021-08-19 | Colombia | Putumayo | 15943 | 652 | 0 | 0.436 | -75.5277 | 2021-08-20 04:21:33 | Putumayo, Colombia | |||
2518032 | 2518032 | 2021-08-18 | Colombia | Putumayo | 15934 | 652 | 0 | 0.436 | -75.5277 | 2021-08-19 04:21:15 | Putumayo, Colombia | |||
245124 | 245124 | 2021-08-17 | Colombia | Putumayo | 15925 | 651 | 0 | 0.436 | -75.5277 | 2021-08-18 04:21:35 | Putumayo, Colombia | |||
1604087 | 1604087 | 2021-08-16 | Colombia | Putumayo | 15917 | 651 | 0 | 0.436 | -75.5277 | 2021-08-17 04:21:49 | Putumayo, Colombia | |||
103181 | 103181 | 2021-08-15 | Colombia | Putumayo | 15863 | 649 | 0 | 0.436 | -75.5277 | 2021-08-16 04:21:31 | Putumayo, Colombia | |||
507539 | 507539 | 2021-08-14 | Colombia | Putumayo | 15863 | 647 | 0 | 0.436 | -75.5277 | 2021-08-15 04:21:41 | Putumayo, Colombia | |||
1483411 | 1483411 | 2021-08-13 | Colombia | Putumayo | 15835 | 646 | 0 | 0.436 | -75.5277 | 2021-08-14 04:21:25 | Putumayo, Colombia | |||
2899541 | 2899541 | 2021-08-12 | Colombia | Putumayo | 15815 | 646 | 0 | 0.436 | -75.5277 | 2021-08-13 04:21:24 | Putumayo, Colombia | |||
1342145 | 1342145 | 2021-08-11 | Colombia | Putumayo | 15766 | 646 | 0 | 0.436 | -75.5277 | 2021-08-12 04:21:25 | Putumayo, Colombia | |||
2351292 | 2351292 | 2021-08-10 | Colombia | Putumayo | 15733 | 645 | 0 | 0.436 | -75.5277 | 2021-08-11 04:21:58 | Putumayo, Colombia | |||
649821 | 649821 | 2021-08-09 | Colombia | Putumayo | 15705 | 642 | 0 | 0.436 | -75.5277 | 2021-08-10 04:21:27 | Putumayo, Colombia | |||
589483 | 589483 | 2021-08-08 | Colombia | Putumayo | 15688 | 642 | 0 | 0.436 | -75.5277 | 2021-08-09 04:21:24 | Putumayo, Colombia | |||
2203495 | 2203495 | 2021-08-07 | Colombia | Putumayo | 15672 | 639 | 0 | 0.436 | -75.5277 | 2021-08-08 04:21:33 | Putumayo, Colombia | |||
1117445 | 1117445 | 2021-08-06 | Colombia | Putumayo | 15638 | 637 | 0 | 0.436 | -75.5277 | 2021-08-07 04:21:30 | Putumayo, Colombia | |||
1956382 | 1956382 | 2021-08-05 | Colombia | Putumayo | 15607 | 635 | 0 | 0.436 | -75.5277 | 2021-08-06 04:21:18 | Putumayo, Colombia | |||
331761 | 331761 | 2021-08-04 | Colombia | Putumayo | 15565 | 634 | 14664 | 267 | 0.436 | -75.5277 | 2021-08-05 04:21:51 | Putumayo, Colombia | ||
3468032 | 3468032 | 2021-08-03 | Colombia | Putumayo | 15532 | 634 | 14635 | 263 | 0.436 | -75.5277 | 2021-08-04 04:21:25 | Putumayo, Colombia | ||
3683306 | 3683306 | 2021-08-02 | Colombia | Putumayo | 15499 | 629 | 14576 | 294 | 0.436 | -75.5277 | 2021-08-03 04:21:39 | Putumayo, Colombia | ||
3015205 | 3015205 | 2021-08-01 | Colombia | Putumayo | 15431 | 629 | 14521 | 281 | 0.436 | -75.5277 | 2021-08-02 04:21:36 | Putumayo, Colombia | ||
3903828 | 3903828 | 2021-07-31 | Colombia | Putumayo | 15390 | 628 | 14481 | 281 | 0.436 | -75.5277 | 2021-08-01 04:21:50 | Putumayo, Colombia | ||
3296033 | 3296033 | 2021-07-30 | Colombia | Putumayo | 15356 | 627 | 14442 | 287 | 0.436 | -75.5277 | 2021-07-31 04:21:35 | Putumayo, Colombia | ||
3385244 | 3385244 | 2021-07-29 | Colombia | Putumayo | 15303 | 625 | 14414 | 264 | 0.436 | -75.5277 | 2021-07-30 04:21:34 | Putumayo, Colombia | ||
408149 | 408149 | 2021-07-28 | Colombia | Putumayo | 15275 | 623 | 14364 | 288 | 0.436 | -75.5277 | 2021-07-29 04:21:33 | Putumayo, Colombia | ||
1306010 | 1306010 | 2021-07-27 | Colombia | Putumayo | 15214 | 620 | 14291 | 303 | 0.436 | -75.5277 | 2021-07-28 04:21:39 | Putumayo, Colombia | ||
3218153 | 3218153 | 2021-07-26 | Colombia | Putumayo | 15152 | 618 | 14216 | 318 | 0.436 | -75.5277 | 2021-07-27 04:21:18 | Putumayo, Colombia | ||
1378362 | 1378362 | 2021-07-25 | Colombia | Putumayo | 15108 | 614 | 14103 | 391 | 0.436 | -75.5277 | 2021-07-26 04:21:28 | Putumayo, Colombia | ||
1330102 | 1330102 | 2021-07-24 | Colombia | Putumayo | 15062 | 609 | 14050 | 403 | 0.436 | -75.5277 | 2021-07-25 04:22:12 | Putumayo, Colombia | ||
3137406 | 3137406 | 2021-07-23 | Colombia | Putumayo | 14925 | 604 | 13920 | 401 | 0.436 | -75.5277 | 2021-07-24 00:21:36 | Putumayo, Colombia | ||
3476166 | 3476166 | 2021-07-22 | Colombia | Putumayo | 14925 | 604 | 13920 | 401 | 0.436 | -75.5277 | 2021-07-23 04:21:29 | Putumayo, Colombia | ||
3331385 | 3331385 | 2021-07-21 | Colombia | Putumayo | 14908 | 604 | 13869 | 435 | 0.436 | -75.5277 | 2021-07-22 04:21:19 | Putumayo, Colombia | ||
2371366 | 2371366 | 2021-07-20 | Colombia | Putumayo | 14642 | 604 | 13811 | 227 | 0.436 | -75.5277 | 2021-07-21 04:21:40 | Putumayo, Colombia | ||
483445 | 483445 | 2021-07-19 | Colombia | Putumayo | 14642 | 602 | 13713 | 327 | 0.436 | -75.5277 | 2021-07-20 04:21:48 | Putumayo, Colombia | ||
2673668 | 2673668 | 2021-07-18 | Colombia | Putumayo | 14642 | 601 | 13667 | 374 | 0.436 | -75.5277 | 2021-07-19 04:21:24 | Putumayo, Colombia | ||
3705980 | 3705980 | 2021-07-17 | Colombia | Putumayo | 14642 | 597 | 13638 | 407 | 0.436 | -75.5277 | 2021-07-18 04:22:07 | Putumayo, Colombia | ||
2947211 | 2947211 | 2021-07-16 | Colombia | Putumayo | 14561 | 597 | 13609 | 355 | 0.436 | -75.5277 | 2021-07-17 04:22:22 | Putumayo, Colombia | ||
295867 | 295867 | 2021-07-15 | Colombia | Putumayo | 14467 | 594 | 13561 | 312 | 0.436 | -75.5277 | 2021-07-16 04:21:22 | Putumayo, Colombia | ||
3631812 | 3631812 | 2021-07-14 | Colombia | Putumayo | 14411 | 593 | 13493 | 325 | 0.436 | -75.5277 | 2021-07-15 04:21:48 | Putumayo, Colombia | ||
578687 | 578687 | 2021-07-13 | Colombia | Putumayo | 14339 | 590 | 13471 | 278 | 0.436 | -75.5277 | 2021-07-14 04:21:35 | Putumayo, Colombia | ||
3740936 | 3740936 | 2021-07-12 | Colombia | Putumayo | 14170 | 585 | 13340 | 245 | 0.436 | -75.5277 | 2021-07-13 04:21:18 | Putumayo, Colombia | ||
3659449 | 3659449 | 2021-07-11 | Colombia | Putumayo | 14170 | 580 | 13123 | 467 | 0.436 | -75.5277 | 2021-07-12 04:21:34 | Putumayo, Colombia | ||
625733 | 625733 | 2021-07-10 | Colombia | Putumayo | 14130 | 580 | 13123 | 427 | 0.436 | -75.5277 | 2021-07-11 04:21:43 | Putumayo, Colombia | ||
829452 | 829452 | 2021-07-09 | Colombia | Putumayo | 14077 | 580 | 13017 | 480 | 0.436 | -75.5277 | 2021-07-10 04:21:25 | Putumayo, Colombia | ||
778216 | 778216 | 2021-07-08 | Colombia | Putumayo | 14041 | 575 | 13017 | 449 | 0.436 | -75.5277 | 2021-07-09 04:21:21 | Putumayo, Colombia | ||
1440438 | 1440438 | 2021-07-07 | Colombia | Putumayo | 14005 | 575 | 12959 | 471 | 0.436 | -75.5277 | 2021-07-08 04:21:26 | Putumayo, Colombia | ||
2693543 | 2693543 | 2021-07-06 | Colombia | Putumayo | 13956 | 570 | 12946 | 440 | 0.436 | -75.5277 | 2021-07-07 04:21:20 | Putumayo, Colombia | ||
1932292 | 1932292 | 2021-07-05 | Colombia | Putumayo | 13884 | 570 | 12858 | 456 | 0.436 | -75.5277 | 2021-07-06 04:21:32 | Putumayo, Colombia | ||
1165023 | 1165023 | 2021-07-04 | Colombia | Putumayo | 13814 | 568 | 12817 | 429 | 0.436 | -75.5277 | 2021-07-05 04:21:28 | Putumayo, Colombia | ||
1495457 | 1495457 | 2021-07-03 | Colombia | Putumayo | 13755 | 568 | 12755 | 432 | 0.436 | -75.5277 | 2021-07-04 04:21:38 | Putumayo, Colombia | ||
2071772 | 2071772 | 2021-07-02 | Colombia | Putumayo | 13696 | 568 | 12691 | 437 | 0.436 | -75.5277 | 2021-07-03 04:21:37 | Putumayo, Colombia | ||
2764788 | 2764788 | 2021-07-01 | Colombia | Putumayo | 13644 | 564 | 12654 | 426 | 0.436 | -75.5277 | 2021-07-02 04:21:47 | Putumayo, Colombia | ||
1892996 | 1892996 | 2021-06-30 | Colombia | Putumayo | 13575 | 563 | 12607 | 405 | 0.436 | -75.5277 | 2021-07-01 04:21:19 | Putumayo, Colombia | ||
400119 | 400119 | 2021-06-29 | Colombia | Putumayo | 13552 | 563 | 12575 | 414 | 0.436 | -75.5277 | 2021-06-30 04:21:41 | Putumayo, Colombia | ||
3125362 | 3125362 | 2021-06-28 | Colombia | Putumayo | 13496 | 563 | 12536 | 397 | 0.436 | -75.5277 | 2021-06-29 04:21:28 | Putumayo, Colombia | ||
2589857 | 2589857 | 2021-06-27 | Colombia | Putumayo | 13469 | 561 | 12461 | 447 | 0.436 | -75.5277 | 2021-06-28 04:21:29 | Putumayo, Colombia | ||
3958361 | 3958361 | 2021-06-26 | Colombia | Putumayo | 13387 | 558 | 12419 | 410 | 0.436 | -75.5277 | 2021-06-27 04:21:39 | Putumayo, Colombia | ||
1712180 | 1712180 | 2021-06-25 | Colombia | Putumayo | 13328 | 556 | 12376 | 396 | 0.436 | -75.5277 | 2021-06-26 04:21:43 | Putumayo, Colombia | ||
2295305 | 2295305 | 2021-06-24 | Colombia | Putumayo | 13264 | 554 | 12361 | 349 | 0.436 | -75.5277 | 2021-06-25 04:21:33 | Putumayo, Colombia | ||
2422745 | 2422745 | 2021-06-23 | Colombia | Putumayo | 13248 | 552 | 12259 | 437 | 0.436 | -75.5277 | 2021-06-24 04:21:55 | Putumayo, Colombia | ||
562822 | 562822 | 2021-06-22 | Colombia | Putumayo | 13165 | 552 | 12210 | 403 | 0.436 | -75.5277 | 2021-06-23 04:21:46 | Putumayo, Colombia | ||
3358524 | 3358524 | 2021-06-21 | Colombia | Putumayo | 13109 | 549 | 12133 | 427 | 0.436 | -75.5277 | 2021-06-22 04:21:34 | Putumayo, Colombia | ||
2884223 | 2884223 | 2021-06-20 | Colombia | Putumayo | 13057 | 546 | 12108 | 403 | 0.436 | -75.5277 | 2021-06-21 04:21:41 | Putumayo, Colombia | ||
107306 | 107306 | 2021-06-19 | Colombia | Putumayo | 12991 | 544 | 12076 | 371 | 0.436 | -75.5277 | 2021-06-20 04:21:48 | Putumayo, Colombia | ||
1125449 | 1125449 | 2021-06-18 | Colombia | Putumayo | 12966 | 541 | 12046 | 379 | 0.436 | -75.5277 | 2021-06-19 04:22:33 | Putumayo, Colombia | ||
2911027 | 2911027 | 2021-06-17 | Colombia | Putumayo | 12926 | 538 | 11968 | 420 | 0.436 | -75.5277 | 2021-06-18 04:22:16 | Putumayo, Colombia | ||
3030145 | 3030145 | 2021-06-16 | Colombia | Putumayo | 12749 | 535 | 11832 | 382 | 0.436 | -75.5277 | 2021-06-17 04:22:36 | Putumayo, Colombia | ||
2339251 | 2339251 | 2021-06-15 | Colombia | Putumayo | 12576 | 530 | 11769 | 277 | 0.436 | -75.5277 | 2021-06-16 04:22:32 | Putumayo, Colombia | ||
1563947 | 1563947 | 2021-06-14 | Colombia | Putumayo | 12576 | 530 | 11769 | 277 | 0.436 | -75.5277 | 2021-06-15 04:22:22 | Putumayo, Colombia | ||
3381230 | 3381230 | 2021-06-13 | Colombia | Putumayo | 12576 | 530 | 11732 | 314 | 0.436 | -75.5277 | 2021-06-14 04:22:46 | Putumayo, Colombia | ||
1736364 | 1736364 | 2021-06-12 | Colombia | Putumayo | 12576 | 530 | 11711 | 335 | 0.436 | -75.5277 | 2021-06-13 04:22:44 | Putumayo, Colombia | ||
3970405 | 3970405 | 2021-06-11 | Colombia | Putumayo | 12521 | 528 | 11697 | 296 | 0.436 | -75.5277 | 2021-06-12 04:22:22 | Putumayo, Colombia | ||
2716827 | 2716827 | 2021-06-10 | Colombia | Putumayo | 12478 | 527 | 11612 | 339 | 0.436 | -75.5277 | 2021-06-11 04:23:20 | Putumayo, Colombia | ||
522712 | 522712 | 2021-06-09 | Colombia | Putumayo | 12399 | 525 | 11569 | 305 | 0.436 | -75.5277 | 2021-06-10 04:23:17 | Putumayo, Colombia | ||
3472152 | 3472152 | 2021-06-08 | Colombia | Putumayo | 12336 | 520 | 11536 | 280 | 0.436 | -75.5277 | 2021-06-09 04:23:31 | Putumayo, Colombia | ||
3145436 | 3145436 | 2021-06-07 | Colombia | Putumayo | 12336 | 520 | 11536 | 280 | 0.436 | -75.5277 | 2021-06-08 04:22:35 | Putumayo, 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]);