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 = "Ishikawa" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190083 | 190083 | 2021-01-11 | Japan | Ishikawa | 1233 | 52 | 1005 | 176 | 36.769464 | 136.771027 | 2021-01-12 05:22:15 | Ishikawa, Japan | ||
2625886 | 2625886 | 2021-01-10 | Japan | Ishikawa | 1227 | 52 | 993 | 182 | 36.769464 | 136.771027 | 2021-01-11 05:21:50 | Ishikawa, Japan | ||
3899974 | 3899974 | 2021-01-09 | Japan | Ishikawa | 1208 | 52 | 981 | 175 | 36.769464 | 136.771027 | 2021-01-10 05:22:12 | Ishikawa, Japan | ||
153997 | 153997 | 2021-01-08 | Japan | Ishikawa | 1193 | 52 | 971 | 170 | 36.769464 | 136.771027 | 2021-01-09 05:22:18 | Ishikawa, Japan | ||
2541421 | 2541421 | 2021-01-07 | Japan | Ishikawa | 1176 | 52 | 962 | 162 | 36.769464 | 136.771027 | 2021-01-08 05:22:42 | Ishikawa, Japan | ||
2864730 | 2864730 | 2021-01-06 | Japan | Ishikawa | 1151 | 51 | 943 | 157 | 36.769464 | 136.771027 | 2021-01-07 05:22:03 | Ishikawa, Japan | ||
3034317 | 3034317 | 2021-01-05 | Japan | Ishikawa | 1139 | 51 | 935 | 153 | 36.769464 | 136.771027 | 2021-01-06 05:22:16 | Ishikawa, Japan | ||
1061862 | 1061862 | 2021-01-04 | Japan | Ishikawa | 1119 | 51 | 927 | 141 | 36.769464 | 136.771027 | 2021-01-05 05:21:49 | Ishikawa, Japan | ||
3230465 | 3230465 | 2021-01-03 | Japan | Ishikawa | 1105 | 51 | 924 | 130 | 36.769464 | 136.771027 | 2021-01-04 05:22:02 | Ishikawa, Japan | ||
2227534 | 2227534 | 2021-01-02 | Japan | Ishikawa | 1097 | 51 | 920 | 126 | 36.769464 | 136.771027 | 2021-01-03 05:22:52 | Ishikawa, Japan | ||
1136898 | 1136898 | 2021-01-01 | Japan | Ishikawa | 1084 | 51 | 915 | 118 | 36.769464 | 136.771027 | 2021-01-02 05:22:33 | Ishikawa, Japan | ||
3695504 | 3695504 | 2020-12-31 | Japan | Ishikawa | 1071 | 51 | 906 | 114 | 36.769464 | 136.771027 | 2021-01-01 05:23:07 | Ishikawa, Japan | ||
1010319 | 1010319 | 2020-12-30 | Japan | Ishikawa | 1064 | 50 | 895 | 119 | 36.769464 | 136.771027 | 2020-12-31 05:22:49 | Ishikawa, Japan | ||
766334 | 766334 | 2020-12-29 | Japan | Ishikawa | 1050 | 50 | 880 | 120 | 36.769464 | 136.771027 | 2020-12-30 05:22:34 | Ishikawa, Japan | ||
3761598 | 3761598 | 2020-12-28 | Japan | Ishikawa | 1040 | 50 | 875 | 115 | 36.769464 | 136.771027 | 2020-12-29 05:22:37 | Ishikawa, Japan | ||
3777918 | 3777918 | 2020-12-27 | Japan | Ishikawa | 1034 | 50 | 870 | 114 | 36.769464 | 136.771027 | 2020-12-28 05:22:06 | Ishikawa, Japan | ||
2223523 | 2223523 | 2020-12-26 | Japan | Ishikawa | 1022 | 50 | 864 | 108 | 36.769464 | 136.771027 | 2020-12-27 05:22:55 | Ishikawa, Japan | ||
202270 | 202270 | 2020-12-25 | Japan | Ishikawa | 1010 | 50 | 860 | 100 | 36.769464 | 136.771027 | 2020-12-26 05:22:28 | Ishikawa, Japan | ||
3691493 | 3691493 | 2020-12-24 | Japan | Ishikawa | 998 | 50 | 853 | 95 | 36.769464 | 136.771027 | 2020-12-25 05:22:48 | Ishikawa, Japan | ||
2406845 | 2406845 | 2020-12-23 | Japan | Ishikawa | 980 | 50 | 838 | 92 | 36.769464 | 136.771027 | 2020-12-24 05:23:04 | Ishikawa, Japan | ||
3769891 | 3769891 | 2020-12-22 | Japan | Ishikawa | 974 | 50 | 837 | 87 | 36.769464 | 136.771027 | 2020-12-23 05:22:03 | Ishikawa, Japan | ||
927707 | 927707 | 2020-12-21 | Japan | Ishikawa | 967 | 50 | 835 | 82 | 36.769464 | 136.771027 | 2020-12-22 05:22:33 | Ishikawa, Japan | ||
2119728 | 2119728 | 2020-12-20 | Japan | Ishikawa | 960 | 50 | 833 | 77 | 36.769464 | 136.771027 | 2020-12-21 05:27:58 | Ishikawa, Japan | ||
2931235 | 2931235 | 2020-12-19 | Japan | Ishikawa | 954 | 50 | 828 | 76 | 36.769464 | 136.771027 | 2020-12-20 05:27:32 | Ishikawa, Japan | ||
1901181 | 1901181 | 2020-12-18 | Japan | Ishikawa | 947 | 50 | 828 | 69 | 36.769464 | 136.771027 | 2020-12-19 05:27:52 | Ishikawa, Japan | ||
2128007 | 2128007 | 2020-12-17 | Japan | Ishikawa | 938 | 50 | 825 | 63 | 36.769464 | 136.771027 | 2020-12-18 05:28:18 | Ishikawa, Japan | ||
3149607 | 3149607 | 2020-12-16 | Japan | Ishikawa | 930 | 50 | 819 | 61 | 36.769464 | 136.771027 | 2020-12-17 05:28:12 | Ishikawa, Japan | ||
1034388 | 1034388 | 2020-12-15 | Japan | Ishikawa | 922 | 50 | 816 | 56 | 36.769464 | 136.771027 | 2020-12-16 05:28:04 | Ishikawa, Japan | ||
1751282 | 1751282 | 2020-12-14 | Japan | Ishikawa | 916 | 50 | 812 | 54 | 36.769464 | 136.771027 | 2020-12-15 05:26:38 | Ishikawa, Japan | ||
3847802 | 3847802 | 2020-12-13 | Japan | Ishikawa | 910 | 50 | 811 | 49 | 36.769464 | 136.771027 | 2020-12-14 05:26:27 | Ishikawa, Japan | ||
845584 | 845584 | 2020-12-12 | Japan | Ishikawa | 907 | 50 | 807 | 50 | 36.769464 | 136.771027 | 2020-12-13 05:27:20 | Ishikawa, Japan | ||
860691 | 860691 | 2020-12-11 | Japan | Ishikawa | 899 | 50 | 806 | 43 | 36.769464 | 136.771027 | 2020-12-12 05:26:19 | Ishikawa, Japan | ||
1600233 | 1600233 | 2020-12-10 | Japan | Ishikawa | 888 | 50 | 803 | 35 | 36.769464 | 136.771027 | 2020-12-11 05:26:59 | Ishikawa, Japan | ||
2975242 | 2975242 | 2020-12-09 | Japan | Ishikawa | 884 | 50 | 798 | 36 | 36.769464 | 136.771027 | 2020-12-10 05:26:19 | Ishikawa, Japan | ||
1818802 | 1818802 | 2020-12-08 | Japan | Ishikawa | 879 | 50 | 798 | 31 | 36.769464 | 136.771027 | 2020-12-09 05:28:01 | Ishikawa, Japan | ||
2347438 | 2347438 | 2020-12-07 | Japan | Ishikawa | 874 | 50 | 794 | 30 | 36.769464 | 136.771027 | 2020-12-08 05:27:42 | Ishikawa, Japan | ||
1006308 | 1006308 | 2020-12-06 | Japan | Ishikawa | 872 | 50 | 794 | 28 | 36.769464 | 136.771027 | 2020-12-07 05:26:14 | Ishikawa, Japan | ||
1632317 | 1632317 | 2020-12-05 | Japan | Ishikawa | 867 | 50 | 791 | 26 | 36.769464 | 136.771027 | 2020-12-06 05:26:18 | Ishikawa, Japan | ||
3859845 | 3859845 | 2020-12-04 | Japan | Ishikawa | 864 | 50 | 788 | 26 | 36.769464 | 136.771027 | 2020-12-05 05:27:36 | Ishikawa, Japan | ||
75103 | 75103 | 2020-12-03 | Japan | Ishikawa | 862 | 50 | 787 | 25 | 36.769464 | 136.771027 | 2020-12-04 05:27:27 | Ishikawa, Japan | ||
738315 | 738315 | 2020-12-02 | Japan | Ishikawa | 861 | 50 | 786 | 25 | 36.769464 | 136.771027 | 2020-12-03 05:28:22 | Ishikawa, Japan | ||
2537409 | 2537409 | 2020-12-01 | Japan | Ishikawa | 859 | 50 | 783 | 26 | 36.769464 | 136.771027 | 2020-12-02 05:27:41 | Ishikawa, Japan | ||
1584178 | 1584178 | 2020-11-30 | Japan | Ishikawa | 853 | 50 | 783 | 20 | 36.769464 | 136.771027 | 2020-12-01 05:26:18 | Ishikawa, Japan | ||
3566581 | 3566581 | 2020-11-29 | Japan | Ishikawa | 850 | 50 | 783 | 17 | 36.769464 | 136.771027 | 2020-11-30 05:26:13 | Ishikawa, Japan | ||
2935246 | 2935246 | 2020-11-28 | Japan | Ishikawa | 846 | 50 | 781 | 15 | 36.769464 | 136.771027 | 2020-11-29 05:25:55 | Ishikawa, Japan | ||
392249 | 392249 | 2020-11-27 | Japan | Ishikawa | 846 | 50 | 780 | 16 | 36.769464 | 136.771027 | 2020-11-28 05:25:50 | Ishikawa, Japan | ||
923696 | 923696 | 2020-11-26 | Japan | Ishikawa | 843 | 49 | 780 | 14 | 36.769464 | 136.771027 | 2020-11-27 05:26:53 | Ishikawa, Japan | ||
1972601 | 1972601 | 2020-11-25 | Japan | Ishikawa | 838 | 49 | 778 | 11 | 36.769464 | 136.771027 | 2020-11-26 05:27:44 | Ishikawa, Japan | ||
1350332 | 1350332 | 2020-11-24 | Japan | Ishikawa | 836 | 49 | 778 | 9 | 36.769464 | 136.771027 | 2020-11-25 05:27:20 | Ishikawa, Japan | ||
678326 | 678326 | 2020-11-23 | Japan | Ishikawa | 835 | 49 | 778 | 8 | 36.769464 | 136.771027 | 2020-11-24 05:27:31 | Ishikawa, Japan | ||
3190002 | 3190002 | 2020-11-22 | Japan | Ishikawa | 835 | 49 | 776 | 10 | 36.769464 | 136.771027 | 2020-11-23 05:25:26 | Ishikawa, Japan | ||
3836496 | 3836496 | 2020-11-21 | Japan | Ishikawa | 833 | 49 | 775 | 9 | 36.769464 | 136.771027 | 2020-11-22 05:25:45 | Ishikawa, Japan | ||
2701524 | 2701524 | 2020-11-20 | Japan | Ishikawa | 831 | 49 | 775 | 7 | 36.769464 | 136.771027 | 2020-11-21 05:25:51 | Ishikawa, Japan | ||
821584 | 821584 | 2020-11-19 | Japan | Ishikawa | 831 | 49 | 774 | 8 | 36.769464 | 136.771027 | 2020-11-20 05:26:28 | Ishikawa, Japan | ||
122718 | 122718 | 2020-11-18 | Japan | Ishikawa | 830 | 49 | 771 | 10 | 36.769464 | 136.771027 | 2020-11-19 05:25:23 | Ishikawa, Japan | ||
3338606 | 3338606 | 2020-11-17 | Japan | Ishikawa | 830 | 49 | 769 | 12 | 36.769464 | 136.771027 | 2020-11-18 05:40:31 | Ishikawa, Japan | ||
3169651 | 3169651 | 2020-11-16 | Japan | Ishikawa | 830 | 49 | 768 | 13 | 36.769464 | 136.771027 | 2020-11-17 05:25:54 | Ishikawa, Japan | ||
2880219 | 2880219 | 2020-11-15 | Japan | Ishikawa | 830 | 49 | 766 | 15 | 36.769464 | 136.771027 | 2020-11-16 05:25:57 | Ishikawa, Japan | ||
2915197 | 2915197 | 2020-11-14 | Japan | Ishikawa | 828 | 49 | 764 | 15 | 36.769464 | 136.771027 | 2020-11-15 05:26:53 | Ishikawa, Japan | ||
2785019 | 2785019 | 2020-11-13 | Japan | Ishikawa | 827 | 49 | 764 | 14 | 36.769464 | 136.771027 | 2020-11-14 05:25:37 | Ishikawa, Japan | ||
864784 | 864784 | 2020-11-12 | Japan | Ishikawa | 827 | 49 | 760 | 18 | 36.769464 | 136.771027 | 2020-11-13 05:25:30 | Ishikawa, Japan | ||
3440829 | 3440829 | 2020-11-11 | Japan | Ishikawa | 825 | 49 | 758 | 18 | 36.769464 | 136.771027 | 2020-11-12 05:25:55 | Ishikawa, Japan | ||
272169 | 272169 | 2020-11-10 | Japan | Ishikawa | 824 | 49 | 755 | 20 | 36.769464 | 136.771027 | 2020-11-11 05:25:30 | Ishikawa, Japan | ||
1988646 | 1988646 | 2020-11-09 | Japan | Ishikawa | 823 | 49 | 755 | 19 | 36.769464 | 136.771027 | 2020-11-10 05:40:07 | Ishikawa, Japan | ||
1728498 | 1728498 | 2020-11-08 | Japan | Ishikawa | 822 | 49 | 753 | 20 | 36.769464 | 136.771027 | 2020-11-09 05:25:45 | Ishikawa, Japan | ||
1543958 | 1543958 | 2020-11-07 | Japan | Ishikawa | 819 | 49 | 752 | 18 | 36.769464 | 136.771027 | 2020-11-08 05:24:56 | Ishikawa, Japan | ||
376196 | 376196 | 2020-11-06 | Japan | Ishikawa | 816 | 49 | 748 | 19 | 36.769464 | 136.771027 | 2020-11-07 05:24:52 | Ishikawa, Japan | ||
892134 | 892134 | 2020-11-05 | Japan | Ishikawa | 815 | 49 | 746 | 20 | 36.769464 | 136.771027 | 2020-11-06 05:24:55 | Ishikawa, Japan | ||
2919196 | 2919196 | 2020-11-04 | Japan | Ishikawa | 813 | 49 | 745 | 19 | 36.769464 | 136.771027 | 2020-11-05 06:05:03 | Ishikawa, Japan | ||
2498033 | 2498033 | 2020-11-03 | Japan | Ishikawa | 813 | 49 | 745 | 19 | 36.769464 | 136.771027 | 2020-11-04 05:25:09 | Ishikawa, Japan | ||
3304208 | 3304208 | 2020-11-02 | Japan | Ishikawa | 812 | 49 | 745 | 18 | 36.769464 | 136.771027 | 2020-11-03 06:00:16 | Ishikawa, Japan | ||
3409457 | 3409457 | 2020-11-01 | Japan | Ishikawa | 812 | 49 | 744 | 19 | 36.769464 | 136.771027 | 2020-11-02 05:25:04 | Ishikawa, Japan | ||
2079946 | 2079946 | 2020-10-31 | Japan | Ishikawa | 810 | 49 | 743 | 18 | 36.769464 | 136.771027 | 2020-11-01 04:36:19 | Ishikawa, Japan | ||
2243399 | 2243399 | 2020-10-30 | Japan | Ishikawa | 806 | 49 | 742 | 15 | 36.769464 | 136.771027 | 2020-10-31 04:24:44 | Ishikawa, Japan | ||
210254 | 210254 | 2020-10-29 | Japan | Ishikawa | 803 | 49 | 742 | 12 | 36.769464 | 136.771027 | 2020-10-30 04:24:49 | Ishikawa, Japan | ||
754316 | 754316 | 2020-10-28 | Japan | Ishikawa | 803 | 49 | 740 | 14 | 36.769464 | 136.771027 | 2020-10-29 04:24:49 | Ishikawa, Japan | ||
1452601 | 1452601 | 2020-10-27 | Japan | Ishikawa | 800 | 49 | 737 | 14 | 36.769464 | 136.771027 | 2020-10-28 04:24:39 | Ishikawa, Japan | ||
3480325 | 3480325 | 2020-10-26 | Japan | Ishikawa | 799 | 49 | 737 | 13 | 36.769464 | 136.771027 | 2020-10-27 04:24:45 | Ishikawa, Japan | ||
8346 | 8346 | 2020-10-25 | Japan | Ishikawa | 798 | 49 | 736 | 13 | 36.769464 | 136.771027 | 2020-10-26 04:25:02 | Ishikawa, Japan | ||
3651583 | 3651583 | 2020-10-24 | Japan | Ishikawa | 797 | 49 | 732 | 16 | 36.769464 | 136.771027 | 2020-10-25 04:24:36 | Ishikawa, Japan | ||
1053838 | 1053838 | 2020-10-23 | Japan | Ishikawa | 797 | 49 | 731 | 17 | 36.769464 | 136.771027 | 2020-10-24 04:24:46 | Ishikawa, Japan | ||
1177508 | 1177508 | 2020-10-22 | Japan | Ishikawa | 795 | 48 | 731 | 16 | 36.769464 | 136.771027 | 2020-10-23 04:24:46 | Ishikawa, Japan | ||
2191613 | 2191613 | 2020-10-21 | Japan | Ishikawa | 795 | 47 | 726 | 22 | 36.769464 | 136.771027 | 2020-10-22 04:24:27 | Ishikawa, Japan | ||
3990624 | 3990624 | 2020-10-20 | Japan | Ishikawa | 795 | 47 | 726 | 22 | 36.769464 | 136.771027 | 2020-10-21 04:24:14 | Ishikawa, Japan | ||
1794644 | 1794644 | 2020-10-19 | Japan | Ishikawa | 795 | 47 | 723 | 25 | 36.769464 | 136.771027 | 2020-10-20 04:24:22 | Ishikawa, Japan | ||
762328 | 762328 | 2020-10-18 | Japan | Ishikawa | 795 | 47 | 721 | 27 | 36.769464 | 136.771027 | 2020-10-19 04:24:16 | Ishikawa, Japan | ||
1026366 | 1026366 | 2020-10-17 | Japan | Ishikawa | 793 | 47 | 721 | 25 | 36.769464 | 136.771027 | 2020-10-18 04:24:25 | Ishikawa, Japan | ||
2856861 | 2856861 | 2020-10-16 | Japan | Ishikawa | 788 | 47 | 721 | 20 | 36.769464 | 136.771027 | 2020-10-17 04:24:12 | Ishikawa, Japan | ||
786391 | 786391 | 2020-10-15 | Japan | Ishikawa | 787 | 47 | 718 | 22 | 36.769464 | 136.771027 | 2020-10-16 04:24:01 | Ishikawa, Japan | ||
79102 | 79102 | 2020-10-14 | Japan | Ishikawa | 786 | 47 | 715 | 24 | 36.769464 | 136.771027 | 2020-10-15 04:24:28 | Ishikawa, Japan | ||
3781917 | 3781917 | 2020-10-13 | Japan | Ishikawa | 782 | 47 | 712 | 23 | 36.769464 | 136.771027 | 2020-10-14 04:24:05 | Ishikawa, Japan | ||
2291457 | 2291457 | 2020-10-12 | Japan | Ishikawa | 780 | 47 | 712 | 21 | 36.769464 | 136.771027 | 2020-10-13 04:24:02 | Ishikawa, Japan | ||
3785910 | 3785910 | 2020-10-11 | Japan | Ishikawa | 780 | 47 | 712 | 21 | 36.769464 | 136.771027 | 2020-10-12 04:23:45 | Ishikawa, Japan | ||
2602048 | 2602048 | 2020-10-10 | Japan | Ishikawa | 780 | 47 | 712 | 21 | 36.769464 | 136.771027 | 2020-10-11 04:23:46 | Ishikawa, Japan | ||
817581 | 817581 | 2020-10-09 | Japan | Ishikawa | 780 | 47 | 710 | 23 | 36.769464 | 136.771027 | 2020-10-10 04:23:57 | Ishikawa, Japan | ||
2689696 | 2689696 | 2020-10-08 | Japan | Ishikawa | 778 | 47 | 708 | 23 | 36.769464 | 136.771027 | 2020-10-09 04:23:59 | Ishikawa, Japan | ||
1041838 | 1041838 | 2020-10-07 | Japan | Ishikawa | 778 | 47 | 704 | 27 | 36.769464 | 136.771027 | 2020-10-08 04:23:56 | Ishikawa, Japan | ||
3117499 | 3117499 | 2020-10-06 | Japan | Ishikawa | 778 | 47 | 701 | 30 | 36.769464 | 136.771027 | 2020-10-07 04:23:40 | Ishikawa, Japan | ||
3801911 | 3801911 | 2020-10-05 | Japan | Ishikawa | 778 | 47 | 696 | 35 | 36.769464 | 136.771027 | 2020-10-06 04:23:33 | Ishikawa, Japan | ||
1822801 | 1822801 | 2020-10-04 | Japan | Ishikawa | 777 | 47 | 694 | 36 | 36.769464 | 136.771027 | 2020-10-05 04:23:33 | Ishikawa, 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]);