johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where recovered = 1817 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- Russia 3
- Malaysia 2
- Sao Tome and Principe 2
- Bulgaria 1
- India 1
- Jordan 1
- Netherlands 1
- Uganda 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1732765 | 1732765 | 2021-03-14 | Sao Tome and Principe | 2078 | 32 | 1817 | 229 | 0.1864 | 6.6131 | 2021-03-15 05:25:51 | Sao Tome and Principe | |||
1580422 | 1580422 | 2021-03-13 | Sao Tome and Principe | 2078 | 32 | 1817 | 229 | 0.1864 | 6.6131 | 2021-03-14 05:25:37 | Sao Tome and Principe | |||
1528025 | 1528025 | 2021-02-09 | Netherlands | Sint Maarten | 1952 | 27 | 1817 | 108 | 18.0425 | -63.0548 | 2021-02-10 05:22:41 | Sint Maarten, Netherlands | ||
2410475 | 2410475 | 2020-12-23 | United Kingdom | Channel Islands | 0 | 0 | 1817 | 984 | 49.3723 | -2.3644 | 2020-12-24 05:23:04 | Channel Islands, United Kingdom | ||
2247055 | 2247055 | 2020-10-30 | Malaysia | Kedah | 2122 | 8 | 1817 | 297 | 6.1184 | 100.3685 | 2020-10-31 04:24:44 | Kedah, Malaysia | ||
213910 | 213910 | 2020-10-29 | Malaysia | Kedah | 2117 | 8 | 1817 | 292 | 6.1184 | 100.3685 | 2020-10-30 04:24:49 | Kedah, Malaysia | ||
3093609 | 3093609 | 2020-09-20 | Russia | Chechen Republic | 2378 | 40 | 1817 | 521 | 43.3976147 | 45.6985005 | 2020-09-21 04:23:00 | Chechen Republic, Russia | ||
1247361 | 1247361 | 2020-09-08 | Uganda | 3900 | 46 | 1817 | 2037 | 1.373333 | 32.290275 | 2020-09-09 04:28:48 | Uganda | |||
427385 | 427385 | 2020-09-07 | Jordan | 2478 | 17 | 1817 | 644 | 31.24 | 36.51 | 2020-09-08 04:28:25 | Jordan | |||
367315 | 367315 | 2020-07-16 | India | Goa | 3108 | 19 | 1817 | 1272 | 15.359682 | 74.057396 | 2020-07-17 04:34:50 | Goa, India | ||
2437979 | 2437979 | 2020-06-20 | Russia | Mordovia Republic | 2931 | 23 | 1817 | 1091 | 54.4419829 | 44.4661144 | 2020-06-21 04:33:19 | Mordovia Republic, Russia | ||
2386924 | 2386924 | 2020-06-16 | Bulgaria | 3453 | 181 | 1817 | 1455 | 42.7339 | 25.4858 | 2020-06-17 04:33:21 | Bulgaria | |||
2864177 | 2864177 | 2020-06-10 | Russia | Voronezh Oblast | 3527 | 17 | 1817 | 1693 | 50.9800393 | 40.15065070000001 | 2020-06-11 03:33:41 | Voronezh 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]);