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 2022-01-25 sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1227326 | 1227326 | 2022-01-24 | Brazil | Acre | 95091 | 1857 | 0 | -9.0238 | -70.812 | 2022-01-25 04:21:05 | Acre, Brazil | |||
1227327 | 1227327 | 2022-01-24 | Brazil | Alagoas | 251188 | 6409 | 0 | -9.5713 | -36.782 | 2022-01-25 04:21:05 | Alagoas, Brazil | |||
1227328 | 1227328 | 2022-01-24 | Brazil | Amapa | 140462 | 2039 | 0 | 0.902 | -52.003 | 2022-01-25 04:21:05 | Amapa, Brazil | |||
1227329 | 1227329 | 2022-01-24 | Brazil | Amazonas | 495528 | 13892 | 0 | -3.4168 | -65.8561 | 2022-01-25 04:21:05 | Amazonas, Brazil | |||
1227330 | 1227330 | 2022-01-24 | Brazil | Bahia | 1319176 | 27791 | 0 | -12.5797 | -41.7007 | 2022-01-25 04:21:05 | Bahia, Brazil | |||
1227331 | 1227331 | 2022-01-24 | Brazil | Ceara | 1032651 | 25039 | 0 | -5.4984 | -39.3206 | 2022-01-25 04:21:05 | Ceara, Brazil | |||
1227332 | 1227332 | 2022-01-24 | Brazil | Distrito Federal | 568433 | 11143 | 0 | -15.7998 | -47.8645 | 2022-01-25 04:21:05 | Distrito Federal, Brazil | |||
1227333 | 1227333 | 2022-01-24 | Brazil | Espirito Santo | 742822 | 13429 | 0 | -19.1834 | -40.3089 | 2022-01-25 04:21:05 | Espirito Santo, Brazil | |||
1227334 | 1227334 | 2022-01-24 | Brazil | Goias | 1006494 | 24870 | 0 | -15.827 | -49.8362 | 2022-01-25 04:21:05 | Goias, Brazil | |||
1227335 | 1227335 | 2022-01-24 | Brazil | Maranhao | 378988 | 10452 | 0 | -4.9609 | -45.2744 | 2022-01-25 04:21:05 | Maranhao, Brazil | |||
1227336 | 1227336 | 2022-01-24 | Brazil | Mato Grosso | 601453 | 14205 | 0 | -12.6819 | -56.9211 | 2022-01-25 04:21:05 | Mato Grosso, Brazil | |||
1227337 | 1227337 | 2022-01-24 | Brazil | Mato Grosso do Sul | 402729 | 9796 | 0 | -20.7722 | -54.7852 | 2022-01-25 04:21:05 | Mato Grosso do Sul, Brazil | |||
1227338 | 1227338 | 2022-01-24 | Brazil | Minas Gerais | 2514049 | 56965 | 0 | -18.5122 | -44.555 | 2022-01-25 04:21:05 | Minas Gerais, Brazil | |||
1227339 | 1227339 | 2022-01-24 | Brazil | Para | 639755 | 17296 | 0 | -1.9981 | -54.9306 | 2022-01-25 04:21:05 | Para, Brazil | |||
1227340 | 1227340 | 2022-01-24 | Brazil | Paraiba | 479952 | 9640 | 0 | -7.24 | -36.782 | 2022-01-25 04:21:05 | Paraiba, Brazil | |||
1227341 | 1227341 | 2022-01-24 | Brazil | Parana | 1827077 | 41005 | 0 | -25.2521 | -52.0215 | 2022-01-25 04:21:05 | Parana, Brazil | |||
1227342 | 1227342 | 2022-01-24 | Brazil | Pernambuco | 669804 | 20590 | 0 | -8.8137 | -36.9541 | 2022-01-25 04:21:05 | Pernambuco, Brazil | |||
1227343 | 1227343 | 2022-01-24 | Brazil | Piaui | 338895 | 7351 | 0 | -7.7183 | -42.7289 | 2022-01-25 04:21:05 | Piaui, Brazil | |||
1227344 | 1227344 | 2022-01-24 | Brazil | Rio Grande do Norte | 404907 | 7643 | 0 | -5.4026 | -36.9541 | 2022-01-25 04:21:05 | Rio Grande do Norte, Brazil | |||
1227345 | 1227345 | 2022-01-24 | Brazil | Rio Grande do Sul | 1704958 | 36644 | 0 | -30.0346 | -51.2177 | 2022-01-25 04:21:05 | Rio Grande do Sul, Brazil | |||
1227346 | 1227346 | 2022-01-24 | Brazil | Rio de Janeiro | 1613260 | 69689 | 0 | -22.9068 | -43.1729 | 2022-01-25 04:21:05 | Rio de Janeiro, Brazil | |||
1227347 | 1227347 | 2022-01-24 | Brazil | Rondonia | 303115 | 6810 | 0 | -11.5057 | -63.5806 | 2022-01-25 04:21:05 | Rondonia, Brazil | |||
1227348 | 1227348 | 2022-01-24 | Brazil | Roraima | 137456 | 2086 | 0 | -2.7376 | -62.0751 | 2022-01-25 04:21:05 | Roraima, Brazil | |||
1227349 | 1227349 | 2022-01-24 | Brazil | Santa Catarina | 1368213 | 20384 | 0 | -27.2423 | -50.2189 | 2022-01-25 04:21:05 | Santa Catarina, Brazil | |||
1227350 | 1227350 | 2022-01-24 | Brazil | Sao Paulo | 4565699 | 156551 | 0 | -23.5505 | -46.6333 | 2022-01-25 04:21:05 | Sao Paulo, Brazil | |||
1227351 | 1227351 | 2022-01-24 | Brazil | Sergipe | 284333 | 6075 | 0 | -10.5741 | -37.3857 | 2022-01-25 04:21:05 | Sergipe, Brazil | |||
1227352 | 1227352 | 2022-01-24 | Brazil | Tocantins | 255544 | 3985 | 0 | -10.1753 | -48.2982 | 2022-01-25 04:21:05 | Tocantins, 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]);