spd_release¶
directory release this record came from
| Table | Type | Nullable | Category | In the CSV export | SQL Server type |
|---|---|---|---|---|---|
history table (postcode_simd_history, SPD) |
string | no | derived from the NRS record | yes | nvarchar(200) |
Provenance in the history table (postcode_simd_history, SPD)¶
Where it comes from
| Input | Field | Condition | Reaches the row by |
|---|---|---|---|
simd_ingest/sources.yaml: spd_release (registry) |
spd_release |
the row itself |
Scope: the row itself.
What was done to it: registry. The SPD release the registry pins, the same on every row. (code: simd_ingest/core/spd.py)
How it is checked (what each check tests; whether a build passed it is in that build's manifest.json["checks"])
spd.primary_key_unique: the key (pc_norm, introduced_on) is unique and never nullspd.primary_key_nonnull: the key (pc_norm, introduced_on) is unique and never nullreadback.history.index_columns: the saved file's NRS columns equal the source, re-read
Why: two-nrs-cuts