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 day = "2020-07-25" 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-25 Japan Aichi     1020 35 498 487 35.035551 137.211621 2020-07-26 04:35:00 Aichi, Japan
2020-07-25 Japan Akita     17 0 16 1 39.748679 140.408228 2020-07-26 04:35:00 Akita, Japan
2020-07-25 Japan Aomori     31 1 26 4 40.781541 140.828896 2020-07-26 04:35:00 Aomori, Japan
2020-07-25 Japan Chiba     1444 46 1086 312 35.510141 140.198917 2020-07-26 04:35:00 Chiba, Japan
2020-07-25 Japan Ehime     84 5 77 2 33.624835 132.856842 2020-07-26 04:35:00 Ehime, Japan
2020-07-25 Japan Fukui     127 8 115 4 35.846614 136.22465400000002 2020-07-26 04:35:00 Fukui, Japan
2020-07-25 Japan Fukuoka     1341 33 893 415 33.526032 130.666949 2020-07-26 04:35:00 Fukuoka, Japan
2020-07-25 Japan Fukushima     86 0 82 4 37.378867 140.223295 2020-07-26 04:35:00 Fukushima, Japan
2020-07-25 Japan Gifu     220 7 159 54 35.778671 137.055925 2020-07-26 04:35:00 Gifu, Japan
2020-07-25 Japan Gunma     179 19 138 22 36.504479 138.985605 2020-07-26 04:35:00 Gunma, Japan
2020-07-25 Japan Hiroshima     257 3 188 66 34.605309000000005 132.788719 2020-07-26 04:35:00 Hiroshima, Japan
2020-07-25 Japan Hokkaido     1386 103 1181 102 43.385711 142.552318 2020-07-26 04:35:00 Hokkaido, Japan
2020-07-25 Japan Hyogo     965 45 745 175 35.039913 134.828057 2020-07-26 04:35:00 Hyogo, Japan
2020-07-25 Japan Ibaraki     239 10 201 28 36.303588 140.319591 2020-07-26 04:35:00 Ibaraki, Japan
2020-07-25 Japan Ishikawa     310 27 270 13 36.769464 136.771027 2020-07-26 04:35:00 Ishikawa, Japan
2020-07-25 Japan Iwate     0 0 0 0 39.593287 141.361777 2020-07-26 04:35:00 Iwate, Japan
2020-07-25 Japan Kagawa     45 0 28 17 34.217292 133.969047 2020-07-26 04:35:00 Kagawa, Japan
2020-07-25 Japan Kagoshima     211 0 125 86 31.009484000000004 130.430665 2020-07-26 04:35:00 Kagoshima, Japan
2020-07-25 Japan Kanagawa     2204 98 1787 319 35.415312 139.338983 2020-07-26 04:35:00 Kanagawa, Japan
2020-07-25 Japan Kochi     78 3 72 3 33.422519 133.367307 2020-07-26 04:35:00 Kochi, Japan
2020-07-25 Japan Kumamoto     60 3 46 11 32.608154 130.74523100000002 2020-07-26 04:35:00 Kumamoto, Japan
2020-07-25 Japan Kyoto     644 19 422 203 35.253815 135.443341 2020-07-26 04:35:00 Kyoto, Japan
2020-07-25 Japan Mie     65 1 49 15 34.508018 136.376013 2020-07-26 04:35:00 Mie, Japan
2020-07-25 Japan Miyagi     142 1 123 18 38.446859 140.927086 2020-07-26 04:35:00 Miyagi, Japan
2020-07-25 Japan Miyazaki     55 0 18 37 32.193203999999994 131.299374 2020-07-26 04:35:00 Miyazaki, Japan
2020-07-25 Japan Nagano     88 0 77 11 36.132134 138.045528 2020-07-26 04:35:00 Nagano, Japan
2020-07-25 Japan Nagasaki     51 2 16 33 33.235712 129.608033 2020-07-26 04:35:00 Nagasaki, Japan
2020-07-25 Japan Nara     196 2 126 68 34.317451 135.871644 2020-07-26 04:35:00 Nara, Japan
2020-07-25 Japan Niigata     91 0 85 6 37.521819 138.918647 2020-07-26 04:35:00 Niigata, Japan
2020-07-25 Japan Oita     60 1 59 0 33.200697 131.43323999999998 2020-07-26 04:35:00 Oita, Japan
2020-07-25 Japan Okayama     59 0 32 27 34.89246 133.826252 2020-07-26 04:35:00 Okayama, Japan
2020-07-25 Japan Okinawa     186 7 145 34 25.768923 126.668016 2020-07-26 04:35:00 Okinawa, Japan
2020-07-25 Japan Osaka     3047 88 2080 879 34.620965000000005 135.507481 2020-07-26 04:35:00 Osaka, Japan
2020-07-25 Japan Port Quarantine     523 1 233 289     2020-07-26 04:35:00 Port Quarantine, Japan
2020-07-25 Japan Saga     66 0 47 19 33.286977 130.115738 2020-07-26 04:35:00 Saga, Japan
2020-07-25 Japan Saitama     2032 72 1497 463 35.997101 139.347635 2020-07-26 04:35:00 Saitama, Japan
2020-07-25 Japan Shiga     152 1 105 46 35.21582700000001 136.138064 2020-07-26 04:35:00 Shiga, Japan
2020-07-25 Japan Shimane     28 0 24 4 35.07076 132.55406399999998 2020-07-26 04:35:00 Shimane, Japan
2020-07-25 Japan Shizuoka     161 1 89 71 34.916975 138.40778400000002 2020-07-26 04:35:00 Shizuoka, Japan
2020-07-25 Japan Tochigi     159 0 97 62 36.689912 139.819213 2020-07-26 04:35:00 Tochigi, Japan
2020-07-25 Japan Tokushima     12 1 6 5 33.919178 134.242091 2020-07-26 04:35:00 Tokushima, Japan
2020-07-25 Japan Tokyo     10974 328 7914 2732 35.711343 139.446921 2020-07-26 04:35:00 Tokyo, Japan
2020-07-25 Japan Tottori     6 0 4 2 35.359069 133.863619 2020-07-26 04:35:00 Tottori, Japan
2020-07-25 Japan Toyama     235 22 207 6 36.637464 137.26934599999998 2020-07-26 04:35:00 Toyama, Japan
2020-07-25 Japan Unknown     8 0 8 0     2020-07-26 04:35:00 Unknown, Japan
2020-07-25 Japan Wakayama     116 3 83 30 33.911879 135.505446 2020-07-26 04:35:00 Wakayama, Japan
2020-07-25 Japan Yamagata     75 1 72 2 38.448396 140.102154 2020-07-26 04:35:00 Yamagata, Japan
2020-07-25 Japan Yamaguchi     47 0 37 10 34.201190000000004 131.573293 2020-07-26 04:35:00 Yamaguchi, Japan
2020-07-25 Japan Yamanashi     86 1 76 9 35.612364 138.61148899999998 2020-07-26 04:35:00 Yamanashi, Japan

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;