Open turicas opened 4 years ago
Como posso ajudar aqui, @turicas ?
Pra começar: cola os links para os boletins oficiais com a data. Assim:
date,url
2020-03-01,http://...
2020-03-02,http://...
2020-03-03,http://...
date,url
2020-02-27,http://www.saude.ba.gov.br/2020/02/27/nota-informativa-coronavirus/
2020-02-28,http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus/
2020-02-28,http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus-2/
2020-03-02,http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/
2020-03-02,http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/
2020-03-03,http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
2020-03-04,http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
2020-03-05,http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
2020-03-06,http://www.saude.ba.gov.br/2020/03/06/bahia-confirma-primeiro-caso-importado-do-novo-coronavirus-covid-19/
2020-03-06,http://www.saude.ba.gov.br/2020/03/06/boletim-novo-coronavirus-06-03-2020/
2020-03-07,http://www.saude.ba.gov.br/2020/03/07/bahia-confirma-segundo-caso-do-novo-coronavirus-covid-19/
2020-03-09,http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
2020-03-10,http://www.saude.ba.gov.br/2020/03/10/boletim-novo-coronavirus-10-03-2020/
2020-03-11, http://www.saude.ba.gov.br/2020/03/11/bahia-confirma-terceiro-caso-do-novo-coronavirus-covid-19/
2020-03-12,http://www.saude.ba.gov.br/2020/03/12/boletim-novo-coronavirus-12-03-2020/
2020-03-13,http://www.saude.ba.gov.br/2020/03/13/comissao-do-hospital-regional-costa-do-cacau-traca-estrategia-frente-ao-novo-coronavirus-covid-19/
2020-03-13,http://www.saude.ba.gov.br/2020/03/13/boletim-novo-coronavirus-13-03-2020/\
2020-03-15,http://www.saude.ba.gov.br/2020/03/15/bahia-confirma-oitavo-caso-do-novo-coronavirus-covid-19/
2020-03-15,http://www.saude.ba.gov.br/2020/03/15/bahia-confirma-nono-caso-do-novo-coronavirus-covid-19/
2020-03-16,http://www.saude.ba.gov.br/2020/03/16/bahia-confirma-decimo-caso-do-novo-coronavirus-covid-19/
2020-03-17,http://www.saude.ba.gov.br/2020/03/17/bahia-confirma-13-casos-do-novo-coronavirus-covid-19/
2020-03-17,http://www.saude.ba.gov.br/2020/03/17/bahia-confirma-14-casos-do-novo-coronavirus-covid-19/
2020-03-18,http://www.saude.ba.gov.br/2020/03/18/bahia-confirma-18-casos-do-novo-coronavirus-covid-19/
2020-03-18,http://www.saude.ba.gov.br/2020/03/18/retificacao-%c7%80-bahia-confirma-27-casos-do-novo-coronavirus-covid-19/
2020-03-19,http://www.saude.ba.gov.br/2020/03/19/bahia-confirma-30-casos-do-novo-coronavirus-covid-19/
2020-03-19,http://www.saude.ba.gov.br/2020/03/19/bahia-segue-com-31-casos-confirmados-de-covid-19/
2020-03-20,http://www.saude.ba.gov.br/2020/03/20/bahia-registra-33-casos-confirmados-de-covid-19/
Tinha quase tudo na planilha, com poquíssimas exceções. Pelo horário das postagens, deve sair um ainda hoje daqui 30 ou 60 minutos.
Obrigado! Já atualizei na planilha. Se puder sempre postar aqui quando tiver atualização, eu vou adicionando de maneira estruturada (pode postar só a partir desse último, não precisa repetir tudo).
@turicas , fiz até o dia 09. Realmente é um trabalho bem braçal. Alguns tem tabelas, outros não, outros são só notícias que usam dados do dia anterior, etc. Espero que ajude.
date;state;city;place_type;notified;confirmed;discarded;suspect;deaths;notes;source_url
27/02/2020;BA;;state;12;0;10;2;0;;http://www.saude.ba.gov.br/2020/02/27/nota-informativa-coronavirus/
28/02/2020;BA;;state;24;0;19;5;0;;[http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus/, http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus-2/]
28/02/2020;BA;Feira de Santana;city;1;0;0;3;0;;[http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus/, http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus-2/]
28/02/2020;BA;Itabuna;city;4;0;0;1;0;;[http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus/, http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus-2/]
28/02/2020;BA;Salvador;city;14;0;0;4;0;;[http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus/, http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus-2/]
28/02/2020;BA;Camaçari;city;2;0;0;0;0;;[http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus/, http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus-2/]
28/02/2020;BA;Jequié;city;1;0;0;0;0;;[http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus/, http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus-2/]
28/02/2020;BA;Tucano;city;1;0;0;0;0;;[http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus/, http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus-2/]
28/02/2020;BA;Jacaraci;city;1;0;0;0;0;;[http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus/, http://www.saude.ba.gov.br/2020/02/28/boletim-coronavirus-2/]
02/03/2020;BA;;state;49;0;32;17;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Feira de Santana;city;3;0;3;0;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Itabuna;city;4;0;4;0;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Salvador;city;26;0;19;7;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Camaçari;city;3;0;1;2;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Jequié;city;2;0;1;1;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Tucano;city;1;0;1;0;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Jacaraci;city;2;0;2;0;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Ilhéus;city;1;0;0;1;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Lauro de Freitas;city;1;0;0;1;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Teixeira de Freitas;city;1;0;1;0;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
02/03/2020;BA;Vitória da Conquista;city;5;0;0;5;0;;[http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020/, http://www.saude.ba.gov.br/2020/03/02/boletim-coronavirus-02-03-2020-17h/]
03/03/2020;BA;;state;61;0;41;20;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Feira de Santana;city;4;0;3;1;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Itabuna;city;4;0;4;0;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Salvador;city;37;0;22;15;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Camaçari;city;3;0;2;1;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Jequié;city;2;0;2;0;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Tucano;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Jacaraci;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Ilhéus;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Lauro de Freitas;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Teixeira de Freitas;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Vitória da Conquista;city;5;0;3;2;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
03/03/2020;BA;Lençóis;city;1;0;0;1;0;;http://www.saude.ba.gov.br/2020/03/03/boletim-coronavirus-03-03-2020/
04/03/2020;BA;;state;66;0;46;20;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Feira de Santana;city;4;0;3;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Itabuna;city;4;0;4;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Salvador;city;40;0;24;16;;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Camaçari;city;3;0;3;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Jequié;city;2;0;2;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Tucano;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Jacaraci;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Ilhéus;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Lauro de Freitas;city;2;0;2;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Teixeira de Freitas;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Vitória da Conquista;city;5;0;2;3;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Lençóis;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
04/03/2020;BA;Santa Cruz Cabrália;city;1;0;0;1;0;;http://www.saude.ba.gov.br/2020/03/04/boletim-coronavirus-04-03-2020/
05/03/2020;BA;;state;73;0;50;23;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Feira de Santana;city;4;0;4;0;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Itabuna;city;4;0;4;0;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Salvador;city;45;0;30;15;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Camaçari;city;4;0;2;2;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Jequié;city;2;0;2;0;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Tucano;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Jacaraci;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Ilhéus;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Lauro de Freitas;city;3;0;1;2;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Teixeira de Freitas;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Vitória da Conquista;city;5;0;2;3;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Lençóis;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
05/03/2020;BA;Santa Cruz Cabrália;city;1;0;0;1;0;;http://www.saude.ba.gov.br/2020/03/05/boletim-novo-coronavirus-05-03-2020/
06/03/2020;BA;;state;93;1;54;38;0;;[http://www.saude.ba.gov.br/2020/03/06/bahia-confirma-primeiro-caso-importado-do-novo-coronavirus-covid-19/, http://www.saude.ba.gov.br/2020/03/06/boletim-novo-coronavirus-06-03-2020/]
07/03/2020;BA;;state;93;2;54;37;0;;http://www.saude.ba.gov.br/2020/03/07/bahia-confirma-segundo-caso-do-novo-coronavirus-covid-19/
09/03/2020;BA;;state;145;2;82;61;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Feira de Santana;city;16;2;5;9;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Itabuna;city;4;0;4;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Salvador;city;85;0;46;39;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Camaçari;city;4;0;4;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Jequié;city;2;0;2;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Tucano;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Jacaraci;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Ilhéus;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Lauro de Freitas;city;7;0;5;2;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Teixeira de Freitas;city;2;0;2;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Vitória da Conquista;city;10;0;5;5;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Lençóis;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Santa Cruz Cabrália;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Araci;city;1;0;0;1;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Candeias;city;1;0;0;1;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Madre de Deus;city;1;0;1;0;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Pojuca;city;1;0;0;1;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Porto Seguro;city;5;0;3;2;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
09/03/2020;BA;Vera Cruz;city;1;0;0;1;0;;http://www.saude.ba.gov.br/2020/03/09/boletim-novo-coronavirus-09-03-2020/
@matheuscas obrigado! em breve checo os casos. Estou organizando melhor a forma como os voluntários adicionam e atualizam os dados. Você poderia entrar em contato comigo por email (se puder, já envie por lá: whatsapp e nome/sobrenome)? turicas arroba brasil ponto io
Talvez um Google Form seja uma alternativa boa para receber dados (já que cai direto em uma planilha).
Link pra quem quiser enviar uma mensagem para o setor de Transparência da Bahia: http://www.transparencia.ba.gov.br/Contato/ Contato da SESAB: Secretário: Fábio Vilas-Boas - jornalismo@saude.ba.gov.br (fonte: http://www.ba.gov.br/node/1670)
Por acaso notei que nem todos os posts estão na categoria Vigilância:
2020-03-22,www.saude.ba.gov.br/2020/03/22/bahia-confirma-55-casos-de-covid-19/
Dados de Feira de Santana podem ser encontrados aqui (atualizados diariamente de acordo com o boletim da ASCOM SMS/FSA).
Boletins:
Status da checagem (anteriores a 20/03):
Modo e responsável pela conversão: