johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where recovered = 1600 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
522555 | 522555 | 2021-06-09 | Australia | Queensland | 1642 | 7 | 1600 | 35 | -27.4698 | 153.0251 | 2021-06-10 04:23:17 | Queensland, Australia | ||
376179 | 376179 | 2020-11-06 | Italy | Valle d'Aosta | 3963 | 195 | 1600 | 2168 | 45.73750286 | 7.320149366 | 2020-11-07 05:24:52 | Valle d'Aosta, Italy | ||
8663 | 8663 | 2020-10-25 | Togo | 2200 | 52 | 1600 | 548 | 8.6195 | 0.8248 | 2020-10-26 04:25:02 | Togo | |||
1354588 | 1354588 | 2020-09-03 | Sierra Leone | 2035 | 71 | 1600 | 364 | 8.460555000000001 | -11.779889 | 2020-09-04 04:28:26 | Sierra Leone | |||
1105825 | 1105825 | 2020-09-02 | Sierra Leone | 2029 | 71 | 1600 | 358 | 8.460555000000001 | -11.779889 | 2020-09-03 04:28:22 | Sierra Leone | |||
586453 | 586453 | 2020-08-13 | Ukraine | Zhytomyr Oblast | 2266 | 49 | 1600 | 617 | 50.2547 | 28.6587 | 2020-08-14 04:51:19 | Zhytomyr Oblast, Ukraine | ||
1920699 | 1920699 | 2020-08-10 | Benin | 1936 | 38 | 1600 | 298 | 9.3077 | 2.3158 | 2020-08-11 04:35:08 | Benin | |||
3923508 | 3923508 | 2020-08-09 | Benin | 1936 | 38 | 1600 | 298 | 9.3077 | 2.3158 | 2020-08-10 04:34:55 | Benin | |||
371676 | 371676 | 2020-08-08 | Benin | 1936 | 38 | 1600 | 298 | 9.3077 | 2.3158 | 2020-08-09 04:34:54 | Benin | |||
458860 | 458860 | 2020-08-07 | Benin | 1936 | 38 | 1600 | 298 | 9.3077 | 2.3158 | 2020-08-08 04:34:53 | Benin | |||
3612545 | 3612545 | 2020-08-06 | Benin | 1936 | 38 | 1600 | 298 | 9.3077 | 2.3158 | 2020-08-07 04:35:11 | Benin | |||
3793375 | 3793375 | 2020-08-05 | Benin | 1936 | 38 | 1600 | 298 | 9.3077 | 2.3158 | 2020-08-06 04:35:02 | Benin | |||
1005329 | 1005329 | 2020-07-09 | Germany | Bremen | 1684 | 54 | 1600 | 37 | 53.0793 | 8.8017 | 2020-07-10 04:34:24 | Bremen, Germany | ||
2625426 | 2625426 | 2020-06-25 | Honduras | 15366 | 426 | 1600 | 13340 | 15.2 | -86.2419 | 2020-06-26 04:33:43 | Honduras |
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]);