demografia.poblacion_municipios
Total population per spanish municipio, disaggregated by sex.
- Time period: 1996-2024, anually
- Regional breakdown: municipios
Columns
| Name | Data Type | Is Nullable | Description |
|---|---|---|---|
| poblacion_municipios_id | serial | NO | primary key |
| municipio_id | int | NO | references geo.municipios |
| anio | int | NO | year |
| sexo | enums.sexo_enum | NO | sex |
| poblacion | int | NO | population |
Table definition
CREATE TABLE
demografia.poblacion_municipios (
poblacion_municipios_id serial PRIMARY KEY,
municipio_id int NOT NULL REFERENCES geo.municipios (municipio_id),
anio int NOT NULL CHECK (
anio BETWEEN 1900 AND EXTRACT(
YEAR
FROM
CURRENT_DATE
)
),
sexo enums.sexo_enum NOT NULL,
poblacion int NOT NULL CHECK (poblacion >= 0)
);
Notable transformations
- All dataset from all municipios were merged.
- Entries with aggregated data for province totals were dropped.
- Entries with missing values for
poblacionwere dropped. - Entries with total aggregated data for
sexwere dropped.
Source
Data extracted from Instituto Nacional de Estadística (INE) Consulted on 3 June 2025.