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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Sri Lanka · 265 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026652 | 1026652 | 2020-10-17 | Sri Lanka | 5475 | 13 | 3395 | 2067 | 7.873054 | 80.77179699999998 | 2020-10-18 04:24:25 | Sri Lanka | |||
2857147 | 2857147 | 2020-10-16 | Sri Lanka | 5354 | 13 | 3385 | 1956 | 7.873054 | 80.77179699999998 | 2020-10-17 04:24:12 | Sri Lanka | |||
786677 | 786677 | 2020-10-15 | Sri Lanka | 5244 | 13 | 3380 | 1851 | 7.873054 | 80.77179699999998 | 2020-10-16 04:24:01 | Sri Lanka | |||
79388 | 79388 | 2020-10-14 | Sri Lanka | 5170 | 13 | 3357 | 1800 | 7.873054 | 80.77179699999998 | 2020-10-15 04:24:28 | Sri Lanka | |||
3782203 | 3782203 | 2020-10-13 | Sri Lanka | 5038 | 13 | 3328 | 1697 | 7.873054 | 80.77179699999998 | 2020-10-14 04:24:05 | Sri Lanka | |||
2291743 | 2291743 | 2020-10-12 | Sri Lanka | 4844 | 13 | 3317 | 1514 | 7.873054 | 80.77179699999998 | 2020-10-13 04:24:02 | Sri Lanka | |||
3786195 | 3786195 | 2020-10-11 | Sri Lanka | 4752 | 13 | 3307 | 1432 | 7.873054 | 80.77179699999998 | 2020-10-12 04:23:45 | Sri Lanka | |||
2602333 | 2602333 | 2020-10-10 | Sri Lanka | 4628 | 13 | 3306 | 1309 | 7.873054 | 80.77179699999998 | 2020-10-11 04:23:46 | Sri Lanka | |||
817866 | 817866 | 2020-10-09 | Sri Lanka | 4523 | 13 | 3296 | 1214 | 7.873054 | 80.77179699999998 | 2020-10-10 04:23:57 | Sri Lanka | |||
2689981 | 2689981 | 2020-10-08 | Sri Lanka | 4488 | 13 | 3278 | 1197 | 7.873054 | 80.77179699999998 | 2020-10-09 04:23:59 | Sri Lanka | |||
1042123 | 1042123 | 2020-10-07 | Sri Lanka | 4459 | 13 | 3274 | 1172 | 7.873054 | 80.77179699999998 | 2020-10-08 04:23:56 | Sri Lanka | |||
3117784 | 3117784 | 2020-10-06 | Sri Lanka | 4252 | 13 | 3266 | 973 | 7.873054 | 80.77179699999998 | 2020-10-07 04:23:40 | Sri Lanka | |||
3802196 | 3802196 | 2020-10-05 | Sri Lanka | 3513 | 13 | 3259 | 241 | 7.873054 | 80.77179699999998 | 2020-10-06 04:23:33 | Sri Lanka | |||
1823086 | 1823086 | 2020-10-04 | Sri Lanka | 3402 | 13 | 3258 | 131 | 7.873054 | 80.77179699999998 | 2020-10-05 04:23:33 | Sri Lanka | |||
2514470 | 2514470 | 2020-10-03 | Sri Lanka | 3395 | 13 | 3254 | 128 | 7.873054 | 80.77179699999998 | 2020-10-04 04:23:44 | Sri Lanka | |||
3389688 | 3389688 | 2020-10-02 | Sri Lanka | 3388 | 13 | 3245 | 130 | 7.873054 | 80.77179699999998 | 2020-10-03 04:23:40 | Sri Lanka | |||
2379929 | 2379929 | 2020-10-01 | Sri Lanka | 3382 | 13 | 3233 | 136 | 7.873054 | 80.77179699999998 | 2020-10-02 04:23:51 | Sri Lanka | |||
1046115 | 1046115 | 2020-09-30 | Sri Lanka | 3380 | 13 | 3230 | 137 | 7.873054 | 80.77179699999998 | 2020-10-01 04:23:42 | Sri Lanka | |||
967196 | 967196 | 2020-09-29 | Sri Lanka | 3374 | 13 | 3230 | 131 | 7.873054 | 80.77179699999998 | 2020-09-30 04:23:33 | Sri Lanka | |||
1515693 | 1515693 | 2020-09-28 | Sri Lanka | 3363 | 13 | 3210 | 140 | 7.873054 | 80.77179699999998 | 2020-09-29 04:23:42 | Sri Lanka | |||
2582281 | 2582281 | 2020-09-27 | Sri Lanka | 3360 | 13 | 3208 | 139 | 7.873054 | 80.771797 | 2020-09-28 04:23:00 | Sri Lanka | |||
2614333 | 2614333 | 2020-09-26 | Sri Lanka | 3349 | 13 | 3186 | 150 | 7.873054 | 80.771797 | 2020-09-27 04:23:00 | Sri Lanka | |||
2813048 | 2813048 | 2020-09-25 | Sri Lanka | 3345 | 13 | 3158 | 174 | 7.873054 | 80.771797 | 2020-09-26 04:23:00 | Sri Lanka | |||
2606325 | 2606325 | 2020-09-24 | Sri Lanka | 3333 | 13 | 3142 | 178 | 7.873054 | 80.771797 | 2020-09-25 04:23:00 | Sri Lanka | |||
2654068 | 2654068 | 2020-09-23 | Sri Lanka | 3324 | 13 | 3129 | 182 | 7.873054 | 80.771797 | 2020-09-24 04:23:00 | Sri Lanka | |||
3316517 | 3316517 | 2020-09-22 | Sri Lanka | 3313 | 13 | 3118 | 182 | 7.873054 | 80.771797 | 2020-09-23 04:23:00 | Sri Lanka | |||
2837116 | 2837116 | 2020-09-21 | Sri Lanka | 3299 | 13 | 3100 | 186 | 7.873054 | 80.771797 | 2020-09-22 04:23:00 | Sri Lanka | |||
3093720 | 3093720 | 2020-09-20 | Sri Lanka | 3287 | 13 | 3088 | 186 | 7.873054 | 80.771797 | 2020-09-21 04:23:00 | Sri Lanka | |||
2455070 | 2455070 | 2020-09-19 | Sri Lanka | 3283 | 13 | 3070 | 200 | 7.873054 | 80.771797 | 2020-09-20 04:22:00 | Sri Lanka | |||
2849139 | 2849139 | 2020-09-18 | Sri Lanka | 3281 | 13 | 3060 | 208 | 7.873054 | 80.771797 | 2020-09-19 04:22:00 | Sri Lanka | |||
1121888 | 1121888 | 2020-09-17 | Sri Lanka | 3276 | 13 | 3043 | 220 | 7.873054 | 80.771797 | 2020-09-18 05:05:00 | Sri Lanka | |||
666577 | 666577 | 2020-09-16 | Sri Lanka | 3271 | 13 | 3021 | 237 | 7.873054 | 80.771797 | 2020-09-17 04:22:00 | Sri Lanka | |||
2729302 | 2729302 | 2020-09-15 | Sri Lanka | 3271 | 13 | 3016 | 242 | 7.873054 | 80.77179699999998 | 2020-09-16 04:22:53 | Sri Lanka | |||
344574 | 344574 | 2020-09-14 | Sri Lanka | 3262 | 13 | 3005 | 244 | 7.873054 | 80.77179699999998 | 2020-09-15 03:22:50 | Sri Lanka | |||
2869013 | 2869013 | 2020-09-13 | Sri Lanka | 3234 | 12 | 2996 | 226 | 7.873054 | 80.771797 | 2020-09-14 04:26:00 | Sri Lanka | |||
547052 | 547052 | 2020-09-12 | Sri Lanka | 3195 | 12 | 2983 | 200 | 7.873054 | 80.77179699999998 | 2020-09-13 04:30:52 | Sri Lanka | |||
1444881 | 1444881 | 2020-09-11 | Sri Lanka | 3169 | 12 | 2969 | 188 | 7.873054 | 80.77179699999998 | 2020-09-12 04:25:05 | Sri Lanka | |||
1173482 | 1173482 | 2020-09-10 | Sri Lanka | 3155 | 12 | 2955 | 188 | 7.873054 | 80.77179699999998 | 2020-09-11 04:46:23 | Sri Lanka | |||
2171847 | 2171847 | 2020-09-09 | Sri Lanka | 3147 | 12 | 2946 | 189 | 7.873054 | 80.77179699999998 | 2020-09-10 04:29:01 | Sri Lanka | |||
1244056 | 1244056 | 2020-09-08 | Sri Lanka | 3140 | 12 | 2935 | 193 | 7.873054 | 80.77179699999998 | 2020-09-09 04:28:48 | Sri Lanka | |||
427635 | 427635 | 2020-09-07 | Sri Lanka | 3123 | 12 | 2926 | 185 | 7.873054 | 80.77179699999998 | 2020-09-08 04:28:25 | Sri Lanka | |||
3161920 | 3161920 | 2020-09-06 | Sri Lanka | 3123 | 12 | 2925 | 186 | 7.873054 | 80.77179699999998 | 2020-09-07 04:28:30 | Sri Lanka | |||
813875 | 813875 | 2020-09-05 | Sri Lanka | 3121 | 12 | 2918 | 191 | 7.873054 | 80.77179699999998 | 2020-09-06 04:28:33 | Sri Lanka | |||
2662075 | 2662075 | 2020-09-04 | Sri Lanka | 3115 | 12 | 2907 | 196 | 7.873054 | 80.77179699999998 | 2020-09-05 04:28:19 | Sri Lanka | |||
1354615 | 1354615 | 2020-09-03 | Sri Lanka | 3111 | 12 | 2883 | 216 | 7.873054 | 80.77179699999998 | 2020-09-04 04:28:26 | Sri Lanka | |||
1105852 | 1105852 | 2020-09-02 | Sri Lanka | 3101 | 12 | 2883 | 206 | 7.873054 | 80.77179699999998 | 2020-09-03 04:28:22 | Sri Lanka | |||
2060181 | 2060181 | 2020-09-01 | Sri Lanka | 3092 | 12 | 2879 | 201 | 7.873054 | 80.77179699999998 | 2020-09-02 04:28:25 | Sri Lanka | |||
194366 | 194366 | 2020-08-31 | Sri Lanka | 3049 | 12 | 2868 | 169 | 7.873054 | 80.77179699999998 | 2020-09-01 04:28:31 | Sri Lanka | |||
3932325 | 3932325 | 2020-08-30 | Sri Lanka | 3012 | 12 | 2860 | 140 | 7.873054 | 80.77179699999998 | 2020-08-31 04:28:27 | Sri Lanka | |||
609987 | 609987 | 2020-08-29 | Sri Lanka | 2995 | 12 | 2849 | 134 | 7.873054 | 80.77179699999998 | 2020-08-30 04:28:22 | Sri Lanka | |||
1523482 | 1523482 | 2020-08-28 | Sri Lanka | 2989 | 12 | 2842 | 135 | 7.873054 | 80.77179699999998 | 2020-08-29 04:28:19 | Sri Lanka | |||
2510483 | 2510483 | 2020-08-27 | Sri Lanka | 2986 | 12 | 2830 | 144 | 7.873054 | 80.77179699999998 | 2020-08-28 04:28:11 | Sri Lanka | |||
1996943 | 1996943 | 2020-08-26 | Sri Lanka | 2984 | 12 | 2819 | 153 | 7.873054 | 80.77179699999998 | 2020-08-27 04:28:15 | Sri Lanka | |||
3562867 | 3562867 | 2020-08-25 | Sri Lanka | 2971 | 12 | 2816 | 143 | 7.873054 | 80.77179699999998 | 2020-08-26 04:28:11 | Sri Lanka | |||
2991571 | 2991571 | 2020-08-24 | Sri Lanka | 2959 | 12 | 2811 | 136 | 7.873054 | 80.77179699999998 | 2020-08-25 04:28:02 | Sri Lanka | |||
2215966 | 2215966 | 2020-08-23 | Sri Lanka | 2953 | 12 | 2805 | 136 | 7.873054 | 80.77179699999998 | 2020-08-24 04:27:56 | Sri Lanka | |||
2299748 | 2299748 | 2020-08-22 | Sri Lanka | 2947 | 12 | 2798 | 137 | 7.873054 | 80.77179699999998 | 2020-08-23 04:27:48 | Sri Lanka | |||
1479855 | 1479855 | 2020-08-21 | Sri Lanka | 2941 | 11 | 2789 | 141 | 7.873054 | 80.77179699999998 | 2020-08-22 04:27:49 | Sri Lanka | |||
3484604 | 3484604 | 2020-08-20 | Sri Lanka | 2918 | 11 | 2765 | 142 | 7.873054 | 80.77179699999998 | 2020-08-21 04:27:41 | Sri Lanka | |||
206553 | 206553 | 2020-08-19 | Sri Lanka | 2902 | 11 | 2760 | 131 | 7.873054 | 80.77179699999998 | 2020-08-20 04:27:43 | Sri Lanka | |||
3178307 | 3178307 | 2020-08-18 | Sri Lanka | 2902 | 11 | 2755 | 136 | 7.873054 | 80.771797 | 2020-08-19 04:27:00 | Sri Lanka | |||
837911 | 837911 | 2020-08-17 | Sri Lanka | 2900 | 11 | 2676 | 213 | 7.873054 | 80.77179699999998 | 2020-08-18 04:27:56 | Sri Lanka | |||
1556269 | 1556269 | 2020-08-16 | Sri Lanka | 2893 | 11 | 2670 | 212 | 7.873054 | 80.77179699999998 | 2020-08-17 04:27:20 | Sri Lanka | |||
146271 | 146271 | 2020-08-15 | Sri Lanka | 2890 | 11 | 2666 | 213 | 7.873054 | 80.77179699999998 | 2020-08-16 04:27:42 | Sri Lanka | |||
1612546 | 1612546 | 2020-08-14 | Sri Lanka | 2886 | 11 | 2658 | 217 | 7.873054 | 80.77179699999998 | 2020-08-15 04:27:31 | Sri Lanka | |||
583130 | 583130 | 2020-08-13 | Sri Lanka | 2882 | 11 | 2646 | 225 | 7.873054 | 80.77179699999998 | 2020-08-14 04:51:19 | Sri Lanka | |||
3531749 | 3531749 | 2020-08-12 | Sri Lanka | 2881 | 11 | 2638 | 232 | 7.873054 | 80.77179699999998 | 2020-08-13 04:29:15 | Sri Lanka | |||
662598 | 662598 | 2020-08-11 | Sri Lanka | 2880 | 11 | 2622 | 247 | 7.873054 | 80.77179699999998 | 2020-08-12 04:27:29 | Sri Lanka | |||
1920825 | 1920825 | 2020-08-10 | Sri Lanka | 2871 | 11 | 2593 | 267 | 7.873054 | 80.77179699999998 | 2020-08-11 04:35:08 | Sri Lanka | |||
3923634 | 3923634 | 2020-08-09 | Sri Lanka | 2844 | 11 | 2579 | 254 | 7.873054 | 80.77179699999998 | 2020-08-10 04:34:55 | Sri Lanka | |||
371802 | 371802 | 2020-08-08 | Sri Lanka | 2841 | 11 | 2576 | 254 | 7.873054 | 80.77179699999998 | 2020-08-09 04:34:54 | Sri Lanka | |||
458986 | 458986 | 2020-08-07 | Sri Lanka | 2839 | 11 | 2564 | 264 | 7.873054 | 80.77179699999998 | 2020-08-08 04:34:53 | Sri Lanka | |||
3612671 | 3612671 | 2020-08-06 | Sri Lanka | 2839 | 11 | 2541 | 287 | 7.873054 | 80.77179699999998 | 2020-08-07 04:35:11 | Sri Lanka | |||
3793501 | 3793501 | 2020-08-05 | Sri Lanka | 2839 | 11 | 2537 | 291 | 7.873054 | 80.77179699999998 | 2020-08-06 04:35:02 | Sri Lanka | |||
98737 | 98737 | 2020-08-04 | Sri Lanka | 2834 | 11 | 2524 | 299 | 7.873054 | 80.77179699999998 | 2020-08-05 04:34:43 | Sri Lanka | |||
2740620 | 2740620 | 2020-08-03 | Sri Lanka | 2828 | 11 | 2517 | 300 | 7.873054 | 80.77179699999998 | 2020-08-04 04:41:59 | Sri Lanka | |||
2808372 | 2808372 | 2020-08-02 | Sri Lanka | 2823 | 11 | 2514 | 298 | 7.873054 | 80.77179699999998 | 2020-08-03 04:34:35 | Sri Lanka | |||
753940 | 753940 | 2020-08-01 | Sri Lanka | 2815 | 11 | 2439 | 365 | 7.873054 | 80.77179699999998 | 2020-08-02 04:34:47 | Sri Lanka | |||
3265105 | 3265105 | 2020-07-31 | Sri Lanka | 2815 | 11 | 2391 | 413 | 7.873054 | 80.77179699999998 | 2020-08-01 04:36:27 | Sri Lanka | |||
1928811 | 1928811 | 2020-07-30 | Sri Lanka | 2814 | 11 | 2333 | 470 | 7.873054 | 80.77179699999998 | 2020-07-31 04:35:18 | Sri Lanka | |||
2958979 | 2958979 | 2020-07-29 | Sri Lanka | 2810 | 11 | 2317 | 482 | 7.873054 | 80.77179699999998 | 2020-07-30 04:35:05 | Sri Lanka | |||
3185596 | 3185596 | 2020-07-28 | Sri Lanka | 2810 | 11 | 2296 | 503 | 7.873054 | 80.77179699999998 | 2020-07-29 04:35:11 | Sri Lanka | |||
177646 | 177646 | 2020-07-27 | Sri Lanka | 2805 | 11 | 2121 | 673 | 7.873054 | 80.77179699999998 | 2020-07-28 04:58:43 | Sri Lanka | |||
442959 | 442959 | 2020-07-26 | Sri Lanka | 2782 | 11 | 2106 | 665 | 7.873054 | 80.77179699999998 | 2020-07-27 04:35:02 | Sri Lanka | |||
1503202 | 1503202 | 2020-07-25 | Sri Lanka | 2770 | 11 | 2103 | 656 | 7.873054 | 80.77179699999998 | 2020-07-26 04:35:00 | Sri Lanka | |||
2564173 | 2564173 | 2020-07-24 | Sri Lanka | 2764 | 11 | 2094 | 659 | 7.873054 | 80.77179699999998 | 2020-07-25 04:47:39 | Sri Lanka | |||
62373 | 62373 | 2020-07-23 | Sri Lanka | 2753 | 11 | 2077 | 665 | 7.873054 | 80.77179699999998 | 2020-07-24 05:30:40 | Sri Lanka | |||
845193 | 845193 | 2020-07-22 | Sri Lanka | 2752 | 11 | 2064 | 677 | 7.873054 | 80.77179699999998 | 2020-07-23 05:15:04 | Sri Lanka | |||
1707932 | 1707932 | 2020-07-21 | Sri Lanka | 2730 | 11 | 2048 | 671 | 7.873054 | 80.77179699999998 | 2020-07-22 04:34:42 | Sri Lanka | |||
327423 | 327423 | 2020-07-20 | Sri Lanka | 2730 | 11 | 2041 | 678 | 7.873054 | 80.77179699999998 | 2020-07-21 04:38:46 | Sri Lanka | |||
122328 | 122328 | 2020-07-19 | Sri Lanka | 2724 | 11 | 2035 | 678 | 7.873054 | 80.77179699999998 | 2020-07-20 05:34:40 | Sri Lanka | |||
3205717 | 3205717 | 2020-07-18 | Sri Lanka | 2703 | 11 | 2023 | 669 | 7.873054 | 80.77179699999998 | 2020-07-19 04:34:58 | Sri Lanka | |||
2709020 | 2709020 | 2020-07-17 | Sri Lanka | 2697 | 11 | 2012 | 674 | 7.873054 | 80.77179699999998 | 2020-07-18 04:34:45 | Sri Lanka | |||
367828 | 367828 | 2020-07-16 | Sri Lanka | 2687 | 11 | 2007 | 669 | 7.873054 | 80.77179699999998 | 2020-07-17 04:34:50 | Sri Lanka | |||
2748496 | 2748496 | 2020-07-15 | Sri Lanka | 2671 | 11 | 2001 | 659 | 7.873054 | 80.77179699999998 | 2020-07-16 04:44:59 | Sri Lanka | |||
2159140 | 2159140 | 2020-07-14 | Sri Lanka | 2665 | 11 | 1988 | 666 | 7.873054 | 80.77179699999998 | 2020-07-15 04:34:39 | Sri Lanka | |||
3491781 | 3491781 | 2020-07-13 | Sri Lanka | 2646 | 11 | 1981 | 654 | 7.873054 | 80.77179699999998 | 2020-07-14 04:34:46 | Sri Lanka | |||
3738044 | 3738044 | 2020-07-12 | Sri Lanka | 2617 | 11 | 1981 | 625 | 7.873054 | 80.77179699999998 | 2020-07-13 04:43:04 | Sri Lanka | |||
3436439 | 3436439 | 2020-07-11 | Sri Lanka | 2511 | 11 | 1980 | 520 | 7.873054 | 80.77179699999998 | 2020-07-12 04:34:30 | Sri Lanka | |||
3237937 | 3237937 | 2020-07-10 | Sri Lanka | 2454 | 11 | 1980 | 463 | 7.873054 | 80.77179699999998 | 2020-07-11 04:34:26 | 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]);