johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where deaths = 21 and province_or_state = "Yamanashi" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
507732 | 507732 | 2021-08-14 | Japan | Yamanashi | 3213 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-15 04:21:41 | Yamanashi, Japan | |||
1483604 | 1483604 | 2021-08-13 | Japan | Yamanashi | 3130 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-14 04:21:25 | Yamanashi, Japan | |||
2899734 | 2899734 | 2021-08-12 | Japan | Yamanashi | 3057 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-13 04:21:24 | Yamanashi, Japan | |||
1342338 | 1342338 | 2021-08-11 | Japan | Yamanashi | 2991 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-12 04:21:25 | Yamanashi, Japan | |||
2351485 | 2351485 | 2021-08-10 | Japan | Yamanashi | 2937 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-11 04:21:58 | Yamanashi, Japan | |||
650014 | 650014 | 2021-08-09 | Japan | Yamanashi | 2899 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-10 04:21:27 | Yamanashi, Japan | |||
589676 | 589676 | 2021-08-08 | Japan | Yamanashi | 2862 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-09 04:21:24 | Yamanashi, Japan | |||
2203688 | 2203688 | 2021-08-07 | Japan | Yamanashi | 2818 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-08 04:21:33 | Yamanashi, Japan | |||
1117638 | 1117638 | 2021-08-06 | Japan | Yamanashi | 2739 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-07 04:21:30 | Yamanashi, Japan | |||
1956575 | 1956575 | 2021-08-05 | Japan | Yamanashi | 2666 | 21 | 0 | 35.612364 | 138.61148899999998 | 2021-08-06 04:21:18 | Yamanashi, Japan | |||
331954 | 331954 | 2021-08-04 | Japan | Yamanashi | 2599 | 21 | 2232 | 346 | 35.612364 | 138.61148899999998 | 2021-08-05 04:21:51 | Yamanashi, Japan | ||
3468225 | 3468225 | 2021-08-03 | Japan | Yamanashi | 2550 | 21 | 2218 | 311 | 35.612364 | 138.61148899999998 | 2021-08-04 04:21:25 | Yamanashi, Japan | ||
3683499 | 3683499 | 2021-08-02 | Japan | Yamanashi | 2503 | 21 | 2185 | 297 | 35.612364 | 138.61148899999998 | 2021-08-03 04:21:39 | Yamanashi, Japan | ||
3015398 | 3015398 | 2021-08-01 | Japan | Yamanashi | 2457 | 21 | 2185 | 251 | 35.612364 | 138.61148899999998 | 2021-08-02 04:21:36 | Yamanashi, Japan | ||
3904021 | 3904021 | 2021-07-31 | Japan | Yamanashi | 2414 | 21 | 2185 | 208 | 35.612364 | 138.61148899999998 | 2021-08-01 04:21:50 | Yamanashi, Japan | ||
3296226 | 3296226 | 2021-07-30 | Japan | Yamanashi | 2384 | 21 | 2181 | 182 | 35.612364 | 138.61148899999998 | 2021-07-31 04:21:35 | Yamanashi, Japan | ||
3385437 | 3385437 | 2021-07-29 | Japan | Yamanashi | 2353 | 21 | 2170 | 162 | 35.612364 | 138.61148899999998 | 2021-07-30 04:21:34 | Yamanashi, Japan | ||
408342 | 408342 | 2021-07-28 | Japan | Yamanashi | 2325 | 21 | 2168 | 136 | 35.612364 | 138.61148899999998 | 2021-07-29 04:21:33 | Yamanashi, Japan | ||
1306203 | 1306203 | 2021-07-27 | Japan | Yamanashi | 2302 | 21 | 2161 | 120 | 35.612364 | 138.61148899999998 | 2021-07-28 04:21:39 | Yamanashi, Japan | ||
3218346 | 3218346 | 2021-07-26 | Japan | Yamanashi | 2279 | 21 | 2150 | 108 | 35.612364 | 138.61148899999998 | 2021-07-27 04:21:18 | Yamanashi, Japan | ||
1378555 | 1378555 | 2021-07-25 | Japan | Yamanashi | 2268 | 21 | 2150 | 97 | 35.612364 | 138.61148899999998 | 2021-07-26 04:21:28 | Yamanashi, Japan | ||
1330295 | 1330295 | 2021-07-24 | Japan | Yamanashi | 2244 | 21 | 2150 | 73 | 35.612364 | 138.61148899999998 | 2021-07-25 04:22:12 | Yamanashi, Japan | ||
3137599 | 3137599 | 2021-07-23 | Japan | Yamanashi | 2232 | 21 | 2139 | 72 | 35.612364 | 138.61148899999998 | 2021-07-24 00:21:36 | Yamanashi, Japan | ||
3476359 | 3476359 | 2021-07-22 | Japan | Yamanashi | 2218 | 21 | 2139 | 58 | 35.612364 | 138.61148899999998 | 2021-07-23 04:21:29 | Yamanashi, Japan | ||
3331578 | 3331578 | 2021-07-21 | Japan | Yamanashi | 2204 | 21 | 2131 | 52 | 35.612364 | 138.61148899999998 | 2021-07-22 04:21:19 | Yamanashi, Japan | ||
2371559 | 2371559 | 2021-07-20 | Japan | Yamanashi | 2197 | 21 | 2123 | 53 | 35.612364 | 138.61148899999998 | 2021-07-21 04:21:40 | Yamanashi, Japan | ||
483638 | 483638 | 2021-07-19 | Japan | Yamanashi | 2190 | 21 | 2108 | 61 | 35.612364 | 138.61148899999998 | 2021-07-20 04:21:48 | Yamanashi, Japan | ||
2673861 | 2673861 | 2021-07-18 | Japan | Yamanashi | 2187 | 21 | 2108 | 58 | 35.612364 | 138.61148899999998 | 2021-07-19 04:21:24 | Yamanashi, Japan | ||
3706173 | 3706173 | 2021-07-17 | Japan | Yamanashi | 2184 | 21 | 2108 | 55 | 35.612364 | 138.61148899999998 | 2021-07-18 04:22:07 | Yamanashi, Japan | ||
2947404 | 2947404 | 2021-07-16 | Japan | Yamanashi | 2181 | 21 | 2103 | 57 | 35.612364 | 138.61148899999998 | 2021-07-17 04:22:22 | Yamanashi, Japan | ||
296060 | 296060 | 2021-07-15 | Japan | Yamanashi | 2176 | 21 | 2097 | 58 | 35.612364 | 138.61148899999998 | 2021-07-16 04:21:22 | Yamanashi, Japan | ||
3632005 | 3632005 | 2021-07-14 | Japan | Yamanashi | 2175 | 21 | 2094 | 60 | 35.612364 | 138.61148899999998 | 2021-07-15 04:21:48 | Yamanashi, Japan | ||
578880 | 578880 | 2021-07-13 | Japan | Yamanashi | 2173 | 21 | 2090 | 62 | 35.612364 | 138.61148899999998 | 2021-07-14 04:21:35 | Yamanashi, Japan | ||
3741129 | 3741129 | 2021-07-12 | Japan | Yamanashi | 2171 | 21 | 2072 | 78 | 35.612364 | 138.61148899999998 | 2021-07-13 04:21:18 | Yamanashi, Japan | ||
3659642 | 3659642 | 2021-07-11 | Japan | Yamanashi | 2160 | 21 | 2072 | 67 | 35.612364 | 138.61148899999998 | 2021-07-12 04:21:34 | Yamanashi, Japan | ||
625926 | 625926 | 2021-07-10 | Japan | Yamanashi | 2156 | 21 | 2072 | 63 | 35.612364 | 138.61148899999998 | 2021-07-11 04:21:43 | Yamanashi, Japan | ||
829645 | 829645 | 2021-07-09 | Japan | Yamanashi | 2153 | 21 | 2063 | 69 | 35.612364 | 138.61148899999998 | 2021-07-10 04:21:25 | Yamanashi, Japan | ||
778409 | 778409 | 2021-07-08 | Japan | Yamanashi | 2144 | 21 | 2060 | 63 | 35.612364 | 138.61148899999998 | 2021-07-09 04:21:21 | Yamanashi, Japan | ||
1440631 | 1440631 | 2021-07-07 | Japan | Yamanashi | 2139 | 21 | 2053 | 65 | 35.612364 | 138.61148899999998 | 2021-07-08 04:21:26 | Yamanashi, Japan | ||
2693736 | 2693736 | 2021-07-06 | Japan | Yamanashi | 2135 | 21 | 2044 | 70 | 35.612364 | 138.61148899999998 | 2021-07-07 04:21:20 | Yamanashi, Japan | ||
1932485 | 1932485 | 2021-07-05 | Japan | Yamanashi | 2125 | 21 | 2004 | 100 | 35.612364 | 138.61148899999998 | 2021-07-06 04:21:32 | Yamanashi, Japan | ||
1165216 | 1165216 | 2021-07-04 | Japan | Yamanashi | 2124 | 21 | 2004 | 99 | 35.612364 | 138.61148899999998 | 2021-07-05 04:21:28 | Yamanashi, Japan | ||
1495650 | 1495650 | 2021-07-03 | Japan | Yamanashi | 2124 | 21 | 2004 | 99 | 35.612364 | 138.61148899999998 | 2021-07-04 04:21:38 | Yamanashi, Japan | ||
2071965 | 2071965 | 2021-07-02 | Japan | Yamanashi | 2113 | 21 | 1984 | 108 | 35.612364 | 138.61148899999998 | 2021-07-03 04:21:37 | Yamanashi, Japan | ||
2764981 | 2764981 | 2021-07-01 | Japan | Yamanashi | 2106 | 21 | 1957 | 128 | 35.612364 | 138.61148899999998 | 2021-07-02 04:21:47 | Yamanashi, Japan | ||
1893189 | 1893189 | 2021-06-30 | Japan | Yamanashi | 2101 | 21 | 1933 | 147 | 35.612364 | 138.61148899999998 | 2021-07-01 04:21:19 | Yamanashi, Japan | ||
400312 | 400312 | 2021-06-29 | Japan | Yamanashi | 2097 | 21 | 1908 | 168 | 35.612364 | 138.61148899999998 | 2021-06-30 04:21:41 | Yamanashi, Japan | ||
3125555 | 3125555 | 2021-06-28 | Japan | Yamanashi | 2093 | 21 | 1816 | 256 | 35.612364 | 138.61148899999998 | 2021-06-29 04:21:28 | Yamanashi, Japan | ||
2590050 | 2590050 | 2021-06-27 | Japan | Yamanashi | 2087 | 21 | 1816 | 250 | 35.612364 | 138.61148899999998 | 2021-06-28 04:21:29 | Yamanashi, Japan | ||
3958554 | 3958554 | 2021-06-26 | Japan | Yamanashi | 2085 | 21 | 1816 | 248 | 35.612364 | 138.61148899999998 | 2021-06-27 04:21:39 | Yamanashi, Japan | ||
1712373 | 1712373 | 2021-06-25 | Japan | Yamanashi | 2073 | 21 | 1788 | 264 | 35.612364 | 138.61148899999998 | 2021-06-26 04:21:43 | Yamanashi, Japan | ||
2295498 | 2295498 | 2021-06-24 | Japan | Yamanashi | 2059 | 21 | 1780 | 258 | 35.612364 | 138.61148899999998 | 2021-06-25 04:21:33 | Yamanashi, Japan | ||
2422938 | 2422938 | 2021-06-23 | Japan | Yamanashi | 2036 | 21 | 1764 | 251 | 35.612364 | 138.61148899999998 | 2021-06-24 04:21:55 | Yamanashi, 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]);