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 last_update = "2021-07-05 04:21:28" sorted by day descending

✎ View and edit SQL

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

Suggested facets: last_update (date)

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
1165168 1165168 2021-07-04 Japan Aichi     51294 971 49476 847 35.035551 137.211621 2021-07-05 04:21:28 Aichi, Japan
1165169 1165169 2021-07-04 Japan Akita     907 20 783 104 39.748679 140.408228 2021-07-05 04:21:28 Akita, Japan
1165170 1165170 2021-07-04 Japan Aomori     2520 31 2423 66 40.781541 140.828896 2021-07-05 04:21:28 Aomori, Japan
1165171 1165171 2021-07-04 Japan Chiba     40874 710 38827 1337 35.510141 140.198917 2021-07-05 04:21:28 Chiba, Japan
1165172 1165172 2021-07-04 Japan Ehime     2755 75 2675 5 33.624835 132.856842 2021-07-05 04:21:28 Ehime, Japan
1165173 1165173 2021-07-04 Japan Fukui     1327 35 1138 154 35.846614 136.22465400000002 2021-07-05 04:21:28 Fukui, Japan
1165174 1165174 2021-07-04 Japan Fukuoka     35638 522 34694 422 33.526032 130.666949 2021-07-05 04:21:28 Fukuoka, Japan
1165175 1165175 2021-07-04 Japan Fukushima     4962 161 4632 169 37.378867 140.223295 2021-07-05 04:21:28 Fukushima, Japan
1165176 1165176 2021-07-04 Japan Gifu     9282 187 9194 0 35.778671 137.055925 2021-07-05 04:21:28 Gifu, Japan
1165177 1165177 2021-07-04 Japan Gunma     8051 152 7847 52 36.504479 138.985605 2021-07-05 04:21:28 Gunma, Japan
1165178 1165178 2021-07-04 Japan Hiroshima     11525 175 11231 119 34.605309000000005 132.788719 2021-07-05 04:21:28 Hiroshima, Japan
1165179 1165179 2021-07-04 Japan Hokkaido     41466 1405 39316 745 43.385711 142.552318 2021-07-05 04:21:28 Hokkaido, Japan
1165180 1165180 2021-07-04 Japan Hyogo     41030 1308 39422 300 35.039913 134.828057 2021-07-05 04:21:28 Hyogo, Japan
1165181 1165181 2021-07-04 Japan Ibaraki     10651 165 10199 287 36.303588 140.319591 2021-07-05 04:21:28 Ibaraki, Japan
1165182 1165182 2021-07-04 Japan Ishikawa     3954 115 3799 40 36.769464 136.771027 2021-07-05 04:21:28 Ishikawa, Japan
1165183 1165183 2021-07-04 Japan Iwate     1713 47 1597 69 39.593287 141.361777 2021-07-05 04:21:28 Iwate, Japan
1165184 1165184 2021-07-04 Japan Kagawa     2099 31 2055 13 34.217292 133.969047 2021-07-05 04:21:28 Kagawa, Japan
1165185 1165185 2021-07-04 Japan Kagoshima     3698 38 3633 27 31.009484000000004 130.430665 2021-07-05 04:21:28 Kagoshima, Japan
1165186 1165186 2021-07-04 Japan Kanagawa     68311 952 65251 2108 35.415312 139.338983 2021-07-05 04:21:28 Kanagawa, Japan
1165187 1165187 2021-07-04 Japan Kochi     1851 26 1731 94 33.422519 133.367307 2021-07-05 04:21:28 Kochi, Japan
1165188 1165188 2021-07-04 Japan Kumamoto     6491 118 6308 65 32.608154 130.74523100000002 2021-07-05 04:21:28 Kumamoto, Japan
1165189 1165189 2021-07-04 Japan Kyoto     16658 246 16242 170 35.253815 135.443341 2021-07-05 04:21:28 Kyoto, Japan
1165190 1165190 2021-07-04 Japan Mie     5278 112 5227 0 34.508018 136.376013 2021-07-05 04:21:28 Mie, Japan
1165191 1165191 2021-07-04 Japan Miyagi     9187 90 8991 106 38.446859 140.927086 2021-07-05 04:21:28 Miyagi, Japan
1165192 1165192 2021-07-04 Japan Miyazaki     3094 27 3028 39 32.193203999999994 131.299374 2021-07-05 04:21:28 Miyazaki, Japan
1165193 1165193 2021-07-04 Japan Nagano     5039 91 4974 0 36.132134 138.045528 2021-07-05 04:21:28 Nagano, Japan
1165194 1165194 2021-07-04 Japan Nagasaki     3216 69 3056 91 33.235712 129.608033 2021-07-05 04:21:28 Nagasaki, Japan
1165195 1165195 2021-07-04 Japan Nara     8246 131 8056 59 34.317451 135.871644 2021-07-05 04:21:28 Nara, Japan
1165196 1165196 2021-07-04 Japan Niigata     3423 52 3326 45 37.521819 138.918647 2021-07-05 04:21:28 Niigata, Japan
1165197 1165197 2021-07-04 Japan Oita     3494 64 3414 16 33.200697 131.43323999999998 2021-07-05 04:21:28 Oita, Japan
1165198 1165198 2021-07-04 Japan Okayama     7596 126 7439 31 34.89246 133.826252 2021-07-05 04:21:28 Okayama, Japan
1165199 1165199 2021-07-04 Japan Okinawa     20991 191 19839 961 25.768923 126.668016 2021-07-05 04:21:28 Okinawa, Japan
1165200 1165200 2021-07-04 Japan Osaka     103849 2680 99047 2122 34.620965000000005 135.507481 2021-07-05 04:21:28 Osaka, Japan
1165201 1165201 2021-07-04 Japan Port Quarantine     3177 5 3051 122     2021-07-05 04:21:28 Port Quarantine, Japan
1165202 1165202 2021-07-04 Japan Saga     2565 24 2558 0 33.286977 130.115738 2021-07-05 04:21:28 Saga, Japan
1165203 1165203 2021-07-04 Japan Saitama     46940 832 44801 1307 35.997101 139.347635 2021-07-05 04:21:28 Saitama, Japan
1165204 1165204 2021-07-04 Japan Shiga     5571 90 5406 75 35.21582700000001 136.138064 2021-07-05 04:21:28 Shiga, Japan
1165205 1165205 2021-07-04 Japan Shimane     553 1 549 3 35.07076 132.55406399999998 2021-07-05 04:21:28 Shimane, Japan
1165206 1165206 2021-07-04 Japan Shizuoka     9401 152 8961 288 34.916975 138.40778400000002 2021-07-05 04:21:28 Shizuoka, Japan
1165207 1165207 2021-07-04 Japan Tochigi     7120 82 6770 268 36.689912 139.819213 2021-07-05 04:21:28 Tochigi, Japan
1165208 1165208 2021-07-04 Japan Tokushima     1657 63 1591 3 33.919178 134.242091 2021-07-05 04:21:28 Tokushima, Japan
1165209 1165209 2021-07-04 Japan Tokyo     176476 2239 168764 5473 35.711343 139.446921 2021-07-05 04:21:28 Tokyo, Japan
1165210 1165210 2021-07-04 Japan Tottori     491 2 457 32 35.359069 133.863619 2021-07-05 04:21:28 Tottori, Japan
1165211 1165211 2021-07-04 Japan Toyama     2042 38 1985 19 36.637464 137.26934599999998 2021-07-05 04:21:28 Toyama, Japan
1165212 1165212 2021-07-04 Japan Unknown     8 0 8 0     2021-07-05 04:21:28 Unknown, Japan
1165213 1165213 2021-07-04 Japan Wakayama     2693 49 2563 81 33.911879 135.505446 2021-07-05 04:21:28 Wakayama, Japan
1165214 1165214 2021-07-04 Japan Yamagata     2028 47 1965 16 38.448396 140.102154 2021-07-05 04:21:28 Yamagata, Japan
1165215 1165215 2021-07-04 Japan Yamaguchi     3159 80 3021 58 34.201190000000004 131.573293 2021-07-05 04:21:28 Yamaguchi, Japan
1165216 1165216 2021-07-04 Japan Yamanashi     2124 21 2004 99 35.612364 138.61148899999998 2021-07-05 04:21:28 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]);