ssb-09406
Atlas view
ssb-09406
api_v1.indicators__ssb_09406Per-source indicator data for ssb-09406, at the publisher's own grain.
Built from
This Atlas view joins data from the following upstream sources. Click through for provenance, methodology, and citation.
Showing direct dbt parents. See full lineage in /lineage/ →
Columns
| Column | Description |
|---|---|
| source_id | Canonical catalogue identifier — ssb-crime-tables Px bundle row. |
| kommune_nr | Always NULL —Px table publishes national aggregates only. |
| fylke_nr | Always NULL. |
| year | Observation year from SSB Tid dimension. |
| contents_code | Concatenates LovbruddKrim Px code and ContentsCode statistic identifier. |
| contents_label | Concatenates offence taxonomy label with statistic label from Px metadata. |
| value | Offence counts or oppklaringsprosent; unit depends on contents_code; NULL when suppressed. |
| status | PxWebAPI cell-status when value withheld. |
| updated_at | ingest `loaded_at` from raw.ssb_09406. |
Sample query
Live PostgREST query that returns the first 5 rows. URL adapts to the current host — local dev shows api-atlas.localhost; the deployed site shows the configured API base.
https://api-atlas.urbalurba.com/indicators__ssb_09406?limit=5
About this view
Per-source indicator data for ssb-09406, at the publisher's own grain.
Per-source indicator relation for `ssb-09406`, published at the grain the publisher
actually uses rather than flattened into the cross-source views.
🔴 stability:source — the column set here follows the publisher, not Atlas. If the
publisher adds, renames or drops a dimension, this relation changes with it. That is
the deliberate trade for getting the real grain; prefer a stability:curated relation
if you need a shape Atlas promises to hold still. Decode codes through
meta_dimensions filtered to source_id=ssb-09406.