DSA210 / Data & provenance

Know what is in the panel.

The 2015–2024 snapshots are versioned, checked and downloadable. “No missing values” is never inferred from a total row count.

Coverage, before any imputation

Non-missing values out of 120 months per country.
CountryRowsCCIRetailUnemploymentInflation
Germany120120120120120
Spain120120120120120
Turkey120120120120120
UK12012006971

The UK is not silently completed

UK retail is absent for every month; it is excluded from retail-target models. UK unemployment is observed for 69 months and inflation for 71. Missing controls are imputed from training-fold medians with missingness indicators. No CCI or retail target is imputed.

A working data dictionary

FieldUnitDefinition / scope
CCIIndex, long-term average 100Official OECD CCICP, amplitude adjusted; consumer-confidence survey index.
sunshine_hourshours per monthFive-city fixed-population-weighted monthly sunshine; seconds converted to hours.
sunshine_capital_hourshours per monthLondon, Berlin, Madrid, Ankara snapshots; sensitivity analysis only.
temperature_2m_mean°CPopulation-weighted city monthly average of daily means.
temperature_2m_max / min°CWeighted mean of city monthly daily-temperature extrema; not a national extreme.
precipitation_sum / rain_summm per monthWeighted city monthly totals.
precipitation_hourshours per monthWeighted monthly duration from source snapshot.
retail_indexVolume index, 2021=100Eurostat snapshot (G47, seasonal/calendar adjusted per notebook); UK unavailable.
unemployment_rate%Eurostat control snapshot; some UK months missing.
inflation_yoy% year-on-yearHICP control snapshot; some UK months missing. Raw percentages are retained.
covid_dummy0 / 11 from March 2020 through June 2022; a coarse control, not a policy-effects estimate.
month_sin / month_cosunitlessCyclical calendar controls; deterministic, no fitted parameters.

Take the evidence with you

What the snapshot cannot recover

Source vintage matters

CCI was retrieved on 31 October 2026. Weather, retail and macro inputs are versioned snapshots. Their exact source retrieval timestamps and the raw Eurostat responses were not retained. These are revised historical values, not a real-time vintage.

Country weather is a proxy

Five selected cities do not represent every household. Fixed population weights are documented in the notebook, but their reference year was not recorded. Open-Meteo uses reanalysis/model estimates; no new station observations were collected.