daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where recovered = 471 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- Japan 5
- China 4
- Ukraine 4
- Taiwan* 3
- Australia 2
- Denmark 2
- Italy 2
- Jordan 1
- Mexico 1
- New Zealand 1
- Saint Kitts and Nevis 1
- United Kingdom 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-16 | Saint Kitts and Nevis | 548 | 3 | 471 | 74 | 17.357822 | -62.782998 | 2021-07-17 04:22:22 | Saint Kitts and Nevis | |||
2021-02-13 | Japan | Iwate | 520 | 29 | 471 | 20 | 39.593287 | 141.361777 | 2021-02-14 05:23:43 | Iwate, Japan | ||
2020-12-15 | China | Fujian | 503 | 1 | 471 | 31 | 26.0789 | 117.9874 | 2020-12-16 05:28:04 | Fujian, China | ||
2020-12-03 | China | Shaanxi | 501 | 3 | 471 | 27 | 35.1917 | 108.8701 | 2020-12-04 05:27:27 | Shaanxi, China | ||
2020-11-07 | Japan | Tochigi | 498 | 1 | 471 | 26 | 36.689912 | 139.819213 | 2020-11-08 05:24:56 | Tochigi, Japan | ||
2020-10-20 | United Kingdom | Gibraltar | 608 | 0 | 471 | 137 | 36.1408 | -5.3536 | 2020-10-21 04:24:14 | Gibraltar, United Kingdom | ||
2020-10-16 | Denmark | Faroe Islands | 482 | 0 | 471 | 11 | 61.8926 | -6.9118 | 2020-10-17 04:24:12 | Faroe Islands, Denmark | ||
2020-10-16 | Australia | South Australia | 479 | 4 | 471 | 4 | -34.9285 | 138.6007 | 2020-10-17 04:24:12 | South Australia, Australia | ||
2020-10-15 | Denmark | Faroe Islands | 480 | 0 | 471 | 9 | 61.8926 | -6.9118 | 2020-10-16 04:24:01 | Faroe Islands, Denmark | ||
2020-10-15 | Australia | South Australia | 479 | 4 | 471 | 4 | -34.9285 | 138.6007 | 2020-10-16 04:24:01 | South Australia, Australia | ||
2020-09-29 | Italy | Basilicata | 776 | 29 | 471 | 276 | 40.63947052 | 15.80514834 | 2020-09-30 04:23:33 | Basilicata, Italy | ||
2020-09-24 | Italy | Molise | 627 | 23 | 471 | 133 | 41.55774754 | 14.65916051 | 2020-09-25 04:23:00 | Molise, Italy | ||
2020-09-15 | Ukraine | Sevastopol* | 675 | 20 | 471 | 184 | 44.6054 | 33.522 | 2020-09-16 04:22:53 | Sevastopol*, Ukraine | ||
2020-09-04 | Taiwan* | 490 | 7 | 471 | 12 | 23.7 | 121.0 | 2020-09-05 04:28:19 | Taiwan* | |||
2020-09-03 | Taiwan* | 489 | 7 | 471 | 11 | 23.7 | 121.0 | 2020-09-04 04:28:26 | Taiwan* | |||
2020-09-02 | Taiwan* | 489 | 7 | 471 | 11 | 23.7 | 121.0 | 2020-09-03 04:28:22 | Taiwan* | |||
2020-08-06 | Ukraine | Mykolaiv Oblast | 666 | 14 | 471 | 181 | 46.975 | 31.9946 | 2020-08-07 04:35:11 | Mykolaiv Oblast, Ukraine | ||
2020-07-06 | Mexico | Colima | 715 | 89 | 471 | 155 | 19.1223 | -104.0072 | 2020-07-07 04:34:00 | Colima, Mexico | ||
2020-06-25 | Japan | Aichi | 526 | 34 | 471 | 21 | 35.035551 | 137.211621 | 2020-06-26 04:33:43 | Aichi, Japan | ||
2020-06-24 | Japan | Aichi | 526 | 34 | 471 | 21 | 35.035551 | 137.211621 | 2020-06-25 05:26:54 | Aichi, Japan | ||
2020-06-23 | Japan | Aichi | 526 | 34 | 471 | 21 | 35.035551 | 137.211621 | 2020-06-24 04:33:28 | Aichi, Japan | ||
2020-06-13 | Ukraine | Kirovohrad Oblast | 577 | 30 | 471 | 76 | 48.5079 | 32.2623 | 2020-06-14 03:33:15 | Kirovohrad Oblast, Ukraine | ||
2020-06-04 | Ukraine | Kharkiv Oblast | 1166 | 49 | 471 | 646 | 49.9935 | 36.2304 | 2020-06-05 02:33:06 | Kharkiv Oblast, Ukraine | ||
2020-05-24 | Jordan | 708 | 9 | 471 | 228 | 31.24 | 36.51 | 2020-05-25 02:32:44 | Jordan | |||
2020-04-17 | China | Heilongjiang | 872 | 13 | 471 | 388 | 47.861999999999995 | 127.7615 | 2020-04-17 00:20:24 | Heilongjiang, China | ||
2020-04-16 | China | Heilongjiang | 861 | 13 | 471 | 377 | 47.862 | 127.7615 | 2020-04-16 02:06:52 | Heilongjiang, China | ||
2020-04-12 | New Zealand | 1330 | 12 | 471 | 855 | -40.9006 | 174.886 | 2020-04-12 23:17:00 | New Zealand |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;