daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where recovered = 1642 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-21 | Netherlands | Bonaire, Sint Eustatius and Saba | 1683 | 17 | 1642 | 24 | 12.1784 | -68.2385 | 2021-07-22 04:21:19 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2021-07-20 | Netherlands | Bonaire, Sint Eustatius and Saba | 1683 | 17 | 1642 | 24 | 12.1784 | -68.2385 | 2021-07-21 04:21:40 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2021-04-22 | Canada | New Brunswick | 1823 | 34 | 1642 | 147 | 46.5653 | -66.4619 | 2021-04-23 04:20:52 | New Brunswick, Canada | ||
2020-12-23 | Japan | Port Quarantine | 1814 | 1 | 1642 | 171 | 2020-12-24 05:23:04 | Port Quarantine, Japan | ||||
2020-09-19 | Canada | Saskatchewan | 1787 | 24 | 1642 | 121 | 52.9399 | -106.4509 | 2020-09-20 04:22:00 | Saskatchewan, Canada | ||
2020-08-02 | Pakistan | Azad Jammu and Kashmir | 2086 | 54 | 1642 | 390 | 34.027401 | 73.947253 | 2020-08-03 04:34:35 | Azad Jammu and Kashmir, Pakistan | ||
2020-07-25 | China | Guangdong | 1672 | 8 | 1642 | 22 | 23.3417 | 113.4244 | 2020-07-26 04:35:00 | Guangdong, China | ||
2020-07-02 | Ukraine | Kiev | 5242 | 111 | 1642 | 3489 | 50.4501 | 30.5234 | 2020-07-03 04:33:54 | Kiev, Ukraine | ||
2020-07-02 | Mexico | Campeche | 2092 | 223 | 1642 | 227 | 19.8301 | -90.5349 | 2020-07-03 04:33:54 | Campeche, Mexico | ||
2020-06-23 | Ukraine | Chernivtsi Oblast | 4419 | 176 | 1642 | 2601 | 48.2917 | 25.9352 | 2020-06-24 04:33:28 | Chernivtsi Oblast, Ukraine | ||
2020-06-10 | Malaysia | Selangor | 1972 | 24 | 1642 | 306 | 3.0738 | 101.5183 | 2020-06-11 03:33:41 | Selangor, Malaysia | ||
2020-06-08 | Russia | Orenburg Oblast | 2397 | 8 | 1642 | 747 | 52.02692620000001 | 54.7276647 | 2020-06-09 03:33:03 | Orenburg Oblast, Russia | ||
2020-05-23 | Mexico | Sinaloa | 2438 | 380 | 1642 | 416 | 25.1721 | -107.4795 | 2020-05-24 02:32:43 | Sinaloa, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;