daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
80 rows where recovered = 245 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-06-29 | Brunei | 259 | 3 | 245 | 11 | 4.5353 | 114.7277 | 2021-06-30 04:21:41 | Brunei | |||
2021-06-28 | Brunei | 259 | 3 | 245 | 11 | 4.5353 | 114.7277 | 2021-06-29 04:21:28 | Brunei | |||
2021-06-27 | Brunei | 259 | 3 | 245 | 11 | 4.5353 | 114.7277 | 2021-06-28 04:21:29 | Brunei | |||
2021-06-26 | Brunei | 259 | 3 | 245 | 11 | 4.5353 | 114.7277 | 2021-06-27 04:21:39 | Brunei | |||
2021-06-25 | Brunei | 256 | 3 | 245 | 8 | 4.5353 | 114.7277 | 2021-06-26 04:21:43 | Brunei | |||
2021-06-24 | Brunei | 256 | 3 | 245 | 8 | 4.5353 | 114.7277 | 2021-06-25 04:21:33 | Brunei | |||
2021-06-23 | Brunei | 256 | 3 | 245 | 8 | 4.5353 | 114.7277 | 2021-06-24 04:21:55 | Brunei | |||
2021-06-22 | Brunei | 256 | 3 | 245 | 8 | 4.5353 | 114.7277 | 2021-06-23 04:21:46 | Brunei | |||
2021-05-17 | China | Shanxi | 251 | 0 | 245 | 6 | 37.5777 | 112.2922 | 2021-05-18 04:20:33 | Shanxi, China | ||
2021-05-16 | China | Shanxi | 251 | 0 | 245 | 6 | 37.5777 | 112.2922 | 2021-05-17 04:20:34 | Shanxi, China | ||
2021-03-18 | Malaysia | Perlis | 321 | 2 | 245 | 74 | 6.4449 | 100.2048 | 2021-03-19 05:26:09 | Perlis, Malaysia | ||
2021-02-02 | Japan | Shimane | 271 | 0 | 245 | 26 | 35.07076 | 132.55406399999998 | 2021-02-03 05:22:52 | Shimane, Japan | ||
2020-11-26 | Japan | Nagasaki | 265 | 3 | 245 | 17 | 33.235712 | 129.608033 | 2020-11-27 05:26:53 | Nagasaki, Japan | ||
2020-11-25 | Japan | Nagasaki | 264 | 3 | 245 | 16 | 33.235712 | 129.608033 | 2020-11-26 05:27:44 | Nagasaki, Japan | ||
2020-11-23 | United Kingdom | Cayman Islands | 265 | 2 | 245 | 18 | 19.3133 | -81.2546 | 2020-11-24 05:27:31 | Cayman Islands, United Kingdom | ||
2020-11-22 | United Kingdom | Cayman Islands | 261 | 2 | 245 | 14 | 19.3133 | -81.2546 | 2020-11-23 05:25:26 | Cayman Islands, United Kingdom | ||
2020-11-21 | United Kingdom | Cayman Islands | 261 | 2 | 245 | 14 | 19.3133 | -81.2546 | 2020-11-22 05:25:45 | Cayman Islands, United Kingdom | ||
2020-11-13 | Japan | Fukui | 271 | 11 | 245 | 15 | 35.846614 | 136.22465400000002 | 2020-11-14 05:25:37 | Fukui, Japan | ||
2020-11-12 | Japan | Fukui | 269 | 11 | 245 | 13 | 35.846614 | 136.22465400000002 | 2020-11-13 05:25:30 | Fukui, Japan | ||
2020-11-11 | Japan | Fukui | 268 | 11 | 245 | 12 | 35.846614 | 136.22465400000002 | 2020-11-12 05:25:55 | Fukui, Japan | ||
2020-11-10 | Japan | Fukui | 266 | 11 | 245 | 10 | 35.846614 | 136.22465400000002 | 2020-11-11 05:25:30 | Fukui, Japan | ||
2020-11-09 | Japan | Fukui | 262 | 11 | 245 | 6 | 35.846614 | 136.22465400000002 | 2020-11-10 05:40:07 | Fukui, Japan | ||
2020-11-08 | Japan | Fukui | 259 | 11 | 245 | 3 | 35.846614 | 136.22465400000002 | 2020-11-09 05:25:45 | Fukui, Japan | ||
2020-11-07 | Japan | Fukui | 258 | 11 | 245 | 2 | 35.846614 | 136.22465400000002 | 2020-11-08 05:24:56 | Fukui, Japan | ||
2020-11-06 | Japan | Fukui | 257 | 11 | 245 | 1 | 35.846614 | 136.22465400000002 | 2020-11-07 05:24:52 | Fukui, Japan | ||
2020-11-05 | Japan | Fukui | 257 | 11 | 245 | 1 | 35.846614 | 136.22465400000002 | 2020-11-06 05:24:55 | Fukui, Japan | ||
2020-11-04 | Japan | Fukui | 257 | 11 | 245 | 1 | 35.846614 | 136.22465400000002 | 2020-11-05 06:05:03 | Fukui, Japan | ||
2020-11-03 | Japan | Fukui | 257 | 11 | 245 | 1 | 35.846614 | 136.22465400000002 | 2020-11-04 05:25:09 | Fukui, Japan | ||
2020-11-02 | Japan | Fukui | 257 | 11 | 245 | 1 | 35.846614 | 136.22465400000002 | 2020-11-03 06:00:16 | Fukui, Japan | ||
2020-10-25 | Japan | Wakayama | 272 | 4 | 245 | 23 | 33.911879 | 135.505446 | 2020-10-26 04:25:02 | Wakayama, Japan | ||
2020-10-25 | China | Tianjin | 260 | 3 | 245 | 12 | 39.3054 | 117.323 | 2020-10-26 04:25:02 | Tianjin, China | ||
2020-10-24 | Japan | Wakayama | 270 | 4 | 245 | 21 | 33.911879 | 135.505446 | 2020-10-25 04:24:36 | Wakayama, Japan | ||
2020-10-23 | Canada | New Brunswick | 324 | 4 | 245 | 75 | 46.5653 | -66.4619 | 2020-10-24 04:24:46 | New Brunswick, Canada | ||
2020-09-30 | Japan | Saga | 245 | 0 | 245 | 0 | 33.286977 | 130.115738 | 2020-10-01 04:23:42 | Saga, Japan | ||
2020-09-29 | Japan | Saga | 245 | 0 | 245 | 0 | 33.286977 | 130.115738 | 2020-09-30 04:23:33 | Saga, Japan | ||
2020-09-28 | Japan | Saga | 245 | 0 | 245 | 0 | 33.286977 | 130.115738 | 2020-09-29 04:23:42 | Saga, Japan | ||
2020-09-07 | Colombia | Guaviare | 351 | 4 | 245 | 102 | 1.0654 | -73.2603 | 2020-09-08 04:28:25 | Guaviare, Colombia | ||
2020-09-06 | Colombia | Guaviare | 351 | 4 | 245 | 102 | 1.0654 | -73.2603 | 2020-09-07 04:28:30 | Guaviare, Colombia | ||
2020-08-21 | China | Liaoning | 261 | 2 | 245 | 14 | 41.2956 | 122.6085 | 2020-08-22 04:27:49 | Liaoning, China | ||
2020-08-20 | China | Liaoning | 261 | 2 | 245 | 14 | 41.2956 | 122.6085 | 2020-08-21 04:27:41 | Liaoning, China | ||
2020-08-19 | Japan | Shiga | 361 | 4 | 245 | 112 | 35.21582700000001 | 136.138064 | 2020-08-20 04:27:43 | Shiga, Japan | ||
2020-08-16 | Colombia | Arauca | 610 | 10 | 245 | 355 | 7.0762 | -70.7105 | 2020-08-17 04:27:20 | Arauca, Colombia | ||
2020-08-09 | Eritrea | 285 | 0 | 245 | 40 | 15.1794 | 39.7823 | 2020-08-10 04:34:55 | Eritrea | |||
2020-08-08 | Eritrea | 285 | 0 | 245 | 40 | 15.1794 | 39.7823 | 2020-08-09 04:34:54 | Eritrea | |||
2020-08-07 | Eritrea | 285 | 0 | 245 | 40 | 15.1794 | 39.7823 | 2020-08-08 04:34:53 | Eritrea | |||
2020-07-19 | Colombia | Caldas | 392 | 7 | 245 | 140 | 5.2983 | -75.2479 | 2020-07-20 05:34:40 | Caldas, Colombia | ||
2020-07-12 | India | Dadra and Nagar Haveli and Daman and Diu | 479 | 0 | 245 | 234 | 20.194742 | 73.080901 | 2020-07-13 04:43:04 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2020-07-07 | Burma | 316 | 6 | 245 | 65 | 21.9162 | 95.956 | 2020-07-08 05:33:48 | Burma | |||
2020-07-06 | Burma | 316 | 6 | 245 | 65 | 21.9162 | 95.956 | 2020-07-07 04:34:00 | Burma | |||
2020-07-05 | Malaysia | Melaka | 251 | 6 | 245 | 0 | 2.1896 | 102.2501 | 2020-07-06 04:33:57 | Melaka, Malaysia | ||
2020-07-04 | Malaysia | Melaka | 251 | 6 | 245 | 0 | 2.1896 | 102.2501 | 2020-07-05 04:33:46 | Melaka, Malaysia | ||
2020-07-03 | Malaysia | Melaka | 251 | 6 | 245 | 0 | 2.1896 | 102.2501 | 2020-07-04 04:33:51 | Melaka, Malaysia | ||
2020-06-28 | Russia | Sakhalin Oblast | 742 | 0 | 245 | 497 | 49.7219665 | 143.448533 | 2020-06-29 04:33:44 | Sakhalin Oblast, Russia | ||
2020-06-12 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-13 03:33:14 | Perak, Malaysia | ||
2020-06-11 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-12 05:09:52 | Perak, Malaysia | ||
2020-06-10 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-11 03:33:41 | Perak, Malaysia | ||
2020-06-10 | Russia | Karelia Republic | 676 | 2 | 245 | 429 | 62.61940309999999 | 33.4920267 | 2020-06-11 03:33:41 | Karelia Republic, Russia | ||
2020-06-09 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-10 04:07:00 | Perak, Malaysia | ||
2020-06-08 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-09 03:33:03 | Perak, Malaysia | ||
2020-06-07 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-08 03:33:22 | Perak, Malaysia | ||
2020-06-06 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-07 03:53:30 | Perak, Malaysia | ||
2020-06-05 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-06 02:33:00 | Perak, Malaysia | ||
2020-06-04 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-05 02:33:06 | Perak, Malaysia | ||
2020-06-03 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-04 02:33:14 | Perak, Malaysia | ||
2020-06-03 | Colombia | Narino | 1263 | 56 | 245 | 962 | 1.2892 | -77.3579 | 2020-06-04 02:33:14 | Narino, Colombia | ||
2020-06-02 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-03 02:33:13 | Perak, Malaysia | ||
2020-06-02 | Ukraine | Khmelnytskyi Oblast | 458 | 11 | 245 | 202 | 49.423 | 26.9871 | 2020-06-03 02:33:13 | Khmelnytskyi Oblast, Ukraine | ||
2020-06-01 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-02 02:33:08 | Perak, Malaysia | ||
2020-05-31 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-06-01 02:32:46 | Perak, Malaysia | ||
2020-05-30 | Malaysia | Perak | 255 | 6 | 245 | 4 | 4.5921 | 101.0901 | 2020-05-31 02:32:45 | Perak, Malaysia | ||
2020-05-29 | Malaysia | Perak | 254 | 6 | 245 | 3 | 4.5921 | 101.0901 | 2020-05-30 02:32:48 | Perak, Malaysia | ||
2020-05-28 | Malaysia | Perak | 254 | 6 | 245 | 3 | 4.5921 | 101.0901 | 2020-05-29 02:32:50 | Perak, Malaysia | ||
2020-05-28 | Rwanda | 349 | 0 | 245 | 104 | -1.9403 | 29.8739 | 2020-05-29 02:32:50 | Rwanda | |||
2020-05-27 | Malaysia | Perak | 254 | 6 | 245 | 3 | 4.5921 | 101.0901 | 2020-05-28 02:32:31 | Perak, Malaysia | ||
2020-05-27 | Rwanda | 346 | 0 | 245 | 101 | -1.9403 | 29.8739 | 2020-05-28 02:32:31 | Rwanda | |||
2020-05-26 | Malaysia | Perak | 254 | 6 | 245 | 3 | 4.5921 | 101.0901 | 2020-05-27 02:32:31 | Perak, Malaysia | ||
2020-05-02 | Montenegro | 322 | 8 | 245 | 69 | 42.708678000000006 | 19.37439 | 2020-05-03 02:32:28 | Montenegro | |||
2020-04-05 | China | Shaanxi | 256 | 3 | 245 | 8 | 35.1917 | 108.8701 | 2020-04-04 01:50:33 | Shaanxi, China | ||
2020-04-04 | China | Shaanxi | 256 | 3 | 245 | 8 | 35.1917 | 108.8701 | 4/4/20 1:50 | Shaanxi, China | ||
2020-04-01 | Singapore | 1000 | 3 | 245 | 752 | 1.2833 | 103.8333 | 2020-04-01 21:58:34 | Singapore |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;