daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,430 rows where active = 2 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-05 04:21:51 | Anguilla, United Kingdom | ||
2021-08-04 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-05 04:21:51 | Kiribati | |||
2021-08-04 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-05 04:21:51 | Grenada | |||
2021-08-04 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-05 04:21:51 | Saint Pierre and Miquelon, France | ||
2021-08-04 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-05 04:21:51 | Guangxi, China | ||
2021-08-03 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-04 04:21:25 | Anguilla, United Kingdom | ||
2021-08-03 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-04 04:21:25 | Kiribati | |||
2021-08-03 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-04 04:21:25 | Grenada | |||
2021-08-03 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-04 04:21:25 | Saint Pierre and Miquelon, France | ||
2021-08-03 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-04 04:21:25 | Guangxi, China | ||
2021-08-02 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-03 04:21:39 | Anguilla, United Kingdom | ||
2021-08-02 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-03 04:21:39 | Kiribati | |||
2021-08-02 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-03 04:21:39 | Grenada | |||
2021-08-02 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-03 04:21:39 | Saint Pierre and Miquelon, France | ||
2021-08-02 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-03 04:21:39 | Guangxi, China | ||
2021-08-01 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-02 04:21:36 | Anguilla, United Kingdom | ||
2021-08-01 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-02 04:21:36 | Kiribati | |||
2021-08-01 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-02 04:21:36 | Grenada | |||
2021-08-01 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-02 04:21:36 | Saint Pierre and Miquelon, France | ||
2021-08-01 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-02 04:21:36 | Guangxi, China | ||
2021-07-31 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-01 04:21:50 | Anguilla, United Kingdom | ||
2021-07-31 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-01 04:21:50 | Kiribati | |||
2021-07-31 | Japan | Gifu | 9589 | 188 | 9399 | 2 | 35.778671 | 137.055925 | 2021-08-01 04:21:50 | Gifu, Japan | ||
2021-07-31 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-01 04:21:50 | Grenada | |||
2021-07-31 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-01 04:21:50 | Saint Pierre and Miquelon, France | ||
2021-07-31 | China | Hainan | 189 | 6 | 181 | 2 | 19.1959 | 109.7453 | 2021-08-01 04:21:50 | Hainan, China | ||
2021-07-31 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-01 04:21:50 | Guangxi, China | ||
2021-07-30 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-31 04:21:35 | Anguilla, United Kingdom | ||
2021-07-30 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-31 04:21:35 | Kiribati | |||
2021-07-30 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-31 04:21:35 | Grenada | |||
2021-07-30 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-31 04:21:35 | Saint Pierre and Miquelon, France | ||
2021-07-30 | China | Shandong | 885 | 7 | 876 | 2 | 36.3427 | 118.1498 | 2021-07-31 04:21:35 | Shandong, China | ||
2021-07-30 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-31 04:21:35 | Guangxi, China | ||
2021-07-29 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-30 04:21:34 | Anguilla, United Kingdom | ||
2021-07-29 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-30 04:21:34 | Kiribati | |||
2021-07-29 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-30 04:21:34 | Grenada | |||
2021-07-29 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-30 04:21:34 | Saint Pierre and Miquelon, France | ||
2021-07-29 | China | Shandong | 885 | 7 | 876 | 2 | 36.3427 | 118.1498 | 2021-07-30 04:21:34 | Shandong, China | ||
2021-07-29 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-30 04:21:34 | Guangxi, China | ||
2021-07-28 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-29 04:21:33 | Anguilla, United Kingdom | ||
2021-07-28 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-29 04:21:33 | Kiribati | |||
2021-07-28 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-29 04:21:33 | Grenada | |||
2021-07-28 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-29 04:21:33 | Saint Pierre and Miquelon, France | ||
2021-07-28 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-29 04:21:33 | Guangxi, China | ||
2021-07-28 | China | Chongqing | 601 | 6 | 593 | 2 | 30.0572 | 107.874 | 2021-07-29 04:21:33 | Chongqing, China | ||
2021-07-27 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-28 04:21:39 | Anguilla, United Kingdom | ||
2021-07-27 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-28 04:21:39 | Kiribati | |||
2021-07-27 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-28 04:21:39 | Grenada | |||
2021-07-27 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-28 04:21:39 | Saint Pierre and Miquelon, France | ||
2021-07-27 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-28 04:21:39 | Guangxi, China | ||
2021-07-27 | China | Chongqing | 601 | 6 | 593 | 2 | 30.0572 | 107.874 | 2021-07-28 04:21:39 | Chongqing, China | ||
2021-07-27 | Australia | Northern Territory | 192 | 0 | 190 | 2 | -12.4634 | 130.8456 | 2021-07-28 04:21:39 | Northern Territory, Australia | ||
2021-07-26 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-27 04:21:18 | Anguilla, United Kingdom | ||
2021-07-26 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-27 04:21:18 | Kiribati | |||
2021-07-26 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-27 04:21:18 | Grenada | |||
2021-07-26 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-27 04:21:18 | Saint Pierre and Miquelon, France | ||
2021-07-26 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-27 04:21:18 | Guangxi, China | ||
2021-07-25 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-26 04:21:28 | Anguilla, United Kingdom | ||
2021-07-25 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-26 04:21:28 | Kiribati | |||
2021-07-25 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-26 04:21:28 | Grenada | |||
2021-07-25 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-26 04:21:28 | Saint Pierre and Miquelon, France | ||
2021-07-25 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-26 04:21:28 | Guangxi, China | ||
2021-07-24 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-25 04:22:12 | Anguilla, United Kingdom | ||
2021-07-24 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-25 04:22:12 | Kiribati | |||
2021-07-24 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-25 04:22:12 | Grenada | |||
2021-07-24 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-25 04:22:12 | Saint Pierre and Miquelon, France | ||
2021-07-24 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-25 04:22:12 | Guangxi, China | ||
2021-07-24 | China | Anhui | 1008 | 6 | 1000 | 2 | 31.8257 | 117.2264 | 2021-07-25 04:22:12 | Anhui, China | ||
2021-07-23 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-24 00:21:36 | Anguilla, United Kingdom | ||
2021-07-23 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-24 00:21:36 | Kiribati | |||
2021-07-23 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-24 00:21:36 | Grenada | |||
2021-07-23 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-24 00:21:36 | Guangxi, China | ||
2021-07-23 | China | Gansu | 197 | 2 | 193 | 2 | 35.7518 | 104.2861 | 2021-07-24 00:21:36 | Gansu, China | ||
2021-07-23 | China | Anhui | 1008 | 6 | 1000 | 2 | 31.8257 | 117.2264 | 2021-07-24 00:21:36 | Anhui, China | ||
2021-07-22 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-23 04:21:29 | Anguilla, United Kingdom | ||
2021-07-22 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-23 04:21:29 | Kiribati | |||
2021-07-22 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-23 04:21:29 | Grenada | |||
2021-07-22 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-23 04:21:29 | Guangxi, China | ||
2021-07-22 | China | Gansu | 197 | 2 | 193 | 2 | 35.7518 | 104.2861 | 2021-07-23 04:21:29 | Gansu, China | ||
2021-07-22 | China | Anhui | 1008 | 6 | 1000 | 2 | 31.8257 | 117.2264 | 2021-07-23 04:21:29 | Anhui, China | ||
2021-07-21 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-22 04:21:19 | Anguilla, United Kingdom | ||
2021-07-21 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-22 04:21:19 | Kiribati | |||
2021-07-21 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-22 04:21:19 | Grenada | |||
2021-07-21 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-22 04:21:19 | Guangxi, China | ||
2021-07-21 | China | Gansu | 197 | 2 | 193 | 2 | 35.7518 | 104.2861 | 2021-07-22 04:21:19 | Gansu, China | ||
2021-07-21 | China | Anhui | 1008 | 6 | 1000 | 2 | 31.8257 | 117.2264 | 2021-07-22 04:21:19 | Anhui, China | ||
2021-07-20 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-21 04:21:40 | Anguilla, United Kingdom | ||
2021-07-20 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-21 04:21:40 | Kiribati | |||
2021-07-20 | China | Macau | 55 | 0 | 53 | 2 | 22.1667 | 113.55 | 2021-07-21 04:21:40 | Macau, China | ||
2021-07-20 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-21 04:21:40 | Guangxi, China | ||
2021-07-19 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-20 04:21:48 | Anguilla, United Kingdom | ||
2021-07-19 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-20 04:21:48 | Kiribati | |||
2021-07-19 | China | Macau | 55 | 0 | 53 | 2 | 22.1667 | 113.55 | 2021-07-20 04:21:48 | Macau, China | ||
2021-07-19 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-20 04:21:48 | Guangxi, China | ||
2021-07-18 | San Marino | 5094 | 90 | 5002 | 2 | 43.9424 | 12.4578 | 2021-07-19 04:21:24 | San Marino | |||
2021-07-18 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-19 04:21:24 | Kiribati | |||
2021-07-18 | China | Macau | 55 | 0 | 53 | 2 | 22.1667 | 113.55 | 2021-07-19 04:21:24 | Macau, China | ||
2021-07-18 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-19 04:21:24 | Guangxi, China | ||
2021-07-18 | Antigua and Barbuda | 1268 | 42 | 1224 | 2 | 17.0608 | -61.7964 | 2021-07-19 04:21:24 | Antigua and Barbuda | |||
2021-07-17 | San Marino | 5094 | 90 | 5002 | 2 | 43.9424 | 12.4578 | 2021-07-18 04:22:07 | San Marino |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;