daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where recovered = 420 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-20 | United Kingdom | British Virgin Islands | 2024 | 23 | 420 | 1581 | 18.4207 | -64.64 | 2021-07-21 04:21:40 | British Virgin Islands, United Kingdom | ||
2021-07-19 | United Kingdom | British Virgin Islands | 2024 | 17 | 420 | 1587 | 18.4207 | -64.64 | 2021-07-20 04:21:48 | British Virgin Islands, United Kingdom | ||
2021-07-18 | United Kingdom | British Virgin Islands | 2024 | 17 | 420 | 1587 | 18.4207 | -64.64 | 2021-07-19 04:21:24 | British Virgin Islands, United Kingdom | ||
2021-07-18 | Canada | Yukon | 502 | 6 | 420 | 76 | 64.2823 | -135.0 | 2021-07-19 04:21:24 | Yukon, Canada | ||
2021-07-17 | United Kingdom | British Virgin Islands | 2024 | 14 | 420 | 1590 | 18.4207 | -64.64 | 2021-07-18 04:22:07 | British Virgin Islands, United Kingdom | ||
2021-07-17 | Canada | Yukon | 502 | 6 | 420 | 76 | 64.2823 | -135.0 | 2021-07-18 04:22:07 | Yukon, Canada | ||
2021-07-16 | Canada | Yukon | 502 | 6 | 420 | 76 | 64.2823 | -135.0 | 2021-07-17 04:22:22 | Yukon, Canada | ||
2021-06-07 | China | Liaoning | 426 | 2 | 420 | 4 | 41.2956 | 122.6085 | 2021-06-08 04:22:35 | Liaoning, China | ||
2021-03-09 | Japan | Tokushima | 461 | 17 | 420 | 24 | 33.919178 | 134.242091 | 2021-03-10 05:24:35 | Tokushima, Japan | ||
2021-01-15 | Malaysia | Terengganu | 755 | 1 | 420 | 334 | 5.3117 | 103.1324 | 2021-01-16 05:22:40 | Terengganu, Malaysia | ||
2020-12-28 | Japan | Yamaguchi | 537 | 3 | 420 | 114 | 34.201190000000004 | 131.573293 | 2020-12-29 05:22:37 | Yamaguchi, Japan | ||
2020-12-25 | Malaysia | Melaka | 922 | 6 | 420 | 496 | 2.1896 | 102.2501 | 2020-12-26 05:22:28 | Melaka, Malaysia | ||
2020-12-24 | Malaysia | Melaka | 908 | 6 | 420 | 482 | 2.1896 | 102.2501 | 2020-12-25 05:22:48 | Melaka, Malaysia | ||
2020-12-16 | Malaysia | Kelantan | 472 | 6 | 420 | 46 | 6.1254 | 102.2381 | 2020-12-17 05:28:12 | Kelantan, Malaysia | ||
2020-12-07 | Japan | Toyama | 462 | 26 | 420 | 16 | 36.637464 | 137.26934599999998 | 2020-12-08 05:27:42 | Toyama, Japan | ||
2020-11-27 | Japan | Fukushima | 490 | 6 | 420 | 64 | 37.378867 | 140.223295 | 2020-11-28 05:25:50 | Fukushima, Japan | ||
2020-11-12 | China | Fujian | 460 | 1 | 420 | 39 | 26.0789 | 117.9874 | 2020-11-13 05:25:30 | Fujian, China | ||
2020-11-11 | China | Fujian | 460 | 1 | 420 | 39 | 26.0789 | 117.9874 | 2020-11-12 05:25:55 | Fujian, China | ||
2020-11-10 | China | Fujian | 459 | 1 | 420 | 38 | 26.0789 | 117.9874 | 2020-11-11 05:25:30 | Fujian, China | ||
2020-10-12 | Japan | Miyagi | 491 | 2 | 420 | 69 | 38.446859 | 140.927086 | 2020-10-13 04:24:02 | Miyagi, Japan | ||
2020-09-08 | Italy | Basilicata | 573 | 28 | 420 | 125 | 40.63947052 | 15.80514834 | 2020-09-09 04:28:48 | Basilicata, Italy | ||
2020-08-31 | Japan | Kumamoto | 520 | 7 | 420 | 93 | 32.608154 | 130.74523100000002 | 2020-09-01 04:28:31 | Kumamoto, Japan | ||
2020-08-25 | Japan | Hiroshima | 453 | 3 | 420 | 30 | 34.605309000000005 | 132.788719 | 2020-08-26 04:28:11 | Hiroshima, Japan | ||
2020-08-21 | India | Mizoram | 903 | 0 | 420 | 483 | 23.309381 | 92.83822 | 2020-08-22 04:27:49 | Mizoram, India | ||
2020-07-11 | Liberia | 963 | 47 | 420 | 496 | 6.4280550000000005 | -9.429499 | 2020-07-12 04:34:30 | Liberia | |||
2020-06-29 | Russia | Kurgan Oblast | 753 | 1 | 420 | 332 | 55.7655302 | 64.5632681 | 2020-06-30 04:33:48 | Kurgan Oblast, Russia | ||
2020-06-27 | India | Goa | 1128 | 2 | 420 | 706 | 15.359682000000001 | 74.057396 | 2020-06-28 04:34:04 | Goa, India | ||
2020-06-20 | Central African Republic | 2686 | 19 | 420 | 2247 | 6.6111 | 20.9394 | 2020-06-21 04:33:19 | Central African Republic | |||
2020-06-17 | Uganda | 732 | 0 | 420 | 312 | 1.373333 | 32.290275 | 2020-06-18 04:33:18 | Uganda | |||
2020-06-14 | Jamaica | 617 | 10 | 420 | 187 | 18.1096 | -77.2975 | 2020-06-15 03:33:14 | Jamaica | |||
2020-06-13 | Jamaica | 615 | 10 | 420 | 185 | 18.1096 | -77.2975 | 2020-06-14 03:33:15 | Jamaica | |||
2020-06-05 | Russia | Pskov Oblast | 1131 | 11 | 420 | 700 | 57.535872899999994 | 28.8586826 | 2020-06-06 02:33:00 | Pskov Oblast, Russia | ||
2020-06-02 | Russia | Kostroma Oblast | 804 | 11 | 420 | 373 | 58.424756 | 44.2533273 | 2020-06-03 02:33:13 | Kostroma Oblast, Russia | ||
2020-06-01 | Ukraine | Lviv Oblast | 1700 | 55 | 420 | 1225 | 49.8397 | 24.0297 | 2020-06-02 02:33:08 | Lviv Oblast, Ukraine | ||
2020-05-29 | Taiwan* | 442 | 7 | 420 | 15 | 23.7 | 121.0 | 2020-05-30 02:32:48 | Taiwan* | |||
2020-05-28 | Taiwan* | 441 | 7 | 420 | 14 | 23.7 | 121.0 | 2020-05-29 02:32:50 | Taiwan* | |||
2020-05-20 | Mexico | Chiapas | 808 | 53 | 420 | 335 | 16.7569 | -93.1292 | 2020-05-21 02:32:48 | Chiapas, Mexico | ||
2020-04-30 | Australia | South Australia | 438 | 4 | 420 | 14 | -34.9285 | 138.6007 | 2020-05-01 02:32:28 | South Australia, Australia | ||
2020-04-29 | Australia | South Australia | 438 | 4 | 420 | 14 | -34.9285 | 138.6007 | 2020-04-30 02:32:27 | South Australia, Australia | ||
2020-04-28 | Australia | South Australia | 438 | 4 | 420 | 14 | -34.9285 | 138.6007 | 2020-04-29 02:32:29 | South Australia, Australia | ||
2020-04-04 | Saudi Arabia | 2179 | 29 | 420 | 1730 | 23.885942 | 45.079162 | 4/4/20 23:34 | Saudi Arabia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;