Chapter coverage by kommune
Atlas view
Chapter coverage by kommune
api_v1.chapter_kommune_coveragePer-kommune rollup of which chapters cover it.
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 |
|---|---|
| chapter_id | Composite slug, namespaced by NGO. Stable across refreshes. |
| kommune_nr | Resolved via dim_postnummer. NULL for branches that span multiple kommuner (regional, national). |
| source | How this (chapter, kommune) link was established. 'declared' = the NGO publishes the kommune list directly for this regional chapter; 'inferred' = derived by Atlas from child-chapter coverage (e.g. union of local kommuner under the regional parent). |
| updated_at | When the row was last loaded from the upstream supply staging model. |
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/chapter_kommune_coverage?limit=5
About this view
Per-kommune rollup of which chapters cover it. Empty today.
Per-kommune rollup of which chapters cover it — Atlas's shape, built so coverage questions do not require walking branch addresses.
🔴 A STATIC DUMP, NOT A LIVE FEED — a one-off export of 2026-04-21 (392 branches,
~2 400 activities per migration 022). Nothing refreshes it.
🔴 SERVING ZERO ROWS TODAY and that is expected, not a broken endpoint: the
redcross-branches ingest is held on a credential, so raw is empty and so is this.
⚠️ Atlas holds NO republication licence here. This is Norges Røde Kors's own
operational data, published on the owner's stated wish — and a wish is not a
licence. NLOD does not cover it; ask Røde Kors before redistributing. That
instruction reached Atlas relayed through the demo consumer, not directly.