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

46,430 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 >30

country_or_region 1

  • Japan · 46,430 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2752888 2752888 2022-12-29 Japan Aichi     1829412 3445 0   35.035551 137.211621 2022-12-30 04:21:04 Aichi, Japan
2752889 2752889 2022-12-29 Japan Akita     177160 460 0   39.748679 140.408228 2022-12-30 04:21:04 Akita, Japan
2752890 2752890 2022-12-29 Japan Aomori     249739 526 0   40.781541 140.828896 2022-12-30 04:21:04 Aomori, Japan
2752891 2752891 2022-12-29 Japan Chiba     1275307 2969 0   35.510141 140.198917 2022-12-30 04:21:04 Chiba, Japan
2752892 2752892 2022-12-29 Japan Ehime     248940 417 0   33.624835 132.856842 2022-12-30 04:21:04 Ehime, Japan
2752893 2752893 2022-12-29 Japan Fukui     169375 144 0   35.846614 136.224654 2022-12-30 04:21:04 Fukui, Japan
2752894 2752894 2022-12-29 Japan Fukuoka     1360910 2302 0   33.526032 130.666949 2022-12-30 04:21:04 Fukuoka, Japan
2752895 2752895 2022-12-29 Japan Fukushima     339617 453 0   37.378867 140.223295 2022-12-30 04:21:04 Fukushima, Japan
2752896 2752896 2022-12-29 Japan Gifu     446219 847 0   35.778671 137.055925 2022-12-30 04:21:04 Gifu, Japan
2752897 2752897 2022-12-29 Japan Gunma     372278 786 0   36.504479 138.985605 2022-12-30 04:21:04 Gunma, Japan
2752898 2752898 2022-12-29 Japan Hiroshima     651857 1005 0   34.605309 132.788719 2022-12-30 04:21:04 Hiroshima, Japan
2752899 2752899 2022-12-29 Japan Hokkaido     1226360 4013 0   43.385711 142.552318 2022-12-30 04:21:04 Hokkaido, Japan
2752900 2752900 2022-12-29 Japan Hyogo     1265004 3195 0   35.039913 134.828057 2022-12-30 04:21:04 Hyogo, Japan
2752901 2752901 2022-12-29 Japan Ibaraki     533596 955 0   36.303588 140.319591 2022-12-30 04:21:04 Ibaraki, Japan
2752902 2752902 2022-12-29 Japan Ishikawa     237984 380 0   36.769464 136.771027 2022-12-30 04:21:04 Ishikawa, Japan
2752903 2752903 2022-12-29 Japan Iwate     200116 400 0   39.593287 141.361777 2022-12-30 04:21:04 Iwate, Japan
2752904 2752904 2022-12-29 Japan Kagawa     203923 416 0   34.217292 133.969047 2022-12-30 04:21:04 Kagawa, Japan
2752905 2752905 2022-12-29 Japan Kagoshima     362597 596 0   31.009484 130.430665 2022-12-30 04:21:04 Kagoshima, Japan
2752906 2752906 2022-12-29 Japan Kanagawa     1969271 3517 0   35.415312 139.338983 2022-12-30 04:21:04 Kanagawa, Japan
2752907 2752907 2022-12-29 Japan Kochi     136195 394 0   33.422519 133.367307 2022-12-30 04:21:04 Kochi, Japan
2752908 2752908 2022-12-29 Japan Kumamoto     448323 850 0   32.608154 130.745231 2022-12-30 04:21:04 Kumamoto, Japan
2752909 2752909 2022-12-29 Japan Kyoto     596677 1285 0   35.253815 135.443341 2022-12-30 04:21:04 Kyoto, Japan
2752910 2752910 2022-12-29 Japan Mie     366509 689 0   34.508018 136.376013 2022-12-30 04:21:04 Mie, Japan
2752911 2752911 2022-12-29 Japan Miyagi     460543 714 0   38.446859 140.927086 2022-12-30 04:21:04 Miyagi, Japan
2752912 2752912 2022-12-29 Japan Miyazaki     257681 483 0   32.193204 131.299374 2022-12-30 04:21:04 Miyazaki, Japan
2752913 2752913 2022-12-29 Japan Nagano     380555 662 0   36.132134 138.045528 2022-12-30 04:21:04 Nagano, Japan
2752914 2752914 2022-12-29 Japan Nagasaki     277949 416 0   33.235712 129.608033 2022-12-30 04:21:04 Nagasaki, Japan
2752915 2752915 2022-12-29 Japan Nara     298783 668 0   34.317451 135.871644 2022-12-30 04:21:04 Nara, Japan
2752916 2752916 2022-12-29 Japan Niigata     393852 285 0   37.521819 138.918647 2022-12-30 04:21:04 Niigata, Japan
2752917 2752917 2022-12-29 Japan Oita     245406 481 0   33.200697 131.43324 2022-12-30 04:21:04 Oita, Japan
2752918 2752918 2022-12-29 Japan Okayama     401543 568 0   34.89246 133.826252 2022-12-30 04:21:04 Okayama, Japan
2752919 2752919 2022-12-29 Japan Okinawa     541274 837 0   25.768923 126.668016 2022-12-30 04:21:04 Okinawa, Japan
2752920 2752920 2022-12-29 Japan Osaka     2528928 7102 0   34.620965 135.507481 2022-12-30 04:21:04 Osaka, Japan
2752921 2752921 2022-12-29 Japan Port Quarantine     22118 8 0       2022-11-22 23:21:06 Port Quarantine, Japan
2752922 2752922 2022-12-29 Japan Saga     217024 326 0   33.286977 130.115738 2022-12-30 04:21:04 Saga, Japan
2752923 2752923 2022-12-29 Japan Saitama     1595587 2930 0   35.997101 139.347635 2022-12-30 04:21:04 Saitama, Japan
2752924 2752924 2022-12-29 Japan Shiga     319554 476 0   35.215827 136.138064 2022-12-30 04:21:04 Shiga, Japan
2752925 2752925 2022-12-29 Japan Shimane     135497 179 0   35.07076 132.554064 2022-12-30 04:21:04 Shimane, Japan
2752926 2752926 2022-12-29 Japan Shizuoka     688189 919 0   34.916975 138.407784 2022-12-30 04:21:04 Shizuoka, Japan
2752927 2752927 2022-12-29 Japan Tochigi     352359 741 0   36.689912 139.819213 2022-12-30 04:21:04 Tochigi, Japan
2752928 2752928 2022-12-29 Japan Tokushima     131216 277 0   33.919178 134.242091 2022-12-30 04:21:04 Tokushima, Japan
2752929 2752929 2022-12-29 Japan Tokyo     3963653 6708 0   35.711343 139.446921 2022-12-30 04:21:04 Tokyo, Japan
2752930 2752930 2022-12-29 Japan Tottori     109774 155 0   35.359069 133.863619 2022-12-30 04:21:04 Tottori, Japan
2752931 2752931 2022-12-29 Japan Toyama     202858 244 0   36.637464 137.269346 2022-12-30 04:21:04 Toyama, Japan
2752932 2752932 2022-12-29 Japan Unknown     173 0 0       2022-11-22 23:21:06 Unknown, Japan
2752933 2752933 2022-12-29 Japan Wakayama     191537 362 0   33.911879 135.505446 2022-12-30 04:21:04 Wakayama, Japan
2752934 2752934 2022-12-29 Japan Yamagata     199194 305 0   38.448396 140.102154 2022-12-30 04:21:04 Yamagata, Japan
2752935 2752935 2022-12-29 Japan Yamaguchi     241680 514 0   34.20119 131.573293 2022-12-30 04:21:04 Yamaguchi, Japan
2752936 2752936 2022-12-29 Japan Yamanashi     154132 252 0   35.612364 138.611489 2022-12-30 04:21:04 Yamanashi, Japan
1073894 1073894 2022-12-28 Japan Aichi     1817131 3423 0   35.035551 137.211621 2022-12-29 04:21:01 Aichi, Japan
1073895 1073895 2022-12-28 Japan Akita     176384 458 0   39.748679 140.408228 2022-12-29 04:21:01 Akita, Japan
1073896 1073896 2022-12-28 Japan Aomori     248443 521 0   40.781541 140.828896 2022-12-29 04:21:01 Aomori, Japan
1073897 1073897 2022-12-28 Japan Chiba     1267316 2955 0   35.510141 140.198917 2022-12-29 04:21:01 Chiba, Japan
1073898 1073898 2022-12-28 Japan Ehime     246076 411 0   33.624835 132.856842 2022-12-29 04:21:01 Ehime, Japan
1073899 1073899 2022-12-28 Japan Fukui     168120 142 0   35.846614 136.224654 2022-12-29 04:21:01 Fukui, Japan
1073900 1073900 2022-12-28 Japan Fukuoka     1349923 2282 0   33.526032 130.666949 2022-12-29 04:21:01 Fukuoka, Japan
1073901 1073901 2022-12-28 Japan Fukushima     337152 446 0   37.378867 140.223295 2022-12-29 04:21:01 Fukushima, Japan
1073902 1073902 2022-12-28 Japan Gifu     442443 836 0   35.778671 137.055925 2022-12-29 04:21:01 Gifu, Japan
1073903 1073903 2022-12-28 Japan Gunma     369198 777 0   36.504479 138.985605 2022-12-29 04:21:01 Gunma, Japan
1073904 1073904 2022-12-28 Japan Hiroshima     645208 1002 0   34.605309 132.788719 2022-12-29 04:21:01 Hiroshima, Japan
1073905 1073905 2022-12-28 Japan Hokkaido     1221571 3982 0   43.385711 142.552318 2022-12-29 04:21:01 Hokkaido, Japan
1073906 1073906 2022-12-28 Japan Hyogo     1256720 3180 0   35.039913 134.828057 2022-12-29 04:21:01 Hyogo, Japan
1073907 1073907 2022-12-28 Japan Ibaraki     528794 948 0   36.303588 140.319591 2022-12-29 04:21:01 Ibaraki, Japan
1073908 1073908 2022-12-28 Japan Ishikawa     236569 377 0   36.769464 136.771027 2022-12-29 04:21:01 Ishikawa, Japan
1073909 1073909 2022-12-28 Japan Iwate     198684 394 0   39.593287 141.361777 2022-12-29 04:21:01 Iwate, Japan
1073910 1073910 2022-12-28 Japan Kagawa     202027 408 0   34.217292 133.969047 2022-12-29 04:21:01 Kagawa, Japan
1073911 1073911 2022-12-28 Japan Kagoshima     359642 593 0   31.009484 130.430665 2022-12-29 04:21:01 Kagoshima, Japan
1073912 1073912 2022-12-28 Japan Kanagawa     1957597 3484 0   35.415312 139.338983 2022-12-29 04:21:01 Kanagawa, Japan
1073913 1073913 2022-12-28 Japan Kochi     135093 388 0   33.422519 133.367307 2022-12-29 04:21:01 Kochi, Japan
1073914 1073914 2022-12-28 Japan Kumamoto     444348 841 0   32.608154 130.745231 2022-12-29 04:21:01 Kumamoto, Japan
1073915 1073915 2022-12-28 Japan Kyoto     593258 1278 0   35.253815 135.443341 2022-12-29 04:21:01 Kyoto, Japan
1073916 1073916 2022-12-28 Japan Mie     362466 681 0   34.508018 136.376013 2022-12-29 04:21:01 Mie, Japan
1073917 1073917 2022-12-28 Japan Miyagi     456851 698 0   38.446859 140.927086 2022-12-29 04:21:01 Miyagi, Japan
1073918 1073918 2022-12-28 Japan Miyazaki     254900 473 0   32.193204 131.299374 2022-12-29 04:21:01 Miyazaki, Japan
1073919 1073919 2022-12-28 Japan Nagano     378355 656 0   36.132134 138.045528 2022-12-29 04:21:01 Nagano, Japan
1073920 1073920 2022-12-28 Japan Nagasaki     275509 409 0   33.235712 129.608033 2022-12-29 04:21:01 Nagasaki, Japan
1073921 1073921 2022-12-28 Japan Nara     296729 664 0   34.317451 135.871644 2022-12-29 04:21:01 Nara, Japan
1073922 1073922 2022-12-28 Japan Niigata     391387 282 0   37.521819 138.918647 2022-12-29 04:21:01 Niigata, Japan
1073923 1073923 2022-12-28 Japan Oita     242768 474 0   33.200697 131.43324 2022-12-29 04:21:01 Oita, Japan
1073924 1073924 2022-12-28 Japan Okayama     397618 559 0   34.89246 133.826252 2022-12-29 04:21:01 Okayama, Japan
1073925 1073925 2022-12-28 Japan Okinawa     539835 837 0   25.768923 126.668016 2022-12-29 04:21:01 Okinawa, Japan
1073926 1073926 2022-12-28 Japan Osaka     2517201 7082 0   34.620965 135.507481 2022-12-29 04:21:01 Osaka, Japan
1073927 1073927 2022-12-28 Japan Port Quarantine     22118 8 0       2022-11-22 23:21:06 Port Quarantine, Japan
1073928 1073928 2022-12-28 Japan Saga     215018 320 0   33.286977 130.115738 2022-12-29 04:21:01 Saga, Japan
1073929 1073929 2022-12-28 Japan Saitama     1586195 2911 0   35.997101 139.347635 2022-12-29 04:21:01 Saitama, Japan
1073930 1073930 2022-12-28 Japan Shiga     317348 473 0   35.215827 136.138064 2022-12-29 04:21:01 Shiga, Japan
1073931 1073931 2022-12-28 Japan Shimane     134264 176 0   35.07076 132.554064 2022-12-29 04:21:01 Shimane, Japan
1073932 1073932 2022-12-28 Japan Shizuoka     681200 910 0   34.916975 138.407784 2022-12-29 04:21:01 Shizuoka, Japan
1073933 1073933 2022-12-28 Japan Tochigi     349780 733 0   36.689912 139.819213 2022-12-29 04:21:01 Tochigi, Japan
1073934 1073934 2022-12-28 Japan Tokushima     129985 274 0   33.919178 134.242091 2022-12-29 04:21:01 Tokushima, Japan
1073935 1073935 2022-12-28 Japan Tokyo     3945281 6685 0   35.711343 139.446921 2022-12-29 04:21:01 Tokyo, Japan
1073936 1073936 2022-12-28 Japan Tottori     108421 153 0   35.359069 133.863619 2022-12-29 04:21:01 Tottori, Japan
1073937 1073937 2022-12-28 Japan Toyama     201651 243 0   36.637464 137.269346 2022-12-29 04:21:01 Toyama, Japan
1073938 1073938 2022-12-28 Japan Unknown     173 0 0       2022-11-22 23:21:06 Unknown, Japan
1073939 1073939 2022-12-28 Japan Wakayama     189674 358 0   33.911879 135.505446 2022-12-29 04:21:01 Wakayama, Japan
1073940 1073940 2022-12-28 Japan Yamagata     198114 300 0   38.448396 140.102154 2022-12-29 04:21:01 Yamagata, Japan
1073941 1073941 2022-12-28 Japan Yamaguchi     238975 505 0   34.20119 131.573293 2022-12-29 04:21:01 Yamaguchi, Japan
1073942 1073942 2022-12-28 Japan Yamanashi     152852 246 0   35.612364 138.611489 2022-12-29 04:21:01 Yamanashi, Japan
327891 327891 2022-12-27 Japan Aichi     1802821 3415 0   35.035551 137.211621 2022-12-28 04:21:04 Aichi, Japan
327892 327892 2022-12-27 Japan Akita     175424 449 0   39.748679 140.408228 2022-12-28 04:21:04 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] TEXT,
   [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]);