daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46,430 rows where country_or_region = "Japan" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (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
- …
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-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-01-24 | Japan | 2 | 0 | 0 | 1/24/20 17:00 | |||||||
2020-01-29 | Japan | 7 | 0 | 1 | 1/29/20 19:30 | |||||||
2020-03-03 | Japan | 293 | 6 | 43 | 36.0 | 138.0 | 2020-03-03T20:03:06 | |||||
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-02-25 | Japan | 170 | 1 | 22 | 2020-02-25T14:53:03 | |||||||
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-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-01-23 | Japan | 1 | 0 | 0 | 1/23/20 17:00 | |||||||
2020-02-22 | Japan | 122 | 1 | 22 | 2020-02-22T14:53:02 | |||||||
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-02-14 | Japan | 29 | 1 | 9 | 2020-02-14T03:53:02 | |||||||
2020-02-17 | Japan | 66 | 1 | 12 | 2020-02-17T14:33:04 | |||||||
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-03-15 | Japan | 839 | 22 | 118 | 36.2048 | 138.2529 | 2020-03-14T22:33:03 | |||||
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-02-18 | Japan | 74 | 1 | 13 | 2020-02-18T17:23:04 | |||||||
2020-01-22 | Japan | 2 | 0 | 0 | 1/22/2020 17:00 | |||||||
2020-02-16 | Japan | 59 | 1 | 12 | 2020-02-16T17:43:03 | |||||||
2020-02-05 | Japan | 22 | 0 | 1 | 2020-02-04T16:43:03 | |||||||
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-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-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-02-26 | Japan | 189 | 2 | 22 | 2020-02-26T23:43:03 | |||||||
2020-02-12 | Japan | 28 | 0 | 9 | 2020-02-12T02:43:03 | |||||||
2020-02-03 | Japan | 20 | 0 | 1 | 2020-02-01T18:53:03 | |||||||
2020-02-28 | Japan | 228 | 4 | 22 | 2020-02-28T12:43:02 | |||||||
2020-01-25 | Japan | 2 | 0 | 0 | 1/25/20 17:00 | |||||||
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-02-09 | Japan | 26 | 0 | 1 | 2020-02-09T06:13:11 | |||||||
2020-02-01 | Japan | 20 | 0 | 1 | 2/1/2020 18:53 | |||||||
2020-02-04 | Japan | 22 | 0 | 1 | 2020-02-04T16:43:03 | |||||||
2020-02-24 | Japan | 159 | 1 | 22 | 2020-02-24T14:23:03 | |||||||
2020-03-20 | Japan | 963 | 33 | 191 | 36.2048 | 138.2529 | 2020-03-20T14:13:08 | |||||
2020-03-10 | Japan | 581 | 10 | 101 | 36.0 | 138.0 | 2020-03-10T16:13:16 | |||||
2020-01-27 | Japan | 4 | 0 | 1 | 1/27/20 23:59 | |||||||
2020-01-31 | Japan | 15 | 0 | 1 | 1/31/2020 23:59 | |||||||
2020-03-13 | Japan | 701 | 19 | 118 | 36.2048 | 138.2529 | 2020-03-11T20:00:00 | |||||
2020-03-17 | Japan | 878 | 29 | 144 | 36.2048 | 138.2529 | 2020-03-17T16:53:04 | |||||
2021-12-02 | Japan | Aichi | 106899 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-03 04:23:05 | Aichi, Japan | |||
2021-10-28 | Japan | Aichi | 106589 | 1156 | 0 | 35.035551 | 137.211621 | 2021-10-29 04:22:03 | Aichi, Japan | |||
2020-10-25 | Japan | Aichi | 5935 | 92 | 5453 | 390 | 35.035551 | 137.211621 | 2020-10-26 04:25:02 | Aichi, Japan | ||
2021-01-26 | Japan | Aichi | 23167 | 375 | 19448 | 3344 | 35.035551 | 137.211621 | 2021-01-27 05:23:41 | Aichi, Japan | ||
2021-09-18 | Japan | Aichi | 103253 | 1101 | 0 | 35.035551 | 137.211621 | 2021-09-19 04:21:34 | Aichi, Japan | |||
2021-05-28 | Japan | Aichi | 46493 | 771 | 38922 | 6800 | 35.035551 | 137.211621 | 2021-05-29 04:20:41 | Aichi, Japan | ||
2022-03-20 | Japan | Aichi | 388713 | 1910 | 0 | 35.035551 | 137.211621 | 2022-03-21 04:20:50 | Aichi, Japan | |||
2021-11-11 | Japan | Aichi | 106746 | 1157 | 0 | 35.035551 | 137.211621 | 2021-11-12 04:22:01 | Aichi, Japan | |||
2021-08-25 | Japan | Aichi | 72840 | 1032 | 0 | 35.035551 | 137.211621 | 2021-08-26 04:21:28 | Aichi, Japan | |||
2021-04-12 | Japan | Aichi | 28964 | 604 | 26691 | 1669 | 35.035551 | 137.211621 | 2021-04-13 04:20:37 | Aichi, Japan | ||
2021-11-02 | Japan | Aichi | 106655 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-03 06:22:09 | Aichi, Japan | |||
2021-05-29 | Japan | Aichi | 46839 | 777 | 39507 | 6555 | 35.035551 | 137.211621 | 2021-05-30 04:20:55 | Aichi, Japan | ||
2021-03-07 | Japan | Aichi | 26190 | 541 | 24981 | 668 | 35.035551 | 137.211621 | 2021-03-08 05:24:48 | Aichi, Japan | ||
2020-07-23 | Japan | Aichi | 878 | 35 | 491 | 352 | 35.035551 | 137.211621 | 2020-07-24 05:30:40 | Aichi, Japan | ||
2022-11-12 | Japan | Aichi | 1462259 | 3013 | 0 | 35.035551 | 137.211621 | 2022-11-13 04:21:14 | Aichi, Japan | |||
2021-09-01 | Japan | Aichi | 85594 | 1046 | 0 | 35.035551 | 137.211621 | 2021-09-02 04:21:15 | Aichi, Japan | |||
2022-02-07 | Japan | Aichi | 208429 | 1258 | 0 | 35.035551 | 137.211621 | 2022-02-08 04:21:15 | Aichi, Japan | |||
2020-12-03 | Japan | Aichi | 10736 | 123 | 8457 | 2156 | 35.035551 | 137.211621 | 2020-12-04 05:27:27 | Aichi, Japan | ||
2020-10-14 | Japan | Aichi | 5662 | 91 | 5228 | 343 | 35.035551 | 137.211621 | 2020-10-15 04:24:28 | Aichi, Japan | ||
2021-05-25 | Japan | Aichi | 45273 | 730 | 37416 | 7127 | 35.035551 | 137.211621 | 2021-05-26 04:20:35 | Aichi, Japan | ||
2021-11-09 | Japan | Aichi | 106729 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-10 04:21:38 | Aichi, Japan | |||
2022-07-23 | Japan | Aichi | 692653 | 2117 | 0 | 35.035551 | 137.211621 | 2022-07-24 04:20:47 | Aichi, Japan | |||
2020-08-04 | Japan | Aichi | 2435 | 35 | 620 | 1780 | 35.035551 | 137.211621 | 2020-08-05 04:34:43 | Aichi, Japan | ||
2022-01-14 | Japan | Aichi | 111923 | 1163 | 0 | 35.035551 | 137.211621 | 2022-01-15 04:21:07 | Aichi, Japan | |||
2021-08-15 | Japan | Aichi | 60369 | 1018 | 0 | 35.035551 | 137.211621 | 2021-08-16 04:21:31 | Aichi, Japan | |||
2021-06-19 | Japan | Aichi | 50429 | 929 | 47265 | 2235 | 35.035551 | 137.211621 | 2021-06-20 04:21:48 | Aichi, Japan | ||
2022-09-06 | Japan | Aichi | 1257634 | 2708 | 0 | 35.035551 | 137.211621 | 2022-09-07 04:20:59 | Aichi, Japan | |||
2020-07-19 | Japan | Aichi | 643 | 34 | 485 | 124 | 35.035551 | 137.211621 | 2020-07-20 05:34:40 | Aichi, Japan | ||
2020-11-18 | Japan | Aichi | 8054 | 103 | 6555 | 1396 | 35.035551 | 137.211621 | 2020-11-19 05:25:23 | Aichi, Japan | ||
2022-01-09 | Japan | Aichi | 108371 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-10 04:22:07 | Aichi, Japan | |||
2022-10-04 | Japan | Aichi | 1371697 | 2881 | 0 | 35.035551 | 137.211621 | 2022-10-05 04:23:06 | Aichi, Japan | |||
2021-12-04 | Japan | Aichi | 106910 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-05 04:22:25 | Aichi, Japan | |||
2022-07-09 | Japan | Aichi | 589307 | 2104 | 0 | 35.035551 | 137.211621 | 2022-07-10 04:20:54 | Aichi, Japan | |||
2020-08-15 | Japan | Aichi | 3718 | 43 | 1804 | 1871 | 35.035551 | 137.211621 | 2020-08-16 04:27:42 | Aichi, Japan | ||
2021-11-29 | Japan | Aichi | 106878 | 1161 | 0 | 35.035551 | 137.211621 | 2021-11-30 04:22:53 | Aichi, Japan | |||
2021-01-08 | Japan | Aichi | 18735 | 263 | 15030 | 3442 | 35.035551 | 137.211621 | 2021-01-09 05:22:18 | Aichi, Japan | ||
2022-03-29 | Japan | Aichi | 408731 | 1958 | 0 | 35.035551 | 137.211621 | 2022-03-30 04:20:45 | Aichi, Japan | |||
2021-11-19 | Japan | Aichi | 106821 | 1159 | 0 | 35.035551 | 137.211621 | 2021-11-20 04:22:17 | Aichi, Japan | |||
2022-06-21 | Japan | Aichi | 561774 | 2095 | 0 | 35.035551 | 137.211621 | 2022-06-22 04:20:54 | Aichi, Japan | |||
2021-04-16 | Japan | Aichi | 29790 | 608 | 27034 | 2148 | 35.035551 | 137.211621 | 2021-04-17 04:20:40 | Aichi, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;