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 = "Osaka" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1885032 | 1885032 | 2021-09-12 | Japan | Osaka | 190491 | 2871 | 0 | 34.620965000000005 | 135.507481 | 2021-09-13 04:21:15 | Osaka, Japan | |||
3805935 | 3805935 | 2021-09-11 | Japan | Osaka | 189344 | 2870 | 0 | 34.620965000000005 | 135.507481 | 2021-09-12 04:21:13 | Osaka, Japan | |||
3448875 | 3448875 | 2021-09-10 | Japan | Osaka | 188081 | 2869 | 0 | 34.620965000000005 | 135.507481 | 2021-09-11 04:21:30 | Osaka, Japan | |||
1262821 | 1262821 | 2021-09-09 | Japan | Osaka | 186772 | 2855 | 0 | 34.620965000000005 | 135.507481 | 2021-09-10 04:21:20 | Osaka, Japan | |||
2279191 | 2279191 | 2021-09-08 | Japan | Osaka | 185284 | 2847 | 0 | 34.620965000000005 | 135.507481 | 2021-09-09 04:21:27 | Osaka, Japan | |||
641970 | 641970 | 2021-09-07 | Japan | Osaka | 183273 | 2838 | 0 | 34.620965000000005 | 135.507481 | 2021-09-08 04:21:31 | Osaka, Japan | |||
3194033 | 3194033 | 2021-09-06 | Japan | Osaka | 181624 | 2832 | 0 | 34.620965000000005 | 135.507481 | 2021-09-07 04:21:35 | Osaka, Japan | |||
3280901 | 3280901 | 2021-09-05 | Japan | Osaka | 180700 | 2830 | 0 | 34.620965000000005 | 135.507481 | 2021-09-06 04:21:22 | Osaka, Japan | |||
249315 | 249315 | 2021-09-04 | Japan | Osaka | 178881 | 2827 | 0 | 34.620965000000005 | 135.507481 | 2021-09-05 04:21:33 | Osaka, Japan | |||
3974596 | 3974596 | 2021-09-03 | Japan | Osaka | 176528 | 2815 | 0 | 34.620965000000005 | 135.507481 | 2021-09-04 04:21:28 | Osaka, Japan | |||
178058 | 178058 | 2021-09-02 | Japan | Osaka | 174225 | 2809 | 0 | 34.620965000000005 | 135.507481 | 2021-09-03 04:21:20 | Osaka, Japan | |||
67093 | 67093 | 2021-09-01 | Japan | Osaka | 171724 | 2801 | 0 | 34.620965000000005 | 135.507481 | 2021-09-02 04:21:15 | Osaka, Japan | |||
2067935 | 2067935 | 2021-08-31 | Japan | Osaka | 168720 | 2789 | 0 | 34.620965000000005 | 135.507481 | 2021-09-01 04:21:38 | Osaka, Japan | |||
1775389 | 1775389 | 2021-08-30 | Japan | Osaka | 166374 | 2786 | 0 | 34.620965000000005 | 135.507481 | 2021-08-31 04:21:46 | Osaka, Japan | |||
3891963 | 3891963 | 2021-08-29 | Japan | Osaka | 164770 | 2784 | 0 | 34.620965000000005 | 135.507481 | 2021-08-30 04:21:23 | Osaka, Japan | |||
2793066 | 2793066 | 2021-08-28 | Japan | Osaka | 162381 | 2782 | 0 | 34.620965000000005 | 135.507481 | 2021-08-29 04:21:14 | Osaka, Japan | |||
2923225 | 2923225 | 2021-08-27 | Japan | Osaka | 159740 | 2780 | 0 | 34.620965000000005 | 135.507481 | 2021-08-28 04:21:28 | Osaka, Japan | |||
1596239 | 1596239 | 2021-08-26 | Japan | Osaka | 156926 | 2778 | 0 | 34.620965000000005 | 135.507481 | 2021-08-27 04:21:37 | Osaka, Japan | |||
32448 | 32448 | 2021-08-25 | Japan | Osaka | 154097 | 2772 | 0 | 34.620965000000005 | 135.507481 | 2021-08-26 04:21:28 | Osaka, Japan | |||
3105487 | 3105487 | 2021-08-24 | Japan | Osaka | 151290 | 2771 | 0 | 34.620965000000005 | 135.507481 | 2021-08-25 04:21:41 | Osaka, Japan | |||
3165658 | 3165658 | 2021-08-23 | Japan | Osaka | 148922 | 2766 | 0 | 34.620965000000005 | 135.507481 | 2021-08-24 04:21:19 | Osaka, Japan | |||
2175585 | 2175585 | 2021-08-22 | Japan | Osaka | 147365 | 2758 | 0 | 34.620965000000005 | 135.507481 | 2021-08-23 04:21:27 | Osaka, Japan | |||
3555681 | 3555681 | 2021-08-21 | Japan | Osaka | 145144 | 2756 | 0 | 34.620965000000005 | 135.507481 | 2021-08-22 04:21:29 | Osaka, Japan | |||
1854023 | 1854023 | 2021-08-20 | Japan | Osaka | 142588 | 2754 | 0 | 34.620965000000005 | 135.507481 | 2021-08-21 04:21:38 | Osaka, Japan | |||
511730 | 511730 | 2021-08-19 | Japan | Osaka | 140003 | 2753 | 0 | 34.620965000000005 | 135.507481 | 2021-08-20 04:21:33 | Osaka, Japan | |||
2518209 | 2518209 | 2021-08-18 | Japan | Osaka | 137560 | 2752 | 0 | 34.620965000000005 | 135.507481 | 2021-08-19 04:21:15 | Osaka, Japan | |||
245301 | 245301 | 2021-08-17 | Japan | Osaka | 135264 | 2747 | 0 | 34.620965000000005 | 135.507481 | 2021-08-18 04:21:35 | Osaka, Japan | |||
1604264 | 1604264 | 2021-08-16 | Japan | Osaka | 133408 | 2743 | 0 | 34.620965000000005 | 135.507481 | 2021-08-17 04:21:49 | Osaka, Japan | |||
103358 | 103358 | 2021-08-15 | Japan | Osaka | 132444 | 2742 | 0 | 34.620965000000005 | 135.507481 | 2021-08-16 04:21:31 | Osaka, Japan | |||
507716 | 507716 | 2021-08-14 | Japan | Osaka | 130680 | 2742 | 0 | 34.620965000000005 | 135.507481 | 2021-08-15 04:21:41 | Osaka, Japan | |||
1483588 | 1483588 | 2021-08-13 | Japan | Osaka | 128852 | 2742 | 0 | 34.620965000000005 | 135.507481 | 2021-08-14 04:21:25 | Osaka, Japan | |||
2899718 | 2899718 | 2021-08-12 | Japan | Osaka | 127291 | 2739 | 0 | 34.620965000000005 | 135.507481 | 2021-08-13 04:21:24 | Osaka, Japan | |||
1342322 | 1342322 | 2021-08-11 | Japan | Osaka | 125637 | 2735 | 0 | 34.620965000000005 | 135.507481 | 2021-08-12 04:21:25 | Osaka, Japan | |||
2351469 | 2351469 | 2021-08-10 | Japan | Osaka | 124148 | 2733 | 0 | 34.620965000000005 | 135.507481 | 2021-08-11 04:21:58 | Osaka, Japan | |||
649998 | 649998 | 2021-08-09 | Japan | Osaka | 123451 | 2733 | 0 | 34.620965000000005 | 135.507481 | 2021-08-10 04:21:27 | Osaka, Japan | |||
589660 | 589660 | 2021-08-08 | Japan | Osaka | 122456 | 2733 | 0 | 34.620965000000005 | 135.507481 | 2021-08-09 04:21:24 | Osaka, Japan | |||
2203672 | 2203672 | 2021-08-07 | Japan | Osaka | 121292 | 2731 | 0 | 34.620965000000005 | 135.507481 | 2021-08-08 04:21:33 | Osaka, Japan | |||
1117622 | 1117622 | 2021-08-06 | Japan | Osaka | 120169 | 2728 | 0 | 34.620965000000005 | 135.507481 | 2021-08-07 04:21:30 | Osaka, Japan | |||
1956559 | 1956559 | 2021-08-05 | Japan | Osaka | 118859 | 2726 | 0 | 34.620965000000005 | 135.507481 | 2021-08-06 04:21:18 | Osaka, Japan | |||
331938 | 331938 | 2021-08-04 | Japan | Osaka | 117774 | 2724 | 105251 | 9799 | 34.620965000000005 | 135.507481 | 2021-08-05 04:21:51 | Osaka, Japan | ||
3468209 | 3468209 | 2021-08-03 | Japan | Osaka | 116550 | 2722 | 104755 | 9073 | 34.620965000000005 | 135.507481 | 2021-08-04 04:21:25 | Osaka, Japan | ||
3683483 | 3683483 | 2021-08-02 | Japan | Osaka | 115472 | 2722 | 104289 | 8461 | 34.620965000000005 | 135.507481 | 2021-08-03 04:21:39 | Osaka, Japan | ||
3015382 | 3015382 | 2021-08-01 | Japan | Osaka | 115024 | 2721 | 104059 | 8244 | 34.620965000000005 | 135.507481 | 2021-08-02 04:21:36 | Osaka, Japan | ||
3904005 | 3904005 | 2021-07-31 | Japan | Osaka | 114134 | 2721 | 103759 | 7654 | 34.620965000000005 | 135.507481 | 2021-08-01 04:21:50 | Osaka, Japan | ||
3296210 | 3296210 | 2021-07-30 | Japan | Osaka | 113094 | 2721 | 103524 | 6849 | 34.620965000000005 | 135.507481 | 2021-07-31 04:21:35 | Osaka, Japan | ||
3385421 | 3385421 | 2021-07-29 | Japan | Osaka | 112212 | 2721 | 103193 | 6298 | 34.620965000000005 | 135.507481 | 2021-07-30 04:21:34 | Osaka, Japan | ||
408326 | 408326 | 2021-07-28 | Japan | Osaka | 111280 | 2719 | 102973 | 5588 | 34.620965000000005 | 135.507481 | 2021-07-29 04:21:33 | Osaka, Japan | ||
1306187 | 1306187 | 2021-07-27 | Japan | Osaka | 110482 | 2719 | 102620 | 5143 | 34.620965000000005 | 135.507481 | 2021-07-28 04:21:39 | Osaka, Japan | ||
3218330 | 3218330 | 2021-07-26 | Japan | Osaka | 109741 | 2719 | 102326 | 4696 | 34.620965000000005 | 135.507481 | 2021-07-27 04:21:18 | Osaka, Japan | ||
1378539 | 1378539 | 2021-07-25 | Japan | Osaka | 109367 | 2718 | 102019 | 4630 | 34.620965000000005 | 135.507481 | 2021-07-26 04:21:28 | Osaka, Japan | ||
1330279 | 1330279 | 2021-07-24 | Japan | Osaka | 108896 | 2717 | 101762 | 4417 | 34.620965000000005 | 135.507481 | 2021-07-25 04:22:12 | Osaka, Japan | ||
3137583 | 3137583 | 2021-07-23 | Japan | Osaka | 108613 | 2716 | 101620 | 4277 | 34.620965000000005 | 135.507481 | 2021-07-24 00:21:36 | Osaka, Japan | ||
3476343 | 3476343 | 2021-07-22 | Japan | Osaka | 108234 | 2716 | 101353 | 4165 | 34.620965000000005 | 135.507481 | 2021-07-23 04:21:29 | Osaka, Japan | ||
3331562 | 3331562 | 2021-07-21 | Japan | Osaka | 107773 | 2715 | 101119 | 3939 | 34.620965000000005 | 135.507481 | 2021-07-22 04:21:19 | Osaka, Japan | ||
2371543 | 2371543 | 2021-07-20 | Japan | Osaka | 107282 | 2711 | 100894 | 3677 | 34.620965000000005 | 135.507481 | 2021-07-21 04:21:40 | Osaka, Japan | ||
483622 | 483622 | 2021-07-19 | Japan | Osaka | 106969 | 2708 | 100719 | 3542 | 34.620965000000005 | 135.507481 | 2021-07-20 04:21:48 | Osaka, Japan | ||
2673845 | 2673845 | 2021-07-18 | Japan | Osaka | 106745 | 2708 | 100611 | 3426 | 34.620965000000005 | 135.507481 | 2021-07-19 04:21:24 | Osaka, Japan | ||
3706157 | 3706157 | 2021-07-17 | Japan | Osaka | 106483 | 2707 | 100465 | 3311 | 34.620965000000005 | 135.507481 | 2021-07-18 04:22:07 | Osaka, Japan | ||
2947388 | 2947388 | 2021-07-16 | Japan | Osaka | 106103 | 2703 | 100326 | 3074 | 34.620965000000005 | 135.507481 | 2021-07-17 04:22:22 | Osaka, Japan | ||
296044 | 296044 | 2021-07-15 | Japan | Osaka | 105849 | 2700 | 100191 | 2958 | 34.620965000000005 | 135.507481 | 2021-07-16 04:21:22 | Osaka, Japan | ||
3631989 | 3631989 | 2021-07-14 | Japan | Osaka | 105525 | 2698 | 100044 | 2783 | 34.620965000000005 | 135.507481 | 2021-07-15 04:21:48 | Osaka, Japan | ||
578864 | 578864 | 2021-07-13 | Japan | Osaka | 105176 | 2696 | 99855 | 2625 | 34.620965000000005 | 135.507481 | 2021-07-14 04:21:35 | Osaka, Japan | ||
3741113 | 3741113 | 2021-07-12 | Japan | Osaka | 104951 | 2693 | 99814 | 2444 | 34.620965000000005 | 135.507481 | 2021-07-13 04:21:18 | Osaka, Japan | ||
3659626 | 3659626 | 2021-07-11 | Japan | Osaka | 104847 | 2693 | 99653 | 2501 | 34.620965000000005 | 135.507481 | 2021-07-12 04:21:34 | Osaka, Japan | ||
625910 | 625910 | 2021-07-10 | Japan | Osaka | 104681 | 2693 | 99653 | 2335 | 34.620965000000005 | 135.507481 | 2021-07-11 04:21:43 | Osaka, Japan | ||
829629 | 829629 | 2021-07-09 | Japan | Osaka | 104481 | 2692 | 99489 | 2300 | 34.620965000000005 | 135.507481 | 2021-07-10 04:21:25 | Osaka, Japan | ||
778393 | 778393 | 2021-07-08 | Japan | Osaka | 104338 | 2690 | 99390 | 2258 | 34.620965000000005 | 135.507481 | 2021-07-09 04:21:21 | Osaka, Japan | ||
1440615 | 1440615 | 2021-07-07 | Japan | Osaka | 104213 | 2687 | 99334 | 2192 | 34.620965000000005 | 135.507481 | 2021-07-08 04:21:26 | Osaka, Japan | ||
2693720 | 2693720 | 2021-07-06 | Japan | Osaka | 104062 | 2685 | 99189 | 2188 | 34.620965000000005 | 135.507481 | 2021-07-07 04:21:20 | Osaka, Japan | ||
1932469 | 1932469 | 2021-07-05 | Japan | Osaka | 103926 | 2681 | 99147 | 2098 | 34.620965000000005 | 135.507481 | 2021-07-06 04:21:32 | Osaka, Japan | ||
1165200 | 1165200 | 2021-07-04 | Japan | Osaka | 103849 | 2680 | 99047 | 2122 | 34.620965000000005 | 135.507481 | 2021-07-05 04:21:28 | Osaka, Japan | ||
1495634 | 1495634 | 2021-07-03 | Japan | Osaka | 103761 | 2680 | 98873 | 2208 | 34.620965000000005 | 135.507481 | 2021-07-04 04:21:38 | Osaka, Japan | ||
2071949 | 2071949 | 2021-07-02 | Japan | Osaka | 103613 | 2680 | 98820 | 2113 | 34.620965000000005 | 135.507481 | 2021-07-03 04:21:37 | Osaka, Japan | ||
2764965 | 2764965 | 2021-07-01 | Japan | Osaka | 103490 | 2677 | 98670 | 2143 | 34.620965000000005 | 135.507481 | 2021-07-02 04:21:47 | Osaka, Japan | ||
1893173 | 1893173 | 2021-06-30 | Japan | Osaka | 103382 | 2671 | 98507 | 2204 | 34.620965000000005 | 135.507481 | 2021-07-01 04:21:19 | Osaka, Japan | ||
400296 | 400296 | 2021-06-29 | Japan | Osaka | 103274 | 2668 | 98306 | 2300 | 34.620965000000005 | 135.507481 | 2021-06-30 04:21:41 | Osaka, Japan | ||
3125539 | 3125539 | 2021-06-28 | Japan | Osaka | 103173 | 2661 | 98265 | 2247 | 34.620965000000005 | 135.507481 | 2021-06-29 04:21:28 | Osaka, Japan | ||
2590034 | 2590034 | 2021-06-27 | Japan | Osaka | 103133 | 2647 | 98121 | 2365 | 34.620965000000005 | 135.507481 | 2021-06-28 04:21:29 | Osaka, Japan | ||
3958538 | 3958538 | 2021-06-26 | Japan | Osaka | 103037 | 2647 | 98054 | 2336 | 34.620965000000005 | 135.507481 | 2021-06-27 04:21:39 | Osaka, Japan | ||
1712357 | 1712357 | 2021-06-25 | Japan | Osaka | 102949 | 2640 | 97864 | 2445 | 34.620965000000005 | 135.507481 | 2021-06-26 04:21:43 | Osaka, Japan | ||
2295482 | 2295482 | 2021-06-24 | Japan | Osaka | 102829 | 2635 | 97754 | 2440 | 34.620965000000005 | 135.507481 | 2021-06-25 04:21:33 | Osaka, Japan | ||
2422922 | 2422922 | 2021-06-23 | Japan | Osaka | 102713 | 2624 | 97441 | 2648 | 34.620965000000005 | 135.507481 | 2021-06-24 04:21:55 | Osaka, Japan | ||
562999 | 562999 | 2021-06-22 | Japan | Osaka | 102588 | 2609 | 97256 | 2723 | 34.620965000000005 | 135.507481 | 2021-06-23 04:21:46 | Osaka, Japan | ||
3358701 | 3358701 | 2021-06-21 | Japan | Osaka | 102481 | 2605 | 97091 | 2785 | 34.620965000000005 | 135.507481 | 2021-06-22 04:21:34 | Osaka, Japan | ||
2884400 | 2884400 | 2021-06-20 | Japan | Osaka | 102439 | 2592 | 96971 | 2876 | 34.620965000000005 | 135.507481 | 2021-06-21 04:21:41 | Osaka, Japan | ||
107483 | 107483 | 2021-06-19 | Japan | Osaka | 102333 | 2589 | 96618 | 3126 | 34.620965000000005 | 135.507481 | 2021-06-20 04:21:48 | Osaka, Japan | ||
1125626 | 1125626 | 2021-06-18 | Japan | Osaka | 102222 | 2584 | 95736 | 3902 | 34.620965000000005 | 135.507481 | 2021-06-19 04:22:33 | Osaka, Japan | ||
2911204 | 2911204 | 2021-06-17 | Japan | Osaka | 102143 | 2567 | 95297 | 4279 | 34.620965000000005 | 135.507481 | 2021-06-18 04:22:16 | Osaka, Japan | ||
3030322 | 3030322 | 2021-06-16 | Japan | Osaka | 102048 | 2563 | 94486 | 4999 | 34.620965000000005 | 135.507481 | 2021-06-17 04:22:36 | Osaka, Japan | ||
2339428 | 2339428 | 2021-06-15 | Japan | Osaka | 101940 | 2544 | 93118 | 6278 | 34.620965000000005 | 135.507481 | 2021-06-16 04:22:32 | Osaka, Japan | ||
1564124 | 1564124 | 2021-06-14 | Japan | Osaka | 101830 | 2540 | 92844 | 6446 | 34.620965000000005 | 135.507481 | 2021-06-15 04:22:22 | Osaka, Japan | ||
3381407 | 3381407 | 2021-06-13 | Japan | Osaka | 101773 | 2530 | 92651 | 6592 | 34.620965000000005 | 135.507481 | 2021-06-14 04:22:46 | Osaka, Japan | ||
1736541 | 1736541 | 2021-06-12 | Japan | Osaka | 101677 | 2524 | 92317 | 6836 | 34.620965000000005 | 135.507481 | 2021-06-13 04:22:44 | Osaka, Japan | ||
3970582 | 3970582 | 2021-06-11 | Japan | Osaka | 101551 | 2512 | 91924 | 7115 | 34.620965000000005 | 135.507481 | 2021-06-12 04:22:22 | Osaka, Japan | ||
2717004 | 2717004 | 2021-06-10 | Japan | Osaka | 101417 | 2501 | 91475 | 7441 | 34.620965000000005 | 135.507481 | 2021-06-11 04:23:20 | Osaka, Japan | ||
522889 | 522889 | 2021-06-09 | Japan | Osaka | 101269 | 2484 | 91014 | 7771 | 34.620965000000005 | 135.507481 | 2021-06-10 04:23:17 | Osaka, Japan | ||
3472329 | 3472329 | 2021-06-08 | Japan | Osaka | 101116 | 2457 | 90754 | 7905 | 34.620965000000005 | 135.507481 | 2021-06-09 04:23:31 | Osaka, Japan | ||
3145613 | 3145613 | 2021-06-07 | Japan | Osaka | 100926 | 2432 | 90334 | 8160 | 34.620965000000005 | 135.507481 | 2021-06-08 04:22:35 | Osaka, Japan | ||
825615 | 825615 | 2021-06-06 | Japan | Osaka | 100854 | 2417 | 90166 | 8271 | 34.620965000000005 | 135.507481 | 2021-06-07 04:22:51 | Osaka, Japan | ||
2586020 | 2586020 | 2021-06-05 | Japan | Osaka | 100709 | 2412 | 89852 | 8445 | 34.620965000000005 | 135.507481 | 2021-06-06 04:24:03 | Osaka, 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]);