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 = "Miyagi" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- 2020-06-19 1
- 2020-06-20 1
- 2020-06-21 1
- 2020-06-22 1
- 2020-06-23 1
- 2020-06-24 1
- 2020-06-25 1
- …
province_or_state 1
- Miyagi · 846 ✖
country_or_region 1
- Japan · 846 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016731 | 2016731 | 2022-09-20 | Japan | Miyagi | 251156 | 378 | 0 | 38.446859 | 140.927086 | 2022-09-21 04:23:22 | Miyagi, Japan | |||
3570604 | 3570604 | 2022-09-19 | Japan | Miyagi | 250805 | 376 | 0 | 38.446859 | 140.927086 | 2022-09-20 04:22:48 | Miyagi, Japan | |||
419343 | 419343 | 2022-09-18 | Japan | Miyagi | 250352 | 376 | 0 | 38.446859 | 140.927086 | 2022-09-19 04:21:49 | Miyagi, Japan | |||
3373367 | 3373367 | 2022-09-17 | Japan | Miyagi | 249551 | 376 | 0 | 38.446859 | 140.927086 | 2022-09-18 04:22:50 | Miyagi, Japan | |||
2355475 | 2355475 | 2022-09-16 | Japan | Miyagi | 248552 | 375 | 0 | 38.446859 | 140.927086 | 2022-09-17 04:20:19 | Miyagi, Japan | |||
3986632 | 3986632 | 2022-09-15 | Japan | Miyagi | 247622 | 372 | 0 | 38.446859 | 140.927086 | 2022-09-16 04:21:19 | Miyagi, Japan | |||
1889149 | 1889149 | 2022-09-14 | Japan | Miyagi | 246590 | 366 | 0 | 38.446859 | 140.927086 | 2022-09-15 04:21:02 | Miyagi, Japan | |||
372204 | 372204 | 2022-09-13 | Japan | Miyagi | 245295 | 360 | 0 | 38.446859 | 140.927086 | 2022-09-14 04:20:44 | Miyagi, Japan | |||
2394809 | 2394809 | 2022-09-12 | Japan | Miyagi | 243566 | 355 | 0 | 38.446859 | 140.927086 | 2022-09-13 04:20:57 | Miyagi, Japan | |||
3765887 | 3765887 | 2022-09-11 | Japan | Miyagi | 243107 | 354 | 0 | 38.446859 | 140.927086 | 2022-09-12 04:20:58 | Miyagi, Japan | |||
3824462 | 3824462 | 2022-09-10 | Japan | Miyagi | 242226 | 347 | 0 | 38.446859 | 140.927086 | 2022-09-11 04:20:50 | Miyagi, Japan | |||
962919 | 962919 | 2022-09-09 | Japan | Miyagi | 240949 | 345 | 0 | 38.446859 | 140.927086 | 2022-09-10 04:21:10 | Miyagi, Japan | |||
253321 | 253321 | 2022-09-08 | Japan | Miyagi | 239652 | 340 | 0 | 38.446859 | 140.927086 | 2022-09-09 04:21:11 | Miyagi, Japan | |||
3745119 | 3745119 | 2022-09-07 | Japan | Miyagi | 238043 | 333 | 0 | 38.446859 | 140.927086 | 2022-09-08 04:21:02 | Miyagi, Japan | |||
114759 | 114759 | 2022-09-06 | Japan | Miyagi | 236144 | 327 | 0 | 38.446859 | 140.927086 | 2022-09-07 04:20:59 | Miyagi, Japan | |||
2633731 | 2633731 | 2022-09-05 | Japan | Miyagi | 233767 | 323 | 0 | 38.446859 | 140.927086 | 2022-09-06 04:21:02 | Miyagi, Japan | |||
2987295 | 2987295 | 2022-09-04 | Japan | Miyagi | 233112 | 321 | 0 | 38.446859 | 140.927086 | 2022-09-05 04:21:01 | Miyagi, Japan | |||
2712980 | 2712980 | 2022-09-03 | Japan | Miyagi | 231620 | 315 | 0 | 38.446859 | 140.927086 | 2022-09-04 04:21:22 | Miyagi, Japan | |||
1393685 | 1393685 | 2022-09-02 | Japan | Miyagi | 229984 | 313 | 0 | 38.446859 | 140.927086 | 2022-09-03 04:21:04 | Miyagi, Japan | |||
3547514 | 3547514 | 2022-09-01 | Japan | Miyagi | 227909 | 310 | 0 | 38.446859 | 140.927086 | 2022-09-02 04:21:07 | Miyagi, Japan | |||
2343434 | 2343434 | 2022-08-31 | Japan | Miyagi | 225805 | 306 | 0 | 38.446859 | 140.927086 | 2022-09-01 04:21:03 | Miyagi, Japan | |||
3773914 | 3773914 | 2022-08-30 | Japan | Miyagi | 223153 | 302 | 0 | 38.446859 | 140.927086 | 2022-08-31 04:20:57 | Miyagi, Japan | |||
1680510 | 1680510 | 2022-08-29 | Japan | Miyagi | 220262 | 298 | 0 | 38.446859 | 140.927086 | 2022-08-30 04:21:03 | Miyagi, Japan | |||
1876994 | 1876994 | 2022-08-28 | Japan | Miyagi | 219127 | 295 | 0 | 38.446859 | 140.927086 | 2022-08-29 04:21:06 | Miyagi, Japan | |||
2096121 | 2096121 | 2022-08-27 | Japan | Miyagi | 216918 | 290 | 0 | 38.446859 | 140.927086 | 2022-08-28 04:21:02 | Miyagi, Japan | |||
1531936 | 1531936 | 2022-08-26 | Japan | Miyagi | 214357 | 287 | 0 | 38.446859 | 140.927086 | 2022-08-27 04:20:57 | Miyagi, Japan | |||
2828823 | 2828823 | 2022-08-25 | Japan | Miyagi | 211595 | 285 | 0 | 38.446859 | 140.927086 | 2022-08-26 04:21:02 | Miyagi, Japan | |||
2323356 | 2323356 | 2022-08-24 | Japan | Miyagi | 208437 | 284 | 0 | 38.446859 | 140.927086 | 2022-08-25 04:21:13 | Miyagi, Japan | |||
1250765 | 1250765 | 2022-08-23 | Japan | Miyagi | 204541 | 280 | 0 | 38.446859 | 140.927086 | 2022-08-24 04:20:46 | Miyagi, Japan | |||
2852869 | 2852869 | 2022-08-22 | Japan | Miyagi | 200429 | 276 | 0 | 38.446859 | 140.927086 | 2022-08-23 04:20:56 | Miyagi, Japan | |||
2402841 | 2402841 | 2022-08-21 | Japan | Miyagi | 198701 | 269 | 0 | 38.446859 | 140.927086 | 2022-08-22 04:20:38 | Miyagi, Japan | |||
3797919 | 3797919 | 2022-08-20 | Japan | Miyagi | 195446 | 267 | 0 | 38.446859 | 140.927086 | 2022-08-21 04:20:44 | Miyagi, Japan | |||
2363505 | 2363505 | 2022-08-19 | Japan | Miyagi | 190662 | 263 | 0 | 38.446859 | 140.927086 | 2022-08-20 04:21:01 | Miyagi, Japan | |||
1161176 | 1161176 | 2022-08-18 | Japan | Miyagi | 186095 | 261 | 0 | 38.446859 | 140.927086 | 2022-08-19 04:20:54 | Miyagi, Japan | |||
3950500 | 3950500 | 2022-08-17 | Japan | Miyagi | 182053 | 261 | 0 | 38.446859 | 140.927086 | 2022-08-18 04:21:11 | Miyagi, Japan | |||
991002 | 991002 | 2022-08-16 | Japan | Miyagi | 178429 | 257 | 0 | 38.446859 | 140.927086 | 2022-08-17 04:20:59 | Miyagi, Japan | |||
2494041 | 2494041 | 2022-08-15 | Japan | Miyagi | 175482 | 251 | 0 | 38.446859 | 140.927086 | 2022-08-16 04:20:58 | Miyagi, Japan | |||
3647591 | 3647591 | 2022-08-14 | Japan | Miyagi | 173968 | 248 | 0 | 38.446859 | 140.927086 | 2022-08-15 04:20:59 | Miyagi, Japan | |||
1968597 | 1968597 | 2022-08-13 | Japan | Miyagi | 171550 | 246 | 0 | 38.446859 | 140.927086 | 2022-08-14 04:20:55 | Miyagi, Japan | |||
2888406 | 2888406 | 2022-08-12 | Japan | Miyagi | 168368 | 240 | 0 | 38.446859 | 140.927086 | 2022-08-13 04:20:52 | Miyagi, Japan | |||
3908011 | 3908011 | 2022-08-11 | Japan | Miyagi | 166329 | 239 | 0 | 38.446859 | 140.927086 | 2022-08-12 04:20:54 | Miyagi, Japan | |||
1346328 | 1346328 | 2022-08-10 | Japan | Miyagi | 163062 | 235 | 0 | 38.446859 | 140.927086 | 2022-08-11 04:20:49 | Miyagi, Japan | |||
1086083 | 1086083 | 2022-08-09 | Japan | Miyagi | 158863 | 235 | 0 | 38.446859 | 140.927086 | 2022-08-10 04:20:57 | Miyagi, Japan | |||
3543498 | 3543498 | 2022-08-08 | Japan | Miyagi | 155278 | 231 | 0 | 38.446859 | 140.927086 | 2022-08-09 04:20:34 | Miyagi, Japan | |||
1069901 | 1069901 | 2022-08-07 | Japan | Miyagi | 153778 | 227 | 0 | 38.446859 | 140.927086 | 2022-08-08 04:21:08 | Miyagi, Japan | |||
1940489 | 1940489 | 2022-08-06 | Japan | Miyagi | 151330 | 223 | 0 | 38.446859 | 140.927086 | 2022-08-07 04:20:54 | Miyagi, Japan | |||
880288 | 880288 | 2022-08-05 | Japan | Miyagi | 148295 | 222 | 0 | 38.446859 | 140.927086 | 2022-08-06 04:20:56 | Miyagi, Japan | |||
2008699 | 2008699 | 2022-08-04 | Japan | Miyagi | 145203 | 217 | 0 | 38.446859 | 140.927086 | 2022-08-05 04:20:52 | Miyagi, Japan | |||
1098126 | 1098126 | 2022-08-03 | Japan | Miyagi | 142261 | 214 | 0 | 38.446859 | 140.927086 | 2022-08-04 04:20:58 | Miyagi, Japan | |||
1405051 | 1405051 | 2022-08-02 | Japan | Miyagi | 138790 | 213 | 0 | 38.446859 | 140.927086 | 2022-08-03 04:20:59 | Miyagi, Japan | |||
3617089 | 3617089 | 2022-08-01 | Japan | Miyagi | 135514 | 213 | 0 | 38.446859 | 140.927086 | 2022-08-02 04:20:53 | Miyagi, Japan | |||
3871569 | 3871569 | 2022-07-31 | Japan | Miyagi | 134181 | 213 | 0 | 38.446859 | 140.927086 | 2022-08-01 04:21:03 | Miyagi, Japan | |||
674323 | 674323 | 2022-07-30 | Japan | Miyagi | 131389 | 212 | 0 | 38.446859 | 140.927086 | 2022-07-31 04:21:02 | Miyagi, Japan | |||
1783522 | 1783522 | 2022-07-29 | Japan | Miyagi | 128441 | 212 | 0 | 38.446859 | 140.927086 | 2022-07-30 04:20:42 | Miyagi, Japan | |||
1065885 | 1065885 | 2022-07-28 | Japan | Miyagi | 124730 | 210 | 0 | 38.446859 | 140.927086 | 2022-07-29 04:20:45 | Miyagi, Japan | |||
2335404 | 2335404 | 2022-07-27 | Japan | Miyagi | 121556 | 207 | 0 | 38.446859 | 140.927086 | 2022-07-28 04:20:56 | Miyagi, Japan | |||
1487594 | 1487594 | 2022-07-26 | Japan | Miyagi | 119109 | 207 | 0 | 38.446859 | 140.927086 | 2022-07-27 04:21:04 | Miyagi, Japan | |||
2594040 | 2594040 | 2022-07-25 | Japan | Miyagi | 116605 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-26 04:20:58 | Miyagi, Japan | |||
896155 | 896155 | 2022-07-24 | Japan | Miyagi | 114750 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-25 04:20:51 | Miyagi, Japan | |||
91149 | 91149 | 2022-07-23 | Japan | Miyagi | 112733 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-24 04:20:47 | Miyagi, Japan | |||
900171 | 900171 | 2022-07-22 | Japan | Miyagi | 110526 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-23 04:20:53 | Miyagi, Japan | |||
670307 | 670307 | 2022-07-21 | Japan | Miyagi | 108019 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-22 04:21:15 | Miyagi, Japan | |||
1608270 | 1608270 | 2022-07-20 | Japan | Miyagi | 105814 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-21 04:21:10 | Miyagi, Japan | |||
958903 | 958903 | 2022-07-19 | Japan | Miyagi | 103721 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-20 04:20:59 | Miyagi, Japan | |||
3210290 | 3210290 | 2022-07-18 | Japan | Miyagi | 103289 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-19 04:20:58 | Miyagi, Japan | |||
3405465 | 3405465 | 2022-07-17 | Japan | Miyagi | 102691 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-18 04:20:59 | Miyagi, Japan | |||
2151665 | 2151665 | 2022-07-16 | Japan | Miyagi | 101816 | 204 | 0 | 38.446859 | 140.927086 | 2022-07-17 04:21:15 | Miyagi, Japan | |||
2418898 | 2418898 | 2022-07-15 | Japan | Miyagi | 100858 | 204 | 0 | 38.446859 | 140.927086 | 2022-07-16 04:21:05 | Miyagi, Japan | |||
3428973 | 3428973 | 2022-07-14 | Japan | Miyagi | 100007 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-15 04:20:53 | Miyagi, Japan | |||
3109493 | 3109493 | 2022-07-13 | Japan | Miyagi | 99199 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-14 04:20:57 | Miyagi, Japan | |||
629916 | 629916 | 2022-07-12 | Japan | Miyagi | 98329 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-13 04:20:58 | Miyagi, Japan | |||
1211560 | 1211560 | 2022-07-11 | Japan | Miyagi | 97599 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-12 04:20:51 | Miyagi, Japan | |||
2789042 | 2789042 | 2022-07-10 | Japan | Miyagi | 97414 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-11 04:20:46 | Miyagi, Japan | |||
141995 | 141995 | 2022-07-09 | Japan | Miyagi | 96989 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-10 04:20:54 | Miyagi, Japan | |||
1417095 | 1417095 | 2022-07-08 | Japan | Miyagi | 96476 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-09 04:20:59 | Miyagi, Japan | |||
2741020 | 2741020 | 2022-07-07 | Japan | Miyagi | 96045 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-08 04:20:56 | Miyagi, Japan | |||
1199815 | 1199815 | 2022-07-06 | Japan | Miyagi | 95642 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-07 04:20:55 | Miyagi, Japan | |||
3966558 | 3966558 | 2022-07-05 | Japan | Miyagi | 95151 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-06 04:20:58 | Miyagi, Japan | |||
3078069 | 3078069 | 2022-07-04 | Japan | Miyagi | 94710 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-05 04:20:45 | Miyagi, Japan | |||
1767351 | 1767351 | 2022-07-03 | Japan | Miyagi | 94610 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-04 04:20:54 | Miyagi, Japan | |||
3365337 | 3365337 | 2022-07-02 | Japan | Miyagi | 94410 | 200 | 0 | 38.446859 | 140.927086 | 2022-07-03 04:20:59 | Miyagi, Japan | |||
593666 | 593666 | 2022-07-01 | Japan | Miyagi | 94164 | 200 | 0 | 38.446859 | 140.927086 | 2022-07-02 04:21:16 | Miyagi, Japan | |||
3940067 | 3940067 | 2022-06-30 | Japan | Miyagi | 93948 | 200 | 0 | 38.446859 | 140.927086 | 2022-07-01 04:21:10 | Miyagi, Japan | |||
2490025 | 2490025 | 2022-06-29 | Japan | Miyagi | 93734 | 200 | 0 | 38.446859 | 140.927086 | 2022-06-30 04:21:01 | Miyagi, Japan | |||
2239407 | 2239407 | 2022-06-28 | Japan | Miyagi | 93510 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-29 04:20:59 | Miyagi, Japan | |||
2147649 | 2147649 | 2022-06-27 | Japan | Miyagi | 93273 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-28 04:20:58 | Miyagi, Japan | |||
475450 | 475450 | 2022-06-26 | Japan | Miyagi | 93190 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-27 04:21:00 | Miyagi, Japan | |||
938825 | 938825 | 2022-06-25 | Japan | Miyagi | 93046 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-26 04:21:02 | Miyagi, Japan | |||
3346645 | 3346645 | 2022-06-24 | Japan | Miyagi | 92831 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-25 04:20:57 | Miyagi, Japan | |||
1648386 | 1648386 | 2022-06-23 | Japan | Miyagi | 92619 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-24 04:20:58 | Miyagi, Japan | |||
2187621 | 2187621 | 2022-06-22 | Japan | Miyagi | 92404 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-23 04:20:55 | Miyagi, Japan | |||
166052 | 166052 | 2022-06-21 | Japan | Miyagi | 92133 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-22 04:20:54 | Miyagi, Japan | |||
1763335 | 1763335 | 2022-06-20 | Japan | Miyagi | 91868 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-21 04:20:56 | Miyagi, Japan | |||
3269521 | 3269521 | 2022-06-19 | Japan | Miyagi | 91789 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-20 04:21:01 | Miyagi, Japan | |||
3397433 | 3397433 | 2022-06-18 | Japan | Miyagi | 91574 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-19 04:20:51 | Miyagi, Japan | |||
2311310 | 2311310 | 2022-06-17 | Japan | Miyagi | 91290 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-18 04:21:10 | Miyagi, Japan | |||
558814 | 558814 | 2022-06-16 | Japan | Miyagi | 91073 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-17 04:20:56 | Miyagi, Japan | |||
3982616 | 3982616 | 2022-06-15 | Japan | Miyagi | 90808 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-16 04:20:55 | Miyagi, Japan | |||
946857 | 946857 | 2022-06-14 | Japan | Miyagi | 90461 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-15 04:20:54 | Miyagi, Japan | |||
2979265 | 2979265 | 2022-06-13 | Japan | Miyagi | 90156 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-14 04:20:52 | Miyagi, 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]);