Official Norway, the EU and world data in one MCPGet access

The top 15UC-001

UC-001Municipalities and countiesWorkflowVerified 23 Oct 2026

The ageing wave in figures: 80+ growth and use of services in Steinkjer

The planner needs to back up the social element of the municipal master plan and the financial plan with the number of older people the municipality will have and what current use of services implies. The figures are in two different Statistics Norway (SSB) tables (population projections and KOSTRA) that have to be found and combined by hand.

community planner in a municipality, Mid-sized municipality in Trøndelag (Steinkjer)

+42%
more residents over 80 in Steinkjer from 2026 to 2040 (1,666 to 2,362)
−13%
residents aged 0 to 24
about 770
users of home-based services in 2040 if use is unchanged, compared with about 540 today

The question

How to ask it

Write the question as you would ask a colleague. The question was run in Norwegian. This is a translation of it.

“How many residents over 80 will Steinkjer have in 2040 compared with today, what share of the over-80s use home-based services and institutional care today, and what does that mean for the number of users if use stays the same?”

The tool chain

How the AI solves it

3 tools from Statistics Norway.

  1. You ask the question in plain language. The AI chooses the tools.

  2. Statistics Norway

    ssb_search_tables “framskrevet folkemengde” returns table 14746 (regional projections, municipal level, 2026–2050, 9 alternatives).

  3. Statistics Norway

    ssb_get_table_info 14746 returns the municipality code 5006 for Steinkjer, the statistics variable “Personer” (the main alternative MMMM) and the age grouping agg_Funksjonell5 (0-24, 25-34, 35-44, 45-69, 70-79, 80+).

  4. Statistics Norway

    ssb_get_data 14746 with Region 5006, Alder (code list agg_Funksjonell5), ContentsCode Personer and Tid 2026 and 2040.

  5. Statistics Norway

    ssb_search_tables “KOSTRA omsorg” returns table 12209 (selected key figures for health and care, municipality, 2015–2025). ssb_get_data 12209 with the region variable KOKkommuneregion0000 = 5006 and Tid set to the latest year.

  6. The AI multiplies today’s shares by 80+ in 2040 and shows the difference from today.

  7. The AI answers with the figures and attaches the source and licence to them.

The calls as they were run (11)
ssb_get_table_info
tabell14746
Table 14746 “Framskrevet folkemengde 1. januar, etter kjønn og alder, i 9 alternativer (K) 2026-2050”, updated 2026-06-12: the variables Region, Kjonn, Alder (code list agg_Funksjonell5 = 0-24, 25-34, 35-44, 45-69, 70-79, 80+), ContentsCode (nine alternatives, Personer = the main alternative MMMM to Personer8 = MM00) and Tid 2026-2050.
ssb_get_table_info
tabell14746
variabelRegion
sokSteinkjer
Steinkjer is region 5006 (“Steinkjer - Stïentje”).
ssb_get_data
tabell14746
utvalg{"Region":"5006","Alder":"*","ContentsCode":"Personer","Tid":"*"}
kodelister{"Alder":"agg_Funksjonell5"}
150 cells: six age groups × 2026-2050, the main alternative. Gave alder_2026_2040, eldre_per_ar and valgfri_alder_alle_ar. Check against the catalogue: 80+ = 1,666 (2026) and 2,362 (2040), 0-24 = 6,631 and 5,773; they match.
ssb_get_data
tabell14746
utvalg{"Region":"5006","Alder":"*","ContentsCode":"*","Tid":"2040"}
kodelister{"Alder":"agg_Funksjonell5"}
54 cells: six age groups × nine alternatives for 2040. Gave alternativer_80_pluss_2040.
ssb_get_data
tabell14746
utvalg{"Region":"5006","ContentsCode":"Personer","Tid":"*"}
25 cells: total population (all ages, both sexes) per year. Gave valgfri_folkemengde_totalt and a check that the age groups add up to the total.
ssb_get_table_info
tabell12209
Table 12209 “Utvalgte nøkkeltall for helse og omsorg (K) 2015-2025”, updated 2026-06-15: the region variable KOKkommuneregion0000, 18 key figures in ContentsCode, Tid 2015-2025.
ssb_get_table_info
tabell12209
variabelKOKkommuneregion0000
sokSteinkjer
Steinkjer has three region codes: 5006 “Steinkjer - Stïentje”, 5004 “Steinkjer (2018-2019)” and 1702 “Steinkjer (-2017)”.
ssb_get_table_info
tabell12209
variabelKOKkommuneregion0000
soklandet
The whole country is the code EAK with the name “Landet” (EAKUO is “Landet uten Oslo”).
ssb_get_data
tabell12209
utvalg{"KOKkommuneregion0000":["5006","EAK"],"ContentsCode":["KOShjtj80aarover0001","KOSsykhjand80aar0000"],"Tid":"*"}
44 cells (2 regions × 2 key figures × 11 years). Steinkjer 5006 only has values from 2020 (2015-2019: null, status “.”); Landet has values for all years. Check against the catalogue: Steinkjer 2025 = 32.6 and 7.3; they match.
ssb_get_data
tabell12209
utvalg{"KOKkommuneregion0000":["5004","1702"],"ContentsCode":["KOShjtj80aarover0001","KOSsykhjand80aar0000"],"Tid":"*"}
44 cells for Steinkjer’s earlier region codes: 1702 has values for 2015-2017 and 5004 has values for 2018-2019. Gave valgfri_kostra_steinkjer_tidligere_koder.
get_data_licences
kildessb
Licence CC BY 4.0 and credit text for Statistics Norway (the sources field in the responses only has name, url and licence).

The figures

What the answer looks like

All figures were fetched live on 23 October 2026.

The number of people over 80 rises every year, from 1,666 in 2026 to 2,763 in 2050

Residents of Steinkjer on 1 January, the main alternative (MMMM). Ages 70 to 79 are included for comparison.

70–79 years80 years and over
05001,0001,5002,0002,5003,00020262030203520402045205080 years and over 2,76370–79 years 2,539

Source: Statistics Norway table 14746, region 5006 Steinkjer, alternative MMMM (main alternative), both sexes combined. Fetched on 23 October 2026.

The group aged 70 to 79 is largest in 2042 (2,915) and then falls to 2,539 in 2050.

Only the 70–79 and 80+ age groups are growing. All younger groups are shrinking.

Residents of Steinkjer by age group, 1 January 2026 and 1 January 2040. In total, the population goes from 24,007 to 23,011 (−4.1%).

20262040
02,0004,0006,0008,0000–2425–3435–4445–6970–7980+5,7732,4132,5916,9842,8882,362

Source: Statistics Norway table 14746, region 5006, alternative MMMM, age grouping agg_Funksjonell5. Fetched on 23 October 2026.

If use is unchanged, home-based services will have about 230 more users

The number of people over 80 multiplied by today’s share using the service. The calculation shows what unchanged use means, not what the need is.

about 770
users of home-based services in 2040, compared with about 540 today
about 170
in institutional care in 2040, compared with about 120 today
32.6%
of people over 80 used home-based services in 2025 (whole country 24.8%)
7.3%
were in institutional care in 2025 (whole country 9.0%)

Formula: 1,666 × 32.6% = 543 and 2,362 × 32.6% = 770 for home-based services. Institutional care: 1,666 × 7.3% = 122 and 2,362 × 7.3% = 172. Source: Statistics Norway table 14746 and KOSTRA table 12209 (2025).

Steinkjer uses home-based services more often and institutional care less often than the whole country

This applies to every year from 2020 to 2025. The KOSTRA figures for Steinkjer (region 5006) start in 2020. Earlier years use other region codes and are not included.

Home-based services

Share of residents aged 80 and over, per cent.

Whole countrySteinkjer
01020304020202021202220232024202532.6%24.8%

Source: Statistics Norway KOSTRA, table 12209.

Institutional care

Share of residents aged 80 and over, per cent.

Whole countrySteinkjer
05102020202120222023202420259.0%7.3%

Source: Statistics Norway KOSTRA, table 12209.

All nine alternatives give between 2,204 and 2,522 people over 80 in 2040

Residents over 80 in Steinkjer on 1 January 2040 in Statistics Norway’s nine projection alternatives. The main alternative is highlighted.

01,0002,0003,000High national growthHHMH2,522Strong ageingLHML2,522High net immigrationMMMH2,363No migrationMM002,363Main alternativeMMMM2,362Low net immigrationMMML2,361No net immigrationMMM02,361Weak ageingHLMH2,206Low national growthLLML2,204

Source: Statistics Norway table 14746, region 5006, nine alternatives, both sexes combined. Fetched on 23 October 2026.

The alternatives that change immigration and migration give almost the same figure (2,361 to 2,363). The alternatives for national growth and ageing give the widest spread.

The result

Steinkjer goes from 1,666 to 2,362 residents over 80 (up 42%) between 2026 and 2040, while the 0–24-year-olds fall from 6,631 to 5,773 (down 13%). Today 32.6% of the over-80s use home-based services and 7.3% have an institutional stay; unchanged use means about 770 users of home-based services in 2040 (compared with about 540) and about 170 with an institutional stay (compared with about 120).

What you get out of it

A sourced set of figures for the financial plan and the social element in minutes instead of days, with a clear line between the Statistics Norway projection and the municipality’s own assumptions.

The limits

What the data does not cover

The projection is the main alternative; Statistics Norway has eight other alternatives that show the uncertainty. An unchanged rate of use is a simplification, and the KOSTRA share applies to 2025. The figures say nothing about capacity, staffing or health status. The KOSTRA table uses a different region variable from the other Statistics Norway tables.

Sources and licence

How to credit the figures

The licences were read through TRY Innsyn on 22 October 2026. This overview is not legal advice. Check the source’s terms before you promise a client anything.

  • Statistics Norway (SSB)CC BY 4.0. Credit: Source: Statistics Norway, licence CC BY 4.0 Read on the source’s own page. Statistics Norway writes that the APIs use CC BY 4.0, like the rest of ssb.no. The page gives no credit line.

Try more

Same tools, other questions

  • What is the projection for people over 80 in Levanger and Verdal up to 2040, and what share uses home-based services there today?
  • How many children aged 6 to 15 will Steinkjer have in 2030 and in 2040 in the main alternative?
  • What is the difference between the main alternative and “Strong ageing” for people over 80 in Steinkjer, year by year up to 2050?

More use cases

Related