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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
182054 | 182054 | 2021-02-21 | Japan | Ishikawa | 1790 | 61 | 1542 | 187 | 36.769464 | 136.771027 | 2021-02-22 05:24:21 | Ishikawa, Japan | ||
742328 | 742328 | 2021-02-20 | Japan | Ishikawa | 1778 | 61 | 1529 | 188 | 36.769464 | 136.771027 | 2021-02-21 05:24:33 | Ishikawa, Japan | ||
471426 | 471426 | 2021-02-19 | Japan | Ishikawa | 1760 | 61 | 1515 | 184 | 36.769464 | 136.771027 | 2021-02-20 05:22:51 | Ishikawa, Japan | ||
1153135 | 1153135 | 2021-02-18 | Japan | Ishikawa | 1743 | 60 | 1498 | 185 | 36.769464 | 136.771027 | 2021-02-19 05:24:16 | Ishikawa, Japan | ||
3601055 | 3601055 | 2021-02-17 | Japan | Ishikawa | 1728 | 60 | 1474 | 194 | 36.769464 | 136.771027 | 2021-02-18 05:22:58 | Ishikawa, Japan | ||
3050190 | 3050190 | 2021-02-16 | Japan | Ishikawa | 1714 | 60 | 1461 | 193 | 36.769464 | 136.771027 | 2021-02-17 05:23:10 | Ishikawa, Japan | ||
1338289 | 1338289 | 2021-02-15 | Japan | Ishikawa | 1693 | 60 | 1449 | 184 | 36.769464 | 136.771027 | 2021-02-16 05:24:38 | Ishikawa, Japan | ||
2283440 | 2283440 | 2021-02-14 | Japan | Ishikawa | 1682 | 60 | 1428 | 194 | 36.769464 | 136.771027 | 2021-02-15 05:24:49 | Ishikawa, Japan | ||
2677840 | 2677840 | 2021-02-13 | Japan | Ishikawa | 1652 | 60 | 1414 | 178 | 36.769464 | 136.771027 | 2021-02-14 05:23:43 | Ishikawa, Japan | ||
3539473 | 3539473 | 2021-02-12 | Japan | Ishikawa | 1636 | 60 | 1408 | 168 | 36.769464 | 136.771027 | 2021-02-13 05:22:12 | Ishikawa, Japan | ||
2637736 | 2637736 | 2021-02-11 | Japan | Ishikawa | 1621 | 60 | 1399 | 162 | 36.769464 | 136.771027 | 2021-02-12 05:23:29 | Ishikawa, Japan | ||
3978591 | 3978591 | 2021-02-10 | Japan | Ishikawa | 1596 | 60 | 1388 | 148 | 36.769464 | 136.771027 | 2021-02-11 05:23:55 | Ishikawa, Japan | ||
1527911 | 1527911 | 2021-02-09 | Japan | Ishikawa | 1580 | 60 | 1383 | 137 | 36.769464 | 136.771027 | 2021-02-10 05:22:41 | Ishikawa, Japan | ||
613702 | 613702 | 2021-02-08 | Japan | Ishikawa | 1570 | 60 | 1378 | 132 | 36.769464 | 136.771027 | 2021-02-09 05:23:30 | Ishikawa, Japan | ||
1672471 | 1672471 | 2021-02-07 | Japan | Ishikawa | 1563 | 59 | 1376 | 128 | 36.769464 | 136.771027 | 2021-02-08 05:22:39 | Ishikawa, Japan | ||
974932 | 974932 | 2021-02-06 | Japan | Ishikawa | 1533 | 59 | 1371 | 103 | 36.769464 | 136.771027 | 2021-02-07 05:23:00 | Ishikawa, Japan | ||
1588190 | 1588190 | 2021-02-05 | Japan | Ishikawa | 1519 | 58 | 1358 | 103 | 36.769464 | 136.771027 | 2021-02-06 05:23:55 | Ishikawa, Japan | ||
790397 | 790397 | 2021-02-04 | Japan | Ishikawa | 1494 | 58 | 1347 | 89 | 36.769464 | 136.771027 | 2021-02-05 05:22:38 | Ishikawa, Japan | ||
340289 | 340289 | 2021-02-03 | Japan | Ishikawa | 1484 | 58 | 1339 | 87 | 36.769464 | 136.771027 | 2021-02-04 05:22:26 | Ishikawa, Japan | ||
1684515 | 1684515 | 2021-02-02 | Japan | Ishikawa | 1473 | 58 | 1331 | 84 | 36.769464 | 136.771027 | 2021-02-03 05:22:52 | Ishikawa, Japan | ||
1676485 | 1676485 | 2021-02-01 | Japan | Ishikawa | 1466 | 58 | 1323 | 85 | 36.769464 | 136.771027 | 2021-02-02 05:22:49 | Ishikawa, Japan | ||
1459773 | 1459773 | 2021-01-31 | Japan | Ishikawa | 1462 | 58 | 1290 | 114 | 36.769464 | 136.771027 | 2021-02-01 05:22:53 | Ishikawa, Japan | ||
2211681 | 2211681 | 2021-01-30 | Japan | Ishikawa | 1455 | 58 | 1290 | 107 | 36.769464 | 136.771027 | 2021-01-31 05:22:42 | Ishikawa, Japan | ||
1897168 | 1897168 | 2021-01-29 | Japan | Ishikawa | 1451 | 58 | 1277 | 116 | 36.769464 | 136.771027 | 2021-01-30 05:22:49 | Ishikawa, Japan | ||
2481984 | 2481984 | 2021-01-28 | Japan | Ishikawa | 1447 | 58 | 1256 | 133 | 36.769464 | 136.771027 | 2021-01-29 05:22:23 | Ishikawa, Japan | ||
3153619 | 3153619 | 2021-01-27 | Japan | Ishikawa | 1442 | 57 | 1238 | 147 | 36.769464 | 136.771027 | 2021-01-28 05:22:24 | Ishikawa, Japan | ||
12354 | 12354 | 2021-01-26 | Japan | Ishikawa | 1437 | 57 | 1227 | 153 | 36.769464 | 136.771027 | 2021-01-27 05:23:41 | Ishikawa, Japan | ||
2567678 | 2567678 | 2021-01-25 | Japan | Ishikawa | 1423 | 57 | 1188 | 178 | 36.769464 | 136.771027 | 2021-01-26 05:22:02 | Ishikawa, Japan | ||
1759310 | 1759310 | 2021-01-24 | Japan | Ishikawa | 1422 | 56 | 1188 | 178 | 36.769464 | 136.771027 | 2021-01-25 05:22:16 | Ishikawa, Japan | ||
2426917 | 2426917 | 2021-01-23 | Japan | Ishikawa | 1416 | 56 | 1169 | 191 | 36.769464 | 136.771027 | 2021-01-24 05:22:35 | Ishikawa, Japan | ||
2466819 | 2466819 | 2021-01-22 | Japan | Ishikawa | 1403 | 56 | 1156 | 191 | 36.769464 | 136.771027 | 2021-01-23 05:22:03 | Ishikawa, Japan | ||
435370 | 435370 | 2021-01-21 | Japan | Ishikawa | 1393 | 56 | 1145 | 192 | 36.769464 | 136.771027 | 2021-01-22 05:22:10 | Ishikawa, Japan | ||
1094102 | 1094102 | 2021-01-20 | Japan | Ishikawa | 1373 | 55 | 1133 | 185 | 36.769464 | 136.771027 | 2021-01-21 05:22:01 | Ishikawa, Japan | ||
908192 | 908192 | 2021-01-19 | Japan | Ishikawa | 1356 | 55 | 1120 | 181 | 36.769464 | 136.771027 | 2021-01-20 05:21:54 | Ishikawa, Japan | ||
237255 | 237255 | 2021-01-18 | Japan | Ishikawa | 1337 | 54 | 1108 | 175 | 36.769464 | 136.771027 | 2021-01-19 05:22:15 | Ishikawa, Japan | ||
3503372 | 3503372 | 2021-01-17 | Japan | Ishikawa | 1325 | 54 | 1084 | 187 | 36.769464 | 136.771027 | 2021-01-18 05:22:34 | Ishikawa, Japan | ||
3101455 | 3101455 | 2021-01-16 | Japan | Ishikawa | 1309 | 53 | 1070 | 186 | 36.769464 | 136.771027 | 2021-01-17 05:22:17 | Ishikawa, Japan | ||
3515417 | 3515417 | 2021-01-15 | Japan | Ishikawa | 1287 | 53 | 1058 | 176 | 36.769464 | 136.771027 | 2021-01-16 05:22:40 | Ishikawa, Japan | ||
3879590 | 3879590 | 2021-01-14 | Japan | Ishikawa | 1267 | 53 | 1041 | 173 | 36.769464 | 136.771027 | 2021-01-15 05:22:24 | Ishikawa, Japan | ||
3308217 | 3308217 | 2021-01-13 | Japan | Ishikawa | 1248 | 53 | 1023 | 172 | 36.769464 | 136.771027 | 2021-01-14 05:22:32 | Ishikawa, Japan | ||
774362 | 774362 | 2021-01-12 | Japan | Ishikawa | 1238 | 52 | 1011 | 175 | 36.769464 | 136.771027 | 2021-01-13 05:22:15 | Ishikawa, Japan | ||
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 |
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]);