ssb-08487
Atlas view
ssb-08487
api_v1.indicators__ssb_08487Per-source indicator data for ssb-08487, 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 — always ssb-crime-tables for this Px bundle. |
| kommune_nr | Derived 4-digit kommune code when Gjerningssted is exactly one active kommune row; otherwise NULL for higher aggregates / historical codes ending in 99. |
| region_code | Raw SSB region identifier for the row — kommune, fylke, police district or country. Kept as its own column because 08487 mixes those levels and the last two fit neither kommune_nr nor fylke_nr. Part of the model's natural key. |
| fylke_nr | Derived 2-digit fylkesnummer only when region_code matches a fylke code pattern. |
| year | End calendar year parsed from Px two-year Tid code (YYYY-YYYY), used as fact-layer year. |
| contents_code | Composite key — region × offence × statistic × two-year interval (see SQL). |
| contents_label | Place label, offence label, metric label, and interval label concatenated for display. |
| value | Two-year average count or per-1-000 rate; NULL when suppressed upstream. |
| status | PxWebAPI cell-status character when value is withheld. |
| updated_at | ingest `loaded_at` from raw.ssb_08487. |
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_08487?limit=5
About this view
Per-source indicator data for ssb-08487, at the publisher's own grain.
Per-source indicator relation for `ssb-08487`, 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-08487.