johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where country_or_region = "Brazil" and "last_update" is on date 2020-06-17 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 27
- Acre 1
- Alagoas 1
- Amapa 1
- Amazonas 1
- Bahia 1
- Ceara 1
- Distrito Federal 1
- Espirito Santo 1
- Goias 1
- Maranhao 1
- Mato Grosso 1
- Mato Grosso do Sul 1
- Minas Gerais 1
- Para 1
- Paraiba 1
- Parana 1
- Pernambuco 1
- Piaui 1
- Rio Grande do Norte 1
- Rio Grande do Sul 1
- Rio de Janeiro 1
- Rondonia 1
- Roraima 1
- Santa Catarina 1
- Sao Paulo 1
- Sergipe 1
- Tocantins 1
country_or_region 1
- Brazil · 27 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2386654 | 2386654 | 2020-06-16 | Brazil | Mato Grosso do Sul | 4164 | 36 | 1969 | 1780 | -20.7722 | -54.7852 | 2020-06-17 04:33:21 | Mato Grosso do Sul, Brazil | ||
2386831 | 2386831 | 2020-06-16 | Brazil | Tocantins | 7573 | 149 | 4226 | 2943 | -10.1753 | -48.2982 | 2020-06-17 04:33:21 | Tocantins, Brazil | ||
2386783 | 2386783 | 2020-06-16 | Brazil | Santa Catarina | 14402 | 212 | 9430 | 4760 | -27.2423 | -50.2189 | 2020-06-17 04:33:21 | Santa Catarina, Brazil | ||
2386765 | 2386765 | 2020-06-16 | Brazil | Roraima | 7150 | 224 | 1770 | 4949 | -2.7376 | -62.0751 | 2020-06-17 04:33:21 | Roraima, Brazil | ||
2386532 | 2386532 | 2020-06-16 | Brazil | Goias | 11836 | 249 | 0 | 11018 | -15.827 | -49.8362 | 2020-06-17 04:33:21 | Goias, Brazil | ||
2386653 | 2386653 | 2020-06-16 | Brazil | Mato Grosso | 6877 | 250 | 2401 | 3761 | -12.6819 | -56.9211 | 2020-06-17 04:33:21 | Mato Grosso, Brazil | ||
2386391 | 2386391 | 2020-06-16 | Brazil | Acre | 10003 | 271 | 5383 | 4349 | -9.0238 | -70.812 | 2020-06-17 04:33:21 | Acre, Brazil | ||
2386400 | 2386400 | 2020-06-16 | Brazil | Amapa | 18024 | 337 | 8041 | 9646 | 0.902 | -52.003 | 2020-06-17 04:33:21 | Amapa, Brazil | ||
2386764 | 2386764 | 2020-06-16 | Brazil | Rondonia | 13010 | 346 | 4649 | 8015 | -11.5057 | -63.5806 | 2020-06-17 04:33:21 | Rondonia, Brazil | ||
2386507 | 2386507 | 2020-06-16 | Brazil | Distrito Federal | 25380 | 348 | 15172 | 9860 | -15.7998 | -47.8645 | 2020-06-17 04:33:21 | Distrito Federal, Brazil | ||
2386791 | 2386791 | 2020-06-16 | Brazil | Sergipe | 16310 | 364 | 5526 | 10420 | -10.5741 | -37.3857 | 2020-06-17 04:33:21 | Sergipe, Brazil | ||
2386728 | 2386728 | 2020-06-16 | Brazil | Parana | 10690 | 372 | 3215 | 6978 | -25.2521 | -52.0215 | 2020-06-17 04:33:21 | Parana, Brazil | ||
2386760 | 2386760 | 2020-06-16 | Brazil | Rio Grande do Sul | 16471 | 374 | 13288 | 2809 | -30.0346 | -51.2177 | 2020-06-17 04:33:21 | Rio Grande do Sul, Brazil | ||
2386733 | 2386733 | 2020-06-16 | Brazil | Piaui | 11559 | 398 | 709 | 9779 | -7.7183 | -42.7289 | 2020-06-17 04:33:21 | Piaui, Brazil | ||
2386665 | 2386665 | 2020-06-16 | Brazil | Minas Gerais | 22024 | 502 | 11826 | 9696 | -18.5122 | -44.555 | 2020-06-17 04:33:21 | Minas Gerais, Brazil | ||
2386759 | 2386759 | 2020-06-16 | Brazil | Rio Grande do Norte | 15690 | 626 | 1993 | 12634 | -5.4026 | -36.9541 | 2020-06-17 04:33:21 | Rio Grande do Norte, Brazil | ||
2386727 | 2386727 | 2020-06-16 | Brazil | Paraiba | 30128 | 671 | 7500 | 21957 | -7.24 | -36.782 | 2020-06-17 04:33:21 | Paraiba, Brazil | ||
2386396 | 2386396 | 2020-06-16 | Brazil | Alagoas | 23632 | 793 | 16115 | 6724 | -9.5713 | -36.782 | 2020-06-17 04:33:21 | Alagoas, Brazil | ||
2386514 | 2386514 | 2020-06-16 | Brazil | Espirito Santo | 29030 | 1132 | 15252 | 12569 | -19.1834 | -40.3089 | 2020-06-17 04:33:21 | Espirito Santo, Brazil | ||
2386433 | 2386433 | 2020-06-16 | Brazil | Bahia | 39207 | 1181 | 16777 | 21248 | -12.5797 | -41.7007 | 2020-06-17 04:33:21 | Bahia, Brazil | ||
2386649 | 2386649 | 2020-06-16 | Brazil | Maranhao | 62711 | 1537 | 36979 | 24195 | -4.9609 | -45.2744 | 2020-06-17 04:33:21 | Maranhao, Brazil | ||
2386401 | 2386401 | 2020-06-16 | Brazil | Amazonas | 58018 | 2550 | 46894 | 8575 | -3.4168 | -65.8561 | 2020-06-17 04:33:21 | Amazonas, Brazil | ||
2386732 | 2386732 | 2020-06-16 | Brazil | Pernambuco | 46427 | 3959 | 30767 | 11701 | -8.8137 | -36.9541 | 2020-06-17 04:33:21 | Pernambuco, Brazil | ||
2386726 | 2386726 | 2020-06-16 | Brazil | Para | 74192 | 4350 | 55864 | 11088 | -1.9981 | -54.9306 | 2020-06-17 04:33:21 | Para, Brazil | ||
2386474 | 2386474 | 2020-06-16 | Brazil | Ceara | 82169 | 5192 | 59901 | 16318 | -5.4984 | -39.3206 | 2020-06-17 04:33:21 | Ceara, Brazil | ||
2386761 | 2386761 | 2020-06-16 | Brazil | Rio de Janeiro | 83343 | 7967 | 65063 | 10313 | -22.9068 | -43.1729 | 2020-06-17 04:33:21 | Rio de Janeiro, Brazil | ||
2386785 | 2386785 | 2020-06-16 | Brazil | Sao Paulo | 190285 | 11132 | 49295 | 129858 | -23.5505 | -46.6333 | 2020-06-17 04:33:21 | Sao Paulo, 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]);