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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491588 | 1491588 | 2021-10-12 | Japan | Aomori | 5805 | 38 | 0 | 40.781541 | 140.828896 | 2021-10-13 04:20:51 | Aomori, Japan | |||
3007321 | 3007321 | 2021-10-11 | Japan | Aomori | 5774 | 38 | 0 | 40.781541 | 140.828896 | 2021-10-12 04:21:09 | Aomori, Japan | |||
423337 | 423337 | 2021-10-10 | Japan | Aomori | 5774 | 38 | 0 | 40.781541 | 140.828896 | 2021-10-11 04:21:31 | Aomori, Japan | |||
2876194 | 2876194 | 2021-10-09 | Japan | Aomori | 5767 | 38 | 0 | 40.781541 | 140.828896 | 2021-10-10 04:21:38 | Aomori, Japan | |||
2959360 | 2959360 | 2021-10-08 | Japan | Aomori | 5748 | 38 | 0 | 40.781541 | 140.828896 | 2021-10-09 04:21:34 | Aomori, Japan | |||
467398 | 467398 | 2021-10-07 | Japan | Aomori | 5746 | 38 | 0 | 40.781541 | 140.828896 | 2021-10-08 04:21:25 | Aomori, Japan | |||
2458778 | 2458778 | 2021-10-06 | Japan | Aomori | 5742 | 38 | 0 | 40.781541 | 140.828896 | 2021-10-07 04:21:36 | Aomori, Japan | |||
3832472 | 3832472 | 2021-10-05 | Japan | Aomori | 5726 | 36 | 0 | 40.781541 | 140.828896 | 2021-10-06 04:21:33 | Aomori, Japan | |||
986965 | 986965 | 2021-10-04 | Japan | Aomori | 5716 | 36 | 0 | 40.781541 | 140.828896 | 2021-10-05 04:21:27 | Aomori, Japan | |||
1274275 | 1274275 | 2021-10-03 | Japan | Aomori | 5715 | 36 | 0 | 40.781541 | 140.828896 | 2021-10-04 04:21:31 | Aomori, Japan | |||
3928028 | 3928028 | 2021-10-02 | Japan | Aomori | 5712 | 36 | 0 | 40.781541 | 140.828896 | 2021-10-03 04:21:24 | Aomori, Japan | |||
2132008 | 2132008 | 2021-10-01 | Japan | Aomori | 5702 | 36 | 0 | 40.781541 | 140.828896 | 2021-10-02 04:21:25 | Aomori, Japan | |||
2772965 | 2772965 | 2021-09-30 | Japan | Aomori | 5692 | 35 | 0 | 40.781541 | 140.828896 | 2021-10-01 04:21:35 | Aomori, Japan | |||
706421 | 706421 | 2021-09-29 | Japan | Aomori | 5669 | 35 | 0 | 40.781541 | 140.828896 | 2021-09-30 04:21:20 | Aomori, Japan | |||
1334263 | 1334263 | 2021-09-28 | Japan | Aomori | 5646 | 35 | 0 | 40.781541 | 140.828896 | 2021-09-29 04:21:45 | Aomori, Japan | |||
1235632 | 1235632 | 2021-09-27 | Japan | Aomori | 5621 | 35 | 0 | 40.781541 | 140.828896 | 2021-09-28 04:21:28 | Aomori, Japan | |||
2075933 | 2075933 | 2021-09-26 | Japan | Aomori | 5616 | 35 | 0 | 40.781541 | 140.828896 | 2021-09-27 04:21:16 | Aomori, Japan | |||
1724485 | 1724485 | 2021-09-25 | Japan | Aomori | 5602 | 35 | 0 | 40.781541 | 140.828896 | 2021-09-26 04:21:29 | Aomori, Japan | |||
1921205 | 1921205 | 2021-09-24 | Japan | Aomori | 5570 | 35 | 0 | 40.781541 | 140.828896 | 2021-09-25 04:21:31 | Aomori, Japan | |||
601676 | 601676 | 2021-09-23 | Japan | Aomori | 5536 | 35 | 0 | 40.781541 | 140.828896 | 2021-09-24 04:21:44 | Aomori, Japan | |||
3011337 | 3011337 | 2021-09-22 | Japan | Aomori | 5504 | 34 | 0 | 40.781541 | 140.828896 | 2021-09-23 04:21:43 | Aomori, Japan | |||
3757475 | 3757475 | 2021-09-21 | Japan | Aomori | 5485 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-22 04:21:45 | Aomori, Japan | |||
809578 | 809578 | 2021-09-20 | Japan | Aomori | 5465 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-21 04:21:26 | Aomori, Japan | |||
1814777 | 1814777 | 2021-09-19 | Japan | Aomori | 5434 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-20 04:21:22 | Aomori, Japan | |||
16357 | 16357 | 2021-09-18 | Japan | Aomori | 5419 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-19 04:21:34 | Aomori, Japan | |||
2618042 | 2618042 | 2021-09-17 | Japan | Aomori | 5343 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-18 04:21:24 | Aomori, Japan | |||
2808750 | 2808750 | 2021-09-16 | Japan | Aomori | 5307 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-17 04:21:46 | Aomori, Japan | |||
1374495 | 1374495 | 2021-09-15 | Japan | Aomori | 5268 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-16 04:22:19 | Aomori, Japan | |||
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 |
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]);