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 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 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40150 | 40150 | 2020-03-05 | Japan | 360 | 6 | 43 | 36.0 | 138.0 | 2020-03-05T13:43:04 | |||||
62490 | 62490 | 2020-03-07 | Japan | 461 | 6 | 76 | 36.0 | 138.0 | 2020-03-07T17:43:05 | |||||
98819 | 98819 | 2020-03-04 | Japan | 331 | 6 | 43 | 36.0 | 138.0 | 2020-03-04T19:23:03 | |||||
107059 | 107059 | 2020-02-15 | Japan | 43 | 1 | 12 | 2020-02-15T17:43:06 | |||||||
197794 | 197794 | 2020-01-24 | Japan | 2 | 0 | 0 | 1/24/20 17:00 | |||||||
197875 | 197875 | 2020-01-29 | Japan | 7 | 0 | 1 | 1/29/20 19:30 | |||||||
261036 | 261036 | 2020-03-03 | Japan | 293 | 6 | 43 | 36.0 | 138.0 | 2020-03-03T20:03:06 | |||||
339648 | 339648 | 2020-03-21 | Japan | 1007 | 35 | 232 | 36.2048 | 138.2529 | 2020-03-21T20:43:02 | |||||
415868 | 415868 | 2020-01-26 | Japan | 4 | 0 | 1 | 1/26/20 16:00 | |||||||
479151 | 479151 | 2020-02-25 | Japan | 170 | 1 | 22 | 2020-02-25T14:53:03 | |||||||
562513 | 562513 | 2020-03-01 | Japan | 256 | 6 | 32 | 36.0 | 138.0 | 2020-03-01T23:33:03 | |||||
566695 | 566695 | 2020-02-06 | Japan | 45 | 0 | 1 | 2020-02-06T02:53:03 | |||||||
617412 | 617412 | 2020-02-27 | Japan | 214 | 4 | 22 | 2020-02-27T23:33:02 | |||||||
657701 | 657701 | 2020-03-09 | Japan | 511 | 17 | 76 | 36.0 | 138.0 | 2020-03-09T09:13:17 | |||||
864412 | 864412 | 2020-01-23 | Japan | 1 | 0 | 0 | 1/23/20 17:00 | |||||||
1085651 | 1085651 | 2020-02-22 | Japan | 122 | 1 | 22 | 2020-02-22T14:53:02 | |||||||
1152652 | 1152652 | 2020-03-02 | Japan | 274 | 6 | 32 | 36.0 | 138.0 | 2020-03-02T20:33:02 | |||||
1176898 | 1176898 | 2020-03-18 | Japan | 889 | 29 | 144 | 36.2048 | 138.2529 | 2020-03-18T12:33:02 | |||||
1192479 | 1192479 | 2020-02-14 | Japan | 29 | 1 | 9 | 2020-02-14T03:53:02 | |||||||
1243379 | 1243379 | 2020-02-17 | Japan | 66 | 1 | 12 | 2020-02-17T14:33:04 | |||||||
1305790 | 1305790 | 2020-01-28 | Japan | 7 | 0 | 1 | 1/28/20 23:00 | |||||||
1366073 | 1366073 | 2020-02-08 | Japan | 25 | 0 | 1 | 2020-02-07T04:13:20 | |||||||
1463482 | 1463482 | 2020-03-15 | Japan | 839 | 22 | 118 | 36.2048 | 138.2529 | 2020-03-14T22:33:03 | |||||
1526895 | 1526895 | 2020-03-19 | Japan | 924 | 29 | 150 | 36.2048 | 138.2529 | 2020-03-19T10:13:15 | |||||
1527217 | 1527217 | 2020-03-08 | Japan | 502 | 6 | 76 | 36.0 | 138.0 | 2020-03-08T14:53:11 | |||||
1527528 | 1527528 | 2020-01-30 | Japan | 11 | 0 | 1 | 1/30/20 16:00 | |||||||
1559686 | 1559686 | 2020-02-13 | Japan | 28 | 1 | 9 | 2020-02-13T12:23:05 | |||||||
1720069 | 1720069 | 2020-02-19 | Japan | 84 | 1 | 18 | 2020-02-19T20:33:02 | |||||||
1783103 | 1783103 | 2020-02-18 | Japan | 74 | 1 | 13 | 2020-02-18T17:23:04 | |||||||
1802375 | 1802375 | 2020-01-22 | Japan | 2 | 0 | 0 | 1/22/2020 17:00 | |||||||
1888732 | 1888732 | 2020-02-16 | Japan | 59 | 1 | 12 | 2020-02-16T17:43:03 | |||||||
2091692 | 2091692 | 2020-02-05 | Japan | 22 | 0 | 1 | 2020-02-04T16:43:03 | |||||||
2111105 | 2111105 | 2020-03-14 | Japan | 773 | 22 | 118 | 36.2048 | 138.2529 | 2020-03-14T22:33:03 | |||||
2127446 | 2127446 | 2020-03-11 | Japan | 639 | 15 | 118 | 36.0 | 138.0 | 2020-03-11T21:33:03 | |||||
2135734 | 2135734 | 2020-02-21 | Japan | 105 | 1 | 22 | 2020-02-21T19:03:06 | |||||||
2255135 | 2255135 | 2020-03-16 | Japan | 825 | 27 | 144 | 36.2048 | 138.2529 | 2020-03-16T14:38:45 | |||||
2263476 | 2263476 | 2020-02-20 | Japan | 94 | 1 | 18 | 2020-02-20T15:53:03 | |||||||
2282877 | 2282877 | 2020-03-12 | Japan | 639 | 16 | 118 | 36.0 | 138.0 | 2020-03-12T05:13:02 | |||||
2379257 | 2379257 | 2020-02-02 | Japan | 20 | 0 | 1 | 2020-02-01T18:53:03 | |||||||
2509767 | 2509767 | 2020-02-26 | Japan | 189 | 2 | 22 | 2020-02-26T23:43:03 | |||||||
2567276 | 2567276 | 2020-02-12 | Japan | 28 | 0 | 9 | 2020-02-12T02:43:03 | |||||||
2860571 | 2860571 | 2020-02-03 | Japan | 20 | 0 | 1 | 2020-02-01T18:53:03 | |||||||
2883927 | 2883927 | 2020-02-28 | Japan | 228 | 4 | 22 | 2020-02-28T12:43:02 | |||||||
2938967 | 2938967 | 2020-01-25 | Japan | 2 | 0 | 0 | 1/25/20 17:00 | |||||||
3089035 | 3089035 | 2020-02-10 | Japan | 26 | 0 | 4 | 2020-02-10T21:33:02 | |||||||
3173360 | 3173360 | 2020-02-23 | Japan | 147 | 1 | 22 | 2020-02-23T23:33:07 | |||||||
3177494 | 3177494 | 2020-03-06 | Japan | 420 | 6 | 46 | 36.0 | 138.0 | 2020-03-06T20:13:13 | |||||
3197736 | 3197736 | 2020-02-11 | Japan | 26 | 0 | 9 | 2020-02-11T02:53:02 | |||||||
3205804 | 3205804 | 2020-02-29 | Japan | 241 | 5 | 32 | 2020-02-29T15:53:04 | |||||||
3222031 | 3222031 | 2020-02-07 | Japan | 25 | 0 | 1 | 2020-02-07T04:13:20 | |||||||
3362403 | 3362403 | 2020-02-09 | Japan | 26 | 0 | 1 | 2020-02-09T06:13:11 | |||||||
3413167 | 3413167 | 2020-02-01 | Japan | 20 | 0 | 1 | 2/1/2020 18:53 | |||||||
3471909 | 3471909 | 2020-02-04 | Japan | 22 | 0 | 1 | 2020-02-04T16:43:03 | |||||||
3551216 | 3551216 | 2020-02-24 | Japan | 159 | 1 | 22 | 2020-02-24T14:23:03 | |||||||
3733944 | 3733944 | 2020-03-20 | Japan | 963 | 33 | 191 | 36.2048 | 138.2529 | 2020-03-20T14:13:08 | |||||
3752830 | 3752830 | 2020-03-10 | Japan | 581 | 10 | 101 | 36.0 | 138.0 | 2020-03-10T16:13:16 | |||||
3753093 | 3753093 | 2020-01-27 | Japan | 4 | 0 | 1 | 1/27/20 23:59 | |||||||
3761210 | 3761210 | 2020-01-31 | Japan | 15 | 0 | 1 | 1/31/2020 23:59 | |||||||
3765386 | 3765386 | 2020-03-13 | Japan | 701 | 19 | 118 | 36.2048 | 138.2529 | 2020-03-11T20:00:00 | |||||
3891329 | 3891329 | 2020-03-17 | Japan | 878 | 29 | 144 | 36.2048 | 138.2529 | 2020-03-17T16:53:04 | |||||
314 | 314 | 2021-12-02 | Japan | Aichi | 106899 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-03 04:23:05 | Aichi, Japan | |||
4330 | 4330 | 2021-10-28 | Japan | Aichi | 106589 | 1156 | 0 | 35.035551 | 137.211621 | 2021-10-29 04:22:03 | Aichi, Japan | |||
8332 | 8332 | 2020-10-25 | Japan | Aichi | 5935 | 92 | 5453 | 390 | 35.035551 | 137.211621 | 2020-10-26 04:25:02 | Aichi, Japan | ||
12340 | 12340 | 2021-01-26 | Japan | Aichi | 23167 | 375 | 19448 | 3344 | 35.035551 | 137.211621 | 2021-01-27 05:23:41 | Aichi, Japan | ||
16355 | 16355 | 2021-09-18 | Japan | Aichi | 103253 | 1101 | 0 | 35.035551 | 137.211621 | 2021-09-19 04:21:34 | Aichi, Japan | |||
20370 | 20370 | 2021-05-28 | Japan | Aichi | 46493 | 771 | 38922 | 6800 | 35.035551 | 137.211621 | 2021-05-29 04:20:41 | Aichi, Japan | ||
24385 | 24385 | 2022-03-20 | Japan | Aichi | 388713 | 1910 | 0 | 35.035551 | 137.211621 | 2022-03-21 04:20:50 | Aichi, Japan | |||
28400 | 28400 | 2021-11-11 | Japan | Aichi | 106746 | 1157 | 0 | 35.035551 | 137.211621 | 2021-11-12 04:22:01 | Aichi, Japan | |||
32416 | 32416 | 2021-08-25 | Japan | Aichi | 72840 | 1032 | 0 | 35.035551 | 137.211621 | 2021-08-26 04:21:28 | Aichi, Japan | |||
36430 | 36430 | 2021-04-12 | Japan | Aichi | 28964 | 604 | 26691 | 1669 | 35.035551 | 137.211621 | 2021-04-13 04:20:37 | Aichi, Japan | ||
43692 | 43692 | 2021-11-02 | Japan | Aichi | 106655 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-03 06:22:09 | Aichi, Japan | |||
50791 | 50791 | 2021-05-29 | Japan | Aichi | 46839 | 777 | 39507 | 6555 | 35.035551 | 137.211621 | 2021-05-30 04:20:55 | Aichi, Japan | ||
54805 | 54805 | 2021-03-07 | Japan | Aichi | 26190 | 541 | 24981 | 668 | 35.035551 | 137.211621 | 2021-03-08 05:24:48 | Aichi, Japan | ||
61744 | 61744 | 2020-07-23 | Japan | Aichi | 878 | 35 | 491 | 352 | 35.035551 | 137.211621 | 2020-07-24 05:30:40 | Aichi, Japan | ||
63046 | 63046 | 2022-11-12 | Japan | Aichi | 1462259 | 3013 | 0 | 35.035551 | 137.211621 | 2022-11-13 04:21:14 | Aichi, Japan | |||
67061 | 67061 | 2021-09-01 | Japan | Aichi | 85594 | 1046 | 0 | 35.035551 | 137.211621 | 2021-09-02 04:21:15 | Aichi, Japan | |||
71075 | 71075 | 2022-02-07 | Japan | Aichi | 208429 | 1258 | 0 | 35.035551 | 137.211621 | 2022-02-08 04:21:15 | Aichi, Japan | |||
75089 | 75089 | 2020-12-03 | Japan | Aichi | 10736 | 123 | 8457 | 2156 | 35.035551 | 137.211621 | 2020-12-04 05:27:27 | Aichi, Japan | ||
79088 | 79088 | 2020-10-14 | Japan | Aichi | 5662 | 91 | 5228 | 343 | 35.035551 | 137.211621 | 2020-10-15 04:24:28 | Aichi, Japan | ||
83095 | 83095 | 2021-05-25 | Japan | Aichi | 45273 | 730 | 37416 | 7127 | 35.035551 | 137.211621 | 2021-05-26 04:20:35 | Aichi, Japan | ||
87109 | 87109 | 2021-11-09 | Japan | Aichi | 106729 | 1156 | 0 | 35.035551 | 137.211621 | 2021-11-10 04:21:38 | Aichi, Japan | |||
91126 | 91126 | 2022-07-23 | Japan | Aichi | 692653 | 2117 | 0 | 35.035551 | 137.211621 | 2022-07-24 04:20:47 | Aichi, Japan | |||
98075 | 98075 | 2020-08-04 | Japan | Aichi | 2435 | 35 | 620 | 1780 | 35.035551 | 137.211621 | 2020-08-05 04:34:43 | Aichi, Japan | ||
99310 | 99310 | 2022-01-14 | Japan | Aichi | 111923 | 1163 | 0 | 35.035551 | 137.211621 | 2022-01-15 04:21:07 | Aichi, Japan | |||
103326 | 103326 | 2021-08-15 | Japan | Aichi | 60369 | 1018 | 0 | 35.035551 | 137.211621 | 2021-08-16 04:21:31 | Aichi, Japan | |||
107451 | 107451 | 2021-06-19 | Japan | Aichi | 50429 | 929 | 47265 | 2235 | 35.035551 | 137.211621 | 2021-06-20 04:21:48 | Aichi, Japan | ||
114736 | 114736 | 2022-09-06 | Japan | Aichi | 1257634 | 2708 | 0 | 35.035551 | 137.211621 | 2022-09-07 04:20:59 | Aichi, Japan | |||
121668 | 121668 | 2020-07-19 | Japan | Aichi | 643 | 34 | 485 | 124 | 35.035551 | 137.211621 | 2020-07-20 05:34:40 | Aichi, Japan | ||
122704 | 122704 | 2020-11-18 | Japan | Aichi | 8054 | 103 | 6555 | 1396 | 35.035551 | 137.211621 | 2020-11-19 05:25:23 | Aichi, Japan | ||
126717 | 126717 | 2022-01-09 | Japan | Aichi | 108371 | 1161 | 0 | 35.035551 | 137.211621 | 2022-01-10 04:22:07 | Aichi, Japan | |||
130734 | 130734 | 2022-10-04 | Japan | Aichi | 1371697 | 2881 | 0 | 35.035551 | 137.211621 | 2022-10-05 04:23:06 | Aichi, Japan | |||
137955 | 137955 | 2021-12-04 | Japan | Aichi | 106910 | 1161 | 0 | 35.035551 | 137.211621 | 2021-12-05 04:22:25 | Aichi, Japan | |||
141972 | 141972 | 2022-07-09 | Japan | Aichi | 589307 | 2104 | 0 | 35.035551 | 137.211621 | 2022-07-10 04:20:54 | Aichi, Japan | |||
145972 | 145972 | 2020-08-15 | Japan | Aichi | 3718 | 43 | 1804 | 1871 | 35.035551 | 137.211621 | 2020-08-16 04:27:42 | Aichi, Japan | ||
149968 | 149968 | 2021-11-29 | Japan | Aichi | 106878 | 1161 | 0 | 35.035551 | 137.211621 | 2021-11-30 04:22:53 | Aichi, Japan | |||
153983 | 153983 | 2021-01-08 | Japan | Aichi | 18735 | 263 | 15030 | 3442 | 35.035551 | 137.211621 | 2021-01-09 05:22:18 | Aichi, Japan | ||
157997 | 157997 | 2022-03-29 | Japan | Aichi | 408731 | 1958 | 0 | 35.035551 | 137.211621 | 2022-03-30 04:20:45 | Aichi, Japan | |||
162012 | 162012 | 2021-11-19 | Japan | Aichi | 106821 | 1159 | 0 | 35.035551 | 137.211621 | 2021-11-20 04:22:17 | Aichi, Japan | |||
166029 | 166029 | 2022-06-21 | Japan | Aichi | 561774 | 2095 | 0 | 35.035551 | 137.211621 | 2022-06-22 04:20:54 | Aichi, Japan | |||
170044 | 170044 | 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 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]);