johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where recovered = 11769 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2339251 | 2339251 | 2021-06-15 | Colombia | Putumayo | 12576 | 530 | 11769 | 277 | 0.436 | -75.5277 | 2021-06-16 04:22:32 | Putumayo, Colombia | ||
1563947 | 1563947 | 2021-06-14 | Colombia | Putumayo | 12576 | 530 | 11769 | 277 | 0.436 | -75.5277 | 2021-06-15 04:22:22 | Putumayo, Colombia | ||
738494 | 738494 | 2020-12-02 | Russia | Chuvashia Republic | 12797 | 290 | 11769 | 738 | 55.4259922 | 47.0849429 | 2020-12-03 05:28:22 | Chuvashia Republic, Russia | ||
3781664 | 3781664 | 2020-10-13 | Burma | 30437 | 693 | 11769 | 17975 | 21.9162 | 95.956 | 2020-10-14 04:24:05 | Burma | |||
3045686 | 3045686 | 2020-07-02 | Denmark | 12815 | 606 | 11769 | 440 | 56.2639 | 9.5018 | 2020-07-03 04:33:54 | Denmark | |||
3683070 | 3683070 | 2020-06-18 | Serbia | 12616 | 258 | 11769 | 589 | 44.0165 | 21.0059 | 2020-06-19 04:33:17 | Serbia |
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]);