daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
176 rows where country_or_region = "Japan" and deaths = 86 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 29
country_or_region 1
- Japan · 176 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-04 | Japan | Tottori | 70189 | 86 | 0 | 35.359069 | 133.863619 | 2022-11-05 04:21:52 | Tottori, Japan | |||
2022-11-03 | Japan | Tottori | 70012 | 86 | 0 | 35.359069 | 133.863619 | 2022-11-04 04:22:11 | Tottori, Japan | |||
2022-11-02 | Japan | Tottori | 69625 | 86 | 0 | 35.359069 | 133.863619 | 2022-11-03 04:22:05 | Tottori, Japan | |||
2022-11-01 | Japan | Tottori | 69219 | 86 | 0 | 35.359069 | 133.863619 | 2022-11-02 04:22:09 | Tottori, Japan | |||
2022-10-31 | Japan | Tottori | 68916 | 86 | 0 | 35.359069 | 133.863619 | 2022-11-01 04:22:36 | Tottori, Japan | |||
2022-10-30 | Japan | Tottori | 68761 | 86 | 0 | 35.359069 | 133.863619 | 2022-10-31 04:21:36 | Tottori, Japan | |||
2022-10-29 | Japan | Tottori | 68468 | 86 | 0 | 35.359069 | 133.863619 | 2022-10-30 04:22:14 | Tottori, Japan | |||
2022-10-28 | Japan | Tottori | 68217 | 86 | 0 | 35.359069 | 133.863619 | 2022-10-29 04:21:13 | Tottori, Japan | |||
2022-10-27 | Japan | Tottori | 67957 | 86 | 0 | 35.359069 | 133.863619 | 2022-10-28 04:22:31 | Tottori, Japan | |||
2022-10-26 | Japan | Tottori | 67731 | 86 | 0 | 35.359069 | 133.863619 | 2022-10-27 04:22:01 | Tottori, Japan | |||
2022-10-25 | Japan | Tottori | 67476 | 86 | 0 | 35.359069 | 133.863619 | 2022-10-26 04:22:19 | Tottori, Japan | |||
2022-10-24 | Japan | Tottori | 67210 | 86 | 0 | 35.359069 | 133.863619 | 2022-10-25 04:21:53 | Tottori, Japan | |||
2022-10-23 | Japan | Tottori | 67112 | 86 | 0 | 35.359069 | 133.863619 | 2022-10-24 04:22:29 | Tottori, Japan | |||
2022-10-22 | Japan | Tottori | 66935 | 86 | 0 | 35.359069 | 133.863619 | 2022-10-23 04:22:46 | Tottori, Japan | |||
2022-09-01 | Japan | Akita | 82679 | 86 | 0 | 39.748679 | 140.408228 | 2022-09-02 04:21:07 | Akita, Japan | |||
2022-08-31 | Japan | Akita | 81613 | 86 | 0 | 39.748679 | 140.408228 | 2022-09-01 04:21:03 | Akita, Japan | |||
2022-08-30 | Japan | Akita | 80282 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-31 04:20:57 | Akita, Japan | |||
2022-08-29 | Japan | Akita | 78718 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-30 04:21:03 | Akita, Japan | |||
2022-08-28 | Japan | Akita | 78280 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-29 04:21:06 | Akita, Japan | |||
2022-08-27 | Japan | Akita | 77499 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-28 04:21:02 | Akita, Japan | |||
2022-08-26 | Japan | Akita | 76240 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-27 04:20:57 | Akita, Japan | |||
2022-08-25 | Japan | Akita | 74928 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-26 04:21:02 | Akita, Japan | |||
2022-08-24 | Japan | Akita | 73463 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-25 04:21:13 | Akita, Japan | |||
2022-08-23 | Japan | Akita | 71790 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-24 04:20:46 | Akita, Japan | |||
2022-08-22 | Japan | Akita | 69919 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-23 04:20:56 | Akita, Japan | |||
2022-08-21 | Japan | Akita | 69184 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-22 04:20:38 | Akita, Japan | |||
2022-08-20 | Japan | Akita | 67764 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-21 04:20:44 | Akita, Japan | |||
2022-08-19 | Japan | Akita | 65941 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-20 04:21:01 | Akita, Japan | |||
2022-08-18 | Japan | Akita | 64196 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-19 04:20:54 | Akita, Japan | |||
2022-08-17 | Japan | Akita | 62331 | 86 | 0 | 39.748679 | 140.408228 | 2022-08-18 04:21:11 | Akita, Japan | |||
2022-07-22 | Japan | Tokushima | 29642 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-23 04:20:53 | Tokushima, Japan | |||
2022-07-21 | Japan | Tokushima | 29047 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-22 04:21:15 | Tokushima, Japan | |||
2022-07-20 | Japan | Tokushima | 28308 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-21 04:21:10 | Tokushima, Japan | |||
2022-07-19 | Japan | Tokushima | 28011 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-20 04:20:59 | Tokushima, Japan | |||
2022-07-18 | Japan | Tokushima | 27803 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-19 04:20:58 | Tokushima, Japan | |||
2022-07-17 | Japan | Tokushima | 27517 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-18 04:20:59 | Tokushima, Japan | |||
2022-07-16 | Japan | Tokushima | 27151 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-17 04:21:15 | Tokushima, Japan | |||
2022-07-15 | Japan | Tokushima | 26816 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-16 04:21:05 | Tokushima, Japan | |||
2022-07-14 | Japan | Tokushima | 26518 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-15 04:20:53 | Tokushima, Japan | |||
2022-07-13 | Japan | Tokushima | 26201 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-14 04:20:57 | Tokushima, Japan | |||
2022-07-12 | Japan | Tokushima | 25923 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-13 04:20:58 | Tokushima, Japan | |||
2022-07-11 | Japan | Tokushima | 25693 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-12 04:20:51 | Tokushima, Japan | |||
2022-07-10 | Japan | Tokushima | 25565 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-11 04:20:46 | Tokushima, Japan | |||
2022-07-09 | Japan | Tokushima | 25421 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-10 04:20:54 | Tokushima, Japan | |||
2022-07-08 | Japan | Tokushima | 25278 | 86 | 0 | 33.919178 | 134.242091 | 2022-07-09 04:20:59 | Tokushima, Japan | |||
2022-05-23 | Japan | Iwate | 33150 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-24 04:20:57 | Iwate, Japan | |||
2022-05-21 | Japan | Iwate | 32824 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-22 04:20:52 | Iwate, Japan | |||
2022-05-20 | Japan | Iwate | 32601 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-21 04:20:58 | Iwate, Japan | |||
2022-05-19 | Japan | Iwate | 32331 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-20 04:20:57 | Iwate, Japan | |||
2022-05-18 | Japan | Iwate | 32069 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-19 04:20:54 | Iwate, Japan | |||
2022-05-17 | Japan | Iwate | 31787 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-18 04:20:50 | Iwate, Japan | |||
2022-05-16 | Japan | Iwate | 31547 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-17 04:20:59 | Iwate, Japan | |||
2022-05-15 | Japan | Iwate | 31373 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-16 04:20:47 | Iwate, Japan | |||
2022-05-14 | Japan | Iwate | 31076 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-15 04:20:53 | Iwate, Japan | |||
2022-05-13 | Japan | Iwate | 30815 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-14 04:20:48 | Iwate, Japan | |||
2022-05-12 | Japan | Iwate | 30523 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-13 04:20:51 | Iwate, Japan | |||
2022-05-11 | Japan | Iwate | 30248 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-12 04:20:54 | Iwate, Japan | |||
2022-05-10 | Japan | Iwate | 29934 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-11 04:20:48 | Iwate, Japan | |||
2022-05-09 | Japan | Iwate | 29626 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-10 04:20:50 | Iwate, Japan | |||
2022-05-08 | Japan | Iwate | 29394 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-09 04:20:54 | Iwate, Japan | |||
2022-05-07 | Japan | Iwate | 29032 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-08 04:20:49 | Iwate, Japan | |||
2022-05-06 | Japan | Iwate | 28762 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-07 04:21:09 | Iwate, Japan | |||
2022-05-05 | Japan | Iwate | 28582 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-06 04:21:00 | Iwate, Japan | |||
2022-05-04 | Japan | Iwate | 28385 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-05 04:20:55 | Iwate, Japan | |||
2022-05-03 | Japan | Iwate | 28164 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-04 04:20:59 | Iwate, Japan | |||
2022-05-02 | Japan | Iwate | 27952 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-03 04:21:00 | Iwate, Japan | |||
2022-05-01 | Japan | Iwate | 27827 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-02 04:21:10 | Iwate, Japan | |||
2022-04-30 | Japan | Iwate | 27616 | 86 | 0 | 39.593287 | 141.361777 | 2022-05-01 04:20:57 | Iwate, Japan | |||
2022-04-29 | Japan | Iwate | 27421 | 86 | 0 | 39.593287 | 141.361777 | 2022-04-30 04:21:05 | Iwate, Japan | |||
2022-04-26 | Japan | Yamagata | 22554 | 86 | 0 | 38.448396 | 140.102154 | 2022-04-27 04:20:52 | Yamagata, Japan | |||
2022-04-05 | Japan | Aomori | 38416 | 86 | 0 | 40.781541 | 140.828896 | 2022-04-06 04:20:49 | Aomori, Japan | |||
2022-04-04 | Japan | Aomori | 38007 | 86 | 0 | 40.781541 | 140.828896 | 2022-04-05 04:20:48 | Aomori, Japan | |||
2022-04-03 | Japan | Aomori | 37758 | 86 | 0 | 40.781541 | 140.828896 | 2022-04-04 04:20:51 | Aomori, Japan | |||
2022-03-09 | Japan | Kagawa | 22052 | 86 | 0 | 34.217292 | 133.969047 | 2022-03-10 04:20:48 | Kagawa, Japan | |||
2022-02-27 | Japan | Miyazaki | 18366 | 86 | 0 | 32.193203999999994 | 131.299374 | 2022-02-28 04:21:05 | Miyazaki, Japan | |||
2022-02-26 | Japan | Miyazaki | 18134 | 86 | 0 | 32.193203999999994 | 131.299374 | 2022-02-27 04:21:04 | Miyazaki, Japan | |||
2022-02-08 | Japan | Kagoshima | 21372 | 86 | 0 | 31.009484000000004 | 130.430665 | 2022-02-09 04:21:04 | Kagoshima, Japan | |||
2022-02-04 | Japan | Oita | 15364 | 86 | 0 | 33.200697 | 131.43323999999998 | 2022-02-05 04:21:05 | Oita, Japan | |||
2022-02-03 | Japan | Oita | 14864 | 86 | 0 | 33.200697 | 131.43323999999998 | 2022-02-04 04:21:10 | Oita, Japan | |||
2022-02-01 | Japan | Ehime | 10671 | 86 | 0 | 33.624835 | 132.856842 | 2022-02-02 04:21:09 | Ehime, Japan | |||
2021-09-02 | Japan | Yamaguchi | 5083 | 86 | 0 | 34.201190000000004 | 131.573293 | 2021-09-03 04:21:20 | Yamaguchi, Japan | |||
2021-09-01 | Japan | Yamaguchi | 5029 | 86 | 0 | 34.201190000000004 | 131.573293 | 2021-09-02 04:21:15 | Yamaguchi, Japan | |||
2021-08-01 | Japan | Tochigi | 8387 | 86 | 7409 | 892 | 36.689912 | 139.819213 | 2021-08-02 04:21:36 | Tochigi, Japan | ||
2021-06-22 | Japan | Miyagi | 9075 | 86 | 8906 | 83 | 38.446859 | 140.927086 | 2021-06-23 04:21:46 | Miyagi, Japan | ||
2021-06-21 | Japan | Miyagi | 9068 | 86 | 8898 | 84 | 38.446859 | 140.927086 | 2021-06-22 04:21:34 | Miyagi, Japan | ||
2021-06-20 | Japan | Miyagi | 9066 | 86 | 8891 | 89 | 38.446859 | 140.927086 | 2021-06-21 04:21:41 | Miyagi, Japan | ||
2021-06-19 | Japan | Miyagi | 9064 | 86 | 8885 | 93 | 38.446859 | 140.927086 | 2021-06-20 04:21:48 | Miyagi, Japan | ||
2021-06-18 | Japan | Miyagi | 9061 | 86 | 8873 | 102 | 38.446859 | 140.927086 | 2021-06-19 04:22:33 | Miyagi, Japan | ||
2021-06-15 | Japan | Shiga | 5430 | 86 | 5079 | 265 | 35.21582700000001 | 136.138064 | 2021-06-16 04:22:32 | Shiga, Japan | ||
2021-05-22 | Japan | Okayama | 6847 | 86 | 5045 | 1716 | 34.89246 | 133.826252 | 2021-05-23 04:20:51 | Okayama, Japan | ||
2021-05-16 | Japan | Kumamoto | 5415 | 86 | 4179 | 1150 | 32.608154 | 130.74523100000002 | 2021-05-17 04:20:34 | Kumamoto, Japan | ||
2021-05-09 | Japan | Nara | 6814 | 86 | 5841 | 887 | 34.317451 | 135.871644 | 2021-05-10 04:20:38 | Nara, Japan | ||
2021-05-08 | Japan | Nara | 6722 | 86 | 5721 | 915 | 34.317451 | 135.871644 | 2021-05-09 04:20:35 | Nara, Japan | ||
2021-05-07 | Japan | Nara | 6636 | 86 | 5616 | 934 | 34.317451 | 135.871644 | 2021-05-08 04:21:04 | Nara, Japan | ||
2021-03-09 | Japan | Fukushima | 2121 | 86 | 1813 | 222 | 37.378867 | 140.223295 | 2021-03-10 05:24:35 | Fukushima, Japan | ||
2021-03-05 | Japan | Gunma | 4578 | 86 | 4279 | 213 | 36.504479 | 138.985605 | 2021-03-06 04:23:41 | Gunma, Japan | ||
2021-03-04 | Japan | Gunma | 4566 | 86 | 4260 | 220 | 36.504479 | 138.985605 | 2021-03-05 05:26:29 | Gunma, Japan | ||
2021-02-10 | Japan | Ibaraki | 5246 | 86 | 4629 | 531 | 36.303588 | 140.319591 | 2021-02-11 05:23:55 | Ibaraki, Japan | ||
2021-02-08 | Japan | Shizuoka | 4755 | 86 | 4308 | 361 | 34.916975 | 138.40778400000002 | 2021-02-09 05:23:30 | Shizuoka, Japan | ||
2021-02-07 | Japan | Shizuoka | 4748 | 86 | 4291 | 371 | 34.916975 | 138.40778400000002 | 2021-02-08 05:22:39 | Shizuoka, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;