drinkable water consumption in Spain over the last 10 years trend

Model: Kimi K2.6 Checked on:

Spain’s public water supply to households — the standard proxy for drinkable (potable) water consumption — shows a clear downward trend over the most recent 10‑year span available in Eurostat (2010‑2020). Volumes fell from about 2,740 million cubic meters in 2010 to roughly 2,234 million cubic meters in 2020, a decrease of ~18.5%12. The decline was fairly steady through the early 2010s, flattened somewhat between 2013 and 2018, and then accelerated again in 2019‑2020, with 2020 recording the lowest value in the decade. The trend is illustrated in the figure produced from the analysis1.

  1. Dataset: env_wat_cat

    Images

    spain_household_water_trend.svg

    Dataset filters for env_wat_cat

    FilterValue(s)
    geoES
    sinceTimePeriod2010

    Program output

    Public Water Supply to Households in Spain (MIO_M3):
 time   value
 2010 2740.00
 2011 2553.05
 2012 2511.80
 2013 2419.27
 2014 2428.05
 2015 2454.31
 2016 2483.65
 2017 2472.10
 2018 2460.60
 2019 2350.00
 2020 2234.00

Change from 2010 to 2020: -506.00 MIO_M3 (-18.5%)

    Code

    import pandas as pd
import matplotlib.pyplot as plt

# Load the filtered dataset
df = pd.read_csv(DATASET_FILE)

# Filter for Public Water Supply to Households
mask = (df['wat_proc'] == 'PWS') & (df['nace_r2'] == 'EP_HH')
household_pws = df[mask].copy()

# Convert time to int and sort
household_pws['time'] = household_pws['time'].astype(int)
household_pws = household_pws.sort_values('time')

print("Public Water Supply to Households in Spain (MIO_M3):")
print(household_pws[['time', 'value']].to_string(index=False))

# Plot
plt.figure(figsize=(10, 6))
plt.plot(household_pws['time'], household_pws['value'], marker='o', linestyle='-', color='steelblue')
plt.title('Spain - Public Water Supply to Households (Drinkable Water)')
plt.xlabel('Year')
plt.ylabel('Million cubic meters (MIO_M3)')
plt.grid(True, alpha=0.3)
plt.xticks(household_pws['time'], rotation=45)
plt.tight_layout()
plt.savefig('spain_household_water_trend.svg')
plt.close()

# Calculate change from earliest to latest year in this filtered set
first_year = household_pws['time'].min()
last_year = household_pws['time'].max()
first_val = household_pws[household_pws['time'] == first_year]['value'].values[0]
last_val = household_pws[household_pws['time'] == last_year]['value'].values[0]
pct_change = ((last_val - first_val) / first_val) * 100

print(f"\nChange from {first_year} to {last_year}: {last_val - first_val:.2f} MIO_M3 ({pct_change:+.1f}%)")
  2. Eurostat dataset: Water use by supply category and economical sector