johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
879 rows where active = 196 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 764
- Japan 20
- Colombia 8
- Mexico 8
- Chile 6
- India 5
- Russia 5
- Ukraine 5
- Belize 4
- Eritrea 4
- Italy 4
- Malaysia 4
- United Kingdom 3
- Uruguay 3
- Cote d'Ivoire 2
- Djibouti 2
- Germany 2
- Latvia 2
- Suriname 2
- Antigua and Barbuda 1
- Barbados 1
- Burkina Faso 1
- Canada 1
- Chad 1
- China 1
- Cyprus 1
- Eswatini 1
- Georgia 1
- Guyana 1
- Iceland 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378302 | 1378302 | 2021-07-25 | Chile | Tarapaca | 40150 | 772 | 39182 | 196 | -19.9232 | -69.5132 | 2021-07-26 04:21:28 | Tarapaca, Chile | ||
1330277 | 1330277 | 2021-07-24 | Japan | Okayama | 7841 | 127 | 7518 | 196 | 34.89246 | 133.826252 | 2021-07-25 04:22:12 | Okayama, Japan | ||
3137561 | 3137561 | 2021-07-23 | Japan | Hiroshima | 11793 | 179 | 11418 | 196 | 34.605309000000005 | 132.788719 | 2021-07-24 00:21:36 | Hiroshima, Japan | ||
3137506 | 3137506 | 2021-07-23 | India | Madhya Pradesh | 791732 | 10512 | 781024 | 196 | 23.541513 | 78.289633 | 2021-07-24 00:21:36 | Madhya Pradesh, India | ||
3331325 | 3331325 | 2021-07-21 | Chile | Tarapaca | 39988 | 764 | 39028 | 196 | -19.9232 | -69.5132 | 2021-07-22 04:21:19 | Tarapaca, Chile | ||
3331238 | 3331238 | 2021-07-21 | Barbados | 4302 | 48 | 4058 | 196 | 13.1939 | -59.5432 | 2021-07-22 04:21:19 | Barbados | |||
483819 | 483819 | 2021-07-19 | Russia | Nenets Autonomous Okrug | 1423 | 10 | 1217 | 196 | 68.27557185 | 57.1686375 | 2021-07-20 04:21:48 | Nenets Autonomous Okrug, Russia | ||
833230 | 833230 | 2021-07-09 | Ukraine | Luhansk Oblast | 26711 | 954 | 25561 | 196 | 48.574 | 39.3078 | 2021-07-10 04:21:25 | Luhansk Oblast, Ukraine | ||
1440851 | 1440851 | 2021-07-07 | Saint Kitts and Nevis | 517 | 3 | 318 | 196 | 17.357822 | -62.782998 | 2021-07-08 04:21:26 | Saint Kitts and Nevis | |||
2072140 | 2072140 | 2021-07-02 | Russia | Magadan Oblast | 8735 | 117 | 8422 | 196 | 62.48858785 | 153.9903764 | 2021-07-03 04:21:37 | Magadan Oblast, Russia | ||
2589724 | 2589724 | 2021-06-27 | Belize | 13137 | 329 | 12612 | 196 | 17.1899 | -88.4976 | 2021-06-28 04:21:29 | Belize | |||
3958228 | 3958228 | 2021-06-26 | Belize | 13137 | 329 | 12612 | 196 | 17.1899 | -88.4976 | 2021-06-27 04:21:39 | Belize | |||
1712047 | 1712047 | 2021-06-25 | Belize | 13137 | 329 | 12612 | 196 | 17.1899 | -88.4976 | 2021-06-26 04:21:43 | Belize | |||
2884216 | 2884216 | 2021-06-20 | Colombia | Guaviare | 4017 | 63 | 3758 | 196 | 1.0654 | -73.2603 | 2021-06-21 04:21:41 | Guaviare, Colombia | ||
3381710 | 3381710 | 2021-06-13 | Togo | 13627 | 126 | 13305 | 196 | 8.6195 | 0.8248 | 2021-06-14 04:22:46 | Togo | |||
1736526 | 1736526 | 2021-06-12 | Japan | Kagoshima | 3569 | 33 | 3340 | 196 | 31.009484000000004 | 130.430665 | 2021-06-13 04:22:44 | Kagoshima, Japan | ||
3089446 | 3089446 | 2021-05-30 | Japan | Miyazaki | 3021 | 25 | 2800 | 196 | 32.193203999999994 | 131.299374 | 2021-05-31 03:08:59 | Miyazaki, Japan | ||
20256 | 20256 | 2021-05-28 | Eritrea | 4022 | 14 | 3812 | 196 | 15.1794 | 39.7823 | 2021-05-29 04:20:41 | Eritrea | |||
1952399 | 1952399 | 2021-05-21 | Eritrea | 3921 | 14 | 3711 | 196 | 15.1794 | 39.7823 | 2021-05-22 04:20:45 | Eritrea | |||
1085570 | 1085570 | 2021-05-14 | United Kingdom | Bermuda | 2462 | 32 | 2234 | 196 | 32.3078 | -64.7505 | 2021-05-15 04:20:58 | Bermuda, United Kingdom | ||
2824801 | 2824801 | 2021-05-01 | Japan | Kagawa | 1281 | 22 | 1063 | 196 | 34.217292 | 133.969047 | 2021-05-02 04:20:48 | Kagawa, Japan | ||
380033 | 380033 | 2021-04-30 | Colombia | Caqueta | 17486 | 655 | 16635 | 196 | 0.8699 | -73.8419 | 2021-05-01 04:20:47 | Caqueta, Colombia | ||
954735 | 954735 | 2021-04-25 | Cote d'Ivoire | 45852 | 282 | 45374 | 196 | 7.54 | -5.5471 | 2021-04-26 04:21:04 | Cote d'Ivoire | |||
954705 | 954705 | 2021-04-25 | Colombia | Caqueta | 17405 | 655 | 16554 | 196 | 0.8699 | -73.8419 | 2021-04-26 04:21:04 | Caqueta, Colombia | ||
3923882 | 3923882 | 2021-04-24 | Cote d'Ivoire | 45820 | 281 | 45343 | 196 | 7.54 | -5.5471 | 2021-04-25 04:20:32 | Cote d'Ivoire | |||
1408823 | 1408823 | 2021-04-23 | Chad | 4747 | 169 | 4382 | 196 | 15.4542 | 18.7322 | 2021-04-24 04:20:38 | Chad | |||
1408735 | 1408735 | 2021-04-23 | Antigua and Barbuda | 1222 | 31 | 995 | 196 | 17.0608 | -61.7964 | 2021-04-24 04:20:38 | Antigua and Barbuda | |||
2411113 | 2411113 | 2021-04-19 | San Marino | 5030 | 88 | 4746 | 196 | 43.9424 | 12.4578 | 2021-04-20 04:20:41 | San Marino | |||
983021 | 983021 | 2021-04-17 | Mauritania | 18121 | 452 | 17473 | 196 | 21.0079 | -10.9408 | 2021-04-18 04:20:41 | Mauritania | |||
2548761 | 2548761 | 2021-04-15 | Eritrea | 3486 | 10 | 3280 | 196 | 15.1794 | 39.7823 | 2021-04-16 04:20:46 | Eritrea | |||
1841831 | 1841831 | 2021-04-14 | Eritrea | 3479 | 10 | 3273 | 196 | 15.1794 | 39.7823 | 2021-04-15 04:20:54 | Eritrea | |||
2645755 | 2645755 | 2021-04-08 | Japan | Aomori | 1131 | 20 | 915 | 196 | 40.781541 | 140.828896 | 2021-04-09 04:21:13 | Aomori, Japan | ||
2645510 | 2645510 | 2021-04-08 | Burkina Faso | 12904 | 152 | 12556 | 196 | 12.2383 | -1.5616 | 2021-04-09 04:21:13 | Burkina Faso | |||
3003248 | 3003248 | 2021-04-06 | India | Dadra and Nagar Haveli and Daman and Diu | 3788 | 2 | 3590 | 196 | 20.194742 | 73.080901 | 2021-04-07 04:20:53 | Dadra and Nagar Haveli and Daman and Diu, India | ||
638107 | 638107 | 2021-03-31 | Russia | Altai Republic | 16655 | 191 | 16268 | 196 | 50.7114101 | 86.8572186 | 2021-04-01 04:27:05 | Altai Republic, Russia | ||
1798780 | 1798780 | 2021-03-23 | Pakistan | Balochistan | 19374 | 203 | 18975 | 196 | 28.328492 | 65.898403 | 2021-03-24 05:25:40 | Balochistan, Pakistan | ||
3420957 | 3420957 | 2021-03-19 | Japan | Shizuoka | 5463 | 109 | 5158 | 196 | 34.916975 | 138.40778400000002 | 2021-03-20 05:25:46 | Shizuoka, Japan | ||
3671300 | 3671300 | 2021-03-06 | Malaysia | Pahang | 3906 | 15 | 3695 | 196 | 3.8126 | 103.3256 | 2021-03-07 05:21:54 | Pahang, Malaysia | ||
3670786 | 3670786 | 2021-03-06 | US | Texas | Menard | 48327 | 195 | 9 | 0 | 196 | 30.88990665 | -99.8204794 | 2021-03-07 05:21:54 | Menard, Texas, US |
3668914 | 3668914 | 2021-03-06 | US | Kansas | Jewell | 20089 | 200 | 4 | 0 | 196 | 39.78470589 | -98.21820662 | 2021-03-07 05:21:54 | Jewell, Kansas, US |
3667660 | 3667660 | 2021-03-06 | Japan | Shizuoka | 5231 | 97 | 4938 | 196 | 34.916975 | 138.40778400000002 | 2021-03-07 05:21:54 | Shizuoka, Japan | ||
1617535 | 1617535 | 2021-03-05 | US | Kansas | Jewell | 20089 | 200 | 4 | 0 | 196 | 39.78470589 | -98.21820662 | 2021-03-06 04:23:41 | Jewell, Kansas, US |
3255436 | 3255436 | 2021-03-02 | US | Kansas | Hodgeman | 20083 | 203 | 7 | 0 | 196 | 38.08780079 | -99.89829881 | 2021-03-03 05:23:28 | Hodgeman, Kansas, US |
999728 | 999728 | 2021-03-01 | US | Kansas | Hodgeman | 20083 | 203 | 7 | 0 | 196 | 38.08780079 | -99.89829881 | 2021-03-02 05:23:30 | Hodgeman, Kansas, US |
2370207 | 2370207 | 2021-02-28 | US | Puerto Rico | Arroyo | 72015 | 196 | 0 | 0 | 196 | 17.998457000000005 | -66.056546 | 2021-03-01 05:23:01 | Arroyo, Puerto Rico, US |
3068709 | 3068709 | 2021-02-27 | US | Puerto Rico | Arroyo | 72015 | 196 | 0 | 0 | 196 | 17.998457000000005 | -66.056546 | 2021-02-28 05:22:20 | Arroyo, Puerto Rico, US |
1861669 | 1861669 | 2021-02-25 | Yemen | 2255 | 625 | 1434 | 196 | 15.552727 | 48.516388 | 2021-02-26 05:22:40 | Yemen | |||
1857967 | 1857967 | 2021-02-25 | India | Puducherry | 39677 | 667 | 38814 | 196 | 11.882658 | 78.86498 | 2021-02-26 05:22:40 | Puducherry, India | ||
531623 | 531623 | 2021-02-22 | US | Idaho | Butte | 16023 | 197 | 1 | 0 | 196 | 43.72592209 | -113.1735463 | 2021-02-23 05:23:41 | Butte, Idaho, US |
182957 | 182957 | 2021-02-21 | US | Idaho | Butte | 16023 | 197 | 1 | 0 | 196 | 43.72592209 | -113.1735463 | 2021-02-22 05:24:21 | Butte, Idaho, US |
182454 | 182454 | 2021-02-21 | US | Alaska | Dillingham | 2070 | 197 | 1 | 0 | 196 | 59.79603738 | -158.23819419999995 | 2021-02-22 05:24:21 | Dillingham, Alaska, US |
743231 | 743231 | 2021-02-20 | US | Idaho | Butte | 16023 | 197 | 1 | 0 | 196 | 43.72592209 | -113.1735463 | 2021-02-21 05:24:33 | Butte, Idaho, US |
742728 | 742728 | 2021-02-20 | US | Alaska | Dillingham | 2070 | 197 | 1 | 0 | 196 | 59.79603738 | -158.23819419999995 | 2021-02-21 05:24:33 | Dillingham, Alaska, US |
742423 | 742423 | 2021-02-20 | Monaco | 1862 | 22 | 1644 | 196 | 43.7333 | 7.4167 | 2021-02-21 05:24:33 | Monaco | |||
472329 | 472329 | 2021-02-19 | US | Idaho | Butte | 16023 | 197 | 1 | 0 | 196 | 43.72592209 | -113.1735463 | 2021-02-20 05:22:51 | Butte, Idaho, US |
471826 | 471826 | 2021-02-19 | US | Alaska | Dillingham | 2070 | 197 | 1 | 0 | 196 | 59.79603738 | -158.23819419999995 | 2021-02-20 05:22:51 | Dillingham, Alaska, US |
1154038 | 1154038 | 2021-02-18 | US | Idaho | Butte | 16023 | 197 | 1 | 0 | 196 | 43.72592209 | -113.1735463 | 2021-02-19 05:24:16 | Butte, Idaho, US |
2637445 | 2637445 | 2021-02-11 | Belize | 12114 | 313 | 11605 | 196 | 17.1899 | -88.4976 | 2021-02-12 05:23:29 | Belize | |||
1527944 | 1527944 | 2021-02-09 | Japan | Yamaguchi | 1323 | 30 | 1097 | 196 | 34.201190000000004 | 131.573293 | 2021-02-10 05:22:41 | Yamaguchi, Japan | ||
974752 | 974752 | 2021-02-06 | Colombia | Arauca | 5446 | 157 | 5093 | 196 | 7.0762 | -70.7105 | 2021-02-07 05:23:00 | Arauca, Colombia | ||
342885 | 342885 | 2021-02-03 | US | Oregon | Harney | 41025 | 202 | 6 | 0 | 196 | 43.06422669 | -118.9666306 | 2021-02-04 05:22:26 | Harney, Oregon, US |
1679900 | 1679900 | 2021-02-01 | US | Washington | Ferry | 53019 | 200 | 4 | 0 | 196 | 48.471143100000006 | -118.5154041 | 2021-02-02 05:22:49 | Ferry, Washington, US |
1679635 | 1679635 | 2021-02-01 | US | Texas | Menard | 48327 | 191 | 5 | 0 | 196 | 30.88990665 | -99.8204794 | 2021-02-02 05:22:49 | Menard, Texas, US |
2211684 | 2211684 | 2021-01-30 | Japan | Kagoshima | 1609 | 19 | 1394 | 196 | 31.009484000000004 | 130.430665 | 2021-01-31 05:22:42 | Kagoshima, Japan | ||
2430218 | 2430218 | 2021-01-23 | US | Virginia | Craig | 51045 | 199 | 3 | 0 | 196 | 37.48133648 | -80.21072274 | 2021-01-24 05:22:35 | Craig, Virginia, US |
2426860 | 2426860 | 2021-01-23 | India | Manipur | 28970 | 369 | 28405 | 196 | 24.738975 | 93.882541 | 2021-01-24 05:22:35 | Manipur, India | ||
2470120 | 2470120 | 2021-01-22 | US | Virginia | Craig | 51045 | 199 | 3 | 0 | 196 | 37.48133648 | -80.21072274 | 2021-01-23 05:22:03 | Craig, Virginia, US |
2467545 | 2467545 | 2021-01-22 | US | Georgia | Baker | 13007 | 202 | 6 | 0 | 196 | 31.32669878 | -84.44218806 | 2021-01-23 05:22:03 | Baker, Georgia, US |
911832 | 911832 | 2021-01-19 | United Kingdom | Turks and Caicos Islands | 1105 | 7 | 902 | 196 | 21.694000000000006 | -71.7979 | 2021-01-20 05:21:54 | Turks and Caicos Islands, United Kingdom | ||
240895 | 240895 | 2021-01-18 | United Kingdom | Turks and Caicos Islands | 1105 | 7 | 902 | 196 | 21.694000000000006 | -71.7979 | 2021-01-19 05:22:15 | Turks and Caicos Islands, United Kingdom | ||
3516200 | 3516200 | 2021-01-15 | US | Georgia | Glascock | 13125 | 204 | 8 | 0 | 196 | 33.22879932 | -82.61297636 | 2021-01-16 05:22:40 | Glascock, Georgia, US |
3882635 | 3882635 | 2021-01-14 | US | Texas | Delta | 48119 | 836 | 5 | 0 | 196 | 33.38570922 | -95.66921122 | 2021-01-15 05:22:24 | Delta, Texas, US |
3311262 | 3311262 | 2021-01-13 | US | Texas | Delta | 48119 | 835 | 4 | 0 | 196 | 33.38570922 | -95.66921122 | 2021-01-14 05:22:32 | Delta, Texas, US |
3308251 | 3308251 | 2021-01-13 | Japan | Yamanashi | 795 | 11 | 588 | 196 | 35.612364 | 138.61148899999998 | 2021-01-14 05:22:32 | Yamanashi, Japan | ||
776554 | 776554 | 2021-01-12 | US | New Mexico | Union | 35059 | 203 | 7 | 0 | 196 | 36.48126404 | -103.4709624 | 2021-01-13 05:22:15 | Union, New Mexico, US |
775993 | 775993 | 2021-01-12 | US | Michigan | Luce | 26095 | 196 | 0 | 0 | 196 | 46.47227431 | -85.54471223 | 2021-01-13 05:22:15 | Luce, Michigan, US |
192948 | 192948 | 2021-01-11 | US | South Dakota | McPherson | 46089 | 199 | 3 | 0 | 196 | 45.76626028 | -99.22118798 | 2021-01-12 05:22:15 | McPherson, South Dakota, US |
191714 | 191714 | 2021-01-11 | US | Michigan | Luce | 26095 | 196 | 0 | 0 | 196 | 46.47227431 | -85.54471223 | 2021-01-12 05:22:15 | Luce, Michigan, US |
190834 | 190834 | 2021-01-11 | US | Georgia | Clay | 13061 | 199 | 3 | 0 | 196 | 31.62221166 | -84.97713865 | 2021-01-12 05:22:15 | Clay, Georgia, US |
2627517 | 2627517 | 2021-01-10 | US | Michigan | Luce | 26095 | 196 | 0 | 0 | 196 | 46.47227431 | -85.54471223 | 2021-01-11 05:21:50 | Luce, Michigan, US |
3903283 | 3903283 | 2021-01-09 | US | Virginia | Falls Church | 51610 | 202 | 6 | 0 | 196 | 38.88485255 | -77.17560759 | 2021-01-10 05:22:12 | Falls Church, Virginia, US |
3901962 | 3901962 | 2021-01-09 | US | Montana | Mineral | 30061 | 196 | 0 | 0 | 196 | 47.15283992 | -115.0015239 | 2021-01-10 05:22:12 | Mineral, Montana, US |
3901605 | 3901605 | 2021-01-09 | US | Michigan | Luce | 26095 | 196 | 0 | 0 | 196 | 46.47227431 | -85.54471223 | 2021-01-10 05:22:12 | Luce, Michigan, US |
157050 | 157050 | 2021-01-08 | US | Texas | Edwards | 48137 | 214 | 3 | 0 | 196 | 29.98202582 | -100.304252 | 2021-01-09 05:22:18 | Edwards, Texas, US |
156356 | 156356 | 2021-01-08 | US | North Dakota | Adams | 38001 | 204 | 2 | 0 | 196 | 46.09686891 | -102.5285397 | 2021-01-09 05:22:18 | Adams, North Dakota, US |
155628 | 155628 | 2021-01-08 | US | Michigan | Luce | 26095 | 196 | 0 | 0 | 196 | 46.47227431 | -85.54471223 | 2021-01-09 05:22:18 | Luce, Michigan, US |
2544474 | 2544474 | 2021-01-07 | US | Texas | Edwards | 48137 | 213 | 2 | 0 | 196 | 29.98202582 | -100.304252 | 2021-01-08 05:22:42 | Edwards, Texas, US |
2868163 | 2868163 | 2021-01-06 | US | Washington | Skamania | 53059 | 197 | 1 | 0 | 196 | 46.02408726 | -121.9164403 | 2021-01-07 05:22:03 | Skamania, Washington, US |
1065039 | 1065039 | 2021-01-04 | US | Texas | Real | 48385 | 225 | 11 | 0 | 196 | 29.83321503 | -99.82018052 | 2021-01-05 05:21:49 | Real, Texas, US |
1064567 | 1064567 | 2021-01-04 | US | Puerto Rico | Ceiba | 72037 | 196 | 0 | 0 | 196 | 18.251818 | -65.666416 | 2021-01-05 05:21:49 | Ceiba, Puerto Rico, US |
3233642 | 3233642 | 2021-01-03 | US | Texas | Real | 48385 | 225 | 11 | 0 | 196 | 29.83321503 | -99.82018052 | 2021-01-04 05:22:02 | Real, Texas, US |
3233170 | 3233170 | 2021-01-03 | US | Puerto Rico | Ceiba | 72037 | 196 | 0 | 0 | 196 | 18.251818 | -65.666416 | 2021-01-04 05:22:02 | Ceiba, Puerto Rico, US |
3233065 | 3233065 | 2021-01-03 | US | Oregon | Lake | 41037 | 200 | 4 | 0 | 196 | 42.79246693 | -120.3850163 | 2021-01-04 05:22:02 | Lake, Oregon, US |
3232585 | 3232585 | 2021-01-03 | US | Nevada | Mineral | 32021 | 200 | 4 | 0 | 196 | 38.53841696 | -118.4344506 | 2021-01-04 05:22:02 | Mineral, Nevada, US |
2230711 | 2230711 | 2021-01-02 | US | Texas | Real | 48385 | 225 | 11 | 0 | 196 | 29.83321503 | -99.82018052 | 2021-01-03 05:22:52 | Real, Texas, US |
2230134 | 2230134 | 2021-01-02 | US | Oregon | Lake | 41037 | 200 | 4 | 0 | 196 | 42.79246693 | -120.3850163 | 2021-01-03 05:22:52 | Lake, Oregon, US |
2229654 | 2229654 | 2021-01-02 | US | Nevada | Mineral | 32021 | 200 | 4 | 0 | 196 | 38.53841696 | -118.4344506 | 2021-01-03 05:22:52 | Mineral, Nevada, US |
2228111 | 2228111 | 2021-01-02 | US | Colorado | Baca | 8009 | 212 | 2 | 0 | 196 | 37.31940883 | -102.5603223 | 2021-01-03 05:22:52 | Baca, Colorado, US |
1140075 | 1140075 | 2021-01-01 | US | Texas | Real | 48385 | 225 | 11 | 0 | 196 | 29.83321503 | -99.82018052 | 2021-01-02 05:22:33 | Real, Texas, US |
3698681 | 3698681 | 2020-12-31 | US | Texas | Real | 48385 | 225 | 11 | 0 | 196 | 29.83321503 | -99.82018052 | 2021-01-01 05:23:07 | Real, Texas, 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]);