Mediebruk_DataTVspill_Ungdata_KH
Atlas view
Mediebruk_DataTVspill_Ungdata_KH
api_v1.indicators__fhi_mediebruk_spillPer-source indicator data for fhi-mediebruk-spill (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. |
| region_code | FHI GEO verbatim — kommune, fylke, bydel or national. |
| kommune_nr | 4-digit kommune code, via region_code_to_kommune_nr — NULL for every region that is not a municipality. Not a bare four-digit regex; that is what called Svalbard a kommune. |
| region_kind | What the GEO code is; joins ref_region_kind. |
| fylke_nr | 2-digit fylke code where GEO is a fylke, else NULL. |
| year | First year of the period. |
| period | FHI AAR verbatim, e.g. "2024_2024". |
| period_start_year | Parsed first year of the period. |
| period_end_year | Parsed last year of the period. |
| sex | all / male / female, decoded from FHI KJONN. |
| ungdata_cohort | FHI ALDER verbatim, always "1_6". ⚠️ An Ungdata survey-cohort identifier, NOT ages 1 to 6. Unverified against Ungdata methodology — carried rather than interpreted. |
| threshold | The degenerate topic slice FHI reports for this table. |
| socioeconomic_status | FHI SOES. "0" is combined; only fhi-depresjon carries the 1/2/3 breakdown. |
| contents_code | SMR or MEIS. |
| contents_label | Human-readable gloss for contents_code. |
| value | The measured value. NULL where FHI suppressed the cell. |
| status | FHI suppression marker. |
| updated_at | When the raw row was loaded. |
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_mediebruk_spill?limit=5
About this view
Per-source indicator data for fhi-mediebruk-spill (Folkehelseinstituttet), at the publisher's own grain.
Per-source indicator relation for `fhi-mediebruk-spill` (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-mediebruk-spill.