Distrikt summary

Atlas view

Distrikt summary

api_v1.distrikt_summary

One row per district chapter, with its child chapters and kommune coverage.

Try at /api ↗View in lineage ↗Report a data issue

First 5 rows · api_v1.distrikt_summary

snapshot 2026-05-12

chapter_id	name	kommune_nr	kommune_name	ngo_orgnr	child_count	kommune_coverage_count
redcross-D018	Agder Røde Kors	4204	Kristiansand	864139442	17	12
redcross-D002	Akershus Røde Kors	3205	Lillestrøm	864139442	19	16
redcross-D006	Buskerud Røde Kors	3301	Drammen	864139442	19	15
redcross-D017	Finnmark Røde Kors	5607	Vadsø	864139442	17	13
redcross-D004	Hedmark Røde Kors	3403	Hamar	864139442	21	16

Built from

This Atlas view joins data from the following upstream sources. Click through for provenance, methodology, and citation.

Atlas internal model ↗

dim_chapter

Conformed chapter dimension across all ingested NGOs.

dim_chapter

Atlas internal model ↗

dim_kommune

Canonical kommune dimension.

dim_kommune

Showing direct dbt parents. See full lineage in /lineage/ →

Columns

Column	Description
chapter_id	Composite slug for the regional chapter (e.g. 'redcross-oslo'). Stable across refreshes. Unique within this view.
name	Display name for the regional chapter (e.g. 'Oslo Røde Kors').
kommune_nr	4-digit kommune code where the regional chapter is headquartered. NULL for distrikter without a single HQ kommune. Note: kommune_coverage_count tells you how many *child* kommuner the distrikt covers — that's the operational footprint, not where the office sits.
kommune_name	Joined from dim_kommune. NULL when kommune_nr is NULL.
ngo_orgnr	9-digit Brreg organisasjonsnummer of the NGO this distrikt belongs to.
child_count	Count of active local chapters whose parent_chapter_id equals this distrikt's chapter_id. The "lokalforeninger" total shown in the UI.
kommune_coverage_count	Count of distinct kommuner served by this distrikt's active children (kommune_nr IS NOT NULL). The operational footprint; may be smaller than child_count when multiple children share a 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 the configured API base.

https://api-atlas.urbalurba.com/distrikt_summary?limit=5

About this view

One row per district chapter, with its child chapters and kommune coverage. Empty today. 🔵 EXPECTED EMPTY TODAY, AND THAT IS NOT A DEFECT. Its grain is Red Cross districts, so it is empty until that data is loaded. Terje's position, 2026-09-21: the Red Cross data is not coming now, it will be there later. The relation is published and answers so a consumer can build against its shape before the rows arrive. ⚠️ A consumer cannot tell "empty by design" from "broken" without being told, and two of these three were asked about on the day someone noticed (urb-agents #1351). If this relation is still empty and this note is gone, something regressed. One row per regional chapter (Red Cross "distrikt" level, and the equivalent regional tier for any other NGO with a hierarchy). Each row carries denormalised counts of how many child chapters the distrikt has and how many distinct kommuner those children cover. Backs atlas-frontend /ngo/[slug]/distrikter and the individual /distrikt/[id] pages; equivalent to the listDistrikter() inline query. Counts come from dim_chapter joined back to itself by parent_chapter_id, filtered to active children. PostgREST consumers filter via ?ngo_orgnr=eq.X (or ?chapter_id=eq.Y for the single-distrikt case).