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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190097 | 190097 | 2021-01-11 | Japan | Niigata | 679 | 3 | 505 | 171 | 37.521819 | 138.918647 | 2021-01-12 05:22:15 | Niigata, Japan | ||
2625900 | 2625900 | 2021-01-10 | Japan | Niigata | 661 | 3 | 503 | 155 | 37.521819 | 138.918647 | 2021-01-11 05:21:50 | Niigata, Japan | ||
3899988 | 3899988 | 2021-01-09 | Japan | Niigata | 640 | 3 | 497 | 140 | 37.521819 | 138.918647 | 2021-01-10 05:22:12 | Niigata, Japan | ||
154011 | 154011 | 2021-01-08 | Japan | Niigata | 627 | 3 | 486 | 138 | 37.521819 | 138.918647 | 2021-01-09 05:22:18 | Niigata, Japan | ||
2541435 | 2541435 | 2021-01-07 | Japan | Niigata | 611 | 3 | 480 | 128 | 37.521819 | 138.918647 | 2021-01-08 05:22:42 | Niigata, Japan | ||
2864744 | 2864744 | 2021-01-06 | Japan | Niigata | 602 | 3 | 476 | 123 | 37.521819 | 138.918647 | 2021-01-07 05:22:03 | Niigata, Japan | ||
3034331 | 3034331 | 2021-01-05 | Japan | Niigata | 582 | 3 | 450 | 129 | 37.521819 | 138.918647 | 2021-01-06 05:22:16 | Niigata, Japan | ||
1061876 | 1061876 | 2021-01-04 | Japan | Niigata | 572 | 3 | 445 | 124 | 37.521819 | 138.918647 | 2021-01-05 05:21:49 | Niigata, Japan | ||
3230479 | 3230479 | 2021-01-03 | Japan | Niigata | 565 | 3 | 438 | 124 | 37.521819 | 138.918647 | 2021-01-04 05:22:02 | Niigata, Japan | ||
2227548 | 2227548 | 2021-01-02 | Japan | Niigata | 555 | 3 | 436 | 116 | 37.521819 | 138.918647 | 2021-01-03 05:22:52 | Niigata, Japan | ||
1136912 | 1136912 | 2021-01-01 | Japan | Niigata | 545 | 3 | 436 | 106 | 37.521819 | 138.918647 | 2021-01-02 05:22:33 | Niigata, Japan | ||
3695518 | 3695518 | 2020-12-31 | Japan | Niigata | 540 | 3 | 426 | 111 | 37.521819 | 138.918647 | 2021-01-01 05:23:07 | Niigata, Japan | ||
1010333 | 1010333 | 2020-12-30 | Japan | Niigata | 532 | 3 | 425 | 104 | 37.521819 | 138.918647 | 2020-12-31 05:22:49 | Niigata, Japan | ||
766348 | 766348 | 2020-12-29 | Japan | Niigata | 520 | 3 | 418 | 99 | 37.521819 | 138.918647 | 2020-12-30 05:22:34 | Niigata, Japan | ||
3761612 | 3761612 | 2020-12-28 | Japan | Niigata | 505 | 3 | 410 | 92 | 37.521819 | 138.918647 | 2020-12-29 05:22:37 | Niigata, Japan | ||
3777932 | 3777932 | 2020-12-27 | Japan | Niigata | 505 | 3 | 405 | 97 | 37.521819 | 138.918647 | 2020-12-28 05:22:06 | Niigata, Japan | ||
2223537 | 2223537 | 2020-12-26 | Japan | Niigata | 503 | 3 | 405 | 95 | 37.521819 | 138.918647 | 2020-12-27 05:22:55 | Niigata, Japan | ||
202284 | 202284 | 2020-12-25 | Japan | Niigata | 486 | 3 | 396 | 87 | 37.521819 | 138.918647 | 2020-12-26 05:22:28 | Niigata, Japan | ||
3691507 | 3691507 | 2020-12-24 | Japan | Niigata | 472 | 3 | 390 | 79 | 37.521819 | 138.918647 | 2020-12-25 05:22:48 | Niigata, Japan | ||
2406859 | 2406859 | 2020-12-23 | Japan | Niigata | 457 | 3 | 379 | 75 | 37.521819 | 138.918647 | 2020-12-24 05:23:04 | Niigata, Japan | ||
3769905 | 3769905 | 2020-12-22 | Japan | Niigata | 448 | 3 | 373 | 72 | 37.521819 | 138.918647 | 2020-12-23 05:22:03 | Niigata, Japan | ||
927721 | 927721 | 2020-12-21 | Japan | Niigata | 443 | 3 | 372 | 68 | 37.521819 | 138.918647 | 2020-12-22 05:22:33 | Niigata, Japan | ||
2119742 | 2119742 | 2020-12-20 | Japan | Niigata | 440 | 3 | 369 | 68 | 37.521819 | 138.918647 | 2020-12-21 05:27:58 | Niigata, Japan | ||
2931249 | 2931249 | 2020-12-19 | Japan | Niigata | 435 | 3 | 353 | 79 | 37.521819 | 138.918647 | 2020-12-20 05:27:32 | Niigata, Japan | ||
1901195 | 1901195 | 2020-12-18 | Japan | Niigata | 428 | 3 | 348 | 77 | 37.521819 | 138.918647 | 2020-12-19 05:27:52 | Niigata, Japan | ||
2128021 | 2128021 | 2020-12-17 | Japan | Niigata | 421 | 3 | 343 | 75 | 37.521819 | 138.918647 | 2020-12-18 05:28:18 | Niigata, Japan | ||
3149621 | 3149621 | 2020-12-16 | Japan | Niigata | 418 | 3 | 335 | 80 | 37.521819 | 138.918647 | 2020-12-17 05:28:12 | Niigata, Japan | ||
1034402 | 1034402 | 2020-12-15 | Japan | Niigata | 414 | 3 | 327 | 84 | 37.521819 | 138.918647 | 2020-12-16 05:28:04 | Niigata, Japan | ||
1751296 | 1751296 | 2020-12-14 | Japan | Niigata | 408 | 2 | 317 | 89 | 37.521819 | 138.918647 | 2020-12-15 05:26:38 | Niigata, Japan | ||
3847816 | 3847816 | 2020-12-13 | Japan | Niigata | 400 | 2 | 317 | 81 | 37.521819 | 138.918647 | 2020-12-14 05:26:27 | Niigata, Japan | ||
845598 | 845598 | 2020-12-12 | Japan | Niigata | 390 | 2 | 306 | 82 | 37.521819 | 138.918647 | 2020-12-13 05:27:20 | Niigata, Japan | ||
860705 | 860705 | 2020-12-11 | Japan | Niigata | 380 | 1 | 294 | 85 | 37.521819 | 138.918647 | 2020-12-12 05:26:19 | Niigata, Japan | ||
1600247 | 1600247 | 2020-12-10 | Japan | Niigata | 374 | 1 | 291 | 82 | 37.521819 | 138.918647 | 2020-12-11 05:26:59 | Niigata, Japan | ||
2975256 | 2975256 | 2020-12-09 | Japan | Niigata | 369 | 1 | 284 | 84 | 37.521819 | 138.918647 | 2020-12-10 05:26:19 | Niigata, Japan | ||
1818816 | 1818816 | 2020-12-08 | Japan | Niigata | 363 | 1 | 279 | 83 | 37.521819 | 138.918647 | 2020-12-09 05:28:01 | Niigata, Japan | ||
2347452 | 2347452 | 2020-12-07 | Japan | Niigata | 359 | 0 | 274 | 85 | 37.521819 | 138.918647 | 2020-12-08 05:27:42 | Niigata, Japan | ||
1006322 | 1006322 | 2020-12-06 | Japan | Niigata | 356 | 0 | 272 | 84 | 37.521819 | 138.918647 | 2020-12-07 05:26:14 | Niigata, Japan | ||
1632331 | 1632331 | 2020-12-05 | Japan | Niigata | 354 | 0 | 270 | 84 | 37.521819 | 138.918647 | 2020-12-06 05:26:18 | Niigata, Japan | ||
3859859 | 3859859 | 2020-12-04 | Japan | Niigata | 350 | 0 | 259 | 91 | 37.521819 | 138.918647 | 2020-12-05 05:27:36 | Niigata, Japan | ||
75117 | 75117 | 2020-12-03 | Japan | Niigata | 348 | 0 | 247 | 101 | 37.521819 | 138.918647 | 2020-12-04 05:27:27 | Niigata, Japan | ||
738329 | 738329 | 2020-12-02 | Japan | Niigata | 340 | 0 | 243 | 97 | 37.521819 | 138.918647 | 2020-12-03 05:28:22 | Niigata, Japan | ||
2537423 | 2537423 | 2020-12-01 | Japan | Niigata | 336 | 0 | 234 | 102 | 37.521819 | 138.918647 | 2020-12-02 05:27:41 | Niigata, Japan | ||
1584192 | 1584192 | 2020-11-30 | Japan | Niigata | 331 | 0 | 228 | 103 | 37.521819 | 138.918647 | 2020-12-01 05:26:18 | Niigata, Japan | ||
3566595 | 3566595 | 2020-11-29 | Japan | Niigata | 331 | 0 | 228 | 103 | 37.521819 | 138.918647 | 2020-11-30 05:26:13 | Niigata, Japan | ||
2935260 | 2935260 | 2020-11-28 | Japan | Niigata | 329 | 0 | 227 | 102 | 37.521819 | 138.918647 | 2020-11-29 05:25:55 | Niigata, Japan | ||
392263 | 392263 | 2020-11-27 | Japan | Niigata | 326 | 0 | 224 | 102 | 37.521819 | 138.918647 | 2020-11-28 05:25:50 | Niigata, Japan | ||
923710 | 923710 | 2020-11-26 | Japan | Niigata | 325 | 0 | 222 | 103 | 37.521819 | 138.918647 | 2020-11-27 05:26:53 | Niigata, Japan | ||
1972615 | 1972615 | 2020-11-25 | Japan | Niigata | 324 | 0 | 215 | 109 | 37.521819 | 138.918647 | 2020-11-26 05:27:44 | Niigata, Japan | ||
1350346 | 1350346 | 2020-11-24 | Japan | Niigata | 316 | 0 | 211 | 105 | 37.521819 | 138.918647 | 2020-11-25 05:27:20 | Niigata, Japan | ||
678340 | 678340 | 2020-11-23 | Japan | Niigata | 313 | 0 | 211 | 102 | 37.521819 | 138.918647 | 2020-11-24 05:27:31 | Niigata, Japan | ||
3190016 | 3190016 | 2020-11-22 | Japan | Niigata | 300 | 0 | 204 | 96 | 37.521819 | 138.918647 | 2020-11-23 05:25:26 | Niigata, Japan | ||
3836510 | 3836510 | 2020-11-21 | Japan | Niigata | 294 | 0 | 201 | 93 | 37.521819 | 138.918647 | 2020-11-22 05:25:45 | Niigata, Japan | ||
2701538 | 2701538 | 2020-11-20 | Japan | Niigata | 285 | 0 | 195 | 90 | 37.521819 | 138.918647 | 2020-11-21 05:25:51 | Niigata, Japan | ||
821598 | 821598 | 2020-11-19 | Japan | Niigata | 274 | 0 | 187 | 87 | 37.521819 | 138.918647 | 2020-11-20 05:26:28 | Niigata, Japan | ||
122732 | 122732 | 2020-11-18 | Japan | Niigata | 273 | 0 | 187 | 86 | 37.521819 | 138.918647 | 2020-11-19 05:25:23 | Niigata, Japan | ||
3338620 | 3338620 | 2020-11-17 | Japan | Niigata | 259 | 0 | 185 | 74 | 37.521819 | 138.918647 | 2020-11-18 05:40:31 | Niigata, Japan | ||
3169665 | 3169665 | 2020-11-16 | Japan | Niigata | 226 | 0 | 184 | 42 | 37.521819 | 138.918647 | 2020-11-17 05:25:54 | Niigata, Japan | ||
2880233 | 2880233 | 2020-11-15 | Japan | Niigata | 226 | 0 | 184 | 42 | 37.521819 | 138.918647 | 2020-11-16 05:25:57 | Niigata, Japan | ||
2915211 | 2915211 | 2020-11-14 | Japan | Niigata | 224 | 0 | 183 | 41 | 37.521819 | 138.918647 | 2020-11-15 05:26:53 | Niigata, Japan | ||
2785033 | 2785033 | 2020-11-13 | Japan | Niigata | 224 | 0 | 183 | 41 | 37.521819 | 138.918647 | 2020-11-14 05:25:37 | Niigata, Japan | ||
864798 | 864798 | 2020-11-12 | Japan | Niigata | 222 | 0 | 182 | 40 | 37.521819 | 138.918647 | 2020-11-13 05:25:30 | Niigata, Japan | ||
3440843 | 3440843 | 2020-11-11 | Japan | Niigata | 216 | 0 | 182 | 34 | 37.521819 | 138.918647 | 2020-11-12 05:25:55 | Niigata, Japan | ||
272183 | 272183 | 2020-11-10 | Japan | Niigata | 200 | 0 | 182 | 18 | 37.521819 | 138.918647 | 2020-11-11 05:25:30 | Niigata, Japan | ||
1988660 | 1988660 | 2020-11-09 | Japan | Niigata | 198 | 0 | 182 | 16 | 37.521819 | 138.918647 | 2020-11-10 05:40:07 | Niigata, Japan | ||
1728512 | 1728512 | 2020-11-08 | Japan | Niigata | 195 | 0 | 182 | 13 | 37.521819 | 138.918647 | 2020-11-09 05:25:45 | Niigata, Japan | ||
1543972 | 1543972 | 2020-11-07 | Japan | Niigata | 188 | 0 | 182 | 6 | 37.521819 | 138.918647 | 2020-11-08 05:24:56 | Niigata, Japan | ||
376210 | 376210 | 2020-11-06 | Japan | Niigata | 186 | 0 | 181 | 5 | 37.521819 | 138.918647 | 2020-11-07 05:24:52 | Niigata, Japan | ||
892148 | 892148 | 2020-11-05 | Japan | Niigata | 185 | 0 | 180 | 5 | 37.521819 | 138.918647 | 2020-11-06 05:24:55 | Niigata, Japan | ||
2919210 | 2919210 | 2020-11-04 | Japan | Niigata | 183 | 0 | 179 | 4 | 37.521819 | 138.918647 | 2020-11-05 06:05:03 | Niigata, Japan | ||
2498047 | 2498047 | 2020-11-03 | Japan | Niigata | 183 | 0 | 179 | 4 | 37.521819 | 138.918647 | 2020-11-04 05:25:09 | Niigata, Japan | ||
3304222 | 3304222 | 2020-11-02 | Japan | Niigata | 183 | 0 | 179 | 4 | 37.521819 | 138.918647 | 2020-11-03 06:00:16 | Niigata, Japan | ||
3409471 | 3409471 | 2020-11-01 | Japan | Niigata | 183 | 0 | 179 | 4 | 37.521819 | 138.918647 | 2020-11-02 05:25:04 | Niigata, Japan | ||
2079960 | 2079960 | 2020-10-31 | Japan | Niigata | 183 | 0 | 179 | 4 | 37.521819 | 138.918647 | 2020-11-01 04:36:19 | Niigata, Japan | ||
2243413 | 2243413 | 2020-10-30 | Japan | Niigata | 182 | 0 | 179 | 3 | 37.521819 | 138.918647 | 2020-10-31 04:24:44 | Niigata, Japan | ||
210268 | 210268 | 2020-10-29 | Japan | Niigata | 182 | 0 | 179 | 3 | 37.521819 | 138.918647 | 2020-10-30 04:24:49 | Niigata, Japan | ||
754330 | 754330 | 2020-10-28 | Japan | Niigata | 181 | 0 | 179 | 2 | 37.521819 | 138.918647 | 2020-10-29 04:24:49 | Niigata, Japan | ||
1452615 | 1452615 | 2020-10-27 | Japan | Niigata | 181 | 0 | 179 | 2 | 37.521819 | 138.918647 | 2020-10-28 04:24:39 | Niigata, Japan | ||
3480339 | 3480339 | 2020-10-26 | Japan | Niigata | 181 | 0 | 179 | 2 | 37.521819 | 138.918647 | 2020-10-27 04:24:45 | Niigata, Japan | ||
8360 | 8360 | 2020-10-25 | Japan | Niigata | 181 | 0 | 179 | 2 | 37.521819 | 138.918647 | 2020-10-26 04:25:02 | Niigata, Japan | ||
3651597 | 3651597 | 2020-10-24 | Japan | Niigata | 180 | 0 | 179 | 1 | 37.521819 | 138.918647 | 2020-10-25 04:24:36 | Niigata, Japan | ||
1053852 | 1053852 | 2020-10-23 | Japan | Niigata | 179 | 0 | 179 | 0 | 37.521819 | 138.918647 | 2020-10-24 04:24:46 | Niigata, Japan | ||
1177522 | 1177522 | 2020-10-22 | Japan | Niigata | 179 | 0 | 179 | 0 | 37.521819 | 138.918647 | 2020-10-23 04:24:46 | Niigata, Japan | ||
2191627 | 2191627 | 2020-10-21 | Japan | Niigata | 179 | 0 | 177 | 2 | 37.521819 | 138.918647 | 2020-10-22 04:24:27 | Niigata, Japan | ||
3990638 | 3990638 | 2020-10-20 | Japan | Niigata | 179 | 0 | 177 | 2 | 37.521819 | 138.918647 | 2020-10-21 04:24:14 | Niigata, Japan | ||
1794658 | 1794658 | 2020-10-19 | Japan | Niigata | 179 | 0 | 176 | 3 | 37.521819 | 138.918647 | 2020-10-20 04:24:22 | Niigata, Japan | ||
762342 | 762342 | 2020-10-18 | Japan | Niigata | 179 | 0 | 176 | 3 | 37.521819 | 138.918647 | 2020-10-19 04:24:16 | Niigata, Japan | ||
1026380 | 1026380 | 2020-10-17 | Japan | Niigata | 179 | 0 | 176 | 3 | 37.521819 | 138.918647 | 2020-10-18 04:24:25 | Niigata, Japan | ||
2856875 | 2856875 | 2020-10-16 | Japan | Niigata | 179 | 0 | 173 | 6 | 37.521819 | 138.918647 | 2020-10-17 04:24:12 | Niigata, Japan | ||
786405 | 786405 | 2020-10-15 | Japan | Niigata | 179 | 0 | 173 | 6 | 37.521819 | 138.918647 | 2020-10-16 04:24:01 | Niigata, Japan | ||
79116 | 79116 | 2020-10-14 | Japan | Niigata | 178 | 0 | 170 | 8 | 37.521819 | 138.918647 | 2020-10-15 04:24:28 | Niigata, Japan | ||
3781931 | 3781931 | 2020-10-13 | Japan | Niigata | 178 | 0 | 170 | 8 | 37.521819 | 138.918647 | 2020-10-14 04:24:05 | Niigata, Japan | ||
2291471 | 2291471 | 2020-10-12 | Japan | Niigata | 178 | 0 | 169 | 9 | 37.521819 | 138.918647 | 2020-10-13 04:24:02 | Niigata, Japan | ||
3785924 | 3785924 | 2020-10-11 | Japan | Niigata | 178 | 0 | 169 | 9 | 37.521819 | 138.918647 | 2020-10-12 04:23:45 | Niigata, Japan | ||
2602062 | 2602062 | 2020-10-10 | Japan | Niigata | 176 | 0 | 169 | 7 | 37.521819 | 138.918647 | 2020-10-11 04:23:46 | Niigata, Japan | ||
817595 | 817595 | 2020-10-09 | Japan | Niigata | 175 | 0 | 168 | 7 | 37.521819 | 138.918647 | 2020-10-10 04:23:57 | Niigata, Japan | ||
2689710 | 2689710 | 2020-10-08 | Japan | Niigata | 175 | 0 | 168 | 7 | 37.521819 | 138.918647 | 2020-10-09 04:23:59 | Niigata, Japan | ||
1041852 | 1041852 | 2020-10-07 | Japan | Niigata | 170 | 0 | 168 | 2 | 37.521819 | 138.918647 | 2020-10-08 04:23:56 | Niigata, Japan | ||
3117513 | 3117513 | 2020-10-06 | Japan | Niigata | 169 | 0 | 166 | 3 | 37.521819 | 138.918647 | 2020-10-07 04:23:40 | Niigata, Japan | ||
3801925 | 3801925 | 2020-10-05 | Japan | Niigata | 169 | 0 | 166 | 3 | 37.521819 | 138.918647 | 2020-10-06 04:23:33 | Niigata, Japan | ||
1822815 | 1822815 | 2020-10-04 | Japan | Niigata | 169 | 0 | 164 | 5 | 37.521819 | 138.918647 | 2020-10-05 04:23:33 | 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]);