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

The top 15UC-047

UC-047Transport, travel and tourismWorkflowVerified 23 Oct 2026

Who comes to Tromsø? Foreign guest nights by country

The marketing manager is planning media buying and marketing for next season together with the agency. She wants to see which countries the guest nights come from and whether a stronger krone explains the changes, and the figures are in a Statistics Norway (SSB) table with over 40 countries.

marketing manager at a destination company, Tourism organisation in Northern Norway

+7.8%
foreign hotel guest nights in Tromsø, August 2026 compared with August 2025 (36,414 to 39,256)
+17.8%
USA, largest market (5,859 nights)
−16.0%
Germany (4,521 nights)

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 did guest nights in Tromsø change in August 2026 compared with August 2025, by country? Which markets are growing and which are falling, and is it true that the krone exchange rate against the euro explains it?”

The tool chain

How the AI solves it

3 tools from Statistics Norway, Norges Bank.

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

  2. Statistics Norway

    ssb_search_tables “overnatting kommune” returns table 12894 (guest nights by municipality, type of accommodation and the guests’ country of residence, monthly 2024M01–2026M08).

  3. Statistics Norway

    ssb_get_data 12894 with Region 5501 (Tromsø), InnKvartering1 *, Landkoder2 * and Tid 2025M08 and 2026M08. The variables are called InnKvartering1 and Landkoder2; the first attempt with the wrong names returned an error message that showed the right names.

  4. Norges Bank

    norgesbank_get_exchange_rates with valuta=EUR, frekvens=maaned and fra=2025-10-01 returns monthly averages for the krone exchange rate.

  5. The AI calculates the change per country and compares euro countries with the USA and the UK.

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

The calls as they were run (5)
ssb_get_table_info
tabell12894
variabelLandkoder2
The table covers 2024M01–2026M08 (updated 2026-10-01), InnKvartering1 has 01 (hotels and similar accommodation establishments) and 02+03+04 (camping, holiday cottages, youth hostels), and Landkoder2 has 74 values (totals, countries and groups of countries) with codes.
ssb_get_data
tabell12894
utvalg{"Region":"5501","InnKvartering1":"01","Landkoder2":"*","ContentsCode":"Overnattinger","Tid":["2025M08","2026M08"]}
148 cells (74 countries and totals × 2 months). Gives the foreign total 36,414 → 39,256 with code 01, as in the catalogue.
ssb_get_data
tabell12894
utvalg{"Region":"5501","InnKvartering1":"01","Landkoder2":["ccc","000"],"ContentsCode":"Overnattinger","Tid":"*"}
64 cells: the foreign total and Norway for all 32 months, 2024M01–2026M08.
ssb_get_data
tabell12894
utvalg{"Region":"5501","InnKvartering1":"01","Landkoder2":"*","ContentsCode":"Overnattinger","Tid":"*"}
fraRad0, 1000 and 2000 (three pages of at most 1000 rows each)
The whole matrix of 2,368 cells (74 × 32), read by machine from the saved responses. The values match the two calls above, and the sum of all countries and groups of countries equals the foreign total in all 32 months.
norgesbank_get_exchange_rates
valuta["EUR","USD","GBP"]
frekvensmaaned
fra2024-01-01
One call per currency. Monthly averages for 33 months each, 2024-01 to 2026-09. No 2026-10 (the month is not over). EUR 11.8448 (2025-12) and 10.8003 (2026-09), as in the catalogue.

The figures

What the answer looks like

All figures were fetched live on 23 October 2026.

Germany was the largest in August 2025. Now the USA and Italy are ahead.

Foreign guest nights at hotels in Tromsø in August, the ten largest markets in 2026. Percentage change below the name.

August 2025August 2026
01,0002,0003,0004,0005,0006,000USA+17.8% from 20255,859Italy+20.7% from 20254,742Germany−16.0% from 20254,521United Kingdom+33.2% from 20252,800France+16.2% from 20252,437Finland−11.6% from 20252,409Switzerland+14.0% from 20252,082Poland+3.7% from 20251,675Spain+53.7% from 20251,625Sweden−19.4% from 20251,436

Source: Statistics Norway table 12894, region 5501 Tromsø, hotels and similar accommodation establishments. Fetched on 23 October 2026. The table shows all countries.

Spain (+54%) and the United Kingdom (+33%) are growing fastest, the Netherlands (−36%) is falling most

Change in foreign hotel guest nights in Tromsø, August 2026 compared with August 2025. Markets with at least 1,000 guest nights in one of the months (13 countries).

GrowthDecline
−40−200204060Spain54%United Kingdom33%Italy21%USA18%France16%Austria15%Switzerland14%China7%Poland4%Finland−12%Germany−16%Sweden−19%Netherlands−36%

Source: Statistics Norway table 12894, region 5501 Tromsø. Our own calculations: August 2026 divided by August 2025.

Small markets are left out because small numbers give large percentages. Slovakia, for example, grew by 184 per cent, from 62 to 176 guest nights.

Winter dominates: December 2025 had 95,292 foreign guest nights, August 36,414

Foreign guest nights at hotels in Tromsø per month, 2024 to August 2026.

202420252026
020,00040,00060,00080,000100,000JanFebMarAprMayJunJulAugSepOctNovDecAugust2026 39,256

Source: Statistics Norway table 12894, region 5501 Tromsø, hotels and similar. The table has 32 months, from January 2024.

The krone has strengthened by 8 to 9 per cent against the euro, dollar and pound since August 2025

Monthly average of the krone exchange rate, indexed to August 2025 = 100. A lower number means a stronger krone.

USDGBPEUR
859095100105Sep ’25NovJan ’26MarMayJulSepAugust 2025USD 92GBP 92EUR 91

Source: Norges Bank, monthly average of daily rates, NOK per unit of currency. The series ends in September 2026.

Does the exchange rate explain it?

Same exchange rate, different trends

Against the euro, the exchange rate is the same for all four euro countries below, but guest nights went in different directions: Germany −16%, Netherlands −36%, Italy +21%, Spain +54%. The krone also strengthened against the dollar and the pound, and the USA (+18%) and the United Kingdom (+33%) grew. A stronger krone can contribute, but the data shows that it does not explain the trend on its own. Correlation is not causation.

The result

Hotels in Tromsø in August: foreign guest nights 36,414 → 39,256 (up 7.8%). The USA up 18% (4,974 → 5,859), the UK 33%, Italy 21% and Spain 54%, while Germany is down 16% (5,383 → 4,521) and the Netherlands 36%. The krone became stronger against the euro (monthly average 11.84 in December 2025 against 10.80 in September 2026), but the growth from Italy and Spain shows that the exchange rate alone does not explain the change.

What you get out of it

The marketing manager and the agency get a data basis for geotargeting and budget allocation per market, and can test a hypothesis against figures instead of assuming.

The limits

What the data does not cover

Only guest nights at commercial accommodation establishments (not guests, revenue or day visitors), and the series only starts in 2024. Small countries have small numbers and noise, and co-variation with the exchange rate is not causation. The exchange rate is a monthly average; October has not been published yet.

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.
  • Norges BankNorges Bank’s terms (no named licence). Credit: Source: Norges Bank Taken from catalogue metadata or a general terms page, not from the source’s own terms for the data. No named licence. The terms are taken from Norges Bank’s general “Copyright and liability” page: copies may be made as long as Norges Bank is named as the source and the content is not changed, and Norges Bank takes no responsibility for errors in exchange rates, interest rates and statistics. It is not stated that the page applies to data.norges-bank.no, hence “indirect”.

Try more

Same tools, other questions

  • How did foreign guest nights in Tromsø change in the winter season from December to March, broken down by the ten largest countries?
  • Compare foreign hotel guest nights in Tromsø, Alta and Bodø in August 2026.
  • What was the krone exchange rate against the dollar and the pound in each month over the last year?

More use cases

Related