johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where recovered = 5019 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
471425 | 471425 | 2021-02-19 | Japan | Ibaraki | 5497 | 102 | 5019 | 376 | 36.303588 | 140.319591 | 2021-02-20 05:22:51 | Ibaraki, Japan | ||
1591851 | 1591851 | 2021-02-05 | Malaysia | Kedah | 6158 | 18 | 5019 | 1121 | 6.1184 | 100.3685 | 2021-02-06 05:23:55 | Kedah, Malaysia | ||
3836417 | 3836417 | 2020-11-21 | Iceland | 5269 | 26 | 5019 | 224 | 64.9631 | -19.0208 | 2020-11-22 05:25:45 | Iceland | |||
1177306 | 1177306 | 2020-10-22 | China | Hong Kong | 5280 | 105 | 5019 | 156 | 22.3 | 114.2 | 2020-10-23 04:24:46 | Hong Kong, China | ||
1045806 | 1045806 | 2020-09-30 | Italy | P.A. Trento | 5992 | 406 | 5019 | 567 | 46.06893511 | 11.12123097 | 2020-10-01 04:23:42 | P.A. Trento, Italy | ||
3484382 | 3484382 | 2020-08-20 | Mexico | Chiapas | 6114 | 980 | 5019 | 115 | 16.7569 | -93.1292 | 2020-08-21 04:27:41 | Chiapas, Mexico | ||
2808272 | 2808272 | 2020-08-02 | Djibouti | 5161 | 59 | 5019 | 83 | 11.8251 | 42.5903 | 2020-08-03 04:34:35 | Djibouti | |||
2958362 | 2958362 | 2020-07-29 | Russia | Bashkortostan Republic | 6675 | 21 | 5019 | 1635 | 54.8573563 | 57.1439682 | 2020-07-30 04:35:05 | Bashkortostan Republic, Russia | ||
2700937 | 2700937 | 2020-06-24 | Russia | Tula Oblast | 6220 | 89 | 5019 | 1112 | 53.9570701 | 37.3690909 | 2020-06-25 05:26:54 | Tula 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]);