daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 6037 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-02-22 | US | Pennsylvania | Clearfield | 42033 | 6150 | 113 | 0 | 6037 | 41.00110782 | -78.47592663 | 2021-02-23 05:23:41 | Clearfield, Pennsylvania, US |
2021-02-04 | US | New Jersey | Warren | 34041 | 6238 | 201 | 0 | 6037 | 40.85951833 | -74.99556527 | 2021-02-05 05:22:38 | Warren, New Jersey, US |
2021-02-01 | US | Texas | Wise | 48497 | 6232 | 98 | 0 | 6037 | 33.21570665 | -97.65460265 | 2021-02-02 05:22:49 | Wise, Texas, US |
2021-01-31 | US | Texas | Wise | 48497 | 6232 | 98 | 0 | 6037 | 33.21570665 | -97.65460265 | 2021-02-01 05:22:53 | Wise, Texas, US |
2021-01-30 | US | Texas | Wise | 48497 | 6232 | 98 | 0 | 6037 | 33.21570665 | -97.65460265 | 2021-01-31 05:22:42 | Wise, Texas, US |
2021-01-26 | US | Pennsylvania | Somerset | 42111 | 6203 | 166 | 0 | 6037 | 39.97172723 | -79.02699593 | 2021-01-27 05:23:41 | Somerset, Pennsylvania, US |
2021-01-19 | US | Virginia | Hampton | 51650 | 6094 | 57 | 0 | 6037 | 37.03513786 | -76.35879121 | 2021-01-20 05:21:54 | Hampton, Virginia, US |
2021-01-16 | US | North Carolina | Moore | 37125 | 6117 | 80 | 0 | 6037 | 35.30885257 | -79.48474178 | 2021-01-17 05:22:17 | Moore, North Carolina, US |
2021-01-16 | US | Alabama | Talladega | 1121 | 6145 | 108 | 0 | 6037 | 33.37823223 | -86.16886178 | 2021-01-17 05:22:17 | Talladega, Alabama, US |
2021-01-10 | US | Missouri | Cass | 29037 | 6095 | 58 | 0 | 6037 | 38.64789422 | -94.353399 | 2021-01-11 05:21:50 | Cass, Missouri, US |
2020-12-18 | Italy | Basilicata | 9890 | 218 | 3635 | 6037 | 40.63947052 | 15.80514834 | 2020-12-19 05:27:52 | Basilicata, Italy | ||
2020-12-07 | Germany | Thuringen | 20979 | 424 | 14949 | 6037 | 51.011 | 10.8453 | 2020-12-08 05:27:42 | Thuringen, Germany | ||
2020-11-23 | US | Texas | Wichita | 48485 | 3364 | 104 | 0 | 6037 | 33.98842886 | -98.7041034 | 2020-11-24 05:27:31 | Wichita, Texas, US |
2020-11-01 | US | Illinois | Unassigned | 90017 | 6320 | 283 | 0 | 6037 | 42.36542373 | 0.0 | 2020-11-02 05:25:04 | Unassigned, Illinois, US |
2020-10-20 | US | Texas | Bell | 48027 | 6171 | 96 | 0 | 6037 | 31.03736027 | -97.4785025 | 2020-10-21 04:24:14 | Bell, Texas, US |
2020-09-03 | US | Alabama | Tuscaloosa | 1125 | 6128 | 91 | 0 | 6037 | 33.28726072 | -87.52556818 | 2020-09-04 04:28:26 | Tuscaloosa, Alabama, US |
2020-08-27 | US | Alabama | Madison | 1089 | 6082 | 45 | 0 | 6037 | 34.76327133 | -86.55069633 | 2020-08-28 04:28:11 | Madison, Alabama, US |
2020-08-21 | US | Delaware | Sussex | 10005 | 6235 | 198 | 0 | 6037 | 38.66143781 | -75.39031349 | 2020-08-22 04:27:49 | Sussex, Delaware, US |
2020-08-15 | US | Nevada | Washoe | 32031 | 6161 | 124 | 0 | 6037 | 40.66562265 | -119.6631594 | 2020-08-16 04:27:42 | Washoe, Nevada, US |
2020-06-05 | US | Michigan | Macomb | 26099 | 6903 | 866 | 0 | 6037 | 42.69158356 | -82.92752801 | 2020-06-06 02:33:00 | Macomb, Michigan, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;