johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,497 rows where active = 91 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,273
- Japan 48
- Russia 13
- United Kingdom 12
- Germany 11
- India 11
- Colombia 10
- Malaysia 10
- Ukraine 10
- France 8
- Canada 7
- Chile 5
- Italy 5
- Mexico 5
- China 4
- Gambia 4
- Liberia 4
- Pakistan 4
- Summer Olympics 2020 4
- Vietnam 4
- Yemen 4
- Australia 3
- Barbados 3
- Burundi 3
- Denmark 2
- Estonia 2
- Iceland 2
- Saint Lucia 2
- Thailand 2
- Bhutan 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331903 | 331903 | 2021-08-04 | Italy | Valle d'Aosta | 11808 | 473 | 11244 | 91 | 45.73750286 | 7.320149366 | 2021-08-05 04:21:51 | Valle d'Aosta, Italy | ||
408298 | 408298 | 2021-07-28 | Japan | Ehime | 2876 | 77 | 2708 | 91 | 33.624835 | 132.856842 | 2021-07-29 04:21:33 | Ehime, Japan | ||
1378815 | 1378815 | 2021-07-25 | Summer Olympics 2020 | 91 | 0 | 0 | 91 | 35.6491 | 139.7737 | 2021-07-26 04:21:28 | Summer Olympics 2020 | |||
1330555 | 1330555 | 2021-07-24 | Summer Olympics 2020 | 91 | 0 | 0 | 91 | 35.6491 | 139.7737 | 2021-07-25 04:22:12 | Summer Olympics 2020 | |||
1330284 | 1330284 | 2021-07-24 | Japan | Shimane | 662 | 2 | 569 | 91 | 35.07076 | 132.55406399999998 | 2021-07-25 04:22:12 | Shimane, Japan | ||
1330273 | 1330273 | 2021-07-24 | Japan | Nagasaki | 3321 | 69 | 3161 | 91 | 33.235712 | 129.608033 | 2021-07-25 04:22:12 | Nagasaki, Japan | ||
3137859 | 3137859 | 2021-07-23 | Summer Olympics 2020 | 91 | 0 | 0 | 91 | 35.6491 | 139.7737 | 2021-07-24 00:21:36 | Summer Olympics 2020 | |||
3479933 | 3479933 | 2021-07-22 | Ukraine | Chernivtsi Oblast | 80069 | 1796 | 78182 | 91 | 48.2917 | 25.9352 | 2021-07-23 04:21:29 | Chernivtsi Oblast, Ukraine | ||
3476619 | 3476619 | 2021-07-22 | Summer Olympics 2020 | 91 | 0 | 0 | 91 | 35.6491 | 139.7737 | 2021-07-23 04:21:29 | Summer Olympics 2020 | |||
3331483 | 3331483 | 2021-07-21 | India | Ladakh | 20282 | 206 | 19985 | 91 | 34.1526 | 77.5771 | 2021-07-22 04:21:19 | Ladakh, India | ||
3331405 | 3331405 | 2021-07-21 | Denmark | Faroe Islands | 949 | 1 | 857 | 91 | 61.8926 | -6.9118 | 2021-07-22 04:21:19 | Faroe Islands, Denmark | ||
3331378 | 3331378 | 2021-07-21 | Colombia | Guaviare | 4943 | 87 | 4765 | 91 | 1.0654 | -73.2603 | 2021-07-22 04:21:19 | Guaviare, Colombia | ||
2673598 | 2673598 | 2021-07-18 | Chile | Aysen | 8022 | 68 | 7863 | 91 | -45.9864 | -73.7669 | 2021-07-19 04:21:24 | Aysen, Chile | ||
3631665 | 3631665 | 2021-07-14 | Barbados | 4213 | 48 | 4074 | 91 | 13.1939 | -59.5432 | 2021-07-15 04:21:48 | Barbados | |||
2697314 | 2697314 | 2021-07-06 | Ukraine | Ivano-Frankivsk Oblast | 86701 | 2101 | 84509 | 91 | 48.9226 | 24.7111 | 2021-07-07 04:21:20 | Ivano-Frankivsk Oblast, Ukraine | ||
1165194 | 1165194 | 2021-07-04 | Japan | Nagasaki | 3216 | 69 | 3056 | 91 | 33.235712 | 129.608033 | 2021-07-05 04:21:28 | Nagasaki, Japan | ||
1499252 | 1499252 | 2021-07-03 | United Kingdom | British Virgin Islands | 392 | 1 | 300 | 91 | 18.4207 | -64.64 | 2021-07-04 04:21:38 | British Virgin Islands, United Kingdom | ||
2075567 | 2075567 | 2021-07-02 | United Kingdom | British Virgin Islands | 392 | 1 | 300 | 91 | 18.4207 | -64.64 | 2021-07-03 04:21:37 | British Virgin Islands, United Kingdom | ||
2764844 | 2764844 | 2021-07-01 | Germany | Bremen | 27449 | 486 | 26880 | 91 | 53.0793 | 8.8017 | 2021-07-02 04:21:47 | Bremen, Germany | ||
1893410 | 1893410 | 2021-06-30 | Saint Lucia | 5296 | 84 | 5121 | 91 | 13.9094 | -60.9789 | 2021-07-01 04:21:19 | Saint Lucia | |||
562993 | 562993 | 2021-06-22 | Japan | Nagasaki | 3117 | 69 | 2957 | 91 | 33.235712 | 129.608033 | 2021-06-23 04:21:46 | Nagasaki, Japan | ||
107460 | 107460 | 2021-06-19 | Japan | Gunma | 7999 | 149 | 7759 | 91 | 36.504479 | 138.985605 | 2021-06-20 04:21:48 | Gunma, Japan | ||
1125796 | 1125796 | 2021-06-18 | Russia | Jewish Autonomous Okrug | 4585 | 146 | 4348 | 91 | 48.57527615 | 132.66307460000002 | 2021-06-19 04:22:33 | Jewish Autonomous Okrug, Russia | ||
1125602 | 1125602 | 2021-06-18 | Japan | Gifu | 9158 | 183 | 8884 | 91 | 35.778671 | 137.055925 | 2021-06-19 04:22:33 | Gifu, Japan | ||
1563860 | 1563860 | 2021-06-14 | Canada | New Brunswick | 2299 | 45 | 2163 | 91 | 46.5653 | -66.4619 | 2021-06-15 04:22:22 | New Brunswick, Canada | ||
522793 | 522793 | 2021-06-09 | India | Andaman and Nicobar Islands | 7168 | 125 | 6952 | 91 | 11.225999 | 92.968178 | 2021-06-10 04:23:17 | Andaman and Nicobar Islands, India | ||
3145282 | 3145282 | 2021-06-07 | Australia | Victoria | 20649 | 820 | 19738 | 91 | -37.8136 | 144.9631 | 2021-06-08 04:22:35 | Victoria, Australia | ||
2585923 | 2585923 | 2021-06-05 | Iceland | 6597 | 30 | 6476 | 91 | 64.9631 | -19.0208 | 2021-06-06 04:24:03 | Iceland | |||
2104162 | 2104162 | 2021-06-01 | Japan | Port Quarantine | 2967 | 3 | 2873 | 91 | 2021-06-02 04:24:34 | Port Quarantine, Japan | ||||
1771112 | 1771112 | 2021-05-23 | Canada | Newfoundland and Labrador | 1253 | 6 | 1156 | 91 | 53.1355 | -57.6604 | 2021-05-24 04:20:53 | Newfoundland and Labrador, Canada | ||
1913249 | 1913249 | 2021-05-20 | Japan | Shimane | 482 | 0 | 391 | 91 | 35.07076 | 132.55406399999998 | 2021-05-21 04:20:43 | Shimane, Japan | ||
2939231 | 2939231 | 2021-05-16 | Gambia | 5940 | 175 | 5674 | 91 | 13.4432 | -15.3101 | 2021-05-17 04:20:34 | Gambia | |||
1872861 | 1872861 | 2021-05-15 | Gambia | 5940 | 175 | 5674 | 91 | 13.4432 | -15.3101 | 2021-05-16 04:20:49 | Gambia | |||
1081830 | 1081830 | 2021-05-14 | Gambia | 5940 | 175 | 5674 | 91 | 13.4432 | -15.3101 | 2021-05-15 04:20:58 | Gambia | |||
2505717 | 2505717 | 2021-05-07 | Malaysia | W.P. Putrajaya | 1427 | 9 | 1327 | 91 | 2.9264 | 101.6964 | 2021-05-08 04:21:04 | W.P. Putrajaya, Malaysia | ||
1412728 | 1412728 | 2021-04-23 | Malaysia | Terengganu | 3954 | 14 | 3849 | 91 | 5.3117 | 103.1324 | 2021-04-24 04:20:38 | Terengganu, Malaysia | ||
983132 | 983132 | 2021-04-17 | Russia | Altai Republic | 16764 | 215 | 16458 | 91 | 50.7114101 | 86.8572186 | 2021-04-18 04:20:41 | Altai Republic, Russia | ||
170049 | 170049 | 2021-04-16 | Japan | Fukui | 703 | 29 | 583 | 91 | 35.846614 | 136.22465400000002 | 2021-04-17 04:20:40 | Fukui, Japan | ||
36260 | 36260 | 2021-04-12 | China | Yunnan | 324 | 2 | 231 | 91 | 24.974 | 101.487 | 2021-04-13 04:20:37 | Yunnan, China | ||
2986872 | 2986872 | 2021-04-10 | Uganda | 41113 | 337 | 40685 | 91 | 1.373333 | 32.290275 | 2021-04-11 04:20:56 | Uganda | |||
605646 | 605646 | 2021-04-09 | India | Manipur | 29475 | 375 | 29009 | 91 | 24.738975 | 93.882541 | 2021-04-10 04:20:59 | Manipur, India | ||
2247103 | 2247103 | 2021-04-07 | Barbados | 3691 | 43 | 3557 | 91 | 13.1939 | -59.5432 | 2021-04-08 04:21:13 | Barbados | |||
3003013 | 3003013 | 2021-04-06 | Barbados | 3691 | 43 | 3557 | 91 | 13.1939 | -59.5432 | 2021-04-07 04:20:53 | Barbados | |||
388057 | 388057 | 2021-04-04 | Colombia | Arauca | 5784 | 173 | 5520 | 91 | 7.0762 | -70.7105 | 2021-04-05 04:20:35 | Arauca, Colombia | ||
1535973 | 1535973 | 2021-03-28 | Japan | Wakayama | 1248 | 18 | 1139 | 91 | 33.911879 | 135.505446 | 2021-03-29 04:28:35 | Wakayama, Japan | ||
1980314 | 1980314 | 2021-03-25 | Australia | Queensland | 1436 | 6 | 1339 | 91 | -27.4698 | 153.0251 | 2021-03-26 05:26:55 | Queensland, Australia | ||
1744572 | 1744572 | 2021-03-20 | Japan | Port Quarantine | 2329 | 2 | 2236 | 91 | 2021-03-21 05:25:44 | Port Quarantine, Japan | ||||
3620925 | 3620925 | 2021-03-17 | Colombia | Choco | 6619 | 204 | 6324 | 91 | 5.2528 | -76.82600000000002 | 2021-03-18 05:26:22 | Choco, Colombia | ||
702588 | 702588 | 2021-03-16 | Russia | Altai Republic | 16469 | 187 | 16191 | 91 | 50.7114101 | 86.8572186 | 2021-03-17 05:25:07 | Altai Republic, Russia | ||
1579986 | 1579986 | 2021-03-13 | Colombia | Arauca | 5642 | 172 | 5379 | 91 | 7.0762 | -70.7105 | 2021-03-14 05:25:37 | Arauca, Colombia | ||
2359299 | 2359299 | 2021-03-08 | Colombia | Amazonas | 5411 | 193 | 5127 | 91 | -1.4429 | -71.5724 | 2021-03-09 05:28:19 | Amazonas, Colombia | ||
55031 | 55031 | 2021-03-07 | Russia | Nenets Autonomous Okrug | 1045 | 3 | 951 | 91 | 68.27557185 | 57.1686375 | 2021-03-08 05:24:48 | Nenets Autonomous Okrug, Russia | ||
54574 | 54574 | 2021-03-07 | Canada | Newfoundland and Labrador | 1006 | 6 | 909 | 91 | 53.1355 | -57.6604 | 2021-03-08 05:24:48 | Newfoundland and Labrador, Canada | ||
3667391 | 3667391 | 2021-03-06 | Canada | Newfoundland and Labrador | 1005 | 6 | 908 | 91 | 53.1355 | -57.6604 | 2021-03-07 05:21:54 | Newfoundland and Labrador, Canada | ||
1093421 | 1093421 | 2021-03-03 | US | Virginia | Highland | 51091 | 92 | 1 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-03-04 05:24:24 | Highland, Virginia, US |
3257493 | 3257493 | 2021-03-02 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-03-03 05:23:28 | Highland, Virginia, US |
3254175 | 3254175 | 2021-03-02 | Japan | Niigata | 1091 | 15 | 985 | 91 | 37.521819 | 138.918647 | 2021-03-03 05:23:28 | Niigata, Japan | ||
1001785 | 1001785 | 2021-03-01 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-03-02 05:23:30 | Highland, Virginia, US |
2370843 | 2370843 | 2021-02-28 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-03-01 05:23:01 | Highland, Virginia, US |
2367696 | 2367696 | 2021-02-28 | Russia | Jewish Autonomous Okrug | 4322 | 119 | 4112 | 91 | 48.57527615 | 132.66307460000002 | 2021-03-01 05:23:01 | Jewish Autonomous Okrug, Russia | ||
3069345 | 3069345 | 2021-02-27 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-02-28 05:22:20 | Highland, Virginia, US |
3066198 | 3066198 | 2021-02-27 | Russia | Jewish Autonomous Okrug | 4319 | 119 | 4109 | 91 | 48.57527615 | 132.66307460000002 | 2021-02-28 05:22:20 | Jewish Autonomous Okrug, Russia | ||
2186929 | 2186929 | 2021-02-26 | US | Virginia | Highland | 51091 | 91 | 0 | 0 | 91 | 38.35799465 | -79.56124594 | 2021-02-27 05:22:28 | Highland, Virginia, US |
1858204 | 1858204 | 2021-02-25 | Russia | Jewish Autonomous Okrug | 4312 | 118 | 4103 | 91 | 48.57527615 | 132.66307460000002 | 2021-02-26 05:22:40 | Jewish Autonomous Okrug, Russia | ||
280191 | 280191 | 2021-02-24 | Japan | Gifu | 4599 | 108 | 4400 | 91 | 35.778671 | 137.055925 | 2021-02-25 05:24:57 | Gifu, Japan | ||
1938506 | 1938506 | 2021-02-23 | US | Nebraska | Deuel | 31049 | 93 | 2 | 0 | 91 | 41.11168186 | -102.3333331 | 2021-02-24 05:29:16 | Deuel, Nebraska, US |
1936650 | 1936650 | 2021-02-23 | Russia | Jewish Autonomous Okrug | 4305 | 118 | 4096 | 91 | 48.57527615 | 132.66307460000002 | 2021-02-24 05:29:16 | Jewish Autonomous Okrug, Russia | ||
530713 | 530713 | 2021-02-22 | Japan | Fukushima | 1876 | 69 | 1716 | 91 | 37.378867 | 140.223295 | 2021-02-23 05:23:41 | Fukushima, Japan | ||
471366 | 471366 | 2021-02-19 | India | Lakshadweep | 272 | 0 | 181 | 91 | 13.6999972 | 72.18333259999999 | 2021-02-20 05:22:51 | Lakshadweep, India | ||
3601182 | 3601182 | 2021-02-17 | Pakistan | Balochistan | 18958 | 199 | 18668 | 91 | 28.328492 | 65.898403 | 2021-02-18 05:22:58 | Balochistan, Pakistan | ||
3601103 | 3601103 | 2021-02-17 | Liechtenstein | 2616 | 55 | 2470 | 91 | 47.14 | 9.55 | 2021-02-18 05:22:58 | Liechtenstein | |||
3600998 | 3600998 | 2021-02-17 | India | Manipur | 29223 | 373 | 28759 | 91 | 24.738975 | 93.882541 | 2021-02-18 05:22:58 | Manipur, India | ||
1338229 | 1338229 | 2021-02-15 | India | Lakshadweep | 234 | 0 | 143 | 91 | 13.6999972 | 72.18333259999999 | 2021-02-16 05:24:38 | Lakshadweep, India | ||
3542735 | 3542735 | 2021-02-12 | US | Vermont | Grand Isle | 50013 | 91 | 0 | 0 | 91 | 44.7975824 | -73.29679772 | 2021-02-13 05:22:12 | Grand Isle, Vermont, US |
2640998 | 2640998 | 2021-02-11 | US | Vermont | Grand Isle | 50013 | 91 | 0 | 0 | 91 | 44.7975824 | -73.29679772 | 2021-02-12 05:23:29 | Grand Isle, Vermont, US |
2637750 | 2637750 | 2021-02-11 | Japan | Niigata | 986 | 13 | 882 | 91 | 37.521819 | 138.918647 | 2021-02-12 05:23:29 | Niigata, Japan | ||
2637738 | 2637738 | 2021-02-11 | Japan | Kagawa | 713 | 17 | 605 | 91 | 34.217292 | 133.969047 | 2021-02-12 05:23:29 | Kagawa, Japan | ||
974978 | 974978 | 2021-02-06 | Liberia | 1945 | 84 | 1770 | 91 | 6.4280550000000005 | -9.429499 | 2021-02-07 05:23:00 | Liberia | |||
1588236 | 1588236 | 2021-02-05 | Liberia | 1945 | 84 | 1770 | 91 | 6.4280550000000005 | -9.429499 | 2021-02-06 05:23:55 | Liberia | |||
1687579 | 1687579 | 2021-02-02 | US | Texas | Foard | 48155 | 75 | 7 | 0 | 91 | 33.97308618 | -99.7767797 | 2021-02-03 05:22:52 | Foard, Texas, US |
1679589 | 1679589 | 2021-02-01 | US | Texas | Irion | 48235 | 88 | 1 | 0 | 91 | 31.30375559 | -100.982439 | 2021-02-02 05:22:49 | Irion, Texas, US |
1462877 | 1462877 | 2021-01-31 | US | Texas | Irion | 48235 | 88 | 1 | 0 | 91 | 31.30375559 | -100.982439 | 2021-02-01 05:22:53 | Irion, Texas, US |
2214785 | 2214785 | 2021-01-30 | US | Texas | Irion | 48235 | 88 | 1 | 0 | 91 | 31.30375559 | -100.982439 | 2021-01-31 05:22:42 | Irion, Texas, US |
3153665 | 3153665 | 2021-01-27 | Liberia | 1932 | 84 | 1757 | 91 | 6.4280550000000005 | -9.429499 | 2021-01-28 05:22:24 | Liberia | |||
3153330 | 3153330 | 2021-01-27 | Bhutan | 856 | 1 | 764 | 91 | 27.5142 | 90.4336 | 2021-01-28 05:22:24 | Bhutan | |||
15418 | 15418 | 2021-01-26 | US | Texas | Foard | 48155 | 73 | 5 | 0 | 91 | 33.97308618 | -99.7767797 | 2021-01-27 05:23:41 | Foard, Texas, US |
2571111 | 2571111 | 2021-01-25 | US | Washington | San Juan | 53055 | 91 | 0 | 0 | 91 | 48.60182783 | -122.96745 | 2021-01-26 05:22:02 | San Juan, Washington, US |
2470252 | 2470252 | 2021-01-22 | US | Washington | San Juan | 53055 | 91 | 0 | 0 | 91 | 48.60182783 | -122.96745 | 2021-01-23 05:22:03 | San Juan, Washington, US |
3503311 | 3503311 | 2021-01-17 | India | Ladakh | 9656 | 128 | 9437 | 91 | 34.1526 | 77.5771 | 2021-01-18 05:22:34 | Ladakh, India | ||
3503263 | 3503263 | 2021-01-17 | Gambia | 3910 | 127 | 3692 | 91 | 13.4432 | -15.3101 | 2021-01-18 05:22:34 | Gambia | |||
3104887 | 3104887 | 2021-01-16 | US | Washington | San Juan | 53055 | 91 | 0 | 0 | 91 | 48.60182783 | -122.96745 | 2021-01-17 05:22:17 | San Juan, Washington, US |
3518849 | 3518849 | 2021-01-15 | US | Washington | San Juan | 53055 | 91 | 0 | 0 | 91 | 48.60182783 | -122.96745 | 2021-01-16 05:22:40 | San Juan, Washington, US |
3518032 | 3518032 | 2021-01-15 | US | Oregon | Wallowa | 41063 | 94 | 3 | 0 | 91 | 45.57894064 | -117.18353799999998 | 2021-01-16 05:22:40 | Wallowa, Oregon, US |
3882790 | 3882790 | 2021-01-14 | US | Texas | Sterling | 48431 | 87 | 4 | 0 | 91 | 31.82781912 | -101.0500746 | 2021-01-15 05:22:24 | Sterling, Texas, US |
3882661 | 3882661 | 2021-01-14 | US | Texas | Glasscock | 48173 | 83 | 1 | 0 | 91 | 31.86942909 | -101.5207776 | 2021-01-15 05:22:24 | Glasscock, Texas, US |
3311844 | 3311844 | 2021-01-13 | United Kingdom | Bermuda | 661 | 12 | 558 | 91 | 32.3078 | -64.7505 | 2021-01-14 05:22:32 | Bermuda, United Kingdom | ||
3311417 | 3311417 | 2021-01-13 | US | Texas | Sterling | 48431 | 87 | 4 | 0 | 91 | 31.82781912 | -101.0500746 | 2021-01-14 05:22:32 | Sterling, Texas, US |
157624 | 157624 | 2021-01-08 | United Kingdom | Bermuda | 641 | 12 | 538 | 91 | 32.3078 | -64.7505 | 2021-01-09 05:22:18 | Bermuda, United Kingdom | ||
2541441 | 2541441 | 2021-01-07 | Japan | Saga | 542 | 3 | 448 | 91 | 33.286977 | 130.115738 | 2021-01-08 05:22:42 | Saga, Japan | ||
2868400 | 2868400 | 2021-01-06 | Malaysia | Terengganu | 397 | 1 | 305 | 91 | 5.3117 | 103.1324 | 2021-01-07 05:22:03 | Terengganu, Malaysia |
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]);