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

13,796 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 · 13,796
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
904426 2021-03-03 Japan Aichi     26010 528 24749 733 35.035551 137.211621 2021-03-04 05:24:24 Aichi, Japan
904427 2021-03-03 Japan Akita     269 6 262 1 39.748679 140.408228 2021-03-04 05:24:24 Akita, Japan
904428 2021-03-03 Japan Aomori     817 20 771 26 40.781541 140.828896 2021-03-04 05:24:24 Aomori, Japan
904429 2021-03-03 Japan Chiba     26785 464 24630 1691 35.510141 140.198917 2021-03-04 05:24:24 Chiba, Japan
904430 2021-03-03 Japan Ehime     1068 23 1005 40 33.624835 132.856842 2021-03-04 05:24:24 Ehime, Japan
904431 2021-03-03 Japan Fukui     545 25 516 4 35.846614 136.22465400000002 2021-03-04 05:24:24 Fukui, Japan
904432 2021-03-03 Japan Fukuoka     18145 302 17237 606 33.526032 130.666949 2021-03-04 05:24:24 Fukuoka, Japan
904433 2021-03-03 Japan Fukushima     2042 74 1777 191 37.378867 140.223295 2021-03-04 05:24:24 Fukushima, Japan
904434 2021-03-03 Japan Gifu     4644 107 4487 50 35.778671 137.055925 2021-03-04 05:24:24 Gifu, Japan
904435 2021-03-03 Japan Gunma     4546 85 4260 201 36.504479 138.985605 2021-03-04 05:24:24 Gunma, Japan
904436 2021-03-03 Japan Hiroshima     5036 100 4887 49 34.605309000000005 132.788719 2021-03-04 05:24:24 Hiroshima, Japan
904437 2021-03-03 Japan Hokkaido     19204 687 17944 573 43.385711 142.552318 2021-03-04 05:24:24 Hokkaido, Japan
904438 2021-03-03 Japan Hyogo     18134 548 17081 505 35.039913 134.828057 2021-03-04 05:24:24 Hyogo, Japan
904439 2021-03-03 Japan Ibaraki     5865 116 5374 375 36.303588 140.319591 2021-03-04 05:24:24 Ibaraki, Japan
904440 2021-03-03 Japan Ishikawa     1873 63 1700 110 36.769464 136.771027 2021-03-04 05:24:24 Ishikawa, Japan
904441 2021-03-03 Japan Iwate     554 30 517 7 39.593287 141.361777 2021-03-04 05:24:24 Iwate, Japan
904442 2021-03-03 Japan Kagawa     753 18 715 20 34.217292 133.969047 2021-03-04 05:24:24 Kagawa, Japan
904443 2021-03-03 Japan Kagoshima     1762 29 1729 4 31.009484000000004 130.430665 2021-03-04 05:24:24 Kagoshima, Japan
904444 2021-03-03 Japan Kanagawa     45228 696 43345 1187 35.415312 139.338983 2021-03-04 05:24:24 Kanagawa, Japan
904445 2021-03-03 Japan Kochi     884 17 866 1 33.422519 133.367307 2021-03-04 05:24:24 Kochi, Japan
904446 2021-03-03 Japan Kumamoto     3450 73 3340 37 32.608154 130.74523100000002 2021-03-04 05:24:24 Kumamoto, Japan
904447 2021-03-03 Japan Kyoto     9077 155 8651 271 35.253815 135.443341 2021-03-04 05:24:24 Kyoto, Japan
904448 2021-03-03 Japan Mie     2544 55 2434 55 34.508018 136.376013 2021-03-04 05:24:24 Mie, Japan
904449 2021-03-03 Japan Miyagi     3721 25 3516 180 38.446859 140.927086 2021-03-04 05:24:24 Miyagi, Japan
904450 2021-03-03 Japan Miyazaki     1949 20 1905 24 32.193203999999994 131.299374 2021-03-04 05:24:24 Miyazaki, Japan
904451 2021-03-03 Japan Nagano     2364 40 2343 -19 36.132134 138.045528 2021-03-04 05:24:24 Nagano, Japan
904452 2021-03-03 Japan Nagasaki     1612 37 1543 32 33.235712 129.608033 2021-03-04 05:24:24 Nagasaki, Japan
904453 2021-03-03 Japan Nara     3309 49 3265 -5 34.317451 135.871644 2021-03-04 05:24:24 Nara, Japan
904454 2021-03-03 Japan Niigata     1093 14 996 83 37.521819 138.918647 2021-03-04 05:24:24 Niigata, Japan
904455 2021-03-03 Japan Oita     1295 21 1248 26 33.200697 131.43323999999998 2021-03-04 05:24:24 Oita, Japan
904456 2021-03-03 Japan Okayama     2498 33 2389 76 34.89246 133.826252 2021-03-04 05:24:24 Okayama, Japan
904457 2021-03-03 Japan Okinawa     8263 121 7829 313 25.768923 126.668016 2021-03-04 05:24:24 Okinawa, Japan
904458 2021-03-03 Japan Osaka     47323 1126 44700 1497 34.620965000000005 135.507481 2021-03-04 05:24:24 Osaka, Japan
904459 2021-03-03 Japan Port Quarantine     2253 2 2187 64     2021-03-04 05:24:24 Port Quarantine, Japan
904460 2021-03-03 Japan Saga     1080 9 1014 57 33.286977 130.115738 2021-03-04 05:24:24 Saga, Japan
904461 2021-03-03 Japan Saitama     29650 591 27705 1354 35.997101 139.347635 2021-03-04 05:24:24 Saitama, Japan
904462 2021-03-03 Japan Shiga     2498 47 2309 142 35.21582700000001 136.138064 2021-03-04 05:24:24 Shiga, Japan
904463 2021-03-03 Japan Shimane     290 0 279 11 35.07076 132.55406399999998 2021-03-04 05:24:24 Shimane, Japan
904464 2021-03-03 Japan Shizuoka     5190 92 4880 218 34.916975 138.40778400000002 2021-03-04 05:24:24 Shizuoka, Japan
904465 2021-03-03 Japan Tochigi     4128 68 3917 143 36.689912 139.819213 2021-03-04 05:24:24 Tochigi, Japan
904466 2021-03-03 Japan Tokushima     456 16 413 27 33.919178 134.242091 2021-03-04 05:24:24 Tokushima, Japan
904467 2021-03-03 Japan Tokyo     111575 1416 107546 2613 35.711343 139.446921 2021-03-04 05:24:24 Tokyo, Japan
904468 2021-03-03 Japan Tottori     211 2 202 7 35.359069 133.863619 2021-03-04 05:24:24 Tottori, Japan
904469 2021-03-03 Japan Toyama     908 28 867 13 36.637464 137.26934599999998 2021-03-04 05:24:24 Toyama, Japan
904470 2021-03-03 Japan Unknown     8 0 8 0     2021-03-04 05:24:24 Unknown, Japan
904471 2021-03-03 Japan Wakayama     1164 18 1113 33 33.911879 135.505446 2021-03-04 05:24:24 Wakayama, Japan
904472 2021-03-03 Japan Yamagata     543 15 515 13 38.448396 140.102154 2021-03-04 05:24:24 Yamagata, Japan
904473 2021-03-03 Japan Yamaguchi     1385 39 1296 50 34.201190000000004 131.573293 2021-03-04 05:24:24 Yamaguchi, Japan
904474 2021-03-03 Japan Yamanashi     943 18 916 9 35.612364 138.61148899999998 2021-03-04 05:24:24 Yamanashi, Japan
66807 2021-03-02 Japan Aichi     25955 523 24690 742 35.035551 137.211621 2021-03-03 05:23:28 Aichi, Japan
66808 2021-03-02 Japan Akita     269 6 261 2 39.748679 140.408228 2021-03-03 05:23:28 Akita, Japan
66809 2021-03-02 Japan Aomori     817 20 771 26 40.781541 140.828896 2021-03-03 05:23:28 Aomori, Japan
66810 2021-03-02 Japan Chiba     26621 461 24434 1726 35.510141 140.198917 2021-03-03 05:23:28 Chiba, Japan
66811 2021-03-02 Japan Ehime     1067 23 1004 40 33.624835 132.856842 2021-03-03 05:23:28 Ehime, Japan
66812 2021-03-02 Japan Fukui     545 25 516 4 35.846614 136.22465400000002 2021-03-03 05:23:28 Fukui, Japan
66813 2021-03-02 Japan Fukuoka     18108 300 17162 646 33.526032 130.666949 2021-03-03 05:23:28 Fukuoka, Japan
66814 2021-03-02 Japan Fukushima     2008 72 1771 165 37.378867 140.223295 2021-03-03 05:23:28 Fukushima, Japan
66815 2021-03-02 Japan Gifu     4635 106 4478 51 35.778671 137.055925 2021-03-03 05:23:28 Gifu, Japan
66816 2021-03-02 Japan Gunma     4529 85 4249 195 36.504479 138.985605 2021-03-03 05:23:28 Gunma, Japan
66817 2021-03-02 Japan Hiroshima     5033 100 4877 56 34.605309000000005 132.788719 2021-03-03 05:23:28 Hiroshima, Japan
66818 2021-03-02 Japan Hokkaido     19144 684 17900 560 43.385711 142.552318 2021-03-03 05:23:28 Hokkaido, Japan
66819 2021-03-02 Japan Hyogo     18094 540 17055 499 35.039913 134.828057 2021-03-03 05:23:28 Hyogo, Japan
66820 2021-03-02 Japan Ibaraki     5831 115 5335 381 36.303588 140.319591 2021-03-03 05:23:28 Ibaraki, Japan
66821 2021-03-02 Japan Ishikawa     1865 63 1686 116 36.769464 136.771027 2021-03-03 05:23:28 Ishikawa, Japan
66822 2021-03-02 Japan Iwate     554 30 516 8 39.593287 141.361777 2021-03-03 05:23:28 Iwate, Japan
66823 2021-03-02 Japan Kagawa     752 18 711 23 34.217292 133.969047 2021-03-03 05:23:28 Kagawa, Japan
66824 2021-03-02 Japan Kagoshima     1762 29 1727 6 31.009484000000004 130.430665 2021-03-03 05:23:28 Kagoshima, Japan
66825 2021-03-02 Japan Kanagawa     45089 691 43215 1183 35.415312 139.338983 2021-03-03 05:23:28 Kanagawa, Japan
66826 2021-03-02 Japan Kochi     884 17 866 1 33.422519 133.367307 2021-03-03 05:23:28 Kochi, Japan
66827 2021-03-02 Japan Kumamoto     3447 73 3334 40 32.608154 130.74523100000002 2021-03-03 05:23:28 Kumamoto, Japan
66828 2021-03-02 Japan Kyoto     9070 154 8629 287 35.253815 135.443341 2021-03-03 05:23:28 Kyoto, Japan
66829 2021-03-02 Japan Mie     2540 54 2422 64 34.508018 136.376013 2021-03-03 05:23:28 Mie, Japan
66830 2021-03-02 Japan Miyagi     3694 25 3497 172 38.446859 140.927086 2021-03-03 05:23:28 Miyagi, Japan
66831 2021-03-02 Japan Miyazaki     1949 20 1896 33 32.193203999999994 131.299374 2021-03-03 05:23:28 Miyazaki, Japan
66832 2021-03-02 Japan Nagano     2364 40 2343 -19 36.132134 138.045528 2021-03-03 05:23:28 Nagano, Japan
66833 2021-03-02 Japan Nagasaki     1612 36 1541 35 33.235712 129.608033 2021-03-03 05:23:28 Nagasaki, Japan
66834 2021-03-02 Japan Nara     3305 49 3253 3 34.317451 135.871644 2021-03-03 05:23:28 Nara, Japan
66835 2021-03-02 Japan Niigata     1092 14 985 93 37.521819 138.918647 2021-03-03 05:23:28 Niigata, Japan
66836 2021-03-02 Japan Oita     1294 21 1240 33 33.200697 131.43323999999998 2021-03-03 05:23:28 Oita, Japan
66837 2021-03-02 Japan Okayama     2489 33 2389 67 34.89246 133.826252 2021-03-03 05:23:28 Okayama, Japan
66838 2021-03-02 Japan Okinawa     8245 121 7817 307 25.768923 126.668016 2021-03-03 05:23:28 Okinawa, Japan
66839 2021-03-02 Japan Osaka     47225 1123 44575 1527 34.620965000000005 135.507481 2021-03-03 05:23:28 Osaka, Japan
66840 2021-03-02 Japan Port Quarantine     2250 2 2183 65     2021-03-03 05:23:28 Port Quarantine, Japan
66841 2021-03-02 Japan Saga     1078 9 1010 59 33.286977 130.115738 2021-03-03 05:23:28 Saga, Japan
66842 2021-03-02 Japan Saitama     29552 583 27645 1324 35.997101 139.347635 2021-03-03 05:23:28 Saitama, Japan
66843 2021-03-02 Japan Shiga     2481 47 2296 138 35.21582700000001 136.138064 2021-03-03 05:23:28 Shiga, Japan
66844 2021-03-02 Japan Shimane     290 0 279 11 35.07076 132.55406399999998 2021-03-03 05:23:28 Shimane, Japan
66845 2021-03-02 Japan Shizuoka     5169 92 4862 215 34.916975 138.40778400000002 2021-03-03 05:23:28 Shizuoka, Japan
66846 2021-03-02 Japan Tochigi     4121 68 3908 145 36.689912 139.819213 2021-03-03 05:23:28 Tochigi, Japan
66847 2021-03-02 Japan Tokushima     451 16 411 24 33.919178 134.242091 2021-03-03 05:23:28 Tokushima, Japan
66848 2021-03-02 Japan Tokyo     111259 1397 107311 2551 35.711343 139.446921 2021-03-03 05:23:28 Tokyo, Japan
66849 2021-03-02 Japan Tottori     211 2 202 7 35.359069 133.863619 2021-03-03 05:23:28 Tottori, Japan
66850 2021-03-02 Japan Toyama     908 28 864 16 36.637464 137.26934599999998 2021-03-03 05:23:28 Toyama, Japan
66851 2021-03-02 Japan Unknown     8 0 8 0     2021-03-03 05:23:28 Unknown, Japan
66852 2021-03-02 Japan Wakayama     1164 18 1113 33 33.911879 135.505446 2021-03-03 05:23:28 Wakayama, Japan
66853 2021-03-02 Japan Yamagata     543 15 514 14 38.448396 140.102154 2021-03-03 05:23:28 Yamagata, Japan
66854 2021-03-02 Japan Yamaguchi     1385 39 1292 54 34.201190000000004 131.573293 2021-03-03 05:23:28 Yamaguchi, Japan
66855 2021-03-02 Japan Yamanashi     942 18 916 8 35.612364 138.61148899999998 2021-03-03 05:23:28 Yamanashi, Japan
1291385 2021-03-01 Japan Aichi     25921 519 24655 747 35.035551 137.211621 2021-03-02 05:23:30 Aichi, Japan
1291386 2021-03-01 Japan Akita     269 6 260 3 39.748679 140.408228 2021-03-02 05:23:30 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]);