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 = "Gifu" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016716 | 2016716 | 2022-09-20 | Japan | Gifu | 282619 | 569 | 0 | 35.778671 | 137.055925 | 2022-09-21 04:23:22 | Gifu, Japan | |||
3570589 | 3570589 | 2022-09-19 | Japan | Gifu | 282050 | 558 | 0 | 35.778671 | 137.055925 | 2022-09-20 04:22:48 | Gifu, Japan | |||
419328 | 419328 | 2022-09-18 | Japan | Gifu | 281626 | 555 | 0 | 35.778671 | 137.055925 | 2022-09-19 04:21:49 | Gifu, Japan | |||
3373352 | 3373352 | 2022-09-17 | Japan | Gifu | 280739 | 551 | 0 | 35.778671 | 137.055925 | 2022-09-18 04:22:50 | Gifu, Japan | |||
2355460 | 2355460 | 2022-09-16 | Japan | Gifu | 279660 | 549 | 0 | 35.778671 | 137.055925 | 2022-09-17 04:20:19 | Gifu, Japan | |||
3986617 | 3986617 | 2022-09-15 | Japan | Gifu | 278403 | 544 | 0 | 35.778671 | 137.055925 | 2022-09-16 04:21:19 | Gifu, Japan | |||
1889134 | 1889134 | 2022-09-14 | Japan | Gifu | 277016 | 543 | 0 | 35.778671 | 137.055925 | 2022-09-15 04:21:02 | Gifu, Japan | |||
372189 | 372189 | 2022-09-13 | Japan | Gifu | 275497 | 543 | 0 | 35.778671 | 137.055925 | 2022-09-14 04:20:44 | Gifu, Japan | |||
2394794 | 2394794 | 2022-09-12 | Japan | Gifu | 273153 | 539 | 0 | 35.778671 | 137.055925 | 2022-09-13 04:20:57 | Gifu, Japan | |||
3765872 | 3765872 | 2022-09-11 | Japan | Gifu | 272380 | 537 | 0 | 35.778671 | 137.055925 | 2022-09-12 04:20:58 | Gifu, Japan | |||
3824447 | 3824447 | 2022-09-10 | Japan | Gifu | 271016 | 535 | 0 | 35.778671 | 137.055925 | 2022-09-11 04:20:50 | Gifu, Japan | |||
962904 | 962904 | 2022-09-09 | Japan | Gifu | 269473 | 530 | 0 | 35.778671 | 137.055925 | 2022-09-10 04:21:10 | Gifu, Japan | |||
253306 | 253306 | 2022-09-08 | Japan | Gifu | 267697 | 529 | 0 | 35.778671 | 137.055925 | 2022-09-09 04:21:11 | Gifu, Japan | |||
3745104 | 3745104 | 2022-09-07 | Japan | Gifu | 265686 | 525 | 0 | 35.778671 | 137.055925 | 2022-09-08 04:21:02 | Gifu, Japan | |||
114744 | 114744 | 2022-09-06 | Japan | Gifu | 263188 | 521 | 0 | 35.778671 | 137.055925 | 2022-09-07 04:20:59 | Gifu, Japan | |||
2633716 | 2633716 | 2022-09-05 | Japan | Gifu | 259974 | 514 | 0 | 35.778671 | 137.055925 | 2022-09-06 04:21:02 | Gifu, Japan | |||
2987280 | 2987280 | 2022-09-04 | Japan | Gifu | 258921 | 508 | 0 | 35.778671 | 137.055925 | 2022-09-05 04:21:01 | Gifu, Japan | |||
2712965 | 2712965 | 2022-09-03 | Japan | Gifu | 257264 | 503 | 0 | 35.778671 | 137.055925 | 2022-09-04 04:21:22 | Gifu, Japan | |||
1393670 | 1393670 | 2022-09-02 | Japan | Gifu | 254962 | 493 | 0 | 35.778671 | 137.055925 | 2022-09-03 04:21:04 | Gifu, Japan | |||
3547499 | 3547499 | 2022-09-01 | Japan | Gifu | 252922 | 485 | 0 | 35.778671 | 137.055925 | 2022-09-02 04:21:07 | Gifu, Japan | |||
2343419 | 2343419 | 2022-08-31 | Japan | Gifu | 250386 | 482 | 0 | 35.778671 | 137.055925 | 2022-09-01 04:21:03 | Gifu, Japan | |||
3773899 | 3773899 | 2022-08-30 | Japan | Gifu | 247459 | 476 | 0 | 35.778671 | 137.055925 | 2022-08-31 04:20:57 | Gifu, Japan | |||
1680495 | 1680495 | 2022-08-29 | Japan | Gifu | 243424 | 474 | 0 | 35.778671 | 137.055925 | 2022-08-30 04:21:03 | Gifu, Japan | |||
1876979 | 1876979 | 2022-08-28 | Japan | Gifu | 242066 | 471 | 0 | 35.778671 | 137.055925 | 2022-08-29 04:21:06 | Gifu, Japan | |||
2096106 | 2096106 | 2022-08-27 | Japan | Gifu | 239608 | 466 | 0 | 35.778671 | 137.055925 | 2022-08-28 04:21:02 | Gifu, Japan | |||
1531921 | 1531921 | 2022-08-26 | Japan | Gifu | 236633 | 462 | 0 | 35.778671 | 137.055925 | 2022-08-27 04:20:57 | Gifu, Japan | |||
2828808 | 2828808 | 2022-08-25 | Japan | Gifu | 233705 | 451 | 0 | 35.778671 | 137.055925 | 2022-08-26 04:21:02 | Gifu, Japan | |||
2323341 | 2323341 | 2022-08-24 | Japan | Gifu | 230049 | 447 | 0 | 35.778671 | 137.055925 | 2022-08-25 04:21:13 | Gifu, Japan | |||
1250750 | 1250750 | 2022-08-23 | Japan | Gifu | 225853 | 444 | 0 | 35.778671 | 137.055925 | 2022-08-24 04:20:46 | Gifu, Japan | |||
2852854 | 2852854 | 2022-08-22 | Japan | Gifu | 220737 | 439 | 0 | 35.778671 | 137.055925 | 2022-08-23 04:20:56 | Gifu, Japan | |||
2402826 | 2402826 | 2022-08-21 | Japan | Gifu | 219017 | 435 | 0 | 35.778671 | 137.055925 | 2022-08-22 04:20:38 | Gifu, Japan | |||
3797904 | 3797904 | 2022-08-20 | Japan | Gifu | 215692 | 426 | 0 | 35.778671 | 137.055925 | 2022-08-21 04:20:44 | Gifu, Japan | |||
2363490 | 2363490 | 2022-08-19 | Japan | Gifu | 211186 | 423 | 0 | 35.778671 | 137.055925 | 2022-08-20 04:21:01 | Gifu, Japan | |||
1161161 | 1161161 | 2022-08-18 | Japan | Gifu | 207031 | 420 | 0 | 35.778671 | 137.055925 | 2022-08-19 04:20:54 | Gifu, Japan | |||
3950485 | 3950485 | 2022-08-17 | Japan | Gifu | 202541 | 417 | 0 | 35.778671 | 137.055925 | 2022-08-18 04:21:11 | Gifu, Japan | |||
990987 | 990987 | 2022-08-16 | Japan | Gifu | 198184 | 412 | 0 | 35.778671 | 137.055925 | 2022-08-17 04:20:59 | Gifu, Japan | |||
2494026 | 2494026 | 2022-08-15 | Japan | Gifu | 194629 | 407 | 0 | 35.778671 | 137.055925 | 2022-08-16 04:20:58 | Gifu, Japan | |||
3647576 | 3647576 | 2022-08-14 | Japan | Gifu | 192643 | 402 | 0 | 35.778671 | 137.055925 | 2022-08-15 04:20:59 | Gifu, Japan | |||
1968582 | 1968582 | 2022-08-13 | Japan | Gifu | 189849 | 400 | 0 | 35.778671 | 137.055925 | 2022-08-14 04:20:55 | Gifu, Japan | |||
2888391 | 2888391 | 2022-08-12 | Japan | Gifu | 185994 | 397 | 0 | 35.778671 | 137.055925 | 2022-08-13 04:20:52 | Gifu, Japan | |||
3907996 | 3907996 | 2022-08-11 | Japan | Gifu | 184588 | 393 | 0 | 35.778671 | 137.055925 | 2022-08-12 04:20:54 | Gifu, Japan | |||
1346313 | 1346313 | 2022-08-10 | Japan | Gifu | 180871 | 391 | 0 | 35.778671 | 137.055925 | 2022-08-11 04:20:49 | Gifu, Japan | |||
1086068 | 1086068 | 2022-08-09 | Japan | Gifu | 177068 | 389 | 0 | 35.778671 | 137.055925 | 2022-08-10 04:20:57 | Gifu, Japan | |||
3543483 | 3543483 | 2022-08-08 | Japan | Gifu | 172344 | 384 | 0 | 35.778671 | 137.055925 | 2022-08-09 04:20:34 | Gifu, Japan | |||
1069886 | 1069886 | 2022-08-07 | Japan | Gifu | 170732 | 382 | 0 | 35.778671 | 137.055925 | 2022-08-08 04:21:08 | Gifu, Japan | |||
1940474 | 1940474 | 2022-08-06 | Japan | Gifu | 167748 | 380 | 0 | 35.778671 | 137.055925 | 2022-08-07 04:20:54 | Gifu, Japan | |||
880273 | 880273 | 2022-08-05 | Japan | Gifu | 164656 | 379 | 0 | 35.778671 | 137.055925 | 2022-08-06 04:20:56 | Gifu, Japan | |||
2008684 | 2008684 | 2022-08-04 | Japan | Gifu | 161529 | 378 | 0 | 35.778671 | 137.055925 | 2022-08-05 04:20:52 | Gifu, Japan | |||
1098111 | 1098111 | 2022-08-03 | Japan | Gifu | 158113 | 376 | 0 | 35.778671 | 137.055925 | 2022-08-04 04:20:58 | Gifu, Japan | |||
1405036 | 1405036 | 2022-08-02 | Japan | Gifu | 154649 | 373 | 0 | 35.778671 | 137.055925 | 2022-08-03 04:20:59 | Gifu, Japan | |||
3617074 | 3617074 | 2022-08-01 | Japan | Gifu | 150092 | 372 | 0 | 35.778671 | 137.055925 | 2022-08-02 04:20:53 | Gifu, Japan | |||
3871554 | 3871554 | 2022-07-31 | Japan | Gifu | 148766 | 370 | 0 | 35.778671 | 137.055925 | 2022-08-01 04:21:03 | Gifu, Japan | |||
674308 | 674308 | 2022-07-30 | Japan | Gifu | 146552 | 368 | 0 | 35.778671 | 137.055925 | 2022-07-31 04:21:02 | Gifu, Japan | |||
1783507 | 1783507 | 2022-07-29 | Japan | Gifu | 143708 | 363 | 0 | 35.778671 | 137.055925 | 2022-07-30 04:20:42 | Gifu, Japan | |||
1065870 | 1065870 | 2022-07-28 | Japan | Gifu | 141083 | 363 | 0 | 35.778671 | 137.055925 | 2022-07-29 04:20:45 | Gifu, Japan | |||
2335389 | 2335389 | 2022-07-27 | Japan | Gifu | 138300 | 360 | 0 | 35.778671 | 137.055925 | 2022-07-28 04:20:56 | Gifu, Japan | |||
1487579 | 1487579 | 2022-07-26 | Japan | Gifu | 135904 | 358 | 0 | 35.778671 | 137.055925 | 2022-07-27 04:21:04 | Gifu, Japan | |||
2594025 | 2594025 | 2022-07-25 | Japan | Gifu | 132455 | 358 | 0 | 35.778671 | 137.055925 | 2022-07-26 04:20:58 | Gifu, Japan | |||
896140 | 896140 | 2022-07-24 | Japan | Gifu | 131365 | 358 | 0 | 35.778671 | 137.055925 | 2022-07-25 04:20:51 | Gifu, Japan | |||
91134 | 91134 | 2022-07-23 | Japan | Gifu | 129626 | 357 | 0 | 35.778671 | 137.055925 | 2022-07-24 04:20:47 | Gifu, Japan | |||
900156 | 900156 | 2022-07-22 | Japan | Gifu | 127516 | 357 | 0 | 35.778671 | 137.055925 | 2022-07-23 04:20:53 | Gifu, Japan | |||
670292 | 670292 | 2022-07-21 | Japan | Gifu | 125519 | 355 | 0 | 35.778671 | 137.055925 | 2022-07-22 04:21:15 | Gifu, Japan | |||
1608255 | 1608255 | 2022-07-20 | Japan | Gifu | 123490 | 354 | 0 | 35.778671 | 137.055925 | 2022-07-21 04:21:10 | Gifu, Japan | |||
958888 | 958888 | 2022-07-19 | Japan | Gifu | 120896 | 354 | 0 | 35.778671 | 137.055925 | 2022-07-20 04:20:59 | Gifu, Japan | |||
3210275 | 3210275 | 2022-07-18 | Japan | Gifu | 119880 | 352 | 0 | 35.778671 | 137.055925 | 2022-07-19 04:20:58 | Gifu, Japan | |||
3405450 | 3405450 | 2022-07-17 | Japan | Gifu | 119215 | 352 | 0 | 35.778671 | 137.055925 | 2022-07-18 04:20:59 | Gifu, Japan | |||
2151650 | 2151650 | 2022-07-16 | Japan | Gifu | 118226 | 352 | 0 | 35.778671 | 137.055925 | 2022-07-17 04:21:15 | Gifu, Japan | |||
2418883 | 2418883 | 2022-07-15 | Japan | Gifu | 117018 | 351 | 0 | 35.778671 | 137.055925 | 2022-07-16 04:21:05 | Gifu, Japan | |||
3428958 | 3428958 | 2022-07-14 | Japan | Gifu | 115974 | 351 | 0 | 35.778671 | 137.055925 | 2022-07-15 04:20:53 | Gifu, Japan | |||
3109478 | 3109478 | 2022-07-13 | Japan | Gifu | 114934 | 351 | 0 | 35.778671 | 137.055925 | 2022-07-14 04:20:57 | Gifu, Japan | |||
629901 | 629901 | 2022-07-12 | Japan | Gifu | 113942 | 351 | 0 | 35.778671 | 137.055925 | 2022-07-13 04:20:58 | Gifu, Japan | |||
1211545 | 1211545 | 2022-07-11 | Japan | Gifu | 112713 | 350 | 0 | 35.778671 | 137.055925 | 2022-07-12 04:20:51 | Gifu, Japan | |||
2789027 | 2789027 | 2022-07-10 | Japan | Gifu | 112287 | 349 | 0 | 35.778671 | 137.055925 | 2022-07-11 04:20:46 | Gifu, Japan | |||
141980 | 141980 | 2022-07-09 | Japan | Gifu | 111642 | 349 | 0 | 35.778671 | 137.055925 | 2022-07-10 04:20:54 | Gifu, Japan | |||
1417080 | 1417080 | 2022-07-08 | Japan | Gifu | 111055 | 349 | 0 | 35.778671 | 137.055925 | 2022-07-09 04:20:59 | Gifu, Japan | |||
2741005 | 2741005 | 2022-07-07 | Japan | Gifu | 110417 | 348 | 0 | 35.778671 | 137.055925 | 2022-07-08 04:20:56 | Gifu, Japan | |||
1199800 | 1199800 | 2022-07-06 | Japan | Gifu | 109884 | 348 | 0 | 35.778671 | 137.055925 | 2022-07-07 04:20:55 | Gifu, Japan | |||
3966543 | 3966543 | 2022-07-05 | Japan | Gifu | 109291 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-06 04:20:58 | Gifu, Japan | |||
3078054 | 3078054 | 2022-07-04 | Japan | Gifu | 108726 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-05 04:20:45 | Gifu, Japan | |||
1767336 | 1767336 | 2022-07-03 | Japan | Gifu | 108503 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-04 04:20:54 | Gifu, Japan | |||
3365322 | 3365322 | 2022-07-02 | Japan | Gifu | 108268 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-03 04:20:59 | Gifu, Japan | |||
593651 | 593651 | 2022-07-01 | Japan | Gifu | 107995 | 347 | 0 | 35.778671 | 137.055925 | 2022-07-02 04:21:16 | Gifu, Japan | |||
3940052 | 3940052 | 2022-06-30 | Japan | Gifu | 107715 | 346 | 0 | 35.778671 | 137.055925 | 2022-07-01 04:21:10 | Gifu, Japan | |||
2490010 | 2490010 | 2022-06-29 | Japan | Gifu | 107441 | 346 | 0 | 35.778671 | 137.055925 | 2022-06-30 04:21:01 | Gifu, Japan | |||
2239392 | 2239392 | 2022-06-28 | Japan | Gifu | 107154 | 345 | 0 | 35.778671 | 137.055925 | 2022-06-29 04:20:59 | Gifu, Japan | |||
2147634 | 2147634 | 2022-06-27 | Japan | Gifu | 106803 | 345 | 0 | 35.778671 | 137.055925 | 2022-06-28 04:20:58 | Gifu, Japan | |||
475435 | 475435 | 2022-06-26 | Japan | Gifu | 106687 | 345 | 0 | 35.778671 | 137.055925 | 2022-06-27 04:21:00 | Gifu, Japan | |||
938810 | 938810 | 2022-06-25 | Japan | Gifu | 106575 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-26 04:21:02 | Gifu, Japan | |||
3346630 | 3346630 | 2022-06-24 | Japan | Gifu | 106337 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-25 04:20:57 | Gifu, Japan | |||
1648371 | 1648371 | 2022-06-23 | Japan | Gifu | 106184 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-24 04:20:58 | Gifu, Japan | |||
2187606 | 2187606 | 2022-06-22 | Japan | Gifu | 105962 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-23 04:20:55 | Gifu, Japan | |||
166037 | 166037 | 2022-06-21 | Japan | Gifu | 105816 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-22 04:20:54 | Gifu, Japan | |||
1763320 | 1763320 | 2022-06-20 | Japan | Gifu | 105582 | 344 | 0 | 35.778671 | 137.055925 | 2022-06-21 04:20:56 | Gifu, Japan | |||
3269506 | 3269506 | 2022-06-19 | Japan | Gifu | 105486 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-20 04:21:01 | Gifu, Japan | |||
3397418 | 3397418 | 2022-06-18 | Japan | Gifu | 105359 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-19 04:20:51 | Gifu, Japan | |||
2311295 | 2311295 | 2022-06-17 | Japan | Gifu | 105198 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-18 04:21:10 | Gifu, Japan | |||
558799 | 558799 | 2022-06-16 | Japan | Gifu | 104962 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-17 04:20:56 | Gifu, Japan | |||
3982601 | 3982601 | 2022-06-15 | Japan | Gifu | 104735 | 343 | 0 | 35.778671 | 137.055925 | 2022-06-16 04:20:55 | Gifu, Japan | |||
946842 | 946842 | 2022-06-14 | Japan | Gifu | 104519 | 341 | 0 | 35.778671 | 137.055925 | 2022-06-15 04:20:54 | Gifu, Japan | |||
2979250 | 2979250 | 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 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]);