Repository navigation
Emit the council-tax band columns of NRS dwellings by 2022 data zone (nrs-dwellings-data-zone-2025) #419
Description
Summary
PolicyEngine/microcosm#931 conditions each household clone's area draw on the council-tax band the FRS records. England and Wales weight each output area by its LSOA's band mix (VOA CTSOP1.1). Scotland uses its council's mix (CTAXBASE 2025), so within a council the band says nothing about where a household lives. In review on PolicyEngine/microcosm#1519, Vahid pointed out that NRS publishes dwellings by band for every 2022 data zone, and Scotland's 2022 output areas nest in those zones.
Chronicle already registers that workbook as nrs-dwellings-data-zone-2025, but emits only its total (nrs.dwellings_total). This issue asks for the eight band columns as facts too.
Until they exist, Microcosm will read the band columns from the registered bytes, pinned by sha256, on PolicyEngine/microcosm#1519. Once Chronicle emits them, Microcosm will vendor the facts instead, as it does the CTAXBASE council mix. The numbers won't change, but the cells will be parsed and checked in one place, and each value will carry its source record id.
Requested
In both record sets, nrs.dwellings_data_zone_2025.2024 and nrs.dwellings_data_zone_2025.2025, add eight measures beside nrs_dwellings_total, in its shape: unit count, aggregation sum, expected cell type number, header row 5.
| Column | Header | Suggested concept |
|---|---|---|
| G | Council Tax band:\nA |
nrs.dwellings_band_a |
| H | Council Tax band:\nB |
nrs.dwellings_band_b |
| I | Council Tax band:\nC |
nrs.dwellings_band_c |
| J | Council Tax band:\nD |
nrs.dwellings_band_d |
| K | Council Tax band:\nE |
nrs.dwellings_band_e |
| L | Council Tax band:\nF |
nrs.dwellings_band_f |
| M | Council Tax band:\nG |
nrs.dwellings_band_g |
| N | Council Tax band:\nH |
nrs.dwellings_band_h |
\n is the line break inside the header cell.
- A check. Please add a test that the eight bands sum to
nrs.dwellings_totalin each data zone. They do in all 7,392 zones of both sheets, with no blank or suppressed cell. - Size. That is 118,272 new facts (7,392 zones × 8 bands × 2 sheets). If bundle size matters, the 2024 sheet alone (59,136 facts) is the one Microcosm reads. December 2024 is nearest the FRS 2024-25 year and VOA's stock at 31 March 2025.
Already registered, no action needed
- The workbook.
dwelling-estimates-by-2022-data-zones-24-25.xlsx: sha2565d61db5faf7e81451d838e5d394b8e0682bbf501341c1220aea4a78082ceb033, 1,223,284 bytes, added in 265fb7e. - The map from output area to data zone. In the May 2026 NSPL (
ons-nspl-may-2026), Scotland'slsoa21cdis the 2022 data zone. Each of the 46,282 Scottish output areas it lists falls in exactly one of the workbook's 7,392 zones.
Disclosure note
Every item requested here is a published area aggregate. Nothing is derived from survey records.
Activity
Draw Scotland's band weights from each data zone's NRS mix
Merge main (chronicle#419's NRS data zone bands) into chronicle#420's…
Merge main (chronicle#419's NRS data zone bands) into chronicle#420's…