Covid-19 Data In Brazil
Daily COVID-19 Records Across Brazil: Regions, States, and Municipalities
@kaggle.leonardovianna_covid_brasil
Daily COVID-19 Records Across Brazil: Regions, States, and Municipalities
@kaggle.leonardovianna_covid_brasil
Files provided by OpenDataSUS with detailed information about the COVID-19 pandemic in Brazil, organized by federal unit, municipality, and other categories. The files present daily data related to confirmed cases, deaths, and other important variables, from the beginning of the pandemic until October 27, 2023 (May 5, 2023, marked the end of the pandemic, according to the WHO).
CREATE TABLE hist_painel_covidbr_2020_parte1_27out2023 (
"regiao" VARCHAR,
"estado" VARCHAR,
"municipio" VARCHAR,
"coduf" BIGINT,
"codmun" DOUBLE,
"codregiaosaude" DOUBLE,
"nomeregiaosaude" VARCHAR,
"data" TIMESTAMP,
"semanaepi" BIGINT,
"populacaotcu2019" DOUBLE,
"casosacumulado" BIGINT,
"casosnovos" BIGINT,
"obitosacumulado" BIGINT,
"obitosnovos" BIGINT,
"recuperadosnovos" DOUBLE,
"emacompanhamentonovos" DOUBLE,
"interior_metropolitana" DOUBLE
);CREATE TABLE hist_painel_covidbr_2020_parte2_27out2023 (
"regiao" VARCHAR,
"estado" VARCHAR,
"municipio" VARCHAR,
"coduf" BIGINT,
"codmun" DOUBLE,
"codregiaosaude" DOUBLE,
"nomeregiaosaude" VARCHAR,
"data" TIMESTAMP,
"semanaepi" BIGINT,
"populacaotcu2019" DOUBLE,
"casosacumulado" BIGINT,
"casosnovos" BIGINT,
"obitosacumulado" BIGINT,
"obitosnovos" BIGINT,
"recuperadosnovos" DOUBLE,
"emacompanhamentonovos" DOUBLE,
"interior_metropolitana" DOUBLE
);CREATE TABLE hist_painel_covidbr_2021_parte1_27out2023 (
"regiao" VARCHAR,
"estado" VARCHAR,
"municipio" VARCHAR,
"coduf" BIGINT,
"codmun" DOUBLE,
"codregiaosaude" DOUBLE,
"nomeregiaosaude" VARCHAR,
"data" TIMESTAMP,
"semanaepi" BIGINT,
"populacaotcu2019" DOUBLE,
"casosacumulado" DOUBLE,
"casosnovos" BIGINT,
"obitosacumulado" BIGINT,
"obitosnovos" BIGINT,
"recuperadosnovos" DOUBLE,
"emacompanhamentonovos" DOUBLE,
"interior_metropolitana" DOUBLE
);CREATE TABLE hist_painel_covidbr_2021_parte2_27out2023 (
"regiao" VARCHAR,
"estado" VARCHAR,
"municipio" VARCHAR,
"coduf" BIGINT,
"codmun" DOUBLE,
"codregiaosaude" DOUBLE,
"nomeregiaosaude" VARCHAR,
"data" TIMESTAMP,
"semanaepi" BIGINT,
"populacaotcu2019" DOUBLE,
"casosacumulado" BIGINT,
"casosnovos" BIGINT,
"obitosacumulado" BIGINT,
"obitosnovos" BIGINT,
"recuperadosnovos" DOUBLE,
"emacompanhamentonovos" DOUBLE,
"interior_metropolitana" DOUBLE
);CREATE TABLE hist_painel_covidbr_2022_parte1_27out2023 (
"regiao" VARCHAR,
"estado" VARCHAR,
"municipio" VARCHAR,
"coduf" BIGINT,
"codmun" DOUBLE,
"codregiaosaude" DOUBLE,
"nomeregiaosaude" VARCHAR,
"data" TIMESTAMP,
"semanaepi" BIGINT,
"populacaotcu2019" DOUBLE,
"casosacumulado" DOUBLE,
"casosnovos" BIGINT,
"obitosacumulado" BIGINT,
"obitosnovos" BIGINT,
"recuperadosnovos" DOUBLE,
"emacompanhamentonovos" DOUBLE,
"interior_metropolitana" DOUBLE
);CREATE TABLE hist_painel_covidbr_2022_parte2_27out2023 (
"regiao" VARCHAR,
"estado" VARCHAR,
"municipio" VARCHAR,
"coduf" BIGINT,
"codmun" DOUBLE,
"codregiaosaude" DOUBLE,
"nomeregiaosaude" VARCHAR,
"data" TIMESTAMP,
"semanaepi" BIGINT,
"populacaotcu2019" DOUBLE,
"casosacumulado" DOUBLE,
"casosnovos" BIGINT,
"obitosacumulado" BIGINT,
"obitosnovos" BIGINT,
"recuperadosnovos" DOUBLE,
"emacompanhamentonovos" DOUBLE,
"interior_metropolitana" DOUBLE
);CREATE TABLE hist_painel_covidbr_2023_parte1_27out2023 (
"regiao" VARCHAR,
"estado" VARCHAR,
"municipio" VARCHAR,
"coduf" BIGINT,
"codmun" DOUBLE,
"codregiaosaude" DOUBLE,
"nomeregiaosaude" VARCHAR,
"data" TIMESTAMP,
"semanaepi" BIGINT,
"populacaotcu2019" DOUBLE,
"casosacumulado" BIGINT,
"casosnovos" BIGINT,
"obitosacumulado" BIGINT,
"obitosnovos" BIGINT,
"recuperadosnovos" DOUBLE,
"emacompanhamentonovos" DOUBLE,
"interior_metropolitana" DOUBLE
);CREATE TABLE hist_painel_covidbr_2023_parte2_27out2023 (
"regiao" VARCHAR,
"estado" VARCHAR,
"municipio" VARCHAR,
"coduf" BIGINT,
"codmun" DOUBLE,
"codregiaosaude" DOUBLE,
"nomeregiaosaude" VARCHAR,
"data" TIMESTAMP,
"semanaepi" BIGINT,
"populacaotcu2019" DOUBLE,
"casosacumulado" BIGINT,
"casosnovos" BIGINT,
"obitosacumulado" BIGINT,
"obitosnovos" BIGINT,
"recuperadosnovos" DOUBLE,
"emacompanhamentonovos" DOUBLE,
"interior_metropolitana" DOUBLE
);Anyone who has the link will be able to view this.