daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
469 rows where active = 531 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 374
- Russia 16
- France 11
- Japan 9
- Chile 8
- Ukraine 7
- India 6
- Spain 4
- Andorra 3
- Colombia 2
- Latvia 2
- Lesotho 2
- Mexico 2
- Australia 1
- Cabo Verde 1
- Congo (Kinshasa) 1
- Cote d'Ivoire 1
- Cuba 1
- Eswatini 1
- Germany 1
- Guinea 1
- Italy 1
- Lebanon 1
- Luxembourg 1
- Malaysia 1
- Mali 1
- Malta 1
- Mongolia 1
- Netherlands 1
- Paraguay 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | Japan | Shiga | 6304 | 94 | 5679 | 531 | 35.21582700000001 | 136.138064 | 2021-08-05 04:21:51 | Shiga, Japan | ||
2021-07-21 | Italy | Basilicata | 27147 | 591 | 26025 | 531 | 40.63947052 | 15.80514834 | 2021-07-22 04:21:19 | Basilicata, Italy | ||
2021-07-21 | Chile | Los Rios | 47731 | 598 | 46602 | 531 | -40.231 | -72.3311 | 2021-07-22 04:21:19 | Los Rios, Chile | ||
2021-07-10 | Guinea | 24065 | 176 | 23358 | 531 | 9.9456 | -9.6966 | 2021-07-11 04:21:43 | Guinea | |||
2021-06-22 | Ukraine | Mykolaiv Oblast | 69775 | 1836 | 67408 | 531 | 46.975 | 31.9946 | 2021-06-23 04:21:46 | Mykolaiv Oblast, Ukraine | ||
2021-06-11 | Russia | Kurgan Oblast | 21711 | 430 | 20750 | 531 | 55.7655302 | 64.5632681 | 2021-06-12 04:22:22 | Kurgan Oblast, Russia | ||
2021-06-03 | Russia | Irkutsk Oblast | 70213 | 2480 | 67202 | 531 | 56.6370122 | 104.719221 | 2021-06-04 04:23:37 | Irkutsk Oblast, Russia | ||
2021-05-31 | Russia | Khanty-Mansi Autonomous Okrug | 57497 | 798 | 56168 | 531 | 61.0259025 | 69.0982628 | 2021-06-01 04:23:09 | Khanty-Mansi Autonomous Okrug, Russia | ||
2021-05-28 | Singapore | 61970 | 32 | 61407 | 531 | 1.2833 | 103.8333 | 2021-05-29 04:20:41 | Singapore | |||
2021-05-22 | India | Dadra and Nagar Haveli and Daman and Diu | 9925 | 4 | 9390 | 531 | 20.194742 | 73.080901 | 2021-05-23 04:20:51 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-05-15 | Japan | Kagoshima | 2842 | 28 | 2283 | 531 | 31.009484000000004 | 130.430665 | 2021-05-16 04:20:49 | Kagoshima, Japan | ||
2021-05-15 | France | Saint Barthelemy | 994 | 1 | 462 | 531 | 17.9 | -62.8333 | 2021-05-16 04:20:49 | Saint Barthelemy, France | ||
2021-05-14 | France | Saint Barthelemy | 994 | 1 | 462 | 531 | 17.9 | -62.8333 | 2021-05-15 04:20:58 | Saint Barthelemy, France | ||
2021-05-13 | France | Saint Barthelemy | 994 | 1 | 462 | 531 | 17.9 | -62.8333 | 2021-05-14 04:20:41 | Saint Barthelemy, France | ||
2021-05-12 | France | Saint Barthelemy | 994 | 1 | 462 | 531 | 17.9 | -62.8333 | 2021-05-13 04:20:51 | Saint Barthelemy, France | ||
2021-05-11 | France | Saint Barthelemy | 994 | 1 | 462 | 531 | 17.9 | -62.8333 | 2021-05-12 04:21:29 | Saint Barthelemy, France | ||
2021-05-10 | France | Saint Barthelemy | 994 | 1 | 462 | 531 | 17.9 | -62.8333 | 2021-05-11 04:20:41 | Saint Barthelemy, France | ||
2021-05-09 | France | Saint Barthelemy | 994 | 1 | 462 | 531 | 17.9 | -62.8333 | 2021-05-10 04:20:38 | Saint Barthelemy, France | ||
2021-05-08 | France | Saint Barthelemy | 994 | 1 | 462 | 531 | 17.9 | -62.8333 | 2021-05-09 04:20:35 | Saint Barthelemy, France | ||
2021-05-06 | Russia | Bryansk Oblast | 38595 | 311 | 37753 | 531 | 52.8873315 | 33.41585300000001 | 2021-05-07 04:20:40 | Bryansk Oblast, Russia | ||
2021-05-05 | Russia | Amur Oblast | 22364 | 285 | 21548 | 531 | 52.8032368 | 128.437295 | 2021-05-06 04:20:38 | Amur Oblast, Russia | ||
2021-04-24 | Malaysia | Negeri Sembilan | 18235 | 31 | 17673 | 531 | 2.7258 | 101.9424 | 2021-04-25 04:20:32 | Negeri Sembilan, Malaysia | ||
2021-04-17 | Ukraine | Sevastopol* | 13771 | 589 | 12651 | 531 | 44.6054 | 33.522 | 2021-04-18 04:20:41 | Sevastopol*, Ukraine | ||
2021-04-15 | Andorra | 12641 | 121 | 11989 | 531 | 42.5063 | 1.5218 | 2021-04-16 04:20:46 | Andorra | |||
2021-04-14 | Andorra | 12641 | 121 | 11989 | 531 | 42.5063 | 1.5218 | 2021-04-15 04:20:54 | Andorra | |||
2021-04-12 | Ukraine | Sevastopol* | 13632 | 582 | 12519 | 531 | 44.6054 | 33.522 | 2021-04-13 04:20:37 | Sevastopol*, Ukraine | ||
2021-04-11 | Russia | Kamchatka Krai | 14265 | 213 | 13521 | 531 | 57.1914882 | 160.03838190000005 | 2021-04-12 04:21:00 | Kamchatka Krai, Russia | ||
2021-04-09 | Russia | Smolensk Oblast | 28458 | 798 | 27129 | 531 | 55.03434960000001 | 33.0192065 | 2021-04-10 04:20:59 | Smolensk Oblast, Russia | ||
2021-04-05 | Malta | 29279 | 399 | 28349 | 531 | 35.9375 | 14.3754 | 2021-04-06 04:20:32 | Malta | |||
2021-03-28 | Andorra | 11850 | 115 | 11204 | 531 | 42.5063 | 1.5218 | 2021-03-29 04:28:35 | Andorra | |||
2021-03-25 | Japan | Okinawa | 8988 | 126 | 8331 | 531 | 25.768923 | 126.668016 | 2021-03-26 05:26:55 | Okinawa, Japan | ||
2021-03-06 | US | Oklahoma | Grant | 40053 | 538 | 7 | 0 | 531 | 36.796297 | -97.78638765 | 2021-03-07 05:21:54 | Grant, Oklahoma, US |
2021-03-06 | US | Oklahoma | Dewey | 40043 | 537 | 6 | 0 | 531 | 35.98772922 | -99.00730714 | 2021-03-07 05:21:54 | Dewey, Oklahoma, US |
2021-03-06 | US | Missouri | Maries | 29125 | 538 | 7 | 0 | 531 | 38.16193985 | -91.92249662 | 2021-03-07 05:21:54 | Maries, Missouri, US |
2021-03-06 | US | Indiana | Ohio | 18115 | 542 | 11 | 0 | 531 | 38.955305 | -84.96515993 | 2021-03-07 05:21:54 | Ohio, Indiana, US |
2021-03-05 | US | Texas | McCulloch | 48307 | 525 | 17 | 0 | 531 | 31.1925468 | -99.34682807 | 2021-03-06 04:23:41 | McCulloch, Texas, US |
2021-03-05 | US | Oklahoma | Grant | 40053 | 538 | 7 | 0 | 531 | 36.796297 | -97.78638765 | 2021-03-06 04:23:41 | Grant, Oklahoma, US |
2021-03-05 | US | Alabama | Choctaw | 1023 | 554 | 23 | 0 | 531 | 32.02227341 | -88.26564429999998 | 2021-03-06 04:23:41 | Choctaw, Alabama, US |
2021-03-04 | US | Oklahoma | Grant | 40053 | 538 | 7 | 0 | 531 | 36.796297 | -97.78638765 | 2021-03-05 05:26:29 | Grant, Oklahoma, US |
2021-02-28 | US | Missouri | Linn | 29115 | 543 | 12 | 0 | 531 | 39.87001769 | -93.10704106 | 2021-03-01 05:23:01 | Linn, Missouri, US |
2021-02-25 | India | Goa | 54771 | 791 | 53449 | 531 | 15.359682 | 74.057396 | 2021-02-26 05:22:40 | Goa, India | ||
2021-02-20 | US | Kentucky | Crittenden | 21055 | 548 | 17 | 0 | 531 | 37.35839237 | -88.08826090000002 | 2021-02-21 05:24:33 | Crittenden, Kentucky, US |
2021-02-19 | US | Kentucky | Crittenden | 21055 | 548 | 17 | 0 | 531 | 37.35839237 | -88.08826090000002 | 2021-02-20 05:22:51 | Crittenden, Kentucky, US |
2021-02-18 | US | Kansas | Greenwood | 20073 | 543 | 12 | 0 | 531 | 37.8774388 | -96.23250453 | 2021-02-19 05:24:16 | Greenwood, Kansas, US |
2021-02-17 | US | Kansas | Greenwood | 20073 | 543 | 12 | 0 | 531 | 37.8774388 | -96.23250453 | 2021-02-18 05:22:58 | Greenwood, Kansas, US |
2021-02-16 | US | Kansas | Greenwood | 20073 | 543 | 12 | 0 | 531 | 37.8774388 | -96.23250453 | 2021-02-17 05:23:10 | Greenwood, Kansas, US |
2021-02-15 | US | North Dakota | Foster | 38031 | 552 | 19 | 0 | 531 | 47.4571084 | -98.88279923 | 2021-02-16 05:24:38 | Foster, North Dakota, US |
2021-02-15 | US | Kansas | Greenwood | 20073 | 543 | 12 | 0 | 531 | 37.8774388 | -96.23250453 | 2021-02-16 05:24:38 | Greenwood, Kansas, US |
2021-02-14 | US | North Dakota | Foster | 38031 | 551 | 19 | 0 | 531 | 47.4571084 | -98.88279923 | 2021-02-15 05:24:49 | Foster, North Dakota, US |
2021-02-14 | US | Missouri | Ozark | 29153 | 543 | 12 | 0 | 531 | 36.64916339 | -92.44459066 | 2021-02-15 05:24:49 | Ozark, Missouri, US |
2021-02-14 | US | Iowa | Fremont | 19071 | 540 | 9 | 0 | 531 | 40.74542720000001 | -95.60129045 | 2021-02-15 05:24:49 | Fremont, Iowa, US |
2021-02-13 | US | North Dakota | Foster | 38031 | 550 | 19 | 0 | 531 | 47.4571084 | -98.88279923 | 2021-02-14 05:23:43 | Foster, North Dakota, US |
2021-02-13 | US | Iowa | Fremont | 19071 | 540 | 9 | 0 | 531 | 40.74542720000001 | -95.60129045 | 2021-02-14 05:23:43 | Fremont, Iowa, US |
2021-02-12 | US | North Dakota | Foster | 38031 | 550 | 19 | 0 | 531 | 47.4571084 | -98.88279923 | 2021-02-13 05:22:12 | Foster, North Dakota, US |
2021-02-12 | US | Iowa | Fremont | 19071 | 540 | 9 | 0 | 531 | 40.74542720000001 | -95.60129045 | 2021-02-13 05:22:12 | Fremont, Iowa, US |
2021-02-11 | US | Puerto Rico | Salinas | 72123 | 531 | 0 | 0 | 531 | 18.010386999999994 | -66.256592 | 2021-02-12 05:23:29 | Salinas, Puerto Rico, US |
2021-02-11 | US | Puerto Rico | Guayama | 72057 | 531 | 0 | 0 | 531 | 18.007516 | -66.13390799999999 | 2021-02-12 05:23:29 | Guayama, Puerto Rico, US |
2021-02-11 | US | North Dakota | Foster | 38031 | 550 | 19 | 0 | 531 | 47.4571084 | -98.88279923 | 2021-02-12 05:23:29 | Foster, North Dakota, US |
2021-02-11 | US | Kansas | Ottawa | 20143 | 542 | 11 | 0 | 531 | 39.13237408 | -97.65020313 | 2021-02-12 05:23:29 | Ottawa, Kansas, US |
2021-02-11 | US | Iowa | Fremont | 19071 | 540 | 9 | 0 | 531 | 40.74542720000001 | -95.60129045 | 2021-02-12 05:23:29 | Fremont, Iowa, US |
2021-02-10 | US | Puerto Rico | Salinas | 72123 | 531 | 0 | 0 | 531 | 18.010386999999994 | -66.256592 | 2021-02-11 05:23:55 | Salinas, Puerto Rico, US |
2021-02-10 | US | Puerto Rico | Guayama | 72057 | 531 | 0 | 0 | 531 | 18.007516 | -66.13390799999999 | 2021-02-11 05:23:55 | Guayama, Puerto Rico, US |
2021-02-10 | US | Kansas | Ottawa | 20143 | 542 | 11 | 0 | 531 | 39.13237408 | -97.65020313 | 2021-02-11 05:23:55 | Ottawa, Kansas, US |
2021-02-10 | US | Iowa | Fremont | 19071 | 540 | 9 | 0 | 531 | 40.74542720000001 | -95.60129045 | 2021-02-11 05:23:55 | Fremont, Iowa, US |
2021-02-10 | US | Idaho | Benewah | 16009 | 538 | 7 | 0 | 531 | 47.21754179 | -116.6586851 | 2021-02-11 05:23:55 | Benewah, Idaho, US |
2021-02-10 | Japan | Ibaraki | 5246 | 86 | 4629 | 531 | 36.303588 | 140.319591 | 2021-02-11 05:23:55 | Ibaraki, Japan | ||
2021-02-09 | US | Puerto Rico | Salinas | 72123 | 531 | 0 | 0 | 531 | 18.010386999999994 | -66.256592 | 2021-02-10 05:22:41 | Salinas, Puerto Rico, US |
2021-02-09 | US | Puerto Rico | Guayama | 72057 | 531 | 0 | 0 | 531 | 18.007516 | -66.13390799999999 | 2021-02-10 05:22:41 | Guayama, Puerto Rico, US |
2021-02-09 | US | Missouri | Ozark | 29153 | 542 | 11 | 0 | 531 | 36.64916339 | -92.44459066 | 2021-02-10 05:22:41 | Ozark, Missouri, US |
2021-02-09 | US | Idaho | Benewah | 16009 | 538 | 7 | 0 | 531 | 47.21754179 | -116.6586851 | 2021-02-10 05:22:41 | Benewah, Idaho, US |
2021-02-05 | US | Texas | Dallam | 48111 | 941 | 22 | 0 | 531 | 36.27787176 | -102.6020725 | 2021-02-06 05:23:55 | Dallam, Texas, US |
2021-02-04 | US | Kentucky | Trimble | 21223 | 534 | 3 | 0 | 531 | 38.61056487 | -85.33775972 | 2021-02-05 05:22:38 | Trimble, Kentucky, US |
2021-02-04 | Suriname | 8595 | 158 | 7906 | 531 | 3.9193 | -56.0278 | 2021-02-05 05:22:38 | Suriname | |||
2021-02-03 | US | Kentucky | Trimble | 21223 | 534 | 3 | 0 | 531 | 38.61056487 | -85.33775972 | 2021-02-04 05:22:26 | Trimble, Kentucky, US |
2021-02-01 | US | Texas | Mills | 48333 | 663 | 19 | 0 | 531 | 31.49557106 | -98.59272068 | 2021-02-02 05:22:49 | Mills, Texas, US |
2021-01-31 | US | Kansas | Mitchell | 20123 | 542 | 11 | 0 | 531 | 39.39331582 | -98.20906732 | 2021-02-01 05:22:53 | Mitchell, Kansas, US |
2021-01-31 | US | Kansas | Gray | 20069 | 543 | 12 | 0 | 531 | 37.73836671 | -100.4369088 | 2021-02-01 05:22:53 | Gray, Kansas, US |
2021-01-30 | US | Kansas | Mitchell | 20123 | 542 | 11 | 0 | 531 | 39.39331582 | -98.20906732 | 2021-01-31 05:22:42 | Mitchell, Kansas, US |
2021-01-30 | US | Kansas | Gray | 20069 | 543 | 12 | 0 | 531 | 37.73836671 | -100.4369088 | 2021-01-31 05:22:42 | Gray, Kansas, US |
2021-01-29 | US | Kansas | Mitchell | 20123 | 542 | 11 | 0 | 531 | 39.39331582 | -98.20906732 | 2021-01-30 05:22:49 | Mitchell, Kansas, US |
2021-01-29 | US | Kansas | Gray | 20069 | 543 | 12 | 0 | 531 | 37.73836671 | -100.4369088 | 2021-01-30 05:22:49 | Gray, Kansas, US |
2021-01-28 | US | Texas | Mitchell | 48335 | 1106 | 23 | 0 | 531 | 32.30623474 | -100.9212058 | 2021-01-29 05:22:23 | Mitchell, Texas, US |
2021-01-28 | US | Puerto Rico | Quebradillas | 72115 | 531 | 0 | 0 | 531 | 18.439692 | -66.926113 | 2021-01-29 05:22:23 | Quebradillas, Puerto Rico, US |
2021-01-28 | US | Michigan | Kalkaska | 26079 | 545 | 14 | 0 | 531 | 44.68512729 | -85.09085699 | 2021-01-29 05:22:23 | Kalkaska, Michigan, US |
2021-01-27 | US | Texas | Mitchell | 48335 | 1106 | 23 | 0 | 531 | 32.30623474 | -100.9212058 | 2021-01-28 05:22:24 | Mitchell, Texas, US |
2021-01-26 | US | West Virginia | Ritchie | 54085 | 539 | 8 | 0 | 531 | 39.18094587 | -81.06356878 | 2021-01-27 05:23:41 | Ritchie, West Virginia, US |
2021-01-26 | US | Texas | Mitchell | 48335 | 1104 | 21 | 0 | 531 | 32.30623474 | -100.9212058 | 2021-01-27 05:23:41 | Mitchell, Texas, US |
2021-01-25 | US | Michigan | Crawford | 26039 | 536 | 5 | 0 | 531 | 44.68255561 | -84.61006219 | 2021-01-26 05:22:02 | Crawford, Michigan, US |
2021-01-25 | US | Georgia | Crawford | 13079 | 541 | 10 | 0 | 531 | 32.71391813 | -83.98061238 | 2021-01-26 05:22:02 | Crawford, Georgia, US |
2021-01-24 | US | Wyoming | Platte | 56031 | 541 | 10 | 0 | 531 | 42.13299116 | -104.966331 | 2021-01-25 05:22:16 | Platte, Wyoming, US |
2021-01-24 | US | Puerto Rico | Yauco | 72153 | 531 | 0 | 0 | 531 | 18.080374 | -66.858814 | 2021-01-25 05:22:16 | Yauco, Puerto Rico, US |
2021-01-22 | US | West Virginia | Tyler | 54095 | 534 | 3 | 0 | 531 | 39.46811972 | -80.88772676 | 2021-01-23 05:22:03 | Tyler, West Virginia, US |
2021-01-22 | US | Kentucky | Gallatin | 21077 | 547 | 16 | 0 | 531 | 38.75398691 | -84.8558382 | 2021-01-23 05:22:03 | Gallatin, Kentucky, US |
2021-01-22 | US | California | Plumas | 6063 | 532 | 2 | 0 | 531 | 40.00355989 | -120.8395236 | 2021-01-23 05:22:03 | Plumas, California, US |
2021-01-20 | US | Texas | Hamilton | 48193 | 585 | 21 | 0 | 531 | 31.70470573 | -98.11083887 | 2021-01-21 05:22:01 | Hamilton, Texas, US |
2021-01-20 | US | Georgia | Wheeler | 13309 | 552 | 21 | 0 | 531 | 32.12009104 | -82.72574721 | 2021-01-21 05:22:01 | Wheeler, Georgia, US |
2021-01-17 | US | Virginia | Amelia | 51007 | 538 | 7 | 0 | 531 | 37.34081025 | -77.98584649 | 2021-01-18 05:22:34 | Amelia, Virginia, US |
2021-01-16 | US | Puerto Rico | Naguabo | 72103 | 531 | 0 | 0 | 531 | 18.230637 | -65.753897 | 2021-01-17 05:22:17 | Naguabo, Puerto Rico, US |
2021-01-14 | US | Missouri | Montgomery | 29139 | 540 | 9 | 0 | 531 | 38.94022054 | -91.47000721 | 2021-01-15 05:22:24 | Montgomery, Missouri, US |
2021-01-13 | Japan | Miyazaki | 1378 | 11 | 836 | 531 | 32.193203999999994 | 131.299374 | 2021-01-14 05:22:32 | Miyazaki, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;