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

47 rows where country_or_region = "Japan" and last_update = "2022-03-09 04:20:59" sorted by day descending

✎ View and edit SQL

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

country_or_region 1

  • Japan · 47 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-03-08 Japan Aichi     353432 1764 0   35.035551 137.211621 2022-03-09 04:20:59 Aichi, Japan
2022-03-08 Japan Akita     11289 40 0   39.748678999999996 140.408228 2022-03-09 04:20:59 Akita, Japan
2022-03-08 Japan Aomori     24925 71 0   40.781541 140.828896 2022-03-09 04:20:59 Aomori, Japan
2022-03-08 Japan Chiba     295591 1442 0   35.510141 140.198917 2022-03-09 04:20:59 Chiba, Japan
2022-03-08 Japan Ehime     19088 121 0   33.624835 132.856842 2022-03-09 04:20:59 Ehime, Japan
2022-03-08 Japan Fukui     15654 40 0   35.846614 136.22465400000002 2022-03-09 04:20:59 Fukui, Japan
2022-03-08 Japan Fukuoka     253947 1020 0   33.526032 130.666949 2022-03-09 04:20:59 Fukuoka, Japan
2022-03-08 Japan Fukushima     26899 189 0   37.378867 140.223295 2022-03-09 04:20:59 Fukushima, Japan
2022-03-08 Japan Gifu     57129 290 0   35.778671 137.055925 2022-03-09 04:20:59 Gifu, Japan
2022-03-08 Japan Gunma     56584 264 0   36.504478999999996 138.985605 2022-03-09 04:20:59 Gunma, Japan
2022-03-08 Japan Hiroshima     79421 418 0   34.605309000000005 132.788719 2022-03-09 04:20:59 Hiroshima, Japan
2022-03-08 Japan Hokkaido     186256 1829 0   43.385711 142.55231799999999 2022-03-09 04:20:59 Hokkaido, Japan
2022-03-08 Japan Hyogo     286082 1918 0   35.039913 134.828057 2022-03-09 04:20:59 Hyogo, Japan
2022-03-08 Japan Ibaraki     83990 322 0   36.303588 140.319591 2022-03-09 04:20:59 Ibaraki, Japan
2022-03-08 Japan Ishikawa     27802 176 0   36.769464 136.771027 2022-03-09 04:20:59 Ishikawa, Japan
2022-03-08 Japan Iwate     12850 64 0   39.593287 141.361777 2022-03-09 04:20:59 Iwate, Japan
2022-03-08 Japan Kagawa     21624 85 0   34.217292 133.969047 2022-03-09 04:20:59 Kagawa, Japan
2022-03-08 Japan Kagoshima     34301 136 0   31.009484000000004 130.430665 2022-03-09 04:20:59 Kagoshima, Japan
2022-03-08 Japan Kanagawa     499386 1818 0   35.415312 139.338983 2022-03-09 04:20:59 Kanagawa, Japan
2022-03-08 Japan Kochi     13493 88 0   33.422519 133.367307 2022-03-09 04:20:59 Kochi, Japan
2022-03-08 Japan Kumamoto     53580 251 0   32.608154 130.74523100000002 2022-03-09 04:20:59 Kumamoto, Japan
2022-03-08 Japan Kyoto     134182 500 0   35.253815 135.443341 2022-03-09 04:20:59 Kyoto, Japan
2022-03-08 Japan Mie     45265 255 0   34.508018 136.376013 2022-03-09 04:20:59 Mie, Japan
2022-03-08 Japan Miyagi     45457 154 0   38.446859 140.927086 2022-03-09 04:20:59 Miyagi, Japan
2022-03-08 Japan Miyazaki     20234 100 0   32.193203999999994 131.299374 2022-03-09 04:20:59 Miyazaki, Japan
2022-03-08 Japan Nagano     33725 156 0   36.132134 138.045528 2022-03-09 04:20:59 Nagano, Japan
2022-03-08 Japan Nagasaki     28701 111 0   33.235712 129.608033 2022-03-09 04:20:59 Nagasaki, Japan
2022-03-08 Japan Nara     61813 299 0   34.317451 135.871644 2022-03-09 04:20:59 Nara, Japan
2022-03-08 Japan Niigata     32160 80 0   37.521819 138.918647 2022-03-09 04:20:59 Niigata, Japan
2022-03-08 Japan Oita     26243 109 0   33.200697 131.43323999999998 2022-03-09 04:20:59 Oita, Japan
2022-03-08 Japan Okayama     52959 211 0   34.89246 133.826252 2022-03-09 04:20:59 Okayama, Japan
2022-03-08 Japan Okinawa     105878 430 0   25.768923 126.668016 2022-03-09 04:20:59 Okinawa, Japan
2022-03-08 Japan Osaka     700896 4166 0   34.620965000000005 135.507481 2022-03-09 04:20:59 Osaka, Japan
2022-03-08 Japan Saga     25874 67 0   33.286977 130.115738 2022-03-09 04:20:59 Saga, Japan
2022-03-08 Japan Saitama     346511 1227 0   35.997101 139.347635 2022-03-09 04:20:59 Saitama, Japan
2022-03-08 Japan Shiga     55320 158 0   35.21582700000001 136.13806399999999 2022-03-09 04:20:59 Shiga, Japan
2022-03-08 Japan Shimane     7197 8 0   35.07076 132.55406399999998 2022-03-09 04:20:59 Shimane, Japan
2022-03-08 Japan Shizuoka     98829 352 0   34.916975 138.40778400000002 2022-03-09 04:20:59 Shizuoka, Japan
2022-03-08 Japan Tochigi     50122 212 0   36.689912 139.819213 2022-03-09 04:20:59 Tochigi, Japan
2022-03-08 Japan Tokushima     12853 76 0   33.919178 134.242091 2022-03-09 04:20:59 Tokushima, Japan
2022-03-08 Japan Tokyo     1075696 3839 0   35.711343 139.446921 2022-03-09 04:20:59 Tokyo, Japan
2022-03-08 Japan Tottori     7502 10 0   35.359069 133.863619 2022-03-09 04:20:59 Tottori, Japan
2022-03-08 Japan Toyama     21299 68 0   36.637464 137.26934599999998 2022-03-09 04:20:59 Toyama, Japan
2022-03-08 Japan Wakayama     24433 106 0   33.911879 135.505446 2022-03-09 04:20:59 Wakayama, Japan
2022-03-08 Japan Yamagata     13207 73 0   38.448396 140.102154 2022-03-09 04:20:59 Yamagata, Japan
2022-03-08 Japan Yamaguchi     23370 144 0   34.201190000000004 131.573293 2022-03-09 04:20:59 Yamaguchi, Japan
2022-03-08 Japan Yamanashi     18563 56 0   35.612364 138.61148899999998 2022-03-09 04:20:59 Yamanashi, Japan

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;