Helt ledige månedsstatistikk (HL060)
Atlas view
Helt ledige månedsstatistikk (HL060)
api_v1.indicators__nav_helt_ledigePer-source indicator data for nav-helt-ledige (Arbeids- og velferdsdirektoratet), 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 catalogue id for this ingest — always nav-helt-ledige. |
| region_code | NAV's own region code, verbatim from the workbook row label — a 4-digit kommune code (including the Svalbard pseudo-kommune 2100), or the literal string "Ukjent" (NAV's own unknown-region bucket). |
| kommune_nr | Four-digit kommune code, derived through region_code_to_kommune_nr. NULL for "Ukjent" and for Svalbard. |
| region_kind | What region_code is, from classify_region_code: kommune, svalbard or unknown — no fylke/bydel rows exist in this table. |
| category_format | Which sheet the row came from — antall (count) or prosent (share of the labour force) — not a column within a sheet. Unlike nav_aap, "Ukjent" is present under both antall and prosent here. |
| year | Calendar year of the observation. |
| month | Calendar month (1-12) of the observation. A plain integer, not a dim_period reference. |
| contents_code | Atlas-normalised variable code: fixed prefix `nav_helt_ledige__` joined with category_format, so each measure is filter-stable in the catalogue. |
| contents_label | Human-readable label combining "Helt ledige" with the antall/prosent format. |
| value | Numeric value for this year/month; NULL when NAV suppresses the cell (*). |
| values_json | Parse of the sheet's rows into month keys for this region/category_format/year slice (NAV's suppression marker * and blanks → JSON null values). |
| updated_at | Timestamp when the row was last written by ingest (from raw.loaded_at). |
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__nav_helt_ledige?limit=5
About this view
Per-source indicator data for nav-helt-ledige (Arbeids- og velferdsdirektoratet), at the publisher's own grain.
Per-source indicator relation for `nav-helt-ledige` (Arbeids- og velferdsdirektoratet), published at the grain
the publisher actually uses rather than flattened into the cross-source views. Atlas's fourth
NAV-adjacent source, third monthly-cadence source. No fylke_nr column — this table has no
fylke-level rows at all.
🔴 stability:source — the column set here follows Arbeids- og velferdsdirektoratet, 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=nav-helt-ledige.