Activity dimension

Atlas view

Activity dimension

api_v1.dim_activity

Atlas's canonical activity dimension, each row mapped to a service category.

Try at /api ↗View in lineage ↗Report a data issue

Built from

This Atlas view joins data from the following upstream sources. Click through for provenance, methodology, and citation.

Atlas internal model ↗

dim_activity

Activity catalog — one row per (NGO, NGO-canonical activity name).

dim_activity

Showing direct dbt parents. See full lineage in /lineage/ →

Columns

Column	Description
activity_id	Composite slug, namespaced by NGO (e.g. 'redcross-besokstjeneste'). Stable across refreshes. Unique within this table.
ngo_orgnr	9-digit Brreg organisasjonsnummer of the NGO that owns the activity. FK to dim_ngo.
canonical_name	Red Cross's globalActivityName, verbatim.
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_active	Whether this NGO still offers the activity. False for retired activities kept in the catalog so historical fact_chapter_activities rows can still resolve activity_id.

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/dim_activity?limit=5

About this view

Atlas's canonical activity dimension, each row mapped to a service category. Empty today. Atlas's canonical activity dimension, each row pointing at a ref_atlas_service_category code. ⚠️ That category mapping is Atlas's editorial judgement, not the owner's classification. 🔴 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.