3. Results and Discussions
As mentioned in subchapter 2.3, the data processing allowed to obtain collections of tables, charts and maps.
Regarding the collection of tables, the existing information in the source data structures on the governmental portal
data.gov.ro, related to the indicators used for the investigation, allowed the creation of five tables, which can be consulted in detail in
Appendix 1. These tables are: Incidence by counties between March 1-31, 2021. (Cases per one thousand inhabitants in the last 14 days.), Tests conducted by counties between March 1-31, 2021, Deaths reported by counties between March 1-31, 2021, Persons hospitalized at ICU by counties between March 1-31, 2021, and Vaccinations by counties between March 1-31, 2021. The tables are in the format found in
Table 1 or
Table 2.
In order to obtain graphical reports based on spatial analysis, the processing of data collected from the governmental portal
data.gov.ro allowed the creation of 153 maps, meaning 5 sets of maps with the evolution of the indicators monitored in the 31 days. The process of processing the available data involved two stages. As a result of the fact that vaccination information was provided at the level of vaccination centers, which in the vast majority were more than one at the level of administrative territorial units, in the first phase it was necessary to cumulate vaccination data by day at the level of administrative units. After this stage, all the data structures were added to the QGIS project [
26], resulting in 153 maps. The analysis proposed in this case is based on the philosophy of tracking the simultaneous evolution of the 5 indicators, presented in heatmap maps. For this comparison to be effective, it is considered that public health specialists, in their analysis for the calculation of the incidence of infections, used the 14-day interval. At the same time, several product datasheets for COVID-19 vaccines, published on the European Medicines Agency [
27] portal, were consulted and it was found that the general rule is that vaccinated persons are not fully protected until 14 days after the second dose of vaccination. As a result of this, the graphical charts for the analysis were built for the interval March 15 2021 - March 31 2021 for all indicators except the vaccination indicator, which was delayed by 14 days, it being included in the chart for the interval March 1 - 14 2021.All the maps displayed in the comparative diagram show a value gradient with the minimum and maximum limits of the monitored indicator, in order to provide a correlation between image and value. The evolution of the monitored indicators over the whole mentioned time interval can be seen in full in
Appendix 2,
Figure 1,
Figure 2 and
Figure 3 showing the beginning, middle and end of the time interval. In the complete collection of information related to this research, published in the GitHub digital repository [
26], you can also find an animation showing the evolution of the 5 indicators per day.
The diagram-type reports, obtained by processing the data related to the 5 indicators, are equal in number to the monitored indicators and allow the observation of the evolution of these indicators at the level of each county in the interval 1 - 31 March 2021. The evolution of the incidence by county is presented in
Figure 4, and the rest of the diagrams can be seen in
Appendix 3.
From the analysis of the obtained reports, it can be seen that the tabular form of data presentation is capable of providing a good picture of the evolution compared by day, at county level or even compared between counties, as a result of the fact that the figures presented in the table are eloquent for the intended purpose. The diagram-type reports are superior to tabular reports, although the values are not explicitly displayed, but because the evolution per day, at county level, is easy to compare visually. Both types of reports have the weakness caused by the difficulty in comparing the simultaneous evolution of the five indicators.
The reports that are presented in the form of heatmaps maps are the most capable of providing a clear picture of how the five indicators change their values simultaneously over time, so that it can be understood whether the evolution of the values at the level of one of the indicators has an echo in the evolutions at the level of the other indicators. It is found that areas with a large number of vaccination centers, which are in fact also important territorial administrative units, have favorable developments of the indicators, in the sense that the incidence increases moderately, simultaneously with the number of PCR tests, the number of deaths is decreasing and the number of persons hospitalized at ICU remains low. Examples can be seen in
Appendix 2, in the western part of Romania, where there are two important counties, Timis and Arad, or in the central-western part of Romania, where Cluj County is located.
As a result of the fact that the volume of data is limited to one month, as shown in this paper, the possibilities to determine the influential inter-indicators are limited and practically difficult to apply. Consequently, in order to verify the possibilities of using the analysis based on the use of a geographic information system in the simulation process, the authors identified a way in which by changing one indicator a result is obtained that influences another indicator. The authors introduced, through simulation, an increase in the number of daily vaccinations with a total of 30,000 vaccinations at the level of each county. This total was distributed at the level of territorial administrative units in proportion to the number of vaccinations carried out in real terms, obtaining a new total of vaccinations at the level of territorial administrative unit, which is used in the proposed simulation.
It is considered that at the level of territorial administrative units, the conditions that lead to illness remain the same. The newly created situation by increasing the number of vaccinations leads to a reduction in the number of residents susceptible to being infected with COVID-19, as a result of the fact that vaccinated people become immune after 14 days, as mentioned in this paper.
As a result of the described framework for the simulation, the authors determined the relationship between the calculated incidence (i) and the number of people likely to get sick (l) from COVID-19. This number (l) is determined by excluding vaccinated persons (v), already infected persons (e) and deceased persons (d) from the total population (p) at the level of the territorial administrative unit (2). Theoretically, only these people can get sick with COVID-19. Using this principle, the authors determined the ratio between the incidence and the number of people likely to get sick with COVID-19 (3). This ratio is used to determine the new incidence, which could be achieved by increasing the number of vaccinations (v1) and implicitly by decreasing the number of people susceptible to the disease. Another incidence value (i1) is determined in this way (4).
Which are: s – sick; i – incidence; p – population; l – susceptible to illness; d - deceased; v – vaccinated; v1 – increased vaccination; i1 – incidence after increase vaccination
For example, you can see the new values in
Table 3.
In the QGIS project, the values obtained at the level of all territorial administrative units were used and the "Incidence with simulated increase of vaccination maps" maps were obtained.
Figure 5,
Figure 6 and
Figure 7 show in parallel the maps obtained with the actual incidence and the maps with the incidence obtained by increasing the number of vaccinations. It can be seen that the high incidence areas are smaller in size, the positive impact on the number of illnesses being obvious. Unfortunately, the lack of a larger volume of data limited the ability to determine interdependencies that can be used for further simulations.
Basically, in accordance with the objectives of the study and starting from the hypotheses on which the research is based, two results emerge that validate these hypotheses to a good extent:
R1 The maps obtained by assigning geographical characteristics to the data collected from the public health system allow the simultaneous observation of the effects and impact over the whole country, at one-day intervals, with the possibility of assessing the situation for the indicators used, direct comparison and monitoring of the daily evolution.
R2 The evolution of the indicators used generates a picture of the trend which, together with the proposed model, constitutes the support for making the forecast. Using this model, by modifying various parameters, such as increasing the number of tests, increasing, or decreasing the number of vaccinations, possibly opening, or closing vaccination centers decision-making efficiency can be improved.
Figure 1.
Vaccination map on March 1, 2021, Deaths, Admissions, Incidence, PCR tests on March 15, 2021.
Figure 1.
Vaccination map on March 1, 2021, Deaths, Admissions, Incidence, PCR tests on March 15, 2021.
Figure 2.
Vaccination map on March 9, 2021, Deaths, Hospitalizations, Incidence, PCR tests on March 23, 2021.
Figure 2.
Vaccination map on March 9, 2021, Deaths, Hospitalizations, Incidence, PCR tests on March 23, 2021.
Figure 3.
Vaccination map on March 17, 2021, Deaths, Hospitalizations, Incidence, PCR tests on March 31, 2021.
Figure 3.
Vaccination map on March 17, 2021, Deaths, Hospitalizations, Incidence, PCR tests on March 31, 2021.
Figure 4.
The incidence of COVID-19 in March 2021 by county.
Figure 4.
The incidence of COVID-19 in March 2021 by county.
Figure 5.
Incident map for March 15, 2021 with actual values and values used in the simulation.
Figure 5.
Incident map for March 15, 2021 with actual values and values used in the simulation.
Figure 6.
Incident map for March 23, 2021 with actual values and values used in the simulation.
Figure 6.
Incident map for March 23, 2021 with actual values and values used in the simulation.
Figure 7.
Incident map for March 31, 2021 with actual values and values used in the simulation.
Figure 7.
Incident map for March 31, 2021 with actual values and values used in the simulation.
Table 1.
Incidence by counties between March 1-31, 2021. (Cases per 1000 inhabitants in the last 14 days.)
Table 1.
Incidence by counties between March 1-31, 2021. (Cases per 1000 inhabitants in the last 14 days.)
COUNTY |
Day 1 |
Day 2 |
Day … |
Day 31 |
ALBA |
108.6217157 |
110.9866 |
… |
194.9185 |
ARAD |
81.81863005 |
84.23531 |
… |
169.8906 |
… |
… |
… |
… |
… |
VRANCEA |
49.9770577 |
48.66565 |
… |
72.30731 |
Table 2.
Vaccinations by counties between March 1-31, 2021.
Table 2.
Vaccinations by counties between March 1-31, 2021.
COUNTY |
Day 1 |
Day 2 |
Day … |
Day 31 |
ALBA |
851 |
819 |
… |
961 |
ARAD |
734 |
732 |
… |
1568 |
… |
… |
… |
… |
… |
VRANCEA |
459 |
504 |
… |
852 |
Table 3.
The new incidence obtained from the simulated increase in vaccinations per county between March 15-31, 2021. (Cases per 1000 inhabitants in the last 14 days.)
Table 3.
The new incidence obtained from the simulated increase in vaccinations per county between March 15-31, 2021. (Cases per 1000 inhabitants in the last 14 days.)
COUNTY |
Day 15 |
|
Day 23 |
Day … |
Day 31 |
ALBA |
129,9929236 |
|
154,4271419 |
… |
170,9672358 |
ARAD |
118,5443343 |
|
148,7452991 |
… |
154,2532665 |
… |
… |
|
… |
… |
… |
VRANCEA |
48,73829657 |
|
57,24509257 |
… |
65,06476179 |