Introduction

What is a management rating agency?

It is a tool that, through data analysis, seeks to systematize the information from different areas of public administration and produce general management indices that allow evaluating the comprehensive performance of public policies implemented by a given government.

Why is it necessary to qualify a management?

Every time the debate is opened on how good or bad a government administration has been, each part of the discussion uses data that argue its position, either against or in favor. What we seek with this work is not to end the debate, but to generate certainty in the midst of so much opinion.

What is the objective of the management rating agency?

The objective is to provide clarity to citizens regarding how their city is being administered. The lack of clarity, either due to a lack of public data or due to their excess, creates a difficulty for public opinion to understand what is happening in their locality.

How is management rated?

We have developed an index that makes it possible to evaluate each management in a comprehensive way and thus arrive at a single indicator that quantifies how the result of the government's management was. To achieve this, we have surveyed the different variables that are under the orbit of public administration and analyzed their temporal evolution. Each item is compared with its value from the previous year, measuring the difference in percentage, to know not only if it improved or worsened but also in what proportion. All these variables were grouped into six areas: health, education, security, economy, environment and infrastructure. Then a general management index is prepared that quantifies the percentage of variables that showed a positive, negative evolution or that do not register differences with respect to the previous period. In this way, it is possible to have a concrete result about the general performance of a government, being able to later delve into the details of each area and its variables.

It should be noted that all the information has been obtained from official sources. At the end of the document, the methodology and information sources of each variable are detailed.

Seville city 2018

With its 688,592 inhabitants, Seville is the fourth most populous city in Spain. It has the fourth annual budget per city with more than seven hundred and seventy-seven thousand seven hundred and sixty-five million euros.

The following graph shows the evolution of management in the city of Seville in 2016. The methodology used to prepare the graph was to take one hundred percent of the analyzed variables and disaggregate what percentage improved compared to the previous year, which they stayed the same and those that got worse. So each year is only comparable to its previous one.

Percentage of data on the total surveyed

The following graph shows the evolution of the capacity of each City Council to collect data. The range is from 0 to 100, where 100 represents all the data that each administration should have in order to carry out diagnoses, plan public policies and measure their impact.

Town Councils ranking by data survey

Seville's position in the comparison of data offices of the 15 most populous cities in Spain.

2017 5º Mejor oficina de datos

2016 5º Mejor oficina de datos

2015 5º Mejor oficina de datos

2014 5º Mejor oficina de datos

En los años 2011, 2012, 2013, 2014, 2015, 2017 y 2018, Sevilla no llega a medir el 50 % de las variables, que, es el mínimo necesario para poder realizar una calificación. Para visualizar las ciudades que sí cumplen los requisitos establecidos para ser calificadas ingrese a: https://blancocp.com.ar/gestion-mas-destacada-del-ano/

All the variables analyzed were grouped into six management areas. Next, the evolution of each one will be detailed. At the end of the document are the justifications for the variables selected in each case.

Variables evolution

Health

The goal of health is for the population to live as many years and as healthy as possible. For this reason, we chose to take into account these three variables that specifically measure this: the need for medical care, life expectancy and infant mortality.

Infant mortality 2004-2017

Enfermedades de declaración obligatoria cada 100.000 habitantes 2014-2018

There are no data published by the City Council on life expectancy.

Education

Currently education is essential to improve the quality of life, so the lack of it, either in people without any type of education or with only a complete primary level, is a central limitation in the development of people. On the other hand, higher studies were taken into account since with the advancement of information and technology, the specification of knowledge becomes essential.

No hay datos publicados por parte del Ayuntamiento sobre ninguna de las seis variables que componen el área de educación.

Security

Security is about being able to live without fear, both of being killed and being hurt. Being able to travel with the peace of mind that nobody and nothing jeopardize physical integrity or material assets.

Death from road accidents 2014-2017 rate per one hundred thousand inhabitants

Criminality evolution 2014-2019 rate per thousand inhabitants

Homicides evolution 2014-2019 rate per one hundred thousand inhabitants

Economy

Variables that measure people's economy have been chosen. The rest of the data produced by the government in this section are important to understand the phenomenon at a global level but do not reflect personal situations. For example, the gross product of a city can grow at the same time that unemployment increases or poverty increases.

There are no data published by the City Council on any of the variables that make up the economy area.

Income data is obtained from AEAT and unemployment data is provided by the Ministry of Employment and Social Security.

Unemployment evolution 2014-2019

Average income 2014-2017

Evolution poverty risk rate, no data published by the City Council

Environment

In this item, all the existing variables that measure the state of the environment in which we live were taken, in order to establish its evolution over time.

The variables to be surveyed are the following: green spaces, road trees, generation of garbage per inhabitant, percentage of recycled garbage, noise and air pollution.

Amount of kilograms of garbage generated per inhabitant 2014-2018

Selective collection percentage of total garbage 2014-2018

There are no data published by the City Council on any of the other four variables that make up the environment area.

Infrastructure

Depending on the level of development of each city, the growth in the supply of certain public services such as paved blocks may be limited by the physical restriction to continue increasing their services. The main challenge in this area is undoubtedly the production of renewable energy, both for its collaboration with the environment and for its sustainability and economic future.

Kilometers of sewerage per thousand inhabitants 2016-2018

There are no data published by the City Council on any of the other variables that make up the area of

Methodology

Currently, cities produce a large amount of data related to management, with a level of detail and segmentation that is important for officials who must prepare diagnoses and solutions, but not necessarily relevant for citizens who focus on results.

To cite just one example, there is the possibility of accessing information on not only the number of people who were ill during the year, but also what type of illnesses they were, in what areas of the city they live, etc. This degree of detail is of utmost importance when developing public policies aimed at preventing diseases. But what citizens are asking is how efficient their officials are at reducing diseases. It is for this reason that we focus on variables that measure global results only.

Another valid clarification has to do with the fact that each city is comparable with itself and with the data it offers; among the data that governments produce we choose the important ones, surely there could be other interesting data that are not being officially released.