johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 180 and country_or_region = "Japan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, longitude
province_or_state 9
country_or_region 1
- Japan · 17 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
75108 | 75108 | 2020-12-03 | Japan | Kochi | 180 | 4 | 143 | 33 | 33.422519 | 133.367307 | 2020-12-04 05:27:27 | Kochi, Japan | ||
923722 | 923722 | 2020-11-26 | Japan | Tokushima | 180 | 9 | 161 | 10 | 33.919178 | 134.242091 | 2020-11-27 05:26:53 | Tokushima, Japan | ||
3651597 | 3651597 | 2020-10-24 | Japan | Niigata | 180 | 0 | 179 | 1 | 37.521819 | 138.918647 | 2020-10-25 04:24:36 | Niigata, Japan | ||
2606074 | 2606074 | 2020-09-24 | Japan | Yamanashi | 180 | 6 | 171 | 3 | 35.612364 | 138.611489 | 2020-09-25 04:23:00 | Yamanashi, Japan | ||
2653817 | 2653817 | 2020-09-23 | Japan | Yamanashi | 180 | 6 | 168 | 6 | 35.612364 | 138.611489 | 2020-09-24 04:23:00 | Yamanashi, Japan | ||
3316266 | 3316266 | 2020-09-22 | Japan | Yamanashi | 180 | 6 | 168 | 6 | 35.612364 | 138.611489 | 2020-09-23 04:23:00 | Yamanashi, Japan | ||
2836865 | 2836865 | 2020-09-21 | Japan | Yamanashi | 180 | 6 | 168 | 6 | 35.612364 | 138.611489 | 2020-09-22 04:23:00 | Yamanashi, Japan | ||
3093469 | 3093469 | 2020-09-20 | Japan | Yamanashi | 180 | 6 | 168 | 6 | 35.612364 | 138.611489 | 2020-09-21 04:23:00 | Yamanashi, Japan | ||
2454819 | 2454819 | 2020-09-19 | Japan | Yamanashi | 180 | 6 | 168 | 6 | 35.612364 | 138.611489 | 2020-09-20 04:22:00 | Yamanashi, Japan | ||
2848888 | 2848888 | 2020-09-18 | Japan | Yamanashi | 180 | 6 | 167 | 7 | 35.612364 | 138.611489 | 2020-09-19 04:22:00 | Yamanashi, Japan | ||
1121637 | 1121637 | 2020-09-17 | Japan | Yamanashi | 180 | 5 | 165 | 10 | 35.612364 | 138.611489 | 2020-09-18 05:05:00 | Yamanashi, Japan | ||
666326 | 666326 | 2020-09-16 | Japan | Yamanashi | 180 | 5 | 165 | 10 | 35.612364 | 138.611489 | 2020-09-17 04:22:00 | Yamanashi, Japan | ||
1612281 | 1612281 | 2020-08-14 | Japan | Saga | 180 | 0 | 106 | 74 | 33.286977 | 130.115738 | 2020-08-15 04:27:31 | Saga, Japan | ||
3612288 | 3612288 | 2020-08-06 | Japan | Miyagi | 180 | 1 | 149 | 30 | 38.446859 | 140.927086 | 2020-08-07 04:35:11 | Miyagi, Japan | ||
62022 | 62022 | 2020-07-23 | Japan | Nara | 180 | 2 | 122 | 56 | 34.317451 | 135.871644 | 2020-07-24 05:30:40 | Nara, Japan | ||
326902 | 326902 | 2020-07-20 | Japan | Gifu | 180 | 7 | 151 | 22 | 35.778671 | 137.055925 | 2020-07-21 04:38:46 | Gifu, Japan | ||
2712329 | 2712329 | 2020-05-28 | Japan | Port Quarantine | 180 | 0 | 153 | 27 | 2020-05-29 02:32:50 | Port Quarantine, 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]);