daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
55 rows where recovered = 633 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-08-04 | China | Shaanxi | 661 | 3 | 633 | 25 | 35.1917 | 108.8701 | 2021-08-05 04:21:51 | Shaanxi, China | ||
2021-08-03 | China | Shaanxi | 661 | 3 | 633 | 25 | 35.1917 | 108.8701 | 2021-08-04 04:21:25 | Shaanxi, China | ||
2021-08-02 | China | Shaanxi | 661 | 3 | 633 | 25 | 35.1917 | 108.8701 | 2021-08-03 04:21:39 | Shaanxi, China | ||
2021-04-13 | Japan | Iwate | 763 | 30 | 633 | 100 | 39.593287 | 141.361777 | 2021-04-14 04:20:41 | Iwate, Japan | ||
2021-03-30 | Australia | South Australia | 655 | 4 | 633 | 18 | -34.9285 | 138.6007 | 2021-03-31 04:26:25 | South Australia, Australia | ||
2021-03-29 | Australia | South Australia | 655 | 4 | 633 | 18 | -34.9285 | 138.6007 | 2021-03-30 04:26:23 | South Australia, Australia | ||
2021-01-20 | Japan | Niigata | 787 | 7 | 633 | 147 | 37.521819 | 138.918647 | 2021-01-21 05:22:01 | Niigata, Japan | ||
2021-01-18 | Japan | Yamaguchi | 921 | 5 | 633 | 283 | 34.201190000000004 | 131.573293 | 2021-01-19 05:22:15 | Yamaguchi, Japan | ||
2020-12-13 | Japan | Tochigi | 870 | 3 | 633 | 234 | 36.689912 | 139.819213 | 2020-12-14 05:26:27 | Tochigi, Japan | ||
2020-10-29 | Japan | Gifu | 677 | 11 | 633 | 33 | 35.778671 | 137.055925 | 2020-10-30 04:24:49 | Gifu, Japan | ||
2020-10-28 | Japan | Gifu | 672 | 11 | 633 | 28 | 35.778671 | 137.055925 | 2020-10-29 04:24:49 | Gifu, Japan | ||
2020-10-10 | Japan | Ibaraki | 706 | 17 | 633 | 56 | 36.303588 | 140.319591 | 2020-10-11 04:23:46 | Ibaraki, Japan | ||
2020-08-28 | Guyana | 1180 | 35 | 633 | 512 | 4.860416000000002 | -58.93018000000001 | 2020-08-29 04:28:19 | Guyana | |||
2020-08-21 | Australia | Western Australia | 651 | 9 | 633 | 9 | -31.9505 | 115.8605 | 2020-08-22 04:27:49 | Western Australia, Australia | ||
2020-08-20 | Australia | Western Australia | 651 | 9 | 633 | 9 | -31.9505 | 115.8605 | 2020-08-21 04:27:41 | Western Australia, Australia | ||
2020-08-19 | Australia | Western Australia | 651 | 9 | 633 | 9 | -31.9505 | 115.8605 | 2020-08-20 04:27:43 | Western Australia, Australia | ||
2020-08-18 | Australia | Western Australia | 647 | 9 | 633 | 5 | -31.9505 | 115.8605 | 2020-08-19 04:27:00 | Western Australia, Australia | ||
2020-08-17 | Australia | Western Australia | 647 | 9 | 633 | 5 | -31.9505 | 115.8605 | 2020-08-18 04:27:56 | Western Australia, Australia | ||
2020-08-16 | Australia | Western Australia | 646 | 9 | 633 | 4 | -31.9505 | 115.8605 | 2020-08-17 04:27:20 | Western Australia, Australia | ||
2020-08-15 | Australia | Western Australia | 646 | 9 | 633 | 4 | -31.9505 | 115.8605 | 2020-08-16 04:27:42 | Western Australia, Australia | ||
2020-08-04 | Libya | 4224 | 96 | 633 | 3495 | 26.3351 | 17.228331 | 2020-08-05 04:34:43 | Libya | |||
2020-07-10 | Eswatini | 1257 | 18 | 633 | 606 | -26.5225 | 31.4659 | 2020-07-11 04:34:26 | Eswatini | |||
2020-07-04 | Chile | Los Rios | 720 | 10 | 633 | 77 | -40.231 | -72.3311 | 2020-07-05 04:33:46 | Los Rios, Chile | ||
2020-07-01 | Mexico | Zacatecas | 941 | 99 | 633 | 209 | 22.7709 | -102.5832 | 2020-07-02 04:33:46 | Zacatecas, Mexico | ||
2020-06-22 | Ukraine | Zhytomyr Oblast | 1270 | 23 | 633 | 614 | 50.2547 | 28.6587 | 2020-06-23 04:33:22 | Zhytomyr Oblast, Ukraine | ||
2020-06-21 | Ukraine | Zhytomyr Oblast | 1257 | 21 | 633 | 603 | 50.2547 | 28.6587 | 2020-06-22 04:33:20 | Zhytomyr Oblast, Ukraine | ||
2020-06-20 | Ukraine | Zhytomyr Oblast | 1229 | 21 | 633 | 575 | 50.2547 | 28.6587 | 2020-06-21 04:33:19 | Zhytomyr Oblast, Ukraine | ||
2020-06-17 | Canada | Saskatchewan | 693 | 13 | 633 | 47 | 52.9399 | -106.4509 | 2020-06-18 04:33:18 | Saskatchewan, Canada | ||
2020-06-12 | Paraguay | 1254 | 11 | 633 | 610 | -23.4425 | -58.4438 | 2020-06-13 03:33:14 | Paraguay | |||
2020-06-12 | Colombia | Narino | 2030 | 72 | 633 | 1325 | 1.2892 | -77.3579 | 2020-06-13 03:33:14 | Narino, Colombia | ||
2020-06-09 | Mexico | Baja California Sur | 812 | 47 | 633 | 132 | 26.0444 | -111.6661 | 2020-06-10 04:07:00 | Baja California Sur, Mexico | ||
2020-06-06 | Japan | Fukuoka | 799 | 30 | 633 | 136 | 33.526032 | 130.666949 | 2020-06-07 03:53:30 | Fukuoka, Japan | ||
2020-06-05 | Japan | Fukuoka | 797 | 30 | 633 | 134 | 33.526032 | 130.666949 | 2020-06-06 02:33:00 | Fukuoka, Japan | ||
2020-06-04 | Chad | 828 | 66 | 633 | 129 | 15.4542 | 18.7322 | 2020-06-05 02:33:06 | Chad | |||
2020-06-03 | Russia | Zabaykalsky Krai | 1218 | 22 | 633 | 563 | 52.248521 | 115.956325 | 2020-06-04 02:33:14 | Zabaykalsky Krai, Russia | ||
2020-05-24 | El Salvador | 1915 | 35 | 633 | 1247 | 13.7942 | -88.8965 | 2020-05-25 02:32:44 | El Salvador | |||
2020-05-13 | China | Shanghai | 660 | 7 | 633 | 20 | 31.201999999999998 | 121.4491 | 2020-05-14 03:32:28 | Shanghai, China | ||
2020-04-22 | Armenia | 1473 | 24 | 633 | 816 | 40.0691 | 45.0382 | 2020-04-22 23:30:32 | Armenia | |||
2020-04-11 | Mexico | 3844 | 233 | 633 | 2978 | 23.6345 | -102.5528 | 2020-04-11 22:45:13 | Mexico | |||
2020-04-10 | Mexico | 3441 | 194 | 633 | 2614 | 23.6345 | -102.5528 | 2020-04-10 22:53:48 | Mexico | |||
2020-04-09 | Mexico | 3181 | 174 | 633 | 2374 | 23.6345 | -102.5528 | 2020-04-09 23:02:19 | Mexico | |||
2020-04-09 | China | Jiangsu | 651 | 0 | 633 | 18 | 32.9711 | 119.455 | 2020-04-05 01:33:26 | Jiangsu, China | ||
2020-04-08 | Mexico | 2785 | 141 | 633 | 2011 | 23.6345 | -102.5528 | 2020-04-08 22:51:39 | Mexico | |||
2020-04-08 | Iceland | 1616 | 6 | 633 | 977 | 64.9631 | -19.0208 | 2020-04-08 22:51:39 | Iceland | |||
2020-04-08 | China | Jiangsu | 651 | 0 | 633 | 18 | 32.9711 | 119.455 | 2020-04-05 01:33:26 | Jiangsu, China | ||
2020-04-07 | Mexico | 2439 | 125 | 633 | 1681 | 23.6345 | -102.5528 | 2020-04-07 23:04:29 | Mexico | |||
2020-04-07 | China | Jiangsu | 651 | 0 | 633 | 18 | 32.9711 | 119.455 | 2020-04-05 01:33:26 | Jiangsu, China | ||
2020-04-06 | Mexico | 2143 | 94 | 633 | 1416 | 23.6345 | -102.5528 | 4/6/20 23:21 | Mexico | |||
2020-04-06 | China | Jiangsu | 651 | 0 | 633 | 18 | 32.9711 | 119.455 | 4/5/20 1:33 | Jiangsu, China | ||
2020-04-05 | Mexico | 1890 | 79 | 633 | 1178 | 23.6345 | -102.5528 | 2020-04-05 23:06:26 | Mexico | |||
2020-04-05 | China | Jiangsu | 651 | 0 | 633 | 18 | 32.9711 | 119.455 | 2020-04-05 01:33:26 | Jiangsu, China | ||
2020-04-04 | Mexico | 1688 | 60 | 633 | 995 | 23.6345 | -102.5528 | 4/4/20 23:34 | Mexico | |||
2020-04-03 | Mexico | 1510 | 50 | 633 | 827 | 23.6345 | -102.5528 | 2020-04-03 22:46:20 | Mexico | |||
2020-02-20 | Mainland China | Zhejiang | 1175 | 1 | 633 | 29.1832 | 120.0934 | 2020-02-20T11:13:27 | ||||
2020-02-05 | Mainland China | Hubei | 19665 | 549 | 633 | 30.9756 | 112.2707 | 2020-02-05T23:13:12 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;