⚠️ 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

517 rows where country_or_region = "Nepal" sorted by province_or_state

View and edit SQL

Suggested facets: latitude, longitude, day (date), last_update (date)

country_or_region

  • Nepal · 517

province_or_state

Link rowid day country_or_region province_or_state ▼ admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
430 2021-02-27 Nepal       274065 2773 270325 967 28.1667 84.25 2021-02-28 05:22:20 Nepal
7574 2020-06-04 Nepal       2634 10 290 2334 28.1667 84.25 2020-06-05 02:33:06 Nepal
8054 2020-08-11 Nepal       23948 83 16664 7201 28.1667 84.25 2020-08-12 04:27:29 Nepal
12007 2020-09-27 Nepal       73394 477 53898 19019 28.1667 84.25 2020-09-28 04:23:00 Nepal
18733 2020-05-12 Nepal       217 0 33 184 28.1667 84.25 2020-05-13 03:32:26 Nepal
19236 2021-05-31 Nepal       561302 7386 447446 106470 28.1667 84.25 2021-06-01 04:23:09 Nepal
23222 2021-05-05 Nepal       359610 3475 289783 66352 28.1667 84.25 2021-05-06 04:20:38 Nepal
27208 2021-02-08 Nepal       272055 2045 268266 1744 28.1667 84.25 2021-02-09 05:23:30 Nepal
33705 2020-04-13 Nepal       14 0 1 13 28.1667 84.25 2020-04-13 23:07:34 Nepal
34200 2020-11-20 Nepal       216965 1298 191002 24665 28.1667 84.25 2020-11-21 05:25:51 Nepal
38169 2020-09-20 Nepal       64122 411 46233 17478 28.1667 84.25 2020-09-21 04:23:00 Nepal
42151 2021-06-16 Nepal       614216 8558 543521 62137 28.1667 84.25 2021-06-17 04:22:36 Nepal
46134 2020-12-21 Nepal       254514 1795 244743 7976 28.1667 84.25 2020-12-22 05:22:33 Nepal
50103 2020-09-04 Nepal       44236 271 25561 18404 28.1667 84.25 2020-09-05 04:28:19 Nepal
57266 2020-06-05 Nepal       2912 11 333 2568 28.1667 84.25 2020-06-06 02:33:00 Nepal
57763 2021-05-20 Nepal       488645 5847 366946 115852 28.1667 84.25 2021-05-21 04:20:43 Nepal
65021 2020-06-22 Nepal       9561 23 2148 7390 28.1667 84.25 2020-06-23 04:33:22 Nepal
65515 2021-02-13 Nepal       272614 2054 268929 1631 28.1667 84.25 2021-02-14 05:23:43 Nepal
69499 2020-11-14 Nepal       208299 1215 170632 36452 28.1667 84.25 2020-11-15 05:26:53 Nepal
76429 2020-03-28 Nepal       5 0 1 4 28.1667 84.25 3/28/20 23:05 Nepal
76920 2020-11-15 Nepal       209776 1221 173430 35125 28.1667 84.25 2020-11-16 05:25:57 Nepal
80908 2021-05-28 Nepal       549111 7047 428670 113394 28.1667 84.25 2021-05-29 04:20:41 Nepal
84894 2021-03-17 Nepal       275518 3014 271550 954 28.1667 84.25 2021-03-18 05:26:22 Nepal
88881 2021-05-08 Nepal       385890 3632 298765 83493 28.1667 84.25 2021-05-09 04:20:35 Nepal
95820 2020-03-30 Nepal       5 0 1 4 28.1667 84.25 3/30/20 22:52 Nepal
99249 2020-03-26 Nepal       3 0 1 2 28.1667 84.25 2020-03-26 23:48:18 Nepal
99740 2020-11-17 Nepal       211475 1247 179242 30986 28.1667 84.25 2020-11-18 05:40:31 Nepal
106983 2020-06-13 Nepal       5335 18 913 4404 28.1667 84.25 2020-06-14 03:33:15 Nepal
107475 2020-12-07 Nepal       241995 1614 227433 12948 28.1667 84.25 2020-12-08 05:27:42 Nepal
113827 2020-04-07 Nepal       9 0 1 8 28.1667 84.25 2020-04-07 23:04:29 Nepal
116914 2020-04-20 Nepal       31 0 4 27 28.1667 84.25 2020-04-20 23:36:27 Nepal
120726 2020-07-05 Nepal       15784 34 6547 9203 28.1667 84.25 2020-07-06 04:33:57 Nepal
120865 2020-02-21 Nepal       1 0 1       2020-02-12T14:43:03  
121311 2021-05-09 Nepal       394667 3720 302787 88160 28.1667 84.25 2021-05-10 04:20:38 Nepal
125298 2021-04-01 Nepal       277461 3031 272851 1579 28.1667 84.25 2021-04-02 04:20:36 Nepal
129285 2021-05-11 Nepal       413111 4084 312019 97008 28.1667 84.25 2021-05-12 04:21:29 Nepal
132977 2020-03-04 Nepal       1 0 1   28.1667 84.25 2020-02-12T14:43:03  
133437 2021-02-28 Nepal       274143 2774 270407 962 28.1667 84.25 2021-03-01 05:23:01 Nepal
137321 2020-03-20 Nepal       1 0 1   28.3949 84.124 2020-03-13T22:22:03  
137779 2021-03-09 Nepal       274869 3012 270987 870 28.1667 84.25 2021-03-10 05:24:35 Nepal
141764 2021-01-08 Nepal       264159 1909 257229 5021 28.1667 84.25 2021-01-09 05:22:18 Nepal
145734 2020-10-27 Nepal       160400 876 118843 40681 28.1667 84.25 2020-10-28 04:24:39 Nepal
149719 2021-05-24 Nepal       520461 6531 398483 115447 28.1667 84.25 2021-05-25 04:21:08 Nepal
153355 2020-02-25 Nepal       1 0 1       2020-02-12T14:43:03  
153788 2020-10-02 Nepal       82450 520 60696 21234 28.1667 84.25 2020-10-03 04:23:40 Nepal
160465 2020-05-01 Nepal       59 0 16 43 28.1667 84.25 2020-05-02 02:32:27 Nepal
160962 2020-12-19 Nepal       253184 1777 242567 8840 28.1667 84.25 2020-12-20 05:27:32 Nepal
164949 2021-03-04 Nepal       274488 2778 270683 1027 28.1667 84.25 2021-03-05 05:26:29 Nepal
168933 2020-11-24 Nepal       224078 1361 204858 17859 28.1667 84.25 2020-11-25 05:27:20 Nepal
175732 2020-05-16 Nepal       291 1 36 254 28.1667 84.25 2020-05-17 02:32:32 Nepal
176230 2020-12-17 Nepal       251692 1749 240363 9580 28.1667 84.25 2020-12-18 05:28:18 Nepal
180199 2020-08-29 Nepal       37340 207 20555 16578 28.1667 84.25 2020-08-30 04:28:22 Nepal
184159 2020-10-07 Nepal       94253 578 68668 25007 28.1667 84.25 2020-10-08 04:23:56 Nepal
191588 2020-07-31 Nepal       19771 56 14399 5316 28.1667 84.25 2020-08-01 04:36:27 Nepal
195235 2020-06-01 Nepal       1811 8 221 1582 28.1667 84.25 2020-06-02 02:33:08 Nepal
195716 2020-10-04 Nepal       86823 535 64069 22219 28.1667 84.25 2020-10-05 04:23:33 Nepal
199441 2020-03-07 Nepal       1 0 1   28.1667 84.25 2020-02-12T14:43:03  
199911 2020-10-12 Nepal       111802 645 77277 33880 28.1667 84.25 2020-10-13 04:24:02 Nepal
206578 2020-04-30 Nepal       57 0 16 41 28.1667 84.25 2020-05-01 02:32:28 Nepal
207076 2021-01-05 Nepal       262784 1893 255666 5225 28.1667 84.25 2021-01-06 05:22:16 Nepal
211045 2020-09-18 Nepal       61593 390 43820 17383 28.1667 84.25 2020-09-19 04:22:00 Nepal
215026 2021-04-04 Nepal       277944 3032 273240 1672 28.1667 84.25 2021-04-05 04:20:35 Nepal
219010 2020-12-01 Nepal       233452 1529 216594 15329 28.1667 84.25 2020-12-02 05:27:41 Nepal
222994 2021-01-01 Nepal       261019 1864 253107 6048 28.1667 84.25 2021-01-02 05:22:33 Nepal
226615 2020-02-09 Nepal       1 0 0       2020-01-31T08:15:53  
227059 2021-06-21 Nepal       622640 8772 559928 53940 28.1667 84.25 2021-06-22 04:21:34 Nepal
231045 2021-05-17 Nepal       464218 5215 345523 113480 28.1667 84.25 2021-05-18 04:20:33 Nepal
235033 2021-06-24 Nepal       629431 8918 570958 49555 28.1667 84.25 2021-06-25 04:21:33 Nepal
242287 2020-06-20 Nepal       8605 22 1578 7005 28.1667 84.25 2020-06-21 04:33:19 Nepal
242414 2020-02-05 Nepal       1 0 0       2020-01-31T08:15:53  
245529 2020-04-28 Nepal       54 0 16 38 28.1667 84.25 2020-04-29 02:32:29 Nepal
246029 2021-06-06 Nepal       588124 7898 491009 89217 28.1667 84.25 2021-06-07 04:22:51 Nepal
250012 2020-12-06 Nepal       240981 1594 225805 13582 28.1667 84.25 2020-12-07 05:26:14 Nepal
253999 2021-03-16 Nepal       275424 3014 271495 915 28.1667 84.25 2021-03-17 05:25:07 Nepal
261430 2020-07-29 Nepal       19273 49 14021 5203 28.1667 84.25 2020-07-30 04:35:05 Nepal
261928 2020-11-25 Nepal       226026 1389 207998 16639 28.1667 84.25 2020-11-26 05:27:44 Nepal
265912 2020-12-10 Nepal       245650 1663 231601 12386 28.1667 84.25 2020-12-11 05:26:59 Nepal
272452 2020-04-17 Nepal       30 0 2 28 28.1667 84.25 2020-04-17 23:30:32 Nepal
272952 2021-06-10 Nepal       601687 8238 515591 77858 28.1667 84.25 2021-06-11 04:23:20 Nepal
280236 2020-06-28 Nepal       12772 28 3013 9731 28.1667 84.25 2020-06-29 04:33:44 Nepal
280730 2021-02-10 Nepal       272349 2047 268549 1753 28.1667 84.25 2021-02-11 05:23:55 Nepal
287533 2020-05-17 Nepal       295 2 36 257 28.1667 84.25 2020-05-18 02:32:21 Nepal
288033 2021-01-31 Nepal       270959 2029 266336 2594 28.1667 84.25 2021-02-01 05:22:53 Nepal
292020 2021-02-17 Nepal       273070 2055 269394 1621 28.1667 84.25 2021-02-18 05:22:58 Nepal
298942 2020-03-25 Nepal       3 0 1 2 28.1667 84.25 2020-03-25 23:33:04 Nepal
299436 2021-03-06 Nepal       274655 3010 270828 817 28.1667 84.25 2021-03-07 05:21:54 Nepal
303424 2021-06-18 Nepal       617947 8641 549682 59624 28.1667 84.25 2021-06-19 04:22:33 Nepal
307408 2021-01-17 Nepal       267322 1959 261444 3919 28.1667 84.25 2021-01-18 05:22:34 Nepal
311379 2020-09-23 Nepal       67804 436 49954 17414 28.1667 84.25 2020-09-24 04:23:00 Nepal
315343 2020-08-19 Nepal       28938 120 17700 11118 28.1667 84.25 2020-08-20 04:27:43 Nepal
319320 2021-06-13 Nepal       608472 8412 531105 68955 28.1667 84.25 2021-06-14 04:22:46 Nepal
323305 2021-01-24 Nepal       269450 2001 264137 3312 28.1667 84.25 2021-01-25 05:22:16 Nepal
330480 2020-06-09 Nepal       4086 15 584 3487 28.1667 84.25 2020-06-10 04:07:00 Nepal
330959 2020-08-12 Nepal       24432 91 16728 7613 28.1667 84.25 2020-08-13 04:29:15 Nepal
334929 2021-04-27 Nepal       307925 3194 278506 26225 28.1667 84.25 2021-04-28 04:20:32 Nepal
342357 2020-07-28 Nepal       19063 49 13875 5139 28.1667 84.25 2020-07-29 04:35:11 Nepal
342858 2021-02-20 Nepal       273351 2061 269755 1535 28.1667 84.25 2021-02-21 05:24:33 Nepal
349881 2020-05-31 Nepal       1572 8 220 1344 28.1667 84.25 2020-06-01 02:32:46 Nepal
350381 2021-04-06 Nepal       278470 3036 273455 1979 28.1667 84.25 2021-04-07 04:20:53 Nepal
354004 2020-02-18 Nepal       1 0 1       2020-02-12T14:43:03  

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
);
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]);