johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where recovered = 5199 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
579101 | 579101 | 2021-07-13 | Saint Lucia | 5430 | 86 | 5199 | 145 | 13.9094 | -60.9789 | 2021-07-14 04:21:35 | Saint Lucia | |||
2295587 | 2295587 | 2021-06-24 | Niger | 5475 | 193 | 5199 | 83 | 17.607789 | 8.081666 | 2021-06-25 04:21:33 | Niger | |||
2423027 | 2423027 | 2021-06-23 | Niger | 5472 | 193 | 5199 | 80 | 17.607789 | 8.081666 | 2021-06-24 04:21:55 | Niger | |||
3054333 | 3054333 | 2021-05-13 | Pakistan | Gilgit-Baltistan | 5414 | 107 | 5199 | 108 | 35.792146 | 74.982138 | 2021-05-14 04:20:41 | Gilgit-Baltistan, Pakistan | ||
1203845 | 1203845 | 2021-03-22 | Japan | Shizuoka | 5500 | 114 | 5199 | 187 | 34.916975 | 138.40778400000002 | 2021-03-23 05:26:18 | Shizuoka, Japan | ||
3777760 | 3777760 | 2020-12-27 | Colombia | Putumayo | 5791 | 239 | 5199 | 353 | 0.436 | -75.5277 | 2020-12-28 05:22:06 | Putumayo, Colombia | ||
2606245 | 2606245 | 2020-09-24 | Russia | Mordovia Republic | 6220 | 40 | 5199 | 981 | 54.4419829 | 44.4661144 | 2020-09-25 04:23:00 | Mordovia Republic, Russia | ||
3205268 | 3205268 | 2020-07-18 | India | Kerala | 11659 | 40 | 5199 | 6420 | 10.450898 | 76.405749 | 2020-07-19 04:34:58 | Kerala, India | ||
3491442 | 3491442 | 2020-07-13 | Russia | Novosibirsk Oblast | 7386 | 146 | 5199 | 2041 | 54.9720169 | 79.48139240000002 | 2020-07-14 04:34:46 | Novosibirsk Oblast, 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]);