johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where country_or_region = "Japan" and "day" is on date 2022-08-30 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state >30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3773891 | 3773891 | 2022-08-30 | Japan | Aichi | 1197330 | 2603 | 0 | 35.035551 | 137.211621 | 2022-08-31 04:20:57 | Aichi, Japan | |||
3773892 | 3773892 | 2022-08-30 | Japan | Akita | 80282 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-31 04:20:57 | Akita, Japan | |||
3773893 | 3773893 | 2022-08-30 | Japan | Aomori | 139556 | 211 | 0 | 40.781541 | 140.828896 | 2022-08-31 04:20:57 | Aomori, Japan | |||
3773894 | 3773894 | 2022-08-30 | Japan | Chiba | 840259 | 2235 | 0 | 35.510141 | 140.198917 | 2022-08-31 04:20:57 | Chiba, Japan | |||
3773895 | 3773895 | 2022-08-30 | Japan | Ehime | 137151 | 261 | 0 | 33.624835 | 132.856842 | 2022-08-31 04:20:57 | Ehime, Japan | |||
3773896 | 3773896 | 2022-08-30 | Japan | Fukui | 95092 | 80 | 0 | 35.846614 | 136.224654 | 2022-08-31 04:20:57 | Fukui, Japan | |||
3773897 | 3773897 | 2022-08-30 | Japan | Fukuoka | 977370 | 1719 | 0 | 33.526032 | 130.666949 | 2022-08-31 04:20:57 | Fukuoka, Japan | |||
3773898 | 3773898 | 2022-08-30 | Japan | Fukushima | 150630 | 244 | 0 | 37.378867 | 140.223295 | 2022-08-31 04:20:57 | Fukushima, Japan | |||
3773899 | 3773899 | 2022-08-30 | Japan | Gifu | 247459 | 476 | 0 | 35.778671 | 137.055925 | 2022-08-31 04:20:57 | Gifu, Japan | |||
3773900 | 3773900 | 2022-08-30 | Japan | Gunma | 201894 | 421 | 0 | 36.504479 | 138.985605 | 2022-08-31 04:20:57 | Gunma, Japan | |||
3773901 | 3773901 | 2022-08-30 | Japan | Hiroshima | 359699 | 645 | 0 | 34.605309 | 132.788719 | 2022-08-31 04:20:57 | Hiroshima, Japan | |||
3773902 | 3773902 | 2022-08-30 | Japan | Hokkaido | 644677 | 2408 | 0 | 43.385711 | 142.552318 | 2022-08-31 04:20:57 | Hokkaido, Japan | |||
3773903 | 3773903 | 2022-08-30 | Japan | Hyogo | 896896 | 2617 | 0 | 35.039913 | 134.828057 | 2022-08-31 04:20:57 | Hyogo, Japan | |||
3773904 | 3773904 | 2022-08-30 | Japan | Ibaraki | 314145 | 580 | 0 | 36.303588 | 140.319591 | 2022-08-31 04:20:57 | Ibaraki, Japan | |||
3773905 | 3773905 | 2022-08-30 | Japan | Ishikawa | 135535 | 233 | 0 | 36.769464 | 136.771027 | 2022-08-31 04:20:57 | Ishikawa, Japan | |||
3773906 | 3773906 | 2022-08-30 | Japan | Iwate | 89840 | 163 | 0 | 39.593287 | 141.361777 | 2022-08-31 04:20:57 | Iwate, Japan | |||
3773907 | 3773907 | 2022-08-30 | Japan | Kagawa | 120600 | 245 | 0 | 34.217292 | 133.969047 | 2022-08-31 04:20:57 | Kagawa, Japan | |||
3773908 | 3773908 | 2022-08-30 | Japan | Kagoshima | 255869 | 420 | 0 | 31.009484 | 130.430665 | 2022-08-31 04:20:57 | Kagoshima, Japan | |||
3773909 | 3773909 | 2022-08-30 | Japan | Kanagawa | 1350154 | 2752 | 0 | 35.415312 | 139.338983 | 2022-08-31 04:20:57 | Kanagawa, Japan | |||
3773910 | 3773910 | 2022-08-30 | Japan | Kochi | 83565 | 234 | 0 | 33.422519 | 133.367307 | 2022-08-31 04:20:57 | Kochi, Japan | |||
3773911 | 3773911 | 2022-08-30 | Japan | Kumamoto | 291594 | 539 | 0 | 32.608154 | 130.745231 | 2022-08-31 04:20:57 | Kumamoto, Japan | |||
3773912 | 3773912 | 2022-08-30 | Japan | Kyoto | 422731 | 899 | 0 | 35.253815 | 135.443341 | 2022-08-31 04:20:57 | Kyoto, Japan | |||
3773913 | 3773913 | 2022-08-30 | Japan | Mie | 212183 | 451 | 0 | 34.508018 | 136.376013 | 2022-08-31 04:20:57 | Mie, Japan | |||
3773914 | 3773914 | 2022-08-30 | Japan | Miyagi | 223153 | 302 | 0 | 38.446859 | 140.927086 | 2022-08-31 04:20:57 | Miyagi, Japan | |||
3773915 | 3773915 | 2022-08-30 | Japan | Miyazaki | 166784 | 278 | 0 | 32.193204 | 131.299374 | 2022-08-31 04:20:57 | Miyazaki, Japan | |||
3773916 | 3773916 | 2022-08-30 | Japan | Nagano | 171602 | 292 | 0 | 36.132134 | 138.045528 | 2022-08-31 04:20:57 | Nagano, Japan | |||
3773917 | 3773917 | 2022-08-30 | Japan | Nagasaki | 183028 | 259 | 0 | 33.235712 | 129.608033 | 2022-08-31 04:20:57 | Nagasaki, Japan | |||
3773918 | 3773918 | 2022-08-30 | Japan | Nara | 192929 | 476 | 0 | 34.317451 | 135.871644 | 2022-08-31 04:20:57 | Nara, Japan | |||
3773919 | 3773919 | 2022-08-30 | Japan | Niigata | 192880 | 122 | 0 | 37.521819 | 138.918647 | 2022-08-31 04:20:57 | Niigata, Japan | |||
3773920 | 3773920 | 2022-08-30 | Japan | Oita | 152669 | 273 | 0 | 33.200697 | 131.43324 | 2022-08-31 04:20:57 | Oita, Japan | |||
3773921 | 3773921 | 2022-08-30 | Japan | Okayama | 228974 | 358 | 0 | 34.89246 | 133.826252 | 2022-08-31 04:20:57 | Okayama, Japan | |||
3773922 | 3773922 | 2022-08-30 | Japan | Okinawa | 472093 | 608 | 0 | 25.768923 | 126.668016 | 2022-08-31 04:20:57 | Okinawa, Japan | |||
3773923 | 3773923 | 2022-08-30 | Japan | Osaka | 1904044 | 5989 | 0 | 34.620965 | 135.507481 | 2022-08-31 04:20:57 | Osaka, Japan | |||
3773924 | 3773924 | 2022-08-30 | Japan | Port Quarantine | 21501 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
3773925 | 3773925 | 2022-08-30 | Japan | Saga | 139549 | 196 | 0 | 33.286977 | 130.115738 | 2022-08-31 04:20:57 | Saga, Japan | |||
3773926 | 3773926 | 2022-08-30 | Japan | Saitama | 1056228 | 2076 | 0 | 35.997101 | 139.347635 | 2022-08-31 04:20:57 | Saitama, Japan | |||
3773927 | 3773927 | 2022-08-30 | Japan | Shiga | 200186 | 286 | 0 | 35.215827 | 136.138064 | 2022-08-31 04:20:57 | Shiga, Japan | |||
3773928 | 3773928 | 2022-08-30 | Japan | Shimane | 69368 | 79 | 0 | 35.07076 | 132.554064 | 2022-08-31 04:20:57 | Shimane, Japan | |||
3773929 | 3773929 | 2022-08-30 | Japan | Shizuoka | 420536 | 645 | 0 | 34.916975 | 138.407784 | 2022-08-31 04:20:57 | Shizuoka, Japan | |||
3773930 | 3773930 | 2022-08-30 | Japan | Tochigi | 193169 | 427 | 0 | 36.689912 | 139.819213 | 2022-08-31 04:20:57 | Tochigi, Japan | |||
3773931 | 3773931 | 2022-08-30 | Japan | Tokushima | 76938 | 122 | 0 | 33.919178 | 134.242091 | 2022-08-31 04:20:57 | Tokushima, Japan | |||
3773932 | 3773932 | 2022-08-30 | Japan | Tokyo | 2910423 | 5293 | 0 | 35.711343 | 139.446921 | 2022-08-31 04:20:57 | Tokyo, Japan | |||
3773933 | 3773933 | 2022-08-30 | Japan | Tottori | 53489 | 54 | 0 | 35.359069 | 133.863619 | 2022-08-31 04:20:57 | Tottori, Japan | |||
3773934 | 3773934 | 2022-08-30 | Japan | Toyama | 106004 | 137 | 0 | 36.637464 | 137.269346 | 2022-08-31 04:20:57 | Toyama, Japan | |||
3773935 | 3773935 | 2022-08-30 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
3773936 | 3773936 | 2022-08-30 | Japan | Wakayama | 114647 | 206 | 0 | 33.911879 | 135.505446 | 2022-08-31 04:20:57 | Wakayama, Japan | |||
3773937 | 3773937 | 2022-08-30 | Japan | Yamagata | 80615 | 150 | 0 | 38.448396 | 140.102154 | 2022-08-31 04:20:57 | Yamagata, Japan | |||
3773938 | 3773938 | 2022-08-30 | Japan | Yamaguchi | 137630 | 326 | 0 | 34.20119 | 131.573293 | 2022-08-31 04:20:57 | Yamaguchi, Japan | |||
3773939 | 3773939 | 2022-08-30 | Japan | Yamanashi | 84382 | 120 | 0 | 35.612364 | 138.611489 | 2022-08-31 04:20:57 | Yamanashi, Japan |
Advanced export
JSON shape: default, array, newline-delimited
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]);