johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

2,383 rows where country_or_region = "Japan" sorted by day descending

View and edit SQL

province_or_state

country_or_region

  • Japan · 2,383
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
180813 2020-07-13 Japan Aichi     531 34 483 14 35.035551 137.211621 2020-07-14 04:34:46 Aichi, Japan
180814 2020-07-13 Japan Akita     16 0 16 0 39.748678999999996 140.408228 2020-07-14 04:34:46 Akita, Japan
180832 2020-07-13 Japan Aomori     33 1 26 6 40.781541 140.828896 2020-07-14 04:34:46 Aomori, Japan
180905 2020-07-13 Japan Chiba     1162 46 921 195 35.510141 140.198917 2020-07-14 04:34:46 Chiba, Japan
180930 2020-07-13 Japan Ehime     82 5 77 0 33.624835 132.856842 2020-07-14 04:34:46 Ehime, Japan
180941 2020-07-13 Japan Fukui     124 8 114 2 35.846614 136.22465400000002 2020-07-14 04:34:46 Fukui, Japan
180942 2020-07-13 Japan Fukuoka     920 33 818 69 33.526032 130.666949 2020-07-14 04:34:46 Fukuoka, Japan
180943 2020-07-13 Japan Fukushima     83 0 82 1 37.378867 140.223295 2020-07-14 04:34:46 Fukushima, Japan
180948 2020-07-13 Japan Gifu     164 7 148 9 35.778671 137.055925 2020-07-14 04:34:46 Gifu, Japan
180965 2020-07-13 Japan Gunma     157 19 134 4 36.504478999999996 138.985605 2020-07-14 04:34:46 Gunma, Japan
180976 2020-07-13 Japan Hiroshima     180 3 166 11 34.605309000000005 132.788719 2020-07-14 04:34:46 Hiroshima, Japan
180977 2020-07-13 Japan Hokkaido     1287 102 1130 55 43.385711 142.55231799999999 2020-07-14 04:34:46 Hokkaido, Japan
180984 2020-07-13 Japan Hyogo     739 45 662 32 35.039913 134.828057 2020-07-14 04:34:46 Hyogo, Japan
180985 2020-07-13 Japan Ibaraki     202 10 169 23 36.303588 140.319591 2020-07-14 04:34:46 Ibaraki, Japan
180990 2020-07-13 Japan Ishikawa     300 27 267 6 36.769464 136.771027 2020-07-14 04:34:46 Ishikawa, Japan
181006 2020-07-13 Japan Kagawa     30 0 28 2 34.217292 133.969047 2020-07-14 04:34:46 Kagawa, Japan
181007 2020-07-13 Japan Kagoshima     150 0 11 139 31.009484000000004 130.430665 2020-07-14 04:34:46 Kagoshima, Japan
181013 2020-07-13 Japan Kanagawa     1760 98 1488 174 35.415312 139.338983 2020-07-14 04:34:46 Kanagawa, Japan
181030 2020-07-13 Japan Kochi     75 3 71 1 33.422519 133.367307 2020-07-14 04:34:46 Kochi, Japan
181036 2020-07-13 Japan Kumamoto     48 3 45 0 32.608154 130.74523100000002 2020-07-14 04:34:46 Kumamoto, Japan
181039 2020-07-13 Japan Kyoto     456 18 362 76 35.253815 135.443341 2020-07-14 04:34:46 Kyoto, Japan
181082 2020-07-13 Japan Mie     49 1 45 3 34.508018 136.376013 2020-07-14 04:34:46 Mie, Japan
181084 2020-07-13 Japan Miyagi     108 1 94 13 38.446859 140.927086 2020-07-14 04:34:46 Miyagi, Japan
181085 2020-07-13 Japan Miyazaki     20 0 17 3 32.193203999999994 131.299374 2020-07-14 04:34:46 Miyazaki, Japan
181098 2020-07-13 Japan Nagano     78 0 76 2 36.132134 138.045528 2020-07-14 04:34:46 Nagano, Japan
181099 2020-07-13 Japan Nagasaki     30 1 17 12 33.235712 129.608033 2020-07-14 04:34:46 Nagasaki, Japan
181100 2020-07-13 Japan Nara     123 2 90 31 34.317451 135.871644 2020-07-14 04:34:46 Nara, Japan
181110 2020-07-13 Japan Niigata     86 0 83 3 37.521819 138.918647 2020-07-14 04:34:46 Niigata, Japan
181130 2020-07-13 Japan Oita     60 1 59 0 33.200697 131.43323999999998 2020-07-14 04:34:46 Oita, Japan
181131 2020-07-13 Japan Okayama     28 0 26 2 34.89246 133.826252 2020-07-14 04:34:46 Okayama, Japan
181132 2020-07-13 Japan Okinawa     151 7 139 5 25.768923 126.668016 2020-07-14 04:34:46 Okinawa, Japan
181138 2020-07-13 Japan Osaka     2045 86 1777 182 34.620965000000005 135.507481 2020-07-14 04:34:46 Osaka, Japan
181154 2020-07-13 Japan Port Quarantine     414 1 201 212     2020-07-14 04:34:46 Port Quarantine, Japan
181188 2020-07-13 Japan Saga     45 0 45 0 33.286977 130.115738 2020-07-14 04:34:46 Saga, Japan
181192 2020-07-13 Japan Saitama     1488 67 1087 334 35.997101 139.347635 2020-07-14 04:34:46 Saitama, Japan
181213 2020-07-13 Japan Shiga     106 1 100 5 35.21582700000001 136.13806399999999 2020-07-14 04:34:46 Shiga, Japan
181214 2020-07-13 Japan Shimane     24 0 24 0 35.07076 132.55406399999998 2020-07-14 04:34:46 Shimane, Japan
181215 2020-07-13 Japan Shizuoka     95 1 82 12 34.916975 138.40778400000002 2020-07-14 04:34:46 Shizuoka, Japan
181248 2020-07-13 Japan Tochigi     98 0 82 16 36.689912 139.819213 2020-07-14 04:34:46 Tochigi, Japan
181249 2020-07-13 Japan Tokushima     10 1 4 5 33.919178 134.242091 2020-07-14 04:34:46 Tokushima, Japan
181250 2020-07-13 Japan Tokyo     8056 325 6336 1395 35.711343 139.446921 2020-07-14 04:34:46 Tokyo, Japan
181254 2020-07-13 Japan Tottori     5 0 3 2 35.359069 133.863619 2020-07-14 04:34:46 Tottori, Japan
181255 2020-07-13 Japan Toyama     230 22 205 3 36.637464 137.26934599999998 2020-07-14 04:34:46 Toyama, Japan
181271 2020-07-13 Japan Unknown     8 0 8 0     2020-07-14 04:34:46 Unknown, Japan
181298 2020-07-13 Japan Wakayama     83 3 61 19 33.911879 135.505446 2020-07-14 04:34:46 Wakayama, Japan
181303 2020-07-13 Japan Yamagata     73 1 68 4 38.448396 140.102154 2020-07-14 04:34:46 Yamagata, Japan
181304 2020-07-13 Japan Yamaguchi     37 0 37 0 34.201190000000004 131.573293 2020-07-14 04:34:46 Yamaguchi, Japan
181306 2020-07-13 Japan Yamanashi     76 1 74 1 35.612364 138.61148899999998 2020-07-14 04:34:46 Yamanashi, Japan
321518 2020-07-12 Japan Aichi     529 34 482 13 35.035551 137.211621 2020-07-13 04:43:04 Aichi, Japan
321519 2020-07-12 Japan Akita     16 0 16 0 39.748678999999996 140.408228 2020-07-13 04:43:04 Akita, Japan
321537 2020-07-12 Japan Aomori     33 1 26 6 40.781541 140.828896 2020-07-13 04:43:04 Aomori, Japan
321610 2020-07-12 Japan Chiba     1122 46 914 162 35.510141 140.198917 2020-07-13 04:43:04 Chiba, Japan
321635 2020-07-12 Japan Ehime     82 5 77 0 33.624835 132.856842 2020-07-13 04:43:04 Ehime, Japan
321646 2020-07-12 Japan Fukui     124 8 114 2 35.846614 136.22465400000002 2020-07-13 04:43:04 Fukui, Japan
321647 2020-07-12 Japan Fukuoka     918 33 817 68 33.526032 130.666949 2020-07-13 04:43:04 Fukuoka, Japan
321648 2020-07-12 Japan Fukushima     83 0 82 1 37.378867 140.223295 2020-07-13 04:43:04 Fukushima, Japan
321653 2020-07-12 Japan Gifu     162 7 148 7 35.778671 137.055925 2020-07-13 04:43:04 Gifu, Japan
321671 2020-07-12 Japan Gunma     155 19 133 3 36.504478999999996 138.985605 2020-07-13 04:43:04 Gunma, Japan
321682 2020-07-12 Japan Hiroshima     176 3 166 7 34.605309000000005 132.788719 2020-07-13 04:43:04 Hiroshima, Japan
321683 2020-07-12 Japan Hokkaido     1285 101 1126 58 43.385711 142.55231799999999 2020-07-13 04:43:04 Hokkaido, Japan
321690 2020-07-12 Japan Hyogo     738 45 662 31 35.039913 134.828057 2020-07-13 04:43:04 Hyogo, Japan
321691 2020-07-12 Japan Ibaraki     199 10 167 22 36.303588 140.319591 2020-07-13 04:43:04 Ibaraki, Japan
321696 2020-07-12 Japan Ishikawa     300 27 267 6 36.769464 136.771027 2020-07-13 04:43:04 Ishikawa, Japan
321712 2020-07-12 Japan Kagawa     29 0 28 1 34.217292 133.969047 2020-07-13 04:43:04 Kagawa, Japan
321713 2020-07-12 Japan Kagoshima     145 0 11 134 31.009484000000004 130.430665 2020-07-13 04:43:04 Kagoshima, Japan
321719 2020-07-12 Japan Kanagawa     1743 98 1464 181 35.415312 139.338983 2020-07-13 04:43:04 Kanagawa, Japan
321736 2020-07-12 Japan Kochi     75 3 71 1 33.422519 133.367307 2020-07-13 04:43:04 Kochi, Japan
321742 2020-07-12 Japan Kumamoto     48 3 45 0 32.608154 130.74523100000002 2020-07-13 04:43:04 Kumamoto, Japan
321745 2020-07-12 Japan Kyoto     447 18 362 67 35.253815 135.443341 2020-07-13 04:43:04 Kyoto, Japan
321788 2020-07-12 Japan Mie     49 1 45 3 34.508018 136.376013 2020-07-13 04:43:04 Mie, Japan
321790 2020-07-12 Japan Miyagi     106 1 92 13 38.446859 140.927086 2020-07-13 04:43:04 Miyagi, Japan
321791 2020-07-12 Japan Miyazaki     20 0 17 3 32.193203999999994 131.299374 2020-07-13 04:43:04 Miyazaki, Japan
321804 2020-07-12 Japan Nagano     77 0 76 1 36.132134 138.045528 2020-07-13 04:43:04 Nagano, Japan
321805 2020-07-12 Japan Nagasaki     26 1 17 8 33.235712 129.608033 2020-07-13 04:43:04 Nagasaki, Japan
321806 2020-07-12 Japan Nara     119 2 90 27 34.317451 135.871644 2020-07-13 04:43:04 Nara, Japan
321816 2020-07-12 Japan Niigata     86 0 83 3 37.521819 138.918647 2020-07-13 04:43:04 Niigata, Japan
321836 2020-07-12 Japan Oita     60 1 59 0 33.200697 131.43323999999998 2020-07-13 04:43:04 Oita, Japan
321837 2020-07-12 Japan Okayama     28 0 26 2 34.89246 133.826252 2020-07-13 04:43:04 Okayama, Japan
321838 2020-07-12 Japan Okinawa     151 7 139 5 25.768923 126.668016 2020-07-13 04:43:04 Okinawa, Japan
321844 2020-07-12 Japan Osaka     2027 86 1777 164 34.620965000000005 135.507481 2020-07-13 04:43:04 Osaka, Japan
321860 2020-07-12 Japan Port Quarantine     401 1 201 199     2020-07-13 04:43:04 Port Quarantine, Japan
321894 2020-07-12 Japan Saga     45 0 45 0 33.286977 130.115738 2020-07-13 04:43:04 Saga, Japan
321898 2020-07-12 Japan Saitama     1462 67 1083 312 35.997101 139.347635 2020-07-13 04:43:04 Saitama, Japan
321919 2020-07-12 Japan Shiga     106 1 100 5 35.21582700000001 136.13806399999999 2020-07-13 04:43:04 Shiga, Japan
321920 2020-07-12 Japan Shimane     24 0 24 0 35.07076 132.55406399999998 2020-07-13 04:43:04 Shimane, Japan
321921 2020-07-12 Japan Shizuoka     95 1 82 12 34.916975 138.40778400000002 2020-07-13 04:43:04 Shizuoka, Japan
321954 2020-07-12 Japan Tochigi     95 0 82 13 36.689912 139.819213 2020-07-13 04:43:04 Tochigi, Japan
321955 2020-07-12 Japan Tokushima     10 1 4 5 33.919178 134.242091 2020-07-13 04:43:04 Tokushima, Japan
321956 2020-07-12 Japan Tokyo     7937 325 6169 1443 35.711343 139.446921 2020-07-13 04:43:04 Tokyo, Japan
321960 2020-07-12 Japan Tottori     5 0 3 2 35.359069 133.863619 2020-07-13 04:43:04 Tottori, Japan
321961 2020-07-12 Japan Toyama     230 22 205 3 36.637464 137.26934599999998 2020-07-13 04:43:04 Toyama, Japan
321977 2020-07-12 Japan Unknown     8 0 8 0     2020-07-13 04:43:04 Unknown, Japan
322004 2020-07-12 Japan Wakayama     80 3 61 16 33.911879 135.505446 2020-07-13 04:43:04 Wakayama, Japan
322009 2020-07-12 Japan Yamagata     72 1 68 3 38.448396 140.102154 2020-07-13 04:43:04 Yamagata, Japan
322010 2020-07-12 Japan Yamaguchi     37 0 37 0 34.201190000000004 131.573293 2020-07-13 04:43:04 Yamaguchi, Japan
322012 2020-07-12 Japan Yamanashi     76 1 74 1 35.612364 138.61148899999998 2020-07-13 04:43:04 Yamanashi, Japan
274910 2020-07-11 Japan Aichi     529 34 481 14 35.035551 137.211621 2020-07-12 04:34:30 Aichi, Japan
274911 2020-07-11 Japan Akita     16 0 16 0 39.748678999999996 140.408228 2020-07-12 04:34:30 Akita, Japan
274929 2020-07-11 Japan Aomori     33 1 26 6 40.781541 140.828896 2020-07-12 04:34:30 Aomori, Japan
275002 2020-07-11 Japan Chiba     1091 46 906 139 35.510141 140.198917 2020-07-12 04:34:30 Chiba, Japan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2410.504ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette