johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,237 rows where active = 58 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,921
- Japan 72
- Malaysia 27
- China 21
- United Kingdom 17
- Russia 15
- Colombia 14
- India 14
- Germany 9
- Canada 8
- Chile 8
- Ukraine 8
- Andorra 7
- Benin 7
- Liberia 7
- Italy 6
- Vietnam 6
- Australia 5
- France 5
- Netherlands 5
- New Zealand 5
- Taiwan* 5
- Belize 4
- Chad 4
- Iceland 4
- Mexico 3
- Barbados 2
- Burkina Faso 2
- Denmark 2
- Ethiopia 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
645625 | 645625 | 2021-09-07 | Malaysia | W.P. Labuan | 9842 | 148 | 9636 | 58 | 5.2831 | 115.2308 | 2021-09-08 04:21:31 | W.P. Labuan, Malaysia | ||
2926880 | 2926880 | 2021-08-27 | Malaysia | W.P. Labuan | 9798 | 148 | 9592 | 58 | 5.2831 | 115.2308 | 2021-08-28 04:21:28 | W.P. Labuan, Malaysia | ||
36103 | 36103 | 2021-08-25 | Malaysia | W.P. Labuan | 9787 | 148 | 9581 | 58 | 5.2831 | 115.2308 | 2021-08-26 04:21:28 | W.P. Labuan, Malaysia | ||
2179240 | 2179240 | 2021-08-22 | Malaysia | W.P. Labuan | 9772 | 148 | 9566 | 58 | 5.2831 | 115.2308 | 2021-08-23 04:21:27 | W.P. Labuan, Malaysia | ||
3559336 | 3559336 | 2021-08-21 | Malaysia | W.P. Labuan | 9768 | 148 | 9562 | 58 | 5.2831 | 115.2308 | 2021-08-22 04:21:29 | W.P. Labuan, Malaysia | ||
331792 | 331792 | 2021-08-04 | Eritrea | 6568 | 35 | 6475 | 58 | 15.1794 | 39.7823 | 2021-08-05 04:21:51 | Eritrea | |||
3468185 | 3468185 | 2021-08-03 | Japan | Gifu | 9687 | 188 | 9441 | 58 | 35.778671 | 137.055925 | 2021-08-04 04:21:25 | Gifu, Japan | ||
3467955 | 3467955 | 2021-08-03 | Canada | Yukon | 610 | 8 | 544 | 58 | 64.2823 | -135.0 | 2021-08-04 04:21:25 | Yukon, Canada | ||
3015347 | 3015347 | 2021-08-01 | Italy | Valle d'Aosta | 11769 | 473 | 11238 | 58 | 45.73750286 | 7.320149366 | 2021-08-02 04:21:36 | Valle d'Aosta, Italy | ||
3903831 | 3903831 | 2021-07-31 | Colombia | San Andres y Providencia | 6730 | 133 | 6539 | 58 | 12.5567 | -81.7185 | 2021-08-01 04:21:50 | San Andres y Providencia, Colombia | ||
408084 | 408084 | 2021-07-28 | Chile | Magallanes | 29120 | 481 | 28581 | 58 | -52.368 | -70.9863 | 2021-07-29 04:21:33 | Magallanes, Chile | ||
3218327 | 3218327 | 2021-07-26 | Japan | Oita | 3570 | 64 | 3448 | 58 | 33.200697 | 131.43323999999998 | 2021-07-27 04:21:18 | Oita, Japan | ||
1378531 | 1378531 | 2021-07-25 | Japan | Miyazaki | 3158 | 27 | 3073 | 58 | 32.193203999999994 | 131.299374 | 2021-07-26 04:21:28 | Miyazaki, Japan | ||
1330382 | 1330382 | 2021-07-24 | New Zealand | 2862 | 28 | 2778 | 58 | -40.9006 | 174.886 | 2021-07-25 04:22:12 | New Zealand | |||
1330269 | 1330269 | 2021-07-24 | Japan | Mie | 5561 | 113 | 5390 | 58 | 34.508018 | 136.376013 | 2021-07-25 04:22:12 | Mie, Japan | ||
3137591 | 3137591 | 2021-07-23 | Japan | Tokushima | 1729 | 63 | 1608 | 58 | 33.919178 | 134.242091 | 2021-07-24 00:21:36 | Tokushima, Japan | ||
3137555 | 3137555 | 2021-07-23 | Japan | Ehime | 2817 | 76 | 2683 | 58 | 33.624835 | 132.856842 | 2021-07-24 00:21:36 | Ehime, Japan | ||
3137374 | 3137374 | 2021-07-23 | China | Shanghai | 2283 | 7 | 2218 | 58 | 31.202 | 121.4491 | 2021-07-24 00:21:36 | Shanghai, China | ||
3476359 | 3476359 | 2021-07-22 | Japan | Yamanashi | 2218 | 21 | 2139 | 58 | 35.612364 | 138.61148899999998 | 2021-07-23 04:21:29 | Yamanashi, Japan | ||
3331353 | 3331353 | 2021-07-21 | China | Shanghai | 2278 | 7 | 2213 | 58 | 31.202 | 121.4491 | 2021-07-22 04:21:19 | Shanghai, China | ||
3331333 | 3331333 | 2021-07-21 | China | Guangdong | 2820 | 8 | 2754 | 58 | 23.3417 | 113.4244 | 2021-07-22 04:21:19 | Guangdong, China | ||
3331320 | 3331320 | 2021-07-21 | Chile | Magallanes | 29090 | 473 | 28559 | 58 | -52.368 | -70.9863 | 2021-07-22 04:21:19 | Magallanes, Chile | ||
2673861 | 2673861 | 2021-07-18 | Japan | Yamanashi | 2187 | 21 | 2108 | 58 | 35.612364 | 138.61148899999998 | 2021-07-19 04:21:24 | Yamanashi, Japan | ||
2947626 | 2947626 | 2021-07-16 | Saint Vincent and the Grenadines | 2258 | 12 | 2188 | 58 | 12.9843 | -61.2872 | 2021-07-17 04:22:22 | Saint Vincent and the Grenadines | |||
2947297 | 2947297 | 2021-07-16 | India | Chandigarh | 61862 | 809 | 60995 | 58 | 30.733839 | 76.76827800000002 | 2021-07-17 04:22:22 | Chandigarh, India | ||
296060 | 296060 | 2021-07-15 | Japan | Yamanashi | 2176 | 21 | 2097 | 58 | 35.612364 | 138.61148899999998 | 2021-07-16 04:21:22 | Yamanashi, Japan | ||
578752 | 578752 | 2021-07-13 | Germany | Sachsen-Anhalt | 99287 | 3430 | 95850 | 58 | 51.9503 | 11.6923 | 2021-07-14 04:21:35 | Sachsen-Anhalt, Germany | ||
829598 | 829598 | 2021-07-09 | Japan | Akita | 931 | 20 | 853 | 58 | 39.748679 | 140.408228 | 2021-07-10 04:21:25 | Akita, Japan | ||
1440571 | 1440571 | 2021-07-07 | Italy | Molise | 13728 | 492 | 13178 | 58 | 41.55774754 | 14.65916051 | 2021-07-08 04:21:26 | Molise, Italy | ||
1165215 | 1165215 | 2021-07-04 | Japan | Yamaguchi | 3159 | 80 | 3021 | 58 | 34.201190000000004 | 131.573293 | 2021-07-05 04:21:28 | Yamaguchi, Japan | ||
1495432 | 1495432 | 2021-07-03 | China | Yunnan | 427 | 2 | 367 | 58 | 24.974 | 101.487 | 2021-07-04 04:21:38 | Yunnan, China | ||
1893337 | 1893337 | 2021-06-30 | Russia | Chukotka Autonomous Okrug | 820 | 8 | 754 | 58 | 66.0006475 | 169.4900869 | 2021-07-01 04:21:19 | Chukotka Autonomous Okrug, Russia | ||
1892839 | 1892839 | 2021-06-30 | Australia | Queensland | 1700 | 7 | 1635 | 58 | -27.4698 | 153.0251 | 2021-07-01 04:21:19 | Queensland, Australia | ||
400273 | 400273 | 2021-06-29 | Japan | Gunma | 8032 | 152 | 7822 | 58 | 36.504479 | 138.985605 | 2021-06-30 04:21:41 | Gunma, Japan | ||
3125550 | 3125550 | 2021-06-28 | Japan | Toyama | 2037 | 38 | 1941 | 58 | 36.637464 | 137.26934599999998 | 2021-06-29 04:21:28 | Toyama, Japan | ||
3125197 | 3125197 | 2021-06-28 | Andorra | 13882 | 127 | 13697 | 58 | 42.5063 | 1.5218 | 2021-06-29 04:21:28 | Andorra | |||
2590029 | 2590029 | 2021-06-27 | Japan | Nara | 8151 | 129 | 7964 | 58 | 34.317451 | 135.871644 | 2021-06-28 04:21:29 | Nara, Japan | ||
2590017 | 2590017 | 2021-06-27 | Japan | Iwate | 1667 | 46 | 1563 | 58 | 39.593287 | 141.361777 | 2021-06-28 04:21:29 | Iwate, Japan | ||
2589773 | 2589773 | 2021-06-27 | Canada | Nova Scotia | 5828 | 92 | 5678 | 58 | 44.682 | -63.7443 | 2021-06-28 04:21:29 | Nova Scotia, Canada | ||
2589692 | 2589692 | 2021-06-27 | Andorra | 13882 | 127 | 13697 | 58 | 42.5063 | 1.5218 | 2021-06-28 04:21:29 | Andorra | |||
3958196 | 3958196 | 2021-06-26 | Andorra | 13882 | 127 | 13697 | 58 | 42.5063 | 1.5218 | 2021-06-27 04:21:39 | Andorra | |||
1712015 | 1712015 | 2021-06-25 | Andorra | 13882 | 127 | 13697 | 58 | 42.5063 | 1.5218 | 2021-06-26 04:21:43 | Andorra | |||
2295273 | 2295273 | 2021-06-24 | China | Shanghai | 2196 | 7 | 2131 | 58 | 31.202 | 121.4491 | 2021-06-25 04:21:33 | Shanghai, China | ||
2422580 | 2422580 | 2021-06-23 | Andorra | 13873 | 127 | 13688 | 58 | 42.5063 | 1.5218 | 2021-06-24 04:21:55 | Andorra | |||
562881 | 562881 | 2021-06-22 | Germany | Mecklenburg-Vorpommern | 44103 | 1148 | 42910 | 58 | 53.6127 | 12.4296 | 2021-06-23 04:21:46 | Mecklenburg-Vorpommern, Germany | ||
3358392 | 3358392 | 2021-06-21 | Benin | 8140 | 103 | 7979 | 58 | 9.3077 | 2.3158 | 2021-06-22 04:21:34 | Benin | |||
2884091 | 2884091 | 2021-06-20 | Benin | 8140 | 103 | 7979 | 58 | 9.3077 | 2.3158 | 2021-06-21 04:21:41 | Benin | |||
107174 | 107174 | 2021-06-19 | Benin | 8140 | 103 | 7979 | 58 | 9.3077 | 2.3158 | 2021-06-20 04:21:48 | Benin | |||
1125317 | 1125317 | 2021-06-18 | Benin | 8140 | 103 | 7979 | 58 | 9.3077 | 2.3158 | 2021-06-19 04:22:33 | Benin | |||
2910895 | 2910895 | 2021-06-17 | Benin | 8140 | 103 | 7979 | 58 | 9.3077 | 2.3158 | 2021-06-18 04:22:16 | Benin | |||
3030013 | 3030013 | 2021-06-16 | Benin | 8140 | 103 | 7979 | 58 | 9.3077 | 2.3158 | 2021-06-17 04:22:36 | Benin | |||
2339412 | 2339412 | 2021-06-15 | Japan | Kagawa | 2073 | 28 | 1987 | 58 | 34.217292 | 133.969047 | 2021-06-16 04:22:32 | Kagawa, Japan | ||
2339119 | 2339119 | 2021-06-15 | Benin | 8140 | 103 | 7979 | 58 | 9.3077 | 2.3158 | 2021-06-16 04:22:32 | Benin | |||
1564138 | 1564138 | 2021-06-14 | Japan | Yamagata | 2011 | 46 | 1907 | 58 | 38.448396 | 140.102154 | 2021-06-15 04:22:22 | Yamagata, Japan | ||
3970319 | 3970319 | 2021-06-11 | Canada | Newfoundland and Labrador | 1368 | 7 | 1303 | 58 | 53.1355 | -57.6604 | 2021-06-12 04:22:22 | Newfoundland and Labrador, Canada | ||
3475977 | 3475977 | 2021-06-08 | Malaysia | Perlis | 539 | 5 | 476 | 58 | 6.4449 | 100.2048 | 2021-06-09 04:23:31 | Perlis, Malaysia | ||
3089423 | 3089423 | 2021-05-30 | Japan | Akita | 755 | 12 | 685 | 58 | 39.748679 | 140.408228 | 2021-05-31 03:08:59 | Akita, Japan | ||
20305 | 20305 | 2021-05-28 | Iceland | 6564 | 30 | 6476 | 58 | 64.9631 | -19.0208 | 2021-05-29 04:20:41 | Iceland | |||
1806680 | 1806680 | 2021-05-27 | Iceland | 6564 | 30 | 6476 | 58 | 64.9631 | -19.0208 | 2021-05-28 04:20:36 | Iceland | |||
1771385 | 1771385 | 2021-05-23 | Japan | Tottori | 455 | 2 | 395 | 58 | 35.359069 | 133.863619 | 2021-05-24 04:20:53 | Tottori, Japan | ||
1916899 | 1916899 | 2021-05-20 | Malaysia | W.P. Labuan | 2553 | 13 | 2482 | 58 | 5.2831 | 115.2308 | 2021-05-21 04:20:43 | W.P. Labuan, Malaysia | ||
2390706 | 2390706 | 2021-05-18 | Iceland | 6549 | 29 | 6462 | 58 | 64.9631 | -19.0208 | 2021-05-19 04:20:42 | Iceland | |||
1081944 | 1081944 | 2021-05-14 | Japan | Kochi | 1144 | 20 | 1066 | 58 | 33.422519 | 133.367307 | 2021-05-15 04:20:58 | Kochi, Japan | ||
2004484 | 2004484 | 2021-05-12 | China | Shanghai | 2025 | 7 | 1960 | 58 | 31.202 | 121.4491 | 2021-05-13 04:20:51 | Shanghai, China | ||
2820813 | 2820813 | 2021-05-10 | Japan | Tottori | 403 | 2 | 343 | 58 | 35.359069 | 133.863619 | 2021-05-11 04:20:41 | Tottori, Japan | ||
1425286 | 1425286 | 2021-05-09 | Russia | Altai Republic | 16837 | 240 | 16539 | 58 | 50.7114101 | 86.8572186 | 2021-05-10 04:20:38 | Altai Republic, Russia | ||
1551794 | 1551794 | 2021-05-08 | China | Shanghai | 2012 | 7 | 1947 | 58 | 31.202 | 121.4491 | 2021-05-09 04:20:35 | Shanghai, China | ||
2760722 | 2760722 | 2021-05-03 | China | Guangdong | 2358 | 8 | 2292 | 58 | 23.3417 | 113.4244 | 2021-05-04 04:20:34 | Guangdong, China | ||
1636645 | 1636645 | 2021-04-29 | Taiwan* | 1121 | 12 | 1051 | 58 | 23.7 | 121.0 | 2021-04-30 04:21:03 | Taiwan* | |||
3397039 | 3397039 | 2021-04-28 | United Kingdom | Anguilla | 87 | 0 | 29 | 58 | 18.2206 | -63.0686 | 2021-04-29 04:20:55 | Anguilla, United Kingdom | ||
3702331 | 3702331 | 2021-04-27 | Russia | Magadan Oblast | 8322 | 99 | 8165 | 58 | 62.48858785 | 153.9903764 | 2021-04-28 04:20:32 | Magadan Oblast, Russia | ||
888319 | 888319 | 2021-04-26 | Russia | Jewish Autonomous Okrug | 4467 | 127 | 4282 | 58 | 48.57527615 | 132.66307460000002 | 2021-04-27 04:20:52 | Jewish Autonomous Okrug, Russia | ||
3924217 | 3924217 | 2021-04-24 | Russia | Karachay-Cherkess Republic | 19982 | 73 | 19851 | 58 | 43.7368326 | 41.7267991 | 2021-04-25 04:20:32 | Karachay-Cherkess Republic, Russia | ||
3923844 | 3923844 | 2021-04-24 | Colombia | Amazonas | 6101 | 235 | 5808 | 58 | -1.4429 | -71.5724 | 2021-04-25 04:20:32 | Amazonas, Colombia | ||
3923720 | 3923720 | 2021-04-24 | Barbados | 3820 | 44 | 3718 | 58 | 13.1939 | -59.5432 | 2021-04-25 04:20:32 | Barbados | |||
1408873 | 1408873 | 2021-04-23 | China | Yunnan | 338 | 2 | 278 | 58 | 24.974 | 101.487 | 2021-04-24 04:20:38 | Yunnan, China | ||
1408751 | 1408751 | 2021-04-23 | Barbados | 3820 | 44 | 3718 | 58 | 13.1939 | -59.5432 | 2021-04-24 04:20:38 | Barbados | |||
1568123 | 1568123 | 2021-04-22 | Japan | Kagoshima | 1992 | 28 | 1906 | 58 | 31.009484000000004 | 130.430665 | 2021-04-23 04:20:52 | Kagoshima, Japan | ||
3242344 | 3242344 | 2021-04-21 | Japan | Kagoshima | 1985 | 28 | 1899 | 58 | 31.009484000000004 | 130.430665 | 2021-04-22 04:20:53 | Kagoshima, Japan | ||
3242150 | 3242150 | 2021-04-21 | China | Shanghai | 1950 | 7 | 1885 | 58 | 31.202 | 121.4491 | 2021-04-22 04:20:53 | Shanghai, China | ||
3129536 | 3129536 | 2021-04-18 | Japan | Iwate | 779 | 31 | 690 | 58 | 39.593287 | 141.361777 | 2021-04-19 04:20:57 | Iwate, Japan | ||
3129522 | 3129522 | 2021-04-18 | Japan | Akita | 367 | 9 | 300 | 58 | 39.748679 | 140.408228 | 2021-04-19 04:20:57 | Akita, Japan | ||
2548922 | 2548922 | 2021-04-15 | Japan | Yamaguchi | 1485 | 43 | 1384 | 58 | 34.201190000000004 | 131.573293 | 2021-04-16 04:20:46 | Yamaguchi, Japan | ||
2548892 | 2548892 | 2021-04-15 | Japan | Kagoshima | 1943 | 28 | 1857 | 58 | 31.009484000000004 | 130.430665 | 2021-04-16 04:20:46 | Kagoshima, Japan | ||
1845602 | 1845602 | 2021-04-14 | United Kingdom | Turks and Caicos Islands | 2360 | 17 | 2285 | 58 | 21.694000000000006 | -71.7979 | 2021-04-15 04:20:54 | Turks and Caicos Islands, United Kingdom | ||
2575336 | 2575336 | 2021-04-13 | United Kingdom | Turks and Caicos Islands | 2360 | 17 | 2285 | 58 | 21.694000000000006 | -71.7979 | 2021-04-14 04:20:41 | Turks and Caicos Islands, United Kingdom | ||
2571401 | 2571401 | 2021-04-13 | Belize | 12513 | 318 | 12137 | 58 | 17.1899 | -88.4976 | 2021-04-14 04:20:41 | Belize | |||
40045 | 40045 | 2021-04-12 | Uganda | 41174 | 337 | 40779 | 58 | 1.373333 | 32.290275 | 2021-04-13 04:20:37 | Uganda | |||
2645707 | 2645707 | 2021-04-08 | India | Lakshadweep | 778 | 1 | 719 | 58 | 13.6999972 | 72.18333259999999 | 2021-04-09 04:21:13 | Lakshadweep, India | ||
1219525 | 1219525 | 2021-03-27 | India | Manipur | 29376 | 374 | 28944 | 58 | 24.738975 | 93.882541 | 2021-03-28 05:28:10 | Manipur, India | ||
1798699 | 1798699 | 2021-03-23 | Liberia | 2042 | 85 | 1899 | 58 | 6.4280550000000005 | -9.429499 | 2021-03-24 05:25:40 | Liberia | |||
1798536 | 1798536 | 2021-03-23 | France | New Caledonia | 116 | 0 | 58 | 58 | -20.904305 | 165.618042 | 2021-03-24 05:25:40 | New Caledonia, France | ||
1798471 | 1798471 | 2021-03-23 | Colombia | Amazonas | 5760 | 211 | 5491 | 58 | -1.4429 | -71.5724 | 2021-03-24 05:25:40 | Amazonas, Colombia | ||
1203867 | 1203867 | 2021-03-22 | Liberia | 2042 | 85 | 1899 | 58 | 6.4280550000000005 | -9.429499 | 2021-03-23 05:26:18 | Liberia | |||
1203704 | 1203704 | 2021-03-22 | France | New Caledonia | 116 | 0 | 58 | 58 | -20.904305 | 165.618042 | 2021-03-23 05:26:18 | New Caledonia, France | ||
1203639 | 1203639 | 2021-03-22 | Colombia | Amazonas | 5753 | 210 | 5485 | 58 | -1.4429 | -71.5724 | 2021-03-23 05:26:18 | Amazonas, Colombia | ||
3369389 | 3369389 | 2021-03-21 | Liberia | 2042 | 85 | 1899 | 58 | 6.4280550000000005 | -9.429499 | 2021-03-22 05:25:43 | Liberia | |||
3369226 | 3369226 | 2021-03-21 | France | New Caledonia | 116 | 0 | 58 | 58 | -20.904305 | 165.618042 | 2021-03-22 05:25:43 | New Caledonia, France | ||
3369051 | 3369051 | 2021-03-21 | Belize | 12400 | 316 | 12026 | 58 | 17.1899 | -88.4976 | 2021-03-22 05:25:43 | Belize | |||
1744672 | 1744672 | 2021-03-20 | New Zealand | 2453 | 28 | 2369 | 58 | -40.9006 | 174.886 | 2021-03-21 05:25:44 | New Zealand |
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]);