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" is on date 2021-05-19 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-05-19 Japan Aichi     42305 691 34636 6978 35.035551 137.211621 2021-05-20 04:21:05 Aichi, Japan
2021-05-19 Japan Akita     718 11 563 144 39.748679 140.408228 2021-05-20 04:21:05 Akita, Japan
2021-05-19 Japan Aomori     2033 27 1702 304 40.781541 140.828896 2021-05-20 04:21:05 Aomori, Japan
2021-05-19 Japan Chiba     35820 658 33681 1481 35.510141 140.198917 2021-05-20 04:21:05 Chiba, Japan
2021-05-19 Japan Ehime     2643 67 2397 179 33.624835 132.856842 2021-05-20 04:21:05 Ehime, Japan
2021-05-19 Japan Fukui     1004 34 904 66 35.846614 136.22465400000002 2021-05-20 04:21:05 Fukui, Japan
2021-05-19 Japan Fukuoka     31359 400 24187 6772 33.526032 130.666949 2021-05-20 04:21:05 Fukuoka, Japan
2021-05-19 Japan Fukushima     4331 133 3624 574 37.378867 140.223295 2021-05-20 04:21:05 Fukushima, Japan
2021-05-19 Japan Gifu     7781 146 6519 1116 35.778671 137.055925 2021-05-20 04:21:05 Gifu, Japan
2021-05-19 Japan Gunma     7370 121 6524 725 36.504479 138.985605 2021-05-20 04:21:05 Gunma, Japan
2021-05-19 Japan Hiroshima     9006 116 6484 2406 34.605309000000005 132.788719 2021-05-20 04:21:05 Hiroshima, Japan
2021-05-19 Japan Hokkaido     31910 964 24565 6381 43.385711 142.552318 2021-05-20 04:21:05 Hokkaido, Japan
2021-05-19 Japan Hyogo     38145 1034 32648 4463 35.039913 134.828057 2021-05-20 04:21:05 Hyogo, Japan
2021-05-19 Japan Ibaraki     9184 139 8409 636 36.303588 140.319591 2021-05-20 04:21:05 Ibaraki, Japan
2021-05-19 Japan Ishikawa     3328 98 2594 636 36.769464 136.771027 2021-05-20 04:21:05 Ishikawa, Japan
2021-05-19 Japan Iwate     1275 42 1015 218 39.593287 141.361777 2021-05-20 04:21:05 Iwate, Japan
2021-05-19 Japan Kagawa     1857 24 1458 375 34.217292 133.969047 2021-05-20 04:21:05 Kagawa, Japan
2021-05-19 Japan Kagoshima     2986 28 2477 481 31.009484000000004 130.430665 2021-05-20 04:21:05 Kagoshima, Japan
2021-05-19 Japan Kanagawa     58586 861 55064 2661 35.415312 139.338983 2021-05-20 04:21:05 Kanagawa, Japan
2021-05-19 Japan Kochi     1188 20 1091 77 33.422519 133.367307 2021-05-20 04:21:05 Kochi, Japan
2021-05-19 Japan Kumamoto     5685 89 4484 1112 32.608154 130.74523100000002 2021-05-20 04:21:05 Kumamoto, Japan
2021-05-19 Japan Kyoto     15016 199 13025 1792 35.253815 135.443341 2021-05-20 04:21:05 Kyoto, Japan
2021-05-19 Japan Mie     4580 98 3948 534 34.508018 136.376013 2021-05-20 04:21:05 Mie, Japan
2021-05-19 Japan Miyagi     8641 80 8165 396 38.446859 140.927086 2021-05-20 04:21:05 Miyagi, Japan
2021-05-19 Japan Miyazaki     2881 25 2459 397 32.193203999999994 131.299374 2021-05-20 04:21:05 Miyazaki, Japan
2021-05-19 Japan Nagano     4463 76 4057 330 36.132134 138.045528 2021-05-20 04:21:05 Nagano, Japan
2021-05-19 Japan Nagasaki     2789 56 2255 478 33.235712 129.608033 2021-05-20 04:21:05 Nagasaki, Japan
2021-05-19 Japan Nara     7475 100 6663 712 34.317451 135.871644 2021-05-20 04:21:05 Nara, Japan
2021-05-19 Japan Niigata     2924 34 2463 427 37.521819 138.918647 2021-05-20 04:21:05 Niigata, Japan
2021-05-19 Japan Oita     3011 37 2208 766 33.200697 131.43323999999998 2021-05-20 04:21:05 Oita, Japan
2021-05-19 Japan Okayama     6508 76 4071 2361 34.89246 133.826252 2021-05-20 04:21:05 Okayama, Japan
2021-05-19 Japan Okinawa     14256 146 12413 1697 25.768923 126.668016 2021-05-20 04:21:05 Okinawa, Japan
2021-05-19 Japan Osaka     96127 2036 77575 16516 34.620965000000005 135.507481 2021-05-20 04:21:05 Osaka, Japan
2021-05-19 Japan Port Quarantine     2889 3 2732 154     2021-05-20 04:21:05 Port Quarantine, Japan
2021-05-19 Japan Saga     2321 16 1895 410 33.286977 130.115738 2021-05-20 04:21:05 Saga, Japan
2021-05-19 Japan Saitama     42064 770 38566 2728 35.997101 139.347635 2021-05-20 04:21:05 Saitama, Japan
2021-05-19 Japan Shiga     4633 74 3972 587 35.21582700000001 136.138064 2021-05-20 04:21:05 Shiga, Japan
2021-05-19 Japan Shimane     469 0 393 76 35.07076 132.55406399999998 2021-05-20 04:21:05 Shimane, Japan
2021-05-19 Japan Shizuoka     7659 131 6630 898 34.916975 138.40778400000002 2021-05-20 04:21:05 Shizuoka, Japan
2021-05-19 Japan Tochigi     5947 74 5491 382 36.689912 139.819213 2021-05-20 04:21:05 Tochigi, Japan
2021-05-19 Japan Tokushima     1595 58 1362 175 33.919178 134.242091 2021-05-20 04:21:05 Tokushima, Japan
2021-05-19 Japan Tokyo     154146 1984 144876 7286 35.711343 139.446921 2021-05-20 04:21:05 Tokyo, Japan
2021-05-19 Japan Tottori     442 2 378 62 35.359069 133.863619 2021-05-20 04:21:05 Tottori, Japan
2021-05-19 Japan Toyama     1582 33 1339 210 36.637464 137.26934599999998 2021-05-20 04:21:05 Toyama, Japan
2021-05-19 Japan Unknown     8 0 8 0     2021-05-20 04:21:05 Unknown, Japan
2021-05-19 Japan Wakayama     2517 36 2250 231 33.911879 135.505446 2021-05-20 04:21:05 Wakayama, Japan
2021-05-19 Japan Yamagata     1775 37 1524 214 38.448396 140.102154 2021-05-20 04:21:05 Yamagata, Japan
2021-05-19 Japan Yamaguchi     2562 55 1919 588 34.201190000000004 131.573293 2021-05-20 04:21:05 Yamaguchi, Japan
2021-05-19 Japan Yamanashi     1433 19 1267 147 35.612364 138.61148899999998 2021-05-20 04:21:05 Yamanashi, Japan

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;