johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Kagawa" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462808 | 2462808 | 2021-09-14 | Japan | Kagawa | 4582 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-15 03:22:37 | Kagawa, Japan | |||
1385647 | 1385647 | 2021-09-13 | Japan | Kagawa | 4575 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-14 04:21:41 | Kagawa, Japan | |||
1885016 | 1885016 | 2021-09-12 | Japan | Kagawa | 4570 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-13 04:21:15 | Kagawa, Japan | |||
3805919 | 3805919 | 2021-09-11 | Japan | Kagawa | 4562 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-12 04:21:13 | Kagawa, Japan | |||
3448859 | 3448859 | 2021-09-10 | Japan | Kagawa | 4553 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-11 04:21:30 | Kagawa, Japan | |||
1262805 | 1262805 | 2021-09-09 | Japan | Kagawa | 4537 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-10 04:21:20 | Kagawa, Japan | |||
2279175 | 2279175 | 2021-09-08 | Japan | Kagawa | 4520 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-09 04:21:27 | Kagawa, Japan | |||
641954 | 641954 | 2021-09-07 | Japan | Kagawa | 4499 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-08 04:21:31 | Kagawa, Japan | |||
3194017 | 3194017 | 2021-09-06 | Japan | Kagawa | 4473 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-07 04:21:35 | Kagawa, Japan | |||
3280885 | 3280885 | 2021-09-05 | Japan | Kagawa | 4457 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-06 04:21:22 | Kagawa, Japan | |||
249299 | 249299 | 2021-09-04 | Japan | Kagawa | 4427 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-05 04:21:33 | Kagawa, Japan | |||
3974580 | 3974580 | 2021-09-03 | Japan | Kagawa | 4397 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-04 04:21:28 | Kagawa, Japan | |||
178042 | 178042 | 2021-09-02 | Japan | Kagawa | 4356 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-03 04:21:20 | Kagawa, Japan | |||
67077 | 67077 | 2021-09-01 | Japan | Kagawa | 4298 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-02 04:21:15 | Kagawa, Japan | |||
2067919 | 2067919 | 2021-08-31 | Japan | Kagawa | 4233 | 34 | 0 | 34.217292 | 133.969047 | 2021-09-01 04:21:38 | Kagawa, Japan | |||
1775373 | 1775373 | 2021-08-30 | Japan | Kagawa | 4171 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-31 04:21:46 | Kagawa, Japan | |||
3891947 | 3891947 | 2021-08-29 | Japan | Kagawa | 4131 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-30 04:21:23 | Kagawa, Japan | |||
2793050 | 2793050 | 2021-08-28 | Japan | Kagawa | 4076 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-29 04:21:14 | Kagawa, Japan | |||
2923209 | 2923209 | 2021-08-27 | Japan | Kagawa | 4008 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-28 04:21:28 | Kagawa, Japan | |||
1596223 | 1596223 | 2021-08-26 | Japan | Kagawa | 3924 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-27 04:21:37 | Kagawa, Japan | |||
32432 | 32432 | 2021-08-25 | Japan | Kagawa | 3828 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-26 04:21:28 | Kagawa, Japan | |||
3105471 | 3105471 | 2021-08-24 | Japan | Kagawa | 3738 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-25 04:21:41 | Kagawa, Japan | |||
3165642 | 3165642 | 2021-08-23 | Japan | Kagawa | 3643 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-24 04:21:19 | Kagawa, Japan | |||
2175569 | 2175569 | 2021-08-22 | Japan | Kagawa | 3582 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-23 04:21:27 | Kagawa, Japan | |||
3555665 | 3555665 | 2021-08-21 | Japan | Kagawa | 3495 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-22 04:21:29 | Kagawa, Japan | |||
1854007 | 1854007 | 2021-08-20 | Japan | Kagawa | 3405 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-21 04:21:38 | Kagawa, Japan | |||
511714 | 511714 | 2021-08-19 | Japan | Kagawa | 3300 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-20 04:21:33 | Kagawa, Japan | |||
2518193 | 2518193 | 2021-08-18 | Japan | Kagawa | 3189 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-19 04:21:15 | Kagawa, Japan | |||
245285 | 245285 | 2021-08-17 | Japan | Kagawa | 3124 | 34 | 0 | 34.217292 | 133.969047 | 2021-08-18 04:21:35 | Kagawa, Japan | |||
1604248 | 1604248 | 2021-08-16 | Japan | Kagawa | 3041 | 33 | 0 | 34.217292 | 133.969047 | 2021-08-17 04:21:49 | Kagawa, Japan | |||
103342 | 103342 | 2021-08-15 | Japan | Kagawa | 2984 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-16 04:21:31 | Kagawa, Japan | |||
507700 | 507700 | 2021-08-14 | Japan | Kagawa | 2935 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-15 04:21:41 | Kagawa, Japan | |||
1483572 | 1483572 | 2021-08-13 | Japan | Kagawa | 2828 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-14 04:21:25 | Kagawa, Japan | |||
2899702 | 2899702 | 2021-08-12 | Japan | Kagawa | 2762 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-13 04:21:24 | Kagawa, Japan | |||
1342306 | 1342306 | 2021-08-11 | Japan | Kagawa | 2702 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-12 04:21:25 | Kagawa, Japan | |||
2351453 | 2351453 | 2021-08-10 | Japan | Kagawa | 2637 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-11 04:21:58 | Kagawa, Japan | |||
649982 | 649982 | 2021-08-09 | Japan | Kagawa | 2599 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-10 04:21:27 | Kagawa, Japan | |||
589644 | 589644 | 2021-08-08 | Japan | Kagawa | 2573 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-09 04:21:24 | Kagawa, Japan | |||
2203656 | 2203656 | 2021-08-07 | Japan | Kagawa | 2523 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-08 04:21:33 | Kagawa, Japan | |||
1117606 | 1117606 | 2021-08-06 | Japan | Kagawa | 2464 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-07 04:21:30 | Kagawa, Japan | |||
1956543 | 1956543 | 2021-08-05 | Japan | Kagawa | 2423 | 32 | 0 | 34.217292 | 133.969047 | 2021-08-06 04:21:18 | Kagawa, Japan | |||
331922 | 331922 | 2021-08-04 | Japan | Kagawa | 2390 | 32 | 2126 | 232 | 34.217292 | 133.969047 | 2021-08-05 04:21:51 | Kagawa, Japan | ||
3468193 | 3468193 | 2021-08-03 | Japan | Kagawa | 2363 | 32 | 2123 | 208 | 34.217292 | 133.969047 | 2021-08-04 04:21:25 | Kagawa, Japan | ||
3683467 | 3683467 | 2021-08-02 | Japan | Kagawa | 2334 | 32 | 2122 | 180 | 34.217292 | 133.969047 | 2021-08-03 04:21:39 | Kagawa, Japan | ||
3015366 | 3015366 | 2021-08-01 | Japan | Kagawa | 2306 | 32 | 2118 | 156 | 34.217292 | 133.969047 | 2021-08-02 04:21:36 | Kagawa, Japan | ||
3903989 | 3903989 | 2021-07-31 | Japan | Kagawa | 2272 | 32 | 2112 | 128 | 34.217292 | 133.969047 | 2021-08-01 04:21:50 | Kagawa, Japan | ||
3296194 | 3296194 | 2021-07-30 | Japan | Kagawa | 2229 | 32 | 2107 | 90 | 34.217292 | 133.969047 | 2021-07-31 04:21:35 | Kagawa, Japan | ||
3385405 | 3385405 | 2021-07-29 | Japan | Kagawa | 2214 | 32 | 2103 | 79 | 34.217292 | 133.969047 | 2021-07-30 04:21:34 | Kagawa, Japan | ||
408310 | 408310 | 2021-07-28 | Japan | Kagawa | 2181 | 32 | 2097 | 52 | 34.217292 | 133.969047 | 2021-07-29 04:21:33 | Kagawa, Japan | ||
1306171 | 1306171 | 2021-07-27 | Japan | Kagawa | 2170 | 32 | 2097 | 41 | 34.217292 | 133.969047 | 2021-07-28 04:21:39 | Kagawa, Japan | ||
3218314 | 3218314 | 2021-07-26 | Japan | Kagawa | 2162 | 32 | 2096 | 34 | 34.217292 | 133.969047 | 2021-07-27 04:21:18 | Kagawa, Japan | ||
1378523 | 1378523 | 2021-07-25 | Japan | Kagawa | 2160 | 32 | 2095 | 33 | 34.217292 | 133.969047 | 2021-07-26 04:21:28 | Kagawa, Japan | ||
1330263 | 1330263 | 2021-07-24 | Japan | Kagawa | 2155 | 32 | 2094 | 29 | 34.217292 | 133.969047 | 2021-07-25 04:22:12 | Kagawa, Japan | ||
3137567 | 3137567 | 2021-07-23 | Japan | Kagawa | 2151 | 32 | 2091 | 28 | 34.217292 | 133.969047 | 2021-07-24 00:21:36 | Kagawa, Japan | ||
3476327 | 3476327 | 2021-07-22 | Japan | Kagawa | 2147 | 32 | 2090 | 25 | 34.217292 | 133.969047 | 2021-07-23 04:21:29 | Kagawa, Japan | ||
3331546 | 3331546 | 2021-07-21 | Japan | Kagawa | 2143 | 31 | 2087 | 25 | 34.217292 | 133.969047 | 2021-07-22 04:21:19 | Kagawa, Japan | ||
2371527 | 2371527 | 2021-07-20 | Japan | Kagawa | 2135 | 31 | 2085 | 19 | 34.217292 | 133.969047 | 2021-07-21 04:21:40 | Kagawa, Japan | ||
483606 | 483606 | 2021-07-19 | Japan | Kagawa | 2131 | 31 | 2082 | 18 | 34.217292 | 133.969047 | 2021-07-20 04:21:48 | Kagawa, Japan | ||
2673829 | 2673829 | 2021-07-18 | Japan | Kagawa | 2131 | 31 | 2078 | 22 | 34.217292 | 133.969047 | 2021-07-19 04:21:24 | Kagawa, Japan | ||
3706141 | 3706141 | 2021-07-17 | Japan | Kagawa | 2128 | 31 | 2077 | 20 | 34.217292 | 133.969047 | 2021-07-18 04:22:07 | Kagawa, Japan | ||
2947372 | 2947372 | 2021-07-16 | Japan | Kagawa | 2127 | 31 | 2071 | 25 | 34.217292 | 133.969047 | 2021-07-17 04:22:22 | Kagawa, Japan | ||
296028 | 296028 | 2021-07-15 | Japan | Kagawa | 2123 | 31 | 2071 | 21 | 34.217292 | 133.969047 | 2021-07-16 04:21:22 | Kagawa, Japan | ||
3631973 | 3631973 | 2021-07-14 | Japan | Kagawa | 2122 | 31 | 2069 | 22 | 34.217292 | 133.969047 | 2021-07-15 04:21:48 | Kagawa, Japan | ||
578848 | 578848 | 2021-07-13 | Japan | Kagawa | 2119 | 31 | 2069 | 19 | 34.217292 | 133.969047 | 2021-07-14 04:21:35 | Kagawa, Japan | ||
3741097 | 3741097 | 2021-07-12 | Japan | Kagawa | 2118 | 31 | 2069 | 18 | 34.217292 | 133.969047 | 2021-07-13 04:21:18 | Kagawa, Japan | ||
3659610 | 3659610 | 2021-07-11 | Japan | Kagawa | 2117 | 31 | 2067 | 19 | 34.217292 | 133.969047 | 2021-07-12 04:21:34 | Kagawa, Japan | ||
625894 | 625894 | 2021-07-10 | Japan | Kagawa | 2113 | 31 | 2067 | 15 | 34.217292 | 133.969047 | 2021-07-11 04:21:43 | Kagawa, Japan | ||
829613 | 829613 | 2021-07-09 | Japan | Kagawa | 2111 | 31 | 2067 | 13 | 34.217292 | 133.969047 | 2021-07-10 04:21:25 | Kagawa, Japan | ||
778377 | 778377 | 2021-07-08 | Japan | Kagawa | 2105 | 31 | 2065 | 9 | 34.217292 | 133.969047 | 2021-07-09 04:21:21 | Kagawa, Japan | ||
1440599 | 1440599 | 2021-07-07 | Japan | Kagawa | 2103 | 31 | 2060 | 12 | 34.217292 | 133.969047 | 2021-07-08 04:21:26 | Kagawa, Japan | ||
2693704 | 2693704 | 2021-07-06 | Japan | Kagawa | 2103 | 31 | 2058 | 14 | 34.217292 | 133.969047 | 2021-07-07 04:21:20 | Kagawa, Japan | ||
1932453 | 1932453 | 2021-07-05 | Japan | Kagawa | 2099 | 31 | 2058 | 10 | 34.217292 | 133.969047 | 2021-07-06 04:21:32 | Kagawa, Japan | ||
1165184 | 1165184 | 2021-07-04 | Japan | Kagawa | 2099 | 31 | 2055 | 13 | 34.217292 | 133.969047 | 2021-07-05 04:21:28 | Kagawa, Japan | ||
1495618 | 1495618 | 2021-07-03 | Japan | Kagawa | 2098 | 31 | 2054 | 13 | 34.217292 | 133.969047 | 2021-07-04 04:21:38 | Kagawa, Japan | ||
2071933 | 2071933 | 2021-07-02 | Japan | Kagawa | 2097 | 31 | 2051 | 15 | 34.217292 | 133.969047 | 2021-07-03 04:21:37 | Kagawa, Japan | ||
2764949 | 2764949 | 2021-07-01 | Japan | Kagawa | 2096 | 31 | 2051 | 14 | 34.217292 | 133.969047 | 2021-07-02 04:21:47 | Kagawa, Japan | ||
1893157 | 1893157 | 2021-06-30 | Japan | Kagawa | 2096 | 31 | 2045 | 20 | 34.217292 | 133.969047 | 2021-07-01 04:21:19 | Kagawa, Japan | ||
400280 | 400280 | 2021-06-29 | Japan | Kagawa | 2094 | 30 | 2044 | 20 | 34.217292 | 133.969047 | 2021-06-30 04:21:41 | Kagawa, Japan | ||
3125523 | 3125523 | 2021-06-28 | Japan | Kagawa | 2092 | 30 | 2041 | 21 | 34.217292 | 133.969047 | 2021-06-29 04:21:28 | Kagawa, Japan | ||
2590018 | 2590018 | 2021-06-27 | Japan | Kagawa | 2092 | 30 | 2040 | 22 | 34.217292 | 133.969047 | 2021-06-28 04:21:29 | Kagawa, Japan | ||
3958522 | 3958522 | 2021-06-26 | Japan | Kagawa | 2090 | 30 | 2037 | 23 | 34.217292 | 133.969047 | 2021-06-27 04:21:39 | Kagawa, Japan | ||
1712341 | 1712341 | 2021-06-25 | Japan | Kagawa | 2090 | 30 | 2035 | 25 | 34.217292 | 133.969047 | 2021-06-26 04:21:43 | Kagawa, Japan | ||
2295466 | 2295466 | 2021-06-24 | Japan | Kagawa | 2084 | 30 | 2030 | 24 | 34.217292 | 133.969047 | 2021-06-25 04:21:33 | Kagawa, Japan | ||
2422906 | 2422906 | 2021-06-23 | Japan | Kagawa | 2084 | 30 | 2023 | 31 | 34.217292 | 133.969047 | 2021-06-24 04:21:55 | Kagawa, Japan | ||
562983 | 562983 | 2021-06-22 | Japan | Kagawa | 2083 | 30 | 2021 | 32 | 34.217292 | 133.969047 | 2021-06-23 04:21:46 | Kagawa, Japan | ||
3358685 | 3358685 | 2021-06-21 | Japan | Kagawa | 2082 | 30 | 2020 | 32 | 34.217292 | 133.969047 | 2021-06-22 04:21:34 | Kagawa, Japan | ||
2884384 | 2884384 | 2021-06-20 | Japan | Kagawa | 2082 | 30 | 2016 | 36 | 34.217292 | 133.969047 | 2021-06-21 04:21:41 | Kagawa, Japan | ||
107467 | 107467 | 2021-06-19 | Japan | Kagawa | 2082 | 29 | 2008 | 45 | 34.217292 | 133.969047 | 2021-06-20 04:21:48 | Kagawa, Japan | ||
1125610 | 1125610 | 2021-06-18 | Japan | Kagawa | 2081 | 29 | 2000 | 52 | 34.217292 | 133.969047 | 2021-06-19 04:22:33 | Kagawa, Japan | ||
2911188 | 2911188 | 2021-06-17 | Japan | Kagawa | 2078 | 29 | 1999 | 50 | 34.217292 | 133.969047 | 2021-06-18 04:22:16 | Kagawa, Japan | ||
3030306 | 3030306 | 2021-06-16 | Japan | Kagawa | 2077 | 29 | 1994 | 54 | 34.217292 | 133.969047 | 2021-06-17 04:22:36 | Kagawa, Japan | ||
2339412 | 2339412 | 2021-06-15 | Japan | Kagawa | 2073 | 28 | 1987 | 58 | 34.217292 | 133.969047 | 2021-06-16 04:22:32 | Kagawa, Japan | ||
1564108 | 1564108 | 2021-06-14 | Japan | Kagawa | 2066 | 28 | 1984 | 54 | 34.217292 | 133.969047 | 2021-06-15 04:22:22 | Kagawa, Japan | ||
3381391 | 3381391 | 2021-06-13 | Japan | Kagawa | 2064 | 27 | 1978 | 59 | 34.217292 | 133.969047 | 2021-06-14 04:22:46 | Kagawa, Japan | ||
1736525 | 1736525 | 2021-06-12 | Japan | Kagawa | 2062 | 26 | 1969 | 67 | 34.217292 | 133.969047 | 2021-06-13 04:22:44 | Kagawa, Japan | ||
3970566 | 3970566 | 2021-06-11 | Japan | Kagawa | 2061 | 26 | 1958 | 77 | 34.217292 | 133.969047 | 2021-06-12 04:22:22 | Kagawa, Japan | ||
2716988 | 2716988 | 2021-06-10 | Japan | Kagawa | 2057 | 26 | 1949 | 82 | 34.217292 | 133.969047 | 2021-06-11 04:23:20 | Kagawa, Japan | ||
522873 | 522873 | 2021-06-09 | Japan | Kagawa | 2047 | 26 | 1942 | 79 | 34.217292 | 133.969047 | 2021-06-10 04:23:17 | Kagawa, Japan | ||
3472313 | 3472313 | 2021-06-08 | Japan | Kagawa | 2041 | 26 | 1933 | 82 | 34.217292 | 133.969047 | 2021-06-09 04:23:31 | Kagawa, Japan | ||
3145597 | 3145597 | 2021-06-07 | Japan | Kagawa | 2038 | 26 | 1931 | 81 | 34.217292 | 133.969047 | 2021-06-08 04:22:35 | Kagawa, 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]);