Røde Kors branch activities
Atlas view
Røde Kors branch activities
api_v1.supply__redcross_branch_activitiesOne row per Røde Kors branch and activity, 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. |
| ngo_orgnr | Organisation number of the owning NGO — constant '864139442' (Norges Røde Kors) for every row in this relation, since it carries one organisation's branches. |
| canonical_name | Red Cross's globalActivityName, verbatim. |
| local_activity_name | Red Cross's local-branch display string for the activity (e.g. 'Modum Røde Kors Hjelpekorps'). Free-text; preserved verbatim. NULL when upstream didn't supply one. |
| service_category_code | From ref_atlas_activity_crosswalk's is_primary = 'true' row for this activity (changed 2026-10-06, was a hardcoded CASE). NULL only if a new globalActivityName appeared in raw that the crosswalk doesn't cover yet (catches drift loudly via the not_null filter applied at dim_activity/fact_chapter_activities — those filter is_service = true; a new unmapped service-type activity would still be is_service = true with NULL category, surfacing the gap). |
| is_service | 🔴 ATLAS'S EDITORIAL JUDGEMENT, not a Red Cross field. False for internal, governance and recruitment activities (Distriktsråd*, Døråpner, EVA, Blodgiververving, Arrangement og reise, Internasjonalt distriktsamarbeid); true otherwise. It answers "is this something a member of the public can receive", and a consumer who disagrees with a particular call should read the list in the model rather than treat the flag as the owner's own classification. |
| 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_branch_activities?limit=5
About this view
One row per Røde Kors branch and activity, from a static 2026-04-21 export. Empty today.
What each Røde Kors branch does, one row per branch × activity. `global_activity_name` is Red Cross's own canonical term; `local_activity_name` is the per-chapter display string.
🔴 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.