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 = "Sucre" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) >30 ✖
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- 2020-06-19 1
- 2020-06-20 1
- 2020-06-21 1
- 2020-06-22 1
- 2020-06-23 1
- 2020-06-24 1
- 2020-06-25 1
- 2020-06-26 1
- …
province_or_state 1
- Sucre · 946 ✖
country_or_region 1
- Colombia · 946 ✖
Link | rowid | day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2712383 | 2712383 | 2020-05-28 | Colombia | Sucre | 10 | 0 | 3 | 7 | 8.814 | -74.7233 | 2020-05-29 02:32:50 | Sucre, Colombia | ||
1790504 | 1790504 | 2020-05-29 | Colombia | Sucre | 15 | 0 | 3 | 12 | 8.814 | -74.7233 | 2020-05-30 02:32:48 | Sucre, Colombia | ||
3638963 | 3638963 | 2020-05-30 | Colombia | Sucre | 15 | 0 | 3 | 12 | 8.814 | -74.7233 | 2020-05-31 02:32:45 | Sucre, Colombia | ||
1794070 | 1794070 | 2020-05-31 | Colombia | Sucre | 19 | 0 | 3 | 16 | 8.814 | -74.7233 | 2020-06-01 02:32:46 | Sucre, Colombia | ||
805511 | 805511 | 2020-06-01 | Colombia | Sucre | 21 | 0 | 4 | 17 | 8.814 | -74.7233 | 2020-06-02 02:33:08 | Sucre, Colombia | ||
2555974 | 2555974 | 2020-06-02 | Colombia | Sucre | 24 | 0 | 4 | 20 | 8.814 | -74.7233 | 2020-06-03 02:33:13 | Sucre, Colombia | ||
3866932 | 3866932 | 2020-06-03 | Colombia | Sucre | 25 | 0 | 4 | 21 | 8.814 | -74.7233 | 2020-06-04 02:33:14 | Sucre, Colombia | ||
1281377 | 1281377 | 2020-06-04 | Colombia | Sucre | 47 | 0 | 4 | 43 | 8.814 | -74.7233 | 2020-06-05 02:33:06 | Sucre, Colombia | ||
1269911 | 1269911 | 2020-06-05 | Colombia | Sucre | 81 | 0 | 5 | 76 | 8.814 | -74.7233 | 2020-06-06 02:33:00 | Sucre, Colombia | ||
574214 | 574214 | 2020-06-06 | Colombia | Sucre | 81 | 0 | 5 | 76 | 8.814 | -74.7233 | 2020-06-07 03:53:30 | Sucre, Colombia | ||
2800158 | 2800158 | 2020-06-07 | Colombia | Sucre | 97 | 2 | 5 | 90 | 8.814 | -74.7233 | 2020-06-08 03:33:22 | Sucre, Colombia | ||
217362 | 217362 | 2020-06-08 | Colombia | Sucre | 131 | 2 | 5 | 124 | 8.814 | -74.7233 | 2020-06-09 03:33:03 | Sucre, Colombia | ||
1210935 | 1210935 | 2020-06-09 | Colombia | Sucre | 131 | 2 | 5 | 124 | 8.814 | -74.7233 | 2020-06-10 04:07:00 | Sucre, Colombia | ||
2864111 | 2864111 | 2020-06-10 | Colombia | Sucre | 143 | 2 | 5 | 136 | 8.814 | -74.7233 | 2020-06-11 03:33:41 | Sucre, Colombia | ||
1273670 | 1273670 | 2020-06-11 | Colombia | Sucre | 166 | 3 | 5 | 158 | 8.814 | -74.7233 | 2020-06-12 05:09:52 | Sucre, Colombia | ||
737700 | 737700 | 2020-06-12 | Colombia | Sucre | 174 | 5 | 6 | 163 | 8.814 | -74.7233 | 2020-06-13 03:33:14 | Sucre, Colombia | ||
3061380 | 3061380 | 2020-06-13 | Colombia | Sucre | 196 | 5 | 6 | 185 | 8.814 | -74.7233 | 2020-06-14 03:33:15 | Sucre, Colombia | ||
1837328 | 1837328 | 2020-06-14 | Colombia | Sucre | 213 | 8 | 7 | 198 | 8.814 | -74.7233 | 2020-06-15 03:33:14 | Sucre, Colombia | ||
287377 | 287377 | 2020-06-15 | Colombia | Sucre | 240 | 11 | 10 | 219 | 8.814 | -74.7233 | 2020-06-16 04:33:09 | Sucre, Colombia | ||
2386814 | 2386814 | 2020-06-16 | Colombia | Sucre | 240 | 11 | 10 | 219 | 8.814 | -74.7233 | 2020-06-17 04:33:21 | Sucre, Colombia | ||
1196051 | 1196051 | 2020-06-17 | Colombia | Sucre | 272 | 12 | 16 | 244 | 8.814 | -74.7233 | 2020-06-18 04:33:18 | Sucre, Colombia | ||
3682848 | 3682848 | 2020-06-18 | Colombia | Sucre | 300 | 12 | 21 | 267 | 8.814 | -74.7233 | 2020-06-19 04:33:17 | Sucre, Colombia | ||
1691699 | 1691699 | 2020-06-19 | Colombia | Sucre | 404 | 12 | 34 | 358 | 8.814 | -74.7233 | 2020-06-20 04:33:19 | Sucre, Colombia | ||
2438121 | 2438121 | 2020-06-20 | Colombia | Sucre | 448 | 15 | 36 | 397 | 8.814 | -74.7233 | 2020-06-21 04:33:19 | Sucre, Colombia | ||
3249528 | 3249528 | 2020-06-21 | Colombia | Sucre | 536 | 21 | 45 | 470 | 8.814 | -74.7233 | 2020-06-22 04:33:20 | Sucre, Colombia | ||
1510789 | 1510789 | 2020-06-22 | Colombia | Sucre | 588 | 22 | 47 | 519 | 8.814 | -74.7233 | 2020-06-23 04:33:22 | Sucre, Colombia | ||
1522595 | 1522595 | 2020-06-23 | Colombia | Sucre | 643 | 23 | 54 | 566 | 8.814 | -74.7233 | 2020-06-24 04:33:28 | Sucre, Colombia | ||
2700910 | 2700910 | 2020-06-24 | Colombia | Sucre | 643 | 23 | 54 | 566 | 8.814 | -74.7233 | 2020-06-25 05:26:54 | Sucre, Colombia | ||
2625270 | 2625270 | 2020-06-25 | Colombia | Sucre | 733 | 25 | 55 | 653 | 8.814 | -74.7233 | 2020-06-26 04:33:43 | Sucre, Colombia | ||
1136283 | 1136283 | 2020-06-26 | Colombia | Sucre | 847 | 31 | 65 | 751 | 8.814 | -74.7233 | 2020-06-27 04:33:35 | Sucre, Colombia | ||
2040002 | 2040002 | 2020-06-27 | Colombia | Sucre | 895 | 41 | 78 | 776 | 8.814 | -74.7233 | 2020-06-28 04:34:04 | Sucre, Colombia | ||
2306667 | 2306667 | 2020-06-28 | Colombia | Sucre | 1092 | 51 | 98 | 943 | 8.814 | -74.7233 | 2020-06-29 04:33:44 | Sucre, Colombia | ||
2633104 | 2633104 | 2020-06-29 | Colombia | Sucre | 1092 | 51 | 98 | 943 | 8.814 | -74.7233 | 2020-06-30 04:33:48 | Sucre, Colombia | ||
2974627 | 2974627 | 2020-06-30 | Colombia | Sucre | 1153 | 63 | 115 | 975 | 8.814 | -74.7233 | 2020-07-01 04:33:52 | Sucre, Colombia | ||
303249 | 303249 | 2020-07-01 | Colombia | Sucre | 1255 | 67 | 123 | 1065 | 8.814 | -74.7233 | 2020-07-02 04:33:46 | Sucre, Colombia | ||
3045558 | 3045558 | 2020-07-02 | Colombia | Sucre | 1373 | 75 | 133 | 1165 | 8.814 | -74.7233 | 2020-07-03 04:33:54 | Sucre, Colombia | ||
2234764 | 2234764 | 2020-07-03 | Colombia | Sucre | 1490 | 82 | 147 | 1261 | 8.814 | -74.7233 | 2020-07-04 04:33:51 | Sucre, Colombia | ||
530103 | 530103 | 2020-07-04 | Colombia | Sucre | 1549 | 90 | 155 | 1304 | 8.814 | -74.7233 | 2020-07-05 04:33:46 | Sucre, Colombia | ||
415541 | 415541 | 2020-07-05 | Colombia | Sucre | 1683 | 97 | 165 | 1421 | 8.814 | -74.7233 | 2020-07-06 04:33:57 | Sucre, Colombia | ||
2685076 | 2685076 | 2020-07-06 | Colombia | Sucre | 1825 | 100 | 192 | 1533 | 8.814 | -74.7233 | 2020-07-07 04:34:00 | Sucre, Colombia | ||
887516 | 887516 | 2020-07-07 | Colombia | Sucre | 1892 | 106 | 227 | 1559 | 8.814 | -74.7233 | 2020-07-08 05:33:48 | Sucre, Colombia | ||
2222907 | 2222907 | 2020-07-08 | Colombia | Sucre | 2003 | 111 | 261 | 1631 | 8.814 | -74.7233 | 2020-07-09 04:34:23 | Sucre, Colombia | ||
1005691 | 1005691 | 2020-07-09 | Colombia | Sucre | 2139 | 125 | 285 | 1729 | 8.814 | -74.7233 | 2020-07-10 04:34:24 | Sucre, Colombia | ||
3237706 | 3237706 | 2020-07-10 | Colombia | Sucre | 2273 | 137 | 333 | 1803 | 8.814 | -74.7233 | 2020-07-11 04:34:26 | Sucre, Colombia | ||
3436208 | 3436208 | 2020-07-11 | Colombia | Sucre | 2376 | 146 | 367 | 1863 | 8.814 | -74.7233 | 2020-07-12 04:34:30 | Sucre, Colombia | ||
3737813 | 3737813 | 2020-07-12 | Colombia | Sucre | 2419 | 157 | 387 | 1875 | 8.814 | -74.7233 | 2020-07-13 04:43:04 | Sucre, Colombia | ||
3491550 | 3491550 | 2020-07-13 | Colombia | Sucre | 2523 | 162 | 432 | 1929 | 8.814 | -74.7233 | 2020-07-14 04:34:46 | Sucre, Colombia | ||
2158909 | 2158909 | 2020-07-14 | Colombia | Sucre | 2583 | 168 | 516 | 1899 | 8.814 | -74.7233 | 2020-07-15 04:34:39 | Sucre, Colombia | ||
2748265 | 2748265 | 2020-07-15 | Colombia | Sucre | 2723 | 170 | 607 | 1946 | 8.814 | -74.7233 | 2020-07-16 04:44:59 | Sucre, Colombia | ||
367597 | 367597 | 2020-07-16 | Colombia | Sucre | 2772 | 178 | 670 | 1924 | 8.814 | -74.7233 | 2020-07-17 04:34:50 | Sucre, Colombia | ||
2708787 | 2708787 | 2020-07-17 | Colombia | Sucre | 3448 | 198 | 911 | 2339 | 8.814 | -74.7233 | 2020-07-18 04:34:45 | Sucre, Colombia | ||
3205485 | 3205485 | 2020-07-18 | Colombia | Sucre | 3933 | 209 | 1035 | 2689 | 8.814 | -74.7233 | 2020-07-19 04:34:58 | Sucre, Colombia | ||
122096 | 122096 | 2020-07-19 | Colombia | Sucre | 4139 | 225 | 1235 | 2679 | 8.814 | -74.7233 | 2020-07-20 05:34:40 | Sucre, Colombia | ||
327191 | 327191 | 2020-07-20 | Colombia | Sucre | 4346 | 239 | 1363 | 2744 | 8.814 | -74.7233 | 2020-07-21 04:38:46 | Sucre, Colombia | ||
1707700 | 1707700 | 2020-07-21 | Colombia | Sucre | 4613 | 247 | 1410 | 2956 | 8.814 | -74.7233 | 2020-07-22 04:34:42 | Sucre, Colombia | ||
844961 | 844961 | 2020-07-22 | Colombia | Sucre | 4726 | 258 | 1492 | 2976 | 8.814 | -74.7233 | 2020-07-23 05:15:04 | Sucre, Colombia | ||
62147 | 62147 | 2020-07-23 | Colombia | Sucre | 4851 | 276 | 1679 | 2896 | 8.814 | -74.7233 | 2020-07-24 05:30:40 | Sucre, Colombia | ||
2563941 | 2563941 | 2020-07-24 | Colombia | Sucre | 4974 | 302 | 1733 | 2939 | 8.814 | -74.7233 | 2020-07-25 04:47:39 | Sucre, Colombia | ||
1502971 | 1502971 | 2020-07-25 | Colombia | Sucre | 5119 | 327 | 1972 | 2820 | 8.814 | -74.7233 | 2020-07-26 04:35:00 | Sucre, Colombia | ||
442727 | 442727 | 2020-07-26 | Colombia | Sucre | 5119 | 327 | 1972 | 2820 | 8.814 | -74.7233 | 2020-07-27 04:35:02 | Sucre, Colombia | ||
177414 | 177414 | 2020-07-27 | Colombia | Sucre | 5440 | 346 | 2286 | 2808 | 8.814 | -74.7233 | 2020-07-28 04:58:43 | Sucre, Colombia | ||
3185363 | 3185363 | 2020-07-28 | Colombia | Sucre | 5663 | 351 | 2476 | 2836 | 8.814 | -74.7233 | 2020-07-29 04:35:11 | Sucre, Colombia | ||
2958747 | 2958747 | 2020-07-29 | Colombia | Sucre | 5742 | 356 | 2722 | 2664 | 8.814 | -74.7233 | 2020-07-30 04:35:05 | Sucre, Colombia | ||
1928579 | 1928579 | 2020-07-30 | Colombia | Sucre | 5817 | 363 | 2924 | 2530 | 8.814 | -74.7233 | 2020-07-31 04:35:18 | Sucre, Colombia | ||
3264872 | 3264872 | 2020-07-31 | Colombia | Sucre | 5928 | 371 | 3013 | 2544 | 8.814 | -74.7233 | 2020-08-01 04:36:27 | Sucre, Colombia | ||
753707 | 753707 | 2020-08-01 | Colombia | Sucre | 6002 | 372 | 3166 | 2464 | 8.814 | -74.7233 | 2020-08-02 04:34:47 | Sucre, Colombia | ||
2808139 | 2808139 | 2020-08-02 | Colombia | Sucre | 6115 | 377 | 3355 | 2383 | 8.814 | -74.7233 | 2020-08-03 04:34:35 | Sucre, Colombia | ||
2740387 | 2740387 | 2020-08-03 | Colombia | Sucre | 6326 | 381 | 3405 | 2540 | 8.814 | -74.7233 | 2020-08-04 04:41:59 | Sucre, Colombia | ||
98504 | 98504 | 2020-08-04 | Colombia | Sucre | 6497 | 386 | 3710 | 2401 | 8.814 | -74.7233 | 2020-08-05 04:34:43 | Sucre, Colombia | ||
3793268 | 3793268 | 2020-08-05 | Colombia | Sucre | 6735 | 387 | 3866 | 2482 | 8.814 | -74.7233 | 2020-08-06 04:35:02 | Sucre, Colombia | ||
3612438 | 3612438 | 2020-08-06 | Colombia | Sucre | 6984 | 391 | 4054 | 2539 | 8.814 | -74.7233 | 2020-08-07 04:35:11 | Sucre, Colombia | ||
458753 | 458753 | 2020-08-07 | Colombia | Sucre | 7119 | 393 | 4209 | 2517 | 8.814 | -74.7233 | 2020-08-08 04:34:53 | Sucre, Colombia | ||
371569 | 371569 | 2020-08-08 | Colombia | Sucre | 7230 | 393 | 4353 | 2484 | 8.814 | -74.7233 | 2020-08-09 04:34:54 | Sucre, Colombia | ||
3923401 | 3923401 | 2020-08-09 | Colombia | Sucre | 7448 | 395 | 4512 | 2541 | 8.814 | -74.7233 | 2020-08-10 04:34:55 | Sucre, Colombia | ||
1920592 | 1920592 | 2020-08-10 | Colombia | Sucre | 7575 | 395 | 4722 | 2458 | 8.814 | -74.7233 | 2020-08-11 04:35:08 | Sucre, Colombia | ||
662161 | 662161 | 2020-08-11 | Colombia | Sucre | 7739 | 400 | 4808 | 2531 | 8.814 | -74.7233 | 2020-08-12 04:27:29 | Sucre, Colombia | ||
3531312 | 3531312 | 2020-08-12 | Colombia | Sucre | 7878 | 402 | 4924 | 2552 | 8.814 | -74.7233 | 2020-08-13 04:29:15 | Sucre, Colombia | ||
582693 | 582693 | 2020-08-13 | Colombia | Sucre | 8128 | 409 | 5088 | 2631 | 8.814 | -74.7233 | 2020-08-14 04:51:19 | Sucre, Colombia | ||
1612109 | 1612109 | 2020-08-14 | Colombia | Sucre | 8232 | 412 | 5280 | 2540 | 8.814 | -74.7233 | 2020-08-15 04:27:31 | Sucre, Colombia | ||
145834 | 145834 | 2020-08-15 | Colombia | Sucre | 8443 | 413 | 5512 | 2518 | 8.814 | -74.7233 | 2020-08-16 04:27:42 | Sucre, Colombia | ||
1555832 | 1555832 | 2020-08-16 | Colombia | Sucre | 8714 | 419 | 5784 | 2511 | 8.814 | -74.7233 | 2020-08-17 04:27:20 | Sucre, Colombia | ||
837474 | 837474 | 2020-08-17 | Colombia | Sucre | 8797 | 422 | 6005 | 2370 | 8.814 | -74.7233 | 2020-08-18 04:27:56 | Sucre, Colombia | ||
3177870 | 3177870 | 2020-08-18 | Colombia | Sucre | 9015 | 424 | 6174 | 2417 | 8.814 | -74.7233 | 2020-08-19 04:27:00 | Sucre, Colombia | ||
206116 | 206116 | 2020-08-19 | Colombia | Sucre | 9440 | 429 | 6398 | 2613 | 8.814 | -74.7233 | 2020-08-20 04:27:43 | Sucre, Colombia | ||
3484167 | 3484167 | 2020-08-20 | Colombia | Sucre | 9827 | 429 | 6677 | 2721 | 8.814 | -74.7233 | 2020-08-21 04:27:41 | Sucre, Colombia | ||
1479418 | 1479418 | 2020-08-21 | Colombia | Sucre | 10113 | 433 | 6872 | 2808 | 8.814 | -74.7233 | 2020-08-22 04:27:49 | Sucre, Colombia | ||
2299311 | 2299311 | 2020-08-22 | Colombia | Sucre | 10113 | 433 | 6872 | 2808 | 8.814 | -74.7233 | 2020-08-23 04:27:48 | Sucre, Colombia | ||
2215529 | 2215529 | 2020-08-23 | Colombia | Sucre | 10357 | 449 | 7530 | 2378 | 8.814 | -74.7233 | 2020-08-24 04:27:56 | Sucre, Colombia | ||
2991134 | 2991134 | 2020-08-24 | Colombia | Sucre | 10505 | 457 | 7704 | 2344 | 8.814 | -74.7233 | 2020-08-25 04:28:02 | Sucre, Colombia | ||
3562430 | 3562430 | 2020-08-25 | Colombia | Sucre | 10858 | 462 | 8001 | 2395 | 8.814 | -74.7233 | 2020-08-26 04:28:11 | Sucre, Colombia | ||
1996506 | 1996506 | 2020-08-26 | Colombia | Sucre | 10999 | 467 | 8294 | 2238 | 8.814 | -74.7233 | 2020-08-27 04:28:15 | Sucre, Colombia | ||
2510046 | 2510046 | 2020-08-27 | Colombia | Sucre | 11168 | 469 | 8520 | 2179 | 8.814 | -74.7233 | 2020-08-28 04:28:11 | Sucre, Colombia | ||
1523045 | 1523045 | 2020-08-28 | Colombia | Sucre | 11365 | 475 | 8854 | 2036 | 8.814 | -74.7233 | 2020-08-29 04:28:19 | Sucre, Colombia | ||
609550 | 609550 | 2020-08-29 | Colombia | Sucre | 11506 | 481 | 9036 | 1989 | 8.814 | -74.7233 | 2020-08-30 04:28:22 | Sucre, Colombia | ||
3931888 | 3931888 | 2020-08-30 | Colombia | Sucre | 11624 | 488 | 9310 | 1826 | 8.814 | -74.7233 | 2020-08-31 04:28:27 | Sucre, Colombia | ||
193929 | 193929 | 2020-08-31 | Colombia | Sucre | 11709 | 491 | 9493 | 1725 | 8.814 | -74.7233 | 2020-09-01 04:28:31 | Sucre, Colombia | ||
2059744 | 2059744 | 2020-09-01 | Colombia | Sucre | 11778 | 495 | 9527 | 1756 | 8.814 | -74.7233 | 2020-09-02 04:28:25 | Sucre, Colombia | ||
1105415 | 1105415 | 2020-09-02 | Colombia | Sucre | 11939 | 503 | 9600 | 1836 | 8.814 | -74.7233 | 2020-09-03 04:28:22 | Sucre, Colombia | ||
1354178 | 1354178 | 2020-09-03 | Colombia | Sucre | 12022 | 509 | 9840 | 1673 | 8.814 | -74.7233 | 2020-09-04 04:28:26 | Sucre, Colombia | ||
2661638 | 2661638 | 2020-09-04 | Colombia | Sucre | 12022 | 509 | 9840 | 1673 | 8.814 | -74.7233 | 2020-09-05 04:28:19 | Sucre, 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]);