johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,607 rows where active = 89 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 1,387
- Japan 43
- Colombia 18
- China 14
- Ukraine 10
- Malaysia 9
- Russia 8
- Yemen 8
- Germany 7
- Chile 6
- Belize 5
- France 5
- Italy 5
- Netherlands 5
- Seychelles 5
- India 4
- Tunisia 4
- United Kingdom 4
- Burundi 3
- Canada 3
- Equatorial Guinea 3
- Gabon 3
- Burkina Faso 2
- Chad 2
- Denmark 2
- Djibouti 2
- Eritrea 2
- Ethiopia 2
- Iceland 2
- Liberia 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015387 | 3015387 | 2021-08-01 | Japan | Shimane | 738 | 2 | 647 | 89 | 35.07076 | 132.55406399999998 | 2021-08-02 04:21:36 | Shimane, Japan | ||
3296225 | 3296225 | 2021-07-30 | Japan | Yamaguchi | 3280 | 80 | 3111 | 89 | 34.201190000000004 | 131.573293 | 2021-07-31 04:21:35 | Yamaguchi, Japan | ||
3385418 | 3385418 | 2021-07-29 | Japan | Oita | 3614 | 64 | 3461 | 89 | 33.200697 | 131.43323999999998 | 2021-07-30 04:21:34 | Oita, Japan | ||
1378355 | 1378355 | 2021-07-25 | Colombia | Guaviare | 4966 | 87 | 4790 | 89 | 1.0654 | -73.2603 | 2021-07-26 04:21:28 | Guaviare, Colombia | ||
3137566 | 3137566 | 2021-07-23 | Japan | Iwate | 1887 | 47 | 1751 | 89 | 39.593287 | 141.361777 | 2021-07-24 00:21:36 | Iwate, Japan | ||
3335156 | 3335156 | 2021-07-21 | Ukraine | Ivano-Frankivsk Oblast | 86784 | 2104 | 84591 | 89 | 48.9226 | 24.7111 | 2021-07-22 04:21:19 | Ivano-Frankivsk Oblast, Ukraine | ||
3335152 | 3335152 | 2021-07-21 | Ukraine | Chernivtsi Oblast | 80062 | 1795 | 78178 | 89 | 48.2917 | 25.9352 | 2021-07-22 04:21:19 | Chernivtsi Oblast, Ukraine | ||
2375133 | 2375133 | 2021-07-20 | Ukraine | Chernivtsi Oblast | 80058 | 1795 | 78174 | 89 | 48.2917 | 25.9352 | 2021-07-21 04:21:40 | Chernivtsi Oblast, Ukraine | ||
2677456 | 2677456 | 2021-07-18 | Ukraine | Volyn Oblast | 62251 | 1203 | 60959 | 89 | 50.7472 | 25.3254 | 2021-07-19 04:21:24 | Volyn Oblast, Ukraine | ||
3709768 | 3709768 | 2021-07-17 | Ukraine | Volyn Oblast | 62247 | 1203 | 60955 | 89 | 50.7472 | 25.3254 | 2021-07-18 04:22:07 | Volyn Oblast, Ukraine | ||
295966 | 295966 | 2021-07-15 | India | Lakshadweep | 10043 | 49 | 9905 | 89 | 13.6999972 | 72.18333259999999 | 2021-07-16 04:21:22 | Lakshadweep, India | ||
578860 | 578860 | 2021-07-13 | Japan | Niigata | 3497 | 54 | 3354 | 89 | 37.521819 | 138.918647 | 2021-07-14 04:21:35 | Niigata, Japan | ||
3744736 | 3744736 | 2021-07-12 | United Kingdom | Gibraltar | 4437 | 94 | 4254 | 89 | 36.1408 | -5.3536 | 2021-07-13 04:21:18 | Gibraltar, United Kingdom | ||
3740769 | 3740769 | 2021-07-12 | Albania | 132597 | 2456 | 130052 | 89 | 41.1533 | 20.1683 | 2021-07-13 04:21:18 | Albania | |||
3663220 | 3663220 | 2021-07-11 | Ukraine | Ivano-Frankivsk Oblast | 86729 | 2103 | 84537 | 89 | 48.9226 | 24.7111 | 2021-07-12 04:21:34 | Ivano-Frankivsk Oblast, Ukraine | ||
829511 | 829511 | 2021-07-09 | Germany | Mecklenburg-Vorpommern | 44174 | 1161 | 42930 | 89 | 53.6127 | 12.4296 | 2021-07-10 04:21:25 | Mecklenburg-Vorpommern, Germany | ||
829407 | 829407 | 2021-07-09 | China | Hong Kong | 11949 | 212 | 11648 | 89 | 22.3 | 114.2 | 2021-07-10 04:21:25 | Hong Kong, China | ||
829295 | 829295 | 2021-07-09 | Australia | Queensland | 1737 | 7 | 1641 | 89 | -27.4698 | 153.0251 | 2021-07-10 04:21:25 | Queensland, Australia | ||
1444227 | 1444227 | 2021-07-07 | Ukraine | Zakarpattia Oblast | 62127 | 1605 | 60433 | 89 | 48.6208 | 22.2879 | 2021-07-08 04:21:26 | Zakarpattia Oblast, Ukraine | ||
1440598 | 1440598 | 2021-07-07 | Japan | Iwate | 1746 | 47 | 1610 | 89 | 39.593287 | 141.361777 | 2021-07-08 04:21:26 | Iwate, Japan | ||
400401 | 400401 | 2021-06-29 | Niger | 5488 | 193 | 5206 | 89 | 17.607789 | 8.081666 | 2021-06-30 04:21:41 | Niger | |||
3125776 | 3125776 | 2021-06-28 | Saint Lucia | 5284 | 84 | 5111 | 89 | 13.9094 | -60.9789 | 2021-06-29 04:21:28 | Saint Lucia | |||
3125365 | 3125365 | 2021-06-28 | Colombia | San Andres y Providencia | 6264 | 124 | 6051 | 89 | 12.5567 | -81.7185 | 2021-06-29 04:21:28 | San Andres y Providencia, Colombia | ||
2589860 | 2589860 | 2021-06-27 | Colombia | San Andres y Providencia | 6256 | 123 | 6044 | 89 | 12.5567 | -81.7185 | 2021-06-28 04:21:29 | San Andres y Providencia, Colombia | ||
3958494 | 3958494 | 2021-06-26 | Italy | Molise | 13699 | 491 | 13119 | 89 | 41.55774754 | 14.65916051 | 2021-06-27 04:21:39 | Molise, Italy | ||
1712313 | 1712313 | 2021-06-25 | Italy | Molise | 13695 | 491 | 13115 | 89 | 41.55774754 | 14.65916051 | 2021-06-26 04:21:43 | Molise, Italy | ||
2295470 | 2295470 | 2021-06-24 | Japan | Kumamoto | 6463 | 113 | 6261 | 89 | 32.608154 | 130.74523100000002 | 2021-06-25 04:21:33 | Kumamoto, Japan | ||
2422916 | 2422916 | 2021-06-23 | Japan | Nagasaki | 3123 | 69 | 2965 | 89 | 33.235712 | 129.608033 | 2021-06-24 04:21:55 | Nagasaki, Japan | ||
2884391 | 2884391 | 2021-06-20 | Japan | Miyagi | 9066 | 86 | 8891 | 89 | 38.446859 | 140.927086 | 2021-06-21 04:21:41 | Miyagi, Japan | ||
2884253 | 2884253 | 2021-06-20 | Equatorial Guinea | 8698 | 120 | 8489 | 89 | 1.6508 | 10.2679 | 2021-06-21 04:21:41 | Equatorial Guinea | |||
107465 | 107465 | 2021-06-19 | Japan | Ishikawa | 3911 | 114 | 3708 | 89 | 36.769464 | 136.771027 | 2021-06-20 04:21:48 | Ishikawa, Japan | ||
107336 | 107336 | 2021-06-19 | Equatorial Guinea | 8698 | 120 | 8489 | 89 | 1.6508 | 10.2679 | 2021-06-20 04:21:48 | Equatorial Guinea | |||
1125479 | 1125479 | 2021-06-18 | Equatorial Guinea | 8698 | 120 | 8489 | 89 | 1.6508 | 10.2679 | 2021-06-19 04:22:33 | Equatorial Guinea | |||
3970805 | 3970805 | 2021-06-11 | Russia | Tyva Republic | 16024 | 203 | 15732 | 89 | 51.4017149 | 93.8582593 | 2021-06-12 04:22:22 | Tyva Republic, Russia | ||
825599 | 825599 | 2021-06-06 | Japan | Kagawa | 2036 | 26 | 1921 | 89 | 34.217292 | 133.969047 | 2021-06-07 04:22:51 | Kagawa, Japan | ||
2315237 | 2315237 | 2021-06-04 | Iceland | 6595 | 30 | 6476 | 89 | 64.9631 | -19.0208 | 2021-06-05 04:23:03 | Iceland | |||
1448648 | 1448648 | 2021-06-03 | Liberia | 2219 | 86 | 2044 | 89 | 6.4280550000000005 | -9.429499 | 2021-06-04 04:23:37 | Liberia | |||
1448620 | 1448620 | 2021-06-03 | Japan | Port Quarantine | 2980 | 3 | 2888 | 89 | 2021-06-04 04:23:37 | Port Quarantine, Japan | ||||
3089144 | 3089144 | 2021-05-30 | Belize | 12791 | 324 | 12378 | 89 | 17.1899 | -88.4976 | 2021-05-31 03:08:59 | Belize | |||
54471 | 54471 | 2021-05-29 | Malaysia | Perlis | 492 | 4 | 399 | 89 | 6.4449 | 100.2048 | 2021-05-30 04:20:55 | Perlis, Malaysia | ||
50513 | 50513 | 2021-05-29 | Belize | 12791 | 324 | 12378 | 89 | 17.1899 | -88.4976 | 2021-05-30 04:20:55 | Belize | |||
20403 | 20403 | 2021-05-28 | Japan | Port Quarantine | 2948 | 3 | 2856 | 89 | 2021-05-29 04:20:41 | Port Quarantine, Japan | ||||
20092 | 20092 | 2021-05-28 | Belize | 12791 | 324 | 12378 | 89 | 17.1899 | -88.4976 | 2021-05-29 04:20:41 | Belize | |||
1771471 | 1771471 | 2021-05-23 | Netherlands | Sint Maarten | 2366 | 27 | 2250 | 89 | 18.0425 | -63.0548 | 2021-05-24 04:20:53 | Sint Maarten, Netherlands | ||
1912934 | 1912934 | 2021-05-20 | Belize | 12761 | 323 | 12349 | 89 | 17.1899 | -88.4976 | 2021-05-21 04:20:43 | Belize | |||
3574816 | 3574816 | 2021-05-17 | Russia | Magadan Oblast | 8399 | 104 | 8206 | 89 | 62.48858785 | 153.9903764 | 2021-05-18 04:20:33 | Magadan Oblast, Russia | ||
2939136 | 2939136 | 2021-05-16 | China | Hong Kong | 11824 | 210 | 11525 | 89 | 22.3 | 114.2 | 2021-05-17 04:20:34 | Hong Kong, China | ||
2939095 | 2939095 | 2021-05-16 | Canada | Newfoundland and Labrador | 1193 | 6 | 1098 | 89 | 53.1355 | -57.6604 | 2021-05-17 04:20:34 | Newfoundland and Labrador, Canada | ||
1872766 | 1872766 | 2021-05-15 | China | Hong Kong | 11821 | 210 | 11522 | 89 | 22.3 | 114.2 | 2021-05-16 04:20:49 | Hong Kong, China | ||
1081930 | 1081930 | 2021-05-14 | Japan | Fukui | 978 | 34 | 855 | 89 | 35.846614 | 136.22465400000002 | 2021-05-15 04:20:58 | Fukui, Japan | ||
1552300 | 1552300 | 2021-05-08 | Taiwan* | 1183 | 12 | 1082 | 89 | 23.7 | 121.0 | 2021-05-09 04:20:35 | Taiwan* | |||
2502358 | 2502358 | 2021-05-07 | Taiwan* | 1178 | 12 | 1077 | 89 | 23.7 | 121.0 | 2021-05-08 04:21:04 | Taiwan* | |||
2020445 | 2020445 | 2021-04-20 | Belize | 12568 | 318 | 12161 | 89 | 17.1899 | -88.4976 | 2021-04-21 04:21:14 | Belize | |||
3129704 | 3129704 | 2021-04-18 | Russia | Altai Republic | 16767 | 217 | 16461 | 89 | 50.7114101 | 86.8572186 | 2021-04-19 04:20:57 | Altai Republic, Russia | ||
2571721 | 2571721 | 2021-04-13 | Japan | Tottori | 311 | 2 | 220 | 89 | 35.359069 | 133.863619 | 2021-04-14 04:20:41 | Tottori, Japan | ||
36366 | 36366 | 2021-04-12 | India | Andaman and Nicobar Islands | 5201 | 62 | 5050 | 89 | 11.225999 | 92.968178 | 2021-04-13 04:20:37 | Andaman and Nicobar Islands, India | ||
605732 | 605732 | 2021-04-09 | Japan | Toyama | 1017 | 29 | 899 | 89 | 36.637464 | 137.26934599999998 | 2021-04-10 04:20:59 | Toyama, Japan | ||
3709973 | 3709973 | 2021-04-03 | Colombia | Arauca | 5781 | 173 | 5519 | 89 | 7.0762 | -70.7105 | 2021-04-04 04:20:49 | Arauca, Colombia | ||
241270 | 241270 | 2021-04-02 | Japan | Iwate | 673 | 30 | 554 | 89 | 39.593287 | 141.361777 | 2021-04-03 04:20:44 | Iwate, Japan | ||
3643563 | 3643563 | 2021-03-30 | Japan | Hiroshima | 5152 | 106 | 4957 | 89 | 34.605309000000005 | 132.788719 | 2021-03-31 04:26:25 | Hiroshima, Japan | ||
1980551 | 1980551 | 2021-03-25 | Iceland | 6158 | 29 | 6040 | 89 | 64.9631 | -19.0208 | 2021-03-26 05:26:55 | Iceland | |||
3369114 | 3369114 | 2021-03-21 | Chile | Aysen | 3356 | 26 | 3241 | 89 | -45.9864 | -73.7669 | 2021-03-22 05:25:43 | Aysen, Chile | ||
1580351 | 1580351 | 2021-03-13 | Russia | Jewish Autonomous Okrug | 4381 | 122 | 4170 | 89 | 48.57527615 | 132.66307460000002 | 2021-03-14 05:25:37 | Jewish Autonomous Okrug, Russia | ||
2207880 | 2207880 | 2021-03-04 | Russia | Nenets Autonomous Okrug | 1028 | 3 | 936 | 89 | 68.27557185 | 57.1686375 | 2021-03-05 05:26:29 | Nenets Autonomous Okrug, Russia | ||
998715 | 998715 | 2021-03-01 | Singapore | 59948 | 29 | 59830 | 89 | 1.2833 | 103.8333 | 2021-03-02 05:23:30 | Singapore | |||
2369764 | 2369764 | 2021-02-28 | US | New York | Unassigned | 90036 | 219 | 130 | 0 | 89 | 44.74530905 | 0.0 | 2021-03-01 05:23:01 | Unassigned, New York, US |
3065784 | 3065784 | 2021-02-27 | Chile | Aysen | 3062 | 25 | 2948 | 89 | -45.9864 | -73.7669 | 2021-02-28 05:22:20 | Aysen, Chile | ||
2185638 | 2185638 | 2021-02-26 | US | Nebraska | Deuel | 31049 | 91 | 2 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-27 05:22:28 | Deuel, Nebraska, US |
1861351 | 1861351 | 2021-02-25 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-26 05:22:40 | Highland, Virginia, US |
1860060 | 1860060 | 2021-02-25 | US | Nebraska | Deuel | 31049 | 91 | 2 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-26 05:22:40 | Deuel, Nebraska, US |
283529 | 283529 | 2021-02-24 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-25 05:24:57 | Highland, Virginia, US |
282238 | 282238 | 2021-02-24 | US | Nebraska | Deuel | 31049 | 91 | 2 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-25 05:24:57 | Deuel, Nebraska, US |
280193 | 280193 | 2021-02-24 | Japan | Hiroshima | 5014 | 102 | 4823 | 89 | 34.605309000000005 | 132.788719 | 2021-02-25 05:24:57 | Hiroshima, Japan | ||
1936592 | 1936592 | 2021-02-23 | Pakistan | Balochistan | 19004 | 199 | 18716 | 89 | 28.328492 | 65.898403 | 2021-02-24 05:29:16 | Balochistan, Pakistan | ||
530753 | 530753 | 2021-02-22 | Japan | Yamaguchi | 1369 | 36 | 1244 | 89 | 34.201190000000004 | 131.573293 | 2021-02-23 05:23:41 | Yamaguchi, Japan | ||
530714 | 530714 | 2021-02-22 | Japan | Gifu | 4574 | 105 | 4380 | 89 | 35.778671 | 137.055925 | 2021-02-23 05:23:41 | Gifu, Japan | ||
745660 | 745660 | 2021-02-20 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-21 05:24:33 | Highland, Virginia, US |
474758 | 474758 | 2021-02-19 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-20 05:22:51 | Highland, Virginia, US |
1153144 | 1153144 | 2021-02-18 | Japan | Miyagi | 3528 | 23 | 3416 | 89 | 38.446859 | 140.927086 | 2021-02-19 05:24:16 | Miyagi, Japan | ||
3603096 | 3603096 | 2021-02-17 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-18 05:22:58 | Deuel, Nebraska, US |
3052231 | 3052231 | 2021-02-16 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-17 05:23:10 | Deuel, Nebraska, US |
1340330 | 1340330 | 2021-02-15 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-16 05:24:38 | Deuel, Nebraska, US |
1338337 | 1338337 | 2021-02-15 | Liechtenstein | 2614 | 55 | 2470 | 89 | 47.14 | 9.55 | 2021-02-16 05:24:38 | Liechtenstein | |||
2285481 | 2285481 | 2021-02-14 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-15 05:24:49 | Deuel, Nebraska, US |
2679881 | 2679881 | 2021-02-13 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-14 05:23:43 | Deuel, Nebraska, US |
3541514 | 3541514 | 2021-02-12 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-13 05:22:12 | Deuel, Nebraska, US |
2639777 | 2639777 | 2021-02-11 | US | Nebraska | Deuel | 31049 | 90 | 1 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-12 05:23:29 | Deuel, Nebraska, US |
2637850 | 2637850 | 2021-02-11 | Netherlands | Sint Maarten | 1985 | 27 | 1869 | 89 | 18.0425 | -63.0548 | 2021-02-12 05:23:29 | Sint Maarten, Netherlands | ||
2637682 | 2637682 | 2021-02-11 | India | Nagaland | 12175 | 88 | 11998 | 89 | 26.06702 | 94.470302 | 2021-02-12 05:23:29 | Nagaland, India | ||
3982241 | 3982241 | 2021-02-10 | Yemen | 2133 | 616 | 1428 | 89 | 15.552727 | 48.516388 | 2021-02-11 05:23:55 | Yemen | |||
790397 | 790397 | 2021-02-04 | Japan | Ishikawa | 1494 | 58 | 1347 | 89 | 36.769464 | 136.771027 | 2021-02-05 05:22:38 | Ishikawa, Japan | ||
342330 | 342330 | 2021-02-03 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-04 05:22:26 | Deuel, Nebraska, US |
340308 | 340308 | 2021-02-03 | Japan | Port Quarantine | 2168 | 2 | 2077 | 89 | 2021-02-04 05:22:26 | Port Quarantine, Japan | ||||
1687368 | 1687368 | 2021-02-02 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-02-03 05:22:52 | Harding, South Dakota, US |
1686556 | 1686556 | 2021-02-02 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-03 05:22:52 | Deuel, Nebraska, US |
1679338 | 1679338 | 2021-02-01 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-02-02 05:22:49 | Harding, South Dakota, US |
1678526 | 1678526 | 2021-02-01 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-02 05:22:49 | Deuel, Nebraska, US |
1462626 | 1462626 | 2021-01-31 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-02-01 05:22:53 | Harding, South Dakota, US |
1461814 | 1461814 | 2021-01-31 | US | Nebraska | Deuel | 31049 | 89 | 0 | 0 | 89 | 41.11168186 | -102.3333331 | 2021-02-01 05:22:53 | Deuel, Nebraska, US |
2214534 | 2214534 | 2021-01-30 | US | South Dakota | Harding | 46063 | 90 | 1 | 0 | 89 | 45.58015551 | -103.4958629 | 2021-01-31 05:22:42 | Harding, South Dakota, 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]);