Highlights ■ The extract, transform, and load algorithm automates data extraction and updates in the PostgreSQL database. ■ The interactive dashboard enables detailed queries on establishments and professionals. ■ Results highlight medical doctor deficit in 22 cities and a shortage of community agents. ■ The tool can scale and assist managers in resource allocation for healthcare. ABSTRACT Objective: To develop a process (pipeline) for extracting, processing, and analyzing data from the National Registry of Health Establishments in the State of […]

ABSTRACT Objective To evaluate a p-median model for health care services accessibility based on decentralization and optimal allocation of Primary Health Care Units in the State of São Paulo, Brazil. Methods Using geographical data of Primary Health Care Units located in the State of São Paulo, potential support and supply facility allocations were simulated by means of a random approach. Several constraints were then imposed on the system to simulate different scenarios. Results were assessed according to geographic disposition. Results […]