daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46,430 rows where country_or_region = "Japan" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
province_or_state >30
- Aichi 946
- Akita 946
- Aomori 946
- Chiba 946
- Ehime 946
- Fukui 946
- Fukuoka 946
- Fukushima 946
- Gifu 946
- Gunma 946
- Hiroshima 946
- Hokkaido 946
- Hyogo 946
- Ibaraki 946
- Ishikawa 946
- Kagawa 946
- Kagoshima 946
- Kanagawa 946
- Kochi 946
- Kumamoto 946
- Kyoto 946
- Mie 946
- Miyagi 946
- Miyazaki 946
- Nagano 946
- Nagasaki 946
- Nara 946
- Niigata 946
- Oita 946
- Okayama 946
- …
last_update (date) >30 ✖
- 2021-11-10 707
- 2022-11-22 125
- 2022-04-13 94
- 2022-05-26 94
- 2020-07-19 49
- 2020-07-20 49
- 2020-07-21 49
- 2020-07-22 49
- 2020-07-23 49
- 2020-07-24 49
- 2020-07-25 49
- 2020-07-26 49
- 2020-07-27 49
- 2020-07-28 49
- 2020-07-29 49
- 2020-07-30 49
- 2020-07-31 49
- 2020-08-01 49
- 2020-08-02 49
- 2020-08-03 49
- 2020-08-04 49
- 2020-08-05 49
- 2020-08-06 49
- 2020-08-07 49
- 2020-08-08 49
- 2020-08-09 49
- 2020-08-10 49
- 2020-08-11 49
- 2020-08-12 49
- 2020-08-13 49
- …
country_or_region 1
- Japan · 46,430 ✖
day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-05 | Japan | 360 | 6 | 43 | 36.0 | 138.0 | 2020-03-05T13:43:04 | |||||
2020-04-13 | Japan | 7370 | 123 | 784 | 6463 | 36.204824 | 138.252924 | 2020-04-13 23:07:34 | Japan | |||
2020-04-17 | Japan | 9787 | 190 | 935 | 8662 | 36.204824 | 138.252924 | 2020-04-17 23:30:32 | Japan | |||
2020-03-07 | Japan | 461 | 6 | 76 | 36.0 | 138.0 | 2020-03-07T17:43:05 | |||||
2020-03-04 | Japan | 331 | 6 | 43 | 36.0 | 138.0 | 2020-03-04T19:23:03 | |||||
2020-02-15 | Japan | 43 | 1 | 12 | 2020-02-15T17:43:06 | |||||||
2020-05-08 | Japan | 15575 | 590 | 5146 | 9839 | 36.204824 | 138.252924 | 2020-05-09 02:32:35 | Japan | |||
2020-04-29 | Japan | 13895 | 413 | 2368 | 11114 | 36.204824 | 138.252924 | 2020-04-30 02:32:27 | Japan | |||
2020-01-24 | Japan | 2 | 0 | 0 | 1/24/20 17:00 | |||||||
2020-01-29 | Japan | 7 | 0 | 1 | 1/29/20 19:30 | |||||||
2020-04-30 | Japan | 14088 | 430 | 2460 | 11198 | 36.204824 | 138.252924 | 2020-05-01 02:32:28 | Japan | |||
2020-03-03 | Japan | 293 | 6 | 43 | 36.0 | 138.0 | 2020-03-03T20:03:06 | |||||
2020-05-21 | Japan | 16424 | 777 | 12672 | 2975 | 36.204824 | 138.252924 | 2020-05-22 02:36:51 | Japan | |||
2020-04-28 | Japan | 13736 | 394 | 1899 | 11443 | 36.204824 | 138.252924 | 2020-04-29 02:32:29 | Japan | |||
2020-03-21 | Japan | 1007 | 35 | 232 | 36.2048 | 138.2529 | 2020-03-21T20:43:02 | |||||
2020-01-26 | Japan | 4 | 0 | 1 | 1/26/20 16:00 | |||||||
2020-04-18 | Japan | 10296 | 222 | 1069 | 9005 | 36.204824 | 138.252924 | 2020-04-18 22:32:28 | Japan | |||
2020-02-25 | Japan | 170 | 1 | 22 | 2020-02-25T14:53:03 | |||||||
2020-04-21 | Japan | 11135 | 263 | 1239 | 9633 | 36.204824 | 138.252924 | 2020-04-21 23:30:30 | Japan | |||
2020-03-01 | Japan | 256 | 6 | 32 | 36.0 | 138.0 | 2020-03-01T23:33:03 | |||||
2020-02-06 | Japan | 45 | 0 | 1 | 2020-02-06T02:53:03 | |||||||
2020-04-05 | Japan | 3139 | 77 | 514 | 2548 | 36.204824 | 138.252924 | 2020-04-05 23:06:26 | Japan | |||
2020-02-27 | Japan | 214 | 4 | 22 | 2020-02-27T23:33:02 | |||||||
2020-03-09 | Japan | 511 | 17 | 76 | 36.0 | 138.0 | 2020-03-09T09:13:17 | |||||
2020-03-27 | Japan | 1468 | 49 | 372 | 1047 | 36.204824 | 138.252924 | 2020-03-27 23:23:03 | Japan | |||
2020-04-15 | Japan | 8100 | 146 | 853 | 7101 | 36.204824 | 138.252924 | 2020-04-15 22:56:32 | Japan | |||
2020-01-23 | Japan | 1 | 0 | 0 | 1/23/20 17:00 | |||||||
2020-05-24 | Japan | 16550 | 820 | 13413 | 2317 | 36.204824 | 138.252924 | 2020-05-25 02:32:44 | Japan | |||
2020-03-26 | Japan | 1387 | 47 | 359 | 981 | 36.204824 | 138.252924 | 2020-03-26 23:48:18 | Japan | |||
2020-04-16 | Japan | 8626 | 178 | 901 | 7547 | 36.204824 | 138.252924 | 2020-04-16 23:30:31 | Japan | |||
2020-05-23 | Japan | 16536 | 808 | 13244 | 2484 | 36.204824 | 138.252924 | 2020-05-24 02:32:43 | Japan | |||
2020-05-26 | Japan | 16623 | 846 | 13810 | 1967 | 36.204824 | 138.252924 | 2020-05-27 02:32:31 | Japan | |||
2020-02-22 | Japan | 122 | 1 | 22 | 2020-02-22T14:53:02 | |||||||
2020-05-25 | Japan | 16581 | 830 | 13612 | 2139 | 36.204824 | 138.252924 | 2020-05-26 02:32:35 | Japan | |||
2020-03-25 | Japan | 1307 | 45 | 310 | 952 | 36.204824 | 138.252924 | 2020-03-25 23:33:04 | Japan | |||
2020-03-02 | Japan | 274 | 6 | 32 | 36.0 | 138.0 | 2020-03-02T20:33:02 | |||||
2020-03-18 | Japan | 889 | 29 | 144 | 36.2048 | 138.2529 | 2020-03-18T12:33:02 | |||||
2020-05-01 | Japan | 14305 | 455 | 2975 | 10875 | 36.204824 | 138.252924 | 2020-05-02 02:32:27 | Japan | |||
2020-02-14 | Japan | 29 | 1 | 9 | 2020-02-14T03:53:02 | |||||||
2020-04-22 | Japan | 11512 | 281 | 1356 | 9875 | 36.204824 | 138.252924 | 2020-04-22 23:30:32 | Japan | |||
2020-02-17 | Japan | 66 | 1 | 12 | 2020-02-17T14:33:04 | |||||||
2020-04-10 | Japan | 5530 | 99 | 685 | 4746 | 36.204824 | 138.252924 | 2020-04-10 22:53:48 | Japan | |||
2020-01-28 | Japan | 7 | 0 | 1 | 1/28/20 23:00 | |||||||
2020-02-08 | Japan | 25 | 0 | 1 | 2020-02-07T04:13:20 | |||||||
2020-04-19 | Japan | 10797 | 236 | 1159 | 9402 | 36.204824 | 138.252924 | 2020-04-19 23:40:41 | Japan | |||
2020-05-14 | Japan | 16120 | 697 | 9868 | 5555 | 36.204824 | 138.252924 | 2020-05-15 02:33:02 | Japan | |||
2020-05-20 | Japan | 16367 | 768 | 11564 | 4035 | 36.204824 | 138.252924 | 2020-05-21 02:32:48 | Japan | |||
2020-04-24 | Japan | 12829 | 345 | 1530 | 10954 | 36.204824 | 138.252924 | 2020-04-25 06:30:33 | Japan | |||
2020-03-15 | Japan | 839 | 22 | 118 | 36.2048 | 138.2529 | 2020-03-14T22:33:03 | |||||
2020-03-24 | Japan | 1193 | 43 | 285 | 865 | 36.204824 | 138.252924 | 2020-03-24 23:37:15 | Japan | |||
2020-03-19 | Japan | 924 | 29 | 150 | 36.2048 | 138.2529 | 2020-03-19T10:13:15 | |||||
2020-03-08 | Japan | 502 | 6 | 76 | 36.0 | 138.0 | 2020-03-08T14:53:11 | |||||
2020-01-30 | Japan | 11 | 0 | 1 | 1/30/20 16:00 | |||||||
2020-02-13 | Japan | 28 | 1 | 9 | 2020-02-13T12:23:05 | |||||||
2020-02-19 | Japan | 84 | 1 | 18 | 2020-02-19T20:33:02 | |||||||
2020-04-04 | Japan | 3139 | 77 | 514 | 2548 | 36.204824 | 138.252924 | 4/4/20 23:34 | Japan | |||
2020-02-18 | Japan | 74 | 1 | 13 | 2020-02-18T17:23:04 | |||||||
2020-01-22 | Japan | 2 | 0 | 0 | 1/22/2020 17:00 | |||||||
2020-05-16 | Japan | 16237 | 725 | 10338 | 5174 | 36.204824 | 138.252924 | 2020-05-17 02:32:32 | Japan | |||
2020-05-22 | Japan | 16513 | 796 | 13005 | 2712 | 36.204824 | 138.252924 | 2020-05-23 02:32:42 | Japan | |||
2020-03-30 | Japan | 1866 | 54 | 424 | 1388 | 36.204824 | 138.252924 | 3/30/20 22:52 | Japan | |||
2020-02-16 | Japan | 59 | 1 | 12 | 2020-02-16T17:43:03 | |||||||
2020-05-05 | Japan | 15253 | 556 | 4496 | 10201 | 36.204824 | 138.252924 | 2020-05-06 02:32:31 | Japan | |||
2020-05-02 | Japan | 14571 | 474 | 3205 | 10892 | 36.204824 | 138.252924 | 2020-05-03 02:32:28 | Japan | |||
2020-02-05 | Japan | 22 | 0 | 1 | 2020-02-04T16:43:03 | |||||||
2020-05-06 | Japan | 15253 | 556 | 4496 | 10201 | 36.204824 | 138.252924 | 2020-05-07 02:32:28 | Japan | |||
2020-03-14 | Japan | 773 | 22 | 118 | 36.2048 | 138.2529 | 2020-03-14T22:33:03 | |||||
2020-03-11 | Japan | 639 | 15 | 118 | 36.0 | 138.0 | 2020-03-11T21:33:03 | |||||
2020-02-21 | Japan | 105 | 1 | 22 | 2020-02-21T19:03:06 | |||||||
2020-03-23 | Japan | 1128 | 42 | 235 | 851 | 36.204824 | 138.252924 | 2020-03-23 23:19:21 | Japan | |||
2020-03-16 | Japan | 825 | 27 | 144 | 36.2048 | 138.2529 | 2020-03-16T14:38:45 | |||||
2020-02-20 | Japan | 94 | 1 | 18 | 2020-02-20T15:53:03 | |||||||
2020-05-03 | Japan | 14877 | 487 | 3981 | 10409 | 36.204824 | 138.252924 | 2020-05-04 02:32:28 | Japan | |||
2020-03-12 | Japan | 639 | 16 | 118 | 36.0 | 138.0 | 2020-03-12T05:13:02 | |||||
2020-02-02 | Japan | 20 | 0 | 1 | 2020-02-01T18:53:03 | |||||||
2020-05-19 | Japan | 16367 | 768 | 11564 | 4035 | 36.204824 | 138.252924 | 2020-05-20 02:32:19 | Japan | |||
2020-04-20 | Japan | 10797 | 236 | 1159 | 9402 | 36.204824 | 138.252924 | 2020-04-20 23:36:27 | Japan | |||
2020-02-26 | Japan | 189 | 2 | 22 | 2020-02-26T23:43:03 | |||||||
2020-04-23 | Japan | 12368 | 328 | 1494 | 10546 | 36.204824 | 138.252924 | 2020-04-24 03:30:31 | Japan | |||
2020-05-27 | Japan | 16651 | 858 | 13973 | 1820 | 36.204824 | 138.252924 | 2020-05-28 02:32:31 | Japan | |||
2020-04-11 | Japan | 6005 | 99 | 762 | 5144 | 36.204824 | 138.252924 | 2020-04-11 22:45:13 | Japan | |||
2020-02-12 | Japan | 28 | 0 | 9 | 2020-02-12T02:43:03 | |||||||
2020-04-12 | Japan | 6748 | 108 | 762 | 5878 | 36.204824 | 138.252924 | 2020-04-12 23:17:00 | Japan | |||
2020-05-12 | Japan | 15968 | 657 | 8531 | 6780 | 36.204824 | 138.252924 | 2020-05-13 03:32:26 | Japan | |||
2020-02-03 | Japan | 20 | 0 | 1 | 2020-02-01T18:53:03 | |||||||
2020-03-29 | Japan | 1866 | 54 | 424 | 1388 | 36.204824 | 138.252924 | 3/29/20 23:08 | Japan | |||
2020-02-28 | Japan | 228 | 4 | 22 | 2020-02-28T12:43:02 | |||||||
2020-05-09 | Japan | 15663 | 607 | 5906 | 9150 | 36.204824 | 138.252924 | 2020-05-10 02:32:30 | Japan | |||
2020-03-22 | Japan | 1086 | 36 | 235 | 815 | 36.204824 | 138.252924 | 3/22/20 23:45 | Japan | |||
2020-01-25 | Japan | 2 | 0 | 0 | 1/25/20 17:00 | |||||||
2020-04-07 | Japan | 3906 | 92 | 592 | 3222 | 36.204824 | 138.252924 | 2020-04-07 23:04:29 | Japan | |||
2020-05-04 | Japan | 15078 | 536 | 4156 | 10386 | 36.204824 | 138.252924 | 2020-05-05 02:32:34 | Japan | |||
2020-02-10 | Japan | 26 | 0 | 4 | 2020-02-10T21:33:02 | |||||||
2020-02-23 | Japan | 147 | 1 | 22 | 2020-02-23T23:33:07 | |||||||
2020-03-06 | Japan | 420 | 6 | 46 | 36.0 | 138.0 | 2020-03-06T20:13:13 | |||||
2020-02-11 | Japan | 26 | 0 | 9 | 2020-02-11T02:53:02 | |||||||
2020-02-29 | Japan | 241 | 5 | 32 | 2020-02-29T15:53:04 | |||||||
2020-02-07 | Japan | 25 | 0 | 1 | 2020-02-07T04:13:20 | |||||||
2020-05-18 | Japan | 16305 | 749 | 11564 | 3992 | 36.204824 | 138.252924 | 2020-05-19 02:32:18 | Japan | |||
2020-05-15 | Japan | 16203 | 713 | 10338 | 5152 | 36.204824 | 138.252924 | 2020-05-16 02:32:19 | Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;