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

  • Miyagi · 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 Miyagi     460543 714 0   38.446859 140.927086 2022-12-30 04:21:04 Miyagi, Japan
2022-12-28 Japan Miyagi     456851 698 0   38.446859 140.927086 2022-12-29 04:21:01 Miyagi, Japan
2022-12-27 Japan Miyagi     452976 685 0   38.446859 140.927086 2022-12-28 04:21:04 Miyagi, Japan
2022-12-26 Japan Miyagi     449379 683 0   38.446859 140.927086 2022-12-27 04:21:07 Miyagi, Japan
2022-12-25 Japan Miyagi     447601 673 0   38.446859 140.927086 2022-12-26 04:21:06 Miyagi, Japan
2022-12-24 Japan Miyagi     444555 666 0   38.446859 140.927086 2022-12-25 04:21:04 Miyagi, Japan
2022-12-23 Japan Miyagi     441048 659 0   38.446859 140.927086 2022-12-24 04:21:02 Miyagi, Japan
2022-12-22 Japan Miyagi     437614 652 0   38.446859 140.927086 2022-12-23 04:21:04 Miyagi, Japan
2022-12-21 Japan Miyagi     433876 642 0   38.446859 140.927086 2022-12-22 04:20:56 Miyagi, Japan
2022-12-20 Japan Miyagi     429795 633 0   38.446859 140.927086 2022-12-21 04:21:03 Miyagi, Japan
2022-12-19 Japan Miyagi     426053 631 0   38.446859 140.927086 2022-12-20 04:21:04 Miyagi, Japan
2022-12-18 Japan Miyagi     424313 626 0   38.446859 140.927086 2022-12-19 04:21:03 Miyagi, Japan
2022-12-17 Japan Miyagi     421286 619 0   38.446859 140.927086 2022-12-18 04:21:03 Miyagi, Japan
2022-12-16 Japan Miyagi     417686 612 0   38.446859 140.927086 2022-12-17 04:21:04 Miyagi, Japan
2022-12-15 Japan Miyagi     414129 603 0   38.446859 140.927086 2022-12-16 04:21:01 Miyagi, Japan
2022-12-14 Japan Miyagi     410113 595 0   38.446859 140.927086 2022-12-15 04:20:58 Miyagi, Japan
2022-12-13 Japan Miyagi     405409 589 0   38.446859 140.927086 2022-12-14 04:21:04 Miyagi, Japan
2022-12-12 Japan Miyagi     401092 581 0   38.446859 140.927086 2022-12-13 04:21:01 Miyagi, Japan
2022-12-11 Japan Miyagi     399034 577 0   38.446859 140.927086 2022-12-12 04:21:01 Miyagi, Japan
2022-12-10 Japan Miyagi     395875 573 0   38.446859 140.927086 2022-12-11 04:20:50 Miyagi, Japan
2022-12-09 Japan Miyagi     392309 572 0   38.446859 140.927086 2022-12-10 04:21:02 Miyagi, Japan
2022-12-08 Japan Miyagi     388814 565 0   38.446859 140.927086 2022-12-09 04:21:05 Miyagi, Japan
2022-12-07 Japan Miyagi     385005 554 0   38.446859 140.927086 2022-12-08 04:21:07 Miyagi, Japan
2022-12-06 Japan Miyagi     380826 552 0   38.446859 140.927086 2022-12-07 04:20:58 Miyagi, Japan
2022-12-05 Japan Miyagi     376951 548 0   38.446859 140.927086 2022-12-06 04:21:03 Miyagi, Japan
2022-12-04 Japan Miyagi     375232 545 0   38.446859 140.927086 2022-12-05 04:20:58 Miyagi, Japan
2022-12-03 Japan Miyagi     372566 542 0   38.446859 140.927086 2022-12-04 04:20:56 Miyagi, Japan
2022-12-02 Japan Miyagi     369266 535 0   38.446859 140.927086 2022-12-03 04:21:02 Miyagi, Japan
2022-12-01 Japan Miyagi     365714 523 0   38.446859 140.927086 2022-12-02 04:21:07 Miyagi, Japan
2022-11-30 Japan Miyagi     362004 518 0   38.446859 140.927086 2022-12-01 04:21:03 Miyagi, Japan
2022-11-29 Japan Miyagi     357597 511 0   38.446859 140.927086 2022-11-30 04:21:07 Miyagi, Japan
2022-11-28 Japan Miyagi     353765 507 0   38.446859 140.927086 2022-11-29 04:21:05 Miyagi, Japan
2022-11-27 Japan Miyagi     351996 506 0   38.446859 140.927086 2022-11-28 04:21:02 Miyagi, Japan
2022-11-26 Japan Miyagi     348449 501 0   38.446859 140.927086 2022-11-27 04:21:05 Miyagi, Japan
2022-11-25 Japan Miyagi     344476 495 0   38.446859 140.927086 2022-11-26 04:21:11 Miyagi, Japan
2022-11-24 Japan Miyagi     341087 489 0   38.446859 140.927086 2022-11-25 04:21:06 Miyagi, Japan
2022-11-23 Japan Miyagi     338361 483 0   38.446859 140.927086 2022-11-24 04:21:09 Miyagi, Japan
2022-11-22 Japan Miyagi     333922 478 0   38.446859 140.927086 2022-11-23 04:21:06 Miyagi, Japan
2022-11-21 Japan Miyagi     330112 476 0   38.446859 140.927086 2022-11-22 04:20:47 Miyagi, Japan
2022-11-20 Japan Miyagi     328421 470 0   38.446859 140.927086 2022-11-21 04:21:05 Miyagi, Japan
2022-11-19 Japan Miyagi     325807 461 0   38.446859 140.927086 2022-11-20 04:21:08 Miyagi, Japan
2022-11-18 Japan Miyagi     322863 458 0   38.446859 140.927086 2022-11-19 04:21:14 Miyagi, Japan
2022-11-17 Japan Miyagi     320099 454 0   38.446859 140.927086 2022-11-18 04:21:15 Miyagi, Japan
2022-11-16 Japan Miyagi     316905 452 0   38.446859 140.927086 2022-11-17 04:21:11 Miyagi, Japan
2022-11-15 Japan Miyagi     313509 451 0   38.446859 140.927086 2022-11-16 04:21:09 Miyagi, Japan
2022-11-14 Japan Miyagi     310560 450 0   38.446859 140.927086 2022-11-15 04:21:16 Miyagi, Japan
2022-11-13 Japan Miyagi     309090 447 0   38.446859 140.927086 2022-11-14 04:21:09 Miyagi, Japan
2022-11-12 Japan Miyagi     306897 446 0   38.446859 140.927086 2022-11-13 04:21:14 Miyagi, Japan
2022-11-11 Japan Miyagi     304495 445 0   38.446859 140.927086 2022-11-12 04:20:41 Miyagi, Japan
2022-11-10 Japan Miyagi     302252 443 0   38.446859 140.927086 2022-11-11 04:21:22 Miyagi, Japan
2022-11-09 Japan Miyagi     299719 440 0   38.446859 140.927086 2022-11-10 04:21:16 Miyagi, Japan
2022-11-08 Japan Miyagi     297010 437 0   38.446859 140.927086 2022-11-09 04:21:22 Miyagi, Japan
2022-11-07 Japan Miyagi     294825 432 0   38.446859 140.927086 2022-11-08 04:21:21 Miyagi, Japan
2022-11-06 Japan Miyagi     293714 431 0   38.446859 140.927086 2022-11-07 04:21:26 Miyagi, Japan
2022-11-05 Japan Miyagi     291612 428 0   38.446859 140.927086 2022-11-06 04:21:24 Miyagi, Japan
2022-11-04 Japan Miyagi     289389 427 0   38.446859 140.927086 2022-11-05 04:21:52 Miyagi, Japan
2022-11-03 Japan Miyagi     288242 423 0   38.446859 140.927086 2022-11-04 04:22:11 Miyagi, Japan
2022-11-02 Japan Miyagi     286226 421 0   38.446859 140.927086 2022-11-03 04:22:05 Miyagi, Japan
2022-11-01 Japan Miyagi     284200 418 0   38.446859 140.927086 2022-11-02 04:22:09 Miyagi, Japan
2022-10-31 Japan Miyagi     282632 418 0   38.446859 140.927086 2022-11-01 04:22:36 Miyagi, Japan
2022-10-30 Japan Miyagi     281816 417 0   38.446859 140.927086 2022-10-31 04:21:36 Miyagi, Japan
2022-10-29 Japan Miyagi     280738 414 0   38.446859 140.927086 2022-10-30 04:22:14 Miyagi, Japan
2022-10-28 Japan Miyagi     279593 409 0   38.446859 140.927086 2022-10-29 04:21:13 Miyagi, Japan
2022-10-27 Japan Miyagi     278686 409 0   38.446859 140.927086 2022-10-28 04:22:31 Miyagi, Japan
2022-10-26 Japan Miyagi     277627 408 0   38.446859 140.927086 2022-10-27 04:22:01 Miyagi, Japan
2022-10-25 Japan Miyagi     276512 407 0   38.446859 140.927086 2022-10-26 04:22:19 Miyagi, Japan
2022-10-24 Japan Miyagi     275560 407 0   38.446859 140.927086 2022-10-25 04:21:53 Miyagi, Japan
2022-10-23 Japan Miyagi     275080 407 0   38.446859 140.927086 2022-10-24 04:22:29 Miyagi, Japan
2022-10-22 Japan Miyagi     274372 406 0   38.446859 140.927086 2022-10-23 04:22:46 Miyagi, Japan
2022-10-21 Japan Miyagi     273547 406 0   38.446859 140.927086 2022-10-22 04:22:53 Miyagi, Japan
2022-10-20 Japan Miyagi     272884 406 0   38.446859 140.927086 2022-10-21 04:22:23 Miyagi, Japan
2022-10-19 Japan Miyagi     272087 405 0   38.446859 140.927086 2022-10-20 04:22:59 Miyagi, Japan
2022-10-18 Japan Miyagi     271122 405 0   38.446859 140.927086 2022-10-19 04:22:26 Miyagi, Japan
2022-10-17 Japan Miyagi     270302 405 0   38.446859 140.927086 2022-10-18 04:22:42 Miyagi, Japan
2022-10-16 Japan Miyagi     269920 405 0   38.446859 140.927086 2022-10-17 04:20:31 Miyagi, Japan
2022-10-15 Japan Miyagi     269287 405 0   38.446859 140.927086 2022-10-16 04:22:39 Miyagi, Japan
2022-10-14 Japan Miyagi     268427 405 0   38.446859 140.927086 2022-10-15 04:22:00 Miyagi, Japan
2022-10-13 Japan Miyagi     267656 403 0   38.446859 140.927086 2022-10-14 04:22:28 Miyagi, Japan
2022-10-12 Japan Miyagi     266678 403 0   38.446859 140.927086 2022-10-13 04:22:39 Miyagi, Japan
2022-10-11 Japan Miyagi     265742 403 0   38.446859 140.927086 2022-10-12 04:22:51 Miyagi, Japan
2022-10-10 Japan Miyagi     265445 402 0   38.446859 140.927086 2022-10-11 04:23:05 Miyagi, Japan
2022-10-09 Japan Miyagi     265096 402 0   38.446859 140.927086 2022-10-10 04:22:32 Miyagi, Japan
2022-10-08 Japan Miyagi     264645 400 0   38.446859 140.927086 2022-10-09 04:21:16 Miyagi, Japan
2022-10-07 Japan Miyagi     264143 400 0   38.446859 140.927086 2022-10-08 04:22:56 Miyagi, Japan
2022-10-06 Japan Miyagi     263599 400 0   38.446859 140.927086 2022-10-07 04:23:08 Miyagi, Japan
2022-10-05 Japan Miyagi     262906 399 0   38.446859 140.927086 2022-10-06 04:21:22 Miyagi, Japan
2022-10-04 Japan Miyagi     262088 397 0   38.446859 140.927086 2022-10-05 04:23:06 Miyagi, Japan
2022-10-03 Japan Miyagi     261391 397 0   38.446859 140.927086 2022-10-04 04:22:55 Miyagi, Japan
2022-10-02 Japan Miyagi     261023 396 0   38.446859 140.927086 2022-10-03 04:23:11 Miyagi, Japan
2022-10-01 Japan Miyagi     260390 395 0   38.446859 140.927086 2022-10-02 04:21:23 Miyagi, Japan
2022-09-30 Japan Miyagi     259671 394 0   38.446859 140.927086 2022-10-01 04:23:01 Miyagi, Japan
2022-09-29 Japan Miyagi     259015 394 0   38.446859 140.927086 2022-09-30 04:23:09 Miyagi, Japan
2022-09-28 Japan Miyagi     258134 392 0   38.446859 140.927086 2022-09-29 04:22:34 Miyagi, Japan
2022-09-27 Japan Miyagi     257027 391 0   38.446859 140.927086 2022-09-28 04:23:01 Miyagi, Japan
2022-09-26 Japan Miyagi     256207 390 0   38.446859 140.927086 2022-09-27 04:23:01 Miyagi, Japan
2022-09-25 Japan Miyagi     255693 389 0   38.446859 140.927086 2022-09-26 04:20:52 Miyagi, Japan
2022-09-24 Japan Miyagi     254835 387 0   38.446859 140.927086 2022-09-25 04:23:31 Miyagi, Japan
2022-09-23 Japan Miyagi     254510 386 0   38.446859 140.927086 2022-09-24 04:21:40 Miyagi, Japan
2022-09-22 Japan Miyagi     253649 382 0   38.446859 140.927086 2022-09-23 04:23:13 Miyagi, Japan
2022-09-21 Japan Miyagi     252614 381 0   38.446859 140.927086 2022-09-22 04:22:56 Miyagi, 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;