daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 6073 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-07-16 | Israel | 850104 | 6444 | 837587 | 6073 | 31.046051 | 34.851612 | 2021-07-17 04:22:22 | Israel | |||
2021-05-20 | India | Chandigarh | 57331 | 666 | 50592 | 6073 | 30.733839 | 76.76827800000002 | 2021-05-21 04:20:43 | Chandigarh, India | ||
2021-02-20 | US | Kentucky | Christian | 21047 | 6148 | 75 | 0 | 6073 | 36.89267803 | -87.49055367 | 2021-02-21 05:24:33 | Christian, Kentucky, US |
2021-01-15 | Afghanistan | 53831 | 2324 | 45434 | 6073 | 33.93911 | 67.709953 | 2021-01-16 05:22:40 | Afghanistan | |||
2021-01-11 | US | Texas | Angelina | 48005 | 5122 | 164 | 0 | 6073 | 31.25457347 | -94.60901487 | 2021-01-12 05:22:15 | Angelina, Texas, US |
2021-01-10 | Germany | Schleswig-Holstein | 28480 | 545 | 21997 | 6073 | 54.2194 | 9.6961 | 2021-01-11 05:21:50 | Schleswig-Holstein, Germany | ||
2020-12-31 | Brazil | Bahia | 493400 | 9129 | 478198 | 6073 | -12.5797 | -41.7007 | 2021-01-01 05:23:07 | Bahia, Brazil | ||
2020-12-20 | US | Wyoming | Natrona | 56025 | 6147 | 74 | 0 | 6073 | 42.96180148 | -106.797885 | 2020-12-21 05:27:58 | Natrona, Wyoming, US |
2020-12-16 | US | Connecticut | Litchfield | 9005 | 6270 | 197 | 0 | 6073 | 41.7937534 | -73.2451475 | 2020-12-17 05:28:12 | Litchfield, Connecticut, US |
2020-11-29 | Pakistan | Islamabad | 30123 | 314 | 23736 | 6073 | 33.665087 | 73.121219 | 2020-11-30 05:26:13 | Islamabad, Pakistan | ||
2020-11-28 | Italy | Basilicata | 7878 | 142 | 1663 | 6073 | 40.63947052 | 15.80514834 | 2020-11-29 05:25:55 | Basilicata, Italy | ||
2020-11-26 | US | Indiana | Vigo | 18167 | 6181 | 108 | 0 | 6073 | 39.42944561 | -87.39169027 | 2020-11-27 05:26:53 | Vigo, Indiana, US |
2020-11-19 | Russia | Saratov Oblast | 24469 | 197 | 18199 | 6073 | 51.6520555 | 46.86319520000001 | 2020-11-20 05:26:28 | Saratov Oblast, Russia | ||
2020-11-01 | US | Florida | Clay | 12019 | 6200 | 127 | 0 | 6073 | 29.98319144 | -81.85609986 | 2020-11-02 05:25:04 | Clay, Florida, US |
2020-10-11 | US | Mississippi | DeSoto | 28033 | 6148 | 75 | 0 | 6073 | 34.87625235 | -89.99091418 | 2020-10-12 04:23:45 | DeSoto, Mississippi, US |
2020-10-09 | Sudan | 13673 | 836 | 6764 | 6073 | 12.8628 | 30.2176 | 2020-10-10 04:23:57 | Sudan | |||
2020-09-11 | US | Pennsylvania | Berks | 42011 | 6458 | 385 | 0 | 6073 | 40.41570541 | -75.92457766 | 2020-09-12 04:25:05 | Berks, Pennsylvania, US |
2020-08-05 | US | Colorado | Adams | 8001 | 6867 | 191 | 0 | 6073 | 39.87432092 | -104.3362578 | 2020-08-06 04:35:02 | Adams, Colorado, US |
2020-07-26 | US | Texas | Denton | 48121 | 4566 | 49 | 0 | 6073 | 33.20521901 | -97.11691153 | 2020-07-27 04:35:02 | Denton, Texas, US |
2020-07-12 | Moldova | 19382 | 642 | 12667 | 6073 | 47.4116 | 28.3699 | 2020-07-13 04:43:04 | Moldova |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;