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

49 rows where country_or_region = "Japan" and "day" is on date 2022-07-15 sorted by day descending

✎ View and edit SQL

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

country_or_region 1

  • Japan · 49 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2418875 2418875 2022-07-15 Japan Aichi     618868 2109 0   35.035551 137.211621 2022-07-16 04:21:05 Aichi, Japan
2418876 2418876 2022-07-15 Japan Akita     34115 72 0   39.748679 140.408228 2022-07-16 04:21:05 Akita, Japan
2418877 2418877 2022-07-15 Japan Aomori     70810 118 0   40.781541 140.828896 2022-07-16 04:21:05 Aomori, Japan
2418878 2418878 2022-07-15 Japan Chiba     497650 1814 0   35.510141 140.198917 2022-07-16 04:21:05 Chiba, Japan
2418879 2418879 2022-07-15 Japan Ehime     53015 144 0   33.624835 132.856842 2022-07-16 04:21:05 Ehime, Japan
2418880 2418880 2022-07-15 Japan Fukui     42825 47 0   35.846614 136.224654 2022-07-16 04:21:05 Fukui, Japan
2418881 2418881 2022-07-15 Japan Fukuoka     493730 1292 0   33.526032 130.666949 2022-07-16 04:21:05 Fukuoka, Japan
2418882 2418882 2022-07-15 Japan Fukushima     70442 228 0   37.378867 140.223295 2022-07-16 04:21:05 Fukushima, Japan
2418883 2418883 2022-07-15 Japan Gifu     117018 351 0   35.778671 137.055925 2022-07-16 04:21:05 Gifu, Japan
2418884 2418884 2022-07-15 Japan Gunma     104995 323 0   36.504479 138.985605 2022-07-16 04:21:05 Gunma, Japan
2418885 2418885 2022-07-15 Japan Hiroshima     179300 499 0   34.605309 132.788719 2022-07-16 04:21:05 Hiroshima, Japan
2418886 2418886 2022-07-15 Japan Hokkaido     395192 2105 0   43.385711 142.552318 2022-07-16 04:21:05 Hokkaido, Japan
2418887 2418887 2022-07-15 Japan Hyogo     478738 2260 0   35.039913 134.828057 2022-07-16 04:21:05 Hyogo, Japan
2418888 2418888 2022-07-15 Japan Ibaraki     172407 455 0   36.303588 140.319591 2022-07-16 04:21:05 Ibaraki, Japan
2418889 2418889 2022-07-15 Japan Ishikawa     65023 199 0   36.769464 136.771027 2022-07-16 04:21:05 Ishikawa, Japan
2418890 2418890 2022-07-15 Japan Iwate     41923 98 0   39.593287 141.361777 2022-07-16 04:21:05 Iwate, Japan
2418891 2418891 2022-07-15 Japan Kagawa     54576 132 0   34.217292 133.969047 2022-07-16 04:21:05 Kagawa, Japan
2418892 2418892 2022-07-15 Japan Kagoshima     107261 217 0   31.009484 130.430665 2022-07-16 04:21:05 Kagoshima, Japan
2418893 2418893 2022-07-15 Japan Kanagawa     836549 2251 0   35.415312 139.338983 2022-07-16 04:21:05 Kanagawa, Japan
2418894 2418894 2022-07-15 Japan Kochi     33819 116 0   33.422519 133.367307 2022-07-16 04:21:05 Kochi, Japan
2418895 2418895 2022-07-15 Japan Kumamoto     134819 323 0   32.608154 130.745231 2022-07-16 04:21:05 Kumamoto, Japan
2418896 2418896 2022-07-15 Japan Kyoto     228469 758 0   35.253815 135.443341 2022-07-16 04:21:05 Kyoto, Japan
2418897 2418897 2022-07-15 Japan Mie     96001 317 0   34.508018 136.376013 2022-07-16 04:21:05 Mie, Japan
2418898 2418898 2022-07-15 Japan Miyagi     100858 204 0   38.446859 140.927086 2022-07-16 04:21:05 Miyagi, Japan
2418899 2418899 2022-07-15 Japan Miyazaki     67080 150 0   32.193204 131.299374 2022-07-16 04:21:05 Miyazaki, Japan
2418900 2418900 2022-07-15 Japan Nagano     83211 206 0   36.132134 138.045528 2022-07-16 04:21:05 Nagano, Japan
2418901 2418901 2022-07-15 Japan Nagasaki     74203 129 0   33.235712 129.608033 2022-07-16 04:21:05 Nagasaki, Japan
2418902 2418902 2022-07-15 Japan Nara     101904 394 0   34.317451 135.871644 2022-07-16 04:21:05 Nara, Japan
2418903 2418903 2022-07-15 Japan Niigata     80681 91 0   37.521819 138.918647 2022-07-16 04:21:05 Niigata, Japan
2418904 2418904 2022-07-15 Japan Oita     67455 174 0   33.200697 131.43324 2022-07-16 04:21:05 Oita, Japan
2418905 2418905 2022-07-15 Japan Okayama     110607 252 0   34.89246 133.826252 2022-07-16 04:21:05 Okayama, Japan
2418906 2418906 2022-07-15 Japan Okinawa     287874 497 0   25.768923 126.668016 2022-07-16 04:21:05 Okinawa, Japan
2418907 2418907 2022-07-15 Japan Osaka     1093837 5231 0   34.620965 135.507481 2022-07-16 04:21:05 Osaka, Japan
2418908 2418908 2022-07-15 Japan Port Quarantine     20156 8 0       2021-11-10 23:21:44 Port Quarantine, Japan
2418909 2418909 2022-07-15 Japan Saga     67181 114 0   33.286977 130.115738 2022-07-16 04:21:05 Saga, Japan
2418910 2418910 2022-07-15 Japan Saitama     608791 1668 0   35.997101 139.347635 2022-07-16 04:21:05 Saitama, Japan
2418911 2418911 2022-07-15 Japan Shiga     102726 223 0   35.215827 136.138064 2022-07-16 04:21:05 Shiga, Japan
2418912 2418912 2022-07-15 Japan Shimane     30043 27 0   35.07076 132.554064 2022-07-16 04:21:05 Shimane, Japan
2418913 2418913 2022-07-15 Japan Shizuoka     195882 425 0   34.916975 138.407784 2022-07-16 04:21:05 Shizuoka, Japan
2418914 2418914 2022-07-15 Japan Tochigi     99325 282 0   36.689912 139.819213 2022-07-16 04:21:05 Tochigi, Japan
2418915 2418915 2022-07-15 Japan Tokushima     26816 86 0   33.919178 134.242091 2022-07-16 04:21:05 Tokushima, Japan
2418916 2418916 2022-07-15 Japan Tokyo     1733041 4594 0   35.711343 139.446921 2022-07-16 04:21:05 Tokyo, Japan
2418917 2418917 2022-07-15 Japan Tottori     20316 20 0   35.359069 133.863619 2022-07-16 04:21:05 Tottori, Japan
2418918 2418918 2022-07-15 Japan Toyama     43655 97 0   36.637464 137.269346 2022-07-16 04:21:05 Toyama, Japan
2418919 2418919 2022-07-15 Japan Unknown     8 0 0       2021-11-10 23:21:44 Unknown, Japan
2418920 2418920 2022-07-15 Japan Wakayama     50331 118 0   33.911879 135.505446 2022-07-16 04:21:05 Wakayama, Japan
2418921 2418921 2022-07-15 Japan Yamagata     32814 98 0   38.448396 140.102154 2022-07-16 04:21:05 Yamagata, Japan
2418922 2418922 2022-07-15 Japan Yamaguchi     54206 181 0   34.20119 131.573293 2022-07-16 04:21:05 Yamaguchi, Japan
2418923 2418923 2022-07-15 Japan Yamanashi     37601 68 0   35.612364 138.611489 2022-07-16 04:21:05 Yamanashi, Japan

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]);