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 last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state 49
- 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
- Okinawa 946
- Osaka 946
- Port Quarantine 946
- Saga 946
- Saitama 946
- Shiga 946
- Shimane 946
- Shizuoka 946
- Tochigi 946
- Tokushima 946
- Tokyo 946
- Tottori 946
- Toyama 946
- Unknown 946
- Wakayama 946
- Yamagata 946
- Yamaguchi 946
- Yamanashi 946
- Iwate 895
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1802375 | 1802375 | 2020-01-22 | Japan | 2 | 0 | 0 | 1/22/2020 17:00 | |||||||
864412 | 864412 | 2020-01-23 | Japan | 1 | 0 | 0 | 1/23/20 17:00 | |||||||
197794 | 197794 | 2020-01-24 | Japan | 2 | 0 | 0 | 1/24/20 17:00 | |||||||
2938967 | 2938967 | 2020-01-25 | Japan | 2 | 0 | 0 | 1/25/20 17:00 | |||||||
415868 | 415868 | 2020-01-26 | Japan | 4 | 0 | 1 | 1/26/20 16:00 | |||||||
3753093 | 3753093 | 2020-01-27 | Japan | 4 | 0 | 1 | 1/27/20 23:59 | |||||||
1305790 | 1305790 | 2020-01-28 | Japan | 7 | 0 | 1 | 1/28/20 23:00 | |||||||
197875 | 197875 | 2020-01-29 | Japan | 7 | 0 | 1 | 1/29/20 19:30 | |||||||
1527528 | 1527528 | 2020-01-30 | Japan | 11 | 0 | 1 | 1/30/20 16:00 | |||||||
3761210 | 3761210 | 2020-01-31 | Japan | 15 | 0 | 1 | 1/31/2020 23:59 | |||||||
3413167 | 3413167 | 2020-02-01 | Japan | 20 | 0 | 1 | 2/1/2020 18:53 | |||||||
2379257 | 2379257 | 2020-02-02 | Japan | 20 | 0 | 1 | 2020-02-01T18:53:03 | |||||||
2860571 | 2860571 | 2020-02-03 | Japan | 20 | 0 | 1 | 2020-02-01T18:53:03 | |||||||
2091692 | 2091692 | 2020-02-05 | Japan | 22 | 0 | 1 | 2020-02-04T16:43:03 | |||||||
3471909 | 3471909 | 2020-02-04 | Japan | 22 | 0 | 1 | 2020-02-04T16:43:03 | |||||||
566695 | 566695 | 2020-02-06 | Japan | 45 | 0 | 1 | 2020-02-06T02:53:03 | |||||||
1366073 | 1366073 | 2020-02-08 | Japan | 25 | 0 | 1 | 2020-02-07T04:13:20 | |||||||
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 | |||||||
3089035 | 3089035 | 2020-02-10 | Japan | 26 | 0 | 4 | 2020-02-10T21:33:02 | |||||||
3197736 | 3197736 | 2020-02-11 | Japan | 26 | 0 | 9 | 2020-02-11T02:53:02 | |||||||
2567276 | 2567276 | 2020-02-12 | Japan | 28 | 0 | 9 | 2020-02-12T02:43:03 | |||||||
1559686 | 1559686 | 2020-02-13 | Japan | 28 | 1 | 9 | 2020-02-13T12:23:05 | |||||||
1192479 | 1192479 | 2020-02-14 | Japan | 29 | 1 | 9 | 2020-02-14T03:53:02 | |||||||
107059 | 107059 | 2020-02-15 | Japan | 43 | 1 | 12 | 2020-02-15T17:43:06 | |||||||
1888732 | 1888732 | 2020-02-16 | Japan | 59 | 1 | 12 | 2020-02-16T17:43:03 | |||||||
1243379 | 1243379 | 2020-02-17 | Japan | 66 | 1 | 12 | 2020-02-17T14:33:04 | |||||||
1783103 | 1783103 | 2020-02-18 | Japan | 74 | 1 | 13 | 2020-02-18T17:23:04 | |||||||
1720069 | 1720069 | 2020-02-19 | Japan | 84 | 1 | 18 | 2020-02-19T20:33:02 | |||||||
2263476 | 2263476 | 2020-02-20 | Japan | 94 | 1 | 18 | 2020-02-20T15:53:03 | |||||||
2135734 | 2135734 | 2020-02-21 | Japan | 105 | 1 | 22 | 2020-02-21T19:03:06 | |||||||
1085651 | 1085651 | 2020-02-22 | Japan | 122 | 1 | 22 | 2020-02-22T14:53:02 | |||||||
3173360 | 3173360 | 2020-02-23 | Japan | 147 | 1 | 22 | 2020-02-23T23:33:07 | |||||||
3551216 | 3551216 | 2020-02-24 | Japan | 159 | 1 | 22 | 2020-02-24T14:23:03 | |||||||
479151 | 479151 | 2020-02-25 | Japan | 170 | 1 | 22 | 2020-02-25T14:53:03 | |||||||
2509767 | 2509767 | 2020-02-26 | Japan | 189 | 2 | 22 | 2020-02-26T23:43:03 | |||||||
617412 | 617412 | 2020-02-27 | Japan | 214 | 4 | 22 | 2020-02-27T23:33:02 | |||||||
2883927 | 2883927 | 2020-02-28 | Japan | 228 | 4 | 22 | 2020-02-28T12:43:02 | |||||||
3205804 | 3205804 | 2020-02-29 | Japan | 241 | 5 | 32 | 2020-02-29T15:53:04 | |||||||
562513 | 562513 | 2020-03-01 | Japan | 256 | 6 | 32 | 36.0 | 138.0 | 2020-03-01T23:33:03 | |||||
1152652 | 1152652 | 2020-03-02 | Japan | 274 | 6 | 32 | 36.0 | 138.0 | 2020-03-02T20:33:02 | |||||
261036 | 261036 | 2020-03-03 | Japan | 293 | 6 | 43 | 36.0 | 138.0 | 2020-03-03T20:03:06 | |||||
98819 | 98819 | 2020-03-04 | Japan | 331 | 6 | 43 | 36.0 | 138.0 | 2020-03-04T19:23:03 | |||||
40150 | 40150 | 2020-03-05 | Japan | 360 | 6 | 43 | 36.0 | 138.0 | 2020-03-05T13:43:04 | |||||
3177494 | 3177494 | 2020-03-06 | Japan | 420 | 6 | 46 | 36.0 | 138.0 | 2020-03-06T20:13:13 | |||||
62490 | 62490 | 2020-03-07 | Japan | 461 | 6 | 76 | 36.0 | 138.0 | 2020-03-07T17:43:05 | |||||
1527217 | 1527217 | 2020-03-08 | Japan | 502 | 6 | 76 | 36.0 | 138.0 | 2020-03-08T14:53:11 | |||||
657701 | 657701 | 2020-03-09 | Japan | 511 | 17 | 76 | 36.0 | 138.0 | 2020-03-09T09:13:17 | |||||
3752830 | 3752830 | 2020-03-10 | Japan | 581 | 10 | 101 | 36.0 | 138.0 | 2020-03-10T16:13:16 | |||||
3765386 | 3765386 | 2020-03-13 | Japan | 701 | 19 | 118 | 36.2048 | 138.2529 | 2020-03-11T20:00:00 | |||||
2127446 | 2127446 | 2020-03-11 | Japan | 639 | 15 | 118 | 36.0 | 138.0 | 2020-03-11T21:33:03 | |||||
2282877 | 2282877 | 2020-03-12 | Japan | 639 | 16 | 118 | 36.0 | 138.0 | 2020-03-12T05:13:02 | |||||
1463482 | 1463482 | 2020-03-15 | Japan | 839 | 22 | 118 | 36.2048 | 138.2529 | 2020-03-14T22:33:03 | |||||
2111105 | 2111105 | 2020-03-14 | Japan | 773 | 22 | 118 | 36.2048 | 138.2529 | 2020-03-14T22:33:03 | |||||
2255135 | 2255135 | 2020-03-16 | Japan | 825 | 27 | 144 | 36.2048 | 138.2529 | 2020-03-16T14:38:45 | |||||
3891329 | 3891329 | 2020-03-17 | Japan | 878 | 29 | 144 | 36.2048 | 138.2529 | 2020-03-17T16:53:04 | |||||
1176898 | 1176898 | 2020-03-18 | Japan | 889 | 29 | 144 | 36.2048 | 138.2529 | 2020-03-18T12:33:02 | |||||
1526895 | 1526895 | 2020-03-19 | Japan | 924 | 29 | 150 | 36.2048 | 138.2529 | 2020-03-19T10:13:15 | |||||
3733944 | 3733944 | 2020-03-20 | Japan | 963 | 33 | 191 | 36.2048 | 138.2529 | 2020-03-20T14:13:08 | |||||
339648 | 339648 | 2020-03-21 | Japan | 1007 | 35 | 232 | 36.2048 | 138.2529 | 2020-03-21T20:43:02 | |||||
2147190 | 2147190 | 2020-03-23 | Japan | 1128 | 42 | 235 | 851 | 36.204824 | 138.252924 | 2020-03-23 23:19:21 | Japan | |||
1479134 | 1479134 | 2020-03-24 | Japan | 1193 | 43 | 285 | 865 | 36.204824 | 138.252924 | 2020-03-24 23:37:15 | Japan | |||
1132628 | 1132628 | 2020-03-25 | Japan | 1307 | 45 | 310 | 952 | 36.204824 | 138.252924 | 2020-03-25 23:33:04 | Japan | |||
919227 | 919227 | 2020-03-26 | Japan | 1387 | 47 | 359 | 981 | 36.204824 | 138.252924 | 2020-03-26 23:48:18 | Japan | |||
809135 | 809135 | 2020-03-27 | Japan | 1468 | 49 | 372 | 1047 | 36.204824 | 138.252924 | 2020-03-27 23:23:03 | Japan | |||
3815963 | 3815963 | 2020-03-31 | Japan | 1953 | 56 | 424 | 1473 | 36.204824 | 138.252924 | 2020-03-31 23:43:43 | Japan | |||
3364870 | 3364870 | 2020-04-01 | Japan | 2178 | 57 | 472 | 1649 | 36.204824 | 138.252924 | 2020-04-01 21:58:34 | Japan | |||
3740636 | 3740636 | 2020-04-03 | Japan | 2617 | 63 | 514 | 2040 | 36.204824 | 138.252924 | 2020-04-03 22:46:20 | Japan | |||
589182 | 589182 | 2020-04-05 | Japan | 3139 | 77 | 514 | 2548 | 36.204824 | 138.252924 | 2020-04-05 23:06:26 | Japan | |||
3021812 | 3021812 | 2020-04-07 | Japan | 3906 | 92 | 592 | 3222 | 36.204824 | 138.252924 | 2020-04-07 23:04:29 | Japan | |||
3562137 | 3562137 | 2020-04-08 | Japan | 4257 | 93 | 622 | 3542 | 36.204824 | 138.252924 | 2020-04-08 22:51:39 | Japan | |||
3950030 | 3950030 | 2020-04-09 | Japan | 4667 | 94 | 632 | 3941 | 36.204824 | 138.252924 | 2020-04-09 23:02:19 | Japan | |||
1250293 | 1250293 | 2020-04-10 | Japan | 5530 | 99 | 685 | 4746 | 36.204824 | 138.252924 | 2020-04-10 22:53:48 | Japan | |||
2567108 | 2567108 | 2020-04-11 | Japan | 6005 | 99 | 762 | 5144 | 36.204824 | 138.252924 | 2020-04-11 22:45:13 | Japan | |||
2578271 | 2578271 | 2020-04-12 | Japan | 6748 | 108 | 762 | 5878 | 36.204824 | 138.252924 | 2020-04-12 23:17:00 | Japan | |||
43245 | 43245 | 2020-04-13 | Japan | 7370 | 123 | 784 | 6463 | 36.204824 | 138.252924 | 2020-04-13 23:07:34 | Japan | |||
3338148 | 3338148 | 2020-04-14 | Japan | 7645 | 143 | 799 | 6703 | 36.204824 | 138.252924 | 2020-04-14 23:33:12 | Japan | |||
860232 | 860232 | 2020-04-15 | Japan | 8100 | 146 | 853 | 7101 | 36.204824 | 138.252924 | 2020-04-15 22:56:32 | Japan | |||
934338 | 934338 | 2020-04-16 | Japan | 8626 | 178 | 901 | 7547 | 36.204824 | 138.252924 | 2020-04-16 23:30:31 | Japan | |||
50344 | 50344 | 2020-04-17 | Japan | 9787 | 190 | 935 | 8662 | 36.204824 | 138.252924 | 2020-04-17 23:30:32 | Japan | |||
418872 | 418872 | 2020-04-18 | Japan | 10296 | 222 | 1069 | 9005 | 36.204824 | 138.252924 | 2020-04-18 22:32:28 | Japan | |||
1385184 | 1385184 | 2020-04-19 | Japan | 10797 | 236 | 1159 | 9402 | 36.204824 | 138.252924 | 2020-04-19 23:40:41 | Japan | |||
2473492 | 2473492 | 2020-04-20 | Japan | 10797 | 236 | 1159 | 9402 | 36.204824 | 138.252924 | 2020-04-20 23:36:27 | Japan | |||
522410 | 522410 | 2020-04-21 | Japan | 11135 | 263 | 1239 | 9633 | 36.204824 | 138.252924 | 2020-04-21 23:30:30 | Japan | |||
1199344 | 1199344 | 2020-04-22 | Japan | 11512 | 281 | 1356 | 9875 | 36.204824 | 138.252924 | 2020-04-22 23:30:32 | Japan | |||
2524894 | 2524894 | 2020-04-23 | Japan | 12368 | 328 | 1494 | 10546 | 36.204824 | 138.252924 | 2020-04-24 03:30:31 | Japan | |||
1459305 | 1459305 | 2020-04-24 | Japan | 12829 | 345 | 1530 | 10954 | 36.204824 | 138.252924 | 2020-04-25 06:30:33 | Japan | |||
3502904 | 3502904 | 2020-04-25 | Japan | 13231 | 360 | 1656 | 11215 | 36.204824 | 138.252924 | 2020-04-26 02:30:31 | Japan | |||
3592555 | 3592555 | 2020-04-26 | Japan | 13441 | 372 | 1809 | 11260 | 36.204824 | 138.252924 | 2020-04-27 02:30:33 | Japan | |||
3589377 | 3589377 | 2020-04-27 | Japan | 14153 | 385 | 1899 | 11869 | 36.204824 | 138.252924 | 2020-04-28 02:30:32 | Japan | |||
271722 | 271722 | 2020-04-28 | Japan | 13736 | 394 | 1899 | 11443 | 36.204824 | 138.252924 | 2020-04-29 02:32:29 | Japan | |||
137508 | 137508 | 2020-04-29 | Japan | 13895 | 413 | 2368 | 11114 | 36.204824 | 138.252924 | 2020-04-30 02:32:27 | Japan | |||
228762 | 228762 | 2020-04-30 | Japan | 14088 | 430 | 2460 | 11198 | 36.204824 | 138.252924 | 2020-05-01 02:32:28 | Japan | |||
1184281 | 1184281 | 2020-05-01 | Japan | 14305 | 455 | 2975 | 10875 | 36.204824 | 138.252924 | 2020-05-02 02:32:27 | Japan | |||
2043387 | 2043387 | 2020-05-02 | Japan | 14571 | 474 | 3205 | 10892 | 36.204824 | 138.252924 | 2020-05-03 02:32:28 | Japan | |||
2278711 | 2278711 | 2020-05-03 | Japan | 14877 | 487 | 3981 | 10409 | 36.204824 | 138.252924 | 2020-05-04 02:32:28 | Japan | |||
3084852 | 3084852 | 2020-05-04 | Japan | 15078 | 536 | 4156 | 10386 | 36.204824 | 138.252924 | 2020-05-05 02:32:34 | Japan | |||
1931989 | 1931989 | 2020-05-05 | Japan | 15253 | 556 | 4496 | 10201 | 36.204824 | 138.252924 | 2020-05-06 02:32:31 | Japan | |||
2110949 | 2110949 | 2020-05-06 | Japan | 15253 | 556 | 4496 | 10201 | 36.204824 | 138.252924 | 2020-05-07 02:32:28 | Japan | |||
3295728 | 3295728 | 2020-05-07 | Japan | 15477 | 577 | 4918 | 9982 | 36.204824 | 138.252924 | 2020-05-08 02:32:32 | 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]);