johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where country_or_region = "Japan" and deaths = 222 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 16
country_or_region 1
- Japan · 36 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3173821 | 3173821 | 2022-12-19 | Japan | Yamanashi | 142736 | 222 | 0 | 35.612364 | 138.611489 | 2022-12-20 04:21:04 | Yamanashi, Japan | |||
1628338 | 1628338 | 2022-12-18 | Japan | Yamanashi | 142139 | 222 | 0 | 35.612364 | 138.611489 | 2022-12-19 04:21:03 | Yamanashi, Japan | |||
1560111 | 1560111 | 2022-09-28 | Japan | Saga | 156757 | 222 | 0 | 33.286977 | 130.115738 | 2022-09-29 04:22:34 | Saga, Japan | |||
3994621 | 3994621 | 2022-09-27 | Japan | Akita | 99413 | 222 | 0 | 39.748679 | 140.408228 | 2022-09-28 04:23:01 | Akita, Japan | |||
2633753 | 2633753 | 2022-09-05 | Japan | Wakayama | 120405 | 222 | 0 | 33.911879 | 135.505446 | 2022-09-06 04:21:02 | Wakayama, Japan | |||
2343413 | 2343413 | 2022-08-31 | Japan | Aomori | 141500 | 222 | 0 | 40.781541 | 140.828896 | 2022-09-01 04:21:03 | Aomori, Japan | |||
1531927 | 1531927 | 2022-08-26 | Japan | Ishikawa | 129463 | 222 | 0 | 36.769464 | 136.771027 | 2022-08-27 04:20:57 | Ishikawa, Japan | |||
2828814 | 2828814 | 2022-08-25 | Japan | Ishikawa | 127431 | 222 | 0 | 36.769464 | 136.771027 | 2022-08-26 04:21:02 | Ishikawa, Japan | |||
2323349 | 2323349 | 2022-08-24 | Japan | Kagawa | 110912 | 222 | 0 | 34.217292 | 133.969047 | 2022-08-25 04:21:13 | Kagawa, Japan | |||
3950501 | 3950501 | 2022-08-17 | Japan | Miyazaki | 133405 | 222 | 0 | 32.193204 | 131.299374 | 2022-08-18 04:21:11 | Miyazaki, Japan | |||
880288 | 880288 | 2022-08-05 | Japan | Miyagi | 148295 | 222 | 0 | 38.446859 | 140.927086 | 2022-08-06 04:20:56 | Miyagi, Japan | |||
3428986 | 3428986 | 2022-07-14 | Japan | Shiga | 101736 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-15 04:20:53 | Shiga, Japan | |||
3109506 | 3109506 | 2022-07-13 | Japan | Shiga | 100680 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-14 04:20:57 | Shiga, Japan | |||
629929 | 629929 | 2022-07-12 | Japan | Shiga | 99949 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-13 04:20:58 | Shiga, Japan | |||
1211573 | 1211573 | 2022-07-11 | Japan | Shiga | 99209 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-12 04:20:51 | Shiga, Japan | |||
2789055 | 2789055 | 2022-07-10 | Japan | Shiga | 98401 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-11 04:20:46 | Shiga, Japan | |||
142008 | 142008 | 2022-07-09 | Japan | Shiga | 98000 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-10 04:20:54 | Shiga, Japan | |||
1417108 | 1417108 | 2022-07-08 | Japan | Shiga | 97648 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-09 04:20:59 | Shiga, Japan | |||
2741033 | 2741033 | 2022-07-07 | Japan | Shiga | 97315 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-08 04:20:56 | Shiga, Japan | |||
3527457 | 3527457 | 2022-06-04 | Japan | Fukushima | 63986 | 222 | 0 | 37.378867 | 140.223295 | 2022-06-05 04:20:55 | Fukushima, Japan | |||
3133543 | 3133543 | 2022-06-03 | Japan | Fukushima | 63874 | 222 | 0 | 37.378867 | 140.223295 | 2022-06-04 04:20:58 | Fukushima, Japan | |||
3578618 | 3578618 | 2022-06-02 | Japan | Fukushima | 63741 | 222 | 0 | 37.378867 | 140.223295 | 2022-06-03 04:20:58 | Fukushima, Japan | |||
970911 | 970911 | 2022-06-01 | Japan | Fukushima | 63627 | 222 | 0 | 37.378867 | 140.223295 | 2022-06-02 05:20:39 | Fukushima, Japan | |||
229218 | 229218 | 2022-05-31 | Japan | Fukushima | 63456 | 222 | 0 | 37.378867 | 140.223295 | 2022-06-01 04:20:55 | Fukushima, Japan | |||
3185983 | 3185983 | 2022-05-30 | Japan | Fukushima | 63299 | 222 | 0 | 37.378867 | 140.223295 | 2022-05-31 04:20:51 | Fukushima, Japan | |||
3198132 | 3198132 | 2022-05-29 | Japan | Fukushima | 63206 | 222 | 0 | 37.378867 | 140.223295 | 2022-05-30 04:20:50 | Fukushima, Japan | |||
2725010 | 2725010 | 2022-05-28 | Japan | Fukushima | 62999 | 222 | 0 | 37.378867 | 140.223295 | 2022-05-29 04:20:53 | Fukushima, Japan | |||
356350 | 356350 | 2022-03-11 | Japan | Tochigi | 51767 | 222 | 0 | 36.689912 | 139.819213 | 2022-03-12 04:20:50 | Tochigi, Japan | |||
2641747 | 2641747 | 2022-02-14 | Japan | Gunma | 41957 | 222 | 0 | 36.504478999999996 | 138.985605 | 2022-02-15 04:21:09 | Gunma, Japan | |||
3061991 | 3061991 | 2022-01-29 | Japan | Gifu | 27786 | 222 | 0 | 35.778671 | 137.055925 | 2022-01-30 04:21:26 | Gifu, Japan | |||
3809925 | 3809925 | 2022-01-28 | Japan | Gifu | 26971 | 222 | 0 | 35.778671 | 137.055925 | 2022-01-29 04:21:10 | Gifu, Japan | |||
1779379 | 1779379 | 2022-01-27 | Japan | Gifu | 26085 | 222 | 0 | 35.778671 | 137.055925 | 2022-01-28 04:21:09 | Gifu, Japan | |||
1318207 | 1318207 | 2022-01-26 | Japan | Gifu | 25395 | 222 | 0 | 35.778671 | 137.055925 | 2022-01-27 04:21:19 | Gifu, Japan | |||
1318212 | 1318212 | 2022-01-26 | Japan | Ibaraki | 31428 | 222 | 0 | 36.303588 | 140.319591 | 2022-01-27 04:21:19 | Ibaraki, Japan | |||
860695 | 860695 | 2020-12-11 | Japan | Kanagawa | 14595 | 222 | 12662 | 1711 | 35.415312 | 139.338983 | 2020-12-12 05:26:19 | Kanagawa, Japan | ||
418872 | 418872 | 2020-04-18 | Japan | 10296 | 222 | 1069 | 9005 | 36.204824 | 138.252924 | 2020-04-18 22:32:28 | 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]);