Røde Kors branches
Atlas view
Røde Kors branches
api_v1.supply__redcross_branchesOne row per Norges Røde Kors branch, from a static 2026-04-21 export.
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 | 'redcross-' || branch_id; namespaced for cross-NGO uniqueness. |
| ngo_orgnr | Hardcoded '864139442' (Norges Røde Kors). |
| chapter_level | Atlas's three-level normalisation of Red Cross's branch_type: 'national' (Nasjonalkontoret), 'regional' (Distrikt), 'local' (Lokalforening, and 'Ukjent' folded in). ⚠️ Derived by Atlas, not a Red Cross field — 'Ukjent' is mapped to local because it behaves like one, which is a judgement. |
| parent_chapter_id | Self-FK to chapter_id. NULL for HQ and Ukjent. |
| chapter_orgnr | Brreg orgnr if the branch is separately registered (every Red Cross local branch has its own). NULL otherwise. Distinct from ngo_orgnr — see dim_chapter.chapter_orgnr. |
| name | Display name for the chapter, verbatim from upstream (Red Cross's localBranchName etc.). Not normalised — preserves casing, diacritics, and embedded prefixes. |
| kommune_nr | Resolved via dim_postnummer.postnummer → kommune_nr lookup. NULL for branches without a postal code (HQ, some Distrikt, Ukjent). |
| is_active | Whether the chapter is operating. ⚠️ Not a straight copy of the upstream flag: a branch is forced false when branch_type is 'Ukjent' or when is_terminated is set, and otherwise takes the upstream is_active. Atlas's derivation. |
| postal_address_line1 | Street address (first line) from upstream. Drives the kommune_nr resolution via dim_postnummer. NULL when the branch doesn't publish a physical address. |
| postal_code | 4-digit Norwegian postal code (postnummer), leading zeros preserved. FK to dim_postnummer; the join produces kommune_nr. |
| post_office | Post-office name, ALLCAPS as published by Bring. |
| phone | Public contact phone for the branch, verbatim from upstream (no normalisation). NULL when not published. |
| Public contact email for the branch. NULL when not published. | |
| web | Public website URL for the branch. NULL when not published. May be a sub-page on the NGO's national site. |
| chapter_subtype | Optional subtype tag for non-geographic / structurally distinct branches. Always NULL for Red Cross today; populated by other NGO supply models — see dim_chapter for the vocabulary. |
| updated_at | When the row was last loaded from the upstream raw table. |
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/supply__redcross_branches?limit=5
About this view
One row per Norges Røde Kors branch, from a static 2026-04-21 export. Empty today.
Norges Røde Kors's own branch list — national office, districts and local chapters — typed out of the Red Cross Organizations API export.
🔴 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.