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 latitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
228833 | 228833 | 2020-04-30 | Sri Lanka | 663 | 7 | 154 | 502 | 7.873054 | 80.77179699999998 | 2020-05-01 02:32:28 | Sri Lanka | |||
229535 | 229535 | 2022-05-31 | Sri Lanka | 663834 | 16517 | 0 | 7.873054 | 80.771797 | 2022-06-01 04:20:55 | Sri Lanka | ||||
233550 | 233550 | 2022-02-11 | Sri Lanka | 625804 | 15754 | 0 | 7.873054 | 80.77179699999998 | 2022-02-12 04:21:06 | Sri Lanka | ||||
237543 | 237543 | 2021-01-18 | Sri Lanka | 53750 | 270 | 45820 | 7660 | 7.873054 | 80.77179699999998 | 2021-01-19 05:22:15 | Sri Lanka | |||
241558 | 241558 | 2021-04-02 | Sri Lanka | 93128 | 571 | 89701 | 2856 | 7.873054 | 80.77179699999998 | 2021-04-03 04:20:44 | Sri Lanka | |||
245575 | 245575 | 2021-08-17 | Sri Lanka | 365683 | 6434 | 0 | 7.873054 | 80.77179699999998 | 2021-08-18 04:21:35 | Sri Lanka | ||||
249589 | 249589 | 2021-09-04 | Sri Lanka | 451401 | 9806 | 0 | 7.873054 | 80.77179699999998 | 2021-09-05 04:21:33 | Sri Lanka | ||||
253622 | 253622 | 2022-09-08 | Sri Lanka | 670341 | 16724 | 0 | 7.873054 | 80.771797 | 2022-09-09 04:21:11 | Sri Lanka | ||||
257640 | 257640 | 2022-12-10 | Sri Lanka | 671752 | 16808 | 0 | 7.873054 | 80.771797 | 2022-12-11 04:20:50 | Sri Lanka | ||||
261840 | 261840 | 2022-03-15 | Sri Lanka | 656814 | 16415 | 0 | 7.873054 | 80.77179699999998 | 2022-03-16 04:20:50 | Sri Lanka | ||||
268589 | 268589 | 2020-05-21 | Sri Lanka | 1055 | 9 | 604 | 442 | 7.873054 | 80.77179699999998 | 2020-05-22 02:36:51 | Sri Lanka | |||
271793 | 271793 | 2020-04-28 | Sri Lanka | 619 | 7 | 134 | 478 | 7.873054 | 80.77179699999998 | 2020-04-29 02:32:29 | Sri Lanka | |||
272456 | 272456 | 2020-11-10 | Sri Lanka | 14715 | 41 | 9537 | 5137 | 7.873054 | 80.77179699999998 | 2020-11-11 05:25:30 | Sri Lanka | |||
276490 | 276490 | 2021-11-03 | Sri Lanka | 542793 | 13791 | 0 | 7.873054 | 80.77179699999998 | 2021-11-04 04:22:20 | Sri Lanka | ||||
280486 | 280486 | 2021-02-24 | Sri Lanka | 81467 | 457 | 76514 | 4496 | 7.873054 | 80.77179699999998 | 2021-02-25 05:24:57 | Sri Lanka | |||
287608 | 287608 | 2020-06-15 | Sri Lanka | 1905 | 11 | 1342 | 552 | 7.873054 | 80.77179699999998 | 2020-06-16 04:33:09 | Sri Lanka | |||
288303 | 288303 | 2021-10-31 | Sri Lanka | 541073 | 13743 | 0 | 7.873054 | 80.77179699999998 | 2021-11-01 04:22:01 | Sri Lanka | ||||
292323 | 292323 | 2022-11-15 | Sri Lanka | 671455 | 16784 | 0 | 7.873054 | 80.771797 | 2022-11-16 04:21:09 | 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 | |||
303480 | 303480 | 2020-07-01 | Sri Lanka | 2054 | 11 | 1748 | 295 | 7.873054 | 80.77179699999998 | 2020-07-02 04:33:46 | Sri Lanka | |||
304176 | 304176 | 2022-04-16 | Sri Lanka | 662827 | 16495 | 0 | 7.873054 | 80.77179699999998 | 2022-04-17 04:20:59 | Sri Lanka | ||||
308195 | 308195 | 2022-12-13 | Sri Lanka | 671770 | 16809 | 0 | 7.873054 | 80.771797 | 2022-12-14 04:21:04 | Sri Lanka | ||||
312211 | 312211 | 2022-11-13 | Sri Lanka | 671417 | 16784 | 0 | 7.873054 | 80.771797 | 2022-11-14 04:21:09 | Sri Lanka | ||||
316224 | 316224 | 2022-02-12 | Sri Lanka | 626966 | 15777 | 0 | 7.873054 | 80.77179699999998 | 2022-02-13 04:21:00 | Sri Lanka | ||||
320243 | 320243 | 2022-10-30 | Sri Lanka | 671070 | 16779 | 0 | 7.873054 | 80.771797 | 2022-10-31 04:21:36 | 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 | |||
328217 | 328217 | 2022-12-27 | Sri Lanka | 671859 | 16815 | 0 | 7.873054 | 80.771797 | 2022-12-28 04:21:04 | 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 | |||
348607 | 348607 | 2022-12-14 | Sri Lanka | 671776 | 16809 | 0 | 7.873054 | 80.771797 | 2022-12-15 04:20:58 | 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 | ||||
360650 | 360650 | 2022-05-07 | Sri Lanka | 663533 | 16509 | 0 | 7.873054 | 80.771797 | 2022-05-08 04:20:49 | 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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
618173 | 618173 | 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 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]);