johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where confirmed = 144 and country_or_region = "Japan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, longitude, combined_key, last_update (date)
country_or_region 1
- Japan · 38 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3566583 | 3566583 | 2020-11-29 | Japan | Kagawa | 144 | 2 | 119 | 23 | 34.217292 | 133.969047 | 2020-11-30 05:26:13 | Kagawa, Japan | ||
923719 | 923719 | 2020-11-26 | Japan | Shimane | 144 | 0 | 141 | 3 | 35.07076 | 132.55406399999998 | 2020-11-27 05:26:53 | Shimane, Japan | ||
2701529 | 2701529 | 2020-11-20 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-21 05:25:51 | Kochi, Japan | ||
821589 | 821589 | 2020-11-19 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-20 05:26:28 | Kochi, Japan | ||
122708 | 122708 | 2020-11-18 | Japan | Ehime | 144 | 6 | 111 | 27 | 33.624835 | 132.856842 | 2020-11-19 05:25:23 | Ehime, Japan | ||
122723 | 122723 | 2020-11-18 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-19 05:25:23 | Kochi, Japan | ||
3338611 | 3338611 | 2020-11-17 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-18 05:40:31 | Kochi, Japan | ||
3169656 | 3169656 | 2020-11-16 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-17 05:25:54 | Kochi, Japan | ||
2880224 | 2880224 | 2020-11-15 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-16 05:25:57 | Kochi, Japan | ||
2915202 | 2915202 | 2020-11-14 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-15 05:26:53 | Kochi, Japan | ||
2785024 | 2785024 | 2020-11-13 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-14 05:25:37 | Kochi, Japan | ||
864789 | 864789 | 2020-11-12 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-13 05:25:30 | Kochi, Japan | ||
3440834 | 3440834 | 2020-11-11 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-12 05:25:55 | Kochi, Japan | ||
272174 | 272174 | 2020-11-10 | Japan | Kochi | 144 | 4 | 140 | 0 | 33.422519 | 133.367307 | 2020-11-11 05:25:30 | Kochi, Japan | ||
1988651 | 1988651 | 2020-11-09 | Japan | Kochi | 144 | 4 | 139 | 1 | 33.422519 | 133.367307 | 2020-11-10 05:40:07 | Kochi, Japan | ||
1728503 | 1728503 | 2020-11-08 | Japan | Kochi | 144 | 4 | 139 | 1 | 33.422519 | 133.367307 | 2020-11-09 05:25:45 | Kochi, Japan | ||
1543963 | 1543963 | 2020-11-07 | Japan | Kochi | 144 | 4 | 139 | 1 | 33.422519 | 133.367307 | 2020-11-08 05:24:56 | Kochi, Japan | ||
376201 | 376201 | 2020-11-06 | Japan | Kochi | 144 | 4 | 139 | 1 | 33.422519 | 133.367307 | 2020-11-07 05:24:52 | Kochi, Japan | ||
892139 | 892139 | 2020-11-05 | Japan | Kochi | 144 | 4 | 139 | 1 | 33.422519 | 133.367307 | 2020-11-06 05:24:55 | Kochi, Japan | ||
2919201 | 2919201 | 2020-11-04 | Japan | Kochi | 144 | 4 | 139 | 1 | 33.422519 | 133.367307 | 2020-11-05 06:05:03 | Kochi, Japan | ||
2498038 | 2498038 | 2020-11-03 | Japan | Kochi | 144 | 4 | 138 | 2 | 33.422519 | 133.367307 | 2020-11-04 05:25:09 | Kochi, Japan | ||
3304213 | 3304213 | 2020-11-02 | Japan | Kochi | 144 | 4 | 138 | 2 | 33.422519 | 133.367307 | 2020-11-03 06:00:16 | Kochi, Japan | ||
3409462 | 3409462 | 2020-11-01 | Japan | Kochi | 144 | 4 | 138 | 2 | 33.422519 | 133.367307 | 2020-11-02 05:25:04 | Kochi, Japan | ||
2079951 | 2079951 | 2020-10-31 | Japan | Kochi | 144 | 4 | 137 | 3 | 33.422519 | 133.367307 | 2020-11-01 04:36:19 | Kochi, Japan | ||
2243404 | 2243404 | 2020-10-30 | Japan | Kochi | 144 | 4 | 137 | 3 | 33.422519 | 133.367307 | 2020-10-31 04:24:44 | Kochi, Japan | ||
210259 | 210259 | 2020-10-29 | Japan | Kochi | 144 | 4 | 137 | 3 | 33.422519 | 133.367307 | 2020-10-30 04:24:49 | Kochi, Japan | ||
754321 | 754321 | 2020-10-28 | Japan | Kochi | 144 | 4 | 136 | 4 | 33.422519 | 133.367307 | 2020-10-29 04:24:49 | Kochi, Japan | ||
427364 | 427364 | 2020-09-07 | Japan | Niigata | 144 | 0 | 137 | 7 | 37.521819 | 138.918647 | 2020-09-08 04:28:25 | Niigata, Japan | ||
3161649 | 3161649 | 2020-09-06 | Japan | Niigata | 144 | 0 | 137 | 7 | 37.521819 | 138.918647 | 2020-09-07 04:28:30 | Niigata, Japan | ||
813604 | 813604 | 2020-09-05 | Japan | Niigata | 144 | 0 | 137 | 7 | 37.521819 | 138.918647 | 2020-09-06 04:28:33 | Niigata, Japan | ||
2661804 | 2661804 | 2020-09-04 | Japan | Niigata | 144 | 0 | 137 | 7 | 37.521819 | 138.918647 | 2020-09-05 04:28:19 | Niigata, Japan | ||
1354344 | 1354344 | 2020-09-03 | Japan | Niigata | 144 | 0 | 136 | 8 | 37.521819 | 138.918647 | 2020-09-04 04:28:26 | Niigata, Japan | ||
1105581 | 1105581 | 2020-09-02 | Japan | Niigata | 144 | 0 | 136 | 8 | 37.521819 | 138.918647 | 2020-09-03 04:28:22 | Niigata, Japan | ||
609717 | 609717 | 2020-08-29 | Japan | Oita | 144 | 1 | 120 | 23 | 33.200697 | 131.43323999999998 | 2020-08-30 04:28:22 | Oita, Japan | ||
1523212 | 1523212 | 2020-08-28 | Japan | Oita | 144 | 1 | 109 | 34 | 33.200697 | 131.43323999999998 | 2020-08-29 04:28:19 | Oita, Japan | ||
2510213 | 2510213 | 2020-08-27 | Japan | Oita | 144 | 1 | 102 | 41 | 33.200697 | 131.43323999999998 | 2020-08-28 04:28:11 | Oita, Japan | ||
2740235 | 2740235 | 2020-08-03 | Japan | Mie | 144 | 1 | 55 | 88 | 34.508018 | 136.376013 | 2020-08-04 04:41:59 | Mie, Japan | ||
2222808 | 2222808 | 2020-07-08 | Japan | Okinawa | 144 | 7 | 138 | 0 | 25.768923 | 126.668016 | 2020-07-09 04:34:23 | Okinawa, 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]);