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 = "Shiga" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491622 | 1491622 | 2021-10-12 | Japan | Shiga | 12330 | 102 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-13 04:20:51 | Shiga, Japan | |||
3007355 | 3007355 | 2021-10-11 | Japan | Shiga | 12327 | 102 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-12 04:21:09 | Shiga, Japan | |||
423371 | 423371 | 2021-10-10 | Japan | Shiga | 12326 | 102 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-11 04:21:31 | Shiga, Japan | |||
2876228 | 2876228 | 2021-10-09 | Japan | Shiga | 12325 | 102 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-10 04:21:38 | Shiga, Japan | |||
2959394 | 2959394 | 2021-10-08 | Japan | Shiga | 12319 | 102 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-09 04:21:34 | Shiga, Japan | |||
467432 | 467432 | 2021-10-07 | Japan | Shiga | 12314 | 102 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-08 04:21:25 | Shiga, Japan | |||
2458812 | 2458812 | 2021-10-06 | Japan | Shiga | 12309 | 102 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-07 04:21:36 | Shiga, Japan | |||
3832506 | 3832506 | 2021-10-05 | Japan | Shiga | 12304 | 102 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-06 04:21:33 | Shiga, Japan | |||
986999 | 986999 | 2021-10-04 | Japan | Shiga | 12290 | 101 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-05 04:21:27 | Shiga, Japan | |||
1274309 | 1274309 | 2021-10-03 | Japan | Shiga | 12283 | 100 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-04 04:21:31 | Shiga, Japan | |||
3928062 | 3928062 | 2021-10-02 | Japan | Shiga | 12277 | 100 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-03 04:21:24 | Shiga, Japan | |||
2132042 | 2132042 | 2021-10-01 | Japan | Shiga | 12259 | 100 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-02 04:21:25 | Shiga, Japan | |||
2772999 | 2772999 | 2021-09-30 | Japan | Shiga | 12239 | 100 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-10-01 04:21:35 | Shiga, Japan | |||
706455 | 706455 | 2021-09-29 | Japan | Shiga | 12227 | 100 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-30 04:21:20 | Shiga, Japan | |||
1334297 | 1334297 | 2021-09-28 | Japan | Shiga | 12203 | 99 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-29 04:21:45 | Shiga, Japan | |||
1235666 | 1235666 | 2021-09-27 | Japan | Shiga | 12173 | 99 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-28 04:21:28 | Shiga, Japan | |||
2075967 | 2075967 | 2021-09-26 | Japan | Shiga | 12162 | 99 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-27 04:21:16 | Shiga, Japan | |||
1724519 | 1724519 | 2021-09-25 | Japan | Shiga | 12151 | 99 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-26 04:21:29 | Shiga, Japan | |||
1921239 | 1921239 | 2021-09-24 | Japan | Shiga | 12124 | 99 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-25 04:21:31 | Shiga, Japan | |||
601710 | 601710 | 2021-09-23 | Japan | Shiga | 12112 | 99 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-24 04:21:44 | Shiga, Japan | |||
3011371 | 3011371 | 2021-09-22 | Japan | Shiga | 12069 | 99 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-23 04:21:43 | Shiga, Japan | |||
3757509 | 3757509 | 2021-09-21 | Japan | Shiga | 12046 | 99 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-22 04:21:45 | Shiga, Japan | |||
809612 | 809612 | 2021-09-20 | Japan | Shiga | 12034 | 99 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-21 04:21:26 | Shiga, Japan | |||
1814811 | 1814811 | 2021-09-19 | Japan | Shiga | 12022 | 98 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-20 04:21:22 | Shiga, Japan | |||
16391 | 16391 | 2021-09-18 | Japan | Shiga | 12001 | 98 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-19 04:21:34 | Shiga, Japan | |||
2618076 | 2618076 | 2021-09-17 | Japan | Shiga | 11971 | 98 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-18 04:21:24 | Shiga, Japan | |||
2808784 | 2808784 | 2021-09-16 | Japan | Shiga | 11920 | 98 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-17 04:21:46 | Shiga, Japan | |||
1374529 | 1374529 | 2021-09-15 | Japan | Shiga | 11876 | 98 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-16 04:22:19 | Shiga, Japan | |||
2462828 | 2462828 | 2021-09-14 | Japan | Shiga | 11832 | 98 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-15 03:22:37 | Shiga, Japan | |||
1385667 | 1385667 | 2021-09-13 | Japan | Shiga | 11784 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-14 04:21:41 | Shiga, Japan | |||
1885036 | 1885036 | 2021-09-12 | Japan | Shiga | 11752 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-13 04:21:15 | Shiga, Japan | |||
3805939 | 3805939 | 2021-09-11 | Japan | Shiga | 11728 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-12 04:21:13 | Shiga, Japan | |||
3448879 | 3448879 | 2021-09-10 | Japan | Shiga | 11665 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-11 04:21:30 | Shiga, Japan | |||
1262825 | 1262825 | 2021-09-09 | Japan | Shiga | 11608 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-10 04:21:20 | Shiga, Japan | |||
2279195 | 2279195 | 2021-09-08 | Japan | Shiga | 11541 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-09 04:21:27 | Shiga, Japan | |||
641974 | 641974 | 2021-09-07 | Japan | Shiga | 11470 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-08 04:21:31 | Shiga, Japan | |||
3194037 | 3194037 | 2021-09-06 | Japan | Shiga | 11385 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-07 04:21:35 | Shiga, Japan | |||
3280905 | 3280905 | 2021-09-05 | Japan | Shiga | 11301 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-06 04:21:22 | Shiga, Japan | |||
249319 | 249319 | 2021-09-04 | Japan | Shiga | 11232 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-05 04:21:33 | Shiga, Japan | |||
3974600 | 3974600 | 2021-09-03 | Japan | Shiga | 11135 | 97 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-04 04:21:28 | Shiga, Japan | |||
178062 | 178062 | 2021-09-02 | Japan | Shiga | 10998 | 96 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-03 04:21:20 | Shiga, Japan | |||
67097 | 67097 | 2021-09-01 | Japan | Shiga | 10766 | 96 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-02 04:21:15 | Shiga, Japan | |||
2067939 | 2067939 | 2021-08-31 | Japan | Shiga | 10583 | 96 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-09-01 04:21:38 | Shiga, Japan | |||
1775393 | 1775393 | 2021-08-30 | Japan | Shiga | 10444 | 96 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-31 04:21:46 | Shiga, Japan | |||
3891967 | 3891967 | 2021-08-29 | Japan | Shiga | 10331 | 96 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-30 04:21:23 | Shiga, Japan | |||
2793070 | 2793070 | 2021-08-28 | Japan | Shiga | 10170 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-29 04:21:14 | Shiga, Japan | |||
2923229 | 2923229 | 2021-08-27 | Japan | Shiga | 9992 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-28 04:21:28 | Shiga, Japan | |||
1596243 | 1596243 | 2021-08-26 | Japan | Shiga | 9778 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-27 04:21:37 | Shiga, Japan | |||
32452 | 32452 | 2021-08-25 | Japan | Shiga | 9564 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-26 04:21:28 | Shiga, Japan | |||
3105491 | 3105491 | 2021-08-24 | Japan | Shiga | 9344 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-25 04:21:41 | Shiga, Japan | |||
3165662 | 3165662 | 2021-08-23 | Japan | Shiga | 9110 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-24 04:21:19 | Shiga, Japan | |||
2175589 | 2175589 | 2021-08-22 | Japan | Shiga | 8938 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-23 04:21:27 | Shiga, Japan | |||
3555685 | 3555685 | 2021-08-21 | Japan | Shiga | 8786 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-22 04:21:29 | Shiga, Japan | |||
1854027 | 1854027 | 2021-08-20 | Japan | Shiga | 8557 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-21 04:21:38 | Shiga, Japan | |||
511734 | 511734 | 2021-08-19 | Japan | Shiga | 8347 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-20 04:21:33 | Shiga, Japan | |||
2518213 | 2518213 | 2021-08-18 | Japan | Shiga | 8115 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-19 04:21:15 | Shiga, Japan | |||
245305 | 245305 | 2021-08-17 | Japan | Shiga | 7908 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-18 04:21:35 | Shiga, Japan | |||
1604268 | 1604268 | 2021-08-16 | Japan | Shiga | 7732 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-17 04:21:49 | Shiga, Japan | |||
103362 | 103362 | 2021-08-15 | Japan | Shiga | 7612 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-16 04:21:31 | Shiga, Japan | |||
507720 | 507720 | 2021-08-14 | Japan | Shiga | 7498 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-15 04:21:41 | Shiga, Japan | |||
1483592 | 1483592 | 2021-08-13 | Japan | Shiga | 7319 | 95 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-14 04:21:25 | Shiga, Japan | |||
2899722 | 2899722 | 2021-08-12 | Japan | Shiga | 7164 | 94 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-13 04:21:24 | Shiga, Japan | |||
1342326 | 1342326 | 2021-08-11 | Japan | Shiga | 7000 | 94 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-12 04:21:25 | Shiga, Japan | |||
2351473 | 2351473 | 2021-08-10 | Japan | Shiga | 6838 | 94 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-11 04:21:58 | Shiga, Japan | |||
650002 | 650002 | 2021-08-09 | Japan | Shiga | 6749 | 94 | 0 | 35.21582700000001 | 136.13806399999999 | 2021-08-10 04:21:27 | Shiga, Japan | |||
589664 | 589664 | 2021-08-08 | Japan | Shiga | 6678 | 94 | 0 | 35.21582700000001 | 136.138064 | 2021-08-09 04:21:24 | Shiga, Japan | |||
2203676 | 2203676 | 2021-08-07 | Japan | Shiga | 6589 | 94 | 0 | 35.21582700000001 | 136.138064 | 2021-08-08 04:21:33 | Shiga, Japan | |||
1117626 | 1117626 | 2021-08-06 | Japan | Shiga | 6472 | 94 | 0 | 35.21582700000001 | 136.138064 | 2021-08-07 04:21:30 | Shiga, Japan | |||
1956563 | 1956563 | 2021-08-05 | Japan | Shiga | 6383 | 94 | 0 | 35.21582700000001 | 136.138064 | 2021-08-06 04:21:18 | Shiga, Japan | |||
331942 | 331942 | 2021-08-04 | Japan | Shiga | 6304 | 94 | 5679 | 531 | 35.21582700000001 | 136.138064 | 2021-08-05 04:21:51 | Shiga, Japan | ||
3468213 | 3468213 | 2021-08-03 | Japan | Shiga | 6201 | 93 | 5659 | 449 | 35.21582700000001 | 136.138064 | 2021-08-04 04:21:25 | Shiga, Japan | ||
3683487 | 3683487 | 2021-08-02 | Japan | Shiga | 6122 | 93 | 5647 | 382 | 35.21582700000001 | 136.138064 | 2021-08-03 04:21:39 | Shiga, Japan | ||
3015386 | 3015386 | 2021-08-01 | Japan | Shiga | 6067 | 93 | 5635 | 339 | 35.21582700000001 | 136.138064 | 2021-08-02 04:21:36 | Shiga, Japan | ||
3904009 | 3904009 | 2021-07-31 | Japan | Shiga | 6023 | 93 | 5622 | 308 | 35.21582700000001 | 136.138064 | 2021-08-01 04:21:50 | Shiga, Japan | ||
3296214 | 3296214 | 2021-07-30 | Japan | Shiga | 5978 | 93 | 5611 | 274 | 35.21582700000001 | 136.138064 | 2021-07-31 04:21:35 | Shiga, Japan | ||
3385425 | 3385425 | 2021-07-29 | Japan | Shiga | 5918 | 93 | 5596 | 229 | 35.21582700000001 | 136.138064 | 2021-07-30 04:21:34 | Shiga, Japan | ||
408330 | 408330 | 2021-07-28 | Japan | Shiga | 5886 | 93 | 5588 | 205 | 35.21582700000001 | 136.138064 | 2021-07-29 04:21:33 | Shiga, Japan | ||
1306191 | 1306191 | 2021-07-27 | Japan | Shiga | 5836 | 93 | 5571 | 172 | 35.21582700000001 | 136.138064 | 2021-07-28 04:21:39 | Shiga, Japan | ||
3218334 | 3218334 | 2021-07-26 | Japan | Shiga | 5805 | 93 | 5557 | 155 | 35.21582700000001 | 136.138064 | 2021-07-27 04:21:18 | Shiga, Japan | ||
1378543 | 1378543 | 2021-07-25 | Japan | Shiga | 5780 | 92 | 5550 | 138 | 35.21582700000001 | 136.138064 | 2021-07-26 04:21:28 | Shiga, Japan | ||
1330283 | 1330283 | 2021-07-24 | Japan | Shiga | 5768 | 92 | 5543 | 133 | 35.21582700000001 | 136.138064 | 2021-07-25 04:22:12 | Shiga, Japan | ||
3137587 | 3137587 | 2021-07-23 | Japan | Shiga | 5757 | 92 | 5528 | 137 | 35.21582700000001 | 136.138064 | 2021-07-24 00:21:36 | Shiga, Japan | ||
3476347 | 3476347 | 2021-07-22 | Japan | Shiga | 5743 | 91 | 5528 | 124 | 35.21582700000001 | 136.138064 | 2021-07-23 04:21:29 | Shiga, Japan | ||
3331566 | 3331566 | 2021-07-21 | Japan | Shiga | 5721 | 91 | 5514 | 116 | 35.21582700000001 | 136.138064 | 2021-07-22 04:21:19 | Shiga, Japan | ||
2371547 | 2371547 | 2021-07-20 | Japan | Shiga | 5708 | 91 | 5508 | 109 | 35.21582700000001 | 136.138064 | 2021-07-21 04:21:40 | Shiga, Japan | ||
483626 | 483626 | 2021-07-19 | Japan | Shiga | 5699 | 90 | 5503 | 106 | 35.21582700000001 | 136.138064 | 2021-07-20 04:21:48 | Shiga, Japan | ||
2673849 | 2673849 | 2021-07-18 | Japan | Shiga | 5688 | 90 | 5494 | 104 | 35.21582700000001 | 136.138064 | 2021-07-19 04:21:24 | Shiga, Japan | ||
3706161 | 3706161 | 2021-07-17 | Japan | Shiga | 5681 | 90 | 5490 | 101 | 35.21582700000001 | 136.138064 | 2021-07-18 04:22:07 | Shiga, Japan | ||
2947392 | 2947392 | 2021-07-16 | Japan | Shiga | 5672 | 90 | 5476 | 106 | 35.21582700000001 | 136.138064 | 2021-07-17 04:22:22 | Shiga, Japan | ||
296048 | 296048 | 2021-07-15 | Japan | Shiga | 5661 | 90 | 5475 | 96 | 35.21582700000001 | 136.138064 | 2021-07-16 04:21:22 | Shiga, Japan | ||
3631993 | 3631993 | 2021-07-14 | Japan | Shiga | 5650 | 90 | 5472 | 88 | 35.21582700000001 | 136.138064 | 2021-07-15 04:21:48 | Shiga, Japan | ||
578868 | 578868 | 2021-07-13 | Japan | Shiga | 5639 | 90 | 5469 | 80 | 35.21582700000001 | 136.138064 | 2021-07-14 04:21:35 | Shiga, Japan | ||
3741117 | 3741117 | 2021-07-12 | Japan | Shiga | 5630 | 90 | 5457 | 83 | 35.21582700000001 | 136.138064 | 2021-07-13 04:21:18 | Shiga, Japan | ||
3659630 | 3659630 | 2021-07-11 | Japan | Shiga | 5626 | 90 | 5446 | 90 | 35.21582700000001 | 136.138064 | 2021-07-12 04:21:34 | Shiga, Japan | ||
625914 | 625914 | 2021-07-10 | Japan | Shiga | 5621 | 90 | 5446 | 85 | 35.21582700000001 | 136.138064 | 2021-07-11 04:21:43 | Shiga, Japan | ||
829633 | 829633 | 2021-07-09 | Japan | Shiga | 5607 | 90 | 5439 | 78 | 35.21582700000001 | 136.138064 | 2021-07-10 04:21:25 | Shiga, Japan | ||
778397 | 778397 | 2021-07-08 | Japan | Shiga | 5599 | 90 | 5437 | 72 | 35.21582700000001 | 136.138064 | 2021-07-09 04:21:21 | Shiga, Japan | ||
1440619 | 1440619 | 2021-07-07 | Japan | Shiga | 5588 | 90 | 5432 | 66 | 35.21582700000001 | 136.138064 | 2021-07-08 04:21:26 | Shiga, Japan | ||
2693724 | 2693724 | 2021-07-06 | Japan | Shiga | 5580 | 90 | 5422 | 68 | 35.21582700000001 | 136.138064 | 2021-07-07 04:21:20 | Shiga, Japan | ||
1932473 | 1932473 | 2021-07-05 | Japan | Shiga | 5571 | 90 | 5417 | 64 | 35.21582700000001 | 136.138064 | 2021-07-06 04:21:32 | Shiga, 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]);