Skip to content

UK source packages: UC award-band distribution (incl. No payment) and Scotland age-of-youngest-child, April–December 2025 monthly histories #234

Description

@juaristi22

Facts request from the microcosm side (microcosm#840 assessment; microcosm#736 item 13). Companion to #188 and to the family-type × child-entitlement request.

Why

microcosm binds the whole dwp_universal_credit family and needs one temporal basis for it. The caseload headline is a calendar-year average of a monthly series (#184), and #188 gave family type and number of children their April–December 2025 histories — but two record sets still exist only as May 2025 snapshots:

  • dwp/uc_payment_distribution_may_2025 — Households on UC by Monthly Award Amount band × Family Type (28 bands incl. "No payment" and "£2500.01 or over"), 140 cells; 100 of them are bound as targets today.
  • the Scotland Age of Youngest Child record set (May 2025; binds dwp.uc.scotland_households_child_under_1).

A May snapshot partition cannot be sum-consistent with a calendar-average parent: the May family-type total is 6,584,442 against the 2025 average of 6,858,287 (+4.2%), and the childless cells alone grew 7–8% over April–December 2025.

What

Extend both record sets to monthly April–December 2025 (Stat-Xplore UC_Households, count measure, Great Britain for the bands; Scotland S92000003 for age of youngest child), keeping the publisher's exact band labels (the numeric bounds and any ×12 annualisation stay a downstream declaration, as the existing package notes say) and the "No payment" band.

Shape

As #188: facts-only, monthly period typing, benefit-unit entity, assertion: observation, provenance to the archived API response. Same package ids with an april_december_2025 suffix so the May packages can be retired the way the family-type ones were.

Consumer

The 100 dwp.uc.payment_distribution_* references and dwp.uc.scotland_households_child_under_1 in microcosm's uk_population_targets.json take value_operation: calendar_year_average alongside the headline, family-type and children cells.

🤖 Generated with Claude Code

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions