daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where country_or_region = "South Africa" and deaths = 0 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, last_update, day (date), last_update (date)
country_or_region 1
- South Africa · 22 ✖
province_or_state 0
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-26 | South Africa | 927 | 0 | 12 | 915 | -30.5595 | 22.9375 | 2020-03-26 23:48:18 | South Africa | |||
2020-03-25 | South Africa | 709 | 0 | 12 | 697 | -30.5595 | 22.9375 | 2020-03-25 23:33:04 | South Africa | |||
2020-03-24 | South Africa | 554 | 0 | 4 | 550 | -30.5595 | 22.9375 | 2020-03-24 23:37:15 | South Africa | |||
2020-03-23 | South Africa | 402 | 0 | 4 | 398 | -30.5595 | 22.9375 | 2020-03-23 23:19:21 | South Africa | |||
2020-03-22 | South Africa | 274 | 0 | 2 | 272 | -30.5595 | 22.9375 | 3/22/20 23:45 | South Africa | |||
2020-03-21 | South Africa | 240 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-21T12:13:19 | |||||
2020-03-20 | South Africa | 202 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-20T14:43:04 | |||||
2020-03-19 | South Africa | 150 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-19T16:43:03 | |||||
2020-03-18 | South Africa | 116 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-18T10:53:02 | |||||
2020-03-17 | South Africa | 62 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-16T14:38:45 | |||||
2020-03-16 | South Africa | 62 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-16T14:38:45 | |||||
2020-03-15 | South Africa | 51 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-15T18:20:18 | |||||
2020-03-14 | South Africa | 38 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-14T16:14:56 | |||||
2020-03-13 | South Africa | 24 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-11T20:00:00 | |||||
2020-03-12 | South Africa | 17 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-12T09:13:24 | |||||
2020-03-11 | South Africa | 13 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-11T10:33:03 | |||||
2020-03-10 | South Africa | 7 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-10T05:13:07 | |||||
2020-03-09 | South Africa | 3 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-08T10:23:04 | |||||
2020-03-08 | South Africa | 3 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-08T10:23:04 | |||||
2020-03-07 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-06T15:43:02 | |||||
2020-03-06 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-06T15:43:02 | |||||
2020-03-05 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-05T13:53:03 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;