Barnevern kommunemonitor

Barnevern kommunemonitor
Barne-, ungdoms- og familiedirektoratet ·bufdir-barnevernBarne-, ungdoms- og familiedirektoratet (Bufdir) publishes the Barnevern kommunemonitor on bufdir.no and ships a single bulk ZIP of indicator workbooks ("last ned hele datasettet"), the same mechanism as the sibling Barnefattigdom monitor. Atlas downloads that ZIP (URL discovered from the monitor page), parses sheet `Sheet1` in each standard-coded workbook, and loads kommune- and sub-kommune-level child-welfare time series into `raw.bufdir_barnevern` — contact with, and removal into, the child-welfare system, alongside spending, staffing, and deadline-compliance indicators. Plugs the barnevern axis Report #2 (Child Welfare / Vulnerability Composite) is missing today. One of 24 workbooks in the live bundle (`Turnover_kommunalt barnevern_2016-2024.xlsx`) has a structurally different layout and is excluded — see `parse.ts`'s `isStandardIndicatorWorkbook`.
Provenance
barnevern-monitorSOCIUsed in Atlas views
These Atlas views (api_v1.* PostgREST endpoints) include this dataset in their input. Click through for the sample query, column list, and lineage.
api_v1.atlas_inventory
What Atlas publishes: one row per endpoint with its row count, freshness and origin.
Barnevern kommunemonitor
Per-source indicator data for bufdir-barnevern, at the publisher's own grain.
Joined with
Datasets that co-occur with this one inside Atlas's dbt models — the datasets you'd typically combine with this one in a real query.
brreg-enheter-allemart_atlas_inventorybrreg-frivilligemart_atlas_inventorybrreg-oppdateringermart_atlas_inventorybrreg-underenhetermart_atlas_inventorybufdir-barnefattigdommart_atlas_inventoryfhi-alkoholmart_atlas_inventoryfhi-befolkningmart_atlas_inventoryfhi-befolkningsvekstmart_atlas_inventoryDimensions
| Code | Meaning | Value format | Notes |
|---|---|---|---|
| indicator_api_id | Stable surrogate indicator key for ZIP workbook rows (not Strapi) | bv_zip_ind_<code> (e.g. bv_zip_ind_1a), or bv_zip_<24 lowercase hex> fallback | Derived from the workbook filename's leading alphanumeric code (1a, 3m, 4f, ...) — Barnevern's indicator codes are alphanumeric, never purely numeric like the sibling Barnefattigdom source's Indikator_<n>. Hash fallback for any non-conforming filename. |
| region_code | Geographic code from workbook column Region | 0 (land), 2-digit fylke, 4-digit kommune, or 6-digit codes for bydel rows | Rows follow whatever geography levels each indicator publishes. |
| category_format | Workbook column Tallformat, normalised lowercase | antall or andel | Barnevern's own vocabulary — "andel" (share), not the sibling Barnefattigdom source's "prosent", verified live 2026-10-01 across all 23 standard workbooks. Despite the name, "andel" values are not all 0-100 percentages (e.g. kroner-per-child expenditure figures also use it) — treat it as "Norwegian-decimal formatted", not "is a percentage". Also: Barnevern's workbooks have no Enhet column (unlike the sibling Barnefattigdom source) — there is no category_unit dimension here. |
| year | Calendar year column from workbook header row | 4-digit integer | Spines differ by indicator — observed range 2015-2025 across sampled workbooks. |
| values_json | Parsed year→value map for the geography and category_format slice | JSON object with string year keys; suppressed cells as null | Matches the sibling source's raw semantics (full spine per slice). |
Sample query
Ingested, not yet published. Atlas holds this source but no published relation carries it yet, so there is no query to run against the public API. Its rows are in Atlas; the modelling that would expose them has not been done. See meta_sources.served_as — an empty value is exactly this state.
Citation
Barne-, ungdoms- og familiedirektoratet. (n.d.). Barnevern kommunemonitor. Retrieved from https://www.bufdir.no/statistikk-og-analyse/monitor/barnevern/. Available in Atlas at https://atlas.sovereignsky.no/datasets/bufdir-barnevern.
@misc{atlas_bufdir_barnevern,
author = {Barne-, ungdoms- og familiedirektoratet},
title = {Barnevern kommunemonitor},
year = {n.d.},
url = {https://www.bufdir.no/statistikk-og-analyse/monitor/barnevern/},
note = {Available in Atlas at https://atlas.sovereignsky.no/datasets/bufdir-barnevern}
}
https://atlas.sovereignsky.no/datasets/bufdir-barnevern