daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where recovered = 424 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- China 19
- Japan 12
- United Kingdom 3
- Togo 2
- Ukraine 2
- Canada 1
- Malaysia 1
- Russia 1
- Saint Lucia 1
- Sudan 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-13 | China | Liaoning | 431 | 2 | 424 | 5 | 41.2956 | 122.6085 | 2021-07-14 04:21:35 | Liaoning, China | ||
2021-07-12 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-13 04:21:18 | Liaoning, China | ||
2021-07-11 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-12 04:21:34 | Liaoning, China | ||
2021-07-10 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-11 04:21:43 | Liaoning, China | ||
2021-07-09 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-10 04:21:25 | Liaoning, China | ||
2021-07-08 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-09 04:21:21 | Liaoning, China | ||
2021-07-07 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-08 04:21:26 | Liaoning, China | ||
2021-07-06 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-07 04:21:20 | Liaoning, China | ||
2021-07-05 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-06 04:21:32 | Liaoning, China | ||
2021-07-04 | China | Liaoning | 429 | 2 | 424 | 3 | 41.2956 | 122.6085 | 2021-07-05 04:21:28 | Liaoning, China | ||
2021-07-03 | China | Liaoning | 429 | 2 | 424 | 3 | 41.2956 | 122.6085 | 2021-07-04 04:21:38 | Liaoning, China | ||
2021-07-02 | China | Liaoning | 428 | 2 | 424 | 2 | 41.2956 | 122.6085 | 2021-07-03 04:21:37 | Liaoning, China | ||
2021-07-01 | China | Liaoning | 428 | 2 | 424 | 2 | 41.2956 | 122.6085 | 2021-07-02 04:21:47 | Liaoning, China | ||
2021-06-30 | China | Liaoning | 427 | 2 | 424 | 1 | 41.2956 | 122.6085 | 2021-07-01 04:21:19 | Liaoning, China | ||
2021-06-29 | China | Liaoning | 427 | 2 | 424 | 1 | 41.2956 | 122.6085 | 2021-06-30 04:21:41 | Liaoning, China | ||
2021-06-28 | China | Liaoning | 427 | 2 | 424 | 1 | 41.2956 | 122.6085 | 2021-06-29 04:21:28 | Liaoning, China | ||
2021-06-27 | China | Liaoning | 427 | 2 | 424 | 1 | 41.2956 | 122.6085 | 2021-06-28 04:21:29 | Liaoning, China | ||
2021-06-02 | Japan | Tottori | 466 | 2 | 424 | 40 | 35.359069 | 133.863619 | 2021-06-03 04:23:32 | Tottori, Japan | ||
2021-05-31 | Malaysia | Perlis | 511 | 4 | 424 | 83 | 6.4449 | 100.2048 | 2021-06-01 04:23:09 | Perlis, Malaysia | ||
2021-05-27 | Japan | Shimane | 526 | 0 | 424 | 102 | 35.07076 | 132.55406399999998 | 2021-05-28 04:20:36 | Shimane, Japan | ||
2021-04-28 | Canada | Nunavut | 478 | 4 | 424 | 50 | 70.2998 | -83.1076 | 2021-04-29 04:20:55 | Nunavut, Canada | ||
2021-03-13 | United Kingdom | Isle of Man | 1234 | 26 | 424 | 784 | 54.2361 | -4.5481 | 2021-03-14 05:25:37 | Isle of Man, United Kingdom | ||
2021-03-12 | United Kingdom | Isle of Man | 1157 | 26 | 424 | 707 | 54.2361 | -4.5481 | 2021-03-13 05:25:15 | Isle of Man, United Kingdom | ||
2021-03-11 | Japan | Tokushima | 462 | 17 | 424 | 21 | 33.919178 | 134.242091 | 2021-03-12 05:26:50 | Tokushima, Japan | ||
2021-01-27 | Japan | Kagawa | 608 | 14 | 424 | 170 | 34.217292 | 133.969047 | 2021-01-28 05:22:24 | Kagawa, Japan | ||
2021-01-24 | Saint Lucia | 810 | 11 | 424 | 375 | 13.9094 | -60.9789 | 2021-01-25 05:22:16 | Saint Lucia | |||
2021-01-03 | Japan | Saga | 477 | 3 | 424 | 50 | 33.286977 | 130.115738 | 2021-01-04 05:22:02 | Saga, Japan | ||
2020-12-08 | Japan | Toyama | 462 | 26 | 424 | 12 | 36.637464 | 137.26934599999998 | 2020-12-09 05:28:01 | Toyama, Japan | ||
2020-12-03 | Japan | Miyazaki | 527 | 1 | 424 | 102 | 32.193203999999994 | 131.299374 | 2020-12-04 05:27:27 | Miyazaki, Japan | ||
2020-10-13 | United Kingdom | Gibraltar | 499 | 0 | 424 | 75 | 36.1408 | -5.3536 | 2020-10-14 04:24:05 | Gibraltar, United Kingdom | ||
2020-10-12 | Japan | Tochigi | 444 | 1 | 424 | 19 | 36.689912 | 139.819213 | 2020-10-13 04:24:02 | Tochigi, Japan | ||
2020-08-17 | Japan | Gifu | 516 | 8 | 424 | 84 | 35.778671 | 137.055925 | 2020-08-18 04:27:56 | Gifu, Japan | ||
2020-08-13 | China | Xinjiang | 891 | 3 | 424 | 464 | 41.1129 | 85.2401 | 2020-08-14 04:51:19 | Xinjiang, China | ||
2020-07-03 | Togo | 671 | 14 | 424 | 233 | 8.6195 | 0.8248 | 2020-07-04 04:33:51 | Togo | |||
2020-07-02 | Togo | 667 | 14 | 424 | 229 | 8.6195 | 0.8248 | 2020-07-03 04:33:54 | Togo | |||
2020-06-15 | Ukraine | Odessa Oblast | 1117 | 18 | 424 | 675 | 46.4846 | 30.7326 | 2020-06-16 04:33:09 | Odessa Oblast, Ukraine | ||
2020-06-15 | Russia | Kemerovo Oblast | 1042 | 7 | 424 | 611 | 54.53357809999999 | 87.342861 | 2020-06-16 04:33:09 | Kemerovo Oblast, Russia | ||
2020-05-23 | Sudan | 3378 | 146 | 424 | 2808 | 12.8628 | 30.2176 | 2020-05-24 02:32:43 | Sudan | |||
2020-04-22 | Ukraine | 6592 | 174 | 424 | 5994 | 48.3794 | 31.1656 | 2020-04-22 23:30:32 | Ukraine | |||
2020-04-02 | China | Beijing | 582 | 8 | 424 | 150 | 40.1824 | 116.4142 | 4/2/20 2:23 | Beijing, China | ||
2020-03-31 | Japan | 1953 | 56 | 424 | 1473 | 36.204824 | 138.252924 | 2020-03-31 23:43:43 | Japan | |||
2020-03-30 | Japan | 1866 | 54 | 424 | 1388 | 36.204824 | 138.252924 | 3/30/20 22:52 | Japan | |||
2020-03-29 | Japan | 1866 | 54 | 424 | 1388 | 36.204824 | 138.252924 | 3/29/20 23:08 | Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;