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 = "Aichi" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190069 | 190069 | 2021-01-11 | Japan | Aichi | 19638 | 279 | 15634 | 3725 | 35.035551 | 137.211621 | 2021-01-12 05:22:15 | Aichi, Japan | ||
2625872 | 2625872 | 2021-01-10 | Japan | Aichi | 19440 | 275 | 15474 | 3691 | 35.035551 | 137.211621 | 2021-01-11 05:21:50 | Aichi, Japan | ||
3899960 | 3899960 | 2021-01-09 | Japan | Aichi | 19097 | 266 | 15251 | 3580 | 35.035551 | 137.211621 | 2021-01-10 05:22:12 | Aichi, Japan | ||
153983 | 153983 | 2021-01-08 | Japan | Aichi | 18735 | 263 | 15030 | 3442 | 35.035551 | 137.211621 | 2021-01-09 05:22:18 | Aichi, Japan | ||
2541407 | 2541407 | 2021-01-07 | Japan | Aichi | 18330 | 256 | 14766 | 3308 | 35.035551 | 137.211621 | 2021-01-08 05:22:42 | Aichi, Japan | ||
2864716 | 2864716 | 2021-01-06 | Japan | Aichi | 17899 | 248 | 14541 | 3110 | 35.035551 | 137.211621 | 2021-01-07 05:22:03 | Aichi, Japan | ||
3034303 | 3034303 | 2021-01-05 | Japan | Aichi | 17535 | 239 | 14385 | 2911 | 35.035551 | 137.211621 | 2021-01-06 05:22:16 | Aichi, Japan | ||
1061848 | 1061848 | 2021-01-04 | Japan | Aichi | 17262 | 232 | 14129 | 2901 | 35.035551 | 137.211621 | 2021-01-05 05:21:49 | Aichi, Japan | ||
3230451 | 3230451 | 2021-01-03 | Japan | Aichi | 17110 | 227 | 13976 | 2907 | 35.035551 | 137.211621 | 2021-01-04 05:22:02 | Aichi, Japan | ||
2227520 | 2227520 | 2021-01-02 | Japan | Aichi | 16925 | 221 | 13797 | 2907 | 35.035551 | 137.211621 | 2021-01-03 05:22:52 | Aichi, Japan | ||
1136884 | 1136884 | 2021-01-01 | Japan | Aichi | 16767 | 216 | 13596 | 2955 | 35.035551 | 137.211621 | 2021-01-02 05:22:33 | Aichi, Japan | ||
3695490 | 3695490 | 2020-12-31 | Japan | Aichi | 16574 | 214 | 13457 | 2903 | 35.035551 | 137.211621 | 2021-01-01 05:23:07 | Aichi, Japan | ||
1010305 | 1010305 | 2020-12-30 | Japan | Aichi | 16335 | 209 | 13329 | 2797 | 35.035551 | 137.211621 | 2020-12-31 05:22:49 | Aichi, Japan | ||
766320 | 766320 | 2020-12-29 | Japan | Aichi | 16041 | 206 | 13118 | 2717 | 35.035551 | 137.211621 | 2020-12-30 05:22:34 | Aichi, Japan | ||
3761584 | 3761584 | 2020-12-28 | Japan | Aichi | 15806 | 202 | 12933 | 2671 | 35.035551 | 137.211621 | 2020-12-29 05:22:37 | Aichi, Japan | ||
3777904 | 3777904 | 2020-12-27 | Japan | Aichi | 15684 | 195 | 12719 | 2770 | 35.035551 | 137.211621 | 2020-12-28 05:22:06 | Aichi, Japan | ||
2223509 | 2223509 | 2020-12-26 | Japan | Aichi | 15468 | 194 | 12509 | 2765 | 35.035551 | 137.211621 | 2020-12-27 05:22:55 | Aichi, Japan | ||
202256 | 202256 | 2020-12-25 | Japan | Aichi | 15203 | 188 | 12304 | 2711 | 35.035551 | 137.211621 | 2020-12-26 05:22:28 | Aichi, Japan | ||
3691479 | 3691479 | 2020-12-24 | Japan | Aichi | 14938 | 185 | 12072 | 2681 | 35.035551 | 137.211621 | 2020-12-25 05:22:48 | Aichi, Japan | ||
2406831 | 2406831 | 2020-12-23 | Japan | Aichi | 14668 | 177 | 11894 | 2597 | 35.035551 | 137.211621 | 2020-12-24 05:23:04 | Aichi, Japan | ||
3769877 | 3769877 | 2020-12-22 | Japan | Aichi | 14429 | 174 | 11712 | 2543 | 35.035551 | 137.211621 | 2020-12-23 05:22:03 | Aichi, Japan | ||
927693 | 927693 | 2020-12-21 | Japan | Aichi | 14239 | 168 | 11581 | 2490 | 35.035551 | 137.211621 | 2020-12-22 05:22:33 | Aichi, Japan | ||
2119714 | 2119714 | 2020-12-20 | Japan | Aichi | 14147 | 163 | 11357 | 2627 | 35.035551 | 137.211621 | 2020-12-21 05:27:58 | Aichi, Japan | ||
2931221 | 2931221 | 2020-12-19 | Japan | Aichi | 13987 | 158 | 11130 | 2699 | 35.035551 | 137.211621 | 2020-12-20 05:27:32 | Aichi, Japan | ||
1901167 | 1901167 | 2020-12-18 | Japan | Aichi | 13757 | 156 | 10931 | 2670 | 35.035551 | 137.211621 | 2020-12-19 05:27:52 | Aichi, Japan | ||
2127993 | 2127993 | 2020-12-17 | Japan | Aichi | 13538 | 152 | 10733 | 2653 | 35.035551 | 137.211621 | 2020-12-18 05:28:18 | Aichi, Japan | ||
3149593 | 3149593 | 2020-12-16 | Japan | Aichi | 13300 | 150 | 10544 | 2606 | 35.035551 | 137.211621 | 2020-12-17 05:28:12 | Aichi, Japan | ||
1034374 | 1034374 | 2020-12-15 | Japan | Aichi | 13052 | 147 | 10393 | 2512 | 35.035551 | 137.211621 | 2020-12-16 05:28:04 | Aichi, Japan | ||
1751268 | 1751268 | 2020-12-14 | Japan | Aichi | 12836 | 145 | 10251 | 2440 | 35.035551 | 137.211621 | 2020-12-15 05:26:38 | Aichi, Japan | ||
3847788 | 3847788 | 2020-12-13 | Japan | Aichi | 12722 | 144 | 10114 | 2464 | 35.035551 | 137.211621 | 2020-12-14 05:26:27 | Aichi, Japan | ||
845570 | 845570 | 2020-12-12 | Japan | Aichi | 12541 | 143 | 9922 | 2476 | 35.035551 | 137.211621 | 2020-12-13 05:27:20 | Aichi, Japan | ||
860677 | 860677 | 2020-12-11 | Japan | Aichi | 12335 | 142 | 9717 | 2476 | 35.035551 | 137.211621 | 2020-12-12 05:26:19 | Aichi, Japan | ||
1600219 | 1600219 | 2020-12-10 | Japan | Aichi | 12137 | 140 | 9547 | 2450 | 35.035551 | 137.211621 | 2020-12-11 05:26:59 | Aichi, Japan | ||
2975228 | 2975228 | 2020-12-09 | Japan | Aichi | 11895 | 138 | 9414 | 2343 | 35.035551 | 137.211621 | 2020-12-10 05:26:19 | Aichi, Japan | ||
1818788 | 1818788 | 2020-12-08 | Japan | Aichi | 11650 | 138 | 9273 | 2239 | 35.035551 | 137.211621 | 2020-12-09 05:28:01 | Aichi, Japan | ||
2347424 | 2347424 | 2020-12-07 | Japan | Aichi | 11451 | 134 | 9163 | 2154 | 35.035551 | 137.211621 | 2020-12-08 05:27:42 | Aichi, Japan | ||
1006294 | 1006294 | 2020-12-06 | Japan | Aichi | 11340 | 132 | 9002 | 2206 | 35.035551 | 137.211621 | 2020-12-07 05:26:14 | Aichi, Japan | ||
1632303 | 1632303 | 2020-12-05 | Japan | Aichi | 11170 | 129 | 8798 | 2243 | 35.035551 | 137.211621 | 2020-12-06 05:26:18 | Aichi, Japan | ||
3859831 | 3859831 | 2020-12-04 | Japan | Aichi | 10951 | 127 | 8640 | 2184 | 35.035551 | 137.211621 | 2020-12-05 05:27:36 | Aichi, Japan | ||
75089 | 75089 | 2020-12-03 | Japan | Aichi | 10736 | 123 | 8457 | 2156 | 35.035551 | 137.211621 | 2020-12-04 05:27:27 | Aichi, Japan | ||
738301 | 738301 | 2020-12-02 | Japan | Aichi | 10541 | 122 | 8307 | 2112 | 35.035551 | 137.211621 | 2020-12-03 05:28:22 | Aichi, Japan | ||
2537395 | 2537395 | 2020-12-01 | Japan | Aichi | 10322 | 121 | 8307 | 1894 | 35.035551 | 137.211621 | 2020-12-02 05:27:41 | Aichi, Japan | ||
1584164 | 1584164 | 2020-11-30 | Japan | Aichi | 10125 | 119 | 7983 | 2023 | 35.035551 | 137.211621 | 2020-12-01 05:26:18 | Aichi, Japan | ||
3566567 | 3566567 | 2020-11-29 | Japan | Aichi | 10016 | 116 | 7751 | 2149 | 35.035551 | 137.211621 | 2020-11-30 05:26:13 | Aichi, Japan | ||
2935232 | 2935232 | 2020-11-28 | Japan | Aichi | 9861 | 115 | 7624 | 2122 | 35.035551 | 137.211621 | 2020-11-29 05:25:55 | Aichi, Japan | ||
392235 | 392235 | 2020-11-27 | Japan | Aichi | 9644 | 115 | 7479 | 2050 | 35.035551 | 137.211621 | 2020-11-28 05:25:50 | Aichi, Japan | ||
923682 | 923682 | 2020-11-26 | Japan | Aichi | 9410 | 113 | 7331 | 1966 | 35.035551 | 137.211621 | 2020-11-27 05:26:53 | Aichi, Japan | ||
1972587 | 1972587 | 2020-11-25 | Japan | Aichi | 9212 | 113 | 7216 | 1883 | 35.035551 | 137.211621 | 2020-11-26 05:27:44 | Aichi, Japan | ||
1350318 | 1350318 | 2020-11-24 | Japan | Aichi | 9035 | 110 | 7133 | 1792 | 35.035551 | 137.211621 | 2020-11-25 05:27:20 | Aichi, Japan | ||
678312 | 678312 | 2020-11-23 | Japan | Aichi | 8925 | 109 | 7065 | 1751 | 35.035551 | 137.211621 | 2020-11-24 05:27:31 | Aichi, Japan | ||
3189988 | 3189988 | 2020-11-22 | Japan | Aichi | 8830 | 106 | 6947 | 1777 | 35.035551 | 137.211621 | 2020-11-23 05:25:26 | Aichi, Japan | ||
3836482 | 3836482 | 2020-11-21 | Japan | Aichi | 8686 | 105 | 6841 | 1740 | 35.035551 | 137.211621 | 2020-11-22 05:25:45 | Aichi, Japan | ||
2701510 | 2701510 | 2020-11-20 | Japan | Aichi | 8475 | 104 | 6734 | 1637 | 35.035551 | 137.211621 | 2020-11-21 05:25:51 | Aichi, Japan | ||
821570 | 821570 | 2020-11-19 | Japan | Aichi | 8273 | 104 | 6612 | 1557 | 35.035551 | 137.211621 | 2020-11-20 05:26:28 | Aichi, Japan | ||
122704 | 122704 | 2020-11-18 | Japan | Aichi | 8054 | 103 | 6555 | 1396 | 35.035551 | 137.211621 | 2020-11-19 05:25:23 | Aichi, Japan | ||
3338592 | 3338592 | 2020-11-17 | Japan | Aichi | 7913 | 101 | 6490 | 1322 | 35.035551 | 137.211621 | 2020-11-18 05:40:31 | Aichi, Japan | ||
3169637 | 3169637 | 2020-11-16 | Japan | Aichi | 7775 | 100 | 6443 | 1232 | 35.035551 | 137.211621 | 2020-11-17 05:25:54 | Aichi, Japan | ||
2880205 | 2880205 | 2020-11-15 | Japan | Aichi | 7712 | 100 | 6327 | 1285 | 35.035551 | 137.211621 | 2020-11-16 05:25:57 | Aichi, Japan | ||
2915183 | 2915183 | 2020-11-14 | Japan | Aichi | 7610 | 100 | 6294 | 1216 | 35.035551 | 137.211621 | 2020-11-15 05:26:53 | Aichi, Japan | ||
2785005 | 2785005 | 2020-11-13 | Japan | Aichi | 7458 | 100 | 6214 | 1144 | 35.035551 | 137.211621 | 2020-11-14 05:25:37 | Aichi, Japan | ||
864770 | 864770 | 2020-11-12 | Japan | Aichi | 7310 | 100 | 6210 | 1000 | 35.035551 | 137.211621 | 2020-11-13 05:25:30 | Aichi, Japan | ||
3440815 | 3440815 | 2020-11-11 | Japan | Aichi | 7167 | 100 | 6015 | 1052 | 35.035551 | 137.211621 | 2020-11-12 05:25:55 | Aichi, Japan | ||
272155 | 272155 | 2020-11-10 | Japan | Aichi | 7063 | 98 | 5949 | 1016 | 35.035551 | 137.211621 | 2020-11-11 05:25:30 | Aichi, Japan | ||
1988632 | 1988632 | 2020-11-09 | Japan | Aichi | 6935 | 98 | 5923 | 914 | 35.035551 | 137.211621 | 2020-11-10 05:40:07 | Aichi, Japan | ||
1728484 | 1728484 | 2020-11-08 | Japan | Aichi | 6878 | 98 | 5872 | 908 | 35.035551 | 137.211621 | 2020-11-09 05:25:45 | Aichi, Japan | ||
1543944 | 1543944 | 2020-11-07 | Japan | Aichi | 6797 | 97 | 5806 | 894 | 35.035551 | 137.211621 | 2020-11-08 05:24:56 | Aichi, Japan | ||
376182 | 376182 | 2020-11-06 | Japan | Aichi | 6684 | 97 | 5749 | 838 | 35.035551 | 137.211621 | 2020-11-07 05:24:52 | Aichi, Japan | ||
892120 | 892120 | 2020-11-05 | Japan | Aichi | 6602 | 97 | 5729 | 776 | 35.035551 | 137.211621 | 2020-11-06 05:24:55 | Aichi, Japan | ||
2919182 | 2919182 | 2020-11-04 | Japan | Aichi | 6523 | 96 | 5702 | 725 | 35.035551 | 137.211621 | 2020-11-05 06:05:03 | Aichi, Japan | ||
2498019 | 2498019 | 2020-11-03 | Japan | Aichi | 6470 | 96 | 5660 | 714 | 35.035551 | 137.211621 | 2020-11-04 05:25:09 | Aichi, Japan | ||
3304194 | 3304194 | 2020-11-02 | Japan | Aichi | 6385 | 96 | 5637 | 652 | 35.035551 | 137.211621 | 2020-11-03 06:00:16 | Aichi, Japan | ||
3409443 | 3409443 | 2020-11-01 | Japan | Aichi | 6341 | 96 | 5613 | 632 | 35.035551 | 137.211621 | 2020-11-02 05:25:04 | Aichi, Japan | ||
2079932 | 2079932 | 2020-10-31 | Japan | Aichi | 6293 | 96 | 5600 | 597 | 35.035551 | 137.211621 | 2020-11-01 04:36:19 | Aichi, Japan | ||
2243385 | 2243385 | 2020-10-30 | Japan | Aichi | 6196 | 95 | 5580 | 521 | 35.035551 | 137.211621 | 2020-10-31 04:24:44 | Aichi, Japan | ||
210240 | 210240 | 2020-10-29 | Japan | Aichi | 6145 | 94 | 5555 | 496 | 35.035551 | 137.211621 | 2020-10-30 04:24:49 | Aichi, Japan | ||
754302 | 754302 | 2020-10-28 | Japan | Aichi | 6058 | 94 | 5538 | 426 | 35.035551 | 137.211621 | 2020-10-29 04:24:49 | Aichi, Japan | ||
1452587 | 1452587 | 2020-10-27 | Japan | Aichi | 6007 | 92 | 5524 | 391 | 35.035551 | 137.211621 | 2020-10-28 04:24:39 | Aichi, Japan | ||
3480311 | 3480311 | 2020-10-26 | Japan | Aichi | 5972 | 92 | 5499 | 381 | 35.035551 | 137.211621 | 2020-10-27 04:24:45 | Aichi, Japan | ||
8332 | 8332 | 2020-10-25 | Japan | Aichi | 5935 | 92 | 5453 | 390 | 35.035551 | 137.211621 | 2020-10-26 04:25:02 | Aichi, Japan | ||
3651569 | 3651569 | 2020-10-24 | Japan | Aichi | 5919 | 92 | 5430 | 397 | 35.035551 | 137.211621 | 2020-10-25 04:24:36 | Aichi, Japan | ||
1053824 | 1053824 | 2020-10-23 | Japan | Aichi | 5877 | 92 | 5406 | 379 | 35.035551 | 137.211621 | 2020-10-24 04:24:46 | Aichi, Japan | ||
1177494 | 1177494 | 2020-10-22 | Japan | Aichi | 5834 | 92 | 5394 | 348 | 35.035551 | 137.211621 | 2020-10-23 04:24:46 | Aichi, Japan | ||
2191599 | 2191599 | 2020-10-21 | Japan | Aichi | 5815 | 91 | 5376 | 348 | 35.035551 | 137.211621 | 2020-10-22 04:24:27 | Aichi, Japan | ||
3990610 | 3990610 | 2020-10-20 | Japan | Aichi | 5779 | 91 | 5361 | 327 | 35.035551 | 137.211621 | 2020-10-21 04:24:14 | Aichi, Japan | ||
1794630 | 1794630 | 2020-10-19 | Japan | Aichi | 5766 | 91 | 5341 | 334 | 35.035551 | 137.211621 | 2020-10-20 04:24:22 | Aichi, Japan | ||
762314 | 762314 | 2020-10-18 | Japan | Aichi | 5751 | 91 | 5305 | 355 | 35.035551 | 137.211621 | 2020-10-19 04:24:16 | Aichi, Japan | ||
1026352 | 1026352 | 2020-10-17 | Japan | Aichi | 5730 | 91 | 5305 | 334 | 35.035551 | 137.211621 | 2020-10-18 04:24:25 | Aichi, Japan | ||
2856847 | 2856847 | 2020-10-16 | Japan | Aichi | 5702 | 91 | 5287 | 324 | 35.035551 | 137.211621 | 2020-10-17 04:24:12 | Aichi, Japan | ||
786377 | 786377 | 2020-10-15 | Japan | Aichi | 5681 | 91 | 5258 | 332 | 35.035551 | 137.211621 | 2020-10-16 04:24:01 | Aichi, Japan | ||
79088 | 79088 | 2020-10-14 | Japan | Aichi | 5662 | 91 | 5228 | 343 | 35.035551 | 137.211621 | 2020-10-15 04:24:28 | Aichi, Japan | ||
3781903 | 3781903 | 2020-10-13 | Japan | Aichi | 5647 | 91 | 5193 | 363 | 35.035551 | 137.211621 | 2020-10-14 04:24:05 | Aichi, Japan | ||
2291443 | 2291443 | 2020-10-12 | Japan | Aichi | 5623 | 91 | 5179 | 353 | 35.035551 | 137.211621 | 2020-10-13 04:24:02 | Aichi, Japan | ||
3785896 | 3785896 | 2020-10-11 | Japan | Aichi | 5605 | 91 | 5155 | 359 | 35.035551 | 137.211621 | 2020-10-12 04:23:45 | Aichi, Japan | ||
2602034 | 2602034 | 2020-10-10 | Japan | Aichi | 5591 | 90 | 5136 | 365 | 35.035551 | 137.211621 | 2020-10-11 04:23:46 | Aichi, Japan | ||
817567 | 817567 | 2020-10-09 | Japan | Aichi | 5570 | 89 | 5112 | 369 | 35.035551 | 137.211621 | 2020-10-10 04:23:57 | Aichi, Japan | ||
2689682 | 2689682 | 2020-10-08 | Japan | Aichi | 5559 | 89 | 5085 | 385 | 35.035551 | 137.211621 | 2020-10-09 04:23:59 | Aichi, Japan | ||
1041824 | 1041824 | 2020-10-07 | Japan | Aichi | 5544 | 89 | 5060 | 395 | 35.035551 | 137.211621 | 2020-10-08 04:23:56 | Aichi, Japan | ||
3117485 | 3117485 | 2020-10-06 | Japan | Aichi | 5529 | 89 | 5034 | 406 | 35.035551 | 137.211621 | 2020-10-07 04:23:40 | Aichi, Japan | ||
3801897 | 3801897 | 2020-10-05 | Japan | Aichi | 5515 | 86 | 5024 | 405 | 35.035551 | 137.211621 | 2020-10-06 04:23:33 | Aichi, Japan | ||
1822787 | 1822787 | 2020-10-04 | Japan | Aichi | 5503 | 86 | 4984 | 433 | 35.035551 | 137.211621 | 2020-10-05 04:23:33 | Aichi, 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]);