johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where recovered = 1885 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1125637 | 1125637 | 2021-06-18 | Japan | Toyama | 2000 | 37 | 1885 | 78 | 36.637464 | 137.26934599999998 | 2021-06-19 04:22:33 | Toyama, Japan | ||
3030137 | 3030137 | 2021-06-16 | Colombia | Guainia | 1951 | 22 | 1885 | 44 | 2.5854 | -68.5247 | 2021-06-17 04:22:36 | Guainia, Colombia | ||
2315167 | 2315167 | 2021-06-04 | Colombia | Vichada | 1947 | 31 | 1885 | 31 | 4.4234 | -69.2878 | 2021-06-05 04:23:03 | Vichada, Colombia | ||
3242150 | 3242150 | 2021-04-21 | China | Shanghai | 1950 | 7 | 1885 | 58 | 31.202 | 121.4491 | 2021-04-22 04:20:53 | Shanghai, China | ||
2020546 | 2020546 | 2021-04-20 | China | Shanghai | 1949 | 7 | 1885 | 57 | 31.202 | 121.4491 | 2021-04-21 04:21:14 | Shanghai, China | ||
352405 | 352405 | 2021-03-11 | Monaco | 2075 | 26 | 1885 | 164 | 43.7333 | 7.4167 | 2021-03-12 05:26:50 | Monaco | |||
3342216 | 3342216 | 2020-11-17 | Ukraine | Kirovohrad Oblast | 3753 | 125 | 1885 | 1743 | 48.5079 | 32.2623 | 2020-11-18 05:40:31 | Kirovohrad Oblast, Ukraine | ||
2918859 | 2918859 | 2020-11-14 | Malaysia | Negeri Sembilan | 3375 | 8 | 1885 | 1482 | 2.7258 | 101.9424 | 2020-11-15 05:26:53 | Negeri Sembilan, Malaysia | ||
2915516 | 2915516 | 2020-11-14 | Togo | 2651 | 61 | 1885 | 705 | 8.6195 | 0.8248 | 2020-11-15 05:26:53 | Togo | |||
2514167 | 2514167 | 2020-10-03 | Italy | Umbria | 2604 | 85 | 1885 | 634 | 43.10675841 | 12.38824698 | 2020-10-04 04:23:44 | Umbria, Italy | ||
1243806 | 1243806 | 2020-09-08 | Jordan | 2581 | 19 | 1885 | 677 | 31.24 | 36.51 | 2020-09-09 04:28:48 | Jordan | |||
837615 | 837615 | 2020-08-17 | Japan | Chiba | 2480 | 58 | 1885 | 537 | 35.510141 | 140.198917 | 2020-08-18 04:27:56 | Chiba, Japan | ||
2748423 | 2748423 | 2020-07-15 | Iceland | 1911 | 10 | 1885 | 16 | 64.9631 | -19.0208 | 2020-07-16 04:44:59 | Iceland | |||
3737739 | 3737739 | 2020-07-12 | Russia | Pskov Oblast | 3214 | 36 | 1885 | 1293 | 57.5358729 | 28.8586826 | 2020-07-13 04:43:04 | Pskov Oblast, Russia | ||
530333 | 530333 | 2020-07-04 | Sri Lanka | 2074 | 11 | 1885 | 178 | 7.873054 | 80.77179699999998 | 2020-07-05 04:33:46 | Sri Lanka | |||
1404367 | 1404367 | 2020-05-14 | Canada | British Columbia | 2392 | 135 | 1885 | 372 | 53.7267 | -127.6476 | 2020-05-15 02:33:02 | British Columbia, Canada |
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]);