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 = "Ehime" 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

  • Ehime · 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 Ehime     248940 417 0   33.624835 132.856842 2022-12-30 04:21:04 Ehime, Japan
2022-12-28 Japan Ehime     246076 411 0   33.624835 132.856842 2022-12-29 04:21:01 Ehime, Japan
2022-12-27 Japan Ehime     243230 407 0   33.624835 132.856842 2022-12-28 04:21:04 Ehime, Japan
2022-12-26 Japan Ehime     239099 405 0   33.624835 132.856842 2022-12-27 04:21:07 Ehime, Japan
2022-12-25 Japan Ehime     238081 398 0   33.624835 132.856842 2022-12-26 04:21:06 Ehime, Japan
2022-12-24 Japan Ehime     236106 393 0   33.624835 132.856842 2022-12-25 04:21:04 Ehime, Japan
2022-12-23 Japan Ehime     233584 391 0   33.624835 132.856842 2022-12-24 04:21:02 Ehime, Japan
2022-12-22 Japan Ehime     231095 387 0   33.624835 132.856842 2022-12-23 04:21:04 Ehime, Japan
2022-12-21 Japan Ehime     228596 377 0   33.624835 132.856842 2022-12-22 04:20:56 Ehime, Japan
2022-12-20 Japan Ehime     225924 372 0   33.624835 132.856842 2022-12-21 04:21:03 Ehime, Japan
2022-12-19 Japan Ehime     222392 370 0   33.624835 132.856842 2022-12-20 04:21:04 Ehime, Japan
2022-12-18 Japan Ehime     221641 366 0   33.624835 132.856842 2022-12-19 04:21:03 Ehime, Japan
2022-12-17 Japan Ehime     220075 363 0   33.624835 132.856842 2022-12-18 04:21:03 Ehime, Japan
2022-12-16 Japan Ehime     217841 360 0   33.624835 132.856842 2022-12-17 04:21:04 Ehime, Japan
2022-12-15 Japan Ehime     215740 358 0   33.624835 132.856842 2022-12-16 04:21:01 Ehime, Japan
2022-12-14 Japan Ehime     213696 354 0   33.624835 132.856842 2022-12-15 04:20:58 Ehime, Japan
2022-12-13 Japan Ehime     211378 348 0   33.624835 132.856842 2022-12-14 04:21:04 Ehime, Japan
2022-12-12 Japan Ehime     208226 342 0   33.624835 132.856842 2022-12-13 04:21:01 Ehime, Japan
2022-12-11 Japan Ehime     207557 342 0   33.624835 132.856842 2022-12-12 04:21:01 Ehime, Japan
2022-12-10 Japan Ehime     206189 342 0   33.624835 132.856842 2022-12-11 04:20:50 Ehime, Japan
2022-12-09 Japan Ehime     204618 339 0   33.624835 132.856842 2022-12-10 04:21:02 Ehime, Japan
2022-12-08 Japan Ehime     203190 334 0   33.624835 132.856842 2022-12-09 04:21:05 Ehime, Japan
2022-12-07 Japan Ehime     201642 329 0   33.624835 132.856842 2022-12-08 04:21:07 Ehime, Japan
2022-12-06 Japan Ehime     200253 329 0   33.624835 132.856842 2022-12-07 04:20:58 Ehime, Japan
2022-12-05 Japan Ehime     198232 325 0   33.624835 132.856842 2022-12-06 04:21:03 Ehime, Japan
2022-12-04 Japan Ehime     197812 325 0   33.624835 132.856842 2022-12-05 04:20:58 Ehime, Japan
2022-12-03 Japan Ehime     197004 324 0   33.624835 132.856842 2022-12-04 04:20:56 Ehime, Japan
2022-12-02 Japan Ehime     196104 324 0   33.624835 132.856842 2022-12-03 04:21:02 Ehime, Japan
2022-12-01 Japan Ehime     195137 324 0   33.624835 132.856842 2022-12-02 04:21:07 Ehime, Japan
2022-11-30 Japan Ehime     194233 322 0   33.624835 132.856842 2022-12-01 04:21:03 Ehime, Japan
2022-11-29 Japan Ehime     193117 320 0   33.624835 132.856842 2022-11-30 04:21:07 Ehime, Japan
2022-11-28 Japan Ehime     191584 319 0   33.624835 132.856842 2022-11-29 04:21:05 Ehime, Japan
2022-11-27 Japan Ehime     191228 318 0   33.624835 132.856842 2022-11-28 04:21:02 Ehime, Japan
2022-11-26 Japan Ehime     190466 318 0   33.624835 132.856842 2022-11-27 04:21:05 Ehime, Japan
2022-11-25 Japan Ehime     189547 317 0   33.624835 132.856842 2022-11-26 04:21:11 Ehime, Japan
2022-11-24 Japan Ehime     188267 317 0   33.624835 132.856842 2022-11-25 04:21:06 Ehime, Japan
2022-11-23 Japan Ehime     187951 316 0   33.624835 132.856842 2022-11-24 04:21:09 Ehime, Japan
2022-11-22 Japan Ehime     186989 315 0   33.624835 132.856842 2022-11-23 04:21:06 Ehime, Japan
2022-11-21 Japan Ehime     185739 313 0   33.624835 132.856842 2022-11-22 04:20:47 Ehime, Japan
2022-11-20 Japan Ehime     185456 313 0   33.624835 132.856842 2022-11-21 04:21:05 Ehime, Japan
2022-11-19 Japan Ehime     184826 310 0   33.624835 132.856842 2022-11-20 04:21:08 Ehime, Japan
2022-11-18 Japan Ehime     184032 309 0   33.624835 132.856842 2022-11-19 04:21:14 Ehime, Japan
2022-11-17 Japan Ehime     183333 309 0   33.624835 132.856842 2022-11-18 04:21:15 Ehime, Japan
2022-11-16 Japan Ehime     182644 308 0   33.624835 132.856842 2022-11-17 04:21:11 Ehime, Japan
2022-11-15 Japan Ehime     181871 303 0   33.624835 132.856842 2022-11-16 04:21:09 Ehime, Japan
2022-11-14 Japan Ehime     180813 302 0   33.624835 132.856842 2022-11-15 04:21:16 Ehime, Japan
2022-11-13 Japan Ehime     180513 300 0   33.624835 132.856842 2022-11-14 04:21:09 Ehime, Japan
2022-11-12 Japan Ehime     179905 297 0   33.624835 132.856842 2022-11-13 04:21:14 Ehime, Japan
2022-11-11 Japan Ehime     179085 293 0   33.624835 132.856842 2022-11-12 04:20:41 Ehime, Japan
2022-11-10 Japan Ehime     178439 291 0   33.624835 132.856842 2022-11-11 04:21:22 Ehime, Japan
2022-11-09 Japan Ehime     177742 291 0   33.624835 132.856842 2022-11-10 04:21:16 Ehime, Japan
2022-11-08 Japan Ehime     177099 290 0   33.624835 132.856842 2022-11-09 04:21:22 Ehime, Japan
2022-11-07 Japan Ehime     176167 290 0   33.624835 132.856842 2022-11-08 04:21:21 Ehime, Japan
2022-11-06 Japan Ehime     175938 290 0   33.624835 132.856842 2022-11-07 04:21:26 Ehime, Japan
2022-11-05 Japan Ehime     175405 290 0   33.624835 132.856842 2022-11-06 04:21:24 Ehime, Japan
2022-11-04 Japan Ehime     174572 290 0   33.624835 132.856842 2022-11-05 04:21:52 Ehime, Japan
2022-11-03 Japan Ehime     174392 290 0   33.624835 132.856842 2022-11-04 04:22:11 Ehime, Japan
2022-11-02 Japan Ehime     173793 289 0   33.624835 132.856842 2022-11-03 04:22:05 Ehime, Japan
2022-11-01 Japan Ehime     173164 289 0   33.624835 132.856842 2022-11-02 04:22:09 Ehime, Japan
2022-10-31 Japan Ehime     172298 289 0   33.624835 132.856842 2022-11-01 04:22:36 Ehime, Japan
2022-10-30 Japan Ehime     172162 289 0   33.624835 132.856842 2022-10-31 04:21:36 Ehime, Japan
2022-10-29 Japan Ehime     171771 289 0   33.624835 132.856842 2022-10-30 04:22:14 Ehime, Japan
2022-10-28 Japan Ehime     171274 289 0   33.624835 132.856842 2022-10-29 04:21:13 Ehime, Japan
2022-10-27 Japan Ehime     170872 289 0   33.624835 132.856842 2022-10-28 04:22:31 Ehime, Japan
2022-10-26 Japan Ehime     170491 289 0   33.624835 132.856842 2022-10-27 04:22:01 Ehime, Japan
2022-10-25 Japan Ehime     170005 289 0   33.624835 132.856842 2022-10-26 04:22:19 Ehime, Japan
2022-10-24 Japan Ehime     169277 289 0   33.624835 132.856842 2022-10-25 04:21:53 Ehime, Japan
2022-10-23 Japan Ehime     169163 289 0   33.624835 132.856842 2022-10-24 04:22:29 Ehime, Japan
2022-10-22 Japan Ehime     168796 289 0   33.624835 132.856842 2022-10-23 04:22:46 Ehime, Japan
2022-10-21 Japan Ehime     168352 289 0   33.624835 132.856842 2022-10-22 04:22:53 Ehime, Japan
2022-10-20 Japan Ehime     167975 289 0   33.624835 132.856842 2022-10-21 04:22:23 Ehime, Japan
2022-10-19 Japan Ehime     167620 289 0   33.624835 132.856842 2022-10-20 04:22:59 Ehime, Japan
2022-10-18 Japan Ehime     167301 289 0   33.624835 132.856842 2022-10-19 04:22:26 Ehime, Japan
2022-10-17 Japan Ehime     166871 289 0   33.624835 132.856842 2022-10-18 04:22:42 Ehime, Japan
2022-10-16 Japan Ehime     166758 289 0   33.624835 132.856842 2022-10-17 04:20:31 Ehime, Japan
2022-10-15 Japan Ehime     166502 289 0   33.624835 132.856842 2022-10-16 04:22:39 Ehime, Japan
2022-10-14 Japan Ehime     166209 289 0   33.624835 132.856842 2022-10-15 04:22:00 Ehime, Japan
2022-10-13 Japan Ehime     165912 289 0   33.624835 132.856842 2022-10-14 04:22:28 Ehime, Japan
2022-10-12 Japan Ehime     165543 289 0   33.624835 132.856842 2022-10-13 04:22:39 Ehime, Japan
2022-10-11 Japan Ehime     165039 289 0   33.624835 132.856842 2022-10-12 04:22:51 Ehime, Japan
2022-10-10 Japan Ehime     164925 289 0   33.624835 132.856842 2022-10-11 04:23:05 Ehime, Japan
2022-10-09 Japan Ehime     164799 289 0   33.624835 132.856842 2022-10-10 04:22:32 Ehime, Japan
2022-10-08 Japan Ehime     164573 289 0   33.624835 132.856842 2022-10-09 04:21:16 Ehime, Japan
2022-10-07 Japan Ehime     164291 289 0   33.624835 132.856842 2022-10-08 04:22:56 Ehime, Japan
2022-10-06 Japan Ehime     164023 289 0   33.624835 132.856842 2022-10-07 04:23:08 Ehime, Japan
2022-10-05 Japan Ehime     163667 289 0   33.624835 132.856842 2022-10-06 04:21:22 Ehime, Japan
2022-10-04 Japan Ehime     163318 289 0   33.624835 132.856842 2022-10-05 04:23:06 Ehime, Japan
2022-10-03 Japan Ehime     162883 289 0   33.624835 132.856842 2022-10-04 04:22:55 Ehime, Japan
2022-10-02 Japan Ehime     162770 288 0   33.624835 132.856842 2022-10-03 04:23:11 Ehime, Japan
2022-10-01 Japan Ehime     162572 288 0   33.624835 132.856842 2022-10-02 04:21:23 Ehime, Japan
2022-09-30 Japan Ehime     162300 288 0   33.624835 132.856842 2022-10-01 04:23:01 Ehime, Japan
2022-09-29 Japan Ehime     162033 288 0   33.624835 132.856842 2022-09-30 04:23:09 Ehime, Japan
2022-09-28 Japan Ehime     161708 288 0   33.624835 132.856842 2022-09-29 04:22:34 Ehime, Japan
2022-09-27 Japan Ehime     161324 288 0   33.624835 132.856842 2022-09-28 04:23:01 Ehime, Japan
2022-09-26 Japan Ehime     160789 288 0   33.624835 132.856842 2022-09-27 04:23:01 Ehime, Japan
2022-09-25 Japan Ehime     160443 288 0   33.624835 132.856842 2022-09-26 04:20:52 Ehime, Japan
2022-09-24 Japan Ehime     159970 288 0   33.624835 132.856842 2022-09-25 04:23:31 Ehime, Japan
2022-09-23 Japan Ehime     159658 288 0   33.624835 132.856842 2022-09-24 04:21:40 Ehime, Japan
2022-09-22 Japan Ehime     159105 288 0   33.624835 132.856842 2022-09-23 04:23:13 Ehime, Japan
2022-09-21 Japan Ehime     158401 287 0   33.624835 132.856842 2022-09-22 04:22:56 Ehime, 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;