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 province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
day (date) >30 ✖
- 2020-01-27 1
- 2020-01-28 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-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
- 2020-02-26 1
- 2020-02-27 1
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
371802 | 371802 | 2020-08-08 | Sri Lanka | 2841 | 11 | 2576 | 254 | 7.873054 | 80.77179699999998 | 2020-08-09 04:34:54 | Sri Lanka | |||
372507 | 372507 | 2022-09-13 | Sri Lanka | 670501 | 16736 | 0 | 7.873054 | 80.771797 | 2022-09-14 04:20:44 | 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 | |||
384534 | 384534 | 2022-09-23 | Sri Lanka | 670685 | 16753 | 0 | 7.873054 | 80.771797 | 2022-09-24 04:21:40 | 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 | |||
396575 | 396575 | 2022-10-07 | Sri Lanka | 670844 | 16767 | 0 | 7.873054 | 80.771797 | 2022-10-08 04:22:56 | 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 | |||
418943 | 418943 | 2020-04-18 | Sri Lanka | 254 | 7 | 86 | 161 | 7.873054 | 80.771797 | 2020-04-18 22:32:28 | Sri Lanka | |||
419646 | 419646 | 2022-09-18 | Sri Lanka | 670596 | 16747 | 0 | 7.873054 | 80.771797 | 2022-09-19 04:21:49 | 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 | |||
431668 | 431668 | 2022-11-03 | Sri Lanka | 671302 | 16782 | 0 | 7.873054 | 80.771797 | 2022-11-04 04:22:11 | 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 | ||||
451698 | 451698 | 2022-12-21 | Sri Lanka | 671831 | 16814 | 0 | 7.873054 | 80.771797 | 2022-12-22 04:20:56 | 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 | ||||
463704 | 463704 | 2022-05-02 | Sri Lanka | 663408 | 16505 | 0 | 7.873054 | 80.771797 | 2022-05-03 04:21:00 | 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 | |||
475751 | 475751 | 2022-06-26 | Sri Lanka | 664080 | 16521 | 0 | 7.873054 | 80.771797 | 2022-06-27 04:21:00 | Sri Lanka | ||||
479209 | 479209 | 2020-02-25 | Sri Lanka | 1 | 0 | 1 | 2020-02-08T03:43:03 | |||||||
479901 | 479901 | 2022-11-08 | Sri Lanka | 671350 | 16782 | 0 | 7.873054 | 80.771797 | 2022-11-09 04:21:22 | 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 | |||
487931 | 487931 | 2022-11-25 | Sri Lanka | 671626 | 16799 | 0 | 7.873054 | 80.771797 | 2022-11-26 04:21:11 | 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 | ||||
503995 | 503995 | 2022-12-17 | Sri Lanka | 671808 | 16814 | 0 | 7.873054 | 80.771797 | 2022-12-18 04:21:03 | 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 | ||||
516039 | 516039 | 2022-10-15 | Sri Lanka | 670918 | 16769 | 0 | 7.873054 | 80.771797 | 2022-10-16 04:22:39 | 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 | ||||
539063 | 539063 | 2022-10-26 | Sri Lanka | 671030 | 16776 | 0 | 7.873054 | 80.771797 | 2022-10-27 04:22:01 | Sri Lanka | ||||
543079 | 543079 | 2022-12-15 | Sri Lanka | 671793 | 16812 | 0 | 7.873054 | 80.771797 | 2022-12-16 04:21:01 | 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 | ||||
559115 | 559115 | 2022-06-16 | Sri Lanka | 663975 | 16519 | 0 | 7.873054 | 80.771797 | 2022-06-17 04:20:56 | Sri Lanka | ||||
562603 | 562603 | 2020-03-01 | Sri Lanka | 1 | 0 | 1 | 7.0 | 81.0 | 2020-02-08T03:43:03 | |||||
563273 | 563273 | 2021-06-22 | Sri Lanka | 243913 | 2704 | 209296 | 31913 | 7.873054 | 80.77179699999998 | 2021-06-23 04:21:46 | Sri Lanka | |||
566730 | 566730 | 2020-02-06 | Sri Lanka | 1 | 0 | 0 | 2020-01-31T08:15:53 | |||||||
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 | ||||
593967 | 593967 | 2022-07-01 | Sri Lanka | 664138 | 16521 | 0 | 7.873054 | 80.771797 | 2022-07-02 04:21:16 | 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 | |||
617484 | 617484 | 2020-02-27 | Sri Lanka | 1 | 0 | 1 | 2020-02-08T03:43:03 | |||||||
618173 | 618173 | 2022-11-05 | Sri Lanka | 671320 | 16782 | 0 | 7.873054 | 80.771797 | 2022-11-06 04:21:24 | Sri Lanka | ||||
622187 | 622187 | 2022-05-22 | Sri Lanka | 663786 | 16513 | 0 | 7.873054 | 80.771797 | 2022-05-26 04:20:50 | 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 | |||
630217 | 630217 | 2022-07-12 | Sri Lanka | 664315 | 16526 | 0 | 7.873054 | 80.771797 | 2022-07-13 04:20:58 | 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 | ||||
657883 | 657883 | 2020-03-09 | Sri Lanka | 1 | 0 | 1 | 7.0 | 81.0 | 2020-02-08T03:43:03 | |||||
658622 | 658622 | 2022-05-13 | Sri Lanka | 663655 | 16511 | 0 | 7.873054 | 80.771797 | 2022-05-14 04:20:48 | 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 | |||
666577 | 666577 | 2020-09-16 | Sri Lanka | 3271 | 13 | 3021 | 237 | 7.873054 | 80.771797 | 2020-09-17 04:22:00 | Sri Lanka | |||
670608 | 670608 | 2022-07-21 | Sri Lanka | 664704 | 16535 | 0 | 7.873054 | 80.771797 | 2022-07-22 04:21:15 | Sri Lanka | ||||
674624 | 674624 | 2022-07-30 | Sri Lanka | 665626 | 16556 | 0 | 7.873054 | 80.771797 | 2022-07-31 04:21:02 | 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 | ||||
690684 | 690684 | 2022-12-23 | Sri Lanka | 671843 | 16814 | 0 | 7.873054 | 80.771797 | 2022-12-24 04:21:02 | 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 | ||||
710761 | 710761 | 2022-11-01 | Sri Lanka | 671110 | 16781 | 0 | 7.873054 | 80.771797 | 2022-11-02 04:22:09 | Sri Lanka | ||||
714773 | 714773 | 2021-11-12 | Sri Lanka | 548784 | 13950 | 0 | 7.873054 | 80.77179699999998 | 2021-11-13 04:21:38 | Sri Lanka | ||||
718793 | 718793 | 2022-12-04 | Sri Lanka | 671711 | 16805 | 0 | 7.873054 | 80.771797 | 2022-12-05 04:20:58 | 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 |
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]);