johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

163 rows where country_or_region = "Sri Lanka" sorted by day descending

View and edit SQL

country_or_region

  • Sri Lanka · 163

province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
242968 2020-07-07 Sri Lanka       2081 11 1955 115 7.873054 80.77179699999998 2020-07-08 05:33:48 Sri Lanka
56559 2020-07-06 Sri Lanka       2077 11 1917 149 7.873054 80.77179699999998 2020-07-07 04:34:00 Sri Lanka
347996 2020-07-05 Sri Lanka       2076 11 1903 162 7.873054 80.77179699999998 2020-07-06 04:33:57 Sri Lanka
319884 2020-07-04 Sri Lanka       2074 11 1885 178 7.873054 80.77179699999998 2020-07-05 04:33:46 Sri Lanka
260318 2020-07-03 Sri Lanka       2069 11 1863 195 7.873054 80.77179699999998 2020-07-04 04:33:51 Sri Lanka
207897 2020-07-02 Sri Lanka       2066 11 1827 228 7.873054 80.77179699999998 2020-07-03 04:33:54 Sri Lanka
164138 2020-07-01 Sri Lanka       2054 11 1748 295 7.873054 80.77179699999998 2020-07-02 04:33:46 Sri Lanka
333936 2020-06-30 Sri Lanka       2047 11 1711 325 7.873054 80.77179699999998 2020-07-01 04:33:52 Sri Lanka
50135 2020-06-29 Sri Lanka       2039 11 1678 350 7.873054 80.77179699999998 2020-06-30 04:33:48 Sri Lanka
60643 2020-06-28 Sri Lanka       2037 11 1661 365 7.873054 80.77179699999998 2020-06-29 04:33:44 Sri Lanka
84094 2020-06-27 Sri Lanka       2033 11 1639 383 7.873054 80.77179699999998 2020-06-28 04:34:04 Sri Lanka
98282 2020-06-26 Sri Lanka       2014 11 1619 384 7.873054 80.77179699999998 2020-06-27 04:33:35 Sri Lanka
371316 2020-06-25 Sri Lanka       2010 11 1602 397 7.873054 80.77179699999998 2020-06-26 04:33:43 Sri Lanka
119635 2020-06-24 Sri Lanka       2001 11 1562 428 7.873054 80.77179699999998 2020-06-25 05:26:54 Sri Lanka
109237 2020-06-23 Sri Lanka       1991 11 1548 432 7.873054 80.77179699999998 2020-06-24 04:33:28 Sri Lanka
183901 2020-06-22 Sri Lanka       1951 11 1526 414 7.873054 80.77179699999998 2020-06-23 04:33:22 Sri Lanka
190738 2020-06-21 Sri Lanka       1950 11 1498 441 7.873054 80.77179699999998 2020-06-22 04:33:20 Sri Lanka
239167 2020-06-20 Sri Lanka       1950 11 1472 467 7.873054 80.77179699999998 2020-06-21 04:33:19 Sri Lanka
90725 2020-06-19 Sri Lanka       1950 11 1446 493 7.873054 80.77179699999998 2020-06-20 04:33:19 Sri Lanka
6580 2020-06-18 Sri Lanka       1947 11 1421 515 7.873054 80.77179699999998 2020-06-19 04:33:17 Sri Lanka
39440 2020-06-17 Sri Lanka       1924 11 1397 516 7.873054 80.77179699999998 2020-06-18 04:33:18 Sri Lanka
235414 2020-06-16 Sri Lanka       1915 11 1371 533 7.873054 80.77179699999998 2020-06-17 04:33:21 Sri Lanka
134937 2020-06-15 Sri Lanka       1905 11 1342 552 7.873054 80.77179699999998 2020-06-16 04:33:09 Sri Lanka
337925 2020-06-14 Sri Lanka       1889 11 1287 591 7.873054 80.77179699999998 2020-06-15 03:33:14 Sri Lanka
225250 2020-06-13 Sri Lanka       1884 11 1252 621 7.873054 80.77179699999998 2020-06-14 03:33:15 Sri Lanka
156626 2020-06-12 Sri Lanka       1880 11 1196 673 7.873054 80.77179699999998 2020-06-13 03:33:14 Sri Lanka
160349 2020-06-11 Sri Lanka       1877 11 1150 716 7.873054 80.77179699999998 2020-06-12 05:09:52 Sri Lanka
152613 2020-06-10 Sri Lanka       1869 11 1122 736 7.873054 80.77179699999998 2020-06-11 03:33:41 Sri Lanka
279091 2020-06-09 Sri Lanka       1859 11 1057 791 7.873054 80.77179699999998 2020-06-10 04:07:00 Sri Lanka
102243 2020-06-08 Sri Lanka       1857 11 990 856 7.873054 80.77179699999998 2020-06-09 03:33:03 Sri Lanka
148825 2020-06-07 Sri Lanka       1835 11 941 883 7.873054 80.77179699999998 2020-06-08 03:33:22 Sri Lanka
267779 2020-06-06 Sri Lanka       1814 11 891 912 7.873054 80.77179699999998 2020-06-07 03:53:30 Sri Lanka
263987 2020-06-05 Sri Lanka       1801 11 858 932 7.873054 80.77179699999998 2020-06-06 02:33:00 Sri Lanka
173838 2020-06-04 Sri Lanka       1797 11 839 947 7.873054 80.77179699999998 2020-06-05 02:33:06 Sri Lanka
326887 2020-06-03 Sri Lanka       1749 11 836 902 7.873054 80.77179699999998 2020-06-04 02:33:14 Sri Lanka
299491 2020-06-02 Sri Lanka       1683 11 823 849 7.873054 80.77179699999998 2020-06-03 02:33:13 Sri Lanka
197445 2020-06-01 Sri Lanka       1643 11 811 821 7.873054 80.77179699999998 2020-06-02 02:33:08 Sri Lanka
94248 2020-05-31 Sri Lanka       1633 10 801 822 7.873054 80.77179699999998 2020-06-01 02:32:46 Sri Lanka
253075 2020-05-30 Sri Lanka       1620 10 781 829 7.873054 80.77179699999998 2020-05-31 02:32:45 Sri Lanka
211557 2020-05-29 Sri Lanka       1558 10 754 794 7.873054 80.77179699999998 2020-05-30 02:32:48 Sri Lanka
22731 2020-05-28 Sri Lanka       1530 10 745 775 7.873054 80.77179699999998 2020-05-29 02:32:50 Sri Lanka
306600 2020-05-27 Sri Lanka       1469 10 732 727 7.873054 80.77179699999998 2020-05-28 02:32:31 Sri Lanka
46347 2020-05-26 Sri Lanka       1319 10 712 597 7.873054 80.77179699999998 2020-05-27 02:32:31 Sri Lanka
249550 2020-05-25 Sri Lanka       1182 10 695 477 7.873054 80.77179699999998 2020-05-26 02:32:35 Sri Lanka
204102 2020-05-24 Sri Lanka       1141 9 674 458 7.873054 80.77179699999998 2020-05-25 02:32:44 Sri Lanka
131188 2020-05-23 Sri Lanka       1089 9 660 420 7.873054 80.77179699999998 2020-05-24 02:32:43 Sri Lanka
19213 2020-05-22 Sri Lanka       1068 9 620 439 7.873054 80.77179699999998 2020-05-23 02:32:42 Sri Lanka
303111 2020-05-21 Sri Lanka       1055 9 604 442 7.873054 80.77179699999998 2020-05-22 02:36:51 Sri Lanka
115858 2020-05-20 Sri Lanka       1028 9 584 435 7.873054 80.77179699999998 2020-05-21 02:32:48 Sri Lanka
221506 2020-05-19 Sri Lanka       1027 9 569 449 7.873054 80.77179699999998 2020-05-20 02:32:19 Sri Lanka
323242 2020-05-18 Sri Lanka       992 9 559 424 7.873054 80.77179699999998 2020-05-19 02:32:18 Sri Lanka
26038 2020-05-17 Sri Lanka       981 9 538 434 7.873054 80.77179699999998 2020-05-18 02:32:21 Sri Lanka
275149 2020-05-16 Sri Lanka       960 9 520 431 7.873054 80.77179699999998 2020-05-17 02:32:32 Sri Lanka
228547 2020-05-15 Sri Lanka       935 9 477 449 7.873054 80.77179699999998 2020-05-16 02:32:19 Sri Lanka
170192 2020-05-14 Sri Lanka       925 9 445 471 7.873054 80.77179699999998 2020-05-15 02:33:02 Sri Lanka
42790 2020-05-13 Sri Lanka       915 9 382 524 7.873054 80.77179699999998 2020-05-14 03:32:28 Sri Lanka
271269 2020-05-12 Sri Lanka       889 9 366 514 7.873054 80.77179699999998 2020-05-13 03:32:26 Sri Lanka
289231 2020-05-11 Sri Lanka       869 9 343 517 7.873054 80.77179699999998 2020-05-12 03:32:27 Sri Lanka
309834 2020-05-10 Sri Lanka       863 9 321 533 7.873054 80.77179699999998 2020-05-11 02:32:30 Sri Lanka
105473 2020-05-09 Sri Lanka       847 9 260 578 7.873054 80.77179699999998 2020-05-10 02:32:30 Sri Lanka
112464 2020-05-08 Sri Lanka       835 9 240 586 7.873054 80.77179699999998 2020-05-09 02:32:35 Sri Lanka
313057 2020-05-07 Sri Lanka       824 9 232 583 7.873054 80.77179699999998 2020-05-08 02:32:32 Sri Lanka
142010 2020-05-06 Sri Lanka       797 9 215 573 7.873054 80.77179699999998 2020-05-07 02:32:28 Sri Lanka
357347 2020-05-05 Sri Lanka       771 9 213 549 7.873054 80.77179699999998 2020-05-06 02:32:31 Sri Lanka
292432 2020-05-04 Sri Lanka       751 8 194 549 7.873054 80.77179699999998 2020-05-05 02:32:34 Sri Lanka
367274 2020-05-03 Sri Lanka       718 7 184 527 7.873054 80.77179699999998 2020-05-04 02:32:28 Sri Lanka
341114 2020-05-02 Sri Lanka       705 7 172 526 7.873054 80.77179699999998 2020-05-03 02:32:28 Sri Lanka
67267 2020-05-01 Sri Lanka       690 7 162 521 7.873054 80.77179699999998 2020-05-02 02:32:27 Sri Lanka
200693 2020-04-30 Sri Lanka       663 7 154 502 7.873054 80.77179699999998 2020-05-01 02:32:28 Sri Lanka
256244 2020-04-29 Sri Lanka       649 7 136 506 7.873054 80.77179699999998 2020-04-30 02:32:27 Sri Lanka
177001 2020-04-28 Sri Lanka       619 7 134 478 7.873054 80.77179699999998 2020-04-29 02:32:29 Sri Lanka
330139 2020-04-27 Sri Lanka       588 7 126 455 7.873054 80.77179699999998 2020-04-28 02:30:32 Sri Lanka
138787 2020-04-26 Sri Lanka       523 7 120 396 7.873054 80.77179699999998 2020-04-27 02:30:33 Sri Lanka
214756 2020-04-25 Sri Lanka       460 7 118 335 7.873054 80.77179699999998 2020-04-26 02:30:31 Sri Lanka
363978 2020-04-24 Sri Lanka       420 7 109 304 7.873054 80.77179699999998 2020-04-25 06:30:33 Sri Lanka
231660 2020-04-23 Sri Lanka       368 7 107 254 7.873054 80.77179699999998 2020-04-24 03:30:31 Sri Lanka
246142 2020-04-22 Sri Lanka       330 7 105 218 7.873054 80.77179699999998 2020-04-22 23:30:32 Sri Lanka
354139 2020-04-21 Sri Lanka       310 7 102 201 7.873054 80.77179699999998 2020-04-21 23:30:30 Sri Lanka
344196 2020-04-20 Sri Lanka       304 7 98 199 7.873054 80.77179699999998 2020-04-20 23:36:27 Sri Lanka
193808 2020-04-19 Sri Lanka       271 7 96 168 7.873054 80.771797 2020-04-19 23:40:41 Sri Lanka
351048 2020-04-18 Sri Lanka       254 7 86 161 7.873054 80.771797 2020-04-18 22:32:28 Sri Lanka
73743 2020-04-17 Sri Lanka       244 7 77 160 7.873054 80.77179699999998 2020-04-17 23:30:32 Sri Lanka
145153 2020-04-16 Sri Lanka       238 7 68 163 7.873054 80.77179699999998 2020-04-16 23:30:31 Sri Lanka
15650 2020-04-15 Sri Lanka       238 7 63 168 7.873054 80.77179699999998 2020-04-15 22:56:32 Sri Lanka
80309 2020-04-14 Sri Lanka       233 7 61 165 7.873054 80.77179699999998 2020-04-14 23:33:12 Sri Lanka
29165 2020-04-13 Sri Lanka       217 7 56 154 7.873054 80.77179699999998 2020-04-13 23:07:34 Sri Lanka
122620 2020-04-12 Sri Lanka       210 7 56 147 7.873054 80.771797 2020-04-12 23:17:00 Sri Lanka
32201 2020-04-11 Sri Lanka       198 7 54 137 7.873054 80.77179699999998 2020-04-11 22:45:13 Sri Lanka
186839 2020-04-10 Sri Lanka       190 7 54 129 7.873054 80.77179699999998 2020-04-10 22:53:48 Sri Lanka
77067 2020-04-09 Sri Lanka       190 7 49 134 7.873054 80.77179699999998 2020-04-09 23:02:19 Sri Lanka
86975 2020-04-08 Sri Lanka       189 7 44 138 7.873054 80.77179699999998 2020-04-08 22:51:39 Sri Lanka
2831 2020-04-07 Sri Lanka       185 6 42 137 7.873054 80.77179699999998 2020-04-07 23:04:29 Sri Lanka
316085 2020-04-06 Sri Lanka       178 5 38 135 7.873054 80.771797 4/6/20 23:21 Sri Lanka
166899 2020-04-05 Sri Lanka       176 5 33 138 7.873054 80.77179699999998 2020-04-05 23:06:26 Sri Lanka
180077 2020-04-04 Sri Lanka       166 5 27 134 7.873054 80.771797 4/4/20 23:34 Sri Lanka
52758 2020-04-03 Sri Lanka       159 4 24 131 7.873054 80.77179699999998 2020-04-03 22:46:20 Sri Lanka
125191 2020-04-02 Sri Lanka       151 4 21 126 7.873054 80.771797 4/2/20 23:25 Sri Lanka
12626 2020-04-01 Sri Lanka       146 3 21 122 7.873054 80.77179699999998 2020-04-01 21:58:34 Sri Lanka
127626 2020-03-31 Sri Lanka       143 2 17 124 7.873054 80.77179699999998 2020-03-31 23:43:43 Sri Lanka
64082 2020-03-30 Sri Lanka       122 2 15 105 7.873054 80.771797 3/30/20 22:52 Sri Lanka

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2347.5ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette