johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where country_or_region = "Japan" and deaths = 240 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 14
country_or_region 1
- Japan · 29 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
327934 | 327934 | 2022-12-27 | Japan | Toyama | 200114 | 240 | 0 | 36.637464 | 137.269346 | 2022-12-28 04:21:04 | Toyama, Japan | |||
3460161 | 3460161 | 2022-11-21 | Japan | Iwate | 140642 | 240 | 0 | 39.593287 | 141.361777 | 2022-11-22 04:20:47 | Iwate, Japan | |||
1049857 | 1049857 | 2022-11-06 | Japan | Saga | 165161 | 240 | 0 | 33.286977 | 130.115738 | 2022-11-07 04:21:26 | Saga, Japan | |||
617881 | 617881 | 2022-11-05 | Japan | Saga | 164789 | 240 | 0 | 33.286977 | 130.115738 | 2022-11-06 04:21:24 | Saga, Japan | |||
2024739 | 2024739 | 2022-10-17 | Japan | Akita | 106563 | 240 | 0 | 39.748679 | 140.408228 | 2022-10-18 04:22:42 | Akita, Japan | |||
3547505 | 3547505 | 2022-09-01 | Japan | Ishikawa | 139515 | 240 | 0 | 36.769464 | 136.771027 | 2022-09-02 04:21:07 | Ishikawa, Japan | |||
1531917 | 1531917 | 2022-08-26 | Japan | Ehime | 129812 | 240 | 0 | 33.624835 | 132.856842 | 2022-08-27 04:20:57 | Ehime, Japan | |||
2402843 | 2402843 | 2022-08-21 | Japan | Nagano | 152001 | 240 | 0 | 36.132134 | 138.045528 | 2022-08-22 04:20:38 | Nagano, Japan | |||
3797921 | 3797921 | 2022-08-20 | Japan | Nagano | 149411 | 240 | 0 | 36.132134 | 138.045528 | 2022-08-21 04:20:44 | Nagano, Japan | |||
2363489 | 2363489 | 2022-08-19 | Japan | Fukushima | 124771 | 240 | 0 | 37.378867 | 140.223295 | 2022-08-20 04:21:01 | Fukushima, Japan | |||
2363507 | 2363507 | 2022-08-19 | Japan | Nagano | 146077 | 240 | 0 | 36.132134 | 138.045528 | 2022-08-20 04:21:01 | Nagano, Japan | |||
1161160 | 1161160 | 2022-08-18 | Japan | Fukushima | 121188 | 240 | 0 | 37.378867 | 140.223295 | 2022-08-19 04:20:54 | Fukushima, Japan | |||
1161178 | 1161178 | 2022-08-18 | Japan | Nagano | 142428 | 240 | 0 | 36.132134 | 138.045528 | 2022-08-19 04:20:54 | Nagano, Japan | |||
3950484 | 3950484 | 2022-08-17 | Japan | Fukushima | 117893 | 240 | 0 | 37.378867 | 140.223295 | 2022-08-18 04:21:11 | Fukushima, Japan | |||
990986 | 990986 | 2022-08-16 | Japan | Fukushima | 115916 | 240 | 0 | 37.378867 | 140.223295 | 2022-08-17 04:20:59 | Fukushima, Japan | |||
2494025 | 2494025 | 2022-08-15 | Japan | Fukushima | 114346 | 240 | 0 | 37.378867 | 140.223295 | 2022-08-16 04:20:58 | Fukushima, Japan | |||
3647575 | 3647575 | 2022-08-14 | Japan | Fukushima | 113090 | 240 | 0 | 37.378867 | 140.223295 | 2022-08-15 04:20:59 | Fukushima, Japan | |||
2888406 | 2888406 | 2022-08-12 | Japan | Miyagi | 168368 | 240 | 0 | 38.446859 | 140.927086 | 2022-08-13 04:20:52 | Miyagi, Japan | |||
2598063 | 2598063 | 2022-05-05 | Japan | Okayama | 82261 | 240 | 0 | 34.89246 | 133.826252 | 2022-05-06 04:21:00 | Okayama, Japan | |||
3265512 | 3265512 | 2022-05-04 | Japan | Okayama | 81996 | 240 | 0 | 34.89246 | 133.826252 | 2022-05-05 04:20:55 | Okayama, Japan | |||
1572151 | 1572151 | 2022-05-03 | Japan | Okayama | 81393 | 240 | 0 | 34.89246 | 133.826252 | 2022-05-04 04:20:59 | Okayama, Japan | |||
463411 | 463411 | 2022-05-02 | Japan | Okayama | 80970 | 240 | 0 | 34.89246 | 133.826252 | 2022-05-03 04:21:00 | Okayama, Japan | |||
3916050 | 3916050 | 2022-05-01 | Japan | Okayama | 80608 | 240 | 0 | 34.89246 | 133.826252 | 2022-05-02 04:21:10 | Okayama, Japan | |||
2840854 | 2840854 | 2022-04-30 | Japan | Okayama | 80275 | 240 | 0 | 34.89246 | 133.826252 | 2022-05-01 04:20:57 | Okayama, Japan | |||
1157167 | 1157167 | 2022-04-29 | Japan | Okayama | 79951 | 240 | 0 | 34.89246 | 133.826252 | 2022-04-30 04:21:05 | Okayama, Japan | |||
1436607 | 1436607 | 2022-03-28 | Japan | Tochigi | 60388 | 240 | 0 | 36.689912 | 139.819213 | 2022-03-29 04:20:46 | Tochigi, Japan | |||
942840 | 942840 | 2022-02-28 | Japan | Mie | 40967 | 240 | 0 | 34.508018 | 136.376013 | 2022-03-01 04:21:09 | Mie, Japan | |||
649997 | 649997 | 2021-08-09 | Japan | Okinawa | 29047 | 240 | 0 | 25.768923 | 126.668016 | 2021-08-10 04:21:27 | Okinawa, Japan | |||
2295471 | 2295471 | 2021-06-24 | Japan | Kyoto | 16503 | 240 | 16038 | 225 | 35.253815 | 135.443341 | 2021-06-25 04:21:33 | Kyoto, 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]);