johns_hopkins_csse_daily_reports
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)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016718 | 2016718 | 2022-09-20 | Japan | Hiroshima | 417080 | 736 | 0 | 34.605309 | 132.788719 | 2022-09-21 04:23:22 | Hiroshima, Japan | |||
3570591 | 3570591 | 2022-09-19 | Japan | Hiroshima | 416183 | 736 | 0 | 34.605309 | 132.788719 | 2022-09-20 04:22:48 | Hiroshima, Japan | |||
419330 | 419330 | 2022-09-18 | Japan | Hiroshima | 414749 | 736 | 0 | 34.605309 | 132.788719 | 2022-09-19 04:21:49 | Hiroshima, Japan | |||
3373354 | 3373354 | 2022-09-17 | Japan | Hiroshima | 412851 | 732 | 0 | 34.605309 | 132.788719 | 2022-09-18 04:22:50 | Hiroshima, Japan | |||
2355462 | 2355462 | 2022-09-16 | Japan | Hiroshima | 410974 | 728 | 0 | 34.605309 | 132.788719 | 2022-09-17 04:20:19 | Hiroshima, Japan | |||
3986619 | 3986619 | 2022-09-15 | Japan | Hiroshima | 408608 | 723 | 0 | 34.605309 | 132.788719 | 2022-09-16 04:21:19 | Hiroshima, Japan | |||
1889136 | 1889136 | 2022-09-14 | Japan | Hiroshima | 405703 | 715 | 0 | 34.605309 | 132.788719 | 2022-09-15 04:21:02 | Hiroshima, Japan | |||
372191 | 372191 | 2022-09-13 | Japan | Hiroshima | 402608 | 710 | 0 | 34.605309 | 132.788719 | 2022-09-14 04:20:44 | Hiroshima, Japan | |||
2394796 | 2394796 | 2022-09-12 | Japan | Hiroshima | 401009 | 702 | 0 | 34.605309 | 132.788719 | 2022-09-13 04:20:57 | Hiroshima, Japan | |||
3765874 | 3765874 | 2022-09-11 | Japan | Hiroshima | 399205 | 702 | 0 | 34.605309 | 132.788719 | 2022-09-12 04:20:58 | Hiroshima, Japan | |||
3824449 | 3824449 | 2022-09-10 | Japan | Hiroshima | 396601 | 700 | 0 | 34.605309 | 132.788719 | 2022-09-11 04:20:50 | Hiroshima, Japan | |||
962906 | 962906 | 2022-09-09 | Japan | Hiroshima | 394196 | 691 | 0 | 34.605309 | 132.788719 | 2022-09-10 04:21:10 | Hiroshima, Japan | |||
253308 | 253308 | 2022-09-08 | Japan | Hiroshima | 391534 | 690 | 0 | 34.605309 | 132.788719 | 2022-09-09 04:21:11 | Hiroshima, Japan | |||
3745106 | 3745106 | 2022-09-07 | Japan | Hiroshima | 388158 | 689 | 0 | 34.605309 | 132.788719 | 2022-09-08 04:21:02 | Hiroshima, Japan | |||
114746 | 114746 | 2022-09-06 | Japan | Hiroshima | 384545 | 687 | 0 | 34.605309 | 132.788719 | 2022-09-07 04:20:59 | Hiroshima, Japan | |||
2633718 | 2633718 | 2022-09-05 | Japan | Hiroshima | 382460 | 673 | 0 | 34.605309 | 132.788719 | 2022-09-06 04:21:02 | Hiroshima, Japan | |||
2987282 | 2987282 | 2022-09-04 | Japan | Hiroshima | 380081 | 672 | 0 | 34.605309 | 132.788719 | 2022-09-05 04:21:01 | Hiroshima, Japan | |||
2712967 | 2712967 | 2022-09-03 | Japan | Hiroshima | 376811 | 665 | 0 | 34.605309 | 132.788719 | 2022-09-04 04:21:22 | Hiroshima, Japan | |||
1393672 | 1393672 | 2022-09-02 | Japan | Hiroshima | 373583 | 656 | 0 | 34.605309 | 132.788719 | 2022-09-03 04:21:04 | Hiroshima, Japan | |||
3547501 | 3547501 | 2022-09-01 | Japan | Hiroshima | 369549 | 651 | 0 | 34.605309 | 132.788719 | 2022-09-02 04:21:07 | Hiroshima, Japan | |||
2343421 | 2343421 | 2022-08-31 | Japan | Hiroshima | 364778 | 649 | 0 | 34.605309 | 132.788719 | 2022-09-01 04:21:03 | Hiroshima, Japan | |||
3773901 | 3773901 | 2022-08-30 | Japan | Hiroshima | 359699 | 645 | 0 | 34.605309 | 132.788719 | 2022-08-31 04:20:57 | Hiroshima, Japan | |||
1680497 | 1680497 | 2022-08-29 | Japan | Hiroshima | 356811 | 638 | 0 | 34.605309 | 132.788719 | 2022-08-30 04:21:03 | Hiroshima, Japan | |||
1876981 | 1876981 | 2022-08-28 | Japan | Hiroshima | 353284 | 635 | 0 | 34.605309 | 132.788719 | 2022-08-29 04:21:06 | Hiroshima, Japan | |||
2096108 | 2096108 | 2022-08-27 | Japan | Hiroshima | 347746 | 631 | 0 | 34.605309 | 132.788719 | 2022-08-28 04:21:02 | Hiroshima, Japan | |||
1531923 | 1531923 | 2022-08-26 | Japan | Hiroshima | 343249 | 626 | 0 | 34.605309 | 132.788719 | 2022-08-27 04:20:57 | Hiroshima, Japan | |||
2828810 | 2828810 | 2022-08-25 | Japan | Hiroshima | 337448 | 620 | 0 | 34.605309 | 132.788719 | 2022-08-26 04:21:02 | Hiroshima, Japan | |||
2323343 | 2323343 | 2022-08-24 | Japan | Hiroshima | 330685 | 617 | 0 | 34.605309 | 132.788719 | 2022-08-25 04:21:13 | Hiroshima, Japan | |||
1250752 | 1250752 | 2022-08-23 | Japan | Hiroshima | 323277 | 612 | 0 | 34.605309 | 132.788719 | 2022-08-24 04:20:46 | Hiroshima, Japan | |||
2852856 | 2852856 | 2022-08-22 | Japan | Hiroshima | 319606 | 604 | 0 | 34.605309 | 132.788719 | 2022-08-23 04:20:56 | Hiroshima, Japan | |||
2402828 | 2402828 | 2022-08-21 | Japan | Hiroshima | 314481 | 601 | 0 | 34.605309 | 132.788719 | 2022-08-22 04:20:38 | Hiroshima, Japan | |||
3797906 | 3797906 | 2022-08-20 | Japan | Hiroshima | 307188 | 597 | 0 | 34.605309 | 132.788719 | 2022-08-21 04:20:44 | Hiroshima, Japan | |||
2363492 | 2363492 | 2022-08-19 | Japan | Hiroshima | 300302 | 592 | 0 | 34.605309 | 132.788719 | 2022-08-20 04:21:01 | Hiroshima, Japan | |||
1161163 | 1161163 | 2022-08-18 | Japan | Hiroshima | 291529 | 586 | 0 | 34.605309 | 132.788719 | 2022-08-19 04:20:54 | Hiroshima, Japan | |||
3950487 | 3950487 | 2022-08-17 | Japan | Hiroshima | 284770 | 582 | 0 | 34.605309 | 132.788719 | 2022-08-18 04:21:11 | Hiroshima, Japan | |||
990989 | 990989 | 2022-08-16 | Japan | Hiroshima | 280516 | 571 | 0 | 34.605309 | 132.788719 | 2022-08-17 04:20:59 | Hiroshima, Japan | |||
2494028 | 2494028 | 2022-08-15 | Japan | Hiroshima | 277640 | 564 | 0 | 34.605309 | 132.788719 | 2022-08-16 04:20:58 | Hiroshima, Japan | |||
3647578 | 3647578 | 2022-08-14 | Japan | Hiroshima | 273721 | 557 | 0 | 34.605309 | 132.788719 | 2022-08-15 04:20:59 | Hiroshima, Japan | |||
1968584 | 1968584 | 2022-08-13 | Japan | Hiroshima | 268117 | 550 | 0 | 34.605309 | 132.788719 | 2022-08-14 04:20:55 | Hiroshima, Japan | |||
2888393 | 2888393 | 2022-08-12 | Japan | Hiroshima | 264865 | 548 | 0 | 34.605309 | 132.788719 | 2022-08-13 04:20:52 | Hiroshima, Japan | |||
3907998 | 3907998 | 2022-08-11 | Japan | Hiroshima | 259835 | 545 | 0 | 34.605309 | 132.788719 | 2022-08-12 04:20:54 | Hiroshima, Japan | |||
1346315 | 1346315 | 2022-08-10 | Japan | Hiroshima | 253552 | 543 | 0 | 34.605309 | 132.788719 | 2022-08-11 04:20:49 | Hiroshima, Japan | |||
1086070 | 1086070 | 2022-08-09 | Japan | Hiroshima | 248181 | 542 | 0 | 34.605309 | 132.788719 | 2022-08-10 04:20:57 | Hiroshima, Japan | |||
3543485 | 3543485 | 2022-08-08 | Japan | Hiroshima | 245042 | 537 | 0 | 34.605309 | 132.788719 | 2022-08-09 04:20:34 | Hiroshima, Japan | |||
1069888 | 1069888 | 2022-08-07 | Japan | Hiroshima | 241699 | 535 | 0 | 34.605309 | 132.788719 | 2022-08-08 04:21:08 | Hiroshima, Japan | |||
1940476 | 1940476 | 2022-08-06 | Japan | Hiroshima | 235670 | 532 | 0 | 34.605309 | 132.788719 | 2022-08-07 04:20:54 | Hiroshima, Japan | |||
880275 | 880275 | 2022-08-05 | Japan | Hiroshima | 231214 | 531 | 0 | 34.605309 | 132.788719 | 2022-08-06 04:20:56 | Hiroshima, Japan | |||
2008686 | 2008686 | 2022-08-04 | Japan | Hiroshima | 227241 | 527 | 0 | 34.605309 | 132.788719 | 2022-08-05 04:20:52 | Hiroshima, Japan | |||
1098113 | 1098113 | 2022-08-03 | Japan | Hiroshima | 222886 | 524 | 0 | 34.605309 | 132.788719 | 2022-08-04 04:20:58 | Hiroshima, Japan | |||
1405038 | 1405038 | 2022-08-02 | Japan | Hiroshima | 219338 | 521 | 0 | 34.605309 | 132.788719 | 2022-08-03 04:20:59 | Hiroshima, Japan | |||
3617076 | 3617076 | 2022-08-01 | Japan | Hiroshima | 216590 | 517 | 0 | 34.605309 | 132.788719 | 2022-08-02 04:20:53 | Hiroshima, Japan | |||
3871556 | 3871556 | 2022-07-31 | Japan | Hiroshima | 213387 | 517 | 0 | 34.605309 | 132.788719 | 2022-08-01 04:21:03 | Hiroshima, Japan | |||
674310 | 674310 | 2022-07-30 | Japan | Hiroshima | 210829 | 517 | 0 | 34.605309 | 132.788719 | 2022-07-31 04:21:02 | Hiroshima, Japan | |||
1783509 | 1783509 | 2022-07-29 | Japan | Hiroshima | 207559 | 516 | 0 | 34.605309 | 132.788719 | 2022-07-30 04:20:42 | Hiroshima, Japan | |||
1065872 | 1065872 | 2022-07-28 | Japan | Hiroshima | 204716 | 516 | 0 | 34.605309 | 132.788719 | 2022-07-29 04:20:45 | Hiroshima, Japan | |||
2335391 | 2335391 | 2022-07-27 | Japan | Hiroshima | 201842 | 514 | 0 | 34.605309 | 132.788719 | 2022-07-28 04:20:56 | Hiroshima, Japan | |||
1487581 | 1487581 | 2022-07-26 | Japan | Hiroshima | 198897 | 513 | 0 | 34.605309 | 132.788719 | 2022-07-27 04:21:04 | Hiroshima, Japan | |||
2594027 | 2594027 | 2022-07-25 | Japan | Hiroshima | 196687 | 509 | 0 | 34.605309 | 132.788719 | 2022-07-26 04:20:58 | Hiroshima, Japan | |||
896142 | 896142 | 2022-07-24 | Japan | Hiroshima | 194641 | 508 | 0 | 34.605309 | 132.788719 | 2022-07-25 04:20:51 | Hiroshima, Japan | |||
91136 | 91136 | 2022-07-23 | Japan | Hiroshima | 192437 | 508 | 0 | 34.605309 | 132.788719 | 2022-07-24 04:20:47 | Hiroshima, Japan | |||
900158 | 900158 | 2022-07-22 | Japan | Hiroshima | 190086 | 507 | 0 | 34.605309 | 132.788719 | 2022-07-23 04:20:53 | Hiroshima, Japan | |||
670294 | 670294 | 2022-07-21 | Japan | Hiroshima | 187538 | 507 | 0 | 34.605309 | 132.788719 | 2022-07-22 04:21:15 | Hiroshima, Japan | |||
1608257 | 1608257 | 2022-07-20 | Japan | Hiroshima | 185194 | 503 | 0 | 34.605309 | 132.788719 | 2022-07-21 04:21:10 | Hiroshima, Japan | |||
958890 | 958890 | 2022-07-19 | Japan | Hiroshima | 183788 | 502 | 0 | 34.605309 | 132.788719 | 2022-07-20 04:20:59 | Hiroshima, Japan | |||
3210277 | 3210277 | 2022-07-18 | Japan | Hiroshima | 182972 | 500 | 0 | 34.605309 | 132.788719 | 2022-07-19 04:20:58 | Hiroshima, Japan | |||
3405452 | 3405452 | 2022-07-17 | Japan | Hiroshima | 181960 | 500 | 0 | 34.605309 | 132.788719 | 2022-07-18 04:20:59 | Hiroshima, Japan | |||
2151652 | 2151652 | 2022-07-16 | Japan | Hiroshima | 180642 | 500 | 0 | 34.605309 | 132.788719 | 2022-07-17 04:21:15 | Hiroshima, Japan | |||
2418885 | 2418885 | 2022-07-15 | Japan | Hiroshima | 179300 | 499 | 0 | 34.605309 | 132.788719 | 2022-07-16 04:21:05 | Hiroshima, Japan | |||
3428960 | 3428960 | 2022-07-14 | Japan | Hiroshima | 178004 | 499 | 0 | 34.605309 | 132.788719 | 2022-07-15 04:20:53 | Hiroshima, Japan | |||
3109480 | 3109480 | 2022-07-13 | Japan | Hiroshima | 176733 | 497 | 0 | 34.605309 | 132.788719 | 2022-07-14 04:20:57 | Hiroshima, Japan | |||
629903 | 629903 | 2022-07-12 | Japan | Hiroshima | 175481 | 496 | 0 | 34.605309 | 132.788719 | 2022-07-13 04:20:58 | Hiroshima, Japan | |||
1211547 | 1211547 | 2022-07-11 | Japan | Hiroshima | 174673 | 496 | 0 | 34.605309 | 132.788719 | 2022-07-12 04:20:51 | Hiroshima, Japan | |||
2789029 | 2789029 | 2022-07-10 | Japan | Hiroshima | 174218 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-11 04:20:46 | Hiroshima, Japan | |||
141982 | 141982 | 2022-07-09 | Japan | Hiroshima | 173554 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-10 04:20:54 | Hiroshima, Japan | |||
1417082 | 1417082 | 2022-07-08 | Japan | Hiroshima | 172893 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-09 04:20:59 | Hiroshima, Japan | |||
2741007 | 2741007 | 2022-07-07 | Japan | Hiroshima | 172307 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-08 04:20:56 | Hiroshima, Japan | |||
1199802 | 1199802 | 2022-07-06 | Japan | Hiroshima | 171667 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-07 04:20:55 | Hiroshima, Japan | |||
3966545 | 3966545 | 2022-07-05 | Japan | Hiroshima | 171004 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-06 04:20:58 | Hiroshima, Japan | |||
3078056 | 3078056 | 2022-07-04 | Japan | Hiroshima | 170645 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-05 04:20:45 | Hiroshima, Japan | |||
1767338 | 1767338 | 2022-07-03 | Japan | Hiroshima | 170317 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-04 04:20:54 | Hiroshima, Japan | |||
3365324 | 3365324 | 2022-07-02 | Japan | Hiroshima | 169892 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-03 04:20:59 | Hiroshima, Japan | |||
593653 | 593653 | 2022-07-01 | Japan | Hiroshima | 169466 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-02 04:21:16 | Hiroshima, Japan | |||
3940054 | 3940054 | 2022-06-30 | Japan | Hiroshima | 169082 | 495 | 0 | 34.605309 | 132.788719 | 2022-07-01 04:21:10 | Hiroshima, Japan | |||
2490012 | 2490012 | 2022-06-29 | Japan | Hiroshima | 168625 | 495 | 0 | 34.605309 | 132.788719 | 2022-06-30 04:21:01 | Hiroshima, Japan | |||
2239394 | 2239394 | 2022-06-28 | Japan | Hiroshima | 168145 | 495 | 0 | 34.605309 | 132.788719 | 2022-06-29 04:20:59 | Hiroshima, Japan | |||
2147636 | 2147636 | 2022-06-27 | Japan | Hiroshima | 167836 | 495 | 0 | 34.605309 | 132.788719 | 2022-06-28 04:20:58 | Hiroshima, Japan | |||
475437 | 475437 | 2022-06-26 | Japan | Hiroshima | 167620 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-27 04:21:00 | Hiroshima, Japan | |||
938812 | 938812 | 2022-06-25 | Japan | Hiroshima | 167299 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-26 04:21:02 | Hiroshima, Japan | |||
3346632 | 3346632 | 2022-06-24 | Japan | Hiroshima | 166967 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-25 04:20:57 | Hiroshima, Japan | |||
1648373 | 1648373 | 2022-06-23 | Japan | Hiroshima | 166663 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-24 04:20:58 | Hiroshima, Japan | |||
2187608 | 2187608 | 2022-06-22 | Japan | Hiroshima | 166324 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-23 04:20:55 | Hiroshima, Japan | |||
166039 | 166039 | 2022-06-21 | Japan | Hiroshima | 165920 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-22 04:20:54 | Hiroshima, Japan | |||
1763322 | 1763322 | 2022-06-20 | Japan | Hiroshima | 165644 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-21 04:20:56 | Hiroshima, Japan | |||
3269508 | 3269508 | 2022-06-19 | Japan | Hiroshima | 165426 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-20 04:21:01 | Hiroshima, Japan | |||
3397420 | 3397420 | 2022-06-18 | Japan | Hiroshima | 165089 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-19 04:20:51 | Hiroshima, Japan | |||
2311297 | 2311297 | 2022-06-17 | Japan | Hiroshima | 164752 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-18 04:21:10 | Hiroshima, Japan | |||
558801 | 558801 | 2022-06-16 | Japan | Hiroshima | 164356 | 494 | 0 | 34.605309 | 132.788719 | 2022-06-17 04:20:56 | Hiroshima, Japan | |||
3982603 | 3982603 | 2022-06-15 | Japan | Hiroshima | 163975 | 493 | 0 | 34.605309 | 132.788719 | 2022-06-16 04:20:55 | Hiroshima, Japan | |||
946844 | 946844 | 2022-06-14 | Japan | Hiroshima | 163554 | 493 | 0 | 34.605309 | 132.788719 | 2022-06-15 04:20:54 | Hiroshima, Japan | |||
2979252 | 2979252 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);