johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where recovered = 696 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
742128 | 742128 | 2021-02-20 | China | Jiangsu | 703 | 0 | 696 | 7 | 32.9711 | 119.455 | 2021-02-21 05:24:33 | Jiangsu, China | ||
471226 | 471226 | 2021-02-19 | China | Jiangsu | 703 | 0 | 696 | 7 | 32.9711 | 119.455 | 2021-02-20 05:22:51 | Jiangsu, China | ||
2637724 | 2637724 | 2021-02-11 | Japan | Aomori | 794 | 15 | 696 | 83 | 40.781541 | 140.828896 | 2021-02-12 05:23:29 | Aomori, Japan | ||
2545081 | 2545081 | 2021-01-07 | Malaysia | Kelantan | 1085 | 9 | 696 | 380 | 6.1254 | 102.2381 | 2021-01-08 05:22:42 | Kelantan, Malaysia | ||
1062176 | 1062176 | 2021-01-04 | Taiwan* | 815 | 7 | 696 | 112 | 23.7 | 121.0 | 2021-01-05 05:21:49 | Taiwan* | |||
3480324 | 3480324 | 2020-10-26 | Japan | Ibaraki | 743 | 18 | 696 | 29 | 36.303588 | 140.319591 | 2020-10-27 04:24:45 | Ibaraki, Japan | ||
2191426 | 2191426 | 2020-10-21 | China | Sichuan | 733 | 3 | 696 | 34 | 30.6171 | 102.7103 | 2020-10-22 04:24:27 | Sichuan, China | ||
3801911 | 3801911 | 2020-10-05 | Japan | Ishikawa | 778 | 47 | 696 | 35 | 36.769464 | 136.771027 | 2020-10-06 04:23:33 | Ishikawa, Japan | ||
666004 | 666004 | 2020-09-16 | Belize | 1536 | 19 | 696 | 821 | 17.1899 | -88.4976 | 2020-09-17 04:22:00 | Belize | |||
2732623 | 2732623 | 2020-09-15 | Ukraine | Mykolaiv Oblast | 2114 | 51 | 696 | 1367 | 46.975 | 31.9946 | 2020-09-16 04:22:53 | Mykolaiv Oblast, Ukraine | ||
2740566 | 2740566 | 2020-08-03 | Liberia | 1207 | 77 | 696 | 434 | 6.4280550000000005 | -9.429499 | 2020-08-04 04:41:59 | Liberia | |||
442947 | 442947 | 2020-07-26 | Sao Tome and Principe | 863 | 14 | 696 | 153 | 0.18636 | 6.613081 | 2020-07-27 04:35:02 | Sao Tome and Principe | |||
1522419 | 1522419 | 2020-06-23 | Ukraine | Lviv Oblast | 4220 | 117 | 696 | 3407 | 49.8397 | 24.0297 | 2020-06-24 04:33:28 | Lviv Oblast, Ukraine | ||
2438308 | 2438308 | 2020-06-20 | Mauritania | 2813 | 108 | 696 | 2009 | 21.0079 | -10.9408 | 2020-06-21 04:33:19 | Mauritania | |||
1837247 | 1837247 | 2020-06-14 | Brazil | Piaui | 10357 | 374 | 696 | 9097 | -7.7183 | -42.7289 | 2020-06-15 03:33:14 | Piaui, Brazil | ||
3639110 | 3639110 | 2020-05-30 | Mali | 1250 | 76 | 696 | 478 | 17.570692 | -3.996166000000001 | 2020-05-31 02:32:45 | Mali | |||
2548173 | 2548173 | 2020-05-27 | Mexico | Coahuila | 965 | 72 | 696 | 197 | 27.0587 | -101.7068 | 2020-05-28 02:32:31 | Coahuila, Mexico | ||
3338113 | 3338113 | 2020-04-14 | Ecuador | 7603 | 369 | 696 | 6538 | -1.8312 | -78.1834 | 2020-04-14 23:33:12 | Ecuador |
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]);