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-apiSOCIUsed 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 organisation and activity, with its Atlas service category.
api_v1.atlas_inventory
What Atlas publishes: one row per endpoint with its row count, freshness and origin.
Chapter coverage by kommune
Per-kommune rollup of which chapters cover it.
Activity dimension
Atlas's canonical activity dimension, each row mapped to a service category.
Chapter dimension
Atlas's canonical local-chapter dimension.
Distrikt summary
One row per district chapter, with its child chapters and kommune coverage.
Chapter activities fact
One row per chapter and activity, joined to Atlas's dimensions.
Local NGO chapters per kommune
One row per local chapter resolved to a kommune, with its NGO and category.
NGO registry
One row per voluntary organisation Atlas tracks, with its identity, branding and focus.
NGO overview
One row per NGO with its six headline counts, precomputed for the per-NGO page.
Røde Kors branch activities
One row per Røde Kors branch and activity, from a static 2026-04-21 export.
Røde Kors branches
One row per Norges Røde Kors branch, from a static 2026-04-21 export.
Røde Kors chapter coverage
Which kommuner each Røde Kors chapter covers, inferred from its local branches.
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.
ssb-klass-kommunermart_atlas_inventorymart_distrikt_summarybrreg-enheter-allemart_atlas_inventorybrreg-frivilligemart_atlas_inventorybrreg-oppdateringermart_atlas_inventorybrreg-underenhetermart_atlas_inventorybufdir-barnefattigdommart_atlas_inventorybufdir-barnevernmart_atlas_inventoryfhi-alkoholmart_atlas_inventoryDimensions
| 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 returning the first 5 rows this source publishes. It queries a published api_v1 relation — raw tables are not exposed through the public API.
https://api-atlas.urbalurba.com/activity_catalog?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