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 = "Aomori" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462794 | 2462794 | 2021-09-14 | Japan | Aomori | 5213 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-15 03:22:37 | Aomori, Japan | |||
1385633 | 1385633 | 2021-09-13 | Japan | Aomori | 5164 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-14 04:21:41 | Aomori, Japan | |||
1885002 | 1885002 | 2021-09-12 | Japan | Aomori | 5141 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-13 04:21:15 | Aomori, Japan | |||
3805905 | 3805905 | 2021-09-11 | Japan | Aomori | 5095 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-12 04:21:13 | Aomori, Japan | |||
3448845 | 3448845 | 2021-09-10 | Japan | Aomori | 5051 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-11 04:21:30 | Aomori, Japan | |||
1262791 | 1262791 | 2021-09-09 | Japan | Aomori | 5007 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-10 04:21:20 | Aomori, Japan | |||
2279161 | 2279161 | 2021-09-08 | Japan | Aomori | 4933 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-09 04:21:27 | Aomori, Japan | |||
641940 | 641940 | 2021-09-07 | Japan | Aomori | 4861 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-08 04:21:31 | Aomori, Japan | |||
3194003 | 3194003 | 2021-09-06 | Japan | Aomori | 4801 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-07 04:21:35 | Aomori, Japan | |||
3280871 | 3280871 | 2021-09-05 | Japan | Aomori | 4781 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-06 04:21:22 | Aomori, Japan | |||
249285 | 249285 | 2021-09-04 | Japan | Aomori | 4725 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-05 04:21:33 | Aomori, Japan | |||
3974566 | 3974566 | 2021-09-03 | Japan | Aomori | 4652 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-04 04:21:28 | Aomori, Japan | |||
178028 | 178028 | 2021-09-02 | Japan | Aomori | 4588 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-03 04:21:20 | Aomori, Japan | |||
67063 | 67063 | 2021-09-01 | Japan | Aomori | 4488 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-02 04:21:15 | Aomori, Japan | |||
2067905 | 2067905 | 2021-08-31 | Japan | Aomori | 4355 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-01 04:21:38 | Aomori, Japan | |||
1775359 | 1775359 | 2021-08-30 | Japan | Aomori | 4271 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-31 04:21:46 | Aomori, Japan | |||
3891933 | 3891933 | 2021-08-29 | Japan | Aomori | 4217 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-30 04:21:23 | Aomori, Japan | |||
2793036 | 2793036 | 2021-08-28 | Japan | Aomori | 4150 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-29 04:21:14 | Aomori, Japan | |||
2923195 | 2923195 | 2021-08-27 | Japan | Aomori | 4053 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-28 04:21:28 | Aomori, Japan | |||
1596209 | 1596209 | 2021-08-26 | Japan | Aomori | 3950 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-27 04:21:37 | Aomori, Japan | |||
32418 | 32418 | 2021-08-25 | Japan | Aomori | 3811 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-26 04:21:28 | Aomori, Japan | |||
3105457 | 3105457 | 2021-08-24 | Japan | Aomori | 3707 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-25 04:21:41 | Aomori, Japan | |||
3165628 | 3165628 | 2021-08-23 | Japan | Aomori | 3626 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-24 04:21:19 | Aomori, Japan | |||
2175555 | 2175555 | 2021-08-22 | Japan | Aomori | 3601 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-23 04:21:27 | Aomori, Japan | |||
3555651 | 3555651 | 2021-08-21 | Japan | Aomori | 3540 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-22 04:21:29 | Aomori, Japan | |||
1853993 | 1853993 | 2021-08-20 | Japan | Aomori | 3457 | 33 | 0 | 40.781541 | 140.828896 | 2021-08-21 04:21:38 | Aomori, Japan | |||
511700 | 511700 | 2021-08-19 | Japan | Aomori | 3383 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-20 04:21:33 | Aomori, Japan | |||
2518179 | 2518179 | 2021-08-18 | Japan | Aomori | 3304 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-19 04:21:15 | Aomori, Japan | |||
245271 | 245271 | 2021-08-17 | Japan | Aomori | 3247 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-18 04:21:35 | Aomori, Japan | |||
1604234 | 1604234 | 2021-08-16 | Japan | Aomori | 3156 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-17 04:21:49 | Aomori, Japan | |||
103328 | 103328 | 2021-08-15 | Japan | Aomori | 3140 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-16 04:21:31 | Aomori, Japan | |||
507686 | 507686 | 2021-08-14 | Japan | Aomori | 3129 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-15 04:21:41 | Aomori, Japan | |||
1483558 | 1483558 | 2021-08-13 | Japan | Aomori | 3073 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-14 04:21:25 | Aomori, Japan | |||
2899688 | 2899688 | 2021-08-12 | Japan | Aomori | 3028 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-13 04:21:24 | Aomori, Japan | |||
1342292 | 1342292 | 2021-08-11 | Japan | Aomori | 2986 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-12 04:21:25 | Aomori, Japan | |||
2351439 | 2351439 | 2021-08-10 | Japan | Aomori | 2909 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-11 04:21:58 | Aomori, Japan | |||
649968 | 649968 | 2021-08-09 | Japan | Aomori | 2883 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-10 04:21:27 | Aomori, Japan | |||
589630 | 589630 | 2021-08-08 | Japan | Aomori | 2872 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-09 04:21:24 | Aomori, Japan | |||
2203642 | 2203642 | 2021-08-07 | Japan | Aomori | 2850 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-08 04:21:33 | Aomori, Japan | |||
1117592 | 1117592 | 2021-08-06 | Japan | Aomori | 2820 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-07 04:21:30 | Aomori, Japan | |||
1956529 | 1956529 | 2021-08-05 | Japan | Aomori | 2793 | 32 | 0 | 40.781541 | 140.828896 | 2021-08-06 04:21:18 | Aomori, Japan | |||
331908 | 331908 | 2021-08-04 | Japan | Aomori | 2767 | 32 | 2575 | 160 | 40.781541 | 140.828896 | 2021-08-05 04:21:51 | Aomori, Japan | ||
3468179 | 3468179 | 2021-08-03 | Japan | Aomori | 2751 | 32 | 2571 | 148 | 40.781541 | 140.828896 | 2021-08-04 04:21:25 | Aomori, Japan | ||
3683453 | 3683453 | 2021-08-02 | Japan | Aomori | 2725 | 32 | 2567 | 126 | 40.781541 | 140.828896 | 2021-08-03 04:21:39 | Aomori, Japan | ||
3015352 | 3015352 | 2021-08-01 | Japan | Aomori | 2712 | 32 | 2563 | 117 | 40.781541 | 140.828896 | 2021-08-02 04:21:36 | Aomori, Japan | ||
3903975 | 3903975 | 2021-07-31 | Japan | Aomori | 2698 | 32 | 2559 | 107 | 40.781541 | 140.828896 | 2021-08-01 04:21:50 | Aomori, Japan | ||
3296180 | 3296180 | 2021-07-30 | Japan | Aomori | 2676 | 31 | 2550 | 95 | 40.781541 | 140.828896 | 2021-07-31 04:21:35 | Aomori, Japan | ||
3385391 | 3385391 | 2021-07-29 | Japan | Aomori | 2661 | 31 | 2543 | 87 | 40.781541 | 140.828896 | 2021-07-30 04:21:34 | Aomori, Japan | ||
408296 | 408296 | 2021-07-28 | Japan | Aomori | 2636 | 31 | 2538 | 67 | 40.781541 | 140.828896 | 2021-07-29 04:21:33 | Aomori, Japan | ||
1306157 | 1306157 | 2021-07-27 | Japan | Aomori | 2628 | 31 | 2533 | 64 | 40.781541 | 140.828896 | 2021-07-28 04:21:39 | Aomori, Japan | ||
3218300 | 3218300 | 2021-07-26 | Japan | Aomori | 2619 | 31 | 2526 | 62 | 40.781541 | 140.828896 | 2021-07-27 04:21:18 | Aomori, Japan | ||
1378509 | 1378509 | 2021-07-25 | Japan | Aomori | 2616 | 31 | 2521 | 64 | 40.781541 | 140.828896 | 2021-07-26 04:21:28 | Aomori, Japan | ||
1330249 | 1330249 | 2021-07-24 | Japan | Aomori | 2608 | 31 | 2517 | 60 | 40.781541 | 140.828896 | 2021-07-25 04:22:12 | Aomori, Japan | ||
3137553 | 3137553 | 2021-07-23 | Japan | Aomori | 2608 | 31 | 2514 | 63 | 40.781541 | 140.828896 | 2021-07-24 00:21:36 | Aomori, Japan | ||
3476313 | 3476313 | 2021-07-22 | Japan | Aomori | 2606 | 31 | 2511 | 64 | 40.781541 | 140.828896 | 2021-07-23 04:21:29 | Aomori, Japan | ||
3331532 | 3331532 | 2021-07-21 | Japan | Aomori | 2602 | 31 | 2509 | 62 | 40.781541 | 140.828896 | 2021-07-22 04:21:19 | Aomori, Japan | ||
2371513 | 2371513 | 2021-07-20 | Japan | Aomori | 2599 | 31 | 2508 | 60 | 40.781541 | 140.828896 | 2021-07-21 04:21:40 | Aomori, Japan | ||
483592 | 483592 | 2021-07-19 | Japan | Aomori | 2579 | 31 | 2506 | 42 | 40.781541 | 140.828896 | 2021-07-20 04:21:48 | Aomori, Japan | ||
2673815 | 2673815 | 2021-07-18 | Japan | Aomori | 2579 | 31 | 2504 | 44 | 40.781541 | 140.828896 | 2021-07-19 04:21:24 | Aomori, Japan | ||
3706127 | 3706127 | 2021-07-17 | Japan | Aomori | 2572 | 31 | 2503 | 38 | 40.781541 | 140.828896 | 2021-07-18 04:22:07 | Aomori, Japan | ||
2947358 | 2947358 | 2021-07-16 | Japan | Aomori | 2564 | 31 | 2499 | 34 | 40.781541 | 140.828896 | 2021-07-17 04:22:22 | Aomori, Japan | ||
296014 | 296014 | 2021-07-15 | Japan | Aomori | 2561 | 31 | 2495 | 35 | 40.781541 | 140.828896 | 2021-07-16 04:21:22 | Aomori, Japan | ||
3631959 | 3631959 | 2021-07-14 | Japan | Aomori | 2554 | 31 | 2490 | 33 | 40.781541 | 140.828896 | 2021-07-15 04:21:48 | Aomori, Japan | ||
578834 | 578834 | 2021-07-13 | Japan | Aomori | 2548 | 31 | 2485 | 32 | 40.781541 | 140.828896 | 2021-07-14 04:21:35 | Aomori, Japan | ||
3741083 | 3741083 | 2021-07-12 | Japan | Aomori | 2541 | 31 | 2470 | 40 | 40.781541 | 140.828896 | 2021-07-13 04:21:18 | Aomori, Japan | ||
3659596 | 3659596 | 2021-07-11 | Japan | Aomori | 2539 | 31 | 2462 | 46 | 40.781541 | 140.828896 | 2021-07-12 04:21:34 | Aomori, Japan | ||
625880 | 625880 | 2021-07-10 | Japan | Aomori | 2538 | 31 | 2462 | 45 | 40.781541 | 140.828896 | 2021-07-11 04:21:43 | Aomori, Japan | ||
829599 | 829599 | 2021-07-09 | Japan | Aomori | 2538 | 31 | 2455 | 52 | 40.781541 | 140.828896 | 2021-07-10 04:21:25 | Aomori, Japan | ||
778363 | 778363 | 2021-07-08 | Japan | Aomori | 2538 | 31 | 2448 | 59 | 40.781541 | 140.828896 | 2021-07-09 04:21:21 | Aomori, Japan | ||
1440585 | 1440585 | 2021-07-07 | Japan | Aomori | 2531 | 31 | 2434 | 66 | 40.781541 | 140.828896 | 2021-07-08 04:21:26 | Aomori, Japan | ||
2693690 | 2693690 | 2021-07-06 | Japan | Aomori | 2526 | 31 | 2431 | 64 | 40.781541 | 140.828896 | 2021-07-07 04:21:20 | Aomori, Japan | ||
1932439 | 1932439 | 2021-07-05 | Japan | Aomori | 2521 | 31 | 2426 | 64 | 40.781541 | 140.828896 | 2021-07-06 04:21:32 | Aomori, Japan | ||
1165170 | 1165170 | 2021-07-04 | Japan | Aomori | 2520 | 31 | 2423 | 66 | 40.781541 | 140.828896 | 2021-07-05 04:21:28 | Aomori, Japan | ||
1495604 | 1495604 | 2021-07-03 | Japan | Aomori | 2518 | 31 | 2423 | 64 | 40.781541 | 140.828896 | 2021-07-04 04:21:38 | Aomori, Japan | ||
2071919 | 2071919 | 2021-07-02 | Japan | Aomori | 2511 | 31 | 2420 | 60 | 40.781541 | 140.828896 | 2021-07-03 04:21:37 | Aomori, Japan | ||
2764935 | 2764935 | 2021-07-01 | Japan | Aomori | 2502 | 31 | 2419 | 52 | 40.781541 | 140.828896 | 2021-07-02 04:21:47 | Aomori, Japan | ||
1893143 | 1893143 | 2021-06-30 | Japan | Aomori | 2500 | 31 | 2418 | 51 | 40.781541 | 140.828896 | 2021-07-01 04:21:19 | Aomori, Japan | ||
400266 | 400266 | 2021-06-29 | Japan | Aomori | 2490 | 31 | 2412 | 47 | 40.781541 | 140.828896 | 2021-06-30 04:21:41 | Aomori, Japan | ||
3125509 | 3125509 | 2021-06-28 | Japan | Aomori | 2479 | 31 | 2412 | 36 | 40.781541 | 140.828896 | 2021-06-29 04:21:28 | Aomori, Japan | ||
2590004 | 2590004 | 2021-06-27 | Japan | Aomori | 2477 | 31 | 2412 | 34 | 40.781541 | 140.828896 | 2021-06-28 04:21:29 | Aomori, Japan | ||
3958508 | 3958508 | 2021-06-26 | Japan | Aomori | 2476 | 31 | 2411 | 34 | 40.781541 | 140.828896 | 2021-06-27 04:21:39 | Aomori, Japan | ||
1712327 | 1712327 | 2021-06-25 | Japan | Aomori | 2465 | 31 | 2410 | 24 | 40.781541 | 140.828896 | 2021-06-26 04:21:43 | Aomori, Japan | ||
2295452 | 2295452 | 2021-06-24 | Japan | Aomori | 2463 | 31 | 2403 | 29 | 40.781541 | 140.828896 | 2021-06-25 04:21:33 | Aomori, Japan | ||
2422892 | 2422892 | 2021-06-23 | Japan | Aomori | 2455 | 31 | 2401 | 23 | 40.781541 | 140.828896 | 2021-06-24 04:21:55 | Aomori, Japan | ||
562969 | 562969 | 2021-06-22 | Japan | Aomori | 2453 | 31 | 2397 | 25 | 40.781541 | 140.828896 | 2021-06-23 04:21:46 | Aomori, Japan | ||
3358671 | 3358671 | 2021-06-21 | Japan | Aomori | 2453 | 31 | 2392 | 30 | 40.781541 | 140.828896 | 2021-06-22 04:21:34 | Aomori, Japan | ||
2884370 | 2884370 | 2021-06-20 | Japan | Aomori | 2453 | 31 | 2390 | 32 | 40.781541 | 140.828896 | 2021-06-21 04:21:41 | Aomori, Japan | ||
107453 | 107453 | 2021-06-19 | Japan | Aomori | 2453 | 31 | 2387 | 35 | 40.781541 | 140.828896 | 2021-06-20 04:21:48 | Aomori, Japan | ||
1125596 | 1125596 | 2021-06-18 | Japan | Aomori | 2452 | 31 | 2384 | 37 | 40.781541 | 140.828896 | 2021-06-19 04:22:33 | Aomori, Japan | ||
2911174 | 2911174 | 2021-06-17 | Japan | Aomori | 2452 | 31 | 2372 | 49 | 40.781541 | 140.828896 | 2021-06-18 04:22:16 | Aomori, Japan | ||
3030292 | 3030292 | 2021-06-16 | Japan | Aomori | 2452 | 31 | 2366 | 55 | 40.781541 | 140.828896 | 2021-06-17 04:22:36 | Aomori, Japan | ||
2339398 | 2339398 | 2021-06-15 | Japan | Aomori | 2451 | 30 | 2356 | 65 | 40.781541 | 140.828896 | 2021-06-16 04:22:32 | Aomori, Japan | ||
1564094 | 1564094 | 2021-06-14 | Japan | Aomori | 2448 | 30 | 2334 | 84 | 40.781541 | 140.828896 | 2021-06-15 04:22:22 | Aomori, Japan | ||
3381377 | 3381377 | 2021-06-13 | Japan | Aomori | 2448 | 30 | 2328 | 90 | 40.781541 | 140.828896 | 2021-06-14 04:22:46 | Aomori, Japan | ||
1736511 | 1736511 | 2021-06-12 | Japan | Aomori | 2447 | 30 | 2316 | 101 | 40.781541 | 140.828896 | 2021-06-13 04:22:44 | Aomori, Japan | ||
3970552 | 3970552 | 2021-06-11 | Japan | Aomori | 2444 | 30 | 2301 | 113 | 40.781541 | 140.828896 | 2021-06-12 04:22:22 | Aomori, Japan | ||
2716974 | 2716974 | 2021-06-10 | Japan | Aomori | 2442 | 30 | 2287 | 125 | 40.781541 | 140.828896 | 2021-06-11 04:23:20 | Aomori, Japan | ||
522859 | 522859 | 2021-06-09 | Japan | Aomori | 2440 | 30 | 2275 | 135 | 40.781541 | 140.828896 | 2021-06-10 04:23:17 | Aomori, Japan | ||
3472299 | 3472299 | 2021-06-08 | Japan | Aomori | 2436 | 30 | 2250 | 156 | 40.781541 | 140.828896 | 2021-06-09 04:23:31 | Aomori, Japan | ||
3145583 | 3145583 | 2021-06-07 | Japan | Aomori | 2426 | 30 | 2213 | 183 | 40.781541 | 140.828896 | 2021-06-08 04:22:35 | Aomori, 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]);