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 = "Niigata" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462820 | 2462820 | 2021-09-14 | Japan | Niigata | 7432 | 58 | 0 | 37.521819 | 138.918647 | 2021-09-15 03:22:37 | Niigata, Japan | |||
1385659 | 1385659 | 2021-09-13 | Japan | Niigata | 7397 | 58 | 0 | 37.521819 | 138.918647 | 2021-09-14 04:21:41 | Niigata, Japan | |||
1885028 | 1885028 | 2021-09-12 | Japan | Niigata | 7389 | 58 | 0 | 37.521819 | 138.918647 | 2021-09-13 04:21:15 | Niigata, Japan | |||
3805931 | 3805931 | 2021-09-11 | Japan | Niigata | 7364 | 58 | 0 | 37.521819 | 138.918647 | 2021-09-12 04:21:13 | Niigata, Japan | |||
3448871 | 3448871 | 2021-09-10 | Japan | Niigata | 7311 | 58 | 0 | 37.521819 | 138.918647 | 2021-09-11 04:21:30 | Niigata, Japan | |||
1262817 | 1262817 | 2021-09-09 | Japan | Niigata | 7253 | 57 | 0 | 37.521819 | 138.918647 | 2021-09-10 04:21:20 | Niigata, Japan | |||
2279187 | 2279187 | 2021-09-08 | Japan | Niigata | 7185 | 56 | 0 | 37.521819 | 138.918647 | 2021-09-09 04:21:27 | Niigata, Japan | |||
641966 | 641966 | 2021-09-07 | Japan | Niigata | 7128 | 56 | 0 | 37.521819 | 138.918647 | 2021-09-08 04:21:31 | Niigata, Japan | |||
3194029 | 3194029 | 2021-09-06 | Japan | Niigata | 7085 | 56 | 0 | 37.521819 | 138.918647 | 2021-09-07 04:21:35 | Niigata, Japan | |||
3280897 | 3280897 | 2021-09-05 | Japan | Niigata | 7062 | 55 | 0 | 37.521819 | 138.918647 | 2021-09-06 04:21:22 | Niigata, Japan | |||
249311 | 249311 | 2021-09-04 | Japan | Niigata | 7002 | 55 | 0 | 37.521819 | 138.918647 | 2021-09-05 04:21:33 | Niigata, Japan | |||
3974592 | 3974592 | 2021-09-03 | Japan | Niigata | 6946 | 55 | 0 | 37.521819 | 138.918647 | 2021-09-04 04:21:28 | Niigata, Japan | |||
178054 | 178054 | 2021-09-02 | Japan | Niigata | 6907 | 55 | 0 | 37.521819 | 138.918647 | 2021-09-03 04:21:20 | Niigata, Japan | |||
67089 | 67089 | 2021-09-01 | Japan | Niigata | 6843 | 55 | 0 | 37.521819 | 138.918647 | 2021-09-02 04:21:15 | Niigata, Japan | |||
2067931 | 2067931 | 2021-08-31 | Japan | Niigata | 6765 | 55 | 0 | 37.521819 | 138.918647 | 2021-09-01 04:21:38 | Niigata, Japan | |||
1775385 | 1775385 | 2021-08-30 | Japan | Niigata | 6702 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-31 04:21:46 | Niigata, Japan | |||
3891959 | 3891959 | 2021-08-29 | Japan | Niigata | 6649 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-30 04:21:23 | Niigata, Japan | |||
2793062 | 2793062 | 2021-08-28 | Japan | Niigata | 6567 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-29 04:21:14 | Niigata, Japan | |||
2923221 | 2923221 | 2021-08-27 | Japan | Niigata | 6452 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-28 04:21:28 | Niigata, Japan | |||
1596235 | 1596235 | 2021-08-26 | Japan | Niigata | 6316 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-27 04:21:37 | Niigata, Japan | |||
32444 | 32444 | 2021-08-25 | Japan | Niigata | 6191 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-26 04:21:28 | Niigata, Japan | |||
3105483 | 3105483 | 2021-08-24 | Japan | Niigata | 6032 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-25 04:21:41 | Niigata, Japan | |||
3165654 | 3165654 | 2021-08-23 | Japan | Niigata | 5919 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-24 04:21:19 | Niigata, Japan | |||
2175581 | 2175581 | 2021-08-22 | Japan | Niigata | 5853 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-23 04:21:27 | Niigata, Japan | |||
3555677 | 3555677 | 2021-08-21 | Japan | Niigata | 5768 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-22 04:21:29 | Niigata, Japan | |||
1854019 | 1854019 | 2021-08-20 | Japan | Niigata | 5641 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-21 04:21:38 | Niigata, Japan | |||
511726 | 511726 | 2021-08-19 | Japan | Niigata | 5534 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-20 04:21:33 | Niigata, Japan | |||
2518205 | 2518205 | 2021-08-18 | Japan | Niigata | 5402 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-19 04:21:15 | Niigata, Japan | |||
245297 | 245297 | 2021-08-17 | Japan | Niigata | 5286 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-18 04:21:35 | Niigata, Japan | |||
1604260 | 1604260 | 2021-08-16 | Japan | Niigata | 5217 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-17 04:21:49 | Niigata, Japan | |||
103354 | 103354 | 2021-08-15 | Japan | Niigata | 5159 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-16 04:21:31 | Niigata, Japan | |||
507712 | 507712 | 2021-08-14 | Japan | Niigata | 5084 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-15 04:21:41 | Niigata, Japan | |||
1483584 | 1483584 | 2021-08-13 | Japan | Niigata | 4986 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-14 04:21:25 | Niigata, Japan | |||
2899714 | 2899714 | 2021-08-12 | Japan | Niigata | 4857 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-13 04:21:24 | Niigata, Japan | |||
1342318 | 1342318 | 2021-08-11 | Japan | Niigata | 4753 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-12 04:21:25 | Niigata, Japan | |||
2351465 | 2351465 | 2021-08-10 | Japan | Niigata | 4679 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-11 04:21:58 | Niigata, Japan | |||
649994 | 649994 | 2021-08-09 | Japan | Niigata | 4599 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-10 04:21:27 | Niigata, Japan | |||
589656 | 589656 | 2021-08-08 | Japan | Niigata | 4549 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-09 04:21:24 | Niigata, Japan | |||
2203668 | 2203668 | 2021-08-07 | Japan | Niigata | 4476 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-08 04:21:33 | Niigata, Japan | |||
1117618 | 1117618 | 2021-08-06 | Japan | Niigata | 4395 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-07 04:21:30 | Niigata, Japan | |||
1956555 | 1956555 | 2021-08-05 | Japan | Niigata | 4307 | 54 | 0 | 37.521819 | 138.918647 | 2021-08-06 04:21:18 | Niigata, Japan | |||
331934 | 331934 | 2021-08-04 | Japan | Niigata | 4235 | 54 | 3680 | 501 | 37.521819 | 138.918647 | 2021-08-05 04:21:51 | Niigata, Japan | ||
3468205 | 3468205 | 2021-08-03 | Japan | Niigata | 4157 | 54 | 3621 | 482 | 37.521819 | 138.918647 | 2021-08-04 04:21:25 | Niigata, Japan | ||
3683479 | 3683479 | 2021-08-02 | Japan | Niigata | 4096 | 54 | 3597 | 445 | 37.521819 | 138.918647 | 2021-08-03 04:21:39 | Niigata, Japan | ||
3015378 | 3015378 | 2021-08-01 | Japan | Niigata | 4065 | 54 | 3587 | 424 | 37.521819 | 138.918647 | 2021-08-02 04:21:36 | Niigata, Japan | ||
3904001 | 3904001 | 2021-07-31 | Japan | Niigata | 4017 | 54 | 3581 | 382 | 37.521819 | 138.918647 | 2021-08-01 04:21:50 | Niigata, Japan | ||
3296206 | 3296206 | 2021-07-30 | Japan | Niigata | 3959 | 54 | 3544 | 361 | 37.521819 | 138.918647 | 2021-07-31 04:21:35 | Niigata, Japan | ||
3385417 | 3385417 | 2021-07-29 | Japan | Niigata | 3917 | 54 | 3530 | 333 | 37.521819 | 138.918647 | 2021-07-30 04:21:34 | Niigata, Japan | ||
408322 | 408322 | 2021-07-28 | Japan | Niigata | 3864 | 54 | 3512 | 298 | 37.521819 | 138.918647 | 2021-07-29 04:21:33 | Niigata, Japan | ||
1306183 | 1306183 | 2021-07-27 | Japan | Niigata | 3813 | 54 | 3494 | 265 | 37.521819 | 138.918647 | 2021-07-28 04:21:39 | Niigata, Japan | ||
3218326 | 3218326 | 2021-07-26 | Japan | Niigata | 3772 | 54 | 3446 | 272 | 37.521819 | 138.918647 | 2021-07-27 04:21:18 | Niigata, Japan | ||
1378535 | 1378535 | 2021-07-25 | Japan | Niigata | 3747 | 54 | 3446 | 247 | 37.521819 | 138.918647 | 2021-07-26 04:21:28 | Niigata, Japan | ||
1330275 | 1330275 | 2021-07-24 | Japan | Niigata | 3724 | 54 | 3446 | 224 | 37.521819 | 138.918647 | 2021-07-25 04:22:12 | Niigata, Japan | ||
3137579 | 3137579 | 2021-07-23 | Japan | Niigata | 3696 | 54 | 3442 | 200 | 37.521819 | 138.918647 | 2021-07-24 00:21:36 | Niigata, Japan | ||
3476339 | 3476339 | 2021-07-22 | Japan | Niigata | 3682 | 54 | 3434 | 194 | 37.521819 | 138.918647 | 2021-07-23 04:21:29 | Niigata, Japan | ||
3331558 | 3331558 | 2021-07-21 | Japan | Niigata | 3645 | 54 | 3426 | 165 | 37.521819 | 138.918647 | 2021-07-22 04:21:19 | Niigata, Japan | ||
2371539 | 2371539 | 2021-07-20 | Japan | Niigata | 3621 | 54 | 3414 | 153 | 37.521819 | 138.918647 | 2021-07-21 04:21:40 | Niigata, Japan | ||
483618 | 483618 | 2021-07-19 | Japan | Niigata | 3585 | 54 | 3391 | 140 | 37.521819 | 138.918647 | 2021-07-20 04:21:48 | Niigata, Japan | ||
2673841 | 2673841 | 2021-07-18 | Japan | Niigata | 3577 | 54 | 3387 | 136 | 37.521819 | 138.918647 | 2021-07-19 04:21:24 | Niigata, Japan | ||
3706153 | 3706153 | 2021-07-17 | Japan | Niigata | 3566 | 54 | 3387 | 125 | 37.521819 | 138.918647 | 2021-07-18 04:22:07 | Niigata, Japan | ||
2947384 | 2947384 | 2021-07-16 | Japan | Niigata | 3548 | 54 | 3376 | 118 | 37.521819 | 138.918647 | 2021-07-17 04:22:22 | Niigata, Japan | ||
296040 | 296040 | 2021-07-15 | Japan | Niigata | 3534 | 54 | 3370 | 110 | 37.521819 | 138.918647 | 2021-07-16 04:21:22 | Niigata, Japan | ||
3631985 | 3631985 | 2021-07-14 | Japan | Niigata | 3515 | 54 | 3367 | 94 | 37.521819 | 138.918647 | 2021-07-15 04:21:48 | Niigata, Japan | ||
578860 | 578860 | 2021-07-13 | Japan | Niigata | 3497 | 54 | 3354 | 89 | 37.521819 | 138.918647 | 2021-07-14 04:21:35 | Niigata, Japan | ||
3741109 | 3741109 | 2021-07-12 | Japan | Niigata | 3491 | 54 | 3337 | 100 | 37.521819 | 138.918647 | 2021-07-13 04:21:18 | Niigata, Japan | ||
3659622 | 3659622 | 2021-07-11 | Japan | Niigata | 3488 | 53 | 3337 | 98 | 37.521819 | 138.918647 | 2021-07-12 04:21:34 | Niigata, Japan | ||
625906 | 625906 | 2021-07-10 | Japan | Niigata | 3474 | 53 | 3337 | 84 | 37.521819 | 138.918647 | 2021-07-11 04:21:43 | Niigata, Japan | ||
829625 | 829625 | 2021-07-09 | Japan | Niigata | 3462 | 53 | 3334 | 75 | 37.521819 | 138.918647 | 2021-07-10 04:21:25 | Niigata, Japan | ||
778389 | 778389 | 2021-07-08 | Japan | Niigata | 3456 | 52 | 3334 | 70 | 37.521819 | 138.918647 | 2021-07-09 04:21:21 | Niigata, Japan | ||
1440611 | 1440611 | 2021-07-07 | Japan | Niigata | 3447 | 52 | 3331 | 64 | 37.521819 | 138.918647 | 2021-07-08 04:21:26 | Niigata, Japan | ||
2693716 | 2693716 | 2021-07-06 | Japan | Niigata | 3434 | 52 | 3329 | 53 | 37.521819 | 138.918647 | 2021-07-07 04:21:20 | Niigata, Japan | ||
1932465 | 1932465 | 2021-07-05 | Japan | Niigata | 3427 | 52 | 3326 | 49 | 37.521819 | 138.918647 | 2021-07-06 04:21:32 | Niigata, Japan | ||
1165196 | 1165196 | 2021-07-04 | Japan | Niigata | 3423 | 52 | 3326 | 45 | 37.521819 | 138.918647 | 2021-07-05 04:21:28 | Niigata, Japan | ||
1495630 | 1495630 | 2021-07-03 | Japan | Niigata | 3414 | 52 | 3324 | 38 | 37.521819 | 138.918647 | 2021-07-04 04:21:38 | Niigata, Japan | ||
2071945 | 2071945 | 2021-07-02 | Japan | Niigata | 3408 | 52 | 3318 | 38 | 37.521819 | 138.918647 | 2021-07-03 04:21:37 | Niigata, Japan | ||
2764961 | 2764961 | 2021-07-01 | Japan | Niigata | 3403 | 52 | 3312 | 39 | 37.521819 | 138.918647 | 2021-07-02 04:21:47 | Niigata, Japan | ||
1893169 | 1893169 | 2021-06-30 | Japan | Niigata | 3401 | 52 | 3308 | 41 | 37.521819 | 138.918647 | 2021-07-01 04:21:19 | Niigata, Japan | ||
400292 | 400292 | 2021-06-29 | Japan | Niigata | 3398 | 52 | 3305 | 41 | 37.521819 | 138.918647 | 2021-06-30 04:21:41 | Niigata, Japan | ||
3125535 | 3125535 | 2021-06-28 | Japan | Niigata | 3398 | 47 | 3299 | 52 | 37.521819 | 138.918647 | 2021-06-29 04:21:28 | Niigata, Japan | ||
2590030 | 2590030 | 2021-06-27 | Japan | Niigata | 3397 | 47 | 3299 | 51 | 37.521819 | 138.918647 | 2021-06-28 04:21:29 | Niigata, Japan | ||
3958534 | 3958534 | 2021-06-26 | Japan | Niigata | 3397 | 47 | 3299 | 51 | 37.521819 | 138.918647 | 2021-06-27 04:21:39 | Niigata, Japan | ||
1712353 | 1712353 | 2021-06-25 | Japan | Niigata | 3394 | 47 | 3295 | 52 | 37.521819 | 138.918647 | 2021-06-26 04:21:43 | Niigata, Japan | ||
2295478 | 2295478 | 2021-06-24 | Japan | Niigata | 3392 | 47 | 3285 | 60 | 37.521819 | 138.918647 | 2021-06-25 04:21:33 | Niigata, Japan | ||
2422918 | 2422918 | 2021-06-23 | Japan | Niigata | 3390 | 47 | 3282 | 61 | 37.521819 | 138.918647 | 2021-06-24 04:21:55 | Niigata, Japan | ||
562995 | 562995 | 2021-06-22 | Japan | Niigata | 3387 | 47 | 3265 | 75 | 37.521819 | 138.918647 | 2021-06-23 04:21:46 | Niigata, Japan | ||
3358697 | 3358697 | 2021-06-21 | Japan | Niigata | 3384 | 47 | 3245 | 92 | 37.521819 | 138.918647 | 2021-06-22 04:21:34 | Niigata, Japan | ||
2884396 | 2884396 | 2021-06-20 | Japan | Niigata | 3384 | 47 | 3237 | 100 | 37.521819 | 138.918647 | 2021-06-21 04:21:41 | Niigata, Japan | ||
107479 | 107479 | 2021-06-19 | Japan | Niigata | 3384 | 47 | 3234 | 103 | 37.521819 | 138.918647 | 2021-06-20 04:21:48 | Niigata, Japan | ||
1125622 | 1125622 | 2021-06-18 | Japan | Niigata | 3383 | 47 | 3224 | 112 | 37.521819 | 138.918647 | 2021-06-19 04:22:33 | Niigata, Japan | ||
2911200 | 2911200 | 2021-06-17 | Japan | Niigata | 3382 | 47 | 3215 | 120 | 37.521819 | 138.918647 | 2021-06-18 04:22:16 | Niigata, Japan | ||
3030318 | 3030318 | 2021-06-16 | Japan | Niigata | 3376 | 47 | 3195 | 134 | 37.521819 | 138.918647 | 2021-06-17 04:22:36 | Niigata, Japan | ||
2339424 | 2339424 | 2021-06-15 | Japan | Niigata | 3371 | 47 | 3179 | 145 | 37.521819 | 138.918647 | 2021-06-16 04:22:32 | Niigata, Japan | ||
1564120 | 1564120 | 2021-06-14 | Japan | Niigata | 3364 | 46 | 3166 | 152 | 37.521819 | 138.918647 | 2021-06-15 04:22:22 | Niigata, Japan | ||
3381403 | 3381403 | 2021-06-13 | Japan | Niigata | 3362 | 46 | 3157 | 159 | 37.521819 | 138.918647 | 2021-06-14 04:22:46 | Niigata, Japan | ||
1736537 | 1736537 | 2021-06-12 | Japan | Niigata | 3357 | 46 | 3150 | 161 | 37.521819 | 138.918647 | 2021-06-13 04:22:44 | Niigata, Japan | ||
3970578 | 3970578 | 2021-06-11 | Japan | Niigata | 3340 | 46 | 3129 | 165 | 37.521819 | 138.918647 | 2021-06-12 04:22:22 | Niigata, Japan | ||
2717000 | 2717000 | 2021-06-10 | Japan | Niigata | 3331 | 46 | 3109 | 176 | 37.521819 | 138.918647 | 2021-06-11 04:23:20 | Niigata, Japan | ||
522885 | 522885 | 2021-06-09 | Japan | Niigata | 3315 | 45 | 3090 | 180 | 37.521819 | 138.918647 | 2021-06-10 04:23:17 | Niigata, Japan | ||
3472325 | 3472325 | 2021-06-08 | Japan | Niigata | 3305 | 40 | 3071 | 194 | 37.521819 | 138.918647 | 2021-06-09 04:23:31 | Niigata, Japan | ||
3145609 | 3145609 | 2021-06-07 | Japan | Niigata | 3299 | 40 | 3036 | 223 | 37.521819 | 138.918647 | 2021-06-08 04:22:35 | Niigata, 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]);