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

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
120865 2020-02-21 Nepal       1 0 1       2020-02-12T14:43:03  
153355 2020-02-25 Nepal       1 0 1       2020-02-12T14:43:03  
226615 2020-02-09 Nepal       1 0 0       2020-01-31T08:15:53  
242414 2020-02-05 Nepal       1 0 0       2020-01-31T08:15:53  
354004 2020-02-18 Nepal       1 0 1       2020-02-12T14:43:03  
379591 2020-02-16 Nepal       1 0 1       2020-02-12T14:43:03  
449954 2020-01-28 Nepal       1 0 0       1/28/20 23:00  
491502 2020-02-20 Nepal       1 0 1       2020-02-12T14:43:03  
673561 2020-02-06 Nepal       1 0 0       2020-01-31T08:15:53  
677624 2020-02-04 Nepal       1 0 0       2020-01-31T08:15:53  
685433 2020-02-27 Nepal       1 0 1       2020-02-12T14:43:03  
708825 2020-02-15 Nepal       1 0 1       2020-02-12T14:43:03  
754576 2020-02-19 Nepal       1 0 1       2020-02-12T14:43:03  
754654 2020-02-11 Nepal       1 0 0       2020-01-31T08:15:53  
874535 2020-02-07 Nepal       1 0 0       2020-01-31T08:15:53  
885809 2020-02-13 Nepal       1 0 1       2020-02-12T14:43:03  
953237 2020-01-26 Nepal       1 0 0       1/26/20 16:00  
965302 2020-02-29 Nepal       1 0 1       2020-02-12T14:43:03  
965392 2020-02-14 Nepal       1 0 1       2020-02-12T14:43:03  
1012446 2020-02-23 Nepal       1 0 1       2020-02-12T14:43:03  
1023607 2020-01-31 Nepal       1 0 0       1/31/2020 23:59  
1086555 2020-02-26 Nepal       1 0 1       2020-02-12T14:43:03  
1143344 2020-02-08 Nepal       1 0 0       2020-01-31T08:15:53  
1215247 2020-02-03 Nepal       1 0 0       2020-01-31T08:15:53  
1311411 2020-02-10 Nepal       1 0 0       2020-01-31T08:15:53  
1369540 2020-02-17 Nepal       1 0 1       2020-02-12T14:43:03  
1403288 2020-02-22 Nepal       1 0 1       2020-02-12T14:43:03  
1497192 2020-01-25 Nepal       1 0 0       1/25/20 17:00  
1523229 2020-02-02 Nepal       1 0 0       2020-01-31T08:15:53  
1552751 2020-01-29 Nepal       1 0 0       1/29/20 19:30  
1560817 2020-02-28 Nepal       1 0 1       2020-02-12T14:43:03  
1586183 2020-02-12 Nepal       1 0 1       2020-02-12T14:43:03  
1637564 2020-02-01 Nepal       1 0 0       1/31/2020 8:15  
1684554 2020-02-24 Nepal       1 0 1       2020-02-12T14:43:03  
1696556 2020-01-27 Nepal       1 0 0       1/27/20 23:59  
1752492 2020-01-30 Nepal       1 0 0       1/30/20 16:00  
137321 2020-03-20 Nepal       1 0 1   28.3949 84.124 2020-03-13T22:22:03  
387031 2020-03-18 Nepal       1 0 1   28.3949 84.124 2020-03-13T22:22:03  
391298 2020-03-16 Nepal       1 0 1   28.3949 84.124 2020-03-13T22:22:03  
642764 2020-03-14 Nepal       1 0 1   28.3949 84.124 2020-03-13T22:22:03  
778095 2020-03-13 Nepal       1 0 1   28.3949 84.124 2020-03-11T20:00:00  
984526 2020-03-12 Nepal       1 0 1   28.3949 84.124 2020-03-10T08:33:03  
1083029 2020-03-17 Nepal       1 0 1   28.3949 84.124 2020-03-13T22:22:03  
1180440 2020-03-11 Nepal       1 0 1   28.3949 84.124 2020-03-10T08:33:03  
1230630 2020-03-15 Nepal       1 0 1   28.3949 84.124 2020-03-13T22:22:03  
1295623 2020-03-10 Nepal       1 0 1   28.3949 84.124 2020-03-10T08:33:03  
1637480 2020-03-21 Nepal       1 0 1   28.3949 84.124 2020-03-13T22:22:03  
1748451 2020-03-19 Nepal       1 0 1   28.3949 84.124 2020-03-13T22:22:03  
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
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
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
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

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