The Open Government and Transparency portal has a specific module for Catalan councils that facilitates the automatic activation of different economic management indicators with the aim that, in a graphic, understandable and close format, it is easier for citizens to consult information related to the economic management of an entity.
The activation of the module by the councils is very simple because you only need to indicate "YES" in the menu that is offered. In addition, it is possible to activate the module both in the "home" of the transparency portal and in the access screen of the "Economic Management" family. Once activated, the new module makes it easy to display a series of indicators on the portal.
The working methodology has been to work with the available data to show comparable data between the different councils and to provide information on each council in the most reliable way possible, facilitating the visualization of data from the last 5 years, as well as to know their impact per inhabitant / year, or see the evolution with respect to the county, provincial and whole of Catalonia (provided that complete data have been available).
The model facilitates the visualization of the last 5 years, to know its impact by inhabitant / year, or to see the evolution with respect to the county, provincial and set scope of Catalonia.
The data, - in open and reusable format, - have been obtained from different supra-municipal sources that are public on the different open data portals of the entities that have the AOC's Transparency and Open Data Portal. Specifically, they have been activated in the different city council portals
In addition, in order to be able to show the impact at the inhabitant level and territorialize them, they have been combined with the census data available at MUNICAT, building new sets of aggregated data that make it easier for us to generate the published graphs and data associated with information at the population level and by territory. These data sets with aggregated and territorialized average data are also public on the corresponding open data portals.
Economic indicators available
The following describes the set of economic indicators available in the module as well as its data source:
BUDGET: How much does my council spend?
- Data on forecasts and initial credits from the City Council's budget with its local autonomous bodies (municipal companies are not included), with their evolution, according to the latest available data.
DEBT: How much does my council owe?
- Debt of the City Council with the financial institutions with its evolution, according to the latest available data.
INVESTMENTS: How much does my city council invest?
- Amount of Chapter 6 (real investments) as well as Chapter 7 (capital transfers), of the total settlement of the City Council budget with its local autonomous bodies (municipal companies are not included), with its evolution, according to the latest available data.
TAX CHARGE: What tax burden does my city council have?
- Sum of revenues per chapter 1 and 2 (taxes), taxes (articles 30, 31, 32, 33), special contributions (article 35) and urban quotas (concept 396) of the City Council with its local autonomous bodies (municipal companies are not included), divided by population (with its evolution, according to the latest available data).
CURRENT REVENUE: How much money does my city council have?
- They are the income that the municipality has to finance its usual activity, own income contributed by the citizens (taxes, taxes and public prices), patrimonial income, plus other people's income contributed mainly by the central or autonomic administration. The total amount of current income must cover at least current expenses and amortization.
- It includes chapters 1,2,4,5 of the budget settlement in its entirety. Also Chapter 3, which excludes special contributions and urban planning fees and income from urbanization actions.
- The data includes the rights recognized as income from the settlement of the consolidated budget of the entity with its local autonomous bodies (except public companies), with its evolution according to the latest available data.
CURRENT EXPENSES AND DEPRECIATIONS: How much money does my city council need to operate?
- These are the resources that the city council dedicates to its normal operation.
- It includes staff costs, current contracts, interest on loans and the return of the same, contributions for other current expenses to third parties such as individuals, public or private entities (via grants and subsidies), autonomous bodies, municipal companies, and other miscellaneous expenses.
- It includes chapters 1, 2, 3, 4 and 9 of the budget settlement in its entirety. Therefore current expenses plus credit repayments from the City Council budget with its local self-governing bodies (municipal companies are not included).
- In order to define the current expenses for the year, the total amount of the current expenses should be reduced by the recognized obligations financed with the cash balance of the previous year, as this information has not been made, this adjustment has not been made. .
YEAR SAVING CAPACITY: Is my city council solvent?
- It is understood as the difference between current income and current expenditure after paying the loans (amortizations) of the City Council budget with its local self-governing bodies (municipal companies are not included).
- A positive saving for the year indicates investment capacity, ability to borrow and in short: solvency.
- For the calculation of the net savings for the year established in art. 53 of the revised text of the Law Regulating Local Finances RD 2/2004, it is necessary to know the theoretical amortization annuity. The lack of this information for our calculation means using the amounts in Chapter 3 (interest) and 9 (amortization), and defining the concept of “ability to save for the year” as the difference between all current income and expenses. loans once the loan repayments have been paid.
The source of data to work all these indicators is mainly the Secretariat of Local Administrations and Relations with Aran, of the Department of the Presidency . Specifically, it is based on the following sets of supra-municipal and public data (which are published on the different transparency portals of each entity):
- Program budgets
- Estimates for expenses and income
- Detailed program budget settlement
- Settlement of the budget for expenses and income
Regarding the data set "Debt" the source has been the Ministry of Finance (MINHAP which publishes the living debt of municipalities continuously in:
This information, which is downloaded and converted to open data format after publication on the transparency portals, is the basis of the item's data source: indebtedness.
From these data sets we have performed the relevant calculations for the different indicators treated (following the different methodological descriptions above), and in order to show the impact at the inhabitant level and territorialize them, they have been combined with the data of census of inhabitants available in MUNICAT.
However, we have built new open (aggregate) data sets, which make it easier for us to generate published graphs and data associated with information at the population level and by territory. These data sets with aggregated and territorialized average data are also public on the corresponding open data portals. Specifically:
1.- Calculation of the economic summary of data by an entity (resource that collects the set of economic data of the entity with calculation of its impact linked to population):
http://dadesobertes.seu-e.cat/csv/resum-indicadors-economics-ens.csv
2.- Calculation of the summary of economic indicators aggregated by territories, (resource that collects the calculation of the summary of economic indicators aggregated by territories, based on the information of the data sets of budgets and indebtedness. From these sets of data has been incorporated for each entity its population data and has worked the territorial vision to offer the county, provincial and Catalan comparison):
http://dadesobertes.seu-e.cat/csv/resum-indicadors-economics-agregats-per-territoris.csv
In these data sets we have worked on the incorporation for each entity of its population data (according to the latest data published in Munich), as well as with the territorialization of the data to be able to offer the county, provincial and Catalan comparison. .
All these supra-municipal and public data sets can be found in the different open data portals of each entity. You also have the possibility to download the global data set at the following link: http://dadesobertes.seu-e.cat/
Description of views:
HIGHLIGHTS: a box shows a summary of the data in absolute value and per inhabitant, and the difference with respect to the previous year.
GRAPHIC INFORMATION: a graph shows the overall evolution of the last 5 years of the indicator, as well as a comparison in terms of territorialized population (region, province, Catalonia). It should be noted that in the absence of data grouped by the whole of a territory, the territorialized comparison collects the information until the last available year. At the same time, the entities (in internal manager mode) can also choose not to show averages for any of the indicators.
Finally, it should be noted that the publisher of the transparency portal of each entity has a space "Observations on the indicators" where each of us can make assessments, comments, publications of documents or links to clarify or provide more information. section, with the premise of making it as close as possible to the citizenry.
