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

  • Nagasaki · 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 Nagasaki     277949 416 0   33.235712 129.608033 2022-12-30 04:21:04 Nagasaki, Japan
2022-12-28 Japan Nagasaki     275509 409 0   33.235712 129.608033 2022-12-29 04:21:01 Nagasaki, Japan
2022-12-27 Japan Nagasaki     272898 405 0   33.235712 129.608033 2022-12-28 04:21:04 Nagasaki, Japan
2022-12-26 Japan Nagasaki     270017 401 0   33.235712 129.608033 2022-12-27 04:21:07 Nagasaki, Japan
2022-12-25 Japan Nagasaki     269331 399 0   33.235712 129.608033 2022-12-26 04:21:06 Nagasaki, Japan
2022-12-24 Japan Nagasaki     267629 399 0   33.235712 129.608033 2022-12-25 04:21:04 Nagasaki, Japan
2022-12-23 Japan Nagasaki     265837 395 0   33.235712 129.608033 2022-12-24 04:21:02 Nagasaki, Japan
2022-12-22 Japan Nagasaki     263936 393 0   33.235712 129.608033 2022-12-23 04:21:04 Nagasaki, Japan
2022-12-21 Japan Nagasaki     261984 388 0   33.235712 129.608033 2022-12-22 04:20:56 Nagasaki, Japan
2022-12-20 Japan Nagasaki     259772 386 0   33.235712 129.608033 2022-12-21 04:21:03 Nagasaki, Japan
2022-12-19 Japan Nagasaki     257351 385 0   33.235712 129.608033 2022-12-20 04:21:04 Nagasaki, Japan
2022-12-18 Japan Nagasaki     256856 383 0   33.235712 129.608033 2022-12-19 04:21:03 Nagasaki, Japan
2022-12-17 Japan Nagasaki     255482 377 0   33.235712 129.608033 2022-12-18 04:21:03 Nagasaki, Japan
2022-12-16 Japan Nagasaki     253868 375 0   33.235712 129.608033 2022-12-17 04:21:04 Nagasaki, Japan
2022-12-15 Japan Nagasaki     252346 373 0   33.235712 129.608033 2022-12-16 04:21:01 Nagasaki, Japan
2022-12-14 Japan Nagasaki     250804 370 0   33.235712 129.608033 2022-12-15 04:20:58 Nagasaki, Japan
2022-12-13 Japan Nagasaki     249033 369 0   33.235712 129.608033 2022-12-14 04:21:04 Nagasaki, Japan
2022-12-12 Japan Nagasaki     247094 364 0   33.235712 129.608033 2022-12-13 04:21:01 Nagasaki, Japan
2022-12-11 Japan Nagasaki     246693 364 0   33.235712 129.608033 2022-12-12 04:21:01 Nagasaki, Japan
2022-12-10 Japan Nagasaki     245633 359 0   33.235712 129.608033 2022-12-11 04:20:50 Nagasaki, Japan
2022-12-09 Japan Nagasaki     244489 358 0   33.235712 129.608033 2022-12-10 04:21:02 Nagasaki, Japan
2022-12-08 Japan Nagasaki     243443 356 0   33.235712 129.608033 2022-12-09 04:21:05 Nagasaki, Japan
2022-12-07 Japan Nagasaki     242352 354 0   33.235712 129.608033 2022-12-08 04:21:07 Nagasaki, Japan
2022-12-06 Japan Nagasaki     241161 353 0   33.235712 129.608033 2022-12-07 04:20:58 Nagasaki, Japan
2022-12-05 Japan Nagasaki     239959 353 0   33.235712 129.608033 2022-12-06 04:21:03 Nagasaki, Japan
2022-12-04 Japan Nagasaki     239672 353 0   33.235712 129.608033 2022-12-05 04:20:58 Nagasaki, Japan
2022-12-03 Japan Nagasaki     239173 353 0   33.235712 129.608033 2022-12-04 04:20:56 Nagasaki, Japan
2022-12-02 Japan Nagasaki     238522 352 0   33.235712 129.608033 2022-12-03 04:21:02 Nagasaki, Japan
2022-12-01 Japan Nagasaki     237798 352 0   33.235712 129.608033 2022-12-02 04:21:07 Nagasaki, Japan
2022-11-30 Japan Nagasaki     237035 352 0   33.235712 129.608033 2022-12-01 04:21:03 Nagasaki, Japan
2022-11-29 Japan Nagasaki     236176 351 0   33.235712 129.608033 2022-11-30 04:21:07 Nagasaki, Japan
2022-11-28 Japan Nagasaki     235129 351 0   33.235712 129.608033 2022-11-29 04:21:05 Nagasaki, Japan
2022-11-27 Japan Nagasaki     234875 349 0   33.235712 129.608033 2022-11-28 04:21:02 Nagasaki, Japan
2022-11-26 Japan Nagasaki     234351 348 0   33.235712 129.608033 2022-11-27 04:21:05 Nagasaki, Japan
2022-11-25 Japan Nagasaki     233672 348 0   33.235712 129.608033 2022-11-26 04:21:11 Nagasaki, Japan
2022-11-24 Japan Nagasaki     232824 348 0   33.235712 129.608033 2022-11-25 04:21:06 Nagasaki, Japan
2022-11-23 Japan Nagasaki     232481 348 0   33.235712 129.608033 2022-11-24 04:21:09 Nagasaki, Japan
2022-11-22 Japan Nagasaki     231711 346 0   33.235712 129.608033 2022-11-23 04:21:06 Nagasaki, Japan
2022-11-21 Japan Nagasaki     230852 345 0   33.235712 129.608033 2022-11-22 04:20:47 Nagasaki, Japan
2022-11-20 Japan Nagasaki     230621 344 0   33.235712 129.608033 2022-11-21 04:21:05 Nagasaki, Japan
2022-11-19 Japan Nagasaki     230178 342 0   33.235712 129.608033 2022-11-20 04:21:08 Nagasaki, Japan
2022-11-18 Japan Nagasaki     229665 340 0   33.235712 129.608033 2022-11-19 04:21:14 Nagasaki, Japan
2022-11-17 Japan Nagasaki     227223 342 0   33.235712 129.608033 2022-11-18 04:21:15 Nagasaki, Japan
2022-11-16 Japan Nagasaki     228584 339 0   33.235712 129.608033 2022-11-17 04:21:11 Nagasaki, Japan
2022-11-15 Japan Nagasaki     227986 339 0   33.235712 129.608033 2022-11-16 04:21:09 Nagasaki, Japan
2022-11-14 Japan Nagasaki     227223 342 0   33.235712 129.608033 2022-11-15 04:21:16 Nagasaki, Japan
2022-11-13 Japan Nagasaki     227003 342 0   33.235712 129.608033 2022-11-14 04:21:09 Nagasaki, Japan
2022-11-12 Japan Nagasaki     226510 342 0   33.235712 129.608033 2022-11-13 04:21:14 Nagasaki, Japan
2022-11-11 Japan Nagasaki     225985 342 0   33.235712 129.608033 2022-11-12 04:20:41 Nagasaki, Japan
2022-11-10 Japan Nagasaki     225469 342 0   33.235712 129.608033 2022-11-11 04:21:22 Nagasaki, Japan
2022-11-09 Japan Nagasaki     224935 342 0   33.235712 129.608033 2022-11-10 04:21:16 Nagasaki, Japan
2022-11-08 Japan Nagasaki     224375 342 0   33.235712 129.608033 2022-11-09 04:21:22 Nagasaki, Japan
2022-11-07 Japan Nagasaki     223699 342 0   33.235712 129.608033 2022-11-08 04:21:21 Nagasaki, Japan
2022-11-06 Japan Nagasaki     223514 342 0   33.235712 129.608033 2022-11-07 04:21:26 Nagasaki, Japan
2022-11-05 Japan Nagasaki     223051 342 0   33.235712 129.608033 2022-11-06 04:21:24 Nagasaki, Japan
2022-11-04 Japan Nagasaki     222390 342 0   33.235712 129.608033 2022-11-05 04:21:52 Nagasaki, Japan
2022-11-03 Japan Nagasaki     222265 342 0   33.235712 129.608033 2022-11-04 04:22:11 Nagasaki, Japan
2022-11-02 Japan Nagasaki     221747 342 0   33.235712 129.608033 2022-11-03 04:22:05 Nagasaki, Japan
2022-11-01 Japan Nagasaki     221212 341 0   33.235712 129.608033 2022-11-02 04:22:09 Nagasaki, Japan
2022-10-31 Japan Nagasaki     220536 340 0   33.235712 129.608033 2022-11-01 04:22:36 Nagasaki, Japan
2022-10-30 Japan Nagasaki     220393 339 0   33.235712 129.608033 2022-10-31 04:21:36 Nagasaki, Japan
2022-10-29 Japan Nagasaki     220058 339 0   33.235712 129.608033 2022-10-30 04:22:14 Nagasaki, Japan
2022-10-28 Japan Nagasaki     219692 339 0   33.235712 129.608033 2022-10-29 04:21:13 Nagasaki, Japan
2022-10-27 Japan Nagasaki     219392 339 0   33.235712 129.608033 2022-10-28 04:22:31 Nagasaki, Japan
2022-10-26 Japan Nagasaki     219019 339 0   33.235712 129.608033 2022-10-27 04:22:01 Nagasaki, Japan
2022-10-25 Japan Nagasaki     218644 338 0   33.235712 129.608033 2022-10-26 04:22:19 Nagasaki, Japan
2022-10-24 Japan Nagasaki     218236 338 0   33.235712 129.608033 2022-10-25 04:21:53 Nagasaki, Japan
2022-10-23 Japan Nagasaki     218145 338 0   33.235712 129.608033 2022-10-24 04:22:29 Nagasaki, Japan
2022-10-22 Japan Nagasaki     217917 338 0   33.235712 129.608033 2022-10-23 04:22:46 Nagasaki, Japan
2022-10-21 Japan Nagasaki     217692 337 0   33.235712 129.608033 2022-10-22 04:22:53 Nagasaki, Japan
2022-10-20 Japan Nagasaki     217478 337 0   33.235712 129.608033 2022-10-21 04:22:23 Nagasaki, Japan
2022-10-19 Japan Nagasaki     217246 337 0   33.235712 129.608033 2022-10-20 04:22:59 Nagasaki, Japan
2022-10-18 Japan Nagasaki     216934 336 0   33.235712 129.608033 2022-10-19 04:22:26 Nagasaki, Japan
2022-10-17 Japan Nagasaki     216574 336 0   33.235712 129.608033 2022-10-18 04:22:42 Nagasaki, Japan
2022-10-16 Japan Nagasaki     216475 335 0   33.235712 129.608033 2022-10-17 04:20:31 Nagasaki, Japan
2022-10-15 Japan Nagasaki     216240 335 0   33.235712 129.608033 2022-10-16 04:22:39 Nagasaki, Japan
2022-10-14 Japan Nagasaki     215976 334 0   33.235712 129.608033 2022-10-15 04:22:00 Nagasaki, Japan
2022-10-13 Japan Nagasaki     215663 334 0   33.235712 129.608033 2022-10-14 04:22:28 Nagasaki, Japan
2022-10-12 Japan Nagasaki     215306 334 0   33.235712 129.608033 2022-10-13 04:22:39 Nagasaki, Japan
2022-10-11 Japan Nagasaki     214952 334 0   33.235712 129.608033 2022-10-12 04:22:51 Nagasaki, Japan
2022-10-10 Japan Nagasaki     214814 334 0   33.235712 129.608033 2022-10-11 04:23:05 Nagasaki, Japan
2022-10-09 Japan Nagasaki     214690 334 0   33.235712 129.608033 2022-10-10 04:22:32 Nagasaki, Japan
2022-10-08 Japan Nagasaki     214543 333 0   33.235712 129.608033 2022-10-09 04:21:16 Nagasaki, Japan
2022-10-07 Japan Nagasaki     214316 333 0   33.235712 129.608033 2022-10-08 04:22:56 Nagasaki, Japan
2022-10-06 Japan Nagasaki     214052 333 0   33.235712 129.608033 2022-10-07 04:23:08 Nagasaki, Japan
2022-10-05 Japan Nagasaki     213759 333 0   33.235712 129.608033 2022-10-06 04:21:22 Nagasaki, Japan
2022-10-04 Japan Nagasaki     213447 333 0   33.235712 129.608033 2022-10-05 04:23:06 Nagasaki, Japan
2022-10-03 Japan Nagasaki     213033 333 0   33.235712 129.608033 2022-10-04 04:22:55 Nagasaki, Japan
2022-10-02 Japan Nagasaki     212896 332 0   33.235712 129.608033 2022-10-03 04:23:11 Nagasaki, Japan
2022-10-01 Japan Nagasaki     212645 331 0   33.235712 129.608033 2022-10-02 04:21:23 Nagasaki, Japan
2022-09-30 Japan Nagasaki     212338 331 0   33.235712 129.608033 2022-10-01 04:23:01 Nagasaki, Japan
2022-09-29 Japan Nagasaki     211992 330 0   33.235712 129.608033 2022-09-30 04:23:09 Nagasaki, Japan
2022-09-28 Japan Nagasaki     211588 328 0   33.235712 129.608033 2022-09-29 04:22:34 Nagasaki, Japan
2022-09-27 Japan Nagasaki     211206 325 0   33.235712 129.608033 2022-09-28 04:23:01 Nagasaki, Japan
2022-09-26 Japan Nagasaki     210825 322 0   33.235712 129.608033 2022-09-27 04:23:01 Nagasaki, Japan
2022-09-25 Japan Nagasaki     210546 322 0   33.235712 129.608033 2022-09-26 04:20:52 Nagasaki, Japan
2022-09-24 Japan Nagasaki     210075 322 0   33.235712 129.608033 2022-09-25 04:23:31 Nagasaki, Japan
2022-09-23 Japan Nagasaki     209802 322 0   33.235712 129.608033 2022-09-24 04:21:40 Nagasaki, Japan
2022-09-22 Japan Nagasaki     209293 322 0   33.235712 129.608033 2022-09-23 04:23:13 Nagasaki, Japan
2022-09-21 Japan Nagasaki     208621 321 0   33.235712 129.608033 2022-09-22 04:22:56 Nagasaki, 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;