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

946 rows where country_or_region = "Japan" and province_or_state = "Hiroshima" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Hiroshima · 946 ✖

country_or_region 1

  • Japan · 946 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-12-29 Japan Hiroshima     651857 1005 0   34.605309 132.788719 2022-12-30 04:21:04 Hiroshima, Japan
2022-12-28 Japan Hiroshima     645208 1002 0   34.605309 132.788719 2022-12-29 04:21:01 Hiroshima, Japan
2022-12-27 Japan Hiroshima     637647 992 0   34.605309 132.788719 2022-12-28 04:21:04 Hiroshima, Japan
2022-12-26 Japan Hiroshima     635162 988 0   34.605309 132.788719 2022-12-27 04:21:07 Hiroshima, Japan
2022-12-25 Japan Hiroshima     630780 983 0   34.605309 132.788719 2022-12-26 04:21:06 Hiroshima, Japan
2022-12-24 Japan Hiroshima     625546 974 0   34.605309 132.788719 2022-12-25 04:21:04 Hiroshima, Japan
2022-12-23 Japan Hiroshima     620432 972 0   34.605309 132.788719 2022-12-24 04:21:02 Hiroshima, Japan
2022-12-22 Japan Hiroshima     615412 967 0   34.605309 132.788719 2022-12-23 04:21:04 Hiroshima, Japan
2022-12-21 Japan Hiroshima     609571 958 0   34.605309 132.788719 2022-12-22 04:20:56 Hiroshima, Japan
2022-12-20 Japan Hiroshima     603227 952 0   34.605309 132.788719 2022-12-21 04:21:03 Hiroshima, Japan
2022-12-19 Japan Hiroshima     601280 952 0   34.605309 132.788719 2022-12-20 04:21:04 Hiroshima, Japan
2022-12-18 Japan Hiroshima     597295 935 0   34.605309 132.788719 2022-12-19 04:21:03 Hiroshima, Japan
2022-12-17 Japan Hiroshima     592591 930 0   34.605309 132.788719 2022-12-18 04:21:03 Hiroshima, Japan
2022-12-16 Japan Hiroshima     588276 926 0   34.605309 132.788719 2022-12-17 04:21:04 Hiroshima, Japan
2022-12-15 Japan Hiroshima     583614 919 0   34.605309 132.788719 2022-12-16 04:21:01 Hiroshima, Japan
2022-12-14 Japan Hiroshima     578441 915 0   34.605309 132.788719 2022-12-15 04:20:58 Hiroshima, Japan
2022-12-13 Japan Hiroshima     572922 915 0   34.605309 132.788719 2022-12-14 04:21:04 Hiroshima, Japan
2022-12-12 Japan Hiroshima     570946 909 0   34.605309 132.788719 2022-12-13 04:21:01 Hiroshima, Japan
2022-12-11 Japan Hiroshima     567588 900 0   34.605309 132.788719 2022-12-12 04:21:01 Hiroshima, Japan
2022-12-10 Japan Hiroshima     563411 899 0   34.605309 132.788719 2022-12-11 04:20:50 Hiroshima, Japan
2022-12-09 Japan Hiroshima     559859 895 0   34.605309 132.788719 2022-12-10 04:21:02 Hiroshima, Japan
2022-12-08 Japan Hiroshima     555983 891 0   34.605309 132.788719 2022-12-09 04:21:05 Hiroshima, Japan
2022-12-07 Japan Hiroshima     552021 887 0   34.605309 132.788719 2022-12-08 04:21:07 Hiroshima, Japan
2022-12-06 Japan Hiroshima     547449 886 0   34.605309 132.788719 2022-12-07 04:20:58 Hiroshima, Japan
2022-12-05 Japan Hiroshima     545939 885 0   34.605309 132.788719 2022-12-06 04:21:03 Hiroshima, Japan
2022-12-04 Japan Hiroshima     543652 881 0   34.605309 132.788719 2022-12-05 04:20:58 Hiroshima, Japan
2022-12-03 Japan Hiroshima     540608 880 0   34.605309 132.788719 2022-12-04 04:20:56 Hiroshima, Japan
2022-12-02 Japan Hiroshima     537832 875 0   34.605309 132.788719 2022-12-03 04:21:02 Hiroshima, Japan
2022-12-01 Japan Hiroshima     534722 867 0   34.605309 132.788719 2022-12-02 04:21:07 Hiroshima, Japan
2022-11-30 Japan Hiroshima     531182 863 0   34.605309 132.788719 2022-12-01 04:21:03 Hiroshima, Japan
2022-11-29 Japan Hiroshima     527319 862 0   34.605309 132.788719 2022-11-30 04:21:07 Hiroshima, Japan
2022-11-28 Japan Hiroshima     525995 859 0   34.605309 132.788719 2022-11-29 04:21:05 Hiroshima, Japan
2022-11-27 Japan Hiroshima     523367 856 0   34.605309 132.788719 2022-11-28 04:21:02 Hiroshima, Japan
2022-11-26 Japan Hiroshima     519871 851 0   34.605309 132.788719 2022-11-27 04:21:05 Hiroshima, Japan
2022-11-25 Japan Hiroshima     516418 848 0   34.605309 132.788719 2022-11-26 04:21:11 Hiroshima, Japan
2022-11-24 Japan Hiroshima     514969 845 0   34.605309 132.788719 2022-11-25 04:21:06 Hiroshima, Japan
2022-11-23 Japan Hiroshima     511305 839 0   34.605309 132.788719 2022-11-24 04:21:09 Hiroshima, Japan
2022-11-22 Japan Hiroshima     507375 835 0   34.605309 132.788719 2022-11-23 04:21:06 Hiroshima, Japan
2022-11-21 Japan Hiroshima     505999 830 0   34.605309 132.788719 2022-11-22 04:20:47 Hiroshima, Japan
2022-11-20 Japan Hiroshima     503648 828 0   34.605309 132.788719 2022-11-21 04:21:05 Hiroshima, Japan
2022-11-19 Japan Hiroshima     500805 822 0   34.605309 132.788719 2022-11-20 04:21:08 Hiroshima, Japan
2022-11-18 Japan Hiroshima     498351 818 0   34.605309 132.788719 2022-11-19 04:21:14 Hiroshima, Japan
2022-11-17 Japan Hiroshima     495630 808 0   34.605309 132.788719 2022-11-18 04:21:15 Hiroshima, Japan
2022-11-16 Japan Hiroshima     492663 802 0   34.605309 132.788719 2022-11-17 04:21:11 Hiroshima, Japan
2022-11-15 Japan Hiroshima     489207 801 0   34.605309 132.788719 2022-11-16 04:21:09 Hiroshima, Japan
2022-11-14 Japan Hiroshima     491155 807 0   34.605309 132.788719 2022-11-15 04:21:16 Hiroshima, Japan
2022-11-13 Japan Hiroshima     489053 802 0   34.605309 132.788719 2022-11-14 04:21:09 Hiroshima, Japan
2022-11-12 Japan Hiroshima     486424 800 0   34.605309 132.788719 2022-11-13 04:21:14 Hiroshima, Japan
2022-11-11 Japan Hiroshima     484266 797 0   34.605309 132.788719 2022-11-12 04:20:41 Hiroshima, Japan
2022-11-10 Japan Hiroshima     481927 796 0   34.605309 132.788719 2022-11-11 04:21:22 Hiroshima, Japan
2022-11-09 Japan Hiroshima     479400 795 0   34.605309 132.788719 2022-11-10 04:21:16 Hiroshima, Japan
2022-11-08 Japan Hiroshima     476484 794 0   34.605309 132.788719 2022-11-09 04:21:22 Hiroshima, Japan
2022-11-07 Japan Hiroshima     475427 794 0   34.605309 132.788719 2022-11-08 04:21:21 Hiroshima, Japan
2022-11-06 Japan Hiroshima     473393 794 0   34.605309 132.788719 2022-11-07 04:21:26 Hiroshima, Japan
2022-11-05 Japan Hiroshima     470865 794 0   34.605309 132.788719 2022-11-06 04:21:24 Hiroshima, Japan
2022-11-04 Japan Hiroshima     469862 794 0   34.605309 132.788719 2022-11-05 04:21:52 Hiroshima, Japan
2022-11-03 Japan Hiroshima     467778 793 0   34.605309 132.788719 2022-11-04 04:22:11 Hiroshima, Japan
2022-11-02 Japan Hiroshima     465832 789 0   34.605309 132.788719 2022-11-03 04:22:05 Hiroshima, Japan
2022-11-01 Japan Hiroshima     463755 789 0   34.605309 132.788719 2022-11-02 04:22:09 Hiroshima, Japan
2022-10-31 Japan Hiroshima     463025 789 0   34.605309 132.788719 2022-11-01 04:22:36 Hiroshima, Japan
2022-10-30 Japan Hiroshima     461804 789 0   34.605309 132.788719 2022-10-31 04:21:36 Hiroshima, Japan
2022-10-29 Japan Hiroshima     460390 789 0   34.605309 132.788719 2022-10-30 04:22:14 Hiroshima, Japan
2022-10-28 Japan Hiroshima     459126 788 0   34.605309 132.788719 2022-10-29 04:21:13 Hiroshima, Japan
2022-10-27 Japan Hiroshima     457881 787 0   34.605309 132.788719 2022-10-28 04:22:31 Hiroshima, Japan
2022-10-26 Japan Hiroshima     456491 785 0   34.605309 132.788719 2022-10-27 04:22:01 Hiroshima, Japan
2022-10-25 Japan Hiroshima     454945 785 0   34.605309 132.788719 2022-10-26 04:22:19 Hiroshima, Japan
2022-10-24 Japan Hiroshima     454357 785 0   34.605309 132.788719 2022-10-25 04:21:53 Hiroshima, Japan
2022-10-23 Japan Hiroshima     453417 785 0   34.605309 132.788719 2022-10-24 04:22:29 Hiroshima, Japan
2022-10-22 Japan Hiroshima     452420 783 0   34.605309 132.788719 2022-10-23 04:22:46 Hiroshima, Japan
2022-10-21 Japan Hiroshima     451505 781 0   34.605309 132.788719 2022-10-22 04:22:53 Hiroshima, Japan
2022-10-20 Japan Hiroshima     450423 781 0   34.605309 132.788719 2022-10-21 04:22:23 Hiroshima, Japan
2022-10-19 Japan Hiroshima     449168 778 0   34.605309 132.788719 2022-10-20 04:22:59 Hiroshima, Japan
2022-10-18 Japan Hiroshima     447738 778 0   34.605309 132.788719 2022-10-19 04:22:26 Hiroshima, Japan
2022-10-17 Japan Hiroshima     447279 778 0   34.605309 132.788719 2022-10-18 04:22:42 Hiroshima, Japan
2022-10-16 Japan Hiroshima     446332 775 0   34.605309 132.788719 2022-10-17 04:20:31 Hiroshima, Japan
2022-10-15 Japan Hiroshima     445128 775 0   34.605309 132.788719 2022-10-16 04:22:39 Hiroshima, Japan
2022-10-14 Japan Hiroshima     444204 775 0   34.605309 132.788719 2022-10-15 04:22:00 Hiroshima, Japan
2022-10-13 Japan Hiroshima     442963 775 0   34.605309 132.788719 2022-10-14 04:22:28 Hiroshima, Japan
2022-10-12 Japan Hiroshima     441666 775 0   34.605309 132.788719 2022-10-13 04:22:39 Hiroshima, Japan
2022-10-11 Japan Hiroshima     441251 775 0   34.605309 132.788719 2022-10-12 04:22:51 Hiroshima, Japan
2022-10-10 Japan Hiroshima     440791 775 0   34.605309 132.788719 2022-10-11 04:23:05 Hiroshima, Japan
2022-10-09 Japan Hiroshima     440098 775 0   34.605309 132.788719 2022-10-10 04:22:32 Hiroshima, Japan
2022-10-08 Japan Hiroshima     439271 775 0   34.605309 132.788719 2022-10-09 04:21:16 Hiroshima, Japan
2022-10-07 Japan Hiroshima     438403 770 0   34.605309 132.788719 2022-10-08 04:22:56 Hiroshima, Japan
2022-10-06 Japan Hiroshima     437372 767 0   34.605309 132.788719 2022-10-07 04:23:08 Hiroshima, Japan
2022-10-05 Japan Hiroshima     436147 765 0   34.605309 132.788719 2022-10-06 04:21:22 Hiroshima, Japan
2022-10-04 Japan Hiroshima     434707 764 0   34.605309 132.788719 2022-10-05 04:23:06 Hiroshima, Japan
2022-10-03 Japan Hiroshima     434227 764 0   34.605309 132.788719 2022-10-04 04:22:55 Hiroshima, Japan
2022-10-02 Japan Hiroshima     433377 764 0   34.605309 132.788719 2022-10-03 04:23:11 Hiroshima, Japan
2022-10-01 Japan Hiroshima     432316 764 0   34.605309 132.788719 2022-10-02 04:21:23 Hiroshima, Japan
2022-09-30 Japan Hiroshima     431463 760 0   34.605309 132.788719 2022-10-01 04:23:01 Hiroshima, Japan
2022-09-29 Japan Hiroshima     429909 758 0   34.605309 132.788719 2022-09-30 04:23:09 Hiroshima, Japan
2022-09-28 Japan Hiroshima     428960 753 0   34.605309 132.788719 2022-09-29 04:22:34 Hiroshima, Japan
2022-09-27 Japan Hiroshima     427565 752 0   34.605309 132.788719 2022-09-28 04:23:01 Hiroshima, Japan
2022-09-26 Japan Hiroshima     426441 747 0   34.605309 132.788719 2022-09-27 04:23:01 Hiroshima, Japan
2022-09-25 Japan Hiroshima     424573 746 0   34.605309 132.788719 2022-09-26 04:20:52 Hiroshima, Japan
2022-09-24 Japan Hiroshima     423649 745 0   34.605309 132.788719 2022-09-25 04:23:31 Hiroshima, Japan
2022-09-23 Japan Hiroshima     422310 743 0   34.605309 132.788719 2022-09-24 04:21:40 Hiroshima, Japan
2022-09-22 Japan Hiroshima     420357 742 0   34.605309 132.788719 2022-09-23 04:23:13 Hiroshima, Japan
2022-09-21 Japan Hiroshima     417986 738 0   34.605309 132.788719 2022-09-22 04:22:56 Hiroshima, Japan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;