daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

9 rows where active = 11337 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

country_or_region 7

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-06-30 Rwanda       39047 438 27272 11337 -1.9403 29.8739 2021-07-01 04:21:19 Rwanda
2021-06-17 Brazil Goias     651369 18351 619681 11337 -15.827 -49.8362 2021-06-18 04:22:16 Goias, Brazil
2021-04-25 Canada Quebec     345301 10878 323086 11337 52.9399 -73.5491 2021-04-26 04:21:04 Quebec, Canada
2021-02-18 Panama       334463 5694 317432 11337 8.538 -80.7821 2021-02-19 05:24:16 Panama
2021-02-04 US Ohio Clark 39023 11599 262 0 11337 39.91592258 -83.78498252 2021-02-05 05:22:38 Clark, Ohio, US
2020-12-29 US Florida Bay 12005 11540 203 0 11337 30.26548745 -85.62122584 2020-12-30 05:22:34 Bay, Florida, US
2020-11-29 Italy P.A. Bolzano     23594 530 11727 11337 46.49933453 11.35662422 2020-11-30 05:26:13 P.A. Bolzano, Italy
2020-10-03 Burma       16503 371 4795 11337 21.9162 95.956 2020-10-04 04:23:44 Burma
2020-09-22 US New York Orange 36071 11835 498 0 11337 41.40337468 -74.30240757 2020-09-23 04:23:00 Orange, New York, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;