daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
142 rows where recovered = 47 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-04-11 | Laos | 51 | 0 | 47 | 4 | 19.85627 | 102.495496 | 2021-04-12 04:21:00 | Laos | |||
2021-04-10 | Laos | 49 | 0 | 47 | 2 | 19.85627 | 102.495496 | 2021-04-11 04:20:56 | Laos | |||
2021-04-09 | Laos | 49 | 0 | 47 | 2 | 19.85627 | 102.495496 | 2021-04-10 04:20:59 | Laos | |||
2021-04-08 | Laos | 49 | 0 | 47 | 2 | 19.85627 | 102.495496 | 2021-04-09 04:21:13 | Laos | |||
2021-04-07 | Laos | 49 | 0 | 47 | 2 | 19.85627 | 102.495496 | 2021-04-08 04:21:13 | Laos | |||
2021-04-06 | Laos | 49 | 0 | 47 | 2 | 19.85627 | 102.495496 | 2021-04-07 04:20:53 | Laos | |||
2021-04-05 | Canada | Northwest Territories | 43 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-04-06 04:20:32 | Northwest Territories,Canada | ||
2021-04-04 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-04-05 04:20:35 | Northwest Territories,Canada | ||
2021-04-03 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-04-04 04:20:49 | Northwest Territories,Canada | ||
2021-04-02 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-04-03 04:20:44 | Northwest Territories,Canada | ||
2021-04-01 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-04-02 04:20:36 | Northwest Territories,Canada | ||
2021-03-31 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-04-01 04:27:05 | Northwest Territories,Canada | ||
2021-03-30 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-03-31 04:26:25 | Northwest Territories,Canada | ||
2021-03-29 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-03-30 04:26:23 | Northwest Territories,Canada | ||
2021-03-28 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-03-29 04:28:35 | Northwest Territories,Canada | ||
2021-03-27 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-03-28 05:28:10 | Northwest Territories,Canada | ||
2021-03-26 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-03-27 05:25:04 | Northwest Territories,Canada | ||
2021-03-25 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-03-26 05:26:55 | Northwest Territories,Canada | ||
2021-03-24 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-03-25 05:27:00 | Northwest Territories,Canada | ||
2021-03-23 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-24 05:25:40 | Macau, China | ||
2021-03-22 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-23 05:26:18 | Macau, China | ||
2021-03-21 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-22 05:25:43 | Macau, China | ||
2021-03-20 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-21 05:25:44 | Macau, China | ||
2021-03-19 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-20 05:25:46 | Macau, China | ||
2021-03-19 | Chile | Unknown | 47 | 1 | 47 | 0 | 2021-03-20 05:25:46 | Unknown, Chile | ||||
2021-03-18 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-19 05:26:09 | Macau, China | ||
2021-03-17 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-18 05:26:22 | Macau, China | ||
2021-03-16 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-17 05:25:07 | Macau, China | ||
2021-03-15 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-16 05:25:13 | Macau, China | ||
2021-03-14 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-15 05:25:51 | Macau, China | ||
2021-03-13 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-14 05:25:37 | Macau, China | ||
2021-03-12 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-13 05:25:15 | Macau, China | ||
2021-03-11 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-12 05:26:50 | Macau, China | ||
2021-03-10 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-11 05:25:48 | Macau, China | ||
2021-03-09 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-10 05:24:35 | Macau, China | ||
2021-03-08 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-09 05:28:19 | Macau, China | ||
2021-03-07 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-08 05:24:48 | Macau, China | ||
2021-03-06 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-07 05:21:54 | Macau, China | ||
2021-03-05 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-06 04:23:41 | Macau, China | ||
2021-03-04 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-05 05:26:29 | Macau, China | ||
2021-03-03 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-04 05:24:24 | Macau, China | ||
2021-03-02 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-03 05:23:28 | Macau, China | ||
2021-03-01 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-02 05:23:30 | Macau, China | ||
2021-02-28 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-03-01 05:23:01 | Macau, China | ||
2021-02-27 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-02-28 05:22:20 | Macau, China | ||
2021-02-26 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-02-27 05:22:28 | Macau, China | ||
2021-02-25 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-02-26 05:22:40 | Macau, China | ||
2021-02-24 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-02-25 05:24:57 | Macau, China | ||
2021-02-23 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-02-24 05:29:16 | Macau, China | ||
2021-02-22 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-02-23 05:23:41 | Macau, China | ||
2021-02-21 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-02-22 05:24:21 | Macau, China | ||
2021-02-20 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-02-21 05:24:33 | Macau, China | ||
2021-02-19 | China | Macau | 48 | 0 | 47 | 1 | 22.1667 | 113.55 | 2021-02-20 05:22:51 | Macau, China | ||
2021-02-07 | France | New Caledonia | 49 | 0 | 47 | 2 | -20.904305 | 165.618042 | 2021-02-08 05:22:39 | New Caledonia, France | ||
2021-02-06 | France | New Caledonia | 49 | 0 | 47 | 2 | -20.904305 | 165.618042 | 2021-02-07 05:23:00 | New Caledonia, France | ||
2021-02-05 | France | New Caledonia | 47 | 0 | 47 | 0 | -20.904305 | 165.618042 | 2021-02-06 05:23:55 | New Caledonia, France | ||
2021-02-04 | France | New Caledonia | 47 | 0 | 47 | 0 | -20.904305 | 165.618042 | 2021-02-05 05:22:38 | New Caledonia, France | ||
2021-02-03 | France | New Caledonia | 47 | 0 | 47 | 0 | -20.904305 | 165.618042 | 2021-02-04 05:22:26 | New Caledonia, France | ||
2021-02-02 | France | New Caledonia | 47 | 0 | 47 | 0 | -20.904305 | 165.618042 | 2021-02-03 05:22:52 | New Caledonia, France | ||
2021-02-01 | France | New Caledonia | 47 | 0 | 47 | 0 | -20.904305 | 165.618042 | 2021-02-02 05:22:49 | New Caledonia, France | ||
2021-01-31 | France | New Caledonia | 47 | 0 | 47 | 0 | -20.904305 | 165.618042 | 2021-02-01 05:22:53 | New Caledonia, France | ||
2021-01-30 | France | New Caledonia | 47 | 0 | 47 | 0 | -20.904305 | 165.618042 | 2021-01-31 05:22:42 | New Caledonia, France | ||
2021-01-16 | Fiji | 55 | 2 | 47 | 6 | -17.7134 | 178.065 | 2021-01-17 05:22:17 | Fiji | |||
2021-01-15 | Fiji | 53 | 2 | 47 | 4 | -17.7134 | 178.065 | 2021-01-16 05:22:40 | Fiji | |||
2021-01-14 | Fiji | 53 | 2 | 47 | 4 | -17.7134 | 178.065 | 2021-01-15 05:22:24 | Fiji | |||
2021-01-13 | Fiji | 53 | 2 | 47 | 4 | -17.7134 | 178.065 | 2021-01-14 05:22:32 | Fiji | |||
2021-01-12 | Fiji | 53 | 2 | 47 | 4 | -17.7134 | 178.065 | 2021-01-13 05:22:15 | Fiji | |||
2021-01-11 | Fiji | 53 | 2 | 47 | 4 | -17.7134 | 178.065 | 2021-01-12 05:22:15 | Fiji | |||
2021-01-10 | Fiji | 53 | 2 | 47 | 4 | -17.7134 | 178.065 | 2021-01-11 05:21:50 | Fiji | |||
2020-12-10 | Canada | Yukon | 58 | 1 | 47 | 10 | 64.2823 | -135.0 | 2020-12-11 05:26:59 | Yukon, Canada | ||
2020-12-09 | Canada | Yukon | 58 | 1 | 47 | 10 | 64.2823 | -135.0 | 2020-12-10 05:26:19 | Yukon, Canada | ||
2020-12-08 | Canada | Yukon | 58 | 1 | 47 | 10 | 64.2823 | -135.0 | 2020-12-09 05:28:01 | Yukon, Canada | ||
2020-12-07 | Canada | Yukon | 57 | 1 | 47 | 9 | 64.2823 | -135.0 | 2020-12-08 05:27:42 | Yukon, Canada | ||
2020-11-18 | Chile | Unknown | 47 | 1 | 47 | 0 | 2020-11-19 05:25:23 | Unknown, Chile | ||||
2020-11-13 | Chile | Unknown | 47 | 1 | 47 | 0 | 2020-11-14 05:25:37 | Unknown, Chile | ||||
2020-09-14 | Canada | Prince Edward Island | 55 | 0 | 47 | 8 | 46.5107 | -63.4168 | 2020-09-15 03:22:50 | Prince Edward Island, Canada | ||
2020-09-13 | Canada | Prince Edward Island | 55 | 0 | 47 | 8 | 46.5107 | -63.4168 | 2020-09-14 04:26:00 | Prince Edward Island, Canada | ||
2020-09-12 | Canada | Prince Edward Island | 55 | 0 | 47 | 8 | 46.5107 | -63.4168 | 2020-09-13 04:30:52 | Prince Edward Island, Canada | ||
2020-09-11 | Canada | Prince Edward Island | 55 | 0 | 47 | 8 | 46.5107 | -63.4168 | 2020-09-12 04:25:05 | Prince Edward Island, Canada | ||
2020-09-09 | Japan | Akita | 50 | 0 | 47 | 3 | 39.748679 | 140.408228 | 2020-09-10 04:29:01 | Akita, Japan | ||
2020-09-08 | Japan | Akita | 50 | 0 | 47 | 3 | 39.748679 | 140.408228 | 2020-09-09 04:28:48 | Akita, Japan | ||
2020-09-07 | Japan | Akita | 50 | 0 | 47 | 3 | 39.748679 | 140.408228 | 2020-09-08 04:28:25 | Akita, Japan | ||
2020-09-06 | Japan | Akita | 50 | 0 | 47 | 3 | 39.748679 | 140.408228 | 2020-09-07 04:28:30 | Akita, Japan | ||
2020-09-05 | Japan | Akita | 50 | 0 | 47 | 3 | 39.748679 | 140.408228 | 2020-09-06 04:28:33 | Akita, Japan | ||
2020-08-30 | Japan | Tokushima | 128 | 4 | 47 | 77 | 33.919178 | 134.242091 | 2020-08-31 04:28:27 | Tokushima, Japan | ||
2020-08-29 | Japan | Tokushima | 128 | 4 | 47 | 77 | 33.919178 | 134.242091 | 2020-08-30 04:28:22 | Tokushima, Japan | ||
2020-08-13 | Japan | Kagawa | 61 | 1 | 47 | 13 | 34.217292 | 133.969047 | 2020-08-14 04:51:19 | Kagawa, Japan | ||
2020-08-12 | Japan | Kagawa | 60 | 0 | 47 | 13 | 34.217292 | 133.969047 | 2020-08-13 04:29:15 | Kagawa, Japan | ||
2020-07-29 | Japan | Kumamoto | 157 | 3 | 47 | 107 | 32.608154 | 130.74523100000002 | 2020-07-30 04:35:05 | Kumamoto, Japan | ||
2020-07-28 | Japan | Saga | 69 | 0 | 47 | 22 | 33.286977 | 130.115738 | 2020-07-29 04:35:11 | Saga, Japan | ||
2020-07-28 | Japan | Kumamoto | 136 | 3 | 47 | 86 | 32.608154 | 130.74523100000002 | 2020-07-29 04:35:11 | Kumamoto, Japan | ||
2020-07-27 | Japan | Saga | 67 | 0 | 47 | 20 | 33.286977 | 130.115738 | 2020-07-28 04:58:43 | Saga, Japan | ||
2020-07-27 | Japan | Kumamoto | 114 | 3 | 47 | 64 | 32.608154 | 130.74523100000002 | 2020-07-28 04:58:43 | Kumamoto, Japan | ||
2020-07-27 | Colombia | Guaviare | 80 | 0 | 47 | 33 | 1.0654 | -73.2603 | 2020-07-28 04:58:43 | Guaviare, Colombia | ||
2020-07-26 | Japan | Saga | 67 | 0 | 47 | 20 | 33.286977 | 130.115738 | 2020-07-27 04:35:02 | Saga, Japan | ||
2020-07-25 | Japan | Saga | 66 | 0 | 47 | 19 | 33.286977 | 130.115738 | 2020-07-26 04:35:00 | Saga, Japan | ||
2020-07-24 | Japan | Saga | 63 | 0 | 47 | 16 | 33.286977 | 130.115738 | 2020-07-25 04:47:39 | Saga, Japan | ||
2020-07-23 | Japan | Saga | 57 | 0 | 47 | 10 | 33.286977 | 130.115738 | 2020-07-24 05:30:40 | Saga, Japan | ||
2020-07-23 | Japan | Mie | 61 | 1 | 47 | 13 | 34.508018 | 136.376013 | 2020-07-24 05:30:40 | Mie, Japan | ||
2020-07-22 | Japan | Saga | 55 | 0 | 47 | 8 | 33.286977 | 130.115738 | 2020-07-23 05:15:04 | Saga, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;