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

200 rows where country_or_region = "Nepal" sorted by day descending

View and edit SQL

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

country_or_region

  • Nepal · 200

province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
496552 2020-08-11 Nepal       23948 83 16664 7201 28.1667 84.25 2020-08-12 04:27:29 Nepal
277954 2020-08-10 Nepal       23310 79 16493 6738 28.1667 84.25 2020-08-11 04:35:08 Nepal
463166 2020-08-09 Nepal       22972 75 16353 6544 28.1667 84.25 2020-08-10 04:34:55 Nepal
398898 2020-08-08 Nepal       22592 73 16313 6206 28.1667 84.25 2020-08-09 04:34:54 Nepal
289462 2020-08-07 Nepal       22214 70 15814 6330 28.1667 84.25 2020-08-08 04:34:53 Nepal
339877 2020-08-06 Nepal       21750 65 15389 6296 28.1667 84.25 2020-08-07 04:35:11 Nepal
42220 2020-08-05 Nepal       21390 60 15156 6174 28.1667 84.25 2020-08-06 04:35:02 Nepal
438769 2020-08-04 Nepal       21009 58 15026 5925 28.1667 84.25 2020-08-05 04:34:43 Nepal
417265 2020-08-03 Nepal       20750 57 14961 5732 28.1667 84.25 2020-08-04 04:41:59 Nepal
507776 2020-08-02 Nepal       20332 57 14603 5672 28.1667 84.25 2020-08-03 04:34:35 Nepal
66949 2020-08-01 Nepal       20086 56 14492 5538 28.1667 84.25 2020-08-02 04:34:47 Nepal
158418 2020-07-31 Nepal       19771 56 14399 5316 28.1667 84.25 2020-08-01 04:36:27 Nepal
379850 2020-07-30 Nepal       19547 52 14248 5247 28.1667 84.25 2020-07-31 04:35:18 Nepal
431401 2020-07-29 Nepal       19273 49 14021 5203 28.1667 84.25 2020-07-30 04:35:05 Nepal
126038 2020-07-28 Nepal       19063 49 13875 5139 28.1667 84.25 2020-07-29 04:35:11 Nepal
308259 2020-07-27 Nepal       18752 48 13754 4950 28.1667 84.25 2020-07-28 04:58:43 Nepal
424609 2020-07-26 Nepal       18613 45 13128 5440 28.1667 84.25 2020-07-27 04:35:02 Nepal
225077 2020-07-25 Nepal       18483 45 13053 5385 28.1667 84.25 2020-07-26 04:35:00 Nepal
402825 2020-07-24 Nepal       18374 44 12947 5383 28.1667 84.25 2020-07-25 04:47:39 Nepal
207481 2020-07-23 Nepal       18241 43 12840 5358 28.1667 84.25 2020-07-24 05:30:40 Nepal
112891 2020-07-22 Nepal       18094 42 12684 5368 28.1667 84.25 2020-07-23 05:15:04 Nepal
303454 2020-07-21 Nepal       17994 40 12477 5477 28.1667 84.25 2020-07-22 04:34:42 Nepal
197101 2020-07-20 Nepal       17844 40 11868 5936 28.1667 84.25 2020-07-21 04:38:46 Nepal
87669 2020-07-19 Nepal       17658 40 11695 5923 28.1667 84.25 2020-07-20 05:34:40 Nepal
489671 2020-07-18 Nepal       17502 40 11637 5825 28.1667 84.25 2020-07-19 04:34:58 Nepal
105179 2020-07-17 Nepal       17445 40 11534 5871 28.1667 84.25 2020-07-18 04:34:45 Nepal
98209 2020-07-16 Nepal       17344 39 11249 6056 28.1667 84.25 2020-07-17 04:34:50 Nepal
351169 2020-07-15 Nepal       17177 39 11025 6113 28.1667 84.25 2020-07-16 04:44:59 Nepal
369442 2020-07-14 Nepal       17061 38 10328 6695 28.1667 84.25 2020-07-15 04:34:39 Nepal
165455 2020-07-13 Nepal       16945 38 10294 6613 28.1667 84.25 2020-07-14 04:34:46 Nepal
358657 2020-07-12 Nepal       16801 38 8589 8174 28.1667 84.25 2020-07-13 04:43:04 Nepal
406641 2020-07-11 Nepal       16719 38 8442 8239 28.1667 84.25 2020-07-12 04:34:30 Nepal
7620 2020-07-10 Nepal       16649 35 8011 8603 28.1667 84.25 2020-07-11 04:34:26 Nepal
390640 2020-07-09 Nepal       16531 35 7891 8605 28.1667 84.25 2020-07-10 04:34:24 Nepal
285525 2020-07-08 Nepal       16423 35 7752 8636 28.1667 84.25 2020-07-09 04:34:23 Nepal
154235 2020-07-07 Nepal       16168 35 7499 8634 28.1667 84.25 2020-07-08 05:33:48 Nepal
256171 2020-07-06 Nepal       15964 35 6811 9118 28.1667 84.25 2020-07-07 04:34:00 Nepal
193273 2020-07-05 Nepal       15784 34 6547 9203 28.1667 84.25 2020-07-06 04:33:57 Nepal
267098 2020-07-04 Nepal       15491 34 6415 9042 28.1667 84.25 2020-07-05 04:33:46 Nepal
77461 2020-07-03 Nepal       15259 32 6143 9084 28.1667 84.25 2020-07-04 04:33:51 Nepal
228877 2020-07-02 Nepal       14519 31 5320 9168 28.1667 84.25 2020-07-03 04:33:54 Nepal
108972 2020-07-01 Nepal       14046 30 4656 9360 28.1667 84.25 2020-07-02 04:33:46 Nepal
214332 2020-06-30 Nepal       13564 29 3194 10341 28.1667 84.25 2020-07-01 04:33:52 Nepal
46010 2020-06-29 Nepal       13248 29 3134 10085 28.1667 84.25 2020-06-30 04:33:48 Nepal
446153 2020-06-28 Nepal       12772 28 3013 9731 28.1667 84.25 2020-06-29 04:33:44 Nepal
15225 2020-06-27 Nepal       12309 28 2834 9447 28.1667 84.25 2020-06-28 04:34:04 Nepal
130056 2020-06-26 Nepal       11755 27 2698 9030 28.1667 84.25 2020-06-27 04:33:35 Nepal
53599 2020-06-25 Nepal       11162 26 2650 8486 28.1667 84.25 2020-06-26 04:33:43 Nepal
28601 2020-06-24 Nepal       10728 24 2338 8366 28.1667 84.25 2020-06-25 05:26:54 Nepal
394887 2020-06-23 Nepal       10099 24 2224 7851 28.1667 84.25 2020-06-24 04:33:28 Nepal
365624 2020-06-22 Nepal       9561 23 2148 7390 28.1667 84.25 2020-06-23 04:33:22 Nepal
259926 2020-06-21 Nepal       9026 23 1772 7231 28.1667 84.25 2020-06-22 04:33:20 Nepal
469483 2020-06-20 Nepal       8605 22 1578 7005 28.1667 84.25 2020-06-21 04:33:19 Nepal
347275 2020-06-19 Nepal       8274 22 1402 6850 28.1667 84.25 2020-06-20 04:33:19 Nepal
503844 2020-06-18 Nepal       7848 22 1186 6640 28.1667 84.25 2020-06-19 04:33:17 Nepal
11369 2020-06-17 Nepal       7177 20 1167 5990 28.1667 84.25 2020-06-18 04:33:18 Nepal
179675 2020-06-16 Nepal       6591 19 1158 5414 28.1667 84.25 2020-06-17 04:33:21 Nepal
245914 2020-06-15 Nepal       6211 19 1041 5151 28.1667 84.25 2020-06-16 04:33:09 Nepal
49751 2020-06-14 Nepal       5760 19 974 4767 28.1667 84.25 2020-06-15 03:33:14 Nepal
386836 2020-06-13 Nepal       5335 18 913 4404 28.1667 84.25 2020-06-14 03:33:15 Nepal
293205 2020-06-12 Nepal       5062 16 877 4169 28.1667 84.25 2020-06-13 03:33:14 Nepal
119543 2020-06-11 Nepal       4614 15 861 3738 28.1667 84.25 2020-06-12 05:09:52 Nepal
332531 2020-06-10 Nepal       4364 15 674 3675 28.1667 84.25 2020-06-11 03:33:41 Nepal
354844 2020-06-09 Nepal       4086 15 584 3487 28.1667 84.25 2020-06-10 04:07:00 Nepal
281719 2020-06-08 Nepal       3762 14 488 3260 28.1667 84.25 2020-06-09 03:33:03 Nepal
3682 2020-06-07 Nepal       3448 13 467 2968 28.1667 84.25 2020-06-08 03:33:22 Nepal
137370 2020-06-06 Nepal       3235 13 365 2857 28.1667 84.25 2020-06-07 03:53:30 Nepal
186532 2020-06-05 Nepal       2912 11 333 2568 28.1667 84.25 2020-06-06 02:33:00 Nepal
133698 2020-06-04 Nepal       2634 10 290 2334 28.1667 84.25 2020-06-05 02:33:06 Nepal
343523 2020-06-03 Nepal       2300 9 278 2013 28.1667 84.25 2020-06-04 02:33:14 Nepal
473121 2020-06-02 Nepal       2099 8 266 1825 28.1667 84.25 2020-06-03 02:33:13 Nepal
410277 2020-06-01 Nepal       1811 8 221 1582 28.1667 84.25 2020-06-02 02:33:08 Nepal
70672 2020-05-31 Nepal       1572 8 220 1344 28.1667 84.25 2020-06-01 02:32:46 Nepal
442365 2020-05-30 Nepal       1401 6 219 1176 28.1667 84.25 2020-05-31 02:32:45 Nepal
242163 2020-05-29 Nepal       1212 6 206 1000 28.1667 84.25 2020-05-30 02:32:48 Nepal
18776 2020-05-28 Nepal       1042 5 187 850 28.1667 84.25 2020-05-29 02:32:50 Nepal
221149 2020-05-27 Nepal       886 4 183 699 28.1667 84.25 2020-05-28 02:32:31 Nepal
335936 2020-05-26 Nepal       772 4 155 613 28.1667 84.25 2020-05-27 02:32:31 Nepal
35042 2020-05-25 Nepal       682 4 112 566 28.1667 84.25 2020-05-26 02:32:35 Nepal
217735 2020-05-24 Nepal       603 3 87 513 28.1667 84.25 2020-05-25 02:32:44 Nepal
318582 2020-05-23 Nepal       584 3 70 511 28.1667 84.25 2020-05-24 02:32:43 Nepal
325300 2020-05-22 Nepal       516 3 70 443 28.1667 84.25 2020-05-23 02:32:42 Nepal
172201 2020-05-21 Nepal       457 3 49 405 28.1667 84.25 2020-05-22 02:36:51 Nepal
175820 2020-05-20 Nepal       427 2 45 380 28.1667 84.25 2020-05-21 02:32:48 Nepal
270580 2020-05-19 Nepal       402 2 37 363 28.1667 84.25 2020-05-20 02:32:19 Nepal
238640 2020-05-18 Nepal       375 2 36 337 28.1667 84.25 2020-05-19 02:32:18 Nepal
91052 2020-05-17 Nepal       295 2 36 257 28.1667 84.25 2020-05-18 02:32:21 Nepal
249339 2020-05-16 Nepal       291 1 36 254 28.1667 84.25 2020-05-17 02:32:32 Nepal
482711 2020-05-15 Nepal       267 0 36 231 28.1667 84.25 2020-05-16 02:32:19 Nepal
496077 2020-05-14 Nepal       249 0 35 214 28.1667 84.25 2020-05-15 02:33:02 Nepal
383088 2020-05-13 Nepal       250 0 35 215 28.1667 84.25 2020-05-14 03:32:28 Nepal
38278 2020-05-12 Nepal       217 0 33 184 28.1667 84.25 2020-05-13 03:32:26 Nepal
452791 2020-05-11 Nepal       134 0 33 101 28.1667 84.25 2020-05-12 03:32:27 Nepal
372672 2020-05-10 Nepal       110 0 31 79 28.1667 84.25 2020-05-11 02:32:30 Nepal
273865 2020-05-09 Nepal       110 0 31 79 28.1667 84.25 2020-05-10 02:32:30 Nepal
321811 2020-05-08 Nepal       102 0 31 71 28.1667 84.25 2020-05-09 02:32:35 Nepal
161637 2020-05-07 Nepal       101 0 22 79 28.1667 84.25 2020-05-08 02:32:32 Nepal
56880 2020-05-06 Nepal       99 0 22 77 28.1667 84.25 2020-05-07 02:32:28 Nepal
361861 2020-05-05 Nepal       82 0 16 66 28.1667 84.25 2020-05-06 02:32:31 Nepal
168653 2020-05-04 Nepal       75 0 16 59 28.1667 84.25 2020-05-05 02:32:34 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]);
Powered by Datasette · Query took 44.277ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette