daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Akita" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-10-03 | Japan | Akita | 1880 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-10-04 04:21:31 | Akita, Japan | |||
2020-06-04 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-05 02:33:06 | Akita, Japan | ||
2022-01-05 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-06 04:22:09 | Akita, Japan | |||
2022-01-04 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-05 04:21:59 | Akita, Japan | |||
2022-02-05 | Japan | Akita | 5206 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-06 04:21:00 | Akita, Japan | |||
2022-02-17 | Japan | Akita | 7392 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-18 04:21:04 | Akita, Japan | |||
2022-01-26 | Japan | Akita | 3110 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-27 04:21:19 | Akita, Japan | |||
2021-11-14 | Japan | Akita | 1925 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-11-15 04:21:36 | Akita, Japan | |||
2022-04-26 | Japan | Akita | 23805 | 54 | 0 | 39.748678999999996 | 140.408228 | 2022-04-27 04:20:52 | Akita, Japan | |||
2021-09-28 | Japan | Akita | 1860 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-09-29 04:21:45 | Akita, Japan | |||
2021-08-11 | Japan | Akita | 1117 | 21 | 0 | 39.748678999999996 | 140.408228 | 2021-08-12 04:21:25 | Akita, Japan | |||
2021-11-27 | Japan | Akita | 1925 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-11-28 04:22:43 | Akita, Japan | |||
2022-02-08 | Japan | Akita | 5719 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-09 04:21:04 | Akita, Japan | |||
2021-09-15 | Japan | Akita | 1796 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-09-16 04:22:19 | Akita, Japan | |||
2021-09-13 | Japan | Akita | 1780 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-09-14 04:21:41 | Akita, Japan | |||
2022-01-07 | Japan | Akita | 1936 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-08 04:21:53 | Akita, Japan | |||
2021-12-28 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-29 03:21:43 | Akita, Japan | |||
2022-03-28 | Japan | Akita | 15421 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-29 04:20:46 | Akita, Japan | |||
2022-02-10 | Japan | Akita | 6155 | 29 | 0 | 39.748678999999996 | 140.408228 | 2022-02-11 04:21:09 | Akita, Japan | |||
2022-03-24 | Japan | Akita | 14494 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-25 04:20:46 | Akita, Japan | |||
2022-01-17 | Japan | Akita | 2140 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-18 04:21:04 | Akita, Japan | |||
2021-08-13 | Japan | Akita | 1154 | 21 | 0 | 39.748678999999996 | 140.408228 | 2021-08-14 04:21:25 | Akita, Japan | |||
2021-10-12 | Japan | Akita | 1893 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-10-13 04:20:51 | Akita, Japan | |||
2020-06-22 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-23 04:33:22 | Akita, Japan | ||
2022-02-24 | Japan | Akita | 8736 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-25 04:21:11 | Akita, Japan | |||
2020-06-23 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-24 04:33:28 | Akita, Japan | ||
2022-03-31 | Japan | Akita | 16333 | 46 | 0 | 39.748678999999996 | 140.408228 | 2022-04-01 04:20:28 | Akita, Japan | |||
2022-03-07 | Japan | Akita | 11039 | 37 | 0 | 39.748678999999996 | 140.408228 | 2022-03-08 04:20:54 | Akita, Japan | |||
2022-04-10 | Japan | Akita | 19218 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-11 04:21:02 | Akita, Japan | |||
2021-08-26 | Japan | Akita | 1538 | 22 | 0 | 39.748678999999996 | 140.408228 | 2021-08-27 04:21:37 | Akita, Japan | |||
2021-08-16 | Japan | Akita | 1193 | 21 | 0 | 39.748678999999996 | 140.408228 | 2021-08-17 04:21:49 | Akita, Japan | |||
2022-03-03 | Japan | Akita | 10301 | 33 | 0 | 39.748678999999996 | 140.408228 | 2022-03-04 04:21:09 | Akita, Japan | |||
2022-04-09 | Japan | Akita | 18966 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-10 04:20:52 | Akita, Japan | |||
2022-03-19 | Japan | Akita | 13554 | 43 | 0 | 39.748678999999996 | 140.408228 | 2022-03-20 04:20:45 | Akita, Japan | |||
2021-12-12 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-13 04:22:02 | Akita, Japan | |||
2021-12-11 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-12 04:22:12 | Akita, Japan | |||
2021-12-29 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-30 04:21:25 | Akita, Japan | |||
2020-06-19 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-20 04:33:19 | Akita, Japan | ||
2022-01-10 | Japan | Akita | 1946 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-11 04:22:01 | Akita, Japan | |||
2022-01-03 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-04 04:22:17 | Akita, Japan | |||
2020-07-21 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-07-22 04:34:42 | Akita, Japan | ||
2021-12-16 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-17 04:22:14 | Akita, Japan | |||
2022-03-25 | Japan | Akita | 14750 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-26 04:20:23 | Akita, Japan | |||
2021-09-25 | Japan | Akita | 1853 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-09-26 04:21:29 | Akita, Japan | |||
2021-12-05 | Japan | Akita | 1933 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-06 04:22:34 | Akita, Japan | |||
2021-08-30 | Japan | Akita | 1605 | 22 | 0 | 39.748678999999996 | 140.408228 | 2021-08-31 04:21:46 | Akita, Japan | |||
2022-01-27 | Japan | Akita | 3376 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-28 04:21:09 | Akita, Japan | |||
2020-05-29 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-05-30 02:32:48 | Akita, Japan | ||
2020-05-31 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-01 02:32:46 | Akita, Japan | ||
2021-11-25 | Japan | Akita | 1925 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-11-26 04:22:33 | Akita, Japan | |||
2021-09-19 | Japan | Akita | 1824 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-09-20 04:21:22 | Akita, Japan | |||
2020-06-14 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-15 03:33:14 | Akita, Japan | ||
2022-04-18 | Japan | Akita | 21610 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-19 04:21:00 | Akita, Japan | |||
2021-08-20 | Japan | Akita | 1328 | 21 | 0 | 39.748678999999996 | 140.408228 | 2021-08-21 04:21:38 | Akita, Japan | |||
2022-03-10 | Japan | Akita | 11723 | 40 | 0 | 39.748678999999996 | 140.408228 | 2022-03-11 04:20:50 | Akita, Japan | |||
2021-09-12 | Japan | Akita | 1774 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-09-13 04:21:15 | Akita, Japan | |||
2022-03-22 | Japan | Akita | 13970 | 44 | 0 | 39.748678999999996 | 140.408228 | 2022-03-23 04:20:48 | Akita, Japan | |||
2021-10-17 | Japan | Akita | 1894 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-10-18 04:21:10 | Akita, Japan | |||
2021-09-24 | Japan | Akita | 1850 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-09-25 04:21:31 | Akita, Japan | |||
2022-04-12 | Japan | Akita | 19808 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-13 04:21:03 | Akita, Japan | |||
2022-01-20 | Japan | Akita | 2256 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-21 04:21:09 | Akita, Japan | |||
2022-03-01 | Japan | Akita | 9828 | 33 | 0 | 39.748678999999996 | 140.408228 | 2022-03-02 04:21:07 | Akita, Japan | |||
2021-11-07 | Japan | Akita | 1910 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-11-08 04:21:43 | Akita, Japan | |||
2022-02-06 | Japan | Akita | 5380 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-07 04:21:05 | Akita, Japan | |||
2022-04-24 | Japan | Akita | 23342 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-25 04:20:56 | Akita, Japan | |||
2020-06-27 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-28 04:34:04 | Akita, Japan | ||
2021-10-18 | Japan | Akita | 1894 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-10-19 04:20:54 | Akita, Japan | |||
2022-01-25 | Japan | Akita | 2868 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-26 04:21:07 | Akita, Japan | |||
2021-08-31 | Japan | Akita | 1624 | 23 | 0 | 39.748678999999996 | 140.408228 | 2021-09-01 04:21:38 | Akita, Japan | |||
2021-09-26 | Japan | Akita | 1853 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-09-27 04:21:16 | Akita, Japan | |||
2021-12-14 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-15 03:22:16 | Akita, Japan | |||
2022-03-05 | Japan | Akita | 10769 | 35 | 0 | 39.748678999999996 | 140.408228 | 2022-03-06 04:20:49 | Akita, Japan | |||
2021-12-26 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-27 04:21:58 | Akita, Japan | |||
2022-04-08 | Japan | Akita | 18681 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-09 04:20:42 | Akita, Japan | |||
2021-10-21 | Japan | Akita | 1896 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-10-22 04:21:14 | Akita, Japan | |||
2021-10-01 | Japan | Akita | 1864 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-10-02 04:21:25 | Akita, Japan | |||
2022-03-09 | Japan | Akita | 11519 | 40 | 0 | 39.748678999999996 | 140.408228 | 2022-03-10 04:20:48 | Akita, Japan | |||
2020-07-14 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-07-15 04:34:39 | Akita, Japan | ||
2022-03-26 | Japan | Akita | 15038 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-27 04:20:47 | Akita, Japan | |||
2022-01-01 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-02 04:20:52 | Akita, Japan | |||
2021-08-22 | Japan | Akita | 1391 | 21 | 0 | 39.748678999999996 | 140.408228 | 2021-08-23 04:21:27 | Akita, Japan | |||
2021-12-03 | Japan | Akita | 1930 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-04 04:22:18 | Akita, Japan | |||
2022-03-06 | Japan | Akita | 10926 | 37 | 0 | 39.748678999999996 | 140.408228 | 2022-03-07 04:20:47 | Akita, Japan | |||
2020-07-08 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-07-09 04:34:23 | Akita, Japan | ||
2020-07-03 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-07-04 04:33:51 | Akita, Japan | ||
2022-04-19 | Japan | Akita | 21973 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-20 04:20:45 | Akita, Japan | |||
2022-03-14 | Japan | Akita | 12407 | 41 | 0 | 39.748678999999996 | 140.408228 | 2022-03-15 04:20:47 | Akita, Japan | |||
2021-09-08 | Japan | Akita | 1722 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-09-09 04:21:27 | Akita, Japan | |||
2021-11-15 | Japan | Akita | 1925 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-11-16 04:21:10 | Akita, Japan | |||
2020-06-28 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-29 04:33:44 | Akita, Japan | ||
2022-04-20 | Japan | Akita | 22261 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-21 04:20:46 | Akita, Japan | |||
2022-03-16 | Japan | Akita | 12928 | 43 | 0 | 39.748678999999996 | 140.408228 | 2022-03-17 04:20:56 | Akita, Japan | |||
2022-02-04 | Japan | Akita | 4947 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-05 04:21:05 | Akita, Japan | |||
2021-08-10 | Japan | Akita | 1104 | 21 | 0 | 39.748678999999996 | 140.408228 | 2021-08-11 04:21:58 | Akita, Japan | |||
2020-06-16 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-17 04:33:21 | Akita, Japan | ||
2021-12-17 | Japan | Akita | 1934 | 27 | 0 | 39.748678999999996 | 140.408228 | 2021-12-18 02:22:20 | Akita, Japan | |||
2020-06-20 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-21 04:33:19 | Akita, Japan | ||
2022-04-13 | Japan | Akita | 20167 | 51 | 0 | 39.748678999999996 | 140.408228 | 2022-04-13 23:21:06 | Akita, Japan | |||
2022-02-22 | Japan | Akita | 8389 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-23 04:21:09 | Akita, Japan | |||
2021-10-06 | Japan | Akita | 1890 | 26 | 0 | 39.748678999999996 | 140.408228 | 2021-10-07 04:21:36 | Akita, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;