September 19, 2020

The cases of COVID-19, municipality to municipality, in Madrid, Catalonia and the communities that publish data



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 and Comunidad Valenciana, which are the ones that have published their figures. 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 is included. Madrid, the Balearic Islands, La Rioja, Extremadura, Castilla y León and the Valencian Community only publish data from PCR analytics.

In addition, the number of new cases detected by PCR testing in the last 14 days has been included for the 10 autonomous communities that publish this figure broken down by municipality.

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 350,000 cases of coronavirus in which the municipality of residence of the infected person has been identified. Of the 13 autonomies analyzed, Madrid is the city with the most infected 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 the 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, at first refused 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 allows us 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 raulsanchez@eldiario.es.

Where does the data come from? Each autonomous community is publishing its data in a different way. Madrid, Catalunya and 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 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 and Castilla y León, the figures for the less populated municipalities have not been included since they have not been obtained from the regional administrations.

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