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 province_or_state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40150 | 40150 | 2020-03-05 | Japan | 360 | 6 | 43 | 36.0 | 138.0 | 2020-03-05T13:43:04 | |||||
43245 | 43245 | 2020-04-13 | Japan | 7370 | 123 | 784 | 6463 | 36.204824 | 138.252924 | 2020-04-13 23:07:34 | Japan | |||
50344 | 50344 | 2020-04-17 | Japan | 9787 | 190 | 935 | 8662 | 36.204824 | 138.252924 | 2020-04-17 23:30:32 | Japan | |||
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 | |||||||
114285 | 114285 | 2020-05-08 | Japan | 15575 | 590 | 5146 | 9839 | 36.204824 | 138.252924 | 2020-05-09 02:32:35 | Japan | |||
137508 | 137508 | 2020-04-29 | Japan | 13895 | 413 | 2368 | 11114 | 36.204824 | 138.252924 | 2020-04-30 02:32:27 | Japan | |||
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 | |||||||
228762 | 228762 | 2020-04-30 | Japan | 14088 | 430 | 2460 | 11198 | 36.204824 | 138.252924 | 2020-05-01 02:32:28 | Japan | |||
261036 | 261036 | 2020-03-03 | Japan | 293 | 6 | 43 | 36.0 | 138.0 | 2020-03-03T20:03:06 | |||||
268519 | 268519 | 2020-05-21 | Japan | 16424 | 777 | 12672 | 2975 | 36.204824 | 138.252924 | 2020-05-22 02:36:51 | Japan | |||
271722 | 271722 | 2020-04-28 | Japan | 13736 | 394 | 1899 | 11443 | 36.204824 | 138.252924 | 2020-04-29 02:32:29 | Japan | |||
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 | |||||||
418872 | 418872 | 2020-04-18 | Japan | 10296 | 222 | 1069 | 9005 | 36.204824 | 138.252924 | 2020-04-18 22:32:28 | Japan | |||
479151 | 479151 | 2020-02-25 | Japan | 170 | 1 | 22 | 2020-02-25T14:53:03 | |||||||
522410 | 522410 | 2020-04-21 | Japan | 11135 | 263 | 1239 | 9633 | 36.204824 | 138.252924 | 2020-04-21 23:30:30 | Japan | |||
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 | |||||||
589182 | 589182 | 2020-04-05 | Japan | 3139 | 77 | 514 | 2548 | 36.204824 | 138.252924 | 2020-04-05 23:06:26 | Japan | |||
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 | |||||
809135 | 809135 | 2020-03-27 | Japan | 1468 | 49 | 372 | 1047 | 36.204824 | 138.252924 | 2020-03-27 23:23:03 | Japan | |||
860232 | 860232 | 2020-04-15 | Japan | 8100 | 146 | 853 | 7101 | 36.204824 | 138.252924 | 2020-04-15 22:56:32 | Japan | |||
864412 | 864412 | 2020-01-23 | Japan | 1 | 0 | 0 | 1/23/20 17:00 | |||||||
875799 | 875799 | 2020-05-24 | Japan | 16550 | 820 | 13413 | 2317 | 36.204824 | 138.252924 | 2020-05-25 02:32:44 | Japan | |||
919227 | 919227 | 2020-03-26 | Japan | 1387 | 47 | 359 | 981 | 36.204824 | 138.252924 | 2020-03-26 23:48:18 | Japan | |||
934338 | 934338 | 2020-04-16 | Japan | 8626 | 178 | 901 | 7547 | 36.204824 | 138.252924 | 2020-04-16 23:30:31 | Japan | |||
997990 | 997990 | 2020-05-23 | Japan | 16536 | 808 | 13244 | 2484 | 36.204824 | 138.252924 | 2020-05-24 02:32:43 | Japan | |||
1041389 | 1041389 | 2020-05-26 | Japan | 16623 | 846 | 13810 | 1967 | 36.204824 | 138.252924 | 2020-05-27 02:32:31 | Japan | |||
1085651 | 1085651 | 2020-02-22 | Japan | 122 | 1 | 22 | 2020-02-22T14:53:02 | |||||||
1105119 | 1105119 | 2020-05-25 | Japan | 16581 | 830 | 13612 | 2139 | 36.204824 | 138.252924 | 2020-05-26 02:32:35 | Japan | |||
1132628 | 1132628 | 2020-03-25 | Japan | 1307 | 45 | 310 | 952 | 36.204824 | 138.252924 | 2020-03-25 23:33:04 | Japan | |||
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 | |||||
1184281 | 1184281 | 2020-05-01 | Japan | 14305 | 455 | 2975 | 10875 | 36.204824 | 138.252924 | 2020-05-02 02:32:27 | Japan | |||
1192479 | 1192479 | 2020-02-14 | Japan | 29 | 1 | 9 | 2020-02-14T03:53:02 | |||||||
1199344 | 1199344 | 2020-04-22 | Japan | 11512 | 281 | 1356 | 9875 | 36.204824 | 138.252924 | 2020-04-22 23:30:32 | Japan | |||
1243379 | 1243379 | 2020-02-17 | Japan | 66 | 1 | 12 | 2020-02-17T14:33:04 | |||||||
1250293 | 1250293 | 2020-04-10 | Japan | 5530 | 99 | 685 | 4746 | 36.204824 | 138.252924 | 2020-04-10 22:53:48 | Japan | |||
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 | |||||||
1385184 | 1385184 | 2020-04-19 | Japan | 10797 | 236 | 1159 | 9402 | 36.204824 | 138.252924 | 2020-04-19 23:40:41 | Japan | |||
1404577 | 1404577 | 2020-05-14 | Japan | 16120 | 697 | 9868 | 5555 | 36.204824 | 138.252924 | 2020-05-15 02:33:02 | Japan | |||
1432102 | 1432102 | 2020-05-20 | Japan | 16367 | 768 | 11564 | 4035 | 36.204824 | 138.252924 | 2020-05-21 02:32:48 | Japan | |||
1459305 | 1459305 | 2020-04-24 | Japan | 12829 | 345 | 1530 | 10954 | 36.204824 | 138.252924 | 2020-04-25 06:30:33 | Japan | |||
1463482 | 1463482 | 2020-03-15 | Japan | 839 | 22 | 118 | 36.2048 | 138.2529 | 2020-03-14T22:33:03 | |||||
1479134 | 1479134 | 2020-03-24 | Japan | 1193 | 43 | 285 | 865 | 36.204824 | 138.252924 | 2020-03-24 23:37:15 | Japan | |||
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 | |||||||
1750825 | 1750825 | 2020-04-04 | Japan | 3139 | 77 | 514 | 2548 | 36.204824 | 138.252924 | 4/4/20 23:34 | Japan | |||
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 | |||||||
1829687 | 1829687 | 2020-05-16 | Japan | 16237 | 725 | 10338 | 5174 | 36.204824 | 138.252924 | 2020-05-17 02:32:32 | Japan | |||
1865013 | 1865013 | 2020-05-22 | Japan | 16513 | 796 | 13005 | 2712 | 36.204824 | 138.252924 | 2020-05-23 02:32:42 | Japan | |||
1872514 | 1872514 | 2020-03-30 | Japan | 1866 | 54 | 424 | 1388 | 36.204824 | 138.252924 | 3/30/20 22:52 | Japan | |||
1888732 | 1888732 | 2020-02-16 | Japan | 59 | 1 | 12 | 2020-02-16T17:43:03 | |||||||
1931989 | 1931989 | 2020-05-05 | Japan | 15253 | 556 | 4496 | 10201 | 36.204824 | 138.252924 | 2020-05-06 02:32:31 | Japan | |||
2043387 | 2043387 | 2020-05-02 | Japan | 14571 | 474 | 3205 | 10892 | 36.204824 | 138.252924 | 2020-05-03 02:32:28 | Japan | |||
2091692 | 2091692 | 2020-02-05 | Japan | 22 | 0 | 1 | 2020-02-04T16:43:03 | |||||||
2110949 | 2110949 | 2020-05-06 | Japan | 15253 | 556 | 4496 | 10201 | 36.204824 | 138.252924 | 2020-05-07 02:32:28 | Japan | |||
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 | |||||||
2147190 | 2147190 | 2020-03-23 | Japan | 1128 | 42 | 235 | 851 | 36.204824 | 138.252924 | 2020-03-23 23:19:21 | Japan | |||
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 | |||||||
2278711 | 2278711 | 2020-05-03 | Japan | 14877 | 487 | 3981 | 10409 | 36.204824 | 138.252924 | 2020-05-04 02:32:28 | Japan | |||
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 | |||||||
2390321 | 2390321 | 2020-05-19 | Japan | 16367 | 768 | 11564 | 4035 | 36.204824 | 138.252924 | 2020-05-20 02:32:19 | Japan | |||
2473492 | 2473492 | 2020-04-20 | Japan | 10797 | 236 | 1159 | 9402 | 36.204824 | 138.252924 | 2020-04-20 23:36:27 | Japan | |||
2509767 | 2509767 | 2020-02-26 | Japan | 189 | 2 | 22 | 2020-02-26T23:43:03 | |||||||
2524894 | 2524894 | 2020-04-23 | Japan | 12368 | 328 | 1494 | 10546 | 36.204824 | 138.252924 | 2020-04-24 03:30:31 | Japan | |||
2548426 | 2548426 | 2020-05-27 | Japan | 16651 | 858 | 13973 | 1820 | 36.204824 | 138.252924 | 2020-05-28 02:32:31 | Japan | |||
2567108 | 2567108 | 2020-04-11 | Japan | 6005 | 99 | 762 | 5144 | 36.204824 | 138.252924 | 2020-04-11 22:45:13 | Japan | |||
2567276 | 2567276 | 2020-02-12 | Japan | 28 | 0 | 9 | 2020-02-12T02:43:03 | |||||||
2578271 | 2578271 | 2020-04-12 | Japan | 6748 | 108 | 762 | 5878 | 36.204824 | 138.252924 | 2020-04-12 23:17:00 | Japan | |||
2581546 | 2581546 | 2020-05-12 | Japan | 15968 | 657 | 8531 | 6780 | 36.204824 | 138.252924 | 2020-05-13 03:32:26 | Japan | |||
2860571 | 2860571 | 2020-02-03 | Japan | 20 | 0 | 1 | 2020-02-01T18:53:03 | |||||||
2875750 | 2875750 | 2020-03-29 | Japan | 1866 | 54 | 424 | 1388 | 36.204824 | 138.252924 | 3/29/20 23:08 | Japan | |||
2883927 | 2883927 | 2020-02-28 | Japan | 228 | 4 | 22 | 2020-02-28T12:43:02 | |||||||
2899236 | 2899236 | 2020-05-09 | Japan | 15663 | 607 | 5906 | 9150 | 36.204824 | 138.252924 | 2020-05-10 02:32:30 | Japan | |||
2910655 | 2910655 | 2020-03-22 | Japan | 1086 | 36 | 235 | 815 | 36.204824 | 138.252924 | 3/22/20 23:45 | Japan | |||
2938967 | 2938967 | 2020-01-25 | Japan | 2 | 0 | 0 | 1/25/20 17:00 | |||||||
3021812 | 3021812 | 2020-04-07 | Japan | 3906 | 92 | 592 | 3222 | 36.204824 | 138.252924 | 2020-04-07 23:04:29 | Japan | |||
3084852 | 3084852 | 2020-05-04 | Japan | 15078 | 536 | 4156 | 10386 | 36.204824 | 138.252924 | 2020-05-05 02:32:34 | Japan | |||
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 | |||||||
3261059 | 3261059 | 2020-05-18 | Japan | 16305 | 749 | 11564 | 3992 | 36.204824 | 138.252924 | 2020-05-19 02:32:18 | Japan | |||
3276403 | 3276403 | 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 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]);