daily_reports (view)
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)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-20 | Japan | Miyagi | 251156 | 378 | 0 | 38.446859 | 140.927086 | 2022-09-21 04:23:22 | Miyagi, Japan | |||
2022-09-19 | Japan | Miyagi | 250805 | 376 | 0 | 38.446859 | 140.927086 | 2022-09-20 04:22:48 | Miyagi, Japan | |||
2022-09-18 | Japan | Miyagi | 250352 | 376 | 0 | 38.446859 | 140.927086 | 2022-09-19 04:21:49 | Miyagi, Japan | |||
2022-09-17 | Japan | Miyagi | 249551 | 376 | 0 | 38.446859 | 140.927086 | 2022-09-18 04:22:50 | Miyagi, Japan | |||
2022-09-16 | Japan | Miyagi | 248552 | 375 | 0 | 38.446859 | 140.927086 | 2022-09-17 04:20:19 | Miyagi, Japan | |||
2022-09-15 | Japan | Miyagi | 247622 | 372 | 0 | 38.446859 | 140.927086 | 2022-09-16 04:21:19 | Miyagi, Japan | |||
2022-09-14 | Japan | Miyagi | 246590 | 366 | 0 | 38.446859 | 140.927086 | 2022-09-15 04:21:02 | Miyagi, Japan | |||
2022-09-13 | Japan | Miyagi | 245295 | 360 | 0 | 38.446859 | 140.927086 | 2022-09-14 04:20:44 | Miyagi, Japan | |||
2022-09-12 | Japan | Miyagi | 243566 | 355 | 0 | 38.446859 | 140.927086 | 2022-09-13 04:20:57 | Miyagi, Japan | |||
2022-09-11 | Japan | Miyagi | 243107 | 354 | 0 | 38.446859 | 140.927086 | 2022-09-12 04:20:58 | Miyagi, Japan | |||
2022-09-10 | Japan | Miyagi | 242226 | 347 | 0 | 38.446859 | 140.927086 | 2022-09-11 04:20:50 | Miyagi, Japan | |||
2022-09-09 | Japan | Miyagi | 240949 | 345 | 0 | 38.446859 | 140.927086 | 2022-09-10 04:21:10 | Miyagi, Japan | |||
2022-09-08 | Japan | Miyagi | 239652 | 340 | 0 | 38.446859 | 140.927086 | 2022-09-09 04:21:11 | Miyagi, Japan | |||
2022-09-07 | Japan | Miyagi | 238043 | 333 | 0 | 38.446859 | 140.927086 | 2022-09-08 04:21:02 | Miyagi, Japan | |||
2022-09-06 | Japan | Miyagi | 236144 | 327 | 0 | 38.446859 | 140.927086 | 2022-09-07 04:20:59 | Miyagi, Japan | |||
2022-09-05 | Japan | Miyagi | 233767 | 323 | 0 | 38.446859 | 140.927086 | 2022-09-06 04:21:02 | Miyagi, Japan | |||
2022-09-04 | Japan | Miyagi | 233112 | 321 | 0 | 38.446859 | 140.927086 | 2022-09-05 04:21:01 | Miyagi, Japan | |||
2022-09-03 | Japan | Miyagi | 231620 | 315 | 0 | 38.446859 | 140.927086 | 2022-09-04 04:21:22 | Miyagi, Japan | |||
2022-09-02 | Japan | Miyagi | 229984 | 313 | 0 | 38.446859 | 140.927086 | 2022-09-03 04:21:04 | Miyagi, Japan | |||
2022-09-01 | Japan | Miyagi | 227909 | 310 | 0 | 38.446859 | 140.927086 | 2022-09-02 04:21:07 | Miyagi, Japan | |||
2022-08-31 | Japan | Miyagi | 225805 | 306 | 0 | 38.446859 | 140.927086 | 2022-09-01 04:21:03 | Miyagi, Japan | |||
2022-08-30 | Japan | Miyagi | 223153 | 302 | 0 | 38.446859 | 140.927086 | 2022-08-31 04:20:57 | Miyagi, Japan | |||
2022-08-29 | Japan | Miyagi | 220262 | 298 | 0 | 38.446859 | 140.927086 | 2022-08-30 04:21:03 | Miyagi, Japan | |||
2022-08-28 | Japan | Miyagi | 219127 | 295 | 0 | 38.446859 | 140.927086 | 2022-08-29 04:21:06 | Miyagi, Japan | |||
2022-08-27 | Japan | Miyagi | 216918 | 290 | 0 | 38.446859 | 140.927086 | 2022-08-28 04:21:02 | Miyagi, Japan | |||
2022-08-26 | Japan | Miyagi | 214357 | 287 | 0 | 38.446859 | 140.927086 | 2022-08-27 04:20:57 | Miyagi, Japan | |||
2022-08-25 | Japan | Miyagi | 211595 | 285 | 0 | 38.446859 | 140.927086 | 2022-08-26 04:21:02 | Miyagi, Japan | |||
2022-08-24 | Japan | Miyagi | 208437 | 284 | 0 | 38.446859 | 140.927086 | 2022-08-25 04:21:13 | Miyagi, Japan | |||
2022-08-23 | Japan | Miyagi | 204541 | 280 | 0 | 38.446859 | 140.927086 | 2022-08-24 04:20:46 | Miyagi, Japan | |||
2022-08-22 | Japan | Miyagi | 200429 | 276 | 0 | 38.446859 | 140.927086 | 2022-08-23 04:20:56 | Miyagi, Japan | |||
2022-08-21 | Japan | Miyagi | 198701 | 269 | 0 | 38.446859 | 140.927086 | 2022-08-22 04:20:38 | Miyagi, Japan | |||
2022-08-20 | Japan | Miyagi | 195446 | 267 | 0 | 38.446859 | 140.927086 | 2022-08-21 04:20:44 | Miyagi, Japan | |||
2022-08-19 | Japan | Miyagi | 190662 | 263 | 0 | 38.446859 | 140.927086 | 2022-08-20 04:21:01 | Miyagi, Japan | |||
2022-08-18 | Japan | Miyagi | 186095 | 261 | 0 | 38.446859 | 140.927086 | 2022-08-19 04:20:54 | Miyagi, Japan | |||
2022-08-17 | Japan | Miyagi | 182053 | 261 | 0 | 38.446859 | 140.927086 | 2022-08-18 04:21:11 | Miyagi, Japan | |||
2022-08-16 | Japan | Miyagi | 178429 | 257 | 0 | 38.446859 | 140.927086 | 2022-08-17 04:20:59 | Miyagi, Japan | |||
2022-08-15 | Japan | Miyagi | 175482 | 251 | 0 | 38.446859 | 140.927086 | 2022-08-16 04:20:58 | Miyagi, Japan | |||
2022-08-14 | Japan | Miyagi | 173968 | 248 | 0 | 38.446859 | 140.927086 | 2022-08-15 04:20:59 | Miyagi, Japan | |||
2022-08-13 | Japan | Miyagi | 171550 | 246 | 0 | 38.446859 | 140.927086 | 2022-08-14 04:20:55 | Miyagi, Japan | |||
2022-08-12 | Japan | Miyagi | 168368 | 240 | 0 | 38.446859 | 140.927086 | 2022-08-13 04:20:52 | Miyagi, Japan | |||
2022-08-11 | Japan | Miyagi | 166329 | 239 | 0 | 38.446859 | 140.927086 | 2022-08-12 04:20:54 | Miyagi, Japan | |||
2022-08-10 | Japan | Miyagi | 163062 | 235 | 0 | 38.446859 | 140.927086 | 2022-08-11 04:20:49 | Miyagi, Japan | |||
2022-08-09 | Japan | Miyagi | 158863 | 235 | 0 | 38.446859 | 140.927086 | 2022-08-10 04:20:57 | Miyagi, Japan | |||
2022-08-08 | Japan | Miyagi | 155278 | 231 | 0 | 38.446859 | 140.927086 | 2022-08-09 04:20:34 | Miyagi, Japan | |||
2022-08-07 | Japan | Miyagi | 153778 | 227 | 0 | 38.446859 | 140.927086 | 2022-08-08 04:21:08 | Miyagi, Japan | |||
2022-08-06 | Japan | Miyagi | 151330 | 223 | 0 | 38.446859 | 140.927086 | 2022-08-07 04:20:54 | Miyagi, Japan | |||
2022-08-05 | Japan | Miyagi | 148295 | 222 | 0 | 38.446859 | 140.927086 | 2022-08-06 04:20:56 | Miyagi, Japan | |||
2022-08-04 | Japan | Miyagi | 145203 | 217 | 0 | 38.446859 | 140.927086 | 2022-08-05 04:20:52 | Miyagi, Japan | |||
2022-08-03 | Japan | Miyagi | 142261 | 214 | 0 | 38.446859 | 140.927086 | 2022-08-04 04:20:58 | Miyagi, Japan | |||
2022-08-02 | Japan | Miyagi | 138790 | 213 | 0 | 38.446859 | 140.927086 | 2022-08-03 04:20:59 | Miyagi, Japan | |||
2022-08-01 | Japan | Miyagi | 135514 | 213 | 0 | 38.446859 | 140.927086 | 2022-08-02 04:20:53 | Miyagi, Japan | |||
2022-07-31 | Japan | Miyagi | 134181 | 213 | 0 | 38.446859 | 140.927086 | 2022-08-01 04:21:03 | Miyagi, Japan | |||
2022-07-30 | Japan | Miyagi | 131389 | 212 | 0 | 38.446859 | 140.927086 | 2022-07-31 04:21:02 | Miyagi, Japan | |||
2022-07-29 | Japan | Miyagi | 128441 | 212 | 0 | 38.446859 | 140.927086 | 2022-07-30 04:20:42 | Miyagi, Japan | |||
2022-07-28 | Japan | Miyagi | 124730 | 210 | 0 | 38.446859 | 140.927086 | 2022-07-29 04:20:45 | Miyagi, Japan | |||
2022-07-27 | Japan | Miyagi | 121556 | 207 | 0 | 38.446859 | 140.927086 | 2022-07-28 04:20:56 | Miyagi, Japan | |||
2022-07-26 | Japan | Miyagi | 119109 | 207 | 0 | 38.446859 | 140.927086 | 2022-07-27 04:21:04 | Miyagi, Japan | |||
2022-07-25 | Japan | Miyagi | 116605 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-26 04:20:58 | Miyagi, Japan | |||
2022-07-24 | Japan | Miyagi | 114750 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-25 04:20:51 | Miyagi, Japan | |||
2022-07-23 | Japan | Miyagi | 112733 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-24 04:20:47 | Miyagi, Japan | |||
2022-07-22 | Japan | Miyagi | 110526 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-23 04:20:53 | Miyagi, Japan | |||
2022-07-21 | Japan | Miyagi | 108019 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-22 04:21:15 | Miyagi, Japan | |||
2022-07-20 | Japan | Miyagi | 105814 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-21 04:21:10 | Miyagi, Japan | |||
2022-07-19 | Japan | Miyagi | 103721 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-20 04:20:59 | Miyagi, Japan | |||
2022-07-18 | Japan | Miyagi | 103289 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-19 04:20:58 | Miyagi, Japan | |||
2022-07-17 | Japan | Miyagi | 102691 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-18 04:20:59 | Miyagi, Japan | |||
2022-07-16 | Japan | Miyagi | 101816 | 204 | 0 | 38.446859 | 140.927086 | 2022-07-17 04:21:15 | Miyagi, Japan | |||
2022-07-15 | Japan | Miyagi | 100858 | 204 | 0 | 38.446859 | 140.927086 | 2022-07-16 04:21:05 | Miyagi, Japan | |||
2022-07-14 | Japan | Miyagi | 100007 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-15 04:20:53 | Miyagi, Japan | |||
2022-07-13 | Japan | Miyagi | 99199 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-14 04:20:57 | Miyagi, Japan | |||
2022-07-12 | Japan | Miyagi | 98329 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-13 04:20:58 | Miyagi, Japan | |||
2022-07-11 | Japan | Miyagi | 97599 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-12 04:20:51 | Miyagi, Japan | |||
2022-07-10 | Japan | Miyagi | 97414 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-11 04:20:46 | Miyagi, Japan | |||
2022-07-09 | Japan | Miyagi | 96989 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-10 04:20:54 | Miyagi, Japan | |||
2022-07-08 | Japan | Miyagi | 96476 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-09 04:20:59 | Miyagi, Japan | |||
2022-07-07 | Japan | Miyagi | 96045 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-08 04:20:56 | Miyagi, Japan | |||
2022-07-06 | Japan | Miyagi | 95642 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-07 04:20:55 | Miyagi, Japan | |||
2022-07-05 | Japan | Miyagi | 95151 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-06 04:20:58 | Miyagi, Japan | |||
2022-07-04 | Japan | Miyagi | 94710 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-05 04:20:45 | Miyagi, Japan | |||
2022-07-03 | Japan | Miyagi | 94610 | 201 | 0 | 38.446859 | 140.927086 | 2022-07-04 04:20:54 | Miyagi, Japan | |||
2022-07-02 | Japan | Miyagi | 94410 | 200 | 0 | 38.446859 | 140.927086 | 2022-07-03 04:20:59 | Miyagi, Japan | |||
2022-07-01 | Japan | Miyagi | 94164 | 200 | 0 | 38.446859 | 140.927086 | 2022-07-02 04:21:16 | Miyagi, Japan | |||
2022-06-30 | Japan | Miyagi | 93948 | 200 | 0 | 38.446859 | 140.927086 | 2022-07-01 04:21:10 | Miyagi, Japan | |||
2022-06-29 | Japan | Miyagi | 93734 | 200 | 0 | 38.446859 | 140.927086 | 2022-06-30 04:21:01 | Miyagi, Japan | |||
2022-06-28 | Japan | Miyagi | 93510 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-29 04:20:59 | Miyagi, Japan | |||
2022-06-27 | Japan | Miyagi | 93273 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-28 04:20:58 | Miyagi, Japan | |||
2022-06-26 | Japan | Miyagi | 93190 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-27 04:21:00 | Miyagi, Japan | |||
2022-06-25 | Japan | Miyagi | 93046 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-26 04:21:02 | Miyagi, Japan | |||
2022-06-24 | Japan | Miyagi | 92831 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-25 04:20:57 | Miyagi, Japan | |||
2022-06-23 | Japan | Miyagi | 92619 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-24 04:20:58 | Miyagi, Japan | |||
2022-06-22 | Japan | Miyagi | 92404 | 199 | 0 | 38.446859 | 140.927086 | 2022-06-23 04:20:55 | Miyagi, Japan | |||
2022-06-21 | Japan | Miyagi | 92133 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-22 04:20:54 | Miyagi, Japan | |||
2022-06-20 | Japan | Miyagi | 91868 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-21 04:20:56 | Miyagi, Japan | |||
2022-06-19 | Japan | Miyagi | 91789 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-20 04:21:01 | Miyagi, Japan | |||
2022-06-18 | Japan | Miyagi | 91574 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-19 04:20:51 | Miyagi, Japan | |||
2022-06-17 | Japan | Miyagi | 91290 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-18 04:21:10 | Miyagi, Japan | |||
2022-06-16 | Japan | Miyagi | 91073 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-17 04:20:56 | Miyagi, Japan | |||
2022-06-15 | Japan | Miyagi | 90808 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-16 04:20:55 | Miyagi, Japan | |||
2022-06-14 | Japan | Miyagi | 90461 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-15 04:20:54 | Miyagi, Japan | |||
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;