07459: Alders- og kjønnsfordeling i kommuner, fylker og hele landet…
Atlas view
07459: Alders- og kjønnsfordeling i kommuner, fylker og hele landet…
api_v1.indicators__ssb_07459Per-source indicator data for ssb-07459 (Statistisk sentralbyrå), 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 source identifier for the upstream table this row came from — the same id used by meta_sources and meta_dimensions. |
| region_code | The publisher's own region code, verbatim. It may be a kommune, fylke, bydel or national code depending on what that publisher emits; region_kind says which. |
| kommune_nr | 4-digit kommune code, derived via region_code_to_kommune_nr. NULL for every region that is not a municipality. ⚠️ Not a bare four-digit match — that is what once called Svalbard, Jan Mayen and the continental shelf municipalities. |
| region_kind | What the region code is, from classify_region_code: kommune · fylke · svalbard · jan_mayen · continental_shelf · unspecified_within_fylke · unspecified_national · unknown. Joins ref_region_kind. 🔵 kommune_nr is now null for every kind except `kommune`, which is what resolves this model's permanent referential warning — the assertion became true rather than the test being relaxed (urb-agents #700). |
| fylke_nr | 2-digit fylke code where the region is a fylke, else NULL. |
| sex | SSB Kjonn — '1' (Menn) or '2' (Kvinner). |
| age | SSB Alder — '000'..'104' or '105+'. |
| age_int | age as an integer where it is finite; NULL for an open-ended bucket such as "105+". |
| age_min | A sortable floor for age: the integer itself when finite, and the number before the "+" for an open-ended bucket (105 for "105+"). Use this to order, and age_int to filter on an exact age. |
| year | First year of the period this row covers. ⚠️ For a multi-year window this is the FIRST year, not the only one — read period_start_year and period_end_year for the span. |
| contents_code | The publisher's code for WHICH measure this row reports. Decode it through meta_dimensions for this source_id. |
| contents_label | Human-readable gloss for contents_code. |
| value | The measured value. NULL where the publisher suppressed the cell — see status. |
| status | The publisher's own suppression or quality marker for this cell, passed through verbatim. |
| updated_at | When Atlas last loaded this row from the upstream. |
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__ssb_07459?limit=5
About this view
Per-source indicator data for ssb-07459 (Statistisk sentralbyrå), at the publisher's own grain.
Per-source indicator relation for `ssb-07459` (Statistisk sentralbyrå), published at the grain the publisher
actually uses rather than flattened into the cross-source views.
🔴 stability:source — the column set here follows Statistisk sentralbyrå, 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=ssb-07459.