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 longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Sri Lanka · 968 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
327423 | 327423 | 2020-07-20 | Sri Lanka | 2730 | 11 | 2041 | 678 | 7.873054 | 80.77179699999998 | 2020-07-21 04:38:46 | Sri Lanka | |||
332212 | 332212 | 2021-08-04 | Sri Lanka | 318775 | 4727 | 284524 | 29524 | 7.873054 | 80.77179699999998 | 2021-08-05 04:21:51 | Sri Lanka | |||
336244 | 336244 | 2022-03-18 | Sri Lanka | 657723 | 16422 | 0 | 7.873054 | 80.77179699999998 | 2022-03-19 04:20:47 | Sri Lanka | ||||
340578 | 340578 | 2021-02-03 | Sri Lanka | 66409 | 332 | 59883 | 6194 | 7.873054 | 80.77179699999998 | 2021-02-04 05:22:26 | 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 | |||
352599 | 352599 | 2021-03-11 | Sri Lanka | 86989 | 520 | 83561 | 2908 | 7.873054 | 80.77179699999998 | 2021-03-12 05:26:50 | Sri Lanka | |||
356634 | 356634 | 2022-03-11 | Sri Lanka | 655383 | 16381 | 0 | 7.873054 | 80.77179699999998 | 2022-03-12 04:20:50 | 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 | |||
371802 | 371802 | 2020-08-08 | Sri Lanka | 2841 | 11 | 2576 | 254 | 7.873054 | 80.77179699999998 | 2020-08-09 04:34:54 | Sri Lanka | |||
376483 | 376483 | 2020-11-06 | Sri Lanka | 12970 | 30 | 7186 | 5754 | 7.873054 | 80.77179699999998 | 2020-11-07 05:24:52 | 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 | |||
388526 | 388526 | 2021-04-04 | Sri Lanka | 93436 | 581 | 90208 | 2647 | 7.873054 | 80.77179699999998 | 2021-04-05 04:20:35 | Sri Lanka | |||
392537 | 392537 | 2020-11-27 | Sri Lanka | 22501 | 107 | 16226 | 6168 | 7.873054 | 80.77179699999998 | 2020-11-28 05:25:50 | 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 | |||
404601 | 404601 | 2021-12-07 | Sri Lanka | 569171 | 14505 | 0 | 7.873054 | 80.77179699999998 | 2021-12-08 04:22:46 | 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 | |||
415771 | 415771 | 2020-07-05 | Sri Lanka | 2076 | 11 | 1903 | 162 | 7.873054 | 80.77179699999998 | 2020-07-06 04:33:57 | Sri Lanka | |||
423658 | 423658 | 2021-10-10 | Sri Lanka | 526383 | 13331 | 0 | 7.873054 | 80.77179699999998 | 2021-10-11 04:21:31 | 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 | |||
435659 | 435659 | 2021-01-21 | Sri Lanka | 56076 | 276 | 47984 | 7816 | 7.873054 | 80.77179699999998 | 2021-01-22 05:22:10 | 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 | |||
443662 | 443662 | 2021-10-20 | Sri Lanka | 533305 | 13543 | 0 | 7.873054 | 80.77179699999998 | 2021-10-21 04:21:18 | Sri Lanka | ||||
447678 | 447678 | 2021-11-17 | Sri Lanka | 553722 | 14057 | 0 | 7.873054 | 80.77179699999998 | 2021-11-18 04:21:33 | 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 | |||
459687 | 459687 | 2022-02-02 | Sri Lanka | 613478 | 15492 | 0 | 7.873054 | 80.77179699999998 | 2022-02-03 04:21:21 | Sri Lanka | ||||
467719 | 467719 | 2021-10-07 | Sri Lanka | 523550 | 13229 | 0 | 7.873054 | 80.77179699999998 | 2021-10-08 04:21:25 | Sri Lanka | ||||
471715 | 471715 | 2021-02-19 | Sri Lanka | 78937 | 433 | 72566 | 5938 | 7.873054 | 80.77179699999998 | 2021-02-20 05:22:51 | 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 | |||
491943 | 491943 | 2021-10-14 | Sri Lanka | 529755 | 13429 | 0 | 7.873054 | 80.77179699999998 | 2021-10-15 04:21:26 | Sri Lanka | ||||
495959 | 495959 | 2021-11-06 | Sri Lanka | 544630 | 13841 | 0 | 7.873054 | 80.77179699999998 | 2021-11-07 04:21:53 | Sri Lanka | ||||
499976 | 499976 | 2022-04-02 | Sri Lanka | 661885 | 16480 | 0 | 7.873054 | 80.77179699999998 | 2022-04-03 04:20:48 | Sri Lanka | ||||
507990 | 507990 | 2021-08-14 | Sri Lanka | 351533 | 5936 | 0 | 7.873054 | 80.77179699999998 | 2021-08-15 04:21:41 | Sri Lanka | ||||
512004 | 512004 | 2021-08-19 | Sri Lanka | 373165 | 6790 | 0 | 7.873054 | 80.77179699999998 | 2021-08-20 04:21:33 | Sri Lanka | ||||
522481 | 522481 | 2020-04-21 | Sri Lanka | 310 | 7 | 102 | 201 | 7.873054 | 80.77179699999998 | 2020-04-21 23:30:30 | 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 | |||
530333 | 530333 | 2020-07-04 | Sri Lanka | 2074 | 11 | 1885 | 178 | 7.873054 | 80.77179699999998 | 2020-07-05 04:33:46 | Sri Lanka | |||
531009 | 531009 | 2021-02-22 | Sri Lanka | 80517 | 450 | 75110 | 4957 | 7.873054 | 80.77179699999998 | 2021-02-23 05:23:41 | Sri Lanka | |||
535043 | 535043 | 2021-10-27 | Sri Lanka | 538320 | 13674 | 0 | 7.873054 | 80.77179699999998 | 2021-10-28 04:22:08 | 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 | |||
551081 | 551081 | 2021-12-08 | Sri Lanka | 569928 | 14533 | 0 | 7.873054 | 80.77179699999998 | 2021-12-09 04:22:49 | Sri Lanka | ||||
555097 | 555097 | 2022-01-16 | Sri Lanka | 596347 | 15211 | 0 | 7.873054 | 80.77179699999998 | 2022-01-17 04:21:08 | 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 | |||
567411 | 567411 | 2021-10-29 | Sri Lanka | 539416 | 13706 | 0 | 7.873054 | 80.77179699999998 | 2021-10-30 04:22:03 | Sri Lanka | ||||
574439 | 574439 | 2020-06-06 | Sri Lanka | 1814 | 11 | 891 | 912 | 7.873054 | 80.77179699999998 | 2020-06-07 03:53:30 | Sri Lanka | |||
575140 | 575140 | 2022-02-25 | Sri Lanka | 643072 | 16142 | 0 | 7.873054 | 80.77179699999998 | 2022-02-26 04:21:12 | 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 | |||
583130 | 583130 | 2020-08-13 | Sri Lanka | 2882 | 11 | 2646 | 225 | 7.873054 | 80.77179699999998 | 2020-08-14 04:51:19 | Sri Lanka | |||
589252 | 589252 | 2020-04-05 | Sri Lanka | 176 | 5 | 33 | 138 | 7.873054 | 80.77179699999998 | 2020-04-05 23:06:26 | Sri Lanka | |||
589934 | 589934 | 2021-08-08 | Sri Lanka | 329994 | 5111 | 0 | 7.873054 | 80.77179699999998 | 2021-08-09 04:21:24 | Sri Lanka | ||||
597981 | 597981 | 2021-10-19 | Sri Lanka | 532766 | 13525 | 0 | 7.873054 | 80.77179699999998 | 2021-10-20 04:21:00 | Sri Lanka | ||||
601997 | 601997 | 2021-09-23 | Sri Lanka | 510040 | 12448 | 0 | 7.873054 | 80.77179699999998 | 2021-09-24 04:21:44 | Sri Lanka | ||||
605992 | 605992 | 2021-04-09 | Sri Lanka | 94564 | 593 | 91272 | 2699 | 7.873054 | 80.77179699999998 | 2021-04-10 04:20:59 | 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 | |||
613991 | 613991 | 2021-02-08 | Sri Lanka | 70235 | 365 | 64141 | 5729 | 7.873054 | 80.77179699999998 | 2021-02-09 05:23:30 | 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 | |||
634231 | 634231 | 2021-10-13 | Sri Lanka | 528415 | 13408 | 0 | 7.873054 | 80.77179699999998 | 2021-10-14 04:21:29 | Sri Lanka | ||||
638227 | 638227 | 2021-03-31 | Sri Lanka | 92706 | 568 | 89251 | 2887 | 7.873054 | 80.77179699999998 | 2021-04-01 04:27:05 | Sri Lanka | |||
642244 | 642244 | 2021-09-07 | Sri Lanka | 471863 | 10504 | 0 | 7.873054 | 80.77179699999998 | 2021-09-08 04:21:31 | 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 | |||
650272 | 650272 | 2021-08-09 | Sri Lanka | 332947 | 5222 | 0 | 7.873054 | 80.77179699999998 | 2021-08-10 04:21:27 | Sri Lanka | ||||
654303 | 654303 | 2021-10-22 | Sri Lanka | 534975 | 13574 | 0 | 7.873054 | 80.77179699999998 | 2021-10-23 04:21:32 | 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 | |||
678614 | 678614 | 2020-11-23 | Sri Lanka | 20508 | 90 | 14497 | 5921 | 7.873054 | 80.77179699999998 | 2020-11-24 05:27:31 | Sri Lanka | |||
682648 | 682648 | 2021-10-24 | Sri Lanka | 536084 | 13611 | 0 | 7.873054 | 80.77179699999998 | 2021-10-25 04:22:31 | Sri Lanka | ||||
686664 | 686664 | 2021-11-13 | Sri Lanka | 549500 | 13972 | 0 | 7.873054 | 80.77179699999998 | 2021-11-14 04:21:31 | Sri Lanka | ||||
694697 | 694697 | 2022-03-17 | Sri Lanka | 657435 | 16419 | 0 | 7.873054 | 80.77179699999998 | 2022-03-18 04:20:55 | Sri Lanka | ||||
698712 | 698712 | 2021-11-04 | Sri Lanka | 543385 | 13806 | 0 | 7.873054 | 80.77179699999998 | 2021-11-05 04:21:54 | Sri Lanka | ||||
702708 | 702708 | 2021-03-16 | Sri Lanka | 88392 | 532 | 84969 | 2891 | 7.873054 | 80.77179699999998 | 2021-03-17 05:25:07 | Sri Lanka | |||
706742 | 706742 | 2021-09-29 | Sri Lanka | 516465 | 12847 | 0 | 7.873054 | 80.77179699999998 | 2021-09-30 04:21:20 | Sri Lanka | ||||
714773 | 714773 | 2021-11-12 | Sri Lanka | 548784 | 13950 | 0 | 7.873054 | 80.77179699999998 | 2021-11-13 04:21:38 | Sri Lanka | ||||
722805 | 722805 | 2021-11-20 | Sri Lanka | 555929 | 14108 | 0 | 7.873054 | 80.77179699999998 | 2021-11-21 04:22:13 | 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 | |||
730835 | 730835 | 2021-12-27 | Sri Lanka | 584107 | 14901 | 0 | 7.873054 | 80.77179699999998 | 2021-12-28 04:21:47 | Sri Lanka | ||||
737931 | 737931 | 2020-06-12 | Sri Lanka | 1880 | 11 | 1196 | 673 | 7.873054 | 80.77179699999998 | 2020-06-13 03:33:14 | Sri Lanka | |||
738603 | 738603 | 2020-12-02 | Sri Lanka | 25410 | 124 | 18304 | 6982 | 7.873054 | 80.77179699999998 | 2020-12-03 05:28:22 | Sri Lanka | |||
742617 | 742617 | 2021-02-20 | Sri Lanka | 79480 | 435 | 73456 | 5589 | 7.873054 | 80.77179699999998 | 2021-02-21 05:24:33 | Sri Lanka | |||
746652 | 746652 | 2022-04-23 | Sri Lanka | 663131 | 16502 | 0 | 7.873054 | 80.77179699999998 | 2022-04-24 04:20:56 | 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 | |||
754603 | 754603 | 2020-10-28 | Sri Lanka | 9205 | 19 | 4075 | 5111 | 7.873054 | 80.77179699999998 | 2020-10-29 04:24:49 | Sri Lanka | |||
758635 | 758635 | 2021-11-26 | Sri Lanka | 561059 | 14258 | 0 | 7.873054 | 80.77179699999998 | 2021-11-27 04:22:45 | Sri Lanka | ||||
762614 | 762614 | 2020-10-18 | Sri Lanka | 5538 | 13 | 3403 | 2122 | 7.873054 | 80.77179699999998 | 2020-10-19 04:24:16 | Sri Lanka | |||
766622 | 766622 | 2020-12-29 | Sri Lanka | 42056 | 195 | 33925 | 7936 | 7.873054 | 80.77179699999998 | 2020-12-30 05:22:34 | Sri Lanka | |||
770656 | 770656 | 2021-10-23 | Sri Lanka | 535529 | 13593 | 0 | 7.873054 | 80.77179699999998 | 2021-10-24 04:21:22 | Sri Lanka | ||||
774650 | 774650 | 2021-01-12 | Sri Lanka | 49537 | 244 | 42621 | 6672 | 7.873054 | 80.77179699999998 | 2021-01-13 05:22:15 | 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 | |||
782698 | 782698 | 2021-12-13 | Sri Lanka | 573649 | 14641 | 0 | 7.873054 | 80.77179699999998 | 2021-12-14 04:22:38 | 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 | |||
790686 | 790686 | 2021-02-04 | Sri Lanka | 67115 | 339 | 60567 | 6209 | 7.873054 | 80.77179699999998 | 2021-02-05 05:22:38 | Sri Lanka | |||
798737 | 798737 | 2021-12-22 | Sri Lanka | 581595 | 14811 | 0 | 7.873054 | 80.77179699999998 | 2021-12-23 04:21:21 | Sri Lanka | ||||
805730 | 805730 | 2020-06-01 | Sri Lanka | 1643 | 11 | 811 | 821 | 7.873054 | 80.77179699999998 | 2020-06-02 02:33:08 | Sri Lanka | |||
809201 | 809201 | 2020-03-27 | Sri Lanka | 106 | 0 | 7 | 99 | 7.873054 | 80.77179699999998 | 2020-03-27 23:23:03 | Sri Lanka | |||
809882 | 809882 | 2021-09-20 | Sri Lanka | 506009 | 12218 | 0 | 7.873054 | 80.77179699999998 | 2021-09-21 04:21:26 | 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 | |||
817866 | 817866 | 2020-10-09 | Sri Lanka | 4523 | 13 | 3296 | 1214 | 7.873054 | 80.77179699999998 | 2020-10-10 04:23:57 | Sri Lanka | |||
821872 | 821872 | 2020-11-19 | Sri Lanka | 18841 | 73 | 12903 | 5865 | 7.873054 | 80.77179699999998 | 2020-11-20 05:26:28 | 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 | |||
829903 | 829903 | 2021-07-09 | Sri Lanka | 271483 | 3434 | 241035 | 27014 | 7.873054 | 80.77179699999998 | 2021-07-10 04:21:25 | 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 | |||
845193 | 845193 | 2020-07-22 | Sri Lanka | 2752 | 11 | 2064 | 677 | 7.873054 | 80.77179699999998 | 2020-07-23 05:15:04 | Sri Lanka | |||
845872 | 845872 | 2020-12-12 | Sri Lanka | 32135 | 149 | 23304 | 8682 | 7.873054 | 80.77179699999998 | 2020-12-13 05:27:20 | 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]);