daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where recovered = 80 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 21
- Japan 28
- Saint Vincent and the Grenadines 10
- Mainland China 7
- Canada 4
- Malaysia 4
- Botswana 3
- Lebanon 3
- Luxembourg 3
- Guyana 2
- India 2
- United Kingdom 2
- Bolivia 1
- Chile 1
- Colombia 1
- Congo (Kinshasa) 1
- Dominican Republic 1
- Egypt 1
- Kuwait 1
- Mexico 1
- Russia 1
- Sudan 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-05-13 | Canada | Yukon | 84 | 2 | 80 | 2 | 64.2823 | -135.0 | 2021-05-14 04:20:41 | Yukon, Canada | ||
2021-05-12 | Canada | Yukon | 84 | 2 | 80 | 2 | 64.2823 | -135.0 | 2021-05-13 04:20:51 | Yukon, Canada | ||
2021-05-11 | Canada | Yukon | 84 | 2 | 80 | 2 | 64.2823 | -135.0 | 2021-05-12 04:21:29 | Yukon, Canada | ||
2021-05-10 | Canada | Yukon | 82 | 2 | 80 | 0 | 64.2823 | -135.0 | 2021-05-11 04:20:41 | Yukon, Canada | ||
2020-12-10 | Saint Vincent and the Grenadines | 91 | 0 | 80 | 11 | 12.9843 | -61.2872 | 2020-12-11 05:26:59 | Saint Vincent and the Grenadines | |||
2020-12-09 | Saint Vincent and the Grenadines | 90 | 0 | 80 | 10 | 12.9843 | -61.2872 | 2020-12-10 05:26:19 | Saint Vincent and the Grenadines | |||
2020-12-08 | Saint Vincent and the Grenadines | 87 | 0 | 80 | 7 | 12.9843 | -61.2872 | 2020-12-09 05:28:01 | Saint Vincent and the Grenadines | |||
2020-12-07 | Saint Vincent and the Grenadines | 87 | 0 | 80 | 7 | 12.9843 | -61.2872 | 2020-12-08 05:27:42 | Saint Vincent and the Grenadines | |||
2020-12-06 | Saint Vincent and the Grenadines | 87 | 0 | 80 | 7 | 12.9843 | -61.2872 | 2020-12-07 05:26:14 | Saint Vincent and the Grenadines | |||
2020-12-05 | Saint Vincent and the Grenadines | 87 | 0 | 80 | 7 | 12.9843 | -61.2872 | 2020-12-06 05:26:18 | Saint Vincent and the Grenadines | |||
2020-12-04 | Saint Vincent and the Grenadines | 87 | 0 | 80 | 7 | 12.9843 | -61.2872 | 2020-12-05 05:27:36 | Saint Vincent and the Grenadines | |||
2020-12-03 | Saint Vincent and the Grenadines | 87 | 0 | 80 | 7 | 12.9843 | -61.2872 | 2020-12-04 05:27:27 | Saint Vincent and the Grenadines | |||
2020-12-02 | Saint Vincent and the Grenadines | 85 | 0 | 80 | 5 | 12.9843 | -61.2872 | 2020-12-03 05:28:22 | Saint Vincent and the Grenadines | |||
2020-12-01 | Saint Vincent and the Grenadines | 85 | 0 | 80 | 5 | 12.9843 | -61.2872 | 2020-12-02 05:27:41 | Saint Vincent and the Grenadines | |||
2020-11-04 | Japan | Yamagata | 86 | 1 | 80 | 5 | 38.448396 | 140.102154 | 2020-11-05 06:05:03 | Yamagata, Japan | ||
2020-11-03 | Japan | Yamagata | 86 | 1 | 80 | 5 | 38.448396 | 140.102154 | 2020-11-04 05:25:09 | Yamagata, Japan | ||
2020-11-02 | Japan | Yamagata | 86 | 1 | 80 | 5 | 38.448396 | 140.102154 | 2020-11-03 06:00:16 | Yamagata, Japan | ||
2020-11-01 | Japan | Yamagata | 86 | 1 | 80 | 5 | 38.448396 | 140.102154 | 2020-11-02 05:25:04 | Yamagata, Japan | ||
2020-10-31 | Japan | Yamagata | 86 | 1 | 80 | 5 | 38.448396 | 140.102154 | 2020-11-01 04:36:19 | Yamagata, Japan | ||
2020-10-30 | Japan | Yamagata | 86 | 1 | 80 | 5 | 38.448396 | 140.102154 | 2020-10-31 04:24:44 | Yamagata, Japan | ||
2020-10-29 | Japan | Yamagata | 86 | 1 | 80 | 5 | 38.448396 | 140.102154 | 2020-10-30 04:24:49 | Yamagata, Japan | ||
2020-10-26 | Malaysia | W.P. Labuan | 269 | 2 | 80 | 187 | 5.2831 | 115.2308 | 2020-10-27 04:24:45 | W.P. Labuan, Malaysia | ||
2020-09-18 | Japan | Kagawa | 94 | 2 | 80 | 12 | 34.217292 | 133.969047 | 2020-09-19 04:22:00 | Kagawa, Japan | ||
2020-09-08 | Japan | Tokushima | 146 | 6 | 80 | 60 | 33.919178 | 134.242091 | 2020-09-09 04:28:48 | Tokushima, Japan | ||
2020-08-20 | Japan | Kochi | 105 | 3 | 80 | 22 | 33.422519 | 133.367307 | 2020-08-21 04:27:41 | Kochi, Japan | ||
2020-08-19 | Japan | Kochi | 105 | 3 | 80 | 22 | 33.422519 | 133.367307 | 2020-08-20 04:27:43 | Kochi, Japan | ||
2020-08-18 | Japan | Oita | 120 | 1 | 80 | 39 | 33.200697 | 131.43324 | 2020-08-19 04:27:00 | Oita, Japan | ||
2020-08-18 | Japan | Kochi | 103 | 3 | 80 | 20 | 33.422519 | 133.367307 | 2020-08-19 04:27:00 | Kochi, Japan | ||
2020-08-17 | Japan | Oita | 113 | 1 | 80 | 32 | 33.200697 | 131.43323999999998 | 2020-08-18 04:27:56 | Oita, Japan | ||
2020-08-12 | Botswana | 1066 | 2 | 80 | 984 | -22.3285 | 24.6849 | 2020-08-13 04:29:15 | Botswana | |||
2020-08-11 | Chile | Aysen | 95 | 1 | 80 | 14 | -45.9864 | -73.7669 | 2020-08-12 04:27:29 | Aysen, Chile | ||
2020-08-11 | Botswana | 1066 | 2 | 80 | 984 | -22.3285 | 24.6849 | 2020-08-12 04:27:29 | Botswana | |||
2020-08-10 | Botswana | 1066 | 2 | 80 | 984 | -22.3285 | 24.6849 | 2020-08-11 04:35:08 | Botswana | |||
2020-08-10 | Japan | Saga | 157 | 0 | 80 | 77 | 33.286977 | 130.115738 | 2020-08-11 04:35:08 | Saga, Japan | ||
2020-07-28 | Japan | Nagano | 98 | 0 | 80 | 18 | 36.132134 | 138.045528 | 2020-07-29 04:35:11 | Nagano, Japan | ||
2020-07-11 | India | Sikkim | 151 | 0 | 80 | 71 | 27.571671000000002 | 88.472712 | 2020-07-12 04:34:30 | Sikkim, India | ||
2020-07-10 | India | Sikkim | 134 | 0 | 80 | 54 | 27.571671000000002 | 88.472712 | 2020-07-11 04:34:26 | Sikkim, India | ||
2020-06-30 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-07-01 04:33:52 | Fukushima, Japan | ||
2020-06-29 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-30 04:33:48 | Fukushima, Japan | ||
2020-06-28 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-29 04:33:44 | Fukushima, Japan | ||
2020-06-27 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-28 04:34:04 | Fukushima, Japan | ||
2020-06-26 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-27 04:33:35 | Fukushima, Japan | ||
2020-06-25 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-26 04:33:43 | Fukushima, Japan | ||
2020-06-24 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-25 05:26:54 | Fukushima, Japan | ||
2020-06-23 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-24 04:33:28 | Fukushima, Japan | ||
2020-06-22 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-23 04:33:22 | Fukushima, Japan | ||
2020-06-21 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-22 04:33:20 | Fukushima, Japan | ||
2020-06-20 | Colombia | Santander | 343 | 10 | 80 | 253 | 6.6437 | -73.6536 | 2020-06-21 04:33:19 | Santander, Colombia | ||
2020-06-20 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-21 04:33:19 | Fukushima, Japan | ||
2020-06-19 | Japan | Fukushima | 82 | 0 | 80 | 2 | 37.378867 | 140.223295 | 2020-06-20 04:33:19 | Fukushima, Japan | ||
2020-06-07 | Guyana | 154 | 12 | 80 | 62 | 4.860416000000002 | -58.93018000000001 | 2020-06-08 03:33:22 | Guyana | |||
2020-06-06 | Guyana | 154 | 12 | 80 | 62 | 4.860416000000002 | -58.93018000000001 | 2020-06-07 03:53:30 | Guyana | |||
2020-06-02 | Russia | Altai Republic | 133 | 0 | 80 | 53 | 50.7114101 | 86.8572186 | 2020-06-03 02:33:13 | Altai Republic, Russia | ||
2020-05-30 | Mexico | Colima | 141 | 21 | 80 | 40 | 19.1223 | -104.0072 | 2020-05-31 02:32:45 | Colima, Mexico | ||
2020-05-21 | United Kingdom | Bermuda | 125 | 9 | 80 | 36 | 32.3078 | -64.7505 | 2020-05-22 02:36:51 | Bermuda, United Kingdom | ||
2020-05-20 | United Kingdom | Bermuda | 125 | 9 | 80 | 36 | 32.3078 | -64.7505 | 2020-05-21 02:32:48 | Bermuda, United Kingdom | ||
2020-05-17 | Malaysia | W.P. Putrajaya | 90 | 1 | 80 | 9 | 2.9264 | 101.6964 | 2020-05-18 02:32:21 | W.P. Putrajaya, Malaysia | ||
2020-05-06 | Sudan | 852 | 49 | 80 | 723 | 12.8628 | 30.2176 | 2020-05-07 02:32:28 | Sudan | |||
2020-05-04 | Congo (Kinshasa) | 682 | 34 | 80 | 568 | -4.322447 | 15.307045 | 2020-05-05 02:32:34 | Congo (Kinshasa) | |||
2020-04-26 | Bolivia | 950 | 50 | 80 | 820 | -16.2902 | -63.5887 | 2020-04-27 02:30:33 | Bolivia | |||
2020-04-14 | Lebanon | 641 | 21 | 80 | 540 | 33.8547 | 35.8623 | 2020-04-14 23:33:12 | Lebanon | |||
2020-04-13 | Lebanon | 632 | 20 | 80 | 532 | 33.8547 | 35.8623 | 2020-04-13 23:07:34 | Lebanon | |||
2020-04-12 | Lebanon | 630 | 20 | 80 | 530 | 33.8547 | 35.8623 | 2020-04-12 23:17:00 | Lebanon | |||
2020-04-09 | Dominican Republic | 2349 | 118 | 80 | 2151 | 18.7357 | -70.1627 | 2020-04-09 23:02:19 | Dominican Republic | |||
2020-04-07 | Malaysia | Negeri Sembilan | 262 | 5 | 80 | 177 | 2.7258 | 101.9424 | 2020-04-07 23:04:49 | Negeri Sembilan, Malaysia | ||
2020-04-06 | Malaysia | Negeri Sembilan | 240 | 4 | 80 | 156 | 2.7258 | 101.9424 | 4/6/20 23:22 | Negeri Sembilan, Malaysia | ||
2020-04-02 | Luxembourg | 2487 | 30 | 80 | 2377 | 49.8153 | 6.1296 | 4/2/20 23:25 | Luxembourg | |||
2020-04-01 | Luxembourg | 2319 | 29 | 80 | 2210 | 49.8153 | 6.1296 | 2020-04-01 21:58:34 | Luxembourg | |||
2020-04-01 | Kuwait | 317 | 0 | 80 | 237 | 29.311659999999996 | 47.481766 | 2020-04-01 21:58:34 | Kuwait | |||
2020-03-31 | Luxembourg | 2178 | 23 | 80 | 2075 | 49.8153 | 6.1296 | 2020-03-31 23:43:43 | Luxembourg | |||
2020-03-24 | Egypt | 402 | 20 | 80 | 302 | 26.820553000000004 | 30.802497999999996 | 2020-03-24 23:37:15 | Egypt | |||
2020-02-25 | Mainland China | Gansu | 91 | 2 | 80 | 36.0611 | 103.8343 | 2020-02-24T15:13:07 | ||||
2020-02-24 | Mainland China | Gansu | 91 | 2 | 80 | 36.0611 | 103.8343 | 2020-02-24T15:13:07 | ||||
2020-02-24 | Mainland China | Liaoning | 121 | 1 | 80 | 41.2956 | 122.6085 | 2020-02-24T06:53:02 | ||||
2020-02-14 | Mainland China | Beijing | 372 | 3 | 80 | 40.1824 | 116.4142 | 2020-02-14T06:33:02 | ||||
2020-02-11 | Mainland China | Shandong | 487 | 1 | 80 | 36.3427 | 118.1498 | 2020-02-11T11:23:04 | ||||
2020-02-10 | Mainland China | Sichuan | 405 | 1 | 80 | 30.6171 | 102.7103 | 2020-02-10T10:03:02 | ||||
2020-01-28 | Mainland China | Hubei | 3554 | 125 | 80 | 30.9756 | 112.2707 | 1/28/20 23:00 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;