johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where recovered = 2068 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2716795 | 2716795 | 2021-06-10 | China | Shanghai | 2141 | 7 | 2068 | 66 | 31.202 | 121.4491 | 2021-06-11 04:23:20 | Shanghai, China | ||
2585756 | 2585756 | 2021-06-05 | Canada | New Brunswick | 2262 | 44 | 2068 | 150 | 46.5653 | -66.4619 | 2021-06-06 04:24:03 | New Brunswick, Canada | ||
3954537 | 3954537 | 2021-05-11 | Japan | Wakayama | 2389 | 34 | 2068 | 287 | 33.911879 | 135.505446 | 2021-05-12 04:21:29 | Wakayama, Japan | ||
530592 | 530592 | 2021-02-22 | Eritrea | 2703 | 7 | 2068 | 628 | 15.1794 | 39.7823 | 2021-02-23 05:23:41 | Eritrea | |||
275785 | 275785 | 2020-11-10 | Ukraine | Sevastopol* | 3190 | 79 | 2068 | 1043 | 44.6054 | 33.522 | 2020-11-11 05:25:30 | Sevastopol*, Ukraine | ||
2299586 | 2299586 | 2020-08-22 | Pakistan | Azad Jammu and Kashmir | 2241 | 61 | 2068 | 112 | 34.027401 | 73.947253 | 2020-08-23 04:27:48 | Azad Jammu and Kashmir, Pakistan | ||
2684843 | 2684843 | 2020-07-06 | India | Jharkhand | 2847 | 20 | 2068 | 759 | 23.654536 | 85.557631 | 2020-07-07 04:34:00 | Jharkhand, India | ||
3249324 | 3249324 | 2020-06-21 | Russia | Kirov Oblast | 2869 | 30 | 2068 | 771 | 57.9665589 | 49.4074599 | 2020-06-22 04:33:20 | Kirov Oblast, Russia | ||
1273472 | 1273472 | 2020-06-11 | Russia | Krasnoyarsk Krai | 5981 | 59 | 2068 | 3854 | 63.3233807 | 97.0979974 | 2020-06-12 05:09:52 | Krasnoyarsk Krai, Russia |
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]);