daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

23 rows where active = 185 and country_or_region = "Japan" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: latitude, last_update, last_update (date)

country_or_region 1

  • Japan · 23 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-07-29 Japan Port Quarantine     3476 6 3287 185     2021-07-30 04:21:34 Port Quarantine, Japan
2021-07-27 Japan Kumamoto     6705 121 6399 185 32.608154 130.74523100000002 2021-07-28 04:21:39 Kumamoto, Japan
2021-06-11 Japan Gunma     7970 148 7637 185 36.504479 138.985605 2021-06-12 04:22:22 Gunma, Japan
2021-05-30 Japan Yamagata     1956 41 1730 185 38.448396 140.102154 2021-05-31 03:08:59 Yamagata, Japan
2021-05-08 Japan Port Quarantine     2825 3 2637 185     2021-05-09 04:20:35 Port Quarantine, Japan
2021-05-05 Japan Yamagata     1571 34 1352 185 38.448396 140.102154 2021-05-06 04:20:38 Yamagata, Japan
2021-04-22 Japan Yamaguchi     1639 43 1411 185 34.201190000000004 131.573293 2021-04-23 04:20:52 Yamaguchi, Japan
2021-04-18 Japan Aomori     1305 20 1100 185 40.781541 140.828896 2021-04-19 04:20:57 Aomori, Japan
2021-03-27 Japan Tochigi     4526 70 4271 185 36.689912 139.819213 2021-03-28 05:28:10 Tochigi, Japan
2021-03-13 Japan Kyoto     9190 164 8841 185 35.253815 135.443341 2021-03-14 05:25:37 Kyoto, Japan
2021-03-09 Japan Shizuoka     5281 99 4997 185 34.916975 138.40778400000002 2021-03-10 05:24:35 Shizuoka, Japan
2021-02-24 Japan Tochigi     4060 65 3810 185 36.689912 139.819213 2021-02-25 05:24:57 Tochigi, Japan
2021-02-18 Japan Ishikawa     1743 60 1498 185 36.769464 136.771027 2021-02-19 05:24:16 Ishikawa, Japan
2021-02-13 Japan Shiga     2305 39 2081 185 35.21582700000001 136.138064 2021-02-14 05:23:43 Shiga, Japan
2021-02-07 Japan Miyagi     3477 22 3270 185 38.446859 140.927086 2021-02-08 05:22:39 Miyagi, Japan
2021-01-20 Japan Ishikawa     1373 55 1133 185 36.769464 136.771027 2021-01-21 05:22:01 Ishikawa, Japan
2021-01-17 Japan Toyama     802 27 590 185 36.637464 137.26934599999998 2021-01-18 05:22:34 Toyama, Japan
2021-01-17 Japan Yamanashi     846 11 650 185 35.612364 138.61148899999998 2021-01-18 05:22:34 Yamanashi, Japan
2020-12-19 Japan Mie     1131 15 931 185 34.508018 136.376013 2020-12-20 05:27:32 Mie, Japan
2020-11-21 Japan Nagano     592 6 401 185 36.132134 138.045528 2020-11-22 05:25:45 Nagano, Japan
2020-10-24 Japan Hyogo     3125 61 2879 185 35.039913 134.828057 2020-10-25 04:24:36 Hyogo, Japan
2020-08-28 Japan Nagasaki     224 3 36 185 33.235712 129.608033 2020-08-29 04:28:19 Nagasaki, Japan
2020-07-27 Japan Hyogo     1026 45 796 185 35.039913 134.828057 2020-07-28 04:58:43 Hyogo, Japan

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;