Skip to main content

Bosettingstall

Atlas view

Bosettingstall

api_v1.indicators__imdi_bosetting

Per-source indicator data for imdi-bosetting (Integrerings- og mangfoldsdirektoratet), 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​

ColumnDescription
source_idAtlas catalogue id for this ingest — always imdi-bosetting.
kommune_nameKommune name verbatim from IMDi's own table row label — IMDi publishes no kommune code.
kommune_nrFour-digit kommune code, resolved via crosswalk_kommune_name restricted to active kommune names. NULL when IMDi's spelling doesn't match (measured live 2026-10-01: 7 of 359 distinct names, all fylke-disambiguation-suffix or spelling differences — see indicators__imdi_bosetting.sql).
yearCalendar year, from the page's own section heading and the discovered URL.
metricWhich stage of the resettlement pipeline: anmodet (requested), vedtatt (decided), bosatte (settled), bosatte_kollektiv_beskyttelse (settled, collective protection), avtalt (agreed — not present for every kommune-year), or avtalt_kollektiv_beskyttelse (agreed, collective protection).
contents_codeAtlas-normalised variable code: fixed prefix `imdi_bosetting__` joined with metric, so each measure is filter-stable in the catalogue.
contents_labelHuman-readable Norwegian label for the metric.
valueThe metric's value for this kommune and year. NULL when IMDi suppressed the cell (its own marker, the literal character ":") or published free text instead of a number.
updated_atTimestamp when the row was last written by ingest (from raw.loaded_at).

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__imdi_bosetting?limit=5

About this view​

Per-source indicator data for imdi-bosetting (Integrerings- og mangfoldsdirektoratet), at the publisher's own grain. Per-source indicator relation for `imdi-bosetting` (Integrerings- og mangfoldsdirektoratet), published at the grain the publisher actually uses rather than flattened into the cross-source views. One row per (kommune_name, year, metric). 🔴 stability:source — the column set here follows Integrerings- og mangfoldsdirektoratet, 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=imdi-bosetting.