Norges Røde Kors Organizations API — branches + per-branch activities
Norges Røde Kors Organizations API — branches + per-branch activities
Norges Røde Kors ·redcross-branchesFirst NGO-supply ingest. Reads Norges Røde Kors's Organizations API data and writes it to two raw.* tables — chapters and per-chapter activities.
raw.redcross_branch_activities| branch_id | global_activity_name | local_activity_name | loaded_at |
|---|---|---|---|
| L098 | Besøksvenn med hund | Besøksvenn med hund Modum Røde Kors | 2026-05-06T14:34:41.625+00:00 |
| L098 | Besøkstjeneste | Besøkstjeneste Modum Røde Kors | 2026-05-06T14:34:41.625+00:00 |
| L098 | Hjelpekorps | Hjelpekorps Modum Røde Kors | 2026-05-06T14:34:41.625+00:00 |
| L098 | Arrangement og reise | Barnehjelp Modum Røde Kors | 2026-05-06T14:34:41.625+00:00 |
| L098 | Barnas Røde Kors | Barnas Røde Kors Modum Røde Kors | 2026-05-06T14:34:41.625+00:00 |
Provenance
organizations-apiSOCI2026-05-06T14:34:41.944657+00:00 · 2,534 rows · 1 runUsed in Atlas views
These Atlas views (api_v1.* PostgREST endpoints) include this dataset in their input. Click through for the sample query, column list, and lineage.
Activity catalogue (cross-NGO)
One row per (NGO, activity) joining dim_activity to the service-category seed for the human-readable label, plus a count of active chapters offering each activity.
Distrikt summary
One row per regional chapter (Red Cross "distrikt" level, and the equivalent regional tier for any other NGO with a hierarchy).
Local NGO chapters per kommune
Active local chapters in each kommune, decorated with the NGO name/brand and the service-category labels offered.
NGO registry
One row per NGO in dim_ngo with chapter_count and has_supply decorations.
NGO overview
One row per NGO in dim_ngo with the six count metrics shown on the per-NGO landing page (atlas-frontend /ngo/[slug]).
Joined with
Datasets that co-occur with this one inside Atlas's dbt models — the datasets you'd typically combine with this one in a real query.
Dimensions
| Code | Meaning | Value format | Notes |
|---|---|---|---|
| branch_id | Branch UUID | text | Stable identifier across snapshots |
| branch_type | Branch type | 3 codes | HQ (national), Distrikt (regional), Lokalforening (local chapter) |
| branch_name | Branch name | text | |
| location | Location attributes | object | kommune, county, region, postal/street addresses |
| branch_status | Operational status | {is_active, is_terminated, creation_date} | |
| parent | Parent branch reference | {branch_id, branch_number, branch_name, branch_type} | HQ has no parent; Lokalforening points at its Distrikt |
| activities | Per-branch activities | list of {global_activity_name, local_activity_name} | ~50 global activity types in the Red Cross catalogue; each branch lists its active subset |
Sample query
Live PostgREST query that returns the first 5 rows of raw.redcross_branches. 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/redcross_branches?limit=5
Citation
Norges Røde Kors. (n.d.). Norges Røde Kors Organizations API — branches + per-branch activities. Retrieved from https://www.rodekors.no/lokalforeninger/. Available in Atlas at https://atlas.sovereignsky.no/datasets/redcross-branches.
@misc{atlas_redcross_branches,
author = {Norges Røde Kors},
title = {Norges Røde Kors Organizations API — branches + per-branch activities},
year = {n.d.},
url = {https://www.rodekors.no/lokalforeninger/},
note = {Available in Atlas at https://atlas.sovereignsky.no/datasets/redcross-branches}
}
https://atlas.sovereignsky.no/datasets/redcross-branches