johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where confirmed = 102 and country_or_region = "Japan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Japan · 19 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2498035 | 2498035 | 2020-11-03 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-11-04 05:25:09 | Kagawa, Japan | ||
3304210 | 3304210 | 2020-11-02 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-11-03 06:00:16 | Kagawa, Japan | ||
3409459 | 3409459 | 2020-11-01 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-11-02 05:25:04 | Kagawa, Japan | ||
2079948 | 2079948 | 2020-10-31 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-11-01 04:36:19 | Kagawa, Japan | ||
2243401 | 2243401 | 2020-10-30 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-10-31 04:24:44 | Kagawa, Japan | ||
210256 | 210256 | 2020-10-29 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-10-30 04:24:49 | Kagawa, Japan | ||
754318 | 754318 | 2020-10-28 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-10-29 04:24:49 | Kagawa, Japan | ||
1452603 | 1452603 | 2020-10-27 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-10-28 04:24:39 | Kagawa, Japan | ||
3480327 | 3480327 | 2020-10-26 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-10-27 04:24:45 | Kagawa, Japan | ||
8348 | 8348 | 2020-10-25 | Japan | Kagawa | 102 | 2 | 95 | 5 | 34.217292 | 133.969047 | 2020-10-26 04:25:02 | Kagawa, Japan | ||
3651585 | 3651585 | 2020-10-24 | Japan | Kagawa | 102 | 2 | 94 | 6 | 34.217292 | 133.969047 | 2020-10-25 04:24:36 | Kagawa, Japan | ||
1053840 | 1053840 | 2020-10-23 | Japan | Kagawa | 102 | 2 | 94 | 6 | 34.217292 | 133.969047 | 2020-10-24 04:24:46 | Kagawa, Japan | ||
1177510 | 1177510 | 2020-10-22 | Japan | Kagawa | 102 | 2 | 94 | 6 | 34.217292 | 133.969047 | 2020-10-23 04:24:46 | Kagawa, Japan | ||
1555989 | 1555989 | 2020-08-16 | Japan | Kochi | 102 | 3 | 79 | 20 | 33.422519 | 133.367307 | 2020-08-17 04:27:20 | Kochi, Japan | ||
1612254 | 1612254 | 2020-08-14 | Japan | Fukushima | 102 | 0 | 89 | 13 | 37.378867 | 140.223295 | 2020-08-15 04:27:31 | Fukushima, Japan | ||
3923090 | 3923090 | 2020-08-09 | Japan | Ehime | 102 | 5 | 86 | 11 | 33.624835 | 132.856842 | 2020-08-10 04:34:55 | Ehime, Japan | ||
1928455 | 1928455 | 2020-07-30 | Japan | Niigata | 102 | 0 | 88 | 14 | 37.521819 | 138.918647 | 2020-07-31 04:35:18 | Niigata, Japan | ||
2958611 | 2958611 | 2020-07-29 | Japan | Nagano | 102 | 0 | 81 | 21 | 36.132134 | 138.045528 | 2020-07-30 04:35:05 | Nagano, Japan | ||
2708772 | 2708772 | 2020-07-17 | Japan | Shizuoka | 102 | 1 | 83 | 18 | 34.916975 | 138.40778400000002 | 2020-07-18 04:34:45 | Shizuoka, 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]);