johns_hopkins_csse_daily_reports

Table actions
⚠️ 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

25,262 rows where country_or_region = "Japan" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state

country_or_region

  • Japan · 25,262 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
32267 32267 2021-10-23 Japan Aichi     106557 1155 0   35.035551 137.211621 2021-10-24 04:21:22 Aichi, Japan
32268 32268 2021-10-23 Japan Akita     1899 27 0   39.748678999999996 140.408228 2021-10-24 04:21:22 Akita, Japan
32269 32269 2021-10-23 Japan Aomori     5889 38 0   40.781541 140.828896 2021-10-24 04:21:22 Aomori, Japan
32270 32270 2021-10-23 Japan Chiba     100286 1022 0   35.510141 140.198917 2021-10-24 04:21:22 Chiba, Japan
32271 32271 2021-10-23 Japan Ehime     5345 82 0   33.624835 132.856842 2021-10-24 04:21:22 Ehime, Japan
32272 32272 2021-10-23 Japan Fukui     3105 37 0   35.846614 136.22465400000002 2021-10-24 04:21:22 Fukui, Japan
32273 32273 2021-10-23 Japan Fukuoka     74423 622 0   33.526032 130.666949 2021-10-24 04:21:22 Fukuoka, Japan
32274 32274 2021-10-23 Japan Fukushima     9483 175 0   37.378867 140.223295 2021-10-24 04:21:22 Fukushima, Japan
32275 32275 2021-10-23 Japan Gifu     18726 217 0   35.778671 137.055925 2021-10-24 04:21:22 Gifu, Japan
32276 32276 2021-10-23 Japan Gunma     16763 177 0   36.504478999999996 138.985605 2021-10-24 04:21:22 Gunma, Japan
32277 32277 2021-10-23 Japan Hiroshima     22009 200 0   34.605309000000005 132.788719 2021-10-24 04:21:22 Hiroshima, Japan
32278 32278 2021-10-23 Japan Hokkaido     60676 1470 0   43.385711 142.55231799999999 2021-10-24 04:21:22 Hokkaido, Japan
32279 32279 2021-10-23 Japan Hyogo     78516 1394 0   35.039913 134.828057 2021-10-24 04:21:22 Hyogo, Japan
32280 32280 2021-10-23 Japan Ibaraki     24406 219 0   36.303588 140.319591 2021-10-24 04:21:22 Ibaraki, Japan
32281 32281 2021-10-23 Japan Ishikawa     7964 130 0   36.769464 136.771027 2021-10-24 04:21:22 Ishikawa, Japan
32282 32282 2021-10-23 Japan Iwate     3487 53 0   39.593287 141.361777 2021-10-24 04:21:22 Iwate, Japan
32283 32283 2021-10-23 Japan Kagawa     4700 38 0   34.217292 133.969047 2021-10-24 04:21:22 Kagawa, Japan
32284 32284 2021-10-23 Japan Kagoshima     9099 67 0   31.009484000000004 130.430665 2021-10-24 04:21:22 Kagoshima, Japan
32285 32285 2021-10-23 Japan Kanagawa     168904 1306 0   35.415312 139.338983 2021-10-24 04:21:22 Kanagawa, Japan
32286 32286 2021-10-23 Japan Kochi     4160 32 0   33.422519 133.367307 2021-10-24 04:21:22 Kochi, Japan
32287 32287 2021-10-23 Japan Kumamoto     14418 136 0   32.608154 130.74523100000002 2021-10-24 04:21:22 Kumamoto, Japan
32288 32288 2021-10-23 Japan Kyoto     35914 290 0   35.253815 135.443341 2021-10-24 04:21:22 Kyoto, Japan
32289 32289 2021-10-23 Japan Mie     14761 164 0   34.508018 136.376013 2021-10-24 04:21:22 Mie, Japan
32290 32290 2021-10-23 Japan Miyagi     16306 118 0   38.446859 140.927086 2021-10-24 04:21:22 Miyagi, Japan
32291 32291 2021-10-23 Japan Miyazaki     6138 41 0   32.193203999999994 131.299374 2021-10-24 04:21:22 Miyazaki, Japan
32292 32292 2021-10-23 Japan Nagano     8852 96 0   36.132134 138.045528 2021-10-24 04:21:22 Nagano, Japan
32293 32293 2021-10-23 Japan Nagasaki     6099 73 0   33.235712 129.608033 2021-10-24 04:21:22 Nagasaki, Japan
32294 32294 2021-10-23 Japan Nara     15576 150 0   34.317451 135.871644 2021-10-24 04:21:22 Nara, Japan
32295 32295 2021-10-23 Japan Niigata     7988 61 0   37.521819 138.918647 2021-10-24 04:21:22 Niigata, Japan
32296 32296 2021-10-23 Japan Oita     8197 84 0   33.200697 131.43323999999998 2021-10-24 04:21:22 Oita, Japan
32297 32297 2021-10-23 Japan Okayama     15251 136 0   34.89246 133.826252 2021-10-24 04:21:22 Okayama, Japan
32298 32298 2021-10-23 Japan Okinawa     50257 369 0   25.768923 126.668016 2021-10-24 04:21:22 Okinawa, Japan
32299 32299 2021-10-23 Japan Osaka     202100 3040 0   34.620965000000005 135.507481 2021-10-24 04:21:22 Osaka, Japan
32300 32300 2021-10-23 Japan Port Quarantine     4383 4 0       2021-10-24 04:21:22 Port Quarantine, Japan
32301 32301 2021-10-23 Japan Saga     5853 30 0   33.286977 130.115738 2021-10-24 04:21:22 Saga, Japan
32302 32302 2021-10-23 Japan Saitama     115637 1034 0   35.997101 139.347635 2021-10-24 04:21:22 Saitama, Japan
32303 32303 2021-10-23 Japan Shiga     12400 103 0   35.21582700000001 136.13806399999999 2021-10-24 04:21:22 Shiga, Japan
32304 32304 2021-10-23 Japan Shimane     1686 5 0   35.07076 132.55406399999998 2021-10-24 04:21:22 Shimane, Japan
32305 32305 2021-10-23 Japan Shizuoka     26770 209 0   34.916975 138.40778400000002 2021-10-24 04:21:22 Shizuoka, Japan
32306 32306 2021-10-23 Japan Tochigi     15455 116 0   36.689912 139.819213 2021-10-24 04:21:22 Tochigi, Japan
32307 32307 2021-10-23 Japan Tokushima     3284 65 0   33.919178 134.242091 2021-10-24 04:21:22 Tokushima, Japan
32308 32308 2021-10-23 Japan Tokyo     377467 3117 0   35.711343 139.446921 2021-10-24 04:21:22 Tokyo, Japan
32309 32309 2021-10-23 Japan Tottori     1666 5 0   35.359069 133.863619 2021-10-24 04:21:22 Tottori, Japan
32310 32310 2021-10-23 Japan Toyama     4865 51 0   36.637464 137.26934599999998 2021-10-24 04:21:22 Toyama, Japan
32311 32311 2021-10-23 Japan Unknown     8 0 0       2021-10-24 04:21:22 Unknown, Japan
32312 32312 2021-10-23 Japan Wakayama     5289 62 0   33.911879 135.505446 2021-10-24 04:21:22 Wakayama, Japan
32313 32313 2021-10-23 Japan Yamagata     3575 57 0   38.448396 140.102154 2021-10-24 04:21:22 Yamagata, Japan
32314 32314 2021-10-23 Japan Yamaguchi     5709 93 0   34.201190000000004 131.573293 2021-10-24 04:21:22 Yamaguchi, Japan
32315 32315 2021-10-23 Japan Yamanashi     5161 29 0   35.612364 138.61148899999998 2021-10-24 04:21:22 Yamanashi, Japan
312751 312751 2021-10-22 Japan Aichi     106535 1155 0   35.035551 137.211621 2021-10-23 04:21:32 Aichi, Japan
312752 312752 2021-10-22 Japan Akita     1896 27 0   39.748678999999996 140.408228 2021-10-23 04:21:32 Akita, Japan
312753 312753 2021-10-22 Japan Aomori     5888 38 0   40.781541 140.828896 2021-10-23 04:21:32 Aomori, Japan
312754 312754 2021-10-22 Japan Chiba     100273 1022 0   35.510141 140.198917 2021-10-23 04:21:32 Chiba, Japan
312755 312755 2021-10-22 Japan Ehime     5339 82 0   33.624835 132.856842 2021-10-23 04:21:32 Ehime, Japan
312756 312756 2021-10-22 Japan Fukui     3103 37 0   35.846614 136.22465400000002 2021-10-23 04:21:32 Fukui, Japan
312757 312757 2021-10-22 Japan Fukuoka     74415 622 0   33.526032 130.666949 2021-10-23 04:21:32 Fukuoka, Japan
312758 312758 2021-10-22 Japan Fukushima     9483 175 0   37.378867 140.223295 2021-10-23 04:21:32 Fukushima, Japan
312759 312759 2021-10-22 Japan Gifu     18720 217 0   35.778671 137.055925 2021-10-23 04:21:32 Gifu, Japan
312760 312760 2021-10-22 Japan Gunma     16761 177 0   36.504478999999996 138.985605 2021-10-23 04:21:32 Gunma, Japan
312761 312761 2021-10-22 Japan Hiroshima     22002 200 0   34.605309000000005 132.788719 2021-10-23 04:21:32 Hiroshima, Japan
312762 312762 2021-10-22 Japan Hokkaido     60671 1470 0   43.385711 142.55231799999999 2021-10-23 04:21:32 Hokkaido, Japan
312763 312763 2021-10-22 Japan Hyogo     78491 1394 0   35.039913 134.828057 2021-10-23 04:21:32 Hyogo, Japan
312764 312764 2021-10-22 Japan Ibaraki     24403 219 0   36.303588 140.319591 2021-10-23 04:21:32 Ibaraki, Japan
312765 312765 2021-10-22 Japan Ishikawa     7962 130 0   36.769464 136.771027 2021-10-23 04:21:32 Ishikawa, Japan
312766 312766 2021-10-22 Japan Iwate     3487 53 0   39.593287 141.361777 2021-10-23 04:21:32 Iwate, Japan
312767 312767 2021-10-22 Japan Kagawa     4699 38 0   34.217292 133.969047 2021-10-23 04:21:32 Kagawa, Japan
312768 312768 2021-10-22 Japan Kagoshima     9099 67 0   31.009484000000004 130.430665 2021-10-23 04:21:32 Kagoshima, Japan
312769 312769 2021-10-22 Japan Kanagawa     168895 1305 0   35.415312 139.338983 2021-10-23 04:21:32 Kanagawa, Japan
312770 312770 2021-10-22 Japan Kochi     4160 32 0   33.422519 133.367307 2021-10-23 04:21:32 Kochi, Japan
312771 312771 2021-10-22 Japan Kumamoto     14416 136 0   32.608154 130.74523100000002 2021-10-23 04:21:32 Kumamoto, Japan
312772 312772 2021-10-22 Japan Kyoto     35903 290 0   35.253815 135.443341 2021-10-23 04:21:32 Kyoto, Japan
312773 312773 2021-10-22 Japan Mie     14758 164 0   34.508018 136.376013 2021-10-23 04:21:32 Mie, Japan
312774 312774 2021-10-22 Japan Miyagi     16305 118 0   38.446859 140.927086 2021-10-23 04:21:32 Miyagi, Japan
312775 312775 2021-10-22 Japan Miyazaki     6138 41 0   32.193203999999994 131.299374 2021-10-23 04:21:32 Miyazaki, Japan
312776 312776 2021-10-22 Japan Nagano     8849 96 0   36.132134 138.045528 2021-10-23 04:21:32 Nagano, Japan
312777 312777 2021-10-22 Japan Nagasaki     6097 73 0   33.235712 129.608033 2021-10-23 04:21:32 Nagasaki, Japan
312778 312778 2021-10-22 Japan Nara     15572 150 0   34.317451 135.871644 2021-10-23 04:21:32 Nara, Japan
312779 312779 2021-10-22 Japan Niigata     7986 61 0   37.521819 138.918647 2021-10-23 04:21:32 Niigata, Japan
312780 312780 2021-10-22 Japan Oita     8197 84 0   33.200697 131.43323999999998 2021-10-23 04:21:32 Oita, Japan
312781 312781 2021-10-22 Japan Okayama     15249 136 0   34.89246 133.826252 2021-10-23 04:21:32 Okayama, Japan
312782 312782 2021-10-22 Japan Okinawa     50248 369 0   25.768923 126.668016 2021-10-23 04:21:32 Okinawa, Japan
312783 312783 2021-10-22 Japan Osaka     202054 3039 0   34.620965000000005 135.507481 2021-10-23 04:21:32 Osaka, Japan
312784 312784 2021-10-22 Japan Port Quarantine     4375 4 0       2021-10-23 04:21:32 Port Quarantine, Japan
312785 312785 2021-10-22 Japan Saga     5849 30 0   33.286977 130.115738 2021-10-23 04:21:32 Saga, Japan
312786 312786 2021-10-22 Japan Saitama     115619 1032 0   35.997101 139.347635 2021-10-23 04:21:32 Saitama, Japan
312787 312787 2021-10-22 Japan Shiga     12394 103 0   35.21582700000001 136.13806399999999 2021-10-23 04:21:32 Shiga, Japan
312788 312788 2021-10-22 Japan Shimane     1683 5 0   35.07076 132.55406399999998 2021-10-23 04:21:32 Shimane, Japan
312789 312789 2021-10-22 Japan Shizuoka     26768 209 0   34.916975 138.40778400000002 2021-10-23 04:21:32 Shizuoka, Japan
312790 312790 2021-10-22 Japan Tochigi     15453 116 0   36.689912 139.819213 2021-10-23 04:21:32 Tochigi, Japan
312791 312791 2021-10-22 Japan Tokushima     3283 65 0   33.919178 134.242091 2021-10-23 04:21:32 Tokushima, Japan
312792 312792 2021-10-22 Japan Tokyo     377435 3116 0   35.711343 139.446921 2021-10-23 04:21:32 Tokyo, Japan
312793 312793 2021-10-22 Japan Tottori     1666 5 0   35.359069 133.863619 2021-10-23 04:21:32 Tottori, Japan
312794 312794 2021-10-22 Japan Toyama     4862 51 0   36.637464 137.26934599999998 2021-10-23 04:21:32 Toyama, Japan
312795 312795 2021-10-22 Japan Unknown     8 0 0       2021-10-23 04:21:32 Unknown, Japan
312796 312796 2021-10-22 Japan Wakayama     5289 62 0   33.911879 135.505446 2021-10-23 04:21:32 Wakayama, Japan
312797 312797 2021-10-22 Japan Yamagata     3575 57 0   38.448396 140.102154 2021-10-23 04:21:32 Yamagata, Japan
312798 312798 2021-10-22 Japan Yamaguchi     5706 93 0   34.201190000000004 131.573293 2021-10-23 04:21:32 Yamaguchi, Japan
312799 312799 2021-10-22 Japan Yamanashi     5158 29 0   35.612364 138.61148899999998 2021-10-23 04:21:32 Yamanashi, Japan
2134773 2134773 2021-10-21 Japan Aichi     106499 1155 0   35.035551 137.211621 2021-10-22 04:21:14 Aichi, Japan
2134774 2134774 2021-10-21 Japan Akita     1896 27 0   39.748678999999996 140.408228 2021-10-22 04:21:14 Akita, 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
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);