daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where recovered = 833 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-28 | Russia | Chukotka Autonomous Okrug | 1112 | 9 | 833 | 270 | 66.0006475 | 169.4900869 | 2021-07-29 04:21:33 | Chukotka Autonomous Okrug, Russia | ||
2021-04-21 | India | Lakshadweep | 1335 | 1 | 833 | 501 | 13.6999972 | 72.18333259999999 | 2021-04-22 04:20:53 | Lakshadweep, India | ||
2021-02-11 | Japan | Kochi | 868 | 17 | 833 | 18 | 33.422519 | 133.367307 | 2021-02-12 05:23:29 | Kochi, Japan | ||
2021-01-09 | China | Sichuan | 857 | 3 | 833 | 21 | 30.6171 | 102.7103 | 2021-01-10 05:22:12 | Sichuan, China | ||
2020-12-28 | Australia | Western Australia | 858 | 9 | 833 | 16 | -31.9505 | 115.8605 | 2020-12-29 05:22:37 | Western Australia, Australia | ||
2020-12-27 | Australia | Western Australia | 858 | 9 | 833 | 16 | -31.9505 | 115.8605 | 2020-12-28 05:22:06 | Western Australia, Australia | ||
2020-12-20 | Japan | Ishikawa | 960 | 50 | 833 | 77 | 36.769464 | 136.771027 | 2020-12-21 05:27:58 | Ishikawa, Japan | ||
2020-11-26 | Japan | Nara | 1038 | 11 | 833 | 194 | 34.317451 | 135.871644 | 2020-11-27 05:26:53 | Nara, Japan | ||
2020-10-29 | China | Shandong | 847 | 7 | 833 | 7 | 36.3427 | 118.1498 | 2020-10-30 04:24:49 | Shandong, China | ||
2020-09-08 | Colombia | Arauca | 1093 | 22 | 833 | 238 | 7.0762 | -70.7105 | 2020-09-09 04:28:48 | Arauca, Colombia | ||
2020-08-25 | Sao Tome and Principe | 892 | 15 | 833 | 44 | 0.1864 | 6.6131 | 2020-08-26 04:28:11 | Sao Tome and Principe | |||
2020-08-10 | Germany | Mecklenburg-Vorpommern | 938 | 20 | 833 | 91 | 53.6127 | 12.4296 | 2020-08-11 04:35:08 | Mecklenburg-Vorpommern, Germany | ||
2020-07-27 | Yemen | 1691 | 483 | 833 | 375 | 15.552727 | 48.516388 | 2020-07-28 04:58:43 | Yemen | |||
2020-07-16 | Japan | Fukuoka | 953 | 33 | 833 | 87 | 33.526032 | 130.666949 | 2020-07-17 04:34:50 | Fukuoka, Japan | ||
2020-07-08 | India | Himachal Pradesh | 1101 | 11 | 833 | 257 | 31.927213000000002 | 77.233081 | 2020-07-09 04:34:23 | Himachal Pradesh, India | ||
2020-07-02 | Cyprus | 999 | 19 | 833 | 147 | 35.1264 | 33.4299 | 2020-07-03 04:33:54 | Cyprus | |||
2020-07-01 | Cyprus | 998 | 19 | 833 | 146 | 35.1264 | 33.4299 | 2020-07-02 04:33:46 | Cyprus | |||
2020-06-30 | Cyprus | 996 | 19 | 833 | 144 | 35.1264 | 33.4299 | 2020-07-01 04:33:52 | Cyprus | |||
2020-06-29 | Cyprus | 994 | 19 | 833 | 142 | 35.1264 | 33.4299 | 2020-06-30 04:33:48 | Cyprus | |||
2020-06-28 | Cyprus | 994 | 19 | 833 | 142 | 35.1264 | 33.4299 | 2020-06-29 04:33:44 | Cyprus | |||
2020-06-19 | Ukraine | Zakarpattia Oblast | 1960 | 53 | 833 | 1074 | 48.6208 | 22.2879 | 2020-06-20 04:33:19 | Zakarpattia Oblast, Ukraine | ||
2020-06-09 | Mexico | Queretaro | 1257 | 168 | 833 | 256 | 20.5888 | -100.3899 | 2020-06-10 04:07:00 | Queretaro, Mexico | ||
2020-06-08 | Gabon | 3101 | 21 | 833 | 2247 | -0.8037 | 11.6094 | 2020-06-09 03:33:03 | Gabon | |||
2020-06-07 | Gabon | 3101 | 21 | 833 | 2247 | -0.8037 | 11.6094 | 2020-06-08 03:33:22 | Gabon | |||
2020-06-06 | Gabon | 3101 | 21 | 833 | 2247 | -0.8037 | 11.6094 | 2020-06-07 03:53:30 | Gabon | |||
2020-06-05 | Gabon | 3101 | 21 | 833 | 2247 | -0.8037 | 11.6094 | 2020-06-06 02:33:00 | Gabon | |||
2020-06-02 | Russia | Altai Krai | 1985 | 12 | 833 | 1140 | 52.6932243 | 82.69314240000001 | 2020-06-03 02:33:13 | Altai Krai, Russia | ||
2020-04-26 | Armenia | 1746 | 28 | 833 | 885 | 40.0691 | 45.0382 | 2020-04-27 02:30:33 | Armenia | |||
2020-04-16 | Malaysia | Selangor | 1323 | 13 | 833 | 477 | 3.0738 | 101.5183 | 2020-04-16 23:30:51 | Selangor, Malaysia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;