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 = "Kyoto" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date)

province_or_state 1

  • Kyoto · 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 Kyoto     596677 1285 0   35.253815 135.443341 2022-12-30 04:21:04 Kyoto, Japan
2022-12-28 Japan Kyoto     593258 1278 0   35.253815 135.443341 2022-12-29 04:21:01 Kyoto, Japan
2022-12-27 Japan Kyoto     589293 1272 0   35.253815 135.443341 2022-12-28 04:21:04 Kyoto, Japan
2022-12-26 Japan Kyoto     585584 1264 0   35.253815 135.443341 2022-12-27 04:21:07 Kyoto, Japan
2022-12-25 Japan Kyoto     584768 1257 0   35.253815 135.443341 2022-12-26 04:21:06 Kyoto, Japan
2022-12-24 Japan Kyoto     581870 1249 0   35.253815 135.443341 2022-12-25 04:21:04 Kyoto, Japan
2022-12-23 Japan Kyoto     579116 1241 0   35.253815 135.443341 2022-12-24 04:21:02 Kyoto, Japan
2022-12-22 Japan Kyoto     576139 1236 0   35.253815 135.443341 2022-12-23 04:21:04 Kyoto, Japan
2022-12-21 Japan Kyoto     573098 1230 0   35.253815 135.443341 2022-12-22 04:20:56 Kyoto, Japan
2022-12-20 Japan Kyoto     569480 1225 0   35.253815 135.443341 2022-12-21 04:21:03 Kyoto, Japan
2022-12-19 Japan Kyoto     566004 1222 0   35.253815 135.443341 2022-12-20 04:21:04 Kyoto, Japan
2022-12-18 Japan Kyoto     565335 1220 0   35.253815 135.443341 2022-12-19 04:21:03 Kyoto, Japan
2022-12-17 Japan Kyoto     562732 1216 0   35.253815 135.443341 2022-12-18 04:21:03 Kyoto, Japan
2022-12-16 Japan Kyoto     560125 1215 0   35.253815 135.443341 2022-12-17 04:21:04 Kyoto, Japan
2022-12-15 Japan Kyoto     557541 1212 0   35.253815 135.443341 2022-12-16 04:21:01 Kyoto, Japan
2022-12-14 Japan Kyoto     554542 1208 0   35.253815 135.443341 2022-12-15 04:20:58 Kyoto, Japan
2022-12-13 Japan Kyoto     551208 1204 0   35.253815 135.443341 2022-12-14 04:21:04 Kyoto, Japan
2022-12-12 Japan Kyoto     547994 1202 0   35.253815 135.443341 2022-12-13 04:21:01 Kyoto, Japan
2022-12-11 Japan Kyoto     547336 1201 0   35.253815 135.443341 2022-12-12 04:21:01 Kyoto, Japan
2022-12-10 Japan Kyoto     545237 1197 0   35.253815 135.443341 2022-12-11 04:20:50 Kyoto, Japan
2022-12-09 Japan Kyoto     542985 1195 0   35.253815 135.443341 2022-12-10 04:21:02 Kyoto, Japan
2022-12-08 Japan Kyoto     540685 1192 0   35.253815 135.443341 2022-12-09 04:21:05 Kyoto, Japan
2022-12-07 Japan Kyoto     538402 1190 0   35.253815 135.443341 2022-12-08 04:21:07 Kyoto, Japan
2022-12-06 Japan Kyoto     535926 1187 0   35.253815 135.443341 2022-12-07 04:20:58 Kyoto, Japan
2022-12-05 Japan Kyoto     533387 1184 0   35.253815 135.443341 2022-12-06 04:21:03 Kyoto, Japan
2022-12-04 Japan Kyoto     532932 1182 0   35.253815 135.443341 2022-12-05 04:20:58 Kyoto, Japan
2022-12-03 Japan Kyoto     531392 1180 0   35.253815 135.443341 2022-12-04 04:20:56 Kyoto, Japan
2022-12-02 Japan Kyoto     529768 1175 0   35.253815 135.443341 2022-12-03 04:21:02 Kyoto, Japan
2022-12-01 Japan Kyoto     528049 1169 0   35.253815 135.443341 2022-12-02 04:21:07 Kyoto, Japan
2022-11-30 Japan Kyoto     526250 1166 0   35.253815 135.443341 2022-12-01 04:21:03 Kyoto, Japan
2022-11-29 Japan Kyoto     524206 1164 0   35.253815 135.443341 2022-11-30 04:21:07 Kyoto, Japan
2022-11-28 Japan Kyoto     522060 1161 0   35.253815 135.443341 2022-11-29 04:21:05 Kyoto, Japan
2022-11-27 Japan Kyoto     521625 1158 0   35.253815 135.443341 2022-11-28 04:21:02 Kyoto, Japan
2022-11-26 Japan Kyoto     520119 1154 0   35.253815 135.443341 2022-11-27 04:21:05 Kyoto, Japan
2022-11-25 Japan Kyoto     518322 1150 0   35.253815 135.443341 2022-11-26 04:21:11 Kyoto, Japan
2022-11-24 Japan Kyoto     516611 1148 0   35.253815 135.443341 2022-11-25 04:21:06 Kyoto, Japan
2022-11-23 Japan Kyoto     515825 1147 0   35.253815 135.443341 2022-11-24 04:21:09 Kyoto, Japan
2022-11-22 Japan Kyoto     513917 1145 0   35.253815 135.443341 2022-11-23 04:21:06 Kyoto, Japan
2022-11-21 Japan Kyoto     512190 1144 0   35.253815 135.443341 2022-11-22 04:20:47 Kyoto, Japan
2022-11-20 Japan Kyoto     511842 1144 0   35.253815 135.443341 2022-11-21 04:21:05 Kyoto, Japan
2022-11-19 Japan Kyoto     510701 1142 0   35.253815 135.443341 2022-11-20 04:21:08 Kyoto, Japan
2022-11-18 Japan Kyoto     509480 1141 0   35.253815 135.443341 2022-11-19 04:21:14 Kyoto, Japan
2022-11-17 Japan Kyoto     508407 1141 0   35.253815 135.443341 2022-11-18 04:21:15 Kyoto, Japan
2022-11-16 Japan Kyoto     507154 1140 0   35.253815 135.443341 2022-11-17 04:21:11 Kyoto, Japan
2022-11-15 Japan Kyoto     505580 1138 0   35.253815 135.443341 2022-11-16 04:21:09 Kyoto, Japan
2022-11-14 Japan Kyoto     504110 1141 0   35.253815 135.443341 2022-11-15 04:21:16 Kyoto, Japan
2022-11-13 Japan Kyoto     503860 1141 0   35.253815 135.443341 2022-11-14 04:21:09 Kyoto, Japan
2022-11-12 Japan Kyoto     502950 1141 0   35.253815 135.443341 2022-11-13 04:21:14 Kyoto, Japan
2022-11-11 Japan Kyoto     501974 1138 0   35.253815 135.443341 2022-11-12 04:20:41 Kyoto, Japan
2022-11-10 Japan Kyoto     501001 1136 0   35.253815 135.443341 2022-11-11 04:21:22 Kyoto, Japan
2022-11-09 Japan Kyoto     499941 1135 0   35.253815 135.443341 2022-11-10 04:21:16 Kyoto, Japan
2022-11-08 Japan Kyoto     498759 1132 0   35.253815 135.443341 2022-11-09 04:21:22 Kyoto, Japan
2022-11-07 Japan Kyoto     497608 1130 0   35.253815 135.443341 2022-11-08 04:21:21 Kyoto, Japan
2022-11-06 Japan Kyoto     497341 1129 0   35.253815 135.443341 2022-11-07 04:21:26 Kyoto, Japan
2022-11-05 Japan Kyoto     496244 1128 0   35.253815 135.443341 2022-11-06 04:21:24 Kyoto, Japan
2022-11-04 Japan Kyoto     495226 1126 0   35.253815 135.443341 2022-11-05 04:21:52 Kyoto, Japan
2022-11-03 Japan Kyoto     494822 1126 0   35.253815 135.443341 2022-11-04 04:22:11 Kyoto, Japan
2022-11-02 Japan Kyoto     493934 1125 0   35.253815 135.443341 2022-11-03 04:22:05 Kyoto, Japan
2022-11-01 Japan Kyoto     492917 1123 0   35.253815 135.443341 2022-11-02 04:22:09 Kyoto, Japan
2022-10-31 Japan Kyoto     491996 1122 0   35.253815 135.443341 2022-11-01 04:22:36 Kyoto, Japan
2022-10-30 Japan Kyoto     491786 1122 0   35.253815 135.443341 2022-10-31 04:21:36 Kyoto, Japan
2022-10-29 Japan Kyoto     491204 1122 0   35.253815 135.443341 2022-10-30 04:22:14 Kyoto, Japan
2022-10-28 Japan Kyoto     490646 1122 0   35.253815 135.443341 2022-10-29 04:21:13 Kyoto, Japan
2022-10-27 Japan Kyoto     490050 1122 0   35.253815 135.443341 2022-10-28 04:22:31 Kyoto, Japan
2022-10-26 Japan Kyoto     489508 1122 0   35.253815 135.443341 2022-10-27 04:22:01 Kyoto, Japan
2022-10-25 Japan Kyoto     488726 1122 0   35.253815 135.443341 2022-10-26 04:22:19 Kyoto, Japan
2022-10-24 Japan Kyoto     488079 1121 0   35.253815 135.443341 2022-10-25 04:21:53 Kyoto, Japan
2022-10-23 Japan Kyoto     487930 1120 0   35.253815 135.443341 2022-10-24 04:22:29 Kyoto, Japan
2022-10-22 Japan Kyoto     487426 1120 0   35.253815 135.443341 2022-10-23 04:22:46 Kyoto, Japan
2022-10-21 Japan Kyoto     487006 1118 0   35.253815 135.443341 2022-10-22 04:22:53 Kyoto, Japan
2022-10-20 Japan Kyoto     486595 1117 0   35.253815 135.443341 2022-10-21 04:22:23 Kyoto, Japan
2022-10-19 Japan Kyoto     486111 1115 0   35.253815 135.443341 2022-10-20 04:22:59 Kyoto, Japan
2022-10-18 Japan Kyoto     485569 1111 0   35.253815 135.443341 2022-10-19 04:22:26 Kyoto, Japan
2022-10-17 Japan Kyoto     484996 1109 0   35.253815 135.443341 2022-10-18 04:22:42 Kyoto, Japan
2022-10-16 Japan Kyoto     484882 1109 0   35.253815 135.443341 2022-10-17 04:20:31 Kyoto, Japan
2022-10-15 Japan Kyoto     484361 1107 0   35.253815 135.443341 2022-10-16 04:22:39 Kyoto, Japan
2022-10-14 Japan Kyoto     483910 1104 0   35.253815 135.443341 2022-10-15 04:22:00 Kyoto, Japan
2022-10-13 Japan Kyoto     483366 1102 0   35.253815 135.443341 2022-10-14 04:22:28 Kyoto, Japan
2022-10-12 Japan Kyoto     482678 1099 0   35.253815 135.443341 2022-10-13 04:22:39 Kyoto, Japan
2022-10-11 Japan Kyoto     481970 1096 0   35.253815 135.443341 2022-10-12 04:22:51 Kyoto, Japan
2022-10-10 Japan Kyoto     481872 1096 0   35.253815 135.443341 2022-10-11 04:23:05 Kyoto, Japan
2022-10-09 Japan Kyoto     481755 1092 0   35.253815 135.443341 2022-10-10 04:22:32 Kyoto, Japan
2022-10-08 Japan Kyoto     481337 1087 0   35.253815 135.443341 2022-10-09 04:21:16 Kyoto, Japan
2022-10-07 Japan Kyoto     480903 1081 0   35.253815 135.443341 2022-10-08 04:22:56 Kyoto, Japan
2022-10-06 Japan Kyoto     480411 1078 0   35.253815 135.443341 2022-10-07 04:23:08 Kyoto, Japan
2022-10-05 Japan Kyoto     479860 1074 0   35.253815 135.443341 2022-10-06 04:21:22 Kyoto, Japan
2022-10-04 Japan Kyoto     479145 1071 0   35.253815 135.443341 2022-10-05 04:23:06 Kyoto, Japan
2022-10-03 Japan Kyoto     478549 1069 0   35.253815 135.443341 2022-10-04 04:22:55 Kyoto, Japan
2022-10-02 Japan Kyoto     478377 1068 0   35.253815 135.443341 2022-10-03 04:23:11 Kyoto, Japan
2022-10-01 Japan Kyoto     477882 1065 0   35.253815 135.443341 2022-10-02 04:21:23 Kyoto, Japan
2022-09-30 Japan Kyoto     477232 1062 0   35.253815 135.443341 2022-10-01 04:23:01 Kyoto, Japan
2022-09-29 Japan Kyoto     476660 1058 0   35.253815 135.443341 2022-09-30 04:23:09 Kyoto, Japan
2022-09-28 Japan Kyoto     475971 1054 0   35.253815 135.443341 2022-09-29 04:22:34 Kyoto, Japan
2022-09-27 Japan Kyoto     475063 1051 0   35.253815 135.443341 2022-09-28 04:23:01 Kyoto, Japan
2022-09-26 Japan Kyoto     474223 1048 0   35.253815 135.443341 2022-09-27 04:23:01 Kyoto, Japan
2022-09-25 Japan Kyoto     473258 1044 0   35.253815 135.443341 2022-09-26 04:20:52 Kyoto, Japan
2022-09-24 Japan Kyoto     472611 1038 0   35.253815 135.443341 2022-09-25 04:23:31 Kyoto, Japan
2022-09-23 Japan Kyoto     471772 1033 0   35.253815 135.443341 2022-09-24 04:21:40 Kyoto, Japan
2022-09-22 Japan Kyoto     470584 1030 0   35.253815 135.443341 2022-09-23 04:23:13 Kyoto, Japan
2022-09-21 Japan Kyoto     468962 1026 0   35.253815 135.443341 2022-09-22 04:22:56 Kyoto, 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;