daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

946 rows where province_or_state = "Cesar" sorted by deaths

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Cesar · 946 ✖

country_or_region 1

day country_or_region province_or_state admin2 fips confirmed deaths ▼ recovered active latitude longitude last_update combined_key
2020-06-08 Colombia Cesar     449 12 71 366 9.3373 -73.6536 2020-06-09 03:33:03 Cesar, Colombia
2020-06-06 Colombia Cesar     415 12 63 340 9.3373 -73.6536 2020-06-07 03:53:30 Cesar, Colombia
2020-06-01 Colombia Cesar     254 12 59 183 9.3373 -73.6536 2020-06-02 02:33:08 Cesar, Colombia
2020-06-09 Colombia Cesar     449 12 71 366 9.3373 -73.6536 2020-06-10 04:07:00 Cesar, Colombia
2020-06-05 Colombia Cesar     415 12 63 340 9.3373 -73.6536 2020-06-06 02:33:00 Cesar, Colombia
2020-06-11 Colombia Cesar     496 12 71 413 9.3373 -73.6536 2020-06-12 05:09:52 Cesar, Colombia
2020-06-04 Colombia Cesar     348 12 63 273 9.3373 -73.6536 2020-06-05 02:33:06 Cesar, Colombia
2020-05-29 Colombia Cesar     130 12 59 59 9.3373 -73.6536 2020-05-30 02:32:48 Cesar, Colombia
2020-05-31 Colombia Cesar     208 12 59 137 9.3373 -73.6536 2020-06-01 02:32:46 Cesar, Colombia
2020-06-02 Colombia Cesar     287 12 60 215 9.3373 -73.6536 2020-06-03 02:33:13 Cesar, Colombia
2020-05-28 Colombia Cesar     115 12 54 49 9.3373 -73.6536 2020-05-29 02:32:50 Cesar, Colombia
2020-06-07 Colombia Cesar     425 12 66 347 9.3373 -73.6536 2020-06-08 03:33:22 Cesar, Colombia
2020-06-10 Colombia Cesar     470 12 71 387 9.3373 -73.6536 2020-06-11 03:33:41 Cesar, Colombia
2020-05-30 Colombia Cesar     163 12 59 92 9.3373 -73.6536 2020-05-31 02:32:45 Cesar, Colombia
2020-06-03 Colombia Cesar     324 12 62 250 9.3373 -73.6536 2020-06-04 02:33:14 Cesar, Colombia
2020-06-12 Colombia Cesar     499 14 71 414 9.3373 -73.6536 2020-06-13 03:33:14 Cesar, Colombia
2020-06-14 Colombia Cesar     528 14 73 441 9.3373 -73.6536 2020-06-15 03:33:14 Cesar, Colombia
2020-06-13 Colombia Cesar     504 14 72 418 9.3373 -73.6536 2020-06-14 03:33:15 Cesar, Colombia
2020-06-15 Colombia Cesar     554 17 86 451 9.3373 -73.6536 2020-06-16 04:33:09 Cesar, Colombia
2020-06-17 Colombia Cesar     560 17 89 454 9.3373 -73.6536 2020-06-18 04:33:18 Cesar, Colombia
2020-06-19 Colombia Cesar     612 17 107 488 9.3373 -73.6536 2020-06-20 04:33:19 Cesar, Colombia
2020-06-16 Colombia Cesar     554 17 86 451 9.3373 -73.6536 2020-06-17 04:33:21 Cesar, Colombia
2020-06-18 Colombia Cesar     589 17 92 480 9.3373 -73.6536 2020-06-19 04:33:17 Cesar, Colombia
2020-06-20 Colombia Cesar     627 19 114 494 9.3373 -73.6536 2020-06-21 04:33:19 Cesar, Colombia
2020-06-26 Colombia Cesar     791 22 309 460 9.3373 -73.6536 2020-06-27 04:33:35 Cesar, Colombia
2020-06-22 Colombia Cesar     730 22 188 520 9.3373 -73.6536 2020-06-23 04:33:22 Cesar, Colombia
2020-06-23 Colombia Cesar     733 22 225 486 9.3373 -73.6536 2020-06-24 04:33:28 Cesar, Colombia
2020-06-27 Colombia Cesar     813 22 315 476 9.3373 -73.6536 2020-06-28 04:34:04 Cesar, Colombia
2020-06-25 Colombia Cesar     784 22 281 481 9.3373 -73.6536 2020-06-26 04:33:43 Cesar, Colombia
2020-06-24 Colombia Cesar     733 22 225 486 9.3373 -73.6536 2020-06-25 05:26:54 Cesar, Colombia
2020-06-21 Colombia Cesar     702 22 152 528 9.3373 -73.6536 2020-06-22 04:33:20 Cesar, Colombia
2020-06-28 Colombia Cesar     946 23 376 547 9.3373 -73.6536 2020-06-29 04:33:44 Cesar, Colombia
2020-06-29 Colombia Cesar     946 23 376 547 9.3373 -73.6536 2020-06-30 04:33:48 Cesar, Colombia
2020-06-30 Colombia Cesar     994 23 410 561 9.3373 -73.6536 2020-07-01 04:33:52 Cesar, Colombia
2020-07-01 Colombia Cesar     1027 25 458 544 9.3373 -73.6536 2020-07-02 04:33:46 Cesar, Colombia
2020-07-03 Colombia Cesar     1076 27 493 556 9.3373 -73.6536 2020-07-04 04:33:51 Cesar, Colombia
2020-07-02 Colombia Cesar     1071 27 475 569 9.3373 -73.6536 2020-07-03 04:33:54 Cesar, Colombia
2020-07-04 Colombia Cesar     1169 28 501 640 9.3373 -73.6536 2020-07-05 04:33:46 Cesar, Colombia
2020-07-05 Colombia Cesar     1272 32 515 725 9.3373 -73.6536 2020-07-06 04:33:57 Cesar, Colombia
2020-07-07 Colombia Cesar     1321 33 641 647 9.3373 -73.6536 2020-07-08 05:33:48 Cesar, Colombia
2020-07-06 Colombia Cesar     1299 33 565 701 9.3373 -73.6536 2020-07-07 04:34:00 Cesar, Colombia
2020-07-09 Colombia Cesar     1359 34 687 638 9.3373 -73.6536 2020-07-10 04:34:24 Cesar, Colombia
2020-07-08 Colombia Cesar     1341 34 683 624 9.3373 -73.6536 2020-07-09 04:34:23 Cesar, Colombia
2020-07-10 Colombia Cesar     1382 35 704 643 9.3373 -73.6536 2020-07-11 04:34:26 Cesar, Colombia
2020-07-11 Colombia Cesar     1418 35 784 599 9.3373 -73.6536 2020-07-12 04:34:30 Cesar, Colombia
2020-07-13 Colombia Cesar     1505 37 840 628 9.3373 -73.6536 2020-07-14 04:34:46 Cesar, Colombia
2020-07-12 Colombia Cesar     1433 37 796 600 9.3373 -73.6536 2020-07-13 04:43:04 Cesar, Colombia
2020-07-19 Colombia Cesar     1997 38 1114 845 9.3373 -73.6536 2020-07-20 05:34:40 Cesar, Colombia
2020-07-14 Colombia Cesar     1557 38 872 647 9.3373 -73.6536 2020-07-15 04:34:39 Cesar, Colombia
2020-07-17 Colombia Cesar     1819 38 979 802 9.3373 -73.6536 2020-07-18 04:34:45 Cesar, Colombia
2020-07-18 Colombia Cesar     1893 38 1054 801 9.3373 -73.6536 2020-07-19 04:34:58 Cesar, Colombia
2020-07-20 Colombia Cesar     2115 39 1137 939 9.3373 -73.6536 2020-07-21 04:38:46 Cesar, Colombia
2020-07-16 Colombia Cesar     1665 41 924 700 9.3373 -73.6536 2020-07-17 04:34:50 Cesar, Colombia
2020-07-21 Colombia Cesar     2126 41 1153 932 9.3373 -73.6536 2020-07-22 04:34:42 Cesar, Colombia
2020-07-15 Colombia Cesar     1584 41 889 654 9.3373 -73.6536 2020-07-16 04:44:59 Cesar, Colombia
2020-07-22 Colombia Cesar     2225 42 1178 1005 9.3373 -73.6536 2020-07-23 05:15:04 Cesar, Colombia
2020-07-23 Colombia Cesar     2309 44 1221 1044 9.3373 -73.6536 2020-07-24 05:30:40 Cesar, Colombia
2020-07-24 Colombia Cesar     2367 46 1259 1062 9.3373 -73.6536 2020-07-25 04:47:39 Cesar, Colombia
2020-07-26 Colombia Cesar     2447 49 1297 1101 9.3373 -73.6536 2020-07-27 04:35:02 Cesar, Colombia
2020-07-25 Colombia Cesar     2447 49 1297 1101 9.3373 -73.6536 2020-07-26 04:35:00 Cesar, Colombia
2020-07-27 Colombia Cesar     2636 52 1398 1186 9.3373 -73.6536 2020-07-28 04:58:43 Cesar, Colombia
2020-07-28 Colombia Cesar     2798 53 1440 1305 9.3373 -73.6536 2020-07-29 04:35:11 Cesar, Colombia
2020-07-30 Colombia Cesar     3001 61 1532 1408 9.3373 -73.6536 2020-07-31 04:35:18 Cesar, Colombia
2020-07-29 Colombia Cesar     2886 61 1482 1343 9.3373 -73.6536 2020-07-30 04:35:05 Cesar, Colombia
2020-08-01 Colombia Cesar     3351 63 1596 1692 9.3373 -73.6536 2020-08-02 04:34:47 Cesar, Colombia
2020-07-31 Colombia Cesar     3116 64 1565 1487 9.3373 -73.6536 2020-08-01 04:36:27 Cesar, Colombia
2020-08-02 Colombia Cesar     3504 68 1652 1784 9.3373 -73.6536 2020-08-03 04:34:35 Cesar, Colombia
2020-08-03 Colombia Cesar     3542 73 1713 1756 9.3373 -73.6536 2020-08-04 04:41:59 Cesar, Colombia
2020-08-04 Colombia Cesar     3735 75 1754 1906 9.3373 -73.6536 2020-08-05 04:34:43 Cesar, Colombia
2020-08-06 Colombia Cesar     3979 82 1881 2016 9.3373 -73.6536 2020-08-07 04:35:11 Cesar, Colombia
2020-08-05 Colombia Cesar     3835 82 1814 1939 9.3373 -73.6536 2020-08-06 04:35:02 Cesar, Colombia
2020-08-07 Colombia Cesar     4204 83 1942 2179 9.3373 -73.6536 2020-08-08 04:34:53 Cesar, Colombia
2020-08-08 Colombia Cesar     4382 90 2002 2290 9.3373 -73.6536 2020-08-09 04:34:54 Cesar, Colombia
2020-08-09 Colombia Cesar     4466 97 2062 2307 9.3373 -73.6536 2020-08-10 04:34:55 Cesar, Colombia
2020-08-10 Colombia Cesar     4511 100 2148 2263 9.3373 -73.6536 2020-08-11 04:35:08 Cesar, Colombia
2020-08-11 Colombia Cesar     4786 101 2286 2399 9.3373 -73.6536 2020-08-12 04:27:29 Cesar, Colombia
2020-08-12 Colombia Cesar     4858 104 2327 2427 9.3373 -73.6536 2020-08-13 04:29:15 Cesar, Colombia
2020-08-13 Colombia Cesar     5123 106 2475 2542 9.3373 -73.6536 2020-08-14 04:51:19 Cesar, Colombia
2020-08-14 Colombia Cesar     5297 113 2622 2562 9.3373 -73.6536 2020-08-15 04:27:31 Cesar, Colombia
2020-08-15 Colombia Cesar     5452 117 2748 2587 9.3373 -73.6536 2020-08-16 04:27:42 Cesar, Colombia
2020-08-16 Colombia Cesar     5732 124 2884 2724 9.3373 -73.6536 2020-08-17 04:27:20 Cesar, Colombia
2020-08-17 Colombia Cesar     5891 130 3111 2650 9.3373 -73.6536 2020-08-18 04:27:56 Cesar, Colombia
2020-08-18 Colombia Cesar     6060 136 3308 2616 9.3373 -73.6536 2020-08-19 04:27:00 Cesar, Colombia
2020-08-19 Colombia Cesar     6439 139 3526 2774 9.3373 -73.6536 2020-08-20 04:27:43 Cesar, Colombia
2020-08-20 Colombia Cesar     6968 146 3650 3172 9.3373 -73.6536 2020-08-21 04:27:41 Cesar, Colombia
2020-08-21 Colombia Cesar     7187 165 3885 3137 9.3373 -73.6536 2020-08-22 04:27:49 Cesar, Colombia
2020-08-22 Colombia Cesar     7187 165 3885 3137 9.3373 -73.6536 2020-08-23 04:27:48 Cesar, Colombia
2020-08-23 Colombia Cesar     7889 200 4351 3338 9.3373 -73.6536 2020-08-24 04:27:56 Cesar, Colombia
2020-08-24 Colombia Cesar     8067 212 4541 3314 9.3373 -73.6536 2020-08-25 04:28:02 Cesar, Colombia
2020-08-25 Colombia Cesar     8385 222 4824 3339 9.3373 -73.6536 2020-08-26 04:28:11 Cesar, Colombia
2020-08-26 Colombia Cesar     8770 233 5013 3524 9.3373 -73.6536 2020-08-27 04:28:15 Cesar, Colombia
2020-08-27 Colombia Cesar     9330 233 5133 3964 9.3373 -73.6536 2020-08-28 04:28:11 Cesar, Colombia
2020-08-28 Colombia Cesar     9655 252 5395 4008 9.3373 -73.6536 2020-08-29 04:28:19 Cesar, Colombia
2020-08-29 Colombia Cesar     10013 267 5626 4120 9.3373 -73.6536 2020-08-30 04:28:22 Cesar, Colombia
2020-08-30 Colombia Cesar     10514 285 5955 4274 9.3373 -73.6536 2020-08-31 04:28:27 Cesar, Colombia
2020-08-31 Colombia Cesar     10815 296 6242 4277 9.3373 -73.6536 2020-09-01 04:28:31 Cesar, Colombia
2020-09-01 Colombia Cesar     11211 313 6428 4470 9.3373 -73.6536 2020-09-02 04:28:25 Cesar, Colombia
2020-09-02 Colombia Cesar     11797 325 6813 4659 9.3373 -73.6536 2020-09-03 04:28:22 Cesar, Colombia
2020-09-03 Colombia Cesar     11964 336 7066 4562 9.3373 -73.6536 2020-09-04 04:28:26 Cesar, Colombia
2020-09-04 Colombia Cesar     11964 336 7066 4562 9.3373 -73.6536 2020-09-05 04:28:19 Cesar, Colombia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;