daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where recovered = 670 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-22 | China | Fujian | 711 | 1 | 670 | 40 | 26.0789 | 117.9874 | 2021-07-23 04:21:29 | Fujian, China | ||
2021-07-21 | China | Fujian | 711 | 1 | 670 | 40 | 26.0789 | 117.9874 | 2021-07-22 04:21:19 | Fujian, China | ||
2021-02-07 | United Kingdom | Bermuda | 692 | 12 | 670 | 10 | 32.3078 | -64.7505 | 2021-02-08 05:22:39 | Bermuda, United Kingdom | ||
2021-02-06 | United Kingdom | Bermuda | 692 | 12 | 670 | 10 | 32.3078 | -64.7505 | 2021-02-07 05:23:00 | Bermuda, United Kingdom | ||
2020-11-22 | China | Jiangsu | 677 | 0 | 670 | 7 | 32.9711 | 119.455 | 2020-11-23 05:25:26 | Jiangsu, China | ||
2020-11-21 | China | Jiangsu | 677 | 0 | 670 | 7 | 32.9711 | 119.455 | 2020-11-22 05:25:45 | Jiangsu, China | ||
2020-11-20 | Japan | Hiroshima | 733 | 6 | 670 | 57 | 34.605309000000005 | 132.788719 | 2020-11-21 05:25:51 | Hiroshima, Japan | ||
2020-11-20 | China | Jiangsu | 677 | 0 | 670 | 7 | 32.9711 | 119.455 | 2020-11-21 05:25:51 | Jiangsu, China | ||
2020-10-28 | Italy | Basilicata | 1901 | 47 | 670 | 1184 | 40.63947052 | 15.80514834 | 2020-10-29 04:24:49 | Basilicata, Italy | ||
2020-10-11 | Australia | Western Australia | 694 | 9 | 670 | 15 | -31.9505 | 115.8605 | 2020-10-12 04:23:45 | Western Australia, Australia | ||
2020-10-10 | Australia | Western Australia | 694 | 9 | 670 | 15 | -31.9505 | 115.8605 | 2020-10-11 04:23:46 | Western Australia, Australia | ||
2020-10-09 | China | Sichuan | 718 | 3 | 670 | 45 | 30.6171 | 102.7103 | 2020-10-10 04:23:57 | Sichuan, China | ||
2020-10-09 | Australia | Western Australia | 692 | 9 | 670 | 13 | -31.9505 | 115.8605 | 2020-10-10 04:23:57 | Western Australia, Australia | ||
2020-10-08 | Australia | Western Australia | 690 | 9 | 670 | 11 | -31.9505 | 115.8605 | 2020-10-09 04:23:59 | Western Australia, Australia | ||
2020-10-07 | Australia | Western Australia | 690 | 9 | 670 | 11 | -31.9505 | 115.8605 | 2020-10-08 04:23:56 | Western Australia, Australia | ||
2020-10-02 | Ukraine | Sevastopol* | 1058 | 29 | 670 | 359 | 44.6054 | 33.522 | 2020-10-03 04:23:40 | Sevastopol*, Ukraine | ||
2020-08-21 | Ukraine | Kirovohrad Oblast | 751 | 45 | 670 | 36 | 48.5079 | 32.2623 | 2020-08-22 04:27:49 | Kirovohrad Oblast, Ukraine | ||
2020-08-06 | Malta | 946 | 9 | 670 | 267 | 35.9375 | 14.3754 | 2020-08-07 04:35:11 | Malta | |||
2020-07-31 | Liberia | 1181 | 73 | 670 | 438 | 6.4280550000000005 | -9.429499 | 2020-08-01 04:36:27 | Liberia | |||
2020-07-16 | Colombia | Sucre | 2772 | 178 | 670 | 1924 | 8.814 | -74.7233 | 2020-07-17 04:34:50 | Sucre, Colombia | ||
2020-07-01 | India | Goa | 1387 | 4 | 670 | 713 | 15.359682000000001 | 74.057396 | 2020-07-02 04:33:46 | Goa, India | ||
2020-06-24 | China | Shanghai | 703 | 7 | 670 | 26 | 31.201999999999998 | 121.4491 | 2020-06-25 05:26:54 | Shanghai, China | ||
2020-06-13 | Sierra Leone | 1132 | 51 | 670 | 411 | 8.460555000000001 | -11.779889 | 2020-06-14 03:33:15 | Sierra Leone | |||
2020-06-11 | Jordan | 890 | 9 | 670 | 211 | 31.24 | 36.51 | 2020-06-12 05:09:52 | Jordan | |||
2020-06-02 | Russia | Kaliningrad Oblast | 1607 | 24 | 670 | 913 | 54.7293041 | 21.1489473 | 2020-06-03 02:33:13 | Kaliningrad Oblast, Russia | ||
2020-05-23 | Mexico | Jalisco | 1132 | 102 | 670 | 360 | 20.6595 | -103.3494 | 2020-05-24 02:32:43 | Jalisco, Mexico | ||
2020-04-21 | Luxembourg | 3618 | 78 | 670 | 2870 | 49.8153 | 6.1296 | 2020-04-21 23:30:30 | Luxembourg | |||
2020-04-11 | Malaysia | Selangor | 1174 | 10 | 670 | 494 | 3.0738 | 101.5183 | 2020-04-11 22:45:33 | Selangor, Malaysia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;