daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Gifu" 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 | Gifu | 282619 | 569 | 0 | 35.778671 | 137.055925 | 2022-09-21 04:23:22 | Gifu, Japan | |||
2022-09-19 | Japan | Gifu | 282050 | 558 | 0 | 35.778671 | 137.055925 | 2022-09-20 04:22:48 | Gifu, Japan | |||
2022-09-18 | Japan | Gifu | 281626 | 555 | 0 | 35.778671 | 137.055925 | 2022-09-19 04:21:49 | Gifu, Japan | |||
2022-09-17 | Japan | Gifu | 280739 | 551 | 0 | 35.778671 | 137.055925 | 2022-09-18 04:22:50 | Gifu, Japan | |||
2022-09-16 | Japan | Gifu | 279660 | 549 | 0 | 35.778671 | 137.055925 | 2022-09-17 04:20:19 | Gifu, Japan | |||
2022-09-15 | Japan | Gifu | 278403 | 544 | 0 | 35.778671 | 137.055925 | 2022-09-16 04:21:19 | Gifu, Japan | |||
2022-09-14 | Japan | Gifu | 277016 | 543 | 0 | 35.778671 | 137.055925 | 2022-09-15 04:21:02 | Gifu, Japan | |||
2022-09-13 | Japan | Gifu | 275497 | 543 | 0 | 35.778671 | 137.055925 | 2022-09-14 04:20:44 | Gifu, Japan | |||
2022-09-12 | Japan | Gifu | 273153 | 539 | 0 | 35.778671 | 137.055925 | 2022-09-13 04:20:57 | Gifu, Japan | |||
2022-09-11 | Japan | Gifu | 272380 | 537 | 0 | 35.778671 | 137.055925 | 2022-09-12 04:20:58 | Gifu, Japan | |||
2022-09-10 | Japan | Gifu | 271016 | 535 | 0 | 35.778671 | 137.055925 | 2022-09-11 04:20:50 | Gifu, Japan | |||
2022-09-09 | Japan | Gifu | 269473 | 530 | 0 | 35.778671 | 137.055925 | 2022-09-10 04:21:10 | Gifu, Japan | |||
2022-09-08 | Japan | Gifu | 267697 | 529 | 0 | 35.778671 | 137.055925 | 2022-09-09 04:21:11 | Gifu, Japan | |||
2022-09-07 | Japan | Gifu | 265686 | 525 | 0 | 35.778671 | 137.055925 | 2022-09-08 04:21:02 | Gifu, Japan | |||
2022-09-06 | Japan | Gifu | 263188 | 521 | 0 | 35.778671 | 137.055925 | 2022-09-07 04:20:59 | Gifu, Japan | |||
2022-09-05 | Japan | Gifu | 259974 | 514 | 0 | 35.778671 | 137.055925 | 2022-09-06 04:21:02 | Gifu, Japan | |||
2022-09-04 | Japan | Gifu | 258921 | 508 | 0 | 35.778671 | 137.055925 | 2022-09-05 04:21:01 | Gifu, Japan | |||
2022-09-03 | Japan | Gifu | 257264 | 503 | 0 | 35.778671 | 137.055925 | 2022-09-04 04:21:22 | Gifu, Japan | |||
2022-09-02 | Japan | Gifu | 254962 | 493 | 0 | 35.778671 | 137.055925 | 2022-09-03 04:21:04 | Gifu, Japan | |||
2022-09-01 | Japan | Gifu | 252922 | 485 | 0 | 35.778671 | 137.055925 | 2022-09-02 04:21:07 | Gifu, Japan | |||
2022-08-31 | Japan | Gifu | 250386 | 482 | 0 | 35.778671 | 137.055925 | 2022-09-01 04:21:03 | Gifu, Japan | |||
2022-08-30 | Japan | Gifu | 247459 | 476 | 0 | 35.778671 | 137.055925 | 2022-08-31 04:20:57 | Gifu, Japan | |||
2022-08-29 | Japan | Gifu | 243424 | 474 | 0 | 35.778671 | 137.055925 | 2022-08-30 04:21:03 | Gifu, Japan | |||
2022-08-28 | Japan | Gifu | 242066 | 471 | 0 | 35.778671 | 137.055925 | 2022-08-29 04:21:06 | Gifu, Japan | |||
2022-08-27 | Japan | Gifu | 239608 | 466 | 0 | 35.778671 | 137.055925 | 2022-08-28 04:21:02 | Gifu, Japan | |||
2022-08-26 | Japan | Gifu | 236633 | 462 | 0 | 35.778671 | 137.055925 | 2022-08-27 04:20:57 | Gifu, Japan | |||
2022-08-25 | Japan | Gifu | 233705 | 451 | 0 | 35.778671 | 137.055925 | 2022-08-26 04:21:02 | Gifu, Japan | |||
2022-08-24 | Japan | Gifu | 230049 | 447 | 0 | 35.778671 | 137.055925 | 2022-08-25 04:21:13 | Gifu, Japan | |||
2022-08-23 | Japan | Gifu | 225853 | 444 | 0 | 35.778671 | 137.055925 | 2022-08-24 04:20:46 | Gifu, Japan | |||
2022-08-22 | Japan | Gifu | 220737 | 439 | 0 | 35.778671 | 137.055925 | 2022-08-23 04:20:56 | Gifu, Japan | |||
2022-08-21 | Japan | Gifu | 219017 | 435 | 0 | 35.778671 | 137.055925 | 2022-08-22 04:20:38 | Gifu, Japan | |||
2022-08-20 | Japan | Gifu | 215692 | 426 | 0 | 35.778671 | 137.055925 | 2022-08-21 04:20:44 | Gifu, Japan | |||
2022-08-19 | Japan | Gifu | 211186 | 423 | 0 | 35.778671 | 137.055925 | 2022-08-20 04:21:01 | Gifu, Japan | |||
2022-08-18 | Japan | Gifu | 207031 | 420 | 0 | 35.778671 | 137.055925 | 2022-08-19 04:20:54 | Gifu, Japan | |||
2022-08-17 | Japan | Gifu | 202541 | 417 | 0 | 35.778671 | 137.055925 | 2022-08-18 04:21:11 | Gifu, Japan | |||
2022-08-16 | Japan | Gifu | 198184 | 412 | 0 | 35.778671 | 137.055925 | 2022-08-17 04:20:59 | Gifu, Japan | |||
2022-08-15 | Japan | Gifu | 194629 | 407 | 0 | 35.778671 | 137.055925 | 2022-08-16 04:20:58 | Gifu, Japan | |||
2022-08-14 | Japan | Gifu | 192643 | 402 | 0 | 35.778671 | 137.055925 | 2022-08-15 04:20:59 | Gifu, Japan | |||
2022-08-13 | Japan | Gifu | 189849 | 400 | 0 | 35.778671 | 137.055925 | 2022-08-14 04:20:55 | Gifu, Japan | |||
2022-08-12 | Japan | Gifu | 185994 | 397 | 0 | 35.778671 | 137.055925 | 2022-08-13 04:20:52 | Gifu, Japan | |||
2022-08-11 | Japan | Gifu | 184588 | 393 | 0 | 35.778671 | 137.055925 | 2022-08-12 04:20:54 | Gifu, Japan | |||
2022-08-10 | Japan | Gifu | 180871 | 391 | 0 | 35.778671 | 137.055925 | 2022-08-11 04:20:49 | Gifu, Japan | |||
2022-08-09 | Japan | Gifu | 177068 | 389 | 0 | 35.778671 | 137.055925 | 2022-08-10 04:20:57 | Gifu, Japan | |||
2022-08-08 | Japan | Gifu | 172344 | 384 | 0 | 35.778671 | 137.055925 | 2022-08-09 04:20:34 | Gifu, Japan | |||
2022-08-07 | Japan | Gifu | 170732 | 382 | 0 | 35.778671 | 137.055925 | 2022-08-08 04:21:08 | Gifu, Japan | |||
2022-08-06 | Japan | Gifu | 167748 | 380 | 0 | 35.778671 | 137.055925 | 2022-08-07 04:20:54 | Gifu, Japan | |||
2022-08-05 | Japan | Gifu | 164656 | 379 | 0 | 35.778671 | 137.055925 | 2022-08-06 04:20:56 | Gifu, Japan | |||
2022-08-04 | Japan | Gifu | 161529 | 378 | 0 | 35.778671 | 137.055925 | 2022-08-05 04:20:52 | Gifu, Japan | |||
2022-08-03 | Japan | Gifu | 158113 | 376 | 0 | 35.778671 | 137.055925 | 2022-08-04 04:20:58 | Gifu, Japan | |||
2022-08-02 | Japan | Gifu | 154649 | 373 | 0 | 35.778671 | 137.055925 | 2022-08-03 04:20:59 | Gifu, Japan | |||
2022-08-01 | Japan | Gifu | 150092 | 372 | 0 | 35.778671 | 137.055925 | 2022-08-02 04:20:53 | Gifu, Japan | |||
2022-07-31 | Japan | Gifu | 148766 | 370 | 0 | 35.778671 | 137.055925 | 2022-08-01 04:21:03 | Gifu, Japan | |||
2022-07-30 | Japan | Gifu | 146552 | 368 | 0 | 35.778671 | 137.055925 | 2022-07-31 04:21:02 | Gifu, Japan | |||
2022-07-29 | Japan | Gifu | 143708 | 363 | 0 | 35.778671 | 137.055925 | 2022-07-30 04:20:42 | Gifu, Japan | |||
2022-07-28 | Japan | Gifu | 141083 | 363 | 0 | 35.778671 | 137.055925 | 2022-07-29 04:20:45 | Gifu, Japan | |||
2022-07-27 | Japan | Gifu | 138300 | 360 | 0 | 35.778671 | 137.055925 | 2022-07-28 04:20:56 | Gifu, Japan | |||
2022-07-26 | Japan | Gifu | 135904 | 358 | 0 | 35.778671 | 137.055925 | 2022-07-27 04:21:04 | Gifu, Japan | |||
2022-07-25 | Japan | Gifu | 132455 | 358 | 0 | 35.778671 | 137.055925 | 2022-07-26 04:20:58 | Gifu, Japan | |||
2022-07-24 | Japan | Gifu | 131365 | 358 | 0 | 35.778671 | 137.055925 | 2022-07-25 04:20:51 | Gifu, Japan | |||
2022-07-23 | Japan | Gifu | 129626 | 357 | 0 | 35.778671 | 137.055925 | 2022-07-24 04:20:47 | Gifu, Japan | |||
2022-07-22 | Japan | Gifu | 127516 | 357 | 0 | 35.778671 | 137.055925 | 2022-07-23 04:20:53 | Gifu, Japan | |||
2022-07-21 | Japan | Gifu | 125519 | 355 | 0 | 35.778671 | 137.055925 | 2022-07-22 04:21:15 | Gifu, Japan | |||
2022-07-20 | Japan | Gifu | 123490 | 354 | 0 | 35.778671 | 137.055925 | 2022-07-21 04:21:10 | Gifu, Japan | |||
2022-07-19 | Japan | Gifu | 120896 | 354 | 0 | 35.778671 | 137.055925 | 2022-07-20 04:20:59 | Gifu, Japan | |||
2022-07-18 | Japan | Gifu | 119880 | 352 | 0 | 35.778671 | 137.055925 | 2022-07-19 04:20:58 | Gifu, Japan | |||
2022-07-17 | Japan | Gifu | 119215 | 352 | 0 | 35.778671 | 137.055925 | 2022-07-18 04:20:59 | Gifu, Japan | |||
2022-07-16 | Japan | Gifu | 118226 | 352 | 0 | 35.778671 | 137.055925 | 2022-07-17 04:21:15 | Gifu, Japan | |||
2022-07-15 | Japan | Gifu | 117018 | 351 | 0 | 35.778671 | 137.055925 | 2022-07-16 04:21:05 | Gifu, Japan | |||
2022-07-14 | Japan | Gifu | 115974 | 351 | 0 | 35.778671 | 137.055925 | 2022-07-15 04:20:53 | Gifu, Japan | |||
2022-07-13 | Japan | Gifu | 114934 | 351 | 0 | 35.778671 | 137.055925 | 2022-07-14 04:20:57 | Gifu, Japan | |||
2022-07-12 | Japan | Gifu | 113942 | 351 | 0 | 35.778671 | 137.055925 | 2022-07-13 04:20:58 | Gifu, Japan | |||
2022-07-11 | Japan | Gifu | 112713 | 350 | 0 | 35.778671 | 137.055925 | 2022-07-12 04:20:51 | Gifu, Japan | |||
2022-07-10 | Japan | Gifu | 112287 | 349 | 0 | 35.778671 | 137.055925 | 2022-07-11 04:20:46 | Gifu, Japan | |||
2022-07-09 | Japan | Gifu | 111642 | 349 | 0 | 35.778671 | 137.055925 | 2022-07-10 04:20:54 | Gifu, Japan | |||
2022-07-08 | Japan | Gifu | 111055 | 349 | 0 | 35.778671 | 137.055925 | 2022-07-09 04:20:59 | Gifu, Japan | |||
2022-07-07 | Japan | Gifu | 110417 | 348 | 0 | 35.778671 | 137.055925 | 2022-07-08 04:20:56 | Gifu, Japan | |||
2022-07-06 | Japan | Gifu | 109884 | 348 | 0 | 35.778671 | 137.055925 | 2022-07-07 04:20:55 | Gifu, Japan | |||
2022-07-05 | Japan | Gifu | 109291 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-06 04:20:58 | Gifu, Japan | |||
2022-07-04 | Japan | Gifu | 108726 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-05 04:20:45 | Gifu, Japan | |||
2022-07-03 | Japan | Gifu | 108503 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-04 04:20:54 | Gifu, Japan | |||
2022-07-02 | Japan | Gifu | 108268 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-03 04:20:59 | Gifu, Japan | |||
2022-07-01 | Japan | Gifu | 107995 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-02 04:21:16 | Gifu, Japan | |||
2022-06-30 | Japan | Gifu | 107715 | 346 | 0 | 35.778671 | 137.055925 | 2022-07-01 04:21:10 | Gifu, Japan | |||
2022-06-29 | Japan | Gifu | 107441 | 346 | 0 | 35.778671 | 137.055925 | 2022-06-30 04:21:01 | Gifu, Japan | |||
2022-06-28 | Japan | Gifu | 107154 | 345 | 0 | 35.778671 | 137.055925 | 2022-06-29 04:20:59 | Gifu, Japan | |||
2022-06-27 | Japan | Gifu | 106803 | 345 | 0 | 35.778671 | 137.055925 | 2022-06-28 04:20:58 | Gifu, Japan | |||
2022-06-26 | Japan | Gifu | 106687 | 345 | 0 | 35.778671 | 137.055925 | 2022-06-27 04:21:00 | Gifu, Japan | |||
2022-06-25 | Japan | Gifu | 106575 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-26 04:21:02 | Gifu, Japan | |||
2022-06-24 | Japan | Gifu | 106337 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-25 04:20:57 | Gifu, Japan | |||
2022-06-23 | Japan | Gifu | 106184 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-24 04:20:58 | Gifu, Japan | |||
2022-06-22 | Japan | Gifu | 105962 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-23 04:20:55 | Gifu, Japan | |||
2022-06-21 | Japan | Gifu | 105816 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-22 04:20:54 | Gifu, Japan | |||
2022-06-20 | Japan | Gifu | 105582 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-21 04:20:56 | Gifu, Japan | |||
2022-06-19 | Japan | Gifu | 105486 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-20 04:21:01 | Gifu, Japan | |||
2022-06-18 | Japan | Gifu | 105359 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-19 04:20:51 | Gifu, Japan | |||
2022-06-17 | Japan | Gifu | 105198 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-18 04:21:10 | Gifu, Japan | |||
2022-06-16 | Japan | Gifu | 104962 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-17 04:20:56 | Gifu, Japan | |||
2022-06-15 | Japan | Gifu | 104735 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-16 04:20:55 | Gifu, Japan | |||
2022-06-14 | Japan | Gifu | 104519 | 341 | 0 | 35.778671 | 137.055925 | 2022-06-15 04:20:54 | Gifu, Japan | |||
2022-06-13 | Japan | Gifu | 104147 | 341 | 0 | 35.778671 | 137.055925 | 2022-06-14 04:20:52 | Gifu, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;