johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
87 rows where country_or_region = "Japan" and deaths = 87 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
country_or_region 1
- Japan · 87 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2438767 | 2438767 | 2022-11-07 | Japan | Tottori | 71125 | 87 | 0 | 35.359069 | 133.863619 | 2022-11-08 04:21:21 | Tottori, Japan | |||
1049865 | 1049865 | 2022-11-06 | Japan | Tottori | 70929 | 87 | 0 | 35.359069 | 133.863619 | 2022-11-07 04:21:26 | Tottori, Japan | |||
617889 | 617889 | 2022-11-05 | Japan | Tottori | 70577 | 87 | 0 | 35.359069 | 133.863619 | 2022-11-06 04:21:24 | Tottori, Japan | |||
3824476 | 3824476 | 2022-09-10 | Japan | Shimane | 76489 | 87 | 0 | 35.07076 | 132.554064 | 2022-09-11 04:20:50 | Shimane, Japan | |||
962933 | 962933 | 2022-09-09 | Japan | Shimane | 75972 | 87 | 0 | 35.07076 | 132.554064 | 2022-09-10 04:21:10 | Shimane, Japan | |||
253335 | 253335 | 2022-09-08 | Japan | Shimane | 75350 | 87 | 0 | 35.07076 | 132.554064 | 2022-09-09 04:21:11 | Shimane, Japan | |||
3745133 | 3745133 | 2022-09-07 | Japan | Shimane | 74742 | 87 | 0 | 35.07076 | 132.554064 | 2022-09-08 04:21:02 | Shimane, Japan | |||
114773 | 114773 | 2022-09-06 | Japan | Shimane | 73996 | 87 | 0 | 35.07076 | 132.554064 | 2022-09-07 04:20:59 | Shimane, Japan | |||
1393667 | 1393667 | 2022-09-02 | Japan | Fukui | 98417 | 87 | 0 | 35.846614 | 136.224654 | 2022-09-03 04:21:04 | Fukui, Japan | |||
1086108 | 1086108 | 2022-08-09 | Japan | Yamanashi | 60452 | 87 | 0 | 35.612364 | 138.611489 | 2022-08-10 04:20:57 | Yamanashi, Japan | |||
2594057 | 2594057 | 2022-07-25 | Japan | Tokushima | 31369 | 87 | 0 | 33.919178 | 134.242091 | 2022-07-26 04:20:58 | Tokushima, Japan | |||
896172 | 896172 | 2022-07-24 | Japan | Tokushima | 30862 | 87 | 0 | 33.919178 | 134.242091 | 2022-07-25 04:20:51 | Tokushima, Japan | |||
91166 | 91166 | 2022-07-23 | Japan | Tokushima | 30240 | 87 | 0 | 33.919178 | 134.242091 | 2022-07-24 04:20:47 | Tokushima, Japan | |||
2047867 | 2047867 | 2022-05-25 | Japan | Iwate | 33617 | 87 | 0 | 39.593287 | 141.361777 | 2022-05-26 04:20:50 | Iwate, Japan | |||
2999305 | 2999305 | 2022-05-24 | Japan | Iwate | 33346 | 87 | 0 | 39.593287 | 141.361777 | 2022-05-25 04:20:56 | Iwate, Japan | |||
621878 | 621878 | 2022-05-22 | Japan | Iwate | 33617 | 87 | 0 | 39.593287 | 141.361777 | 2022-05-26 04:20:50 | Iwate, Japan | |||
2331411 | 2331411 | 2022-05-08 | Japan | Yamagata | 24423 | 87 | 0 | 38.448396 | 140.102154 | 2022-05-09 04:20:54 | Yamagata, Japan | |||
360373 | 360373 | 2022-05-07 | Japan | Yamagata | 24165 | 87 | 0 | 38.448396 | 140.102154 | 2022-05-08 04:20:49 | Yamagata, Japan | |||
1397724 | 1397724 | 2022-05-06 | Japan | Yamagata | 23964 | 87 | 0 | 38.448396 | 140.102154 | 2022-05-07 04:21:09 | Yamagata, Japan | |||
2598079 | 2598079 | 2022-05-05 | Japan | Yamagata | 23849 | 87 | 0 | 38.448396 | 140.102154 | 2022-05-06 04:21:00 | Yamagata, Japan | |||
3265528 | 3265528 | 2022-05-04 | Japan | Yamagata | 23724 | 87 | 0 | 38.448396 | 140.102154 | 2022-05-05 04:20:55 | Yamagata, Japan | |||
1572167 | 1572167 | 2022-05-03 | Japan | Yamagata | 23587 | 87 | 0 | 38.448396 | 140.102154 | 2022-05-04 04:20:59 | Yamagata, Japan | |||
463427 | 463427 | 2022-05-02 | Japan | Yamagata | 23474 | 87 | 0 | 38.448396 | 140.102154 | 2022-05-03 04:21:00 | Yamagata, Japan | |||
3916066 | 3916066 | 2022-05-01 | Japan | Yamagata | 23362 | 87 | 0 | 38.448396 | 140.102154 | 2022-05-02 04:21:10 | Yamagata, Japan | |||
2840870 | 2840870 | 2022-04-30 | Japan | Yamagata | 23259 | 87 | 0 | 38.448396 | 140.102154 | 2022-05-01 04:20:57 | Yamagata, Japan | |||
1157183 | 1157183 | 2022-04-29 | Japan | Yamagata | 23157 | 87 | 0 | 38.448396 | 140.102154 | 2022-04-30 04:21:05 | Yamagata, Japan | |||
1696365 | 1696365 | 2022-04-28 | Japan | Yamagata | 22990 | 87 | 0 | 38.448396 | 140.102154 | 2022-04-29 04:20:59 | Yamagata, Japan | |||
3851848 | 3851848 | 2022-04-27 | Japan | Yamagata | 22791 | 87 | 0 | 38.448396 | 140.102154 | 2022-04-28 04:20:47 | Yamagata, Japan | |||
3206294 | 3206294 | 2022-04-11 | Japan | Toyama | 29748 | 87 | 0 | 36.637464 | 137.26934599999998 | 2022-04-12 04:20:49 | Toyama, Japan | |||
2800763 | 2800763 | 2022-04-06 | Japan | Aomori | 38970 | 87 | 0 | 40.781541 | 140.828896 | 2022-04-07 04:20:53 | Aomori, Japan | |||
2477990 | 2477990 | 2022-03-30 | Japan | Saga | 31770 | 87 | 0 | 33.286977 | 130.115738 | 2022-03-31 04:20:56 | Saga, Japan | |||
1436596 | 1436596 | 2022-03-28 | Japan | Niigata | 40761 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-29 04:20:46 | Niigata, Japan | |||
876277 | 876277 | 2022-03-27 | Japan | Niigata | 40411 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-28 04:20:33 | Niigata, Japan | |||
2163560 | 2163560 | 2022-03-26 | Japan | Niigata | 39904 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-27 04:20:47 | Niigata, Japan | |||
1720496 | 1720496 | 2022-03-25 | Japan | Niigata | 39359 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-26 04:20:23 | Niigata, Japan | |||
1468113 | 1468113 | 2022-03-24 | Japan | Niigata | 38835 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-25 04:20:46 | Niigata, Japan | |||
3022287 | 3022287 | 2022-03-23 | Japan | Niigata | 38298 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-24 04:20:43 | Niigata, Japan | |||
1905209 | 1905209 | 2022-03-22 | Japan | Niigata | 37957 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-23 04:20:48 | Niigata, Japan | |||
950866 | 950866 | 2022-03-12 | Japan | Kagawa | 23381 | 87 | 0 | 34.217292 | 133.969047 | 2022-03-13 04:20:49 | Kagawa, Japan | |||
356327 | 356327 | 2022-03-11 | Japan | Kagawa | 22950 | 87 | 0 | 34.217292 | 133.969047 | 2022-03-12 04:20:50 | Kagawa, Japan | |||
1865479 | 1865479 | 2022-03-10 | Japan | Kagawa | 22522 | 87 | 0 | 34.217292 | 133.969047 | 2022-03-11 04:20:50 | Kagawa, Japan | |||
315927 | 315927 | 2022-02-12 | Japan | Nagasaki | 20267 | 87 | 0 | 33.235712 | 129.608033 | 2022-02-13 04:21:00 | Nagasaki, Japan | |||
1362366 | 1362366 | 2022-02-08 | Japan | Oita | 17043 | 87 | 0 | 33.200697 | 131.43323999999998 | 2022-02-09 04:21:04 | Oita, Japan | |||
71104 | 71104 | 2022-02-07 | Japan | Oita | 16520 | 87 | 0 | 33.200697 | 131.43323999999998 | 2022-02-08 04:21:15 | Oita, Japan | |||
2012720 | 2012720 | 2022-02-06 | Japan | Oita | 16198 | 87 | 0 | 33.200697 | 131.43323999999998 | 2022-02-07 04:21:05 | Oita, Japan | |||
1294049 | 1294049 | 2022-02-05 | Japan | Oita | 15810 | 87 | 0 | 33.200697 | 131.43323999999998 | 2022-02-06 04:21:00 | Oita, Japan | |||
459368 | 459368 | 2022-02-02 | Japan | Ehime | 10952 | 87 | 0 | 33.624835 | 132.856842 | 2022-02-03 04:21:21 | Ehime, Japan | |||
1885047 | 1885047 | 2021-09-12 | Japan | Yamaguchi | 5414 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-13 04:21:15 | Yamaguchi, Japan | |||
3805950 | 3805950 | 2021-09-11 | Japan | Yamaguchi | 5404 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-12 04:21:13 | Yamaguchi, Japan | |||
3448890 | 3448890 | 2021-09-10 | Japan | Yamaguchi | 5379 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-11 04:21:30 | Yamaguchi, Japan | |||
1262836 | 1262836 | 2021-09-09 | Japan | Yamaguchi | 5355 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-10 04:21:20 | Yamaguchi, Japan | |||
2279206 | 2279206 | 2021-09-08 | Japan | Yamaguchi | 5326 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-09 04:21:27 | Yamaguchi, Japan | |||
641985 | 641985 | 2021-09-07 | Japan | Yamaguchi | 5296 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-08 04:21:31 | Yamaguchi, Japan | |||
3194048 | 3194048 | 2021-09-06 | Japan | Yamaguchi | 5265 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-07 04:21:35 | Yamaguchi, Japan | |||
3280916 | 3280916 | 2021-09-05 | Japan | Yamaguchi | 5243 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-06 04:21:22 | Yamaguchi, Japan | |||
249330 | 249330 | 2021-09-04 | Japan | Yamaguchi | 5201 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-05 04:21:33 | Yamaguchi, Japan | |||
3974611 | 3974611 | 2021-09-03 | Japan | Yamaguchi | 5135 | 87 | 0 | 34.201190000000004 | 131.573293 | 2021-09-04 04:21:28 | Yamaguchi, Japan | |||
3468216 | 3468216 | 2021-08-03 | Japan | Tochigi | 8601 | 87 | 7488 | 1026 | 36.689912 | 139.819213 | 2021-08-04 04:21:25 | Tochigi, Japan | ||
3683490 | 3683490 | 2021-08-02 | Japan | Tochigi | 8462 | 87 | 7442 | 933 | 36.689912 | 139.819213 | 2021-08-03 04:21:39 | Tochigi, Japan | ||
2422913 | 2422913 | 2021-06-23 | Japan | Miyagi | 9085 | 87 | 8921 | 77 | 38.446859 | 140.927086 | 2021-06-24 04:21:55 | Miyagi, Japan | ||
3030326 | 3030326 | 2021-06-16 | Japan | Shiga | 5449 | 87 | 5126 | 236 | 35.21582700000001 | 136.138064 | 2021-06-17 04:22:36 | Shiga, Japan | ||
3970575 | 3970575 | 2021-06-11 | Japan | Nagano | 4920 | 87 | 4750 | 83 | 36.132134 | 138.045528 | 2021-06-12 04:22:22 | Nagano, Japan | ||
2716997 | 2716997 | 2021-06-10 | Japan | Nagano | 4914 | 87 | 4731 | 96 | 36.132134 | 138.045528 | 2021-06-11 04:23:20 | Nagano, Japan | ||
522882 | 522882 | 2021-06-09 | Japan | Nagano | 4901 | 87 | 4720 | 94 | 36.132134 | 138.045528 | 2021-06-10 04:23:17 | Nagano, Japan | ||
3472322 | 3472322 | 2021-06-08 | Japan | Nagano | 4886 | 87 | 4693 | 106 | 36.132134 | 138.045528 | 2021-06-09 04:23:31 | Nagano, Japan | ||
3675674 | 3675674 | 2021-05-04 | Japan | Mie | 3930 | 87 | 3277 | 566 | 34.508018 | 136.376013 | 2021-05-05 04:20:43 | Mie, Japan | ||
2760941 | 2760941 | 2021-05-03 | Japan | Mie | 3899 | 87 | 3276 | 536 | 34.508018 | 136.376013 | 2021-05-04 04:20:34 | Mie, Japan | ||
2450794 | 2450794 | 2021-05-02 | Japan | Mie | 3863 | 87 | 3224 | 552 | 34.508018 | 136.376013 | 2021-05-03 04:20:39 | Mie, Japan | ||
54814 | 54814 | 2021-03-07 | Japan | Gunma | 4601 | 87 | 4310 | 204 | 36.504479 | 138.985605 | 2021-03-08 05:24:48 | Gunma, Japan | ||
3667631 | 3667631 | 2021-03-06 | Japan | Gunma | 4595 | 87 | 4301 | 207 | 36.504479 | 138.985605 | 2021-03-07 05:21:54 | Gunma, Japan | ||
2637730 | 2637730 | 2021-02-11 | Japan | Gifu | 4423 | 87 | 4090 | 246 | 35.778671 | 137.055925 | 2021-02-12 05:23:29 | Gifu, Japan | ||
2637735 | 2637735 | 2021-02-11 | Japan | Ibaraki | 5292 | 87 | 4691 | 514 | 36.303588 | 140.319591 | 2021-02-12 05:23:29 | Ibaraki, Japan | ||
3978585 | 3978585 | 2021-02-10 | Japan | Gifu | 4408 | 87 | 4061 | 260 | 35.778671 | 137.055925 | 2021-02-11 05:23:55 | Gifu, Japan | ||
1527935 | 1527935 | 2021-02-09 | Japan | Shizuoka | 4776 | 87 | 4392 | 297 | 34.916975 | 138.40778400000002 | 2021-02-10 05:22:41 | Shizuoka, Japan | ||
1759306 | 1759306 | 2021-01-24 | Japan | Hiroshima | 4623 | 87 | 4009 | 527 | 34.605309000000005 | 132.788719 | 2021-01-25 05:22:16 | Hiroshima, Japan | ||
237262 | 237262 | 2021-01-18 | Japan | Kyoto | 6987 | 87 | 5013 | 1887 | 35.253815 | 135.443341 | 2021-01-19 05:22:15 | Kyoto, Japan | ||
738313 | 738313 | 2020-12-02 | Japan | Hyogo | 5867 | 87 | 4849 | 931 | 35.039913 | 134.828057 | 2020-12-03 05:28:22 | Hyogo, Japan | ||
1584167 | 1584167 | 2020-11-30 | Japan | Chiba | 6992 | 87 | 5977 | 928 | 35.510141 | 140.198917 | 2020-12-01 05:26:18 | Chiba, Japan | ||
2510219 | 2510219 | 2020-08-27 | Japan | Saitama | 3745 | 87 | 3026 | 632 | 35.997101 | 139.347635 | 2020-08-28 04:28:11 | Saitama, Japan | ||
2563848 | 2563848 | 2020-07-24 | Japan | Osaka | 2915 | 87 | 2046 | 782 | 34.620965000000005 | 135.507481 | 2020-07-25 04:47:39 | Osaka, Japan | ||
2799958 | 2799958 | 2020-06-07 | Japan | Kanagawa | 1395 | 87 | 1163 | 145 | 35.415312 | 139.338983 | 2020-06-08 03:33:22 | Kanagawa, Japan | ||
574014 | 574014 | 2020-06-06 | Japan | Kanagawa | 1390 | 87 | 1163 | 140 | 35.415312 | 139.338983 | 2020-06-07 03:53:30 | Kanagawa, Japan | ||
1269711 | 1269711 | 2020-06-05 | Japan | Kanagawa | 1385 | 87 | 1157 | 141 | 35.415312 | 139.338983 | 2020-06-06 02:33:00 | Kanagawa, Japan | ||
1281184 | 1281184 | 2020-06-04 | Japan | Kanagawa | 1379 | 87 | 1131 | 161 | 35.415312 | 139.338983 | 2020-06-05 02:33:06 | Kanagawa, Japan | ||
3866739 | 3866739 | 2020-06-03 | Japan | Kanagawa | 1373 | 87 | 1124 | 162 | 35.415312 | 139.338983 | 2020-06-04 02:33:14 | Kanagawa, Japan | ||
2555751 | 2555751 | 2020-06-02 | Japan | Hokkaido | 1099 | 87 | 812 | 200 | 43.385711 | 142.55231799999999 | 2020-06-03 02:33:13 | Hokkaido, Japan | ||
805288 | 805288 | 2020-06-01 | Japan | Hokkaido | 1096 | 87 | 810 | 199 | 43.385711 | 142.55231799999999 | 2020-06-02 02:33:08 | Hokkaido, 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]);