johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where recovered = 2790 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2571701 | 2571701 | 2021-04-13 | Japan | Mie | 3034 | 74 | 2790 | 170 | 34.508018 | 136.376013 | 2021-04-14 04:20:41 | Mie, Japan | ||
1204082 | 1204082 | 2021-03-22 | Sierra Leone | 3948 | 79 | 2790 | 1079 | 8.460555000000001 | -11.779889 | 2021-03-23 05:26:18 | Sierra Leone | |||
3369604 | 3369604 | 2021-03-21 | Sierra Leone | 3948 | 79 | 2790 | 1079 | 8.460555000000001 | -11.779889 | 2021-03-22 05:25:43 | Sierra Leone | |||
1744814 | 1744814 | 2021-03-20 | Sierra Leone | 3948 | 79 | 2790 | 1079 | 8.460555000000001 | -11.779889 | 2021-03-21 05:25:44 | Sierra Leone | |||
3503371 | 3503371 | 2021-01-17 | Japan | Ibaraki | 3812 | 44 | 2790 | 978 | 36.303588 | 140.319591 | 2021-01-18 05:22:34 | Ibaraki, Japan | ||
864301 | 864301 | 2020-12-11 | Ukraine | Kirovohrad Oblast | 6921 | 194 | 2790 | 3937 | 48.5079 | 32.2623 | 2020-12-12 05:26:19 | Kirovohrad Oblast, Ukraine | ||
2919015 | 2919015 | 2020-11-04 | Colombia | Amazonas | 2940 | 120 | 2790 | 30 | -1.4429 | -71.5724 | 2020-11-05 06:05:03 | Amazonas, Colombia | ||
3184930 | 3184930 | 2020-07-28 | Italy | Abruzzo | 3369 | 472 | 2790 | 107 | 42.35122196 | 13.39843823 | 2020-07-29 04:35:11 | Abruzzo, Italy | ||
1510681 | 1510681 | 2020-06-22 | Russia | Novosibirsk Oblast | 5142 | 72 | 2790 | 2280 | 54.9720169 | 79.48139240000002 | 2020-06-23 04:33:22 | Novosibirsk Oblast, Russia | ||
2390114 | 2390114 | 2020-05-19 | Italy | Campania | 4707 | 399 | 2790 | 1518 | 40.83956555 | 14.25084984 | 2020-05-20 02:32:19 | Campania, Italy |
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]);