HL060 Helt ledige. Fylke og kommune. Tidsserie måned.
HL060 Helt ledige. Fylke og kommune. Tidsserie måned.
Arbeids- og velferdsdirektoratet ·nav-helt-ledigeNAV (Arbeids- og velferdsetaten) publishes HL060 on its helt-ledige (fully unemployed) statistics page: the count and share of the labour force registered as fully unemployed, per kommune, as one xlsx workbook covering every month of the current calendar year to date. Atlas downloads that workbook (URL discovered from the page — a relative `/_/attachment/download/...` link, re-resolved each run since it changes with every release) and loads the `3. Kommune Antall` and `4. Kommune Prosent av arbeidsst` sheets into `raw.nav_helt_ledige`. Atlas's fourth NAV-adjacent source, and the third source on the `monthly_sources_refresh` Dagster job built for `nav-uforetrygd` and already reused by `nav-aap` — no new job. v1 tracks the live current-year file only; whether a historical archive exists for this specific table was checked and found inconclusive from a static-HTML scan (same as `nav-aap`, unlike `nav-uforetrygd`'s clean archive) — backfill is deferred, not resolved.
Provenance
HL060SOCIUsed 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.
api_v1.atlas_inventory
What Atlas publishes: one row per endpoint with its row count, freshness and origin.
Helt ledige månedsstatistikk (HL060)
Per-source indicator data for nav-helt-ledige (Arbeids- og velferdsdirektoratet), at the publisher's own grain.
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.
brreg-enheter-allemart_atlas_inventorybrreg-frivilligemart_atlas_inventorybrreg-oppdateringermart_atlas_inventorybrreg-underenhetermart_atlas_inventorybufdir-barnefattigdommart_atlas_inventorybufdir-barnevernmart_atlas_inventoryfhi-alkoholmart_atlas_inventoryfhi-befolkningmart_atlas_inventoryDimensions
| Code | Meaning | Value format | Notes |
|---|---|---|---|
| region_code | Geographic code from the workbook row label, or the literal text "Ukjent" | 4-digit kommune code (including the Svalbard pseudo-kommune 2100), or the literal string Ukjent (NAV's own unknown-region bucket) | Confirmed live 2026-10-02: this table has NO fylke rows (bare "I alt <name>" rollup rows are excluded, not summed) and NO bydel rows at all — every real region row is a 4-digit code, including Svalbard's own pseudo-kommune code 2100. The one exception is "Ukjent" (NAV's own region-not-determinable bucket), which carries no numeric code at all and — unusually for this session — is ALSO the literal label of its own fylke-level header row (that header row carries zero data and is dropped by the ingest's existing hasData guard; only the data-bearing kommune-level "Ukjent" leaf row survives). region_kind is derived downstream via classify_region_code, which correctly falls through to its existing `unknown` branch for a non-numeric label — no macro change needed; 2100 resolves via the existing `^21\d{2}$` svalbard branch. ⚠️ Unlike nav-aap, "Ukjent" is present in BOTH sheets here (359 distinct regions in both Antall and Prosent — 357 kommuner + Svalbard's 2100 + Ukjent) — but every one of its month cells in the Prosent sheet is NAV's own suppression marker (`*`), not a real share. Do not assume the nav-aap asymmetry (357 vs 358) carries over to this source; it was checked independently and does not hold. |
| category_format | Which sheet the row came from, not a column within a sheet | antall or prosent | antall = "3. Kommune Antall" (count); prosent = "4. Kommune Prosent av arbeidsst" (share of the labour force). Named "prosent" rather than nav-aap's "andel" to match this table's own sheet-name vocabulary. |
| year | Calendar year, read from the sheet's own period-label cell (e.g. 'Januar - august 2026') | 4-digit integer | One year per file — the live file is replaced in place as the year progresses. ⚠️ A different period-label shape than AAP155's "Periode: <year> <mm> - <year> <mm>" cell — this table's own cell reads "<Month> - <month> <year>", confirmed live. Each NAV table's own cell was read directly, not assumed uniform across the family. |
| month | Calendar month, from the sheet's own Norwegian month-name header row | 1-12 integer | A plain integer column, same shape as nav-uforetrygd/nav-aap — no dim_period reference. |
| values_json | Parsed month->value map for the region and category_format slice, for this sheet's year | JSON object with string month-number keys; suppressed cells (NAV's own `*` marker) as null | Matches the full month spine present in the live file (partial-year, growing monthly). |
Sample query
Ingested, not yet published. Atlas holds this source but no published relation carries it yet, so there is no query to run against the public API. Its rows are in Atlas; the modelling that would expose them has not been done. See meta_sources.served_as — an empty value is exactly this state.
Citation
Arbeids- og velferdsdirektoratet. (n.d.). HL060 Helt ledige. Fylke og kommune. Tidsserie måned.. Retrieved from https://www.nav.no/no/nav-og-samfunn/statistikk/arbeidssokere-og-stillinger-statistikk/helt-ledige. Available in Atlas at https://atlas.sovereignsky.no/datasets/nav-helt-ledige.
@misc{atlas_nav_helt_ledige,
author = {Arbeids- og velferdsdirektoratet},
title = {HL060 Helt ledige. Fylke og kommune. Tidsserie måned.},
year = {n.d.},
url = {https://www.nav.no/no/nav-og-samfunn/statistikk/arbeidssokere-og-stillinger-statistikk/helt-ledige},
note = {Available in Atlas at https://atlas.sovereignsky.no/datasets/nav-helt-ledige}
}
https://atlas.sovereignsky.no/datasets/nav-helt-ledige