johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
72 rows where active = 58 and country_or_region = "Japan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
country_or_region 1
- Japan · 72 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468185 | 3468185 | 2021-08-03 | Japan | Gifu | 9687 | 188 | 9441 | 58 | 35.778671 | 137.055925 | 2021-08-04 04:21:25 | Gifu, Japan | ||
3218327 | 3218327 | 2021-07-26 | Japan | Oita | 3570 | 64 | 3448 | 58 | 33.200697 | 131.43323999999998 | 2021-07-27 04:21:18 | Oita, Japan | ||
1378531 | 1378531 | 2021-07-25 | Japan | Miyazaki | 3158 | 27 | 3073 | 58 | 32.193203999999994 | 131.299374 | 2021-07-26 04:21:28 | Miyazaki, Japan | ||
1330269 | 1330269 | 2021-07-24 | Japan | Mie | 5561 | 113 | 5390 | 58 | 34.508018 | 136.376013 | 2021-07-25 04:22:12 | Mie, Japan | ||
3137555 | 3137555 | 2021-07-23 | Japan | Ehime | 2817 | 76 | 2683 | 58 | 33.624835 | 132.856842 | 2021-07-24 00:21:36 | Ehime, Japan | ||
3137591 | 3137591 | 2021-07-23 | Japan | Tokushima | 1729 | 63 | 1608 | 58 | 33.919178 | 134.242091 | 2021-07-24 00:21:36 | Tokushima, Japan | ||
3476359 | 3476359 | 2021-07-22 | Japan | Yamanashi | 2218 | 21 | 2139 | 58 | 35.612364 | 138.61148899999998 | 2021-07-23 04:21:29 | Yamanashi, Japan | ||
2673861 | 2673861 | 2021-07-18 | Japan | Yamanashi | 2187 | 21 | 2108 | 58 | 35.612364 | 138.61148899999998 | 2021-07-19 04:21:24 | Yamanashi, Japan | ||
296060 | 296060 | 2021-07-15 | Japan | Yamanashi | 2176 | 21 | 2097 | 58 | 35.612364 | 138.61148899999998 | 2021-07-16 04:21:22 | Yamanashi, Japan | ||
829598 | 829598 | 2021-07-09 | Japan | Akita | 931 | 20 | 853 | 58 | 39.748679 | 140.408228 | 2021-07-10 04:21:25 | Akita, Japan | ||
1165215 | 1165215 | 2021-07-04 | Japan | Yamaguchi | 3159 | 80 | 3021 | 58 | 34.201190000000004 | 131.573293 | 2021-07-05 04:21:28 | Yamaguchi, Japan | ||
400273 | 400273 | 2021-06-29 | Japan | Gunma | 8032 | 152 | 7822 | 58 | 36.504479 | 138.985605 | 2021-06-30 04:21:41 | Gunma, Japan | ||
3125550 | 3125550 | 2021-06-28 | Japan | Toyama | 2037 | 38 | 1941 | 58 | 36.637464 | 137.26934599999998 | 2021-06-29 04:21:28 | Toyama, Japan | ||
2590017 | 2590017 | 2021-06-27 | Japan | Iwate | 1667 | 46 | 1563 | 58 | 39.593287 | 141.361777 | 2021-06-28 04:21:29 | Iwate, Japan | ||
2590029 | 2590029 | 2021-06-27 | Japan | Nara | 8151 | 129 | 7964 | 58 | 34.317451 | 135.871644 | 2021-06-28 04:21:29 | Nara, Japan | ||
2339412 | 2339412 | 2021-06-15 | Japan | Kagawa | 2073 | 28 | 1987 | 58 | 34.217292 | 133.969047 | 2021-06-16 04:22:32 | Kagawa, Japan | ||
1564138 | 1564138 | 2021-06-14 | Japan | Yamagata | 2011 | 46 | 1907 | 58 | 38.448396 | 140.102154 | 2021-06-15 04:22:22 | Yamagata, Japan | ||
3089423 | 3089423 | 2021-05-30 | Japan | Akita | 755 | 12 | 685 | 58 | 39.748679 | 140.408228 | 2021-05-31 03:08:59 | Akita, Japan | ||
1771385 | 1771385 | 2021-05-23 | Japan | Tottori | 455 | 2 | 395 | 58 | 35.359069 | 133.863619 | 2021-05-24 04:20:53 | Tottori, Japan | ||
1081944 | 1081944 | 2021-05-14 | Japan | Kochi | 1144 | 20 | 1066 | 58 | 33.422519 | 133.367307 | 2021-05-15 04:20:58 | Kochi, Japan | ||
2820813 | 2820813 | 2021-05-10 | Japan | Tottori | 403 | 2 | 343 | 58 | 35.359069 | 133.863619 | 2021-05-11 04:20:41 | Tottori, Japan | ||
1568123 | 1568123 | 2021-04-22 | Japan | Kagoshima | 1992 | 28 | 1906 | 58 | 31.009484000000004 | 130.430665 | 2021-04-23 04:20:52 | Kagoshima, Japan | ||
3242344 | 3242344 | 2021-04-21 | Japan | Kagoshima | 1985 | 28 | 1899 | 58 | 31.009484000000004 | 130.430665 | 2021-04-22 04:20:53 | Kagoshima, Japan | ||
3129522 | 3129522 | 2021-04-18 | Japan | Akita | 367 | 9 | 300 | 58 | 39.748679 | 140.408228 | 2021-04-19 04:20:57 | Akita, Japan | ||
3129536 | 3129536 | 2021-04-18 | Japan | Iwate | 779 | 31 | 690 | 58 | 39.593287 | 141.361777 | 2021-04-19 04:20:57 | Iwate, Japan | ||
2548892 | 2548892 | 2021-04-15 | Japan | Kagoshima | 1943 | 28 | 1857 | 58 | 31.009484000000004 | 130.430665 | 2021-04-16 04:20:46 | Kagoshima, Japan | ||
2548922 | 2548922 | 2021-04-15 | Japan | Yamaguchi | 1485 | 43 | 1384 | 58 | 34.201190000000004 | 131.573293 | 2021-04-16 04:20:46 | Yamaguchi, Japan | ||
3621106 | 3621106 | 2021-03-17 | Japan | Nagano | 2464 | 41 | 2365 | 58 | 36.132134 | 138.045528 | 2021-03-18 05:26:22 | Nagano, Japan | ||
3663622 | 3663622 | 2021-03-09 | Japan | Ishikawa | 1879 | 62 | 1759 | 58 | 36.769464 | 136.771027 | 2021-03-10 05:24:35 | Ishikawa, Japan | ||
3066029 | 3066029 | 2021-02-27 | Japan | Okayama | 2479 | 32 | 2389 | 58 | 34.89246 | 133.826252 | 2021-02-28 05:22:20 | Okayama, Japan | ||
2283442 | 2283442 | 2021-02-14 | Japan | Kagawa | 719 | 17 | 644 | 58 | 34.217292 | 133.969047 | 2021-02-15 05:24:49 | Kagawa, Japan | ||
3539463 | 3539463 | 2021-02-12 | Japan | Ehime | 1029 | 22 | 949 | 58 | 33.624835 | 132.856842 | 2021-02-13 05:22:12 | Ehime, Japan | ||
1527930 | 1527930 | 2021-02-09 | Japan | Port Quarantine | 2178 | 2 | 2118 | 58 | 2021-02-10 05:22:41 | Port Quarantine, Japan | ||||
1672503 | 1672503 | 2021-02-07 | Japan | Yamagata | 526 | 13 | 455 | 58 | 38.448396 | 140.102154 | 2021-02-08 05:22:39 | Yamagata, Japan | ||
974920 | 974920 | 2021-02-06 | Japan | Aomori | 740 | 13 | 669 | 58 | 40.781541 | 140.828896 | 2021-02-07 05:23:00 | Aomori, Japan | ||
974952 | 974952 | 2021-02-06 | Japan | Saga | 976 | 6 | 912 | 58 | 33.286977 | 130.115738 | 2021-02-07 05:23:00 | Saga, Japan | ||
1676473 | 1676473 | 2021-02-01 | Japan | Aomori | 717 | 13 | 646 | 58 | 40.781541 | 140.828896 | 2021-02-02 05:22:49 | Aomori, Japan | ||
3515445 | 3515445 | 2021-01-15 | Japan | Tottori | 175 | 2 | 115 | 58 | 35.359069 | 133.863619 | 2021-01-16 05:22:40 | Tottori, Japan | ||
3515449 | 3515449 | 2021-01-15 | Japan | Yamagata | 440 | 13 | 369 | 58 | 38.448396 | 140.102154 | 2021-01-16 05:22:40 | Yamagata, Japan | ||
1136927 | 1136927 | 2021-01-01 | Japan | Toyama | 562 | 26 | 478 | 58 | 36.637464 | 137.26934599999998 | 2021-01-02 05:22:33 | Toyama, Japan | ||
3695533 | 3695533 | 2020-12-31 | Japan | Toyama | 559 | 26 | 475 | 58 | 36.637464 | 137.26934599999998 | 2021-01-01 05:23:07 | Toyama, Japan | ||
1010348 | 1010348 | 2020-12-30 | Japan | Toyama | 552 | 26 | 468 | 58 | 36.637464 | 137.26934599999998 | 2020-12-31 05:22:49 | Toyama, Japan | ||
202299 | 202299 | 2020-12-25 | Japan | Toyama | 538 | 26 | 454 | 58 | 36.637464 | 137.26934599999998 | 2020-12-26 05:22:28 | Toyama, Japan | ||
1751272 | 1751272 | 2020-12-14 | Japan | Ehime | 360 | 9 | 293 | 58 | 33.624835 | 132.856842 | 2020-12-15 05:26:38 | Ehime, Japan | ||
3847835 | 3847835 | 2020-12-13 | Japan | Yamaguchi | 435 | 2 | 375 | 58 | 34.201190000000004 | 131.573293 | 2020-12-14 05:26:27 | Yamaguchi, Japan | ||
2975243 | 2975243 | 2020-12-09 | Japan | Iwate | 225 | 6 | 161 | 58 | 39.593287 | 141.361777 | 2020-12-10 05:26:19 | Iwate, Japan | ||
1818834 | 1818834 | 2020-12-08 | Japan | Yamagata | 186 | 1 | 127 | 58 | 38.448396 | 140.102154 | 2020-12-09 05:28:01 | Yamagata, Japan | ||
1006311 | 1006311 | 2020-12-06 | Japan | Kagoshima | 673 | 13 | 602 | 58 | 31.009484000000004 | 130.430665 | 2020-12-07 05:26:14 | Kagoshima, Japan | ||
3836521 | 3836521 | 2020-11-21 | Japan | Tochigi | 558 | 2 | 498 | 58 | 36.689912 | 139.819213 | 2020-11-22 05:25:45 | Tochigi, Japan | ||
2701558 | 2701558 | 2020-11-20 | Japan | Yamanashi | 304 | 7 | 239 | 58 | 35.612364 | 138.61148899999998 | 2020-11-21 05:25:51 | Yamanashi, Japan | ||
122749 | 122749 | 2020-11-18 | Japan | Wakayama | 346 | 4 | 284 | 58 | 33.911879 | 135.505446 | 2020-11-19 05:25:23 | Wakayama, Japan | ||
122752 | 122752 | 2020-11-18 | Japan | Yamanashi | 292 | 7 | 227 | 58 | 35.612364 | 138.61148899999998 | 2020-11-19 05:25:23 | Yamanashi, Japan | ||
2498039 | 2498039 | 2020-11-03 | Japan | Kumamoto | 814 | 8 | 748 | 58 | 32.608154 | 130.74523100000002 | 2020-11-04 05:25:09 | Kumamoto, Japan | ||
3409463 | 3409463 | 2020-11-01 | Japan | Kumamoto | 802 | 8 | 736 | 58 | 32.608154 | 130.74523100000002 | 2020-11-02 05:25:04 | Kumamoto, Japan | ||
2191608 | 2191608 | 2020-10-21 | Japan | Gunma | 806 | 19 | 729 | 58 | 36.504479 | 138.985605 | 2020-10-22 04:24:27 | Gunma, Japan | ||
3801917 | 3801917 | 2020-10-05 | Japan | Kumamoto | 626 | 8 | 560 | 58 | 32.608154 | 130.74523100000002 | 2020-10-06 04:23:33 | Kumamoto, Japan | ||
3161638 | 3161638 | 2020-09-06 | Japan | Kagoshima | 371 | 11 | 302 | 58 | 31.009484000000004 | 130.430665 | 2020-09-07 04:28:30 | Kagoshima, Japan | ||
813593 | 813593 | 2020-09-05 | Japan | Kagoshima | 371 | 11 | 302 | 58 | 31.009484000000004 | 130.430665 | 2020-09-06 04:28:33 | Kagoshima, Japan | ||
2661819 | 2661819 | 2020-09-04 | Japan | Toyama | 401 | 25 | 318 | 58 | 36.637464 | 137.26934599999998 | 2020-09-05 04:28:19 | Toyama, Japan | ||
1354333 | 1354333 | 2020-09-03 | Japan | Kagoshima | 368 | 11 | 299 | 58 | 31.009484000000004 | 130.430665 | 2020-09-04 04:28:26 | Kagoshima, Japan | ||
609705 | 609705 | 2020-08-29 | Japan | Kagoshima | 359 | 11 | 290 | 58 | 31.009484000000004 | 130.430665 | 2020-08-30 04:28:22 | Kagoshima, Japan | ||
1523200 | 1523200 | 2020-08-28 | Japan | Kagoshima | 356 | 11 | 287 | 58 | 31.009484000000004 | 130.430665 | 2020-08-29 04:28:19 | Kagoshima, Japan | ||
146011 | 146011 | 2020-08-15 | Japan | Tochigi | 269 | 1 | 210 | 58 | 36.689912 | 139.819213 | 2020-08-16 04:27:42 | Tochigi, Japan | ||
2808122 | 2808122 | 2020-08-02 | Japan | Shiga | 184 | 1 | 125 | 58 | 35.21582700000001 | 136.138064 | 2020-08-03 04:34:35 | Shiga, Japan | ||
753555 | 753555 | 2020-08-01 | Japan | Mie | 112 | 1 | 53 | 58 | 34.508018 | 136.376013 | 2020-08-02 04:34:47 | Mie, Japan | ||
753776 | 753776 | 2020-08-01 | Japan | Wakayama | 163 | 3 | 102 | 58 | 33.911879 | 135.505446 | 2020-08-02 04:34:47 | Wakayama, Japan | ||
3264855 | 3264855 | 2020-07-31 | Japan | Shiga | 171 | 1 | 112 | 58 | 35.21582700000001 | 136.138064 | 2020-08-01 04:36:27 | Shiga, Japan | ||
1928562 | 1928562 | 2020-07-30 | Japan | Shiga | 168 | 1 | 109 | 58 | 35.21582700000001 | 136.138064 | 2020-07-31 04:35:18 | Shiga, Japan | ||
177315 | 177315 | 2020-07-27 | Japan | Okinawa | 210 | 7 | 145 | 58 | 25.768923 | 126.668016 | 2020-07-28 04:58:43 | Okinawa, Japan | ||
367349 | 367349 | 2020-07-16 | Japan | Hyogo | 776 | 45 | 673 | 58 | 35.039913 | 134.828057 | 2020-07-17 04:34:50 | Hyogo, Japan | ||
2222616 | 2222616 | 2020-07-08 | Japan | Fukuoka | 898 | 33 | 807 | 58 | 33.526032 | 130.666949 | 2020-07-09 04:34:23 | Fukuoka, Japan | ||
2712236 | 2712236 | 2020-05-28 | Japan | Ishikawa | 297 | 24 | 215 | 58 | 36.769464 | 136.771027 | 2020-05-29 02:32:50 | Ishikawa, 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]);