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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1089925 | 1089925 | 2021-03-03 | Colombia | La Guajira | 16243 | 637 | 15338 | 268 | 11.3548 | -72.5205 | 2021-03-04 05:24:24 | La Guajira, Colombia | ||
3253997 | 3253997 | 2021-03-02 | Colombia | La Guajira | 16206 | 637 | 15289 | 280 | 11.3548 | -72.5205 | 2021-03-03 05:23:28 | La Guajira, Colombia | ||
998289 | 998289 | 2021-03-01 | Colombia | La Guajira | 16162 | 636 | 15262 | 264 | 11.3548 | -72.5205 | 2021-03-02 05:23:30 | La Guajira, Colombia | ||
2367347 | 2367347 | 2021-02-28 | Colombia | La Guajira | 16139 | 635 | 15258 | 246 | 11.3548 | -72.5205 | 2021-03-01 05:23:01 | La Guajira, Colombia | ||
3065849 | 3065849 | 2021-02-27 | Colombia | La Guajira | 16131 | 634 | 15253 | 244 | 11.3548 | -72.5205 | 2021-02-28 05:22:20 | La Guajira, Colombia | ||
2183433 | 2183433 | 2021-02-26 | Colombia | La Guajira | 16119 | 634 | 15247 | 238 | 11.3548 | -72.5205 | 2021-02-27 05:22:28 | La Guajira, Colombia | ||
1857855 | 1857855 | 2021-02-25 | Colombia | La Guajira | 16110 | 633 | 15244 | 233 | 11.3548 | -72.5205 | 2021-02-26 05:22:40 | La Guajira, Colombia | ||
280033 | 280033 | 2021-02-24 | Colombia | La Guajira | 16096 | 633 | 15239 | 224 | 11.3548 | -72.5205 | 2021-02-25 05:24:57 | La Guajira, Colombia | ||
1936301 | 1936301 | 2021-02-23 | Colombia | La Guajira | 16085 | 632 | 15235 | 218 | 11.3548 | -72.5205 | 2021-02-24 05:29:16 | La Guajira, Colombia | ||
530556 | 530556 | 2021-02-22 | Colombia | La Guajira | 16082 | 631 | 15231 | 220 | 11.3548 | -72.5205 | 2021-02-23 05:23:41 | La Guajira, Colombia | ||
181890 | 181890 | 2021-02-21 | Colombia | La Guajira | 16081 | 631 | 15224 | 226 | 11.3548 | -72.5205 | 2021-02-22 05:24:21 | La Guajira, Colombia | ||
742164 | 742164 | 2021-02-20 | Colombia | La Guajira | 16071 | 630 | 15212 | 229 | 11.3548 | -72.5205 | 2021-02-21 05:24:33 | La Guajira, Colombia | ||
471262 | 471262 | 2021-02-19 | Colombia | La Guajira | 16058 | 630 | 15188 | 240 | 11.3548 | -72.5205 | 2021-02-20 05:22:51 | La Guajira, Colombia | ||
1152971 | 1152971 | 2021-02-18 | Colombia | La Guajira | 16032 | 630 | 15182 | 220 | 11.3548 | -72.5205 | 2021-02-19 05:24:16 | La Guajira, Colombia | ||
3600891 | 3600891 | 2021-02-17 | Colombia | La Guajira | 16026 | 628 | 15178 | 220 | 11.3548 | -72.5205 | 2021-02-18 05:22:58 | La Guajira, Colombia | ||
3050026 | 3050026 | 2021-02-16 | Colombia | La Guajira | 16022 | 627 | 15167 | 228 | 11.3548 | -72.5205 | 2021-02-17 05:23:10 | La Guajira, Colombia | ||
1338125 | 1338125 | 2021-02-15 | Colombia | La Guajira | 16020 | 627 | 15164 | 229 | 11.3548 | -72.5205 | 2021-02-16 05:24:38 | La Guajira, Colombia | ||
2283276 | 2283276 | 2021-02-14 | Colombia | La Guajira | 16019 | 625 | 15146 | 248 | 11.3548 | -72.5205 | 2021-02-15 05:24:49 | La Guajira, Colombia | ||
2677676 | 2677676 | 2021-02-13 | Colombia | La Guajira | 16012 | 623 | 15131 | 258 | 11.3548 | -72.5205 | 2021-02-14 05:23:43 | La Guajira, Colombia | ||
3539309 | 3539309 | 2021-02-12 | Colombia | La Guajira | 15995 | 622 | 15110 | 263 | 11.3548 | -72.5205 | 2021-02-13 05:22:12 | La Guajira, Colombia | ||
2637572 | 2637572 | 2021-02-11 | Colombia | La Guajira | 15965 | 621 | 15093 | 251 | 11.3548 | -72.5205 | 2021-02-12 05:23:29 | La Guajira, Colombia | ||
3978427 | 3978427 | 2021-02-10 | Colombia | La Guajira | 15951 | 615 | 15026 | 310 | 11.3548 | -72.5205 | 2021-02-11 05:23:55 | La Guajira, Colombia | ||
1527747 | 1527747 | 2021-02-09 | Colombia | La Guajira | 15905 | 614 | 15010 | 281 | 11.3548 | -72.5205 | 2021-02-10 05:22:41 | La Guajira, Colombia | ||
613538 | 613538 | 2021-02-08 | Colombia | La Guajira | 15888 | 611 | 14981 | 296 | 11.3548 | -72.5205 | 2021-02-09 05:23:30 | La Guajira, Colombia | ||
1672307 | 1672307 | 2021-02-07 | Colombia | La Guajira | 15872 | 608 | 14935 | 329 | 11.3548 | -72.5205 | 2021-02-08 05:22:39 | La Guajira, Colombia | ||
974768 | 974768 | 2021-02-06 | Colombia | La Guajira | 15850 | 605 | 14932 | 313 | 11.3548 | -72.5205 | 2021-02-07 05:23:00 | La Guajira, Colombia | ||
1588026 | 1588026 | 2021-02-05 | Colombia | La Guajira | 15824 | 604 | 14913 | 307 | 11.3548 | -72.5205 | 2021-02-06 05:23:55 | La Guajira, Colombia | ||
790233 | 790233 | 2021-02-04 | Colombia | La Guajira | 15793 | 603 | 14859 | 331 | 11.3548 | -72.5205 | 2021-02-05 05:22:38 | La Guajira, Colombia | ||
340125 | 340125 | 2021-02-03 | Colombia | La Guajira | 15742 | 601 | 14794 | 347 | 11.3548 | -72.5205 | 2021-02-04 05:22:26 | La Guajira, Colombia | ||
1684351 | 1684351 | 2021-02-02 | Colombia | La Guajira | 15672 | 599 | 14715 | 358 | 11.3548 | -72.5205 | 2021-02-03 05:22:52 | La Guajira, Colombia | ||
1676321 | 1676321 | 2021-02-01 | Colombia | La Guajira | 15616 | 598 | 14681 | 337 | 11.3548 | -72.5205 | 2021-02-02 05:22:49 | La Guajira, Colombia | ||
1459609 | 1459609 | 2021-01-31 | Colombia | La Guajira | 15595 | 597 | 14648 | 350 | 11.3548 | -72.5205 | 2021-02-01 05:22:53 | La Guajira, Colombia | ||
2211517 | 2211517 | 2021-01-30 | Colombia | La Guajira | 15583 | 595 | 14625 | 363 | 11.3548 | -72.5205 | 2021-01-31 05:22:42 | La Guajira, Colombia | ||
1897004 | 1897004 | 2021-01-29 | Colombia | La Guajira | 15566 | 592 | 14573 | 401 | 11.3548 | -72.5205 | 2021-01-30 05:22:49 | La Guajira, Colombia | ||
2481820 | 2481820 | 2021-01-28 | Colombia | La Guajira | 15525 | 591 | 14528 | 406 | 11.3548 | -72.5205 | 2021-01-29 05:22:23 | La Guajira, Colombia | ||
3153455 | 3153455 | 2021-01-27 | Colombia | La Guajira | 15499 | 590 | 14479 | 430 | 11.3548 | -72.5205 | 2021-01-28 05:22:24 | La Guajira, Colombia | ||
12190 | 12190 | 2021-01-26 | Colombia | La Guajira | 15353 | 590 | 14334 | 429 | 11.3548 | -72.5205 | 2021-01-27 05:23:41 | La Guajira, Colombia | ||
2567514 | 2567514 | 2021-01-25 | Colombia | La Guajira | 15353 | 590 | 14334 | 429 | 11.3548 | -72.5205 | 2021-01-26 05:22:02 | La Guajira, Colombia | ||
1759146 | 1759146 | 2021-01-24 | Colombia | La Guajira | 15322 | 584 | 14288 | 450 | 11.3548 | -72.5205 | 2021-01-25 05:22:16 | La Guajira, Colombia | ||
2426753 | 2426753 | 2021-01-23 | Colombia | La Guajira | 15274 | 583 | 14259 | 432 | 11.3548 | -72.5205 | 2021-01-24 05:22:35 | La Guajira, Colombia | ||
2466655 | 2466655 | 2021-01-22 | Colombia | La Guajira | 15242 | 582 | 14260 | 400 | 11.3548 | -72.5205 | 2021-01-23 05:22:03 | La Guajira, Colombia | ||
435206 | 435206 | 2021-01-21 | Colombia | La Guajira | 15222 | 580 | 14234 | 408 | 11.3548 | -72.5205 | 2021-01-22 05:22:10 | La Guajira, Colombia | ||
1093938 | 1093938 | 2021-01-20 | Colombia | La Guajira | 15153 | 580 | 14176 | 397 | 11.3548 | -72.5205 | 2021-01-21 05:22:01 | La Guajira, Colombia | ||
908028 | 908028 | 2021-01-19 | Colombia | La Guajira | 15085 | 578 | 14152 | 355 | 11.3548 | -72.5205 | 2021-01-20 05:21:54 | La Guajira, Colombia | ||
237091 | 237091 | 2021-01-18 | Colombia | La Guajira | 15072 | 576 | 14071 | 425 | 11.3548 | -72.5205 | 2021-01-19 05:22:15 | La Guajira, Colombia | ||
3503208 | 3503208 | 2021-01-17 | Colombia | La Guajira | 15019 | 574 | 13856 | 589 | 11.3548 | -72.5205 | 2021-01-18 05:22:34 | La Guajira, Colombia | ||
3101291 | 3101291 | 2021-01-16 | Colombia | La Guajira | 14932 | 572 | 13845 | 515 | 11.3548 | -72.5205 | 2021-01-17 05:22:17 | La Guajira, Colombia | ||
3515253 | 3515253 | 2021-01-15 | Colombia | La Guajira | 14852 | 571 | 13833 | 448 | 11.3548 | -72.5205 | 2021-01-16 05:22:40 | La Guajira, Colombia | ||
3879426 | 3879426 | 2021-01-14 | Colombia | La Guajira | 14798 | 568 | 13799 | 431 | 11.3548 | -72.5205 | 2021-01-15 05:22:24 | La Guajira, Colombia | ||
3308053 | 3308053 | 2021-01-13 | Colombia | La Guajira | 14753 | 567 | 13768 | 418 | 11.3548 | -72.5205 | 2021-01-14 05:22:32 | La Guajira, Colombia | ||
774198 | 774198 | 2021-01-12 | Colombia | La Guajira | 14699 | 565 | 13627 | 507 | 11.3548 | -72.5205 | 2021-01-13 05:22:15 | La Guajira, Colombia | ||
189919 | 189919 | 2021-01-11 | Colombia | La Guajira | 14646 | 562 | 13548 | 536 | 11.3548 | -72.5205 | 2021-01-12 05:22:15 | La Guajira, Colombia | ||
2625722 | 2625722 | 2021-01-10 | Colombia | La Guajira | 14599 | 558 | 13508 | 533 | 11.3548 | -72.5205 | 2021-01-11 05:21:50 | La Guajira, Colombia | ||
3899810 | 3899810 | 2021-01-09 | Colombia | La Guajira | 14548 | 558 | 13474 | 516 | 11.3548 | -72.5205 | 2021-01-10 05:22:12 | La Guajira, Colombia | ||
153833 | 153833 | 2021-01-08 | Colombia | La Guajira | 14511 | 556 | 13425 | 530 | 11.3548 | -72.5205 | 2021-01-09 05:22:18 | La Guajira, Colombia | ||
2541257 | 2541257 | 2021-01-07 | Colombia | La Guajira | 14447 | 551 | 13348 | 548 | 11.3548 | -72.5205 | 2021-01-08 05:22:42 | La Guajira, Colombia | ||
2864566 | 2864566 | 2021-01-06 | Colombia | La Guajira | 14372 | 548 | 13323 | 501 | 11.3548 | -72.5205 | 2021-01-07 05:22:03 | La Guajira, Colombia | ||
3034153 | 3034153 | 2021-01-05 | Colombia | La Guajira | 14339 | 548 | 13290 | 501 | 11.3548 | -72.5205 | 2021-01-06 05:22:16 | La Guajira, Colombia | ||
1061698 | 1061698 | 2021-01-04 | Colombia | La Guajira | 14290 | 547 | 13269 | 474 | 11.3548 | -72.5205 | 2021-01-05 05:21:49 | La Guajira, Colombia | ||
3230301 | 3230301 | 2021-01-03 | Colombia | La Guajira | 14288 | 547 | 13231 | 510 | 11.3548 | -72.5205 | 2021-01-04 05:22:02 | La Guajira, Colombia | ||
2227371 | 2227371 | 2021-01-02 | Colombia | La Guajira | 14284 | 547 | 13156 | 581 | 11.3548 | -72.5205 | 2021-01-03 05:22:52 | La Guajira, Colombia | ||
1136735 | 1136735 | 2021-01-01 | Colombia | La Guajira | 14217 | 545 | 13119 | 553 | 11.3548 | -72.5205 | 2021-01-02 05:22:33 | La Guajira, Colombia | ||
3695341 | 3695341 | 2020-12-31 | Colombia | La Guajira | 14153 | 541 | 13084 | 528 | 11.3548 | -72.5205 | 2021-01-01 05:23:07 | La Guajira, Colombia | ||
1010156 | 1010156 | 2020-12-30 | Colombia | La Guajira | 14094 | 540 | 13035 | 519 | 11.3548 | -72.5205 | 2020-12-31 05:22:49 | La Guajira, Colombia | ||
766171 | 766171 | 2020-12-29 | Colombia | La Guajira | 14023 | 540 | 12980 | 503 | 11.3548 | -72.5205 | 2020-12-30 05:22:34 | La Guajira, Colombia | ||
3761435 | 3761435 | 2020-12-28 | Colombia | La Guajira | 14009 | 540 | 12915 | 554 | 11.3548 | -72.5205 | 2020-12-29 05:22:37 | La Guajira, Colombia | ||
3777755 | 3777755 | 2020-12-27 | Colombia | La Guajira | 13938 | 536 | 12865 | 537 | 11.3548 | -72.5205 | 2020-12-28 05:22:06 | La Guajira, Colombia | ||
2223360 | 2223360 | 2020-12-26 | Colombia | La Guajira | 13916 | 536 | 12787 | 593 | 11.3548 | -72.5205 | 2020-12-27 05:22:55 | La Guajira, Colombia | ||
202107 | 202107 | 2020-12-25 | Colombia | La Guajira | 13860 | 533 | 12698 | 629 | 11.3548 | -72.5205 | 2020-12-26 05:22:28 | La Guajira, Colombia | ||
3691330 | 3691330 | 2020-12-24 | Colombia | La Guajira | 13767 | 533 | 12614 | 620 | 11.3548 | -72.5205 | 2020-12-25 05:22:48 | La Guajira, Colombia | ||
2406682 | 2406682 | 2020-12-23 | Colombia | La Guajira | 13671 | 531 | 12546 | 594 | 11.3548 | -72.5205 | 2020-12-24 05:23:04 | La Guajira, Colombia | ||
3769728 | 3769728 | 2020-12-22 | Colombia | La Guajira | 13614 | 529 | 12462 | 623 | 11.3548 | -72.5205 | 2020-12-23 05:22:03 | La Guajira, Colombia | ||
927544 | 927544 | 2020-12-21 | Colombia | La Guajira | 13502 | 528 | 12362 | 612 | 11.3548 | -72.5205 | 2020-12-22 05:22:33 | La Guajira, Colombia | ||
2119565 | 2119565 | 2020-12-20 | Colombia | La Guajira | 13399 | 523 | 12299 | 577 | 11.3548 | -72.5205 | 2020-12-21 05:27:58 | La Guajira, Colombia | ||
2931072 | 2931072 | 2020-12-19 | Colombia | La Guajira | 13330 | 520 | 12216 | 594 | 11.3548 | -72.5205 | 2020-12-20 05:27:32 | La Guajira, Colombia | ||
1901018 | 1901018 | 2020-12-18 | Colombia | La Guajira | 13184 | 518 | 12126 | 540 | 11.3548 | -72.5205 | 2020-12-19 05:27:52 | La Guajira, Colombia | ||
2127844 | 2127844 | 2020-12-17 | Colombia | La Guajira | 13087 | 515 | 12058 | 514 | 11.3548 | -72.5205 | 2020-12-18 05:28:18 | La Guajira, Colombia | ||
3149444 | 3149444 | 2020-12-16 | Colombia | La Guajira | 13043 | 514 | 11997 | 532 | 11.3548 | -72.5205 | 2020-12-17 05:28:12 | La Guajira, Colombia | ||
1034225 | 1034225 | 2020-12-15 | Colombia | La Guajira | 12944 | 513 | 11933 | 498 | 11.3548 | -72.5205 | 2020-12-16 05:28:04 | La Guajira, Colombia | ||
1751119 | 1751119 | 2020-12-14 | Colombia | La Guajira | 12882 | 508 | 11904 | 470 | 11.3548 | -72.5205 | 2020-12-15 05:26:38 | La Guajira, Colombia | ||
3847639 | 3847639 | 2020-12-13 | Colombia | La Guajira | 12842 | 505 | 11850 | 487 | 11.3548 | -72.5205 | 2020-12-14 05:26:27 | La Guajira, Colombia | ||
845421 | 845421 | 2020-12-12 | Colombia | La Guajira | 12787 | 503 | 11842 | 442 | 11.3548 | -72.5205 | 2020-12-13 05:27:20 | La Guajira, Colombia | ||
860528 | 860528 | 2020-12-11 | Colombia | La Guajira | 12755 | 502 | 11790 | 463 | 11.3548 | -72.5205 | 2020-12-12 05:26:19 | La Guajira, Colombia | ||
1600070 | 1600070 | 2020-12-10 | Colombia | La Guajira | 12645 | 502 | 11754 | 389 | 11.3548 | -72.5205 | 2020-12-11 05:26:59 | La Guajira, Colombia | ||
2975079 | 2975079 | 2020-12-09 | Colombia | La Guajira | 12615 | 498 | 11651 | 466 | 11.3548 | -72.5205 | 2020-12-10 05:26:19 | La Guajira, Colombia | ||
1818639 | 1818639 | 2020-12-08 | Colombia | La Guajira | 12520 | 495 | 11634 | 391 | 11.3548 | -72.5205 | 2020-12-09 05:28:01 | La Guajira, Colombia | ||
2347275 | 2347275 | 2020-12-07 | Colombia | La Guajira | 12496 | 493 | 11554 | 449 | 11.3548 | -72.5205 | 2020-12-08 05:27:42 | La Guajira, Colombia | ||
1006145 | 1006145 | 2020-12-06 | Colombia | La Guajira | 12456 | 491 | 11460 | 505 | 11.3548 | -72.5205 | 2020-12-07 05:26:14 | La Guajira, Colombia | ||
1632154 | 1632154 | 2020-12-05 | Colombia | La Guajira | 12357 | 482 | 11368 | 507 | 11.3548 | -72.5205 | 2020-12-06 05:26:18 | La Guajira, Colombia | ||
3859682 | 3859682 | 2020-12-04 | Colombia | La Guajira | 12277 | 481 | 11253 | 543 | 11.3548 | -72.5205 | 2020-12-05 05:27:36 | La Guajira, Colombia | ||
74940 | 74940 | 2020-12-03 | Colombia | La Guajira | 12159 | 476 | 11193 | 490 | 11.3548 | -72.5205 | 2020-12-04 05:27:27 | La Guajira, Colombia | ||
738152 | 738152 | 2020-12-02 | Colombia | La Guajira | 12094 | 473 | 11081 | 540 | 11.3548 | -72.5205 | 2020-12-03 05:28:22 | La Guajira, Colombia | ||
2537246 | 2537246 | 2020-12-01 | Colombia | La Guajira | 11984 | 469 | 11004 | 511 | 11.3548 | -72.5205 | 2020-12-02 05:27:41 | La Guajira, Colombia | ||
1584015 | 1584015 | 2020-11-30 | Colombia | La Guajira | 11923 | 467 | 10937 | 519 | 11.3548 | -72.5205 | 2020-12-01 05:26:18 | La Guajira, Colombia | ||
3566418 | 3566418 | 2020-11-29 | Colombia | La Guajira | 11849 | 457 | 10858 | 534 | 11.3548 | -72.5205 | 2020-11-30 05:26:13 | La Guajira, Colombia | ||
2935083 | 2935083 | 2020-11-28 | Colombia | La Guajira | 11758 | 456 | 10760 | 542 | 11.3548 | -72.5205 | 2020-11-29 05:25:55 | La Guajira, Colombia | ||
392086 | 392086 | 2020-11-27 | Colombia | La Guajira | 11662 | 454 | 10678 | 530 | 11.3548 | -72.5205 | 2020-11-28 05:25:50 | La Guajira, Colombia | ||
923533 | 923533 | 2020-11-26 | Colombia | La Guajira | 11601 | 449 | 10632 | 520 | 11.3548 | -72.5205 | 2020-11-27 05:26:53 | La Guajira, Colombia | ||
1972438 | 1972438 | 2020-11-25 | Colombia | La Guajira | 11523 | 447 | 10591 | 485 | 11.3548 | -72.5205 | 2020-11-26 05:27:44 | La Guajira, Colombia | ||
1350169 | 1350169 | 2020-11-24 | Colombia | La Guajira | 11393 | 446 | 10570 | 377 | 11.3548 | -72.5205 | 2020-11-25 05:27:20 | 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]);