johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where recovered = 6331 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3740939 | 3740939 | 2021-07-12 | Colombia | San Andres y Providencia | 6522 | 130 | 6331 | 61 | 12.5567 | -81.7185 | 2021-07-13 04:21:18 | San Andres y Providencia, Colombia | ||
1440603 | 1440603 | 2021-07-07 | Japan | Kumamoto | 6494 | 119 | 6331 | 44 | 32.608154 | 130.74523100000002 | 2021-07-08 04:21:26 | Kumamoto, Japan | ||
40105 | 40105 | 2021-04-12 | Malaysia | Kelantan | 7177 | 26 | 6331 | 820 | 6.1254 | 102.2381 | 2021-04-13 04:20:37 | Kelantan, Malaysia | ||
3153636 | 3153636 | 2021-01-27 | Japan | Okinawa | 7270 | 90 | 6331 | 849 | 25.768923 | 126.668016 | 2021-01-28 05:22:24 | Okinawa, Japan | ||
774054 | 774054 | 2021-01-12 | Bahamas | 8004 | 175 | 6331 | 1498 | 25.025885 | -78.035889 | 2021-01-13 05:22:15 | Bahamas | |||
189775 | 189775 | 2021-01-11 | Bahamas | 8004 | 175 | 6331 | 1498 | 25.025885 | -78.035889 | 2021-01-12 05:22:15 | Bahamas | |||
202253 | 202253 | 2020-12-25 | Italy | Valle d'Aosta | 7130 | 371 | 6331 | 428 | 45.73750286 | 7.320149366 | 2020-12-26 05:22:28 | Valle d'Aosta, Italy | ||
845459 | 845459 | 2020-12-12 | Eswatini | 6714 | 127 | 6331 | 256 | -26.5225 | 31.4659 | 2020-12-13 05:27:20 | Eswatini | |||
3866898 | 3866898 | 2020-06-03 | Russia | Saint Petersburg | 17069 | 240 | 6331 | 10498 | 59.9606739 | 30.158655100000004 | 2020-06-04 02:33:14 | Saint Petersburg, 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]);