Befolkningsframskriving

Befolkningsframskriving
Folkehelseinstituttet ·fhi-prognoseFHI Folkehelsestatistikk table 171 — population projections (Befolkningsframskriving) by region × age band × forecast year. Pairs with fhi-befolkning (table 338) so observed and projected trajectories splice naturally.
raw.fhi_prognose| geo_code | aar_code | kjonn_code | alder_code | prognoseaar_code | measure_type | value | status | loaded_at |
|---|---|---|---|---|---|---|---|---|
| 0 | 2024_2024 | 0 | 0_120 | 2030 | TELLER | 5744565 | — | 2026-05-06T14:34:10.319+00:00 |
| 0 | 2024_2024 | 0 | 0_120 | 2040 | TELLER | 5976950 | — | 2026-05-06T14:34:10.319+00:00 |
| 0 | 2024_2024 | 0 | 0_120 | 2050 | TELLER | 6114899 | — | 2026-05-06T14:34:10.319+00:00 |
| 0 | 2024_2024 | 0 | 0_24 | 2030 | TELLER | 1556913 | — | 2026-05-06T14:34:10.319+00:00 |
| 0 | 2024_2024 | 0 | 0_24 | 2040 | TELLER | 1522281 | — | 2026-05-06T14:34:10.319+00:00 |
Provenance
171SOCI2026-05-06T14:34:15.011801+00:00 · 38,037 rows · 1 runUsed 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.
No Atlas views consume this dataset yet — it may be a reference table or recently added.
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.
No co-occurring datasets in Atlas yet.
Dimensions
| Code | Meaning | Value format | Notes |
|---|---|---|---|
| GEO | Region (mixed kommune / fylke / bydel / nasjon) | 1- to 6-character numeric code | ~409 codes |
| AAR | Base year of the projection (anchor year) | "YYYY_YYYY" range string | The year the forecast is anchored on — *not* the year being projected. PROGNOSEAAR is the target. |
| KJONN | Sex | 3 codes upstream; Atlas filters to 1 | "0" both (Atlas only ingests this) — re-ingest for sex-stratified slice |
| ALDER | Age band | "min_max" range string | 31 codes — includes the universal 0_120, 5-year disjoint slices (0_4, 5_9, …, 100_120), and aggregates (0_17, 45_64, 80_120). Pick a single non-overlapping partition downstream. |
| PROGNOSEAAR | Year being projected to (target year) | 4-digit year as text | 26 codes upstream (per-year out to ~2050+). Atlas keeps 3 horizons: 2030, 2040, 2050. Add intermediate years as a sibling source if 5-year resolution is needed. |
| MEASURE_TYPE | Which number | 3 codes upstream; Atlas filters to 1 | TELLER (count) only — RATE / SMR are derivable downstream from these counts. |
Sample query
Live PostgREST query that returns the first 5 rows of raw.fhi_prognose. URL adapts to the current host — local dev shows api-atlas.localhost; the deployed site shows api-atlas.sovereignsky.no.
https://api-atlas.sovereignsky.no/fhi_prognose?limit=5
Citation
Folkehelseinstituttet. (n.d.). Befolkningsframskriving. Retrieved from https://statistikk.fhi.no/nokkel/xhjU-zpSijmY8w2E1Zhcrzqbt_xSfLCoudR2O1jYTbM?GEO=0,03,31,32,33,34,39,40,42,11,46,15,50,18,55,56&AAR=2024_2024&KJONN=0&ALDER=0_17,80_120&PROGNOSEAAR=2030,2035,2040,2045,2050&MEASURE_TYPE=TELLER. Available in Atlas at https://atlas.sovereignsky.no/datasets/fhi-prognose.
@misc{atlas_fhi_prognose,
author = {Folkehelseinstituttet},
title = {Befolkningsframskriving},
year = {n.d.},
url = {https://statistikk.fhi.no/nokkel/xhjU-zpSijmY8w2E1Zhcrzqbt_xSfLCoudR2O1jYTbM?GEO=0,03,31,32,33,34,39,40,42,11,46,15,50,18,55,56&AAR=2024_2024&KJONN=0&ALDER=0_17,80_120&PROGNOSEAAR=2030,2035,2040,2045,2050&MEASURE_TYPE=TELLER},
note = {Available in Atlas at https://atlas.sovereignsky.no/datasets/fhi-prognose}
}
https://atlas.sovereignsky.no/datasets/fhi-prognose