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-03 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-03 Japan Aichi     34528 636 29951 3941 35.035551 137.211621 2021-05-04 04:20:34 Aichi, Japan
2021-05-03 Japan Akita     506 9 381 116 39.748679 140.408228 2021-05-04 04:20:34 Akita, Japan
2021-05-03 Japan Aomori     1632 23 1318 291 40.781541 140.828896 2021-05-04 04:20:34 Aomori, Japan
2021-05-03 Japan Chiba     33618 625 31485 1508 35.510141 140.198917 2021-05-04 04:20:34 Chiba, Japan
2021-05-03 Japan Ehime     2408 45 1984 379 33.624835 132.856842 2021-05-04 04:20:34 Ehime, Japan
2021-05-03 Japan Fukui     906 33 749 124 35.846614 136.22465400000002 2021-05-04 04:20:34 Fukui, Japan
2021-05-03 Japan Fukuoka     24475 361 20301 3813 33.526032 130.666949 2021-05-04 04:20:34 Fukuoka, Japan
2021-05-03 Japan Fukushima     3513 124 2966 423 37.378867 140.223295 2021-05-04 04:20:34 Fukushima, Japan
2021-05-03 Japan Gifu     5974 134 5387 453 35.778671 137.055925 2021-05-04 04:20:34 Gifu, Japan
2021-05-03 Japan Gunma     6236 104 5550 582 36.504479 138.985605 2021-05-04 04:20:34 Gunma, Japan
2021-05-03 Japan Hiroshima     6226 110 5478 638 34.605309000000005 132.788719 2021-05-04 04:20:34 Hiroshima, Japan
2021-05-03 Japan Hokkaido     24790 871 21795 2124 43.385711 142.552318 2021-05-04 04:20:34 Hokkaido, Japan
2021-05-03 Japan Hyogo     32906 704 26514 5688 35.039913 134.828057 2021-05-04 04:20:34 Hyogo, Japan
2021-05-03 Japan Ibaraki     8317 135 7588 594 36.303588 140.319591 2021-05-04 04:20:34 Ibaraki, Japan
2021-05-03 Japan Ishikawa     2589 75 2118 396 36.769464 136.771027 2021-05-04 04:20:34 Ishikawa, Japan
2021-05-03 Japan Iwate     988 32 780 176 39.593287 141.361777 2021-05-04 04:20:34 Iwate, Japan
2021-05-03 Japan Kagawa     1324 23 1094 207 34.217292 133.969047 2021-05-04 04:20:34 Kagawa, Japan
2021-05-03 Japan Kagoshima     2270 28 1999 243 31.009484000000004 130.430665 2021-05-04 04:20:34 Kagoshima, Japan
2021-05-03 Japan Kanagawa     54278 822 51341 2115 35.415312 139.338983 2021-05-04 04:20:34 Kanagawa, Japan
2021-05-03 Japan Kochi     1077 20 955 102 33.422519 133.367307 2021-05-04 04:20:34 Kochi, Japan
2021-05-03 Japan Kumamoto     4295 80 3654 561 32.608154 130.74523100000002 2021-05-04 04:20:34 Kumamoto, Japan
2021-05-03 Japan Kyoto     12954 187 10829 1938 35.253815 135.443341 2021-05-04 04:20:34 Kyoto, Japan
2021-05-03 Japan Mie     3899 87 3276 536 34.508018 136.376013 2021-05-04 04:20:34 Mie, Japan
2021-05-03 Japan Miyagi     8143 69 7606 468 38.446859 140.927086 2021-05-04 04:20:34 Miyagi, Japan
2021-05-03 Japan Miyazaki     2299 22 2043 234 32.193203999999994 131.299374 2021-05-04 04:20:34 Miyazaki, Japan
2021-05-03 Japan Nagano     3940 70 3589 281 36.132134 138.045528 2021-05-04 04:20:34 Nagano, Japan
2021-05-03 Japan Nagasaki     2165 41 1779 345 33.235712 129.608033 2021-05-04 04:20:34 Nagasaki, Japan
2021-05-03 Japan Nara     6330 77 5264 989 34.317451 135.871644 2021-05-04 04:20:34 Nara, Japan
2021-05-03 Japan Niigata     2384 25 1951 408 37.521819 138.918647 2021-05-04 04:20:34 Niigata, Japan
2021-05-03 Japan Oita     2003 26 1425 552 33.200697 131.43323999999998 2021-05-04 04:20:34 Oita, Japan
2021-05-03 Japan Okayama     4245 47 3157 1041 34.89246 133.826252 2021-05-04 04:20:34 Okayama, Japan
2021-05-03 Japan Okinawa     12643 137 11353 1153 25.768923 126.668016 2021-05-04 04:20:34 Okinawa, Japan
2021-05-03 Japan Osaka     84339 1532 61076 21731 34.620965000000005 135.507481 2021-05-04 04:20:34 Osaka, Japan
2021-05-03 Japan Port Quarantine     2749 3 2584 162     2021-05-04 04:20:34 Port Quarantine, Japan
2021-05-03 Japan Saga     1677 13 1387 277 33.286977 130.115738 2021-05-04 04:20:34 Saga, Japan
2021-05-03 Japan Saitama     38522 746 35134 2642 35.997101 139.347635 2021-05-04 04:20:34 Saitama, Japan
2021-05-03 Japan Shiga     3855 61 3218 576 35.21582700000001 136.138064 2021-05-04 04:20:34 Shiga, Japan
2021-05-03 Japan Shimane     357 0 314 43 35.07076 132.55406399999998 2021-05-04 04:20:34 Shimane, Japan
2021-05-03 Japan Shizuoka     6564 121 6072 371 34.916975 138.40778400000002 2021-05-04 04:20:34 Shizuoka, Japan
2021-05-03 Japan Tochigi     5420 71 5091 258 36.689912 139.819213 2021-05-04 04:20:34 Tochigi, Japan
2021-05-03 Japan Tokushima     1399 47 965 387 33.919178 134.242091 2021-05-04 04:20:34 Tokushima, Japan
2021-05-03 Japan Tokyo     141698 1898 132098 7702 35.711343 139.446921 2021-05-04 04:20:34 Tokyo, Japan
2021-05-03 Japan Tottori     375 2 316 57 35.359069 133.863619 2021-05-04 04:20:34 Tottori, Japan
2021-05-03 Japan Toyama     1361 29 1164 168 36.637464 137.26934599999998 2021-05-04 04:20:34 Toyama, Japan
2021-05-03 Japan Unknown     8 0 8 0     2021-05-04 04:20:34 Unknown, Japan
2021-05-03 Japan Wakayama     2236 33 1851 352 33.911879 135.505446 2021-05-04 04:20:34 Wakayama, Japan
2021-05-03 Japan Yamagata     1538 33 1326 179 38.448396 140.102154 2021-05-04 04:20:34 Yamagata, Japan
2021-05-03 Japan Yamaguchi     1901 46 1573 282 34.201190000000004 131.573293 2021-05-04 04:20:34 Yamaguchi, Japan
2021-05-03 Japan Yamanashi     1248 19 1076 153 35.612364 138.61148899999998 2021-05-04 04:20:34 Yamanashi, Japan

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;