| Literature DB >> 33076238 |
Enrique Arvelo1, Jesica de Armas1, Monserrat Guillen2.
Abstract
In this work, we establish a methodological framework to analyze the care demand for elderly citizens in any area with a large proportion of elderly population, and to find connections to the cumulative incidence of COVID-19. Thanks to this analysis, it is possible to detect deficiencies in the public elderly care system, identify the most disadvantaged areas in this sense, and reveal convenient information to improve the system. The methods used in each step of the framework belong to data analytics: choropleth maps, clustering analysis, principal component analysis, or linear regression. We applied this methodology to Barcelona to analyze the distribution of the demand for elderly care services. Thus, we obtained a deeper understanding of how the demand for elderly care is dispersed throughout the city. Considering the characteristics that were likely to impact the demand for homecare in the neighborhoods, we clearly identified five groups of neighborhoods with different profiles and needs. Additionally, we found that the number of cases in each neighborhood was more correlated to the number of elderly people in the neighborhood than it was to the number of beds in assisted living or day care facilities in the neighborhood, despite the negative impact of COVID-19 cases on the reputation of this kind of center.Entities:
Keywords: COVID-19; care system; data analytics; elderly population
Mesh:
Year: 2020 PMID: 33076238 PMCID: PMC7602505 DOI: 10.3390/ijerph17207486
Source DB: PubMed Journal: Int J Environ Res Public Health ISSN: 1660-4601 Impact factor: 3.390
Figure 1Barcelona’s population pyramid, 2020.
Data sources.
| Index | Data Table | Source |
|---|---|---|
| 1 | Neighborhood population by gender | Open Data BCN |
| 2 | Neighborhood population by age | Open Data BCN |
| 3 | Neighborhood population by age quantiles | Open Data BCN |
| 4 | Neighborhood population by gender and age | Open Data BCN |
| 5 | Neighborhood disabled population by age quantiles | Open Data BCN |
| 6 | Neighborhood population living alone by age | Open Data BCN |
| 7 | Censual Districts population demographics | Open Data BCN |
| 8 | Neighborhood RFID index | Government Report |
| 9 | Geographic outlines | GitHub [ |
| 10 | Assisted living facilities | Open Data BCN |
| 11 | Day care centers | Open Data BCN |
| 12 | COVID-19 | Barcelona Municipal Data Office |
Figure 2Increments in between-cluster variance.
Figure 3Maps of clusters.
Figure 4Robustness check dendrogram using Ward clustering.
Misclassifications.
| K-Means | Ward | n |
|---|---|---|
| One | Five | 1 |
| Four | One | 10 |
| Four | Three | 1 |
| Four | Five | 1 |
Hit rate.
| Cluster | Hit Rate | |
|---|---|---|
| Overall | 60/73 | 82.2% |
| One | 12/13 | 92.3% |
| Two | 14/14 | 100% |
| Three | 7/7 | 100% |
| Four | 17/29 | 58.7% |
| Five | 10/10 | 100% |
Regression analysis for the number of confirmed cases of COVID-19 in Barcelona by neighborhood until 20 July 2020 (standard errors are displayed in parenthesis under the coefficient estimates, n = 73 neighborhoods).
| Variable | (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) |
|---|---|---|---|---|---|---|---|---|
| Elderly Population | 0.021 1 | 0.021 1 | 0.021 1 | 0.021 1 | 0.021 1 | 0.021 1 | 0.021 1 | 0.021 1 |
| (0.002) | (0.001) | (0.001) | (0.002) | (0.002) | (0.001) | (0.002) | (0.002) | |
| RFID | −0.401 1 | −0.415 1 | −0.414 1 | −0.413 1 | −0.508 1 | −0.519 1 | −0.516 1 | −0.520 1 |
| (0.101) | (0.105) | (0.105) | (0.106) | (0.13) | (0.133) | (0.133) | (0.134) | |
| % of Disabled Elderly | −1.85 | −1.765 | −1.763 | −1.856 | ||||
| (1.427) | (1.416) | (1.417) | (1.435) | |||||
| DC Capacity | −0.026 | −0.044 | −0.047 | −0.066 | ||||
| (0.125) | (0.133) | (0.125) | (0.134) | |||||
| AL Capacity | 0.006 | 0.008 | 0.005 | 0.008 | ||||
| (0.019) | (0.02) | (0.019) | (0.02) | |||||
| Total Facility Capacity | 0.005 | 0.003 | ||||||
| (0.018) | (0.018) | |||||||
| Constant | 45.544 1 | 46.367 1 | 46.273 1 | 46.282 1 | 96.024 2 | 94.584 2 | 94.417 2 | 96.947 2 |
| (10.864) | (11.013) | (11.018) | (11.088) | (40.404) | (40.207) | (40.211) | (40.715) | |
| Observations | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 |
| R2 | 0.785 | 0.785 | 0.785 | 0.785 | 0.79 | 0.79 | 0.79 | 0.791 |
| Adjusted R2 | 0.775 | 0.776 | 0.776 | 0.773 | 0.778 | 0.777 | 0.777 | 0.775 |
| Residual Std. Error | 36.157 (df = 69) | 36.144 (df = 69) | 36.151 (df = 69) | 36.380 (df = 68) | 35.980 (df = 68) | 36.000 (df = 68) | 36.008 (df = 68) | 36.201 (df = 67) |
| F Statistic | 83.882 1 (df = 3; 69) | 83.960 1 (df = 3; 69) | 83.919 1 (df = 3; 69) | 62.183 1 (df = 4; 68) | 63.953 1 (df = 4; 68) | 63.864 1 (df = 4; 68) | 63.827 1 (df = 4; 68) | 50.572 1 (df = 5; 67) |
1p < 0.01; 2 p < 0.05.
Regression analysis for the cases per 100,000 residents in Barcelona by neighborhood until 20 July 2020 (standard errors are displayed in parenthesis under the coefficient estimates, n = 73 neighborhoods).
| Variable | (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) |
|---|---|---|---|---|---|---|---|---|
| % of Elderly | 27.360 1 | 25.544 1 | 25.679 1 | 26.504 1 | 26.491 1 | 25.028 1 | 25.202 1 | 25.428 1 |
| (4.194) | (4.168) | (4.202) | (4.211) | (4.821) | (4.868) | (4.885) | (4.846) | |
| RFID | −2.065 1 | −2.286 1 | −2.260 1 | −2.223 1 | −2.205 1 | −2.366 1 | −2.335 1 | −2.397 1 |
| (0.383) | (0.397) | (0.4) | (0.397) | (0.538) | (0.555) | (0.555) | (0.552) | |
| % of Disabled Elderly | −2.27 | −1.252 | −1.174 | −2.768 | ||||
| (6.084) | (5.986) | (6.006) | (6.052) | |||||
| DC Capacity | −0.316 | −0.585 | −0.343 | −0.623 | ||||
| (0.405) | (0.446) | (0.414) | (0.457) | |||||
| AL Capacity | 0.062 | 0.106 | 0.062 | 0.108 | ||||
| (0.069) | (0.076) | (0.069) | (0.077) | |||||
| Total Facility Capacity | 0.045 | 0.045 | ||||||
| (0.064) | (0.064) | |||||||
| Constant | 120.975 | 155.419 | 151.546 | 145.196 | 199.628 | 199.332 | 192.58 | 241.573 |
| (95.199) | (96.341) | (96.774) | (96.16) | (231.587) | (231.256) | (231.475) | (231.876) | |
| Observations | 73 | 73 | 73 | 73 | 73 | 73 | 73 | 73 |
| R2 | 0.532 | 0.534 | 0.532 | 0.545 | 0.533 | 0.534 | 0.532 | 0.547 |
| Adjusted R2 | 0.512 | 0.514 | 0.511 | 0.519 | 0.506 | 0.507 | 0.504 | 0.513 |
| Residual Std. Error | 136.391 (df = 69) | 136.186 (df = 69) | 136.494 (df = 69) | 135.482 (df = 68) | 137.250 (df = 68) | 137.140 (df = 68) | 137.456 (df = 68) | 136.277 (df = 67) |
| F Statistic | 26.190 1 (df = 3; 69) | 26.338 1 (df = 3; 69) | 26.116 1 (df = 3; 69) | 20.389 1 (df = 4; 68) | 19.432 1 (df = 4; 68) | 19.491 1 (df = 4; 68) | 19.323 1 (df = 4; 68) | 16.163 1 (df = 5; 67) |
1p < 0.01.
Figure 5Location of AL/DC and total cases.
Figure 6Location of AL/DC and cases per 100,000.