daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where active = 6241 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-07 | Morocco | 537253 | 9341 | 521671 | 6241 | 31.7917 | -7.0926 | 2021-07-08 04:21:26 | Morocco | |||
2021-04-10 | India | Uttarakhand | 107479 | 1752 | 99486 | 6241 | 30.156447 | 79.197608 | 2021-04-11 04:20:56 | Uttarakhand, India | ||
2021-03-07 | Pakistan | Sindh | 259855 | 4426 | 249188 | 6241 | 26.009446 | 68.77680699999999 | 2021-03-08 05:24:48 | Sindh, Pakistan | ||
2021-03-05 | US | Kentucky | Bullitt | 21029 | 6290 | 49 | 0 | 6241 | 37.97162523 | -85.68955617 | 2021-03-06 04:23:41 | Bullitt, Kentucky, US |
2021-03-05 | US | Alabama | Autauga | 1001 | 6333 | 92 | 0 | 6241 | 32.53952745 | -86.64408227 | 2021-03-06 04:23:41 | Autauga, Alabama, US |
2021-02-07 | US | Indiana | Wayne | 18177 | 6421 | 180 | 0 | 6241 | 39.8633444 | -85.01044989 | 2021-02-08 05:22:39 | Wayne, Indiana, US |
2021-02-01 | US | Florida | Highlands | 12055 | 6504 | 263 | 0 | 6241 | 27.34254618 | -81.34071957 | 2021-02-02 05:22:49 | Highlands, Florida, US |
2021-01-08 | Germany | Schleswig-Holstein | 27542 | 520 | 21281 | 6241 | 54.2194 | 9.6961 | 2021-01-09 05:22:18 | Schleswig-Holstein, Germany | ||
2021-01-01 | US | Missouri | Clay | 29047 | 6339 | 98 | 0 | 6241 | 39.31132056 | -94.41850862 | 2021-01-02 05:22:33 | Clay, Missouri, US |
2020-12-29 | US | Illinois | Adams | 17001 | 6311 | 70 | 0 | 6241 | 39.98815591 | -91.18786813 | 2020-12-30 05:22:34 | Adams, Illinois, US |
2020-12-16 | India | Punjab | 161383 | 5135 | 150007 | 6241 | 30.841465000000003 | 75.40879 | 2020-12-17 05:28:12 | Punjab, India | ||
2020-11-30 | Korea, South | 34652 | 526 | 27885 | 6241 | 35.90775700000001 | 127.766922 | 2020-12-01 05:26:18 | Korea, South | |||
2020-11-29 | US | Georgia | Lowndes | 13185 | 6367 | 126 | 0 | 6241 | 30.83568832 | -83.27056716 | 2020-11-30 05:26:13 | Lowndes, Georgia, US |
2020-11-28 | US | Mississippi | Jackson | 28059 | 6360 | 119 | 0 | 6241 | 30.54020656 | -88.64184064 | 2020-11-29 05:25:55 | Jackson, Mississippi, US |
2020-11-14 | US | New Hampshire | Hillsborough | 33011 | 6569 | 328 | 0 | 6241 | 42.91537785 | -71.7200253 | 2020-11-15 05:26:53 | Hillsborough, New Hampshire, US |
2020-10-07 | US | Georgia | Cherokee | 13057 | 6335 | 94 | 0 | 6241 | 34.24393976 | -84.47431861 | 2020-10-08 04:23:56 | Cherokee, Georgia, US |
2020-09-10 | US | Kansas | Wyandotte | 20209 | 6360 | 119 | 0 | 6241 | 39.11727348 | -94.76378225 | 2020-09-11 04:46:23 | Wyandotte, Kansas, US |
2020-09-09 | US | Oregon | Multnomah | 41051 | 6365 | 124 | 0 | 6241 | 45.54747959 | -122.4169351 | 2020-09-10 04:29:01 | Multnomah, Oregon, US |
2020-09-01 | US | Missouri | St. Louis City | 29510 | 6452 | 211 | 0 | 6241 | 38.63555736 | -90.24349225 | 2020-09-02 04:28:25 | St. Louis City, Missouri, US |
2020-08-23 | US | Kansas | Sedgwick | 20173 | 6289 | 48 | 0 | 6241 | 37.6842718 | -97.4608198 | 2020-08-24 04:27:56 | Sedgwick, Kansas, US |
2020-07-27 | US | Florida | Volusia | 12127 | 6341 | 100 | 0 | 6241 | 29.05858895 | -81.18263252 | 2020-07-28 04:58:43 | Volusia, Florida, US |
2020-05-12 | US | Louisiana | Orleans | 22071 | 6718 | 477 | 0 | 6241 | 30.06971951 | -89.92660315 | 2020-05-13 03:32:26 | Orleans, Louisiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;