johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where country_or_region = "Jordan" and recovered = 1 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, last_update, day (date)
country_or_region 1
- Jordan · 14 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
919228 | 919228 | 2020-03-26 | Jordan | 212 | 0 | 1 | 211 | 31.24 | 36.51 | 2020-03-26 23:48:18 | Jordan | |||
1132629 | 1132629 | 2020-03-25 | Jordan | 172 | 0 | 1 | 171 | 31.24 | 36.51 | 2020-03-25 23:33:04 | Jordan | |||
1479135 | 1479135 | 2020-03-24 | Jordan | 154 | 0 | 1 | 153 | 31.24 | 36.51 | 2020-03-24 23:37:15 | Jordan | |||
2147191 | 2147191 | 2020-03-23 | Jordan | 127 | 0 | 1 | 126 | 31.24 | 36.51 | 2020-03-23 23:19:21 | Jordan | |||
2910709 | 2910709 | 2020-03-22 | Jordan | 112 | 0 | 1 | 111 | 31.24 | 36.51 | 3/22/20 23:45 | Jordan | |||
339760 | 339760 | 2020-03-21 | Jordan | 85 | 0 | 1 | 30.5852 | 36.2384 | 2020-03-20T20:43:02 | |||||
3734047 | 3734047 | 2020-03-20 | Jordan | 85 | 0 | 1 | 30.5852 | 36.2384 | 2020-03-20T20:43:02 | |||||
1527002 | 1527002 | 2020-03-19 | Jordan | 69 | 0 | 1 | 30.5852 | 36.2384 | 2020-03-19T18:13:29 | |||||
1177002 | 1177002 | 2020-03-18 | Jordan | 52 | 0 | 1 | 30.5852 | 36.2384 | 2020-03-18T14:53:05 | |||||
3891445 | 3891445 | 2020-03-17 | Jordan | 34 | 0 | 1 | 30.5852 | 36.2384 | 2020-03-17T11:13:29 | |||||
2255269 | 2255269 | 2020-03-16 | Jordan | 17 | 0 | 1 | 30.5852 | 36.2384 | 2020-03-16T15:13:35 | |||||
1463632 | 1463632 | 2020-03-15 | Jordan | 8 | 0 | 1 | 30.5852 | 36.2384 | 2020-03-15T18:20:18 | |||||
2111317 | 2111317 | 2020-03-14 | Jordan | 1 | 0 | 1 | 30.5852 | 36.2384 | 2020-03-14T12:53:07 | |||||
3765414 | 3765414 | 2020-03-13 | Jordan | 1 | 0 | 1 | 31.24 | 36.51 | 2020-03-11T20:00:00 |
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]);