johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46,430 rows where country_or_region = "Japan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Aichi 143
- Akita 143
- Aomori 143
- Chiba 143
- Ehime 143
- Fukui 143
- Fukuoka 143
- Fukushima 143
- Gifu 143
- Gunma 143
- Hiroshima 143
- Hokkaido 143
- Hyogo 143
- Ibaraki 143
- Ishikawa 143
- Kagawa 143
- Kagoshima 143
- Kanagawa 143
- Kochi 143
- Kumamoto 143
- Kyoto 143
- Mie 143
- Miyagi 143
- Miyazaki 143
- Nagano 143
- Nagasaki 143
- Nara 143
- Niigata 143
- Oita 143
- Okayama 143
- …
country_or_region 1
- Japan · 7,083 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026352 | 1026352 | 2020-10-17 | Japan | Aichi | 5730 | 91 | 5305 | 334 | 35.035551 | 137.211621 | 2020-10-18 04:24:25 | Aichi, Japan | ||
1026353 | 1026353 | 2020-10-17 | Japan | Akita | 59 | 0 | 58 | 1 | 39.748679 | 140.408228 | 2020-10-18 04:24:25 | Akita, Japan | ||
1026354 | 1026354 | 2020-10-17 | Japan | Aomori | 100 | 1 | 36 | 63 | 40.781541 | 140.828896 | 2020-10-18 04:24:25 | Aomori, Japan | ||
1026355 | 1026355 | 2020-10-17 | Japan | Chiba | 4490 | 76 | 4037 | 377 | 35.510141 | 140.198917 | 2020-10-18 04:24:25 | Chiba, Japan | ||
1026356 | 1026356 | 2020-10-17 | Japan | Ehime | 116 | 6 | 108 | 2 | 33.624835 | 132.856842 | 2020-10-18 04:24:25 | Ehime, Japan | ||
1026357 | 1026357 | 2020-10-17 | Japan | Fukui | 254 | 11 | 234 | 9 | 35.846614 | 136.22465400000002 | 2020-10-18 04:24:25 | Fukui, Japan | ||
1026358 | 1026358 | 2020-10-17 | Japan | Fukuoka | 5139 | 99 | 4973 | 67 | 33.526032 | 130.666949 | 2020-10-18 04:24:25 | Fukuoka, Japan | ||
1026359 | 1026359 | 2020-10-17 | Japan | Fukushima | 359 | 6 | 259 | 94 | 37.378867 | 140.223295 | 2020-10-18 04:24:25 | Fukushima, Japan | ||
1026360 | 1026360 | 2020-10-17 | Japan | Gifu | 642 | 10 | 619 | 13 | 35.778671 | 137.055925 | 2020-10-18 04:24:25 | Gifu, Japan | ||
1026361 | 1026361 | 2020-10-17 | Japan | Gunma | 769 | 19 | 712 | 38 | 36.504479 | 138.985605 | 2020-10-18 04:24:25 | Gunma, Japan | ||
1026362 | 1026362 | 2020-10-17 | Japan | Hiroshima | 649 | 4 | 599 | 46 | 34.605309000000005 | 132.788719 | 2020-10-18 04:24:25 | Hiroshima, Japan | ||
1026363 | 1026363 | 2020-10-17 | Japan | Hokkaido | 2518 | 108 | 2166 | 244 | 43.385711 | 142.552318 | 2020-10-18 04:24:25 | Hokkaido, Japan | ||
1026364 | 1026364 | 2020-10-17 | Japan | Hyogo | 2994 | 61 | 2776 | 157 | 35.039913 | 134.828057 | 2020-10-18 04:24:25 | Hyogo, Japan | ||
1026365 | 1026365 | 2020-10-17 | Japan | Ibaraki | 725 | 18 | 673 | 34 | 36.303588 | 140.319591 | 2020-10-18 04:24:25 | Ibaraki, Japan | ||
1026366 | 1026366 | 2020-10-17 | Japan | Ishikawa | 793 | 47 | 721 | 25 | 36.769464 | 136.771027 | 2020-10-18 04:24:25 | Ishikawa, Japan | ||
1026367 | 1026367 | 2020-10-17 | Japan | Iwate | 26 | 0 | 23 | 3 | 39.593287 | 141.361777 | 2020-10-18 04:24:25 | Iwate, Japan | ||
1026368 | 1026368 | 2020-10-17 | Japan | Kagawa | 100 | 2 | 91 | 7 | 34.217292 | 133.969047 | 2020-10-18 04:24:25 | Kagawa, Japan | ||
1026369 | 1026369 | 2020-10-17 | Japan | Kagoshima | 463 | 12 | 439 | 12 | 31.009484000000004 | 130.430665 | 2020-10-18 04:24:25 | Kagoshima, Japan | ||
1026370 | 1026370 | 2020-10-17 | Japan | Kanagawa | 7891 | 154 | 7120 | 617 | 35.415312 | 139.338983 | 2020-10-18 04:24:25 | Kanagawa, Japan | ||
1026371 | 1026371 | 2020-10-17 | Japan | Kochi | 140 | 4 | 134 | 2 | 33.422519 | 133.367307 | 2020-10-18 04:24:25 | Kochi, Japan | ||
1026372 | 1026372 | 2020-10-17 | Japan | Kumamoto | 740 | 8 | 637 | 95 | 32.608154 | 130.74523100000002 | 2020-10-18 04:24:25 | Kumamoto, Japan | ||
1026373 | 1026373 | 2020-10-17 | Japan | Kyoto | 1922 | 27 | 1761 | 134 | 35.253815 | 135.443341 | 2020-10-18 04:24:25 | Kyoto, Japan | ||
1026374 | 1026374 | 2020-10-17 | Japan | Mie | 549 | 7 | 515 | 27 | 34.508018 | 136.376013 | 2020-10-18 04:24:25 | Mie, Japan | ||
1026375 | 1026375 | 2020-10-17 | Japan | Miyagi | 524 | 2 | 463 | 59 | 38.446859 | 140.927086 | 2020-10-18 04:24:25 | Miyagi, Japan | ||
1026376 | 1026376 | 2020-10-17 | Japan | Miyazaki | 366 | 1 | 365 | 0 | 32.193203999999994 | 131.299374 | 2020-10-18 04:24:25 | Miyazaki, Japan | ||
1026377 | 1026377 | 2020-10-17 | Japan | Nagano | 326 | 4 | 315 | 7 | 36.132134 | 138.045528 | 2020-10-18 04:24:25 | Nagano, Japan | ||
1026378 | 1026378 | 2020-10-17 | Japan | Nagasaki | 242 | 3 | 235 | 4 | 33.235712 | 129.608033 | 2020-10-18 04:24:25 | Nagasaki, Japan | ||
1026379 | 1026379 | 2020-10-17 | Japan | Nara | 606 | 9 | 572 | 25 | 34.317451 | 135.871644 | 2020-10-18 04:24:25 | Nara, Japan | ||
1026380 | 1026380 | 2020-10-17 | Japan | Niigata | 179 | 0 | 176 | 3 | 37.521819 | 138.918647 | 2020-10-18 04:24:25 | Niigata, Japan | ||
1026381 | 1026381 | 2020-10-17 | Japan | Oita | 159 | 2 | 155 | 2 | 33.200697 | 131.43323999999998 | 2020-10-18 04:24:25 | Oita, Japan | ||
1026382 | 1026382 | 2020-10-17 | Japan | Okayama | 172 | 1 | 155 | 16 | 34.89246 | 133.826252 | 2020-10-18 04:24:25 | Okayama, Japan | ||
1026383 | 1026383 | 2020-10-17 | Japan | Okinawa | 2888 | 54 | 2547 | 287 | 25.768923 | 126.668016 | 2020-10-18 04:24:25 | Okinawa, Japan | ||
1026384 | 1026384 | 2020-10-17 | Japan | Osaka | 11464 | 227 | 10715 | 522 | 34.620965000000005 | 135.507481 | 2020-10-18 04:24:25 | Osaka, Japan | ||
1026385 | 1026385 | 2020-10-17 | Japan | Port Quarantine | 1088 | 1 | 514 | 573 | 2020-10-18 04:24:25 | Port Quarantine, Japan | ||||
1026386 | 1026386 | 2020-10-17 | Japan | Saga | 252 | 0 | 249 | 3 | 33.286977 | 130.115738 | 2020-10-18 04:24:25 | Saga, Japan | ||
1026387 | 1026387 | 2020-10-17 | Japan | Saitama | 5328 | 103 | 4778 | 447 | 35.997101 | 139.347635 | 2020-10-18 04:24:25 | Saitama, Japan | ||
1026388 | 1026388 | 2020-10-17 | Japan | Shiga | 522 | 8 | 497 | 17 | 35.21582700000001 | 136.138064 | 2020-10-18 04:24:25 | Shiga, Japan | ||
1026389 | 1026389 | 2020-10-17 | Japan | Shimane | 140 | 0 | 140 | 0 | 35.07076 | 132.55406399999998 | 2020-10-18 04:24:25 | Shimane, Japan | ||
1026390 | 1026390 | 2020-10-17 | Japan | Shizuoka | 578 | 2 | 558 | 18 | 34.916975 | 138.40778400000002 | 2020-10-18 04:24:25 | Shizuoka, Japan | ||
1026391 | 1026391 | 2020-10-17 | Japan | Tochigi | 463 | 1 | 437 | 25 | 36.689912 | 139.819213 | 2020-10-18 04:24:25 | Tochigi, Japan | ||
1026392 | 1026392 | 2020-10-17 | Japan | Tokushima | 158 | 9 | 140 | 9 | 33.919178 | 134.242091 | 2020-10-18 04:24:25 | Tokushima, Japan | ||
1026393 | 1026393 | 2020-10-17 | Japan | Tokyo | 28823 | 434 | 26306 | 2083 | 35.711343 | 139.446921 | 2020-10-18 04:24:25 | Tokyo, Japan | ||
1026394 | 1026394 | 2020-10-17 | Japan | Tottori | 35 | 0 | 36 | 0 | 35.359069 | 133.863619 | 2020-10-18 04:24:25 | Tottori, Japan | ||
1026395 | 1026395 | 2020-10-17 | Japan | Toyama | 422 | 26 | 396 | 0 | 36.637464 | 137.26934599999998 | 2020-10-18 04:24:25 | Toyama, Japan | ||
1026396 | 1026396 | 2020-10-17 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-10-18 04:24:25 | Unknown, Japan | ||||
1026397 | 1026397 | 2020-10-17 | Japan | Wakayama | 255 | 4 | 236 | 15 | 33.911879 | 135.505446 | 2020-10-18 04:24:25 | Wakayama, Japan | ||
1026398 | 1026398 | 2020-10-17 | Japan | Yamagata | 81 | 1 | 78 | 2 | 38.448396 | 140.102154 | 2020-10-18 04:24:25 | Yamagata, Japan | ||
1026399 | 1026399 | 2020-10-17 | Japan | Yamaguchi | 209 | 2 | 203 | 4 | 34.201190000000004 | 131.573293 | 2020-10-18 04:24:25 | Yamaguchi, Japan | ||
1026400 | 1026400 | 2020-10-17 | Japan | Yamanashi | 199 | 6 | 191 | 2 | 35.612364 | 138.61148899999998 | 2020-10-18 04:24:25 | Yamanashi, Japan | ||
2856847 | 2856847 | 2020-10-16 | Japan | Aichi | 5702 | 91 | 5287 | 324 | 35.035551 | 137.211621 | 2020-10-17 04:24:12 | Aichi, Japan | ||
2856848 | 2856848 | 2020-10-16 | Japan | Akita | 59 | 0 | 58 | 1 | 39.748679 | 140.408228 | 2020-10-17 04:24:12 | Akita, Japan | ||
2856849 | 2856849 | 2020-10-16 | Japan | Aomori | 83 | 1 | 36 | 46 | 40.781541 | 140.828896 | 2020-10-17 04:24:12 | Aomori, Japan | ||
2856850 | 2856850 | 2020-10-16 | Japan | Chiba | 4458 | 76 | 4019 | 363 | 35.510141 | 140.198917 | 2020-10-17 04:24:12 | Chiba, Japan | ||
2856851 | 2856851 | 2020-10-16 | Japan | Ehime | 116 | 6 | 108 | 2 | 33.624835 | 132.856842 | 2020-10-17 04:24:12 | Ehime, Japan | ||
2856852 | 2856852 | 2020-10-16 | Japan | Fukui | 254 | 11 | 234 | 9 | 35.846614 | 136.22465400000002 | 2020-10-17 04:24:12 | Fukui, Japan | ||
2856853 | 2856853 | 2020-10-16 | Japan | Fukuoka | 5136 | 99 | 4953 | 84 | 33.526032 | 130.666949 | 2020-10-17 04:24:12 | Fukuoka, Japan | ||
2856854 | 2856854 | 2020-10-16 | Japan | Fukushima | 347 | 6 | 255 | 86 | 37.378867 | 140.223295 | 2020-10-17 04:24:12 | Fukushima, Japan | ||
2856855 | 2856855 | 2020-10-16 | Japan | Gifu | 642 | 10 | 619 | 13 | 35.778671 | 137.055925 | 2020-10-17 04:24:12 | Gifu, Japan | ||
2856856 | 2856856 | 2020-10-16 | Japan | Gunma | 766 | 19 | 710 | 37 | 36.504479 | 138.985605 | 2020-10-17 04:24:12 | Gunma, Japan | ||
2856857 | 2856857 | 2020-10-16 | Japan | Hiroshima | 647 | 4 | 597 | 46 | 34.605309000000005 | 132.788719 | 2020-10-17 04:24:12 | Hiroshima, Japan | ||
2856858 | 2856858 | 2020-10-16 | Japan | Hokkaido | 2491 | 108 | 2129 | 254 | 43.385711 | 142.552318 | 2020-10-17 04:24:12 | Hokkaido, Japan | ||
2856859 | 2856859 | 2020-10-16 | Japan | Hyogo | 2977 | 60 | 2764 | 153 | 35.039913 | 134.828057 | 2020-10-17 04:24:12 | Hyogo, Japan | ||
2856860 | 2856860 | 2020-10-16 | Japan | Ibaraki | 723 | 18 | 664 | 41 | 36.303588 | 140.319591 | 2020-10-17 04:24:12 | Ibaraki, Japan | ||
2856861 | 2856861 | 2020-10-16 | Japan | Ishikawa | 788 | 47 | 721 | 20 | 36.769464 | 136.771027 | 2020-10-17 04:24:12 | Ishikawa, Japan | ||
2856862 | 2856862 | 2020-10-16 | Japan | Iwate | 26 | 0 | 23 | 3 | 39.593287 | 141.361777 | 2020-10-17 04:24:12 | Iwate, Japan | ||
2856863 | 2856863 | 2020-10-16 | Japan | Kagawa | 99 | 2 | 91 | 6 | 34.217292 | 133.969047 | 2020-10-17 04:24:12 | Kagawa, Japan | ||
2856864 | 2856864 | 2020-10-16 | Japan | Kagoshima | 463 | 12 | 432 | 19 | 31.009484000000004 | 130.430665 | 2020-10-17 04:24:12 | Kagoshima, Japan | ||
2856865 | 2856865 | 2020-10-16 | Japan | Kanagawa | 7841 | 154 | 7062 | 625 | 35.415312 | 139.338983 | 2020-10-17 04:24:12 | Kanagawa, Japan | ||
2856866 | 2856866 | 2020-10-16 | Japan | Kochi | 140 | 4 | 134 | 2 | 33.422519 | 133.367307 | 2020-10-17 04:24:12 | Kochi, Japan | ||
2856867 | 2856867 | 2020-10-16 | Japan | Kumamoto | 735 | 8 | 625 | 102 | 32.608154 | 130.74523100000002 | 2020-10-17 04:24:12 | Kumamoto, Japan | ||
2856868 | 2856868 | 2020-10-16 | Japan | Kyoto | 1914 | 27 | 1755 | 132 | 35.253815 | 135.443341 | 2020-10-17 04:24:12 | Kyoto, Japan | ||
2856869 | 2856869 | 2020-10-16 | Japan | Mie | 546 | 7 | 515 | 24 | 34.508018 | 136.376013 | 2020-10-17 04:24:12 | Mie, Japan | ||
2856870 | 2856870 | 2020-10-16 | Japan | Miyagi | 522 | 2 | 461 | 59 | 38.446859 | 140.927086 | 2020-10-17 04:24:12 | Miyagi, Japan | ||
2856871 | 2856871 | 2020-10-16 | Japan | Miyazaki | 366 | 1 | 365 | 0 | 32.193203999999994 | 131.299374 | 2020-10-17 04:24:12 | Miyazaki, Japan | ||
2856872 | 2856872 | 2020-10-16 | Japan | Nagano | 323 | 3 | 315 | 5 | 36.132134 | 138.045528 | 2020-10-17 04:24:12 | Nagano, Japan | ||
2856873 | 2856873 | 2020-10-16 | Japan | Nagasaki | 241 | 3 | 234 | 4 | 33.235712 | 129.608033 | 2020-10-17 04:24:12 | Nagasaki, Japan | ||
2856874 | 2856874 | 2020-10-16 | Japan | Nara | 603 | 9 | 571 | 23 | 34.317451 | 135.871644 | 2020-10-17 04:24:12 | Nara, Japan | ||
2856875 | 2856875 | 2020-10-16 | Japan | Niigata | 179 | 0 | 173 | 6 | 37.521819 | 138.918647 | 2020-10-17 04:24:12 | Niigata, Japan | ||
2856876 | 2856876 | 2020-10-16 | Japan | Oita | 159 | 2 | 155 | 2 | 33.200697 | 131.43323999999998 | 2020-10-17 04:24:12 | Oita, Japan | ||
2856877 | 2856877 | 2020-10-16 | Japan | Okayama | 170 | 1 | 155 | 14 | 34.89246 | 133.826252 | 2020-10-17 04:24:12 | Okayama, Japan | ||
2856878 | 2856878 | 2020-10-16 | Japan | Okinawa | 2855 | 54 | 2519 | 282 | 25.768923 | 126.668016 | 2020-10-17 04:24:12 | Okinawa, Japan | ||
2856879 | 2856879 | 2020-10-16 | Japan | Osaka | 11414 | 226 | 10671 | 517 | 34.620965000000005 | 135.507481 | 2020-10-17 04:24:12 | Osaka, Japan | ||
2856880 | 2856880 | 2020-10-16 | Japan | Port Quarantine | 1076 | 1 | 514 | 561 | 2020-10-17 04:24:12 | Port Quarantine, Japan | ||||
2856881 | 2856881 | 2020-10-16 | Japan | Saga | 250 | 0 | 248 | 2 | 33.286977 | 130.115738 | 2020-10-17 04:24:12 | Saga, Japan | ||
2856882 | 2856882 | 2020-10-16 | Japan | Saitama | 5283 | 103 | 4709 | 471 | 35.997101 | 139.347635 | 2020-10-17 04:24:12 | Saitama, Japan | ||
2856883 | 2856883 | 2020-10-16 | Japan | Shiga | 520 | 8 | 496 | 16 | 35.21582700000001 | 136.138064 | 2020-10-17 04:24:12 | Shiga, Japan | ||
2856884 | 2856884 | 2020-10-16 | Japan | Shimane | 140 | 0 | 140 | 0 | 35.07076 | 132.55406399999998 | 2020-10-17 04:24:12 | Shimane, Japan | ||
2856885 | 2856885 | 2020-10-16 | Japan | Shizuoka | 575 | 2 | 557 | 16 | 34.916975 | 138.40778400000002 | 2020-10-17 04:24:12 | Shizuoka, Japan | ||
2856886 | 2856886 | 2020-10-16 | Japan | Tochigi | 458 | 1 | 435 | 22 | 36.689912 | 139.819213 | 2020-10-17 04:24:12 | Tochigi, Japan | ||
2856887 | 2856887 | 2020-10-16 | Japan | Tokushima | 149 | 9 | 140 | 0 | 33.919178 | 134.242091 | 2020-10-17 04:24:12 | Tokushima, Japan | ||
2856888 | 2856888 | 2020-10-16 | Japan | Tokyo | 28588 | 431 | 26091 | 2066 | 35.711343 | 139.446921 | 2020-10-17 04:24:12 | Tokyo, Japan | ||
2856889 | 2856889 | 2020-10-16 | Japan | Tottori | 35 | 0 | 35 | 0 | 35.359069 | 133.863619 | 2020-10-17 04:24:12 | Tottori, Japan | ||
2856890 | 2856890 | 2020-10-16 | Japan | Toyama | 422 | 26 | 396 | 0 | 36.637464 | 137.26934599999998 | 2020-10-17 04:24:12 | Toyama, Japan | ||
2856891 | 2856891 | 2020-10-16 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-10-17 04:24:12 | Unknown, Japan | ||||
2856892 | 2856892 | 2020-10-16 | Japan | Wakayama | 254 | 4 | 235 | 15 | 33.911879 | 135.505446 | 2020-10-17 04:24:12 | Wakayama, Japan | ||
2856893 | 2856893 | 2020-10-16 | Japan | Yamagata | 81 | 1 | 77 | 3 | 38.448396 | 140.102154 | 2020-10-17 04:24:12 | Yamagata, Japan | ||
2856894 | 2856894 | 2020-10-16 | Japan | Yamaguchi | 209 | 2 | 201 | 6 | 34.201190000000004 | 131.573293 | 2020-10-17 04:24:12 | Yamaguchi, Japan | ||
2856895 | 2856895 | 2020-10-16 | Japan | Yamanashi | 199 | 6 | 190 | 3 | 35.612364 | 138.61148899999998 | 2020-10-17 04:24:12 | Yamanashi, Japan | ||
786377 | 786377 | 2020-10-15 | Japan | Aichi | 5681 | 91 | 5258 | 332 | 35.035551 | 137.211621 | 2020-10-16 04:24:01 | Aichi, Japan | ||
786378 | 786378 | 2020-10-15 | Japan | Akita | 59 | 0 | 58 | 1 | 39.748679 | 140.408228 | 2020-10-16 04:24:01 | Akita, 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]);