12451: Bostedskommune- og kjønnsfordelt sykefravær (legemeldt) for lønnstakere (K) 2000K2-2026K2
12451: Bostedskommune- og kjønnsfordelt sykefravær (legemeldt) for lønnstakere (K) 2000K2-2026K2
Statistisk sentralbyrå ·ssb-12451SSB table 12451 — legemeldt (physician-certified) sick-leave, percentage and lost workdays, per kommune of residence, quarterly. Atlas's third NAV-adjacent welfare-claim source (after `nav-uforetrygd` and `nav-aap`), but reached through SSB's PXWebAPI rather than a NAV Excel download — NAV's own sykefravær/sykepenger statistics pages publish no kommune-level table at all (checked live 2026-10-02; every downloadable table there is fylke-level or coarser). SSB republishes NAV's underlying register data at kommune resolution instead. Fetched via this project's existing `lib/pxweb.ts` client — the same mechanism every other `ssb-*` source uses, not a new NAV-family parser. v1 scope: `Sykefraversprosent` and `Sykefraversdagsverk` only (two of the table's nine measures — the rest are a different metric family or pure year-over-year deltas, deferred, see PLAN-013 [Q2]), `Kjonn=0` (Begge kjønn total, not the sex-split), full `Tid` history (105 quarters, 2000K2-2026K2).
Provenance
12451SOCIUsed 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.
12451: Bostedskommune- og kjønnsfordelt sykefravær (legemeldt)
Per-source indicator data for ssb-12451 (Statistisk sentralbyrå), 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 | Kommune of residence (bostedskommune), SSB-format | Numeric code: 4-digit kommune, plus SSB's own sentinel shapes | 937 codes total, spanning the full 2000-2026 series including historical (pre-merger) kommune codes — same convention as every other SSB Region dimension in this project. Confirmed live 2026-10-02 that the sentinel codes present already match classify_region_code's existing patterns exactly: XX99 ("Uoppgitt kommune <fylke>"), 9999 ("Uoppgitt kommune" national), 2111 (Longyearbyen/Svalbard), 2199/2299 (Svalbard/Jan Mayen unspecified). One exception: `0716u` ("Våle (-2001)") — SSB's own disambiguation suffix for a historical kommune whose numeric code was later reused by a different kommune (0716 is Re, 2002-2019). Not digit-only, so it correctly falls through to classify_region_code's `unknown` branch rather than a dedicated new one — a single discontinued code, not a new sentinel class. |
| period | Quarter, SSB's own code (e.g. 2026K2 = 2026, 2nd quarter) | YYYYKQ text, stored verbatim — not parsed into year+quarter columns | Same convention as ssb-12944's "period stored as text, not parsed" — keeps this module a faithful passthrough. 105 distinct values at ingest time, 2000K2 through 2026K2. |
| contents_code | Which sykefravær figure this row's value is — not a format variant | Sykefraversprosent | Sykefraversdagsverk | v1 scope is these two headline measures only. The table also has ArbeidstakereSykefra / ArbeidstakereSykePro (a different metric — count/share of employees with ANY sick-leave spell, not days-weighted) and four *Endr* variants that are pure year-over-year deltas of the measures above, trivially re-derivable from the raw quarterly series — none ingested, per PLAN-013's [Q2]. |
| value | The measure's value for this kommune and quarter | Numeric (percent for Sykefraversprosent, lost workdays for Sykefraversdagsverk) | No suppression marker observed on any cell checked live, including Norway's smallest kommune by population (Utsira) — not a blanket claim that no cell in this table is ever suppressed, just what the sampled cells showed. `status` carries SSB's own cell-level flag when one exists (none observed at ingest time). |
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
Statistisk sentralbyrå. (n.d.). 12451: Bostedskommune- og kjønnsfordelt sykefravær (legemeldt) for lønnstakere (K) 2000K2-2026K2. Retrieved from https://www.ssb.no/sykefratot. Available in Atlas at https://atlas.sovereignsky.no/datasets/ssb-12451.
@misc{atlas_ssb_12451,
author = {Statistisk sentralbyrå},
title = {12451: Bostedskommune- og kjønnsfordelt sykefravær (legemeldt) for lønnstakere (K) 2000K2-2026K2},
year = {n.d.},
url = {https://www.ssb.no/sykefratot},
note = {Available in Atlas at https://atlas.sovereignsky.no/datasets/ssb-12451}
}
https://atlas.sovereignsky.no/datasets/ssb-12451