johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where recovered = 4035 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- Colombia 2
- Chile 1
- India 1
- Jordan 1
- Sierra Leone 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3632235 | 3632235 | 2021-07-14 | Sierra Leone | 6100 | 113 | 4035 | 1952 | 8.460555000000001 | -11.779889 | 2021-07-15 04:21:48 | Sierra Leone | |||
3958354 | 3958354 | 2021-06-26 | Colombia | Guaviare | 4208 | 74 | 4035 | 99 | 1.0654 | -73.2603 | 2021-06-27 04:21:39 | Guaviare, Colombia | ||
2915028 | 2915028 | 2020-11-14 | Colombia | Choco | 4354 | 163 | 4035 | 156 | 5.2528 | -76.82600000000002 | 2020-11-15 05:26:53 | Choco, Colombia | ||
2812798 | 2812798 | 2020-09-25 | Jordan | 7211 | 39 | 4035 | 3137 | 31.24 | 36.51 | 2020-09-26 04:23:00 | Jordan | |||
2958510 | 2958510 | 2020-07-29 | India | Jharkhand | 9861 | 98 | 4035 | 5728 | 23.654536 | 85.557631 | 2020-07-30 04:35:05 | Jharkhand, India | ||
418822 | 418822 | 2020-04-18 | Chile | 9730 | 126 | 4035 | 5569 | -35.6751 | -71.543 | 2020-04-18 22:32:28 | Chile |
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]);