johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where active = 234 and country_or_region = "Japan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, latitude, day (date), last_update (date)
province_or_state 11
country_or_region 1
- Japan · 16 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468203 | 3468203 | 2021-08-03 | Japan | Nagasaki | 3550 | 69 | 3247 | 234 | 33.235712 | 129.608033 | 2021-08-04 04:21:25 | Nagasaki, Japan | ||
1306178 | 1306178 | 2021-07-27 | Japan | Miyagi | 9711 | 91 | 9386 | 234 | 38.446859 | 140.927086 | 2021-07-28 04:21:39 | Miyagi, Japan | ||
2371550 | 2371550 | 2021-07-20 | Japan | Tochigi | 7440 | 84 | 7122 | 234 | 36.689912 | 139.819213 | 2021-07-21 04:21:40 | Tochigi, Japan | ||
2673852 | 2673852 | 2021-07-18 | Japan | Tochigi | 7397 | 83 | 7080 | 234 | 36.689912 | 139.819213 | 2021-07-19 04:21:24 | Tochigi, Japan | ||
2586011 | 2586011 | 2021-06-05 | Japan | Miyagi | 8964 | 83 | 8647 | 234 | 38.446859 | 140.927086 | 2021-06-06 04:24:03 | Miyagi, Japan | ||
2760943 | 2760943 | 2021-05-03 | Japan | Miyazaki | 2299 | 22 | 2043 | 234 | 32.193203999999994 | 131.299374 | 2021-05-04 04:20:34 | Miyazaki, Japan | ||
3924059 | 3924059 | 2021-04-24 | Japan | Yamaguchi | 1696 | 43 | 1419 | 234 | 34.201190000000004 | 131.573293 | 2021-04-25 04:20:32 | Yamaguchi, Japan | ||
3883627 | 3883627 | 2021-04-11 | Japan | Shizuoka | 5967 | 121 | 5612 | 234 | 34.916975 | 138.40778400000002 | 2021-04-12 04:21:00 | Shizuoka, Japan | ||
1290027 | 1290027 | 2021-03-29 | Japan | Kyoto | 9430 | 169 | 9027 | 234 | 35.253815 | 135.443341 | 2021-03-30 04:26:23 | Kyoto, Japan | ||
1684508 | 1684508 | 2021-02-02 | Japan | Fukushima | 1737 | 46 | 1457 | 234 | 37.378867 | 140.223295 | 2021-02-03 05:22:52 | Fukushima, Japan | ||
435360 | 435360 | 2021-01-21 | Japan | Ehime | 891 | 17 | 640 | 234 | 33.624835 | 132.856842 | 2021-01-22 05:22:10 | Ehime, Japan | ||
3847827 | 3847827 | 2020-12-13 | Japan | Tochigi | 870 | 3 | 633 | 234 | 36.689912 | 139.819213 | 2020-12-14 05:26:27 | Tochigi, Japan | ||
272178 | 272178 | 2020-11-10 | Japan | Miyagi | 892 | 6 | 652 | 234 | 38.446859 | 140.927086 | 2020-11-11 05:25:30 | Miyagi, Japan | ||
2991305 | 2991305 | 2020-08-24 | Japan | Port Quarantine | 749 | 1 | 514 | 234 | 2020-08-25 04:28:02 | Port Quarantine, Japan | ||||
367520 | 367520 | 2020-07-16 | Japan | Port Quarantine | 436 | 1 | 201 | 234 | 2020-07-17 04:34:50 | Port Quarantine, Japan | ||||
2748172 | 2748172 | 2020-07-15 | Japan | Osaka | 2126 | 86 | 1806 | 234 | 34.620965000000005 | 135.507481 | 2020-07-16 04:44:59 | 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]);