NGO overview
Atlas view
NGO overview
api_v1.ngo_overviewOne row per NGO with its six headline counts, precomputed for the per-NGO page.
First 5 rows ·
api_v1.ngo_overviewsnapshot 2026-05-12
| orgnr | chapter_count | national_count | regional_count | local_count | activity_count | kommune_count |
|---|---|---|---|---|---|---|
| 864139442 | 391 | 1 | 18 | 372 | 35 | 265 |
| 871033552 | 0 | 0 | 0 | 0 | 0 | 0 |
| 938429863 | 0 | 0 | 0 | 0 | 0 | 0 |
| 938498318 | 0 | 0 | 0 | 0 | 0 | 0 |
| 940190738 | 0 | 0 | 0 | 0 | 0 | 0 |
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).
Atlas internal model ↗
dim_chapter
Conformed chapter dimension across all ingested NGOs.
Showing direct dbt parents. See full lineage in /lineage/ →
Columns
| Column | Description |
|---|---|
| orgnr | 9-digit Brreg organisasjonsnummer. Natural key for this view. |
| chapter_count | Total count of chapters for this NGO across all levels (active + inactive). |
| national_count | Count of chapters at chapter_level = 'national'. |
| regional_count | Count of chapters at chapter_level = 'regional' (e.g. Red Cross distrikt). |
| local_count | Count of chapters at chapter_level = 'local' (the kommune-bound branches). |
| activity_count | Count of distinct activities offered by this NGO (rows in dim_activity for this orgnr). |
| kommune_count | Count of distinct kommuner with at least one active local chapter for this NGO. The "footprint" metric for coverage-gap questions. |
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/ngo_overview?limit=5
About this view
One row per NGO with its six headline counts, precomputed for the per-NGO page.
One row per NGO in dim_ngo with the six count metrics shown on
the per-NGO landing page (atlas-frontend /ngo/[slug]).
Equivalent to the getNgoOverview() inline query, but precomputed
for all NGOs so PostgREST projects it as a single endpoint
consumers filter via ?orgnr=eq.X.
Counts include both active and inactive chapters in the
level-specific buckets (national/regional/local). kommune_count
counts distinct kommune_nr only across *active* local chapters,
matching the original query's behaviour.