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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069868 | 3069868 | 2021-11-23 | Colombia | Putumayo | 16867 | 680 | 0 | 0.436 | -75.5277 | 2021-11-24 04:22:14 | Putumayo, Colombia | |||
3748966 | 3748966 | 2021-11-22 | Colombia | Putumayo | 16807 | 679 | 0 | 0.436 | -75.5277 | 2021-11-23 04:22:39 | Putumayo, Colombia | |||
1014173 | 1014173 | 2021-11-21 | Colombia | Putumayo | 16807 | 678 | 0 | 0.436 | -75.5277 | 2021-11-22 04:22:20 | Putumayo, Colombia | |||
722337 | 722337 | 2021-11-20 | Colombia | Putumayo | 16781 | 677 | 0 | 0.436 | -75.5277 | 2021-11-21 04:22:13 | Putumayo, Colombia | |||
161867 | 161867 | 2021-11-19 | Colombia | Putumayo | 16755 | 677 | 0 | 0.436 | -75.5277 | 2021-11-20 04:22:17 | Putumayo, Colombia | |||
3288754 | 3288754 | 2021-11-18 | Colombia | Putumayo | 16751 | 677 | 0 | 0.436 | -75.5277 | 2021-11-19 04:21:40 | Putumayo, Colombia | |||
447210 | 447210 | 2021-11-17 | Colombia | Putumayo | 16747 | 677 | 0 | 0.436 | -75.5277 | 2021-11-18 04:21:33 | Putumayo, Colombia | |||
3342460 | 3342460 | 2021-11-16 | Colombia | Putumayo | 16712 | 677 | 0 | 0.436 | -75.5277 | 2021-11-17 04:21:48 | Putumayo, Colombia | |||
2287296 | 2287296 | 2021-11-15 | Colombia | Putumayo | 16700 | 677 | 0 | 0.436 | -75.5277 | 2021-11-16 04:21:10 | Putumayo, Colombia | |||
1322070 | 1322070 | 2021-11-14 | Colombia | Putumayo | 16686 | 677 | 0 | 0.436 | -75.5277 | 2021-11-15 04:21:36 | Putumayo, Colombia | |||
686196 | 686196 | 2021-11-13 | Colombia | Putumayo | 16672 | 676 | 0 | 0.436 | -75.5277 | 2021-11-14 04:21:31 | Putumayo, Colombia | |||
714305 | 714305 | 2021-11-12 | Colombia | Putumayo | 16643 | 676 | 0 | 0.436 | -75.5277 | 2021-11-13 04:21:38 | Putumayo, Colombia | |||
28255 | 28255 | 2021-11-11 | Colombia | Putumayo | 16632 | 676 | 0 | 0.436 | -75.5277 | 2021-11-12 04:22:01 | Putumayo, Colombia | |||
2844694 | 2844694 | 2021-11-10 | Colombia | Putumayo | 16619 | 676 | 0 | 0.436 | -75.5277 | 2021-11-11 04:21:45 | Putumayo, Colombia | |||
86964 | 86964 | 2021-11-09 | Colombia | Putumayo | 16615 | 675 | 0 | 0.436 | -75.5277 | 2021-11-10 04:21:38 | Putumayo, Colombia | |||
3639392 | 3639392 | 2021-11-08 | Colombia | Putumayo | 16586 | 675 | 0 | 0.436 | -75.5277 | 2021-11-09 04:21:36 | Putumayo, Colombia | |||
2000500 | 2000500 | 2021-11-07 | Colombia | Putumayo | 16573 | 675 | 0 | 0.436 | -75.5277 | 2021-11-08 04:21:43 | Putumayo, Colombia | |||
495491 | 495491 | 2021-11-06 | Colombia | Putumayo | 16561 | 675 | 0 | 0.436 | -75.5277 | 2021-11-07 04:21:53 | Putumayo, Colombia | |||
3121346 | 3121346 | 2021-11-05 | Colombia | Putumayo | 16549 | 675 | 0 | 0.436 | -75.5277 | 2021-11-06 04:21:51 | Putumayo, Colombia | |||
698244 | 698244 | 2021-11-04 | Colombia | Putumayo | 16534 | 674 | 0 | 0.436 | -75.5277 | 2021-11-05 04:21:54 | Putumayo, Colombia | |||
276022 | 276022 | 2021-11-03 | Colombia | Putumayo | 16530 | 673 | 0 | 0.436 | -75.5277 | 2021-11-04 04:22:20 | Putumayo, Colombia | |||
43547 | 43547 | 2021-11-02 | Colombia | Putumayo | 16515 | 672 | 0 | 0.436 | -75.5277 | 2021-11-03 06:22:09 | Putumayo, Colombia | |||
3511243 | 3511243 | 2021-11-01 | Colombia | Putumayo | 16500 | 672 | 0 | 0.436 | -75.5277 | 2021-11-02 04:22:03 | Putumayo, Colombia | |||
287835 | 287835 | 2021-10-31 | Colombia | Putumayo | 16490 | 672 | 0 | 0.436 | -75.5277 | 2021-11-01 04:22:01 | Putumayo, Colombia | |||
2720841 | 2720841 | 2021-10-30 | Colombia | Putumayo | 16480 | 672 | 0 | 0.436 | -75.5277 | 2021-10-31 04:22:08 | Putumayo, Colombia | |||
566943 | 566943 | 2021-10-29 | Colombia | Putumayo | 16467 | 671 | 0 | 0.436 | -75.5277 | 2021-10-30 04:22:03 | Putumayo, Colombia | |||
4185 | 4185 | 2021-10-28 | Colombia | Putumayo | 16453 | 671 | 0 | 0.436 | -75.5277 | 2021-10-29 04:22:03 | Putumayo, Colombia | |||
534575 | 534575 | 2021-10-27 | Colombia | Putumayo | 16440 | 671 | 0 | 0.436 | -75.5277 | 2021-10-28 04:22:08 | Putumayo, Colombia | |||
3492012 | 3492012 | 2021-10-26 | Colombia | Putumayo | 16421 | 671 | 0 | 0.436 | -75.5277 | 2021-10-27 04:22:32 | Putumayo, Colombia | |||
3793734 | 3793734 | 2021-10-25 | Colombia | Putumayo | 16419 | 670 | 0 | 0.436 | -75.5277 | 2021-10-26 04:22:09 | Putumayo, Colombia | |||
682180 | 682180 | 2021-10-24 | Colombia | Putumayo | 16415 | 670 | 0 | 0.436 | -75.5277 | 2021-10-25 04:22:31 | Putumayo, Colombia | |||
770188 | 770188 | 2021-10-23 | Colombia | Putumayo | 16402 | 670 | 0 | 0.436 | -75.5277 | 2021-10-24 04:21:22 | Putumayo, Colombia | |||
653835 | 653835 | 2021-10-22 | Colombia | Putumayo | 16398 | 670 | 0 | 0.436 | -75.5277 | 2021-10-23 04:21:32 | Putumayo, Colombia | |||
2123582 | 2123582 | 2021-10-21 | Colombia | Putumayo | 16388 | 670 | 0 | 0.436 | -75.5277 | 2021-10-22 04:21:14 | Putumayo, Colombia | |||
443194 | 443194 | 2021-10-20 | Colombia | Putumayo | 16384 | 670 | 0 | 0.436 | -75.5277 | 2021-10-21 04:21:18 | Putumayo, Colombia | |||
597513 | 597513 | 2021-10-19 | Colombia | Putumayo | 16380 | 669 | 0 | 0.436 | -75.5277 | 2021-10-20 04:21:00 | Putumayo, Colombia | |||
2043690 | 2043690 | 2021-10-18 | Colombia | Putumayo | 16376 | 669 | 0 | 0.436 | -75.5277 | 2021-10-19 04:20:54 | Putumayo, Colombia | |||
1909051 | 1909051 | 2021-10-17 | Colombia | Putumayo | 16373 | 669 | 0 | 0.436 | -75.5277 | 2021-10-18 04:21:10 | Putumayo, Colombia | |||
934640 | 934640 | 2021-10-16 | Colombia | Putumayo | 16369 | 668 | 0 | 0.436 | -75.5277 | 2021-10-17 04:21:29 | Putumayo, Colombia | |||
2943195 | 2943195 | 2021-10-15 | Colombia | Putumayo | 16363 | 668 | 0 | 0.436 | -75.5277 | 2021-10-16 04:21:15 | Putumayo, Colombia | |||
491475 | 491475 | 2021-10-14 | Colombia | Putumayo | 16350 | 668 | 0 | 0.436 | -75.5277 | 2021-10-15 04:21:26 | Putumayo, Colombia | |||
633763 | 633763 | 2021-10-13 | Colombia | Putumayo | 16345 | 668 | 0 | 0.436 | -75.5277 | 2021-10-14 04:21:29 | Putumayo, Colombia | |||
1491441 | 1491441 | 2021-10-12 | Colombia | Putumayo | 16342 | 668 | 0 | 0.436 | -75.5277 | 2021-10-13 04:20:51 | Putumayo, Colombia | |||
3007174 | 3007174 | 2021-10-11 | Colombia | Putumayo | 16336 | 668 | 0 | 0.436 | -75.5277 | 2021-10-12 04:21:09 | Putumayo, Colombia | |||
423190 | 423190 | 2021-10-10 | Colombia | Putumayo | 16328 | 668 | 0 | 0.436 | -75.5277 | 2021-10-11 04:21:31 | Putumayo, Colombia | |||
2876047 | 2876047 | 2021-10-09 | Colombia | Putumayo | 16323 | 668 | 0 | 0.436 | -75.5277 | 2021-10-10 04:21:38 | Putumayo, Colombia | |||
2959213 | 2959213 | 2021-10-08 | Colombia | Putumayo | 16313 | 668 | 0 | 0.436 | -75.5277 | 2021-10-09 04:21:34 | Putumayo, Colombia | |||
467251 | 467251 | 2021-10-07 | Colombia | Putumayo | 16305 | 668 | 0 | 0.436 | -75.5277 | 2021-10-08 04:21:25 | Putumayo, Colombia | |||
2458631 | 2458631 | 2021-10-06 | Colombia | Putumayo | 16298 | 668 | 0 | 0.436 | -75.5277 | 2021-10-07 04:21:36 | Putumayo, Colombia | |||
3832325 | 3832325 | 2021-10-05 | Colombia | Putumayo | 16290 | 668 | 0 | 0.436 | -75.5277 | 2021-10-06 04:21:33 | Putumayo, Colombia | |||
986818 | 986818 | 2021-10-04 | Colombia | Putumayo | 16289 | 668 | 0 | 0.436 | -75.5277 | 2021-10-05 04:21:27 | Putumayo, Colombia | |||
1274128 | 1274128 | 2021-10-03 | Colombia | Putumayo | 16286 | 668 | 0 | 0.436 | -75.5277 | 2021-10-04 04:21:31 | Putumayo, Colombia | |||
3927881 | 3927881 | 2021-10-02 | Colombia | Putumayo | 16282 | 668 | 0 | 0.436 | -75.5277 | 2021-10-03 04:21:24 | Putumayo, Colombia | |||
2131861 | 2131861 | 2021-10-01 | Colombia | Putumayo | 16276 | 667 | 0 | 0.436 | -75.5277 | 2021-10-02 04:21:25 | Putumayo, Colombia | |||
2772818 | 2772818 | 2021-09-30 | Colombia | Putumayo | 16262 | 667 | 0 | 0.436 | -75.5277 | 2021-10-01 04:21:35 | Putumayo, Colombia | |||
706274 | 706274 | 2021-09-29 | Colombia | Putumayo | 16261 | 666 | 0 | 0.436 | -75.5277 | 2021-09-30 04:21:20 | Putumayo, Colombia | |||
1334116 | 1334116 | 2021-09-28 | Colombia | Putumayo | 16257 | 666 | 0 | 0.436 | -75.5277 | 2021-09-29 04:21:45 | Putumayo, Colombia | |||
1235485 | 1235485 | 2021-09-27 | Colombia | Putumayo | 16243 | 666 | 0 | 0.436 | -75.5277 | 2021-09-28 04:21:28 | Putumayo, Colombia | |||
2075786 | 2075786 | 2021-09-26 | Colombia | Putumayo | 16243 | 666 | 0 | 0.436 | -75.5277 | 2021-09-27 04:21:16 | Putumayo, Colombia | |||
1724338 | 1724338 | 2021-09-25 | Colombia | Putumayo | 16238 | 665 | 0 | 0.436 | -75.5277 | 2021-09-26 04:21:29 | Putumayo, Colombia | |||
1921058 | 1921058 | 2021-09-24 | Colombia | Putumayo | 16233 | 665 | 0 | 0.436 | -75.5277 | 2021-09-25 04:21:31 | Putumayo, Colombia | |||
601529 | 601529 | 2021-09-23 | Colombia | Putumayo | 16227 | 665 | 0 | 0.436 | -75.5277 | 2021-09-24 04:21:44 | Putumayo, Colombia | |||
3011190 | 3011190 | 2021-09-22 | Colombia | Putumayo | 16213 | 665 | 0 | 0.436 | -75.5277 | 2021-09-23 04:21:43 | Putumayo, Colombia | |||
3757328 | 3757328 | 2021-09-21 | Colombia | Putumayo | 16205 | 665 | 0 | 0.436 | -75.5277 | 2021-09-22 04:21:45 | Putumayo, Colombia | |||
809431 | 809431 | 2021-09-20 | Colombia | Putumayo | 16204 | 665 | 0 | 0.436 | -75.5277 | 2021-09-21 04:21:26 | Putumayo, Colombia | |||
1814630 | 1814630 | 2021-09-19 | Colombia | Putumayo | 16201 | 665 | 0 | 0.436 | -75.5277 | 2021-09-20 04:21:22 | Putumayo, Colombia | |||
16210 | 16210 | 2021-09-18 | Colombia | Putumayo | 16191 | 665 | 0 | 0.436 | -75.5277 | 2021-09-19 04:21:34 | Putumayo, Colombia | |||
2617895 | 2617895 | 2021-09-17 | Colombia | Putumayo | 16188 | 665 | 0 | 0.436 | -75.5277 | 2021-09-18 04:21:24 | Putumayo, Colombia | |||
2808603 | 2808603 | 2021-09-16 | Colombia | Putumayo | 16177 | 665 | 0 | 0.436 | -75.5277 | 2021-09-17 04:21:46 | Putumayo, Colombia | |||
1374348 | 1374348 | 2021-09-15 | Colombia | Putumayo | 16168 | 665 | 0 | 0.436 | -75.5277 | 2021-09-16 04:22:19 | Putumayo, Colombia | |||
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 |
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]);