Distrikt summary
Atlas view
Distrikt summary
api_v1.distrikt_summaryOne row per regional chapter (Red Cross "distrikt" level, and the equivalent regional tier for any other NGO with a hierarchy).
First 5 rows ·
api_v1.distrikt_summarysnapshot 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.
Atlas internal model ↗
dim_kommune
Canonical kommune dimension.
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 api-atlas.sovereignsky.no.
https://api-atlas.sovereignsky.no/distrikt_summary?limit=5
About this view
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).