daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,153 rows where active = 137 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,015
- Japan 26
- Italy 10
- Colombia 9
- Ukraine 9
- France 8
- India 7
- Russia 6
- Chile 4
- Sri Lanka 4
- Canada 3
- Malaysia 3
- Central African Republic 2
- China 2
- Cruise Ship 2
- Mexico 2
- New Zealand 2
- Pakistan 2
- Summer Olympics 2020 2
- United Kingdom 2
- Albania 1
- Andorra 1
- Burkina Faso 1
- Cote d'Ivoire 1
- Cyprus 1
- Denmark 1
- Eswatini 1
- Georgia 1
- Germany 1
- Iceland 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-02 | Ukraine | Ternopil Oblast | 70259 | 1204 | 68918 | 137 | 49.5535 | 25.5948 | 2021-08-03 04:21:39 | Ternopil Oblast, Ukraine | ||
2021-08-01 | Japan | Iwate | 2011 | 47 | 1827 | 137 | 39.593287 | 141.361777 | 2021-08-02 04:21:36 | Iwate, Japan | ||
2021-07-29 | Ukraine | Chernivtsi Oblast | 80140 | 1798 | 78205 | 137 | 48.2917 | 25.9352 | 2021-07-30 04:21:34 | Chernivtsi Oblast, Ukraine | ||
2021-07-27 | Summer Olympics 2020 | 137 | 0 | 0 | 137 | 35.6491 | 139.7737 | 2021-07-28 04:21:39 | Summer Olympics 2020 | |||
2021-07-26 | Summer Olympics 2020 | 137 | 0 | 0 | 137 | 35.6491 | 139.7737 | 2021-07-27 04:21:18 | Summer Olympics 2020 | |||
2021-07-23 | Japan | Shiga | 5757 | 92 | 5528 | 137 | 35.21582700000001 | 136.138064 | 2021-07-24 00:21:36 | Shiga, Japan | ||
2021-07-17 | Albania | 132665 | 2456 | 130072 | 137 | 41.1533 | 20.1683 | 2021-07-18 04:22:07 | Albania | |||
2021-07-09 | Ukraine | Volyn Oblast | 62219 | 1201 | 60881 | 137 | 50.7472 | 25.3254 | 2021-07-10 04:21:25 | Volyn Oblast, Ukraine | ||
2021-07-07 | Andorra | 14021 | 127 | 13757 | 137 | 42.5063 | 1.5218 | 2021-07-08 04:21:26 | Andorra | |||
2021-07-06 | Chile | Magallanes | 28982 | 464 | 28381 | 137 | -52.368 | -70.9863 | 2021-07-07 04:21:20 | Magallanes, Chile | ||
2021-07-01 | Italy | P.A. Bolzano | 73315 | 1180 | 71998 | 137 | 46.49933453 | 11.35662422 | 2021-07-02 04:21:47 | P.A. Bolzano, Italy | ||
2021-06-29 | Ukraine | Ivano-Frankivsk Oblast | 86654 | 2097 | 84420 | 137 | 48.9226 | 24.7111 | 2021-06-30 04:21:41 | Ivano-Frankivsk Oblast, Ukraine | ||
2021-06-26 | Russia | Jewish Autonomous Okrug | 4658 | 150 | 4371 | 137 | 48.57527615 | 132.66307460000002 | 2021-06-27 04:21:39 | Jewish Autonomous Okrug, Russia | ||
2021-06-12 | Colombia | Guaviare | 3546 | 60 | 3349 | 137 | 1.0654 | -73.2603 | 2021-06-13 04:22:44 | Guaviare, Colombia | ||
2021-06-09 | Saint Lucia | 5156 | 80 | 4939 | 137 | 13.9094 | -60.9789 | 2021-06-10 04:23:17 | Saint Lucia | |||
2021-06-09 | India | Dadra and Nagar Haveli and Daman and Diu | 10437 | 4 | 10296 | 137 | 20.194742 | 73.080901 | 2021-06-10 04:23:17 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-05-11 | Canada | New Brunswick | 2015 | 41 | 1837 | 137 | 46.5653 | -66.4619 | 2021-05-12 04:21:29 | New Brunswick, Canada | ||
2021-05-06 | Russia | Tyva Republic | 15839 | 202 | 15500 | 137 | 51.4017149 | 93.8582593 | 2021-05-07 04:20:40 | Tyva Republic, Russia | ||
2021-05-04 | Netherlands | Aruba | 10704 | 100 | 10467 | 137 | 12.5211 | -69.9683 | 2021-05-05 04:20:43 | Aruba, Netherlands | ||
2021-05-04 | Japan | Yamanashi | 1252 | 19 | 1096 | 137 | 35.612364 | 138.61148899999998 | 2021-05-05 04:20:43 | Yamanashi, Japan | ||
2021-05-02 | Canada | New Brunswick | 1939 | 37 | 1765 | 137 | 46.5653 | -66.4619 | 2021-05-03 04:20:39 | New Brunswick, Canada | ||
2021-04-30 | Colombia | San Andres y Providencia | 3647 | 52 | 3458 | 137 | 12.5567 | -81.7185 | 2021-05-01 04:20:47 | San Andres y Providencia, Colombia | ||
2021-04-28 | Japan | Miyazaki | 2172 | 22 | 2013 | 137 | 32.193203999999994 | 131.299374 | 2021-04-29 04:20:55 | Miyazaki, Japan | ||
2021-04-24 | Canada | New Brunswick | 1847 | 35 | 1675 | 137 | 46.5653 | -66.4619 | 2021-04-25 04:20:32 | New Brunswick, Canada | ||
2021-04-21 | Japan | Fukui | 779 | 31 | 611 | 137 | 35.846614 | 136.22465400000002 | 2021-04-22 04:20:53 | Fukui, Japan | ||
2021-04-14 | Japan | Hiroshima | 5330 | 107 | 5086 | 137 | 34.605309000000005 | 132.788719 | 2021-04-15 04:20:54 | Hiroshima, Japan | ||
2021-04-10 | Niger | 5072 | 188 | 4747 | 137 | 17.607789 | 8.081666 | 2021-04-11 04:20:56 | Niger | |||
2021-04-08 | Saint Vincent and the Grenadines | 1774 | 10 | 1627 | 137 | 12.9843 | -61.2872 | 2021-04-09 04:21:13 | Saint Vincent and the Grenadines | |||
2021-04-03 | Chile | Aysen | 3599 | 28 | 3434 | 137 | -45.9864 | -73.7669 | 2021-04-04 04:20:49 | Aysen, Chile | ||
2021-04-02 | Uganda | 40924 | 335 | 40452 | 137 | 1.373333 | 32.290275 | 2021-04-03 04:20:44 | Uganda | |||
2021-03-31 | Central African Republic | 5161 | 67 | 4957 | 137 | 6.6111 | 20.9394 | 2021-04-01 04:27:05 | Central African Republic | |||
2021-03-30 | Central African Republic | 5161 | 67 | 4957 | 137 | 6.6111 | 20.9394 | 2021-03-31 04:26:25 | Central African Republic | |||
2021-03-25 | Singapore | 60253 | 30 | 60086 | 137 | 1.2833 | 103.8333 | 2021-03-26 05:26:55 | Singapore | |||
2021-03-24 | Russia | Magadan Oblast | 8239 | 99 | 8003 | 137 | 62.48858785 | 153.9903764 | 2021-03-25 05:27:00 | Magadan Oblast, Russia | ||
2021-03-14 | Pakistan | Balochistan | 19220 | 202 | 18881 | 137 | 28.328492 | 65.898403 | 2021-03-15 05:25:51 | Balochistan, Pakistan | ||
2021-03-13 | Mauritius | 691 | 10 | 592 | 137 | -20.348404 | 57.552152 | 2021-03-14 05:25:37 | Mauritius | |||
2021-03-04 | US | South Dakota | Hyde | 46069 | 138 | 1 | 0 | 137 | 44.54747703 | -99.48572582 | 2021-03-05 05:26:29 | Hyde, South Dakota, US |
2021-03-03 | US | South Dakota | Hyde | 46069 | 138 | 1 | 0 | 137 | 44.54747703 | -99.48572582 | 2021-03-04 05:24:24 | Hyde, South Dakota, US |
2021-03-03 | US | Oregon | Wallowa | 41063 | 142 | 5 | 0 | 137 | 45.57894064 | -117.18353799999998 | 2021-03-04 05:24:24 | Wallowa, Oregon, US |
2021-03-02 | US | South Dakota | Hyde | 46069 | 138 | 1 | 0 | 137 | 44.54747703 | -99.48572582 | 2021-03-03 05:23:28 | Hyde, South Dakota, US |
2021-03-02 | India | Lakshadweep | 407 | 1 | 269 | 137 | 13.6999972 | 72.18333259999999 | 2021-03-03 05:23:28 | Lakshadweep, India | ||
2021-03-01 | US | South Dakota | Hyde | 46069 | 138 | 1 | 0 | 137 | 44.54747703 | -99.48572582 | 2021-03-02 05:23:30 | Hyde, South Dakota, US |
2021-02-28 | US | South Dakota | Hyde | 46069 | 138 | 1 | 0 | 137 | 44.54747703 | -99.48572582 | 2021-03-01 05:23:01 | Hyde, South Dakota, US |
2021-02-19 | US | Puerto Rico | Guanica | 72055 | 137 | 0 | 0 | 137 | 17.982429 | -66.91964300000001 | 2021-02-20 05:22:51 | Guanica, Puerto Rico, US |
2021-02-19 | US | Oregon | Wallowa | 41063 | 141 | 4 | 0 | 137 | 45.57894064 | -117.18353799999998 | 2021-02-20 05:22:51 | Wallowa, Oregon, US |
2021-02-18 | US | Puerto Rico | Guanica | 72055 | 137 | 0 | 0 | 137 | 17.982429 | -66.91964300000001 | 2021-02-19 05:24:16 | Guanica, Puerto Rico, US |
2021-02-17 | US | Puerto Rico | Guanica | 72055 | 137 | 0 | 0 | 137 | 17.982429 | -66.91964300000001 | 2021-02-18 05:22:58 | Guanica, Puerto Rico, US |
2021-02-16 | US | Puerto Rico | Guanica | 72055 | 137 | 0 | 0 | 137 | 17.982429 | -66.91964300000001 | 2021-02-17 05:23:10 | Guanica, Puerto Rico, US |
2021-02-15 | Japan | Nagasaki | 1585 | 36 | 1412 | 137 | 33.235712 | 129.608033 | 2021-02-16 05:24:38 | Nagasaki, Japan | ||
2021-02-14 | Japan | Hiroshima | 4950 | 99 | 4714 | 137 | 34.605309000000005 | 132.788719 | 2021-02-15 05:24:49 | Hiroshima, Japan | ||
2021-02-14 | Italy | Valle d'Aosta | 7909 | 413 | 7359 | 137 | 45.73750286 | 7.320149366 | 2021-02-15 05:24:49 | Valle d'Aosta, Italy | ||
2021-02-11 | Japan | Nara | 3167 | 42 | 2988 | 137 | 34.317451 | 135.871644 | 2021-02-12 05:23:29 | Nara, Japan | ||
2021-02-09 | US | Texas | Armstrong | 48011 | 214 | 6 | 0 | 137 | 34.96507426 | -101.3574874 | 2021-02-10 05:22:41 | Armstrong, Texas, US |
2021-02-09 | Japan | Ishikawa | 1580 | 60 | 1383 | 137 | 36.769464 | 136.771027 | 2021-02-10 05:22:41 | Ishikawa, Japan | ||
2021-02-09 | India | Meghalaya | 13893 | 148 | 13608 | 137 | 25.536934 | 91.278882 | 2021-02-10 05:22:41 | Meghalaya, India | ||
2021-02-07 | US | Missouri | Worth | 29227 | 138 | 1 | 0 | 137 | 40.47945588 | -94.42328751 | 2021-02-08 05:22:39 | Worth, Missouri, US |
2021-02-07 | India | Meghalaya | 13885 | 147 | 13601 | 137 | 25.536934 | 91.278882 | 2021-02-08 05:22:39 | Meghalaya, India | ||
2021-02-04 | US | Nebraska | Garfield | 31071 | 140 | 3 | 0 | 137 | 41.91428955 | -98.99111827 | 2021-02-05 05:22:38 | Garfield, Nebraska, US |
2021-02-03 | US | Nebraska | Garfield | 31071 | 140 | 3 | 0 | 137 | 41.91428955 | -98.99111827 | 2021-02-04 05:22:26 | Garfield, Nebraska, US |
2021-02-03 | Russia | Nenets Autonomous Okrug | 929 | 1 | 791 | 137 | 68.27557185 | 57.1686375 | 2021-02-04 05:22:26 | Nenets Autonomous Okrug, Russia | ||
2021-02-03 | Liechtenstein | 2582 | 53 | 2392 | 137 | 47.14 | 9.55 | 2021-02-04 05:22:26 | Liechtenstein | |||
2021-02-01 | Pakistan | Balochistan | 18830 | 196 | 18497 | 137 | 28.328492 | 65.898403 | 2021-02-02 05:22:49 | Balochistan, Pakistan | ||
2021-01-31 | Russia | Nenets Autonomous Okrug | 917 | 0 | 780 | 137 | 68.27557185 | 57.1686375 | 2021-02-01 05:22:53 | Nenets Autonomous Okrug, Russia | ||
2021-01-26 | US | New Mexico | Mora | 35033 | 143 | 6 | 0 | 137 | 36.01095101 | -104.9497716 | 2021-01-27 05:23:41 | Mora, New Mexico, US |
2021-01-26 | US | Georgia | Quitman | 13239 | 138 | 1 | 0 | 137 | 31.86728114 | -85.01773177 | 2021-01-27 05:23:41 | Quitman, Georgia, US |
2021-01-25 | US | New Mexico | Mora | 35033 | 143 | 6 | 0 | 137 | 36.01095101 | -104.9497716 | 2021-01-26 05:22:02 | Mora, New Mexico, US |
2021-01-22 | US | New Mexico | Mora | 35033 | 142 | 5 | 0 | 137 | 36.01095101 | -104.9497716 | 2021-01-23 05:22:03 | Mora, New Mexico, US |
2021-01-22 | US | Georgia | Quitman | 13239 | 138 | 1 | 0 | 137 | 31.86728114 | -85.01773177 | 2021-01-23 05:22:03 | Quitman, Georgia, US |
2021-01-22 | India | Chandigarh | 20664 | 332 | 20195 | 137 | 30.733839 | 76.76827800000002 | 2021-01-23 05:22:03 | Chandigarh, India | ||
2021-01-21 | US | New Mexico | Mora | 35033 | 142 | 5 | 0 | 137 | 36.01095101 | -104.9497716 | 2021-01-22 05:22:10 | Mora, New Mexico, US |
2021-01-20 | US | New Mexico | Mora | 35033 | 142 | 5 | 0 | 137 | 36.01095101 | -104.9497716 | 2021-01-21 05:22:01 | Mora, New Mexico, US |
2021-01-07 | Japan | Yamaguchi | 656 | 3 | 516 | 137 | 34.201190000000004 | 131.573293 | 2021-01-08 05:22:42 | Yamaguchi, Japan | ||
2021-01-06 | India | Nagaland | 11954 | 80 | 11737 | 137 | 26.06702 | 94.470302 | 2021-01-07 05:22:03 | Nagaland, India | ||
2021-01-02 | US | West Virginia | Calhoun | 54013 | 137 | 0 | 0 | 137 | 38.84315422 | -81.11934872 | 2021-01-03 05:22:52 | Calhoun, West Virginia, US |
2021-01-02 | US | Oregon | Harney | 41025 | 139 | 2 | 0 | 137 | 43.06422669 | -118.9666306 | 2021-01-03 05:22:52 | Harney, Oregon, US |
2021-01-01 | Chile | Aysen | 1588 | 15 | 1436 | 137 | -45.9864 | -73.7669 | 2021-01-02 05:22:33 | Aysen, Chile | ||
2020-12-28 | US | Texas | Kinney | 48271 | 154 | 3 | 0 | 137 | 29.34967888 | -100.4186638 | 2020-12-29 05:22:37 | Kinney, Texas, US |
2020-12-27 | US | Texas | Kinney | 48271 | 153 | 3 | 0 | 137 | 29.34967888 | -100.4186638 | 2020-12-28 05:22:06 | Kinney, Texas, US |
2020-12-26 | US | Alaska | Copper River | 2066 | 137 | 0 | 0 | 137 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2020-12-26 | US | Wyoming | Niobrara | 56027 | 139 | 2 | 0 | 137 | 43.05607708 | -104.4758896 | 2020-12-27 05:22:55 | Niobrara, Wyoming, US |
2020-12-26 | US | Texas | Kinney | 48271 | 153 | 3 | 0 | 137 | 29.34967888 | -100.4186638 | 2020-12-27 05:22:55 | Kinney, Texas, US |
2020-12-25 | US | Alaska | Copper River | 2066 | 137 | 0 | 0 | 137 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2020-12-25 | US | Texas | Kinney | 48271 | 150 | 3 | 0 | 137 | 29.34967888 | -100.4186638 | 2020-12-26 05:22:28 | Kinney, Texas, US |
2020-12-24 | US | Alaska | Copper River | 2066 | 137 | 0 | 0 | 137 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2020-12-24 | US | Texas | Kinney | 48271 | 145 | 3 | 0 | 137 | 29.34967888 | -100.4186638 | 2020-12-25 05:22:48 | Kinney, Texas, US |
2020-12-23 | US | Alaska | Copper River | 2066 | 137 | 0 | 0 | 137 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2020-12-23 | US | Texas | Kinney | 48271 | 141 | 3 | 0 | 137 | 29.34967888 | -100.4186638 | 2020-12-24 05:23:04 | Kinney, Texas, US |
2020-12-22 | US | Virginia | Rappahannock | 51157 | 139 | 2 | 0 | 137 | 38.68295619 | -78.15826963 | 2020-12-23 05:22:03 | Rappahannock, Virginia, US |
2020-12-22 | US | Virginia | Norton | 51720 | 138 | 1 | 0 | 137 | 36.93357076 | -82.62750411 | 2020-12-23 05:22:03 | Norton, Virginia, US |
2020-12-21 | US | Texas | Shackelford | 48417 | 129 | 1 | 0 | 137 | 32.73587756 | -99.35401337 | 2020-12-22 05:22:33 | Shackelford, Texas, US |
2020-12-20 | US | Texas | Shackelford | 48417 | 127 | 1 | 0 | 137 | 32.73587756 | -99.35401337 | 2020-12-21 05:27:58 | Shackelford, Texas, US |
2020-12-20 | US | Puerto Rico | Arroyo | 72015 | 137 | 0 | 0 | 137 | 17.998457000000005 | -66.056546 | 2020-12-21 05:27:58 | Arroyo, Puerto Rico, US |
2020-12-20 | US | Hawaii | Kauai | 15007 | 138 | 1 | 0 | 137 | 22.03935037 | -159.5966786 | 2020-12-21 05:27:58 | Kauai, Hawaii, US |
2020-12-19 | US | Texas | Shackelford | 48417 | 126 | 1 | 0 | 137 | 32.73587756 | -99.35401337 | 2020-12-20 05:27:32 | Shackelford, Texas, US |
2020-12-19 | US | Hawaii | Kauai | 15007 | 138 | 1 | 0 | 137 | 22.03935037 | -159.5966786 | 2020-12-20 05:27:32 | Kauai, Hawaii, US |
2020-12-18 | US | Virginia | King and Queen | 51097 | 139 | 2 | 0 | 137 | 37.71044922 | -76.88689628 | 2020-12-19 05:27:52 | King and Queen, Virginia, US |
2020-12-18 | US | Texas | Shackelford | 48417 | 126 | 1 | 0 | 137 | 32.73587756 | -99.35401337 | 2020-12-19 05:27:52 | Shackelford, Texas, US |
2020-12-18 | US | Colorado | Ouray | 8091 | 154 | 3 | 0 | 137 | 38.14717457 | -107.7675136 | 2020-12-19 05:27:52 | Ouray, Colorado, US |
2020-12-17 | US | Texas | Shackelford | 48417 | 126 | 1 | 0 | 137 | 32.73587756 | -99.35401337 | 2020-12-18 05:28:18 | Shackelford, Texas, US |
2020-12-17 | US | Puerto Rico | Jayuya | 72073 | 137 | 0 | 0 | 137 | 18.211446 | -66.58878 | 2020-12-18 05:28:18 | Jayuya, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;