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

11,787 rows where country_or_region = "Japan" sorted by day descending

View and edit SQL

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

province_or_state

country_or_region

  • Japan · 11,787
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
298607 2021-01-21 Japan Aichi     22204 346 17940 3918 35.035551 137.211621 2021-01-22 05:22:10 Aichi, Japan
298608 2021-01-21 Japan Akita     229 1 169 59 39.748679 140.408228 2021-01-22 05:22:10 Akita, Japan
298609 2021-01-21 Japan Aomori     666 9 570 87 40.781541 140.828896 2021-01-22 05:22:10 Aomori, Japan
298610 2021-01-21 Japan Chiba     19054 194 12708 6152 35.510141 140.198917 2021-01-22 05:22:10 Chiba, Japan
298611 2021-01-21 Japan Ehime     891 17 640 234 33.624835 132.856842 2021-01-22 05:22:10 Ehime, Japan
298612 2021-01-21 Japan Fukui     467 13 378 76 35.846614 136.22465400000002 2021-01-22 05:22:10 Fukui, Japan
298613 2021-01-21 Japan Fukuoka     14391 157 9832 4402 33.526032 130.666949 2021-01-22 05:22:10 Fukuoka, Japan
298614 2021-01-21 Japan Fukushima     1534 36 1161 337 37.378867 140.223295 2021-01-22 05:22:10 Fukushima, Japan
298615 2021-01-21 Japan Gifu     3730 59 2934 737 35.778671 137.055925 2021-01-22 05:22:10 Gifu, Japan
298616 2021-01-21 Japan Gunma     3492 64 2841 587 36.504479 138.985605 2021-01-22 05:22:10 Gunma, Japan
298617 2021-01-21 Japan Hiroshima     4533 77 3863 593 34.605309000000005 132.788719 2021-01-22 05:22:10 Hiroshima, Japan
298618 2021-01-21 Japan Hokkaido     16318 557 14001 1760 43.385711 142.552318 2021-01-22 05:22:10 Hokkaido, Japan
298619 2021-01-21 Japan Hyogo     14750 330 11912 2508 35.039913 134.828057 2021-01-22 05:22:10 Hyogo, Japan
298620 2021-01-21 Japan Ibaraki     4109 48 3144 917 36.303588 140.319591 2021-01-22 05:22:10 Ibaraki, Japan
298621 2021-01-21 Japan Ishikawa     1395 57 1145 193 36.769464 136.771027 2021-01-22 05:22:10 Ishikawa, Japan
298622 2021-01-21 Japan Iwate     484 25 391 68 39.593287 141.361777 2021-01-22 05:22:10 Iwate, Japan
298623 2021-01-21 Japan Kagawa     567 9 368 190 34.217292 133.969047 2021-01-22 05:22:10 Kagawa, Japan
298624 2021-01-21 Japan Kagoshima     1483 17 1236 230 31.009484000000004 130.430665 2021-01-22 05:22:10 Kagoshima, Japan
298625 2021-01-21 Japan Kanagawa     36376 386 29569 6421 35.415312 139.338983 2021-01-22 05:22:10 Kanagawa, Japan
298626 2021-01-21 Japan Kochi     813 13 731 69 33.422519 133.367307 2021-01-22 05:22:10 Kochi, Japan
298627 2021-01-21 Japan Kumamoto     3117 50 2243 824 32.608154 130.74523100000002 2021-01-22 05:22:10 Kumamoto, Japan
298628 2021-01-21 Japan Kyoto     7393 93 5433 1867 35.253815 135.443341 2021-01-22 05:22:10 Kyoto, Japan
298629 2021-01-21 Japan Mie     1881 25 1496 360 34.508018 136.376013 2021-01-22 05:22:10 Mie, Japan
298630 2021-01-21 Japan Miyagi     3182 22 2549 611 38.446859 140.927086 2021-01-22 05:22:10 Miyagi, Japan
298631 2021-01-21 Japan Miyazaki     1675 14 1275 386 32.193203999999994 131.299374 2021-01-22 05:22:10 Miyazaki, Japan
298632 2021-01-21 Japan Nagano     2101 25 1662 414 36.132134 138.045528 2021-01-22 05:22:10 Nagano, Japan
298633 2021-01-21 Japan Nagasaki     1359 18 920 421 33.235712 129.608033 2021-01-22 05:22:10 Nagasaki, Japan
298634 2021-01-21 Japan Nara     2710 33 2289 388 34.317451 135.871644 2021-01-22 05:22:10 Nara, Japan
298635 2021-01-21 Japan Niigata     808 7 652 149 37.521819 138.918647 2021-01-22 05:22:10 Niigata, Japan
298636 2021-01-21 Japan Oita     988 12 803 173 33.200697 131.43323999999998 2021-01-22 05:22:10 Oita, Japan
298637 2021-01-21 Japan Okayama     2183 17 1434 732 34.89246 133.826252 2021-01-22 05:22:10 Okayama, Japan
298638 2021-01-21 Japan Okinawa     6774 90 5808 876 25.768923 126.668016 2021-01-22 05:22:10 Okinawa, Japan
298639 2021-01-21 Japan Osaka     40059 796 32604 6659 34.620965000000005 135.507481 2021-01-22 05:22:10 Osaka, Japan
298640 2021-01-21 Japan Port Quarantine     2116 1 1956 159     2021-01-22 05:22:10 Port Quarantine, Japan
298641 2021-01-21 Japan Saga     868 6 605 257 33.286977 130.115738 2021-01-22 05:22:10 Saga, Japan
298642 2021-01-21 Japan Saitama     22409 293 16201 5915 35.997101 139.347635 2021-01-22 05:22:10 Saitama, Japan
298643 2021-01-21 Japan Shiga     1868 20 1438 410 35.21582700000001 136.138064 2021-01-22 05:22:10 Shiga, Japan
298644 2021-01-21 Japan Shimane     248 0 224 24 35.07076 132.55406399999998 2021-01-22 05:22:10 Shimane, Japan
298645 2021-01-21 Japan Shizuoka     4100 64 3110 926 34.916975 138.40778400000002 2021-01-22 05:22:10 Shizuoka, Japan
298646 2021-01-21 Japan Tochigi     3434 30 2229 1175 36.689912 139.819213 2021-01-22 05:22:10 Tochigi, Japan
298647 2021-01-21 Japan Tokushima     338 11 220 107 33.919178 134.242091 2021-01-22 05:22:10 Tokushima, Japan
298648 2021-01-21 Japan Tokyo     90727 758 68901 21068 35.711343 139.446921 2021-01-22 05:22:10 Tokyo, Japan
298649 2021-01-21 Japan Tottori     187 2 132 53 35.359069 133.863619 2021-01-22 05:22:10 Tottori, Japan
298650 2021-01-21 Japan Toyama     835 27 676 132 36.637464 137.26934599999998 2021-01-22 05:22:10 Toyama, Japan
298651 2021-01-21 Japan Unknown     8 0 8 0     2021-01-22 05:22:10 Unknown, Japan
298652 2021-01-21 Japan Wakayama     948 11 769 168 33.911879 135.505446 2021-01-22 05:22:10 Wakayama, Japan
298653 2021-01-21 Japan Yamagata     455 13 401 41 38.448396 140.102154 2021-01-22 05:22:10 Yamagata, Japan
298654 2021-01-21 Japan Yamaguchi     996 6 740 250 34.201190000000004 131.573293 2021-01-22 05:22:10 Yamaguchi, Japan
298655 2021-01-21 Japan Yamanashi     876 13 720 143 35.612364 138.61148899999998 2021-01-22 05:22:10 Yamanashi, Japan
889659 2021-01-20 Japan Aichi     21934 338 17687 3909 35.035551 137.211621 2021-01-21 05:22:01 Aichi, Japan
889660 2021-01-20 Japan Akita     227 1 166 60 39.748679 140.408228 2021-01-21 05:22:01 Akita, Japan
889661 2021-01-20 Japan Aomori     660 9 554 97 40.781541 140.828896 2021-01-21 05:22:01 Aomori, Japan
889662 2021-01-20 Japan Chiba     18574 189 11967 6418 35.510141 140.198917 2021-01-21 05:22:01 Chiba, Japan
889663 2021-01-20 Japan Ehime     866 16 613 237 33.624835 132.856842 2021-01-21 05:22:01 Ehime, Japan
889664 2021-01-20 Japan Fukui     467 13 376 78 35.846614 136.22465400000002 2021-01-21 05:22:01 Fukui, Japan
889665 2021-01-20 Japan Fukuoka     14106 154 9580 4372 33.526032 130.666949 2021-01-21 05:22:01 Fukuoka, Japan
889666 2021-01-20 Japan Fukushima     1534 35 1128 371 37.378867 140.223295 2021-01-21 05:22:01 Fukushima, Japan
889667 2021-01-20 Japan Gifu     3673 58 2934 681 35.778671 137.055925 2021-01-21 05:22:01 Gifu, Japan
889668 2021-01-20 Japan Gunma     3427 61 2715 651 36.504479 138.985605 2021-01-21 05:22:01 Gunma, Japan
889669 2021-01-20 Japan Hiroshima     4507 76 3787 644 34.605309000000005 132.788719 2021-01-21 05:22:01 Hiroshima, Japan
889670 2021-01-20 Japan Hokkaido     16188 551 13866 1771 43.385711 142.552318 2021-01-21 05:22:01 Hokkaido, Japan
889671 2021-01-20 Japan Hyogo     14513 320 11714 2479 35.039913 134.828057 2021-01-21 05:22:01 Hyogo, Japan
889672 2021-01-20 Japan Ibaraki     4026 46 3050 930 36.303588 140.319591 2021-01-21 05:22:01 Ibaraki, Japan
889673 2021-01-20 Japan Ishikawa     1375 56 1133 186 36.769464 136.771027 2021-01-21 05:22:01 Ishikawa, Japan
889674 2021-01-20 Japan Iwate     483 25 386 72 39.593287 141.361777 2021-01-21 05:22:01 Iwate, Japan
889675 2021-01-20 Japan Kagawa     555 6 357 192 34.217292 133.969047 2021-01-21 05:22:01 Kagawa, Japan
889676 2021-01-20 Japan Kagoshima     1460 17 1176 267 31.009484000000004 130.430665 2021-01-21 05:22:01 Kagoshima, Japan
889677 2021-01-20 Japan Kanagawa     35645 379 28622 6644 35.415312 139.338983 2021-01-21 05:22:01 Kanagawa, Japan
889678 2021-01-20 Japan Kochi     807 13 721 73 33.422519 133.367307 2021-01-21 05:22:01 Kochi, Japan
889679 2021-01-20 Japan Kumamoto     3077 46 2176 855 32.608154 130.74523100000002 2021-01-21 05:22:01 Kumamoto, Japan
889680 2021-01-20 Japan Kyoto     7253 90 5327 1836 35.253815 135.443341 2021-01-21 05:22:01 Kyoto, Japan
889681 2021-01-20 Japan Mie     1847 24 1475 348 34.508018 136.376013 2021-01-21 05:22:01 Mie, Japan
889682 2021-01-20 Japan Miyagi     3131 22 2411 698 38.446859 140.927086 2021-01-21 05:22:01 Miyagi, Japan
889683 2021-01-20 Japan Miyazaki     1647 14 1230 403 32.193203999999994 131.299374 2021-01-21 05:22:01 Miyazaki, Japan
889684 2021-01-20 Japan Nagano     2076 22 1595 459 36.132134 138.045528 2021-01-21 05:22:01 Nagano, Japan
889685 2021-01-20 Japan Nagasaki     1334 18 879 437 33.235712 129.608033 2021-01-21 05:22:01 Nagasaki, Japan
889686 2021-01-20 Japan Nara     2672 33 2263 376 34.317451 135.871644 2021-01-21 05:22:01 Nara, Japan
889687 2021-01-20 Japan Niigata     788 7 633 148 37.521819 138.918647 2021-01-21 05:22:01 Niigata, Japan
889688 2021-01-20 Japan Oita     955 12 792 151 33.200697 131.43323999999998 2021-01-21 05:22:01 Oita, Japan
889689 2021-01-20 Japan Okayama     2154 17 1434 703 34.89246 133.826252 2021-01-21 05:22:01 Okayama, Japan
889690 2021-01-20 Japan Okinawa     6706 89 5752 865 25.768923 126.668016 2021-01-21 05:22:01 Okinawa, Japan
889691 2021-01-20 Japan Osaka     39558 777 31931 6850 34.620965000000005 135.507481 2021-01-21 05:22:01 Osaka, Japan
889692 2021-01-20 Japan Port Quarantine     2108 1 1946 161     2021-01-21 05:22:01 Port Quarantine, Japan
889693 2021-01-20 Japan Saga     842 6 584 252 33.286977 130.115738 2021-01-21 05:22:01 Saga, Japan
889694 2021-01-20 Japan Saitama     21973 292 14664 7017 35.997101 139.347635 2021-01-21 05:22:01 Saitama, Japan
889695 2021-01-20 Japan Shiga     1840 20 1402 418 35.21582700000001 136.138064 2021-01-21 05:22:01 Shiga, Japan
889696 2021-01-20 Japan Shimane     248 0 223 25 35.07076 132.55406399999998 2021-01-21 05:22:01 Shimane, Japan
889697 2021-01-20 Japan Shizuoka     4040 64 3002 974 34.916975 138.40778400000002 2021-01-21 05:22:01 Shizuoka, Japan
889698 2021-01-20 Japan Tochigi     3385 29 2092 1264 36.689912 139.819213 2021-01-21 05:22:01 Tochigi, Japan
889699 2021-01-20 Japan Tokushima     328 10 214 104 33.919178 134.242091 2021-01-21 05:22:01 Tokushima, Japan
889700 2021-01-20 Japan Tokyo     89256 751 66881 21624 35.711343 139.446921 2021-01-21 05:22:01 Tokyo, Japan
889701 2021-01-20 Japan Tottori     187 2 128 57 35.359069 133.863619 2021-01-21 05:22:01 Tottori, Japan
889702 2021-01-20 Japan Toyama     827 27 659 141 36.637464 137.26934599999998 2021-01-21 05:22:01 Toyama, Japan
889703 2021-01-20 Japan Unknown     8 0 8 0     2021-01-21 05:22:01 Unknown, Japan
889704 2021-01-20 Japan Wakayama     928 11 755 162 33.911879 135.505446 2021-01-21 05:22:01 Wakayama, Japan
889705 2021-01-20 Japan Yamagata     455 13 400 42 38.448396 140.102154 2021-01-21 05:22:01 Yamagata, Japan
889706 2021-01-20 Japan Yamaguchi     987 6 740 241 34.201190000000004 131.573293 2021-01-21 05:22:01 Yamaguchi, Japan
889707 2021-01-20 Japan Yamanashi     871 13 703 155 35.612364 138.61148899999998 2021-01-21 05:22:01 Yamanashi, Japan
318226 2021-01-19 Japan Aichi     21688 329 17400 3959 35.035551 137.211621 2021-01-20 05:21:54 Aichi, Japan
318227 2021-01-19 Japan Akita     219 1 164 54 39.748679 140.408228 2021-01-20 05:21:54 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]);