daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

49 rows where country_or_region = "Japan" and last_update = "2020-07-24 05:30:40" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

country_or_region 1

  • Japan · 49 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-07-23 Japan Aichi     878 35 491 352 35.035551 137.211621 2020-07-24 05:30:40 Aichi, Japan
2020-07-23 Japan Akita     16 0 16 0 39.748679 140.408228 2020-07-24 05:30:40 Akita, Japan
2020-07-23 Japan Aomori     31 1 26 4 40.781541 140.828896 2020-07-24 05:30:40 Aomori, Japan
2020-07-23 Japan Chiba     1397 46 1038 313 35.510141 140.198917 2020-07-24 05:30:40 Chiba, Japan
2020-07-23 Japan Ehime     83 5 77 1 33.624835 132.856842 2020-07-24 05:30:40 Ehime, Japan
2020-07-23 Japan Fukui     127 8 115 4 35.846614 136.22465400000002 2020-07-24 05:30:40 Fukui, Japan
2020-07-23 Japan Fukuoka     1240 33 877 330 33.526032 130.666949 2020-07-24 05:30:40 Fukuoka, Japan
2020-07-23 Japan Fukushima     86 0 82 4 37.378867 140.223295 2020-07-24 05:30:40 Fukushima, Japan
2020-07-23 Japan Gifu     208 7 156 45 35.778671 137.055925 2020-07-24 05:30:40 Gifu, Japan
2020-07-23 Japan Gunma     177 19 138 20 36.504479 138.985605 2020-07-24 05:30:40 Gunma, Japan
2020-07-23 Japan Hiroshima     243 3 179 61 34.605309000000005 132.788719 2020-07-24 05:30:40 Hiroshima, Japan
2020-07-23 Japan Hokkaido     1371 103 1171 97 43.385711 142.552318 2020-07-24 05:30:40 Hokkaido, Japan
2020-07-23 Japan Hyogo     918 45 706 167 35.039913 134.828057 2020-07-24 05:30:40 Hyogo, Japan
2020-07-23 Japan Ibaraki     237 10 199 28 36.303588 140.319591 2020-07-24 05:30:40 Ibaraki, Japan
2020-07-23 Japan Ishikawa     307 27 270 10 36.769464 136.771027 2020-07-24 05:30:40 Ishikawa, Japan
2020-07-23 Japan Iwate     0 0 0 0 39.593287 141.361777 2020-07-24 05:30:40 Iwate, Japan
2020-07-23 Japan Kagawa     45 0 28 17 34.217292 133.969047 2020-07-24 05:30:40 Kagawa, Japan
2020-07-23 Japan Kagoshima     189 0 108 81 31.009484000000004 130.430665 2020-07-24 05:30:40 Kagoshima, Japan
2020-07-23 Japan Kanagawa     2158 98 1714 346 35.415312 139.338983 2020-07-24 05:30:40 Kanagawa, Japan
2020-07-23 Japan Kochi     77 3 72 2 33.422519 133.367307 2020-07-24 05:30:40 Kochi, Japan
2020-07-23 Japan Kumamoto     57 3 46 8 32.608154 130.74523100000002 2020-07-24 05:30:40 Kumamoto, Japan
2020-07-23 Japan Kyoto     624 18 422 184 35.253815 135.443341 2020-07-24 05:30:40 Kyoto, Japan
2020-07-23 Japan Mie     61 1 47 13 34.508018 136.376013 2020-07-24 05:30:40 Mie, Japan
2020-07-23 Japan Miyagi     140 1 113 26 38.446859 140.927086 2020-07-24 05:30:40 Miyagi, Japan
2020-07-23 Japan Miyazaki     27 0 18 9 32.193203999999994 131.299374 2020-07-24 05:30:40 Miyazaki, Japan
2020-07-23 Japan Nagano     86 0 77 9 36.132134 138.045528 2020-07-24 05:30:40 Nagano, Japan
2020-07-23 Japan Nagasaki     50 1 17 32 33.235712 129.608033 2020-07-24 05:30:40 Nagasaki, Japan
2020-07-23 Japan Nara     180 2 122 56 34.317451 135.871644 2020-07-24 05:30:40 Nara, Japan
2020-07-23 Japan Niigata     91 0 85 6 37.521819 138.918647 2020-07-24 05:30:40 Niigata, Japan
2020-07-23 Japan Oita     60 1 59 0 33.200697 131.43323999999998 2020-07-24 05:30:40 Oita, Japan
2020-07-23 Japan Okayama     45 0 31 14 34.89246 133.826252 2020-07-24 05:30:40 Okayama, Japan
2020-07-23 Japan Okinawa     162 7 143 12 25.768923 126.668016 2020-07-24 05:30:40 Okinawa, Japan
2020-07-23 Japan Osaka     2766 86 2012 668 34.620965000000005 135.507481 2020-07-24 05:30:40 Osaka, Japan
2020-07-23 Japan Port Quarantine     507 1 233 273     2020-07-24 05:30:40 Port Quarantine, Japan
2020-07-23 Japan Saga     57 0 47 10 33.286977 130.115738 2020-07-24 05:30:40 Saga, Japan
2020-07-23 Japan Saitama     1952 71 1377 504 35.997101 139.347635 2020-07-24 05:30:40 Saitama, Japan
2020-07-23 Japan Shiga     145 1 104 40 35.21582700000001 136.138064 2020-07-24 05:30:40 Shiga, Japan
2020-07-23 Japan Shimane     26 0 24 2 35.07076 132.55406399999998 2020-07-24 05:30:40 Shimane, Japan
2020-07-23 Japan Shizuoka     124 1 89 34 34.916975 138.40778400000002 2020-07-24 05:30:40 Shizuoka, Japan
2020-07-23 Japan Tochigi     147 0 95 52 36.689912 139.819213 2020-07-24 05:30:40 Tochigi, Japan
2020-07-23 Japan Tokushima     10 1 4 5 33.919178 134.242091 2020-07-24 05:30:40 Tokushima, Japan
2020-07-23 Japan Tokyo     10419 327 7767 2325 35.711343 139.446921 2020-07-24 05:30:40 Tokyo, Japan
2020-07-23 Japan Tottori     5 0 4 1 35.359069 133.863619 2020-07-24 05:30:40 Tottori, Japan
2020-07-23 Japan Toyama     235 22 206 7 36.637464 137.26934599999998 2020-07-24 05:30:40 Toyama, Japan
2020-07-23 Japan Unknown     8 0 8 0     2020-07-24 05:30:40 Unknown, Japan
2020-07-23 Japan Wakayama     109 3 81 25 33.911879 135.505446 2020-07-24 05:30:40 Wakayama, Japan
2020-07-23 Japan Yamagata     75 1 72 2 38.448396 140.102154 2020-07-24 05:30:40 Yamagata, Japan
2020-07-23 Japan Yamaguchi     47 0 37 10 34.201190000000004 131.573293 2020-07-24 05:30:40 Yamaguchi, Japan
2020-07-23 Japan Yamanashi     85 1 75 9 35.612364 138.61148899999998 2020-07-24 05:30:40 Yamanashi, Japan

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;