Trangbodd_UTDANN
Atlas view
Trangbodd_UTDANN
api_v1.indicators__fhi_trangboddPer-source indicator data for fhi-trangbodd (Folkehelseinstituttet), 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 source identifier for the upstream table this row came from — the same id used by meta_sources and meta_dimensions. |
| region_code | The publisher's own region code, verbatim. It may be a kommune, fylke, bydel or national code depending on what that publisher emits; region_kind says which. |
| kommune_nr | 4-digit kommune code, derived via region_code_to_kommune_nr. NULL for every region that is not a municipality. ⚠️ Not a bare four-digit match — that is what once called Svalbard, Jan Mayen and the continental shelf municipalities. |
| fylke_nr | 2-digit fylke code where the region is a fylke, else NULL. |
| year | First year of the period this row covers. ⚠️ For a multi-year window this is the FIRST year, not the only one — read period_start_year and period_end_year for the span. |
| period | The publisher's own period code, verbatim (e.g. "2024_2024"). |
| period_start_year | Parsed first year of the period. |
| period_end_year | Parsed last year of the period. |
| age_group | The publisher's age-band dimension, verbatim. Bands are not always disjoint — an "all ages" bucket usually sits alongside the slices, so summing without filtering double-counts. |
| age_group_min | Numeric floor of age_group, parsed from the band's "min_max" form. NULL where the band has no finite floor. |
| age_group_max | Numeric ceiling of age_group, parsed from the band's "min_max" form. NULL for an open-ended band. |
| parents_education | 🔴 The PARENTS' education level, not the pupil's — this table breaks completion down by parental education. Upstream's UTDANN code; decode through ref_fhi_utdann. |
| parents_education_label_no | Norwegian label for parents_education, joined from ref_fhi_utdann. NULL where the code has no entry there. |
| housing_status | Housing-status code (upstream BODD) as the publisher emits it. |
| contents_code | The publisher's code for WHICH measure this row reports. Decode it through meta_dimensions for this source_id. |
| contents_label | Human-readable gloss for contents_code. |
| value | The measured value. NULL where the publisher suppressed the cell — see status. |
| status | The publisher's own suppression or quality marker for this cell, passed through verbatim. |
| updated_at | When Atlas last loaded this row from the upstream. |
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__fhi_trangbodd?limit=5
About this view
Per-source indicator data for fhi-trangbodd (Folkehelseinstituttet), at the publisher's own grain.
Per-source indicator relation for `fhi-trangbodd` (Folkehelseinstituttet), published at the grain the publisher
actually uses rather than flattened into the cross-source views.
🔴 stability:source — the column set here follows Folkehelseinstituttet, 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=fhi-trangbodd.