daily_reports (view)
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-20 | Japan | Hiroshima | 417080 | 736 | 0 | 34.605309 | 132.788719 | 2022-09-21 04:23:22 | Hiroshima, Japan | |||
2022-09-19 | Japan | Hiroshima | 416183 | 736 | 0 | 34.605309 | 132.788719 | 2022-09-20 04:22:48 | Hiroshima, Japan | |||
2022-09-18 | Japan | Hiroshima | 414749 | 736 | 0 | 34.605309 | 132.788719 | 2022-09-19 04:21:49 | Hiroshima, Japan | |||
2022-09-17 | Japan | Hiroshima | 412851 | 732 | 0 | 34.605309 | 132.788719 | 2022-09-18 04:22:50 | Hiroshima, Japan | |||
2022-09-16 | Japan | Hiroshima | 410974 | 728 | 0 | 34.605309 | 132.788719 | 2022-09-17 04:20:19 | Hiroshima, Japan | |||
2022-09-15 | Japan | Hiroshima | 408608 | 723 | 0 | 34.605309 | 132.788719 | 2022-09-16 04:21:19 | Hiroshima, Japan | |||
2022-09-14 | Japan | Hiroshima | 405703 | 715 | 0 | 34.605309 | 132.788719 | 2022-09-15 04:21:02 | Hiroshima, Japan | |||
2022-09-13 | Japan | Hiroshima | 402608 | 710 | 0 | 34.605309 | 132.788719 | 2022-09-14 04:20:44 | Hiroshima, Japan | |||
2022-09-12 | Japan | Hiroshima | 401009 | 702 | 0 | 34.605309 | 132.788719 | 2022-09-13 04:20:57 | Hiroshima, Japan | |||
2022-09-11 | Japan | Hiroshima | 399205 | 702 | 0 | 34.605309 | 132.788719 | 2022-09-12 04:20:58 | Hiroshima, Japan | |||
2022-09-10 | Japan | Hiroshima | 396601 | 700 | 0 | 34.605309 | 132.788719 | 2022-09-11 04:20:50 | Hiroshima, Japan | |||
2022-09-09 | Japan | Hiroshima | 394196 | 691 | 0 | 34.605309 | 132.788719 | 2022-09-10 04:21:10 | Hiroshima, Japan | |||
2022-09-08 | Japan | Hiroshima | 391534 | 690 | 0 | 34.605309 | 132.788719 | 2022-09-09 04:21:11 | Hiroshima, Japan | |||
2022-09-07 | Japan | Hiroshima | 388158 | 689 | 0 | 34.605309 | 132.788719 | 2022-09-08 04:21:02 | Hiroshima, Japan | |||
2022-09-06 | Japan | Hiroshima | 384545 | 687 | 0 | 34.605309 | 132.788719 | 2022-09-07 04:20:59 | Hiroshima, Japan | |||
2022-09-05 | Japan | Hiroshima | 382460 | 673 | 0 | 34.605309 | 132.788719 | 2022-09-06 04:21:02 | Hiroshima, Japan | |||
2022-09-04 | Japan | Hiroshima | 380081 | 672 | 0 | 34.605309 | 132.788719 | 2022-09-05 04:21:01 | Hiroshima, Japan | |||
2022-09-03 | Japan | Hiroshima | 376811 | 665 | 0 | 34.605309 | 132.788719 | 2022-09-04 04:21:22 | Hiroshima, Japan | |||
2022-09-02 | Japan | Hiroshima | 373583 | 656 | 0 | 34.605309 | 132.788719 | 2022-09-03 04:21:04 | Hiroshima, Japan | |||
2022-09-01 | Japan | Hiroshima | 369549 | 651 | 0 | 34.605309 | 132.788719 | 2022-09-02 04:21:07 | Hiroshima, Japan | |||
2022-08-31 | Japan | Hiroshima | 364778 | 649 | 0 | 34.605309 | 132.788719 | 2022-09-01 04:21:03 | Hiroshima, Japan | |||
2022-08-30 | Japan | Hiroshima | 359699 | 645 | 0 | 34.605309 | 132.788719 | 2022-08-31 04:20:57 | Hiroshima, Japan | |||
2022-08-29 | Japan | Hiroshima | 356811 | 638 | 0 | 34.605309 | 132.788719 | 2022-08-30 04:21:03 | Hiroshima, Japan | |||
2022-08-28 | Japan | Hiroshima | 353284 | 635 | 0 | 34.605309 | 132.788719 | 2022-08-29 04:21:06 | Hiroshima, Japan | |||
2022-08-27 | Japan | Hiroshima | 347746 | 631 | 0 | 34.605309 | 132.788719 | 2022-08-28 04:21:02 | Hiroshima, Japan | |||
2022-08-26 | Japan | Hiroshima | 343249 | 626 | 0 | 34.605309 | 132.788719 | 2022-08-27 04:20:57 | Hiroshima, Japan | |||
2022-08-25 | Japan | Hiroshima | 337448 | 620 | 0 | 34.605309 | 132.788719 | 2022-08-26 04:21:02 | Hiroshima, Japan | |||
2022-08-24 | Japan | Hiroshima | 330685 | 617 | 0 | 34.605309 | 132.788719 | 2022-08-25 04:21:13 | Hiroshima, Japan | |||
2022-08-23 | Japan | Hiroshima | 323277 | 612 | 0 | 34.605309 | 132.788719 | 2022-08-24 04:20:46 | Hiroshima, Japan | |||
2022-08-22 | Japan | Hiroshima | 319606 | 604 | 0 | 34.605309 | 132.788719 | 2022-08-23 04:20:56 | Hiroshima, Japan | |||
2022-08-21 | Japan | Hiroshima | 314481 | 601 | 0 | 34.605309 | 132.788719 | 2022-08-22 04:20:38 | Hiroshima, Japan | |||
2022-08-20 | Japan | Hiroshima | 307188 | 597 | 0 | 34.605309 | 132.788719 | 2022-08-21 04:20:44 | Hiroshima, Japan | |||
2022-08-19 | Japan | Hiroshima | 300302 | 592 | 0 | 34.605309 | 132.788719 | 2022-08-20 04:21:01 | Hiroshima, Japan | |||
2022-08-18 | Japan | Hiroshima | 291529 | 586 | 0 | 34.605309 | 132.788719 | 2022-08-19 04:20:54 | Hiroshima, Japan | |||
2022-08-17 | Japan | Hiroshima | 284770 | 582 | 0 | 34.605309 | 132.788719 | 2022-08-18 04:21:11 | Hiroshima, Japan | |||
2022-08-16 | Japan | Hiroshima | 280516 | 571 | 0 | 34.605309 | 132.788719 | 2022-08-17 04:20:59 | Hiroshima, Japan | |||
2022-08-15 | Japan | Hiroshima | 277640 | 564 | 0 | 34.605309 | 132.788719 | 2022-08-16 04:20:58 | Hiroshima, Japan | |||
2022-08-14 | Japan | Hiroshima | 273721 | 557 | 0 | 34.605309 | 132.788719 | 2022-08-15 04:20:59 | Hiroshima, Japan | |||
2022-08-13 | Japan | Hiroshima | 268117 | 550 | 0 | 34.605309 | 132.788719 | 2022-08-14 04:20:55 | Hiroshima, Japan | |||
2022-08-12 | Japan | Hiroshima | 264865 | 548 | 0 | 34.605309 | 132.788719 | 2022-08-13 04:20:52 | Hiroshima, Japan | |||
2022-08-11 | Japan | Hiroshima | 259835 | 545 | 0 | 34.605309 | 132.788719 | 2022-08-12 04:20:54 | Hiroshima, Japan | |||
2022-08-10 | Japan | Hiroshima | 253552 | 543 | 0 | 34.605309 | 132.788719 | 2022-08-11 04:20:49 | Hiroshima, Japan | |||
2022-08-09 | Japan | Hiroshima | 248181 | 542 | 0 | 34.605309 | 132.788719 | 2022-08-10 04:20:57 | Hiroshima, Japan | |||
2022-08-08 | Japan | Hiroshima | 245042 | 537 | 0 | 34.605309 | 132.788719 | 2022-08-09 04:20:34 | Hiroshima, Japan | |||
2022-08-07 | Japan | Hiroshima | 241699 | 535 | 0 | 34.605309 | 132.788719 | 2022-08-08 04:21:08 | Hiroshima, Japan | |||
2022-08-06 | Japan | Hiroshima | 235670 | 532 | 0 | 34.605309 | 132.788719 | 2022-08-07 04:20:54 | Hiroshima, Japan | |||
2022-08-05 | Japan | Hiroshima | 231214 | 531 | 0 | 34.605309 | 132.788719 | 2022-08-06 04:20:56 | Hiroshima, Japan | |||
2022-08-04 | Japan | Hiroshima | 227241 | 527 | 0 | 34.605309 | 132.788719 | 2022-08-05 04:20:52 | Hiroshima, Japan | |||
2022-08-03 | Japan | Hiroshima | 222886 | 524 | 0 | 34.605309 | 132.788719 | 2022-08-04 04:20:58 | Hiroshima, Japan | |||
2022-08-02 | Japan | Hiroshima | 219338 | 521 | 0 | 34.605309 | 132.788719 | 2022-08-03 04:20:59 | Hiroshima, Japan | |||
2022-08-01 | Japan | Hiroshima | 216590 | 517 | 0 | 34.605309 | 132.788719 | 2022-08-02 04:20:53 | Hiroshima, Japan | |||
2022-07-31 | Japan | Hiroshima | 213387 | 517 | 0 | 34.605309 | 132.788719 | 2022-08-01 04:21:03 | Hiroshima, Japan | |||
2022-07-30 | Japan | Hiroshima | 210829 | 517 | 0 | 34.605309 | 132.788719 | 2022-07-31 04:21:02 | Hiroshima, Japan | |||
2022-07-29 | Japan | Hiroshima | 207559 | 516 | 0 | 34.605309 | 132.788719 | 2022-07-30 04:20:42 | Hiroshima, Japan | |||
2022-07-28 | Japan | Hiroshima | 204716 | 516 | 0 | 34.605309 | 132.788719 | 2022-07-29 04:20:45 | Hiroshima, Japan | |||
2022-07-27 | Japan | Hiroshima | 201842 | 514 | 0 | 34.605309 | 132.788719 | 2022-07-28 04:20:56 | Hiroshima, Japan | |||
2022-07-26 | Japan | Hiroshima | 198897 | 513 | 0 | 34.605309 | 132.788719 | 2022-07-27 04:21:04 | Hiroshima, Japan | |||
2022-07-25 | Japan | Hiroshima | 196687 | 509 | 0 | 34.605309 | 132.788719 | 2022-07-26 04:20:58 | Hiroshima, Japan | |||
2022-07-24 | Japan | Hiroshima | 194641 | 508 | 0 | 34.605309 | 132.788719 | 2022-07-25 04:20:51 | Hiroshima, Japan | |||
2022-07-23 | Japan | Hiroshima | 192437 | 508 | 0 | 34.605309 | 132.788719 | 2022-07-24 04:20:47 | Hiroshima, Japan | |||
2022-07-22 | Japan | Hiroshima | 190086 | 507 | 0 | 34.605309 | 132.788719 | 2022-07-23 04:20:53 | Hiroshima, Japan | |||
2022-07-21 | Japan | Hiroshima | 187538 | 507 | 0 | 34.605309 | 132.788719 | 2022-07-22 04:21:15 | Hiroshima, Japan | |||
2022-07-20 | Japan | Hiroshima | 185194 | 503 | 0 | 34.605309 | 132.788719 | 2022-07-21 04:21:10 | Hiroshima, Japan | |||
2022-07-19 | Japan | Hiroshima | 183788 | 502 | 0 | 34.605309 | 132.788719 | 2022-07-20 04:20:59 | Hiroshima, Japan | |||
2022-07-18 | Japan | Hiroshima | 182972 | 500 | 0 | 34.605309 | 132.788719 | 2022-07-19 04:20:58 | Hiroshima, Japan | |||
2022-07-17 | Japan | Hiroshima | 181960 | 500 | 0 | 34.605309 | 132.788719 | 2022-07-18 04:20:59 | Hiroshima, Japan | |||
2022-07-16 | Japan | Hiroshima | 180642 | 500 | 0 | 34.605309 | 132.788719 | 2022-07-17 04:21:15 | Hiroshima, Japan | |||
2022-07-15 | Japan | Hiroshima | 179300 | 499 | 0 | 34.605309 | 132.788719 | 2022-07-16 04:21:05 | Hiroshima, Japan | |||
2022-07-14 | Japan | Hiroshima | 178004 | 499 | 0 | 34.605309 | 132.788719 | 2022-07-15 04:20:53 | Hiroshima, Japan | |||
2022-07-13 | Japan | Hiroshima | 176733 | 497 | 0 | 34.605309 | 132.788719 | 2022-07-14 04:20:57 | Hiroshima, Japan | |||
2022-07-12 | Japan | Hiroshima | 175481 | 496 | 0 | 34.605309 | 132.788719 | 2022-07-13 04:20:58 | Hiroshima, Japan | |||
2022-07-11 | Japan | Hiroshima | 174673 | 496 | 0 | 34.605309 | 132.788719 | 2022-07-12 04:20:51 | Hiroshima, Japan | |||
2022-07-10 | Japan | Hiroshima | 174218 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-11 04:20:46 | Hiroshima, Japan | |||
2022-07-09 | Japan | Hiroshima | 173554 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-10 04:20:54 | Hiroshima, Japan | |||
2022-07-08 | Japan | Hiroshima | 172893 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-09 04:20:59 | Hiroshima, Japan | |||
2022-07-07 | Japan | Hiroshima | 172307 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-08 04:20:56 | Hiroshima, Japan | |||
2022-07-06 | Japan | Hiroshima | 171667 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-07 04:20:55 | Hiroshima, Japan | |||
2022-07-05 | Japan | Hiroshima | 171004 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-06 04:20:58 | Hiroshima, Japan | |||
2022-07-04 | Japan | Hiroshima | 170645 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-05 04:20:45 | Hiroshima, Japan | |||
2022-07-03 | Japan | Hiroshima | 170317 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-04 04:20:54 | Hiroshima, Japan | |||
2022-07-02 | Japan | Hiroshima | 169892 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-03 04:20:59 | Hiroshima, Japan | |||
2022-07-01 | Japan | Hiroshima | 169466 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-02 04:21:16 | Hiroshima, Japan | |||
2022-06-30 | Japan | Hiroshima | 169082 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-01 04:21:10 | Hiroshima, Japan | |||
2022-06-29 | Japan | Hiroshima | 168625 | 495 | 0 | 34.605309 | 132.788719 | 2022-06-30 04:21:01 | Hiroshima, Japan | |||
2022-06-28 | Japan | Hiroshima | 168145 | 495 | 0 | 34.605309 | 132.788719 | 2022-06-29 04:20:59 | Hiroshima, Japan | |||
2022-06-27 | Japan | Hiroshima | 167836 | 495 | 0 | 34.605309 | 132.788719 | 2022-06-28 04:20:58 | Hiroshima, Japan | |||
2022-06-26 | Japan | Hiroshima | 167620 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-27 04:21:00 | Hiroshima, Japan | |||
2022-06-25 | Japan | Hiroshima | 167299 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-26 04:21:02 | Hiroshima, Japan | |||
2022-06-24 | Japan | Hiroshima | 166967 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-25 04:20:57 | Hiroshima, Japan | |||
2022-06-23 | Japan | Hiroshima | 166663 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-24 04:20:58 | Hiroshima, Japan | |||
2022-06-22 | Japan | Hiroshima | 166324 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-23 04:20:55 | Hiroshima, Japan | |||
2022-06-21 | Japan | Hiroshima | 165920 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-22 04:20:54 | Hiroshima, Japan | |||
2022-06-20 | Japan | Hiroshima | 165644 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-21 04:20:56 | Hiroshima, Japan | |||
2022-06-19 | Japan | Hiroshima | 165426 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-20 04:21:01 | Hiroshima, Japan | |||
2022-06-18 | Japan | Hiroshima | 165089 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-19 04:20:51 | Hiroshima, Japan | |||
2022-06-17 | Japan | Hiroshima | 164752 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-18 04:21:10 | Hiroshima, Japan | |||
2022-06-16 | Japan | Hiroshima | 164356 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-17 04:20:56 | Hiroshima, Japan | |||
2022-06-15 | Japan | Hiroshima | 163975 | 493 | 0 | 34.605309 | 132.788719 | 2022-06-16 04:20:55 | Hiroshima, Japan | |||
2022-06-14 | Japan | Hiroshima | 163554 | 493 | 0 | 34.605309 | 132.788719 | 2022-06-15 04:20:54 | Hiroshima, Japan | |||
2022-06-13 | Japan | Hiroshima | 163242 | 490 | 0 | 34.605309 | 132.788719 | 2022-06-14 04:20:52 | Hiroshima, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;