daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,068 rows where country_or_region = "Sri Lanka" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Sri Lanka · 1,068 ✖
province_or_state 0
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-30 | Sri Lanka | 663 | 7 | 154 | 502 | 7.873054 | 80.77179699999998 | 2020-05-01 02:32:28 | Sri Lanka | |||
2022-05-31 | Sri Lanka | 663834 | 16517 | 0 | 7.873054 | 80.771797 | 2022-06-01 04:20:55 | Sri Lanka | ||||
2022-02-11 | Sri Lanka | 625804 | 15754 | 0 | 7.873054 | 80.77179699999998 | 2022-02-12 04:21:06 | Sri Lanka | ||||
2021-01-18 | Sri Lanka | 53750 | 270 | 45820 | 7660 | 7.873054 | 80.77179699999998 | 2021-01-19 05:22:15 | Sri Lanka | |||
2021-04-02 | Sri Lanka | 93128 | 571 | 89701 | 2856 | 7.873054 | 80.77179699999998 | 2021-04-03 04:20:44 | Sri Lanka | |||
2021-08-17 | Sri Lanka | 365683 | 6434 | 0 | 7.873054 | 80.77179699999998 | 2021-08-18 04:21:35 | Sri Lanka | ||||
2021-09-04 | Sri Lanka | 451401 | 9806 | 0 | 7.873054 | 80.77179699999998 | 2021-09-05 04:21:33 | Sri Lanka | ||||
2022-09-08 | Sri Lanka | 670341 | 16724 | 0 | 7.873054 | 80.771797 | 2022-09-09 04:21:11 | Sri Lanka | ||||
2022-12-10 | Sri Lanka | 671752 | 16808 | 0 | 7.873054 | 80.771797 | 2022-12-11 04:20:50 | Sri Lanka | ||||
2022-03-15 | Sri Lanka | 656814 | 16415 | 0 | 7.873054 | 80.77179699999998 | 2022-03-16 04:20:50 | Sri Lanka | ||||
2020-05-21 | Sri Lanka | 1055 | 9 | 604 | 442 | 7.873054 | 80.77179699999998 | 2020-05-22 02:36:51 | Sri Lanka | |||
2020-04-28 | Sri Lanka | 619 | 7 | 134 | 478 | 7.873054 | 80.77179699999998 | 2020-04-29 02:32:29 | Sri Lanka | |||
2020-11-10 | Sri Lanka | 14715 | 41 | 9537 | 5137 | 7.873054 | 80.77179699999998 | 2020-11-11 05:25:30 | Sri Lanka | |||
2021-11-03 | Sri Lanka | 542793 | 13791 | 0 | 7.873054 | 80.77179699999998 | 2021-11-04 04:22:20 | Sri Lanka | ||||
2021-02-24 | Sri Lanka | 81467 | 457 | 76514 | 4496 | 7.873054 | 80.77179699999998 | 2021-02-25 05:24:57 | Sri Lanka | |||
2020-06-15 | Sri Lanka | 1905 | 11 | 1342 | 552 | 7.873054 | 80.77179699999998 | 2020-06-16 04:33:09 | Sri Lanka | |||
2021-10-31 | Sri Lanka | 541073 | 13743 | 0 | 7.873054 | 80.77179699999998 | 2021-11-01 04:22:01 | Sri Lanka | ||||
2022-11-15 | Sri Lanka | 671455 | 16784 | 0 | 7.873054 | 80.771797 | 2022-11-16 04:21:09 | Sri Lanka | ||||
2021-07-15 | Sri Lanka | 280543 | 3661 | 253953 | 22929 | 7.873054 | 80.77179699999998 | 2021-07-16 04:21:22 | Sri Lanka | |||
2020-07-01 | Sri Lanka | 2054 | 11 | 1748 | 295 | 7.873054 | 80.77179699999998 | 2020-07-02 04:33:46 | Sri Lanka | |||
2022-04-16 | Sri Lanka | 662827 | 16495 | 0 | 7.873054 | 80.77179699999998 | 2022-04-17 04:20:59 | Sri Lanka | ||||
2022-12-13 | Sri Lanka | 671770 | 16809 | 0 | 7.873054 | 80.771797 | 2022-12-14 04:21:04 | Sri Lanka | ||||
2022-11-13 | Sri Lanka | 671417 | 16784 | 0 | 7.873054 | 80.771797 | 2022-11-14 04:21:09 | Sri Lanka | ||||
2022-02-12 | Sri Lanka | 626966 | 15777 | 0 | 7.873054 | 80.77179699999998 | 2022-02-13 04:21:00 | Sri Lanka | ||||
2022-10-30 | Sri Lanka | 671070 | 16779 | 0 | 7.873054 | 80.771797 | 2022-10-31 04:21:36 | Sri Lanka | ||||
2020-07-20 | Sri Lanka | 2730 | 11 | 2041 | 678 | 7.873054 | 80.77179699999998 | 2020-07-21 04:38:46 | Sri Lanka | |||
2022-12-27 | Sri Lanka | 671859 | 16815 | 0 | 7.873054 | 80.771797 | 2022-12-28 04:21:04 | Sri Lanka | ||||
2021-08-04 | Sri Lanka | 318775 | 4727 | 284524 | 29524 | 7.873054 | 80.77179699999998 | 2021-08-05 04:21:51 | Sri Lanka | |||
2022-03-18 | Sri Lanka | 657723 | 16422 | 0 | 7.873054 | 80.77179699999998 | 2022-03-19 04:20:47 | Sri Lanka | ||||
2021-02-03 | Sri Lanka | 66409 | 332 | 59883 | 6194 | 7.873054 | 80.77179699999998 | 2021-02-04 05:22:26 | Sri Lanka | |||
2020-09-14 | Sri Lanka | 3262 | 13 | 3005 | 244 | 7.873054 | 80.77179699999998 | 2020-09-15 03:22:50 | Sri Lanka | |||
2022-12-14 | Sri Lanka | 671776 | 16809 | 0 | 7.873054 | 80.771797 | 2022-12-15 04:20:58 | Sri Lanka | ||||
2021-03-11 | Sri Lanka | 86989 | 520 | 83561 | 2908 | 7.873054 | 80.77179699999998 | 2021-03-12 05:26:50 | Sri Lanka | |||
2022-03-11 | Sri Lanka | 655383 | 16381 | 0 | 7.873054 | 80.77179699999998 | 2022-03-12 04:20:50 | Sri Lanka | ||||
2022-05-07 | Sri Lanka | 663533 | 16509 | 0 | 7.873054 | 80.771797 | 2022-05-08 04:20:49 | Sri Lanka | ||||
2020-07-16 | Sri Lanka | 2687 | 11 | 2007 | 669 | 7.873054 | 80.77179699999998 | 2020-07-17 04:34:50 | Sri Lanka | |||
2020-08-08 | Sri Lanka | 2841 | 11 | 2576 | 254 | 7.873054 | 80.77179699999998 | 2020-08-09 04:34:54 | Sri Lanka | |||
2022-09-13 | Sri Lanka | 670501 | 16736 | 0 | 7.873054 | 80.771797 | 2022-09-14 04:20:44 | Sri Lanka | ||||
2020-11-06 | Sri Lanka | 12970 | 30 | 7186 | 5754 | 7.873054 | 80.77179699999998 | 2020-11-07 05:24:52 | Sri Lanka | |||
2021-04-30 | Sri Lanka | 108146 | 678 | 95975 | 11493 | 7.873054 | 80.77179699999998 | 2021-05-01 04:20:47 | Sri Lanka | |||
2022-09-23 | Sri Lanka | 670685 | 16753 | 0 | 7.873054 | 80.771797 | 2022-09-24 04:21:40 | Sri Lanka | ||||
2021-04-04 | Sri Lanka | 93436 | 581 | 90208 | 2647 | 7.873054 | 80.77179699999998 | 2021-04-05 04:20:35 | Sri Lanka | |||
2020-11-27 | Sri Lanka | 22501 | 107 | 16226 | 6168 | 7.873054 | 80.77179699999998 | 2020-11-28 05:25:50 | Sri Lanka | |||
2022-10-07 | Sri Lanka | 670844 | 16767 | 0 | 7.873054 | 80.771797 | 2022-10-08 04:22:56 | Sri Lanka | ||||
2021-06-29 | Sri Lanka | 257225 | 3030 | 223471 | 30724 | 7.873054 | 80.77179699999998 | 2021-06-30 04:21:41 | Sri Lanka | |||
2021-12-07 | Sri Lanka | 569171 | 14505 | 0 | 7.873054 | 80.77179699999998 | 2021-12-08 04:22:46 | Sri Lanka | ||||
2021-07-28 | Sri Lanka | 301832 | 4258 | 271855 | 25719 | 7.873054 | 80.77179699999998 | 2021-07-29 04:21:33 | Sri Lanka | |||
2020-07-05 | Sri Lanka | 2076 | 11 | 1903 | 162 | 7.873054 | 80.77179699999998 | 2020-07-06 04:33:57 | Sri Lanka | |||
2020-04-18 | Sri Lanka | 254 | 7 | 86 | 161 | 7.873054 | 80.771797 | 2020-04-18 22:32:28 | Sri Lanka | |||
2022-09-18 | Sri Lanka | 670596 | 16747 | 0 | 7.873054 | 80.771797 | 2022-09-19 04:21:49 | Sri Lanka | ||||
2021-10-10 | Sri Lanka | 526383 | 13331 | 0 | 7.873054 | 80.77179699999998 | 2021-10-11 04:21:31 | Sri Lanka | ||||
2020-09-07 | Sri Lanka | 3123 | 12 | 2926 | 185 | 7.873054 | 80.77179699999998 | 2020-09-08 04:28:25 | Sri Lanka | |||
2022-11-03 | Sri Lanka | 671302 | 16782 | 0 | 7.873054 | 80.771797 | 2022-11-04 04:22:11 | Sri Lanka | ||||
2021-01-21 | Sri Lanka | 56076 | 276 | 47984 | 7816 | 7.873054 | 80.77179699999998 | 2021-01-22 05:22:10 | Sri Lanka | |||
2020-07-26 | Sri Lanka | 2782 | 11 | 2106 | 665 | 7.873054 | 80.77179699999998 | 2020-07-27 04:35:02 | Sri Lanka | |||
2021-10-20 | Sri Lanka | 533305 | 13543 | 0 | 7.873054 | 80.77179699999998 | 2021-10-21 04:21:18 | Sri Lanka | ||||
2021-11-17 | Sri Lanka | 553722 | 14057 | 0 | 7.873054 | 80.77179699999998 | 2021-11-18 04:21:33 | Sri Lanka | ||||
2022-12-21 | Sri Lanka | 671831 | 16814 | 0 | 7.873054 | 80.771797 | 2022-12-22 04:20:56 | Sri Lanka | ||||
2020-08-07 | Sri Lanka | 2839 | 11 | 2564 | 264 | 7.873054 | 80.77179699999998 | 2020-08-08 04:34:53 | Sri Lanka | |||
2022-02-02 | Sri Lanka | 613478 | 15492 | 0 | 7.873054 | 80.77179699999998 | 2022-02-03 04:21:21 | Sri Lanka | ||||
2022-05-02 | Sri Lanka | 663408 | 16505 | 0 | 7.873054 | 80.771797 | 2022-05-03 04:21:00 | Sri Lanka | ||||
2021-10-07 | Sri Lanka | 523550 | 13229 | 0 | 7.873054 | 80.77179699999998 | 2021-10-08 04:21:25 | Sri Lanka | ||||
2021-02-19 | Sri Lanka | 78937 | 433 | 72566 | 5938 | 7.873054 | 80.77179699999998 | 2021-02-20 05:22:51 | Sri Lanka | |||
2022-06-26 | Sri Lanka | 664080 | 16521 | 0 | 7.873054 | 80.771797 | 2022-06-27 04:21:00 | Sri Lanka | ||||
2022-11-08 | Sri Lanka | 671350 | 16782 | 0 | 7.873054 | 80.771797 | 2022-11-09 04:21:22 | Sri Lanka | ||||
2021-07-19 | Sri Lanka | 286419 | 3827 | 261848 | 20744 | 7.873054 | 80.77179699999998 | 2021-07-20 04:21:48 | Sri Lanka | |||
2022-11-25 | Sri Lanka | 671626 | 16799 | 0 | 7.873054 | 80.771797 | 2022-11-26 04:21:11 | Sri Lanka | ||||
2021-10-14 | Sri Lanka | 529755 | 13429 | 0 | 7.873054 | 80.77179699999998 | 2021-10-15 04:21:26 | Sri Lanka | ||||
2021-11-06 | Sri Lanka | 544630 | 13841 | 0 | 7.873054 | 80.77179699999998 | 2021-11-07 04:21:53 | Sri Lanka | ||||
2022-04-02 | Sri Lanka | 661885 | 16480 | 0 | 7.873054 | 80.77179699999998 | 2022-04-03 04:20:48 | Sri Lanka | ||||
2022-12-17 | Sri Lanka | 671808 | 16814 | 0 | 7.873054 | 80.771797 | 2022-12-18 04:21:03 | Sri Lanka | ||||
2021-08-14 | Sri Lanka | 351533 | 5936 | 0 | 7.873054 | 80.77179699999998 | 2021-08-15 04:21:41 | Sri Lanka | ||||
2021-08-19 | Sri Lanka | 373165 | 6790 | 0 | 7.873054 | 80.77179699999998 | 2021-08-20 04:21:33 | Sri Lanka | ||||
2022-10-15 | Sri Lanka | 670918 | 16769 | 0 | 7.873054 | 80.771797 | 2022-10-16 04:22:39 | Sri Lanka | ||||
2020-04-21 | Sri Lanka | 310 | 7 | 102 | 201 | 7.873054 | 80.77179699999998 | 2020-04-21 23:30:30 | Sri Lanka | |||
2021-06-09 | Sri Lanka | 213396 | 1910 | 180427 | 31059 | 7.873054 | 80.77179699999998 | 2021-06-10 04:23:17 | Sri Lanka | |||
2020-07-04 | Sri Lanka | 2074 | 11 | 1885 | 178 | 7.873054 | 80.77179699999998 | 2020-07-05 04:33:46 | Sri Lanka | |||
2021-02-22 | Sri Lanka | 80517 | 450 | 75110 | 4957 | 7.873054 | 80.77179699999998 | 2021-02-23 05:23:41 | Sri Lanka | |||
2021-10-27 | Sri Lanka | 538320 | 13674 | 0 | 7.873054 | 80.77179699999998 | 2021-10-28 04:22:08 | Sri Lanka | ||||
2022-10-26 | Sri Lanka | 671030 | 16776 | 0 | 7.873054 | 80.771797 | 2022-10-27 04:22:01 | Sri Lanka | ||||
2022-12-15 | Sri Lanka | 671793 | 16812 | 0 | 7.873054 | 80.771797 | 2022-12-16 04:21:01 | Sri Lanka | ||||
2020-09-12 | Sri Lanka | 3195 | 12 | 2983 | 200 | 7.873054 | 80.77179699999998 | 2020-09-13 04:30:52 | Sri Lanka | |||
2021-12-08 | Sri Lanka | 569928 | 14533 | 0 | 7.873054 | 80.77179699999998 | 2021-12-09 04:22:49 | Sri Lanka | ||||
2022-01-16 | Sri Lanka | 596347 | 15211 | 0 | 7.873054 | 80.77179699999998 | 2022-01-17 04:21:08 | Sri Lanka | ||||
2022-06-16 | Sri Lanka | 663975 | 16519 | 0 | 7.873054 | 80.771797 | 2022-06-17 04:20:56 | Sri Lanka | ||||
2021-06-22 | Sri Lanka | 243913 | 2704 | 209296 | 31913 | 7.873054 | 80.77179699999998 | 2021-06-23 04:21:46 | Sri Lanka | |||
2021-10-29 | Sri Lanka | 539416 | 13706 | 0 | 7.873054 | 80.77179699999998 | 2021-10-30 04:22:03 | Sri Lanka | ||||
2020-06-06 | Sri Lanka | 1814 | 11 | 891 | 912 | 7.873054 | 80.77179699999998 | 2020-06-07 03:53:30 | Sri Lanka | |||
2022-02-25 | Sri Lanka | 643072 | 16142 | 0 | 7.873054 | 80.77179699999998 | 2022-02-26 04:21:12 | Sri Lanka | ||||
2021-07-13 | Sri Lanka | 277519 | 3574 | 247569 | 26376 | 7.873054 | 80.77179699999998 | 2021-07-14 04:21:35 | Sri Lanka | |||
2020-08-13 | Sri Lanka | 2882 | 11 | 2646 | 225 | 7.873054 | 80.77179699999998 | 2020-08-14 04:51:19 | Sri Lanka | |||
2020-04-05 | Sri Lanka | 176 | 5 | 33 | 138 | 7.873054 | 80.77179699999998 | 2020-04-05 23:06:26 | Sri Lanka | |||
2021-08-08 | Sri Lanka | 329994 | 5111 | 0 | 7.873054 | 80.77179699999998 | 2021-08-09 04:21:24 | Sri Lanka | ||||
2022-07-01 | Sri Lanka | 664138 | 16521 | 0 | 7.873054 | 80.771797 | 2022-07-02 04:21:16 | Sri Lanka | ||||
2021-10-19 | Sri Lanka | 532766 | 13525 | 0 | 7.873054 | 80.77179699999998 | 2021-10-20 04:21:00 | Sri Lanka | ||||
2021-09-23 | Sri Lanka | 510040 | 12448 | 0 | 7.873054 | 80.77179699999998 | 2021-09-24 04:21:44 | Sri Lanka | ||||
2021-04-09 | Sri Lanka | 94564 | 593 | 91272 | 2699 | 7.873054 | 80.77179699999998 | 2021-04-10 04:20:59 | Sri Lanka | |||
2020-08-29 | Sri Lanka | 2995 | 12 | 2849 | 134 | 7.873054 | 80.77179699999998 | 2020-08-30 04:28:22 | Sri Lanka | |||
2021-02-08 | Sri Lanka | 70235 | 365 | 64141 | 5729 | 7.873054 | 80.77179699999998 | 2021-02-09 05:23:30 | Sri Lanka | |||
2022-11-05 | Sri Lanka | 671320 | 16782 | 0 | 7.873054 | 80.771797 | 2022-11-06 04:21:24 | Sri Lanka |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;