johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where country_or_region = "Japan" and deaths = 152 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, latitude, combined_key
province_or_state 23
country_or_region 1
- Japan · 51 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
384256 | 384256 | 2022-09-23 | Japan | Yamanashi | 94609 | 152 | 0 | 35.612364 | 138.611489 | 2022-09-24 04:21:40 | Yamanashi, Japan | |||
1624322 | 1624322 | 2022-09-22 | Japan | Yamanashi | 94345 | 152 | 0 | 35.612364 | 138.611489 | 2022-09-23 04:23:13 | Yamanashi, Japan | |||
1370526 | 1370526 | 2022-09-21 | Japan | Yamanashi | 94018 | 152 | 0 | 35.612364 | 138.611489 | 2022-09-22 04:22:56 | Yamanashi, Japan | |||
2987315 | 2987315 | 2022-09-04 | Japan | Toyama | 112623 | 152 | 0 | 36.637464 | 137.269346 | 2022-09-05 04:21:01 | Toyama, Japan | |||
1346307 | 1346307 | 2022-08-10 | Japan | Aomori | 104944 | 152 | 0 | 40.781541 | 140.828896 | 2022-08-11 04:20:49 | Aomori, Japan | |||
1086062 | 1086062 | 2022-08-09 | Japan | Aomori | 102885 | 152 | 0 | 40.781541 | 140.828896 | 2022-08-10 04:20:57 | Aomori, Japan | |||
3617070 | 3617070 | 2022-08-01 | Japan | Ehime | 72268 | 152 | 0 | 33.624835 | 132.856842 | 2022-08-02 04:20:53 | Ehime, Japan | |||
958904 | 958904 | 2022-07-19 | Japan | Miyazaki | 70513 | 152 | 0 | 32.193204 | 131.299374 | 2022-07-20 04:20:59 | Miyazaki, Japan | |||
3210291 | 3210291 | 2022-07-18 | Japan | Miyazaki | 69948 | 152 | 0 | 32.193204 | 131.299374 | 2022-07-19 04:20:58 | Miyazaki, Japan | |||
3405466 | 3405466 | 2022-07-17 | Japan | Miyazaki | 69116 | 152 | 0 | 32.193204 | 131.299374 | 2022-07-18 04:20:59 | Miyazaki, Japan | |||
3851831 | 3851831 | 2022-04-27 | Japan | Oita | 42812 | 152 | 0 | 33.200697 | 131.43324 | 2022-04-28 04:20:47 | Oita, Japan | |||
2319334 | 2319334 | 2022-03-16 | Japan | Kagoshima | 37021 | 152 | 0 | 31.009484000000004 | 130.430665 | 2022-03-17 04:20:56 | Kagoshima, Japan | |||
1547979 | 1547979 | 2022-03-07 | Japan | Miyagi | 44821 | 152 | 0 | 38.446859 | 140.927086 | 2022-03-08 04:20:54 | Miyagi, Japan | |||
2199661 | 2199661 | 2022-03-06 | Japan | Shiga | 54084 | 152 | 0 | 35.21582700000001 | 136.13806399999999 | 2022-03-07 04:20:47 | Shiga, Japan | |||
3820462 | 3820462 | 2022-02-16 | Japan | Tochigi | 37081 | 152 | 0 | 36.689912 | 139.819213 | 2022-02-17 04:20:56 | Tochigi, Japan | |||
2473959 | 2473959 | 2022-02-03 | Japan | Kumamoto | 31349 | 152 | 0 | 32.608154 | 130.74523100000002 | 2022-02-04 04:21:10 | Kumamoto, Japan | |||
1227625 | 1227625 | 2022-01-24 | Japan | Nara | 20445 | 152 | 0 | 34.317451 | 135.871644 | 2022-01-25 04:21:05 | Nara, Japan | |||
1140924 | 1140924 | 2022-01-23 | Japan | Nara | 19963 | 152 | 0 | 34.317451 | 135.871644 | 2022-01-24 04:21:12 | Nara, Japan | |||
2832842 | 2832842 | 2022-01-22 | Japan | Nara | 19488 | 152 | 0 | 34.317451 | 135.871644 | 2022-01-23 04:21:13 | Nara, Japan | |||
3424960 | 3424960 | 2022-01-21 | Japan | Nara | 18989 | 152 | 0 | 34.317451 | 135.871644 | 2022-01-22 04:21:13 | Nara, Japan | |||
1960568 | 1960568 | 2022-01-20 | Japan | Nara | 18501 | 152 | 0 | 34.317451 | 135.871644 | 2022-01-21 04:21:09 | Nara, Japan | |||
16377 | 16377 | 2021-09-18 | Japan | Mie | 14404 | 152 | 0 | 34.508018 | 136.376013 | 2021-09-19 04:21:34 | Mie, Japan | |||
3741119 | 3741119 | 2021-07-12 | Japan | Shizuoka | 9618 | 152 | 9106 | 360 | 34.916975 | 138.40778400000002 | 2021-07-13 04:21:18 | Shizuoka, Japan | ||
3659632 | 3659632 | 2021-07-11 | Japan | Shizuoka | 9598 | 152 | 9075 | 371 | 34.916975 | 138.40778400000002 | 2021-07-12 04:21:34 | Shizuoka, Japan | ||
625916 | 625916 | 2021-07-10 | Japan | Shizuoka | 9585 | 152 | 9075 | 358 | 34.916975 | 138.40778400000002 | 2021-07-11 04:21:43 | Shizuoka, Japan | ||
829635 | 829635 | 2021-07-09 | Japan | Shizuoka | 9548 | 152 | 9075 | 321 | 34.916975 | 138.40778400000002 | 2021-07-10 04:21:25 | Shizuoka, Japan | ||
778399 | 778399 | 2021-07-08 | Japan | Shizuoka | 9505 | 152 | 9057 | 296 | 34.916975 | 138.40778400000002 | 2021-07-09 04:21:21 | Shizuoka, Japan | ||
1440621 | 1440621 | 2021-07-07 | Japan | Shizuoka | 9471 | 152 | 9038 | 281 | 34.916975 | 138.40778400000002 | 2021-07-08 04:21:26 | Shizuoka, Japan | ||
2693726 | 2693726 | 2021-07-06 | Japan | Shizuoka | 9438 | 152 | 9016 | 270 | 34.916975 | 138.40778400000002 | 2021-07-07 04:21:20 | Shizuoka, Japan | ||
1932475 | 1932475 | 2021-07-05 | Japan | Shizuoka | 9414 | 152 | 8961 | 301 | 34.916975 | 138.40778400000002 | 2021-07-06 04:21:32 | Shizuoka, Japan | ||
1165177 | 1165177 | 2021-07-04 | Japan | Gunma | 8051 | 152 | 7847 | 52 | 36.504479 | 138.985605 | 2021-07-05 04:21:28 | Gunma, Japan | ||
1165206 | 1165206 | 2021-07-04 | Japan | Shizuoka | 9401 | 152 | 8961 | 288 | 34.916975 | 138.40778400000002 | 2021-07-05 04:21:28 | Shizuoka, Japan | ||
1495611 | 1495611 | 2021-07-03 | Japan | Gunma | 8048 | 152 | 7845 | 51 | 36.504479 | 138.985605 | 2021-07-04 04:21:38 | Gunma, Japan | ||
2071926 | 2071926 | 2021-07-02 | Japan | Gunma | 8042 | 152 | 7839 | 51 | 36.504479 | 138.985605 | 2021-07-03 04:21:37 | Gunma, Japan | ||
2764942 | 2764942 | 2021-07-01 | Japan | Gunma | 8037 | 152 | 7836 | 49 | 36.504479 | 138.985605 | 2021-07-02 04:21:47 | Gunma, Japan | ||
1893150 | 1893150 | 2021-06-30 | Japan | Gunma | 8036 | 152 | 7833 | 51 | 36.504479 | 138.985605 | 2021-07-01 04:21:19 | Gunma, Japan | ||
400273 | 400273 | 2021-06-29 | Japan | Gunma | 8032 | 152 | 7822 | 58 | 36.504479 | 138.985605 | 2021-06-30 04:21:41 | Gunma, Japan | ||
3125516 | 3125516 | 2021-06-28 | Japan | Gunma | 8029 | 152 | 7817 | 60 | 36.504479 | 138.985605 | 2021-06-29 04:21:28 | Gunma, Japan | ||
2590011 | 2590011 | 2021-06-27 | Japan | Gunma | 8026 | 152 | 7814 | 60 | 36.504479 | 138.985605 | 2021-06-28 04:21:29 | Gunma, Japan | ||
3958515 | 3958515 | 2021-06-26 | Japan | Gunma | 8022 | 152 | 7813 | 57 | 36.504479 | 138.985605 | 2021-06-27 04:21:39 | Gunma, Japan | ||
1712334 | 1712334 | 2021-06-25 | Japan | Gunma | 8017 | 152 | 7802 | 63 | 36.504479 | 138.985605 | 2021-06-26 04:21:43 | Gunma, Japan | ||
2295459 | 2295459 | 2021-06-24 | Japan | Gunma | 8013 | 152 | 7797 | 64 | 36.504479 | 138.985605 | 2021-06-25 04:21:33 | Gunma, Japan | ||
2585995 | 2585995 | 2021-06-05 | Japan | Fukushima | 4632 | 152 | 4293 | 187 | 37.378867 | 140.223295 | 2021-06-06 04:24:03 | Fukushima, Japan | ||
2586001 | 2586001 | 2021-06-05 | Japan | Ibaraki | 9891 | 152 | 9333 | 406 | 36.303588 | 140.319591 | 2021-06-06 04:24:03 | Ibaraki, Japan | ||
2315315 | 2315315 | 2021-06-04 | Japan | Ibaraki | 9864 | 152 | 9283 | 429 | 36.303588 | 140.319591 | 2021-06-05 04:23:03 | Ibaraki, Japan | ||
1708342 | 1708342 | 2021-06-02 | Japan | Okinawa | 17521 | 152 | 14448 | 2921 | 25.768923 | 126.668016 | 2021-06-03 04:23:32 | Okinawa, Japan | ||
742335 | 742335 | 2021-02-20 | Japan | Kyoto | 9008 | 152 | 8408 | 448 | 35.253815 | 135.443341 | 2021-02-21 05:24:33 | Kyoto, Japan | ||
3308206 | 3308206 | 2021-01-13 | Japan | Chiba | 15418 | 152 | 10163 | 5103 | 35.510141 | 140.198917 | 2021-01-14 05:22:32 | Chiba, Japan | ||
2127993 | 2127993 | 2020-12-17 | Japan | Aichi | 13538 | 152 | 10733 | 2653 | 35.035551 | 137.211621 | 2020-12-18 05:28:18 | Aichi, Japan | ||
678323 | 678323 | 2020-11-23 | Japan | Hokkaido | 7368 | 152 | 4629 | 2587 | 43.385711 | 142.552318 | 2020-11-24 05:27:31 | Hokkaido, Japan | ||
194099 | 194099 | 2020-08-31 | Japan | Osaka | 8542 | 152 | 7027 | 1363 | 34.620965000000005 | 135.507481 | 2020-09-01 04:28:31 | Osaka, 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]);