daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where active = 6147 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-06-05 | Italy | Toscana | 242216 | 6749 | 229320 | 6147 | 43.76923077 | 11.25588885 | 2021-06-06 04:24:03 | Toscana, Italy | ||
2021-03-19 | India | Gujarat | 283864 | 4437 | 273280 | 6147 | 22.694884 | 71.590923 | 2021-03-20 05:25:46 | Gujarat, India | ||
2021-03-04 | India | Karnataka | 953136 | 12350 | 934639 | 6147 | 14.70518 | 76.166436 | 2021-03-05 05:26:29 | Karnataka, India | ||
2021-02-15 | US | Washington | Whatcom | 53073 | 6225 | 78 | 0 | 6147 | 48.82227976 | -121.7490018 | 2021-02-16 05:24:38 | Whatcom, Washington, US |
2021-02-14 | US | Washington | Whatcom | 53073 | 6225 | 78 | 0 | 6147 | 48.82227976 | -121.7490018 | 2021-02-15 05:24:49 | Whatcom, Washington, US |
2021-02-13 | US | Washington | Whatcom | 53073 | 6225 | 78 | 0 | 6147 | 48.82227976 | -121.7490018 | 2021-02-14 05:23:43 | Whatcom, Washington, US |
2021-01-31 | US | Indiana | Wayne | 18177 | 6322 | 175 | 0 | 6147 | 39.8633444 | -85.01044989 | 2021-02-01 05:22:53 | Wayne, Indiana, US |
2021-01-14 | US | Kansas | Butler | 20015 | 6198 | 51 | 0 | 6147 | 37.78134351 | -96.83878537 | 2021-01-15 05:22:24 | Butler, Kansas, US |
2021-01-13 | US | Kansas | Butler | 20015 | 6198 | 51 | 0 | 6147 | 37.78134351 | -96.83878537 | 2021-01-14 05:22:32 | Butler, Kansas, US |
2020-12-28 | Ukraine | Khmelnytskyi Oblast | 38408 | 648 | 31613 | 6147 | 49.423 | 26.9871 | 2020-12-29 05:22:37 | Khmelnytskyi Oblast, Ukraine | ||
2020-12-14 | Italy | Basilicata | 9491 | 207 | 3137 | 6147 | 40.63947052 | 15.80514834 | 2020-12-15 05:26:38 | Basilicata, Italy | ||
2020-12-08 | Germany | Thuringen | 21438 | 452 | 15407 | 6147 | 51.011 | 10.8453 | 2020-12-09 05:28:01 | Thuringen, Germany | ||
2020-11-11 | Brazil | Rondonia | 73990 | 1486 | 66357 | 6147 | -11.5057 | -63.5806 | 2020-11-12 05:25:55 | Rondonia, Brazil | ||
2020-11-02 | US | South Carolina | Beaufort | 45013 | 6240 | 93 | 0 | 6147 | 32.39226291 | -80.72619758 | 2020-11-03 06:00:16 | Beaufort, South Carolina, US |
2020-10-19 | US | Alaska | Anchorage | 2020 | 6188 | 41 | 0 | 6147 | 61.14998174 | -149.14269860000005 | 2020-10-20 04:24:22 | Anchorage, Alaska, US |
2020-10-14 | US | Tennessee | Williamson | 47187 | 6198 | 47 | 0 | 6147 | 35.89099229 | -86.89281867 | 2020-10-15 04:24:28 | Williamson, Tennessee, US |
2020-10-13 | US | Georgia | Bibb | 13021 | 6335 | 188 | 0 | 6147 | 32.80904227 | -83.70489165 | 2020-10-14 04:24:05 | Bibb, Georgia, US |
2020-09-25 | US | California | Solano | 6095 | 6195 | 50 | 0 | 6147 | 38.26827353 | -121.9357113 | 2020-09-26 04:23:00 | Solano, California, US |
2020-09-20 | US | Arkansas | Benton | 5007 | 6226 | 79 | 0 | 6147 | 36.33644656 | -94.25680817 | 2020-09-21 04:23:00 | Benton, Arkansas, US |
2020-09-10 | US | Missouri | Jackson | 29095 | 6232 | 85 | 0 | 6147 | 39.01002188 | -94.34724536 | 2020-09-11 04:46:23 | Jackson, Missouri, US |
2020-08-30 | US | Texas | McLennan | 48309 | 3288 | 81 | 0 | 6147 | 31.55255453 | -97.20217694 | 2020-08-31 04:28:27 | McLennan, Texas, US |
2020-08-11 | US | Texas | Lubbock | 48303 | 2340 | 75 | 0 | 6147 | 33.61008596 | -101.8204789 | 2020-08-12 04:27:29 | Lubbock, Texas, US |
2020-07-14 | US | Texas | Galveston | 48167 | 5124 | 54 | 0 | 6147 | 29.40167322 | -94.90469073 | 2020-07-15 04:34:39 | Galveston, Texas, US |
2020-07-07 | Russia | Nizhny Novgorod Oblast | 19024 | 271 | 12606 | 6147 | 55.47180329999999 | 44.0911594 | 2020-07-08 05:33:48 | Nizhny Novgorod Oblast, Russia | ||
2020-06-12 | US | Pennsylvania | Delaware | 42045 | 6759 | 612 | 0 | 6147 | 39.91680171 | -75.40243663 | 2020-06-13 03:33:14 | Delaware, Pennsylvania, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;