daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where active = 6230 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-09-18 | Malaysia | W.P. Kuala Lumpur | 182480 | 2303 | 173947 | 6230 | 3.139 | 101.6869 | 2021-09-19 04:21:34 | W.P. Kuala Lumpur, Malaysia | ||
2021-04-30 | Italy | Basilicata | 23956 | 534 | 17192 | 6230 | 40.63947052 | 15.80514834 | 2021-05-01 04:20:47 | Basilicata, Italy | ||
2021-02-23 | US | Georgia | Bulloch | 13031 | 6318 | 88 | 0 | 6230 | 32.39577406 | -81.74811421 | 2021-02-24 05:29:16 | Bulloch, Georgia, US |
2021-02-17 | Sweden | Jamtland Harjedalen | 6343 | 113 | 0 | 6230 | 63.1712 | 14.9592 | 2021-02-18 05:22:58 | Jamtland Harjedalen, Sweden | ||
2021-01-28 | India | Uttar Pradesh | 599624 | 8642 | 584752 | 6230 | 26.925425 | 80.560982 | 2021-01-29 05:22:23 | Uttar Pradesh, India | ||
2021-01-05 | US | Texas | Walker | 48471 | 7254 | 89 | 0 | 6230 | 30.73872995 | -95.57440968 | 2021-01-06 05:22:16 | Walker, Texas, US |
2020-12-13 | US | Georgia | Paulding | 13223 | 6321 | 91 | 0 | 6230 | 33.91969522 | -84.86848792 | 2020-12-14 05:26:27 | Paulding, Georgia, US |
2020-11-05 | Canada | Alberta | 30447 | 343 | 23874 | 6230 | 53.9333 | -116.5765 | 2020-11-06 05:24:55 | Alberta, Canada | ||
2020-10-20 | Russia | Arkhangelsk Oblast | 17351 | 271 | 10850 | 6230 | 63.5589686 | 43.1221646 | 2020-10-21 04:24:14 | Arkhangelsk Oblast, Russia | ||
2020-10-17 | India | Punjab | 127154 | 3999 | 116925 | 6230 | 30.841465000000003 | 75.40879 | 2020-10-18 04:24:25 | Punjab, India | ||
2020-08-05 | US | Louisiana | Caddo | 22017 | 6516 | 286 | 0 | 6230 | 32.57991587 | -93.88375652 | 2020-08-06 04:35:02 | Caddo, Louisiana, US |
2020-07-22 | Moldova | 21798 | 712 | 14856 | 6230 | 47.4116 | 28.3699 | 2020-07-23 05:15:04 | Moldova | |||
2020-07-20 | US | Florida | Osceola | 12097 | 6268 | 38 | 0 | 6230 | 28.06312234 | -81.14882926 | 2020-07-21 04:38:46 | Osceola, Florida, US |
2020-06-16 | US | Pennsylvania | Delaware | 42045 | 6852 | 622 | 0 | 6230 | 39.91680171 | -75.40243663 | 2020-06-17 04:33:21 | Delaware, Pennsylvania, US |
2020-06-15 | US | New York | Erie | 36029 | 6817 | 587 | 0 | 6230 | 42.76249024 | -78.73063652 | 2020-06-16 04:33:09 | Erie, New York, US |
2020-06-11 | US | Tennessee | Shelby | 47157 | 6406 | 135 | 0 | 6230 | 35.1864775 | -89.89692423 | 2020-06-12 05:09:52 | Shelby, Tennessee, US |
2020-04-06 | US | California | Los Angeles | 6037 | 6377 | 147 | 0 | 6230 | 34.30828379 | -118.2282411 | 4/6/20 23:22 | Los Angeles, California, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;