Chapter activities fact
Atlas view
Chapter activities fact
api_v1.fact_chapter_activitiesOne row per chapter and activity, joined to Atlas's dimensions.
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 | Composite slug, namespaced by NGO. Stable across refreshes. |
| activity_id | Composite slug, e.g. 'redcross-besokstjeneste'. Stable across refreshes. |
| ngo_orgnr | Denormalised from dim_chapter for query convenience. |
| kommune_nr | Denormalised from dim_chapter. NULL for non-local chapters (regional, national). |
| local_activity_name | NGO's local display string for the activity at this chapter (e.g. 'Modum Røde Kors Hjelpekorps'). |
| 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. |
| canonical_name | Denormalised from dim_activity for query convenience. |
| source_id | Atlas source identifier — constant 'redcross-branches' for every row, since this fact derives from that one source. |
| updated_at | When the row was last loaded from the upstream supply staging model. |
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/fact_chapter_activities?limit=5
About this view
One row per chapter and activity, joined to Atlas's dimensions. Empty today.
The analytical grain for chapter activity: one row per chapter × activity, joined to Atlas's dimensions so it reconciles with the rest of the supply layer.
🔴 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.