johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where recovered = 4095 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3770208 | 3770208 | 2020-12-22 | Thailand | 5716 | 60 | 4095 | 1607 | 15.870032 | 100.992541 | 2020-12-23 05:22:03 | Thailand | |||
1177493 | 1177493 | 2020-10-22 | Jamaica | 8600 | 179 | 4095 | 4326 | 18.1096 | -77.2975 | 2020-10-23 04:24:46 | Jamaica | |||
2661768 | 2661768 | 2020-09-04 | Italy | Puglia | 5741 | 560 | 4095 | 1086 | 41.12559576 | 16.86736689 | 2020-09-05 04:28:19 | Puglia, Italy | ||
62099 | 62099 | 2020-07-23 | Ukraine | Rivne Oblast | 5303 | 91 | 4095 | 1117 | 50.6199 | 26.2516 | 2020-07-24 05:30:40 | Rivne Oblast, Ukraine | ||
845117 | 845117 | 2020-07-22 | Haiti | 7100 | 151 | 4095 | 2854 | 18.9712 | -72.2852 | 2020-07-23 05:15:04 | Haiti | |||
1707856 | 1707856 | 2020-07-21 | Haiti | 7063 | 146 | 4095 | 2822 | 18.9712 | -72.2852 | 2020-07-22 04:34:42 | Haiti | |||
2158558 | 2158558 | 2020-07-14 | Italy | Campania | 4779 | 432 | 4095 | 252 | 40.83956555 | 14.25084984 | 2020-07-15 04:34:39 | Campania, Italy | ||
3737599 | 3737599 | 2020-07-12 | India | Kerala | 7873 | 31 | 4095 | 3747 | 10.450898 | 76.405749 | 2020-07-13 04:43:04 | Kerala, India | ||
3435856 | 3435856 | 2020-07-11 | Italy | Campania | 4769 | 432 | 4095 | 242 | 40.83956555 | 14.25084984 | 2020-07-12 04:34:30 | Campania, Italy | ||
3867080 | 3867080 | 2020-06-03 | Iraq | 8168 | 256 | 4095 | 3817 | 33.223191 | 43.679291 | 2020-06-04 02:33:14 | Iraq | |||
3084899 | 3084899 | 2020-05-04 | Poland | 14006 | 698 | 4095 | 9213 | 51.9194 | 19.1451 | 2020-05-05 02:32:34 | Poland |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);