analisis.v_indicadores_anuales_provinciales_unificados
The analisis.v_indicadores_anuales_provinciales_unificados view consolidates the main annual indicators that are available at province level. Every year contributes 52 rows (one per province), and any indicator without data for a province-year combination remains NULL in the unified output. This makes it possible to join the view safely with other yearly provincial datasets without losing the geographic universe.
Source views
The unified view draws from the following intermediate views defined in sql/views.sql. All of them align their outputs on the same (anio, provincia_id) keys before being joined together.
Indicators included
| Indicator | Table | Intermediate view | Aggregation logic | Time period |
|---|---|---|---|---|
poblacion_provincia |
demografia.poblacion_municipios |
analisis.v_poblacion_provincial |
Sum of municipal population for men and women | 1996-2024 |
matrimonios_heterosexuales |
demografia.matrimonios_heterosexuales |
analisis.v_matrimonios_heterosexuales_anual |
Sum of marriages where estado_civil_anterior = 'Total' |
1975-2023 |
matrimonios_homosexuales_hombres |
demografia.matrimonios_homosexuales |
analisis.v_matrimonios_homosexuales_anual |
Sum of marriages between men | 2005-2023 |
matrimonios_homosexuales_mujeres |
demografia.matrimonios_homosexuales |
analisis.v_matrimonios_homosexuales_anual |
Sum of marriages between women | 2005-2023 |
feminicidios_pareja_expareja |
violencia_genero.feminicidios_pareja_expareja |
analisis.v_feminicidios_pareja_expareja_anual |
Sum of reported femicides (zeros are backfilled when no records exist) | 2003-2024 |
huerfanos_menores |
violencia_genero.feminicidios_pareja_expareja |
analisis.v_feminicidios_pareja_expareja_anual |
Sum of orphaned minors (available from 2013 onwards; earlier years remain NULL) |
2013-2024 |
menores_victimas_mortales |
violencia_genero.menores_victimas_mortales |
analisis.v_menores_victimas_mortales_anual |
Sum of victims (zeros are backfilled when no records exist) | 2013-2024 |
servicio_016_contactos |
violencia_genero.servicio_016 |
analisis.v_servicio_016_anual |
Sum of calls, WhatsApp, emails and chats (zeros are backfilled when no records exist) | 2008-2024 |
atenpro_usuarias_activas |
violencia_genero.usuarias_atenpro |
analisis.v_atenpro_usuarias_activas_anual |
December measurement (end-of-year active users; missing years remain NULL) |
2005-2024 |
dispositivos_electronicos_seguimiento_activos |
violencia_genero.dispositivos_electronicos_seguimiento |
analisis.v_dispositivos_electronicos_seguimiento_anual |
December measurement (end-of-year active devices; missing years remain NULL) |
2009-2024 |
denuncias_vg_pareja |
violencia_genero.denuncias_vg_pareja |
analisis.v_denuncias_vg_pareja_anual |
Sum of complaints (zeros are backfilled when no records exist) | 2009-2024 |
prestaciones_maternidad |
educacion_juventud.prestaciones_maternidad_paternidad |
analisis.v_prestaciones_maternidad_paternidad_anual |
Sum of maternity benefits (percibidas_madre + percibidas_padre when tipo = 'Maternidad') |
2002-2019 |
prestaciones_paternidad |
educacion_juventud.prestaciones_maternidad_paternidad |
analisis.v_prestaciones_maternidad_paternidad_anual |
Sum of paternity benefits (percibidas_padre when tipo = 'Paternidad'; NULL before 2007) |
2007-2019 |
tasa_actividad |
economia_laboral.tasa_actividad_paro_empleo_provincias |
analisis.v_tasa_actividad_paro_empleo_anual |
Average of the four quarterly totals for the year | 2002-2024 |
tasa_empleo |
economia_laboral.tasa_actividad_paro_empleo_provincias |
analisis.v_tasa_actividad_paro_empleo_anual |
Average of the four quarterly totals for the year | 2002-2024 |
tasa_paro |
economia_laboral.tasa_actividad_paro_empleo_provincias |
analisis.v_tasa_actividad_paro_empleo_anual |
Average of the four quarterly totals for the year | 2002-2024 |