October 28, 2020

The cases of COVID-19 and the incidence of infections in 14 days, municipality to municipality



Source: autonomous communities

The map shows the numbers of confirmed cases of COVID-19 in each municipality of the autonomous communities that have published their data of infected in each locality. To date, the following communities are included: Community of Madrid, Euskadi, Catalunya, Cantabria, Canarias, Murcia, Asturias, Baleares, Andalucía, La Rioja, Comunidad Valenciana, Navarra and Castilla-La Mancha, which are the ones that have published their figures. Castilla-La Mancha only includes confirmed cases in recent weeks and does not publish their accumulated data since the beginning of the epidemic. In addition, this medium has included confirmed cases from the most populated localities in Extremadura and Castilla y León.

The data for each municipality show the same variable: the number of people who have tested positive for coronavirus and their place of residence has been identified. For some communities the data of positives by PCR test and by rapid antibody test are included. Madrid, the Balearic Islands, La Rioja, Navarra, Extremadura, Castilla y León, Murcia and the Valencian Community only publish data from PCR analytics.

In addition, the number of new cases detected by PCR test in the last 14 days has been included for all the autonomous communities included by this means. The following graph shows the ranking of large municipalities (more than 40,000 inhabitants) according to the number of confirmed cases in the last 14 days in relation to their population.

The date and time of update of each community depends on each one of them: some update the data every day and others take longer to update the figures. The update time also differs between the different autonomous communities. More details on the methodology.

In total, the figures collected add up to more than 700,000 cases of coronavirus in which the municipality of residence of the infected person has been identified. Of the 15 autonomous regions analyzed, Madrid is the city with the most infected people detected in a single municipality. However, the municipalities with the highest incidence rate (cases per 100,000 inhabitants) are small localities in which an outbreak can affect a larger proportion of the population.

It must be taken into account that the number of cases is closely related to the ability to detect them by health authorities. That is, the more tests or analyzes performed, the more cases detected. How many confirmed cases are there in each municipality? Check it out in the following table.



Several communities have refused to publish data by municipality to avoid the social stigmatization of small municipalities with many infected. This is the case of the Autonomous Government of La Rioja, which at first was not going to publish data by locality and now publishes them from the municipalities with more than 10 cases.

Balearics, according to this last minute information, refused at first to share his data, although in the end he has published it. Extremadura, under the same criteria, has only referred to this medium the cases in the 8 most populated municipalities in the region. Castilla y León is only publishing its figures by health areas and eldiario.es has only included the cases confirmed by PCR from the basic areas that group a single municipality.

However, these data are essential to combat an epidemic: they make it possible to detect sources of contagion and act accordingly, provide more information to local administrations and regional governments of neighboring communities, and facilitate the analysis of the impact of the epidemic.

This analysis makes it possible to verify in which areas there is a higher incidence rate based on variables such as average income, percentage of the population over 65 years of age or population density. Precisely, from all administrations hundreds of statistics are published broken down by municipality: population by age, country of birth, nationality, average income, data on registered unemployment, level of studies or mortality rates.

Countries such as Germany, the United Kingdom or the United States publish their data on confirmed cases at the district, local authority and county level, an administrative level similar to a municipality in Spain.

How this map was made

This map created by eldiario.es has been compiled by compiling the numbers of confirmed cases by municipality of residence published by each autonomous community. The figures are updated with the latest data available in each autonomous community.

Why isn’t my community coming out? Only the autonomies that have opened their data on confirmed COVID-19 cases in each municipality have been included. Some communities have not published disaggregated data at the local level and others are publishing data by district or health area.

If you are responsible for data in an autonomous community and your figures are not included in this map, you can write an email to [email protected]

Where does the data come from? Each autonomous community is publishing its data in a different way. Madrid, Catalunya Y Euskadi They are publishing their data in an open format so that anyone can reuse it.

The Region of Murcia publishes them in an epidemiological report in PDF and Canary Islands, Balearic Islands and Cantabria they publish their figures on an interactive map. Asturias has published its data in an epidemiological report.

In the case of Andalusia, the figures for the municipalities of each province have been published on the website of the Junta de Andalucía. La Rioja publishes its figures on its open data portal for municipalities with more than 10 cases. The Valencia Community has published its figures on the open data portal.

Are they all updated at the same time and day? No. The date and time of the update depends on each autonomous community and the map will include the latest available data. If you click on each municipality, the date of update of the figures appears.

The Community of Madrid published its reports every 24 hours and now it does so every week. The Generalitat de Catalunya updates its data several times a day but at different times each day. The figures for Cantabria are modified every day including the cases notified until 8 in the afternoon.

Confirmed cases in the Basque Country were updated every 24 hours and now they do so every week. The Government of the Canary Islands updates its data twice a day. Murcia updates its data with more delay: it takes several days to update its epidemiological report.

Most communities have changed their formats and hours of updating the figures as the epidemic has progressed.

What happens if my municipality says that there are no cases detected? This does not mean that there are no infected people among the residents of the municipality. The number of confirmed cases depends on the number of tests carried out by each autonomous community. In other words, if many analytical tests have been performed in a municipality, it is more likely that there are more confirmed cases.

In addition, some autonomous communities such as Madrid or Murcia do not break down the data for municipalities with less than 5 cases. And the Generalitat de Catalunya includes some positives in “other municipalities” without identifying the locality. For these cases, it has been specified that no data is available. La Rioja does not include the figures for municipalities with less than 10 infected people.

In the cases of Extremadura, Navarra and Castilla y León, the figures for the less populated municipalities have not been included since they have not been obtained from the autonomous administrations.

Castilla-La Mancha only publishes the figures for municipalities with more than 1,000 inhabitants and does not publish the accumulated total. It only makes public the confirmed cases in the last two weeks without specifying the type of test carried out or further details.

Why is there no data on deceased and recovered persons? Only three communities (Canarias, Cantabria, Andalucía) have released their data on deaths and people cured in each municipality. That information will be included when more communities begin to include that information.

.



Source link