Barnevern kommunemonitor
Atlas view
Barnevern kommunemonitor
api_v1.indicators__bufdir_barnevernPer-source indicator data for bufdir-barnevern, 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 | Atlas catalogue id for this ingest — always bufdir-barnevern. |
| indicator_api_id | Stable surrogate workbook id — bv_zip_ind_<code> (e.g. bv_zip_ind_1a), or bv_zip_<24 hex SHA-256> fallback. |
| indicator_slug | Normalised slug from the upstream indicator name; used as part of contents_code. |
| indicator_group_slug | Fixed literal barnevern_zip for ZIP-ingested rows. |
| indicator_name | Workbook-derived indicator title concatenated above the Region header rows. |
| indicator_title | Same human-facing title chain as indicator_name after ZIP parsing. |
| link_text | NULL for workbook-backed rows. |
| region_code | Geographic code string from workbook column Region, verbatim from upstream. It may be a kommune, fylke, bydel, Svalbard, or national code; region_kind says which. |
| region_kind | What region_code is, from classify_region_code: kommune · fylke · svalbard · bydel · nasjon · unknown. |
| kommune_nr | Four-digit kommune code, derived through region_code_to_kommune_nr so Svalbard-shaped codes are correctly NULL rather than misclassified as a kommune. NULL for other geography levels. |
| fylke_nr | Two-digit fylke code when region_code is exactly two digits; NULL otherwise. |
| category_format | Tallformat column — andel (share/decimal-formatted, not limited to 0-100) or antall (count). There is no category_unit column for this source. |
| year | Calendar year of the observation. |
| contents_code | Atlas-normalised variable code: prefix `bv_`, the indicator slug, and category_format joined with `__`, so each measure is filter-stable in the catalogue. |
| contents_label | Human-readable label combining the workbook title with the andel/antall format. |
| value | Numeric value for this year; NULL when the upstream series omits this year. |
| values_json | Parse of Sheet1 rows into year keys (spreadsheet blanks / suppression → JSON null values). |
| updated_at | Timestamp 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__bufdir_barnevern?limit=5
About this view
Per-source indicator data for bufdir-barnevern, at the publisher's own grain.
Per-source indicator relation for `bufdir-barnevern` (Barne-, ungdoms- og familiedirektoratet), published at the grain the publisher
actually uses rather than flattened into the cross-source views.
🔴 stability:source — the column set here follows Barne-, ungdoms- og familiedirektoratet, 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=bufdir-barnevern. Sibling of
mart_indicators__bufdir_barnefattigdom — no category_unit column here, and
category_format uses "andel" (this source's own vocabulary), not "prosent".