johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where recovered = 3665 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- Azerbaijan 1
- Barbados 1
- Colombia 1
- Germany 1
- Hungary 1
- Luxembourg 1
- Mexico 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3129229 | 3129229 | 2021-04-18 | Barbados | 3781 | 44 | 3665 | 72 | 13.1939 | -59.5432 | 2021-04-19 04:20:57 | Barbados | |||
2812975 | 2812975 | 2020-09-25 | Russia | Novgorod Oblast | 5032 | 86 | 3665 | 1281 | 58.2843833 | 32.5169757 | 2020-09-26 04:23:00 | Novgorod Oblast, Russia | ||
2653614 | 2653614 | 2020-09-23 | Colombia | Choco | 3967 | 155 | 3665 | 147 | 5.2528 | -76.826 | 2020-09-24 04:23:00 | Choco, Colombia | ||
3161531 | 3161531 | 2020-09-06 | Germany | Brandenburg | 3927 | 169 | 3665 | 122 | 52.4125 | 12.5316 | 2020-09-07 04:28:30 | Brandenburg, Germany | ||
2299538 | 2299538 | 2020-08-22 | Mexico | Morelos | 4944 | 944 | 3665 | 335 | 18.6813 | -99.1013 | 2020-08-23 04:27:48 | Morelos, Mexico | ||
206188 | 206188 | 2020-08-19 | Hungary | 5002 | 609 | 3665 | 728 | 47.1625 | 19.5033 | 2020-08-20 04:27:43 | Hungary | |||
3867014 | 3867014 | 2020-06-03 | Azerbaijan | 6260 | 76 | 3665 | 2519 | 40.1431 | 47.5769 | 2020-06-04 02:33:14 | Azerbaijan | |||
1404593 | 1404593 | 2020-05-14 | Luxembourg | 3915 | 103 | 3665 | 147 | 49.8153 | 6.1296 | 2020-05-15 02:33:02 | Luxembourg |
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]);