johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

27 rows where country_or_region = "Brazil" and last_update = "2021-09-07 04:21:35" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: longitude

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
3193729 3193729 2021-09-06 Brazil Acre     87877 1814 0   -9.0238 -70.812 2021-09-07 04:21:35 Acre, Brazil
3193730 3193730 2021-09-06 Brazil Alagoas     236777 6106 0   -9.5713 -36.782 2021-09-07 04:21:35 Alagoas, Brazil
3193731 3193731 2021-09-06 Brazil Amapa     122540 1959 0   0.902 -52.003 2021-09-07 04:21:35 Amapa, Brazil
3193732 3193732 2021-09-06 Brazil Amazonas     424996 13696 0   -3.4168 -65.8561 2021-09-07 04:21:35 Amazonas, Brazil
3193733 3193733 2021-09-06 Brazil Bahia     1224174 26577 0   -12.5797 -41.7007 2021-09-07 04:21:35 Bahia, Brazil
3193734 3193734 2021-09-06 Brazil Ceara     933490 24065 0   -5.4984 -39.3206 2021-09-07 04:21:35 Ceara, Brazil
3193735 3193735 2021-09-06 Brazil Distrito Federal     476143 10144 0   -15.7998 -47.8645 2021-09-07 04:21:35 Distrito Federal, Brazil
3193736 3193736 2021-09-06 Brazil Espirito Santo     567037 12313 0   -19.1834 -40.3089 2021-09-07 04:21:35 Espirito Santo, Brazil
3193737 3193737 2021-09-06 Brazil Goias     828878 22699 0   -15.827 -49.8362 2021-09-07 04:21:35 Goias, Brazil
3193738 3193738 2021-09-06 Brazil Maranhao     351106 10071 0   -4.9609 -45.2744 2021-09-07 04:21:35 Maranhao, Brazil
3193739 3193739 2021-09-06 Brazil Mato Grosso     524386 13557 0   -12.6819 -56.9211 2021-09-07 04:21:35 Mato Grosso, Brazil
3193740 3193740 2021-09-06 Brazil Mato Grosso do Sul     370224 9434 0   -20.7722 -54.7852 2021-09-07 04:21:35 Mato Grosso do Sul, Brazil
3193741 3193741 2021-09-06 Brazil Minas Gerais     2081186 53323 0   -18.5122 -44.555 2021-09-07 04:21:35 Minas Gerais, Brazil
3193742 3193742 2021-09-06 Brazil Para     585515 16512 0   -1.9981 -54.9306 2021-09-07 04:21:35 Para, Brazil
3193743 3193743 2021-09-06 Brazil Paraiba     435822 9217 0   -7.24 -36.782 2021-09-07 04:21:35 Paraiba, Brazil
3193744 3193744 2021-09-06 Brazil Parana     1469154 37801 0   -25.2521 -52.0215 2021-09-07 04:21:35 Parana, Brazil
3193745 3193745 2021-09-06 Brazil Pernambuco     610740 19469 0   -8.8137 -36.9541 2021-09-07 04:21:35 Pernambuco, Brazil
3193746 3193746 2021-09-06 Brazil Piaui     317558 6963 0   -7.7183 -42.7289 2021-09-07 04:21:35 Piaui, Brazil
3193747 3193747 2021-09-06 Brazil Rio Grande do Norte     365736 7286 0   -5.4026 -36.9541 2021-09-07 04:21:35 Rio Grande do Norte, Brazil
3193748 3193748 2021-09-06 Brazil Rio Grande do Sul     1412828 34333 0   -30.0346 -51.2177 2021-09-07 04:21:35 Rio Grande do Sul, Brazil
3193749 3193749 2021-09-06 Brazil Rio de Janeiro     1137927 63243 0   -22.9068 -43.1729 2021-09-07 04:21:35 Rio de Janeiro, Brazil
3193750 3193750 2021-09-06 Brazil Rondonia     263834 6488 0   -11.5057 -63.5806 2021-09-07 04:21:35 Rondonia, Brazil
3193751 3193751 2021-09-06 Brazil Roraima     124441 1957 0   -2.7376 -62.0751 2021-09-07 04:21:35 Roraima, Brazil
3193752 3193752 2021-09-06 Brazil Santa Catarina     1162499 18813 0   -27.2423 -50.2189 2021-09-07 04:21:35 Santa Catarina, Brazil
3193753 3193753 2021-09-06 Brazil Sao Paulo     4291993 146567 0   -23.5505 -46.6333 2021-09-07 04:21:35 Sao Paulo, Brazil
3193754 3193754 2021-09-06 Brazil Sergipe     277578 6001 0   -10.5741 -37.3857 2021-09-07 04:21:35 Sergipe, Brazil
3193755 3193755 2021-09-06 Brazil Tocantins     220290 3704 0   -10.1753 -48.2982 2021-09-07 04:21:35 Tocantins, Brazil

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);