daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "La Guajira" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-05 | Colombia | La Guajira | 5673 | 247 | 4091 | 1335 | 11.3548 | -72.5205 | 2020-09-06 04:28:33 | La Guajira, Colombia | ||
2020-09-06 | Colombia | La Guajira | 5884 | 248 | 4378 | 1258 | 11.3548 | -72.5205 | 2020-09-07 04:28:30 | La Guajira, Colombia | ||
2020-09-07 | Colombia | La Guajira | 5884 | 248 | 4378 | 1258 | 11.3548 | -72.5205 | 2020-09-08 04:28:25 | La Guajira, Colombia | ||
2020-09-08 | Colombia | La Guajira | 5934 | 249 | 4542 | 1143 | 11.3548 | -72.5205 | 2020-09-09 04:28:48 | La Guajira, Colombia | ||
2020-09-09 | Colombia | La Guajira | 6227 | 255 | 4761 | 1211 | 11.3548 | -72.5205 | 2020-09-10 04:29:01 | La Guajira, Colombia | ||
2020-09-10 | Colombia | La Guajira | 6328 | 256 | 4992 | 1080 | 11.3548 | -72.5205 | 2020-09-11 04:46:23 | La Guajira, Colombia | ||
2020-09-11 | Colombia | La Guajira | 6438 | 257 | 5190 | 991 | 11.3548 | -72.5205 | 2020-09-12 04:25:05 | La Guajira, Colombia | ||
2020-09-12 | Colombia | La Guajira | 6510 | 259 | 5276 | 975 | 11.3548 | -72.5205 | 2020-09-13 04:30:52 | La Guajira, Colombia | ||
2020-09-13 | Colombia | La Guajira | 6640 | 264 | 5388 | 988 | 11.3548 | -72.5205 | 2020-09-14 04:26:00 | La Guajira, Colombia | ||
2020-09-14 | Colombia | La Guajira | 6676 | 268 | 5439 | 969 | 11.3548 | -72.5205 | 2020-09-15 03:22:50 | La Guajira, Colombia | ||
2020-09-15 | Colombia | La Guajira | 6864 | 268 | 5448 | 1148 | 11.3548 | -72.5205 | 2020-09-16 04:22:53 | La Guajira, Colombia | ||
2020-09-16 | Colombia | La Guajira | 6991 | 271 | 5474 | 1246 | 11.3548 | -72.5205 | 2020-09-17 04:22:00 | La Guajira, Colombia | ||
2020-09-17 | Colombia | La Guajira | 7057 | 272 | 5575 | 1210 | 11.3548 | -72.5205 | 2020-09-18 05:05:00 | La Guajira, Colombia | ||
2020-09-18 | Colombia | La Guajira | 7106 | 272 | 5575 | 1259 | 11.3548 | -72.5205 | 2020-09-19 04:22:00 | La Guajira, Colombia | ||
2020-09-19 | Colombia | La Guajira | 7207 | 275 | 5698 | 1234 | 11.3548 | -72.5205 | 2020-09-20 04:22:00 | La Guajira, Colombia | ||
2020-09-20 | Colombia | La Guajira | 7397 | 278 | 5807 | 1312 | 11.3548 | -72.5205 | 2020-09-21 04:23:00 | La Guajira, Colombia | ||
2020-09-21 | Colombia | La Guajira | 7479 | 282 | 5905 | 1292 | 11.3548 | -72.5205 | 2020-09-22 04:23:00 | La Guajira, Colombia | ||
2020-09-22 | Colombia | La Guajira | 7529 | 282 | 5905 | 1342 | 11.3548 | -72.5205 | 2020-09-23 04:23:00 | La Guajira, Colombia | ||
2020-09-23 | Colombia | La Guajira | 7609 | 286 | 6181 | 1142 | 11.3548 | -72.5205 | 2020-09-24 04:23:00 | La Guajira, Colombia | ||
2020-09-24 | Colombia | La Guajira | 7689 | 289 | 6373 | 1027 | 11.3548 | -72.5205 | 2020-09-25 04:23:00 | La Guajira, Colombia | ||
2020-09-25 | Colombia | La Guajira | 7771 | 291 | 6543 | 937 | 11.3548 | -72.5205 | 2020-09-26 04:23:00 | La Guajira, Colombia | ||
2020-09-26 | Colombia | La Guajira | 7912 | 292 | 6779 | 841 | 11.3548 | -72.5205 | 2020-09-27 04:23:00 | La Guajira, Colombia | ||
2020-09-27 | Colombia | La Guajira | 7987 | 297 | 6937 | 753 | 11.3548 | -72.5205 | 2020-09-28 04:23:00 | La Guajira, Colombia | ||
2020-09-28 | Colombia | La Guajira | 8032 | 300 | 7070 | 662 | 11.3548 | -72.5205 | 2020-09-29 04:23:42 | La Guajira, Colombia | ||
2020-09-29 | Colombia | La Guajira | 8105 | 302 | 7268 | 535 | 11.3548 | -72.5205 | 2020-09-30 04:23:33 | La Guajira, Colombia | ||
2020-09-30 | Colombia | La Guajira | 8136 | 307 | 7373 | 456 | 11.3548 | -72.5205 | 2020-10-01 04:23:42 | La Guajira, Colombia | ||
2020-10-01 | Colombia | La Guajira | 8161 | 309 | 7425 | 427 | 11.3548 | -72.5205 | 2020-10-02 04:23:51 | La Guajira, Colombia | ||
2020-10-02 | Colombia | La Guajira | 8230 | 314 | 7443 | 473 | 11.3548 | -72.5205 | 2020-10-03 04:23:40 | La Guajira, Colombia | ||
2020-10-03 | Colombia | La Guajira | 8280 | 318 | 7481 | 481 | 11.3548 | -72.5205 | 2020-10-04 04:23:44 | La Guajira, Colombia | ||
2020-10-04 | Colombia | La Guajira | 8316 | 322 | 7522 | 472 | 11.3548 | -72.5205 | 2020-10-05 04:23:33 | La Guajira, Colombia | ||
2020-10-05 | Colombia | La Guajira | 8432 | 326 | 7535 | 571 | 11.3548 | -72.5205 | 2020-10-06 04:23:33 | La Guajira, Colombia | ||
2020-10-06 | Colombia | La Guajira | 8464 | 331 | 7533 | 600 | 11.3548 | -72.5205 | 2020-10-07 04:23:40 | La Guajira, Colombia | ||
2020-10-07 | Colombia | La Guajira | 8562 | 335 | 7539 | 688 | 11.3548 | -72.5205 | 2020-10-08 04:23:56 | La Guajira, Colombia | ||
2020-10-08 | Colombia | La Guajira | 8654 | 335 | 7539 | 780 | 11.3548 | -72.5205 | 2020-10-09 04:23:59 | La Guajira, Colombia | ||
2020-10-09 | Colombia | La Guajira | 8701 | 337 | 7547 | 817 | 11.3548 | -72.5205 | 2020-10-10 04:23:57 | La Guajira, Colombia | ||
2020-10-10 | Colombia | La Guajira | 8759 | 345 | 7582 | 832 | 11.3548 | -72.5205 | 2020-10-11 04:23:46 | La Guajira, Colombia | ||
2020-10-11 | Colombia | La Guajira | 8855 | 345 | 7582 | 928 | 11.3548 | -72.5205 | 2020-10-12 04:23:45 | La Guajira, Colombia | ||
2020-10-12 | Colombia | La Guajira | 8961 | 351 | 7837 | 773 | 11.3548 | -72.5205 | 2020-10-13 04:24:02 | La Guajira, Colombia | ||
2020-10-13 | Colombia | La Guajira | 8987 | 356 | 7903 | 728 | 11.3548 | -72.5205 | 2020-10-14 04:24:05 | La Guajira, Colombia | ||
2020-10-14 | Colombia | La Guajira | 9041 | 356 | 8001 | 684 | 11.3548 | -72.5205 | 2020-10-15 04:24:28 | La Guajira, Colombia | ||
2020-10-15 | Colombia | La Guajira | 9074 | 363 | 8102 | 609 | 11.3548 | -72.5205 | 2020-10-16 04:24:01 | La Guajira, Colombia | ||
2020-10-16 | Colombia | La Guajira | 9147 | 363 | 8102 | 682 | 11.3548 | -72.5205 | 2020-10-17 04:24:12 | La Guajira, Colombia | ||
2020-10-17 | Colombia | La Guajira | 9182 | 371 | 8227 | 584 | 11.3548 | -72.5205 | 2020-10-18 04:24:25 | La Guajira, Colombia | ||
2020-10-18 | Colombia | La Guajira | 9246 | 374 | 8337 | 535 | 11.3548 | -72.5205 | 2020-10-19 04:24:16 | La Guajira, Colombia | ||
2020-10-19 | Colombia | La Guajira | 9265 | 376 | 8402 | 487 | 11.3548 | -72.5205 | 2020-10-20 04:24:22 | La Guajira, Colombia | ||
2020-10-20 | Colombia | La Guajira | 9302 | 377 | 8479 | 446 | 11.3548 | -72.5205 | 2020-10-21 04:24:14 | La Guajira, Colombia | ||
2020-10-21 | Colombia | La Guajira | 9334 | 379 | 8517 | 438 | 11.3548 | -72.5205 | 2020-10-22 04:24:27 | La Guajira, Colombia | ||
2020-10-22 | Colombia | La Guajira | 9386 | 381 | 8576 | 429 | 11.3548 | -72.5205 | 2020-10-23 04:24:46 | La Guajira, Colombia | ||
2020-10-23 | Colombia | La Guajira | 9436 | 382 | 8614 | 440 | 11.3548 | -72.5205 | 2020-10-24 04:24:46 | La Guajira, Colombia | ||
2020-10-24 | Colombia | La Guajira | 9467 | 388 | 8668 | 411 | 11.3548 | -72.5205 | 2020-10-25 04:24:36 | La Guajira, Colombia | ||
2020-10-25 | Colombia | La Guajira | 9499 | 390 | 8689 | 420 | 11.3548 | -72.5205 | 2020-10-26 04:25:02 | La Guajira, Colombia | ||
2020-10-26 | Colombia | La Guajira | 9590 | 392 | 8727 | 471 | 11.3548 | -72.5205 | 2020-10-27 04:24:45 | La Guajira, Colombia | ||
2020-10-27 | Colombia | La Guajira | 9609 | 395 | 8791 | 423 | 11.3548 | -72.5205 | 2020-10-28 04:24:39 | La Guajira, Colombia | ||
2020-10-28 | Colombia | La Guajira | 9638 | 398 | 8829 | 411 | 11.3548 | -72.5205 | 2020-10-29 04:24:49 | La Guajira, Colombia | ||
2020-10-29 | Colombia | La Guajira | 9638 | 398 | 8829 | 411 | 11.3548 | -72.5205 | 2020-10-30 04:24:49 | La Guajira, Colombia | ||
2020-10-30 | Colombia | La Guajira | 9730 | 403 | 8883 | 444 | 11.3548 | -72.5205 | 2020-10-31 04:24:44 | La Guajira, Colombia | ||
2020-10-31 | Colombia | La Guajira | 10060 | 407 | 9014 | 639 | 11.3548 | -72.5205 | 2020-11-01 04:36:19 | La Guajira, Colombia | ||
2020-11-01 | Colombia | La Guajira | 10151 | 410 | 9239 | 502 | 11.3548 | -72.5205 | 2020-11-02 05:25:04 | La Guajira, Colombia | ||
2020-11-02 | Colombia | La Guajira | 10747 | 412 | 9282 | 1053 | 11.3548 | -72.5205 | 2020-11-03 06:00:16 | La Guajira, Colombia | ||
2020-11-03 | Colombia | La Guajira | 10300 | 415 | 9415 | 470 | 11.3548 | -72.5205 | 2020-11-04 05:25:09 | La Guajira, Colombia | ||
2020-11-04 | Colombia | La Guajira | 10355 | 418 | 9441 | 496 | 11.3548 | -72.5205 | 2020-11-05 06:05:03 | La Guajira, Colombia | ||
2020-11-05 | Colombia | La Guajira | 10444 | 420 | 9537 | 487 | 11.3548 | -72.5205 | 2020-11-06 05:24:55 | La Guajira, Colombia | ||
2020-11-06 | Colombia | La Guajira | 10484 | 420 | 9597 | 467 | 11.3548 | -72.5205 | 2020-11-07 05:24:52 | La Guajira, Colombia | ||
2020-11-07 | Colombia | La Guajira | 10554 | 421 | 9641 | 492 | 11.3548 | -72.5205 | 2020-11-08 05:24:56 | La Guajira, Colombia | ||
2020-11-08 | Colombia | La Guajira | 10660 | 422 | 9687 | 551 | 11.3548 | -72.5205 | 2020-11-09 05:25:45 | La Guajira, Colombia | ||
2020-11-09 | Colombia | La Guajira | 10711 | 425 | 9845 | 441 | 11.3548 | -72.5205 | 2020-11-10 05:40:07 | La Guajira, Colombia | ||
2020-11-10 | Colombia | La Guajira | 10732 | 426 | 9903 | 403 | 11.3548 | -72.5205 | 2020-11-11 05:25:30 | La Guajira, Colombia | ||
2020-11-11 | Colombia | La Guajira | 10794 | 430 | 9944 | 420 | 11.3548 | -72.5205 | 2020-11-12 05:25:55 | La Guajira, Colombia | ||
2020-11-12 | Colombia | La Guajira | 10845 | 432 | 10001 | 412 | 11.3548 | -72.5205 | 2020-11-13 05:25:30 | La Guajira, Colombia | ||
2020-11-13 | Colombia | La Guajira | 10897 | 432 | 10001 | 464 | 11.3548 | -72.5205 | 2020-11-14 05:25:37 | La Guajira, Colombia | ||
2020-11-14 | Colombia | La Guajira | 10921 | 434 | 10044 | 443 | 11.3548 | -72.5205 | 2020-11-15 05:26:53 | La Guajira, Colombia | ||
2020-11-15 | Colombia | La Guajira | 10991 | 437 | 10121 | 433 | 11.3548 | -72.5205 | 2020-11-16 05:25:57 | La Guajira, Colombia | ||
2020-11-16 | Colombia | La Guajira | 11035 | 438 | 10198 | 399 | 11.3548 | -72.5205 | 2020-11-17 05:25:54 | La Guajira, Colombia | ||
2020-11-17 | Colombia | La Guajira | 11048 | 442 | 10246 | 360 | 11.3548 | -72.5205 | 2020-11-18 05:40:31 | La Guajira, Colombia | ||
2020-11-18 | Colombia | La Guajira | 11081 | 443 | 10267 | 371 | 11.3548 | -72.5205 | 2020-11-19 05:25:23 | La Guajira, Colombia | ||
2020-11-19 | Colombia | La Guajira | 11116 | 444 | 10295 | 377 | 11.3548 | -72.5205 | 2020-11-20 05:26:28 | La Guajira, Colombia | ||
2020-11-20 | Colombia | La Guajira | 11206 | 446 | 10323 | 437 | 11.3548 | -72.5205 | 2020-11-21 05:25:51 | La Guajira, Colombia | ||
2020-11-21 | Colombia | La Guajira | 11268 | 446 | 10387 | 435 | 11.3548 | -72.5205 | 2020-11-22 05:25:45 | La Guajira, Colombia | ||
2020-11-22 | Colombia | La Guajira | 11296 | 446 | 10450 | 400 | 11.3548 | -72.5205 | 2020-11-23 05:25:26 | La Guajira, Colombia | ||
2020-11-23 | Colombia | La Guajira | 11370 | 446 | 10498 | 426 | 11.3548 | -72.5205 | 2020-11-24 05:27:31 | La Guajira, Colombia | ||
2020-11-24 | Colombia | La Guajira | 11393 | 446 | 10570 | 377 | 11.3548 | -72.5205 | 2020-11-25 05:27:20 | La Guajira, Colombia | ||
2020-11-25 | Colombia | La Guajira | 11523 | 447 | 10591 | 485 | 11.3548 | -72.5205 | 2020-11-26 05:27:44 | La Guajira, Colombia | ||
2020-11-26 | Colombia | La Guajira | 11601 | 449 | 10632 | 520 | 11.3548 | -72.5205 | 2020-11-27 05:26:53 | La Guajira, Colombia | ||
2020-11-27 | Colombia | La Guajira | 11662 | 454 | 10678 | 530 | 11.3548 | -72.5205 | 2020-11-28 05:25:50 | La Guajira, Colombia | ||
2020-11-28 | Colombia | La Guajira | 11758 | 456 | 10760 | 542 | 11.3548 | -72.5205 | 2020-11-29 05:25:55 | La Guajira, Colombia | ||
2020-11-29 | Colombia | La Guajira | 11849 | 457 | 10858 | 534 | 11.3548 | -72.5205 | 2020-11-30 05:26:13 | La Guajira, Colombia | ||
2020-11-30 | Colombia | La Guajira | 11923 | 467 | 10937 | 519 | 11.3548 | -72.5205 | 2020-12-01 05:26:18 | La Guajira, Colombia | ||
2020-12-01 | Colombia | La Guajira | 11984 | 469 | 11004 | 511 | 11.3548 | -72.5205 | 2020-12-02 05:27:41 | La Guajira, Colombia | ||
2020-12-02 | Colombia | La Guajira | 12094 | 473 | 11081 | 540 | 11.3548 | -72.5205 | 2020-12-03 05:28:22 | La Guajira, Colombia | ||
2020-12-03 | Colombia | La Guajira | 12159 | 476 | 11193 | 490 | 11.3548 | -72.5205 | 2020-12-04 05:27:27 | La Guajira, Colombia | ||
2020-12-04 | Colombia | La Guajira | 12277 | 481 | 11253 | 543 | 11.3548 | -72.5205 | 2020-12-05 05:27:36 | La Guajira, Colombia | ||
2020-12-05 | Colombia | La Guajira | 12357 | 482 | 11368 | 507 | 11.3548 | -72.5205 | 2020-12-06 05:26:18 | La Guajira, Colombia | ||
2020-12-06 | Colombia | La Guajira | 12456 | 491 | 11460 | 505 | 11.3548 | -72.5205 | 2020-12-07 05:26:14 | La Guajira, Colombia | ||
2020-12-07 | Colombia | La Guajira | 12496 | 493 | 11554 | 449 | 11.3548 | -72.5205 | 2020-12-08 05:27:42 | La Guajira, Colombia | ||
2020-12-08 | Colombia | La Guajira | 12520 | 495 | 11634 | 391 | 11.3548 | -72.5205 | 2020-12-09 05:28:01 | La Guajira, Colombia | ||
2020-12-09 | Colombia | La Guajira | 12615 | 498 | 11651 | 466 | 11.3548 | -72.5205 | 2020-12-10 05:26:19 | La Guajira, Colombia | ||
2020-12-10 | Colombia | La Guajira | 12645 | 502 | 11754 | 389 | 11.3548 | -72.5205 | 2020-12-11 05:26:59 | La Guajira, Colombia | ||
2020-12-11 | Colombia | La Guajira | 12755 | 502 | 11790 | 463 | 11.3548 | -72.5205 | 2020-12-12 05:26:19 | La Guajira, Colombia | ||
2020-12-12 | Colombia | La Guajira | 12787 | 503 | 11842 | 442 | 11.3548 | -72.5205 | 2020-12-13 05:27:20 | La Guajira, Colombia | ||
2020-12-13 | Colombia | La Guajira | 12842 | 505 | 11850 | 487 | 11.3548 | -72.5205 | 2020-12-14 05:26:27 | La Guajira, Colombia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;