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 = "2021-04-14 04:20:41" 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
2021-04-13 Japan Aichi     29132 604 26805 1723 35.035551 137.211621 2021-04-14 04:20:41 Aichi, Japan
2021-04-13 Japan Akita     341 9 286 46 39.748679 140.408228 2021-04-14 04:20:41 Akita, Japan
2021-04-13 Japan Aomori     1196 20 1035 141 40.781541 140.828896 2021-04-14 04:20:41 Aomori, Japan
2021-04-13 Japan Chiba     30896 594 29263 1039 35.510141 140.198917 2021-04-14 04:20:41 Chiba, Japan
2021-04-13 Japan Ehime     1746 25 1372 349 33.624835 132.856842 2021-04-14 04:20:41 Ehime, Japan
2021-04-13 Japan Fukui     665 27 558 80 35.846614 136.22465400000002 2021-04-14 04:20:41 Fukui, Japan
2021-04-13 Japan Fukuoka     19592 341 18638 613 33.526032 130.666949 2021-04-14 04:20:41 Fukuoka, Japan
2021-04-13 Japan Fukushima     2830 118 2405 307 37.378867 140.223295 2021-04-14 04:20:41 Fukushima, Japan
2021-04-13 Japan Gifu     5064 129 4855 80 35.778671 137.055925 2021-04-14 04:20:41 Gifu, Japan
2021-04-13 Japan Gunma     5309 101 4969 239 36.504479 138.985605 2021-04-14 04:20:41 Gunma, Japan
2021-04-13 Japan Hiroshima     5302 107 5067 128 34.605309000000005 132.788719 2021-04-14 04:20:41 Hiroshima, Japan
2021-04-13 Japan Hokkaido     21898 783 20190 925 43.385711 142.552318 2021-04-14 04:20:41 Hokkaido, Japan
2021-04-13 Japan Hyogo     23283 608 19624 3051 35.039913 134.828057 2021-04-14 04:20:41 Hyogo, Japan
2021-04-13 Japan Ibaraki     7160 129 6678 353 36.303588 140.319591 2021-04-14 04:20:41 Ibaraki, Japan
2021-04-13 Japan Ishikawa     2073 66 1867 140 36.769464 136.771027 2021-04-14 04:20:41 Ishikawa, Japan
2021-04-13 Japan Iwate     763 30 633 100 39.593287 141.361777 2021-04-14 04:20:41 Iwate, Japan
2021-04-13 Japan Kagawa     1001 19 835 147 34.217292 133.969047 2021-04-14 04:20:41 Kagawa, Japan
2021-04-13 Japan Kagoshima     1926 28 1836 62 31.009484000000004 130.430665 2021-04-14 04:20:41 Kagoshima, Japan
2021-04-13 Japan Kanagawa     49755 800 47706 1249 35.415312 139.338983 2021-04-14 04:20:41 Kanagawa, Japan
2021-04-13 Japan Kochi     946 19 910 17 33.422519 133.367307 2021-04-14 04:20:41 Kochi, Japan
2021-04-13 Japan Kumamoto     3551 74 3434 43 32.608154 130.74523100000002 2021-04-14 04:20:41 Kumamoto, Japan
2021-04-13 Japan Kyoto     10384 176 9461 747 35.253815 135.443341 2021-04-14 04:20:41 Kyoto, Japan
2021-04-13 Japan Mie     3034 74 2790 170 34.508018 136.376013 2021-04-14 04:20:41 Mie, Japan
2021-04-13 Japan Miyagi     7272 44 6060 1168 38.446859 140.927086 2021-04-14 04:20:41 Miyagi, Japan
2021-04-13 Japan Miyazaki     2021 22 1938 61 32.193203999999994 131.299374 2021-04-14 04:20:41 Miyazaki, Japan
2021-04-13 Japan Nagano     3250 47 2876 327 36.132134 138.045528 2021-04-14 04:20:41 Nagano, Japan
2021-04-13 Japan Nagasaki     1674 39 1597 38 33.235712 129.608033 2021-04-14 04:20:41 Nagasaki, Japan
2021-04-13 Japan Nara     4550 57 3823 670 34.317451 135.871644 2021-04-14 04:20:41 Nara, Japan
2021-04-13 Japan Niigata     1769 18 1435 316 37.521819 138.918647 2021-04-14 04:20:41 Niigata, Japan
2021-04-13 Japan Oita     1353 22 1287 44 33.200697 131.43323999999998 2021-04-14 04:20:41 Oita, Japan
2021-04-13 Japan Okayama     2991 35 2603 353 34.89246 133.826252 2021-04-14 04:20:41 Okayama, Japan
2021-04-13 Japan Okinawa     10845 130 9488 1227 25.768923 126.668016 2021-04-14 04:20:41 Okinawa, Japan
2021-04-13 Japan Osaka     62043 1227 50437 10379 34.620965000000005 135.507481 2021-04-14 04:20:41 Osaka, Japan
2021-04-13 Japan Port Quarantine     2537 3 2359 175     2021-04-14 04:20:41 Port Quarantine, Japan
2021-04-13 Japan Saga     1288 13 1212 63 33.286977 130.115738 2021-04-14 04:20:41 Saga, Japan
2021-04-13 Japan Saitama     34580 720 32227 1633 35.997101 139.347635 2021-04-14 04:20:41 Saitama, Japan
2021-04-13 Japan Shiga     3016 59 2744 213 35.21582700000001 136.138064 2021-04-14 04:20:41 Shiga, Japan
2021-04-13 Japan Shimane     293 0 286 7 35.07076 132.55406399999998 2021-04-14 04:20:41 Shimane, Japan
2021-04-13 Japan Shizuoka     5995 121 5660 214 34.916975 138.40778400000002 2021-04-14 04:20:41 Shizuoka, Japan
2021-04-13 Japan Tochigi     4954 70 4649 235 36.689912 139.819213 2021-04-14 04:20:41 Tochigi, Japan
2021-04-13 Japan Tokushima     736 24 522 190 33.919178 134.242091 2021-04-14 04:20:41 Tokushima, Japan
2021-04-13 Japan Tokyo     126787 1811 120485 4491 35.711343 139.446921 2021-04-14 04:20:41 Tokyo, Japan
2021-04-13 Japan Tottori     311 2 220 89 35.359069 133.863619 2021-04-14 04:20:41 Tottori, Japan
2021-04-13 Japan Toyama     1055 29 912 114 36.637464 137.26934599999998 2021-04-14 04:20:41 Toyama, Japan
2021-04-13 Japan Unknown     8 0 8 0     2021-04-14 04:20:41 Unknown, Japan
2021-04-13 Japan Wakayama     1589 19 1287 283 33.911879 135.505446 2021-04-14 04:20:41 Wakayama, Japan
2021-04-13 Japan Yamagata     1242 22 935 285 38.448396 140.102154 2021-04-14 04:20:41 Yamagata, Japan
2021-04-13 Japan Yamaguchi     1468 43 1383 42 34.201190000000004 131.573293 2021-04-14 04:20:41 Yamaguchi, Japan
2021-04-13 Japan Yamanashi     1036 19 964 53 35.612364 138.61148899999998 2021-04-14 04:20:41 Yamanashi, Japan

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;