Disaggregated Municipal Energy Consumption and Emissions in End-use Sectors in Germany and Spain for 2022

Sectorally-detailed municipal energy consumption and emissions datasets are crucial for localized policy-making, resource allocation, and climate action planning. While some large municipalities develop bottom-up inventories, smaller ones often lack the capacity to do so. Existing studies have spatially disaggregated national totals, yet no dataset to date provides both energy consumption and emissions data across multiple sectors at the municipal level. This study addresses that gap by disaggregating national final energy consumption and emissions data in 2022 to the municipal level for Germany and Spain. The dataset covers five key end-use sectors: industry, transport, agriculture, households, and commerce. Where available, sub-sectors such as passenger and freight transport, or specific industries like chemical and paper manufacturing are further considered for disaggregation. Two main challenges are addressed: the limited availability of municipal-level proxies and the presence of missing values in proxy datasets. We apply XGBoost for imputation and implement a step-wise disaggregation using regional statistics. Using only open data, we ensure replicability, and assign confidence ratings to all values to support transparent interpretation.