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 = "Atlantico" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069848 | 3069848 | 2021-11-23 | Colombia | Atlantico | 337462 | 9649 | 0 | 10.6966 | -74.8741 | 2021-11-24 04:22:14 | Atlantico, Colombia | |||
3748946 | 3748946 | 2021-11-22 | Colombia | Atlantico | 336914 | 9648 | 0 | 10.6966 | -74.8741 | 2021-11-23 04:22:39 | Atlantico, Colombia | |||
1014153 | 1014153 | 2021-11-21 | Colombia | Atlantico | 336914 | 9646 | 0 | 10.6966 | -74.8741 | 2021-11-22 04:22:20 | Atlantico, Colombia | |||
722317 | 722317 | 2021-11-20 | Colombia | Atlantico | 336558 | 9635 | 0 | 10.6966 | -74.8741 | 2021-11-21 04:22:13 | Atlantico, Colombia | |||
161847 | 161847 | 2021-11-19 | Colombia | Atlantico | 336285 | 9635 | 0 | 10.6966 | -74.8741 | 2021-11-20 04:22:17 | Atlantico, Colombia | |||
3288734 | 3288734 | 2021-11-18 | Colombia | Atlantico | 335959 | 9625 | 0 | 10.6966 | -74.8741 | 2021-11-19 04:21:40 | Atlantico, Colombia | |||
447190 | 447190 | 2021-11-17 | Colombia | Atlantico | 335549 | 9625 | 0 | 10.6966 | -74.8741 | 2021-11-18 04:21:33 | Atlantico, Colombia | |||
3342440 | 3342440 | 2021-11-16 | Colombia | Atlantico | 335350 | 9620 | 0 | 10.6966 | -74.8741 | 2021-11-17 04:21:48 | Atlantico, Colombia | |||
2287276 | 2287276 | 2021-11-15 | Colombia | Atlantico | 335094 | 9617 | 0 | 10.6966 | -74.8741 | 2021-11-16 04:21:10 | Atlantico, Colombia | |||
1322050 | 1322050 | 2021-11-14 | Colombia | Atlantico | 334837 | 9615 | 0 | 10.6966 | -74.8741 | 2021-11-15 04:21:36 | Atlantico, Colombia | |||
686176 | 686176 | 2021-11-13 | Colombia | Atlantico | 334434 | 9614 | 0 | 10.6966 | -74.8741 | 2021-11-14 04:21:31 | Atlantico, Colombia | |||
714285 | 714285 | 2021-11-12 | Colombia | Atlantico | 334089 | 9614 | 0 | 10.6966 | -74.8741 | 2021-11-13 04:21:38 | Atlantico, Colombia | |||
28235 | 28235 | 2021-11-11 | Colombia | Atlantico | 333656 | 9610 | 0 | 10.6966 | -74.8741 | 2021-11-12 04:22:01 | Atlantico, Colombia | |||
2844674 | 2844674 | 2021-11-10 | Colombia | Atlantico | 333175 | 9606 | 0 | 10.6966 | -74.8741 | 2021-11-11 04:21:45 | Atlantico, Colombia | |||
86944 | 86944 | 2021-11-09 | Colombia | Atlantico | 332728 | 9605 | 0 | 10.6966 | -74.8741 | 2021-11-10 04:21:38 | Atlantico, Colombia | |||
3639372 | 3639372 | 2021-11-08 | Colombia | Atlantico | 332528 | 9603 | 0 | 10.6966 | -74.8741 | 2021-11-09 04:21:36 | Atlantico, Colombia | |||
2000480 | 2000480 | 2021-11-07 | Colombia | Atlantico | 332235 | 9598 | 0 | 10.6966 | -74.8741 | 2021-11-08 04:21:43 | Atlantico, Colombia | |||
495471 | 495471 | 2021-11-06 | Colombia | Atlantico | 331826 | 9593 | 0 | 10.6966 | -74.8741 | 2021-11-07 04:21:53 | Atlantico, Colombia | |||
3121326 | 3121326 | 2021-11-05 | Colombia | Atlantico | 331428 | 9590 | 0 | 10.6966 | -74.8741 | 2021-11-06 04:21:51 | Atlantico, Colombia | |||
698224 | 698224 | 2021-11-04 | Colombia | Atlantico | 331093 | 9584 | 0 | 10.6966 | -74.8741 | 2021-11-05 04:21:54 | Atlantico, Colombia | |||
276002 | 276002 | 2021-11-03 | Colombia | Atlantico | 330744 | 9578 | 0 | 10.6966 | -74.8741 | 2021-11-04 04:22:20 | Atlantico, Colombia | |||
43527 | 43527 | 2021-11-02 | Colombia | Atlantico | 330498 | 9573 | 0 | 10.6966 | -74.8741 | 2021-11-03 06:22:09 | Atlantico, Colombia | |||
3511223 | 3511223 | 2021-11-01 | Colombia | Atlantico | 330296 | 9568 | 0 | 10.6966 | -74.8741 | 2021-11-02 04:22:03 | Atlantico, Colombia | |||
287815 | 287815 | 2021-10-31 | Colombia | Atlantico | 330134 | 9563 | 0 | 10.6966 | -74.8741 | 2021-11-01 04:22:01 | Atlantico, Colombia | |||
2720821 | 2720821 | 2021-10-30 | Colombia | Atlantico | 329793 | 9559 | 0 | 10.6966 | -74.8741 | 2021-10-31 04:22:08 | Atlantico, Colombia | |||
566923 | 566923 | 2021-10-29 | Colombia | Atlantico | 329425 | 9555 | 0 | 10.6966 | -74.8741 | 2021-10-30 04:22:03 | Atlantico, Colombia | |||
4165 | 4165 | 2021-10-28 | Colombia | Atlantico | 329119 | 9550 | 0 | 10.6966 | -74.8741 | 2021-10-29 04:22:03 | Atlantico, Colombia | |||
534555 | 534555 | 2021-10-27 | Colombia | Atlantico | 328844 | 9545 | 0 | 10.6966 | -74.8741 | 2021-10-28 04:22:08 | Atlantico, Colombia | |||
3491992 | 3491992 | 2021-10-26 | Colombia | Atlantico | 328471 | 9545 | 0 | 10.6966 | -74.8741 | 2021-10-27 04:22:32 | Atlantico, Colombia | |||
3793714 | 3793714 | 2021-10-25 | Colombia | Atlantico | 328236 | 9540 | 0 | 10.6966 | -74.8741 | 2021-10-26 04:22:09 | Atlantico, Colombia | |||
682160 | 682160 | 2021-10-24 | Colombia | Atlantico | 328008 | 9534 | 0 | 10.6966 | -74.8741 | 2021-10-25 04:22:31 | Atlantico, Colombia | |||
770168 | 770168 | 2021-10-23 | Colombia | Atlantico | 327726 | 9533 | 0 | 10.6966 | -74.8741 | 2021-10-24 04:21:22 | Atlantico, Colombia | |||
653815 | 653815 | 2021-10-22 | Colombia | Atlantico | 327332 | 9528 | 0 | 10.6966 | -74.8741 | 2021-10-23 04:21:32 | Atlantico, Colombia | |||
2123562 | 2123562 | 2021-10-21 | Colombia | Atlantico | 326926 | 9522 | 0 | 10.6966 | -74.8741 | 2021-10-22 04:21:14 | Atlantico, Colombia | |||
443174 | 443174 | 2021-10-20 | Colombia | Atlantico | 326580 | 9518 | 0 | 10.6966 | -74.8741 | 2021-10-21 04:21:18 | Atlantico, Colombia | |||
597493 | 597493 | 2021-10-19 | Colombia | Atlantico | 326282 | 9511 | 0 | 10.6966 | -74.8741 | 2021-10-20 04:21:00 | Atlantico, Colombia | |||
2043670 | 2043670 | 2021-10-18 | Colombia | Atlantico | 326157 | 9511 | 0 | 10.6966 | -74.8741 | 2021-10-19 04:20:54 | Atlantico, Colombia | |||
1909031 | 1909031 | 2021-10-17 | Colombia | Atlantico | 326023 | 9511 | 0 | 10.6966 | -74.8741 | 2021-10-18 04:21:10 | Atlantico, Colombia | |||
934620 | 934620 | 2021-10-16 | Colombia | Atlantico | 325729 | 9506 | 0 | 10.6966 | -74.8741 | 2021-10-17 04:21:29 | Atlantico, Colombia | |||
2943175 | 2943175 | 2021-10-15 | Colombia | Atlantico | 325444 | 9502 | 0 | 10.6966 | -74.8741 | 2021-10-16 04:21:15 | Atlantico, Colombia | |||
491455 | 491455 | 2021-10-14 | Colombia | Atlantico | 325136 | 9499 | 0 | 10.6966 | -74.8741 | 2021-10-15 04:21:26 | Atlantico, Colombia | |||
633743 | 633743 | 2021-10-13 | Colombia | Atlantico | 324798 | 9496 | 0 | 10.6966 | -74.8741 | 2021-10-14 04:21:29 | Atlantico, Colombia | |||
1491421 | 1491421 | 2021-10-12 | Colombia | Atlantico | 324546 | 9489 | 0 | 10.6966 | -74.8741 | 2021-10-13 04:20:51 | Atlantico, Colombia | |||
3007154 | 3007154 | 2021-10-11 | Colombia | Atlantico | 324352 | 9486 | 0 | 10.6966 | -74.8741 | 2021-10-12 04:21:09 | Atlantico, Colombia | |||
423170 | 423170 | 2021-10-10 | Colombia | Atlantico | 324175 | 9485 | 0 | 10.6966 | -74.8741 | 2021-10-11 04:21:31 | Atlantico, Colombia | |||
2876027 | 2876027 | 2021-10-09 | Colombia | Atlantico | 323874 | 9484 | 0 | 10.6966 | -74.8741 | 2021-10-10 04:21:38 | Atlantico, Colombia | |||
2959193 | 2959193 | 2021-10-08 | Colombia | Atlantico | 323520 | 9480 | 0 | 10.6966 | -74.8741 | 2021-10-09 04:21:34 | Atlantico, Colombia | |||
467231 | 467231 | 2021-10-07 | Colombia | Atlantico | 323241 | 9477 | 0 | 10.6966 | -74.8741 | 2021-10-08 04:21:25 | Atlantico, Colombia | |||
2458611 | 2458611 | 2021-10-06 | Colombia | Atlantico | 322890 | 9470 | 0 | 10.6966 | -74.8741 | 2021-10-07 04:21:36 | Atlantico, Colombia | |||
3832305 | 3832305 | 2021-10-05 | Colombia | Atlantico | 322662 | 9470 | 0 | 10.6966 | -74.8741 | 2021-10-06 04:21:33 | Atlantico, Colombia | |||
986798 | 986798 | 2021-10-04 | Colombia | Atlantico | 322418 | 9468 | 0 | 10.6966 | -74.8741 | 2021-10-05 04:21:27 | Atlantico, Colombia | |||
1274108 | 1274108 | 2021-10-03 | Colombia | Atlantico | 322154 | 9465 | 0 | 10.6966 | -74.8741 | 2021-10-04 04:21:31 | Atlantico, Colombia | |||
3927861 | 3927861 | 2021-10-02 | Colombia | Atlantico | 321879 | 9461 | 0 | 10.6966 | -74.8741 | 2021-10-03 04:21:24 | Atlantico, Colombia | |||
2131841 | 2131841 | 2021-10-01 | Colombia | Atlantico | 321518 | 9459 | 0 | 10.6966 | -74.8741 | 2021-10-02 04:21:25 | Atlantico, Colombia | |||
2772798 | 2772798 | 2021-09-30 | Colombia | Atlantico | 321129 | 9457 | 0 | 10.6966 | -74.8741 | 2021-10-01 04:21:35 | Atlantico, Colombia | |||
706254 | 706254 | 2021-09-29 | Colombia | Atlantico | 320812 | 9453 | 0 | 10.6966 | -74.8741 | 2021-09-30 04:21:20 | Atlantico, Colombia | |||
1334096 | 1334096 | 2021-09-28 | Colombia | Atlantico | 320546 | 9445 | 0 | 10.6966 | -74.8741 | 2021-09-29 04:21:45 | Atlantico, Colombia | |||
1235465 | 1235465 | 2021-09-27 | Colombia | Atlantico | 320120 | 9445 | 0 | 10.6966 | -74.8741 | 2021-09-28 04:21:28 | Atlantico, Colombia | |||
2075766 | 2075766 | 2021-09-26 | Colombia | Atlantico | 320120 | 9442 | 0 | 10.6966 | -74.8741 | 2021-09-27 04:21:16 | Atlantico, Colombia | |||
1724318 | 1724318 | 2021-09-25 | Colombia | Atlantico | 319755 | 9439 | 0 | 10.6966 | -74.8741 | 2021-09-26 04:21:29 | Atlantico, Colombia | |||
1921038 | 1921038 | 2021-09-24 | Colombia | Atlantico | 319304 | 9434 | 0 | 10.6966 | -74.8741 | 2021-09-25 04:21:31 | Atlantico, Colombia | |||
601509 | 601509 | 2021-09-23 | Colombia | Atlantico | 318853 | 9430 | 0 | 10.6966 | -74.8741 | 2021-09-24 04:21:44 | Atlantico, Colombia | |||
3011170 | 3011170 | 2021-09-22 | Colombia | Atlantico | 318570 | 9427 | 0 | 10.6966 | -74.8741 | 2021-09-23 04:21:43 | Atlantico, Colombia | |||
3757308 | 3757308 | 2021-09-21 | Colombia | Atlantico | 318309 | 9426 | 0 | 10.6966 | -74.8741 | 2021-09-22 04:21:45 | Atlantico, Colombia | |||
809411 | 809411 | 2021-09-20 | Colombia | Atlantico | 318132 | 9423 | 0 | 10.6966 | -74.8741 | 2021-09-21 04:21:26 | Atlantico, Colombia | |||
1814610 | 1814610 | 2021-09-19 | Colombia | Atlantico | 317961 | 9417 | 0 | 10.6966 | -74.8741 | 2021-09-20 04:21:22 | Atlantico, Colombia | |||
16190 | 16190 | 2021-09-18 | Colombia | Atlantico | 317533 | 9413 | 0 | 10.6966 | -74.8741 | 2021-09-19 04:21:34 | Atlantico, Colombia | |||
2617875 | 2617875 | 2021-09-17 | Colombia | Atlantico | 317223 | 9412 | 0 | 10.6966 | -74.8741 | 2021-09-18 04:21:24 | Atlantico, Colombia | |||
2808583 | 2808583 | 2021-09-16 | Colombia | Atlantico | 316969 | 9410 | 0 | 10.6966 | -74.8741 | 2021-09-17 04:21:46 | Atlantico, Colombia | |||
1374328 | 1374328 | 2021-09-15 | Colombia | Atlantico | 316518 | 9407 | 0 | 10.6966 | -74.8741 | 2021-09-16 04:22:19 | Atlantico, Colombia | |||
2462627 | 2462627 | 2021-09-14 | Colombia | Atlantico | 316518 | 9406 | 0 | 10.6966 | -74.8741 | 2021-09-15 03:22:37 | Atlantico, Colombia | |||
1385466 | 1385466 | 2021-09-13 | Colombia | Atlantico | 316357 | 9406 | 0 | 10.6966 | -74.8741 | 2021-09-14 04:21:41 | Atlantico, Colombia | |||
1884835 | 1884835 | 2021-09-12 | Colombia | Atlantico | 316233 | 9404 | 0 | 10.6966 | -74.8741 | 2021-09-13 04:21:15 | Atlantico, Colombia | |||
3805738 | 3805738 | 2021-09-11 | Colombia | Atlantico | 316010 | 9400 | 0 | 10.6966 | -74.8741 | 2021-09-12 04:21:13 | Atlantico, Colombia | |||
3448678 | 3448678 | 2021-09-10 | Colombia | Atlantico | 315763 | 9395 | 0 | 10.6966 | -74.8741 | 2021-09-11 04:21:30 | Atlantico, Colombia | |||
1262624 | 1262624 | 2021-09-09 | Colombia | Atlantico | 315532 | 9391 | 0 | 10.6966 | -74.8741 | 2021-09-10 04:21:20 | Atlantico, Colombia | |||
2278994 | 2278994 | 2021-09-08 | Colombia | Atlantico | 315355 | 9387 | 0 | 10.6966 | -74.8741 | 2021-09-09 04:21:27 | Atlantico, Colombia | |||
641773 | 641773 | 2021-09-07 | Colombia | Atlantico | 315133 | 9386 | 0 | 10.6966 | -74.8741 | 2021-09-08 04:21:31 | Atlantico, Colombia | |||
3193836 | 3193836 | 2021-09-06 | Colombia | Atlantico | 315029 | 9384 | 0 | 10.6966 | -74.8741 | 2021-09-07 04:21:35 | Atlantico, Colombia | |||
3280704 | 3280704 | 2021-09-05 | Colombia | Atlantico | 314900 | 9382 | 0 | 10.6966 | -74.8741 | 2021-09-06 04:21:22 | Atlantico, Colombia | |||
249118 | 249118 | 2021-09-04 | Colombia | Atlantico | 314737 | 9380 | 0 | 10.6966 | -74.8741 | 2021-09-05 04:21:33 | Atlantico, Colombia | |||
3974399 | 3974399 | 2021-09-03 | Colombia | Atlantico | 314542 | 9377 | 0 | 10.6966 | -74.8741 | 2021-09-04 04:21:28 | Atlantico, Colombia | |||
177861 | 177861 | 2021-09-02 | Colombia | Atlantico | 314301 | 9371 | 0 | 10.6966 | -74.8741 | 2021-09-03 04:21:20 | Atlantico, Colombia | |||
66896 | 66896 | 2021-09-01 | Colombia | Atlantico | 314042 | 9368 | 0 | 10.6966 | -74.8741 | 2021-09-02 04:21:15 | Atlantico, Colombia | |||
2067738 | 2067738 | 2021-08-31 | Colombia | Atlantico | 313924 | 9365 | 0 | 10.6966 | -74.8741 | 2021-09-01 04:21:38 | Atlantico, Colombia | |||
1775192 | 1775192 | 2021-08-30 | Colombia | Atlantico | 313823 | 9361 | 0 | 10.6966 | -74.8741 | 2021-08-31 04:21:46 | Atlantico, Colombia | |||
3891766 | 3891766 | 2021-08-29 | Colombia | Atlantico | 313710 | 9355 | 0 | 10.6966 | -74.8741 | 2021-08-30 04:21:23 | Atlantico, Colombia | |||
2792869 | 2792869 | 2021-08-28 | Colombia | Atlantico | 313538 | 9350 | 0 | 10.6966 | -74.8741 | 2021-08-29 04:21:14 | Atlantico, Colombia | |||
2923028 | 2923028 | 2021-08-27 | Colombia | Atlantico | 313392 | 9348 | 0 | 10.6966 | -74.8741 | 2021-08-28 04:21:28 | Atlantico, Colombia | |||
1596042 | 1596042 | 2021-08-26 | Colombia | Atlantico | 313247 | 9343 | 0 | 10.6966 | -74.8741 | 2021-08-27 04:21:37 | Atlantico, Colombia | |||
32251 | 32251 | 2021-08-25 | Colombia | Atlantico | 313001 | 9339 | 0 | 10.6966 | -74.8741 | 2021-08-26 04:21:28 | Atlantico, Colombia | |||
3105290 | 3105290 | 2021-08-24 | Colombia | Atlantico | 313001 | 9335 | 0 | 10.6966 | -74.8741 | 2021-08-25 04:21:41 | Atlantico, Colombia | |||
3165461 | 3165461 | 2021-08-23 | Colombia | Atlantico | 312899 | 9332 | 0 | 10.6966 | -74.8741 | 2021-08-24 04:21:19 | Atlantico, Colombia | |||
2175388 | 2175388 | 2021-08-22 | Colombia | Atlantico | 312804 | 9328 | 0 | 10.6966 | -74.8741 | 2021-08-23 04:21:27 | Atlantico, Colombia | |||
3555484 | 3555484 | 2021-08-21 | Colombia | Atlantico | 312608 | 9321 | 0 | 10.6966 | -74.8741 | 2021-08-22 04:21:29 | Atlantico, Colombia | |||
1853826 | 1853826 | 2021-08-20 | Colombia | Atlantico | 312392 | 9321 | 0 | 10.6966 | -74.8741 | 2021-08-21 04:21:38 | Atlantico, Colombia | |||
511533 | 511533 | 2021-08-19 | Colombia | Atlantico | 312029 | 9317 | 0 | 10.6966 | -74.8741 | 2021-08-20 04:21:33 | Atlantico, Colombia | |||
2518012 | 2518012 | 2021-08-18 | Colombia | Atlantico | 311883 | 9311 | 0 | 10.6966 | -74.8741 | 2021-08-19 04:21:15 | Atlantico, Colombia | |||
245104 | 245104 | 2021-08-17 | Colombia | Atlantico | 311745 | 9309 | 0 | 10.6966 | -74.8741 | 2021-08-18 04:21:35 | Atlantico, Colombia | |||
1604067 | 1604067 | 2021-08-16 | Colombia | Atlantico | 311673 | 9305 | 0 | 10.6966 | -74.8741 | 2021-08-17 04:21:49 | Atlantico, 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]);