johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,068 rows where country_or_region = "Sri Lanka" sorted by recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, last_update (date)
day (date) >30 ✖
- 2020-01-27 1
- 2020-01-28 1
- 2020-01-29 1
- 2020-01-30 1
- 2020-01-31 1
- 2020-02-01 1
- 2020-02-02 1
- 2020-02-03 1
- 2020-02-04 1
- 2020-02-05 1
- 2020-02-06 1
- 2020-02-07 1
- 2020-02-08 1
- 2020-02-09 1
- 2020-02-10 1
- 2020-02-11 1
- 2020-02-12 1
- 2020-02-13 1
- 2020-02-14 1
- 2020-02-15 1
- 2020-02-16 1
- 2020-02-17 1
- 2020-02-18 1
- 2020-02-19 1
- 2020-02-20 1
- 2020-02-21 1
- 2020-02-22 1
- 2020-02-23 1
- 2020-02-24 1
- 2020-02-25 1
- …
country_or_region 1
- Sri Lanka · 1,068 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▲ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
332212 | 332212 | 2021-08-04 | Sri Lanka | 318775 | 4727 | 284524 | 29524 | 7.873054 | 80.77179699999998 | 2021-08-05 04:21:51 | Sri Lanka | |||
3468483 | 3468483 | 2021-08-03 | Sri Lanka | 316219 | 4645 | 282770 | 28804 | 7.873054 | 80.77179699999998 | 2021-08-04 04:21:25 | Sri Lanka | |||
3683757 | 3683757 | 2021-08-02 | Sri Lanka | 313769 | 4571 | 280868 | 28330 | 7.873054 | 80.77179699999998 | 2021-08-03 04:21:39 | Sri Lanka | |||
3015656 | 3015656 | 2021-08-01 | Sri Lanka | 311349 | 4503 | 278910 | 27936 | 7.873054 | 80.77179699999998 | 2021-08-02 04:21:36 | Sri Lanka | |||
3904279 | 3904279 | 2021-07-31 | Sri Lanka | 308812 | 4436 | 277118 | 27258 | 7.873054 | 80.77179699999998 | 2021-08-01 04:21:50 | Sri Lanka | |||
3296484 | 3296484 | 2021-07-30 | Sri Lanka | 306662 | 4380 | 275212 | 27070 | 7.873054 | 80.77179699999998 | 2021-07-31 04:21:35 | Sri Lanka | |||
3385695 | 3385695 | 2021-07-29 | Sri Lanka | 304202 | 4324 | 273496 | 26382 | 7.873054 | 80.77179699999998 | 2021-07-30 04:21:34 | Sri Lanka | |||
408600 | 408600 | 2021-07-28 | Sri Lanka | 301832 | 4258 | 271855 | 25719 | 7.873054 | 80.77179699999998 | 2021-07-29 04:21:33 | Sri Lanka | |||
1306461 | 1306461 | 2021-07-27 | Sri Lanka | 299892 | 4195 | 270356 | 25341 | 7.873054 | 80.77179699999998 | 2021-07-28 04:21:39 | Sri Lanka | |||
3218604 | 3218604 | 2021-07-26 | Sri Lanka | 298181 | 4147 | 269007 | 25027 | 7.873054 | 80.77179699999998 | 2021-07-27 04:21:18 | Sri Lanka | |||
1378813 | 1378813 | 2021-07-25 | Sri Lanka | 296516 | 4099 | 267602 | 24815 | 7.873054 | 80.77179699999998 | 2021-07-26 04:21:28 | Sri Lanka | |||
1330553 | 1330553 | 2021-07-24 | Sri Lanka | 294850 | 4054 | 266665 | 24131 | 7.873054 | 80.77179699999998 | 2021-07-25 04:22:12 | Sri Lanka | |||
3137857 | 3137857 | 2021-07-23 | Sri Lanka | 292608 | 4002 | 265708 | 22898 | 7.873054 | 80.77179699999998 | 2021-07-24 00:21:36 | Sri Lanka | |||
3476617 | 3476617 | 2021-07-22 | Sri Lanka | 291298 | 3959 | 264755 | 22584 | 7.873054 | 80.77179699999998 | 2021-07-23 04:21:29 | Sri Lanka | |||
3331836 | 3331836 | 2021-07-21 | Sri Lanka | 289577 | 3917 | 263758 | 21902 | 7.873054 | 80.77179699999998 | 2021-07-22 04:21:19 | Sri Lanka | |||
2371817 | 2371817 | 2021-07-20 | Sri Lanka | 287973 | 3870 | 262828 | 21275 | 7.873054 | 80.77179699999998 | 2021-07-21 04:21:40 | Sri Lanka | |||
483896 | 483896 | 2021-07-19 | Sri Lanka | 286419 | 3827 | 261848 | 20744 | 7.873054 | 80.77179699999998 | 2021-07-20 04:21:48 | Sri Lanka | |||
2674119 | 2674119 | 2021-07-18 | Sri Lanka | 284932 | 3779 | 256676 | 24477 | 7.873054 | 80.77179699999998 | 2021-07-19 04:21:24 | Sri Lanka | |||
3706431 | 3706431 | 2021-07-17 | Sri Lanka | 283512 | 3733 | 255833 | 23946 | 7.873054 | 80.77179699999998 | 2021-07-18 04:22:07 | Sri Lanka | |||
2947662 | 2947662 | 2021-07-16 | Sri Lanka | 282060 | 3702 | 254871 | 23487 | 7.873054 | 80.77179699999998 | 2021-07-17 04:22:22 | Sri Lanka | |||
296318 | 296318 | 2021-07-15 | Sri Lanka | 280543 | 3661 | 253953 | 22929 | 7.873054 | 80.77179699999998 | 2021-07-16 04:21:22 | Sri Lanka | |||
3632263 | 3632263 | 2021-07-14 | Sri Lanka | 279059 | 3611 | 253014 | 22434 | 7.873054 | 80.77179699999998 | 2021-07-15 04:21:48 | Sri Lanka | |||
579138 | 579138 | 2021-07-13 | Sri Lanka | 277519 | 3574 | 247569 | 26376 | 7.873054 | 80.77179699999998 | 2021-07-14 04:21:35 | Sri Lanka | |||
3741387 | 3741387 | 2021-07-12 | Sri Lanka | 276106 | 3533 | 246241 | 26332 | 7.873054 | 80.77179699999998 | 2021-07-13 04:21:18 | Sri Lanka | |||
3659900 | 3659900 | 2021-07-11 | Sri Lanka | 274538 | 3502 | 244437 | 26599 | 7.873054 | 80.77179699999998 | 2021-07-12 04:21:34 | Sri Lanka | |||
626184 | 626184 | 2021-07-10 | Sri Lanka | 273031 | 3467 | 242839 | 26725 | 7.873054 | 80.77179699999998 | 2021-07-11 04:21:43 | Sri Lanka | |||
829903 | 829903 | 2021-07-09 | Sri Lanka | 271483 | 3434 | 241035 | 27014 | 7.873054 | 80.77179699999998 | 2021-07-10 04:21:25 | Sri Lanka | |||
778667 | 778667 | 2021-07-08 | Sri Lanka | 269946 | 3391 | 239584 | 26971 | 7.873054 | 80.77179699999998 | 2021-07-09 04:21:21 | Sri Lanka | |||
1440889 | 1440889 | 2021-07-07 | Sri Lanka | 268676 | 3351 | 238131 | 27194 | 7.873054 | 80.77179699999998 | 2021-07-08 04:21:26 | Sri Lanka | |||
2693994 | 2693994 | 2021-07-06 | Sri Lanka | 267433 | 3313 | 236659 | 27461 | 7.873054 | 80.77179699999998 | 2021-07-07 04:21:20 | Sri Lanka | |||
1932743 | 1932743 | 2021-07-05 | Sri Lanka | 266499 | 3268 | 234942 | 28289 | 7.873054 | 80.77179699999998 | 2021-07-06 04:21:32 | Sri Lanka | |||
1165474 | 1165474 | 2021-07-04 | Sri Lanka | 265630 | 3236 | 233317 | 29077 | 7.873054 | 80.77179699999998 | 2021-07-05 04:21:28 | Sri Lanka | |||
1495908 | 1495908 | 2021-07-03 | Sri Lanka | 264057 | 3191 | 231394 | 29472 | 7.873054 | 80.77179699999998 | 2021-07-04 04:21:38 | Sri Lanka | |||
2072223 | 2072223 | 2021-07-02 | Sri Lanka | 262795 | 3157 | 229541 | 30097 | 7.873054 | 80.77179699999998 | 2021-07-03 04:21:37 | Sri Lanka | |||
2765239 | 2765239 | 2021-07-01 | Sri Lanka | 260972 | 3120 | 227840 | 30012 | 7.873054 | 80.77179699999998 | 2021-07-02 04:21:47 | Sri Lanka | |||
1893447 | 1893447 | 2021-06-30 | Sri Lanka | 259089 | 3077 | 225952 | 30060 | 7.873054 | 80.77179699999998 | 2021-07-01 04:21:19 | Sri Lanka | |||
400570 | 400570 | 2021-06-29 | Sri Lanka | 257225 | 3030 | 223471 | 30724 | 7.873054 | 80.77179699999998 | 2021-06-30 04:21:41 | Sri Lanka | |||
3125813 | 3125813 | 2021-06-28 | Sri Lanka | 255508 | 2985 | 221249 | 31274 | 7.873054 | 80.77179699999998 | 2021-06-29 04:21:28 | Sri Lanka | |||
2590308 | 2590308 | 2021-06-27 | Sri Lanka | 253618 | 2944 | 218998 | 31676 | 7.873054 | 80.77179699999998 | 2021-06-28 04:21:29 | Sri Lanka | |||
1712631 | 1712631 | 2021-06-25 | Sri Lanka | 249926 | 2862 | 214668 | 32396 | 7.873054 | 80.77179699999998 | 2021-06-26 04:21:43 | Sri Lanka | |||
3958812 | 3958812 | 2021-06-26 | Sri Lanka | 251751 | 2905 | 214668 | 34178 | 7.873054 | 80.77179699999998 | 2021-06-27 04:21:39 | Sri Lanka | |||
2295756 | 2295756 | 2021-06-24 | Sri Lanka | 248050 | 2814 | 212825 | 32411 | 7.873054 | 80.77179699999998 | 2021-06-25 04:21:33 | Sri Lanka | |||
2423196 | 2423196 | 2021-06-23 | Sri Lanka | 246109 | 2769 | 211186 | 32154 | 7.873054 | 80.77179699999998 | 2021-06-24 04:21:55 | Sri Lanka | |||
563273 | 563273 | 2021-06-22 | Sri Lanka | 243913 | 2704 | 209296 | 31913 | 7.873054 | 80.77179699999998 | 2021-06-23 04:21:46 | Sri Lanka | |||
2884674 | 2884674 | 2021-06-20 | Sri Lanka | 239689 | 2581 | 201389 | 35719 | 7.873054 | 80.77179699999998 | 2021-06-21 04:21:41 | Sri Lanka | |||
3358975 | 3358975 | 2021-06-21 | Sri Lanka | 241820 | 2633 | 201389 | 37798 | 7.873054 | 80.77179699999998 | 2021-06-22 04:21:34 | Sri Lanka | |||
107757 | 107757 | 2021-06-19 | Sri Lanka | 237661 | 2534 | 199393 | 35734 | 7.873054 | 80.77179699999998 | 2021-06-20 04:21:48 | Sri Lanka | |||
1125900 | 1125900 | 2021-06-18 | Sri Lanka | 235413 | 2480 | 197259 | 35674 | 7.873054 | 80.77179699999998 | 2021-06-19 04:22:33 | Sri Lanka | |||
2911478 | 2911478 | 2021-06-17 | Sri Lanka | 233064 | 2425 | 195434 | 35205 | 7.873054 | 80.77179699999998 | 2021-06-18 04:22:16 | Sri Lanka | |||
3030594 | 3030594 | 2021-06-16 | Sri Lanka | 230692 | 2374 | 194145 | 34173 | 7.873054 | 80.77179699999998 | 2021-06-17 04:22:36 | Sri Lanka | |||
2339700 | 2339700 | 2021-06-15 | Sri Lanka | 228256 | 2315 | 192478 | 33463 | 7.873054 | 80.77179699999998 | 2021-06-16 04:22:32 | Sri Lanka | |||
1564396 | 1564396 | 2021-06-14 | Sri Lanka | 225922 | 2260 | 190464 | 33198 | 7.873054 | 80.77179699999998 | 2021-06-15 04:22:22 | Sri Lanka | |||
3381679 | 3381679 | 2021-06-13 | Sri Lanka | 223638 | 2136 | 188547 | 32955 | 7.873054 | 80.77179699999998 | 2021-06-14 04:22:46 | Sri Lanka | |||
1736813 | 1736813 | 2021-06-12 | Sri Lanka | 221277 | 2073 | 186516 | 32688 | 7.873054 | 80.77179699999998 | 2021-06-13 04:22:44 | Sri Lanka | |||
3970854 | 3970854 | 2021-06-11 | Sri Lanka | 218366 | 2011 | 184090 | 32265 | 7.873054 | 80.77179699999998 | 2021-06-12 04:22:22 | Sri Lanka | |||
2717276 | 2717276 | 2021-06-10 | Sri Lanka | 216134 | 1910 | 182238 | 31986 | 7.873054 | 80.77179699999998 | 2021-06-11 04:23:20 | Sri Lanka | |||
523161 | 523161 | 2021-06-09 | Sri Lanka | 213396 | 1910 | 180427 | 31059 | 7.873054 | 80.77179699999998 | 2021-06-10 04:23:17 | Sri Lanka | |||
3472601 | 3472601 | 2021-06-08 | Sri Lanka | 210661 | 1844 | 178259 | 30558 | 7.873054 | 80.77179699999998 | 2021-06-09 04:23:31 | Sri Lanka | |||
3145885 | 3145885 | 2021-06-07 | Sri Lanka | 207979 | 1789 | 176045 | 30145 | 7.873054 | 80.77179699999998 | 2021-06-08 04:22:35 | Sri Lanka | |||
825887 | 825887 | 2021-06-06 | Sri Lanka | 205333 | 1696 | 167304 | 36333 | 7.873054 | 80.77179699999998 | 2021-06-07 04:22:51 | Sri Lanka | |||
2586292 | 2586292 | 2021-06-05 | Sri Lanka | 202357 | 1656 | 166132 | 34569 | 7.873054 | 80.77179699999998 | 2021-06-06 04:24:03 | Sri Lanka | |||
2315606 | 2315606 | 2021-06-04 | Sri Lanka | 199254 | 1656 | 164281 | 33317 | 7.873054 | 80.77179699999998 | 2021-06-05 04:23:03 | Sri Lanka | |||
1448891 | 1448891 | 2021-06-03 | Sri Lanka | 195844 | 1608 | 162397 | 31839 | 7.873054 | 80.77179699999998 | 2021-06-04 04:23:37 | Sri Lanka | |||
1708615 | 1708615 | 2021-06-02 | Sri Lanka | 192547 | 1566 | 160714 | 30267 | 7.873054 | 80.77179699999998 | 2021-06-03 04:23:32 | Sri Lanka | |||
2104433 | 2104433 | 2021-06-01 | Sri Lanka | 189241 | 1484 | 153371 | 34386 | 7.873054 | 80.77179699999998 | 2021-06-02 04:24:34 | Sri Lanka | |||
1189049 | 1189049 | 2021-05-31 | Sri Lanka | 186364 | 1441 | 151740 | 33183 | 7.873054 | 80.77179699999998 | 2021-06-01 04:23:09 | Sri Lanka | |||
3089726 | 3089726 | 2021-05-30 | Sri Lanka | 183452 | 1441 | 149825 | 32186 | 7.873054 | 80.77179699999998 | 2021-05-31 03:08:59 | Sri Lanka | |||
51095 | 51095 | 2021-05-29 | Sri Lanka | 180593 | 1363 | 148391 | 30839 | 7.873054 | 80.77179699999998 | 2021-05-30 04:20:55 | Sri Lanka | |||
20674 | 20674 | 2021-05-28 | Sri Lanka | 177711 | 1363 | 146362 | 29986 | 7.873054 | 80.77179699999998 | 2021-05-29 04:20:41 | Sri Lanka | |||
1807049 | 1807049 | 2021-05-27 | Sri Lanka | 174861 | 1298 | 143789 | 29774 | 7.873054 | 80.77179699999998 | 2021-05-28 04:20:36 | Sri Lanka | |||
1310472 | 1310472 | 2021-05-26 | Sri Lanka | 172277 | 1298 | 142378 | 28601 | 7.873054 | 80.77179699999998 | 2021-05-27 04:20:59 | Sri Lanka | |||
83398 | 83398 | 2021-05-25 | Sri Lanka | 169900 | 1269 | 141175 | 27456 | 7.873054 | 80.77179699999998 | 2021-05-26 04:20:35 | Sri Lanka | |||
1413360 | 1413360 | 2021-05-24 | Sri Lanka | 167172 | 1243 | 139947 | 25982 | 7.873054 | 80.77179699999998 | 2021-05-25 04:21:08 | Sri Lanka | |||
1771646 | 1771646 | 2021-05-23 | Sri Lanka | 164201 | 1210 | 128607 | 34384 | 7.873054 | 80.77179699999998 | 2021-05-24 04:20:53 | Sri Lanka | |||
726801 | 726801 | 2021-05-22 | Sri Lanka | 161242 | 1178 | 126995 | 33069 | 7.873054 | 80.77179699999998 | 2021-05-23 04:20:51 | Sri Lanka | |||
1952816 | 1952816 | 2021-05-21 | Sri Lanka | 158333 | 1133 | 125360 | 31840 | 7.873054 | 80.77179699999998 | 2021-05-22 04:20:45 | Sri Lanka | |||
1913515 | 1913515 | 2021-05-20 | Sri Lanka | 154786 | 1051 | 123532 | 30203 | 7.873054 | 80.77179699999998 | 2021-05-21 04:20:43 | Sri Lanka | |||
2256036 | 2256036 | 2021-05-19 | Sri Lanka | 151343 | 1051 | 122367 | 27925 | 7.873054 | 80.77179699999998 | 2021-05-20 04:21:05 | Sri Lanka | |||
2391074 | 2391074 | 2021-05-18 | Sri Lanka | 147720 | 1015 | 121145 | 25560 | 7.873054 | 80.77179699999998 | 2021-05-19 04:20:42 | Sri Lanka | |||
3574899 | 3574899 | 2021-05-17 | Sri Lanka | 145202 | 981 | 119629 | 24592 | 7.873054 | 80.77179699999998 | 2021-05-18 04:20:33 | Sri Lanka | |||
2939629 | 2939629 | 2021-05-16 | Sri Lanka | 142746 | 962 | 118322 | 23462 | 7.873054 | 80.77179699999998 | 2021-05-17 04:20:34 | Sri Lanka | |||
1873259 | 1873259 | 2021-05-15 | Sri Lanka | 140471 | 941 | 117220 | 22310 | 7.873054 | 80.77179699999998 | 2021-05-16 04:20:49 | Sri Lanka | |||
1082228 | 1082228 | 2021-05-14 | Sri Lanka | 138085 | 923 | 110108 | 27054 | 7.873054 | 80.77179699999998 | 2021-05-15 04:20:58 | Sri Lanka | |||
3054494 | 3054494 | 2021-05-13 | Sri Lanka | 135796 | 892 | 108802 | 26102 | 7.873054 | 80.77179699999998 | 2021-05-14 04:20:41 | Sri Lanka | |||
2004964 | 2004964 | 2021-05-12 | Sri Lanka | 133527 | 850 | 107657 | 25020 | 7.873054 | 80.77179699999998 | 2021-05-13 04:20:51 | Sri Lanka | |||
3954795 | 3954795 | 2021-05-11 | Sri Lanka | 131098 | 850 | 106641 | 23607 | 7.873054 | 80.77179699999998 | 2021-05-12 04:21:29 | Sri Lanka | |||
2821074 | 2821074 | 2021-05-10 | Sri Lanka | 128530 | 827 | 105611 | 22092 | 7.873054 | 80.77179699999998 | 2021-05-11 04:20:41 | Sri Lanka | |||
1425406 | 1425406 | 2021-05-09 | Sri Lanka | 125906 | 801 | 104463 | 20642 | 7.873054 | 80.77179699999998 | 2021-05-10 04:20:38 | Sri Lanka | |||
1552274 | 1552274 | 2021-05-08 | Sri Lanka | 123234 | 786 | 103098 | 19350 | 7.873054 | 80.77179699999998 | 2021-05-09 04:20:35 | Sri Lanka | |||
2502332 | 2502332 | 2021-05-07 | Sri Lanka | 121338 | 764 | 101763 | 18811 | 7.873054 | 80.77179699999998 | 2021-05-08 04:21:04 | Sri Lanka | |||
3113788 | 3113788 | 2021-05-06 | Sri Lanka | 119424 | 745 | 100885 | 17794 | 7.873054 | 80.77179699999998 | 2021-05-07 04:20:40 | Sri Lanka | |||
646255 | 646255 | 2021-05-05 | Sri Lanka | 117529 | 734 | 100075 | 16720 | 7.873054 | 80.77179699999998 | 2021-05-06 04:20:38 | Sri Lanka | |||
3675955 | 3675955 | 2021-05-04 | Sri Lanka | 115590 | 709 | 99153 | 15728 | 7.873054 | 80.77179699999998 | 2021-05-05 04:20:43 | Sri Lanka | |||
2761222 | 2761222 | 2021-05-03 | Sri Lanka | 113676 | 709 | 98209 | 14758 | 7.873054 | 80.77179699999998 | 2021-05-04 04:20:34 | Sri Lanka | |||
2451075 | 2451075 | 2021-05-02 | Sri Lanka | 111753 | 696 | 97848 | 13209 | 7.873054 | 80.77179699999998 | 2021-05-03 04:20:39 | Sri Lanka | |||
2825088 | 2825088 | 2021-05-01 | Sri Lanka | 109862 | 687 | 96478 | 12697 | 7.873054 | 80.77179699999998 | 2021-05-02 04:20:48 | Sri Lanka | |||
380496 | 380496 | 2021-04-30 | Sri Lanka | 108146 | 678 | 95975 | 11493 | 7.873054 | 80.77179699999998 | 2021-05-01 04:20:47 | Sri Lanka | |||
1636619 | 1636619 | 2021-04-29 | Sri Lanka | 106484 | 661 | 95445 | 10378 | 7.873054 | 80.77179699999998 | 2021-04-30 04:21:03 | Sri Lanka | |||
3393698 | 3393698 | 2021-04-28 | Sri Lanka | 104953 | 661 | 95083 | 9209 | 7.873054 | 80.77179699999998 | 2021-04-29 04:20:55 | Sri Lanka | |||
3702414 | 3702414 | 2021-04-27 | Sri Lanka | 103487 | 647 | 94856 | 7984 | 7.873054 | 80.77179699999998 | 2021-04-28 04:20:32 | Sri Lanka |
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]);