johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,947 rows where active = 68 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 1,697
- Japan 62
- China 16
- France 12
- India 11
- Malaysia 11
- Netherlands 11
- Russia 11
- Italy 10
- Mexico 9
- Colombia 8
- Canada 7
- Germany 7
- Ukraine 7
- Chad 6
- Liberia 5
- Malta 5
- United Kingdom 5
- Monaco 4
- New Zealand 4
- Eritrea 3
- Seychelles 3
- Singapore 3
- Brunei 2
- Djibouti 2
- Gabon 2
- Saint Lucia 2
- Taiwan* 2
- Australia 1
- Burkina Faso 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3809590 | 3809590 | 2021-09-11 | Malaysia | W.P. Labuan | 9872 | 148 | 9656 | 68 | 5.2831 | 115.2308 | 2021-09-12 04:21:13 | W.P. Labuan, Malaysia | ||
3452530 | 3452530 | 2021-09-10 | Malaysia | W.P. Labuan | 9870 | 148 | 9654 | 68 | 5.2831 | 115.2308 | 2021-09-11 04:21:30 | W.P. Labuan, Malaysia | ||
3468449 | 3468449 | 2021-08-03 | San Marino | 5167 | 90 | 5009 | 68 | 43.9424 | 12.4578 | 2021-08-04 04:21:25 | San Marino | |||
3683337 | 3683337 | 2021-08-02 | Eritrea | 6559 | 35 | 6456 | 68 | 15.1794 | 39.7823 | 2021-08-03 04:21:39 | Eritrea | |||
3015236 | 3015236 | 2021-08-01 | Eritrea | 6547 | 35 | 6444 | 68 | 15.1794 | 39.7823 | 2021-08-02 04:21:36 | Eritrea | |||
3903859 | 3903859 | 2021-07-31 | Eritrea | 6547 | 35 | 6444 | 68 | 15.1794 | 39.7823 | 2021-08-01 04:21:50 | Eritrea | |||
411932 | 411932 | 2021-07-28 | Ukraine | Rivne Oblast | 79665 | 1207 | 78390 | 68 | 50.6199 | 26.2516 | 2021-07-29 04:21:33 | Rivne Oblast, Ukraine | ||
1306179 | 1306179 | 2021-07-27 | Japan | Miyazaki | 3173 | 27 | 3078 | 68 | 32.193203999999994 | 131.299374 | 2021-07-28 04:21:39 | Miyazaki, Japan | ||
1306174 | 1306174 | 2021-07-27 | Japan | Kochi | 2009 | 29 | 1912 | 68 | 33.422519 | 133.367307 | 2021-07-28 04:21:39 | Kochi, Japan | ||
1306059 | 1306059 | 2021-07-27 | Gabon | 25344 | 163 | 25113 | 68 | -0.8037 | 11.6094 | 2021-07-28 04:21:39 | Gabon | |||
1305958 | 1305958 | 2021-07-27 | China | Guangdong | 2869 | 8 | 2793 | 68 | 23.3417 | 113.4244 | 2021-07-28 04:21:39 | Guangdong, China | ||
3218202 | 3218202 | 2021-07-26 | Gabon | 25344 | 163 | 25113 | 68 | -0.8037 | 11.6094 | 2021-07-27 04:21:18 | Gabon | |||
1378526 | 1378526 | 2021-07-25 | Japan | Kochi | 1994 | 29 | 1897 | 68 | 33.422519 | 133.367307 | 2021-07-26 04:21:28 | Kochi, Japan | ||
1378317 | 1378317 | 2021-07-25 | China | Hong Kong | 11978 | 212 | 11698 | 68 | 22.3 | 114.2 | 2021-07-26 04:21:28 | Hong Kong, China | ||
1330200 | 1330200 | 2021-07-24 | India | Ladakh | 20296 | 207 | 20021 | 68 | 34.1526 | 77.5771 | 2021-07-25 04:22:12 | Ladakh, India | ||
3476354 | 3476354 | 2021-07-22 | Japan | Toyama | 2123 | 38 | 2017 | 68 | 36.637464 | 137.26934599999998 | 2021-07-23 04:21:29 | Toyama, Japan | ||
2371369 | 2371369 | 2021-07-20 | Colombia | San Andres y Providencia | 6598 | 133 | 6397 | 68 | 12.5567 | -81.7185 | 2021-07-21 04:21:40 | San Andres y Providencia, Colombia | ||
2673767 | 2673767 | 2021-07-18 | India | Lakshadweep | 10064 | 49 | 9947 | 68 | 13.6999972 | 72.18333259999999 | 2021-07-19 04:21:24 | Lakshadweep, India | ||
295822 | 295822 | 2021-07-15 | China | Hong Kong | 11955 | 212 | 11675 | 68 | 22.3 | 114.2 | 2021-07-16 04:21:22 | Hong Kong, China | ||
625701 | 625701 | 2021-07-10 | China | Shanghai | 2243 | 7 | 2168 | 68 | 31.202 | 121.4491 | 2021-07-11 04:21:43 | Shanghai, China | ||
829420 | 829420 | 2021-07-09 | China | Shanghai | 2243 | 7 | 2168 | 68 | 31.202 | 121.4491 | 2021-07-10 04:21:25 | Shanghai, China | ||
1440609 | 1440609 | 2021-07-07 | Japan | Nagasaki | 3219 | 69 | 3082 | 68 | 33.235712 | 129.608033 | 2021-07-08 04:21:26 | Nagasaki, Japan | ||
2693724 | 2693724 | 2021-07-06 | Japan | Shiga | 5580 | 90 | 5422 | 68 | 35.21582700000001 | 136.138064 | 2021-07-07 04:21:20 | Shiga, Japan | ||
1165239 | 1165239 | 2021-07-04 | Malta | 30652 | 420 | 30164 | 68 | 35.9375 | 14.3754 | 2021-07-05 04:21:28 | Malta | |||
2295465 | 2295465 | 2021-06-24 | Japan | Iwate | 1653 | 46 | 1539 | 68 | 39.593287 | 141.361777 | 2021-06-25 04:21:33 | Iwate, Japan | ||
2295464 | 2295464 | 2021-06-24 | Japan | Ishikawa | 3926 | 115 | 3743 | 68 | 36.769464 | 136.771027 | 2021-06-25 04:21:33 | Ishikawa, Japan | ||
563236 | 563236 | 2021-06-22 | Saint Lucia | 5227 | 84 | 5075 | 68 | 13.9094 | -60.9789 | 2021-06-23 04:21:46 | Saint Lucia | |||
563012 | 563012 | 2021-06-22 | Japan | Wakayama | 2663 | 49 | 2546 | 68 | 33.911879 | 135.505446 | 2021-06-23 04:21:46 | Wakayama, Japan | ||
562777 | 562777 | 2021-06-22 | China | Hong Kong | 11896 | 210 | 11618 | 68 | 22.3 | 114.2 | 2021-06-23 04:21:46 | Hong Kong, China | ||
3358714 | 3358714 | 2021-06-21 | Japan | Wakayama | 2660 | 48 | 2544 | 68 | 33.911879 | 135.505446 | 2021-06-22 04:21:34 | Wakayama, Japan | ||
3358492 | 3358492 | 2021-06-21 | China | Shanghai | 2184 | 7 | 2109 | 68 | 31.202 | 121.4491 | 2021-06-22 04:21:34 | Shanghai, China | ||
2884311 | 2884311 | 2021-06-20 | India | Dadra and Nagar Haveli and Daman and Diu | 10514 | 4 | 10442 | 68 | 20.194742 | 73.080901 | 2021-06-21 04:21:41 | Dadra and Nagar Haveli and Daman and Diu, India | ||
107459 | 107459 | 2021-06-19 | Japan | Gifu | 9175 | 183 | 8924 | 68 | 35.778671 | 137.055925 | 2021-06-20 04:21:48 | Gifu, Japan | ||
2910982 | 2910982 | 2021-06-17 | China | Hong Kong | 11881 | 210 | 11603 | 68 | 22.3 | 114.2 | 2021-06-18 04:22:16 | Hong Kong, China | ||
1564221 | 1564221 | 2021-06-14 | Netherlands | Sint Maarten | 2532 | 32 | 2432 | 68 | 18.0425 | -63.0548 | 2021-06-15 04:22:22 | Sint Maarten, Netherlands | ||
1563902 | 1563902 | 2021-06-14 | China | Hong Kong | 11878 | 210 | 11600 | 68 | 22.3 | 114.2 | 2021-06-15 04:22:22 | Hong Kong, China | ||
1736210 | 1736210 | 2021-06-12 | Australia | Victoria | 20660 | 820 | 19772 | 68 | -37.8136 | 144.9631 | 2021-06-13 04:22:44 | Victoria, Australia | ||
3970596 | 3970596 | 2021-06-11 | Japan | Yamagata | 2004 | 46 | 1890 | 68 | 38.448396 | 140.102154 | 2021-06-12 04:22:22 | Yamagata, Japan | ||
522928 | 522928 | 2021-06-09 | Malta | 30573 | 419 | 30086 | 68 | 35.9375 | 14.3754 | 2021-06-10 04:23:17 | Malta | |||
522680 | 522680 | 2021-06-09 | China | Shanghai | 2139 | 7 | 2064 | 68 | 31.202 | 121.4491 | 2021-06-10 04:23:17 | Shanghai, China | ||
2315557 | 2315557 | 2021-06-04 | Russia | Tyva Republic | 15979 | 203 | 15708 | 68 | 51.4017149 | 93.8582593 | 2021-06-05 04:23:03 | Tyva Republic, Russia | ||
1448434 | 1448434 | 2021-06-03 | Colombia | Guainia | 1818 | 22 | 1728 | 68 | 2.5854 | -68.5247 | 2021-06-04 04:23:37 | Guainia, Colombia | ||
3089493 | 3089493 | 2021-05-30 | Malta | 30533 | 419 | 30046 | 68 | 35.9375 | 14.3754 | 2021-05-31 03:08:59 | Malta | |||
3089269 | 3089269 | 2021-05-30 | Colombia | Guainia | 1754 | 22 | 1664 | 68 | 2.5854 | -68.5247 | 2021-05-31 03:08:59 | Guainia, Colombia | ||
1810425 | 1810425 | 2021-05-27 | Malaysia | Perlis | 465 | 4 | 393 | 68 | 6.4449 | 100.2048 | 2021-05-28 04:20:36 | Perlis, Malaysia | ||
1806642 | 1806642 | 2021-05-27 | France | New Caledonia | 126 | 0 | 58 | 68 | -20.904305 | 165.618042 | 2021-05-28 04:20:36 | New Caledonia, France | ||
1310066 | 1310066 | 2021-05-26 | France | New Caledonia | 126 | 0 | 58 | 68 | -20.904305 | 165.618042 | 2021-05-27 04:20:59 | New Caledonia, France | ||
82992 | 82992 | 2021-05-25 | France | New Caledonia | 126 | 0 | 58 | 68 | -20.904305 | 165.618042 | 2021-05-26 04:20:35 | New Caledonia, France | ||
1412954 | 1412954 | 2021-05-24 | France | New Caledonia | 126 | 0 | 58 | 68 | -20.904305 | 165.618042 | 2021-05-25 04:21:08 | New Caledonia, France | ||
726362 | 726362 | 2021-05-22 | Colombia | Vaupes | 1470 | 14 | 1388 | 68 | 0.8554 | -70.812 | 2021-05-23 04:20:51 | Vaupes, Colombia | ||
1952629 | 1952629 | 2021-05-21 | Netherlands | Aruba | 10902 | 106 | 10728 | 68 | 12.5211 | -69.9683 | 2021-05-22 04:20:45 | Aruba, Netherlands | ||
2390813 | 2390813 | 2021-05-18 | Japan | Tottori | 442 | 2 | 372 | 68 | 35.359069 | 133.863619 | 2021-05-19 04:20:42 | Tottori, Japan | ||
2939098 | 2939098 | 2021-05-16 | Canada | Nunavut | 624 | 4 | 552 | 68 | 70.2998 | -83.1076 | 2021-05-17 04:20:34 | Nunavut, Canada | ||
1082043 | 1082043 | 2021-05-14 | Netherlands | Curacao | 12246 | 119 | 12059 | 68 | 12.1696 | -68.99 | 2021-05-15 04:20:58 | Curacao, Netherlands | ||
2450595 | 2450595 | 2021-05-02 | China | Shanghai | 1996 | 7 | 1921 | 68 | 31.202 | 121.4491 | 2021-05-03 04:20:39 | Shanghai, China | ||
2824827 | 2824827 | 2021-05-01 | Japan | Tottori | 374 | 2 | 304 | 68 | 35.359069 | 133.863619 | 2021-05-02 04:20:48 | Tottori, Japan | ||
1636139 | 1636139 | 2021-04-29 | China | Shanghai | 1984 | 7 | 1909 | 68 | 31.202 | 121.4491 | 2021-04-30 04:21:03 | Shanghai, China | ||
888325 | 888325 | 2021-04-26 | Russia | Karachay-Cherkess Republic | 20009 | 73 | 19868 | 68 | 43.7368326 | 41.7267991 | 2021-04-27 04:20:52 | Karachay-Cherkess Republic, Russia | ||
1409067 | 1409067 | 2021-04-23 | Japan | Miyazaki | 2085 | 22 | 1995 | 68 | 32.193203999999994 | 131.299374 | 2021-04-24 04:20:38 | Miyazaki, Japan | ||
1568130 | 1568130 | 2021-04-22 | Japan | Miyazaki | 2076 | 22 | 1986 | 68 | 32.193203999999994 | 131.299374 | 2021-04-23 04:20:52 | Miyazaki, Japan | ||
2020494 | 2020494 | 2021-04-20 | Canada | Nova Scotia | 1831 | 67 | 1696 | 68 | 44.682 | -63.7443 | 2021-04-21 04:21:14 | Nova Scotia, Canada | ||
2411064 | 2411064 | 2021-04-19 | Russia | Magadan Oblast | 8297 | 99 | 8130 | 68 | 62.48858785 | 153.9903764 | 2021-04-20 04:20:41 | Magadan Oblast, Russia | ||
2571545 | 2571545 | 2021-04-13 | Comoros | 3796 | 146 | 3582 | 68 | -11.6455 | 43.3333 | 2021-04-14 04:20:41 | Comoros | |||
2983456 | 2983456 | 2021-04-10 | Russia | Jewish Autonomous Okrug | 4454 | 125 | 4261 | 68 | 48.57527615 | 132.66307460000002 | 2021-04-11 04:20:56 | Jewish Autonomous Okrug, Russia | ||
2247400 | 2247400 | 2021-04-07 | Japan | Fukui | 628 | 27 | 533 | 68 | 35.846614 | 136.22465400000002 | 2021-04-08 04:21:13 | Fukui, Japan | ||
3003135 | 3003135 | 2021-04-06 | China | Yunnan | 301 | 2 | 231 | 68 | 24.974 | 101.487 | 2021-04-07 04:20:53 | Yunnan, China | ||
3085499 | 3085499 | 2021-04-05 | Russia | Jewish Autonomous Okrug | 4444 | 125 | 4251 | 68 | 48.57527615 | 132.66307460000002 | 2021-04-06 04:20:32 | Jewish Autonomous Okrug, Russia | ||
3085442 | 3085442 | 2021-04-05 | Pakistan | Gilgit-Baltistan | 5061 | 103 | 4890 | 68 | 35.792146 | 74.982138 | 2021-04-06 04:20:32 | Gilgit-Baltistan, Pakistan | ||
388111 | 388111 | 2021-04-04 | Eswatini | 17352 | 668 | 16616 | 68 | -26.5225 | 31.4659 | 2021-04-05 04:20:35 | Eswatini | |||
241297 | 241297 | 2021-04-02 | Japan | Tottori | 275 | 2 | 205 | 68 | 35.359069 | 133.863619 | 2021-04-03 04:20:44 | Tottori, Japan | ||
1219628 | 1219628 | 2021-03-27 | Liberia | 2052 | 85 | 1899 | 68 | 6.4280550000000005 | -9.429499 | 2021-03-28 05:28:10 | Liberia | |||
1881046 | 1881046 | 2021-03-26 | Liberia | 2052 | 85 | 1899 | 68 | 6.4280550000000005 | -9.429499 | 2021-03-27 05:25:04 | Liberia | |||
1980676 | 1980676 | 2021-03-25 | Liberia | 2052 | 85 | 1899 | 68 | 6.4280550000000005 | -9.429499 | 2021-03-26 05:26:55 | Liberia | |||
2781039 | 2781039 | 2021-03-24 | Japan | Wakayama | 1220 | 18 | 1134 | 68 | 33.911879 | 135.505446 | 2021-03-25 05:27:00 | Wakayama, Japan | ||
1798865 | 1798865 | 2021-03-23 | Russia | Nenets Autonomous Okrug | 1071 | 4 | 999 | 68 | 68.27557185 | 57.1686375 | 2021-03-24 05:25:40 | Nenets Autonomous Okrug, Russia | ||
3372972 | 3372972 | 2021-03-21 | United Kingdom | Bermuda | 789 | 12 | 709 | 68 | 32.3078 | -64.7505 | 2021-03-22 05:25:43 | Bermuda, United Kingdom | ||
1580335 | 1580335 | 2021-03-13 | Russia | Altai Republic | 16426 | 183 | 16175 | 68 | 50.7114101 | 86.8572186 | 2021-03-14 05:25:37 | Altai Republic, Russia | ||
352329 | 352329 | 2021-03-11 | Japan | Port Quarantine | 2277 | 2 | 2207 | 68 | 2021-03-12 05:26:50 | Port Quarantine, Japan | ||||
3668250 | 3668250 | 2021-03-06 | US | Colorado | Mineral | 8079 | 73 | 1 | 0 | 68 | 37.66954283 | -106.9281698 | 2021-03-07 05:21:54 | Mineral, Colorado, US |
3668056 | 3668056 | 2021-03-06 | US | Alaska | Yakutat | 2282 | 69 | 1 | 0 | 68 | 59.8909808 | -140.36014509999998 | 2021-03-07 05:21:54 | Yakutat, Alaska, US |
1616871 | 1616871 | 2021-03-05 | US | Colorado | Mineral | 8079 | 73 | 1 | 0 | 68 | 37.66954283 | -106.9281698 | 2021-03-06 04:23:41 | Mineral, Colorado, US |
1616677 | 1616677 | 2021-03-05 | US | Alaska | Yakutat | 2282 | 69 | 1 | 0 | 68 | 59.8909808 | -140.36014509999998 | 2021-03-06 04:23:41 | Yakutat, Alaska, US |
2208088 | 2208088 | 2021-03-04 | US | Alaska | Yakutat | 2282 | 69 | 1 | 0 | 68 | 59.8909808 | -140.36014509999998 | 2021-03-05 05:26:29 | Yakutat, Alaska, US |
2207787 | 2207787 | 2021-03-04 | New Zealand | 2389 | 28 | 2295 | 68 | -40.9006 | 174.886 | 2021-03-05 05:26:29 | New Zealand | |||
1090509 | 1090509 | 2021-03-03 | US | Alaska | Yakutat | 2282 | 69 | 1 | 0 | 68 | 59.8909808 | -140.36014509999998 | 2021-03-04 05:24:24 | Yakutat, Alaska, US |
1090208 | 1090208 | 2021-03-03 | New Zealand | 2389 | 28 | 2295 | 68 | -40.9006 | 174.886 | 2021-03-04 05:24:24 | New Zealand | |||
3254581 | 3254581 | 2021-03-02 | US | Alaska | Yakutat | 2282 | 69 | 1 | 0 | 68 | 59.8909808 | -140.36014509999998 | 2021-03-03 05:23:28 | Yakutat, Alaska, US |
999044 | 999044 | 2021-03-01 | US | Colorado | Dolores | 8033 | 73 | 0 | 0 | 68 | 37.75208676 | -108.5211585 | 2021-03-02 05:23:30 | Dolores, Colorado, US |
2368102 | 2368102 | 2021-02-28 | US | Colorado | Dolores | 8033 | 73 | 0 | 0 | 68 | 37.75208676 | -108.5211585 | 2021-03-01 05:23:01 | Dolores, Colorado, US |
3066604 | 3066604 | 2021-02-27 | US | Colorado | Dolores | 8033 | 73 | 0 | 0 | 68 | 37.75208676 | -108.5211585 | 2021-02-28 05:22:20 | Dolores, Colorado, US |
3066117 | 3066117 | 2021-02-27 | Netherlands | Curacao | 4727 | 22 | 4637 | 68 | 12.1696 | -68.99 | 2021-02-28 05:22:20 | Curacao, Netherlands | ||
2184188 | 2184188 | 2021-02-26 | US | Colorado | Dolores | 8033 | 73 | 0 | 0 | 68 | 37.75208676 | -108.5211585 | 2021-02-27 05:22:28 | Dolores, Colorado, US |
1858610 | 1858610 | 2021-02-25 | US | Colorado | Dolores | 8033 | 73 | 0 | 0 | 68 | 37.75208676 | -108.5211585 | 2021-02-26 05:22:40 | Dolores, Colorado, US |
280788 | 280788 | 2021-02-24 | US | Colorado | Dolores | 8033 | 73 | 0 | 0 | 68 | 37.75208676 | -108.5211585 | 2021-02-25 05:24:57 | Dolores, Colorado, US |
1153166 | 1153166 | 2021-02-18 | Japan | Wakayama | 1156 | 17 | 1071 | 68 | 33.911879 | 135.505446 | 2021-02-19 05:24:16 | Wakayama, Japan | ||
3601454 | 3601454 | 2021-02-17 | US | Alaska | Denali | 2068 | 68 | 0 | 0 | 68 | 63.67264044 | -150.0076108 | 2021-02-18 05:22:58 | Denali, Alaska, US |
3050589 | 3050589 | 2021-02-16 | US | Alaska | Denali | 2068 | 68 | 0 | 0 | 68 | 63.67264044 | -150.0076108 | 2021-02-17 05:23:10 | Denali, Alaska, US |
1338688 | 1338688 | 2021-02-15 | US | Alaska | Denali | 2068 | 68 | 0 | 0 | 68 | 63.67264044 | -150.0076108 | 2021-02-16 05:24:38 | Denali, Alaska, US |
2283839 | 2283839 | 2021-02-14 | US | Alaska | Denali | 2068 | 68 | 0 | 0 | 68 | 63.67264044 | -150.0076108 | 2021-02-15 05:24:49 | Denali, Alaska, US |
2678239 | 2678239 | 2021-02-13 | US | Alaska | Denali | 2068 | 68 | 0 | 0 | 68 | 63.67264044 | -150.0076108 | 2021-02-14 05:23:43 | Denali, Alaska, US |
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]);