daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where province_or_state = "Ceara" and recovered = 223281 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-10-26 | Brazil | Ceara | 270867 | 9293 | 223281 | 38017 | -5.4984 | -39.3206 | 2020-10-27 04:24:45 | Ceara, Brazil | ||
2020-10-25 | Brazil | Ceara | 270378 | 9259 | 223281 | 37735 | -5.4984 | -39.3206 | 2020-10-26 04:25:02 | Ceara, Brazil | ||
2020-10-24 | Brazil | Ceara | 270070 | 9248 | 223281 | 36865 | -5.4984 | -39.3206 | 2020-10-25 04:24:36 | Ceara, Brazil | ||
2020-10-23 | Brazil | Ceara | 269255 | 9245 | 223281 | 36640 | -5.4984 | -39.3206 | 2020-10-24 04:24:46 | Ceara, Brazil | ||
2020-10-22 | Brazil | Ceara | 268345 | 9243 | 223281 | 35750 | -5.4984 | -39.3206 | 2020-10-23 04:24:46 | Ceara, Brazil | ||
2020-10-21 | Brazil | Ceara | 267721 | 9243 | 223281 | 33808 | -5.4984 | -39.3206 | 2020-10-22 04:24:27 | Ceara, Brazil | ||
2020-10-20 | Brazil | Ceara | 266316 | 9227 | 223281 | 33790 | -5.4984 | -39.3206 | 2020-10-21 04:24:14 | Ceara, Brazil | ||
2020-10-19 | Brazil | Ceara | 265875 | 9217 | 223281 | 33091 | -5.4984 | -39.3206 | 2020-10-20 04:24:22 | Ceara, Brazil | ||
2020-10-18 | Brazil | Ceara | 265102 | 9210 | 223281 | 31757 | -5.4984 | -39.3206 | 2020-10-19 04:24:16 | Ceara, Brazil | ||
2020-10-17 | Brazil | Ceara | 264245 | 9207 | 223281 | 31757 | -5.4984 | -39.3206 | 2020-10-18 04:24:25 | Ceara, Brazil | ||
2020-10-16 | Brazil | Ceara | 264172 | 9202 | 223281 | 30663 | -5.4984 | -39.3206 | 2020-10-17 04:24:12 | Ceara, Brazil | ||
2020-10-15 | Brazil | Ceara | 262831 | 9199 | 223281 | 30094 | -5.4984 | -39.3206 | 2020-10-16 04:24:01 | Ceara, Brazil | ||
2020-10-14 | Brazil | Ceara | 261504 | 9184 | 223281 | 28825 | -5.4984 | -39.3206 | 2020-10-15 04:24:28 | Ceara, Brazil | ||
2020-10-13 | Brazil | Ceara | 260642 | 9140 | 223281 | 28221 | -5.4984 | -39.3206 | 2020-10-14 04:24:05 | Ceara, Brazil | ||
2020-10-12 | Brazil | Ceara | 260336 | 9135 | 223281 | 27806 | -5.4984 | -39.3206 | 2020-10-13 04:24:02 | Ceara, Brazil | ||
2020-10-11 | Brazil | Ceara | 260154 | 9134 | 223281 | 27739 | -5.4984 | -39.3206 | 2020-10-12 04:23:45 | Ceara, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;