johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where country_or_region = "Japan" and deaths = 464 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Japan · 13 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3222450 | 3222450 | 2022-12-25 | Japan | Oita | 236009 | 464 | 0 | 33.200697 | 131.43324 | 2022-12-26 04:21:06 | Oita, Japan | |||
542755 | 542755 | 2022-12-15 | Japan | Aomori | 229445 | 464 | 0 | 40.781541 | 140.828896 | 2022-12-16 04:21:01 | Aomori, Japan | |||
2394825 | 2394825 | 2022-09-12 | Japan | Tochigi | 209992 | 464 | 0 | 36.689912 | 139.819213 | 2022-09-13 04:20:57 | Tochigi, Japan | |||
2987294 | 2987294 | 2022-09-04 | Japan | Mie | 224269 | 464 | 0 | 34.508018 | 136.376013 | 2022-09-05 04:21:01 | Mie, Japan | |||
2712979 | 2712979 | 2022-09-03 | Japan | Mie | 222274 | 464 | 0 | 34.508018 | 136.376013 | 2022-09-04 04:21:22 | Mie, Japan | |||
2594030 | 2594030 | 2022-07-25 | Japan | Ibaraki | 189454 | 464 | 0 | 36.303588 | 140.319591 | 2022-07-26 04:20:58 | Ibaraki, Japan | |||
2840834 | 2840834 | 2022-04-30 | Japan | Hiroshima | 126849 | 464 | 0 | 34.605309 | 132.788719 | 2022-05-01 04:20:57 | Hiroshima, Japan | |||
1157147 | 1157147 | 2022-04-29 | Japan | Hiroshima | 126106 | 464 | 0 | 34.605309 | 132.788719 | 2022-04-30 04:21:05 | Hiroshima, Japan | |||
1696329 | 1696329 | 2022-04-28 | Japan | Hiroshima | 125139 | 464 | 0 | 34.605309 | 132.788719 | 2022-04-29 04:20:59 | Hiroshima, Japan | |||
3851812 | 3851812 | 2022-04-27 | Japan | Hiroshima | 123976 | 464 | 0 | 34.605309 | 132.788719 | 2022-04-28 04:20:47 | Hiroshima, Japan | |||
1326242 | 1326242 | 2022-04-26 | Japan | Hiroshima | 122913 | 464 | 0 | 34.605309000000005 | 132.788719 | 2022-04-27 04:20:52 | Hiroshima, Japan | |||
1090078 | 1090078 | 2021-03-03 | Japan | Chiba | 26836 | 464 | 24630 | 1742 | 35.510141 | 140.198917 | 2021-03-04 05:24:24 | Chiba, Japan | ||
1901199 | 1901199 | 2020-12-18 | Japan | Osaka | 26512 | 464 | 21879 | 4169 | 34.620965000000005 | 135.507481 | 2020-12-19 05:27:52 | Osaka, 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]);