daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where recovered = 2021 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-23 | Japan | Toyama | 2138 | 38 | 2021 | 79 | 36.637464 | 137.26934599999998 | 2021-07-24 00:21:36 | Toyama, Japan | ||
2021-06-22 | Japan | Kagawa | 2083 | 30 | 2021 | 32 | 34.217292 | 133.969047 | 2021-06-23 04:21:46 | Kagawa, Japan | ||
2021-04-30 | Japan | Miyazaki | 2208 | 22 | 2021 | 165 | 32.193203999999994 | 131.299374 | 2021-05-01 04:20:47 | Miyazaki, Japan | ||
2021-04-29 | Japan | Miyazaki | 2193 | 22 | 2021 | 150 | 32.193203999999994 | 131.299374 | 2021-04-30 04:21:03 | Miyazaki, Japan | ||
2021-02-02 | Malaysia | W.P. Labuan | 2154 | 12 | 2021 | 121 | 5.2831 | 115.2308 | 2021-02-03 05:22:52 | W.P. Labuan, Malaysia | ||
2020-11-19 | Cyprus | 7711 | 41 | 2021 | 5649 | 35.1264 | 33.4299 | 2020-11-20 05:26:28 | Cyprus | |||
2020-11-18 | Cyprus | 7513 | 40 | 2021 | 5452 | 35.1264 | 33.4299 | 2020-11-19 05:25:23 | Cyprus | |||
2020-11-17 | Cyprus | 7285 | 40 | 2021 | 5224 | 35.1264 | 33.4299 | 2020-11-18 05:40:31 | Cyprus | |||
2020-11-16 | Cyprus | 7178 | 40 | 2021 | 5117 | 35.1264 | 33.4299 | 2020-11-17 05:25:54 | Cyprus | |||
2020-11-15 | Cyprus | 7051 | 39 | 2021 | 4991 | 35.1264 | 33.4299 | 2020-11-16 05:25:57 | Cyprus | |||
2020-11-14 | Cyprus | 6853 | 38 | 2021 | 4794 | 35.1264 | 33.4299 | 2020-11-15 05:26:53 | Cyprus | |||
2020-11-13 | Cyprus | 6646 | 34 | 2021 | 4591 | 35.1264 | 33.4299 | 2020-11-14 05:25:37 | Cyprus | |||
2020-11-01 | Syria | 5789 | 292 | 2021 | 3476 | 34.802075 | 38.99681500000001 | 2020-11-02 05:25:04 | Syria | |||
2020-08-26 | Germany | Sachsen-Anhalt | 2199 | 65 | 2021 | 126 | 51.9503 | 11.6923 | 2020-08-27 04:28:15 | Sachsen-Anhalt, Germany | ||
2020-08-07 | Japan | Saitama | 2735 | 79 | 2021 | 635 | 35.997101 | 139.347635 | 2020-08-08 04:34:53 | Saitama, Japan | ||
2020-08-04 | Russia | Udmurt Republic | 2442 | 27 | 2021 | 394 | 57.1961165 | 52.69598320000001 | 2020-08-05 04:34:43 | Udmurt Republic, Russia | ||
2020-06-30 | Chile | Nuble | 2397 | 32 | 2021 | 344 | -36.7226 | -71.7622 | 2020-07-01 04:33:52 | Nuble, Chile | ||
2020-06-22 | Kyrgyzstan | 3356 | 40 | 2021 | 1295 | 41.20438 | 74.766098 | 2020-06-23 04:33:22 | Kyrgyzstan | |||
2020-06-21 | Kyrgyzstan | 3356 | 40 | 2021 | 1295 | 41.20438 | 74.766098 | 2020-06-22 04:33:20 | Kyrgyzstan | |||
2020-05-28 | Italy | Sicilia | 3438 | 272 | 2021 | 1145 | 38.11569725 | 13.362356699999998 | 2020-05-29 02:32:50 | Sicilia, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;