johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where country_or_region = "Japan" and deaths = 280 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 12
country_or_region 1
- Japan · 21 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348315 | 348315 | 2022-12-14 | Japan | Saga | 191807 | 280 | 0 | 33.286977 | 130.115738 | 2022-12-15 04:20:58 | Saga, Japan | |||
2768962 | 2768962 | 2022-09-26 | Japan | Ishikawa | 159956 | 280 | 0 | 36.769464 | 136.771027 | 2022-09-27 04:23:01 | Ishikawa, Japan | |||
1976615 | 1976615 | 2022-09-25 | Japan | Ishikawa | 159270 | 280 | 0 | 36.769464 | 136.771027 | 2022-09-26 04:20:52 | Ishikawa, Japan | |||
2649782 | 2649782 | 2022-09-24 | Japan | Ishikawa | 159026 | 280 | 0 | 36.769464 | 136.771027 | 2022-09-25 04:23:31 | Ishikawa, Japan | |||
384222 | 384222 | 2022-09-23 | Japan | Ishikawa | 158432 | 280 | 0 | 36.769464 | 136.771027 | 2022-09-24 04:21:40 | Ishikawa, Japan | |||
1624288 | 1624288 | 2022-09-22 | Japan | Ishikawa | 157828 | 280 | 0 | 36.769464 | 136.771027 | 2022-09-23 04:23:13 | Ishikawa, Japan | |||
2355468 | 2355468 | 2022-09-16 | Japan | Kagawa | 136397 | 280 | 0 | 34.217292 | 133.969047 | 2022-09-17 04:20:19 | Kagawa, Japan | |||
253302 | 253302 | 2022-09-08 | Japan | Ehime | 148750 | 280 | 0 | 33.624835 | 132.856842 | 2022-09-09 04:21:11 | Ehime, Japan | |||
1250765 | 1250765 | 2022-08-23 | Japan | Miyagi | 204541 | 280 | 0 | 38.446859 | 140.927086 | 2022-08-24 04:20:46 | Miyagi, Japan | |||
1069908 | 1069908 | 2022-08-07 | Japan | Okayama | 156226 | 280 | 0 | 34.89246 | 133.826252 | 2022-08-08 04:21:08 | Okayama, Japan | |||
629932 | 629932 | 2022-07-12 | Japan | Tochigi | 97095 | 280 | 0 | 36.689912 | 139.819213 | 2022-07-13 04:20:58 | Tochigi, Japan | |||
1845982 | 1845982 | 2022-04-18 | Japan | Mie | 65982 | 280 | 0 | 34.508018 | 136.376013 | 2022-04-19 04:21:00 | Mie, Japan | |||
3416926 | 3416926 | 2022-04-17 | Japan | Mie | 65647 | 280 | 0 | 34.508018 | 136.376013 | 2022-04-18 04:21:12 | Mie, Japan | |||
303875 | 303875 | 2022-04-16 | Japan | Mie | 65124 | 280 | 0 | 34.508018 | 136.376013 | 2022-04-17 04:20:59 | Mie, Japan | |||
2669820 | 2669820 | 2022-04-15 | Japan | Mie | 64579 | 280 | 0 | 34.508018 | 136.376013 | 2022-04-16 04:20:48 | Mie, Japan | |||
158006 | 158006 | 2022-03-29 | Japan | Gunma | 68485 | 280 | 0 | 36.504478999999996 | 138.985605 | 2022-03-30 04:20:45 | Gunma, Japan | |||
1436577 | 1436577 | 2022-03-28 | Japan | Gunma | 67866 | 280 | 0 | 36.504478999999996 | 138.985605 | 2022-03-29 04:20:46 | Gunma, Japan | |||
876258 | 876258 | 2022-03-27 | Japan | Gunma | 67565 | 280 | 0 | 36.504478999999996 | 138.985605 | 2022-03-28 04:20:33 | Gunma, Japan | |||
986984 | 986984 | 2021-10-04 | Japan | Kyoto | 35570 | 280 | 0 | 35.253815 | 135.443341 | 2021-10-05 04:21:27 | Kyoto, Japan | |||
790386 | 790386 | 2021-02-04 | Japan | Chiba | 23209 | 280 | 17491 | 5438 | 35.510141 | 140.198917 | 2021-02-05 05:22:38 | Chiba, Japan | ||
1136902 | 1136902 | 2021-01-01 | Japan | Kanagawa | 21730 | 280 | 17855 | 3595 | 35.415312 | 139.338983 | 2021-01-02 05:22:33 | Kanagawa, 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]);