daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where country_or_region = "Japan" and deaths = 188 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 19
country_or_region 1
- Japan · 58 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-08 | Japan | Toyama | 145841 | 188 | 0 | 36.637464 | 137.269346 | 2022-11-09 04:21:22 | Toyama, Japan | |||
2022-11-07 | Japan | Toyama | 144882 | 188 | 0 | 36.637464 | 137.269346 | 2022-11-08 04:21:21 | Toyama, Japan | |||
2022-11-06 | Japan | Toyama | 144712 | 188 | 0 | 36.637464 | 137.269346 | 2022-11-07 04:21:26 | Toyama, Japan | |||
2022-11-05 | Japan | Tokushima | 98933 | 188 | 0 | 33.919178 | 134.242091 | 2022-11-06 04:21:24 | Tokushima, Japan | |||
2022-11-05 | Japan | Toyama | 144157 | 188 | 0 | 36.637464 | 137.269346 | 2022-11-06 04:21:24 | Toyama, Japan | |||
2022-11-04 | Japan | Tokushima | 98545 | 188 | 0 | 33.919178 | 134.242091 | 2022-11-05 04:21:52 | Tokushima, Japan | |||
2022-09-21 | Japan | Yamagata | 101452 | 188 | 0 | 38.448396 | 140.102154 | 2022-09-22 04:22:56 | Yamagata, Japan | |||
2022-08-23 | Japan | Wakayama | 104425 | 188 | 0 | 33.911879 | 135.505446 | 2022-08-24 04:20:46 | Wakayama, Japan | |||
2022-07-31 | Japan | Oita | 92043 | 188 | 0 | 33.200697 | 131.43324 | 2022-08-01 04:21:03 | Oita, Japan | |||
2022-07-30 | Japan | Oita | 90231 | 188 | 0 | 33.200697 | 131.43324 | 2022-07-31 04:21:02 | Oita, Japan | |||
2022-05-20 | Japan | Kagoshima | 77343 | 188 | 0 | 31.009484 | 130.430665 | 2022-05-21 04:20:58 | Kagoshima, Japan | |||
2022-05-19 | Japan | Kagoshima | 76639 | 188 | 0 | 31.009484 | 130.430665 | 2022-05-20 04:20:57 | Kagoshima, Japan | |||
2022-05-18 | Japan | Kagoshima | 75913 | 188 | 0 | 31.009484 | 130.430665 | 2022-05-19 04:20:54 | Kagoshima, Japan | |||
2022-05-17 | Japan | Kagoshima | 75157 | 188 | 0 | 31.009484 | 130.430665 | 2022-05-18 04:20:50 | Kagoshima, Japan | |||
2022-05-03 | Japan | Miyagi | 75106 | 188 | 0 | 38.446859 | 140.927086 | 2022-05-04 04:20:59 | Miyagi, Japan | |||
2022-05-02 | Japan | Miyagi | 74717 | 188 | 0 | 38.446859 | 140.927086 | 2022-05-03 04:21:00 | Miyagi, Japan | |||
2022-05-01 | Japan | Miyagi | 74489 | 188 | 0 | 38.446859 | 140.927086 | 2022-05-02 04:21:10 | Miyagi, Japan | |||
2022-04-30 | Japan | Miyagi | 74200 | 188 | 0 | 38.446859 | 140.927086 | 2022-05-01 04:20:57 | Miyagi, Japan | |||
2022-04-29 | Japan | Miyagi | 73923 | 188 | 0 | 38.446859 | 140.927086 | 2022-04-30 04:21:05 | Miyagi, Japan | |||
2022-04-28 | Japan | Miyagi | 73464 | 188 | 0 | 38.446859 | 140.927086 | 2022-04-29 04:20:59 | Miyagi, Japan | |||
2022-04-27 | Japan | Miyagi | 73020 | 188 | 0 | 38.446859 | 140.927086 | 2022-04-28 04:20:47 | Miyagi, Japan | |||
2022-04-22 | Japan | Ishikawa | 40831 | 188 | 0 | 36.769464 | 136.771027 | 2022-04-23 04:20:50 | Ishikawa, Japan | |||
2022-03-28 | Japan | Shiga | 67621 | 188 | 0 | 35.21582700000001 | 136.13806399999999 | 2022-03-29 04:20:46 | Shiga, Japan | |||
2022-03-27 | Japan | Shiga | 67233 | 188 | 0 | 35.21582700000001 | 136.13806399999999 | 2022-03-28 04:20:33 | Shiga, Japan | |||
2022-03-26 | Japan | Shiga | 66610 | 188 | 0 | 35.21582700000001 | 136.13806399999999 | 2022-03-27 04:20:47 | Shiga, Japan | |||
2022-03-25 | Japan | Shiga | 66114 | 188 | 0 | 35.21582700000001 | 136.13806399999999 | 2022-03-26 04:20:23 | Shiga, Japan | |||
2022-03-24 | Japan | Shiga | 65478 | 188 | 0 | 35.21582700000001 | 136.13806399999999 | 2022-03-25 04:20:46 | Shiga, Japan | |||
2022-03-23 | Japan | Shiga | 64793 | 188 | 0 | 35.21582700000001 | 136.13806399999999 | 2022-03-24 04:20:43 | Shiga, Japan | |||
2022-03-07 | Japan | Fukushima | 26491 | 188 | 0 | 37.378867 | 140.223295 | 2022-03-08 04:20:54 | Fukushima, Japan | |||
2022-03-06 | Japan | Fukushima | 26242 | 188 | 0 | 37.378867 | 140.223295 | 2022-03-07 04:20:47 | Fukushima, Japan | |||
2022-03-05 | Japan | Fukushima | 25897 | 188 | 0 | 37.378867 | 140.223295 | 2022-03-06 04:20:49 | Fukushima, Japan | |||
2022-03-04 | Japan | Fukushima | 25513 | 188 | 0 | 37.378867 | 140.223295 | 2022-03-05 04:21:10 | Fukushima, Japan | |||
2022-03-03 | Japan | Fukushima | 25187 | 188 | 0 | 37.378867 | 140.223295 | 2022-03-04 04:21:09 | Fukushima, Japan | |||
2022-03-02 | Japan | Fukushima | 24848 | 188 | 0 | 37.378867 | 140.223295 | 2022-03-03 04:21:01 | Fukushima, Japan | |||
2022-02-17 | Japan | Kumamoto | 42221 | 188 | 0 | 32.608154 | 130.74523100000002 | 2022-02-18 04:21:04 | Kumamoto, Japan | |||
2022-01-28 | Japan | Gunma | 27193 | 188 | 0 | 36.504478999999996 | 138.985605 | 2022-01-29 04:21:10 | Gunma, Japan | |||
2021-09-08 | Japan | Shizuoka | 24952 | 188 | 0 | 34.916975 | 138.40778400000002 | 2021-09-09 04:21:27 | Shizuoka, Japan | |||
2021-08-06 | Japan | Gifu | 9830 | 188 | 0 | 35.778671 | 137.055925 | 2021-08-07 04:21:30 | Gifu, Japan | |||
2021-08-05 | Japan | Gifu | 9785 | 188 | 0 | 35.778671 | 137.055925 | 2021-08-06 04:21:18 | Gifu, Japan | |||
2021-08-04 | Japan | Gifu | 9730 | 188 | 9454 | 88 | 35.778671 | 137.055925 | 2021-08-05 04:21:51 | Gifu, Japan | ||
2021-08-03 | Japan | Gifu | 9687 | 188 | 9441 | 58 | 35.778671 | 137.055925 | 2021-08-04 04:21:25 | Gifu, Japan | ||
2021-08-02 | Japan | Gifu | 9633 | 188 | 9428 | 17 | 35.778671 | 137.055925 | 2021-08-03 04:21:39 | Gifu, Japan | ||
2021-08-01 | Japan | Gifu | 9615 | 188 | 9412 | 15 | 35.778671 | 137.055925 | 2021-08-02 04:21:36 | Gifu, Japan | ||
2021-07-31 | Japan | Gifu | 9589 | 188 | 9399 | 2 | 35.778671 | 137.055925 | 2021-08-01 04:21:50 | Gifu, Japan | ||
2021-07-30 | Japan | Gifu | 9571 | 188 | 9392 | 0 | 35.778671 | 137.055925 | 2021-07-31 04:21:35 | Gifu, Japan | ||
2021-07-29 | Japan | Gifu | 9537 | 188 | 9379 | 0 | 35.778671 | 137.055925 | 2021-07-30 04:21:34 | Gifu, Japan | ||
2021-07-28 | Japan | Gifu | 9514 | 188 | 9368 | 0 | 35.778671 | 137.055925 | 2021-07-29 04:21:33 | Gifu, Japan | ||
2021-07-27 | Japan | Gifu | 9483 | 188 | 9357 | 0 | 35.778671 | 137.055925 | 2021-07-28 04:21:39 | Gifu, Japan | ||
2021-07-26 | Japan | Gifu | 9465 | 188 | 9347 | 0 | 35.778671 | 137.055925 | 2021-07-27 04:21:18 | Gifu, Japan | ||
2021-07-25 | Japan | Gifu | 9450 | 188 | 9337 | 0 | 35.778671 | 137.055925 | 2021-07-26 04:21:28 | Gifu, Japan | ||
2021-07-24 | Japan | Gifu | 9443 | 188 | 9325 | 0 | 35.778671 | 137.055925 | 2021-07-25 04:22:12 | Gifu, Japan | ||
2021-07-23 | Japan | Gifu | 9431 | 188 | 9316 | 0 | 35.778671 | 137.055925 | 2021-07-24 00:21:36 | Gifu, Japan | ||
2021-05-04 | Japan | Kyoto | 13067 | 188 | 10829 | 2050 | 35.253815 | 135.443341 | 2021-05-05 04:20:43 | Kyoto, Japan | ||
2020-12-28 | Japan | Hyogo | 9428 | 188 | 7871 | 1369 | 35.039913 | 134.828057 | 2020-12-29 05:22:37 | Hyogo, Japan | ||
2020-12-25 | Japan | Aichi | 15203 | 188 | 12304 | 2711 | 35.035551 | 137.211621 | 2020-12-26 05:22:28 | Aichi, Japan | ||
2020-11-24 | Japan | Kanagawa | 11477 | 188 | 10022 | 1267 | 35.415312 | 139.338983 | 2020-11-25 05:27:20 | Kanagawa, Japan | ||
2020-09-17 | Japan | Osaka | 9860 | 188 | 8794 | 878 | 34.620965 | 135.507481 | 2020-09-18 05:05:00 | Osaka, Japan | ||
2020-09-16 | Japan | Osaka | 9803 | 188 | 8700 | 915 | 34.620965 | 135.507481 | 2020-09-17 04:22:00 | Osaka, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;