Database used in : Analysis of intermunicipal journeys for cardiac surgery in Brazilian Unified Health System (SUS): an approach based on network theory

Data and scripts referring to the results generated in the article entitled: Analysis of intermunicipal journeys for cardiac surgery in Brazilian Unified Health System (SUS): an approach based on network theory.

To obtain the results of the work the following sequence of database treatment was performed:

DATASUS --> BASE_PER_YEAR --> EDGES_BASE --> EDGES_VC_BASE

The bases were downloaded from the DATASUS site (link: https://datasus.saude.gov.br/transferencia-de-arquivos/#) in .dbc format separated by month and year; using Tabwin we joined the bases generating a base for each year in csv format. The reformatted bases are gathered together in the file PER_YEAR_BASE.ZIP; from the bases for each year we manually built the files in csv format with the list of the edges with the following fields: "Source", "Target", "Type", "Id", "Label" and "Weight". The "Source" column was filled with data from MUNIC_RES and the "Target" column with data from MUNIC_MOV. The "ID" and "Weight" fields were filled in automatically using Gephi, where the "Weight" column represents the sum of the edge, defined by the pair of Source and Target columns, were repeated throughout the year. This generated the bases containing the list of edges that are grouped in the file EDGES_BASE.ZIP. Each base was filtered to contain only edges related to the city "Vitória da Conquista" and grouped in the file EDGES_VC_BASE.zip

INDE BASE --> NODES_BASE

To build the list of nodes containing the list of municipalities with their respective geographical locations (in UTM), we used the database of the INDE (available on the link: https://visualizador.inde.gov.br/). The file in shape format was treated in the ArqGis program and the database with the network nodes was created (file NODES_BASE.csv).

EDGES_VC_BASE and NODES_BASE -->  NETWORK

Using the program Gephi we joined the bases referring to the edges (EDGES_VC_BASE) and those referring to the nodes of the network (NODES_BASE) and built the networks for each year studied for the city of "Vitória da Conquista". All networks are in gephi format and compressed in the NETWORKS.zip file.

EDGES_VC_BASE and NODES_BASE --> INDICES

Using the R script "distance.R" and using as input the files of edges (EDGES_VC_BASE) and nodes (NODES_BASE) we generate files in csv format with the columns: dist_med_in , dist_med_out, Flow_in and flow_out. The indexes dist_med_in and dist_med_out represent the average distance traveled in meters to enter and leave the municipality, respectively; the indexes flow_in and flow_out estimate the quantity of people that entered and left the municipality. All index files are grouped in the compressed file INDICES.zip.

The last two digits at the end of all file names represent the year of analysis.