Indicator coverage gaps per kommune
Atlas view
Indicator coverage gaps per kommune
api_v1.indicator_missing_kommunerOne row per (source_id, contents_code, kommune_nr) for every active kommune that has *no* non-NULL value at the indicator's latest_year.
First 5 rows ·
api_v1.indicator_missing_kommunersnapshot 2026-05-12
| source_id | contents_code | kommune_nr | kommune_name |
|---|---|---|---|
| ssb-crime-tables | 5532__18__AnmeldteLovbrudd__2007-2008 | 1857 | Værøy |
| ssb-crime-tables | 5532__18__AnmeldteLovbrudd__2007-2008 | 1859 | Flakstad |
| ssb-crime-tables | 5532__18__AnmeldteLovbrudd__2007-2008 | 1860 | Vestvågøy |
| ssb-crime-tables | 5532__18__AnmeldteLovbrudd__2007-2008 | 1865 | Vågan |
| ssb-crime-tables | 5532__18__AnmeldteLovbrudd__2007-2008 | 1866 | Hadsel |
Built from
This Atlas view joins data from the following upstream sources. Click through for provenance, methodology, and citation.
Atlas internal model ↗
dim_kommune
Canonical kommune dimension.
Atlas internal model ↗
fact_kommune_indicators
First cross-source mart.
Showing direct dbt parents. See full lineage in /lineage/ →
Columns
| Column | Description |
|---|---|
| source_id | Atlas source identifier, e.g. 'ssb-08764'. |
| contents_code | Source-specific ContentsCode verbatim from upstream (e.g. 'EUskala60', 'Folkemengde'). |
| kommune_nr | 4-digit zero-padded kommune code. FK to dim_kommune; only active kommuner with no value at latest_year are listed. |
| kommune_name | Joined from dim_kommune. |
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 api-atlas.sovereignsky.no.
https://api-atlas.sovereignsky.no/indicator_missing_kommuner?limit=5
About this view
One row per (source_id, contents_code, kommune_nr) for every
active kommune that has *no* non-NULL value at the indicator's
latest_year. The "coverage gap" sidebar on the data explorer
detail page; equivalent to the listMissingKommuner() inline query.
PostgREST consumers filter via
?source_id=eq.X&contents_code=eq.Y. Membership semantics: a
kommune is considered "missing" if it either has no row at
latest_year, or has a row with value IS NULL. Status markers (':',
'X') do not count as a value.
The full table is the cross-product of every indicator with every
active kommune that lacks data. Most cells are present, so the
unfiltered row count is the per-indicator gap-list aggregated
across all indicators.