daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
77 rows where recovered = 248 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-02 | Brunei | 261 | 3 | 248 | 10 | 4.5353 | 114.7277 | 2021-07-03 04:21:37 | Brunei | |||
2021-07-01 | Brunei | 261 | 3 | 248 | 10 | 4.5353 | 114.7277 | 2021-07-02 04:21:47 | Brunei | |||
2021-06-30 | Brunei | 260 | 3 | 248 | 9 | 4.5353 | 114.7277 | 2021-07-01 04:21:19 | Brunei | |||
2021-06-02 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-06-03 04:23:32 | Shanxi, China | ||
2021-06-01 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-06-02 04:24:34 | Shanxi, China | ||
2021-05-31 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-06-01 04:23:09 | Shanxi, China | ||
2021-05-30 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-31 03:08:59 | Shanxi, China | ||
2021-05-29 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-30 04:20:55 | Shanxi, China | ||
2021-05-28 | China | Shanxi | 253 | 0 | 248 | 5 | 37.5777 | 112.2922 | 2021-05-29 04:20:41 | Shanxi, China | ||
2021-04-18 | China | Yunnan | 330 | 2 | 248 | 80 | 24.974 | 101.487 | 2021-04-19 04:20:57 | Yunnan, China | ||
2021-02-03 | Japan | Shimane | 273 | 0 | 248 | 25 | 35.07076 | 132.55406399999998 | 2021-02-04 05:22:26 | Shimane, Japan | ||
2021-01-31 | Japan | Shimane | 268 | 0 | 248 | 20 | 35.07076 | 132.55406399999998 | 2021-02-01 05:22:53 | Shimane, Japan | ||
2021-01-30 | Japan | Shimane | 265 | 0 | 248 | 17 | 35.07076 | 132.55406399999998 | 2021-01-31 05:22:42 | Shimane, Japan | ||
2021-01-03 | Malaysia | W.P. Putrajaya | 314 | 3 | 248 | 63 | 2.9264 | 101.6964 | 2021-01-04 05:22:02 | W.P. Putrajaya, Malaysia | ||
2020-11-20 | Japan | Aomori | 280 | 6 | 248 | 26 | 40.781541 | 140.828896 | 2020-11-21 05:25:51 | Aomori, Japan | ||
2020-11-18 | Japan | Fukui | 289 | 11 | 248 | 30 | 35.846614 | 136.22465400000002 | 2020-11-19 05:25:23 | Fukui, Japan | ||
2020-10-16 | Japan | Saga | 250 | 0 | 248 | 2 | 33.286977 | 130.115738 | 2020-10-17 04:24:12 | Saga, Japan | ||
2020-10-15 | Japan | Saga | 249 | 0 | 248 | 1 | 33.286977 | 130.115738 | 2020-10-16 04:24:01 | Saga, Japan | ||
2020-10-14 | Japan | Saga | 249 | 0 | 248 | 1 | 33.286977 | 130.115738 | 2020-10-15 04:24:28 | Saga, Japan | ||
2020-10-13 | Japan | Saga | 249 | 0 | 248 | 1 | 33.286977 | 130.115738 | 2020-10-14 04:24:05 | Saga, Japan | ||
2020-10-05 | Bhutan | 299 | 0 | 248 | 51 | 27.5142 | 90.4336 | 2020-10-06 04:23:33 | Bhutan | |||
2020-09-04 | United Kingdom | Gibraltar | 305 | 0 | 248 | 57 | 36.1408 | -5.3536 | 2020-09-05 04:28:19 | Gibraltar, United Kingdom | ||
2020-08-22 | China | Liaoning | 261 | 2 | 248 | 11 | 41.2956 | 122.6085 | 2020-08-23 04:27:48 | Liaoning, China | ||
2020-08-20 | Japan | Toyama | 334 | 22 | 248 | 64 | 36.637464 | 137.26934599999998 | 2020-08-21 04:27:41 | Toyama, Japan | ||
2020-08-20 | Japan | Shiga | 366 | 4 | 248 | 114 | 35.21582700000001 | 136.138064 | 2020-08-21 04:27:41 | Shiga, Japan | ||
2020-08-17 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-18 04:27:56 | Melaka, Malaysia | ||
2020-08-17 | Eritrea | 285 | 0 | 248 | 37 | 15.1794 | 39.7823 | 2020-08-18 04:27:56 | Eritrea | |||
2020-08-16 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-17 04:27:20 | Melaka, Malaysia | ||
2020-08-16 | Eritrea | 285 | 0 | 248 | 37 | 15.1794 | 39.7823 | 2020-08-17 04:27:20 | Eritrea | |||
2020-08-15 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-16 04:27:42 | Melaka, Malaysia | ||
2020-08-15 | Eritrea | 285 | 0 | 248 | 37 | 15.1794 | 39.7823 | 2020-08-16 04:27:42 | Eritrea | |||
2020-08-14 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-15 04:27:31 | Melaka, Malaysia | ||
2020-08-14 | Eritrea | 285 | 0 | 248 | 37 | 15.1794 | 39.7823 | 2020-08-15 04:27:31 | Eritrea | |||
2020-08-13 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-14 04:51:19 | Melaka, Malaysia | ||
2020-08-13 | Eritrea | 285 | 0 | 248 | 37 | 15.1794 | 39.7823 | 2020-08-14 04:51:19 | Eritrea | |||
2020-08-12 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-13 04:29:15 | Melaka, Malaysia | ||
2020-08-12 | Eritrea | 285 | 0 | 248 | 37 | 15.1794 | 39.7823 | 2020-08-13 04:29:15 | Eritrea | |||
2020-08-11 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-12 04:27:29 | Melaka, Malaysia | ||
2020-08-11 | Eritrea | 285 | 0 | 248 | 37 | 15.1794 | 39.7823 | 2020-08-12 04:27:29 | Eritrea | |||
2020-08-10 | Malaysia | Melaka | 254 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-11 04:35:08 | Melaka, Malaysia | ||
2020-08-10 | Eritrea | 285 | 0 | 248 | 37 | 15.1794 | 39.7823 | 2020-08-11 04:35:08 | Eritrea | |||
2020-08-09 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-10 04:34:55 | Melaka, Malaysia | ||
2020-08-08 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-09 04:34:54 | Melaka, Malaysia | ||
2020-08-07 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-08 04:34:53 | Melaka, Malaysia | ||
2020-08-06 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-07 04:35:11 | Melaka, Malaysia | ||
2020-08-05 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-06 04:35:02 | Melaka, Malaysia | ||
2020-08-04 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-05 04:34:43 | Melaka, Malaysia | ||
2020-08-03 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-04 04:41:59 | Melaka, Malaysia | ||
2020-08-02 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-03 04:34:35 | Melaka, Malaysia | ||
2020-08-02 | Colombia | Caqueta | 1276 | 29 | 248 | 999 | 0.8699 | -73.8419 | 2020-08-03 04:34:35 | Caqueta, Colombia | ||
2020-08-01 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-02 04:34:47 | Melaka, Malaysia | ||
2020-07-31 | Malaysia | Melaka | 253 | 6 | 248 | 0 | 2.1896 | 102.2501 | 2020-08-01 04:36:27 | Melaka, Malaysia | ||
2020-07-06 | Ukraine | Sumy Oblast | 321 | 5 | 248 | 68 | 50.9077 | 34.7981 | 2020-07-07 04:34:00 | Sumy Oblast, Ukraine | ||
2020-07-05 | Ukraine | Sumy Oblast | 317 | 5 | 248 | 64 | 50.9077 | 34.7981 | 2020-07-06 04:33:57 | Sumy Oblast, Ukraine | ||
2020-07-01 | Mozambique | 903 | 6 | 248 | 649 | -18.665695 | 35.529562 | 2020-07-02 04:33:46 | Mozambique | |||
2020-06-22 | Japan | Ishikawa | 300 | 27 | 248 | 25 | 36.769464 | 136.771027 | 2020-06-23 04:33:22 | Ishikawa, Japan | ||
2020-06-21 | Japan | Ishikawa | 299 | 27 | 248 | 24 | 36.769464 | 136.771027 | 2020-06-22 04:33:20 | Ishikawa, Japan | ||
2020-06-20 | Japan | Ishikawa | 299 | 27 | 248 | 24 | 36.769464 | 136.771027 | 2020-06-21 04:33:19 | Ishikawa, Japan | ||
2020-06-17 | Russia | Kurgan Oblast | 422 | 0 | 248 | 174 | 55.7655302 | 64.5632681 | 2020-06-18 04:33:18 | Kurgan Oblast, Russia | ||
2020-06-07 | Togo | 495 | 13 | 248 | 234 | 8.6195 | 0.8248 | 2020-06-08 03:33:22 | Togo | |||
2020-05-31 | Colombia | Cundinamarca | 852 | 16 | 248 | 588 | 5.026 | -74.03 | 2020-06-01 02:32:46 | Cundinamarca, Colombia | ||
2020-05-15 | Canada | Newfoundland and Labrador | 260 | 3 | 248 | 9 | 53.1355 | -57.6604 | 2020-05-16 02:32:19 | Newfoundland and Labrador, Canada | ||
2020-05-14 | Canada | Newfoundland and Labrador | 260 | 3 | 248 | 10 | 53.1355 | -57.6604 | 2020-05-15 02:33:02 | Newfoundland and Labrador, Canada | ||
2020-04-27 | United Kingdom | Isle of Man | 308 | 20 | 248 | 40 | 54.2361 | -4.5481 | 2020-04-28 02:30:32 | Isle of Man, United Kingdom | ||
2020-04-20 | Andorra | 717 | 37 | 248 | 432 | 42.5063 | 1.5218 | 2020-04-20 23:36:27 | Andorra | |||
2020-04-17 | Malaysia | Negeri Sembilan | 403 | 7 | 248 | 148 | 2.7258 | 101.9424 | 2020-04-17 23:30:52 | Negeri Sembilan, Malaysia | ||
2020-04-14 | Uruguay | 483 | 8 | 248 | 227 | -32.5228 | -55.7658 | 2020-04-14 23:33:12 | Uruguay | |||
2020-04-14 | Albania | 475 | 24 | 248 | 203 | 41.1533 | 20.1683 | 2020-04-14 23:33:12 | Albania | |||
2020-04-14 | China | Shaanxi | 256 | 3 | 248 | 5 | 35.1917 | 108.8701 | 2020-04-11 00:52:23 | Shaanxi, China | ||
2020-04-13 | China | Shaanxi | 256 | 3 | 248 | 5 | 35.1917 | 108.8701 | 2020-04-11 00:52:23 | Shaanxi, China | ||
2020-04-12 | China | Shaanxi | 256 | 3 | 248 | 5 | 35.1917 | 108.8701 | 2020-04-11 00:52:00 | Shaanxi, China | ||
2020-04-11 | China | Shaanxi | 256 | 3 | 248 | 5 | 35.1917 | 108.8701 | 2020-04-11 00:52:23 | Shaanxi, China | ||
2020-04-01 | Argentina | 1054 | 28 | 248 | 778 | -38.4161 | -63.6167 | 2020-04-01 21:58:34 | Argentina | |||
2020-03-17 | China | Guangxi | 253 | 2 | 248 | 23.8298 | 108.7881 | 2020-03-17T00:33:02 | ||||
2020-03-16 | China | Guangxi | 252 | 2 | 248 | 23.8298 | 108.7881 | 2020-03-16T14:38:45 | ||||
2020-02-27 | Mainland China | Beijing | 410 | 5 | 248 | 40.1824 | 116.4142 | 2020-02-27T02:23:13 | ||||
2020-02-25 | Mainland China | Hebei | 311 | 6 | 248 | 38.0428 | 114.5149 | 2020-02-25T12:43:02 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;