johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5 rows where country_or_region = "Brazil" and deaths = 1645 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
province_or_state 5
- Amapa 1
- Maranhao 1
- Mato Grosso do Sul 1
- Rondonia 1
- Roraima 1
country_or_region 1
- Brazil · 5 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2103879 | 2103879 | 2021-06-01 | Brazil | Roraima | 104182 | 1645 | 97922 | 4275 | -2.7376 | -62.0751 | 2021-06-02 04:24:34 | Roraima, Brazil | ||
1912942 | 1912942 | 2021-05-20 | Brazil | Amapa | 109777 | 1645 | 82294 | 25838 | 0.902 | -52.003 | 2021-05-21 04:20:43 | Amapa, Brazil | ||
1751019 | 1751019 | 2020-12-14 | Brazil | Rondonia | 86118 | 1645 | 74704 | 9769 | -11.5057 | -63.5806 | 2020-12-15 05:26:38 | Rondonia, Brazil | ||
271897 | 271897 | 2020-11-10 | Brazil | Mato Grosso do Sul | 85990 | 1645 | 80462 | 3405 | -20.7722 | -54.7852 | 2020-11-11 05:25:30 | Mato Grosso do Sul, Brazil | ||
1691534 | 1691534 | 2020-06-19 | Brazil | Maranhao | 68500 | 1645 | 43830 | 23025 | -4.9609 | -45.2744 | 2020-06-20 04:33:19 | Maranhao, Brazil |
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]);