daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
23 rows where active = 6832 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-04 | India | Jharkhand | 340408 | 5034 | 328542 | 6832 | 23.654536 | 85.557631 | 2021-06-05 04:23:03 | Jharkhand, India | ||
2021-05-28 | Brazil | Acre | 82149 | 1655 | 73662 | 6832 | -9.0238 | -70.812 | 2021-05-29 04:20:41 | Acre, Brazil | ||
2021-03-05 | US | Virginia | Suffolk | 51800 | 6995 | 163 | 0 | 6832 | 36.70155394 | -76.63603554 | 2021-03-06 04:23:41 | Suffolk, Virginia, US |
2021-02-27 | Guatemala | 174335 | 6374 | 161129 | 6832 | 15.7835 | -90.2308 | 2021-02-28 05:22:20 | Guatemala | |||
2021-02-01 | Ukraine | Kharkiv Oblast | 77978 | 1374 | 69772 | 6832 | 49.9935 | 36.2304 | 2021-02-02 05:22:49 | Kharkiv Oblast, Ukraine | ||
2021-01-22 | US | Ohio | Muskingum | 39119 | 6939 | 107 | 0 | 6832 | 39.96575964 | -81.94363275 | 2021-01-23 05:22:03 | Muskingum, Ohio, US |
2021-01-21 | Venezuela | 122260 | 1129 | 114299 | 6832 | 6.4238 | -66.5897 | 2021-01-22 05:22:10 | Venezuela | |||
2021-01-17 | India | Chhattisgarh | 293501 | 3558 | 283111 | 6832 | 21.264705 | 82.035366 | 2021-01-18 05:22:34 | Chhattisgarh, India | ||
2021-01-15 | Italy | Basilicata | 12365 | 289 | 5244 | 6832 | 40.63947052 | 15.80514834 | 2021-01-16 05:22:40 | Basilicata, Italy | ||
2020-12-27 | US | Alabama | Houston | 1069 | 6895 | 63 | 0 | 6832 | 31.15197924 | -85.29939599 | 2020-12-28 05:22:06 | Houston, Alabama, US |
2020-12-13 | US | West Virginia | Kanawha | 54039 | 6998 | 166 | 0 | 6832 | 38.33860077 | -81.52857054 | 2020-12-14 05:26:27 | Kanawha, West Virginia, US |
2020-12-06 | US | Illinois | Macon | 17115 | 6977 | 145 | 0 | 6832 | 39.86064913 | -88.96342505 | 2020-12-07 05:26:14 | Macon, Illinois, US |
2020-12-02 | Ukraine | Rivne Oblast | 31798 | 394 | 24572 | 6832 | 50.6199 | 26.2516 | 2020-12-03 05:28:22 | Rivne Oblast, Ukraine | ||
2020-12-01 | Sweden | Halland | 6941 | 109 | 0 | 6832 | 56.8967 | 12.8034 | 2020-12-02 05:27:41 | Halland, Sweden | ||
2020-11-20 | US | Minnesota | Scott | 27139 | 6884 | 52 | 0 | 6832 | 44.6490231 | -93.53340251 | 2020-11-21 05:25:51 | Scott, Minnesota, US |
2020-11-16 | Russia | Saratov Oblast | 23785 | 191 | 16762 | 6832 | 51.6520555 | 46.86319520000001 | 2020-11-17 05:25:54 | Saratov Oblast, Russia | ||
2020-10-30 | US | Illinois | McHenry | 17111 | 6953 | 121 | 0 | 6832 | 42.32451172 | -88.45248227 | 2020-10-31 04:24:44 | McHenry, Illinois, US |
2020-10-24 | US | Virginia | Chesterfield | 51041 | 6934 | 102 | 0 | 6832 | 37.37373208 | -77.58680140000001 | 2020-10-25 04:24:36 | Chesterfield, Virginia, US |
2020-10-14 | Germany | Baden-Wurttemberg | 55639 | 1909 | 47737 | 6832 | 48.6616 | 9.3501 | 2020-10-15 04:24:28 | Baden-Wurttemberg, Germany | ||
2020-09-17 | US | Missouri | St. Charles | 29183 | 6940 | 108 | 0 | 6832 | 38.77875681 | -90.66662425 | 2020-09-18 05:05:00 | St. Charles, Missouri, US |
2020-09-11 | US | Florida | Lake | 12069 | 6972 | 140 | 0 | 6832 | 28.76202069 | -81.7125123 | 2020-09-12 04:25:05 | Lake, Florida, US |
2020-08-21 | US | Colorado | Adams | 8001 | 7673 | 207 | 0 | 6832 | 39.87432092 | -104.3362578 | 2020-08-22 04:27:49 | Adams, Colorado, US |
2020-07-01 | India | Unknown | 6832 | 0 | 0 | 6832 | 2020-07-02 04:33:46 | Unknown, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;