Child-poverty coverage gap (kommune)
Atlas view
Child-poverty coverage gap (kommune)
api_v1.coverage_gap_barnefattigdomOne row per active kommune for the latest year of SSB 08764 child poverty data, combining the EUskala60 share (% of children in low-income households) with the Personer count (number of children).
First 5 rows ·
api_v1.coverage_gap_barnefattigdomsnapshot 2026-05-12
| kommune_nr | kommune_name | fylke_name | year | value_pct | personer |
|---|---|---|---|---|---|
| 0301 | Oslo | Oslo | 2024 | 13 | 130343 |
| 1101 | Eigersund | Rogaland | 2024 | 8.6 | 3270 |
| 1103 | Stavanger | Rogaland | 2024 | 9.9 | 31018 |
| 1106 | Haugesund | Rogaland | 2024 | 11.8 | 7358 |
| 1108 | Sandnes | Rogaland | 2024 | 9 | 19802 |
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 |
|---|---|
| kommune_nr | 4-digit zero-padded kommune code. FK to dim_kommune; only active kommuner are included. Unique within this view. |
| kommune_name | Joined from fact_kommune_indicators (originally from dim_kommune). |
| fylke_name | Joined from fact_kommune_indicators (originally from dim_fylke). NULL for kommuner whose fylke_nr isn't in dim_fylke (rare — Svalbard 21xx). |
| year | The latest year for ssb-08764/EUskala60. Same value across all rows; carried on each row so the consumer reads it without a separate query. |
| value_pct | EU-skala 60 % share — the percent of children under 18 in low-income households (defined as < 60 % of national median equivalised income). NULL when upstream suppressed the cell. |
| personer | Number of children under 18 in low-income households at the same year. NULL when upstream suppressed the cell. |
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/coverage_gap_barnefattigdom?limit=5
About this view
One row per active kommune for the latest year of SSB 08764 child
poverty data, combining the EUskala60 share (% of children in
low-income households) with the Personer count (number of
children). Backs the barnefattigdom map page (atlas-frontend
/coverage-gap/barnefattigdom).
First member of the mart_coverage_gap_<topic> family. Future
coverage-gap maps follow the same shape: latest year per kommune,
one row per kommune, value(s) pivoted out of contents_code into
named columns. PostgREST projects this view as a single endpoint;
consumers don't filter, they read the whole map dataset in one
request.
Inactive kommuner are excluded so the map renders today's
kommune set. NULL values are kept in place — Map.tsx renders
them as "no data".