Geolocalização de internações cadastradas no Sistema de Informações Hospitalares do Sistema Único de Saúde: uma solução baseada no programa estatístico R

Abstract

Objective: to describe a solution enabling geolocation of hospital admissions (AIH), processed on the Brazilian National Health System's Hospital Information System. Methods: in order to spatialize AIHs an R language script was written, based on the microdatasus and CepR packages; the script was applied to identify all AIHs in Goiás state in the year 2015; after downloading and pre-processing the data, the procedure for AIH spatialization was detailed. Results: of the 361,213 AIHs processed, we were able to retrieve 24,220 different ZIP codes (CEPs); from this set of ZIP codes, 23,910 (98.7%) were geolocated; these geolocated ZIP codes enabled spatialization of 97.7% of AIHs processed for the state of Goiás. Conclusion: it is possible to spatialize AIHs with a high success rate; the method detailed in this paper opens a new range of possibilities for the design of evaluation studies, formulation of policies and planning of health care actions.

Programa Mais Médicos: como avaliar o impacto de uma abordagem inovadora para superação de iniquidades em recursos humanos

“…Apesar dessa vantagem, as ICSAP são divulgadas apenas de forma agregada pelo DATASUS, não permitindo, até recentemente, sua vinculação a equipes ou unidades de saúde. Para contornar essa dificuldade, Rocha et al (24) desenvolveram uma abordagem de geolocalização de ICSAP. A aplicação dessa abordagem conjuntamente com a definição de uma área de abrangência potencial das equipes torna possível atribuir a uma UBS uma carga de ICSAP.…”

“…A aplicação dessa abordagem conjuntamente com a definição de uma área de abrangência potencial das equipes torna possível atribuir a uma UBS uma carga de ICSAP. Um piloto dessa metodologia foi aplicado por Rocha et al (24) junto às ICSAP processadas por hospitais brasileiros do estado de Goiás (figura 4).…”

Pacote csapAIH: a Lista Brasileira de Internações por Condições Sensíveis à Atenção Primária no programa R

“…Users with some knowledge of R can use these tools and create scripts for analysis of local interest and for monitoring the municipal health situation or the health situation of Health Service areas/administrative divisions within a municipality. 6 These scripts can be used as "templates" and, with slight modifications, can be used in other locations. Users with no knowledge of the program may, in turn, follow instructions for reading these files and automatically generating reports.…”

“…Creating tools that facilitate this process can be useful both for health research and also for Brazil's Municipal and State Health Departments to monitor indicators. 6 There are some specific R packages for this purpose, such as read.dbc 7,8 for reading databases compressed by DATASUS in .dbc format: the homonyms datasus 9,10 and microdatasus 11 for downloading files containing databases of some Brazilian information systems; and csapAIH, 12 for classifying Ambulatory Care Sensitive Conditions (ACSC) in accordance with the Brazilian ACSC List. 13 ACSCs are an indirect indicator of the effectiveness of Primary Health Care (PHC), as measured by hospitalizations for health conditions that would not develop to the point of requiring hospitalization if PHC worked flawlessly.…”

Internações, óbitos e custos hospitalares por diabetes mellitus

“…HIS is an administrative tool of the Department of Informatics of the Unified Health System (DATASUS) that contains data on hospitalizations performed in public health institutions throughout the Brazilian territory. 15 From this perspective, data were collected from the Northeast region of Brazil, considered the second region with the largest number of inhabitants, which is equivalent to approximately 56.7 million people distributed in nine Federative Units (FU), 16 The variables were collected in September 2018, considering the time limit between 2013 and 2017. Thus, one selected the option of "Diabetes Mellitus treatments", protocoled with the code: 03.03.03.003-8 throughout the national territory.…”