johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where recovered = 4832 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903821 | 3903821 | 2021-07-31 | Colombia | Guaviare | 5009 | 90 | 4832 | 87 | 1.0654 | -73.2603 | 2021-08-01 04:21:50 | Guaviare, Colombia | ||
3385237 | 3385237 | 2021-07-29 | Colombia | Guaviare | 4998 | 88 | 4832 | 78 | 1.0654 | -73.2603 | 2021-07-30 04:21:34 | Guaviare, Colombia | ||
20141 | 20141 | 2021-05-28 | Canada | Nova Scotia | 5497 | 80 | 4832 | 585 | 44.682 | -63.7443 | 2021-05-29 04:20:41 | Nova Scotia, Canada | ||
1936593 | 1936593 | 2021-02-23 | Pakistan | Gilgit-Baltistan | 4954 | 102 | 4832 | 20 | 35.792146 | 74.982138 | 2021-02-24 05:29:16 | Gilgit-Baltistan, Pakistan | ||
2541386 | 2541386 | 2021-01-07 | Italy | Basilicata | 11471 | 269 | 4832 | 6370 | 40.63947052 | 15.80514834 | 2021-01-08 05:22:42 | Basilicata, Italy | ||
272133 | 272133 | 2020-11-10 | Italy | Abruzzo | 15888 | 628 | 4832 | 10428 | 42.35122196 | 13.39843823 | 2020-11-11 05:25:30 | Abruzzo, Italy | ||
376252 | 376252 | 2020-11-06 | Malta | 6893 | 73 | 4832 | 1988 | 35.9375 | 14.3754 | 2020-11-07 05:24:52 | Malta | |||
821180 | 821180 | 2020-10-09 | Ukraine | Kharkiv Oblast | 23342 | 396 | 4832 | 18114 | 49.9935 | 36.2304 | 2020-10-10 04:23:57 | Kharkiv Oblast, Ukraine | ||
2689640 | 2689640 | 2020-10-08 | India | Meghalaya | 7261 | 60 | 4832 | 2369 | 25.536934 | 91.278882 | 2020-10-09 04:23:59 | Meghalaya, India | ||
3612595 | 3612595 | 2020-08-06 | Haiti | 7532 | 171 | 4832 | 2529 | 18.9712 | -72.2852 | 2020-08-07 04:35:11 | Haiti | |||
3793425 | 3793425 | 2020-08-05 | Haiti | 7511 | 166 | 4832 | 2513 | 18.9712 | -72.2852 | 2020-08-06 04:35:02 | Haiti | |||
98661 | 98661 | 2020-08-04 | Haiti | 7476 | 165 | 4832 | 2479 | 18.9712 | -72.2852 | 2020-08-05 04:34:43 | Haiti | |||
2740544 | 2740544 | 2020-08-03 | Haiti | 7468 | 165 | 4832 | 2471 | 18.9712 | -72.2852 | 2020-08-04 04:41:59 | Haiti | |||
2740336 | 2740336 | 2020-08-03 | Ukraine | Rivne Oblast | 6270 | 97 | 4832 | 1341 | 50.6199 | 26.2516 | 2020-08-04 04:41:59 | Rivne Oblast, Ukraine | ||
1196001 | 1196001 | 2020-06-17 | Brazil | Rondonia | 13567 | 361 | 4832 | 8375 | -11.5057 | -63.5806 | 2020-06-18 04:33:18 | Rondonia, Brazil |
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]);