daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,439 rows where active = 108 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,237
- Japan 49
- Canada 9
- Colombia 9
- France 8
- India 8
- Russia 8
- Germany 7
- Malaysia 7
- Ukraine 7
- Georgia 6
- Pakistan 6
- Burkina Faso 5
- Italy 5
- China 4
- Liechtenstein 3
- Mexico 3
- Netherlands 3
- Vietnam 3
- Afghanistan 2
- Burma 2
- Chile 2
- Comoros 2
- Djibouti 2
- Jordan 2
- Malta 2
- New Zealand 2
- Rwanda 2
- Singapore 2
- Thailand 2
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-31 | Japan | Yamaguchi | 3297 | 80 | 3109 | 108 | 34.201190000000004 | 131.573293 | 2021-08-01 04:21:50 | Yamaguchi, Japan | ||
2021-07-30 | Japan | Oita | 3635 | 64 | 3463 | 108 | 33.200697 | 131.43323999999998 | 2021-07-31 04:21:35 | Oita, Japan | ||
2021-07-30 | Japan | Kochi | 2073 | 29 | 1936 | 108 | 33.422519 | 133.367307 | 2021-07-31 04:21:35 | Kochi, Japan | ||
2021-07-28 | Germany | Brandenburg | 109125 | 3817 | 105200 | 108 | 52.4125 | 12.5316 | 2021-07-29 04:21:33 | Brandenburg, Germany | ||
2021-07-26 | Japan | Yamanashi | 2279 | 21 | 2150 | 108 | 35.612364 | 138.61148899999998 | 2021-07-27 04:21:18 | Yamanashi, Japan | ||
2021-07-21 | Japan | Wakayama | 2759 | 49 | 2602 | 108 | 33.911879 | 135.505446 | 2021-07-22 04:21:19 | Wakayama, Japan | ||
2021-07-18 | Italy | Molise | 13821 | 492 | 13221 | 108 | 41.55774754 | 14.65916051 | 2021-07-19 04:21:24 | Molise, Italy | ||
2021-07-17 | Japan | Hiroshima | 11647 | 178 | 11361 | 108 | 34.605309000000005 | 132.788719 | 2021-07-18 04:22:07 | Hiroshima, Japan | ||
2021-07-15 | India | Ladakh | 20234 | 206 | 19920 | 108 | 34.1526 | 77.5771 | 2021-07-16 04:21:22 | Ladakh, India | ||
2021-07-12 | Japan | Iwate | 1800 | 47 | 1645 | 108 | 39.593287 | 141.361777 | 2021-07-13 04:21:18 | Iwate, Japan | ||
2021-07-11 | Canada | Yukon | 461 | 5 | 348 | 108 | 64.2823 | -135.0 | 2021-07-12 04:21:34 | Yukon, Canada | ||
2021-07-10 | Canada | Yukon | 461 | 5 | 348 | 108 | 64.2823 | -135.0 | 2021-07-11 04:21:43 | Yukon, Canada | ||
2021-07-09 | Italy | P.A. Bolzano | 73369 | 1180 | 72081 | 108 | 46.49933453 | 11.35662422 | 2021-07-10 04:21:25 | P.A. Bolzano, Italy | ||
2021-07-09 | Colombia | San Andres y Providencia | 6516 | 128 | 6280 | 108 | 12.5567 | -81.7185 | 2021-07-10 04:21:25 | San Andres y Providencia, Colombia | ||
2021-07-09 | Canada | Yukon | 461 | 5 | 348 | 108 | 64.2823 | -135.0 | 2021-07-10 04:21:25 | Yukon, Canada | ||
2021-07-08 | Niger | 5529 | 194 | 5227 | 108 | 17.607789 | 8.081666 | 2021-07-09 04:21:21 | Niger | |||
2021-07-03 | Japan | Akita | 904 | 20 | 776 | 108 | 39.748679 | 140.408228 | 2021-07-04 04:21:38 | Akita, Japan | ||
2021-07-02 | Japan | Yamanashi | 2113 | 21 | 1984 | 108 | 35.612364 | 138.61148899999998 | 2021-07-03 04:21:37 | Yamanashi, Japan | ||
2021-06-28 | Canada | Yukon | 264 | 4 | 152 | 108 | 64.2823 | -135.0 | 2021-06-29 04:21:28 | Yukon, Canada | ||
2021-06-27 | Canada | Yukon | 264 | 4 | 152 | 108 | 64.2823 | -135.0 | 2021-06-28 04:21:29 | Yukon, Canada | ||
2021-06-26 | Canada | Yukon | 264 | 4 | 152 | 108 | 64.2823 | -135.0 | 2021-06-27 04:21:39 | Yukon, Canada | ||
2021-06-25 | Japan | Port Quarantine | 3092 | 5 | 2980 | 108 | 2021-06-26 04:21:43 | Port Quarantine, Japan | ||||
2021-06-23 | Liechtenstein | 3123 | 58 | 2957 | 108 | 47.14 | 9.55 | 2021-06-24 04:21:55 | Liechtenstein | |||
2021-06-22 | Japan | Yamaguchi | 3116 | 73 | 2935 | 108 | 34.201190000000004 | 131.573293 | 2021-06-23 04:21:46 | Yamaguchi, Japan | ||
2021-06-22 | Japan | Port Quarantine | 3078 | 4 | 2966 | 108 | 2021-06-23 04:21:46 | Port Quarantine, Japan | ||||
2021-06-21 | Japan | Kumamoto | 6439 | 113 | 6218 | 108 | 32.608154 | 130.74523100000002 | 2021-06-22 04:21:34 | Kumamoto, Japan | ||
2021-06-20 | Liechtenstein | 3121 | 58 | 2955 | 108 | 47.14 | 9.55 | 2021-06-21 04:21:41 | Liechtenstein | |||
2021-06-19 | Liechtenstein | 3121 | 58 | 2955 | 108 | 47.14 | 9.55 | 2021-06-20 04:21:48 | Liechtenstein | |||
2021-06-18 | India | Andaman and Nicobar Islands | 7363 | 127 | 7128 | 108 | 11.225999 | 92.968178 | 2021-06-19 04:22:33 | Andaman and Nicobar Islands, India | ||
2021-06-16 | Japan | Kochi | 1689 | 23 | 1558 | 108 | 33.422519 | 133.367307 | 2021-06-17 04:22:36 | Kochi, Japan | ||
2021-06-09 | Japan | Iwate | 1534 | 46 | 1380 | 108 | 39.593287 | 141.361777 | 2021-06-10 04:23:17 | Iwate, Japan | ||
2021-06-07 | Japan | Wakayama | 2638 | 45 | 2485 | 108 | 33.911879 | 135.505446 | 2021-06-08 04:22:35 | Wakayama, Japan | ||
2021-06-07 | Japan | Iwate | 1510 | 46 | 1356 | 108 | 39.593287 | 141.361777 | 2021-06-08 04:22:35 | Iwate, Japan | ||
2021-06-06 | Japan | Wakayama | 2637 | 45 | 2484 | 108 | 33.911879 | 135.505446 | 2021-06-07 04:22:51 | Wakayama, Japan | ||
2021-06-05 | Japan | Wakayama | 2635 | 45 | 2482 | 108 | 33.911879 | 135.505446 | 2021-06-06 04:24:03 | Wakayama, Japan | ||
2021-06-04 | Japan | Kagawa | 2026 | 26 | 1892 | 108 | 34.217292 | 133.969047 | 2021-06-05 04:23:03 | Kagawa, Japan | ||
2021-05-30 | Canada | Newfoundland and Labrador | 1309 | 6 | 1195 | 108 | 53.1355 | -57.6604 | 2021-05-31 03:08:59 | Newfoundland and Labrador, Canada | ||
2021-05-25 | Russia | Mari El Republic | 13428 | 239 | 13081 | 108 | 56.5767504 | 47.8817512 | 2021-05-26 04:20:35 | Mari El Republic, Russia | ||
2021-05-25 | Pakistan | Gilgit-Baltistan | 5516 | 107 | 5301 | 108 | 35.792146 | 74.982138 | 2021-05-26 04:20:35 | Gilgit-Baltistan, Pakistan | ||
2021-05-25 | Fiji | 259 | 4 | 147 | 108 | -17.7134 | 178.065 | 2021-05-26 04:20:35 | Fiji | |||
2021-05-13 | Pakistan | Gilgit-Baltistan | 5414 | 107 | 5199 | 108 | 35.792146 | 74.982138 | 2021-05-14 04:20:41 | Gilgit-Baltistan, Pakistan | ||
2021-05-10 | Malaysia | W.P. Putrajaya | 1470 | 9 | 1353 | 108 | 2.9264 | 101.6964 | 2021-05-11 04:20:41 | W.P. Putrajaya, Malaysia | ||
2021-05-08 | Russia | Tyva Republic | 15845 | 202 | 15535 | 108 | 51.4017149 | 93.8582593 | 2021-05-09 04:20:35 | Tyva Republic, Russia | ||
2021-05-08 | Japan | Fukui | 945 | 33 | 804 | 108 | 35.846614 | 136.22465400000002 | 2021-05-09 04:20:35 | Fukui, Japan | ||
2021-05-06 | Japan | Fukui | 921 | 33 | 780 | 108 | 35.846614 | 136.22465400000002 | 2021-05-07 04:20:40 | Fukui, Japan | ||
2021-05-05 | Japan | Fukui | 915 | 33 | 774 | 108 | 35.846614 | 136.22465400000002 | 2021-05-06 04:20:38 | Fukui, Japan | ||
2021-05-04 | Japan | Kochi | 1090 | 20 | 962 | 108 | 33.422519 | 133.367307 | 2021-05-05 04:20:43 | Kochi, Japan | ||
2021-05-02 | Japan | Akita | 492 | 9 | 375 | 108 | 39.748679 | 140.408228 | 2021-05-03 04:20:39 | Akita, Japan | ||
2021-04-30 | Mauritius | 1206 | 16 | 1084 | 108 | -20.348404 | 57.552152 | 2021-05-01 04:20:47 | Mauritius | |||
2021-04-26 | Japan | Miyazaki | 2141 | 22 | 2011 | 108 | 32.193203999999994 | 131.299374 | 2021-04-27 04:20:52 | Miyazaki, Japan | ||
2021-04-18 | Pakistan | Gilgit-Baltistan | 5182 | 103 | 4971 | 108 | 35.792146 | 74.982138 | 2021-04-19 04:20:57 | Gilgit-Baltistan, Pakistan | ||
2021-04-10 | New Zealand | 2574 | 28 | 2440 | 108 | -40.9006 | 174.886 | 2021-04-11 04:20:56 | New Zealand | |||
2021-04-07 | India | Meghalaya | 14140 | 150 | 13882 | 108 | 25.536934 | 91.278882 | 2021-04-08 04:21:13 | Meghalaya, India | ||
2021-03-30 | Japan | Wakayama | 1273 | 18 | 1147 | 108 | 33.911879 | 135.505446 | 2021-03-31 04:26:25 | Wakayama, Japan | ||
2021-03-28 | United Kingdom | Turks and Caicos Islands | 2326 | 17 | 2201 | 108 | 21.694000000000006 | -71.7979 | 2021-03-29 04:28:35 | Turks and Caicos Islands, United Kingdom | ||
2021-03-28 | India | Ladakh | 9974 | 130 | 9736 | 108 | 34.1526 | 77.5771 | 2021-03-29 04:28:35 | Ladakh, India | ||
2021-03-22 | Japan | Yamagata | 662 | 16 | 538 | 108 | 38.448396 | 140.102154 | 2021-03-23 05:26:18 | Yamagata, Japan | ||
2021-03-18 | Singapore | 60152 | 30 | 60014 | 108 | 1.2833 | 103.8333 | 2021-03-19 05:26:09 | Singapore | |||
2021-03-06 | US | Montana | Powder River | 30075 | 114 | 6 | 0 | 108 | 45.39617714 | -105.636738 | 2021-03-07 05:21:54 | Powder River, Montana, US |
2021-03-05 | US | Montana | Powder River | 30075 | 114 | 6 | 0 | 108 | 45.39617714 | -105.636738 | 2021-03-06 04:23:41 | Powder River, Montana, US |
2021-03-05 | Singapore | 60007 | 29 | 59870 | 108 | 1.2833 | 103.8333 | 2021-03-06 04:23:41 | Singapore | |||
2021-03-04 | US | Montana | Powder River | 30075 | 114 | 6 | 0 | 108 | 45.39617714 | -105.636738 | 2021-03-05 05:26:29 | Powder River, Montana, US |
2021-03-03 | US | Montana | Powder River | 30075 | 114 | 6 | 0 | 108 | 45.39617714 | -105.636738 | 2021-03-04 05:24:24 | Powder River, Montana, US |
2021-03-03 | Japan | Ishikawa | 1870 | 62 | 1700 | 108 | 36.769464 | 136.771027 | 2021-03-04 05:24:24 | Ishikawa, Japan | ||
2021-03-02 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-03-03 05:23:28 | Garden, Nebraska, US |
2021-03-02 | Pakistan | Balochistan | 19076 | 200 | 18768 | 108 | 28.328492 | 65.898403 | 2021-03-03 05:23:28 | Balochistan, Pakistan | ||
2021-03-01 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-03-02 05:23:30 | Garden, Nebraska, US |
2021-02-28 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-03-01 05:23:01 | Garden, Nebraska, US |
2021-02-28 | Trinidad and Tobago | 7713 | 139 | 7466 | 108 | 10.6918 | -61.2225 | 2021-03-01 05:23:01 | Trinidad and Tobago | |||
2021-02-27 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-28 05:22:20 | Garden, Nebraska, US |
2021-02-27 | Trinidad and Tobago | 7705 | 139 | 7458 | 108 | 10.6918 | -61.2225 | 2021-02-28 05:22:20 | Trinidad and Tobago | |||
2021-02-26 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-27 05:22:28 | Garden, Nebraska, US |
2021-02-26 | France | St Martin | 1519 | 12 | 1399 | 108 | 18.0708 | -63.0501 | 2021-02-27 05:22:28 | St Martin, France | ||
2021-02-25 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-26 05:22:40 | Garden, Nebraska, US |
2021-02-25 | France | St Martin | 1519 | 12 | 1399 | 108 | 18.0708 | -63.0501 | 2021-02-26 05:22:40 | St Martin, France | ||
2021-02-24 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-25 05:24:57 | Garden, Nebraska, US |
2021-02-24 | France | St Martin | 1519 | 12 | 1399 | 108 | 18.0708 | -63.0501 | 2021-02-25 05:24:57 | St Martin, France | ||
2021-02-23 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-24 05:29:16 | Garden, Nebraska, US |
2021-02-23 | France | St Martin | 1519 | 12 | 1399 | 108 | 18.0708 | -63.0501 | 2021-02-24 05:29:16 | St Martin, France | ||
2021-02-23 | Djibouti | 6052 | 63 | 5881 | 108 | 11.8251 | 42.5903 | 2021-02-24 05:29:16 | Djibouti | |||
2021-02-22 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-23 05:23:41 | Garden, Nebraska, US |
2021-02-21 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-22 05:24:21 | Garden, Nebraska, US |
2021-02-21 | Japan | Miyagi | 3563 | 24 | 3431 | 108 | 38.446859 | 140.927086 | 2021-02-22 05:24:21 | Miyagi, Japan | ||
2021-02-20 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-21 05:24:33 | Garden, Nebraska, US |
2021-02-20 | Japan | Fukushima | 1872 | 68 | 1696 | 108 | 37.378867 | 140.223295 | 2021-02-21 05:24:33 | Fukushima, Japan | ||
2021-02-19 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-20 05:22:51 | Garfield, Washington, US |
2021-02-19 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-20 05:22:51 | Garden, Nebraska, US |
2021-02-18 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-19 05:24:16 | Garfield, Washington, US |
2021-02-18 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-19 05:24:16 | Garden, Nebraska, US |
2021-02-17 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-18 05:22:58 | Garfield, Washington, US |
2021-02-17 | US | Nebraska | Garden | 31069 | 109 | 1 | 0 | 108 | 41.61703149 | -102.3313973 | 2021-02-18 05:22:58 | Garden, Nebraska, US |
2021-02-16 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-17 05:23:10 | Garfield, Washington, US |
2021-02-16 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-17 05:23:10 | Columbia, Washington, US |
2021-02-15 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-16 05:24:38 | Garfield, Washington, US |
2021-02-15 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-16 05:24:38 | Columbia, Washington, US |
2021-02-14 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-15 05:24:49 | Garfield, Washington, US |
2021-02-14 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-15 05:24:49 | Columbia, Washington, US |
2021-02-14 | China | Jilin | 573 | 3 | 462 | 108 | 43.6661 | 126.1923 | 2021-02-15 05:24:49 | Jilin, China | ||
2021-02-13 | US | Washington | Garfield | 53023 | 112 | 4 | 0 | 108 | 46.43197502 | -117.5454032 | 2021-02-14 05:23:43 | Garfield, Washington, US |
2021-02-13 | US | Washington | Columbia | 53013 | 112 | 4 | 0 | 108 | 46.29442881 | -117.9051983 | 2021-02-14 05:23:43 | Columbia, Washington, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;